SUMMARY

• Over 7+ years of experience in Business Intelligence and Data Warehousing using SAP BO.
• Strong Domain Knowledge of Utility (Electricity), Finance, Mining, Health Care, etc.
• Expert working in all phases of SDLC Life Cycle.
• Technical hands-on expertise using OLAP tool Business Objects 6.0 /XI R1/R2/XI 3.1(Reports, Designer, Web Intelligence, Info view, and Supervisor).
• Proficient knowledge on BO XI Architecture and new features.
• Good Experience in SAP BO XI 3.1/XI R1/R2,6.5/6.0, Architecture, Administration, CMC, CCM, Clustering BO Servers, Report Conversion Tool, Dashboard Manager, Import Wizard, Publisher and Performance Manager.
• Experienced in Creating and Updating Universe Using Business Object Designer.
• Versatile experience includes linking Multiple Universes, creating Derived tables, Customized Hierarchies and Data Integrator scripts.
• Created Excellent Reports and dash board using Business Objects Web Intelligence/Rich Client/Info View, Desktop Intelligence, Crystal Reports and Xcelsius.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Worked with Crystal Report XIR2 for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports, data reports along with LOV.
• Developed different flavors of reports like Monthly, Quarterly, and yearly variance with line charts, pie charts and bar charts.
• Experience in ETL includes extraction of source data, Data profiling, Transformations and testing Data Quality using Data Integrator, Data Quality and Data Services.
• Experienced with databases such as Oracle 8i/9i/10g, Teradata, SQL SERVER 2000/2005, DB2 and in writing SQL.
• Good Knowledge of RDBMS, OLTP, OLAP, and Data Warehousing concepts.
• Experience with Data Modeling using Erwin.
• Strong Experience on database interfaces like SQL*Plus, TOAD, SQL Assistant.
• Possess strong analytical & problem solving skills.
• Good team player with excellent oral and written communication skills
• Excellent in documenting Business Requirements, Technical Designs, Unit Test plans, System Test plans, User Acceptance test plans and User Training manuals.

• Reporting Tools: SAP Business Objects XI4.0/XI 3.1 /XI R1/R2,6.X, Web Intelligence, Universe Designer, Desktop Intelligence, Infoview, Rich client, Report Conversion Tool, Query Builder, CMC,CCM, Crystal Reports8.5/9.0/10/XI, Crystal Enterprise 9.0/10/XI , Xcelcius, Import Wizard, Dash board
• ETL Tools: Business Objects Data Services XI 3.1/ 3.2/R2, Data Integrator XIR2, Data Quality XIR2
• Data Modeling: Dimensional Data Modeling, ERwin 4.5/4.0, Physical and Logical Data Modeling.
• Operating System: Windows Vista/XP/2003, Unix, Linux
• Languages: C,C++,HTML,XML, SQL and PL/SQL
• Tools: SQL*Plus, TOAD, SQL Assistant ,Putty, SSH Tectia

Confidential, IL Duration: Oct ’10 – Till-Date
Position: SAP Business Object Consultant

WMS Gaming Inc ("WMS") has been shaping the gaming industry for over 60 years. Today, our slot machines are active in over 300 gaming jurisdictions worldwide.
In addition to our Illinois presence, WMS is the natural choice for gaming establishments permitted by the Video Gaming Act for one simple reason: our uncompromising focus on Player Driven Innovation™. We combine groundbreaking technologies, engaging game content and innovative productexecutions to transform the player experience in an attempt to maximaize return on investment.
Roles and Responsibilities

• Interacted with various business people and gathered business requirements and translated them into technical specifications, translated user input into BO design documentation for report layout.
• Documented PLA (Project Logical Architecture), PAD (Physical Application Design), LAD (Logical Application Design) and BO PAD.
• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Meter Interval Reports.
• Analyzed the existing database and designed the Universes using SAP Business Objects Designer Module for generating reports.
• Created cascading List of Values and defined custom hierarchies in Universe Designer.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Created Classes, Objects, Dimensions and Measures and used the @variable, @prompt, @aggregate functions for improving report performance.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts Using different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports in Webi Rich Client.
• Automated document Scheduling, Publishing and Distribution for WebI and Desktop Intelligence clients, using the Central management Console (CMC).
• Created parameterized Crystal reports and customized existing reports for presentations using Summary reports, Detail reports, Cross-Tab reports and Sub-reports.
• Designed, developed, maintained and tested Universes for supporting ad hoc queries.
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Migrated Universes and reports from development to Unit testing and production environments.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with dashboard manager and Xcelsius 2008 SP3 for dynamic data visualization.
• Experienced working with Match Transforms, Address Cleanse and Data Cleanse Transforms for US Data Cleansing in Data Quality using Data Services XI 3.2.
• Experienced Installing SAP Business Object XI 4.0.
• Used Data Integrator and Platform Transforms extensively, Created jobs, Workflows and Dataflow.
• An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

Environment: SAP Business Objects XI 4.0/ 3.2 SP2,Data Services XI 3.2 SP2, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Xcelsius 2008 SP3, Teradata 13.x, IBM DB2 , Oracle 10g, SQL SERVER 2005, Windows XP, Toad, ERwin

Confidential Duration: Aug’09 – Sept’10
Position: SAP Business Objects Consultant.

Project Name: ORR (Operational Reporting System Replacement)
The project Operational Reporting System Replacement (ORR) was an extension to Operational Reporting System (ORS) which involved maintaining the data of newly/being installed Edison Smart Connect meters and generating reports using SAP Business Objects reporting tool.

Roles and Responsibilities

• Worked extensively with business users, business analysts and SAP BO Developers to understand technical, functional and business requirements and developed Universes in Designer, SAP BO reports in Webi and Deski and Xcelsius dashboards.
• Translated the reporting requirements into high level design documents including granular technical design documents, Involved in Data Modeling and SQL server Database.
• Created Reports in Web-Intelligence XI R3.1 SP2 using complex functions and supported the deployment of Universes and Reports.
• Designed and developed complex universes with multiple Fact Tables and several hundreds ofobjects as per the Universe design best practices.
• Created Canned/Ad-hoc Reports using Webi, Deski, Info View and Crystal Reports on a daily, weekly and monthly bases as per the user requirements, .
• Created different types of reports, like Master/Detail, Cross Tab and Chart (for trend analysis). Used filters, conditions, list of values (LOV), calculations, etc
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with dashboard manager and Xcelsius 2008 for dynamic data visualization.
• Created complex variables, breaks, sorts, drill functionality into Webi and Linked reports.
• Scheduled, monitored and fixed errors of the jobs, Optimize mappings to achieve faster load..
• Performance tuning of the SQL queries by restructuring the Joins, creation of required indexes to avoid table scans, error handling of queries etc.
• Involved in job, workflows, Dataflows, Transforms to extract data from SAP notification module according to the Business rules provided by the users using Data Service 3.2.
• Performed address cleansing by using USA address cleanse.
• Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.
• Documenting the changes and training the end users.

Environment: SAP Business Objects XI 3.1, Data Services 3.2 12.2.0, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence, CMS, Xcelsius 2008, SQL Server2005, TOAD, Windows XP, Web Intelligence.

Confidential, Phoenix AZ Duration: April’08 – June’09
Position: Sr. BO/BODI Developer

Roles and Responsibilities:

• Extensively involved in setting a new SAP BO XI R2/R3 Environment installed and configured SAP Business Objects XI R2/R3 on Staging Environment, Applied Service Pack and fix pack.
• Migrated several reports/universes from SAP BO XI R2 to R3 using Import wizard and converted some reports to Webi and Deski using Report Conversion Tool.
• Monitored and solved the issues encountered in Universes and reports while migration and tested before moving to production.
• Performed Server Management and Administration Tasks, using Central Configuration Manager (CCM) and Central Management Console (CMC).
• Scheduling/ Publishing the reports on daily and weekly basis to the users Inbox
• Created annual and quarterly finance reports of the Client in Crystal Reports 2008 using complex functions, drill-down and graphical formatting features.
• Extensively worked on Creating, Updating and maintaining Universes using BO Designer.
• Creating various sub queries, master and detailed reports using Webi Rich Client and joined them at Info View using Hyperlinks.
• Created Dashboard using CrystalXcelsius.
• Created and trained end users in understanding the reports. Functionalities such as Slice and Dice, Prompt, Drill mode and Ranking were used for Multidimensional Formatting.
• Expert in creating several complex reports (including multi groupings, parameter fields, formulas, retrieving data from more than one database) using Crystal Reports.
• Responsible for SQL Tuning and optimized using Explain Plan, Indexes, Optimizer hints.
• Exported the Universe to Repository for making available to Business Objects users and Web Intelligence users.
• Creating the Reports using the Universes as the main Data providers and writing the complex queries including Sub Queries.
• Extensively worked on creating financial reports like Division, Asset range report, Headcount of Employees Responsible for writing the SQL queries for data validation and testing the reports.
• Experienced working on various Parts of ETL including Address Cleaning using Data Services.
• Exporting the Reports to the Document Agent Server and Used the Broadcast Agent server to Schedule and Monitoring the Reports.

Environment: SAP Business Objects XI R2/R3, Crystal Reports XIR2, Designer, Desktop Intelligence, Web Intelligence,SAP Business Objects Data Services XI 3.1, Xcelsius 2008, SQL Server 2005, Web Intelligence 6.5, Windows XP.

Confidential, Richardson, TX Duration: Jan’07 – Feb ‘08
Position: Business Objects Developer

Roles and Responsibilities:

• Extensively involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed, and managed Universes in BO Designer for creating reports against SAP BW.
• Created New Classes, Objects, Resolved Loops, Traps etc in designing the Universes.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Worked with BI Consultants in Data Modeling, Data Extraction, Data Loading (Full/Delta Upload), Scheduling and Monitoring.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Extensively used Calculations, Variables, Break Points, Drill, and Slice and Dice for generating reports using Info View, Rich Client.
• Defined Hierarchies in Universe to provide the users with Drill down option in Webi reports and Predefined Conditions to use in Business Objects.
• Defined Aliases and Contexts to resolve loops in the universes.
• Created reports using @Prompt Function and defined various Formula Variables.
• Designed, developed and published the reports using Crystal Reports XI.
• Developed the effective Drilldown Reports, cross tab Reports, Parameterized Reports and Formula Reports using Crystal Reports XI.
• Created Dashboards to monitor business performance, insightful analytics, and role based dashboards with dashboard manager and Xcelsius 2008 for dynamic data visualization.
• Automated document Scheduling, Publishing and Distribution for WebI and Info View clients using Broadcast Agent server.
• Involved working on some of theData Cleansing and Data Integration Transformations.
• Working closely with End users, Involved in user Training.
• Developed the detailed Step by Step Documentation.

Environment: Business Objects XI R2/v6.5, Data Integrator XI R2, Data Quality XI R2 Crystal Reports, Crystal Enterprise 10.0, Designer, Desktop Intelligence, Xcelsius 2008, Web Intelligence, CMS, Erwin 4.0, SQL Server 2003, Oracle 9i, SQL and Windows XP.

Confidential, Bangalore, India Duration: Oct ’05 – Dec’06
Position: Business Objects Consultant

Roles and Responsibilities:

• Interaction with Business users on requirements gathering for report and universe development.
• Performed requirement gathering, developed the report specification and universe specification based on the existing system.
• Expert Creating, testing the new and updated Universes and writing detailed test cases, resolved Loops and Traps, joined tables using cardinalities.
• Developed Business Objects reports using Business Objects full client, Info View using calculations, variables, filters, conditions, breaks, sorting, drill down and slice and dice.
• Developed Business Objects reports connecting various data sources like Business Objects Universes, Excel spreadsheets and exported the Reports and Universe to BO Repository.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Scheduled Business Objects reports using Broadcast Agent (BCA).
• Worked closely with Business analysts and database administrators.
• Worked on Toad to run SQL queries for validating Business Objects reports.
• Prepared month-end reports for General Ledger, Net Investment, Interest, Fees and Incomes
• Automated document Scheduling, Publishing and Distribution for WebI and Info View clients using Broadcast Agent server.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Data Integration.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs.

Environment: Business Objects 6x, Data Integrator, Designer, Desktop Intelligence, Web Intelligence, CMS, Crystal, Oracle 8i, SQL, Toad, MS Excel, SQL Server.

Confidential, Hyderabad, India Duration: Aug ‘04 - Sept ‘05
Position: Oracle Developer

Roles and Responsibilities:

• Implemented various business rules for creating database tables, indexes in ORACLE RDBMS using appropriate constraints and database triggers.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Analysis Design & coding of the specifications.
• Involved in Database Programming & Interfaces.
• Developed database triggers, procedures and functions to monitor the business functionality and needs.
• Corporate training in Business Objects.
• Developed Business Objects universe and reports.

Environment: Oracle 8i, Business Objects, SQL, PL/SQL, UNIX, TOAD and Windows XP.

• Bachelor of Engineering (Computer Science & Engineering) – Confidential , India