SUMMARY:

• More than fifteen years of diversified experience in Data Management, Data Warehouse Architect and Business Intelligence Implementation projects, Data Modeling, Vendor Management, Team Development and Application development. Implemented Data Marts, Centralized Reporting, Financial Dashboards increasing management visibility and customer satisfaction
• Managed ETL development processes, Metadata Modeling, Organized and managed onshore/offshore teams, lead and mentor technology teams.
• Excellent knowledge of data warehouse architectures concepts and technologies, Business Intelligence Implementations, ETL design and development, Data Integration, Systems, Database Architecture, TOGAF Enterprise Architecture standards, Data Governance, MDM Data Hub, Agile data warehousing methodologies,
• Data acquisition and delivery, the real - time enterprise, dimensions of data governance and Data Quality Practices.
• Analyze business requirements, technical specs, source repositories and physical data models for ETL mapping & process flow
• Experience in Analytics/aggregation, Staging for data marts, data warehouses (ETL), Delta processing (change data capture), Data cleansing, validation, conversion, Data mining using various technologies, such as SAP Data services SAP DI, Datastage, Informatica, DMExpress, SSIS, MS SQL based ETL and etc.
• Managed and Administered Oracle Database and Application Servers, Cognos ETL and Content Management Servers.
• Experience in developing slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3
• Well acquainted with Session partitioning and Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings
• Experienced in creating entity relational & dimensional relational data models i.e. Star Schema and Snowflake Schema.
• Proficient in Data Mart, ODS, Dimension Data Modeling and Star Schema Design.
• Created Functional, Technical Design, Data mapping documents by Interacting with Customers and subject matter expert (SME). In Addition participating in requirement gathering, Analyzed the requirements.
• Involved in data modeling and Designed Data Architecture / Data mapping using ERWIN. Created Dimension, facts and cubes for Data warehousing which includes large volumes of data.
• Involved in analyzing business requirement and translate them into details conceptual data model, process model, logical model and physical model using Entity Relationship Diagrams (ERD).
• Extensive experience in design, development and implementation of ETL solutions for data migration in Oracle application implementation projects, Enterprise data management, data cleansing and data quality assurance in a multi-platform legacy applications environment.
• Experienced in Master Data Management concepts and solution. Implemented a major MDM initiative for a POS inventory distribution system.
• Strong working knowledge and expertise in programming skills such as PL/SQL and various development tools.
• Support of IT systems in all phases of the system lifecycle SDLC. Participate and implement business processes, project planning, system analysis, development and testing to exceed client expectations.
• Worked in various methodologies like SCRUM (Agile), Water Fall methodologies and etc.
• Strengths include strong technical backgrounds, industrial experience in a number of professional environments, good interpersonal, Strong Analytical and testing skills, excellent verbal and written communication, writing technical document skills and flexibility to successfully adapt to rapidly changing/evolving demands of the IT industry.

TECHNICAL EXPERTISE:

Data Management Tools: SAP Data services SAP DI, Datastage, Informatica, DMExpress, SSIS Oracle ODI, Warehouse Builder 10G, SAS BI Suite, Cognos reports, OBIEE 10g/11g

Software used: Oracle 12c,11g,- 6, Oracle Developer Suite 10g, PL/SQL, HP UNIX 11.0, shell scripting,, MS SQL, Tera Data, AMISYS Advance, Oracle OEM, Crystal Reports, Fusion Middleware OBIEE & BPEL, WebLogic 11g, OBIEE 10g/11g, Cognos Report, Oracle Application Express 1.0, 2.0, 3.1,4.0(HTMLDB), Java, J2EE, Java script, Ajax, Jquery, CSS, Power builder, XML, Oracle BI Publisher, Oracle WebLogic Server, Oracle JDeveloper 11g, ADF, Oracle SOA Suite, Oracle Work group Server, VB script, Suprtool 4.9 for HP-UX, Oracle Discoverer, Mercury Quality center, Quick Test Pro (QTP), Test Director, Win Runner, PVCS 6.0/7.0, Rational Clear Quest, AppWorx 6.0, CYPRESS Version 4.5., Tuxedo, SharePoint, Clearcase, VISIO Data flow diagram

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh, NC

Sr. Data Architect

Responsibilities:

• Working with DC and stores sales ETL architecture Data Governance, MDM Data Hub, Agile data warehousing methodologies
• Using SAP Data Integrator create maps to transform data. Designed and documented the Data warehouse Meta Data.
• Translated business rules and functionality requirements into ETL procedures.
• Designed and implemented complex data transformation mappings.
• Participate and implement business processes, project planning, system analysis, development and testing to exceed client expectations
• Support BI Team for dashboard using OBIEE.

Environment: Oracle 10g, PL/SQL, SAP Data services SAP DI, Datastage, OBIEE, S QL*Plus, Oracle 10g, Oracle BI Publisher, TOAD, Microsoft Project Visio.

Confidential, Richmond

Sr Data warehouse Architect Consultant

Responsibilities:

• Use ETL tool DMExpress and oracle warehouse builder to create maps to transform data. Designed and documented the Data warehouse Meta Data.
• Developed, tested, stored procedures, functions and packages in PL/SQL for Data ETL.
• Translated business rules and functionality requirements into ETL procedures and worked in Oracle Master Data Management (MDM) Oracle Enterprise Data Quality (DQ) and Oracle Enterprise Product Data Quality
• Developed and tested all the backend programs, data mappings and updated processes.
• Developed ETL architecture and processes. Defined structure of dataflow for seamless migration from large mix data systems.
• Designed and implemented complex data transformation mappings.
• Support of IT systems in all phases of the system lifecycle SDLC.
• Participate and implement business processes, project planning, system analysis, development and testing to exceed client expectations

Environment: Oracle 10g, PL/SQL, Oracle Portal, Oracle DQ, DMExpress, Oracle Warehouse Builder, SQL*Plus, Oracle 10g, Cognos Reports, Oracle BI Publisher, Jdeveloper, TOAD, Microsoft Project Visio.

Confidential, Dallas

Data warehouse Architect Consultant

Responsibilities:

• Worked on data warehouse and data mart solutions using Microsoft technologies, such as SSIS, MS SQL based ETL
• Used ETL tool SSIS Power center to create maps to transform data. Created various active and passive transformations like source qualifier, Lookup, Router and standard and reusable mappings using SSIS.
• Analytics/aggregation, Staging for data marts, data warehouses (ETL), Delta processing (change data capture), Pivots / normalization, Data cleansing, validation, conversion, Web log / clickstream processing, Database loads and extracts, Data mining using SSIS and Enterprise Service Bus platforms (BizTalk),.
• Played a key role in designing and developing ETL models for various projects. Analyzed data sources and targets using SSIS Data Profiling option.
• Designed and implemented ETL mappings/processes using SSIS.
• Identified and resolved performance issues with SSIS mappings and workflows
• Analyze business requirements, technical specs, source repositories and physical data models for ETL mapping & process flow.

Environment: Oracle 10g, PL/SQL, Oracle Portal, SQL Server, SSIS, SQL*Plus, Oracle 10g, Oracle Apex 3.1 & 3.2,4.0, Oracle BI Publisher, Jdeveloper, TOAD, Oracle Financials 11i (AR, AP, PM ) Microsoft Project Visio.

Confidential, New York

Oracle/ETL Consultant

Responsibilities:

• Responsible for the design and build of ETL and conversion components using Informatica.
• Analyze business requirements, technical specs, source repositories and physical data models for ETL mapping & process flow
• Accountable to build, manage and execute ETL development plans on department initiatives
• Work closely with the Solution Lead and Process Analysts to ensure designs meet the requirements
• Creating Solution Architecture documents and implement business processes, project planning, system analysis, development and testing to exceed client expectations
• Create and promote ETL best practices within the team. Establish, coordinate, monitor and participate in ETL reviews, architecture reviews and status meetings as necessary
• Analyze business requirements, technical specs, source repositories and physical data models for ETL mapping & process flow using Informatica.

Environment: Oracle 10g, PL/SQL, Tera Data,Informatica, Oracle Portal, SQL*Plus, Oracle 10g, Oracle Apex 3.1 & 3.2,4.0, Oracle BI Publisher, Jdeveloper, TOAD, Oracle Financials 11i (AR, AP, PM ) Microsoft Project Visio.

Confidential, Raleigh, NC

Data Integration Consultant

Responsibilities:

• Analyzes business requirements, technical specifications, source repositories and physical data models for ETL mapping and process flow
• Accountable to build, manage and execute ETL development plans on department initiatives
• Works closely with the Data Architect and Business Analyst to ensure designs meet the requirements
• Responsibility for conversion of school district legacy programs into oracle Apex screens.
• Provides guidance on project scope to ensure successful integration with corporate architecture and infrastructure environments
• Worked in CTE system to integrate various school districts on data integration.
• Responsible for requirement analysis, client interaction and preparation of Technical document.

Environment: Oracle, Teradata, PL/SQL, Oracle BI Publisher, Oracle Portal, SQL*Plus, Oracle 10g, TOAD, Microsoft Project, Visio.

Confidential, Miami, FL

DW technical architect

Responsibilities:

• Worked as a DW technical architect position for Healthcare system and biotechnology management system Amisys Advance insurance system conversion from in Oracle platform Apex system integrated with Amisys advance Appworx, cypress and etc.
• Overall responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces (ETL). Responsible for the design and build of ETL and conversion components
• Analyze business requirements, technical specs, source repositories and physical data models for ETL mapping & process flow
• Managed a team of 6 programmers have excellent business knowledge on Amisys Advance conversion procedure, claims process, medical management, billing, AR, AP, adjudication processes
• Setting up of Unit / Integrated testing of interfaces (ETL) & documentation.
• Evaluated many health care systems such as Data Ocean, Case tracker, click4care

Environment: Oracle APEX 2.0/3.0, PL/SQL, Informatica, SAS BI Suite, Oracle Portal, SQL*Plus, Oracle 10g, TOAD, Microsoft Project, Visio, Amisys Advance, Appworx, cypress

Confidential, Portland, Oregon

Senor Oracle analyst/developer

Responsibilities:

• Responsible for analysis of client requirements, design and development for various campaigns of a leading consulting company in Portland, Oregon using Oracle 8i and 9i DB, Data integration on HP UNIX 11.0 platform
• Used Various ETL Tools to build ETL / conversion components
• Analyze business requirements, technical specs, source repositories and physical data models for ETL mapping & process flow
• Procurement, CRM modules and Order Management (OM) using PL/SQL, Oracle APIs, Oracle Reports, Oracle Forms, Discover, APEX, Workflow and AIM
• Responsible for documenting and defining project management enhancements, technology architecture and schema changes, tuning methodology, coding standard, new tools analysis and testing

Environment: Oracle 8i, 9i, Oracle e-business suite (11&11i), TOAD, Microsoft Project, Visio, PL/SQL, HTMLDB, SQL*Plus, Designer2000Rel. 2.1, Forms 4.5, Reports 2.5, HP UNIX 10.0 platforms