SUMMARY:

• Over 7+ years of experience in the Software Development Life Cycle (SDLC) that includes expertise in the Analysis, Design, Development, Implementation, Modeling, Testing and data Warehousing using the tool InformaticaPowerCenter9.0.1/8.6/7.1.
• Around 3+years experience working on Master Data Management (MDM) and Business Intelligence projects for Pharmaceutical/Life Science companies. Core responsibilities include data profiling, fit - for-use analysis, business/technical requirements gathering, architectural and technical design, data modeling, development/documentation of test cases, and business process development.
• Designing, Installing & Configuring core Informatica MDM Hub components Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter and IDD & Data Modeling.
• MDM Hub configurations - Data modeling, Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director.
• Defining and configuring landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages.
• Performing Data standardization of addresses using Address Doctor, Trillium, and Informatica Data in real-time using SIF API’s.
• Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectives in many project life cycles.
• Strong experience in InformaticaData Quality (IDQ), Power Center, Data Cleansing, Data profiling, Data quality measurement and Data validation processing.
• Experience working with various heterogeneous source systems such as Oracle, DB2, MS SQL server, XML files, flat files, Teradata and MS SQL server.
• Performed ETL performance tuning of the sources, targets, transformations, mappings, workflows and sessions to resolve or remove the bottlenecks.
• Have extensively worked in developing ETL for supporting Data Extraction, Data Transformation and loading using Informatica Power center
• Well acquainted with Informatica Designer Components-Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Worked extensively using complex mappings using different transformations like Source Qualifiers, Expression, Filters, Joiners, Routers, Union, Lookup(connected & unconnected) and Aggregators.
• Experience in developing Sessions/tasks, worklets, workflows using workflow manager tools-Task Developer, workflow & worklet designer.
• Working with Slowly Changing Dimension methodology (Type 1, Type 2. Type 3) and slowly growing target methodologies.
• Experience in debugging mappings, analyzed bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Hands on experience in performance tuning and optimization of various transformations.
• Experience in documenting the ETL process flow for better maintenance and analyzing the process flow.

TECHNICAL SKILLS

EIM Tools: Informatica MDM Multi-Domain 9.7.1, 9.x, Informatica Data Director(IDD), Informatica Data Quality(IDQ), Service Integration Framework(SIF).

ETL Tools: Informatica Power center 9.5.1/9.1.0/8.6.1/7.1

Reporting Tools: Cognos 10 & Informatica Power Analyzer 4.0

Scheduling Tools: Workflow Manager, ESP, Control-M, AutoSys

Databases: Oracle 11g/10g/9i/8i, DB2, SQL Server

Languages: SQL, C, C++

Operating Systems: Windows XP/98/2000/2003/2008, MS-dos

PROFESSIONAL EXPERIENCE:

Confidential, Pasadena, CA

Informatica MDM Developer

Responsibilities:

• Installed & Configured MDM Hub on Dev, Test and Prod Server, cleanse, resource kit, and Address Doctor in Dev, QA.
• Gathered requirements from business users
• Creating the Base objects, Staging tables and landing tables foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Created Mappings to get the data loaded into the Staging tables during the Stage Process.
• Defined Trust and validation rules for the base tables.
• Coordinated with Business team and making them understand Match & Merge and incorporated their requirements.
• Created Match rule sets in for the base objects by defining the Match Path components, Match columns and rules.
• Created IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import data.
• Configured Address Doctor and fixed the AD issues by doing the changes in the config file.
• Worked on BDD config file to get the changes reflected on IDD.
• Developed and created queries that can be used for over and under Matching.
• Analyzed the data by running the queries and provided the stats after Initial data and incremental Loads.
• Discussed use of Roles, creation of users and assignment of user to Role.
• Defined Roles and privileges for each environment according to requirements.
• Defined the security such that schema will be secured with access only granted for specific downstream integration uses, using users created for those specific integrations.
• Created Batch Groups in Utilities Workbench and scheduled them externally using Power Center and Autosys (any scheduling tool).
• Contribute towards enrichment of data quality rules.
• Combining regulatory and application requirements into the business rules.
• Providing the advanced business rule writing skills via IDQ Developer and our skilled technicians

Environment: Informatica Multidomain MDM 9.5.0, IDD, Informatica Power Center 9.1.0, IDQ, Jboss, Oracle 10g,SQL Developer, Address Doctor, SIF, Toad, SQL*Loader, Erwin.

Confidential, NYC, NY

MDM Analyst

Responsibilities:

• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.
• Led the implementation of the first Enterprise hostedTableauServer environment at Confidential .
• Working in SQL server, Oracle databases and Netezza Data Warehouse appliance.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Performed data analysis on source data to be transferred into an MDM structure.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence (BI) Data Warehouse.
• Build cold loaddatacollected from discrete business processes intoMasterData Management (MDM).
• Working on multiple levels of anInformatica MetadataManagement project, including designing themetadatastrategy, defining themetadatamanagement architecture, managing the metadataproject, mentoringmetadatadeveloper.
• Analyse data with Informatica Analyst and update Master Data Management (MDM)
• Working on design and development on Oracle and Teradata usingInformatica Powercenteras the ETL tool.
• Presented hub solutions for a Multi-Domain Party model MDM for customers and reps and products.
• Create and maintain data model/architecture standards, including master data management (MDM)
• Worked on enterprise Data Management components such as Data Governance, Data Standardization as Data Governance, Master Data Management.
• Solid understanding of relational and dimensional data modeling techniques (logical & physical)
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle9i/10i, ERwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Working on ETL process using Informatica PowerCenter and IBM InfoSphereDataStagetools.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
• Developed Systems Specifications document to define the impact of the new requirements on the existing system.
• Working on operational databases anddatawarehouse, reference and master data management (MDM), dataanalysis and mapping

Environment: Informatica Multidomain MDM 9.5.0, IDD, Informatica Power Center 9.1.0, IDQ, Jboss, Oracle 10g,SQL Developer, Address Doctor, SIF, Toad, SQL*Loader, Erwin.

Confidential, Brea, CA

Informatica Developer

Responsibilities:

• Single handedly developed the module by dumping the data from source to a staging area, the staging data was then cleansed and validated against the specified business rules and loaded into Intermediate layer.
• The cleansed data from the Intermediate layer was then loaded into Data Repository after applying the required transformation rules.
• Created materialized views for the better performance in reporting.
• Responsible for Extraction, Transformation and Loading the data into Data warehouse by using Informatica Power center 9.5.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations, Lookup and Expression Transformations in Informatica.
• Created staging tables from the legacy database along with the auditing information.
• Involved in Analysis Phase to gather the requirement provided by user and prepare the functional document.
• Interacting with BA’s and downstream end users to understand the requirements clearly.
• Involved in creating the data model and specs for the ETL development.
• Developed Informatica mappings. Unit test ETL mapping codes and validated the result set data.
• Load the data from various File systems to the DWH and DM.
• Maintain the Versioning for the objects by using VSS.
• Analyzed the compatibility of the current code base and determined the impacts of new data mart (CDM) over the existing system.
• Designed and documented the technical and functional specification of the module.
• Documented validation rules, exception processing and test strategy of the mappings
• Migrated ETL codes from Development to Test to Production.
• Supported and executed the job run cycles manually through the workflow process setup for each release.
• Performed unit testing for the developed mappings.
• Created Source to Target Mappings (STTMs) document.
• Validated and monitored daily job runs.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Studied and analyzed existing mappings/sessions and identified performance bottlenecks.
• Translate data transfer requirements into ETL solutions.
• Design, develop, test, and maintain ETL processes.
• Write complex DB2 joins and conditional DB2 logic.
• Create reusable objects.

Environment: Informatica 9.5.1, Share point, System navigator, TOAD, IBM DB2, AS400.

Confidential, Paramus, NJ

Informatica Developer

Responsibilities:

• Involved in writing project documentation.
• Worked on Informatica tools, Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Various kinds of transformations were used to implement simple and complex business logic. The mappings involved extensive use of transformations like Filter, Router, Expression, and Union.
• Used Lookup Transformation to access data from tables, which are not the source for mapping.
• Build Session, Worklets/Workflow, Create/Modify Parameter File.
• Solely responsible for the daily loads and handling the reject data.
• Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements.
• Changed some stored procedures in Oracle 9i as per the Business Requirements.
• Used SQL tools like SQL Navigator to run SQL queries and validate the data in warehouse.
• Used workflow manager and work flow monitor to run and monitor jobs.
• Extensively worked with flat files and excel sheet data sources. Wrote batch scripts to automate flat file transportation local to Informatica server.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, Worklets, Assignment, Timer and scheduling of the workflow.
• Analyzing the source data and deciding on appropriate extraction, transformation and load strategy.
• Developed a number of complex ETL mappings, mapplet and reusable transformations for daily data loads.
• Developed mapping parameters and variables to support SQL override.
• Created physical data models and procedures for DB2 and Oracle.
• Designed and developed table structures, stored procedures and functions to implement business rules.
• Used Informatica Data Explorer and Informatica Data Quality for Data Quality Management and Data profiling purposes.
• Used Informatica Data Quality to formulate data conversion and data cleansing rules.
• Generated Perl scripts for data validation, data collection and data importing.
• Involved in ERWIN as data modeling tool.
• Used techniques like source query tuning, single pass reading and caching lookups to achieve optimized performance.
• Used Teradata SQL Assistant to run the SQL queries and validate the data.
• Associated with Production support team in various performances related issues.

Environment: Informatica PowerCenter 8.6.1, Oracle 11g, ERWIN, Teradata, PL/SQL, UNIX, Windows XP/7, SQL Server.

Confidential

Report Developer

Responsibilities:

• Responsible for the creating stored procedures and database triggers.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the data from data files into the staging tables.
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required project.
• Understand the Business requirements and estimate the effort for the new requirements.
• Trend analysis of defects/logs for identification of problem areas and to improve productivity.
• Customization/Creation of ETL components.
• Handled complete configuration of customized/new tasks and loading process through DAC.
• Understand the Business requirements and estimate the effort for the new requirements.
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Take care of CR (Change Request).
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Creation of Unit Test Cases for testing purpose.
• Performance tuning of the application wherever required
• Preparing the estimation for new CR and bug fixes.
• Doing the System improvement plan wherever required.

Environment: Informatica 8.x, Erwin, SQL, PL/SQL, Toad, Unix/Oracle 9i.