SUMMARY

• 9 years of experience in the domain of Master Data Management and Data Warehousing
• Design, Implementation, Testing and Maintenance experience in Siperian MDM.

TECHNICAL SKILLS

RDBMS: Oracle 10g/11g, Teradata V2R5

Programming Languages: PL/SQL, Java, Unix shell programming

MDM Tool: Siperian XU SP2, Informatica MDM 9.x

ETL Tool: Informatica 8.6, 9.0.1

Scheduling Tools: Control - M, Autosys

Application Dev Tools: Toad for Oracle, SQL Developer, SQLPlus, Putty

Database Utilities: SQL Loader, GP Load

Web Programming: HTML, JSP, XML

PROFESSIONAL EXPERIENCE

Confidential

MDM Specialist

Technology: Oracle Database 11g, Informatica MDM MDE 9.x, Informatica PowerCenter 9.5, Weblogic 11g, UC4 V8, RedHat Linux

Responsibilities:

• Maintenance and administration of Informatica MDM and IDD environment
• Designing and building source system interfaces to MDM like powercenter workflows and excel worksheets for business users.
• Automated Customer master jobs using UC4 platform.
• Informatica MDM upgrades and patches.
• Weblogic administration
• Interfacing between Business and Infrastructure for smooth implementation of platform upgrades like IE11 upgrade, OS security patches update etc.
• Troubleshooting data load jobs
• Creating various business reports for business and data stewards
• Working with compliance team on aggregate spend project to create sunshine and state compliance reports
• Creating incidents with Informatica support and getting issues resolved.
• UE code modifications to address changing business needs.

Confidential

Siperian Developer, Informatica Developer, UNIX developer, PL/SQL developer

Technology: Oracle Database 11g, Siperian 9.0.1, Informatica PowerCenter 9.0.1, JBoss

Responsibilities:

• Integration of source systems into CM.
• Design and development of generic source adapter to MDM
• Building Informatica components for generic source adapters.
• Created UNIX scripts for archiving source files, loading source data, FTPing files
• BDD testing
• Siperian installation and upgrade
• SL3 Support
• Troubleshooting Match rules
• CM and CRM synchronization
• Resolving MET issues in ORS
• Reconciliation of data between Veeva, SAPCRM and Siperian hub.

Confidential

Siperian Developer, Informatica Developer, Unix developer, Oracle developer

Technology: Oracle Database 10g, Siperian XU SP2, Informatica 8.1, Web Logic 9.2

Responsibilities:

• Tuning of Match rules
• Designing approach notes for new CR developments.
• Customizing Siperian functionality using User Exits
• SL3 Technical support.
• Involved in Siperian Real time (SIF) POC.
• Developing Informatica mappings.
• Created Unix batch scripts for loading feeds.
• Adoption of new source systems in Siperian.
• Raising technical cases with Siperian.
• Production Deployment support
• Training junior members of the team

Confidential

Siperian Admin and Developer, PL/SQL Developer

Technology: Oracle Database 10g, Siperian XU SP2, Informatica 8.6

Responsibilities:

• Creation of hub objects like landing tables, Staging tables and Base Objects, Queries and packages, mappings, Cleanse functions, Batch groups, message triggers etc.
• Configuration of Match, Merge & Trust settings.
• Creation of Hierarchies in Hierarchy Manager
• Installing Siperian Hub, Registering ORS, Creating Roles and Managing users.
• Import, Export and Validation of ORS using Metadata manager.
• Tuning of Match rules
• Developing oracle applications for extending functionality of Siperian.
• Configured Business Data Director in Siperian XU SP2.
• Resolving issues addressed by production support team.

Confidential

Siperian Developer, Oracle Developer, Data Modeller

Technology: Oracle database 10g, Siperian MDM Hub XU SP1, SunOS 5.10, SQL LoaderDB-Designer

Responsibilities:

• Design of a pure configurable, plug & play data extraction engine from Siperian hub - part of publish zone
• Developed data extraction components using PL/SQL & Unix scripts
• Created many Oracle objects like Packages, Procedures, Functions, triggers, types etc as part of data extraction engine and data adapter plug in.
• Creation of hub objects like landing tables, Staging tables and Base Objects, Queries and packages, mappings, Cleanse functions, Batch groups, message triggers etc.
• Configuration of Match, Merge & Trust settings.
• Creation of Hierarchies.
• Import & Export of ORS using Metadata manager.
• Data Steward functions of Hub using Data Manager and Merge Manager.

Confidential

Teradata Developer

Technology: NCR Teradata V2R5, Sunopsis, Datastage 7

Responsibilities:

• Created packages in Sunopsis for loading data.
• Created views in Teradata for applying business rules.
• Analyses of Datastage jobs and implemented the logic in Teradata BTEQ scripts

Confidential, Broomfield

Report Publisher, Oracle Developer, Informatica Developer

Technology: Informatica 8.1(PowerCenter), Microsoft SQL Server Reporting Services 2005 Hyperion Brio9.1, Oracle 9i & 10g

Responsibilities:

• Involved in developing reports in SQL Server Reporting Services.
• Created mapping in Informatica for loading data into reporting tables.
• Involved in migrating the legacy brio reports into SQL server reporting Services.
• Involved in monitoring production job runs and unit testing.

Confidential, Broomfield

Oracle Developer, Informatica Developer

Technology: Informatica 8.1, Oracle 9i, UNIX

Responsibilities:

• Created Mappings, Workflows, Sessions, Batches in Informatica.
• Unit testing of mappings.
• Production support for the project.

Confidential

MySQL developer, Java programmer

Technology: MySQL, JSP, Servlets, Java

Responsibilities:

• Created business logic in MySql macros.
• Created UI using JSP and HTML
• Building data model for the project.