Experience Summary

• With an over all IT experience of approximately 8+ years in design, development, testing and deploying reporting solutions using Business objects in various line of businesses (Data Warehousing, Banking, Retail and Insurance Industries).
• Technical hands-on expertise using OLAP tool Business objects 5.x/6.0/XIR2/R3(Reporting,Designer,Web Intelligence,Infoview and Administrator)
• Extensive knowledge in creating dashboard and linking reports to them.

Created dashboards using Xcelsius.

• Proficient knowledge on BO XI Admin, SAP HANA and new features.
• Expertise in Universe designing, developing and generating complex dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy test.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Worked with Crystal Report XIR2 for creating complex reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV and slowly changing dimension.
• Worked on Agile Projects.
• Managed Offshore-Onsite model and experienced in implementing outsourced projects from planning to delivery phase.
• Responsible for Project management activities like project estimation, planning, cost and schedule tracking, resource management, risk management and performance reporting for multiple projects.
• Solid quantitative analytical, process development, facilitation and organizational skills.
• Strong Communication, fast learner and excellent interpersonal skills.

Tools Worked on

Career Profile

Confidential, January 2012-Till Date
Client: Confidential
Role: Migration Lead
Project Name: Superdome Migration to Exadata X2

Confidential, is one of the largest investment and insurance companies in the United States. The project aims at development of the Enterprise Data warehousing applications in the Property and Casualty division of Hartford. Hartford product line are Group Benefits, Retirement Programs, Mutual Funds (Institutional), Investment Management, Reinsurance & International and also supports Annuities, Mutual Funds, Automobile, Insurance, Homeowners Insurance, Flood Insurance, Life Insurance, College Savings, International AARP endorsed Products and Online Commerce Protection for individuals.

Migrate the CCMT Data Warehouses and applications off the IM Superdome and EMC frames and onto the Exadata platform (for Data Warehouses) and server platforms (for PL Rating Engine and ETL Framework) while maintaining functionality with no negative affect on performance.

Activities:

• As the Project Lead, involved in planning, resource and budget estimation for the project. Mentored resources wherever required.
• Proactively identified project risks, analyzed and incorporated remediation steps.
• Timely communication of project statuses, budget estimates and resource needs to senior management and different stakeholders involved.
• Working with Project Managers in defining the scope, handling change controls and end delivery.
• Managed onshore and offshore technical and development resources for the project.
• Worked with Solution Specialist, QA PM, DBA' s in preparing the game plan for data from super dome to Exadata server.
• Move the PLDW ETL Load processes from the Superdome to the Exadata platform.
• Move the ETL Framework to a stand-alone server.
• Move the PL Rating Engine to a stand-alone server.
• Code remediation for key processes to optimize performance.

Tools: Toad, Oracle, IM Remedy, Informatica, Exadata, Unix, Linux, Autosys

The New Business Vision program will introduce new data sources to Information Management for Real Time Service transactions to be captured in the Commercial Lines Data Warehouse. This project is initiated by Select Customer to drive more new business quotes and issues from engaged and unengaged agents by providing an improved user experience. It includes Deliver Real-Time Bind-able Quotes (Automated Underwriting) at an increasing rate over time while maintaining profitability, Deliver an Easy, Predictable experience for Underwriter Referred Quotes and Provide support for proprietary and non-proprietary access, enabling anticipated business strategies. In addition to an improved agent experience, the project will reduce new business processing costs, overall, inclusive of responsible architecture choices to realize short and long-term objectives to maximize delivery, stability and lower total cost of ownership.

Activities:

• Performed role of tech lead and business objects consultant for NBV, QP3 and GBD migration project.
• Involving in project activities from Requirements Gathering, impact analysis, Report Design and unit testing.
• Performed user rights, folder rights setting and server settings.
• Requirements Gathering and creating the Business Requirement Document.
• Analyzing the Report Requirements and creating the Mapping documents.
• Identified the key resources, skills and point persons in each area of development and allocating work and mentors where necessary. Worked with the resource managers to achieve this task successfully.
• Identified project risks, analyzing and incorporating remediation steps.
• Implemented Change Control process to review new additions or existing production issues, also monitor scope creep and resource needs for approved change controls.
• Creating Reports using Business Objects XIR3 Web intelligence and Desktop Intelligence
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula
• Testing of reports and Bug fixing using IM Quality Center.
• Tracking and maintaining Defect Status Report for the project
• Performance Tuning of the reports.
• Ensure maintainability of the application with user.

Tools: Business Objects, Toad, Oracle, IM Remedy,Informatica,Unix

Recognized for the diversity of its product portfolio and distribution networks, The Hartford serves customers through independent agents and brokers, financial institutions, affinity groups and via the Internet. Approximately 11,000 independent agencies and more than 100,000 registered broker/dealers sell the company\'s products. Our 30,000 employees serve customers worldwide. Of this total, 27,600 are in the United States and 11,500 in Connecticut.

Hartford product lines are Group Benefits, Retirement Programs, Mutual Funds (Institutional), Investment Management, Reinsurance & International and also support Annuities, Mutual Funds, Automobile, Insurance, Homeowners Insurance, Flood Insurance, Life Insurance, College Savings; International AARP endorsed Products and Online Commerce Protection for individuals.

Activities:

• Gathering relevant reporting information and accurately assessing customer concerns and other market trends to provide meaningful inputs to management and actively contribute to the decision making process
• Planning of timelines, resources and cost estimates for each phase of the project (development, quality, testing and deliverance).
• Timely communication of project statuses, budget estimates and resource needs to senior management and different stakeholders involved.
• Managing the project scope, documenting additional scopes, following project change requests for additional scopes and participating in key discussions involving the approvals of additional scopes.
• Involved extensively in issue resolutions, proactively or reactively, at the same time delivering the product on time.
• Managing dependencies and interfaces of the project thru the lifecycle.
• Providing direction, motivation and support to the project team
• Preparing Lessons Learned and End of Project reports.
• Created new universe, reports and dashboards for sales representatives, Regional Manager and Regional Vice Presidents.
• Provided the security access management by creating users/groups and folders.
• Scheduling reports based on user level access.
• Helped team members with their deliverables for QA process by preparing test scripts and validating reports.
• Coordinating and conveying requirements with onsite and offshore team.
• Prepared documentation for all universe and reports developed and keep track of all changes.
• Developed universe and reports user documentation guide for the end users reference.
• Actively participated in doing the Major / small / Emergency Projects which comes as an enhancements or project request
• Performance Tuning of the BO Reports
• Logging defects in IPMS and doing root cause analysis when ever necessary using IQA, EQA process
• Provide reporting and Analytical capability across applications
• Created complex hyperlinks

Tools: Business Objects (Infoview, Dashboard) Toad, Oracle, IM Remedy, sql server,Xcelsius

Confidential, January 2006-December 2008
Client: Confidential
Role: Team Member
Project Name: P& C IM Invest Project

Recognized for the diversity of its product portfolio and distribution networks, The Hartford serves customers through independent agents and brokers, financial institutions, affinity groups and via the Internet. Approximately 11,000 independent agencies and more than 100,000 registered broker/dealers sell the company\'s products. Our 30,000 employees serve customers worldwide. Of this total, 27,600 are in the United States and 11,500 in Connecticut.

Hartford product lines are Group Benefits, Retirement Programs, Mutual Funds (Institutional), Investment Management, Reinsurance & International and also support Annuities, Mutual Funds, Automobile, Insurance, Homeowners Insurance, Flood Insurance, Life Insurance, College Savings; International AARP endorsed Products and Online Commerce Protection for individuals.

Activities:

• Solving tickets raised by One View users through Remedy Application Following the SLA response and Resolution times.
• Performed role of business analyst by gathering the requirements, preparing Business Requirements Document (BRD) and getting signoff from customer and solution specialist.
• Making changes to existing Universe and reports based on user requirements.
• Performed impact analysis before making respective changes.
• Helping team members with their deliverables by doing QA process by preparing test scripts and validating reports.
Actively participated in doing the Major / small / Emergency Projects which comes as an enhancements or project request
• Actively executing Process Exceptions according to User' s requirement.
• Performance Tuning of the BO Reports
• Maintain project related documents in TCS tool IPMS
• Logging defects in IPMS and doing root cause analysis when ever necessary using IQA, EQA process
• Ensure compliance to IPMS/EPMS Timesheets
• Provide reporting and Analytical capability across applications
• Raising and Handling Remedy tickets for issues related to Hartford through Remedy Tool.

Tools: Business Objects, Toad, IM Remedy, Unix,Informatica,Oracle

Confidential, February 2006 to November 2006
Client: Cognizant Technology, Chennai, India
Project Name: Integrated Business Intelligence Data Warehouse System, IBIS
Tools: Business Objects, Toad, Informatica, Pl/sql,IM Remedy

Confidential, April 2005 to February 2006
Client: Confidential
Project Name: METRO Cash & Carry
Tools Used: Business Objects, SQL Server, Unix, Toad, IM Remedy

Confidential, September 2004 to March 2005
Client: Confidential
Project Name: Spira De Credit Cards Data Mart
Tools: Business Objects, Toad, IM Remedy, Oracle, Unix

Education & Certification:

• Bachelor Degree in Information Technology
• Completed Business objects 6.5 & SAP Business Objects XI R2 Level 1 certification.
• Completed Oracle Level 1 Certification.