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.