PROFESSIONAL SUMMARY

• About 7 years of IT experience in Business Objects XI R3/R2/6.5 with experience in CMC, Infoview, Desktop Intelligence, Import Wizard, Designer, Reporter, Web Intelligence
• Experienced the features of Business Objects XI R2, Crystal reports XI R2/8.0, Crystal Xcelsius.
• Experience in building Universes, retrieving data using Universes, Personal data files (MS Access, Excel) and creating complex ad-hoc Reports using the Business Objects Web Intelligence (WebI) modules.
• Experience in Installation, Administration, Design Universe, Reporting (Desktop Intelligence & Web Intelligence) and Migration of Business Objects XI R3/R2 /6.5.
• Extensive knowledge in Business Objects Full client & thin client environment.
• Worked on Web Intelligence (WebI) to develop and publish thin client reports.
• Experienced in setting up of Repository, creating, managing users and user groups.
• Experience in migration from previous versions of Business Objects to its higher version.
• Extensively worked in designing, implementing, distributing and maintaining Universes.
• Experience in creating Crystal Reports using Crystal Reports XI/2008 with expertise in developing various standard, graphical, formula based, well-formatted, drill-down, Summary and Parameters based reports and profound experience in developing complex reports using Sub-Reports (Linked and Unlinked), Cross-Tab, Stored procedures and Views.
• Strong knowledge in building queries on different types of Data Providers Universes, Personal data files, Stored Procedures, Free-hand SQL, and Web connect.
• Experienced in setting up of Repository, creating, managing users and user groups.
• Have experience working with databases like Oracle, SQL Server and MS-Access.
• Experienced in web publishing and scheduling documents using Broadcast Agent or Publishing wizard.
• Strong background in Data warehouse concepts - ETL, Data modeling, and Reporting.
• Extensively worked with end-user requirements, business data requirements, analysis and study.
• Unique ability to understand long-term project development issues at all levels.
• Strong Business Intelligence implementation knowledge of strategic planning, development and production in various core sectors
• Demonstrated excellent interpersonal skills and communication skills during identification of user requirements.
• Capable of working in a team or individually, self-motivated with good problem solving skills.

TECHINAL SKILLS

Reporting Tools : Business Objects XIR1/R2/R3,6.5/6.0/5.x,Crystal Reports 2008/XI/10/9, Crystal Xcelsius, Central Management Console (CMC), Central Configuration Manager (CCM), Import Wizard, Performance Management, Desktop Intelligence, Web intelligence Application Servers : Apache 1.3.27, IIS 5.0 and Tomcat 4.0.6 Business : MS Visio and MS Front Page Microsoft Tools : Microsoft Office Suite (Word, Excel, Access, PowerPoint, and Outlook) UML Diagram Tools : Microsoft Visio Database : SQL Server 2000/2003/2005, Oracle9i/10g, MS Access 2000/XP/2007, Toad Languages : SQL, PL / SQL Web Technologies : HTML, DHTML Operating Systems : Win XP SP2/SP3, Win 2000, Win NT 4.0 and UNIX

EDUCATION

• Bachelors of Technology in Electronics and Communication Engineering.

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA Jun 2009 - Present Sr. Business Objects Developer

WellPoint is the nation's leading health benefits company serving the needs of approximately 35 million medical members nationwide. WellPoint companies offer a choice of quality branded health benefits and related financial services designed to meet the changing expectations of customers. Developed a Reporting System which would help their Sales/Marketing teams to view and forecast the sales of their surgical product, and analyze the revenue of the company which would give the clear picture of business to the top level management to take decisions. The company has served its customers by offering access to quality health care at a competitive price and has served the people of Virginia through support of community organizations, programs and events that promote good health.

Responsibilities

• Performed an initial study of the current reporting application, to finalize the data elements required for reporting.
• Installed and configured BO Software on client machines and created User groups and users of PROD, DEV, TEST environments.
• Created Repository for BO development, created Universes and Complex Reports.
• Involved in working with different database environments and moving of the universes and reports between PROD, DEV, and TEST.
• Added users, user groups and managed the access privileges of the user community using the CMC module
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Maintained universes and Object Oriented Universe Design Techniques, working knowledge of Linked Universes.
• Designed Metadata Universe by creating the Business Objects Semantic Layer selecting/joining Tables, set cardinalities and creating objects and classified them into Dimensions, Details and Measures and give Business Name and group them into classes and sub classes
• Involved in creating the Aggregate tables at different levels.
• Multilevel hierarchies are set up enabling the drill down functionality.
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in WebI.
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Resolved issues like Chasm traps, Fan Traps in the universe build by creating contexts and aliases as required.
• Resolved loops by creating aliases, contexts and short cut joins by resolving loops, cardinalities and integrity checks of the Universe before exporting.
• As a part of report development, created the reports using universe as a main data provider and using the Powerful business objects functionalities, and formulae. Involved in trouble shooting of various reporting errors.
• Created the complex WebI reports such as Cross Tab and Master Detail Reports using the Java Report Panel.
• Created a set of Ad hoc reports with Business Objects and finally deploying them in Web Intelligence
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.
• Worked on Import and Export of the Universes, with the changes in Database Objects by using Import wizard and Designer module.
• Developed crystal reports, which include the following features - parameter fields, formulas, conditional formatting, multiple grouping and running totals
• Developed crystal reports using various Charts and Graphs like Bar Chart (Side by Side, Stacked), Line graphs, Pie Charts.
• Troubleshoots system errors and bugs and rectifies them.
• Involved in Training the Users in using this robust system.

Environment Business Objects XI R3/R2, Designer XI R3/R2, Desktop Intelligence, Web Logic 6.0, Crystal Reports 2008, Xcelsius 4.5/2008, Oracle 10g, SQL, PL/SQ.

Confidential, Denver, CO Apr 2008- May 2009 Business Objects Developer

Bank of the West, headquartered in Sanfransico, California is a financially strong, well-capitalized and prudently managed FDIC- insured bank. Their business includes Commercial, Personal services, Insurance, Loans, Wealth/Cash management, Capital Marketing. Created Universes and used optimising techniques. Involved in supporting the Business Objects applications that are in production environment, administered the BO activities, and granting the necessary db access rights and privileges for the BO users.

Responsibilities

• Responsible for system study & Business Requirements Analysis & Documentation (Technical).
• Applied command restrictions to various existing groups and users restricting different functionalities in Business Objects suite.
• Created user profiles in CMC module with varying security profiles for each user.
• Implemented Row Level Securities and Object level security universe to incorporate security for sensitive information.
• Documented the Tables required from the Underlying database to build the universes
• Designed Metadata Universe by creating the Business Objects Semantic Layer selecting/joining Tables, set cardinalities and creating objects and classified them into Dimensions, Details and Measures and give Business Name and group them into classes and sub classes
• Created local objects in the Universes with complex SQL functions to manipulate the data based on the report requirements
• Created Derived Tables to reduce the complexity of the Metadata Universes. Defined @Aggregate Awareness, @Prompt, @Select, @Where functions in universe level.
• Created Cascading Prompts in the universe to filter the list of Account names based on the Business Units.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and used Complex Formulas in the report variables.
• Resolved issues like Chasm traps, Fan Traps in the universe build by creating contexts and aliases as required
• Created Report Level Variables, Objects and Formula to create new columns based on the result set.
• Resolved Migration issues both in Designer, Reporter and created test cases to check the Migrated Reports
• Created Universes specific to dashboard development with various measures defined.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in WebI.
• Defined Report Level Ranking, Database Ranking and Alerts in Reports based on the specifications.
• Defined User Response function in Report Level to display the data selected by the users in the Report Headers
• Enabled/Disabled different servers in Central Configuration Manager and Central Management Console
• Involved in the creating the reports using the Web XI R2. Created the Reports (Master/Detail, Brake, Cross Tab, Chart, Templates) in Business Objects using the Universe as the main Data Provides and writing the Complex queries including Sub-Queries.
• Enhanced the Reports with the functionalities like Ranking and synchronizing the data using the merge dimensions option
• Actively working with Database design team to add new business rules and logic for the universe design.
• Resolved loops by creating aliases, contexts and short cut joins by resolving loops, cardinalities and integrity checks of the Universe before exporting.
• Created and customized application dashboards using Performance Manager to meet the requirements Upper Level Management.
• Developed dashboards and scoreboards for detailed analysis.
• Scheduled reports through Web I Scheduler for distribution and printing.
• Created Crystal Reports using both universes and business views based on business requirements

Environment Business Objects XI R2/R3 (CMC, Designer, Desk I, Web I), SQL Server 2005, Oracle 10g/9i, Tomcat, Apache server, PL/SQL, Window XP.

Confidential, New Haven, CT Feb 2007 - Mar 2008 Business Objects Developer/Admin

CIGNA had initiated a Corporate Social Responsibility program to improve health, well-being, Claims processing and security for all its customers. CIGNA's business practices demand strong financial controls, detailed plans and rigorous reviews. The CSR Program CIGNA establishes meaningful links between its own employees, individuals and families and well being of communities across globe. As a part of this CSR program, several reports and measurements are needed based on the standard operating procedures at CIGNA which include regular and appropriate reporting of internal audit functions.

• Responsibilities
• Worked with HR directors, Business Analysts, DBA's and end-users to gather universe design and reporting requirements to implement business logic for successful implementation of report systems.
• Created complex reports using multiple data providers for processing insurance claims for customers.
• Created universes, universe objects, classes, applied filters, pre-defined and complex conditions.
• Worked extensively on modules CMC, Designer, Web Intelligence, Auditor, Publisher and Info view.
• Created a fully functional Full client and thin client reports by making use of Business Objects functionalities.
• Used Personal data files, free-hand SQL, stored procedures and also functionalities like Combine Queries, aggregate awareness in universe.
• Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulae etc
• Created Dashboards using Dashboard Manager and Dashboard universes with metrics.
• Implemented object level security in universe to incorporate security for sensitive information.
• Implemented various levels of user profile rules, such as Folder level, scheduling reports or view only access.
• Used Infoview or WebI to create, analyze and publish reports to various groups or users.
• Designed Data model for Data Warehouse using snowflake schema, star schema.
• Generated reports with 2D, 3D and pie charts for business query results.
• Generated complex reports involving numerous prompts, open document functions and taking data through multiple data providers.
• Generated various reports with “prompt” functionalities both at universe and report level to enhance end-user interactivity.
• Extensively used extended syntax's and complex formulas.
• Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Edited Joins, resolved loops using aliases and contexts in the universe and exported to repository.
• Created Crystal reports when needed and exported to enterprise repository in order to make Crystal reports accessible through Infoview.
• Used T-SQL Aggregating, group by, Indexes, stored procedures.
• Responsible to support the issues with reports on the Business Objects Enterprise environments (Development, UAT, Test and Production).
• Used ETL tool Informatica when needed for loading data into another Database DB2.
• Involved in writing detail level documentation for reports, migration of reports as well as universes to production.

Environment DB2 UDB, Business Objects XI R2, Crystal Reports XI R2, SQL, Windows XP, Web Intelligence, Informatica 7.0, UNIX Shell Scripting.

Confidential, Gaithersburg, MD Nov 2005-Jan 2007 Business Objects Developer Nationwide Insurance is one of the largest and diversified insurance companies in US. The company provides a full range of personalized Insurance and financial services including Auto Insurance, Homeowners Insurance, Life Insurance, Farm Insurance and commercial Insurance.

Responsibilities

• Interacted with functional / end users to gather requirements of core reporting system to understand exceptional feature users expecting with reporting system and to implement business logic.
• Analyze the reporting requirements with the business users and come up with the technical specifications for the BO Reports
• Worked on Business Objects DeskI and WebI Reports of BO XIR2 Environment.
• Worked on User Management, Server Management and Content Management.
• Migrated the Users, Groups, Universes, Personal Folders, Connections, Reports (DeskI & WebI), Excel, Pdf and Instances to Production, Development and Test Environments using Import Wizard from BO 6.5 to BO XIR2.
• Creating the reports using Business Objects functionalities like Multiple Data Providers, Prompts, Slice and Dice, Drill Down, Cross Tab and Master Detail.
• Added users, user groups and managed the access privileges of the user community using the CMC module of Business Objects.
• Created complex variables, breaks, sorts, filter and conditions for various reports.
• Linked multiple universes and reports using stored procedures, visual basic procedures, flat files and excel files.
• Responsible in publishing and scheduling business intelligence documents to large number of end users.
• Implemented row level restrictions according to different business group requirements.
• Involved in migrating and deploying -- universes and reports across multiple domains.
• Solved many Universe problems. (Loops, Fan and Chasm Traps)
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Creating, maintaining and modifying the universes using Business Objects designer
• Creating reports using Crystal Reports XI when needed.
• Aided in the multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.
• Implemented Data modeling using ERWIN tool when necessary
• Created jobs to Extract, Transform and Load data into data warehouse using Datastage7.0
• Responsible in maintaining Development, Test and Production repositories and providing round the clock support during the production stage.
• Involved in scheduling the documents for monthly, weekly and daily.

Environment Business Objects XI R2, Infoview, PL/SQL, Oracle 10g/9i, ERWIN 4.0, Crystal reports XI, Data Stage 7.0

Confidential, Phoenix, AZ Sep 2004 - Oct 2005 Business Objects Developer

The project involved in the maintenance of Decision Support System for Wells Fargo by means of integrating data from disparate feed systems, situated across different locations, into a repository of meaningful business information. The Banking Data Warehouse (BDW) system for Wells Fargo is designed to handle the increasing data volumes generated by the bank's growing, active client base while improving customer service levels. Responsibilities

• Gathered user-requirements/feedback, implement in reporting applications.
• Designed and developed Business Objects universe and report templates.
• Implemented subject-oriented contexts in designer.
• Created Cascading Prompts in the universe to filter the list of Account names based on the Business Units.
• Created reports using Business Objects functionalities like queries, Slice & Dice, Drill Down, Cross Tab, Master/Detail and used Complex Formulas in the report variables.
• Created Universes for report generation using Designer module in Business Objects.
• Defined Customized Sorts in Universes and Reports Level.
• Added users, user groups and managed the access privileges of user community using the CMC Module of Business Objects of XI R2 and Business Objects 6.5.
• Designed Metadata Universe by creating the Business Objects Semantic Layer selecting/joining Tables, set cardinalities and creating objects and classified them into Dimensions, Details and Measures and give Business Name and group them into classes and sub classes
• Resolved universe development issues involving loops and chasm traps.
• Check the Integrity of the Universes.
• Customized list of values and efficient prompts for intuitive reporting and analysis.
• Exported the universes to the Repository to making resources available to the users.
• Track data issues and direct technical resolution; interact with other teams on technical interface issues.
• Impact analysis - update and prepare team for new data, data change Met users to discuss new reports, reporting issues, data issues/changes relevant to users.
• Tested, QA-ed and delivered reporting applications, resolve all reporting/data issue.
• Increased reliability of reports through elimination of errors and efficient resolution of issues - user base grew by 200%, steady issues resolution rate 98%+ catered to reporting needs of departments ranging from contracts operations to higher management levels.
• Published and scheduled Business Objects Reports to users using Scheduler.

Environment Business Objects XI /6.5, Designer, Web Intelligence 6.5, Oracle 8i/9i, Windows 2003 Server.

Confidential, Hyderabad, India. Jul 2003 - Aug 2004 SQL Programmer The project is making the GUI application to maintain the money transactions. The company invites deposits, fixed deposits from customers and offers loans to qualified customers. This assignment consist the automation of all company transaction. Responsibilities

• Design and development of software related to materials management and finance.
• Documented database procedures in PL/SQL to control deletion of material code and developed front end using Visual Basic.
• Documented database triggers, which would not allow change without proper authorizations in transactions viz. material return from plant goods issue, goods purchased through proper channels in purchasing department and goods receipt physical inventory once saved in Oracle.
• Developed reports for purchase orders, sales orders, and goods issued and goods receipt. Coded database procedure to calculate average purchase price of material for current financial year for costing purpose.
• Conducted detailed study of the existing manual system. Also analyzed and designed the system along with senior members Participated in unit testing and system testing Interacted with users in implementation.

Environment VB 6.0, Oracle 7.x, SQL Loader, PL/SQL, Reports 3.0 and Windows NT/2000.