SUMMARY

• IT certified specialist wif relevant expertise in Enterprise Information Management & Databases wif 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, 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
• Good knowledge in using SIF API’s such as Get, Search Query, Cleanse Put, Search Match, Merge and Unmerge
• Proficient in Message Queue setup to alert downstream systems upon insert or update actions in MDM hub from web service developed using SIF APIS
• Good knowledge in implementing and understanding the the use case of User Exits for Data Validation and Data Cleaning
• Guiding Java Developers to develop Web Service by using SIF APIs to get registered Operational Reference Store
• Performing Data Standardization of addresses using Address Doctor and Informatica Data Quality.
• Profiling Data Sources using IDQ (developer & analyst).
• Informatica Power Center tools such as Source Analyzer, Transformation Developer, Mapplets 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).

TECHNICAL SKILLS

EIM: Informatica (Siperian) MDM & IDD..

DB used: DB2, Oracle, Teradata, SQL Server, MySQL, Ingres, Progress

Profile and quality: IDQ and Ataccama DQ Analyzer Data Warehouse (integration, reconciliation, data marts) using DataStage, PowerCenter, LucidDB, DataCleaner

BI: mining, OLAP, querying, Crystal Reports, Cognos BI Query Studio and Analysis Studio

DBMS: DB analysis, design, development, maintaining, applications analysis, design, development, implementation

BPM: modelling (Star & Snowflake), metadata maintenance, integration, reengineering, management using Erwin and other tools.

Programmed in: DB2, PL/SQL, Teradata, SQL Server, Ingres, Progress, RPG, CL, COBOL, C++, ILE RPG and Visual Basic Project Management duties for evaluation/testing/implementation of software.

Hardware: HP 9000 series, IBM i/Series (AS/400), z/Series(S/390)

PROFESSIONAL EXPERIENCE

MDM Lead

Confidential, Boston, MA

Responsibilities:

• Evaluate and assess the new requirements in the MDM environment.
• Design and develop the Cleansing, Standardization and Match process of the Customer domain.
• Ensure new code, meets performance goals, coding standards and does not adversely impact the environment.
• Tune Up the Match/Merge Setup in order to increase performance.
• Participate in analysis and design of the Hierarchies wif project managers to determine the best approach aligning to the environment (Customer Domain).
• Document the Hierarchies specifications and develop them.
• Efficient creation of hierarchies, including the definition of hierarchy nodes and the relationships
• Developed ORS Specific and Generic SIF Java services to integrate MDM wif External Java Application
• Understood the client requirements and guided team to implement and in corporate cleanse functions and user exits.
• Load data to test the hierarchies using IBM DataStage
• Worked closely wif Informatica Support to solve the defects raised.
• Configure and test the IDD (BDD) environment based on the technical document and requirements.
• The company is using Agile Environment to develop the daily environment and improvements.

MDM Lead

Confidential, Atlanta, GA

Responsibilities:

• Participated in analysis and design of the Hierarchies wif project managers to determine the best approach aligning to the environment (Customer Domain).
• 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 wif Data Steward Team for designing and documenting Informatica Data Director (IDD) for supporting management of MDM data wif hierarchies.
• Configured and tested the IDD environment based on the technical document.
• Guided team to implement SOAP Web Service using SIF APIs such EJB Siperian Client in order to use Get, Search Query, and Cleanse Put functionality.

MDM Consultant

Confidential, Richmond, VA

Responsibilities:

• Participated in the BRDs Sessions, giving insightful perspective of the MDM Hub and its environment (Customer, Vendor and Item Domain).
• Conducted MDM technical interviews wif candidates for MDM positions for the project.
• Participated in planning and design review meetings wif technical leads and project managers to determine schedules, review technical problems, and assign tasks and resources. (Customer, Vendor and Item Domain).
• Tracked progress wif 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 wif downstream developers in order to determine feature priority. Interface wif 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 wif 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.
• Mentored and provided direction to less experienced software engineers regarding MDM platform development, processes, and product architecture.

MDM Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Met wif 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 wif 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 wif 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, 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 TEMPeffectiveness 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 wif the SIF JMS.
• Partner wif Data Stewards and Enterprise Data Architect to implement a long-range roadmap of Master Data management, including data quality initiatives.
• Partners wif various IT teams to syndicate master data from the MDM solution across the application landscape wif 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 wif different stake holders, provided status on key project milestones and financial forecast updates.
• Conducted code review sessions wif developers and their manager using Agile process (Scrum).
• Collaborated wif 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 wif 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 wif 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 MDM/DWH/BI

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 wif the Business team.
• Collaborated wif 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 wif 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, 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 wif the Enterprise Model team to create the Snowflakes and Star models required in the DWH and Datamarts .
• Started the integration of PowerCenter wif 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 wif 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 wif 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.