SUMMARY:

• 14+ years of experience in Data Warehouse systems comprising of Informatica MDM, Informatica Power center, Teradata, Unix and Mainframe etc.,
• Worked in various roles as Technical Lead, Onsite Coordinator, Project Manager and ETL Developer & Mainframe Developer.
• Proficient in end to end installation and configuration of Informatica 9.x/10.0 suits (PC, IDQ, MM, BG, TDM, DVO, B2B, PowerExchnage for express CDC for Oracle both in Linux and windows)
• PMI Certified Professional since October, 2005.
• Having 10 years of Lead experience for the Development, Maintenance and Production support projects.
• Experienced in all aspects of SDLC including analysis, design, code, testing, and production support.
• Proficient in understanding business processes/requirements and translating them into technical requirements, design specifications and implement those requirements.
• Experience in leading onsite teams and offshore teams. Liaison between onsite and offshore teams.
• Proficient in Data Modeling concepts using Erwin, Star Schema, Facts & Dimension tables for Logical & Physical 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.
• Informatica (Siperian) MDM processes including batch based and real-time processing.
• Configuring Informatica Data Director (IDD) to meet Data Governance objectives in many project life cycles.
• Developed extensions and customizations to the services (SIF) tier of Informatica MDM Hub. Configured JMS message Queue and message triggers with SIF API.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited using Informatica.
• Used Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet and Mapping Designer.
• Worked extensively with complex mappings using multiple transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators, Stored Procedures, Rank and Normalizer.
• Strong Experience in using Mapping Parameters and Variables, Session and workflow level parameter and variables and dynamic generation of parameter files.
• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer. Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Proficient in performance tuning of Jobs. Strong in finding out the bottlenecks and fixing them using various tuning methods like session partitioning, reducing the lookup sizes, using persistent caches etc.
• Worked with Stored Procedures, Triggers, Cursors, Indexes and Functions.
• Experience in UNIX Shell Scripting, CRON, FTP, Connect Direct (CD) and file management in various UNIX environments.
• Good Experience in using the defect tracking tools like BMC Remedy, JIRA, HP-Quality Center.
• Skilled in delivering quality deliverables and meeting project objectives in tight deadline

TECHNICAL SKILLS:

EMI Tools: Informatica MDM Multi-Domain Addition10.x, 9.x, IDD, SIF

ETL Tools: PowerCenter 9.x/8.x (Designer, Workflow Manager, workflow Monitor, Rep.Server, Repository Manager, Mappings/Mapplets/ PowerCentertransformations), star Schema, Snowflake Schema, Test Data Manager(TDM)

Programming: J2EE, Teradata BTEQ and Loading Utilities (MLoad, Fast Load,Tpump), UNIX Shell Scripting, SQL, PL/SQL, COBOL, FOCUS,WebFOCUS, Coldfusion, JCL, REXX, HTML, EXEC, EXEC2, VSQL

Data Modeling: Erwin data modeler

Data bases: Oracle 8i, 9i,10g,11g, DB2, Teradata, FOCUS, Vertica, Sybase, SQLserver 2008

DB & other tools: SQL Developer, Toad, SQL* Plus, SQL Assistant, Teradata viewpointTeradata Loader Utilities, SQL * Plus, SQL*Loader, EDA Query Tool, HTTP listener, CD(Connect Direct), Oracle Golden Gate

Operation Systems: Linux, Unix, WINDOWS XP/NT/ 2000/98/95, MVS/XA/ESA, z/390

Scheduling: CRON, ESP, Autosys, TWS

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

MDM Lead

Responsibilities:

• Produces detailed MDM design specifications consistent with the high-level MDM design specifications
• Coordinated with ETL team for performing batch process to populate data from external source systems to landing tables in hub
• Analyzed the source systems data for identifying integrity issues and incorporated the same in Systems and Trust.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema modeling, Snowflake modeling, fact and dimension modeling at all the three levels: view, logical & physical.
• Involved in Test Data Management (TDM) via ILM.
• Configured Landing, staging tables, Base Objects
• Design, document and configure the Informatica MDM Hub to support loading, cleansing
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Preparing Test Data ( TDM) via Informatica Test Data Management 9.6, this process could be taken up in three different ways, Data Masking, Data Subset via ILM and TDM Data generation from version 9.6 onwards.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data.
• Created static lookups, dynamic lookups, queries, packages and query groups.
• Customized User Exists for deferent scenarios
• Used Hierarchy tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles
• Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data
• Developed extensions and customizations to the services (SIF) tier of Informatica MDM Hub
• Performed Import and Export of Metadata and Promote Incremental changes between environments from development to testing phase.

Environment: Multi Domain MDM 10.1.0, IDD, Oracle 11g, Oracle PL/SQL, SQL Server 2008, SQL*Plus, XML, J2EE, JSON, Weblogic Application Server.

MDM Lead

Responsibilities:

• Business requirements analysis and determining of project scope.
• Interaction with senior management and other workers in IT and user departments.
• Designed and developed mappings for loading of landing tables from different data sources.
• Analyzed the source systems and defined the Systems and Trust according to client requirements
• Configured Landing, staging tables, Base Objects
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Defined Match rules in Match and Merge settings of the base tables by creating Match Path Components, Match Columns and Rule sets.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data.
• Created static lookups, dynamic lookups, queries, packages and query groups.
• Customized User Exists for deferent scenarios
• Developed Hierarchies using Hierarchy Manager in the Hub as per the needs.
• Customized/Configured Business Data director (BDD)/Informatica data director (IDD)applications
• Configured JMS message Queue and message triggers with SIF API.
• Informatica MDM and ETL Admin activities including security and code promotion.
• Scheduling and supporting MDM HUB database weekly backups.
• Created Batch Groups in Utilities Workbench and scheduled them externally using Power Center and Autosys.
• Good Expertise on Informatica Power Center version 9 x/8 x, Informatica ILM-TDM Tool version 9 x and Informatica Power Center Data Validation Option (DVO) & Windows Environment and Business intelligence data management services (BIDM) tools.
• Created Unit Test Case Document, Technical Design Documents, Informatica Hub and IDD Migration Request Document.

Environment: Informatica Multidomain MDM 9.7.1, IDD, Informatica Power Center 9.1.0, Weblogic, Oracle 10g,SQL Developer, SIF, Toad, SQL*Loader, Erwin. Autosys

MDM Developer

Responsibilities:

• Involved in implementing the Landing Process for loading the customer/product Data into Informatica MDM from diverse systems.
• Defined the Trust and Validation rules.
• Developed custom mapping functions.
• Worked on multiple data cleansing and standardization scenarios using mappings
• Configured Landing, staging tables, Base Objects.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records.
• Done Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Executed and tested match rules on basis of application performance.
• Performed match/merge and ran match rules to check the effectiveness of MDM on data.
• Produced database code (SQL, stored procedures etc.,) solutions meeting technical specifications and business requirements.
• Formulated foreign key relationships and lookup information.
• Conducted MDM unit tests and code reviews
• Participated in system and integration test, identifies and resolves solution defects
• Created Unit Test Case document, Technical Design Documents

Environment: MultiDomain MDM 9.5, WebLogic 10.3.6, Oracle 10g, Oracle PL/SQL, SQL Developer, Toad, Star schema, snowflake schema.

Onsite Coordinator/Project Manager

Responsibilities:

• Involved in establishing connectivity to the client systems from offshore
• Driving the Knowledge Sessions for different teams.
• Driving the KT sessions for bringing up the team members up to speed
• Conducting weekly meetings with offshore/Onsite team members.
• Tracking the SLAs and making sure that team meets the SLA targets.
• Providing the RCA for any SLA misses and explaining the client in the weekly meetings.
• Conducting the adhoc meetings with client and explain if there is any SLA miss for the Priority one applications.
• Making sure that PERF alerts go in time with appropriate information if there is any expected SLA misses.
• Tracking the defects and reporting the progress of the defects implementation.
• Trouble shooting of the runtime problems and identifying the bottlenecks in the processing and provided solutions for the same in Informatica workflows & Teradata BTEQs.
• Coming up with system monitoring improvement ideas and working towards implementation the same
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in the Teradata BTEQ queries performance tuning.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Conducted code reviews developed by my team mates before moving the code into QA.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.5, ORACLE 10g/9i, TOAD, Vertica, Unix, Shell Scripting, TWS 9, BMC Remedy, C:D(Connect Direct), VSQL, Erwin Data Modeller, DB2, SQL, Teradata, SQL Assistant.

Onsite Coordinator

Responsibilities:

• Implementing Slowly Changing Dimension (SCD type II) design for the Data Warehouse.
• Developing workflows with Worklets, Event waits, Assignments, Conditional flows, Email and Command Tasks using Workflow Manager.
• Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, Update Strategy Designing and optimizing the Mapping.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle and Flat files and loaded into Oracle, Vertica
• Developed Informatica Workflows and sessions for mappings using Workflow Manager.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Conducting weekly meetings with offshore team members.
• Driving the KT sessions for bringing up the team members up to speed

Environment: Informatica Power Center 8.6, ORACLE, TOAD, Vertica, Unix, Shell Scripting, TWS 8.5, BMC Remedy, VSQL, Erwin Data Modeller

Onsite Coordinator

Responsibilities:

• Configuring C: D for sending files/receiving files to/from the downstream/upstream systems.
• Tuning of Teradata long running queries using Explain and analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes etc.
• Loading data into stage vertica and Teradata tables using flat files and loading target tables from stage tables.
• Used BTEQ, MLOAD, FastLoad, TPump, FastExport utilities to extract data from different sources and load into Teradata stage/target tables.
• Design ETL processes using Informatica tool to load data from Golden Gate Oracle source systems and Flat files into Oracle Target database/Flat files.
• Developing workflows with Worklets, event wait, assignment tasks, conditional flows and email using Workflow manager.
• Reusing the single workflow for loading data from various regions’ files with similar file structure using indirect loading as source type in session properties.
• Modified/created UNIX shell scripts for automating the tasks.
• Trouble shooting of the runtime problems and identifying the bottlenecks in the processing and provided solutions for the same in Informatica workflows.
• Involved in Unit testing, integration testing and tracking the defects to the closure
• Conducting weekly meetings with offshore team members.
• Driving the KT sessions for bringing up the team members up to speed

Environment: Teradata, Informatica Power Center, SQL Assistant, ORACLE, TOAD, Vertica, Unix, Shell Scripting, TWS 8.5, BMC Remedy, C:D(Connect Direct), Teradata Viewpoint, Vertica, VSQL, Erwin Data Modeller, JCL, COBOL, ESPMENU.

Senior Programmer Analyst

Responsibilities:

• Peruse the logs for the correct execution of the application by the users.
• See the reports whether they executing properly. See the report dates for their correctness.
• Execute the reports to ensure that the balancing is done properly.
• Check the daily database through HTTP Listener for the correctness of the database update.
• Check the Lockup and Line databases for their correct update by the users.
• Give suggestions for the improvement of the system to my manager.
• Interacting with Business Managers for adhoc reports and providing the reports within the available timelines which will mostly be within short span of time
• Preparing corresponding technical requirements based on the business requirements and getting the approval of onsite project manager
• Solve any production issues.
• Assisted Release Manager in Release management activities

Environment: WEBFOCUS, Developer Studio, EDA Server, Windows NT Server, EDA Query Tool, HTTP Listener

Senior Programmer Analyst

Responsibilities:

• Analysis of requirements, re-estimation will be sent to the concerned onsite PL.
• Analysis of code and making appropriate code changes to the existing code and writing new programs to in corporate required changes.
• Testing is to be done according to the test plan.
• Involved in peer reviews.
• Tracked the defects via Quality Center (QC).

Environment: COBOL, JCL, FOCUS, DB2, ENDEVOR, XPEDITOR, ES-9000, ESPMENU