Experience Summary

• I have 11 years of experience as IT consultant working for Fortune 500 companies in various capacities. My last six years engagement was consulting for data warehouse projects involving ETL, dimensional modeling, reporting tools, and data quality data governance.
• I am well versed with all aspects of software development life cycle spanning requirements to deployment, imparting user trainings, facilitating JAD sessions, conducting workshops, organizing UAT, manage data quality and data governance, change management, issue management and continuous support involving multi skilled teams and senior decision takers with hands-on business implementation, relationship building, financial targets and political undertakings. I have an extensive experience with data warehouse projects involving dimensional modeling, ETL, BI reports Dashboards, Data Quality, Data Governance, Master Data Management Customer
• My work experiences are primarily in following roles
• Business Analyst
• Data Analyst
• System Analyst
• Product Owner
• I have worked primarily in the following domains
• Insurance P C
• Banking Risk Management
• Manufacturing ERP
• Energy - Oil Gas Drilling Completion
• Retail

PROJECT EXPERIENCE

Confidential

Role: Sr. Business Analyst

Project Description

• 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.
• Confidential uses 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.
• Confidential is a diversified power management company with more than 100 years of experience providing energy-efficient solutions that help its customers to effectively manage electrical, hydraulic and mechanical power.Confidential is a global technology leader in electrical components, systems and services for power quality, distribution and control hydraulics components, systems and services for industrial and mobile equipment aerospace fuel, hydraulic and pneumatic systems for commercial and military use and truck and automotive drivetrain and powertrain systems for performance, fuel economy and safety. Confidential has 2012 sales of 21.8 billion.
• 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.

• Responsibility:
• Ongoing OBAW Data Health Dashboard - Addressing quality of data loaded in OBAW.
• Ongoing Data Quality for TPH using Qlikview Client
• Ongoing Process for Data Health Check using Qlikview Client Preventive Data Quality - Addressing data quality prior to data being available to end users
• Source System Extract Screening Detective Data Quality - Addressing data quality prior to data being loaded to BI environment
• PowerINSIGHT 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:
• 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:
• 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.
• 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.

Confidential

Position: Business Analyst

• Confidential is an Confidential consumer electronics corporation headquartered in Richfield, Minnesota. Best Buy is the world's largest multi-channel consumer electronics retailer with stores in the United States, Canada, China, and Mexico. Best Buy has over 1,400 stores and locations in the Confidential, including large-format and Best Buy Mobile stores. Geek Squad is a subsidiary of Best Buy. Geek Squad provides services in-store, on-site, and over the Internet via remote access, and also provides 24-hour telephone and emergency on-site support.
• Best Buy wanted to cross sell Geek Squad services to other retail online stores like Amazon, Wal-Mart, Target, Sears etc. Once the customer shops for any electronic product from these websites, he will get the option to configure the services of Geek Squad at bundled rates.

Responsibility:

• Part of Client's 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, phased rollout of the project and submit Scope Of Work to Best Buy.
• Manage assumptions, dependencies, conflicts and prioritization.
• Understanding and management of risks and issues.

Confidential

Position: Business Data Analyst

• FIRS LFA Modernization program objective is to address limited business knowledge expertise, reduce complexity and significantly improve agility for new product launch speed to market and regulatory changes. The proposed solution was creating a new FODS Financial Operation Data Store to replace the silo old systems by removing black boxes and streamline the business process and data flow. Much emphasis was given on coverage standardization across all P C and CFO area for both Premium and Loss data. Also coverage mapping and definition was proposed to be managed and maintained by the P C Product Admin System and controlled by business.
• Another goal was to externalize business rule and put them in a rule engine to give direct insight to data and rules. This will increase business understanding of rules and reduce IT time in answering business questions.

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.
• Summary Financial Create GL file to be consumed by CFO system.
• Detailed Financial Sent to data mart for reporting
• Calculation
• Distribution State Fee Surcharges, Assumed/Ceding business, Escrow Accounts, Commissions, Quota Share.
• Standardization Coverage mapping
• Extraction Raw data required for project.
• 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 program.

Confidential

Position: Business Analyst

• Confidential was an initiative to address the limitation of the current financial analysis business process, in order to effectively support credit management's business strategy for maximizing efficiencies and reducing overall cost.
• Sponsored by Risk Architecture group, the CAT initiative entails an end-to-end redesign of credit financial processes, including the streaming of multiple, disparate application currently used in various geographies. The benefit includes process improvement, cost reduction, integration, standardization and automation.

Position: Business Data Analyst

Responsibility:

• Interacted with business users to gather the requirements and business logics.
• Analyzed source from Moody's Risk Analyst system to create a mapping to the target down stream 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.

Confidential

Position: Business Analyst

• Working with Information Management division to support all data related IT services to the enterprise. The IM team develops and maintains Data Warehouse for Confidential I have mainly worked for Confidential division to enable business to take major analytical decisions from the reports generated from the Data-warehouse.
• 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.

Confidential

Project Role: Business Analyst/Data Analyst

• 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.
• ICF Analysis Underwriter Analysis

Project Role: Business Analyst/Data Analyst

• Confidential 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
• To develop/enhance new/existing applications in Data warehousing and Actuarial area to cater the growing business requirements for Auto and Home.
• PL Motorcycle Part of Personal Lines

Project Role: Business Analyst/Data Analyst

• 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.
• Auto Quote Consolidation Part of Personal Lines

Project Role: Business Analyst/Data Analyst

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,Confidential will add the new elements, which are being incorporated in the front-end systems, to different loads, datamarts and business object universes.

Project Role: Business Analyst/Data Analyst

Confidential 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.

Confidential

Position: Business Analyst

Confidential Equitable has been providing millions of customers with life insurance, annuities and other needs-based products. Data warehouse will maintain the information of Policies, Products, Agents and Commissions. This data is used by the management for querying, analyzing and making decisions on commissions paid to agents and products. COIL Corporate Owned Incentive Life is a new product from AXA. The project has different interfaces like Accounting, Sales, Commissions and Prior Insurance.

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.

Confidential

Position: Business Analyst

• Confidential is a leading provider of pharmaceutical and biotech services to health plans, health plan sponsors and participants across theConfidential . STP Strategic Testing Process was to create strategic testing hardware and software framework, automation scripts and business processes for Caremark adjudication systems, Customer Care, LINKS, IVR, eBusiness, Data Warehouse and Finance systems.
• The Objective of the STP program is to perform Enterprise Level Business Testing by automating the E2E business critical regression test scenarios in a dedicated STP environment which mimics the Caremark's production environment.

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.

Confidential

Role: Product Lead and Business Analyst

• Confidential company is the world's leading provider of software and consulting services for the upstream oil and gas industry.
• OpenWire is a Drilling Completion product which provides timely access to well operation and subsurface data. The software provides access to real time formation evaluation and drilling data with an automated means to upload critical well data into the Landmark OpenWorks data management environment. The system, which receives WITSML Wellsite Information Transfer Standard Markup Language , provides connections to the OpenWorks system from multiple data vendors. The data connection into the OpenWorks system makes it easy to do a wide range of workflows, including pore pressure analysis, live monitoring of well trajectory, rapid interpretation of data, and real-time reinterpretation of subsurface data utilizing a range of Landmark products.

Responsibility

• The various tasks involved:
• My role was as a Product Lead and Business Analyst for OpenWire . My task involved setting up the product at offshore after knowledge transfer and training from the customer. This project was based on Agile Software Development Methodology and was tuned to suit onsite-offshore model.
• 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

Confidential

Position: Configuration Manager

• Confidential was launched to work as a Credit Risk Management System based on three-tier architecture. It obtains the Counterparty and mapping information and provides the same to different risk engines, which in turn processes the data and provides the output back to Paragon. It involves different products like Inventory, Settlement, Traded Products and the main area of work is Commercial Banking.
• Confidential this project is to provide a comprehensive risk and limit monitoring system with flexibility in viewing exposure information. The project also lays emphasis on monitoring the excesses and helping credit officers to monitor and manage market risk.

Responsibility

• 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.

Confidential

Position: Developer

The key objective of the Confidential project was complete automation of P O ferries. This included creation of booking, maintaining the physical inventory, product level inventory and accounts, pricing of the products and all the port specific operations like a system for Check-in operation in the port, requisition for load, Discharge, Pilot-age, Towage with the Port authority, Creation of the booking at the port for account customers, Creation of Notebook booking, Assigning the berth and Sailing color to the vessel, Port Cash Handling, Lane allocation and also generating and submission of the manifest.

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.

Confidential

Role: Software Analyst

Project Description:

• Carnation Auto is an auto solution company, engaged in multi-brand automotive sales and service network in India. Carnation provides complete solutions for multi-brand cars, starting from quick servicing, mechanical repairs, body repairs, accessories, insurance, certified pre-owned cars and even doorstep service through a chain of workshop on wheels.
• In order to enhance the overall experience of owning a car while optimizing the cost of ownership, Carnation is setting up a state-of-the-art network of integrated auto solution hubs across the country. TCS is helping Carnation to 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.
• As part of Phase1 a prototype was developed and basic customization was completed by TCS. Phase2 project was undertaken for modernization of existing product to new version and implementing new 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 -
• Creating the migration strategy plan
• Analysing the source and target tables
• Understanding what customized tables were incorrectly implemented and in turn map them to correct tables in the new product.
• Building the migration team
• Functional Part
• Document Requirement for new enhancements
• Modernization of current e-commerce implementation
• Quality Assurance
• QA strategy
• Research on defect reporting tool for the project.
• Templates for QA
• Building the team

Confidential

Position: Team Member Testing

Responsibility:

• Test design
• Test plan
• Create Test Cases
• Run test cases