SUMMARY:

• Have 15 years of total IT experience in different technologies and domains.
• Worked on ETL tools Informatica and Confidential D Confidential Integration (PDI) to extract d Confidential from different sources, transform them using vast range of transformation components and then finally load into de - normalized tables in the d Confidential base tables as dimensions and facts.
• Design, Develop, implement, automat and maintain ETL processes for large scale enterprise d Confidential .
• Extract structured and semi-structured d Confidential from source systems, transform it to fit business needs, and load it into a d Confidential mart
• Extensively used SQL, PL/SQL for d Confidential base objects development in finance, insurance and EPR applications.
• Used SQL PL/SQL for d Confidential analytics, metrics and reports to identify process improvement / enablement of new process or operation or even new system.
• Used Unix Shell script and Python to process input and output files for different ETL tasks.
• Used Python to build visual feedback dashboard for system performance using Blinkstick.
• Worked on SQL loader tool to load flat files in different formats.
• Worked on Order Management (OM) module of Oracle Apps.
• Collaborated with product owners, technical architects, business analyst and technical leads to gather and understand architecture decisions, as well as product requirements.
• Worked for diverse companies from various business domains and highly scalable application with huge customer base and high d Confidential volume.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Python, Unix Shell Script

D Confidential bases: Oracle, MS SQL Server, Mongo DB

ETL Tools: Informatica, Confidential D Confidential Integration (PDI)

Tools: & Utilities PVCS, MS VSS, HP Quality Center, HP Kintana, Rally, Toad, Tidal

PROFESSIONAL EXPERIENCE:

Confidential

Systems Analyst/ ETL and PL/SQL Developer

ETL Tools: Informatica 10.1 Languages: SQL, PL/SQL, Unix Shell Script, Java D Confidential base: Oracle 11g O/s: Unix, Windows Tools: Toad, Tidal, SSH Tectia, Rally

Responsibilities:

• Requirement gathering and analyzing business requirements by discussing with business stakeholders.
• Designing d Confidential base tables in Confidential to store application d Confidential in logical format for transaction system.
• Designing and development of d Confidential base objects like Packages, Stored Procedures, Functions, Utilities etc.
• Based on requirement and d Confidential analysis, partitioning table for better performance.
• Performance Tuning of SQL queries by analyzing Explain Plan.
• Performance Tuning of stored procedure code by using advance PL/SQL like Bulk Collect, FOR ALL, LIMIT etc.
• Designing and developing ETL processes using variety of Informatica transformations like Expression, Joiner, Filter, Router, Update Strategy etc.
• Used Informatica Partitioning for performance tuning i.e. to have multiple threads to run simultaneously and have better throughput.
• Implemented Confidential in Informatica for Confidential with history of change in location, expertize, department etc.
• Designing Start schema and Snow Flake schema using Dimensional Modeling to separate description and Measures for reports, metrics, dashboards etc.
• File transfer / copy using Python and Shell Scripts
• Excel reading and converting to CSV using Python
• Excel d Confidential type formatting using Python
• Blinkstick Dashboard using Python
• D Confidential Analytics using SQL, PL/SQL, Oracle Analytic functions.
• Report Dashboards and Metrics generation for business users
• SIT, UAT testing and production deployment

Confidential

ETL and PL/SQL Developer

Languages: SQL, PL/SQL, Python, Unix Shell Script ETL Tools: Informatica 9.61, Confidential D Confidential Integration 6.0 D Confidential base: Oracle 11g O/s: Unix, Windows Tools: HP Quality Center, Kintana

Responsibilities:

• Requirement gathering and analyzing business requirements by discussing with business stakeholders.
• Designing and development of d Confidential base objects like Packages, Stored Procedures, Functions, Utilities etc.
• Based on requirement and d Confidential analysis, partitioning table for better performance.
• Performance Tuning of SQL queries by analyzing Explain Plan.
• Performance Tuning of stored procedure code by using advance PL/SQL like Bulk Collect, FOR ALL, LIMIT etc.
• Designing and developing ETL processes using variety of Steps and Jon Entries in Confidential D Confidential Integration (PDI).
• Implemented Confidential using Confidential Dimension Lookup / Update step
• Used Informatica Partitioning for performance tuning i.e. to have multiple threads to run simultaneously and have better throughput.
• Implemented Confidential in Informatica for learners of the Confidential Network Academy courses.
• Designing and developing ETL processes using variety of Informatica transformations like Expression, Joiner, Filter, Router, Update Strategy etc.
• Designing Start schema and Snow Flake schema using Dimensional Modeling to separate description and Measures for reports, metrics, dashboards etc.
• File transfer / copy using Python and Shell Scripts
• Excel reading and converting to CSV using Python
• Excel d Confidential type formatting using Python
• D Confidential Analytics using SQL, PL/SQL, Oracle Analytic functions.
• Report Dashboards and Metrics generation for business users
• SIT, UAT testing and production deployment

Confidential

PL/SQL Developer

Languages: SQL, PL/SQL D Confidential base: Oracle 11g O/s: Unix, Windows Tools: HP Quality Center, Kintana

Responsibilities:

• Customer interaction for requirement
• Analysis of the specifications provided by the client
• Designing and developing d Confidential base objects
• Designing and developing ETL processes using variety of Informatica transformations like Expression, Joiner, Filter, Router, Update Strategy etc.
• Designing Start schema and Snow Flake schema using Dimensional Modeling to separate description and Measures for reports, metrics, dashboards etc.
• D Confidential Analytics using SQL, PL/SQL
• Report Dashboards and Metrics generation for business users
• Performance Tuning of SQLs analyzing Explain Plan

Confidential

PL/SQL Developer

Languages: SQL, PL/SQL ERP: Oracle Apps R12 D Confidential base: Oracle 11g Tools: PVCS, HP Quality Center, HP Kintana O/s: Unix

Responsibilities:

• Analysis of the specifications provided by the client
• Prepared technical documents with details validations needed to be carried out in Unit Testing.
• Registering PL/SQL Stored Procedures in Front End using Concurrent Program
• Defining Concurrent Programs, Executables and Creation of Values Sets
• Developing Oracle Reports and registering them with Oracle Apps.
• Developed Inbound Interfaces and Outbound Interfaces.
• Created KPs for migration and provided support for TCA and TCB

SQL PL/SQL Developer

Confidential

Languages: PL/SQL D Confidential base: Oracle 10g Tools: MS VSS, HP Quality Center O/s: Unix

Responsibilities:

• Analyzing the functional documents and preparing Technical Specification Documents.
• Development of screens to capture details like insurance, premium, nominees
• Unit Testing of the components developed
• Migration to test instance
• Testing Support and migration to production instance.