SUMMARY:

• SAP Certified consultant with over Twelve years of experience in Information Technology mainly in full life cycle implementations involving Analysis, Design, Development, Testing, Deployment, post - production support/maintenance, documentation, and end-user training.
• Experienced in Dimensional Database modeling & Design, preparing Software requirement specifications test Plans, UAT and test scripts
• Expertise in Business Objects suites: Installation, configuration and integration of systems, design, development and production rollout of Business Objects reporting Application.
• Expertise in Business Objects Reporting tools including (Business Objects 4.1/4.0/XI3.1/R2/6.x/5.x, CMC, Desktop Intelligence, Web Intelligence, Import Wizard, and Report Conversion Tool), Crystal Reports XI/10/9, and Crystal Xcelsius 2008/4.5
• Expertise in creating highly formatted canned reports and well versed with universe designing, report writing.
• Excellent experience with DW Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables. Experience includes designing, implementing and integrating various Data warehouse and Data Marts using Oracle 10g/9i, MS-SQL Server 2008, DB2.
• Expertise in Integrating and Extracting data into Business Objects environment from the SAP BW database system.
• Extensively worked on BEX, WAD reports.
• Experience in Migrating to BO XI R2/3.00 from previous versions (6.5.x and 5.1.x)
• Proficient in SQL, PL/SQL and extensively used PL/SQL in writing Views and Stored Procedures.
• Working knowledge of Business Objects Enterprise Performance Management & Xcelsius Dashboards
• Designed, Developed and maintained the Xcelsius dashboards in both Xcelsius 4.5 and 2008 using live data connecting via the Web Service connectors like QAAWS and LiveOffice
• Expertise in administration activities like creating and managing repositories, users, user groups, working with privileges in repository manager.
• Capable of improving the Business Process, have shown signs of Entrepreneurship & Strategic project management. Exceptional technical, liaison, and interpersonal skills have helped me taste success throughout my career.

TECHNICAL SKILLS:

Reporting Tools: BI Tools - Business Objects Enterprise Suite 4.2/4.0/XI3.1/XIR2/R1/6.x/5.x (Universe Design Tool, Information Design Tool, Web Intelligence, CMC and Supervisor), Crystal Reports XI/2011/2008,2016 Xcelsius 4.5/2008, Performance Management and Dashboard Manager, QAAWS, Live Office

Web Technologies: HTML, XML, VBScript, JavaScript

ETL Tools: Informatica PowerCenter 9.X, Data Integrator (BODS), SAP BW 3.5/7.0

Databases: SQL Server 2000/2005/2008/2016, Oracle 12c/11i/10g/9i/8i, DB2, Sybase and MS Access, Azure Sql

Languages: PL/SQL, SQL, T-SQL, .Net

Operating Systems: Windows 98/2000/NT/XP/Windows 7 Professional, UNIX

Servers: IIS 5.0/ 6.0,7.0 Web Logic Application Server 8.2 / 7.2 / 6.1, TOMCAT

Other Tools: TOAD, SQL Developer, MS Office, MS Visio 2003/2007, MS Project

PROFESSIONAL EXPERIENCE:

Confidential, Harrisburg PA

SAP BI Consultant

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements, analyzing, documenting business requirements, functional requirements for developing data models and reports.
• Worked on several projects including internal applications and public facing reports and applications like HBMS (Highway beautification Management System), KEES, EPS (Epermitting System), MEDS, MVDLS (Motor Vehicle Driver License System) using technology like Business Objects Suite and developed highly formatted reports
• Involved in several projects like Azure Cost Usage Reports, Eco lane which involved working with tools like PowerBI, Azure Sql.
• Involved in creating Data models for internal application and worked on created ETL workflows for projects like Gatekeeper for IBM DataPower activity using tools like Informatica Client.
• Involved in debugging tickets including informatica Jobs, Workflows and automating the tasks pertaining to the Jobs using Shell Script.
• Created Adhoc and complex canned reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values, local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.
• Worked on Power Bis latest features which includes and not limited to BookMarks, Modelling for PowerBI, Creating DAX expressions, R scripting and worked with Report server for working with multisource reports and scheduling the report to the POWERBI server.
• Attended AzureML Training Sessions when working on Machine Learning POC.

Environment: Informatica Power center 9.6, SAP Business Intelligence 4.2, Power BI, Universe Designer Tool, Information Design Tool, Web Intelligence, Crystal Reports 2016, CMC, CMS, Oracle, DB2, Sql Server 2017

Confidential, Morgantown WV

SAP BI Consultant

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements, analyzing, documenting business requirements, functional requirements for developing data models and reports.
• Involved in building Sales and Distribution (SD), Materials Management (MM) Information and Finance (FI) data models.
• Developed the Sales order, Delivery, Backlogs and Billing infocubes based on the client reporting requirements.
• Developed the Interactive and Formatted Dashboard Reporting.
• Extensively worked on Workbooks.
• Extracted the sales history data from non sap systems using DB Connect.
• Developed the dashboard reporting for sales related information and order fulfilment reports.
• Worked extensively with BI Content and customized SD and MM DSOs and Info Cubes to fulfil business requirements.
• Designed and developed custom info cubes, DSO’s and reports for material stock movement.
• Developed custom cubes, Delivery item detail cube, Shipment cost details cube as per the client requirements
• Created generic Data Sources to extract data from various Data Sources to achieve end-user requirements.
• Created process chains for periodic upload of master data, transactional data, and scheduled and monitored the data loads with delta update and full update mechanisms.
• Created Aggregates on Infocubes to improve the query performance.
• Developed reports billing conditions monthly, Combined Sales and Billing Details.
• Created Multiprovider to split Query process on various data targets, and Infoset on ODS to integrate data logically for optimal query performance.
• Created reports using Business Objects functionality like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formula's.
• Migrated reports from Development/Testing environment to Production Environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures and Freehand SQL to create reports.
• Created Derived tables to support business functionality.
• Evaluated BW Statistics on Infocubes and Aggregates to perform optimization for reporting.
• Worked as part of team involving Business Objects System Migration from 4.0 to 4.1

Environment: SAP ECC 6.0, SAP BI 7.0, FI-AR, FI-AP, FI-GL, FI-SL, SD, MM, ABAP/4, BEx Analyzer, Query Designer, Web Application Designer, Business Objects XI4.1/4.0, Universe Designer Tool, Information Design Tool, Web Intelligence, Crystal Reports 2011, CMC, CMS, Oracle.

Confidential

SAP BI Consultant

Responsibilities:

• Involved in the full life cycle implementation which includes Gap Analysis, design, development, testing, implementation and support.
• Understanding the business challenges and translating them into requirements.
• Extensively worked in Business Information Warehouse Info Cubes, DSO Objects, Infoobjects, Transformations and DTP’s and Routines.
• Created generic data sources with ability of delta functionality.
• Involved in Enhancements and Extractions by using different Modules.
• Created Adhoc and complex canned reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values, local variables, Alerts, Ranking and multiple data providers, sections, breaks, drill down reports and hyperlinked reports.
• Developed Web Intelligence reports from the Universes developed on BEx Queries by combining data from SAP and non-SAP data in a single report, including data from XLS, CSV, and Text files.
• Created/Modified Universes, Reports from the underlying Databases for different business modules.
• Given training to the Business Objects End users on BOE XI 4.0 New features and the New tool Web Intelligence Rich Client.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports, formatting sections, tables, inserting and organizing multiple breaks.
• Extensively worked on drill mode to view data in different Perspectives.
• Involved in Unit testing, System testing and User Acceptance Test (Dashboards and Reports) throughout migration process.
• Provided support in enhancement and maintenance of the Reports and Universes.

Environment: SAP Net Weaver BW 3.5/7, ECC6.0, SAP BO 4.0 Enterprise (Universe Design Tool, Information Design Tool, Web Intelligence, WebI Rich client, Metadata Manager), Xcelsius Designer, Qaaws, Live Office, BEx Queries, BEx Analyzer, Oracle 10g, SAP Integration Kit.

Confidential

SAP BI Consultant

Responsibilities:

• Closely worked with the Business Analysts and Involved in the meetings with Business Users for requirements gathering and providing inputs on the WebI XI R2 compatibility to the users and the BAs.
• Prepared the Report Design Specs and helped the off-shore development team, understand the Report Design specs, Universe Schema and providing them the inputs on the reports development and unit testing.
• Assigning the work to the offshore team (evening off-shore call for assigning work and morning off-shore call for daily updates and discussing their development issues) and providing daily updates to the client manager.
• Actively involved in the daily triage calls and closely working with the QA team and providing them report defect clarifications.
• Developed ad-hoc reports based on the user requirements (for UAT purpose).
• Took the weekly backup of the reports and the universe in DEV environment and deploy/migrate them on to ST and Pre-Prod environments for Testing and UAT purposes respectively.
• Administrative tasks such as creating groups, users, creating folder and moving reports and providing security to folders. Setup user authentication and authorization.
• Worked closely with developers on the universe enhancements and universe gaps based on the user requirements.
• Updated the standard universe provided by based on the user requirements.
• Worked on the SQL Views and derived tables for universe objects creation based on the business requirements to simplify the complex reports development.
• Established join conditions and checked for their cardinalities. Created classes, sub-classes, objects, dummy prompt objects, cascading prompts, contexts, and aliases.
• Worked on complex queries involving the Budget, Entities (Site, Project, facility), Forms, Auditing etc., Linked the result set from multiple data providers and used the functionalities such as combined queries, Drill Down, Open Document, Slice and Dice, etc.
• Developed different types of standard reports with drilling capabilities in tables, cross-tab and charts with complex calculations, Variables, Breaks, Sorting, and Alerts etc.
• Performed report data integrity check through running the query against SQL Server using SQL Server Management Studio. Performed extensive Report Testing includes UAT and Regression testing.
• Worked on performance tuning of the reports and made the necessary changes to the report queries and the variables to improve the query response time.
• Applied changes to the reports developed by other vendors based on the QA defects and the user requirements.

Environment: Business Objects XI R2, Universe Designer, Web Intelligence, Import Wizard, Report Conversion tool, CMC, CMS, Oracle 10g/9i, SQL Server 2005/2008, and Quality Center.

Confidential, Dallas TX

BO Developer

Responsibilities:

• Involved in initial analysis, requirements gathering and capacity planning at the time of major corporate Business Objects version upgrade to XI R2.
• Created and updated universes using Designer in Business Objects XIR2 based on the reporting requirements
• Developed different types of standard reports with drilling capabilities in tables, cross-tab and charts with complex calculation, and multiple data provider’s in both Full Client and Web Intelligence environments
• Involved on testing migrated reports in Business Objects DeskI and WebI reports from BO 6.5 to XI R2.
• Created Schedule task and distributed to end users for period-end and special request reports.
• A developed report with VB Macros to pass parameters while the report is scheduled and automatically emails to end-users as agnostic document.
• Performed Audit function for user activity statistics and monitoring the environment.
• Applied and corrected variable context corrections for reports in Deski.
• Worked on changes to existing WebI reports according to XI R2 in compatibility to existing reporting environment.
• Applied changes to existing WebI reports by performing formatting and other changes.
• Mapped previous version reports to point to test universe for verifying changes and used additional data providers to test the DeskI reports.
• Actively participated in performance tuning sessions and suggested some model changes to improve the reports performance and overall system performance
• Developed some Merchant and Transaction based Dashboards using Xcelsius
• Created Technical and Design Documents, Test Consideration Documents, Run documents for new Reports and universes.
• Performed report data integrity check through running the query against SQL Server using SQL Server Management Studio.
• Performed extensive Report Testing includes UAT and Regression testing.
• Prepared test cases for migrated and tested reports.

Environment: Business Objects XI R2/6.5, Universe Designer, Desktop Intelligence, Web Intelligence, Import Wizard, Report Conversion tool, SQL Server 2000/2005, Oracle 9i

Confidential, Springfield MO

BO Developer

Responsibilities:

• Thorough analysis of the legacy systems and gathered business requirements to in corporate the changes to meet the reporting needs.
• Interacted with Data Architects to get a clear understanding of the Dataflow and Database Design/Structure.
• Created the BusinessObjects Universe, Classes and Objects with the Collections warehouse and DLF System.
• Potential usage of alias, context, and joins concepts to resolve the loops.
• Designed aggregated tables on the most frequently queried data, and used @aggregate aware functionality in defining dimensions and measures. Setup custom hierarchies for drilldown paths.
• Worked extensively with @functions (@aggregate aware, @select, @prompt, @where) in the creation of dimensions, measures and conditions.
• Developed Complex Reports (Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts). Worked extensively with the major functionalities of BusinessObjects like Group By, query prompt, drill filter, and Breaks, Sorts, Ranking, Calculation using the Slice and Dice panel.
• Created user Prompts, conditions and Filters to improve the report generation. Also used Alerts to improve the readability of the report.
• Used Broadcast Agent Console to manage the schedules and prioritizing the scheduled jobs.
• Created required restriction sets to maintain the security for the users uing Supervisor.
• Created complex reports using multiple data providers like Oracle, SQL and Excel to extract data and also to Validate.
• Performance Tuning of Reports by creating Linked Universes, Joins, Contexts and Aliases for resolving Loops and checked the Integrity of the Universes using Business Objects Designer module during development.
• Regular Production moves after the project got the UAT sign-off involving Universes, reports, groups and categories.
• Ensuring data accuracy, connectivity and format changes if any along with security model after the production move.
• Re-creating/validating the universe connections, report data source information to ensure data is extracted from the correct source.

Environment: BusinessObjects 6.5.1, Desktop Intelligence 6.5.1, Designer 6.5.1, Supervisor 6.5.1, Oracle 9i, TOAD, Windows 200