SUMMARY

• Around 16 years of Overall IT and Data Warehousing Experience working on SAP BW4HANA, BW/BI with 1 year in Ab Initio ETL.
• Worked on 6+ full lifecycle implementations in BW/4HANA and earlier versions of BW.
• Involved in all teh project phases such as Requirement gathering, Blueprint, Design, Development, Testing, Go Live and Production support.
• Experience in communicating with Business users on gathering and understanding reporting requirements and delivering quality and productive reports that are used for improving Business processes.
• Experience in Documentation of Functional Specifications, Technical Specifications, End User training manuals, power point presentations to management teams.
• Conducted several End user training sessions with Business users and presented on how to use Reporting tools.
• Experience in data modeling, ETL, translating requirements into functional/design specifications, creating custom BI objects, creating reports using BI reporting tools.
• Implemented End to End Implementation in BW4HANA/S4. Experienced in Modeling data flows in BW/4HANA
• Functional knowledge in Areas: SD, MM (Purchasing/Inventory), HR, FI, SEM.
• ABAP/SQL Usage in BI: Experienced in creating CDS Views, Table Functions, Procedures, Developed Generic Data extractors based on Function module, worked on custom Enhancements of Standard extractors. Also used ABAP/AMDP code in Start Routine/End Routine/Expert Routine in Transformation, in User exit variables in Bex Queries.
• Well experienced new Info providers in BW/4HANA Creation of Advanced DSO (ADSO), Info Objects, Composite Provider and Open ODS View.
• Extraction and Customization: Extraction of data from S/4HANA, Creation of Custom CDS Views, Standard Extractors using ODP Framework, Generics extractors using FM, non - SAP data sources using DB CONNECT/BOBJ DS, Flat File extraction and Enhancement of Extractors
• Excellent communication, interpersonal, analytical and problem-solving skills and strong ability to perform as an individual and as part of a team.

TECHNICAL SKILLS

Data Modeling: SAP BW/4HANA 2.0, HANA DB, BI/BW 7.5/7.3/7.0/3.5 Data Services, IDT, Big Query, SQL, Ab Initio

ERP: S/4HANA, SAP ECC 6.0/5.0, SAP R/3 4.7/4.6c

Function Modules: SD, MM, HR, FI

Reporting Tools: SAP Analytics Cloud (SAC), WEBI, Lumira, Business Explorer (Bex), WAD, Visual Composer, Report Designer, SEM CPM, Universe Designer, Crystal Reports, Excelsius and Power BI Reporting, Looker

Operating Systems: Windows 95/98/2000/XP/NT 4.0,UNIX

Database: HANA, Oracle 10g, MS SQL Server, DB2, Big Query

Languages: ABAP/4, HTML, Java Script, JAVA, C, C++

Tools: ASAP, MS Visio, MS office

PROFESSIONAL EXPERIENCE

Confidential

Sr. SAP BI Developer (Techno-Functional)

Environment: SAP BW/4HANA, BI 7.5/7.0/3.5, S/4HANA, SAP ECC 6, SD, MM, FI, WEBI, SAC, Lumira.

Responsibilities:

• Worked on 3 Full life cycle implementation projects, Sales and Distribution Redesign, Inventory Planning Proposal reports, SHAPE migration projects.
• Complete knowledge of teh reporting areas Sales and Distribution, Purchasing and Inventory currently exists in BW environment.
• Worked on Full life cycle implementation of Inventory reporting in BW/4HANA.
• Use teh Operation Data Provisioning (ODP) Framework for data extraction from teh SAP Data Sources.
• Created several CDS views and created data sources based on these CDS Views.
• Having Experience in SAP BI Related AMDP/ABAP routines like Start/End/Field/Expert routines.
• Experienced in using ADSO, Info Objects, Composite Providers and Open ODS Views.
• Worked on SAC reporting using Live and Import connections.
• Developed Models in SAC on BW4HANA Queries for Sales and Purchasing Reports and used variables/linked models/attributes/Hierarchies in these reports.
• Built several stories for End users consisting several chart types such as Bar/Column chart/Stacked Bar/Line Trend/Heat Map/Histogram/Numeric Point/Pie chart etc.
• Worked on several reports using Data Analyzer in SAC.
• Worked on SHAPE Migration project (Schlumberger Wilson Acquisition). Responsible for developing Data conversion ETL in BOBJ Data Services to convert Wilson (Oracle data) and load into SAP BI.
• Worked on Data warehouse revamp project to improve Data load and Query performance
• Involved in requirement gathering sessions with several business team members and responsible for delivering several reporting needs.
• Extensive involvement in Requirement/Design/Development/Testing/Go live of Sales and Distribution redesign project which involves areas such as Sales, Deliveries and Billing and Quotations.
• Worked on Production Support of BW Data loads on daily basis every other week. Well knowledgeable in resolving production support issues.
• Supported Downtime activities such as Support packages, Upgrades and Time change etc.
• Involved in developing BOBJ WEBI reports for Line Pipe Purchase team.
• Involved in BW Upgrade/Migration from BW 3.5 -> BI 7.0 -> BI 7.3 -> BI 7.5 versions.
• Setup Broadcast of Bex reports using Information Broadcaster via email to Branch/Reginal Managers
• POC for Big Query SQL scripts for ETL in GCS environment for Power BI Reporting.
• Provided Production Support for BW Data loads as Primary/Secondary.
• Worked on HANA modeling using calculation views, table functions, Procedures.
• Worked on Virtual Data extract using SDA (Smart Data Access) to get data from non-SAP systems.
• Use BW/4HANA Cockpit to Manage, Active and Load data into teh SAP BW Objects and monitor Process chains.

Confidential, Houston TX

Sr. SAP BI Consultant (Techno-Functional)

Environment: SAP BI 7.0, SAP R/3 ECC 6, FI AA, AR, AP and GL Bex Suite.

Responsibilities:

• Involved in Requirements gathering, Analysis, Design, Development, unit testing and support activities for BW reporting requirement for FI data.
• Worked on General Ledger, Asset Accounting, Accounts Payable, Accounts Receivable and Journal Entry workflow reports.
• Gatheird reporting requirements from Business users for AA and JE WF information and created a detailed end-to-end design of teh dataflow, involved in development for teh backend BW objects are frontend Bex reports.
• Used standard extractors for FI AR, GL and Asset Accounting. Also created several generic extractors based on Function Module as well as table/view for Journal Entry workflow reports.
• Developed Detailed as well as summary reports using Bex Suite on FI data.
• Provided production support during teh warranty period in trouble shooting issues with teh reports and data loads
• Provided training sessions to end users about using teh bex reports that has been developed.

Confidential, Denver CO

Sr. SAP BI Consultant (Techno-Functional)

Environment: SAP BI 7.0, SAP R/3 ECC 6, BEx Suite, HR Time Management, HR Payroll, KRONOS time keeping system.

Responsibilities:

• Worked in a full life cycle implementation project with data extraction from HR Time Management and Payroll.
• Gatheird Requirements from Business and prepared Functional and Technical specifications for teh reporting needs.
• Created several custom extractors based on Table/views and Function modules to extract data from several R/3 tables as well as time (B2) and payroll (RT) cluster tables.
• Built Data warehouse with several custom Infoproviders to report against Time/Payroll information.
• Used ABAP routines in all teh areas of BI.
• Extensively used Bex Query Designer to create Several Bex Reports on Time data such as MBO Eligible earnings, Employee Vacation Limit Report, Sick and Vacation Accrual Exception report etc.
• Also created Several Bex Reprts on Payroll data such as AP Garnishment payments, Workers Opportunity Tax Credit, Union pension calculation etc.
• Provided production support for teh existing HR applications.

Confidential, Houston TX

Sr. SAP BI Consultant (Techno-Functional)

Environment: SAP BI 7.0, SAP R/3 ECC 6, SD, MM, Purchasing, Bex Suite.

Responsibilities:

• Worked as a Technical Developer on a Full life cycle implementation project in SAP BI 7.
• Involved in Requirements gathering, Analysis, Design, Development, unit testing and support activities.
• Worked on Sales, Billing and Delivery data coming from R/3 system. Also worked on Purchase Requisition, Goods Issue and Goods receipt data.
• Developed data transfer programs in ABAP to send sap tables data from R/3 system to External Application servers.
• Used ABAP extensively in writing Start routines/End routines/Expert routines in teh areas of BI.
• Designed teh data model in SAP BI according to teh reporting requirements.
• Responsible for creation of new objects as well as enhanced existing objects in SAP BI. Enhanced DSO’s, Virtual providers, Multiproviders etc.
• Developed several Bex queries for teh Vendor Specific Objective evidence project which involves calculation of various discount bands and YTD reports based on Region, Business Unit and Business Area.
• Involved in teh production support activities, archiving data from teh DSO’s and Cubes, Supported with teh failures of teh jobs. Performed user training on using Bex reports.

Confidential, Wichita, KS

Sr. SAP BI Consultant (Techno-Functional)

Environment: SAP BI 7.0, SAP BW 3.5, SAP R/3 4.6C/ECC 6, BEx Suite, FI, HR, Purchasing, MS SQL server.

Responsibilities:

• Lead teh team for 2 Full life cycle implementation projects in SAP BI 7.
• Trained 4 non-SAP new hires on Data warehousing basics and SAP BW 7.0, Migration of objects from SAP BW3.5 to SAP BI 7.0.
• Designed and architected teh BW Purchasing, HR, Risk Management and Fleet Management reporting areas.
• Provided guidance and support throughout all teh phases of teh projects such as Gathering requirements from Business users, translating requirements into technical specifications, Designing of Data Model in BI, Implementation of Data flows and Reports, Testing and Go-Live.
• Upgrade/Migration of backend as well as frontend objects from BW 3.5 to 7.
• Worked on Data extractions from R/3 modules FI Funds Management, HR Payroll, Purchasing and non SAP systems using DB CONNECT utility from Risk Management dept. based on SQL Server, Fleet Department based on DB2 systems.
• Created several Custom BI data flows and also activated Business content data flows for FI, HR PT/Payroll for data coming from SAP and non SAP systems.
• Created Bex Queries for comparison of initial and final Gross, Net, ER Tax, EE and Tax amounts and Average cycle time from PR to PO to GR to IR.
• Extracted HR Payroll lock hours data into BW and created report to show teh number of hours HR TEMPhas locked teh payroll system for adjustments.
• Created custom extractor based on Function Module for a Purchasing requirement to calculate cycle time starting from Requisition creation, Requisition Authorization, PO Creation, GR creation, IR creation, Invoice till Payment. Also developed complex transformations using ABAP routines in Transformation Routine, Start/End routines.
• Performance tuning in data loads and Execution of Queries.
• Created several Process chains for Automation of Data loads in BI.
• Extensively used Infospoke for Data Exports to Flat files for consumption of data in Non-SAP systems.
• Issued 24x7 production support.
• Built Custom Infocubes, DSO objects (standard and write optimized), Multiproviders, Infosets to store Payroll/PT, Purchase Requisition and PO, Goods Receipt, Invoice Receipt, Direct pay Invoice data.

Confidential, GA

Ab Initio Developer

Environment: Ab Initio, SQL, Oracle DB, Unix.

Responsibilities:

• Developed AB Initio ETL process loading and interpreting teh transformation rules for all target data objects and develop teh software components to support teh transformation as well as estimating task duration
• Worked on developing a high level ETL and Detail design for teh Complete ETL Process.
• Created AB Initio multifile system shell scripts on different nodes which can process multiple partitions of data at teh same time using AB Initio’s m type and mp type shell commands
• Worked with teh Data Profiler developing business validation rules for teh required fields identified.
• Also developed Data Prep Graph, Data Validation Graphs and Delta Processing Graphs
• Worked extensively working on data splitting and implementation of data validation rules.
• Written several Test Plans, Test Cases, and Test Procedures
• Responsible for Quality Assurance & Quality Control based on CMM (Capability Maturity Model)