We provide IT Staff Augmentation Services!

Mdm Lead Resume

Albany, NY

SUMMARY:

  • 14+ years of experience comprising of Informatica PIM(Product 360), Informatica MDM, ActiveVOS, Informatica Powercenter, Informatica Developer, Address Doctor, Oracle, Teradata, DB2, Unix, FOCUS, WebFOCUS and Mainframe etc.
  • Having 8+ 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.
  • Having extensive experience managing offshore and onsite teams and coordinated both the teams.
  • Installed MDM in the windows development environment.
  • Worked on ETL process for bringing in the data into MDM landing tables
  • Worked on profiling the data using Developer tool/Analyst Tool for identifying the data integrity from different sources.
  • Based on the data quality analysis and discussion with stake holders the source data trusted scores are defined.
  • Validation rules are developed based on the profiled data quality and data analysis.
  • Came to conclusion on key fields after discussing with people in the knowledge of data.
  • Defining and configuring landing tables, staging tables, base objects, foreign - key relationships, lookups, query groups, queries/custom queries and packages.
  • Created cleanse functions for cleansing and standardization
  • 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 filters for meeting the different data scenarios.
  • Performed match/merge and ran match rules to check the effectiveness of MDM on data and fine tuned the match rules.
  • Developed adhoc queries like ExecuteBatchDelete SOAP requests for deleting the specific data from the concerned underlying tables using.
  • Developed Unmerge user exit for reprocessing the some of the records which are supposed to be processed differently.
  • Created Hub User Exits for achieving the custom functions
  • Closely worked with Data Steward Team for designing, documenting and configuring Informatica Data Director.
  • Configured static lookups, dynamic lookups, bulk uploads.
  • Configured JMS Message Queues and appropriate triggers for passing the data to the contributing systems.
  • Created custom workflows in ActiveVOS and deployed the same from designer to the server
  • Created BPELs, PDD files, BPR and BPRD files
  • Used XML Schema, WSDL for creating the partner service provider and process service consumer
  • Created forms and created/modified/updated avcconfig files
  • XML, XPath, Xquery are used in creating BPEL.
  • Used correlation sets for process orchestration in asynchronous calls.
  • Created the SOAP and REST web services for using in partner service provider and process service consumer
  • Configured Identity services and email services
  • Configured Human tasks and email approval process
  • Created error handlers, event handlers
  • Used Different web services in the BPELs like SOAP, REST.
  • Managed the ActiveVOS servers
  • Have knowledge of integrating ActiveVOS with Informatica PIM(Informatica Product 360)
  • Installed Clusterix, Product Manager, Supplier Portal, Audit Trail, Different Modules of Media Manager
  • Created Import Mapping and hot folder configuration
  • Created Catalogs and Merges
  • Involved in writing multiple exports and creating DQ rules.
  • Created HTML Preview template
  • Created Export Profiles
  • Customized Repository using the Repository Manager
  • Worked on different Modules of Media Manager - Image Magic, Pipeline, Funcd’s, Workflow Manger, Process watcher, Medias and Administrator.
  • Created different Media Manager workflows like MQ workflows, DQ workflows and Derivative Workflows.
  • Customization done for Imports and Exports and custom jobs.
  • Created Mapplets using Address Validators with different scopes for achieving the best output.
  • Used different kinds of inputs like free format, hybrid addresses and produced standardized Addresses.
  • Generated different levels of geocodes for the same address for meeting different access levels.
  • Expertise in Address Doctor Integration with Power Center, Developer, MDM
  • Address Doctor Upgrade in Power Center and Developer.
  • Extensive Experience in creating data profiles and rules.
  • 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.
  • Strong Experience in developing Sessions/tasks, Workflows using Workflow Manager Tools - Task Developer, Workflow Designer.
  • 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.
  • Extensive experience in creating BTEQs for report generation from Teradata tables
  • 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.
  • Learnt VMFOCUS and EXEC and EXEC2 and involved in code changes
  • Made table changes for blocking the 900/976 number so that number allocation will start.
  • Involved in VMFOCUS schedule changes via EXEC.
  • Worked on making FOCUS code changes to fit reports changes required.
  • Created Focus databases for implementing the new functionality
  • Performed FOCUS database fine tuning
  • Involved in testing the code for version upgrades.
  • 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.
  • Gave 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
  • Solved any production issues.
  • Assisted Release Manager in Release management activities
  • Updated/Created COBOL programs
  • Create JCLs for executed the multiple programs and scheduled the same
  • Created flat files, GDGs and VSAM files
  • Created Unit test cases and executed unit test cases
  • Good Confidential Power shell scripts creation for automation purpose
  • Wrote Oracle SQL queries and store procedures
  • Have knowledge of writing UNIX scripts, Powershell

TECHNICAL SKILLS:

PIM(Product 360): Product Manager 8.0.3, ActiveMQ, Supplier Portal, Audit Trail

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

BPM Tools: ActiveVOS 9.4.2.1

ETL Tools: Address Doctor 5.x, Power Center 10.x/9.x (Designer, Workflow Manager, workflow Monitor, Rep. Server, Repository Manager, Mappings/Mapplets/ Power Center transformations), Analyst Services, DIS(Data Integration Service), CMS(Content Management Service), Informatica Developer 10.x

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

Media Manager: Administrator, Workflow Manager, Pipeline, Medias, Funcds, File watcher, Image Magic, ActiveMQ

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

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

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

Scheduling: CRON, ESP, TWS, Informatica Scheduler

Web Services: SOAP, REST

PROFESSIONAL EXPERIENCE:

Confidential, Albany, NY

MDM Lead

Environment: PIM(Product 360) 8.0.3.1 , Supplier Portal, Media Manager 5.8, ActiveMQ, Audit Trail, Multi-Domain MDM 10.0, IDD, Oracle 11g, Oracle PL/SQL, Windows Application Server, ActiveVOS 9.4.2.1, Informatica Power Center 10.1, Informatica Developer, Address Doctor 5.1, Power shell

Confidential, Richardson, TX

MDM Lead

Environment: Multi Domain MDM 9.7, IDD, Oracle 11g, Oracle PL/SQL, Windows Application Server, ActiveVOS.

Confidential, Saint Louis, MO

Onsite Coordinator

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.

Confidential, Saint Louis, MO

Onsite Coordinator

Environment: FOCUS, BTEQ, COBOL, TERADATA, SQL Assistant, Queryman, REXX, ORACLE, SQLPLUS, JCL, COBOL, MVS FOCUS DB.

Confidential, Saint Louis, MO

Onsite Coordinator

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.

Confidential, Jersey City, NJ

Programmer Analyst

Environment: WEBFOCUS, Developer Studio, EDA Server, Windows NT Server, EDA Query Tool, HTTP Listener, COBOL, JCL, FOCUS, DB2, ENDEVOR, XPEDITOR, ES-9000, ESPMENU

Responsibilities:

  • 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.
  • Strong Experience in developing Sessions/tasks, Workflows using Workflow Manager Tools - Task Developer, Workflow Designer.
  • 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.
  • Extensive experience in creating BTEQs for report generation from Teradata tables
  • 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.
  • Learnt VMFOCUS and EXEC and EXEC2 and involved in code changes
  • Made table changes for blocking the 900/976 number so that number allocation will start.
  • Involved in VMFOCUS schedule changes via EXEC.
  • Worked on making FOCUS code changes to fit reports changes required.
  • Created Focus databases for implementing the new functionality
  • Performed FOCUS database fine tuning
  • Involved in testing the code for version upgrades.

Hire Now