SUMMARY:

• With 9 years of extensive IT experience in all aspects of Software Analysis, Design, Development, Implementation, Testing of Data Warehousing Systems and Data marts.
• Experience in OLTP/OLAP systems, Data Modeling Experience with ER and Dimensional Data modeling using Star Schema and Snowflake Schema modeling, Logical and Physical data modeling using ERWIN 4.0/3.5.
• Experience Database development experience using SQL server Oracle PL/SQL, NCR Teradata SQL*Plus, Developer 2000, and MS Access
• Experience in writing scripts like SQL scripts, PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized Views and Triggers.
• Installing and Configuring of Informatica MDM Hub Console Hub Store Cleanse and Match Server Address Informatica Power Center applications
• Worked on power exchange to access the data from different sources and to avoid manual coding.
• Responsible for Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse.
• All facets of MDM implementations including Data Profiling metadata acquisition data migration validation reject processing and pre landing processing
• Strong Business Process Management & Application Implementation/Integration experience in Healthcare Payer
• Experience in working with XML and Flat file sources coming from various legacy source systems.
• Performing requirement gathering analysis design development testing implementation support and maintenance phases of both MDM and Data Integration Projects
• Master Data Management MDM Data Integration concepts in large scale implementation environments
• Trained and Executed Pentaho, a graphical ETL tool to load and process big data sources.
• Experience building OBIEE reports and dashboards as per user requirements using different views available in OBIEE environment.
• Experience in designing star schema (identification of facts, measures and dimensions), Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin data modeler, E - R Studio.
• Closely worked with other IT team member's business partner's data steward's stakeholders steering committee members and executive sponsors for all MDM and data governance related activities
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Extensively used ETL methodologies for supporting data extraction, transformation and loading process, in a corporate-wide-ETL Solution using Informatica Power Center
• Extensively worked on Informatica Client Tools - Source Analyzer, Target Designer, Transformations Developer, Mapplet and Mapping Designer, Task Developer, Workflow Monitor.
• Facilitated code reviews as a Lead developer, to ensure code quality.
• Extensive knowledge in life cycle of Data Warehouse projects involving data analysis, data extraction, conversion, cleansing and loading in Agile Scrum model.
• Supported Mango DB database.
• Worked in SFDC Articles, Knowledge Base.
• Lead/mentor/review the Offshore team, who is responsible for building ETL processes for staging and data warehousing
• Installed and configured Informatica MDM hub on JBoss application server.
• Expertise in Query Analyzing, performance tuning of Informatica mappings.
• Using DB connect for real-time data integration between Splunk Enterprise and databases.
• Skilled in designing, Installing & Configuring core Informatica MDM Hub components - InformaticaMDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter and InformaticaData Director (IDD)
• Extensive experience in Data Warehousing Reporting using Business Objects (XI version R1/R2) using Desktop Intelligence/Web Intelligence.
• Experience working with Designing, Customizing and Configuring Universes for generating customized scheduled reports.
• Experience working with Autosys, scripting JIL files to schedule jobs, Informatica Scheduler and Unix Scheduler.
• Experienced in developing Conceptual, logical models and physical models database design for Online Transactional Processing (OLTP) and Online Analytical Processing (OLAP) systems using ERWIN and Power Designer.
• Experienced in developing Conceptual, Logical and Physical models using ERWIN, Sybase Power designer and Embarcadero E-R Studio.
• Experience in writing UNIX shell scripts to support and automate the ETL process.
• Experience working with Versioning Tools like TFS, CVS and PVCS Version Manager.
• Experience in Complete Software Development Life Cycle (SDLC)
• Expert in Troubleshooting/ Problem Solving.
• Exceptional written and verbal Communication Skills with ability to work and interact with teams and individuals at all levels

TECHNICAL SKILLS:

Operating Systems: Windows Windows 2003, 07, 10servers, Unix. MSDOS

RDBMS: Oracle 11g, MS-SQL Server

Data Modeling: Erwin r7.1/7.2, 9.5, ER studio v8 0.1 and oracle designer.

Data Base Tools: SQL Loader, MS Visio, MS Access

Reporting Tools: Business Objects XI/6.x/5.x, OBIEE 10.x/9.x; Power play and Transformer.

Scripting: UNIX Shell Scripting

Web Technology: HTML, Java script

Languages: SQL, PL/SQL, C, C ++, Java 1.2, XML.

BI Tools: Cognos, micro strategy

Query Tools: Toad, Teradata SQL assistant

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential, New York, NY

Responsibilities:

• Strong HIPAA EDI 4010 and 5010 with ICD - 9 and ICD 10, analysis & compliance experience from, Healthcare payers, providers and exchanges perspective, with primary focus on Coordination of benefits
• Involved in implementing the Land Process of loading the customer Data Set into Informatica MDM from various source systems
• Enrollment and Maintenance EDI data from employer groups to various health insurance payer
• Working closely with the client on planning and brainstorming to migrate the current RDBMS to Hadoop.
• Migration of informatica jobs to Hadoop sqoop jobs and load into oracle database.
• Used Informatica Power Exchange for loading/retrieving data from mainframe system.
• Change Data Capture has done using the Power Exchange.
• Worked on data cleansing using the cleanse functions in Informatica MDM
• Wrote numerous BTEQ scripts to run complex queries on the Teradata database.
• Support the Informatica Grid environments
• Performed relational data modeling (Logical & Physical) and dimension data modeling. Explored No SQL Databases such as Mango DB & TALEND.
• Involved in implementing the Land Process of loading the customer/product Data Set into InformaticaMDM from various source systems.
• Creating and Binding fields with the Splunk MetaData with the help of Regular Expression
• Involved in scheduling the workflows through Autosys Job scheduler using UNIX scripts
• Supported PWX for DB2, cdc and data files.
• Worked in SFDC Articles, Knowledge Base.
• Created and Configured Workflows, Worklets, and Sessions to transport the data to target warehouse Netezza tables using Informatica Workflow Manager
• Part of multiple implementation plans involving DW implementations, BI team implementations.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool Autosys using JIL's.
• Hands on creating end to end ETL strategies that will include data profiling as well
• Used recently introduced Power BI to create self-service BI capabilities and use tabular models.
• Participated in an Agile BI/DW team setting, as a Core team member, participated in the daily scrum meetings for reporting updates on onsite work as well as the offshore development team.
• Develop a plan for migrating the existing Oracle Data Warehouse to Netezza.
• Supported Mango DB database.
• Worked on complex transformations such as JAVA transformation, Normalizer, Transaction Control transformations
• Experience in working with big data Hadoop stack tools like HDFS, HIVE, Pig, Sqoop
• Performance Analysis and resolution in Netezza, Managed Netezza Migration, Deployments and maintenance.
• Created numerous reports and dashboards using OBIEE platform.
• Developed different kinds of Reports (pivots, charts, tabular) using global and local Filters using OBIEE Platform.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Worked on managing and reviewing Hadoop log files. Tested and reported defects in an Agile Methodology perspective.
• Extensively used Agintiy work bench to perform DML, DDL etc operations on Netezza Database.
• Worked with multiple source systems DB2, SQL Server, Oracle databases.
• Extensively worked with SQL for unit testing as well as during developmental phases.
• Extensively worked with nested workflows involving both reusable and non-reusable worklets.
• Extensively worked with Informatica Versioning and Informatica Scheduler.
• Developed, transformed and tested business required data enhancements using ETL processes.

Environment: Informatica Power Center 9.5.1/8.1, Informatica MDM 9.7.1 IBM Infosphere Quality stage SQL server 2008, Oracle, DB2, Toad, Unix, Informatica Versioning Tool, Erwin 9.5, data stage Autosys, Hadoop, spark, Informatica Scheduler Teradata 13 and 14, Teradata SQL Assistant, Java, Teradata Manager.

Informatica MDM Developer

Confidential, Teaneck, NJ

Responsibilities:

• Installed Informatica MDM 9. 5 In UNIX Red Hat with the middleware JBOSS 5 1 GA
• Configured cleanse server and address doctor
• Implement Informatica MDM workflow including data profiling configuration specification and coding match rules tuning migration
• Involved in Business meetings to understand the business requirement specifications and implemented the ETL jobs using Data stage.
• Implemented Apache Spark data processing project to handle data from RDBMS and streaming sources.
• Used Informatica PowerCenter 9.5.1 to Extract, Transform and Load data into Netezza Data Warehouse from various sources like Oracle and flat files
• Build out best practices regarding data staging data cleansing and data transformation routines within the Informatica MDM solution
• Define and build best practices regarding creating business rules within the Informatica MDM solution
• Experienced in data migration using Import wizard, Apex data loader, SFDC Data export.
• Implemented Iterative and Incremental Agile - Scrum Methodology for rapidly changing or highly emergent requirements and following parallel development and testing.
• Involved in data modeling and data profiling.
• Participated in the review and approval of the technical transformation requirements document used to design and build the ETL modules in Data stage Designer
• Worked with No SQL databases like Mango DB to save and retrieve the data.
• Using DB connect for real-time data integration between Splunk Enterprise and databases.
• Developed Spark SQL to load tables into HDFS to run select queries on top.
• Migrated the Informatica xml's between various environments and executed them successfully
• Worked on SFDC implementation related to Cloud.
• Worked with Union, Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Joiner, Source Qualifier, Sequence Generator, Java, Stored Procedure Transformations.
• Created Base Tables Stages tables based on the data model and number of source systems
• Developed the mappings using various cleanse functions in the Hub and the address doctor to standardize the data
• Created proactive agents iBots and interactive Dashboards to alert the Marketing team about business changes using OBIEE Platform.
• Migrate and validate existing Campaign, Offers, Strategic segments, Templates.
• Integrate with eMessage
• Worked on Performance Tuning of Netezza queries with proper understanding of joins and Distribution
• Utilized the parameter set feature in Data stage 8.7 to create common project level parameters.
• Performed Data modeling using Erwin, maintaining the database schema
• Experience with Geneos support tool in Golden Gate data Replication and Informatica Power Exchange to fetch data from legacy systems.
• Upgrade new Version of Hub and Cleanse Server on JBoss
• Design and implement multi-channel marketing campaigns for execution through IBM EMM Suite (formerly Unica Affinium)
• Collaborated with users in defining Match Rules and conducted workshops to discuss over and under matching
• Worked in MDM Hub Console for creation of golden records.
• Work on any on the services failures using the admin console and using the infa commands.
• Sourced transaction data being staged by Golden Gate tool CDC (Change Data Capture) through Informatica Powercenter and loaded into the target based on the DML action indicated by Golden Gate.
• Performed analysis design development and maintenance activities associated with the database and data in support of multiple applications including following standards/procedures to achieve integration of systems through database design
• Finally Created Data Validation Document Unit Test Case Document Technical Design Document Informatica Migration Request Document and Knowledge Transfer Document

Environment: Informatica MDM 9.5.1 Informatica 9.5 IDQ, IBM Infosphere Quality stage Oracle 11g MS Excel Unix, SFDC, ERWIN, java, Data Stage, spark, Autosys, splunk.

ETL Consultant

Confidential, Richmond, VA

Responsibilities:

• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Extensively worked on tuning mappings and reducing processing times.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/Workflows.
• Met with end users to gather requirements.
• Translated business requirements into Informatica mappings/workflows.
• Created various transformations such as Normalizer, Union, Aggregator, Update Strategy, Look Up, Joiner, Filter and Router Transformations.
• Involved in Performance tuning. Identified and eliminated bottlenecks (source, target, and mapping)
• Creating connection to databases like SQL Server, Oracle, Netezza and application connections.
• Creating Netezza DB Objects using Best practices of Netezza in order to avoid data skews on the Netezza Objects.
• Read XML files as source and parsed it using Talend and applied business logics to it and loaded into the target tables
• Proficient experience in working on conceptual, physical and logical data models (3NF) using various Data Modeling tools like Erwin, MS Visio, Power Designer.
• Created shell scripts to kick off Informatica workflows and PL/SQL procedures.
• Used DAC (Data warehouse Administration Console) for both incremental and full loads.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Created UNIX scripts for automation of ETL process.
• Provided technical guidance for re - engineering functions of Oracle warehouse operations into Netezza.
• Coordinated the OBIEE and Web Catalog objects migration from Development environment to QA environment and then to the Production environment.
• Created Scheduler jobs for Netezza SQL scripts using Dollar Universe Scheduling tool.
• Designed and created an Autosys job plan to schedule our processes
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Performance tuning of Netezza SQL scripts
• Trained on building Conceptual, Logical and Physical data model
• Taking the backup of the repository at regular interval depending on the amount of work done.
• Worked with DBA to identify source and target bottle necks.
• Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica Power Center8.6.1/9.1, SQL Server 2005, Control M, Oracle 10g, PL/SQL, Business Objects XIR2, DAC, Toad, Linux, Autosys, UNIX Shell Scripts.

Informatica ETL Consultant

Confidential, Attleboro, MA

Responsibilities:

• Interact with Business Analyst to assist him in Understanding the Source and Target System.
• Responsible to pull the data from XML files, Flat files (Fixed width & Delimited) and COBOL files by using complex transformations like Normalizer, XML Source Qualifier etc.
• Extracted and transformed data from various sources like relational databases (Oracle, SQL Server)
• Created Mappings using Mapping Designer to load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision mail, command, worklets, assignment, timer and scheduling of the workflow.
• Worked on Power Center Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Used Debugger within the Mapping Designer to test the data flow between source and target and to troubleshoot the invalid mappings.
• Efficiently implemented Change Data Capture (CDC) to extract information from numerous Oracle tables and experienced Pushdown Optimization in Informatica Power Center.
• Designed and developed UNIX Shell scripts to report job failure alerts.
• Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load.
• Used Version Control to check in and checkout versions of objects.
• Worked on SQL tools like TOAD and SQL Developer to run SQL Queries and validate the data.
• Scheduled Informatica Jobs through Autosys scheduling tool.
• Involved in Unit testing, System testing and UAT to check data consistency.
• Assisted QA team to fix and find solutions for the production issues
• Prepared all documents necessary for knowledge transfer such as ETL strategy, ETL development standards, ETL processes, etc.

Environment: Informatica Power Center 9.1, Oracle 10g, Erwin, PL/SQL, Autosys, MS-SQL Server 2008, Toad, MS-Visio, Windows XP

Informatica Developer

Confidential

Responsibilities:

• Business Analysis and Systems Design.
• Developed Logical and Physical database design.
• Extensively used XML transformations in Informatica for processing data.
• Created transformations in Informatica such as XML parser and XML generator transformations for processing xml related data.
• Maintained Shared objects at the Informatica level to avoid redundancy.
• Extensively used packages, stored procedures and database triggers.
• Analysis is done based on business rules in existing systems and user requirements.

Environment: Informatica 7.1, Oracle 7.x, Windows 3.1/95, Forms, SQL, PL/SQL.

Informatica Developer

Confidential

Responsibilities:

• Worked on Informatica client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Involved in developing multidimensional data modeling using star schema and snow flake schema.
• Used Informatica to extract and load data from Oracle database and flat files to Oracle tables.
• Created various mappings using Designer which include Expression, Router, Aggregator, Stored Procedure, Update strategy and Look - up Transformations.
• Created Mapplets using Mapplet Designer to reuse in different mappings.
• Handled Performance Tuning by checking bottlenecks also created partitions, SQL override in Source qualifier.
• Designed and developed Reporting System using Business Objects.
• Performed Unit Testing and documented the complete Mappings

Environment: Informatica Power Center 7.1.3, Oracle 10g, UNIX, Windows XP, Business Objects.