• 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