Experience Summary

• Senior data warehouse consultant with 12 years' of experience with multiple Fortune 500 customers. My last seven years engagements were mostly consulting for DWH projects involving MDM, Data Quality, Data Governance, Dimensional Modeling, ETL Process, BI reports Dashboards.
• Well versed with SDLC spanning from requirements to deployment, facilitating JAD-sessions, conducting workshops, organizing UAT, change management, user training, issue management and continuous support involving multiple-skilled teams and senior decision takers. Have hands-on expertise on business implementation, relationship building, financial targets and political undertakings.
• At enterprise level I have been involved in tasks related to data architect, business process modelling BPM , charting roadmaps, work-breakdown, organizational change management, planning and scheduling. Been involved in performing data and capability assessment for various enterprise wide projects and involved in leading the selection, configuration and currency of data tooling for the enterprise for DWH and BI programs. Currently I am responsible and accountable for developing and maintaining MDM data standards, data quality and data lifecycle for the enterprise.

DWH BI Skills Matrix:

DETAILED PROJECT EXPERIENCE

Confidneital

Role: Business Data Analyst

Project Description:

• Confidneital is part of the enterprise wide program, aiming to build a single source of SPo1 Customer data gaining benefits via sharing consolidated account base across Russian businesses and support sales reporting across Po1 snacks, beverages, juices and WBD dairy and beverages . iSales is being used in Russia as a SFA solution for Indirect sales Distributors Dealers data which is currently Po1 and planned to be rolled out to WBD as well.
• The core benefits driven by Customer MDM is enabling a joint customer base that consolidate, harmonize and merge all direct and indirect customers from all Russian businesses. This allows different categories to understand a potential for business growth through increasing sales to customers not covered by specific category but used by others, e.g. start selling Pepsi products to dairy customer and vice versa.
• Another supplementary non-tangible benefits is a contribution for building integrated sales reporting. This benefit will be achieved through decreasing manual efforts for consolidating multiple customer files into one. Instead of doing this Customer MDM will provide a mechanism to do this in automated fashion.
• MDM will receive Customer data from SAP, iSales and Oracle BI. The source data will be standardized using BODS Russia Service.
• The standardized data will hit KLADR Russian Government Database to validate address component. If there is a hit the records will be enriched with KLADR ID. If there is no hit then records will be spit out in data Quality Reports.
• Break Keys will be used to group these records in logical match sets.
• Matching will be done using SAP Match Transform Tool and numerical score will be generated indicating strength of match.
• According to matching logic the records will be designated as Driver, Passenger or Unique record. Golden master will be updated as per survivorship and trust framework.
• X-Reference tables will be updated.

Responsibility:

• Understand Teradata MDM functionality and architecture.
• Interacted with Russian business users to gather the Customer data requirements.
• Identify Customer Data Elements to be used for the project and mapping to Party Model
• Help data modellers in finalizing the party model.
• Analysing KLADR database to be used as third party Customer and Address validating source. KLADR is Russian Tax Authority database providing authenticated Customer and Address data.
• Creating specification documents for following interfaces:
• KLADR to SAP Tables will act as reference table and refreshed every quarter
• Matching SAP/iSales/Oracl Customer Data and storing in Sandbox.
• Survivorship Trust Framework to update the MDM Golden Master.
• Any reportable data element will be mapped to Common Format View for enterprise reporting.
• Data Analysis which includes executing data queries and performing data research.
• Liaise between the development team and business users in order to define clear and precise requirements.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Documenting business requirements in Functional Document and Mapping Document.

Tools:

Teradata MDM, Teradata, Teradata SQL Assistant, BODS, Oracle iSales, SAP

Operating System:

Windows 7

Team Size:

15-20 Members

Confidneital

Role: Sr. Business Analyst-BI Data Architect

Confidential has been identified as an Eaton initiative to deliver business analytics across the organization. With Siebel and the numerous ERP systems MFG/Pro, Oracle, SAP, etc. as sources of transactional information, the program's objective is to provide standardized reporting analytics that provide the business with consistent insight into their transactional systems. By aligning the individual business objectives into a comprehensive organized roadmap, Eaton believes that this will lead to more effective sale pipeline processes. Additionally, rather than spending efforts on individual initiatives to capture, consolidate present the data, a coordinated aligned approach will help the organization realize program goals quicker reduce duplicate investments. To achieve these goals following foundational components /projects were undertaken:

1 Project 1: Oracle MDM

• CDH Customer Data Hub module of Oracle MDM Oracle E-Business suite R12.1.3 as its customer management system to maintain cleansed, enriched and verified customer data throughout Eaton. Currently MDM receives data from the disparate ERP sources and further validates, cleanse and enrich customer data before sending to enterprise customer repository.
• Siebel CRM would also like to leverage MDM's capability to maintain the authentic and complete data for a customer. Once a customer has been created in Siebel, it would be sent to CDH for customer validation and enrichment as detailed below.
• Siebel to send newly created customers to CDH Oracle MDM .
• CDH to pre-process the batch for 'Record Completeness Data Quality using OEDQ ' and record de-duplication.
• CDH to send the pre-processed records to 3rd party D B Dun Bradstreet to get Duns Number and Duns Confidence Code
• Using Duns Number and Duns Confidence code run auto-merge/manual merge using matching rules.
• Enrich the record using the D B World-base data to create Master Customer Record for Eaton enterprise.
• Send the validated customers back to Siebel with correct Duns Number, Duns Confidence Code and any enriched information required.

Responsibility:

• Understand MDM functionality and Oracle TCA architecture and how it can be used in the current project.
• Interacted with business users to gather the requirements.
• Interacted with business users to gather the reporting requirements for data quality for 'Record Completeness' and using OEDQ for data profiling and QlikView for reporting.
• Identify Customer Data Elements to be used for the project.
• Data Analysis which includes executing data queries and performing data research.
• Liaise between the development team and business users in order to define clear and precise requirements.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Documenting business requirements in BRD SRD.
• At Enterprise Level perform data and capability assessment for various enterprise wide projects.
• Lead the selection, configuration and currency of data tooling for the enterprise for DWH and BI programs.
• Responsible and accountable for developing and maintaining data standards, data quality and data lifecycle for the enterprise.

Tools:

Oracle MDM, QlikView, PL SQL Developer, OEDQ Oracle Enterprise Data Quality

Operating System:

Windows 7

2 Project 2: Enterprise Data Quality Reporting

Data Quality:

• Data quality being foundational to BI Analytics, a systemic approach to assess and improve quality of underlying data was a key to success of the analytics program. This project outlines Data Quality Framework spanning across systems already integrated to OBI EE, and systems in-scope for integration to OBI EE. Following are the main aspect of the framework and my role was to perform analysis and document the requirements:
• Source System Extract Screening Detective Data Quality - Addressing data quality prior to data being loaded to BI environment
• Ongoing Process for Data Health Check using Qlikview Client Preventive Data Quality - Addressing data quality prior to data being available to end users
• Ongoing Data Quality for TPH using Qlikview Client
• Ongoing OBAW Data Health Dashboard - Addressing quality of data loaded in OBAW.

MDM:

Other component to make PowerINSIGHT successful was including enterprise repositories for customer product data MDM . This customer product data will be used by PowerINSIGHT as a key source for allowing the normalization of customer product data across all Eaton plants. This was to be done using third party data from D B Dun Bradstreet .

OBIEE:

Other foundational component was to include the Oracle BI Suite OBIEE Sales, Pricing, Order Management, Services, etc. of Analytics modules. To support future upgrades and expediting deployment, Eaton needs to ensure reliance on the out-of-the-box OOTB solution as much as it can. Extending the solution with additional attributes or reports is expected, but customizing the OOTB should be avoided.

Responsibility:

• Interacted with business users to gather the data quality requirements and corresponding business rules.
• Interacted with business users to gather the reporting requirements for data quality health reports.
• Create comprehensive data element matrix and bundle them as per their dimensions. This will form the master data element list.
• Data Analysis which includes executing data queries and performing data research.
• Liaise between the development team and business users in order to define clear and precise requirements.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Documenting business requirements in BRD SRD.
• At Enterprise Level perform data and capability assessment for various enterprise wide projects.
• Lead the selection, configuration and currency of data tooling for the enterprise for DWH and BI programs.
• Responsible and accountable for developing and maintaining data standards, data quality and data lifecycle for the enterprise.

Tools:

Business OBIEE, Qlikview, Oracle Exadata, PL SQL Developer, Cognos, Oracle MDM

Operating System:

Windows 7

Confidneital

Role: Product Manager

Project Description:

• Confidneital is a leading auto Solution Company in India, engaged in multi-brand automotive sales and service network in India. They wanted to enhance the overall experience of owning a car while optimizing the cost of ownership. Carnation wanted TCS to help automate the network operation and customize e-commerce solution based on the Tata e-Commerce Platform TEP . TEP is itself based on Apache OFBiz The Apache Open for Business Project platform.
• Joined Phase 2 of the project where carnation wanted the extension products functionality using new TEP platform and further implementing new business functionality.
• The tasks undertaken as part of the project were:
• Migration from TEP 1.0 to TEP 1.2
• Modernize the e-commerce site with industry features like multiple images, lazy loading, multiple payment gateways and enhanced customer browsing.
• Building new functionality like online insurance, roadside assistance, car part online sales.

Responsibility:

• Data Base Migration to new platform
• Business Functionality Ownership
• Quality Assurance

Tools:

TEP 1.2 Tata E-Commerce Platform , Apache OFBiz The Apache Open for Business Project platform, MYSQL 5.5, Java, Bugzilla for defect reporting.

Operating System:

Windows XP

Confidneital

Position: Business Analyst

Responsibility:

• Part of TCS Assessment Team to determine business goals, outline approach and scope for the initiative.
• Interacted with business users to document Voice of Customer.
• Perform feasibility study on cost, scope, rollout plans, Scope Of Work SOW , Team size, Communication Plan and Service Level Agreement
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.

Tools:

MS-Office

Operating System:

Windows XP

Confidneital

Position: Business Analyst BPM Data Architect

Responsibility:

• Part of Business Team to set business goals, approach, scope and provide support to IT and testing team as an SME.
• Interacted with business users to gather the requirements and business logics by documenting following in RSM.
• Extraction Raw data required for project.
• Standardization Coverage mapping
• Distribution State Fee Surcharges, Assumed/Ceding business, Escrow Accounts, Commissions, Quota Share.
• Calculation
• Detailed Financial Sent to data mart for reporting
• Summary Financial Create GL file to be consumed by CFO system.
• Location complexity analysis for phased rollout and approach.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Involved in Functional testing and Large Volume Testing as part of business team.
• Create and manage metadata for P C area.
• Involved in reconciliation of the system and problem solving if there are discrepancies.
• Involved in defining the metadata need and approach for the enterprise
• Perform data and capability assessment for the enterprise.
• Lead the selection, configuration and currency of data tooling for the enterprise for DWH and BI subject area.
• Responsible and accountable for developing and maintaining data standards, data quality and data lifecycle for the enterprise.
• Involved with Enterprise Architecture Unified Architecture USAA for complex high-dollar business and IT initiatives.

Tools:

Business Object, SAS, MS-Office, Oracle, Toad, RuleXpress, Mainframe, Mastercraft, C .

Operating System:

Windows XP

Team Size:

15 Members

Confidneital

Position: Business Data Analyst

Position: Business Data Analyst

Responsibility:

• Interacted with business users to gather the requirements and business logics.
• Analysed source from Moody's Risk Analyst system to create a mapping to the target downstream systems.
• Defined to implement the required business transformation rules and logic.
• Data Analysis which includes executing data queries and performing data research.
• Liaise between the development team and business users in order to define clear and precise requirements.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Conducting JAD sessions with Business Users and SME's when required.
• Documenting business requirements in BRD SRD.
• Involved in Functional testing and assisting the Business user in UAT
• Conducted product demo and user training
• Creation of training manual and process document helping user to test during UAT and pilot.
• Involved in reconciliation of the system and problem solving if there are discrepancies.

Tools:

MS-Excel, Oracle, Visual Studio for Office.

Operating System:

Windows XP

Confidneital

Position: Business Data Analyst Product Lead

Program Objective:

Working with Information Management division to support all data related IT services to the enterprise. The IM team develops and maintains Data Warehouse for 'The Hartford Financial Services Inc'. I have mainly worked for Personal Lines and Commercial Lines division to enable business to take major analytical decisions from the reports generated from the Data-warehouse.

Commercial Lines Projects:

Commercial lines had 3 major data warehouse Oracle, Teradata SAS and one legacy mainframe system. The major flaw of these systems is lack of authoritative source and disparate business rules. The goal was to create a single comprehensive data store by consolidating various applications into a common platform. This included unifying disparate business rules by applying conformity process and developing efficient manufacturing and access method as well as retiring the silo-ed systems. This would benefit the business in getting correct information for analysis and decision making.

1 Project Name:

FLOW Analysis

Project Role: Business Analyst/Data Analyst

FLOW Analysis Objective: The primary objective of Flow Analysis is to deliver Flow Reports currently residing in Hartsource Data Mart Siebel and Microstrategy Report Platform and moving them all to a single report platform of Business Objects. Currently FLOW provides detail analytical information on tracking the path of how new business policies come in to the Hartford. Some of the key measures of Flow are determining counts and premiums for Quotes, Submissions and Issued Policies as well as providing various ratios such as Quote ratio, Declined ratio, Hit ratio, and Yield ratio.

Confidneital

Project Role: Business Analyst/Data Analyst

ICF Analysis Objective: : The primary objective of ICF is to deliver Flag Stop Reports currently residing Microstrategy Report Platform and moving them all to a single report platform of Business Objects. ICF release relates to Underwriters Question Answers Flags raised during time of submission of an Insurance Quote

Personal Lines: To develop/enhance new/existing applications in Data warehousing and Actuarial area to cater the growing business requirements for Auto and Home.

Confidneital

Project Role: Business Analyst/Data Analyst

PL Motorcycle Objective: This project will build a motorcycle product which will be offered for new business in the American Association of Retired Person AARP and AARP-thru-Agents business segment. The policies will be written in Universal Auto PNG Rate Plan and will be available for internet business only. IM will add the new elements, which are being incorporated in the front-end systems, to different loads, datamarts and business object universes.

Confidneital

Project Role: Business Analyst/Data Analyst

Auto Quote Consolidation Objective: The goal of the project is to consolidate the two pathways that exist today for Direct and AARP. It will also leverage the recent work done with the Affinity framework to create one quoting workflow process for new business and sales. Also as part of the project, the experience will be wrapped with the right branding i.e. AARP, any new Affinities that are introduced, NASCAR, HIG Hartford Insurance Group etc. . IM will add the new elements, which are being incorporated in the front-end systems, to different loads, datamarts and business object universes.

Confidneital

Project Role: Business Analyst/Data Analyst

UCX Home Objective:

The UCX Home project will deliver an online quote capability for homeowners, condo and renters insurance for Direct and AARP business segment. This includes introducing a bundled homeowners and auto product offering and integrating homeowners within the existing auto flow cross-sell . Home will enable PL to achieve its cross-sell goals, increase operational efficiencies through the use of a low-cost business channel, improve retention rates, and enhance The Hartford's internet capability.

Responsibility

• Current state, impact and gap analysis by elicitation with Business Users and SME's to identify the data being used for their analysis and reporting requirements.
• Conducting JAD sessions with Business Users and SME's when required.
• Responsible and independent charge of business process and data analysis for Account, Role Player and Activity components.
• Creation of current state bus matrix by identifying attributes facts and analytical process. These attributes were segregated into their respective dimensions and normalized as per insurance industry standards. The facts were analyzed and normalized to lowest grains. Analytical processes were represented in the bus matrix with respect to their dimensions.
• Documenting business requirements in BRD SRD.
• Data Analysis which includes executing data queries and performing data research.
• Taking a view of reportable data and find out how it will tie back to source systems.
• Creation of Data Mapping Documents for documenting business transformation rules and logic for ETL extraction. These involved approvals from the data stewards for Business Names, Business Definitions and Oracle Names.
• Liaise between the development team and business users in order to define clear and precise requirements.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Creation of Test Plans, Test Cases, Test Scripts and Expected Results using Quality Center.
• Involved in Functional testing and assisting the Business user in UAT
• Create system use cases for data load and validation for complex scenarios like 'Rate of Change', 'Time Warp Views', 'Month End Snapshots' etc.

Tools Used

Oracle Exadata, Teradata, Teradata SQL Assistant, MS-VISIO, TOAD, Quality Center, Adaptive Metadata Tool, Trillium, Informatica, Business Object

Methodology Commercial Lines

Agile-Scrum Methodology

Personal Lines Waterfall Model

Confidneital

Position: Business Analyst

Responsibility:

• Interacted with business users to gather the requirements and business logics for the new interfaces.
• Analyzed source systems SQL server, XML and COBOL files from Andesa third party vendor and creating a mapping to the target down stream systems.
• Defined to implement the required business transformation rules and logic for ETL development.
• Data Analysis which includes executing data queries and performing data research.
• Written the technical specifications document and data mapping document.
• Involved in Designing exception handling and data cleansing / standardization procedures.
• Liaise between the development team and business users in order to define clear and precise requirements for ETL development for Interfaces.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Created Test Plans, Test Cases, Test Scripts, Expected Results, Assumptions and Validations.

Tools:

Datastage, UNIX, SQL Server 2000, Oracle 9i/10g, TOAD

Operating System:

Windows XP, UNIX, Main Frames, COBOL

Confidneital

Position: Business Analyst / Consultant

Responsibility:

• Analysis of current systems and business functionality for application like adjudication, finance, LINKS, IVR to carry on the scoping and estimation for scope of work. Conducting JAD sessions and interview with various enterprise wide business users to understand the functionality and create business requirement documents for our testing team.
• Evaluate, review, design and plan the developmental activities for business needs.
• Design the STP test structure using Mercury Quality Centre by analyzing each application.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.
• Onsite Offshore coordination for resolution of query as well as task assignment.

Tools:

Mercury Quality Centre

Confidneital

Role: Product Lead and Business Analyst

• Business analysis and requirement gathering Travel onsite for 4 weeks to have sessions interview with customers for each release of OpenWire. The product owner and end user gave us the new requirements which were discussed and estimated according to agile methodology. Business requirement documents were created and sign off taken from the customers.
• Conduct daily stand-up meeting as per Agile/Scrum.
• Complete product ownership for delivery and single point of contact for customer interaction.
• Team Management, task assignment and project performance metrics.
• Manage assumptions, dependencies, conflicts and prioritization.
• Creation Execution of test cases, traceability matrix and analysis.
• Understanding and management of risks and issues.
• Test data analysis and test bed preparation.
• Coordinating development work for the team and supporting them with business functionality.
• Managing testing environment matrix and prioritization. Creating these environments in virtual machine using VMware.
• Appraisal Performance rating for the team as well as recruitment for project.

Hardware:

Dell Precession 690 with Dual Processor, 4 GB Memory dual monitors

Operating System:

Windows XP, Windows 2003 Server

Languages:

Java, Hibernate, Echo2 AJAX Framework , WITSML, Apache-Tomcat

Special Software:

Oracle 9i Oracle 10g Database ,SQL Server, MS-Project, MS-Excel, MS-Word, MS-Visio, Mercury Quality Centre Test case planning, writing execution , PeopleSoft Defect reporting and management tool , CALIBER Requirement gathering management tool , Vmware Creating virtual machines for testing environment

Confidneital

Position: Configuration Manager

Responsibility

• Configuration manager activities involved
• Administrator for Oracle 9i server.
• Administrating of Weblogic 8.1, Apache Tomcat servers.
• Onsite-offshore coordination
• Software delivery to customer by using version control tool VSS
• Implementing the application code to QA and Production environment for quarterly release.
• Backup strategy plans for Oracle Database.BCP Backup Continuity Plan activity carried out for the project.

Operating System:

Solaris 8, Windows XP, Windows 2003 Server

Languages:

Java, Oracle 8i/9i database, Tuxedo, CORBA, Weblogic 8.1, Apache Tomcat, C

Special Software:

Master-craft, PL/SQL, Kawa, VSS

Configuration Management Team Size: 4 Members

Confidneital

Position: Developer

Responsibility

• Data Modelling and UML Design of the components.
• Existing Data model analysis and proposing the new logical data model.
• Preparation of Low Level Design.
• Construction and Unit Testing of Account Management and Finance module implementing business logic for EJB's
• Modeling and construction of Credit Note Rule batch.
• System Testing and involved in PAT as well as making of User Manual.
• Documentation as per ISO 9001 CMM Level 5 Standards.

Operating System:

Windows 98

Languages:

UML, Java, EJB, JSP, Struts Framework, XML, Oracle 9i

Special Software:

Master-craft, PL/SQL, Oracle 9i AS, Edit plus, J-developer