PROFESSIONAL SUMMARY:

• Over 10+ years of IT experience and wide range of experience in software development, Architecture, Design, Data Integration, Data Warehousing, Business Intelligence, Master Data Management and Quality assurance.
• Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
• Experience in Master Data Management concepts (MDM), IDD, IDQ and ability to apply this knowledge in building MDM solutions.
• Extensive ETL experience using Informatica Power center client tools (Designer, workflow manager, workflow monitor and server manager).
• Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.
• Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 5.x/6.x/7.x/8. x.
• Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
• Hands on experience on several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Slowly Changing Dimensions (SCD Type I and Type II).
• Strong experience in performance tuning, debugging and Error handling of mappings, sources and targets for better performance, also identified and fixed the bottlenecks.
• Extensive experience in creating and Reusable Mapp lets, Work lets used event wait, Event raise, Decision box, Email and Command tasks in Workflows.
• Extensively used the Autosys tool for various jobs scheduling.
• Strong knowledge in writing efficient & complex SQL Queries Oracle 11g/10g/9i and in PL/SQL for Stored Procedures, triggers, indexes, cursors.
• Experienced in UNIX work environment, file transfers (FTP, SFTP), job scheduling and error handling.
• Hands on experience on UNIX shell scripts for Informatica pre & post session operations.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Extensive functional and technical exposure. Experience working on high - visibility projects.
• Assign work and provide technical oversight to onshore and offshore developers.
• Worked in Data Warehouse and Business Intelligence Projects along with the team of Informatica, Talend (ETL).
• Good experience in design and configuration of landing tables, staging tables, base objects, hierarchies, foreign-key relationships, lookups, query groups, queries/custom queries and packages
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, Match rules, Merge properties and Batch Group creation.
• Experienced in all phases of SDLC using Waterfall, Agile methodology.
• Experienced in working with business analysts to understand requirements and translating them into ETL code in Requirement Analysis phase.
• Experienced in understanding of MDM domains - Customer, Product and Vendor Domains as well as Business Rules and workflows within an MDM application.
• Experienced in performing progressively more complex and responsible tasks involving Master Data Management (MDM), data bases in business intelligence environments
• Involved in creating High Level Design and Detailed Design documents in the Design
• Extensively worked on Informatica SAP BAPI/IDOCs transformations, Web services transformations and security/certificates/mutual authentication configuration using Informatica 8.6, Siebel reports (Answers & Dashboards).
• Experienced in using, Change Data Capture (CDC) to simplify ETL in data warehouse applications.

SKILLS & TOOLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x, Informatica MDM Multi Domain Edition

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Sybase Power Designer 16/15, Erwin 3.5.2/ 3.X & Toad 8.0/9.1

Databases: Oracle 11g/10g/9i/8i/8.0/7.x, IBM DB2 UDB 8.0/7.0, Netezza 5.0/6.0, XML, Teradata, SQL Server 2000/ 2005/ 2008 & MS Access

Reporting/OLAP Tools: Business Objects XI 3.1, OBIEE 10.1.X

Programming: SQL, PL/SQL, VB, C, C++ & Java, SQL*Plus & SQL*Loader, UNIX Shell Scripting

PROFESSIONAL EXPERIENCE:

Role: Sr. Informatica/MDM Developer

Roles and Responsibilities:

• Configured Informatica Data Director IDD in reference to the Data Governance of user’s IT Managers Data Stewards.
• Involved in requirement gathering from Business to understand the Data inputs.
• Configured Informatica Data Director IDD in reference to the Data Governance of user’s IT Managers Data Stewards.
• Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
• Primary activities include data analysis identifying and implementing data quality rules in IDQ and finally linking rules including Address Doctor to Power Center ETL processes and delivery to MDM Data Hub and other data consumers.
• Developed business rules for cleansing/validating/standardization of data.
• Developed User Exits for implementing custom business rules.
• Defined System Trust and Validation rules for the base object columns.
• Developed MDM Hub Match and Merge rules Batch jobs and Batch groups.
• Created Queries Query Groups and packages in MDM Hub Console.
• Design and Development of ETL routines, using Informatica Designer within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, Normalizer, Mapplets, connected and unconnected stored
• Extensively used Global Source/Targets, User Defined Function, Reusable Mapping and transformation.
• Experience in creating Dynamic deployment groups and ETL Query for promoting up to higher environments.
• Extensively used UNIX commands within Informatica for Pre Session and Post Session Data Loading
• Process.
• Mainly involved in ETL design & development.
• Involved in Preparation of low level designs (Mapping Documents) by understanding the system CPMS.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Responsible in developing the ETL logics and the data maps for loading the tables.
• Responsible for migrating from Development to staging and to Production (deployments).
• Reloading of applications run and need to make sure reloading process is completed.
• Restarting of applications run and need to make sure restart process is completed.
• Analyze functional requirements provided by Business Analysts for the code changes.

Environment: Informatica MDM 9.7.1, Hierarchy Manager, Informatica Data Director, Informatica Power Center 9.1, Neetezza, Tidal, Informatica data quality, Java, JBOSS, Oracle 11g, batch scripts, Address Doctor5, SQL Developer, ALM, Quality Center.

Ridgefield, CT 

Role: Sr. Informatica/MDM Developer

Roles and Responsibilities:

• Extracted data from various heterogeneous sources like Oracle, SQL Server, MS Access and Flat files.
• Experience on working with complete Software Development Life Cycle of the application.
• Provided production support for daily data processing of the clients Customer, Pharma related data.
• Involved in writing UNIX scripts for data parsing, manipulation and updating.
• Responsible for development, testing and support of the application.
• Involved in monitoring and maintenance of the Unix Server performance.
• Involved in creating database tables, views, triggers.
• Worked with PL / SQL to create new stored procedures and also modify the already existing procedures as per the change requirements from users.
• Created many PL/ SQL batches and executed them through Unix Shell scripts
• Handled production related issues and tickets for resolving them in time.
• Created bug fix plans and worked on change requirements.
• Worked with Client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Worked on Designer tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Solid Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with Joiner functions like normal join, full outer join, master outer join and detail outer join in the Joiner transformation.
• Worked with Session logs and Work flow logs for Error handling and troubleshooting in Dev environment.
• Used Debugger wizard to troubleshoot data and error conditions.
• Responsible for Best Practices like naming conventions, and Performance Tuning.
• Responsible for migrate the code using deployment groups across various Instances.
• Optimized SQL queries for better performance.
• Worked with Agile method.
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Responsible for Unit Testing of Mappings and Workflows.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy.

Environment: Informatica MDM 9.1, Informatica Power Center 9.5 (Repository Manager, Designer, Workflow Manager, Workflow Monitor), SQL Server2008, Oracle 10g, UNIX Shell Scripting, Flat Files, SQL Developer, Teradata.

Rio Rancho, NM

Role: Informatica developer

Roles and Responsibilities:

• Involved in Data transfer from OLTP systems forming the extracted sources.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Analyzed the sources, transformed the data, mapped the data and loaded the data into targets using Power Center Designer.
• Designed and developed Oracle PL/SQL Procedures.
• Worked on Informatica Utilities - Source Analyzer, Warehouse Designer, Mapping Designer, Mapp let Designer and Transformation Developer.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Designed and built ETL mappings and workflows to load data from different sources Oracle, SQL Server and fixed width as well as Delimited Flat files.
• Modified reports and Talend ETL jobs based on the feedback from QA testers and Users in development and staging environments.
• Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, Joiner transformations.
• Involved in creating Shell Scripts to automate Pre-Session and Post-Session Processes.
• Developed Sessions and Batches to schedule the loads at required frequency using Power Center Server Manager 5.1.
• Involved in data quality testing.

Environment: Informatica Power Center9.6, Informatica MDM, IDQ, Oracle, UNIX, Java, Web Services, Sybase Power Designer Global CRM, XML, Veeva CRM, Qlikview, Cognos, Windows XP, TOAD, MS Visio, Putty, Hortonworks.

Confidential

Portland, OR 

Role: Informatica Developer

Roles and Responsibilities:

• Informatica MDM Hub Console development
• Designed, Installed, Configured core Informatica Master Data Management (MDM) Hub components such as Informatica Master Data Management (MDM) Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter & Data Modeling.
• Experience in several facets of Master Data Management (MDM) Multi Domain Edition implementations including Source Data Analysis, Data Modeling, Staging process Configuration, Landing Process Configuration.
• Experience in Match and Merge Analysis, Trust Validations, Meta data Management
• Hands on Experience with Master Data Management (MDM) concepts and Informatica MDM tool -Informatica MDM Hub Console, Hierarchy Manager (HM) and Informatica Data Director (IDD).
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, DTS and SSIS services.
• Created Business Applications in IDD and helped the Data Steward to analyze the data.
• Lookup tables were configured in the IDD applications.
• Created Queries and performed the Manual match and Merge operations in IDD.
• SIF API was created to access Master Data Management (MDM) Hub from External Application.
• Handled Master Data and Transactional Data, and did the reporting of transactional data which is required by the Business Decision Support People.
• Coordinate MDM program activities for the Member and Provider data domains.
• Conduct source system analysis, and data profiling for lifecycle management.
• Define measurable metrics and the minimal required attributes for each domain or subject area to support a robust and successful deployment of a MDM platform.
• Define requirements for data matching and merging rules, survivorship criteria and data stewardship workflows that can be deployed in the endorsed MDM tool.

Environment: Informatica MDM 9.7.1/9.5.1 , Informatica Data Director 9.5.1, Informatica Power Center 9.5, Jboss, Oracle 11gR2, Microsoft SQL Server, Address Doctor, SQL Developer, DB Visualizer, Erwin.

Confidential

Rocky Hill, CT

Role: ETL Informatica developer

Roles and Responsibilities:

• Designed and developed several ETL scripts using Informatica, UNIX shell scripts
• Analyzed the source data coming from Oracle, Flat Files, and MS Excel coordinated with data warehouse team in developing Dimensional Model.
• Created and altered logical and physical database objects such as table spaces, tables, indexes, synonyms, sequences, constraints, and triggers to development needs.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Implemented various workflows using transformations such as JAVA transformation, XML transformation, Normalizer, look up, aggregator, stored procedure and scheduled jobs for different sessions.
• Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Workflow Manager.
• Created user defined Exceptions while Handling Exceptions
• Facilitating proof-of-concepts and work with Business Process Experts to show how Tableau can transform Company data into an asset.
• Converted various business requirements and Specifications into Tableau Presentations through coding, design, and supported relating to inventory and supporting visualizations.
• Complete visualizations for assigned activities and publish them to Tableau server.
• Assisting users with questions and issues using Tableau.
• Liaise between business users and Tableau support team. Analyzed performance tuning of Oracle 10g to improve its performance.
• Developed Shell Scripts to automate file manipulation and data loading procedures
• Proficient with Visual Source Safe for version control for Informatica objects, Oracle views and packages and test scripts.

Environment: Informatica Power Center 9.1, Oracle 10g/11g, SQL developer, Erwin, Flat files, Teradata, TOAD, PL/SQL, MS SQL Server, Crystal Reports, Autosys, Cognos, UNIX.