SUMMARY

• Over Fourteen 14 years of experience in Information technology, worked on numerous Data warehouse Business Intelligence projects.
• Excellent experience in Data Warehouse Business Intelligence Architecture, Business System Analysis, Requirements gathering, Software design development, Data Architect Project management.
• Excellent experience in Financial, Wealth Management, Banking, Manufacturing, Student Information and Inventory Management Domains.
• Extensive experience in Data warehousing as Data warehouse Analyst, Data warehouse Architect, Data Architect and ETL Specialist.
• Extensive experience in analyzing and documenting business requirement and system functional specifications including gap analysis, conducting JAD/review meeting sessions with various stakeholders and end users.
• Extensive experience in data profiling and data quality frameworks.
• Extensive knowledge on Enterprise data warehouse, Data Marts, operational and analytical environments.
• Excellent experience in supporting and implementing projects using Agile, Software development life cycle SDLC , Rational unified process RUP methodologies.
• Excellent experience in Data Migration, Data integration and providing support to the Applications.
• Strong Data Modeling experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling using tools like Erwin.
• Expertise in implementing Ralph Kimball's and Bill Inmon methodologies for architecting the data warehouse.
• Excellent experience in Design and Implementing ETL processes to load data using Informatica 9.x/7.x/6.x/5.1,Abinitio,SSIS, Microsoft DTS, and Oracle Warehouse Builder 9.2.
• Excellent experience in dealing with wide variety of databases like Oracle, Teradata SQL server.
• Experience with extracting data from various source systems like ERP Sources SAP, Mainframe , flat files etc.
• Experience in designing and developing generic frameworks to extract data from various source systems.
• Excellent experience in ESSBASE, SAP BO 4.0/XI, Cognos, SSAS, SAS, Crystal reports.
• Excellent experience leading teams and managing projects based out of offshore locations.
• Extensive track record as a lead and team player with excellent communication and interpersonal skills.
• Excellent experience in leading teams and managing projects.

TECHNICAL PROFILE

• ETL TOOLS : Abinitio, Informatica Power Center 9.x/7.x/6.x, SSIS, Microsoft DTS
• SQL Loader, Oracle Warehouse Builder, Talend
• B.I. TOOLS : ESSBASE, Cognos, SAP Business Objects 4.0/ XI/6.x/5.x, Crystal,
• SAS,SSAS
• Languages : Java 2.0, C, C , COBOL
• Operating Systems : Unix Sun solaris, Hp-Ux Windows NT/XP/2000/95, MS DOS
• RDBMS : SQLServer 2008/2005,Oracle 11g/9i/8i/7.x, Teradata, DB2
• GUI : Visual Basic 6, Developer 2000
• Modeling Tools : Erwin, Designer 2000, Rational Rose, Power Designer,
• Enterprise Architect
• Methodology : OOAD, UML
• Web Server : TOMCAT 4.0.
• Application Server : IBM Web sphere 3.0, Web logic.
• ERP : SAP-ABAP, SAP BW
• Project Management : MS Project
• Others : Toad, Putty, Hummingbird, Remedy, Clear case, Harvest, Argent,
• Roshade, Abinitio Data Profiler, Control-m scheduler, SSH, Subversion.

PROFESSIONAL EXPERIENCE

Confidential

Roles Responsibilities: Data Warehouse Architect /Project Lead

• Conducted JAD sessions with Business User Groups, Subject Matter Experts, and IT Groups to gather business and user requirements.
• Designed logical, physical data models and architecture for CPDW.
• Conducted POCs for Data Mart ,SSAS Cubes SAP BI 4.0 Dashboards.
• Responsible for all design code reviews activities.
• Created SSIS packages to load the data from JDE CRM source systems.
• Helping the team in resolving technical challenges during the project life cycle.
• Co-ordinate with onsite offshore teams during the project life cycle.
• Establish standards and guidelines in accordance with customer guidelines and ensure the implementation is in line with architecture and design.
• Involved in writing User Acceptance Test Plans according to Business IT Specification documents.
• Conducting User Acceptance Testing UAT , developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Maintain track project team member's activities such as effort resources management.
• Preparation of SOW, providing estimation for the project tasks .

Environment: SSIS, SSAS, SQL Server, SAP BO 4.0, Windows NT, Erwin

Confidential

Roles Responsibilities: Data Warehouse Architect /Project Manager

• Management of process lifecycle, project risk and remediation Prepared project Plan, estimation resource loading activities.
• Review architecture, design and development activities.
• Review design and technical documents to make sure they fulfill the business requirements.
• Provided technical guidance to the Team on all the design and development activities.
• Due diligence, requirement gathering, solution design and roll-out.
• Prepared data migration approach for migrating the date from V5to IDS system.
• Key player in confirming the approach for reporting layer approach and implementation.
• Establish standards and guidelines in accordance with customer Guide and ensure the implementation is in line with architecture and design

Environment: Informatica 9.1, Oracle 11g, SAP BO 4.0, Windows NT, Erwin

Confidential

Roles Responsibilities: Data Architect

• Create Data flow Diagrams DFD , Business Process flows and Data process models.
• Designed logical physical data models for integrated Data warehouse using Erwin, which is in 3rd normal form.
• Designed star schema logical physical data models for integrated Data marts.
• Designed Dimensional and Fact table to meet TR HUB requirements reporting needs.

Environment: Talend, Oracle 11g, Erwin,UNIX, Windows NT.

Confidential

Roles Responsibilities: BIDW Architect/Sr. Business System Analyst/ Project Lead

• Conducted JAD sessions with Business User Groups, Subject Matter Experts, and IT Groups to gather business and user requirements
• Extracted, discussed, and refined business requirements from business users and team members. Also, authored functional requirements documents by interacting with development team.
• Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation and conducted feasibility study and performed impact analysis for proposed enhancements.
• Creating Business requirements documents BRD , IT Specification documents using Software Development Life Cycle.
• Update the Architecture as per new business requirements.
• Design and development of ETL packages Reports for business.
• Created interface requirements documents which became the baseline and standard for all data exchanges.
• Creating and maintaining all the project related documents in the knowledge link repository.
• Used Data warehousing for Data Profiling to examine the data availability and correctness of the data.
• Provide source to target mapping documents from ETL standpoint documents and also provide the reporting needs to the team.
• Co-ordinate with the technical team during the construction.
• Involved in writing User Acceptance Test Plans according to Business IT Specification documents.
• Conducting User Acceptance Testing UAT , developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Write and execute positive and negative UAT test cases to ensure the data accuracy in warehouse.
• Interface with internal customers in developing analytical reports using Business Objects, Cognos ESSBASE Hyperion.
• Provided training to users on new interfaces features of the application.
• Tracking of project related activates to producer KPI's.
• Maintain track project team member's activities such as effort resources management.

Environment: Informatica 9.1, Oracle 11g, C, Java, Power Designer, Enterprise Architect, Clear case, Business Objects, Cognos, Hyperion, UNIX, Windows NT.

Confidential

Business System Analyst/ Data Architect / Onsite Lead

Roles Responsibilities:

• Conducted JAD sessions with Business User Groups, Subject Matter Experts, and IT Groups to gather business and user requirements
• Extracted, discussed, and refined business requirements from business users and team members. Also, authored functional requirements documents by interacting with development team.
• Conducted GAP Analysis in understanding how the upgraded system carries out the business functions and assists in ensuring the timely and effective implementation and conducted feasibility study and performed impact analysis for proposed enhancements.
• Creating Business requirements documents BRD , System requirements documents SRS using waterfall Software Development Life Cycle.
• Conducting feasibility of the project and provide high level estimates to portfolio manager.
• Creating User narrative document using Agile Software Development Life Cycle.
• Responsible for maintaining product backlog, Burn down charts, implementation and release plans.
• Responsible for printing story cards, organizing them in the agile room, and help the team to burn down the task hours on daily basis.
• Responsible for arranging sprint planning, sprint prioritization and retrospective meetings.
• Creating and maintaining all the project related documents in the knowledge link repository.
• Reduced the data warehouse footprint from 53 data bases to 11 databases.
• Updated logical physical data models for Data warehouse using Erwin, which is in 3rd normal form.
• Designed star schema logical physical data models for Data marts.
• Integrated multiple data models into a single model as a part of source system integration effort.
• Working on re-modeling effort as COAF is moving towards Enterprise data model.
• Reverse engineered legacy data models to support ongoing enhancements to existing databases.
• Responsible for collecting and uploading metadata to the model mart repository.
• Responsible for maintaining Data model repository for Data warehouse group.
• Designed Dimensional and Fact table to meet various projects team's requirements in data warehouse portfolio.
• Create Data flow Diagrams DFD , Business Process flows and Data process models.
• Designed and incorporated new ETL architecture standards to meet COF enterprise standards.
• Used Microsoft DTS and Abinitio to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Used Data warehousing for Data Profiling to examine the data availability and correctness of the data.
• Used SQL queries and Abinito data profiler to profile data on Operational Reporting Environment ORE , Data warehouse and Data marts.
• Conducted gap analysis by looking at the existing DTS packages and Abinitio graphs.
• Helped technical team in converting existing DTS packages to Abinitio graphs.
• Key player in migrating the data from SQL Server 2000 to 2005 to support Operational reporting environment.
• Key player in migrating the data from SQL server 2000 to Teradata to support new Data warehouse.
• Provide source to target mapping documents from ETL standpoint documents and also provide the reporting needs to the team.
• Co-ordinate with the technical team during the construction.
• Co-ordinate between the various project teams Upstream source systems , Dealer, Direct and Reporting teams for a smooth project releases.
• Involved in writing User Acceptance Test Plans according to Business Specifications.
• Conducting User Acceptance Testing UAT , developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Write and execute positive and negative UAT test cases to ensure the data accuracy in warehouse.
• Created interface requirements documents which became the baseline and standard for all data exchanges.
• Interface with internal customers in developing, migrating operational and analytical reports using Business Objects, Crystal, SAS and Adhoc queries.
• Performed report validation by writing SQL queries using Microsoft SQL query analyzer and TOAD on an Oracle 10g databases. Performed data audits to ensure accurate data cleansing and following of proper procedures across business units.
• Capture and Formulation of Business Rules and delivery of Business Rules Templates.
• Co-ordinate with the onsite and Offshore teams.
• Document the business and technical metadata for the projects.
• Review and approve Design and technical design documents to make sure they fulfill the business requirements.
• Supported QA in preparing test strategies, test scenarios and test scripts.
• Review and approve test plan, test cases and test conditions to be used in testing based on business requirements and technical specifications.
• Provided training to users on new interfaces.
• Provide post implementation support for the projects.

Environment: Abinitio, Microsoft DTS, SSIS, SQL server 2000/2005, Oracle, Teradata,

• Visio, Clear case, Control-M scheduler, Erwin, Business Objects, SAS, UNIX, Windows NT.

Confidential

Onsite Tech Lead

Responsibilities:

• Gathered business and technical requirements for project.
• Provided technical assistance to the team on complex mapping issues.
• Designed the reusable transformations for the data validation across the release.
• Designed various mappings to load the data from source to target ERP
• Co-ordinate between the various project teams Data Acquisition, Reference Data, ERP team and Reporting teams for a smooth data flow process.
• Involved in code reviews.
• Involved in ETL code promotion across different environments development, testing and production .
• Defined ETL development standards document and the best practices to be followed during construction.
• Designed Unit Test environment for the team to test the ETL mappings.
• Created the Process/Support Documentation.

Environment: Informatica Power Center 7.1.2, UNIX, Oracle 9i, Teradata, Windows NT.