SUMMARY

• Priyanka Thomas has been in the Information Technology industry for over 54 months working as a software engineer in the data-warehousing area. She has worked on application development projects as well as on maintenance and support of critical business applications for various client organizations during this tenure. She is an expert in Informatica ETL tool and has excellent exposure to Oracle database. She is an Informatica certified professional (Designer, Advanced Designer, Admin) and has a bachelor'sdegree in electronics and communication engineering.

Work Experience

Associate-Projects
Confidential

Sep 2007 - Apr 2012

Project 1: Bayer ABBI - DWBI CR
Client: Confidential
Role: DW Developer DI
Skills: Informatica 8.6, Informatica 9 & Teradata 13.0
Period: December 2011 - April 2012

Confidential, is the U.S.-based pharmaceuticals operation of Confidential a
divisionof Bayer AG. One of the world\'s leading, innovative companies in the healthcare and medical products industry, Bayer HealthCare combines the global activities of the Animal Health, Consumer Care, Diabetes Care, and Pharmaceuticals divisions. Bayer Healthcare Pharmaceutical's A Better Business Intelligence (ABBI) project corresponds to build phase of the program aimed at building a data warehouse of business intelligence gathered from heterogeneous data sources. Various data sources situated internally and externally would provide Commercial data for Bayer\'s range of products (for example sales by product category, sales by region). Cognizant\'s ABBI solution will integrate and maintain data coming from these sources on a single integrated platform. It also provides a host of reports delivered to Bayer.

Responsibilities:

• Analyzed client requirements and created design document for various change requests.
• Developed Mapping Documents indicating the source tables, columns, data types, transformation required, Business rules, target tables, columns and data types.
• Developed numerous Complex Informatica Mappings, Mapplets, Aggregator, Joiner, Filter, Source Qualifier, Expression, Router, Lookup and Update Strategy Transformations.
• Implemented different Tasks in workflows which included Worklets, Sessions, Command, E-mail, Event-Wait etc.
• Worked with complex queries in Teradata for data validation and reporting.
• Wrote Teradata code for creating temporary work tables in source and target database.
• Prepared Test Cases for testing each of the interfaces which were used by the QA team.
• Performed unit testing, system integration test as well as user acceptance testing of the developed code.
• Participated in code migration from Informatica 8.6 to Informatica 9.
• Participated in production deployment of the developed change request code.

Project 2: Pfizer RIF Level 2 and 4
Client: Confidential
Role: DW Developer DI
Skills: Informatica 8.1 & Oracle 10g
Period: May 2009 - November 2011

Confidential, is the largest Pharmaceutical Company, with many Blockbuster drugs. Pfizer Inc, founded in 1849, is dedicated to better health and greater access to healthcare for people and their valued animals. A part of Pfizer's HHIT, the Data Warehousing and Business Intelligence (DW & BI) group is responsible for providing DW & BI services and setting strategy for the division. One of the key data warehouse applications developed and supported by DW & BI Team is Research information factory (RIF).

Responsibilities:

• Documented user requirements, Translated requirements into system solutions.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process.
• Developed Mapping Documents indicating the source tables, columns, data types, transformation required, Business rules, target tables, columns and data types.
• Developed numerous Complex Informatica Mappings, Mapplets and Aggregator, Joiner, Filter, Source Qualifier, Expression, Router, Lookup and Update Strategy Transformations.
• Created different Tasks in workflows which included Sessions, Commands, Worklets, Decision Task, E-mail, Event-Wait etc.
• Generated Email Notifications through scripts that run in the Post session implementations.
• Worked with complex SQL queriesfor data validation and reporting.
• Worked on Performance Tuning of the complex transformations, mappings, sessions and SQL queries to achievefaster data loads to the data warehouse.
• Prepared Test Cases for testing each of the interfaces which were used by the QA team.
• Performed unit testing, system integration test as well as user acceptance testing of the developed code.
• Extensively used Informatica Metadata to analyze and manage repository efficiently.
• Performed Code review to ensure that ETL development was done according to the company's ETLStandard and that ETL best practice were followed.
  

Project 3: Applix ETL Support
Client: Confidential
Role: Informatica Developer
Skills: Informatica 8.6, Oracle 9i and UNIX
Period: February 2008 - April 2009

• The D & B Corporation (NYSE: DNB) is the most trusted source of information that companies need to make their business a success. D & B is the world\'s leading provider of business-to-business credit, marketing and purchasing information. The Applix ETL Project is to implement the business rules and generate the feed files to the TM1 Applix system, which is an OLAP tool with proprietary cubes and excel based frontend for reporting.

Responsibilities:

• Resolved production issues and provided bug fixes.
• Automated the jobs through scheduling using Built in Informatica scheduler, which runsevery day by maintaining the data validations.
• Monitored production workflows and fixed the failures by effective trouble shooting and quick resolutions.
• Undertook different RFC's (Request for Change).

Project 4: SCOTS ETL Support
Client: Confidential
Role: Informatica Developer
Skills: Informatica 8.6, Oracle 9i and UNIX
Period: February 2008 - April 2009

SCOTS includes a standard extract release process to enable other systems to utilize the standard code table set. The SCOTS system provides a web-based User Interface for reviewing the code table set and for requesting changes to that set, such as the creation of new code tables and code values.

Responsibilities:

• Resolved production issues and provided bug fixes
• Provided production support and DW - ETL job scheduling
• Undertook RFC's (Request For Change)

Project 5: GOE ETL Support
Client: Confidential
Role: Informatica Developer
Skills: Informatica 8.6, Oracle 9i, Sybase, Mainframes and UNIX
Period: Dec 2007 - April 2009

GOE- Guided Ordered Entry is a Critical Application for D & B. It is a repository of 108 million customer's data and serves as a credible source for many downstream applications within D & B. The environment comprises of Informatica Power Center 8.6 and Power Connect for mainframe.

Responsibilities:

• Custodian of production environment.
• Monitored production workflows and fixed the failures by effective trouble shooting and quick resolutions.
• Performed Performance tuning and enhancements of Informatica mappings and workflows.
• Conducted weekly review meetings with Line of Business and published weekly issue volume reports.
• Worked on Informatica Power Center upgrade from 7 to 8.1.
• Wrote UNIX scripts for unit testing the ETL Codes involved in enhancements.
• Designed Informatica mappings and workflows for populating tables for one time load and Incremental loads.
• Worked on Exception Handling Mappings for Data Quality, Data Cleansing and Data Validation.
• Extensively worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.
• Extensively worked with Scheduling tools like Control M.

Bachelor of Technology (B Tech)

Specialization: Electronics and Communication Engineering

• Informatica 7.1 Mapping Designer Certification
• Informatica 8.6 Mapping Designer Certification
• Informatica 8.6 Advanced Mapping Designer Certification
• Informatica 8.6 Architecture and Administrator Certification
  

TECHNICAL SKILLS

Microsoft Windows Server 2003, Windows XP, Vista

Technical skills

Data Warehouse Architecture, Design & Development

Programming Languages

C, C++,PL/SQL

Databases

Oracle 10g, Sybase, Mainframes,Teradata

ETL Servers & Tools

Informatica Power Center 7.1, 8.1, 8.6 and 9, Unix

Tools & Utilities

Informatica Power Exchange, Striva Detail Navigator, Microsoft VSS , Control M