Post Job Free

Resume

Sign in

SAP BI HANA BW

Location:
Decatur, GA, 30030
Salary:
150000
Posted:
June 08, 2017

Contact this candidate

Resume:

• Professional Summary

• IT Systems Expert with expertise in requirement gathering and analysis, architectural.

• Experienced SAP Consultant committed to maintain cutting edge technical skills

• Client-focused with more than 10 years designing innovative applications and achieving high client satisfaction.

• Experienced BI and Data Warehouse specialist with 10 years - with 4.5 Years with IBM with 6 IBM implementations.

Skills

• SAP NetWeaver BI Certified.

• Exceptional background in Analysis, Design and Development.

• Proficient in Project Management, especially ASAP Methodology.

• Strong skills in carrying Functional strategies, development and testing.

• Experienced in SAP Front End Reporting Tools: SAP BusinessObjects 4.1 Design Studio, Webi, Lumira, BO Analysis for OLAP.

• Skilled in data analytics from various tools and data governance.

• Accomplished in HANA modeling, Data provisioning and reporting in SAP HANA 1.O using HANA studio

• Expert in BW backend Modeling for and worked on cross functional project such as SD, MM, FI - CO, COPA, TM and HCM. (BW 3.5 - BW7.4) and proficient in BO4.2 and BW7.5

• Excellent knowledge in Business Object Data Services to acquire data from SAP and non SAP sources.

• Designed and developed BW Cubes, DSO, DataSources, BEx queries from ECC sources.

• Worked on B.O. Universes for BO reporting.

• Enhanced and appended DataSources for BI content reporting and dataflow.

• Skilled in SQL scripts for HANA scenarios.

• Experienced with writing ABAP code in BW transformations – start/end/field routines.

• Heavily experienced in ETL using BW and BODS, also knowledge with TIBCO.

Experience

FoQus Consulting

June 2016 – present

Client: Boston University

• Developed HCM (Human Capital Management) Dashboard – Employee Model. BO4.1

• Designed BW models based off current and future architecture (BW7.4)

• Leveraged HANA DB for modeling Attribute Views Analytical Views and Calculation Views.

• Monitored the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

• Provided needed in depth SAP BI knowledge.

Hitachi Consulting

April 2015 – December 2015

1) Client: Tyson Food July 2015 – December 2015 Fayetteville, AK.

• Designed and supported BI SAP TMS (Transport Management System).

• Strategized to merge acquisition data using BODS (BO4.1) to extract into HANA DB.

• Evaluated the BI (BW7.4) and HANA (HANA1 SP09) Security concepts, models, procedures.

• Used SAP Optimized BW objects to load the new HANA optimized data models.

• Worked cross-functionally to collect necessary information inputs for analysis.

2) Client: Buckman Lab April 2015 – July 2015 Memphis, TN.

• Used best Practice to collect requirements for Worldwide Procurement Reports.

• Designed report with Business Objet Design Studio and Lumira. (BO4.1).

• Migrated models into Hana DB through data provisioning and BODS (Data Services).

• Led onshore/offshore and designed BW models (BW7.4).

IBM

October 2011 – March 2015

1) Client: Ernst & Young January 2015 – March 2015 Secaucus, NJ.

• Developed a DataWarehouse solution to improve their assurance data exploration.

• Designed and modeled OpenHub to dispatch data to a Teradata DB.

• Transformed their data through extensive and complex ABAP routines.

• Supported and monitored complex RSPC Process Chains.

• Implemented HANA migration and Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data

2) Client: Abbvie Pharmaceutical August 2014 – December 2014 Chicago, IL.

• Analyzed current existing data from different sources to demonstrate performance metrics for any PO (Purchase Orders) strategies (OTC, PTP, and RTR).

• Participated in client/partner meetings and Presented the POC - proof of Concepts.

• Designed and customized BW objects to create PTP invoice metrics from nonSAP source (Brainware)

• Developed BEx Queries with Invoice Lifecycle Metrics.

• End to end experience of software development lifecycle including requirements engineering,

design, development, implementation, training and support.

3) Client: GMCR Keurig June 2014 – August 2014 Burlington, VT.

• Analyzed, Designed and customized BW objects to create 1 financial report: Royalty Report.

• Designed a solution using flat file and SAP objects to create the correct routines.

• Used their billing flow combined with the flat files to calculate their royalties.

• Used BusinessObject Webi on top of the BEx query to develop the Royalty Report.

4) Client: Anderson Inc. December 2013 – June 2014 Toledo, OH.

• Improved, Analyzed and Developed Risk Management reports such as Customer Risk Exposure, Open Activities Reports, all part of their Transport Management solutions.

• Led onshore/offshore team to create WEBI Reports, and Dashboards.

• Developed DSO, Cubes and BEx Queries for Contract and Ticket Managements flows.

• Used APD queries for Customer Risk Exposure report and Built Custom Routines for deferred payments, down payments and related it to tickets and contracts.

• Coordinated end to end developments.

5) Client: Campbell Soup April 2012 – September 2013 Camden, NJ.

• Responsible for developing APO Demand Planning, SNOP BW workflow.

• Developed and Mapped CVC Structures of actual/historical records for planning purpose.

• Defined Forecast models for time series forecasting with 140 Key Figures

• Performed data transfers between R/3, APO, BW, Manugistic, and live cache.

• Created Business Objects Webi reports using BEx as source.

• Used CHARM for objects Transportation and led cutover activities.

6) Client: UPS Supply Chain October 2011 – April 2012 Alpharetta, Ga.

• Assisted in full life cycle of several OM (Order Management) Requirements.

• Developed warehouse returns, Order Cycles, Order Lines and Deliveries lines DSO and Cubes.

• Designed Mean delivery time, Vendors reports using Crystal Rep ort.

• Appended 2LIS_XX DataSources to fulfill the OM requirements.

KBTS Consulting

August 2006 – July 2011

1)Client: CapGemini / Coca Cola October 2009 – July 2011 Atlanta, Ga.

SAP BI Consultant

• Worked Full life cycle on SD - MTO-OTC - Collective Billing Implementation and supported COPA for their payment history reporting needs.

• Analyzed and Developed BEx Queries MultiProviders, InfoCubes DSO and appended DataSources (2LIS_xxx based DataSources).

• Worked on Customer Content and Developed ECM (Enterprise Contracts Management) queries.

• Developed these BEx reports Number of Contracts, Contract Management, Residual term Analysis.

• Supported all RSPC process chains for all SD submodules.

2)Client: KBTS SAP Training March 2007 – September 2009 Atlanta, Ga.

SAP BIW Consultant

• Conducted instructor led training session in SAP BW back end (developers) and front end (users).

• Trained users in Enterprise Portal.

• Tested end user procedures and ensured training validity.

• Trained power users with BEx and Web Application Design’s usage.

3)Client: Wheatland Tube January 2007 – March 2007 Pittsburgh, PA.

SAP BIW Consultant

• Worked with several functional users to gather the PO (Purchase Order) requirements.

• Extracted standard BW contents from SAP R/3 datarsources 2LIS_02_ITM using LO Cockpit.

• Designed custom InfoCubes and DSO Objects and enhanced existing DataSource, InfoSources.

• Supported Purchasing Values (Net Value of Orders from Vendor Analysis), Vendor Evaluation and Purchasing activities reports.

4)Client: Heatcraft Refrigeration Products August 2006 – December 2006 Stone Mountain, Ga.

SAP System Consultant

• Involved in Data Migration for SD modules.

• Supported Customer Master Data, pricing procedures, services, contracts, billing.

• Customized Pricing procedures, Condition types, Condition Tables, Access Sequence.

• Revamped Sales and delivery document types, number range.

• Took part in Core User Training.

Horizon Software International

August 2004 – May 2005

System Analyst

• Implemented POS (point of Sales) terminals installation with Horizon Proprietary software.

• Installed mySQL for backend and used SQL language for database update/repairs.

• Supported clients as a tier 2 technical support and live support.

Georgia State University

July 2002 – July 2004 Atlanta, Ga.

IT support

• Troubleshot classroom, Libraries and Computer Lab’s computers

• Supported and upgraded Windows servers and PC OS.

• Supported on campus Webstar (online registration support).

Education

Georgia State University

Bachelor’s Degree in Computer Science in MAY 2003

Certifications

SAP NETWEAVER ASSOCIATE BI



Contact this candidate