SUMMARY:

• Around 7 years of SAP Business Objects BO experience and Business Intelligence Business Warehousing.
• Extensive experience in working with multiple projects encompassing multi-cultural teams from diverse geographical regions.
• Experience working for corporations across diversified industry verticals includes Pharmaceutical, Retail, Manufacturing.
• Proficient with Business Objects Reporting tools and Business Intelligence applications using SAP Business Objects Business Intelligence 4.0 with BI Launch Pad, SAP Business Objects Enterprise XI R3.1/R2, with InfoView.
• Implemented 2 complete Lifecycle Data Services projects including requirement gathering, data modeling, extractions, data staging, data cleansing, data quality and transformations and reporting.
• Expert in Data Services Data Quality DQM like address cleansing and data cleansing process.
• Installed the All in One AIO Best Practices Projects, Data flows, Work flows and transformations and Data Quality DQM like address cleansing and data cleansing process.
• Involved in installation of standard SAP Data Services, delivering Best Practices in Data Migration.
• Data Object Planning, Definition, Mapping, Migration Consolidation.
• Performed BO Admin duties, Adding New users and user groups, setting up Security Migrating Reports/Universes etc.
• Experience working with Web Intelligence,Web Intelligence Rich Client WEBI , Desktop Intelligence, Crystal Reports 2008 2011, Xcelsius 2008 Dashboards 4.0 , Central Management Console CMC , Query as a Web Service QaaWS , Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Experienced in working on Design Studio 1.3.
• Excellent knowledge in implementation of Relational Database OLTP and Data Warehousing systems OLAP and Data Marts.
• Experience in Business Requirements Analysis and Documentation.
• Used Dashboard design tool to build interactive dashboards to be used by executive management.
• Extensively worked on developing Dashboards, Analytics, and Metrics using Performance Management.

Used BEX queries developed in SAP BI/BW 7.1 as a data source for the universes built in SAP BO/BI 4.0

Expertise in generating the Complex Crystal Reports like On Demand reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Ad Hoc Reports, Summary Reports, Linked Reports, Mailing Labels and Aging Reports.

• Good Experience in creating Corporate Dashboards, Scorecards, Performance Metrics, Rules, Alerts, Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart and Goals using Xcelsius 2008.
• Hands on experience in creating BOXcelsius dashboards and KPI's to large-scale multi-layer reports.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively with Team members, developers, clients and end users in a diverse environment.

TECHNICAL SKILLS

• BO Tools: SAP BO4.1, 4.0, SAP Business Objects XI 3.1/XIR2, Xcelsius 2008 Dashboard Design ,
• Crystal Reports 2011/2008, Universe Designer, WebI, DeskI, QaaWS, BIES/BICS,
• BOBJ Explorer/Polestar XI 3.1, CMC, InfoView, BI Launch Pad, Analysis - Edition for Microsoft Office.
• Data Modeling: Dimensional Data Modeling Star Schema, Snow-Flake ,FACT, Dimensions , Physical and
• Logical Data Modeling, Entities, Attributes, Cardinality, ER Diagrams, ERWIN
• 6.1/4.5/3.5, MS Visio, DB Designer
• SAP BW/BI:SAP BI 7.3/7.0, SAP BW 3.5
• SAP ERP:SAP ECC 6.0
• Operating Systems: UNIX, LINUX, Windows
• Databases: Oracle 11g, 10g/9i/8i/8.0, Sybase, SQL Server 2005, MS Access
• Other Tools: MS Office 2010/2007/2003 Excel, PowerPoint, Word, Outlook, Project ,Visual Studio, HP
• Quality Center, Remedy, SharePoint, Illustrator

Professional Experience:

Confidential

SAP BOBJ Consultant

Description: Confidential is the largest dental plan system in the United States. The Delta Dental Plans Association is composed of 39 independent Delta Dental member companies operating in all 50 states. These member companies provide coverage to 59.5 million people, enrolled in over 97,900 groups.

Responsibilities:

• Created Complex reports using diverse business objects functions such as slice and dice, Master/detail, crosstab, user responses, formulas, multiple dataproviders and Combined Queries.
• Used features such as custom SQL, free hand SQL and stored procedures to build over 100 reports in WEBI and DESKI.
• Worked on Aggregate Awareness and Derived tables as Universe Optimization techniques.
• Used Xcelsius 2008 to build dashboards.
• Used natural and customized hierarchies in the universe to build reports with drill down and drill through functionality
• Created reports using Desktop Intelligence functionalities like Sections, Breaks, Filters, Alerters, slice and dice, drill down functions and formulas etc.
• Created linked reports for WEBI reports using open document functionality.
• Used variables for building complex BI reports
• Did WEBI reporting on BO universes based on BEX queries and SAP Info Cubes.
• Used Stored Procedures to create different types of reports with the help of command object.
• Export and Manage reports on the server. Schedule the reports in various formats in Info view for recurring reports.
• Performed documentation for the BusinessObjectsEnterpriseSystem, design, development, test plan, implementation and maintenance.
• Deployed Business Objects BOBJ Servers in Development, UAT and Production environments.
• Participated in all BI Testing cycles which involved unit testing, system integration testing, regression testing.
• Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the BOBJ Reports and Universes.
• Responsible for handling production support issues.
• Used Data Integrator in ETL activities. Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
• Creation of different data stores to get SAP tables, Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into oracle staging area. Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs.
• Created On-Demand Sub reports and Hierarchical Grouping.
• Developed various complex BI reports to display the leasing summary, Amount financed, Equipment listings.

Environment: SAP BO 4.1, Web Intelligence Rich Client, Dashboard Design, BI LaunchPad, QaaWS SQL server2008, Mobile BI, Analysis - Edition for Microsoft Office.

Confidential

Role: SAP BOBJ Consultant

Description: Massachusetts, officially the Commonwealth of Massachusetts, is a state in the New England region of the northeastern United States. For maintaining the resident's information and report SAP Business Objects SAP BOBJ tools were used.

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.
• Involved in designing Universe and migrating existing Desktop Intelligence Deski Reports to Web Intelligence Webi report.
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.

Used various Universe optimization techniques to improve query performance.

• Enhanced existing Universes and added additional Links, Joins according to the requirement and sorted Loops, Traps.
• Designed and developed Crystal Reports using Crystal 2011.
• Created Views, Stored Procedures, Queries and tables to create the reports.

Developed over 27 crystal reports, which were having high data complexity and business logic.

• Created dynamic and static parameter based report and scheduled it on the Crystal Server.
• Developed various Charts and Graphs like Bar Chart Side by Side, Stacked , Line graphs, Pie Charts etc by using Chart expert of Crystal Reports XI.
• Created company specific formula and used Crystal repository to store generalized formulas for reusability. Also Used Stored Procedure to generate reports.
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
• Used BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values LOVS , Alerts, Ranking and multiple data.
• Performed and coordinated System Integration Testing SIT and User Acceptance Testing UAT .
• Involved in creating Test plans and test scripts for User Acceptance Testing.

Environment: SAP BO XI3.1, Web Intelligence, Oracle 10g, Crystal Reports 2008, Xcelsius 2008, Import Wizard, and CMC.

Confidential

Role: SAP BI / BO Consultant

Confidential is a city in Washington, which was founded in 1875 by George Washington. The city provides various services and amenities for its residents. For maintaining the resident's information and report SAP Business Objects SAP BOBJ tools were used

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
• Extensively worked on SD InfoCube 0SD C03 and Data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider's 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
• Created new info providers in SAP BI depending upon the end user needs
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions, RKF's and CKF's.
• Worked on Central Management Console CMC in configuring BO environment.
• Defined BO Classes, Objects in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and InfoCubes of SAP BI using Universe Designer
• Extensively worked on Infoviewto create Web Intelligence Reports over the Universe Created.
• Created Webi reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked In creating Variables, Prompts in Webi.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Created Master/Detail, Cross tab, Chart templates reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Created reports with Charts bar chart, Pie chart, etc. , Cross-tabs and Sub reports.

Environment: SAP Business Objects SAP BOBJ , Enterprise XI 3.1 SP3 Designer, Desktop Intelligence, Web Intelligence, Info View, Import Wizard, Report Conversion Tool , Crystal Reports 2008, Xcelsius 2008, SQL Server 2008, Oracle 10g.

Confidential

Role: SAP BI / BO Consultant

Confidential is a global leader in IT Solutions Services. The services include expertise in business and technology consulting, application services, system integration, SAP upgrades, customsoftware development, maintenance and support, re-engineering, and outsourced support.

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
• Extensively worked on SD InfoCube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider's 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
• Created new info providers in SAP BI depending upon the end user needs
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions, RKF's and CKF's.
• Worked on Central Management Console CMC in configuring BO environment.
• Defined BO Classes, Objects in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and InfoCubes of SAP BI using Universe Designers UDT and IDT.
• Extensively worked on Infoview to create Web Intelligence Reports over the Universe Created.
• Created Webi reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked In creating Variables, Prompts in Webi.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Created Master/Detail, Cross tab, Chart templates reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Created reports with Charts bar chart, Pie chart, etc. , Cross-tabs and Sub reports.

Environment: SAP Netweaver 04s BI 7.0 , ECC 6.0, CO, FI-GL, SD, BEx Analyzer, BO XI R2, Webi.

Confidential

Role: SAP Business Objects Consultant / Reports Developer

Description: This project involved designing several forms to process sales orders, updating new products and prices, updating the customer information, preparation of online. Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalizing the relations, creating Tables, Views, Indexes, Sequences and coding.

Responsibilities:

• Involved in developing, designing and maintaining new and existing universes with Classes and Objects.
• Involved in migration of Universes, Reports, and Users from BO 6.5.1 to BO XI 3.1.
• Deployed Business Objects BOBJ Servers in Development, UAT and Production environments.
• Tested and implemented Service Packs and Fix packs to resolve identified issues and bugs in Business Objects XI 3.1
• Installed and configured BOBJ desktop applications such as: Designer, Desktop Intelligence Deski , Web Intelligence Rich Client and Crystal Reports Client.
• Extensively used Designer to design various universes for different groups. Created complex reports using cascading prompts, decode objects etc.
• Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the BOBJ Reports and Universes.
• Extensively used the Import Wizard to migrate the universes, corporate documents, users and groups from the legacyBO to the XI 3.1 version.
• Used Stored Procedures to create different types of reports with the help of command object.
• Export and Manage reports on the server. Schedule the reports in various formats in Info view for recurring reports.
• Created customized existing reports using sub-reports and charts to present information.
• Created the Crystal reports using Oracle tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.
• Installed Web intelligence on the server and configured the IIS console to define the paths aliases necessary to run WEBI.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Involved in Full project life cycle requirement gathering to implementation phase .

Environment: SAP Windows Enterprise Server 2003 Apache Tomcat, SAP BusinessObjects SAP BOBJ EnterpriseXI 3.1SP2 Designer, Desktop intelligence, Web Intelligence, Import wizard, Publishing Wizard, Report Conversion Tool , Business Objects Integration for SAP Solutions XI 3.1, Business Explorer Query Designer ,Crystal Reports 2008, Crystal Xcelsius, SAP BW,SAP BI 7.0, Oracle 10g, Mercury Quality Center 9.