SUMMARY

• Over NINE Years of Experience in Designing, Development and Implementation of Operational Data Stores, Master Data Management,
• Data Warehouses & Data marts using Informatica Power Center, Informatica IDQ and Informatica Cloud.
• Have created multiple subscription data models using Informatica DIH for data warehouses and external vendors.
• Accomplished creating many data integration projects using Informatica involving multiple types of data sources both on - premise and cloud
• The cloud sources have been MS Dynamics and SalesForce.
• Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, testing, implementation and post-implementation review.
• Possess wide range of IT industry experience with Pharma Domain (Sales and Marketing), Travel and Hospitality Domain (Real Estate) etc.
• Good knowledge of XML mappings, xsd schema definitions and xml sources and targets.
• Worked using Power Exchange to pull data using Web Services from application built of SAP, Salesforce.com etc and used SOAP requests in WSDL transformation and source to pull data.
• Extensive experience with ETL tool Informatica in designing the Workflows, Worklets,
• Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.5.1/9.1/8.6/8.5/8.1.1.
• Proficient in Extracting, Cleaning, Transforming and Loading the data using all the Transformations in the ETL tool Informatica.
• Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• Involved in Debugging and Performance tuning of targets, sources, mappings and sessions
• Extensive experience in developing reusable transformations and mapplets embedding the business logic. Installed different IDQ services in Informatica 91.
• Extensive experience on using informatica to load data to Netezza using Informatica power exchange for netezza utilities.
• Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables.
• Involved in preparing migration documents to move the mappings from development to production repositories
• Good Knowledge on using scheduling tools to automate running of Informatica workflows. Involved in UNIX shell scripting, FTP and file management in various UNIX environments
• Team player and self-starter with good communication skills and ability to work independently and as part of a team.
• Sound knowledge of Microsoft Visual Basic (VB and VBA Excel).
• Excellent in developing macros in VB Excel.
• Sound knowledge in development projects of Informatica.
• Excellent communication skills, strong problem solving skills, good team player and self-starter.
• Involved in full lifecycle of several projects including requirements gathering, analysis, design, development, testing and debugging.
• Experience in writing Integration and System Test Scripts.

TECHNICAL SKILLS

Tool: Informatica 9.6.1Informatica Data Quality Informatica Analyst Informatica DIH Informatica B2B Toad 11.0 Toad for DA SSMS AGINITY WA Scheduler Control M

Programming Languages: SQL/PL-SQL Unix/Linux DOS

Scripting Language: Unix/Linux VB Scripting

Database: IBM Netezza Oracle MSSQL SQL Server

Utilities: VM Ware MS Office Suite Toad SQL Developer REMEDY Quality Center Visio VSS

OS: Unix/Linux Windows Vista/XP

Soft Skills: Dressing Grooming Articulation skills Basics of Business Effective Meetings English Edge Global Effectiveness Group Discussion Learning to Learn Personal Effectiveness Presentation Skills Professional Practices Speak up Written Communication skills

PROFESSIONAL EXPERIENCE

Confidential, Lombard, IL

Senior ETL Developer and Data Architect

• Tools: Informatica Power Center 9.6.1 hotfix, Informatica Developer 9.6.1 hotfix, SQL Server 2012, Control M
• Operating Systems: Windows 2008
• Programming Languages: SQL/PL-SQL, Windows Batch Script

Responsibilities:

• Senior ETL Developer and Data Architect
• Developed complex maps to cleanse incoming properties data
• Used Informatica Address Doctor to cleanse addresses and find the health of the incoming data
• Used Bing and Google geo coding location APIs to enrich the data with proper geocodes of the properties
• Used Informatica Data Quality to generate web services and read Soap and RESTful APIs
• Created Subscriptions with DIH
• Developed Error Handling Methods in case a property address is not up to the business standards
• Developed dynamic email notification system to send proper information to the concerned parties who are the stewards of the incoming data
• Lead a group of four people which included developers and testers
• Extensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
• Actively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
• Used deployment groups, repository queries and labels to actively deploy Informatica code from one environment to the other
• Developed ETL process which audit’s ETL loads, passes incremental parameters and deletes bad data in the case of partial runs

Confidential, Indianapolis, IN

• Tools: Informatica 9.1, Netezza, Linux, SSAS, Tableau,Quality Center and WA
• Operating Systems: Linux
• Programming Languages: SQL/PL - SQL, Linux Shell Script

Responsibilities:

• Used Data Transformation Studio to configure and deploy data transformation service required to load HL7 messages from message queue to relational tables
• Responsible for installing and maintaining OHADI (Oracle Healthcare Analytics and Data Integration) repository and required ETL components
• Developed error handling strategy which was implemented enterprise wide as a standard to process data from all source systems, the process uses a re- usable Informatica code which uses custom SQL queries to populate the errors from source system
• Lead a group of four or more junior and senior developers on a variety of development projects which involved moving data from different sources to Health care Data Warehouse
• Extensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
• Actively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
• Part of Code review and design review boards responsible for making sure the codes adhere to the UPMC standards and signing off the Informatica solutions before development, respectively
• Used deployment groups, repository queries and labels to actively deploy Informatica code from one environment to the other
• Lead Informatica developer on the project which loads patient encounters originating from Medipac source system, the process used several background log tables to covert the incoming message event feed into data with value
• Worked extensively on developing re-usable logics which are used in multiple projects
• Developed ETL process which audit’s ETL loads, passes incremental parameters and deletes bad data in the case of partial runs

Confidential, Indianapolis, IN

• Tools: Informatica 9.1, Netezza, Linux, SSAS, Tableau,Quality Center and WA
• Operating Systems: Linux
• Programming Languages: SQL/PL - SQL, Linux Shell Script

Responsibilities:

• Developed and SDA2 type data warehouse model where Specialty Drugs data would come from different sources.
• Developed error handling strategy which was implemented enterprise wide as a standard to process data from all source systems, the process uses a re usable Informatica code which uses custom SQL queries to populate the errors from source system
• Lead a group of four or more junior and senior developers on a variety of development projects which involved moving data from different sources to Health care Data Warehouse
• Using SSAS, developed and analytical model to slice and dice the data
• Using Tableau, generated reports over the SSAS cube

Confidential

• Tools: Informatica 9.1, Netezza, Linux, SSIS, Tableau,Quality Center and WA
• Operating Systems: Linux
• Programming Languages: SQL/PL - SQL, Linux Shell Script

Responsibilities:

• Understand and analyze Business, Functional, Technical and requirements for Profit and Loss Operations Tool.
• Designing Powercenter Informatica Mappings and Workflows as a solution with equal focus on business requirements and performance and the data quality.
• Track and prepare the report of development activities.
• Understand the testing effort and keep track of the new requirements / change in requirements of the project.
• Create the Test Plan, Test Scenarios, Test Cases, Test conditions and expected results for Unit and Integration testing
• Create Test Scenarios, Test Cases, Test conditions and expected results for module, integration and system testing.
• Perform Testing for the code developed by other team members.
• Check / Review the Test Cases documents prepared by other team members.
• Coordinate offshore activities of the project and ensure the timely delivery of different deliverables.
• Implementing and monitoring process improvement and quality assurance processes.
• Applications related Issue Tracking & Resolution using help of TCS Experience Based KM (Knowledge Management) tool.Recording solutions of recurring errors/problems in Consult Repository.

Confidential

• Tools: SQL Server 2008, VBA Excel
• Operating Systems: Linux
• Programming Languages: SQL/PL - SQL, VB Script

Responsibilities:

• Gather account sales data from a third vendor using Informatica and process the data using SAS , run various extracts from the data for other functions in Sales Legacy.
• This process is done on a weekly or monthly basis.
• Process alignment data for various sales representatives with different geographies.
• This process is done on a monthly basis to check what are the changes in alignment of the Sales Rep are and notify clients in form of reports.
• Align sales rep data with all other physicians and accounts.
• Process and design sales data in SQL-SERVER and VBA using alignment data to fix quota/goal for the sales representatives for forthcoming quarters.
• This is a quarterly process and all the necessary reports needed to deduce the future goals for Sales Rep are send in form of reports.
• Process data in SQL-SERVER and VBA using sales data from physicians, accounts, alignment data and payment curves provided by client to generate
• Incentive Reports for Sales Representative. These reports are generated monthly and are used by Sales Rep and their managers to see how much incentives are they liable to get paid.
• Process Change Requests using REMEDY tool in any of the above using SLA.

Confidential, Indianapolis, IN

• Tools: Informatica 8.6, Netezza, Linux, Quality Center and WA
• Operating Systems: Linux
• Programming Languages: SQL/PL - SQL, Linux Shell Script

Responsibilities:

• Developed complex mapping to load file data into stage layer
• Used parameters and variables to capture the date of loading

Confidential, Indianapolis, IN

• Tools: Inform, Clintrial
• Operating Systems: Windows
• Programming Languages: SQL/PL - SQL, VB Script

Responsibilities:

• Developed VB codes as rules which were called to check the sanctity of data when fed by any used during Clinical Trials
• Developed PL/SQL to cleanse and organize the data which was then sent for reporting