PROFESSIONAL SUMMARY

• Over8years of Professional Experience in Data Warehousing as Business Intelligence Reporter using tools like Business Objects XI R3, XI R2, 6.x, 5.x, Crystal Reports, Crystal Xcelsius, Dashboards.
• Experience in using Business Intelligence (BI) Tools like Business Objects XIR3/XIR2/6.x/5.x to build complex universes and reports on multiple databases and experience in development, testing and implementation.
• Experienced in working with Business Objects modules like CMC, Designer, Info view, Web Intelligence, Performance Manager, Import Wizard, Publishing Wizard, Supervisor and Broadcast Agent, ZABO, EDMS.
• Experienced in installation,configuration, migration and administration of Business Objects XI R2 and the previous versions.
• Having Industrial Experience on Data Warehouse, Business Intelligence and Data Mart systems in implementation of Business objects applications for various verticals such as Food Production Industry,Pharmaceutical, Financial, and Insurance.
• Expertises in resolving join path problems like Loops and Traps in the universes using Aliases and Contexts.
• Expert in working with Business Objects Performance Management to create Dashboards and Analytics.
• Experience in Creating & Maintaining various complex Ad-hoc reports using Web I and Desk I/ Business Objects.
• Extensively used Business Objects reporting functionalities suchas Filters, Ranking, Alerts, Sections, Breaks, Sorts, Query prompts and Drill filters.
• Extensively used Calculation Contexts, Variables, Drill down, Slice and Dice in making the reports easy for user analysis.
• Hands on experience in Installation and Configuration of Business Objects Enterprise XIR2 in Windows environment.
• Involvedin Migration of Business Objects 6.5 content in to Business ObjectsXIR2 environment.
• Good experience in Crystal ReportsXI/10/9, Business Objects Suite (6.x/XIR3) Designer, Desktop Intelligence, Web Intelligence, Broad Cast Agent, Central Management Console/ Supervisor, Performance Management / Application Foundation.
• Experience in developing Crystal Reports, Cross Tab Reports, Top N Reports for highlighting significant data, summary reports with drill-down capabilities.
• Involved in administration tasks such as managing user accounts and groups, controlling user access, scheduling reports and events.
• Extensive knowledge in all phases of software development life cycle. (Requirement Analysis, Design, Development, Testing and Documentation). Exposure to version tracking control systems (PVCS, Exchange)
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts usingStar Schema and Snow Flake Schema for faster and effective Querying for the Metadata Management solutions.
• Specialized in creating complex query reports using Oracle, SQL server, MS Access and various RDBMS.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

TECHNICAL KNOWLEDGE

Databases: Oracle 10g/9i/8i, SQL Server 2005/2000/7.0, DB2 UDB 8.0, MS Access, Teradata.
BI Tools: Business Objects XIR2 (Info view, CMC, CMS, CCM, Designer, Desk I, Web Intelligence, Import Wizard, Report Conversion Tool, Performance Manager, Query as Web Services), Business Objects 6.5.1/6.1b/5.1.2 (Supervisor, Designer, Reporter), ZABO, Application Foundation, Crystal Xcelsius 4.5, WEBI 6.x/2x, Broadcast Agent 6.x/5x, Crystal Reports XI/10, Crystal Viewer. 
ETL tools: Informatica (Power Center 5.1/6.2/7.1, Power Mart 5.1/6.2)
Front-end tools: TOAD, SQL Developer
Modeling Tools: Erwin 4.1/3.5.2, Visio 2000, UML 2.0
Programming Languages: SQL, PL/SQL, Oracle Forms 4.5/6i, Java, VB 6.0, UNIX Shell Scripting, XML, HTML, ASP. 
Operating Systems: Windows95/98/2003/XP, Window 7, UNIX 
Web Tools: Tomcat, Apache, Web Sphere, Web Logic, IIS

PROFESSIONAL EXPERIENCE

Confidential, Decatur, IL
May'10 - Present
Sr. Business Objects Developer
PlanView Application (PVE) manages the planned work process across various departments, which include approval process, charge to location entry followed by requestor approval, setting schedules, creating a baseline and completed status reviews by work managers and requestors. This will allow analysis of where time is spent and drive future decisions for both resources and technology.
The project aims to help make decisions for new product improvements, analysis of existing products and improve customer service. 
Responsibilities:

• Installed Business Objects modules, created Repository with multiple universes and document domains for Development and Test environments and distributed the Domain key among the enterprise.
• Installed Business Objects XI 3.1 Designer and Import Wizard tools.
• DevelopedDashboards using Performance Manager, Dashboard manager (XI R3.1) and Crystal Xcelsius (Standalone format)
• Designed, created and implemented and tested dataflow, workflows, scripts and jobs for multiple projects.
• Full lifecycle project focusing on surveys, promotions, including Data Services and Designer components.
• Installed the ADM PlanView Scoreboard Extension, Created ODBC database connections to the Planview transactional database and to the Planview Datamart database
• Responsible for gathering the user requirement; prepare the requirement specifications document, design, development, analysis and testing.
• Created and modified the existing Universes by adding new classes/objects, prompts, hierarchies, Strategies. Resolved the loops using Aliases and contexts and checked the Integrity of the Universes.
• Created Business Objects reports, enhancements and fixes using Web Intelligence and customizing BO universes.
• Developed new Reports based on Business Requirements documents for Projects, Resources, Work and Request Portfolios for PlanView Application.
• Assist in ensuring all existing BO reports work appropriately during the PVE10.2 upgrade project.
• Involved in troubleshooting BO Central Management Console (CMC) problems.
• Performed report analysis to ensure existing documentation is accurately depicting the report information.
• Provide guidance to I.T. team members in relation to Universe items or best practices for report promotions and/or report documentation.
• Generated Business Objects Reports involving complex Queries, Sub Queries Unions and Intersection.
• Created Users and Groups and assigned access levels to BO content as well as applications.
• Extensively used Designer to design various universes for different business groups.
• Used @ functions like @aggregate aware, @prompt and implemented custom hierarchies.
• Created complex reports using cascading prompts, variables and calculation context.
• Created different types of reports such as Master/Detail, Cross Tab, Chart and Tabular using universe as a main data provider.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, Variables, and Formulas, Calculated data items, Filters, Sortsand Query prompt and Drill filters.
• Responsible for creating a Dashboard with graphical pie chats and speedometer representations with Crystal Xcelsius.
• Performed unit testing, system testing and user acceptance test (UAT) for universe, reports, and security management.
• Interacted with Co Developers, Business Support Analysts and Business Users in gathering the requirements for the Report Requests.
• Attended PVE-Team meetings and Weekly Status meetings and documented each stage of Implementation.
• Created documentation for users to access and analyze data using Business Objects.
• Provided support and training for business users in using Info view and Web I

Environment:
Data Services XIR 3.1, Business Objects XIR 3.1, CMC/Supervisor, Designer, Info View, Web I, Desk I, Crystal Reports, Xcelsius, Oracle, MS SQL Server 2005, Windows 7.

Confidential, Philadelphia, PA June'09 - Apr'10
Sr. BI Developer 
Confidential is a pharmaceutical, biological, and healthcare company. GSK is the world\'s second largest pharmaceutical company and a research-based company with a wide portfolio of pharmaceutical products. In order to keep track of the huge amounts of data generated, a data warehouse was developed which aided all levels of management in obtaining a clear perspective on the trend of the business and sales. Budgeting for the company needs and forecasting the company business decisions were based on the reports produced using this data warehouse. 

Responsibilities:

• Experience with Installation and Configuration of all Business objects modules.
• Created Universes using the Business Objects Designer and connected to the database.
• Developed, implemented and maintained Universes using Business Objects Designer.
• Used Business Objects 6.5 for developing reports.
• Used Business Objects XI for securing the universes and extracting the universes from Metadata.
• Responsible for creation of the Universe with Classes, sub classes, DimensionObjects, Measure objects and Condition objects.
• Applied Row Level and Object Level securities to restrict sensitive data at designer level.
• Resolved loops in universes using Aliases and Contexts.
• Set up Aggregate Awareness to enhance the performance of SQL transactions.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Exported the Business Objects reports to the repository to be viewed by all the users on the intranet and the Internet.
• Involved in creating reports on the web using Business Objects and Web Intelligence. Involved in formatting the reports to the user requirements.
• Involvedin Migration of Business Objects 6.5 content in to Business ObjectsXIR2 environment.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, list of values (LOVS), local variables, Alerts, Ranking and multiple data providers.
• Used Filters, Sections, Breaks, Sorts, Slice & Dice, Query prompts and Drill filters functionalities in making the reports easy for analysis.
• Created reports using Desk I and Web I in BO XIR2 environment.
• Developed Full client reports and Web I reports with various complex features and user accounts.
• Administer user accounts, implement data security and personalization, and impart necessary features involved in creating reports on the web using Business Objects Web Intelligence training and knowledge transfer to assigned project members.
• Scheduled Reports using Crystal Reports and used the Business Objects Server Administration Tool.
• Managed the user, groups, repositories and the documents through Supervisor. Actively attended for the meeting in the team management to discuss the views and analysis of the documentation.

Environment: 
Business Objects 6.5/XIR2(CMC/Supervisor, Designer, Desk I, Web I), CCM, Report Conversion Tool, BCA, Performance Manager, Crystal Reports, Teradata SQL Assistant, Windows 2003 Server.

Confidential, Pittsburgh, PA
Feb'08 - May'09
Sr. BI Consultant
DHS provides wide range of services to the county residents through its DHS program offices. Data source consists of various independent operating applications, is supplemented with the US Census bureau and is capable of reporting data in "real time". The Data Warehouse has evolved to be a central repository of social services data, which allows DHS to track and report client demographic and service data across its program offices and beyond. Since the Data Warehouse enables data-driven decision making among DHS staff, it also makes possible better outcomes for the individuals served by the Department.

Responsibilities:

• Installed Business Objects and created Repository with multiple universe and document domains for Development and Test environments and distributed the Domain key among the enterprise.
• Configured Web Intelligence using Configuration tool.
• Responsible for setting up the Users/Groups, Database connections, assigning privileges to the users using Supervisor.
• Assigned Broadcast Agent to various groups using Web I Admin Console.
• Implemented security structures with Row Level restrictions and Object hiding.
• Defined categories of documents for different level of groups.
• Involved in gathering functional requirements from the business users.
• Design and Development of Universes, which suits the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Created derived tables to reduce the complexity of the universes and also created prompts to force the users to restrict the data in the process of building the universes.
• Involved in the troubleshooting of universe schema with Loops, Chasm and Fan traps and Cardinality problems by creating Aliases and Contexts as required.
• Created custom List of Values (LOVs) for better understanding of prompts by the end user.
• Created Adhoc and Canned reports and fine tuning them for faster execution.
• Created custom Hierarchies to support drill down functionality for in depth analysis.
• Extensively used Calculations, Variables, Breaks, Slice and Dice and Alerts for creating Business Objects reports.
• Linked Universes to share the common components using Kernel and Component approach.
• Generated complex reports using the various data Providers like Universes, Personal Data Files and Free Hand SQL.
• Created Web Intelligence documents and published them to corporate documents.
• Defined categories of documents for different level of groups.
• Involved in day-to-day Business Objects Server maintenance.
• Optimized systems with load balancing with distributing components on different servers.
• Worked with DBA for creating the aggregate tables to improve the performance of the SQL transactions and used Aggregate Awareness(@Aggregate Aware) in select statements to run a query against the aggregate tables in the database instead of base tables.
• Created users/groups and defined privileges using Central Management Console. Migrating Business Objects 6.5 version reports to new version XIR2.
• Converted the existing full client reports to Web I reports using Report Conversion Tool.
• Imported existing users, groups, categories, Web I documents, connections, universes and restrictions to BO XI environment.
• Actively involved in giving demos to the users and prospective users about the functionality available in Business Objects.

Environment: 
Business Objects 6.5.1/5.1.8 (Supervisor, Designer, Reporter), Web I 6.0, ZABO, Info View, Broadcast Agent, Oracle 9i, DB2 UDB, SQL, TOAD, Sun Solaris, Windows 2000/NT.

Confidential, Memphis, TN
Jan'07 - Dec'07 
BO Consultant 
First Data the leader in electronic commerce and payment services, First Data serves more than two million merchant locations, making it easier, faster and more secure for people and businesses to buy goods and services using virtually any form of payment. This project is intended to bring up their reporting application using Business Objects. Data extraction is done from various data sources. Reports are generated from this data source and distributed through the corporate Intranet.

Responsibilities:

• Gathering the user requirement and prepare the requirement specifications document. This involved interaction with the business users and understanding the current reporting system.
• Involved in the Installation and configuration of all components of Business Objects and configured the Web Intelligence using configuration tool.
• Responsible for setting up the Users/Groups, Database connections, assigning privileges to the Users using Supervisor.
• Installed & configured BCA Scheduler & Publisher BCAP.
• Assigned Broadcast Agent to various groups using Web I Admin Console.
• Created centralized Repository with all three domains (security, universe and document) and distributed the BO Main key among the enterprise.
• Defined Joins and Cardinalities on tables manually in the universe and created Classes and Objects as per requirements.
• Worked in creation of multiple universe and document domains for development, test and production Environments.
• Created users, groups and assigned roles, privileges and also set row level and object level securities to different users and groups using Supervisor module.
• Good experience in creating and maintaining Secured,Shared and Personal connections.
• Involved in designing and developing of Universe for reports generation.
• Checked the integrity function for existence of loops and resolved them by using aliases and contexts.
• Involved in the performance tuning of the SQL queries by restructuring the Joins, creation of indexes etc.
• Manipulated the data by creating user defined objects using advanced database functions
• Involved in setting up of Aggregate awareness to enhance the performance of SQL transactions.
• Created the Reports using the universes as the main Data providers and writing the complex queries including Sub Queries, Unions.
• Formatting the Reports based on the user requirements using all the functionalities in Business objects like Slice and Dice, Drill Down ,Alerter, User response, and Formulas etc
• Developed complex reports using @Functions like @Prompt (for user defined queries), @Where (for creating conditional filters), @Select and Cross Tab tables.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way and Hierarchies to provide the drill down functionality to end-users.
• Created Full Client reports using different Data providers like Oracle, Excel sheets, SQL server.
• Created report level contexts in Web Intelligence and Desktop Intelligence reports.
• Used Broadcast Agent for scheduling and distributing the documents.
• Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications.
• Trained business users in creating web intelligence reports.

Environment: 
Business Objects 6.5.1(Supervisor ,Designer ,Reporter),Web Intelligence 6x, Broad Cast Agent, ZABO, Crystal 9, Oracle 9i, MS SQL server 2000, Sybase 12.0,TOAD,ERWIN,Windows 2000/NT,UNIX.

Confidential, Minneapolis, MN
May'05 - Dec'06 
Business object Developer 
Express Scripts Inc is the one of America's largest pharmacy benefit manager (PBM), providing the pharmacy benefits for millions of people nationwide through employers, managed-care plans, unions. Express Scripts handles millions of prescriptions each year through Home delivery and at retail pharmacies. Enterprise Benefit Systems (EBS) is a client server application used by the Client Benefit Administration (CBA) team to create and revise benefits for clients, based on the client's needs. The project scope in Key is to build Business Objects reports from several universes using Oracle 9i data source.

Responsibilities:

• Interacting with report users and Business Analysts to understand and document the requirements and translate these to Technical Specifications for Designing Universes and Business Object Reports.
• Developed Business Object Universes using Designer and Business Objects for the reporting solution for Operational reporting system.
• Potential usage of alias, context, and shortcut join concepts to overcome the loops.
• Created reports that limit the reports to display information for particular measures by designing complex Filters.
• Created reports like, Reports by Category, Reports by Plan, and Reports by Time (Year, Quarter, and Month Date).
• Created complex reports like Master Detail and Cross Tab reports to view and analyze the data.
• Developed Ad hoc reports using Business Objects.
• Formatted Reports as per the user requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
• Involved in Importing/Exporting the Universes to repository to make available to the end user. 
  Used Web Intelligence for web based query and reporting and published reports using Info view.
• Extensively used Calculations, Break points, Drill down, Slice and Dice, @Functions and Formulas, Filters & Alerts for creating Complex reports.
• Used the Broadcast Agent for Scheduling and monitoring the reports. Validation of the data by creating different test reports on warehouse tables and on base tables.
• Tested the report data, performance of data retrieval against the Warehouse data with TOAD.

Environment: 
Business Objects Designer6.5.1, Business Objects Reporter 6.5.1, Web Intelligence 6.5.1, TOAD, ZABO, Broadcast Agent, Dashboard Manager, Oracle 8.1.7/9i, SQL, PL/SQL, SQL*PLUS, Windows XP.

Confidential, Broomfield, CO
Feb'04 - Apr'05 
Business object Developer 
GATEWAY Insurance, which provides insurance for Life, Motor and Investment etc; this application is developed to assist which of the coverage's are most profitable and those that are least profitable. The project involved measurement of profits over time by covered item type, city and state, sales broker and sales region.

Responsibilities:

• Created complex Universes and Reports and Checked the Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Managed the user, groups, repositories and the documents through Supervisor.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula\'s etc.
• Exporting the reports to the Broadcast Agent Server, and used the Broadcast Agent to Schedule and Monitor the Reports.
• Created a wide variety of charts from the table. Used reports and generated pictorial views in the form of 2D, 3D & Pie Charts from existing reports & Chart Wizard.
• Administer user accounts, implement data security and personalization, and impart necessary involved in creating reports on the web using Business Objects Web Intelligence training and knowledge transfer to assigned project members.
• Scheduled Reports using Crystal Reports and used the Business Objects Server Administration Tool.
• Actively attended for the meeting in the team management to discuss the views and analysis of the documentation.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing, data transformation and data loading.
• Involved in creating reports on the web using Business Objects Web Intelligence 5i.
• Worked with supervisor module in creating users and user groups for different areas and setting privileges to them.
• Tested the Created reports and modified the relevant objects in the Universe.

Environment:
Business Objects 5i, Business Objects Designer, Business Objects Supervisor, Desk I, Web I, WebiSDK, Oracle SQL, Crystal reports.

Confidential, Hyderabad, India
Jan'03 - Dec'03 
Programmer/Analyst

Responsibilities:

• Extensively involved in Coding PL/SQL, Packages, Procedures, Functions and Database Objects according to Business rules.
• Extensively coded Forms, Reports using Developer.
• Performed tuning the application (includes Packages, Procedures, Functions, Triggers and Database Objects.
• Created Database Objects (indexes) to boost the performance of the Application.
• Extensively involved in coding of Triggers, Packages in the Application Level at each and every Transaction.
• Database Triggers, Cursors were used for the Data Validation at every Transaction level.

Environment: 
Oracle 7.3.2SQL, PL/SQL, Developer/2000 and Sun Solaris NT.

EDUCATION

Masters in Computer Applications, Confidential, India
Bachelors Degree in Electronics, Confidential, India