SUMMARY

• 6 years of proven experience as Pl/Sql developer in Pharma/Telecom domain
• Strong database skills. Experience in working with Oracle, SQL DDL & DML Queries, Stored Procedures, triggers, packages, wrapper procedures.
• Experience in handling on going Data Mart jobs for pharma clients.
• Strong experience in end to end ETL processes involving extraction of data from flat files into source tables, transforming the data after applying the business logic and load into final tables.
• Strong experience in working on MSBI projects. Creating packages using SSIS, Cube building and deployment using SSAS for end users analysis purposes and create interactive reports as per business requirements using SSRS.
• Experience in Automating the ETL processes using cronjobs and Windows scheduler.
• Worked on relational data models. Experience in writing complex SQL queries for fetching data from different fact tables and dimensional tables.
• Strong understanding of database concepts.
• Strong experience in writing queries involving multiple joins on primary key and foreign key attributes.
• Experience in Sql query optimization and performance tuning.
• Experience in analysing large tables and creating partitioned tables, views, indexes and packages.
• Experienced in Unix shell scripting and batch programming.
• Good domain knowledge of US pharmaceutical industry.
• Worked with Pharma cients like Confidential, Confidential, Confidential, Confidential, Johnson&Johnson,BI,Bayer, Shire, Confidential, Confidential .

TECHNICAL SKILLS

Technologies/Frameworks: Pl/Sql, Unix, MSBI (SSIS, SSAS, SSRS)

Database: Oracle 11g

Tools: /Debugger: Toad, Sql Developer, PUTTY, Reflection, Windows scheduler, Tableau

Operating Systems: Windows/Linux

PROFESSIONAL EXPERIENCE

Software Engineer

Confidential

Responsibilities:

• Worked on various on - going data marts for different pharma clients.
• Experience in writing stored procedures, packages, creating different types of triggers.
• Worked on creation of fact tables and dimension tables, populating data in tables using stored procedures, packages.
• Experience in creating SSIS packages, building and deploying cubes for analysis purposes using SSAS and SSRS reports for BI projects.
• Experience in troubleshooting SSIS packages and modifying them as per user requirements.
• End to End data delivery in many ETL processes involving extraction of data from flat files into source tables, transforming the data after applying the business logic and load into final tables.
• Automating ETL processes using unix shell scripting and cronjobs, and windows scheduler.
• Handing adhoc requests from the pharma clients and delivering required data to them meeting the deadline.
• Tuning the performance of multiple processes reducing the run times using query optimization methods.
• Creating partitioned tables.
• Handling many yearly, half yearly, monthly, quarterly and weekly on going production processes.
• Error resolution and data issue handling of many production processes and delivering data on time.
• Unit testing modules which are developed for new projects by writing relevant unit test cases and negative test cases.
• Experience in working in AWS for running batch processes to import files from FTP location to database and then creating flat files.
• Experience in analysing large tables with many rows.
• Experience in writing complex SQL queries and creating PL/SQL blocks like procedures and functions for doing logical and computational jobs.
• Experience in writing complex SQL queries involving multiple joins between fact tables and dimensional tables.

Software Engineer

Confidential

Responsibilities:

• Worked on various on-going data marts for different pharma clients.
• Experience in writing stored procedures, packages, creating different types of triggers.
• Worked on creation of fact tables and dimension tables, populating data in tables using stored procedures, packages.
• End to End data delivery in many ETL processes involving extraction of data from flat files into source tables, transforming the data after applying the business logic and load into final tables.
• Handing adhoc requests from the pharma clients and delivering required data to them meeting the deadline.
• Handling many yearly, half yearly, monthly, quarterly and weekly on going production processes.
• Error resolution and data issue handling of many production processes and delivering data on time.
• Unit testing modules which are developed for new projects by writing relevant unit test cases and negative test cases.
• Experience in analysing large tables with many rows.
• Experience in writing complex SQL queries and creating PL/SQL blocks like procedures and functions for doing logical and computational jobs.
• Experience in writing complex SQL queries involving multiple joins between fact tables and dimensional tables.

CORE ENGINEER

Confidential

Responsibilities:

• Worked on internal user’s portal which involved importing subscriber list of the network providers and applying business logic and extracting the same into excel report for analysing using SQL.
• Sending relevant subscriber information and graphical trend in excel report form to the network operators.
• Creating CDR (Charge Data Register) report.
• Worked on developing timesheet application and automating it which will enable user to log hours with ease and the application will in turn compute the utilization, leave days etc automatically.