Candidates About

 

Andy SAP 

Profile

SAP BW/BI/HANA/ABAP solution architect with 18 years of IT experience that includes 16 years of SAP BW (Versions 2.x, 3.x, 7.x), over 9 years of SAP BusinessObjects (3.x, 4.x), 2 years of SAP HANA implementation experience, and 2 yrs non-SAP IT  experience. 

 

Experience Summary

-          SAP BW/BI Lead roles at Love’s, NTT Data, SITA Corp, AIG and Microexcel.

-          SAP BW, BusinessObjects Reporting solution implementations & Upgrades for clients such as Love’s, AIG, Turner Constructions, Hospira, T-Mobile, Hubbell, Momentive Performance Materials, KLA-Tencore and Pearson.

-          Speaker at an ASUG Conference – Enterprise Information Management.

Skills Summary

u SAP BW/BI Project Management u SAP BW/BI/HANA Technical Architecture Solutioning u SAP SCM/SEM/CRM Integration with SAP BI u SAP BW/BO Upgrades

u Reports Development (BEx, Crystal, Webi) u Dashboards Development (Design Studio, Xcelcius, BEx Web) u BI Data Modeling u BI Data Migrations with BO Data Services

u SAP BW/BI Security and Authorizations u SAP BI Data Extractions u SAP HANA u SAP Lumira (SAP Visual Intelligence) u SAP BPC u SAP ABAP

Professional Experience

Love’s Country Stores, Oklahoma City, OK.

Jan 2014 –  Till Date

SAP Versions: SAP BW 7.4 SP11 on HANA, SAP BO 4.1 SP5, SAP BPC 10,ABAP.

SAP BW/BI/HANA/ABAP Lead responsibilities :

·          Oversee an SI vendor in implementing Financial reporting that includes P&L, Income Statements, Expense Reports, Rolling 12 month trend reports, Budget Distribution and other reports out of GL, AR, AP data.

·          Designed and developed technical solutions for FI measures such as ’12 Month Co Average’ and Maturity metrics.

·          After going live in June 2014, managed an onsite and offshore team in on-going support and enhancements of FI and CRM reporting.

·          Designed and built a Design Studio Dashboard to monitor TireCare metrics with CRM Service Requests data.

·          Utilized HANA Live views for CRM Service Requests in developing CRM reports such as Daily Declines and Service Case Detail Reports that includes data authorizations.

·          Utilized data modeling techquies such as Composite Providers to combine BW data with views in HANA.

·          Built a P&L dashboard based on KPI’s built based on SAP HANA calculated views.

·          Support of SAP BPC environment – upload of summarized GL data, Plan vs. Actual reporting.

 

 

Kohler, Sheboygan,WI.

August 2013 – Dec 2013

SAP Versions: SAP BW 7.3 on HANA implementation ,ABAP.

SAP BW/HANA/ABAP Technical Lead responsibilities:

·          Design and implement an Enterprise Sales Database (ESD) for Kohler’s Sales, Marketing and Finance reporting.

·          Create an SAP BW 7.3 on HANA optimized foundational data model to combine historical (Oracle) data with current (SAP ECC 6.0) data, and combine Sales and Marketing (LO Cockpit) information with COPA (Line Item level) information to provide a one-source-of-truth reporting solution.

·          Implemented with an ASAP methodology, conducted in-depth blueprint sessions, coordinated offshore development, supported user integration testing, with planned go-live for end of December 2013.

 

Microexcel, Secaucus, NJ.

May 2013 – August 2013

SAP Versions: SAP BW 7.02/7.3, SAP BI 4.0, SAP HANA, SAP Lumira,ABAP.         

SAP BW/HANA/ABAP Technical Lead responsibilities:

·          Lead BW engagements – requirement analysis, resource planning, delivery.

·          Build SAP BW, SAP HANA, SAP Lumira demonstrations to showcase capabilities to clients.

·          Participate and contribute in SAP ASUG, SAPPHIRE, SAP Teched events.

 

AIG, Parsipanny, NJ.             

April 2012 – May 2013

SAP Versions: ECC 6.0, BW 7.02/7.3, BO 4.0, Dashboards 4.0,ABAP.

As a BW Lead, responsibilities included BW production support team management, offcycle/oncycle deployment oversight, and technical issue resolutions.

 

BAU (Business-as-usual) activities included support and enhancements for:

·          GL/FSL/RI/CD data models

·          CFP reporting architecture that includes Finance Analytical, Operational and Statutory Yellow Book reporting.

·          GIFT Release support – US, UK, Japan, Nordic countries

·          STAT Analytics, an ASL/Department level performance reporting solution with BO Advanced Analysis toolset.

 

DSS Retirement Phase 1 – As the BW Lead for the Phase 1 of the project, successfully designed and delivered a reporting solution for retiring the ICP module, which included a set of 12 reports for the Chartis F&A Ops group.

 

DSS Retirement Phase 2 – Provided oversight for the delivery of 18 reports for OPS Results, OPS Expenses, Claims Financial, Canada and T-Recs user groups.

 

Expense Analytics – Headcount and Expense management reporting at Function, Sub-Function, Geography and Manager levels.  Built a BO Web Intelligence and BI Mobile App reporting and dashboard solution.

 

 

SITA CORP, Somerset, NJ.

November 2011 – March 2012.

SITA CORP SAP BW/BI/HANA Lead Responsibilities:

q  SITA CORP is an SAP Partner providing SAP Consulting, Managed Services, and Mobile Solutions.  As an SAP BW/BI/HANA practice manager, I have responsibilities of developing a Center of Excellence in SAP BW/BI/HANA.

·          BW 7.3 database migration - from Oracle based to a HANA 1.0 database.

·          Demonstrated use of SAP In-Memory Computing Studio components (Admin Console, Information Modeler) in user management and data modeling.

·          Built dashboards integrating BO 4.0 to BW 7.3.

 

Client: Turner Construction, Montvale, NJ.

SAP Versions: ECC 6.0, BW 7.3, BI 4.0,ABAP.

q  Responsibilities for Project Cornerstone

q  Legacy to SAP Data Migration:

·          Involved in data conversion and cleansing activities utilizing BO Data Services 3.2.  Built job flows that combine data from multiple sources (CMIC, Ferrell, Prolog, MS Excel), transforms based on business logic and validation rules, to generate output files that can be loaded to SAP ECC. 

·          Setup of validation reports in FI, MM, SD and CRM areas.  Built and maintained universes and webi reports for data validation and reconciliation activities.

·          Provided validation user training and support.

q  BO XI 3.1 upgrade to BI 4.0 using the Upgrade Management Tool

·          Prepared upgrade plan with tasks & milestones, along with QA & UAT testing strategies.

·          Migrated Users, Security, Universes and Reports to BI 4.0.

·          Configured BI 4.0 Processing Servers (Adaptive, Webi, Dashboard, Crystal) for optimal performance.

 

 

Intelligroup Inc., an NTT DATA Company, Princeton, NJ.

Client: Hospira, Chicago, IL.

Feb 2011 – November 2011

SAP Versions: BW 7.3, BW 3.5, SAP ECC 6.0,ABAP.

q  SAP BW Delivery Lead for all SAP BW Development and Support assignments at Hospira.  Responsibilities include requirement solutioning, project scoping, estimating, resource planning, and delivery.  Managed a team 12 Developers and 4 Support resources (onsite and offshore) in delivery the following projects..

·          HSST CRM-BW implementation:  Hospira plan’s to implement CRM 7.0 to support and improve medical device service contracts, complaints management processes.  CRM analytical reports are being provided in the areas of contracts management, complaints management, surveys, amongst other areas.  Responsible for technical architecture setup (data models and reports).

·          Phoenix (implementation in BW 7.3):  Implementation of Sales Performance Mamangment (SPM) interfaces that combines direct sales (from COPA) & indirect sales (from ModelN system) for reporting through SPM.

·          SAP BW Support:  12/7 support of the BW production environment.  This includes supporting all SAP (FI/SD/MM/APO) and Non-SAP interfaces.  Support of business users based in US, EMEA and APAC regions in their reporting needs.

·          APO-BW Reports Migration from BW 3.5 to BW 7.3:  Provided migration methodologies for APO Reports (Staggers, MPS, Forecast Analysis, Projected Withdrawal and Weekly Inventory Projection reports). 

·          DIOS & Competitive Insghts:  Overseeing delivery of DIOS (Inventory Optimization processes) and Competitive Insights extracts development and delivery.

 

Client: REXAM, Chicago, IL.

Nov 2010 – Jan 2011

SAP Versions: BW 3.5, SAP ECC 6.0,ABAP.

q  BW Technical Lead for Rexam’s BW 3.5 to BI 7.0 technical upgrade.  Rexam is looking to upgrade the SAP landscape to NetWeaver 7.0 environment to be in compliance with Rexam’s IT systems update.  This is to enable compliance with IE 8.0, Windows 7, Microsoft Office 2010 updates.

·          Prepared BW technical upgrade project plan, BW tasks, testing plan, test cases.

·          Supported Basis team with BW tasks in the Prepare, Upgrade and Post Upgrade phases.

 

Client: T-Mobile, Bothell, WA.

Feb 2010 – Nov 2010.

SAP Versions: BI 7.0, BEx (Excel and Web) Analyzer, SAP ECC 5.0.

q  BI Technical Lead for T-Mobile’s BI Functional Migration project.  To maximize ROI on BI, T-Mobile migrated all 3.5 functionalities to 7.0 functionalities, along with implementing new 7.0 tools and features. 

·          Management of backend, frontend and security migrations with onsite and offshore teams.

·          Coordinate with T-Mobile in overseeing project tasks with other T-Mobile teams (EIT, AMS, Basis).

·          Redesign and optimization of obsolete BI authorizations to new Analysis Authorization concepts and processes.

·          Oversee technical issue resolutions during migration of objects.

·          Performance tuning of BEx reports.

·          BI 7.0 BEx Power User and End User web based training material development.

 

q  BI Systems Analyst for T-Mobile’s El Dorado (BW piece for Insurance Order Reporting) and CUP (Care Upgrade Policy) projects. 

·          El Dorado – BW Extract requirements captured in FSDs, designed solutions for Open Hub extractions of Sales, Deliveries, Billing, Purchase Orders and related master data extracts.

·          CUP – Designed a delta load process to optimize load performance for Revenue and COGS data captured from POS and non-POS processes.

 

 

 

 

 

Client: Hubbell Inc., SC

December 2008 – Jan 2010

SAP Versions: BI 7.0, BO XI (R3.1), XCelcius 2008, Crystal Reports 2008, SAP R/3 4.7

q  BI Lead Architect for Hubbell’s BW 3.1 to BI 7.0 re-architecture and migration project.  Migration involves upgrading Hubbell’s reporting environment to use tools and features of SAP BI 7.0, BO XI R3.1, Crystal Reports 2008 and Xcelcius Dashboards accessed through EP.

·          Setup of a data warehouse foundation for Hubbell’s current and future reporting needs.

·          Setup of a seamless security enabled BI, BO, EP environment.

·          Setup of a foundation to enable platform specific solution designs, hierarchies for rolling-up platform specific data up to corporate, setup of XCelcius dashboarding facility for functional area kpi’s, provide BO Webi adhoc reporting capability integrated with Enterprise Portal.

·          Architecture setup for the Executive Report (includes SD, CO-PA, CO-PC, PCA, Forecast and Plan from IP, and non-SAP data) to report and analyze on planned, forecast, actual and backlog figures.

·          Setup of an XCelsius dashboard for the Executive Report.  Executive Report has Corporate and Platform (HLI, HES, HPS) specific data pertaining to Actuals, Plan, Forecast and Variances from SD Orders. Gross Order, Net Order, Gross Billing, Net Billing, Gross Margin and Net Margin %s, Prior and Current Year Variances from CO-PA and PCA.

 

Client: MEDA Pharma, Somerset, NJ.

Octomer 2008 – November 2008

BI 7.0, Crystal Reports v10, Crystal Enterprise Server, SAP ECC 6.0.

q  BI Solution Architect responsible for setting up the Financial Package (a set of financial reports) using Crystal Reports.

·          Reports include Income Statement, Cost Center Reports (with cost center and cost element grouping), Net Sales by Product, Advertising & Promotions, among others.

·          Provide solutions and work-arounds for Crystal Reports version incompatibility issues.

·          BI 7.0 Functional Migration of objects currently in use.

·          Provide BI 7.0 training for the existing BI team.

 

Client: KLA-Tencor, Milpitas, CA.

April 2008 – September 2008

BI 7.0, CRM 5.0, SAP R/3 4.7.

q   BI Solution Architect responsible to resolve data warehouse architecture and reports design issues related to the Panthera project (CRM Service Analytics implementation).

·          Resolved issues pertaining to Installed Base, Contracts, Service Cases, Escalations, Billing, Resource Utilization reports.

·          Setup of Tool Metric KPI’s to show Tool Down Times, MTTR (Mean Time To Repair), MTBF (Mean Time Before Failure), Availability and Uptime %’s.

·          Responsible for Onsite-Offshore coordination for enhancements.

 

 

 

 

Client: Momentive Performance Materials (MPM), Albany, NY.

November 2007 – April 2008

BW 3.5, SEM 4.0, BI Content 3.53, R/3 4.6.

q  BW Lead/Solution Architect responsible for Intelligroup’s BCS/BPS implementation at MPM (Project Jupiter).  Project Jupiter is to replace the current offline Oracle based planning and consolidation system. 

·          Responsible for the BW architecture required for the implementation, development and delivery from offshore.

·          Design of data models, FIGL extraction, and providing Income Statement, Balance Sheet, and Cash Flow reports through Enterprise Portal.

·          Integration testing of the planning and consolidation processes.

 

Client: Pearson, Old Tappan, NJ.

December 2005 – November 2007

BW 3.5, BI Content 3.53, R/3 4.6, ECC 5.0, APO 3.0.

q  BW Lead/Solution Architect responsibilities for Intelligroup’s BW engagement (Support and Enhancements) at Pearson.  Responsible for the delivery of multiple BW projects (ISBN13 Conversion, Global Spend Analytics, Global Production Datamart, Global Calculation Tool, Bookscan, Gelco, etc.) to aid Pearson’s worldwide print and digital publishing business.

·          Provided solution designs, estimates (time and resource), resource management, project management, solution delivery and support of all BW projects.

q  Book Scan: Provides Pearson Higher Ed sales through Book Scan.

q  GELCO:  Analysis of employee T&E expenses.

q  Global Production Datamart Phase II: For an effective supplier rationalization across the globe.

q  Spend Analytics Phase II: To analyze spend across business units and leverage best pricing options.

q  Global Calculation Tool: To compare supplier scale pricing

·          Production Support responsibilities:

q  Resolve escalated techincal issues for R/3 4.6, ECC 5.0, APO feeds to BW.

q  IT and Business Maintenance requests.

q  Off-shore batch monitoring team management

 

Client: GE – Insurance, Kansas City, Kansas.

July 2005 – Nov 2005

BW 3.1, BI Content 3.3, R/3 4.7.

q  Project PASS is an R/3 & BW implementation project for Kansas City based GE-Insurance, being implemented using an on-site/off-shore development methodology by Intelligroup.  GE-Insurance needs about 600 Insurance reports to be developed and deployed.

·          Lead for a 30 member off-shore BW team for Project PASS. 

·          Involved in BW architecture & landscape decisions.

·          Task Order based reports (Workbooks and Web Reports) delivery - Estimates, Assignment, and Delivery.

·          Responsible for creating and maintaining teams for reports development, architecture development, QA and data loads.

·          Responsible for recruiting BW resources with the required skill-sets for Project PASS BW tasks.

           

Client:  Owens Corning Asia, Taloja, India.                                                                         

Nov 2004 – June 2005

BW 3.1, SCM 4.0, CRM 4.0 and SAP Version 4.7.

q  Asia-Pacific SAP Implementation.  Owens Corning (OC) is currently implementing SAP in 6 of Asia-Pacific countries.  Apart from providing R/3 SD and Inventory data to OC’s Global BW systems, a regional BW system is being implemented specifically for reporting needs of Asia-Pacific region.  This regional BW system is integrated with R/3, SCM, CRM and EP.

·          Lead for the Asia-Pacific BW implementation.

·          Design and develop CRM reports for Lead Management, Opportunities, Quotations, Activities, and Complaints.

·          Setup/Configure integration with Enterprise Portals, install Business Packages related to Employee and Customer Portals.

·          Train users in using BW reports.

 

Client:  Owens Corning, OH                                                                          

May 2004 – Oct. 2004

BW Version 3.1C, SCM Version 4.0 and SAP Version 3.1I          

SCM-BW Integration. Customer Inventory Management (CIM) - Owens Corning is currently implementing SCM 4.0 for the CIM project, specifically to manage their customer's inventory utilizing the Vendor Managed Inventory (VMI) and Material Release Shipment Schedule (MRSS) methodologies. 

·          Responsible for SCM-BW integration for the CIM project.

·          Responsible for onsite-offshore BW development coordination.

·          Designed the DP planning area object structure (in SCM-BW) required to facilitate navigational abilities based on ABC Classification of Products.

·          Developed interfaces for loading initial Sales History data extracted from SQL Server to DP planning areas. 

 

Client:  GE Silicones, Albany, New York.                                                                            

October 2003-May 2004

BW Version 3.0B and 3.1C, SAP Version 4.6B and 3.1I   

q  BW Consultant

·          Responsible for data integration of OSi R/3 3.1I and GE 4.6B Systems in GE BW 3.0B.

·          Prepared an analysis document for the data integration work, analyzing all reporting requirements (Digital Cockpit, Position Reporting, FOTC and SPAN), researching all available solutions for data integration, proposing the best available solution, and providing hardware sizing requirements.

·          Used LIS Extractors and enhanced standard Sales Order, Open Orders, and Deliveries Extractors, built custom Open Deliveries and 3rd Party Drop Ship, Credit and Debit Memo Extractors on R/3 3.1I. 

·          Resolved Master Data conflicts, Transactional Delta Issues, and Data load issues.  Created and scheduled process chains for Master Data and Delta loads.

 

HCL Technologies, IL.

Clients:  Ajinomoto, IL & Armstrong, PA                                                                             

August 2003 – September 2003

BW Version 3.0B and 3.1C, SAP Version 4.6C

q  BW Consultant.

·          Ajinomoto and Armstrong are considering a web-based application for their management cockpit and KPI reporting needs.

·          Designed and developed the Web Application Prototype using the Web Application Designer tool of Business Explorer.

·          Configured WAS/ITS, Global BW Reporting settings, and web based reporting settings to accommodate web report access globally.

·          Designed and built InfoCube and ODS objects, reports based on these InfoProviders, and a user-friendly web application to analyze business cases.

·          Capabilities of the web application prototype include filtering/drilling down using navigational blocks, filters, dropdown list boxes, radio buttons, exception alerting, RRI, exporting of data, and capability of storing remarks.

 

NetEffects Inc., MO.

Feb 2001 – May 2003

BW Version 3.0B and 2.1C,SAP Version 3.1H and 4.0B

q  BW Consultant.

·          <span style="font-size:12pt;font-family:Garamond, se