We provide IT Staff Augmentation Services!

Business Analyst Resume

Ny, UsA

Experience Summary
A senior IT Consultant with 11+ years’ of experience with Fortune 500 companies in various functions and capacities. My last six years engagements were mostly consulting for data warehouse projects involving dimensional modeling, ETL, BI reports & Dashboards, MDM, Data Quality & Data Governance. I am well versed with all aspects of software development life cycle spanning requirements to deployment, imparting user training, facilitating JAD-Sessions, conducting workshops, organizing UAT, manage data quality and data governance, change management, issue management and continuous support involving multiple-skilled teams and senior decision takers with hands-on business implementation, relationship building, financial targets and political undertakings. At enterprise level I have been involved task related to road map charting, planning & scheduling, work-breakdown, organizational change management and business process modelling.I have gained rich multi-cultural experience while working for big corporate at customer locations in different geographies including:
My work experiences are primarily in following roles

  • DWH/BI Business Analyst
  • Data Analyst
  • Data Architect
  • Product Manager
I have worked primarily in the following domains
  • Insurance (P&C )
  • Banking(Risk Management)
  • Manufacturing(ERP)
  • Energy - Oil & Gas (Drilling & Completion)
  • Retail
Technical expertise
  • 7+ Years’ Experience as BI Business Analyst and Data Analyst.
  • 3 Years’ Experience as Product Manager using Agile Software Development (Scrum) methodology.
  • 1 Year Experience in Java Application Development.
DETAILED PROJECT EXPERIENCE

Confidential , NY, USA
Role: Business Data Analyst (Working under Enterprise Data COE)

Program Description:
The Confidential is an enterprise wide program initiated to create a centralized Master Database to consolidate master as well lookup reference data from multiple legacy systems (across regions) and the ability to govern data through a harmonized set of values. The mapping of source values to the harmonized values will be required to bring in the Master data from various regions into a single, consolidated repository to be consumed by downstream systems & applications.

Project Description:
Confidential 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 nderstand 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
Confidential, USA
Role: Sr. Business Analyst-BI & Data Architect
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 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. Confidential 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
Team Size: 15 Members
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
Team Size: 15 Members

Confidential, New Delhi, India
Role: Product Manager
Project Description:
Confidential is a leading auto Solution Company in India, 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 was 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. The prototype being successful, Carnation wanted it extended to complete range of products using new TEP platform and 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 -
  • 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
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
Work Location: Noida, India
Team Size: 5 Members

Confidential, Richfield MN
Position: Business Analyst
Project Description:
The Confidential multinational 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 United States, 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.
Tools: MS-Office
Operating System: Windows XP
Confidential,
Position: Business Data Analyst

Project Description: Confidential 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.
  • 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

Confidential , NJ, USA
Position: Business Analyst

Project Description: Credit Analysis Tool (CAT) 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.
Tools: MS-Excel, Oracle, Visual Studio for Office.
Operating System: Windows XP
CAT Team Size: 10 Members

Confidential, Hartford, CT,
Position: Business Analyst
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.

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

Confidential NY, USA
Position: Business Analyst

Project Description: Confidential 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.
Tools: Datastage, UNIX, SQL Server 2000, Oracle 9i/10g, TOAD
Operating System: Windows XP, UNIX, Main Frames, COBOL
COIL Team Size: 4 Members

Confidential
Position: Business Analyst

Project Description: Confidential is a leading provider of pharmaceutical and biotech services to health plans, health plan sponsors and participants across the Confidential. 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.
Tools: Mercury Quality Centre

Confidential, Texas, USA
Role: Product Lead and Business Analyst

Experience Summary
A senior IT Consultant with 11+ years’ of experience with Fortune 500 companies in various functions and capacities. My last six years engagements were mostly consulting for data warehouse projects involving dimensional modeling, ETL, BI reports & Dashboards, MDM, Data Quality & Data Governance. I am well versed with all aspects of software development life cycle spanning requirements to deployment, imparting user training, facilitating JAD-Sessions, conducting workshops, organizing UAT, manage data quality and data governance, change management, issue management and continuous support involving multiple-skilled teams and senior decision takers with hands-on business implementation, relationship building, financial targets and political undertakings. At enterprise level I have been involved task related to road map charting, planning & scheduling, work-breakdown, organizational change management and business process modelling. I have gained rich multi-cultural experience while working for big corporate at customer locations in different geographies including:

Confidential
Role: Business Data Analyst (Working under Enterprise Data COE)


Program Description:
The Confidential is an enterprise wide program initiated to create a centralized Master Database to consolidate master as well lookup reference data from multiple legacy systems (across regions) and the ability to govern data through a harmonized set of values. The mapping of source values to the harmonized values will be required to bring in the Master data from various regions into a single, consolidated repository to be consumed by downstream systems & applications.

Project Description:
Confidential 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: MS-Office
Operating System: Windows XP

Confidential TX, USA
Position: Business Data Analyst

Project Description: Confidential 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.
  • 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

Confidential, USA
Position: Business Analyst

Project Description: Credit Analysis Tool (CAT) 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.

Hire Now