Professional Experience:

Confidential

Role: Sr. Business Objects Developer

Responsibilities:

Environment: Informatica 9.1.0, Teradata, UNIX, SAP Business Objects XI3.1 Windows OS, Microsoft Excel, MS Office Word.

Confidential

Role: Business Objects Developer

Confidential based bank holding company specializing in credit cards, home loans, auto loans, banking and savings products. In terms of total assets, Capital One is the ninth largest bank holding company in the Confidential.

Environment: Informatica 9.1.0, Oracle, SQL Server, Teradata, UNIX, SAP Business Objects XI4.0, XI3.1 Windows OS, Microsoft Excel, MS Office Word.

Confidential

Role: Business Objects Developer

Confidential is the platform utilized at Nomura for Data Acquisition, Data distribution, Data warehousing and other data centric tasks. Assessment if this platform will help in developing a comprehensive road map suitable for supporting Operation , Finance , Compliance, Regulatory and other users locally and globally.

Environment: Business Objects XI R3.1 CMC, CMS, CCM /, Designer, Web Intelligence XI R3,Oracle 10g, MS SQL Server 2005, TOAD 9.7, Windows 2003 Server, Informatica.

Confidential

Role: Business Objects developer

Confidential multinational consumer goods company headquartered in downtown Confidential provides consumer products in the areas of pharmaceuticals, cleaning supplies etc.

Responsibilities:

• Currently working in two of the projects to create the reports for Yearly/Monthly/Quarterly.
• Created the design documents by analyzing the client requirements.
• Responsible for defining the scope of the project, gathering business requirements, doing gap Analysis and documents them textually or within models.
• Used aggregate tables for pulling in the data for stored procedures for optimizing the universe.
• Created a universe by using the stored procedures.
• Worked with DBA for modifying the database and populating the test data for few of the tables which don't have data yet.
• Constant interaction with business users to get the data and create reports. Involved in creating users, groups, assigning rights to users or groups, scheduling reports, managing servers using CMC.
• Developed /tested UAT migrated to production environment 45 Business objects reports using complex Sub reports.
• Checking the integrity of the Universes, and export the universes to Repository for making available to users.

Confidential

Role: BO Developer

Confidential is a leading health insurance company. BCBS is one of the nation's leading providers of health, dental, disability and long-term care benefits. This application is the single source for all Claims processing data.

Responsibilities:

• Currently working in two of the projects to create the reports for Yearly/Monthly/Quarterly.
• Complex formulae written for creating the reports which used running totals.
• Used aggregate tables for pulling in the data for stored procedures for optimizing the universe.
• Created a universe by using the stored procedures.
• Expertise in SQL for writing complex functions, procedures and packages.
• Worked with DBA for modifying the database and populating the test data for few of the tables which don't have data yet.
• Constant interaction with business users to get the data and create the stored procedures used for pulling the data into crystal reports.
• Created the design documents by analyzing the client requirements.
• Created Dashboards for daily, weekly, monthly reports

Environment: Business Objects XIR3/R2, Xcelsius, Crystal Reports XI, SQL SERVER 2005, TOAD, Win 2008, and PL/SQL

Confidential

Role: Business Objects Developer

Confidential is a provider of comprehensive health benefits solutions and health management services for multinational employers and government entities around the world. Consolidate different reporting applications into a single unified reporting application, moving legacy reporting applications into Business objects environment using WebI reports and Crystal reports. Transform and load the Multi-Currency claim, finance data into Data Warehouse for reporting. Business Objects is used as reporting solution.

Responsibilities:

• Developed reports using Web Intelligence, and Crystal Reports
• Create complex formulas at Universe level and Report level.
• Did performance tuning of reports and stored procedures.
• rained users in developing ad-hoc reports using WebI
• Did report development using Web Intelligence by using features such as multiple data providers, input controls and database ranking
• Combined queries using set operators, also used sub-queries and multiple data providers to develop complex reports.
• Created robust workflows and data flows to streamline the data loading process
• Created complex data and work flows, and transformations within the data flows to accurately load the data
• Populating the subject oriented data from various data sources, and finally using these data stores to populate a data mart
• Validating the mappings and the other important aspects by loading data into a staging area
• Used various Transforms and functions like query, table comparison, CDC, merge, case, key, date generation, lookup, date, conversions.
• Created efficient error-handling routines
• Debugging any issues that arose by the way of using log files
• Troubleshooting the production issues.
• Defined the deployment strategy for the reports and scheduled reports to run reports automatically
• Involved in troubleshooting, post-production support and handling Change Requests.

Environment: Oracle 10g, SQL Server 2000 / 2005, Business Objects XI R3.1/ XI R2, Designer, Web Intelligence, Desktop Intelligence, Crystal Reports XI R2/ 2008, Windows XP/2003, PL/SQL.

Confidential

Role: Business Objects Developer

Confidential is a major financial service provider operating in Confidential. It is ranked as the 25th largest company in the world according to the Forbes Global 2000 and the fourth largest financial service provider in the world according to Tier 1 capital. Some of the services offered worldwide are in Commercial Banking, Investment Banking and Investment management. The objective of the project was to create financial reports with Business Objects XI so that the end users can better evaluate their customers and businesses.

Responsibilities:

• Involved in Analyzing and Documenting End User requirements, Business requirements and Data Specifications for Business Objects reports.
• Involved in the creation of Universes, Classes and Objects.
• Created and set up Universes for each reporting group and established a BO Environment
• Created Derived Tables in the Universe to create frequently used reports
• Created User Objects to create Monthly Snapshot Reports.
• Created Complex Reports by using functionalities like Slice and Dice, Drill Down, Master Detail, etc.
• Developed Hierarchies to Support Drill down Reports, which allows the users to analyze the data.
• Created graphical representation of reports such as Bar charts, Line Charts as per end user requirements.
• Involved in full life cycle of Business Objects reporting application.
• Created and deployed WEBI Reports through Info View.
• Scheduled Daily, Weekly, Monthly and Quarterly Reports using Broadcast Agent Server.
• Exported the Universes to the Repository making resources available to the Users.
• Implemented Security for the End Users based on groups and permissions.
• Created Multiple Universes in Designer in secure connection as well shared connection.
• Worked on Broadcast Agent server and Customized Scheduling, Refreshing and Publishing Reports.
• Trained users to use interpret and modify reports as and when needed.

Environment: Business Objects XI R2 BO Reporter, Designer, Broadcast Agent, Supervisor, Web Intelligence, InfoView , Xcelsius, Oracle 9i, Informatica Power Center 7.1, Data Stage, SQL, SQL Plus, Windows 2000/XP, ERWin 4.0.