We provide IT Staff Augmentation Services!

Lead Mdm Developer Resume

NJ

SUMMARY

  • Fifteen plus years of experience in Software Development and Database Design in the areas of Commercial and Business Applications as a Senior MDM Developer, Senior ETL Designer/ Developer.
  • Ten plus years of strong MDM (Master Data Management), Data Warehousing, Migration and Conversion project experience including Informatica Power Center and Power Exchange.
  • Good experience in Data Modelling with expertise in Enhancing the IBM MDM Model.
  • Good Knowledge in Finance Sector including Equities, Fixed income, Prime Brokerage such as options futures, bonds and swaps.
  • Good Knowledge in Insurance Sector with different Line of Business such as Life, Annuities, Dental, Vision, Brokerage, Auto and Home.
  • Good Exposure in Informatica Administration, Informatica Power Center, Informatica IDQ (Data Quality), Informatica MDM (Master Data Management), Power Exchange to Main Frame.
  • Expertise in Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
  • Good experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modelling using Erwin.
  • Worked in the Requirement Analysis, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Testing of Applications in Data warehouse, OLAP and Business Objects with Finance, Insurance, and Pharmaceutical at various Data Warehousing Business Application Systems of Financial ( Confidential -MERRILL LYNCH NJ, Confidential CT), Insurance ( Confidential NJ, Hartford Life CT, Confidential NJ) and Pharmaceutical ( Confidential NJ).
  • Design, Develop and Test the Workflows, Sessions, Mappings and Mapplets.
  • Writing the PL/SQL Stored Procedures, Functions.
  • SQL Tuning and Application Tuning.
  • Experience in writing the Shell Scripting and Job Scheduling (Autosys).
  • Expertise in Preparing ETL Standards, Process and HLD (High Level Design) Documentation.
  • Coordinating and monitoring the project progress to assure the flow and completion of work on schedule.
  • Conversant with all phases of Software development cycles involving Systems Analysis, Design, Development, testing and Implementation and user co-ordination.
  • Documentation, Training end-users, Enhancements and Support of the Application in a live production environment.

TECHNICAL SKILLS

Operating System: Sun Solaris, Sco-Unix, Windows 2000, Windows NT 4.0,Windows 98/95

Language: PL/SQL, C#, VB.NET, Java, JavaScript

Tools: Informatica Power Center/Power Exchange, Informatica IDQ, Informatica MDM/IBM MDM, Toad, DB artisan, Toad for Data Analyst, Sql Navigator, Business Objects, Erwin, Developer 2000,Web Force

RDBMS: Oracle, Sql Server, DB2

FRAME WORK: .Net

Scheduling Tools: Autosys, Maestro

PROFESSIONAL EXPERIENCE

Confidential, NJ

Lead MDM Developer

Responsibilities:

  • Involved in the Data Acquisition from various Source Systems.
  • Involved in the GAP Analysis and Data analysis to find out the set of new attributes, which need to be added to the MDM Model as per the START4 New Application.
  • Performed Data Analaysi using IDE - Informatica Data Explorer to profile Customer/Party Related Data.
  • Involved in Defining the Data Model.
  • Involved in the Design and Configuration the rules for cleansing, landing, matching and merging.
  • Configuring the trust rules and creating the validation rules.
  • Creating the queries and packages for viewing the data.
  • Worked with business analysts/Data Modeler to design, develop, and configure business rules for standardize, match and merge.
  • Designed the Books and Records attributes Data File Format.
  • Worked closely with Architect and Data Modeler to enhance the existing IBM MDM Model with the new attributes as per the Business needs.
  • Extensively worked on Party Data.
  • Performed the Data mapping between Source Systems as Source and IBM MDM Model as target to load the data from various source systems into MDM DB2 tables.
  • Designed/Created the Informatica Workflows, Worklets, Sessions, Mappings and mapplets.
  • Provided an Acord Mapping sheet for Rationalizing the Type code Values.
  • Generated Various Reports for UAT/End user testing using SQL.
  • Provided the Extensive Support for QA/UAT and End User for their testing.

Confidential, NJ

Lead MDM Developer

Responsibilities:

  • Involved in the Data Acquisition from various Source Systems.
  • Involved in the GAP analysis to find out the new attributes, which need to be added to the MDM Model as per the Business needs.
  • Performed the Data mapping between Source Systems as Source and IBM MDM Model as target to load the data from various source systems into MDM DB2 tables.
  • Performed Data Analysis using IDE - Informatica Data Explorer to profile Customer/Party Related Data.
  • Involved in Defining the Data Model.
  • Involved in the Design and Configuration the rules for cleansing, landing, matching and merging.
  • Configuring the trust rules and creating the validation rules.
  • Creating the queries and packages for viewing the data.
  • Worked with business analysts/Data Modeler to design, develop, and configure business rules for standardize, match and merge.
  • Extensively worked on Party Data.
  • Performed the Data Analysis, Data Cleansing, Data Quality Checks, Data Validations and Data Discrepancy.
  • Designed/Created the Informatica Workflows, Worklets, Sessions, Mappings and mapplets.
  • Generated Various Reports for UAT/End user testing using SQL.
  • Utilized of Informatica IDQ for data profiling and matching/removing duplicate data.
  • Performed Data Profiling and Data Quality.

Environment: DB2, Informatica Power Center 9.1, IBM-MDM, Informatica MDM, Informatica IDQ, Trillium and Autosys.

Confidential, NJ

Lead ETL Developer

Responsibilities:

  • Performed the Data Analysis, Data Cleansing, Data Quality Checks, Data Validations and Data Discrepancy.
  • Worked with Informatica power center to develop the mappings/workflow for BU Enrichment.
  • Involved in the Data Acquisition from various Source Systems for Equity and Fixed Income.
  • Implemented the Design process of Dimension and Fact Process flow for Incremental Load.
  • Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
  • Creation and maintenance of Informatica users and privileges.
  • Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments.
  • Created Integration Services, Groups, roles, and privileges and assigned them to each user group.
  • Designed/Created the Informatica Workflows, Worklets, Sessions, Mappings and Mapplets.
  • Created/Modified the Shell Scripts to automate the extraction and loading process of Dimensions on daily basis.
  • Designed/Created the autosys (JIL) scripts to schedule the streams.
  • Involved in the Production Support and Post Production issues.

Environment: DB2, Informatica Power Center 8.6, Sql Server, Sybase, Data Analyst and Autosys.

Confidential, NJ

Lead ETL Developer

Responsibilities:

  • Involved in Data Analysis, Data Validations, Data Cleansing and Data Discrepancy.
  • Initiated and built technical design documents from the Business Requirement Document
  • Created the Informatica Workflows, Worklets, Sessions, Mappings and mapplets.
  • Coordinating with the business users.
  • Identified and executed the Performance Tuning of the bottlenecks on ETL mappings, sources, targets and database.
  • Involved in meeting with Actimize users regarding the generated alerts based on the case scenarios.
  • Ensured the Business Rules and Data Validation.
  • Tuned SQL queries to increase the performance-related issues of the existing data.
  • Created the Indexes, Views and Materlized Views.
  • Involved in the Production Support.

Environment: Oracle 10g, Informatica PowerCenter 8.1, Toad 7.6, AIX, Windows, Actimize.

Confidential, NJ

Lead ETL Developer

Responsibilities:

  • Involved in Requirement Collection & High Level Design for the ETL Processes.
  • Created PL/SQL Stored Procedures, Function to accomplish the complexity of the Project.
  • Tuned SQL queries to increase the performance-related issues of the existing data.
  • Created the Indexes, Views and Materlized Views.
  • Created the Informatica Workflows, Worklets, Mappings and Sessions
  • Created the Shell Scripts to automate the extraction and loading process.
  • Involved in the Production Support.
  • Written the test cases and documentation.

Environment: Oracle 10g, Informatica Power Center 8.1, Siperian, Toad 7.6, SunOS5.8, Windows.

Confidential, NJ

Lead ETL Developer

Responsibilities:

  • Involved in Requirement Gathering, Data Analysis.
  • Ensured the Business Rules and Data Validation.
  • Performed cleansing, standardizing the rules and consolidating the customer, Product and Account data which is sourced from different source systems.
  • Performed match and merge rules (both exact and fuzzy match) rules for identifying the same customer represented as different customers in various systems.
  • Involved in Requirement Collection & High Level Design for the ETL Processes.
  • DDD & Xponent Framework (Complete Automation of Xponent & DDD Loads).
  • Created PL/SQL Stored Procedures, Function to accomplish the business rules
  • Created the Informatica Workflows, Worklets, Mappings and Sessions.
  • Implemented the Design process of Dimension and Fact Process flow for Incremental Load.
  • Involved in SQL Tuning and Application Tuning.
  • Created the Indexes, Views and Materlized Views.
  • Created the Shell Scripts to automate the extraction and loading process.
  • Involved in the Production Support.
  • Written the test cases and documentation.

Environment: Oracle 10g, Informatica Power Center 8.1, Siperian, Toad 7.6, Web Force, SunOS5.8, Windows.

Confidential, NY

ETL DESIGNER/ ETL ANALYST

Responsibilities:

  • Coordinating and monitoring the progress of project to assure the flow and completion of work on schedule.
  • Involved in System Study, Data Analysis, Data Cleansing, Data Scrubbing.
  • Data Reconciliation, Data Discrepancy and Generated the Data Audit Reports.
  • Ensured the Business Rules and Data Validation.
  • Created the Informatica Workflows, Worklets, Mappings and Sessions
  • Created PL/SQL Stored Procedures, Function to accomplish the business rules
  • Implemented the Design process of Dimension and Fact Process flow for Incremental Load.
  • Tuned SQL queries to increase the performance-related issues of the existing data.
  • Created Indexes, Views and Secured Views.
  • Written the autosys scripts to schedule the Informatica jobs on daily, weekly and monthly basis.
  • Involved in the Production Support.

Environment: Oracle 10g, Informatica PowerCenter 8.1, Toad 7.6, Autosys, Mercury Quality Center 9.0, SunOS5.8, Windows.

Confidential, Hartford

Senior ETL Analyst/Developer

Responsibilities:

  • Responsible to convert the data (Direct and Ceded data) necessary to support ceded reinsurance processing, Accounts Receivable/Payable.
  • Responsible for staging the data from Legacy Systems: REINS, NPPS, MIS, and PACER.
  • Developed data maps to extract data from mainframe systems using Informatica mainframe connectivity tool Power Exchange.
  • Extensively used Informatica PowerCenter 6.2 to extract data from flat files & Oracle to Oracle.
  • Created the PL/SQL Packages, Stored Procedures, Function to accomplish the business rules
  • Involved in Data Analysis, Data Cleansing and Testing.
  • Involved in Data Analysis on Production Premium, Cash and Receipts.
  • Tuned SQL queries to increase the performance-related issues of the existing data.
  • Written the shell scripts to automate the extraction and loading process.
  • Identified and executed the Performance Tuning of the bottlenecks on ETL mappings, sources, targets and database.
  • Written the autosys scripts to schedule the Informatica jobs

Environment: Oracle 9.i, Informatica PowerCenter 6.2, DETAIL Navigator v4.2.0 (PowerConnect to Main Frame), Quest TOAD 7.3, ProCede 8.4.1, Autosys, SunOS 5.8, Windows.

Confidential, Stamford CT

ETL Lead/ ETL DESIGNER

Responsibilities:

  • Coordinating and monitoring the progress of project to assure the flow and completion of work on schedule
  • Handled Team of 6Team Members.
  • Created PL/SQL Stored Procedures, Function to accomplish the business rules
  • Involved in Data Analysis, Data Cleansing and Testing.
  • Involved in SQL Tuning and Application Tuning.
  • Created the Informatica Workflows, Worklets, Mappings and Sessions.
  • Ensured the Business Rules and Data Validation.
  • Written the test cases and documentation (High Level and Low Level Design).

Environment: Oracle 9.i, Informatica PowerCenter 6.1, SQL, PL/SQL, Erwin 4.5 and Windows.

Confidential, NJ

Developer

Responsibilities:

  • Primary responsibilities include analysis, design, development, testing and implementation of various modules using developer 2000 and to provide technical support for the QA team.
  • Written various program units for different functionalities, also written several scripts, stored procedures and functions using Forms.
  • Generated various reports using Report Writer.
  • Proficient in meeting, tight deadlines, Performance tuning and client interaction.
  • Developed various modules/forms in loans using developer 2000
  • Tuned SQL queries to increase the performance-related issues of the existing data.
  • Created several batch processing scripts.
  • Written various Form Level Triggers, Validations.

Environment: Windows NT, Oracle 7.x, SQL, PL/SQL, Developer 2000, and Forms 5.0.

Confidential

Developer

Responsibilities:

  • Primary responsibilities include analysis, design, development, testing and implementation of various modules using developer 2000 and to provide technical support for the QA team.
  • Written various program units for different functionalities, stored procedures and functions using Forms.
  • Generated various reports using Report Writer.
  • Proficient in meeting, tight deadlines, Performance tuning and client interaction.
  • Developed various modules/forms in loans using developer 2000
  • Involved in Application Tuning and Performance Tuning.
  • Written several batch processing scripts.
  • Written various Form Level Triggers, Validations.

Environment: Windows NT, Developer 2000, Oracle 7.x, SQL, PL/SQL.

Hire Now