SUMMARY:

• 12 Years of experience in end to end development of business software solution involving Enterprise Data Integration, Business Intelligence, Data Warehouse (EDW), ETL, Data Mining (DM), Online Analytical Processing (OLAP), Online Transactional processing(OLTP), Data Marts, Data Integration and Analytics (DIA) across pharmaceutical, Travel Hospitality and Consumer Products.
• Extensive experience in interacting with business user for requirements gathering and analysis.
• Experience in address validation using address doctor transformation in Informatica Data Quality (IDQ) to parse, analyze, standardize and enrich customer and vendor addresses.
• Email Validation, Phone Validation, De - dup and Fuzzy Match in Informatica Data Quality (IDQ).
• Utilized Informatica Developer and Analyst to design and develop custom rules and score cards.
• Developed informatica web services for phone and email cloud validation.
• Mining and analysis of source data for the purpose of solution performance analysis, optimization and creation of the target Data warehouse.
• Expertise in creating Reports, Dashboards, Charts, Graphs having complex business logic with improved performance using Business Objects, Web Intelligence and Qlik Sense Reports.
• Involved in process improvement activity, to improve process performance, data synchronization, data correctness, flexibility and responsiveness to produce and approve a product.
• Online analytical processing (OLAP) - Star and Snow flake schema design and development.
• Identification of materialized views, summarization and aggregation.
• Skilled working and expertise knowledge of Informatica (IDQ, Analyst, Developer, Repository Manager, Designer, Workflow Manager, and Workflow Monitor)
• Knowledge on procedural data base and scripting language PL/SQL, UNIX shell and Perl.
• Conceptualising and visualizing the integrated data sources for the extraction of the measures describing common aspects of the business.
• Usage of Teradata Power Exchange for fast load TPT Load. Salesforce Data Loader for load.
• Performance tuning through optimization of sources, staging, targets, transformations, etc.
• Work with users for stabilization and acceptance of the solution.
• System Release Management. System Outage Management.
• Performing Impact analysis and sending Notifications to all stakeholders in case of issues.
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self-motivated, very fast learner and good listener.
• Software Testing including Unit, System and Integration Testing, Test case/data preparation, execution and verification of the test results using Quality Centre.
• Performing walkthroughs & inspections as per standards.
• Creative in design and technical documentation.

TECHNICAL SKILLS:

Operating System: Unix, Linux, Windows

Programming Languages: PL\SQL, PERL, UNIX Shell ASP.NET, Python

ETL/DQ Tools: Informatica Designer, workflow manager, Informatica Data Quality IDQ(Developer), Informatica Analyst, Power Exchange, CDC

Databases: Oracle, Netezza, DB2, Teradata, SQL SERVER

Database Tools: Teradata SQL Assistant and Administrator, PLSQL developer, SQL Developer, Quest Central DB2, TOAD, Aqua Data Studio

Reporting Software: Business Objects BOXI r2/r3, Qlik Sense

Terminals: Reflections, Putty, SSH Secure Shell, WinSCP

Incident Management: Remedy Action Request

Versioning: Rational ClearCase, Huddle, CVS, Regulus

Scheduling: Tidal, Autosys

Others: SOAP UI, HP Quality Center

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr. ETL Developer

Responsibilities:

• Performed data validation, data profiling, data cleansing, Data Integration, using IDQ and Informatica Analyst.
• Defining rules in DQ and creation of scorecards in informatica Analyst.
• Creating reference tables, parsing and standardizing data using Address Validation.
• Testing and debug existing DQ components.
• Creation of project, technical and detailed design documents.
• Automation of email, phone, address and dedup match validation.
• Usage of IDQ for Data profiling and Data quality. Drill down profile results.
• Implementation of Web service for Email and Phone Validation.
• Dedup and fuzzy match and merge logic on org with address, without address and materials.
• Creation of dashboard, graphs and charts in Qliksense.

Skills: Informatica 10, SQL Server, Qlik Sense, Informatica IDQ(Developer), Informatica Analyst, Shell Scripting, SOAP UI, Python

Confidential, Parsippany, NJ

Sr ETL Developer

Responsibilities:

• Perform data analysis to gain an understating on how the business uses data.
• Provide expertise in developing technical solutions aligned to departmental strategy and vision. This involves requirement gathering, analysis, design and development of ETL process.
• Responsible for data assessment; data extract, transform, and load (ETL) from relational databases; implementation of Informatica processes to deliver data into Data mart, maintenance and tuning of ETL processes, documentation of all activities. Primary deliverable would include Data Analysis, Design, and Development of ETL applications using Informatica Power Center. Conversion of mappings from oracle to Teradata.
• Development of mappings, sessions & workflows using ETL tool Informatica Power Center to transform data from multiple sources including flat files, Oracle, Teradata and other relational sources. Created Stored Procedures and optimization scripts.
• Extensively used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Joiner, Look up, Update Strategy, Sequence Generator, Rank and Aggregator Transformation. Usage of Teradata Power Exchange for fast load TPT Load.
• Documentation of the application design and creation of Detail Design Documents.
• Unit, system and integration testing, test case / data preparation, execution and verification of the test results using Quality Centre.
• Creating, debugging and executing Informatica Mappings, Sessions, Tasks and Workflows in multiple subject areas.
• OLAP, Data mart, Fact (Star Schema) and Dimensional DB design and implementation.
• Writing complex queries, Stored Procedures.
• Performance tuning of sources, mappings, targets and sessions.

Skills: Informatica 9/10, Oracle, Teradata, SQL Developer, Teradata SQL Assistant. Quality Centre

Confidential, Parsippany, NJ

Sr ETL Developer

Responsibilities:

• Responsible for requirements analysis; data assessment; design; data extract, transform, and load (ETL) from relational databases; implementation of Informatica processes to deliver data into Data mart, maintenance and tuning of ETL processes, documentation of all activities. Primary deliverable would include Data Analysis, Design, and Development of ETL applications using Informatica PowerCenter.
• Development of mappings, sessions & workflows using ETL tool Informatica PowerCenter to transform data from multiple sources including flat files, DB2, Oracle and Informix relational sources. Create Stored Procedures and optimization scripts.
• Provide day-to-day support for operational data needs.
• Development of IDQ mappings for address validation and cleaning. Email addresses cleaning using standardizer transformation.
• Usage of IDQ for Data profiling and Data quality across DWH.
• Informatica Data Quality (IDQ) for Address label generator and specifying custom rules for data standardization across domain.
• Experienced with IDQ (Informatica Data Quality) for profiling database tables, Data cleansing.
• Movement of data from the system to Amazon cloud through data ingestion task.
• Extensively used various transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.
• Unit, system and integration testing, test case / data preparation, execution and verification of the test results using Quality Centre.
• Creating, debugging and executing Informatica Mappings, Sessions, Tasks and Workflows in multiple subject areas. Usage of Salesforce Data Loader for fast load.
• Writing complex queries, Stored Procedures.
• Performance tuning of sources, mappings, targets and sessions.

Skills: Informatica 9, Python,DB2, WINSCP, Informatica IDQ, Informatica Analyst, Aqua Data Studio, Oracle, Teradata, Windows 2003 Server, SQL Developer, TOAD

Confidential, Parsippany, NJ

ETL Developer

Responsibilities:

• Detailed analysis of the BRD and transformation of the business rules in technical specifications. Develop detailed specifications for development of modules as per Change Management Procedure.
• Identification of different discrete data sources for the purpose of data integration and breaking it into subject areas for the purpose of integration of the Data into warehouse (IMS-RX,IMS-DDD,IMS-HCOS,SAP,NP,SOPS,FF)
• Logical Modelling involving creation of the star and snowflake schema, by identifying different facts/Measure and Dimensions.
• Design complex ETL mappings using informatica for purpose of extraction of required data from the different discrete sources, transformation of the data applying business rules specified in the BRD/SRS, cleansing and loading in Target Data Warehouse. Usage of Netezza Power Echange for fast load.
• Netezza procedures for the complex lookups, evaluation of different cycle times and business days conversion while adjusting the dates based on the cycle, tolerance, etc
• Define and maintain Enterprise framework and firm standards for ETL processes
• Manage Data Mapping, transformations from source system to the Data Warehouse Environment. Analyse the data to find out data inconsistency and anomalies.
• Manage reporting Meta data and data standardization for end to end integration
• Coordinating with development team.
• Unit, system and integration testing, test case / data preparation, execution and verification of the test results using Quality Centre.

Skills: Informatica 9, Oracle, Netezza, SQL Developer, TOAD, TIdal, Python

Confidential . Indianapolis, IN

ETL Developer

Responsibilities:

• POC and SME for entire life cycle development of ETL (LORS, GMARS, GLIMS, ViCoM) Solution.
• Detailed analysis of the requirements on various OSSCE measures that the sites generate across various business areas in SCM as needed by the users. Breaking down into different subject areas that the users can relate to in their business terms. Creation of BRD/SRS.
• Identification of different discrete data sources for the purpose of data integration and breaking it into subject areas for the purpose of integration of the Data into warehouse of the pharmaceutical related production, manufacturing and lab result critical data along with the discrete Lab systems like Darwin, LIMS (Laboratory information management system) and SAP in developing an end-to-end GMP business solution.
• Logical Modelling involving creation of the star and snowflake schema, by identifying different facts/Measure and Dimensions.
• Transforming the Logical model into Physical Model. Partition allocation, indexing, etc.
• Design complex ETL mappings using informatica for purpose of extraction of required data from the different discrete sources, transformation of the data applying business rules specified in the BRD/SRS, cleansing and loading in Target Data Warehouse.
• PL/SQL procedures for the complex lookups, evaluation of different cycle times and business days conversion while adjusting the dates based on the cycle, tolerance, etc.
• Analyse the data to find out data inconsistency and anomalies.
• Design and develop Universes based on the subject areas to enable Adhoc report generation.
• Development a Dot Net based MDE tool for GmP Config data entry.
• Developed Canned Reports to represent different OSSCE matrices across SCM using BOXI r2.
• Software Testing including Unit, System and Integration Testing, Test case/data preparation, execution and verification of the test results using Quality Centre.
• Ensure the data requirements of the application are effectively addressed in accordance with BRD/SRS.
• Conceptualising and visualizing the integrating data sources for the extraction of the measures describing common aspects of the business.
• Documentation (Data Dictionary, ETL Design, Reporting Design, Universe Design, System Design and Overview, IQ/OQ, DRP, System Configuration and Release Notes.)
• Content organization, migration and Deployment.
• System Release Management. System Outage Management.
• Working with sites for the stabilization and acceptance of the solution.
• Performing Impact analysis and sending Notifications to all stakeholders in case of issues.