Title

Customer and Product MDM Hub implementation using Informatica MDM formerly Siperian suite and publishing the information over t a Sales Force Cloud SFDC .

Responsibilities

• At a 'Data Architect ' role my primary responsibilities are:
• Create and manage Data Models, Design Artifacts and owning Key Design Decisions for MDM Hub.
• Designing three way Balance and Control mechanisms between Legacy Source systems RTMS , MDM Hub and SFDC.
• Customization of Match, Merge rules and trust settings in the MDM Hub t enable better consolidation of MDM Golden record.
• Designing robust error/reject tracking at Sales Force SFDC side and building a recycling framework.
• Create Conceptual Detail Architecture documents related t MDM Hub.
• Provide Technical Leadership for overall Data Governance framework around MDM implementation Program.

Environment

Oracle 11g, Informatica MDM Hub 9.5 , Informatica 9.x, SQL Developer Data Modeler, UNIX, Sales Force Dotcom SFDC

Title

Enterprise Data Warehouse EDW on Netezza and its integration with Merchandise Planning Oracle RPAS and Master Data MDM Solution using Oracle DRM and Site Hub.

Responsibilities

• At a 'Lead Data Architect' role my primary responsibilities are:
• Provide Technical Leadership for overall Integration related t EDW, Master Data MDM and Merchandise Planning Program.
• Closely working with Business and BA organization for requirements gathering, analysis, and discovery.
• Create Conceptual Detail Architecture documents related t Planning EDW solutions.
• Assist in scoping, estimation of various Information Architecture tracks.
• Create review Design/Architecture Artifacts.
• Own Key Design Decisions KDD's
• Collaborate with internal Information Architecture leads Data Architecture, ETL Architecture , BI Architecture
• Interface with Enterprise Architecture Solution Architecture teams.

Environment

Netezza, UNIX, Oracle RPAS, RDF, ERWIN, Oracle DRM , Site Hub, Data Stage , MS SQL server, Cognos , Qlikview

Title

• Soarian Data Integration t Clinical Data warehouse Knowledge Center
• Fresenius Medical Care North America is in the middle of replacing its legacy systems with Siemens suite of products Soarian Clinicals and Financials . Fresenius has chosen data integration tool Informatica Powercenter for integrating Siemens based Source system structure and information t the Clinical Data warehouse called Knowledge Center for Enterprise Reporting.

Responsibilities

My responsibility included

• Leading a team 6-8 peoples comprising of Developers, Business Analysts, Quality Assurance experts t implement critical interfaces Like Patient , Admission , Dialysis Access , Treatment Results , Lab Results , Orders , Insurance from Soarian Clinicals mainly and Financials t the Clinical Data warehouse.
• Building Systems Integrations Diagram and Data Flow Diagram in collaboration with Source system SME, Architects, Business Analysts, and VP/Director of Data quality and Reporting organization.
• Working with Business users for data collection/discovery, profiling, and analysis.
• Technical design of complex Interfaces Includes modeling interface tables and ETL data flow t transform Entity Value open ended Soarian Data Structure t DW data structure, implement Business Rules, cleanse, validate, roll up, summarize data all the way t Clinical Data warehouse.
• Building detailed technical specifications document TSD .
• Project Estimation and putting together implementation road map.
• Prototyping and evaluating different ways t implement industry best practices in terms of ETL or DB Design t extract and load Information from Soarian MS SQL Server based databases t Oracle Knowledge Center clinical data warehouse.
• Providing Optimization and Tuning solutions for multiple poor performing existing interfaces and programs.
• Actively working with Senior Developers t solve challenges in Admission/Visits, Dialysis Access, Assessments driven interfaces.
• Performed Integration testing and developed Deployment/Migration plan.

Environment

Informatica 8.6, XML, HL7, Oracle 10g, UNIX, MS SQL server, Netezza

Title

Design flexible interfaces for Global Labeling Project.

Responsibilities

My responsibility included

• Gathering and analyzing data integration requirements for ERP, STEP XML , and MES t labeling software PrisymID databases and creating detailed technical design specifications.
• Prototyping and evaluating different ways t connect t Lotus Domin database and providing solution for integration of STEP Product Data using an alternative XML Informatica interfacing approach.

Environment

Informatica 8.6, XML, Oracle 10g, UNIX, Lotus Domino

Title

Lead an Information Integration competency center IICC by utilizing the latest Informatica tool sets t support 300 users across the organization.

Responsibilities

My responsibility included

• Construct and Implement Informatica Best Practices and Naming Conventions across the organization.
• Build and Implement a framework for Administration of 15 Informatica servers managing deployment across diverse environments.
• Dynamic Detection of worst performing Informatica jobs, RC Root Cause Analysis and continuously improving them.
• Develop a customized process t gather granular utilization Statistics CPU, Memory, and Hard Drive Usage and monitor them.
• Capacity planning and Sizing of all Informatica Servers SAND t PROD .
• Working on Central Storage for Informatica Servers and Disaster Recovery DR Capabilities of the organization.
• Participate in the process of Code and design Review.

Environment

Informatica 8.6 , IDQ, IDE, MM, DA, Real-time CDC, SFDC, Oracle 10g

Title

Implement ETL Framework around HBSP's PIM, EBS, and Web site.

Responsibilities

My responsibility included

• Gathering Integration Specifications and layout Integration framework for onetime XML Import feed from legacy system POPS and Documentum t PIM Fulltilt .
• Analyze, Design and Develop hourly XML export feeds t Website DPS , Endeca, E-Business Suite, Alfresco, Fulfillment Vendors Wilde, Pitney Bowes and legacy system POPS, Documentum.
• Design and Develop complex Reusable components and Mapplets in Informatica 8.1/8.5 t convert Fulltilt hierarchical data structure in a flat and de-normalized structure.
• Worked on interface loading using Oracle EBS/ERP power exchange connector/plug-in.
• Design and Develop reusable components for 26 Distributors feeds using PL/SQL, UNIX shell scripts and Informatica.
• Standardizing Error handling and Notification process for fatal and Non-Fatal errors using Informatica 8.1/8.5.

Environment

Informatica 8.5, Oracle 10g, EBS Power Connect, XML, Unix , Oxygen

Title

Refactoring Enterprise Data Warehouse for First Marblehead

Responsibilities

My responsibility included

• Review, Modify ODS and EDW data model as Ralph Kimball's Star schema methodology and create partitioning strategy.
• Design and Develop an Incremental Load process t the persistent and partitioned EDW with reduced load cycle time.
• Developing and maintaining Data Profiling mappings using Informatica t measure data quality of certain key fields.
• Using First Logic plug-in with Informatica t cleanse Name and Address data coming from Capital Markets.
• Defining overall ETL standards and Best Practices as per Industry Benchmarks.
• Wrote Materialized Views and introduced new Indexes Bitmap and B-Tree t improve performance drastically.
• Implementing Incremental load for Various Data Marts Trust Admin, Fraud, Key Indicator and reduce cycle time substantially.

Environment

Oracle 9i, PL/SQL, TOAD, Informatica Power Center 7.x/8.x, UNIX

Title

Prudential Data Conversion for Plymouth Rock group of Companies.

Responsibilities

My responsibility included

• As a Tech lead I was involved in gathering business requirements and coming up with technical specifications.
• Interacting with Project Managers t scope out deliverables and time lines.
• Mentoring junior members in our team of 4 and chalking out their deliverables.
• Defining ETL standards and Best Practices as per Industry Benchmarks.
• Designing and developing Reusable ETL components.
• Creating complex Informatica Mappings, Reusable Mapplets
• Designing a flexible Reusable Control Exception Handling Model for the Conversion Process.
• Writing complex SQL script for doing the QA of above data.

Environment

Oracle 9i, PL/SQL, TOAD, Informatica Power Center 7.x,Control-M

Title

Enterprise Information Infrastructure EII for ING, America

Responsibilities

My responsibility included

• Leading a small team of 3 people during the performance-tuning phase of the EII implementation.
• Analyzing and Performance Tuning of SQL queries and defining development standards.
• Defining Indexes for high performance of business queries as well reduction of load times int Data Warehouse and Mart.
• Implemented Slowly Changing Dimensions Type 2: versions t update the dimensional schema.
• Implemented procedures/functions in DB2 SQL for Stored Procedure Transformations.

Environment

DB2 8.1, Oracle 9i, PL/SQL, TOAD, Informatica 7.x/6.x, Control-M

Title

Financial Reporting for AR Services from Data warehouse

Responsibilities

My responsibility included

• Leading a team of 5 people for project implementation using onsite as well as remotely connected delivery team.
• Gathering and analyzing requirements and reaching t a realistic Project Estimation.
• Designing Dimensional Models Star Schema for Data Warehouse
• Using Ralph Kimball's Star Schema methodology.
• Defining ETL standards and Optimization rule as per Best Practices.
• Creating complex Informatica Mappings and sessions, stored procedures in PL/SQL , Tuning SQL scripts as well as optimization of existing.

Environment

Oracle 8i/9i, PL/SQL, Teradata, Power Center 7.x/6.x/5.x, DPA, ERWIN4.1

Title

Orion Data warehouse for E-Global Reporting

Responsibilities

My responsibility included

• Responsible for requirement gathering, analysis Project Estimation.
• Leading a team of 4 people using global delivery model.
• Delivering a dimensional model Ralph Kimball's Star Schema using Erwin 4.1 Data Modeler t for real estate Market information.
• Architecting a 3-tier data flow transformation channel consisting of Application, Raw ODS Data mart using Power Center 6.2.
• Resolving Informatica performance issues by doing test runs and incorporating industry standard tuning measures.
• Writing and tuning Database scripts / Query optimization.

Environment

Oracle 8i/9i, PL/SQL, SQL Plus, Teradata, Power Center 6.2, ERWIN4.1

Title

Marketing Experience Project - Enterprise Data Warehouse and Relational Operational Data store for Sales Marketing, Risk, and Finance team.

Responsibilities

My responsibility included

• Played the role of Tech Lead during the last phase of Marketing Data warehouse project Mentored and managed a team of 5 peoples.
• Member of the core warehouse design team, which interacted with the business community t identify the core business process and facts.
• Involved in dimensional modeling star schema of the data warehouse using Ralph Kimball's methodology.
• Extending the HIPPA regulation t the Claims Calyps module and work with EDI consultant for the data mappings.
• Database Design for Promotions, Leads, Claims module.
• Collect performance for sessions and resolved memory issues like DTM buffer size, cache size t optimize session runs.
• Automation of Production ETL system.

Environment

Oracle 8.1, PL/SQL, Power Center 5.1, ERWIN4.1, SQL Server 7.0, UNIX

Environment

VB 6.0, SQL Server 7.0, Crystal Reports, ASP, IIS, Erwin 3.5.2, VSS 6.0