Ashish Lohia

Experience

• 

  Impelsys

  Mar 2012 - Sept 2013

  QC Engineer

  1. Involved in development, testing and implementation of Oracle Database tables.2. Solving problems faced by clients.3. Analyzing client requirement and validating the issues posted.4. Created Tables and Constraints.

• 

  IQVIA

  Sept 2013 - now

  Programmer

  1. Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.2. Worked on SQL*Loader to load data from flat files obtained from various facilities.3. Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.4. Developed PL/SQL Triggers and master tables for automatic creation of primary keys.5. Created PL/SQL Stored procedures, Functions and Packages for moving the data from staging area to data mart.6. Worked on Performance Tuning for Oracle RDBMS using Explain Plan, TKPROF and HINTS.7. Created indexes on the tables for faster retrieval of the data to enhance database performance.8. Worked on Oracle supplied packages, Ref Cursors, Dynamic SQL, Records and PL/SQL Tables.9. Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.10. Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.11. Creation of database objects like Tables, Views, Sequences, Materialized Views, Procedures and Packages using oracle tools like PL/SQL Developer.12. Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.13. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.14. Interacting with customer to acquire and understand the technical requirements.15. Responsible for sending daily and weekly status reports Show less