SUMMARY:

• SAP BI/B0 consultant with over 6 years of experience, which includes experience in Business Intelligence and Business Objects as a technical and functional consultant playing various key roles in Design, development, Production support and reporting techniques across modules including modules FI/CO, HR, SD, PP, MM.
• Extensively worked on SAP Net weaver 2004s BI 7.1 Ehp1/7, SAP BW 3.5/7.3 versions with experience in analysis, design and development using Administrator Workbench, Business Content, Data Modeling and Extraction from different source systems and flat files.
• Experienced in Analysis, Design and Development of various Data Warehousing projects using SAP Business Objects Data Services, Data Integrator, Business Objects XI.
• Experience in the Business Requirements Analysis, Application Design, Dimensional Data Modeling, Development, Testing, Implementation, maintenance, documentation.
• Worked on SAP Business Objects XI 3.1,4.0, XIR2, 6.x, and 5.x Suite (Desktop and Enterprise Server products suite), Web Intelligence, Voyager, Performance Management and Dashboard Manager, Xcelsius, Data Integrator/Data Services.
• Expert in SAP Business Objects Designer, Bex Query Designer, Voyager, Desktop Intelligence, Supervisor/CMC, Info view, Full - Client, and Web Intelligence tools.
• Experience in CMC, User Setup, User Rights setup, Folder level restrictions setup, job server settings, reports.
• Good Experience and analytical skills in reporting requirements into drill-down/drill-across universe support, and review designs with business users.
• Excellent skills in analysis and business requirements gathering from end users to the client and experience in documentation of developed applications.
• Sound knowledge in Star & Snowflake Schemas.
• Developing all Data Integrator mappings to load data from multiple SQL Server data sources for load into a custom reporting data mart.
• Effectively tested and documented all Jobs/Workflows/Dataflows.
• Expertise in translating business reporting requirements into universe strategies and design.
• Good Experience in architecture.
• In-depth knowledge in creation of WEBI reports and Dashboards using Xcelsius.
• Knowledge of migration from Crystal reporting to SAP Business Objects and end-users.
• Worked on Bex Query Designer by performing advanced data analysis and hierarchical member selection within the SAP BusinessObjects query and analysis tools such as SAP Business Objects Web Intelligence, SAP Crystal Reports Enterprise and SAP BusinessObjects Dashboards.
• Experience in Full Software development life cycle (SDLC) knowledge from Requirements Gathering, Technical Design, analysis, development and support.
• Proficient in setting up Repository, creating and managing users and user groups and security.
• Proficient in creating reports using Business Objects XI R2 functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Proficient in SQL, PL/SQL developed Stored Procedures, Triggers, Functions and Packages besides writing DDL, DML and Transaction queries with development tools like TOAD.
• Configuration of basic operating system software RDBMS (Oracle), providing UNIX level support to DBA/Application administrator.
• Flexible and resourceful, applying strong organizational, time-management and planning skills to deliver projects on time and budget, despite intense pressure and aggressive timelines.
• Ability to communicate effectively with all levels of management and the client community.
• Implemented 2 complete Lifecycle Data Services projects including requirement gathering, data modeling, extractions, data staging, data cleansing, data quality and transformations and reporting.
• Experience with Data Quality Management Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Profiling, Data Quality, and Data Model Standards.
• Extensive experience and solid understanding of Data Warehousing, Star, Snow Flake Schema Modeling, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.
• Experience in integrated planning in creation of web & excel based planning applications.
• Experience in Data modeling using Info Cube, Multi Provider, DSO, Info Set, Info Sources and Data Sources.
• Enhanced Data Sources and Created Generic Data Sources as part of Extraction.
• Expertise in BW authorizations and security by creating Authorization Profiles using Profile Generator.
• Excellent knowledge in implementation of Relational Database (OLTP) and Data Warehousing systems (OLAP) and Data Marts.
• Hands-on Expertise in Data Loading (Full/Delta Load) of Master and transactional data from SAP R/3 system.
• Developed Update and Transfer Routines in BW to implement business rules and conversions while extracting data from R/3.
• Proficient in writing ABAP user exits for transaction data and along with start routine, end routine and update routines.
• Experience in APO demand planning and supply network planning.
• Designed and developed queries for reporting using Query Designer and Web Application Designer.

EXPERIENCE:

Confidential, Jackson, MI

Sr. SAP BIBO Consultant

Responsibilities:

• Gathered and analyzed requirements from Business Groups and senior executives using Agile Scrum Methodology, document them and involved in uploading them in HPQC.
• Collaborated effectively with Business Owners, various Project Managers, Business Analysts, Quality assurance team and other team members in the Analysis and gathering of Requirements.
• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Creating, modifying, maintaining and managing Universes and implementing row level security.
• Maintenance, support, administration of SAP Business Objects XI R4.0/R3.1/R2 and SAP Business Objects 6.5 environments.
• Interacted with business managers and end users to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP Business Objects Universes and Reports.
• Created different Universe and Document domains.
• Involved in the designing and Building of Universes, Classes and Objects.
• Resolved loop and traps using Contexts and Aliases.
• Exported the universes to the Repository to making resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created the reports using various SAP Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Developed both Full client and WEBI reports.
• Experience in Crystal Xcelsius to create interactive dashboards by using QAAWS and Live Office.
• Used Live Office and QaaWs (Query as a Web Service) to feed live data into Xcelsius 2008 to show product portfolio.
• Created complex Xcelsius dash boards to reflect User Adoption Metrics.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
• Set up groups and users for SAP Business Objects deployment.
• Managed user profiles using Supervisor.
• Published and scheduled SAP Business Objects Reports to users using BCA Scheduler and SDK.
• Gathering requirements and creating dashboards using Crystal Xcelsius.
• Hands-on experience in the application of the more advanced capabilities of Xcelsius such as trend analysis, predictive analysis, drilling, graphic design, dynamic adjustment of X & Y axis as selections changes.
• Created interactive dashboards from Microsoft Excel or a live data source and export your dashboard to a familiar format like M.S. Office, Flash (SWF) files, Adobe PDF, and Adobe AIR.
• Extend, manage, and secure access to real-time company data with one-click export of your Dashboards to SAP Crystal Reports Server and corporate portals.
• Experience in building complex reports with stored procedures, sub reports, with graph etc .
• Develop and deploy performance dashboards and business applications connected to your corporate database.
• Designed Job/Workflow/Dataflow structure for optimized batch load performance.
• Effectively tested and documented all Jobs/Workflows/Dataflows.
• Involved in loading of data into Teradata from legacy systems and flat files using complex scripts.
• Extensively used Teradata and Oracle utilities such as Fast Load, Multiload, Tpump and Toad.
• Involved in using Excel, Excel VBA, and Teradata SQL to analyze the data and calculate results.
• Experience in developing dimensional modeling solution based on SAP Data Integrator backend.
• Developing all Data Integrator mappings to load data from multiple SQL Server data sources for load into a custom reporting data mart.
• Worked extensively on LO Cockpit. Enhanced extract structures.
• Modified standard and created custom info sources, data sources, info objects, ODS and Info Cubes.
• Loaded data like shopping cart (0BBP TD SC 1), Purchase Orders (0BBP TD PO 1) and Invoices (0BBP TD INV 1) into BW.
• Designed Generic data extractors to extract/cleanse and transform the data to suit the Business Warehouse model.
• Created custom LIS structure 2LIS 01 S720 for management summary update in BW.
• Data extraction from SAP R/3 (FI/CO) into the SAP BW.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source and worked in office analytics.
• Generated month to date and year to date reports for FI and monthly distribution reports for Human Resources
• Experience in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Created inventory accuracy Dash Boards (Xcelsius) and for management reports for inventory management and wages and costs report from cost center accounting.
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Designed, developed and maintained Universes for supporting Adhoc and Canned reports.
• Maintained security for the end users by giving privileges with supervisor module.
• Used BO universe as an input to Xcelsius using Query as a Web Service.
• Utilized Xml, Sql services, Webservices, oracle sources for generating dashboards.
• Made graphical analysis and dashboards.
• Coordinated with ETL, Data warehouse team to implement the Star Schema modeling.
• Created Context, Alias to resolve the Loops in the universe.
• Created user objects to enhance the reporting needs.
• Object properties (Dimension, Measure & Detail) are defined properly at the design level so that it does affect the reports and charts.
• Created Filters (Condition Objects) to improve the report generation.
• Created Hierarchies from providing drill down options for the end-user.
• Maintained security for the end users by giving privileges with Supervisor.
• Created the Derived and Aggregate Tables.
• Detected cardinalities and checked the Integrity of Universes.
• Created variables, @prompt (Interactive objects), formulas and etc.
• Created Standard reports, Summary, Cross Tabs, sub reports using Crystal Reports.
• Using various visual analytics, themes, colors, and fonts, customize the look and feel of dashboards to fit the corporate standards.
• Increase productivity by consolidating multiple reports into a single live dashboard.
• With point-and-click ease, created live business dashboards from any Microsoft SQL Server Reporting
• Maintained whether the SAP Crystal Dashboard Design visualization is deployed to Info view, Dashboard Builder, orembeded inside Microsoft Office and Adobe PDF.
• Summarize rows of data in easy-to-understand charts and maps and provide report-level details.
• Creating interactive Xcelsius dashboards by using QAAWS and Live Office.
• Created complex Xcelsius dash boards by connecting directly with existing Crystal Reports and XML files.
• Fast-Load, Multiload, BTEQ & Fast-Export were the Teradata utilities used.
• Designed and created macros using Excel and VBA, including a macro to get customized reports.

Technical Environment: SAP Business Objects XI R2/R3.1/4.0,6.1,6.5, Data Integrator/Data Services, Web Intelligence, Xcelsius 2008/4.5, Designer, Supervisor, CMC, Oracle 11g/10g/9i, Terradata, MS SQL server, Crystal Reports 8.0, Crystal Reports 2016, Windows NT, PL/SQL, Windows NT, UNIX, IIS, SAP ECC 6.0, SAP BI 7.0 / BW 3.5/7.3, SAP BOBJ, FI/CO, GL, AP, AR, SD, HR, CRM, SRM, HR, WM, QM, APO, PM, IM, OTC, WPM.

Confidential, Minneapolis, MN

Sr. SAP BIBO Consultant

Responsibilities:

• Created the Regression Test Suits for BW extracts / reports.
• Maintained the Regression Test Suits based on the changes implemented as part of Change of Request.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for SAP Business Objects Universes and Reports.
• Involved in the designing and Building of Universes, Classes and Objects.
• Resolve loop using Contexts and Aliases.
• Exported the universes to the Repository to making resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Created the reports using SAP Business Objects functionality's like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae's etc.
• Created Schedulers to monitor Broadcast Agent.
• Built full client and WEBI reports.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems.
• Created SAP Business Objects Repository while building SAP Business Objects solution.
• Created and tested classes and objects to organize the universe.
• Published and scheduled SAP Business Objects Reports to users using Scheduler.
• Created and Maintained load jobs using BTEQ, FASTLOAD and MLOAD in Terradata.
• The new reporting tools being used are Xcelsius, WEBI and Crystal Reports.
• Worked in creation of Regression Test scenario in BW Reporting related to SAP FICO
• Worked in execution of Regression Test scenario related to BW, EDW, SAP BPC, Opportunity to Cash, Manufacturing to deliver and Reconciliation; update the test result in HPQC.
• Involved in the postproduction support, which required Info cube management using Compression, Rollup, and Reconstruction, Indexes and Partitioning and performance tuning using Aggregates/ Multi providers.
• Liaison with Business to understand the impact of Change Request.
• Involved in complete phase of testing (Unit testing, User acceptance testing, Data validation testing) and validated data between BW and R/3. Involved in testing of BW reports in SD & MM and validated the data between R/3 system and BW. Conducted training on BEx usage for Business Users and Web training and new features for Team Members.
• Involved in creating custom Master data Info Object with compounding characteristics.
• Used SD Sales overview Info Cube (0SD C03), Customer (0SD C01)
• Assigning data sources to the Info Source, defining transfer structure, configuring the extract structures for replication and updating of data source from the source system.
• Created the Process Chain Process.
• Discuss with the Business scenarios to be tested for the Regression for the impact of Change Request.
• Coordinate with the team member to execute the Regression Testing and update the results in share point.
• Creation of business process test cases and upload to solution manager.
• Create the SAP FICO Reporting Business Scenario for Regression Testing.
• Execute the Regression Test Script and update the test results in HPQC and generates the report in HPQC.
• Work with Business to explain the impact analysis and finalize the Test script to be executed during regression testing.
• Coordinate with Offshore team to write the test script and to monitor the test execution.
• Worked extensively on LO Cockpit. Enhanced extract structures.
• Modified standard and created custom info sources, data sources, info objects, ODS and Info Cubes.
• Did Formal and Informal testing of all the Objects.
• Written Test Scripts for all the Objects tested. Provided Testing Support to the Team and find the bugs in Universe.
• Also worked parallel with other project CSB6.0 and Banking Tracking Projects for creating reports and writing validation documents.
• Involved in solving loops in CSB Universe and removed bugs.
• Extensively used Teradata utilities such as BTEQ, Fast Load, Multiload.

Technical Environment: Business Objects 6.5, Business Objects 4.2, BI4.2, WEBI, Designer, Supervisor, Broadcast Agent, ZABO, Terradata, PL/SQL, Windows NT, Crystal reports 9.0., SAP ECC 6.0, SAP BI 7.0/7.3, BI Portal, BO 4.0, EDW, SAP CRM, HR, IS Retail, ESSBASE, DB2, Oracle, SAP Business Objects 6.5/XI Release2, Central Management Console, Universe Designer, BCA, Info view, Oracle 8i,Terradata, Sql Server 2000, SQL, PL/SQL, SQL * Loader, UNIX, TOAD, Windows 2003 Server

TECHNICAL SKILLS:

Business Intelligence Tools: SAP Business Objects XI R2/R3.1/Xi4.0, 6.X, 5.X

Data warehouse: BI 7.0, BW 3.5, BW 7.3 BOE 4.0/XI.

Methodologies: UML, RUP, SDLC, Agile/Scrum, Spiral, Waterfall, JAD, RAD, SAS, Business Process Restructuring, PMM, Star Schema, Snowflake Schema

Project Tools: HPQC, SM7, MS Office, MS Project 2007, MS Visio 2007, Rational Requisite Pro v7.0.0, Rational Rose.

Database Servers: Oracle 11g/10g/9i/8i, SQL Server, DB2 (UDB),Terradata

Data Modeling: ERwin

Languages: PL/SQL, T-SQL, C, JAVA

Platforms: Windows 98/2000/XP/2003, UNIX, Solaris10/9, Linux (Ubuntu), Mac

Data Loading Utilities: SQL * Loader, BCP, DTS

Source Controls: Microsoft Visual Source Safe, Clear Case, Source Offsite, Perforce

Project Management: Microsoft Project, Microsoft Vision

Web Tools: HTML, XHTML, CSS, CGI-Perl, JavaScript, VBScript

SAP Modules: SD, MM, FI, CO, PCA, HR, PP, PM, IM, SCM, CRM, SRM, SEM, WM, QM, APO, Sales Force

Testing Tools: Quality Center 9.x, Load Runner 9.x, QTP 9.x, Performance Center 9.x

Test Strategies: Unit, Integration, System, Regression, User Acceptance, Black Box, White Box testing, Functional and Manual Testing.

Reporting Tools: BEx Reporting, Web Application Designer, Cognos Report Designer, Business Objects (XI R2.1, 3.1), Micro Strategy, Crystal Report, WEBI Reports, Xcelsius, QlikView, Xcelsius 4.5, 2008

ABAP Programming: BADI, Exit's, Function Module, Configuration, BAPI/RFC, Webdynpro, Visual Composure.