Experienced in:

• Designing, Installing Configuring core Informatica MDM Hub components : Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD
• 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.
• 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.
• With the software lifecycle phases including design, development and implementation.
• Highlights of Qualifications
• EIM: Informatica MDM IDD. .
• DB used: DB2, Oracle, Teradata, SQL Server, MySQL, Ingres, Progress
• Profile: IDQ and Ataccama DQ Analyzer
• Data Warehouse integration, reconciliation, data marts using DataStage, LucidDB, DataCleaner, Informatica Power Center.
• 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, 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

PROFESIONAL EXPERIENCE

MDM Architect

Confidential

• Participate in the BRDs Sessions, giving insightful perspective of the MDM Hub and its environment Customer, Vendor and Item Domain .
• Conduct MDM technical interviews with candidates for MDM positions for the project.
• Participate 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 .
• Track progress with respect to plan. Provide project leadership including: organizing overall project, establishing timelines, breaking down and assigning tasks. Customer, Vendor and Item Domain .
• Profile the data using IDQ to analyse source data party and address for the Customer and Vendor domains coming from Source systems.
• Develop a Customer Domain PoC MDM Hub and IDD for the Data Stewards in order to demonstrate the tool.
• Contribute to analysis FSDs TDDs by providing input for the features and determine feasibility of each feature. Customer, Vendor and Item Domain .
• Participate 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 .
• Prepare 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 .
• Provide technical leadership to MDM team on design and implementation.
• Consult 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 .
• Ensure MDM code conforms to established coding standards and meets the feature specification.
• Document 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, as well as development them in the MDM Hub, to be used in the IDD.
• Design and develop the Cleansing, Standardization and Match process of the Customer and Vendor domains.
• Design and develop the Survivorship of Customer and Vendor domains.
• Lead the design, development and execution of test newly developed features to ensure proper functioning prior to release to QA.
• Ensure new code, feature or software product meets performance goals and does not adversely impact the performance of existing subsystems.
• Involve with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Perform land process to load data into landing tables of MDM Hub using Power Center for initial data load in hub store.
• Help define and track Data Quality and Data Governance metrics.
• Mentor and provide direction to less experienced software engineers regarding MDM platform development, processes, and product architecture.

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

MDM Consultant

Confidential

• Meeting 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.
• Participating in leadership meetings with other project teams and determine impact of other projects on the current MDM project.
• Creating project deliverable templates and standards including coding standards, etc converting BRDs into FRDs.
• Setting up the environments Install configure MDM Hub repository, Hub Console, Cleanse Match Server
• Collaborating with the modeling team to create the logical model required.
• Configuring and creating landing, base objects staging tables.
• Developing the mappings and used the necessary cleanse functions by analysing the data.
• Determining foreign key relationships, static lookups, dynamic lookups.
• Creating queries, packages, query groups, custom functions and batch groups.
• Setting up match/survivorship rules and profiling the match rules results to assess the effectiveness of MDM process on data.
• Configuring and implementing hierarchies.
• Performing data standardization using Address Doctor, Trillium, Informatica Data Quality and Data integration using SIF API's
• Managing 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.
• Configuring and customizing Subject Area Groups and Subject Areas in IDD, as well as screens and lookups, to meet the data governance objectives.
• Tools: Informatica MDM Hub Server IDD, Oracle, SQL Developer, JBOSS, MS Project.

MDM/ETL Tech Lead

Confidential

• 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 9.1, Informatica MDM, Teradata, DB2, Oracle, SAP BA BW, Unix, MS Project, Autosys, JBOSS.

Business Analyst MDM/DWH/BI

Confidential

• 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
• Leaded 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.
• Leaded 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.
• Leaded, 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

• 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 Datamarts .
• Started the integration of Power Center with B2B Data transformation.
• Used tools Informatica Power Center 9.1, Z/Series, Squirrel, ErWin, DB2, Oracle Developer, Unix, Project Manager among others

Project Leader Data Modeling / DBA Team

Confidential

• 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.

DB2 AS400 Data Specialist

Confidential

• Maintained the daily operations on the AS/400 CL DB2
• Data warehousing over several servers, delivered solutions for production programs.
• Designed and maintained databases and database solutions that operate within prescribed resource limits and meet company standards.
• Participated in and contributed to all phases of systems development projects.
• Monitored and tuned database and database application performance tuning, and viability of DPF.
• Investigated and analyzed the root causes of incidents and initiated changes to internal processes, procedures, or databases to resolve the underlying problem or provide a workaround, like MDC.
• Modeled reengineering actual systems to dramatically improve performance over several servers CL, DB2 R.S.A
• Used tools IBM RAD, iNavigator, QMF, Infosphere Warehouse Data Stage, Crystal Reports, Monarch Pro

DB Consultant

Confidential

• Gathered requirements from client's business, translating the requirements into technical document for Data warehouse design, and development, dimensional data modeling.
• Analyzed, designed, coded and debugged programs for use on mainframe computer systems Sever 2003, DB2, MySQL Oracle .
• Wrote programs specification and documentation DB2, Oracle, Teradata, MySQL, COBOL, PL/SQL, and RPG .
• Documented and performed system testing.
• Analyzed environments and designed Data warehouse based on clients necessities.
• Leaded the data technology solution analysis, design, and implementation, and ensures that the product fulfilled the requirements.
• Performed analysis of testing issues, and assisted in integration and operation testing.
• Provided technical level mainframe operating systems programming to support the mainframe operation systems and infrastructure.
• ETL development using DataStage and Informatica, loading and validating data.
• Used tools: ETL Tools, Erwin, SSIS, Monarch Pro, QMF, LucidDB, DataCleaner.

IT Manager

Confidential

• Hired and managed a team of 3 engineers and 4 techs to handle the daily operations based on the specific need of the company.
• Planned, installed and administrated an 80 node NT Ethernet LAN.
• Managed the ERP Mapics system based on AS/400 and mixed Win95/98/XP/2000 environment
• Developed methods and procedures for IT and communications systems internal and external .
• Managed MS Windows NT 4.0, Exchange 5.5 servers and print servers with their associated operating systems and software, ensuring their maximum performance, efficiency, and availability.
• Monitored, troubleshot and provided solutions to assure communication through frame relay in the WAN Convergence, Cisco, Nortel, and Telmex .
• Researched and recommended new technologies to reduce costs and improve business performance.
• Negotiated hardware and software solutions with network solutions suppliers.
• Researched, analyzed and tested to ensured overall success of new configurations, installations and settings.

Project Leader

Confidential

• Worked with the ERP MFG/Pro based on Progress SQL and running under a HP/9000 Inventories, Production, Purchases, Technology, Planning MRP and Quality Assurance
• Led a team of 4 engineers to develop and maintain company's departments
• Provided Q/A statistics of the service provided and feedback to members of the team
• Analyzed and designed software and documentation for new developments and updates
• Established a security system for the Y2K
• Provided training and guidance to customers as well as other members of the team
• Developed a Q/A system to track the production results with CPK's using Progress SQL
• Performed testing, communicated issues to technical team, and assisted in integration and operation testing
• Managed and coordinated a 30 nodes NT Ethernet LAN