SUMMARY

• SAP BW/BO Consultant for nearly 6 years of professional Information Technologyexperience In Full Life - Cycle implementations of SAP BW/BO projects using ASAP methodology, Including Development, Enhancement and Maintenance Projects.
• Proficient in translating business needs into SAP BWData Modeling & multiple reporting solutions.Experience in End-User trainingand preparing the training material and presentations.
• Experienced in Dimensional Database modeling & Design with DW Concepts such as Star schema, Snowflake Schema, Fact and dimensional tables.
• Proficient in SAP OLTP extractions of LO-Cockpit, SD, FI, MM, PP, HR, Generic extraction, flat files & using DB Connect for legacy data.
• Well versed in reporting tools including BEx Query Designer and BEx Analyzer, using Excel workbooks, Custom Query design, Variables, Structures, CKF, RKF,selections, formulas, filters, conditions, exceptions, cell definitions and Ad-hoc Reports using BEx Web Analyzer.Upgrade and Migration requirements related to BEx Query Designer, BEx Analyzer and BEx Web Application Designer.
• Expertise in working with SAP BOBJ Platform such as UDT,IDT, Web Intelligence, Crystal Reports 2008/2011, Crystal Reports for Enterprise, QAAWS, Live Office, Xcelsius Designer 2008 and SAP Dashboard Designer 4.0.Expertise in creating highly formatted canned reports and well versed with universe designing, report writing.
• Skillful in Basic understanding of ABAP Programming language related to SAP BW.
• Worked onProduction Support issues which involved debugging ABAP routines, Data loads, Validation and trouble shooting of Transaction Data and Master Data, Change management, Process Chains Monitoring, Transport Management, Roles & Security, System Checks.
• Experience on ETL Tools such as BODS 4.0, to extract source data & Data profiling, Transformations and loaded into target repository and checking the data quality of the loaded data in the warehouse.
• Expert level knowledge and hands on experience in using SAP Business Objects Data Quality for Data Migration, Address Cleansing and Matching in large projects.
• Worked in ETL BODSDevelopment /Template involving DI Objects like Batch Jobs, Workflows, Dataflows, Scripts, Variables Transformations (Query, SQL, Table Comparison, Map, Validation, Pivot, Hierarchy Flattening, Case, Merge, Row-Generation, Global / USA Address Cleansing, Data Cleanse, Match) and Text Data Processing.
• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Knowledge in administration activities like creating and managing repositories, users, user groups, working with privileges in repository manager.
• Proficient Knowledge with SAP HANA Modeling, SAP BW 7.3 on HANA, and ETL- Data Provisioning Using BODS 4.0, & SLT. Excellent knowledge in SQL scripting and CE functions.
• Excellent interpersonal & communication skills to work Cross-functionally with Enterprise Team members and ensure all applications & reporting solutions are clearly integrated and synchronized.

TECHNICAL SKILLS

ERP: SAP ECC, SAP R/3.

Data warehouse and Reporting Tools: SAP BW (Versions 7.4, 7.3, 7.0, 3.5),SAP BO (Versions 4.1, 4.0 and XI 3.1).

ETL Tool: SAP BODS 4.1

RDBMS: SAP HANA

Languages: SQL

GUI: SAP GUI.

RDBMS: Oracle 9i/11i, MS SQL 2005/2008, MS Access.

Operating System: Windows 8/7/NT/XP.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SAP BW/BO Developer

Responsibilities:

• Worked extensively on Data warehousing workbench RSA1; (BI 7.0/BW7.3).
• Worked with business in gathering requirements, analyzed the legacy data and meet with different stake holders to understand the source and target requirements. Identified the flow of information by analyzing the existing systems.
• Involved in Data Migration from RDBMS and Flat files using BODS by Creating Workflows, Data flows using Designer. Creating Workflows, Data flows using Designer. Most of the transforms used were like the Source Lookup, Case, Merge, and Sequence Generator.
• Worked extensively on Data Profiling to assess the Data Quality and formulate the Data Cleansing strategy.
• Analyzed the source data coming from Oracle DB & Flat Files, coordinated with data management team in developing data migration and conversion process to ECC & BW systems using BODS 4.0.
• Created Infocubes and MultiProviders as per the requirement and maintainedAggregates and Rollup activities as a part of the Infocube Management.
• Extracting data from SAP R/3 by using Generic Extraction and Customizing LO Cockpit as per requirements. Designed and developed custom data sources with the help of RS02.
• Discussion with functional team and created business specifications and data flow diagrams.
• Developed BEx Queries and defined Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Filters and Formulas, for customized reporting using BEx Query Designer BEx Analyzer & Developed several workbooks.
• Installing Business content in BW and R/3, Activated data sources in R/3 for Transaction data and Master Data. Mapping KPIs with Standard SAP business content and analysis.
• Coordinated with SAP OLTP functional and ABAP Team for Enhancements through FM & Exits.
• Sourced HR data like Personnel and Time Management and Financial data (Payroll) into the Infocube. Integrated several modules from the HRIS data into Infocubes.
• Understand the client requirements and developing the Reports and dashboards using business objects tools.Building of the Universes for the reports using Business Objects Designer.
• Successfully Integrated SAP BI with SAP business objects 4.1.
• Developed Various Reports in Web intelligence to track Sales periodically.
• Organized data in reports by using filters, ranking, alters and sorts.
• Created Crystal Reports with hierarchies and Filter.
• Developed highly formatted reports using Crystal Reports 2011 on top of BEX Queries.
• Created, designed and implemented Universes, WebIntelligence, and Crystal Reports 2011.
• Defined business objects standard reports & ad-hoc reports and Created report templates for consistency in the look and feel of the reports.
• Developed complex reports using Business Objects functionality like Slice and Dice, Drill down, Cross Tab, Master detail and Formulas etc.
• Some Important dashboards developed on KPIs are Financial Salvage reports, Inventory Turn Analysis, Shrink reports and analyzed in three dimensions Clubs, Regions, Zones.
• Worked with the ERP Consultants in configuring the Enterprise Structure and Employee Structure as per client requirements as part of sourcing Personnel Administration data.
• Worked with Client Payroll Schema and its related sub schemas, as part of sourcing Payroll data.
• Maintained both the Master data and Transaction data in the Infocube created for HR.
• Created and maintained Employee Hierarchy Reports, Employee Performance Reports using BEX Analyzer.Developed variety of reports like Employee Joining Report, Working Hours report, Payroll reports.Generated Payroll periods, Cumulative Periods, & Absentee Quotas through Reports (RPTQTA00).Utilized Hierarchies in the reporting to provide drilldown features.
• Maintaining Reconciliation’s to verify the data Integrity and data quality
• Implemented Process Chains for automated master data and transaction data loads of all modules.Documentation of the project.

Environment: SAPBI7.0/BW7.3,SAPBOBJ 4.1/ BODS 4.1, and Atos Service desk tool,Oracle 11g, MSSQL and SAP ECC ERP 6.0.

Confidential, Dallas, TX

SAP BW/BO Developer

Responsibilities:

• Responsible for end to end Projects and support functions.
• Involved in data migration from various corporate systems and interacted with end users and functional consultants.Creating Workflows, Data flows using Designer.
• Modified SAP BODS jobs as per the new mapping rules and business requirements.
• Worked with Business Users to determine their reporting requirements in SD and HR Area.
• (BI 7.0) Performed Data Modeling and Reporting requirement analysis and creation of queries based on business requirements; Build Info Objects, Infocubes (Multidimensional, BW Star schema), Data Store Objects (DSO), Multi Providers, and Infosets.
• Created custom objects according to the specification of the Functional documents.
• Involved in Business Blueprinting, Gap Analysis, Solution Designing, Data Modeling, ETL, Report Designing and Development, Production Deployment/Support and End-User Training
• Worked along with Functional & ABAP consultants on various enhancements projects for existing BW Reports across modules like HR - LSO, HR - ERC, HR - PA, HR - OM, HR- PD, HR - Benefits, HR- Payroll, FI - AP, FI - AR & FI - GL.Created reports using multiple data providers.
• Extracted ECC data for Personal Management, Payroll, and Personal Administration in HR, Delivery, Shipping Document in Sales and Distribution.
• Extensively worked on building Queries using Calculated and Restricted key figures, Structures, Variables, Exceptions, Conditions, Filters and Formulas.
• Planning for Nightly data loads for any new Module implemented and working on various performance initiatives to reduce loading time for timely data availability.
• Worked with Production Support team for performance Improvements of loads/Reports by creating Aggregates, Indexes for lookup & parallel processing of loads
• Experience in improving query performance using Query Cache, RSRT debug and defining aggregates. Improve Loading performance through DSO staging, created multiple Infocubes, BEx query structure, aggregates, compression, PSA packet sizing, change log deletion & partitioning.
• Transforming, migrating, validating and reconciliation of data.
• Created custom Time hierarchy Year-Qtr.-Mon-Week and Year-Mon-Week in Universe using BO Designer. Defined Aliases and Contexts to resolve the join issues in the Universe, Solved the issues during designing such as loops, Cartesian product due to fan trap and chasm traps.
• Developed Drill down, Link Report reports, sub reports, used various Charts and Graphs like Bar Chart (Side By Side, Stacked), Line graphs, Pie Charts using Web Intelligence Reporting Tool.
• Implemented dynamic charts and graphs in dashboards to improve look and feel using Xcelsius.
• Responsible for scheduling reports as email attachments in xls or pdf formats.
• Trained Business Users to create BEX& BO reports.

Environment: SAPBI7.0/BW7.3,SAPBOBJ suite 3.x/4.0, BODS 4.0, and Service desk tool.

Confidential, Parsippany, NJ

SAPBW/BODeveloper

Responsibilities:

• Extensively worked with the business and data analysts in requirements gathering and to translate business requirements into technical specifications.
• Coordinating with end-users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications
• Created reports using multiple data providers.
• Involved in different phrases of the project like analyzing requirement, planning, execution and Maintenance. Worked with Flat files systems to load data into SAP BI.
• Extensively worked with PSA in Monitoring the Data Transfer from source systems into BI
• Uploaded master and transactional data from flat files and SAP as the OLTP source worked extensively on administration workbench (RSA1).
• Created the customized objects using BEx Query Designer according to the business requirement and Functional Specifications.Worked on BEx Query Designer & BEx Analyzer by defining Variables, Conditions, Filters, Exceptions, Calculated key figure, restricted key figures.
• Created users, groups and access rights using Central Management Console.
• Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.Generated various reports on Daily, Weekly, Monthly and Yearly basis
• Created complex Universes, Linked with existing Universes from Data marts. Resolved loops, & created complex Reports, using BO Functionalities like Slice and Dice, Drill Down, Variables, Filters, Breaks, Alerts, cross tabs and other features.
• Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert those into user interfaces like excel files, PowerPoint representations for better understanding.
• Developed various Reports for Area wise, Regional, National, and Response Analysis using Crystal Reports / Business Objects. Business users to use Web Intelligence to create ad-hoc reports as well as view existing published reports.
• Tested about 80 Business Objects full Client reports in the BO / Crystal environment.
• Generating and scheduling standard and Ad-hoc reports using BO and Crystal Reports.
• Worked closely with technical peers to insure successful integration of developed applications.
• Participated in developing the Relational Model (Logical & Physical) and in documentation of technical methods of development as well as business related information regarding the design process. Created various validation reports between BW systems and BOBJ system.

Environment: BI7.0, Business Objects 4.0, Web Intelligence, Crystal Reports 2011, Oracle 9i, & MS SQL.

Confidential

SAP BI/BO Technical Consultant

Responsibilities:

• Worked extensively on Data Warehousing workbench.
• Redesigned custom cubes to improve reporting performance.
• Coordinated with SAP OLTP functional and ABAP Team for Enhancements through FM &Exits.
• Customizing and activation the Business Content Objects and Loading the data into data targets.
• Used BEx Query Designer to develop reports and facilitate data analysis using CKFs, RKFs, free characteristics, Exceptions, Conditions, Filters, Jump targets (RRI), Structures, formulas and Variables.
• Understanding the reporting requirements from client’s perspective and interacted with Functional Consultants in developing BEx query, Web Intelligent reports, Crystal Reports 2008.
• Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert those into user interfaces like excel files, PowerPoint representations for better understanding.
• Created cross tabs, Charts, folding, filters, prompts, alerters and variables in designing reports.
• Worked on SAP Business Objects Data Quality XI to do address profiling, parsing, standardization, cleansing, matching for master data such as org structure, customer and vendors.
• Post completion of SAP BI configuration based on SAP BI as source creating Universes on top of BI queries and developing the BO dashboards, WEBI reports and placing all this reports in corporate dashboard and presenting these dashboards through info view to the management
• Integrated all the data in BW using Infosets and MultiProviders to create reports as per requirement.
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW on monthly and quarterly Basis.
• Worked on generic extraction using Table/View to extract data from SAP R3 ERP system.
• Error Handling on Extraction, Data loading and end user issues on Reporting.
• Daily Discussions with Team lead, Team members and Modeling as per the requirements.

Environment: SAP BI 7.0/BW3.5, SAP ECC 6.0, BO XI 3.1

Confidential

SAP BI/BO Technical Consultant

Responsibilities:

• Handling BW in SAP ERP Applications.Activated, Installed and Extended Business Contents based on Gap Analysis established on user requirements.
• Worked on all advanced reporting features in WEBi XI like Drill Down, Drill Up, Breaks, Scope of Analysis, Ranking and report level variable based filtering to create complex reports.
• Worked on DWH Workbench: Data Model - Designing & testing of Info Objects, Infocubes, Data Store Objects (DSO), MultiProviders, Infosets and Open Hub Services.
• Created the customized objects according to the Functional Specifications.
• Worked in keeping DSO as staging layer before transferring the contents to the Info Cube.
• Making all the reporting data targets filled with the Master data and Transaction data correctly.
• Updating the data load status and sending the status of the loads every hour.
• Worked extensively on generic extraction, standard LO extractors, Installed relevant SAP business content. Used LO Data sources for extracting sales order, delivery billing information and scheduled data extractions in LO cockpit.
• Done data cleansing using the data quality transformations like country id, address cleanse, data cleanse available in sap data services.
• Used BEx Query Designer to develop reports and facilitate data analysis using filters, navigational attributes, calculated and restricted key figures.
• Communicated with ABAP Team for Enhancements through user Exits in BEx Query Designer.
• Handling Change request, data load details and designed Process Chains to trigger Multiple Data Loads.
• Applied and corrected variable context corrections for reports in Desktop Intelligence Tool.

Environment: SAP BI 7.0, SAP ECC 6.0, BO XI 3.1

Confidential

Functional Analyst

Responsibilities:

• Design, Review & understanding of technical specification / functional specification.
• Development of BW Objects as per the technical specification by adhering to Quality Standards.
• Design and development of Freight Costs visibility reports in BW. This involved requirement analysis from the client, design of ODS, Cube, reports etc.
• Created the objects according to the technical specs.Used BEX Analyzer for normal Query Designing.Generated pending PO and PR report.
• Detected/resolved data Cardinality and loops, checked integrity of Universes.
• Authorization functions include configuration of hierarchy and authorization with variables, authorization Info Cube, allocation of roles and authorization objects.
• Worked on data source enhancements and generic extractors to meet the business needs
• Created transfer rules and update rules including routines for currency conversion.
• Created revenue margin variance reports with complex restrictions on characteristics and calculations on key figures based on business requirements.
• Resolution & recommendation of table sizes, parameters, table spaces, partition break ups, and errors.Transported BW objects and BEX objects to Quality and Production boxes.
• Basis functions include monitoring and supervising check DBA, archive logs, parameters settings in R/3 and BW, and performance tune-ups.
• Performed Unit Test in Development and SIT in Quality box
• Applied changes to the reports developed by other vendors based on the QA defects and the user requirements.

Environment: SAP BI 7.0, SAP ECC 6.0, BO XI 3.1, Microsoft Dynamics Suite, MSSQL 2005