PROFESSIONAL SUMMARY

• 10+ years of professional IT experience in theareas of ETL Informatica Power Centre, Data Warehousing(DWH), Data Marts, DataModelling using ER Studio, Relational Databases(Oracle, SQL Server),Query Languages(SQL, PL/SQL) and UNIX shell scripting.
• Experienced in ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modelling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Experience of various domains like Pharmaceutical, Healthcare and Life Sciences.
• I have Strong Data warehouse ETL experience using Informatica Power centre Designer, Power centre Workflow Manger, Power centre Workflow Monitor.
• Strong Experience in developing Sessions/Tasks, Work lets, Mapplets, creating events and Transformations.
• Good experience in reading different Incremental Sources like SAP, Oracle, DB2, MS SQL Server, Flat Files, XML.
• Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment.
• Good Understanding of Slaesforce, ERP, CRM data for Informatica loading
• Implemented the dynamic Flat File loading using the indirect method and events.
• Hands on experience of Salesforce.com with ETL Informatica.
• Strong experience in Dimensional Modelling using Star and Snow Flake Schema, Identifying Facts and Dimensions, Physical and logical data modelling.
• Developed mappings using the mappings specs and process flow, used Joiners, aggregators, update strategy, Lookup, sorter, router, transaction control transformations in mappings.
• Vast experience in resolving on - going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experienced in developing complex SQL queries using unions, multiple table joins and views.
• Good Knowledge in PL/SQL’s Stored Procedures, Functions, Packages, DB Triggers, Indexes, SQL, Cursors.
• Extensively used User-defined Object types, Records, and Tables in PL/SQL Programming.
• Constructed and implemented multiple-table links requiring complex JOIN statements, including Outer-joins and Self-joins.
• Worked on Agile Methodology.
• Experienced in UNIX Shell Scripts to execute the scripts and manipulate files and directories using Vi Editor.
• Created and edited multiple Autosys jobs. Full knowledge and experience of autosys job scheduling.
• Worked as a team in conjunction with various DBAs, Data Architects, Business owners and technical staff.
• Excellent interpersonal and communication skills, and experienced in working with all levels of management, business people, developers and testers across multiple disciplines.
• Ability to learn new technologies and always ready to take new/extra responsibilities and challenges.

TECHNOLOGY SKILL SET:

• Databases
• Oracle:
• Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8.
• Microsoft:
• SQL Server
• MS Access
• Others:
• Teradata, DB2
• Tools and Utilities
• Informatica ETL/MDM:
• Informatica Power Centre Designer, Workflow Manager, Workflow Monitor, Repository Manager.
• ER Studio.
• Salesforce.com
• Informatica MDM(Siperian MDM)
• Oracle:
• Toad
• SQL Developer
• SQL Navigator
• SQL Loader
• SQL * Plus
• Unix/Linux:
• SSH Tectia
• Putty
• Scheduling Tools:
• Autosys
• Unix Cron
• File Transferring:
• Expdp/Impdp
• FTP/SFTP
• SQL Loader

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

Sr. ETL Informatica Developer/Analyst

Responsibilities:-

• Developed mappings using the mappings specs and process flow, used Joiners, aggregators, update strategy, Lookup, sorter, router, transaction control transformations in mappings
• Created multiple ETL mini flows to provide business with monthly, quarterly and yearly reports well ahead of regular schedules.
• Creating various specialized reports by using SQL for data manipulation.
• Done extensive testing and wrote queries in SQL to ensure the data accuracy and authenticity.
• In-depth knowledge of all the kinds of workflow tasks and Repository management
• Able to Handle shell scripts and stored procedures from Informatica.
• Well experienced in data warehouse, data migration and data conversions.
• Has good experience in designing Logical and Physical data models for different database applications using the ER Studio.
• Debugging the code and created error log package to record all the bad records along with error codes and error message.
• Strong technical hands on experience in creating and maintaining database objects like tables, views, materialized views, indexes, sequences, synonyms and database links and performing DML operations using insert, update and delete statements.
• Constructed the required data involving complex JOIN statements, including outer-joins, intersect and union all.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Scheduling the sessions toextract, transformandloaddata in to warehouse database, basedn Business requirements.
• Utilized SQL*Loader to load flat files into database tables.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Coordinated with front end team working on Java and web services and provided them the required procedures and packages and necessary insight into the data.
• Created complex SQL queries using inline views, sub queries, correlated sub queries
• Ability to handle the data transformations as per requirements
• Involved in different phase of testing like User Acceptance Testing, Unit testing.
• Involved in writing Test cases and performing data validation and process testing for application moving into production.

Technology: Informatica, SQL Server, Oracle 11g, Salesforce, DB2,SQL, PL/SQL, TUnix, Linux, FTP, SFTP, SSH Tectia, ER Studio

Confidential

Sr. ETL Informatica Consultant

Responsibilities:-

• Created PL/SQL Stored Procedures, Functions, Triggers and Packages to transfer the data from the intermediary database to the main database DLCUSPRD.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming for generating worksheets.
• Created Materialized Views and Indexes for better performance of compound tables, Autonomous Transactions, Coding Dynamic SQL Statements.
• Used Exception Handling extensively to debug and display the error messages in the application.
• Perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Database performance monitoring and identifying bottlenecks hindering the performance of the database.
• Created changes in the database according new requirements (new tables in the existing database and fields in the existing tables).
• Constructed and implemented multiple-table links requiring complex JOIN statements, including Outer-joins and Self-joins.
• Developed SQL*Loader control files to extract data from flat files, create error, result log files and load data into temporary table to do validations Testing and debugging of the applications.
• Provide the support and maintenance to the DLCUSPRD/ECDSUSPRD/MCIDB databases including UAT/IT/DEV Instances as Application DBA
• Created automated jobs using UNIX Shell scripts to synchronize the data
• To monitor daily running Scheduled and Manual jobs that refreshes many Materialized Views.
• Troubleshooting the errors during Data Load.
• Resolve the issues/errors that cause the failure of job and make the jobs running with analysis of failure causes debugging packages, procedures, scripts.
• Perform the data maintenance activities as per the requirement and deleting obsolete data from database as per Merck requirements.
• Granting the object access and Secure Compound to the users
• Resolve the incidents and problems with ITIL standards and Problem Management process finding the root cause and coordination among team.

Technology: Oracle 9i/10g, SQL, PL/SQL, Teradata, DB2,UNIX, ETL Informatica

Confidential

Oracle PL/SQL Developer / Analyst

Responsibilities:-

• Worked on PL/SQL in creating complex stored procedures and functions for databases of Customer Master SIMOn and Learning Network applications.
• Created various database objects like tables, indexes and views.
• Implementing application modules using Procedures, Packages and creation of Tables, Views, Materialized views, Sequences, Indexes, Synonyms and Functions.
• Used Collections like variable arrays, nested tables extensively.
• Writing triggers, stored procedures and functions required to send the Credit Approval Details
• Developed shell scripts to automate the daily and weekly load processes. Created and Scheduled Jobs.
• Monitor, Analyze the ETL/MDM data load jobs in database and resolve any issues that Caused the load job failure in real time.
• Wrote triggers to handle user generated events.
• Involved in requirement gathering and prepared technical design.
• Strictly adhered to coding standard and naming convention of objects.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic.
• Tuning complex queries for Weekly/Monthly reports as per the requirement from the business and automating them based on their future needs and criticality using Joins.
• Identifying the value add to automate the process and write scripts to implement those value add using UNIX and Autosys tool.
• Direct Interaction with Clients for better understanding of the Data Load requirements for ETL/MDM data load jobs Making various procedure scripts to minimize the work load.
• Grant Application access to users and maintain their information based on assignments.
• Perform the weekly data maintenance activities for Job Loads and the Trillium/Postal updates for the Merck customers to reflect the latest customer address information in Customer Master.
• Resolve the incidents and problems with ITIL standards and Problem Management process with proper analysis, finding the root cause and coordination among team.

Technology: Oracle 9i/10g, Siperian MDM, ETL Informatica, DB2, SAP, Java, JSP, UNIX

Confidential

Oracle PL/SQL Developer/Analyst

Responsibilities:

• Involved in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• Interacted with the business users and collected the requirements and prepared BRD (Business Requirement Document) that provides detailed information about the requirements.
• Complex PL/SQL procedures and functions and packages are developed to adhere to the specifications of the application.
• Used Dynamic SQL and autonomous transactions for error handling.
• Developed shell scripts for batch processing and database transactions.
• Involved in developing materialized views, views, synonyms and hints dB links to access data across schemas, indexed to gain performance.
• Created Records, PL/SQL Tables, Objects, Collections (Nested Tables and Arrays), and Error Handling.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Involved in unit testing the application code and database code for data integrity and application functionality.
• Tuning complex queries using Query Optimizer hints, joins and indexes.
• Providing support on highly critical application from the business point of view.

Technology: Oracle 9i, PL/SQL, CRM,UNIX/LINUX