SUMMARY:

• Seventeen (17+) years of Software Development Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Testing in various Client/Server and OLTP/OLAP Applications.
• Fifteen (15+) Years of solid ETL (Extract Transform Load) Data Warehouse experience using Informatica PowerCenter, Informatica Developer, Informatica BDM, Informatica MDM, Informatica power exchange CDC mode and connector mode, B2B Data Transformation,Metadata Maanager, Data Validation Option (DVO).
• Have implemented CDC - Power exchange on oracle/DB2/SQL Server 2008, 2012 tables for Real time mode and batch mode in windows and linux server.
• Have implemented informatica powerexchange to read/write data from SAS/Salesforce/SAP applications to integrate the data into downstream system.
• Sound experience and knowledge on continuous integration & continuous deployment environments.
• Solid understanding of application program interfaces (APIs), messaging software and interoperability techniques and standards
• Very good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
• Very good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.
• Strong analytical skills with Excellent problem solving and debugging skills
• Very key player in Team collaboration maintaining exceptional code, architecture and documentation.
• Strong exposure in Data Management, Governance and Controls functions
• Extensive knowledge on informatica product installations on linux and windows platform.
• Have configured address doctor in IDQ platform.
• Have Remarkable experience as an Informatica BDM/Powercenter/IDQ/MDM administrator.
• Expertise in Informatica Performance Tuning and Error Handling.
• Experienced in developing Test Plans, Test Strategies and Test Cases for Data Warehousing projects ensuring the data meets the business requirements
• Have done POC on other Informatica Products like B2B Data Transformation, Metadata Manager, Data Validation Option, ILM
• Worked on Informatica Real time implementation using MQ and Web Services and Power Exchange.
• Strong knowledge on integrating HR data like Employee/Compensation/Onetime payment/Leave of Absence/Global Mobility/Contract contingent worker data into Workday cloud application.
• Excellent Interpersonal Skills with the ability to work independently and with the Team.

TECHNICAL SKILLS:

ETL Tools: Informatica BDM 10.1.1 U2, Informatica MDM 9.7.1, Informatica PowerCenter 9.6.1, Informatica B2B DT, Informatica-Web services, Informatica- MQ Series, Informatica - PowerExchange 9.5 for oracle EBS, SAP, SAS,salesforce Informatica IDQ, Informatica MDM Data Director 9.7.1,informatica DVO, Informatica ILM. HUE Browser, hbase, hive tables

Data Modeling/others: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions, UML and MDM Concepts.

Databases: Netezza 4.0 /Oracle 11g/10g/9i/8i, T-SQL, MS SQL Server 2008/2012, Sybase SQL Server 12.0/11.x, MS Access 7.0/2000, SQL, PL/SQL, SAP, window azure database, SQ

Job Scheduling: Informatica Scheduler, Control M,UC4, TIDAL, Tivoli-IBM Scheduler, CA-Autosys

Environment: Unix /Window/Share Point 2010

Tools: / Others: MSWord, MS-Excel, MS- PowerPoint, MS-Outlook,MS-Visio. MS-Project,Win SQL 7.5 / Toad for Oracle 8.6.1/SQL developer/Business Objects XI R2

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany,NJ

Informatica Architect /BDM Delivery Lead /Admin

Responsibilities:

• Designed and implemented generic Visio Mapping template that facilitated automatic generation of Informatica ETL mappings which reduced significant time and effort.
• Designed and implemented dynamic mapping concept on BDM 10.1.1 U2 environment
• Lead development initiative to adhere Informatica best practices and standards outlined in Informatica's Velocity Methodology for informatica BDM and power center environment
• Worked with informatica IPS to set up EC2/EMR environments on AWS cloud.
• Strong Experience in Hadoop, Hive, hbase distributed computing and parallel processing.
• Experience upgrading Informatica PowerCenter BDM on Linux or AIX platform
• Experience applying Hotfixes to Informatica servers
• Experienced in troubleshooting and finding root cause for all BDM failures on EC2 and Hadoop environments.
• Configured and implemented CDC power exchange against SQLSERVER 2008/2012, Oracle 11g/DB2 environments.
• Thorough knowledge on power exchange table registrations/exporting datamaps to higher environment using DTLURDMO tool.
• Strong databases experience against oracle/SQL server/AWS RDS/Redshift
• Worked extensively on Informatica partitioning when dealing with large volumes of Meter Reads data and also partitioned the tables in Oracle for optimal performance.
• Upgraded informatica 9.6.1 envriornment to 10.1.1 envrionment
• Documented ETL Designs, ETL Standards and Source to Target mapping.
• Supported SQL server Database migration project to Azure SQL Server on cloud
• Led a group of technical on-shore and off-shore developers and support team.
• Worked on creating data profiling/score cards for business reporting
• Worked on creating HLD/LLD documents
• Worked on control M job automation for production runs
• Managed software design and technical architecture of large complex system, using project management and planning skills to minimize development time and maximize client acceptance.

Environment: Informatica BDM 10.1.1 U2, EMR 5.4,powercenter 9.6.1,Power exchange 9.6.1,hive,hbase,RDS/Redhsift/control M/Informatica IDQ 10.1.1/Informatica IDQ 10.1,hue browser,aginity

ETL/DQ Architect

Responsibilities:

• Working on various data profiling activities using Informatica Analyst and Informatica Data quality in the requirement and the data analyses phase for Fin regulatory reporting and Fed Remediation reporting projects.
• Working with Data modeler to create the data model to accommodate the incoming exception data.
• Established complete Data Quality applications for the business and technology users across the entire full development life-cycle for IHC project.
• Implemented best standards/guidelines/Best practices and naming standards for IDQ/Powercenter/MDM environments.
• Worked on Complex quality rule and index design, development and implementation patterns with cleanse, parse, standardization, validation, scorecard, exception on IDQ
• Integrated IDQ with Powercenter and MDM for Automation purpose
• Created multiple scorecards to the business on the various reports on incoming data on various source systems using IDQ
• Have done POC on data integration with Hadoop by ingesting powercenter workflows into Hadoop system and configured power exchange for HDFS systems in admin console.
• Providing on-going support for data questions to the outbound systems and data governance team.
• Sole person working with unstructured global customer data for the Global Business Unit.
• Being part of Data Governance team defined the rules for MDM standardization on KDE
• Working on Informatica Metadata manager to create data linage and business impacts on the Key Data Elements (KDE) used for various reports.
• Provided profiling, cleansing and validation reports in preparation for a data migration project
• Integrated various source system data into single datawarhouse.
• Extensively created and used Informatica IDQ - reusable components for data standardization of the party and account MDM project
• Managing team of 15 for project deliverables including offshore and nearshore.
• Automated the jobs using JIL scripts in Autosys.
• Extensively used HP-ALM and Jira tools for defect and activity tracking.
• Implemented UFA (Unix frame work Architecture) for DQ and MDM project automation.
• Created multiple jobs to load counterparty and accounts data to landing tables.

Environment: Informatica BDM 10.1, Informatica MDM Data Director 9.7.1, Informatica 9.7.1, Informatica Power Center 10.1, Informatica MDM 9.7.1, Informatica Power Exchange 10.1, Informatica IDQ 10.1, Powercenter Data Analyzer 10.1, Informatica MM 9.7.1, Tidal, HPQC, Autosys scheduler.

ETL and DATA Architect

Responsibilities:

• Worked with infrastructure team and installed Informatica suits in DEV/UAT/PROD environments.
• Created Informatica Best standards on the naming convention and architectural standards to load the data into MDM.
• Involved in various data profiling activities using Informatica Analyst and Informatica IDQ in the data analyses phase for Product and customer domains.
• Worked with Data modeler to create the data model to accommodate the incoming data.
• Extensively created and used Informatica IDQ - reusable components for data cleansing/consolidate/fuzzy logic for customer addresses for standardization.
• Efficiently handled coordinated onsite/offshore model
• Implemented power exchange connectivity from informatica to oracle EBS databases.
• Implemented incremental data loads to capture only the incremental on the full volume flat files
• Involved in various performance tuning activities on the Informatica and database side.
• Have written various shell script program to automate the batch process on daily and intra-daily mode.
• Created TRD/HLD/LLD documents pertaining to project requirements.
• Worked with Business and Data Governance team to identify the Reference data for the project automation.
• Extensively used all the transformations to achieve the business requirements in the mapping using informatica designer. working with different Vendors of offshore and onsite model to deliver the requirements in time.
• Managing the team size of 10-15 for the development efforts and deliverables.
• Created ETL mappings/sessions/workflows with various transformation utilizing Informatica web services, powercenter and powerexchange to extract/transfer data to external applications on demand and batch mode.
• Have done the POC on the data cleansing rules in informatica - IDQ.
• Worked with SQA team for the project deliverables to meet functional, Technical testing.
• Worked with reporting team get the correct sales reports for CEO decisions.

MDM

Responsibilities:

• Analyzed the source system for integrity issues to the data resided in various source systems and defined the same in Systems and Trust Rules in MDM Tool.
• Involved in implementing the Landing Process of loading the customer/product Data Set into Informatica MDM from various source systems using Informatica Powercenter and IDQ.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Configured Address Doctor which can cleanse whole world address Data and enhanced by making some modifications during installation
• Worked on data cleansing and standardization using the cleanse functions in Informatica MDM.
• Used Hierarchies tool for configuring entity base objects, entity types, relationship base objects, relationship types, profiles, put and display packages and used the entity types as subject areas in IDD.
• Defined the Trust and Validation rules and setting up the match/merge rule sets to get the right master records based on business needs.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Performed match/merge and ran match rules to check the effectiveness of MDM process on data.
• Created Unit Test Case document for MDM and ETL and various data Cleansing activities.
• Extensively used IDD to create new products and new customer information for incremental data and trouble scooted the issue related with IDD.
• Created and implemented the design the publish data from MDM to downstream system in batch mode.

Environment: WebLogic Server 10.3.6.0, Informatica MDM Data Director 9.7.1, Informatica 9.7.1, Informatica Power Center 9.5.1, Informatica MDM 9.7.1, Informatica Power Exchange 9.5.1, Informatica IDQ 9.5.1, Powercenter Data Analyzer 9.5.1, Oracle 10g /11g, Flat Files, UNIX Shell Scripting, Windows XP, Informatica Scheduler, Tidal, HPQC, Window Azure Cloud, Informatica DVO. Informatica ILM.