SUMMARY:

• Project Lead & MDM Architect with close to 10 years experience in Enterprise Information Management Consulting providing comprehensive Architectural solutions in Master Data Management with strong skillset with the following Product Suites such as Informatica MDM (Siperian) Product, PIM (Product 360), Supplier 360, IBM Cognos Business Intelligence & Predictive Analytic Tools
• Strong Understanding of Data Governance practices ensuring collaborative process improvement among Stewards, Business Process Units and Data Quality Teams to help achieve Organization Unit Goals
• Experience in handling data from SAP ERP, Sales Force Applications, Dun & Bradstreet, Oracle CRM and other Legacy Source Systems using traditional ELT, ETL products and EAI methodologies
• Partnered with business teams to gather and translate business functional requirements into technical solutions
• Driven on - going refinement and improvement of operating practices & procedures to ensure quality of service
• Experienced in operating and maintaining large scale enterprise data solutions
• Completed PIM 7.1 (Product 360): New User Extended (onDemand eLearning) at Informatica University
• Participated in design & code reviews on all MDM SIF API services including SOA RESTful services, JMS queues, interfaces and components
• Experienced in Change Management, Release Management, and Scaled Agile Framework
• Extensive experience in Identification of User requirements, System Design, writing Program specifications, Coding, Implementation and Testing of EIM Systems
• Strong Understanding of financial accounting and reporting standards (GAAP) & HIPAA regulations
• Experienced working with database environments like Oracle, SQL Server, MS Access, DB2 & Teradata
• Competent in developing SQL, PL/SQL Procedures, Functions, & Packages in SQL Server & Oracle Databases
• Highly focused, hard-working team leader with strong problem solving, interpersonal & technical skills

TECHNICAL SKILLS:

EIM Tools: Informatica MDM 9.5,10, 10.2 (MDM Hub, Informatica Data Director), PIM 7.1 (Product 360)

ERP: Oracle E-Business Suite R 12.1.1, SAP ECC

Cleanse Adapters: Address Doctor, Trillium

ETL: Informatica Power center 9.0/8.0(Designer, Workflow Manager), SSIS

BI Tools: Cognos 10/8.x (Business Insight, Report Studio, Framework Manager, Transformer, Metric Studio), Cognos TM1, OBIEE, SSRS, SSAS, SAP Business ObjectsDatabase Systems: Oracle 11g, 10g/9i/8i/7x, MS Access, SQL Server 2000/2005, IBM DB2 and Teradata

Application Servers: Web Logic 10.x/9.x, JBoss, IBM Websphere 7.0

Web Servers: Microsoft Internet Information Server (IIS) 5.0/4.0/3.0 & Tomcat

LDAP Servers: Sun One 5.2, Netscape Directory Server, ADS

Operating Systems: Windows NT/2000/Server 2003/XP, UNIX, LINUX, CITRIX

Programming Skills: SQL, PL/SQL, MDX, Python, Java, Java Script and VB

Applications: Microsoft Visual Studio, MS Office Suite (Word, Excel, Power-point, Access)

Other: TOAD, PL/SQL Developer, ERWIN 4.0/7.0

PROFESSIONAL EXPERIENCE:

Confidential, Teaneck, NJ

MDM Technical Lead (Architecture & Platform)

Responsibilities:

• Acted as the First line of business contact for Univision
• Responsible for maintaining applications-data for Customer Hub and Product Hub in Informatica MDM/IDQ
• Worked with Data Stewards and Application Source System teams in defining BRD and Technical Design Documents including Source Systems, Hub Data Model Design, GAP analysis, Hierarchy configuration Match Rules, Integration.
• Managed MDM administration including application installation, configuration and troubleshooting for work packages and patch upgrades
• Provided Business Users with “Send to Oracle” feature in IDD and Entity 360 application utilizing smart search capability with User Exit and Enterprise Service Bus Integration component with JMS queue configuration and webservices interaction using SIF
• Utilized Service Now to create Enhancements and Defects to manage Project related iteration and Sprint planning activities.
• Performed Bulk Merge based on Requests from Master Data Stewards
• Created capabilities of Bulk Approval through IDD for task flow management using Active VOS
• Created Statement of Purpose for Operational Procedures & work arounds to support MDM application
• Monitored and supported MDM Domains, Nodes, Service Manager and application services
• Worked Closely with Informatica Product Vendor’s in raising product defects and working with them to resolve the defects in lower environments planning for EBF’s and Hot Fixes
• Configured Post Load Hub Exit to enable multithreading for reactivaton scenarios of Customers

Environment: Informatica Multidomain MDM 10.2 HF1 EBF3, Address Doctor, Teradata, Jboss, SQL Server 2012, SQL Developer, IDD, SIF, Red Hat Linux, Smart Bear SOAP, Eclipse

Confidential, San Francisco, CA

Senior Consultant | MDM Architect

Responsibilities:

• Worked closely with Business Systems Consultant, Business Analysts, Tech Relationship Managers and Development team in defining the Functional Specifications Design Document.
• Created Technical Design Document that reflects that actual MDM Implementation methodology that is derived from FSD
• Performed Proof of Concept Demonstrating Product capability of governing loaded Hub Data in IDD
• Configured Hub Data model including Base Objects, Hierarchies, Relationships, Landing Tables, Source Systems, Staging Tables, MDM Mappings and Batch Groups
• Enabled /Implemented Consensus Hard Deleted Detection (Delta) as multiple source systems were involved that were responsible to determine the delete state of a record.
• Implemented Data Standardization by creation General Cleanse Functions, Business Attribute Cleanse Functions and Composite Cleanse Functions
• Worked with Development Team to enable automation of Batch Jobs utilizing Autosys

Environment: Informatica Multidomain MDM 10.2 HF1 EBF2, Ab Initio, Weblogic, Oracle 11g, SQL Developer, IDD, SIF, Red Hat Linux, Smart Bear SOAP, Eclipse, Teradata

Confidential, Palo Alto, CA

Project Lead, MDM Architect, Scrum Master - MDM (Design & Operations)

Responsibilities:

• Created and Implemented Design for Master Data Management Conversion Process for the Company Data Split from HPE to HPI considering all attributes from Business Process Usages to Business Area Groups from a company specific process perspective consumed by SFDC & other downstreams
• Provided recommendations, work arounds and risk mitigation architectural solutions from a Master Data Management Process perspective
• Managed Sprint Planning sessions, pro actively created User stories from Product Backlogs with team co ordination and scheduled daily scrum calls to ensure the agile SAFE methodologies were implemented successfully on an MDM Program Scope
• Configured MDM Hub Base Tables for HPI Split and supporting Landing, Staging Tables, Mappings and Batch Groups to support Conversion process Data flow and On going Synchronization
• Created SQL Scripts with Business Process and Business Relationship Type rules to land data into MDM HPI supporting Landing Tables
• Configured and managed Informatics Data Director Governance Applications for HPE and HPI implemented Business Relationship management with validation and security for Customers, Partners and Competitors
• Mentored Tibco Team in Message queue configurations and supported in testing the Message distribution of MDM data to several downstream applications
• Played the role of a Scrum Master in the delivery of Projects planned in multiple Sprints per Program Increment implemented in Scaled Agile Framework
• Provided Detailed Demo presentation to Business Product Owners, Business Operations teams, Project Management team and Development Units with biweekly Mid Sprint and End of Sprint Demo’s on User Stories created for Sprints
• Ensured Coding Practices were met with Code Review approvals and Retrospective meetings to seek continuous improvement in the MDM Process Improvement

Environment: Informatica Multidomain MDM 10 HF2 EBF13, Informatica Power Center 9.5, JBoss, Oracle 11g, SQL Developer, Address Doctor, IDD, SIF, Sales Force, DNB, Tibco Messaging, Quest Toad, SQL*Loader, Red Hat Linux, Erwin

Confidential, East Hanover, New Jersey

Lead Master Data Management Consultant

Responsibilities:

• Communicated with multiple cross functional internal and external teams like External Hub Data Vendors, Customer Data Warehouse, and Information Management System Units in successfully aligning the UAT Publish Process on the life cycle Reference Data Management Process.
• Designed Queries and mentored offshore resources in building Test Cases (Validation SQL Queries) to verify data across File Systems, MDM System and Data Warehouses.
• Paid attention to detail in Match Tuning process particularly in the verification of Percentage of Records that matched for the Customers from different systems
• Ensured Individual Data Files were accurately updated with latest External Vendor supplied Data prior to kicking off MDM Jobs
• Executed Jobs from external Source Systems to populate the MDM Landing Tables; performed Count Validation on weekly data publish
• Manually ran weekly Staging, Load, Match, Auto merge and Auto match & Merge Jobs for Consolidating Master Records for Customer Data using Match All (Match Rule Sets)
• Addressed data issues on match results by Creating External Match Jobs to correct and re publish Master Data
• Analyzed and Published MDM Reports like “No of Physicians per Product” and Prescriber ID’s that were inactivated with each load during MDM process
• Reported Back Observations made on the Patient Status & Sales Record Counts to External Data Vendors

Environment: Informatica MDM 9.1(HUB/Cleanse), Informatica Data Director(IDD/User Interface), IBM Data Stage(ETL), Oracle 10g(Database), PL SQL Developer, Oracle Web logic Server

Confidential, Palo Alto, CA

MDM Consultant | Product Information Management

Responsibilities:

• Performed GAP analysis on prior MDM solution including the data model and the user interface
• Documented the master entities, data types, referential integrity, foreign key relationships & new business requirements that were proposed to tweak the earlier MDCP data model
• Created Informatica Powercenter mappings and transformations for integrating data flow from legacy to new informatica MDM solution utilizing capabilities like Designer, Repository Manager, Workflow Manager,
• Performed Proof of Concept for PIM 7.0(Heiler) data integration utilizing the PIM Desktop Client in configuring the PIM data model, repository properties, import mapping creations, export rule templates and validating end to end processes in the demonstration working closely with Product Experts and Client.
• Designed the Data Model in the MDM Hub Repositories by creating Base Objects using schema import and manually adding rows based on customer requirements
• Created one to one and one to many mappings between the Landing & Staging Tables
• Created Hierarchies like World Region- Country in the Data Model by creating Entity Objects, Entity Types, Hierarchies & Relationship Base Objects, then created profiles to be utilized for Data Stewards for Master Data Governance
• Defined Match Paths, specified Match columns, strategy with match rules for merge consolidation prior to mastering record in the base object
• Created stage, load, match Batch Groups & executed them manually & worked with other teams to create custom stored procedure scripts to perform automation of batch group execution
• Monitored Batch job error debug and handling, imports, change lists and validation using metadata manager
• Designing & configuring multiple IDD applications in creating contacts & person front end UI apps

Environment: Informatica Multidomain MDM 9.5, Informatica Power Center 9.5, JBoss, Oracle 11g, SQL Developer, Address Doctor, IDD, SIF, DNB, Tibco Messaging, Quest Toad, SQL*Loader, Red Hat Linux, Erwin

Confidential, New York, NY

Sr Consultant

Responsibilities:

• Collaborated with Technical team, Business Analysts & EU Countries Business Users to create Date Requirement Templates and Quantitative Reporting Templates
• Performed Installation & Configuration of the TM1application on development servers
• Translated Business Requirements into Cognos Technical Requirement Specifications
• Designed dimensions, Turbo Integrator processes, cubes & applied business rules prior to deployment of the Actuarial & finance application
• Setup Cognos FSR for delivery of Quarterly and Annual Reporting templates
• Performed Version Control check outs with StarTeam on models and other objects

Environment: Cognos 10TM1(Architect, Perspectives, TM1 Web), Cognos BI( Business Insight, Framework Manager, Power play Transformer, Report Studio, Analysis Studio, Query Studio), Cognos FSR, UNIX, Oracle 10g, TOAD, MS Access DB, STARTEAM

Confidential, Williston, VT

Cognos Report Developer

Responsibilities:

• Worked with Business Owners and Developers in support of Cognos 8 Business Intelligence solutions as part of the enterprise systems architecture
• Designed & modeled Financial Cubes in Cognos 8.4 Transformer utilizing IQD’s & packages as data sources to build cubes for analyzing P&L, Capital, and Expense Details data.
• Developed P&L, Budget & Forecast reports for Specialty Coffee Business unit Cognos Report studio using advanced reporting capabilities & calculations for determining report output for fiscal year information.

Environment: Cognos 8.4(Framework Manager, Power play Transformer, Report Studio, Analysis Studio, Query Studio), SQL SERVER 2008, SSIS/SSAS, Oracle 10g, PL/SQL

Confidential, Oklahoma City, OK

Cognos Consultant

Responsibilities:

• Co-ordinated with SVP, Franchisee Groups, Market Leaders in gathering Business Requirements and translated the requirements into Wireframe Specifications.
• Worked extensively on SQL, PL/SQL Scripts
• Designed& supported Cognos Powerplay Transformer Model in (.mdl,.pyj formats) utilizing multiple data source connections to build Customer Matrix and Flash cubes for Business analytics reporting.
• Developed Weekly Opportunity Store Tracking, System Variance & Ranking of Stores by Percentage food cost of Sales report sets in Cognos report studio using advanced reporting capabilities.
• Performed QA analysis and testing for the Cognos reports utilizing Cognos Test cases and User stories
• Documented reports in JIRA Studio & wireframed the guidelines for business user understanding

Environment: Cognos 8.4(Framework Manager, Powerplay Transformer, Report Studio, Analysis Studio, Query Studio),Cognos Report Net 1.1(Migration) Cognos TM1 9.5, JIRA STUDIO, SQL SERVER 2008, SSIS/SSAS, PL/SQL

Confidential, Melville, NY

Cognos Reporting Consultant

Responsibilities:

• Facilitated GAP analysis sessions in identifying Cognos functionalities that supported the requirements.
• Maintained and implemented Best practices in setting up folder structures, report & model design
• Designed report sets on Activations, Outstanding liability, Transaction Type by date that include multiple chart type selections, multi measure prompts, two calendar type prompt rendering, parameterized filters
• Designed Portal Tabs for setting up the Prepaid Dashboard for development & testing environments
• Customized portlets with Cognos SDK that reference to prompt and report pages respectively
• Performed functional testing and SQL Testing for all the reports in the prepaid dashboard
• Supported User Acceptance Testing tasks in fulfilling action logs and provided project tracking updates.

Environment: Cognos 8.4(Framework Manager, Report Studio, Analysis Studio, Query Studio), Cognos SDK, SQL, PL/SQL, IBM DB2, Erwin 4.0, IBM DB2 Info sphere Cubing Services, Ab Initio, IBM AIX, LINUX.

Confidential, Topeka, KS

Cognos Consultant

Responsibilities:

• Gathered requirements and report specifications from External marketing team & business users on used cases for the Group Reporting project.
• Developed network pricing relational model for claims reporting purposes utilizing best practices in Cognos Framework Manager & optimizing the underlying SQL for fine tuning
• Published cubes and packages in the Cognos Portal for a certain request based on a specific timeframe
• Designed top Dental Provider reports providing the user the ability to rank them on a specific number and present them with prompt boxes to filter on groups and sub groups
• Exported IBM SPSS Predictive Results to IBM Cognos BI utilizing the Collaboration & Deployment Feature

Environment: Cognos 8.4(Framework Manager, Report Studio, Analysis Studio, Query Studio),IBM Cognos SPSS(Statistics, Modeler,, Cognos SDK, SQL, PL/SQL, Oracle 10g, IBM DB2, Windows Server 2003,Microsoft Visual Studio

Confidential, Chicago, IL

Business Analytics Consultant - Cognos

Responsibilities:

• Sketched the roadmap for demonstrating DW-BI capabilities within ISR’s current architecture.
• Worked with business users on used cases for requirement gathering during business analysis
• Closely worked with data modelers and coordinated meetings with the offshore team on the design of existing multidimensional model containing many to many relationships
• Designed Survey reports with dynamic display of charts with a multi level prompting interface
• Developed Category Breakdown Matrix reports to identify the overall scores and difference values by implementing Business rules and statistical significance calculations

Environment: Cognos 8.3(Framework Manager, Report Studio, Analysis Studio, Query Studio),Composite Information Server, Cognos SDK, SQL, MDX, PL/SQL, MS Access, SQL Server Analysis Services(MSAS) 2005, Oracle 10g, Windows Server 2003,Microsoft Visual Studio, Visual Source Safe.