SUMMARY:

• IT certified specialist with relevant expertise in Enterprise Information Management & Databases with excellent and proven technical and management skills, dedicated to the principles of quality, continuous improvement and customer satisfaction. Accustomed to fast - paced environments where deadlines are a priority and managing multiple jobs simultaneously is the norm.
• Designing, Installing & Configuring core Informatica (Siperian) MDM Hub components: Informatica (Siperian) MDM Hub Console, Hub Store, Hub Server, Process Servers, Cleanse Adapter and IDD (BDD).
• Master Data Management concepts, Methodologies and ability to apply this knowledge in building MDM solutions.
• MDM Hub configurations - Data Mappings, Data validation, Match and Merge rules, Hierarchy Manager.
• Customized/configured IDD application and Subject Areas, Subject Area Groups, Deploy and test IDD application, cleanse functions, utilizing timeline, export and import master data.
• Worked extensively on BDDconfig file to get the changes reflected on IDD.
• Designing & developing multiple cleansing and standardization scenarios.
• Implementing Hierarchy Manager Module in addition to Match/Merge/Unmerge to depict various hierarchies
• Performing Data Standardization of addresses using Address Doctor and Informatica Data Quality.
• Upgrading Informatica MDM (Hub Store, Hub Server, Process Server and Troubleshooting).
• Profiling Data Sources using IDQ (developer & analyst).
• Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Working on transformations like Source Qualifier, Expression, Aggregator, Router, Filter, Update Strategy, Lookup, Sorter, Normalize, Union, Stored Procedure, and Sequence Generator, Slowly Changing Dimensions.
• Scheduling and Creating Workflows, sessions & involved in the Performance Tuning of Mappings & Sessions.
• SQL, UNIX, Shell Scripting, Data Relationships, Data extraction & Validation.
• Debugging, troubleshooting, monitoring and performance tuning in SQL queries.
• Software development lifecycle phases (SDLC).
• Customer-oriented, Listened to identified and documented requirements
• Crisis manager, worked 24/7 to maintain consistent performance and profitability of the system
• Recruited and established a departmental team of 15 professionals who were able to effectively implement and innovate products based on company requirements
• Provided exceptional leadership by demonstrating acute decision-making and communications abilities
• Hands-on manager, playing an active role in the team
• Results-oriented, performed strategic planning, scheduling and effectively used resources, status reporting and concrete goal setting
• Bottom-Line oriented, administered budget of $500,000.00 and reduced costs by 15% through the negotiation of new deals with suppliers
• Asset manager, achieved significant cost reduction by implementing the right procedures
• Managed the daily personnel/operating activities of the department (i.e., hires, trains, appraises, rewards, motivates, disciplines, etc.)

PROFESSIONAL EXPERIENCE:

Sr. MDM Consultant

Confidential, Reston, VA

Responsibilities:

• Evaluating and assessing the new requirements in the MDM environment.
• Evaluating the new sources and their impact in the model.
• Understanding the goals and risks associated with the business and technical requirements, and offer counsel on risk mitigation and the alignment of data solution with objectives.
• Designing and developing the Cleansing, Standardization and Match process of the Customer domain.
• Ensuring new code meets performance goals, coding standards and does not adversely impact the environment.
• Tuning up the Match/Merge setup in order to increase performance.
• Configuring and testing the IDD (BDD) environment based on the requirements and changes in the model and hierarchy.
• Optimizing of the custom code (packages, procedures, user exits, etc.…)
• Performing deep data analysis across the MDM data model in response to data quality concerns and other issues raised by customers or application partners.
• Post-delivery communication to up/down-stream applications/Support teams and Business.
• Modifying and implementing new User Exits (Java).
• Creating new and modifying existing jil and config files for the Autosys jobs.
• Administration activities as security, code promotion, configuring changes and issue debugging.
• The company is using Agile Environment to develop the daily environment and improvements.
• Tools: Informatica (Siperian) MDM Hub Server 9.7.1 HF5, Oracle, PowerCenter, JBoss, Autosys.

MDM Lead

Confidential, Mountain View, CA

Responsibilities:

• Evaluated and assessed the change of new source D&B to Avention in the MDM environment.
• Planed and prioritised steps to task, evaluated progress of the activities.
• Motivated staff and created a positive team feeling.
• Assessed the rest of the environment behaviour due to the change (Salesforce (CRM), CDH & ERP)
• Understood the goals and risks associated with the business and technical requirements, and offer counsel on risk mitigation and the alignment of data solution with objectives.
• Designed and developed the Cleansing, Standardization and Match process of the Customer domain for Avention data.
• Ensured new code, meets performance goals, coding standards and doe s not adversely impact the environment.
• Tuned up the Match/Merge Setup in order to increase performance.
• Participated in analysis and design of the Hierarchies with project manager to determine the best approach aligning to the environment.
• Efficient creation of hierarchies, including the definition of hierarchy nodes and the relationships.
• Loaded data to test the hierarchies using PowerCenter.
• Modified and implementing new User Exits (Java).
• Configured and tested the IDD (BDD) environment based on the requirements and changes in the model and hierarchy.
• Optimized of the custom code (packages, procedures, user exits, etc.…)
• Performed deep data analysis across the MDM data model in response to data quality concerns and other issues raised by customers or application partners.
• Upgraded activities from 9.7.1 HF5 to 10.1.0., configuring changes to the tool to ensure that the functionality of the application is intact after the upgrade, verifying the security of the application in the new environment.
• Post-delivery communication to up/down-stream applications/Support teams and Business.
• Configured and troubleshoot ActiveVOS for IDD,
• Administrated activities as security, code promotion, configuring changes and issue debugging.
• The company was using Agile Environment to develop the daily environment and improvements.
• Tools: Informatica (Siperian) MDM Hub Server 9.7.1 HF5 and 10.1.0 HF1, Oracle, PowerCenter, WebSphere.

MDM Architect

Confidential, Boston, MA

Responsibilities:

• Followed systems and procedures established, monitored progress of the project, acted as interface between team and outside.
• Evaluated and assessed the new requirements in the MDM environment.
• Understood the goals and risks associated with the business and technical requirements, and offer counsel on risk mitigation and the alignment of data solution with objectives.
• Designed and developed the Cleansing, Standardization and Match process of the Customer domain.
• Ensured new code meets performance goals, coding standards and does not adversely impact the environment.
• Tuned up the Match/Merge Setup in order to increase performance.
• Participated in analysis and design of the Hierarchies with project managers to determine the best approach aligning to the environment (Customer Domain).
• Documented the Hierarchies specifications and develop them.
• Efficient creation of hierarchies, including the definition of hierarchy nodes and the relationships
• Loaded data to test the hierarchies using IBM DataStage
• Configured and test the IDD (BDD) environment based on the technical document and requirements.
• Optimization of the custom code (packages, procedures, user exits, etc…)
• Administered the hub (installing the HF, verifying performance and integrity, Logs analysis, match rules tuning, testing IO, etc.…)
• Documented incident life cycle for post implementation reviews.
• Performed deep data analysis across the MDM data model in response to data quality concerns and other issues raised by customers or application partners.
• Participated in the upgrade from 9.0.1 to 9.7.1, validating the metadata, converting of the existing application databases to talk to the new version of the tool, regenerating match tokens, validating the upgrade, etc.…
• Configured changes to the tool to ensure that the functionality of the application is intact after the upgrade.
• Verified the security of the application and the new environment.
• Verified the new and modified jil and config files for the Autosys environment.
• Post-delivered communication to up/down-stream applications/Support teams and Business.
• The company is using Agile Environment to develop the daily environment and improvements.
• Tools: Informatica (Siperian) MDM Hub Server 9.0.1 HF4 and 9.7.1 HF5, Oracle, DataStage, WebSphere, Autosys

MDM Consultant

Confidential, Atlanta, GA

Responsibilities:

• Participated in analysis and design of the Hierarchies with project managers to determine the best approach aligning to the environment (Customer Domain).
• Audited the data using IDQ, creating profiles, mappings, mapplets/rules, scorecards, etc.…
• Documented the Hierarchies specifications and developed.
• Efficient creation of hierarchies, including the definition of hierarchy nodes and the relationships
• Loaded data to test the hierarchies using PowerCenter
• Ensured new code meets performance goals, coding standards and does not adversely impact the environment.
• Involved with Data Steward Team for designing and documenting Informatica Data Director (IDD) for supporting management of MDM data with hierarchies.
• Configured and tested the IDD environment based on the technical document.
• Tools: Informatica (Siperian) MDM Hub Server & IDD 9.7.1HF1, IPC 9.5.1, IDQ 9.5.1, SQL Server 2008, JBOSS.

MDM Architect

Confidential, Richmond, VA

Responsibilities:

• Participated in the BRDs Sessions, giving insightful perspective of the MDM Hub and its environment (Customer, Vendor and Item Domain).
• Co-ordinated efforts and resources, gave orders and instructions.
• Conducted MDM technical interviews with candidates for MDM positions for the project.
• Participated in planning and design review meetings with technical leads and project managers to determine schedules, review technical problems, and assign tasks and resources. (Customer, Vendor and Item Domain).
• Tracked progress with respect to plan. Provided project leadership including: organizing overall project, establishing timelines, breaking down and assigning tasks. (Customer, Vendor and Item Domain).
• Profiled the data using IDQ to analyse source data party and address for the Customer and Vendor domains coming from Source systems.
• Developed a Customer Domain PoC (MDM Hub and IDD) for the Data Stewards in order to demonstrate the tool.
• Contributed to analysis (FSDs & TDDs) by providing input for the features and determine feasibility of each feature. (Customer, Vendor and Item Domain).
• Participated in Requirements Analysis, Gap-Fit each MDM requirement as well as provide high level of estimate for the level of effort required to meet each requirement. (Customer, Vendor and Item Domain).
• Prepared the Data Migration Analysis, Document outlining the expected tasks, level of effort and resource requirements to migrate from several sources to MDM Hub. (Customer, Vendor and Item Domain).
• Provided technical leadership to MDM team on design and implementation.
• Consulted with downstream developers in order to determine feature priority. Interface with Customer Support and user groups to find out how customers are using products in order to better understand customer issues and provide input to future product design. (Customer, Vendor and Item Domain).
• Documented outlining the expected level of effort and resource requirements to map source systems data attributes and structure to the enterprise logical data model for the Customer, Vendor and Item Hierarchies.
• Designed and developed the Cleansing, Standardization and Match process of the Customer and Vendor domains.
• Designed and developed the Survivorship of Customer and Vendor domains.
• Developed the Customer related Hierarchies (BO, Stage, Landing, relationships, packages, loading data, test and implementation).
• Led the design, development and execution of test newly developed features to ensure proper functioning prior to release to QA.
• Ensured new code, feature or software product meets performance goals, coding standards and does not adversely impact the performance of existing subsystems.
• Involved with Data Steward Team for designing, documenting and configure Informatica Data Director for supporting management of MDM data.
• Performed initial load data into landing tables of MDM Hub using PowerCenter.
• Helped define and track Data Quality and Data Governance metrics using IDQ.
• Mentored and provided direction to less experienced software engineers regarding MDM platform development, processes, and product architecture.

Tools: Informatica (Siperian) MDM Hub Server & IDD 9.7.1HF1, IDQ 9.5.1, IPC 9.5.1, SQL Server 2012, JBOSS.

MDM Consultant

Confidential, Sunnyvale, CA.

Responsibilities:

• Met with clients to gather their requirements, identifying the priorities and needs in order to solve them, defining key capabilities /requirements that will enable their strategy.
• Participated in leadership meetings with other project teams and determine impact of other projects on the current MDM project.
• Created project deliverable templates and standards(including coding standards, etc.) converting BRDs into FRDs.
• Set up the environments (Install & configure) MDM Hub repository, Hub Console, Cleanse Match Server
• Collaborated with the modeling team to create the logical model required.
• Configured and creating landing, base objects & staging tables.
• Developed the mappings and used the necessary cleanse functions by analysing the data.
• Determined foreign key relationships, static lookups, and dynamic lookups.
• Created queries, packages, query groups, custom functions and batch groups.
• Set up match/survivorship rules and profiling the match rules results to assess the effectiveness of MDM process on data.
• Configured and implemented hierarchies.
• Performed data standardization using Address Doctor, Informatica Data Quality and Data integration using SIF API's
• Managed the message queues with the SIF JMS.
• Partner with Data Stewards and Enterprise Data Architect to implement a long-range roadmap of Master Data management, including data quality initiatives.
• Partners with various IT teams to syndicate master data from the MDM solution across the application landscape with consistency, integrity and reliability.
• Configured and customized Subject Area Groups and Subject Areas in IDD, as well as screens and lookups, to meet the data governance objectives.

Tools: Informatica (Siperian) MDM Hub Server & IDD Developer, IDQ, JBOSS, MS Project, Oracle.

MDM/ETL Tech Lead

Confidential

Responsibilities:

• Participated and leaded in the gathering and documenting of data and analytical requirements.
• Conducted project and designed review sessions with different stake holders, provided status on key project milestones and financial forecast updates.
• Conducted code review sessions with developers and their manager using agile process (Scrum).
• Collaborated with the Enterprise Architecture teams (data integration, data architecture, business intelligence) to develop and deliver MDM solutions
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Interacted with database administrators to facilitate Informatica MDM Hub (Siperian) Console development.
• Helped determining and setting Trust configuration and Validation Rules.
• Configured data flow as Land, Stage, Load, Tokenize, Match & Consolidate process.
• Profiled the Match/Merge rules to determined performance and accuracy.
• Ensured the master data from the MDM solution across the application landscape with consistency, integrity and reliability.
• Designs and develops necessary batch interfaces to and from MDM hub.
• Provided time and effort, estimated and leaded projects of medium to large complexity
• Assessed situations and suggesting systemic process improvements
• Wrote Technical Designs, developed ETL Job Streams, Business Objects reports/dashboards and promoting code to test and production environments
• Documented development work and providing status on progress.
• Performed the data profiling on metadata.
• Managed business glossaries using the metadata manager.
• Performed as the Go-To person on projects of a medium to high complexity.
• Tools: Informatica PowerCenter, Informatica (Siperian) MDM, Teradata, DB2, Oracle, SAP BA & BW, UNIX, MS Project, Autosys, JBOSS.

Business Analyst

Confidential, NY

Responsibilities:

• Understood the business users requirements for information and communicating them to the rest of the MDM/DWH/BI team
• Assisted MDM/DW/BI data analyst in analyzing existing reports and identifying iteration metrics
• Led preparation of data warehouse requirements document
• Created the mapping necessary for the ETL process
• Defined the MDM Match and Survivorship rules with the Business team.
• Collaborated with the modeling team to define and design Logical Model to use in MDM.
• Assisted the data modelers to prepare models (Star & Snowflake) for the DWH environment.
• Analyzed existing reports to improve.
• Led the identification and documentation of business metrics (KPIs)
• Helped identifying potential sources of data for the data warehouse
• Reviewed and complied all the fields to be used or defined with the metadata standards.
• Reviewed models to ascertain that requirements are met.
• Led, designed, reviewed & oversaw code reviews to ensure all solutions are aligned to pre-defined architectural specifications and quality guidelines.
• Tools: ERwin, DataStage, Ab Initio, Teradata and DB2, Cognos BI Query Studio and Analysis Studio, UNIX, MS Project.

Project Leader ETL Team

Confidential, San Antonio, TX.

Responsibilities:

• Created system requirements, performed design and analysis, coded and unit testing of complex system functionality and/or defect correction across platforms as IMS, BD2 & Oracle.
• Facilitated root cause analysis of system issues to minimize impact and future occurrences.
• Gathered analyzed and influenced user and system requirements. Identified and created solutions to improve system performance and availability.
• Created system documentation/play book and served as a lead technical reviewer and contributor in requirements, design and code reviews.
• Coordinated system application transition from development teams to maintenance and production team and/or construct and implementing necessary controls to assure system / application traceability.
• Developed accurate estimates on work packages and distributing work packages on behalf of the manager. Analyzing and designing specifications for junior team members to execute.
• Collaborated with the Enterprise Model team to create the Snowflakes and Star models required in the DWH and Data Marts.
• Started the integration of PowerCenter with B2B Data transformation.
• Used tools Informatica PowerCenter, Z/Series, Squirrel, ErWin, DB2, Oracle Developer, Unix, Project Manager among others

Project Leader Data Modeling/DBA Team

Confidential, San Antonio, TX.

Responsibilities:

• Participated in analysis, designed, modeled (Star & Snowflake), developed, implemented and maintained the databases on several platforms (DB2, Oracle, SQL Server) Conceptual, Logical & Physical Schemas.
• Managed multiple initiatives of significant scope and complexity. Provided insight and guides management on project-related issues.
• Ensured business continuity by developing and implementing highly available database systems and database recovery plans and procedures. Liaised with database software vendors and external technical support on issues.
• Drove continuous database improvement initiatives to increase efficiency, availability, and productivity.
• Acquired and applied advanced knowledge of database design and management including modeling, creation and maintaining of the most difficult and critical databases objects to serve as a resource to team members on escalated issues of an unusual nature.
• Applied extensive knowledge and demonstrating proficiency with database tools and utilities in different platforms, as well as expert SQL and database performance tuning skills.
• Used tools Z/Series, Squirrel, ErWin, DB2, Oracle Developer and proprietary systems.