SUMMARY

• Over 13 years of IT experience as SAP BW/BI, BOBJ, SAP Hana Architect in modeling/project management, go - live and optimization.
• Involved in more than 8 full life cycle implementations using BW/Hana in SD, Purchasing, AP-AR, AA, COPA, FICO, MM, HR.
• Proficient in helping the client to identify project scope, prepare project charter, statement of case and get the client sign off.
• Experience in conducting requirements gathering phase, identifying data points, gap analysis, reporting requirements analysis and mapping requirements to business content to identify gaps, and KPI analysis.
• Capability to prioritize, integrate and coordinate project activities and tasks and able to work independent. Good problem solving and decision-making skills. Ability to work effectively in a diversified team; guiding and supporting project team members.
• Responsible for project planning, deliverables, issues resolution, advisor on latest SAP HANA to leverage reporting tools and landscape architecture.
• An organized professional with excellent communication, high level of Motivation, hardworking, interpersonal skills and Customer Oriented attitude.
• Served as project architect for complete HANA full life cycle implementation in FI/CO/HR/SCM reporting.
• Extensive knowledge in Advanced DSO(ADSO), Open DSO View and Composite Provider
• Worked on SAP BW 7.4 Migration to SAP BW 7.5 on Hana
• Expert in hands on development in SAP HANA using graphical, scripted views, star join calculation views and decision making to optimize the report performance
• Expert in hands on development in SAP HANA using Attribute view, Analytical view, Analytical Privileges, Procedures, Table functions
• Extensively worked in project go-live coordinator inside car and suite on HANA, BW on HANA projects.
• Responsible for Business reporting requirement gathering & convert them into Blueprint.
• Responsible for business blueprint based on the business case and end user requirement for real time reporting in SAP Finance area.
• Served as data modeler to identify the core ECC tables and relationship and replication/transformations.
• Responsible for translating Functional Specifications into Technical Specifications and Business KPIs into HANA & Define the Reports/dashboard Layouts
• Data Provisioning using SLT, SDA and BODS
• Hands on experience in connecting classical database tables using smart data access.
• Expertise in multi-dimensional data modeling using extended star schema, creating necessary InfoObjects, DSOs, InfoCubes, InfoSets, MultiProviders, InfoPackages, DTPs, Update Rules, Transfer Rules, Transformations and InfoSources, Datasource enhancement
• Experience in creating and maintaining process chains and meta chains for automating data loads
• Served as a Project lead, Senior BW/BI Lead Consultant, Business Analyst and Techno Functional Consultant for multiple global roll-out BW implementations.
• Extensively worked in BW 7.4 features for specific to business case and implemented them as per business requirement.
• Expertise in Abap coding - Transformation routines, Start routine, End routine and expert routines.
• Experienced in extracting data from SAP R/3, ECC (FI, MM, SD, HR, COPA), from SAP CRM and BW using different extraction structures such as FI, COPA, LO Cockpit and generic extractors and also non-R/3 systems like Tera-data using Informatica and flat Files.
• Expertise in creating custom extractors from R3 as per business requirement and complex logic and also ALE based function module extractors based on change pointers in IDOC, extending extractors using CMOD. Expertise in ABAP optimization using as SAP recommended.
• Expertise in front-end Business warehouse components: Extensively worked on Bex Queries, Bex Analyzer, calculated

PROFESSIONAL EXPERIENCE

Confidential, Sheboygan Falls, WI

SAP BW-HANA Developer

Responsibilities:

• Extensively worked in requirement gathering phase for suite on HANA project, ABAP optimization and HANA models.
• Collected the requirement and translated into HANA specific models in Sales, Assets Account, Account Payable, Quality Management, Production planning
• Worked s/4 Core data services (CDS) to create tables and views
• Worked with SAP ECC Logistics (LO) in loading Sales and Distribution, Purchasing, MM, data into BI. Involved in Initializing the LO Data source by Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source
• Design real time reports using a combination of HANA live report and historical data from BW
• Created SAP HANA information models such as Procedure and Hana Views (Calculation views) with graphical and SQL Scripting
• Extensively worked in requirement gathering phase for suite on HANA project, ABAP optimization code push down and HANA models.
• Extensively created BW Advanced ADSO, Open ODSO, Composite Provider
• Worked on Extracting File text and PDF from website to BODS to BW using Python Scrip

Environment: SAP HANA 1.0- SP12, SAP HANA 2.3.51, SAP BW 7.30, 7.31, SAP BW 7.4, SAP BW 7.5, ECC 6.0, Business Object 4.0, 4.1, 4.2 Information design tool 4.0, 4.1 Universe design 3.1, Web intelligence, BODS, Microsoft Power BI, Python, CBP

Confidential, Memphis, TN

SAP BW/HANA Solution Lead

Responsibilities:

• Extensively worked in requirement gathering phase for suite on HANA project, ABAP optimization and HANA models.
• Collected the requirement and translated into HANA specific models in Sales, Finance reports and created Webi reports as per user requirement.
• Created custom tables in ECC to capture snapshot using HANA job schedule.
• Worked with SAP ECC Logistics (LO) in loading Sales and Distribution, Purchasing, MM, data into BI. Involved in Initializing the LO Data source by Activating the Business Content Data Sources, Maintaining the Extract Structure, Generating the Data Source
• Created Schemas, imported tables and loaded data to table and copied standard content from SAP to local repository using SAP HANA
• Design real time reports using a combination of HANA live report and historical data from BW
• Created SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access), SDI, and reporting on SAP HANA Live (Analytics) and performed ETL scenarios with SAP HANA (using Data Services/SLT replication), and Predictive Analytics on SAP HANA
• Managed 5 resources (Hana/BW) team in different modules
• Extensively worked in requirement gathering phase for suite on HANA project, ABAP optimization code push down and HANA models.
• Assist Manager in identifying, establishing, and driving standardized BI delivery solutions for the company
• Extensively created BW virtual providers on HANA view for GL reports to combine history with snapshot and consumes BEx queries into HANA view.
• Scheduled and exported the reports to PDF’s or Excel on weekly and monthly basis.
• Provided process documentation, which includes data flow and how to guides the end users for post-production support.
• Created IDT universes on top of standard HANA views and deployed the data into BOBJ Webi report.
• Performed various functionalities on the reports like filters, Ranking, Control, Data tracking, Alert, and sorts.

Environment: SAP HANA 1.0- SP12, SAP BW 7.30, 7.31, SAP BW 7.4, ECC 6.0, Business Object 4.0, 4.1, 4.2 Information design tool 4.0, 4.1 Universe design 3.1, Web intelligence, BODS, Microsoft Power BI

Confidential, Fort Smith, AR

SAP BW/HANA Solution Lead

Responsibilities:

• Designing and developing the Technical specification document based on the functional specification document.
• Developed Hybrid Provider Based on datastore object and on Direct Access
• Work on Hana Studio - Schemas and tables on Hana, attribute view, analytical view and Calculation views
• Migration activities for BW 7.3 to BW 7.4 on HANA
• Implementing SAP BW on specific modeling like Composite Providers and exposing BW objects in Hana views, Operational Data Provisioning, LSA+++
• Developed/ Implemented SAP BW on Hana components like Datasource Advanced, Composite Provider, Semantic Group of Advanced Datastore Object Transformations, Data Transfer Process (DTP).
• Extracted and enhanced DataSources from various SAP modules: SD, MM. FI-AR/AP, COPA GL
• Created, designed and implemented Universes, WebI Reports, and Dashboards using best practices.
• Worked on production support involved in monitoring load failures, delta loads, documenting and monitoring performance of the system
• Created Schemas, imported tables and loaded data to table and copied standard content from SAP to local repository using Hana
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, attribute change run etc.,
• Worked on BEX Query Designer in designing queries using Columns, Rows and Free Characteristics detailed drill down data analysis to required level of information
• Expertise in building BI components like Info objects, data sources, InfoCube, DSO, Transformations, Data Transfer Process (DTP), MultiProviders and Master data Info Objects.
• Expertise in Abap coding and Debugging the Extractor checker, transformation routine, Start routines and End routines
• Developed flexible queries with variables using filters, Navigational attributes, Restricted Key figures, Calculated Key figures, Reusable structures and Currency translation factors in BEX.
• Developed Queries to access data from various BW InfoProviders like DSO, InfoCubes, InfoObjects, MultiProviders and InfoSets using BEX query designer, Composite Provider.

Environment: SAP HANA 1.0- SP8, SAP BW 7.4, SAP BW 7.30, 7.31, ECC 6.0, Business Object 4.0, 4.1 Information design tool 4.0,4.1 Universe design 3.1, Web intelligence

Confidential, Dallas, TX

SAP BW/BI/ BOBJ

Responsibilities:

• Interacting with users for customized and standard reports, gap analysis and associated solutions. Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, R/3 systems as per the system landscape.
• Interacted with Project manager and end-users in architecting reporting solutions by understanding the requirements and writing universe, report and Dashboard specifications.
• Developed various transformations to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
• Created, designed and implemented Universes, WebI Reports, and Xcelsius Dashboards using best practices.
• Requirements gathering, data modeling, scheduling data extraction from source systems.
• Created BEX reports using filters, calculated key figures, and restricted key figures for use in BOBJ Tools like Universe Designer.
• Created Universes on SAP data (InfoCubes / BEX queries).
• Created process chains using various process to automate data loading, activation of DSO, compression, drop and create indexes, attribute change run etc.,
• Creating multi-layered Xcelsius dashboards to display various components and included Filters, List View, table, Line, Column and Pie charts.
• Created Details Drill-down Reports using Web Intelligence worked on Ad hoc Query, Reporting, and Analysis.
• Created detailed crystal reports using Formulas, Parameters and Grouping functionality.
• Created and enhanced InfoProviders, MultiProviders, Transformations, and Data Transfer Process and extensively worked on designing process chains.
• Enhanced the existing master and transaction data extractors in SAP R/3.
• Involved in extracting FICO data from SAP R/3 to SAP BW.
• Extracted and enhanced data sources from various SAP modules: SD, MM, AR, AP, CO-PA.
• Created BEX queries for reports in areas like Finance, Manufacturing and Inventory Management.
• Developed flexible queries using filters, navigational attributes, variables in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• As a part of Production support involved in monitoring load failures, Delta loads, documenting and monitoring the performance of the system.
• Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.

Environment: Business Objects Enterprise XI 3.1, SAP BW 7.0, BW 3.5, ECC 6.0, Business Explorer (BEX), Oracle 10g, SQL Server 2005, Universe Designer, Enterprise Portal, Web Intelligence

Confidential, Lynchburg, VA

SAP BW/BOBJ Consultant

Responsibilities:

• Involved in implementation of Business Objects XI R2.
• Designed universes, WebI Reports and l Xcelsius Dashboards.
• Designed BEX queries to be used exclusively in Business Objects.
• Interacted with business users and gather the design specs for dashboards.
• Designed a dashboard for Lead / Target analysis where the target data is obtained from Non- SAP sources.
• Created detailed Crystal Reports using Formulas, Parameters and Grouping functionality.
• Gathered the requirements from business users and did the gap analysis.
• Involved in extracting SD, FI-CO and CO-PA data from SAP R/3 to SAP BI.
• Enhanced the data sources for FI-AR, FI-AP and extracted the data into BI.
• Used extractors from Logistics cockpit for Sales Order Header (2LIS 11 VAHDR), Item Level (2LIS 11 VAITM) & Billing (2LIS 13 VTIT)
• Designed and developed the CO-PA DataSources and involved in extracting the actuals data from CO-PA into BI.
• Developed DSO, InfoCubes for the actuals data from CO-PA.
• Created MultiProviders to include the actual data from COPA and planned data from IP.
• Designed and created complex queries using user-exit variables.
• Created Process Chains for daily delta loads for cleanup operations of PSA.
• Created partitioning, aggregates, and indexes as performance tuning measures.
• Transported the objects from Dev to Quality and Dev to Production using Transport Organizer.
• Developed documentation, conducted User Acceptance events, and trained the end users.

Environment: SAP BI 7.0, BW 3.5, Business Objects 3.x,4.x ECC 6.0, IP, SQL Server 2005, BEX Portal;

Confidential, Huntington Beach, CA

SAP BW/BI Technical Consultant

Responsibilities:

• Migration of reporting strategy from R/3 ABAP reports to BW reports in BEX in Logistics area dealing SD, MM, PP, Sales Forecast and COPA.
• Design and develop BW architecture for creating various reports in BEX.
• Successfully implemented and migrated R/3 reports to BW.
• Prepared the blue print, data flow diagrams and detailed design documents for all data providers.
• Generated the data source for COPA and extracted the data.
• Extracted the data from sales, shipping, purchase, inventory, Production planning and sales forecast.
• Designed and developed the data loading process using process chains.
• Designed and developed multi provider connecting sales, shipping, purchase, inventory, production planning and sales forecast and created complex reports.
• Expertise in building BI components like Info objects, data sources, InfoCube, DSO, Transformations, Data Transfer Process (DTP), MultiProviders and Master data Info Objects, Transfer Structures, Communication Structures, Transfer Rules and Update Rules
• Developed Queries to access data from various BW InfoProviders like DSO, InfoCubes, InfoObjects, MultiProviders and InfoSets using BEX query designer
• Designed and created customized Info Cubes, ODS objects, Info Sources & Data Sources in SD, MM.
• Activation of Business content data sources for 0FI GL 4, 0FI GL 6, 0FI GL 7.
• Enhanced standard Data Sources populated data using customer exit. Created custom Info Cubes with appropriate update rules, transfer rules, Info Objects.
• Responsible for extraction of Purchasing and Inventory logistics data Creating new Info Objects and enhancing Extract structures, Enhanced Transfer rules and communication structure.
• Enhanced the extractor 2LIS 03 BF, 2LIS 02 SCL and 0FI AP 3 to capture the additional information not part of the extractor.
• BW data production support - scheduling, monitoring and troubleshoot.
• Created customized info objects, customized info sources as part of the Gap analysis.
• Created Generic extractors for uploading data from the customizing tables. Possess excellent knowledge on Application specific extractors, delta management and reporting.
• Had sessions on Knowledge Transfer to End Users on the creation of reports/queries including the various options available during the creation of queries.
• Set up the info package schedules for the initialization and the delta data updates to the data target.

Environment: SAP BW 3.x, SAP R/3, BEX;

Confidential - Phoenix, Arizona

SAP BW Technical Consultant

Responsibilities:

• Worked with Info Cubes in SD and FI. Gathered the requirements from the business users and did the gap analysis.
• Designed and developed custom ODS object and Info cube for billing items.
• FI-AR - Designed ODS and Info Cube for line item extraction.
• FI-AP - Designed ODS and Info Cube for line item extraction.
• Extracted multiple line item records for FI-AR and FI-AP line item Info Cubes.
• Designed queries for receivables and payables overdue for customized key figures (buckets) for FI-AR and FI-AP cubes using calculated key figures and restricted key figures.
• Designed formula variables and customer exit variables.
• Enhanced the data sources for FI-AR, FI-AP and Billing at item level (Logistics Cockpit).
• Gathered requirements for CO-PA
• Good knowledge of various data design models - Star Schema and Extended Star Schema models.
• Experience with BW Administrator Workbench (Modeling, Monitoring, Reporting Agent, Translation, Metadata Repository, Business Content, Documents, and Transport Connection) and working with Data Mart Interface, Multi Providers, Info Cubes, ODS Objects, InfoObjects and Info Sources.
• Loaded data from flat files and SAP R/3 systems.
• Created custom InfoObjects and enhanced standard InfoObjects
• Implemented Update Rules and Transfer Rules to transform data into a more meaningful representation
• Experience in creating Generic Data sources using tables in SAP R/3 and replicating them to BW in the process to load R/3 Data to SAP BW.
• Set up InfoPackages and InfoPackage groups to manage data loads
• Defined and customized BEX queries and variables

Environment: SAP BW3.5, SAP R/3 4.6C/4.7