SUMMARY

• IT certified specialist with relevant expertise in Enterprise Information Management & Databases with excellent and proven technical and management skills, dedicated to teh principles of quality, continuous improvement and customer satisfaction. Accustomed to fast - paced environments where deadlines are a priority and managing multiple jobs simultaneously is teh 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 dis 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 teh 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 teh teh 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 teh 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 teh new requirements in teh MDM environment.
• Design and develop teh Cleansing, Standardization and Match process of teh Customer domain.
• Ensure new code, meets performance goals, coding standards and does not adversely impact teh environment.
• Tune Up teh Match/Merge Setup in order to increase performance.
• Participate in analysis and design of teh Hierarchies with project managers to determine teh best approach aligning to teh environment (Customer Domain).
• Document teh Hierarchies specifications and develop them.
• Efficient creation of hierarchies, including teh definition of hierarchy nodes and teh relationships
• Developed ORS Specific and Generic SIF Java services to integrate MDM with External Java Application
• Understood teh client requirements and guided team to implement and in corporate cleanse functions and user exits.
• Load data to test teh hierarchies using IBM DataStage
• Worked closely with Informatica Support to solve teh defects raised.
• Configure and test teh IDD (BDD) environment based on teh technical document and requirements.
• Teh company is using Agile Environment to develop teh daily environment and improvements.

MDM Lead

Confidential, Atlanta, GA

Responsibilities:

• Participated in analysis and design of teh Hierarchies with project managers to determine teh best approach aligning to teh environment (Customer Domain).
• Documented teh Hierarchies specifications and developed.
• Efficient creation of hierarchies, including teh definition of hierarchy nodes and teh relationships
• Loaded data to test teh hierarchies using PowerCenter
• Ensured new code, meets performance goals, coding standards and does not adversely impact teh 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 teh IDD environment based on teh 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 teh BRDs Sessions, giving insightful perspective of teh MDM Hub and its environment (Customer, Vendor and Item Domain).
• Conducted MDM technical interviews with candidates for MDM positions for teh 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 teh data using IDQ to analyse source data party and address for teh Customer and Vendor domains coming from Source systems.
• Developed a Customer Domain PoC (MDM Hub and IDD) for teh Data Stewards in order to demonstrate teh tool.
• Contributed to analysis (FSDs & TDDs) by providing input for teh 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 teh level of effort required to meet each requirement. (Customer, Vendor and Item Domain).
• Prepared teh Data Migration Analysis, Document outlining teh 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 teh expected level of effort and resource requirements to map source systems data attributes and structure to teh enterprise logical data model for teh Customer, Vendor and Item Hierarchies.
• Designed and developed teh Cleansing, Standardization and Match process of teh Customer and Vendor domains.
• Designed and developed teh Survivorship of Customer and Vendor domains.
• Developed teh Customer related Hierarchies (BO, Stage, Landing, relationships, packages, loading data, test and implementation).
• Led teh 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 teh 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.
• Mentored and provided direction to less experienced software engineers regarding MDM platform development, processes, and product architecture.

MDM Consultant

Confidential, Sunnyvale, CA

Responsibilities:

• Met with clients to gather their requirements, identifying teh priorities and needs in order to solve them, defining key capabilities /requirements dat will enable their strategy.
• Participated in leadership meetings with other project teams and determine impact of other projects on teh current MDM project.
• Created project deliverable templates and standards (including coding standards, etc) converting BRDs into FRDs.
• Set up teh environments (Install & configure) MDM Hub repository, Hub Console, Cleanse Match Server
• Collaborated with teh modeling team to create teh logical model required.
• Configured and creating landing, base objects & staging tables.
• Developed teh mappings and used teh necessary cleanse functions by analysing teh 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 teh match rules results to assess teh 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 teh message queues with teh 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 teh MDM solution across teh 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 teh 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 teh 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 teh 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 teh Match/Merge rules to determined performance and accuracy.
• Ensured teh master data from teh MDM solution across teh 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 teh data profiling on metadata.
• Managed business glossaries using teh metadata manager.
• Performed as teh 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 teh business users requirements for information and communicating them to teh rest of teh 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 teh mapping necessary for teh ETL process
• Defined teh MDM Match and Survivorship rules with teh Business team.
• Collaborated with teh modeling team to define and design Logical Model to use in MDM.
• Assisted teh data modelers to prepare models(Star & Snowflake) for teh DWH environment.
• Analyzed existing reports to improve.
• Led teh identification and documentation of business metrics (KPIs)
• Helped identifying potential sources of data for teh data warehouse
• Reviewed and complied all teh fields to be used or defined with teh metadata standards.
• Reviewed models to ascertain dat 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.
• Gatheird 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 teh manager. Analyzing and designing specifications for junior team members to execute.
• Collaborated with teh Enterprise Model team to create teh Snowflakes and Star models required in teh DWH and Datamarts .
• Started teh 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 teh 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 teh 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.