SUMMARY:

• An ETL Specialist/Informatica Architect with 17+ years of diversified experience in architecting solutions in different Software Development areas in Database architecture, design, and development with diversified clients of Manufacturing(GE), Finance ( GE), Healthcare (GE, J&J, Confidential /IMS, Confidential ).
• Subject matter expert (SME) in Life sciences majorly in HCP Spend, Healthcare Compliance, Customer Master, Rx Data, IMS Data, MCM Interactions, Sales Analytics, Sales Force Automation(SFA), Consumer Insights and Ethnicity marketing
• MDM Architect for the customer data with internal and external sources with and without data stewards.
• Well versed with the Informatica end - to-end application, from the Architecture to the delivery with various sources and Targets, ranging from Mainframe to the Oracle Applications.
• Experience in Informatica Administration, installing and upgrading the servers.
• Experience in third party software, including First Logic to integrate with Informatica.
• Experience in using Power Designer 10.0 & Erwin for Data Modelling.
• Excellent track record in working various types of projects, OLAP, OLTP, Data Warehousing, Migration, BI Solutions project.
• Experience in working with different databases Teradata, Oracle, SQL Server
• Experience in working with SFDC (Salesforce.com) transformations.
• Designed automated processes using UNIX and Maestro/TIDAL/Autosys Schedulers.
• Experience with handling huge databases with million rows refresh methodologies.
• Experience in pharmaceutical domain handling prescription data and HCC Compliance.
• Excellent hands on with Oracle partitioning and Materialized Views
• Experience converting client needs to technical specs and architecting based on the needs.
• Experience working with Atomization process in manfacturing Segments.
• Excellent in providing strategic solutions with short term goals and long term goals along with a road map.
• Excellent in Data analysis to identify the business scenarios Vs Data Scenarios.
• Well Versed with Different Tools for Accessing Databases and development in databases including: TOAD, PL/SQL Developer, I*SQL PLUS, SQL* PLUS, SQL Navigator.
• Extensive knowledge in SQL*Load, Teradata Fast Upload for day to day production data analysis and fixes.
• Highly talented in Performance tuning of the Queries and attacking the bottlenecks of the Application.
• Experienced in Unix Shell Scripting and other Unix utilities like AWK and sed.
• Extensive exposure to deal with Multi lingual data, diacritical and UTF8.

TECHNICAL SKILLS:

Hardware/OS: UNIX, Linux, AS/400, Sun Solaris, HP-UX, AIX, Windows 95/NT/98/2K/XP.

Languages: C, C++, Java, VB, PL/SQL, Visual C++, Pro*C, CL/400, ILE RPG

Database Systems: DB2/400, Oracle 8/8i/9i/10g/11g, MS Access, SQL SERVER, Teradata 12

Scripting Languages: Shell Scripting, AWK, SED

Tools: Informatica, MDM/Siperian, IDQ, TOAD, Win CVS, Power Designer, VISIO, i* sqlplus, BMC Fast Unload, Kalido DIW, BTEQ, Teradata SQL Assistant, Teradata Studio Express, SFDC Apex Loader, SFDC Apex Explorer

Schedulers: Informatica Scheduler, Maestro, Cron, TIDAL, Autosys

Application Servers: WebSphere, WebLogic Server

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

MDM Solution Architect /Sr ETL Architect/SME

Responsibilities:

• Performing the current state assessment and providing process improvement measurements.
• Data Quality Analysis of Customer Master data in MDM/Siperian
• Migration to Informatica MDM from Siperian XU
• Identified duplicates and changed the MDM processes to prevent and cleanup the current data
• Implemented DEA address compliance changes in MDM Hub console and corresponding ETL landing changes.
• Building of MCM Interactions in CDW from different channels such as Email, Direct Mail, Web etc.
• IMS Prescriber data analysis and co-ordination with IMS for data errors in the DEA data feed
• Re-architected Publish layers by removing redundancy, old business rules and consolidating the business rules
• Reviewing QC scripts and signing off
• Providing Strategic road map on Customer Master and Product Master
• Assessment of Nuclues360 from Cegedim to replace Informatica MDM
• Customer HCP and Accounts Data Integration from Symphony data provider
• Sharing the analysis with all stakeholders and prepping for the support team
• Inbound process overview
• Performance improvement in runtimes by redesigning and consolidating.
• Achieved 70% reduction in runtimes (13 hours to 4 hours) for Publish layer1
• Scripted SQL s for top level metrics about the data change trends
• Analyzes the data flow from all sources and downstream systems and recommended the corrective processes to prevent junk data build up.

Environment: Informatica Power Center 9.1, Informatica MDM 9.1, Oracle 11g,Teradata 12, HP UX UNIX, Linux, Business Objects, Autosys, iCue/Veeva/SFDC.

Confidential, Raritan, NJ

ETL Specialist/Informatica Architect/Lead Consultant

Responsibilities:

• Performed the building, designing and developing of the Data Warehouse utilizing Informatica.
• Mapped the development for the Data Warehouse with Informatica and Unix Shell scripting.
• Informatica mappings for various integration needs of Totality.
• Assigned and balanced the work load for the other Informatica team members.
• Performed the Data analysis and Data Cleansing.
• Performed the Level 3 Support for ETL production support.
• Worked with the Cognos reporting team for the required changes.
• Conversion of Cognos reports pointing to OLTP to Data Warehouse.
• GXRS Claims loading into Totality.
• Established different feeds with in and out of Totality application.
• CRM Data integration for Health Care professionals (HCP) & Institutions.
• Provided the strategic solutions for the business problems.
• Created Shell scripts for automating e-mail notifications.
• Scripted SQL s for top level metrics about the application usage (ad-hoc).

Environment: Informatica Power Center 8.1.1/8.6.1, Siperian, Oracle 10g/11g, HP UX UNIX, Linux, Cognos, Maestro / TIDAL.

Confidential, Cranbury, NJ

Marketing Effectiveness Analyst/Informatica Architect/Lead Consultant

Responsibilities:

• Developed, tested, and maintained the interfaces utilizing Informatica.
• Consumer Programs Automation.
• Built the Reporting Universe for Confidential data marts.
• Prescriber Promotion Response end to end application building & support.
• Performed the Back up of Production and Development Repositories.
• Query Optimization using Analytical Functions.
• Control Selection program redesign.
• Generic Consumer Programs Reporting Universe.
• Consumer Characteristics data integration & product development.
• Rx (Pharmacy), MX (Medical), Hx (Hospital) Integration for Consumer Programs.
• Followed the SDLC in the Development.
• Consumer program reporting Mart.
• Dynamic Variable calculation in Rx (Pharmacy) claims Consumer Programs.
• Excel Reports with Pivot functionality.

Environment: Informatica Power Center 6/7.1/8.1.1, Oracle 9i/10g, IBM AIX Unix, Micro-strategy

Confidential, Waukesha, WI

Informatica Developer/Administrator/Data Architect

Responsibilities:

• Maintained the Data Quality & Ensuring Intra modular Data integrity.
• Developed the Scripts and testing and implementing the data changes for BUG fixing.
• Developed Informatica Interfaces between different modules.
• Created and maintained multiple database environments for development, testing, staging etc.
• Architected a new integrated database to serve the needs of each of the old application areas.
• Set up a framework for integrating the applications.
• Enhanced the capability and functionality of integrating applications.
• Analyzed the Requirements and Database Design.
• Address data cleansing with First Logic and Informatica.
• Duplicated the Accounts match finding with First Logic Match Engine and Informatica 7.1.
• Administration of Informatica Server, First Logic Server, eDQ Server.
• Developed, tested and maintained the interfaces using Informatica.
• Implemented the Schemas through the complete cycle and requirements gathering.
• Customer Data Integration between 2 ERP systems.
• Performed the Data Loading for Load Test Data.
• Performed the Data Analysis for Integrity and Cleanliness and accuracy.
• Defined the structure in WIN CVS and managing the code in CVS.
• Migrated Informatica6.0 to Informatica 7.0.
• Migrated Informatica 7.0 to Informatica 7.1.
• Migrated First Logic matching Engine.
• Set up the reusable processes.

Environment: Informatica Power Mart 6.0, Oracle 9i, Informatica 7.1, Informatica 7.0, Unix, First Logic 4.1c, Power Designer 10, e-Data Quality (eDQ) Server

Confidential

Validation Consultant

Environment: DDTS, CEM, eNPI, Windows NT/2000

Responsibilities:

• Validation Leader for eFMEA, Causality Engine and CEM (Content Engineering & Management).
• Core team Member of Projects.
• Prepared the Validation Test Plan & Publishing Validation Report.
• Assigned the Test plans to the Validation Testers.
• Tracked the validation test progress.
• Estimated the product status after validation.

Environment: DDTS, CEM, eNPI, Windows NT/2000

Confidential

Module Leader

Responsibilities:

• Project Management.
• System Analysis / Impact Analysis and Development.
• Data extraction.
• Created Unit/System test plans and performed the testing and debugging.
• Quality Assurance.

Environment: Unix, Windows 95, Windows NT, Shell Script, PL/SQL, AWK/SED Scripts, TOAD

Confidential

Project Leader

Responsibilities:

• Project Management.
• System Analysis/Impact Analysis and Development.
• Created Unit/System test plans and performed the testing and debugging.
• Quality Assurance.
• Migration Support.
• Compatibility checking for new environment.
• Post production Support & Data extraction.
• Performance data capturing.

Environment: Unix, Windows 95, Windows NT, Shell Script, PL/SQL, AWK/SED Scripts, C, Pro* C, Java, JSP Omnidex, BMC Fast Unload, SYNCSORT, PL/SQL Developer.

Confidential

Module Leader

Responsibilities:

• Module Management and Planning.
• Carried out quality activities through IPMS.
• System Analysis and design.
• Design activities.
• Development/Coding.
• Creation of Unit, System test plans.
• Testing and debugging.

Environment: Unix, Windows 95, Windows NT, Shell Script, PL/SQL, AWK/SED Scripts, C, Pro* C, JAVA, JSP, Syncsort, PL/SQL Developer