• A result driven Business Intelligence and Data Warehousing professional with a Master Degree in Computer Applications and having 9 years of experience in Business Objects XI including BOXI R4.
• Currently associated with Tata Consultancy Services, USA as Assistant Consultant, holding responsibilities of Technical Team Lead and On Site Coordinator.
• Complete end to end knowledge of BI/DW concepts and expertise in development projects and maintenance projects.
• Proven technical and analytical skills, along with efficiency to understand and create complex business reports and BO Universes.
• Experience in complete software development life cycle.
• Onsite-Offshore coordination and execution of projects of Onsite Offshore model.
• Experience in working with clients like Swiss Re and Etihad Airways.

• Quick adaptability to new technologies.
• Strong motivating skills for effective teamwork and team leading capability.
• Zeal to accept work related challenges, dedication towards work.
• Comprehensive problem solving abilities.
• Time Management.

Reporting tool:

Business Objects 6.5, BOXI R2/R3 R4

Databases:

Oracle 9i,10g,11g SQL PL/SQL

Operating Systems:

Windows 7 Enterprise, XP, 2000, 98

Other Tools:

Web Intelligence Rich Client Tool,

TOAD, Version Manager, JIRA, SNOW

Confidential

Reinsurance-

Client Market Underwriting, Financial Accounting Hub ,PLD Profit and Loss Database

Business Objects XI/R2,R4, Informatica Power Center 8.x, Oracle-10g

Sr Business Objects Developer Technical Team Lead

Confidential

Airline

Business Objects XI, Informatica 7.x, Oracle-9i

Business Objects Developer

Confidential

ROLE

Sr Business Objects Developer Team Lead

TECHNOLOGY

Business Objects XI/R2, R4 - WEBI, Informatica Power Center 8.x, Oracle-10g

• The client is a leading provider of Property Casualty Reinsurance and Life Health Reinsurance from 1863, Founded in Zurich, Switzerland. Swiss Re operates in more than 30 countries with 70 Offices and provides its expertise and services to the clients throughout the world. The core Business of Swiss Re is in Risk Transfer, Risk Finance and Asset Management. The client also has business in Financial Service and Real Estate areas. Swiss Re offers a broad spectrum of products for property and casualty, and life and health reinsurance as well as financial services solutions to manage capital and risk.
• Swiss Re's traditional reinsurance products and related services for property and casualty as well as for life and health business are complemented by insurance-based corporate finance solutions and supplementary services for comprehensive risk management.

Confidential

Client Market Underwriting Modules have multiple source systems to capture the transactional data like GFS Global Facultative System for processing and managing the entire facultative portfolio of the P C, IUF Integrated Underwriting Facility for Treaty type portfolios, eBoard for governing group details, ODS-P Operational Data Source Pricing for pricing related data, Quote-Tracker for capturing the quote related information, SICSnt Standard Insurance Computer System/New Technology for supporting the entire business administration process from contract administration to claims handling , Technical Accounting called TA, MANHATTAN, EDMS etc. All these data from various source systems are brought into a single data warehouse called as CMPDWH Client Market Product Datawarehouse . We have multiple data marts for reporting purposes like Facultative, Treaty, Claims, Technical Accounting, eBoard Reporting. In this project we created universes for each reporting application and created both standard reports and non-std reports for daily business purposes in different categories like Reconciliation reports, Turn-Around-Time reports, Ageing reports, Data Quality reports, Status reports etc.

Confidential

• PLD Profit Loss Database is to capture daily P L and the attribution for the risk budgeting framework as part of the AM Asset Management P L measurement project. This supports the production of key management reports as the product control team produces a daily P L report that goes to the CIO, CRO, CFO, CEO and Company Chairman.
• Our main responsibility is to develop the reports based on the business needs. This project mainly deals with various areas of the Asset Management domain. We generate reports on Profit Loss Accounting with Pillar I, II, III IV concepts, Adjustment Detail Reports, PnL Impact of Adjustments, End of Day PnL, New Trade details reports, Net Asset Value by Day reports, Reconciliation reports etc.

Confidential

FAH Finance Accounting Hub is an integrated FM wide finance architecture with one common accounting engine, subledger, reporting data repository and front end. It is based on the third party applications namely Aptitude, the Microgen's Accounting Hub MAH and the own developed application called INSIGHT module InSight FI . Other modules of INSIGHT are InSightOP Operations , InSIGHTEQ Equities and InSightFI Finance .

• Expertise in Universe Report designing using Business Objects based on the business requirements.
• Created ad-hoc reports using various data types, based on the prototypes provided by users using Business Objects report builder.
• Enhanced existing reports to meet the user requirements based on the Change Requests given by the client.
• Worked extensively in complex reports including aggregates, cross tab reports, reports with charts, filters and alert, drill down and drill through reports etc.
• Responsible for unit testing of Universes and resolving loops / traps by creating table aliases and contexts.
• Involved in QA activities of the project as there is no separate dedicated QA team.
• Responsible for testing reports by preparing the test data, meeting all the report conditions.
• Worked closely with the business user groups in providing fixes for existing reports in the maintenance phases.
• Executing all assigned maintenance and enhancement activities.
• Creating/updating report specifications.
• Studying the entire application management process, identifying areas for improvements and implementing the same.
• Handling the onsite-offshore tasks as the onsite coordinator.
• Involved in offshore delivery team resource planning.
• Monitoring the progress of each deliverables and in turn providing the status to the client manager.
• Participating in continuous Knowledge Transition documentation.
• Defining responsibilities and reviewing deliverables.
• Determining and fulfilling the resource requirements.
• Appraising the performance of the subordinates.
• Status review and staff meetings.
• Managing, Coordinating, Planning and executing the tasks.

Confidential

Confidential

ROLE

Business Objects Developer

TECHNOLOGY

Business Objects XI, Informatica 7.x, Oracle-9i

Etihad Airways, established by royal decree in July 2003 and based in Abu Dhabi, is the flag carrier airline of the United Arab Emirates. Etihad is the second largest air travel service provider in the Middle East and also a leading supplier of IT solutions to the global air travel industry. Business Intelligence System of Etihad is capable of transforming operational data into analytical information, thus aiding stake-holders to take strategic business decisions. The BIS provides inputs in various areas like Market Intelligence, Products, Revenue, Cost, Budgets and Net Contribution.

• Involved in analysis, development, testing, tuning and maintenance, and problems solving during implementation.
• Data retrieval and multidimensional analysis.
• Creating Technical Design Document.
• Creating reports as per the end users' requirements.
• Creating ad-hoc and canned reports.
• Worked extensively in Universe design for creating new reports.
• Technically helping the business users regarding the BO report issues.
• Change request analysis and estimation.
• Continuous knowledge transition and documentation.
• Capacity Management.
• Scheduling of reports to be emailed to end users daily in PDF, XLS and TXT formats from Info view.