Candidate Information Name Available: Register for Free Title Software Engineer Data Target Location US-OR-Hillsboro Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Data Engineer Software Beaverton, OR Software Engineer Machine Learning Portland, OR Software Engineer Senior Portland, OR Senior Data Engineer Portland, OR Data Analysis Ml Engineer Portland, OR Software Engineer C++ OpenCV DICOM Deep Learning C# Python Imagi Wilsonville, OR Software Engineering Manager Lake Oswego, OR

Candidate's Name
Assistant Consultant Street Address  Years Hillsboro, Oregon Valid H1B Till 2028EMAIL AVAILABLEPHONE NUMBER AVAILABLECareer ObjectiveTo obtain a position as Data Engineer/ Software Engineer in a challenging environment, where I can utilize my Data Warehouse knowledge and experience, to achieve the best possible solution and benefit the organization.Experience Summary11+ years of experience in Analysis, Design, Development and Data processing using Oracle Technology on different platforms.I worked extensively on PLSQL - Functions, Stored Procedures, Cursors, Triggers and Packages.Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table Partitioning.Experience with Data flow diagrams, Data dictionary, Entity relation modelling and design techniques.Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, 12c, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.Proficient in advance features of PL SQL programming like Records and Collections, Bulk load, Bind variables, Ref Cursors and Dynamic SQL.Good Knowledge of Client-Server application development using Oracle PL/SQL, SQL*PLUS, TOAD and SQL*LOADER.Experience in designing, modeling, performance tuning and analysis.Good experience in UNIX and Shell scripts to create reports and logs based on the business prerequisites.Worked in Agile Methodology.Worked on version control tools such as GitHub, Devops and used JIRA bug tracking tool.Experienced in Production Support Role 24/7 to resolve the issues using in a ticketing system.Extensively used the advanced features of PLSQL like Records, tables, object types ad Dynamic SQL.Collaborate well with Project Management, Business Analyst and Department management teams.Flexible, enthusiastic, and project-oriented team player with excellent communication skills with leadership abilities to develop creative solutions for challenging requirements of client.Expertise in Dynamic SQL, Collections and Exception handling.Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and IndexesGathering the customer requirements, custom designing solutions, performance tuning, troubleshooting for software and application problems.Involved in various technologies during my service like Snowflake Data warehouse, Oracle (SQL), SQL Server, Unix and understanding the Talend Code for Troubleshooting.Very good understanding of relational and dimensional data modelling and exploring.Great Experience in implementing ELT & ETL frameworks using Snow pipe, Tasks, Copy and Stored procedures.In-depth Experience of Zero copy Cloning and Time travel in Snowflake.Experience in version tools like GIT, SVN, Devops.Experience in Change tools like Jira, CREQ etc.Experience in Service tools like ServiceManagement for ticketing.HighlightsOracle SQL 10g CertificationOn the spot Award/Best Team Award/Smiles AwardTopper in Metriculation/12th Standard/ BTech(3rd Position in Class)Classical Dancer in Kuchipudi (Indian Dance Form) and Classical SingerStudiesS.NoCourseInstitutionPercentage1Bachelor of Technology(Electronics and Communications)JNTU college of Engineering Kakinada78%2Intermediate(12th Class)Aditya Junior College93%3Metriculation(10th Class)APPM Model High School Rajahmundry85%Work Experience in Tata Consultancy ServicesPPD Inc.(Jan 2021  Till Date)Worked on MOSAIC Phase 3 project which involves PLSQL Development. Developing and Enhancing views and other logics.Worked on Migrating the Oracle Code to Snowflake Views and Procedure.Optimizing the complex queries to reduce the costing and execution time.Worked on creating the new Database with the help of DBA and created new objects like tables,views and procedures.Worked on Zero copy cloning and time travel concepts of snowflake.Worked on Data loads with the help of Talend jobs .Technical Skill : Snowflake, PLSQL and basics of TalendThomson Reuters(Jan-2014 - May-2020)Worked on enhancing and developing the complex Procedures and views.Execute SOX Controls for different Applications I have worked on.Worked on writing the complex SQL queries to generate the Financial reports for the Client Analyzation purposes.Worked on Migration projects to migrate the code, Data and DB objects from older Oracle to latest versions.Worked on Migrating the older windows version to latest versions on client servers.Worked on various applications like Wildat, Edata, GetPaid, Clarity PPM, Customer Master etc. during the span I have worked in this Project.Technical Skill: Unix, sql, plsql,sql server, shell scriptTelenor Norway(May-2012 - Dec-2013)Telenor Norway  Upgration of Geneva Application from IRB 4.3 to RBM 5.3Responsible for developing Change Requests and Resolving Incidents following SLA.Worked on Modifying the Java Code, SQL queries and other enhancements requests for managing the Charge codes or other requirements from the Client.Worked on Testing the Deployments of the code and also managing the version control.Technical Skill:PL/SQL & JAVAFiat Chrysler Automobiles(Feb-2012 - Apr-2012)Developed a internal site for the project using struts.Technical Skill: Java with struts