SUMMARY

• More than 7+ years in SAP BI/BOBJ Consultant with extensive experience in building EDW (Enterprise Data Warehouse) using BI. Good experience in BW, BOBJ with cross functional solution expertise and was involved in several end to end SAP BOBJ, Data Services and BW implementations
• Highly experienced in BOBJ and relevant tools like Dashboard Design 4.0, Data Integrator, Data Quality, Data Services Designer and Data Services Management Console.
• Strong Experience in SAP BI/BW 7.0/3.5 - Business Objects/ Crystal Reports, SAP BW-BO Integration, Creation of BI Queries (BEx) and Universes on top of Info Cubes & BI/ BEx queries.
• Experienced in Crystal Reports, Info View, Web Intelligence, SAP Integration Kit, Xcelsius and BO Explorer.
• Extensively worked in various features in the Business Objects Web Intelligence and crystal Reports such as Pre-defined Filters, Prompts, Cross-Tab, Report Linking, Sub-Queries/ Sub-reports, Slice & Dice, Hierarchies, Drill Down, Charts/ Graphs, Report layout/ format features etc.
• Highly experienced in designing dashboards and all the necessary reporting elements like webi reports, universes, wsdl’s, queries etc
• Performance tuning by maintaining Aggregates, Compression, Partitions, indexing of Info Cubes and use of BW Statistics, OSS Notes application to tune the Oracle Database.
• Responsible for designing and developing data migration applicationsfor the Extraction, Transformation and Loading of data from multiple sources into SAP ECC and SAP BW.
• Worked in projects involving SAP Data Migration, SAP Data Cleansing, Pro-Active Data Validation, Data Object Planning, Definition, Mapping, Migration & Consolidation
• Responsible for developing conversion and migration projects using SAP Data Migration Framework/AIO Methodology templates.
• Experience in documenting Functional, Technical Specifications and Test Cases.
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills with ability to interact with end-users, managers and technical personnel

PROFESSIONAL EXPERIENCE

Confidential, Plymouth, MN

SAP BOBJ Consultant

Responsibilities:

• Extensively worked with the end users to gather the reporting requirements.
• Created complex technical documentation for the business requirements.
• Created complex sales reports in SAP Business Objects including complex cross tab, summary reports.
• Created universes using derived tables and materialized views.
• Created universes and resolved loops and Traps by table aliases and contexts.
• Involved in Up gradate on of reports from SAP Business Objects 6i to Business Objects XIR2.
• Created Standard reports, Complex charts and Drill Down Reports using Business Objects XIR2.
• Created Ad-hoc reports using SAP Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down Functions.
• Responsible for designing, developing and delivering Fleet Dashboard that will provide the increased visibility of their operations to the Business Finanace teams and Management teams.
• Provided access to cross domain information from single shot by building dashboard for 9 sub areas.
• For each sub area a detailed and Dashboard WEBI reports are built.
• The dashboard provides an executive and toolkit view to support the decision making process across the organization.

Environment: SAP BW 3.5, SAP R/3 4.7, ABAP/4, BEx, Visual composer

Confidential, Billerica, MA

SAP BOBJ Consultant

Responsibilities:

• Create Webi-reports using Rich Client and Info-view
• Created SAP Business Objects Webi reports that provided Provider volume details
• Created complex sales reports in SAP Business Objects
• Evaluate/compare features between XI 3.1 vs 4.0
• Worked with internal resources to troubleshoot and resolve existing report and server issues
• Troubleshoot SAP Business Objects environment related issues
• Worked with Staff to transfer Business Objects knowledge across Team
• Troubleshot user/report issues
• Data migration, consolidation, reporting redesign project. Business need is to eliminate data quality issues, enhance the accessibility and usability of information, harmonization of data and reports and improve the efficiency of reports.
• Gathered information from clients regarding business requirements by conducting multiple workshops with business & functional to research existing business and system

Environment: SAP Business Objects XI 3.2, SAP BI/BO 4.0, Business Objects XI 4.0/3.1 Designer, WEBI, Info view, WEBI, Rich client,Oracle R12. MS Sql Server 2008, Sql Developer, Sql Server 2008 Management Studio

Confidential, Atlanta, GA

SAP BOBJ Consultant

Responsibilities:

• Responsible for designing, developing and delivering Fleet Dashboard that will provide the increased visibility of their operations to the Business Finanace teams and Management teams.
• Provided access to cross domain information from single shot by building dashboard for 9 sub areas.
• For each sub area a detailed and Dashboard WEBI reports are built.
• The dashboard provides an executive and toolkit view to support the decision making process across the organization.
• Responsible for Performance tuning using the KPI Store model and data is migrated into these data stores using SAP Data Services.
• Part of end to end project lifecycle and proudly rolled out the project to the Business Groups with proper training and transition.
• Worked closely with SAP dev team to iron out the various product bugs in the latest BOBJ toolset
• Worked with the latest BOBJ toolset like Data Federation, Information Steward, Universe Design Tool, WEBI Rich Client etc.

Environment: BI 7.0, ECC 5.0, ABAP/4, BEx, Business objects XI 3.1 Designer, WEBI, Info view, crystal reports 2008

Confidential, Houston, TX

SAP BI / BO Consultant

Responsibilities:

• Responsible for data migration, consolidation, reporting redesign project. Business need is to eliminate data quality issues, enhance the accessibility and usability of information, harmonization of data and reports and improve the efficiency of reports.
• Gathered information from clients regarding business requirements by conducting multiple workshops with business & functional to research existing business and system
• Designed and developed multiple complex batch jobs to fetch the data from different sources ranging from PRD and Non PRD data sources, cleanse, standardize, address correction and standardize...etc.
• Designed and developed a migration solution to load data from Brazil and Argentina legacy systems into the PRD system using SAP Data services
• Developed a migration strategy and relevant objects to load supplemental data into BW and send the data into HFM.
• Established a Common Data Warehouse integrated with HFM to eliminate reporting differences and reconciliation.
• Worked in development of a coherent and comprehensive testing strategy and rolled out to several business finance groups across the globe.

Environment: SAP BI 7.0, BW 3.5, SAP ECC 5.0, R/3 4.7, ABAP/4, BEx, Web Application Designer, Business Objects XI 3.0/3.1 Designer, Crystal reports

Confidential, Cedar Rapids, IA

SAP Business Object and Crystal Report Consultant

Responsibilities:

• Extensively worked with the end users to gather the reporting requirements.
• Created complex technical documentation for the business requirements.
• Created complex sales reports in SAP Business Objects including complex cross tab, summary reports.
• Created universes using derived tables and materialized views.
• Created universes and resolved loops and Traps by table aliases and contexts.
• Involved in Up gradate on of reports from SAP Business Objects 6i to Business Objects XIR2.
• Created Standard reports, Complex charts and Drill Down Reports using Business Objects XIR2.
• Created Ad-hoc reports using SAP Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down Functions.

Environment: SAP BW 3.5, SAP R/3 4.7, ABAP/4, BEx, Visual composer

Confidential, San Diego, CA

SAP BI / BO Consultant

Responsibilities:

• Extensively worked with the end users to gather the reporting requirements.
• Created complex technical documentation for the business requirements.
• Created complex sales reports in SAP Business Objects including complex cross tab, summary reports.
• Created universes using derived tables and materialized views.
• Created universes and resolved loops and Traps by table aliases and contexts.
• Created Ad-hoc reports using SAP Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down Functions.
• Responsible for preparing the mapping documents.
• The business need is to design and develop a common source for information to improve accuracy and the ability to Automate and Govern.
• Developed complex jobs, workflows, data flows to load the data into SAP BW from various systems using various transformations like table Comparison, Merge, Pivot, Case, Query etc in Data flows.
• Worked in Business Objects Data Quality (Address Cleansing) tool for cleansing customer master data using Data Services
• Automate & govern the data flows between all systems (SAP, BW, HFM, BPC).

Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence, SQL Server 2008/2005

Confidential, Parsippany, NJ

SAP Business Objects Developer

Responsibilities:

• Created Universes using Business Objects and resolved loops and Join problems by creating Aliases and Context.
• Responsible for analysis meeting with end users and business units in order to define the requirements.
• Experience in translating business requirements in to technical/data element requirements.
• Involved in gathering the requirements for reporting from the end users.
• Used Broadcast Agent to schedule the reports.
• Migration of Universes and reports from development to Production environment.
• Modified Universe after analyzing areas of business and user requirements
• Use of slicing and dicing for generating master/detail and tabular reports
• Experience in creating application schema as tables, view and indexes.
• Created Full Client Reports making use of Business Objects functionalities, like Multiple Data Providers, Prompts, Slice and Dice, Drill Down/Up.
• Involved in preparing detailed ETL design documents, unit test plans for the mappings.
• Scheduled and monitored using Broad Cast Agent.
• Created Dashboards based on the requirement.

Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Data Integrator & Services, Web Intelligence, Business Explorer (Polestar) XI 3.1, T-SQL, Oracle PL/SQL, Info View, CMC.

Confidential, Princeton, NJ

SAP BI / BW Developer

Responsibilities:

• Conducted requirements gathering and workshop sessions with Business Analysts and users. Documented detail requirements and Design Specifications.
• Created detail technical specifications from functional specifications. So that the off-shore team can work on data provisioning and reports/dashboards
• Extensively involved in Data Extraction from legacy applications, non-SAP sources and ECC
• Worked extensively with the LO cockpit to activate, configure and customize the necessary data sources related to sales and purchase order.
• Created Info Packages for required data sources and configured them for Full, Delta updates, to schedule loads in batch and Ad-hoc.
• Analyzed and adjusted Info Cube Data Models for unbalanced and degenerative dimensions and inefficient transfer/update rules.
• Created transformations with formulas and routines to implement business rules.
• Created and customized the DTP's for the required data targets. Activated master data in them and made the data available for reporting
• Optimized query performance by implementing performance techniques Aggregates, OLAP Cache maintenance, Indexes, compression etc
• Created process chains and scheduled them for execution on daily, weekly and monthly basis.
• Designed 3 OLAP Universes for Sales Reports and modified existing Finance Universes as per the requirements using BOBJ Designer

Environment: SAP Business Objects XI 3.1/3.2,Xcelsius 2008, Crystal Reports 2008, Web Intelligence, Business Explorer (Polestar) XI 3.1, SAP BI/BW 7.0.

Confidential, Cleveland, OH

Report Developer

Responsibilities:

• Managing and publishing Crystal Reports using Crystal Enterprise
• Actively participating in the design and review of the new reports standards.
• Responsible for developing and maintaining Crystal Reports, development cycle of client requirements, analysisclient needs
• Educated end-user about database construction through Data Dictionary
• Create business users and grants privileges.
• Interact with business users and support them if any problem arise
• Running and testing required queries and reports before publishing and test the performance
• Maintained high level of customer satisfaction with custom reporting services from both internal and external customers.
• Involved in Creation of ad-hoc Crystal Reports, Created ODBC Connections, database Connections, stored procedure using oracle.
• Customized data by adding Filters Calculations, Prompts, Summaries and Functions

Environment: Windows Server 2000/2003/XP, Universe, Crystal Reports 2008, Data Integrator, Xcelsius 2008, BEx Query designer& Analyzer, Info View, CMC, Oracle 10g, SQL Server 2005.

Confidential

Business Objects Consultant

Responsibilities:

• Responsible for Extracting, Transforming and Loading data from Oracle, XML, Flat files and placing it into Data warehouse.
• Worked extensively with mappings using expression, aggregator, filter, lookup and procedures to develop and populate Data Warehouse.
• Created sessions and batches to run the mappings and set the session parameters to improve the load performance.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the Hierarchies.
• Resolved join path problems like fan trap and chasm trap.
• Created hierarchy and conditions at the designer level.
• Created various reports using universes as the main data provider.
• Created daily, weekly, monthly and quarterly reports for the management team and field operation Managers using Business Objects Reports.
• Creation of different types of reports such as master/detail, cross tab and chat for trend analysis.
• Involved in Development of Complex Reports using methods like Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulas etc.

Environment: Business Objects 6.5, Designer, Reporter, Oracle 9i/10g, Windows NT, SQL Server 2000/2005