Summary:

• 8 years of IT experience with 7 years of extensive ETL Developer experience in Design, Development, Implementations, Support & Maintenance of Data Warehouses and DataMarts using Informatica.
• Extensive experience in data warehousing Technologies using Informatica PowerCenter 6.x/7.x/8.1.1 and intense expertise using Oracle 7.x/8.x/9i/10g and SQL Server.
• Extensive experience in full life cycle project design and development.
• Knowledge of Data Warehousing concepts & Dimensional modeling like Star and Snowflake Schemas.
• Hands-on working experience in Dimensional Data Modeling, Data Cleansing, Standardization and Migration, and Data Staging of operational sources using ETL processes for data warehouses.
• Excellent working experience in Data Warehouse applications, directly responsible for the Extraction, Transformation & Loading of data from multiple sources into Data Warehouse.
• Experience in implementing complex business rules by creating re-usable transformations (Expression, Aggregate, Lookup, Router, Rank, Update Strategy) using Powercenter.
• Proficient in using Informatica Workflow Manager to create and schedule workflows.
• Well acquainted with Performance Tuning of sources, targets, mappings and sessions to overcome the bottlenecks in transformation and Loading.
• Highly proficient in SQL, PL/SQL, Stored Procedures, Triggers.
• Expertise in UNIX Shell Scripts.
• Knowledge of archiving and purging the databases.
• Gained working knowledge in reporting tools like Siebel Analytics, Business objects and COGNOS.
• Excellent Analytical, Communication and Team Working Skills.

certification:

• Certified Informatica Developer from Informatica Corporation

technical proficiencies:

Operating System: HP_UX 10.20/11i, DG-UNIX 5.4, AIX 3.0, WINDOWS NT

Database: ORACLE 8.x/8i/9i/10g/11g, MS SQL Server 2000

ETL Tools: Informatica Power Center/Power Mart 9.x/8.x/7.x/6.x/5.x,
Informatica Data Quality

Other Tools: TOAD, SQL-Navigator, SQL*PLUS, SQL* Loader

Languages: SQL, PL/SQL 2.3/8.0, Unix Shell Scripting

Reporting Tools: Business Objects 6.2/5.1,Cognos, Crystal Reports 8.0

Data Modeling ERWIN 4.0/ERX 3.5.2

Web Technologies: HTML, XML, Java Script

professional experience:

Confidential, NY June'11 - Till Date
Role: Senior ETL Developer

Confidential, is a pharmaceutical company with well-established franchises in the therapeutic areas of the central nervous and cardiovascular systems. The project is Project Synergy which is a full Suite Implementation of Revitas ContractSphere application.

Responsibilities:

• Analyzed the business requirements and involved in creating the system design document.
• Involved in design and development of ETL processes to support the Contractsphere Application.
• Involved in design and development of various interfaces using Informatica to load the data from SAP to Contractsphere and contractsphere to SAP based on the business requirements.
• Created various UNIX Shell Scripts for archiving of flat files and for creating the indirect source file based on the source files that are coming from SAP.
• Responsible for unit testing of the mappings created according to the business requirements
• Worked closely with Revitas team to understand the application, for development and testing purposes
• Involved in writing and executing the test cases for system integration testing.
• Documented the test results and get business approvals for the same
• Responsible for code promotion activities
• Provided best Technical and Process oriented Solutions for the Requirements.
• Involved in creating the knowledge transfer documents for the client.
• Involved in scheduling the Informatica jobs in control M and communicating the same to Revitas team to schedule respective Revitas jobs.
• Involved in manually running the Revitas jobs through front end for testing purposes such as settlement acknowledgements to verify the data and contract pricing eligibility job to generate data for the interface run when there are any contract or pricing changes.
• Involved in the data verification activities through front end Revitas application such as verifying the settlements are properly settled.

Environment: Informatica Power Center 9.0.1, Oracle 11g, ERWin 4.0, Microstrategy, SQL, PL/SQL,Revitas Contractsphere, Linux.

Confidential, NJ Mar'07 - May'11
Role: Data Warehouse Developer

A pharmaceutical unit of the Roche Group and one of the world's leading research-oriented health care firms. The Commercial Operations group supports the Prescription drug Sales and Marketing activities targeted towards health care professionals, hospitals, pharmacy benefit firms and federal health agencies. This data warehouse captures and stores information regarding salesforce activities like Calls/Samples/Presentations from the SFE system, Factory Sales data, third party data related to Prescriptions (IMSXponent Plantrak Rx), NDC and DDD (Drug Distribution Data) for Roche and Competitor products. It facilitates to view the fact data by different dimensions like Time, Aligned, Unaligned, Product grouping, Market, Customer views.

Responsibilities:

Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
Parsing high-level design spec to simple ETL coding and mapping standards.

• Involved in design and deveopment of data warehouse for CANADIAN Roche and coordinating with reporting team to design reports using COGNOS.
• Developed ETL process for new product alignment process and territory management changes.
• Designed & Developed Informatica mappings, creating sessions and workflows for Data Loads. Used Transformations like Joiner, Expressions, Aggregator, Stored Procedure, Lookups and Filter. Created worklets and workflows.
• Extensively used SQL overrides and substituted them in the place of multiple transformations. Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems. Used workflow manager for session management, database connection management and scheduling of jobs.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Involved in developing ETL process for customer Master Data Management to consolidate customers from different third-party vendors such as IMS,Dendrite,Walmart and Mckesson in support of Siperian (Master Data Management system).
• Involved in development of ETL process for co-marketing sales activity including Arthritis and oncology market and provide data for third-party vendors such as HeartBeat.
• Designed and developed weekly and monthly process for New Prescriber Audit (NPA) to create reports bassed on dispensed new and total prescriptions at the form/strength level.
• Involved in development of ETL process for Xponent Monthly and Weekly data from IMS and NDC including measures such as NRx, TRx counts, dollars, volumes and therapy.
• Designed and developed ETL process for contract management system reporting including contracts, business units , outlet sales data , chargeback and rebate data.
• Used Informatica Data quality tool for data cleansing and parsing capabilities, to standardize, validate and enhance data.
• Imported Informatica Data Quality (IDQ) plans as mapplets into Power Center to analyze, standardize and cleanse the source data.
• Developed and tested Current Process Modifications in Data Warehouse based on Change Requests from Users.
• Developed unit test strategy and involved in coordinating the full cycle system testing effort with the help of QA and project management team
• Involved in Monthly and Weekly Production process Support for Warehouse and DataMart with Customer, Rx and DDD data from IMS Health and NDC.
• Responsible for Migrating the Informatica Processes from development to Test and production Environment.
• Supported team members in critical ETL processes

Environment: HP 9000 UX Servers, HP-UX 10.2, Windows XP, Oracle 10g, Informatica Power Center 8.6, Informatica Data Quality, ERWin 4.0, Business Objects, Siebel Analytics 7.8/7.7, SQL, PL/SQL.

Confidential, PA Apr'06 - Feb'07
Role: Data Warehouse Developer

Confidential, is a global research-driven pharmaceutical company dedicated in discovering, developing, manufacturing and marketing vaccines and medicines to address unmet medical needs. Merck & Co., Inc implemented Informatica to develop sales & marketing warehouse for their products.

Responsibilities:

• Worked with business users and performed gap analysis for projects such as Merck Vaccine Division, Quest 8.0 and Informix.
• Used Erwin 4.1to review data model of the Warehouse.
• Designed & Developed Informatica mappings Using various Transformations like Lookup,Joiner, Router, Aggregate, Expression, Source Qualifier, Update Strategy and Filter.
• Developed reusable Maplets and Transformations
• Extensively used Dynamic Lookups for incremental loads.
• Involved in error checking and testing of ETL procedures and programs using Informatica session log.
• Created worklets and workflows and involved in the development of ETL procedures for moving data from source to target systems.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Performance tuning of Informatica ETL mapping like increasing the caching size, overriding existing SQL.
• Performance tuning of SQL queries.
• Developed Shell scripts for ETL automation and batch processing.
• Involved in performing Unit Testingand Integration Testingto check whether the data was loaded into the warehouse according to the business logic.

Environment: Informatica Power Center 7.1, Business Objects 6.1, UNIX Shell Scripting, Oracle 9i/10g, PL/SQL, Windows XP, Erwin, AIX.

Confidential, MN Feb'05 - Mar'06
Role: Data Warehouse Developer

Medica provides popular health plans and #1 rated service to business and government employers, to labor unions, and to individuals of all ages — from recent graduates to Medicare beneficiaries. This Project United Platform Migration was developed in an effort to support Medica business as Medica migrates from COSMOS to the United Platform. United Health Group will create a platform to support the data exchange between partner systems and United Platform systems and the project includes integration of all COSMOS and UP data to the new data warehouse structure and the modification of all downstream data marts, extracts, and applications to the new Medica Warehouse structure.

Responsibilities:

• Worked with business users and performed gap analysis.
• Designed & Developed Informatica mappings Using various Transformations such as Lookup, Joiner, Router, Aggregate, Expression, Source Qualifier, Update Strategy and Filter.
• Developed reusable Transformations, Mapplets, Sessions and Worklets.
• Extensively used SQL overrides and substituted them in the place of multiple transformations.
• Created worklets and workflows and Analyzed business process workflows and assisted in the development of ETL procedures for moving data from source to target systems.
• Parameterized sessions for parallel process execution to balance high volume loads.
• Extensively worked on performance tuning for the Informatica mappings to reduce the processing time on various transformations such as Source Qualifier, Filter, Aggregator, Joiner and Lookup.
• Performance tuning of Oracle PL/SQL code.
• Developed Shell scripts for ETL automation and batch processing.
• Developed processes which use pre and post process shell scripts, used windows batch scripting and involved in designing error handling strategy.
• Designed and developed incremental data loads of Dimension tables in the Warehouse.
• Performed Unit Testing to validate the data against the business rules.
• Involved in supporting the Project Management team with estimation, reviews and providing technical support to QA team.
• Involved in executing and monitoring the regular production loads.

Environment: Informatica Power Center 6.2, Business Objects 6.1, UNIX Shell Scripting, Oracle 9i, PL/SQL, Windows XP, Erwin, AIX.

Confidential, DHL Finance, India Jul '04 - Dec '04
Role: Software Developer

The client is a large Finance company, financing major industries. A large database is maintained regarding the details of the customers and the transactions involved with each customer. The Main system gets various feeds from all sub-systems in different regions by the end of the day and the system we developed processed these feeds to update the corporate database that was used by the marketing and various administrative departments for decision-making.

Responsibilities:

• Designing and developing Front-end Forms.
• Database Design.
• Documentation.
• Sql Queries to retrieve data from Oracle Database.
• Design and Development of Reports.

Environment: Windows NT/2000, and Oracle8i.