SUMMARY:

• Over 20+ Years of IT/IS experience in the Analysis, Design, Development, Implementation and Testing of SAP Applications and SAP HANA, SAP BW,
• 20+ Years of experience in SAP HANA, SAP BW on HANA, SAP BW, SAP BODS, SLT, SAP R/3. SAP experience as Techno - Functional Consultant in FI-CO/SD/MM/WM/PP/PM/QM/SM/PS/HR/TEM modules, SAP BW and SAP BASIS.
• Strong experience in developing data models in SAP HANA platform. Delivered reporting solutions using SAP HANA models for FI, HR, SD, MM, PM, Quality, Volume Metrics. Created Native HANA Views..
• Well versed with using SQL script for HANA platform development for both developing script based calculation views and for stored procedures. Used SQL script for creating stored procedures, table funcitons.
• SAP HANA optimization using table partitioning, performance optimization.
• Worked on SAP HANA Live project(SAP HANA Live for ERP) in Side-Car scenario. Used SLT to replicate data. Created very complex custom HANA models using reuse views, query views and value help views. Used HANA Live explorer extensively to find the gaps in delivered HANA content and made enhancements.
• SAP EIM experience for data provisioning in HANA using SAP BODS, SLT, SDA for remote data sources.
• SAP BW Certified 12+ years as SAP BW consultant with experience in developing custom data models using SAP BW object for Logistics, FI-CO, FI-AR/AP/GL, PS functional areas. Experience with activating and extending SAP Business Content. Excellent experience in BW customizing.
• Strong experience in delivering KPI reports in Sales & Marketing, Delivery & Logistics, Quality, Volumetric Reporting.
• Experienced in Gap Analysis, User Interaction, Requirements Gathering and delivering Solutions. Strong experience in setting up BW best practices, Performance Tuning to optimize overall user experience.
• Strong understanding of SAP Configuration and Functional Knowledge to understand user requirements. Experience in converting business requirements to functional and technical requirements and design and implement. Experienced in creating Functional Specs, Technical Specs, Test Plans, user documentation and user training documents.
• Back-end: LO-Cockpit, CO-PA, FI/SL extending data sources through Append structures, Business Warehouse Components Extractors, Update routines, Transfer routines for comm structures. Generic data source extraction using RSO2.
• SAP CRM/SCM to BW Integration. Extracting data from CRM/SCM to BW. Activating CRM specific cubes in BW and customizing CRM cubes in BW. Extracting master/transaction data from SAP CRM. Worked on loading data from SCM data sources in DP and SNP area.
• Experienced in Job Scheduling, data loading using Process Chains and info package groups.
• SAP BASIS experience both in SAP R/3 and BW in transports, SAP BW Security, user profile administrations, dump analysis, system logs, runtime analysis, performance tuning, applying OSS notes etc.
• Front-end: Business warehouse components BEx queries using calculated key figures, restricted key figures, filters, structures, hierarchies, variables, conditions, exceptions.
• Extensive experience in SAP ABAP working in FI/CO, MM, SD, PS, SM, HR modules and SAP Script, ALE, IDocs, BDC, BAPI, RFC, Jco, Reports, Interactive Reports, Dialog Programming, and Data Dictionary.
• Team Leadership experience handling on-site and off-shore resources. Strong work experience in global support model to support SAP applications. Mentored many team members of clients located different geo-graphical locations.

TECHNICAL SKILLS:

Data Warehousing: BW 7x, 3.1C, 3.0B 2.1C, SAP HANA, BODS, SLT

SAP R/3: 3.1H - 4.7 - ECC

Languages: ABAP/4, SQL, Java, XML, HTML, C, RPG/400, VB

Databases: Oracle,DB2/400

Tools: & Utilities: Visio, MS-Project, MS-Office

Methodology: ASAPOperating System: Windows NT/98/95/00,Unix/AIX,OS/400

PROFESSIONAL EXPERIENCE:

SAP HANA/BW Architect

Confidential, Springdale AR

• Working on implementing Product Cost Forecasting Solution for Confidential to enable to business to create costing estimates based on current raw material prices, cost drivers, forex trends, raw material price overrides.
• Sourced the cost component details and product itemization and related master data from ECC using ODP/SLT data sources.
• Customized AMDP processes to build product itemization data using material BOM structures.
• Built complex HANA data models to support analytics for Cost & Yield Volume Itemization, Costing Scenario Comparison, Spend Analysis, BOM Scenario Analysis for future BOM changes, Dis-Assembly Costing Analytics.
• Built integrated data models to consume Production Volume data coming from JDE and other sources.
• Used HANA Data Models in BW virtual objects to leverage BW master data for meaningful data analysis.
• Supported Tyson team to work with SAP on technical issues in HANA environment.

Sr. SAP BW/HANA Architect

Confidential, Houston, TX

• Worked on reporting solution implementation project for Confidential tax compliance process automation using SAP HANA /BW hybrid solution. SAP BW/HANA is used to interface with Endur for trading information, deals, movements, special ledger, volume tax and local taxes etc with SAP Finance, master data.
• Implemented HANA information models using LSA++ architecture.
• Worked extensively In HANA Studio to build EDAM HANA models to build enterprise wide harmonized HANA models to handle multiple data sources, build data mart/reporting HANA views to take care of business use case specific deviations to deliver to business needs.
• Developed HANA SQL procedures to create time dependent master data e.g customer, vendor, material, plant to track master data attribute changes required by business use case.
• Developed HANA views using table functions using HANA SQL for delivering complex use cases to improve performance and flexibility.
• Extensively used HANA composite providers to create reporting layer to implement hybrid solution using new native HANA models along with existing BW objects to create global reporting solution for both Confidential (HANA Models) and SOPUS (Legacy BW implementation).
• Interfaced SAP Trading source system for FI/GL, Shell GSAP source system for master data and SOPUS transactional data, Endur for trading, movements, billing, special ledger, taxation information.
• Created process automation for data interface monitoring, data reconciliation between all the involved systems for data integrity.
• Crated complex information models using HANA calculation views for trend analysis for volume movements, invoicing, tax filing support and error analysis reports.
• Used BOBJ WEBIs and AO Analysis for creating executive reports and adhoc analysis.
• Used BODS to interface with non-SAP data sources like Endur, and SAP SLT for interfacing with SAP data sources like Confidential SAP, Shell Global SAP source systems.
• Prepared cut-over plan and help execution of the production cut over and post production support for the project.

Sr. SAP BW/HANA Architect

Confidential, Findlay, OH

• Worked on SAP HANA Live for ERP to enhance user experience by creating custom HANA models for business consumption by reusing/enhancing HANA live delivered content reuse views, query views, value help views.
• Used HANA Live explorer extensively to explore HANA live delivered content to explore possibilities of replacing legacy reports in ECC/BW with HANA enabled reports for analytics/speed of delivery.
• Created workspaces for OLAP for Analysis for ad-hoc reporting using HANA models.
• Trained users with the new BO tools so that they can generate reports using new BO tools.
• Conducted workshops with business to gather data analytics requirements, find gaps in existing process for enhancements for enhancing business user experience with new HANA enabled reports.
• Used SAP SLT to deliver data from ECC to HANA using SLT trigger mechanism for delta loads.
• Implemented table partitions where the table sizes are larger. Enhanced HANA performance by implementing HANA best practices.
• Prepared cut-over plan and help execution of the production cut over and post production support for the project.

Sr. SAP BW/HANA Architect/Consultant

Confidential, Houston, TX

• Built native HANA models for HR applications bringing in data from SAP successfactors (employees), Fieldglass(contractors), Budget data using SAP Data Services(BODS).
• Setup SAP BODS interface to load data from SAP cloud platform, created many jobs to load data into HANA tables for data consumption.
• Created many reports using BOBJ AO Analysis tool and created many workbooks and published them to corporate consumption.
• Setup user workshops to gather reporting requirements, and to analyze data availability in various source systems for gap analysis.
• Created HANA models from current BW objects and used them in native HANA models for object reusability and faster delivery of the reports.
• Worked with business users for UAT, production cutover planning, post go-live support needs.

Sr. SAP BW/BI Architect/Consultant

Confidential, Corporate, Downstream

• Brand new SAP BW implementation Worked on SAP BW on HANA DB and used SAP Data Services (BODS) for data integration, SAP BOBJ for reporting.
• Responsible for setting up volumetric data integration from Energy Components and aligning volumetric data and Opex data with other applications. Data integration using SAP BODS for smart data integration.
• Extracted data from 15 different Energy Components (EC) source systems globally separated, using SAP BODS. Developed BODS jobs for extraction and loaded data into SAP HANA system for SAP HANA models.
• Created SAP HANA models for volumetric reporting using attribute views, analytical views, and calculation views using multi layer modelling and with object reusability concepts.
• Implemented attribute views with texts with multi language capability.
• Created eclipse composite providers and used existing BW objects from SAP BW/HANA for reporting needs in SAP HANA models.
• Responsible for delivering Well Information Management Reporting solution for Confidential operations for worldwide production units using inspections data from SAP QM module.
• Delivered many queries and reports for SAP BOBJ dashboards for management reporting, and WEBIs for ad-hoc analysis.
• Responsible for set up the stage for Integration Testing, User Acceptance Testing.
• Responsible for set up the processes to extract data using traditional SAP process for data extraction from SAP systems and Data Services for non-SAP systems.
• Set up processes for complex Well Testing backlog aging reports using APDs and process chains.
• Setup jobs to do the initial data migration into new BW on HANA environment, data validation, setup plan for production roll out, and post production support.

Sr. SAP BW/BI Architect/Consultant

Confidential, South Beloit, IL

• Managed BW project delivery, setting client expectation, tracking work items, design, build, testing and production support.
• Worked on BW backend architecture, adding new back end objects to existing BW implementation and enhancements/improvements to existing design.
• Implemented and enhanced BW design in the areas of Sales, Shipments, Billing, Vistex areas.
• Created new process chains and scheduled for automated daily loads for new functional areas.
• Implemented automated communication through email alerts for data load monitoring.
• Worked on various report deliverables in the area of Sales and Distribution which include Daily Orders and Shipments report, Line Fill report, Production Schedule report, Days Forward Coverage Report, Forecast Bias Report etc.

Sr. SAP BW/BI Consultant

Confidential, Denton, TX

• Worked as Solution Architect for redesigning to improve current BW design for Packaging Material process related BW backend objects and reports to resolve data issues, improve report performance, implement BW best practices.
• Worked on Who Buys What and PLC re-design to reduce complexity in current design.
• Worked on Inventory Management reporting design to reduce design complexity, optimize ETL logic, reduce unused objects from the current design.
• Worked as Go-To person for other team members for their technical/design issues.

Sr. SAP BW/BI Consultant

Confidential, Houston, TX

• Designed solution for Projects to Assets using BW Project Systems (PS) and BW Purchasing content.
• Designed solution for IOL Financial consolidation reports using SAP BW FI-SL content.
• Worked on remediation for StarCOGS ( Cost of Goods application) design reports and created all the design documents.
• Implemented Projects Systems (PTA) reports which includes data from PS, IM, Purchasing functional areas to show analytical reports to compare budget, actual, commitment and PS and Purchasing integration report building, back end implementation to support PTA reports.
• Created utility tools to improve development/design decisions and to speed up design process and implementation process.
• Worked with other project teams to prioritize inter related tasks, help other team members in resolving their design/technical issues. Acted as a go to person for BW technical issues for other team members.
• Worked with other teams finalizing user testing preparation, cutover tasks, project documentation, user documentation, training materials for power users.
• Conducted BW training for users with new reporting functionality.

Sr. SAP BW/BI Consultant

Confidential

• Lead the BW ETL performance optimization project to remove in-efficiencies in extractors.
• Lead the implementation of reporting in Inventory Management. Customized SAP business content data sources, designed data model for IM, developed custom cubes, DSOs, Transformations, developed performance optimized transformation routines, start routines, end routines on back end side.
• Developed solution to facilitate Stock Aging reports using BW APDs.
• Lead the implementation of Delivery Reporting for Capital Equipment, Reporting for Billing, Service Orders with classification data. Helped team members to achieve their deliverables, helped them in resolving technical issues, data modeling optimization etc.
• Worked as a mentor for many project team members. Helped them in solving design/ implementation and data model issues.
• Working in new BI 7.0 version.
• Worked extensively in performance tuning, implanting performance optimized solutions so the reports and back end development meet business expectations.
• Developed front end reports using Web Application Designer, new enhanced BEX Query Designer.
• Developed process to reduce object regression issues for developing code R/3 data source user exits, transformation routines and on front end variable user exits.
• Working on performance improvement project. Analyzing bottlenecks, identifying code improvements in transformations, update rules, transfer rules, user exits. Designing version manageable includes and methods for transformations.
• Setting up standards for back end development objects, like naming conventions, coding standards, guide lines etc.
• Created procedures to test BW upgrade process to mitigate the risk due to upgrade of the systems/applications and to manage the impact to the business continuity.

Sr. SAP BW/BI Consultant(Architect)

Confidential, Houston, TX

• Worked on BI 7.0 Upgrade project and testing BW 3.X objects/reports in new version for technical upgrade.
• Lead the implementation of Asset Accounting reporting in BW. Enhanced business content to meet business reporting requirements.
• Gathered business requirements for Asset Accounting reports for both Period Closing process and ad-hoc reporting process.
• Created multiprovideres using Asset Accounting and GL Cubes to generate re-conciliation reports to identify any transaction posting issues.
• Used SAP Best Practices to improve usability of Asset Account Reporting with re-useable BW objects using restricted/Calculated key figures, structures, complex formulas. Enabled users to reduce the Period Closing Process time.
• Re-Worked on old GL implementation(Using ODS) in BW and converted to Star Schema model(Cubes/Multi-Providers). Created multiple cubes to separate B/S, P/L data into different cubes.
• Created historic cubes to separate current and older data to improve performance of current data reports which are frequently used.
• Implemented best practices in coding start/end routines, transformation routines with global includes, global reusable objects for code harmonization, to improve maintainability of back-end objects.
• Created How-To documents for other team members to use new processes implemented. Created How-To documents to solve common issues in data loading, reporting and for best practices.
• Implemented BW technical content to identify performance issues in data loading, reporting. Also used technical content to identify BW usage and unused objects.

SAP BW Senior Consultant

Confidential, Houston, TX

• As a senior BW consultant worked on many projects to enhance the usability of BW and user experience at Confidential in OTC, PTP, Logistics, Finance, Supply Chain Management(APO), CRM areas.
• Worked extensively on BW Backend objects like InfoCubes, ODSs, InfoSets, InfoObjects, TranserRules, Update Rules, Update Routines, Reporting Agent, Process Chains, Job Scheduling, BW user exits, then BW front end reporting using advanced concepts like Web Reporting, Restricted/Calculated Key figures, formulas, structures, variables, Virtual Key figures, Virtual Characteristics, BW front end user exits.
• Worked on Profitability Optimization Model for Confidential to enable users to calculate fixed cost allocations to at a product or supply chain level.
• As part of SAP APO upgrade project handled all the BW-APO integration testing scenarios, test plans and fixed the issues caused by APO upgrade to BW extraction.
• Worked on Full Life Cycle project implementing SAP CRM InfoCubes for Confidential Sales Pipe Line project.
• Created Cubes and ODS objects for CRM Opportunity Management and Lead Management.
• Activated master data sources in CRM source system to bring CRM Master Data.
• Worked on many enhancements related to OTC(Order to Cash), DL(Distribution Logistics), GM(Gross Margin) and Finance cubes involving complex BW multi layer architecture. Created lookup routines while loading data to targets.
• Created data targets in the area of PM to enable reporting in PM Service Items.
• Worked on BW performance enhancements. Created aggregates, indexes, partitions, query filters. Used BW Technical Content cubes to analyze performance issues.
• Worked on Process Chain enhancements to optimize data loads.
• Worked on WebTemplates and Reporting Agent for pre-calculation of WebTemplates and facilitated users to download large volumes of query output and upload to Price Management Waterfall tool for further analysis.
• Worked in Global Support model and worked with off-site resources located various locations world-wide to give optimal support to customer.
• Participated in various support pack upgrade testing.

SAP BW Principal Systems Analyst

Confidential, San Diego, CA

• Full life-cycle BW implementation SAP BW 3.1c with Business Content 3.3.
• Worked on SAP CRM - BW integration project. Created CRM Activities, Installed Base, Sales Force Automation cubes, analyzing gaps between business requirements and business content, customizing BW cubes related to CRM.
• Responsible for FI, SD, SM, QM cubes. Created custom Info Cube/ODS to bring in Open Orders, Contracts, Invoices, Service Order, Quality notifications.
• Worked in various functional areas Sales(SD), Service(SM), Quality(QM), Finance(FI) cubes involving complex BW multi layer architecture.
• Responsible for bringing in third party MII data to replicate existing data warehouse, and leverage BW OLAP capabilities, by creating multi cubes with MII and Sales data for KPI analysis.
• Worked with user community to enhance existing functionality and rolling out new functionality in BW reporting.
• Enhanced extract structures for master data objects to bring in additional fields using user exits.
• Extracted SAP Classification data for customers and materials using SAP cross application extraction components.
• Created Process Chains/Info package groups to schedule data loads.
• Responsible for managing transports for preparing for production go-live.
• Responsible for daily/weekly jobs for master data loads and deltas. Resolving data load issues.
• Worked extensively on queries using calculated key figs, restricted key figs, hierarchies.
• Responsible for BW authorizations, creating new roles, BW Reporting Authorization objects using RSSM, assigning roles to users, modifications to existing roles as per changes in organization etc.
• Created reports in BEx using Navigational attributes, variables, global structures, RRI, Exception Reporting,
• Setup printing jobs using reporting agent to schedule printing reports in batch jobs. Used conditions and exceptions.

SAP Interfaces/BW Specialist

Confidential, St.Louis, MO

• Worked as EDI consultant to interface Agilisys and SAP R/3 4.6c using IDocs, ALE, RFCs.
• ALE Configuration in SAP R/3 to transfer master and transaction data from SAP R/3 to Agilisys.
• Created custom IDoc to transfer IDoc statuses from Agilisys to SAP R/3
• Created functional and technical specifications for business requirements.
• Worked on data extraction from Aglisys to SAP BW using custom extractor.

SAP BW Consultant

Confidential, San Jose CA

• Designed and developed star schema structures for new business content and customized cubes for MM and SD applications using LO Cockpit customizing.
• Designed InfoCubes and ODS objects to aggregate data from FI-AR, FI-AP, FI-GL..
• Enhanced and created InfoCubes, MultiCubes and ODS objects as required by the business requirements.
• Created Transfer Rules, Update Rules using ABAP routines, Master Data reference, Formulas etc to enhance incoming data.
• Used R/3 User Exits to populate the new fields added to Master/Transactional Data Structures.
• ETL Performance using Parallel loading, adjusting data packet sizes, deleting indexes etc.
• Loaded standard hierarchies for GL accounts, Cost Centers.
• Enhanced, developed and designed queries using BEx Analyzer Reporting tool for data presentation for drill down functionality in excel.
• Created reports in BEx using Navigational attributes, variables, global structures, RRI, Exception Reporting,
• Created Multi Providers for reporting purpose using basic Info Cubes.
• Conducted user acceptance testing and training.
• Unit testing the Infocube data with transactions against the updates, and delta updates.
• Building and activating InfoSources for master data (including Navigational Attributes) and transaction data from the data source (Source System).
• Working with training development to include data access solution in BW course materials
• Creating Infopackage Groups, Process Chains for data loading. Transports in SAP landscape, applying OSS notes.

Sr. SAP Consultant/Team Lead

Confidential, San Jose, CA

• Member of SAP BW Implementation Team for full life cycle implementation
• Extended the custom InfoSource from the Business Content for MM - Purchasing for Transactional data
• Worked on Data Extraction, Transferring the data into SAP BW from SAP R/3.
• Installed and extended standard Business Content based on client requirements for enhancing DataSources for transaction data, master data
• Created Master data InfoSources for uploading attributes, texts, and hierarchies from Non SAP system
• Responsible for building InfoCubes for SD Customer, Deliveries and Sales overview from the standard content
• Used R/3 User Exits to populate the new fields added to Master/Transactional Data Structures.
• Testing the InfoCube data with transactions against the updates, and delta updates.
• Transporting the BW objects created/activated/modified from Development System to Test System and Production System.
• Created workbook templates for the required purchasing queries and assigned them to the roles..
• ETL Performance using Parallel loading, adjusting data packet sizes etc.
• Involved in developing the queries to suit the client’s requirement using BEx Analyzer and incorporating the queries into workbooks. Used Variables, Filters and free characteristics, restricted key figures, calculated key figures in developing the queries.
• Interacted with functional experts for designing data models and Data Sources.
• Created various InfoSets for enabling the users to create the queries easily with minimal effort.
• User administration, Roles and authorizations. OSS notes, transports, job scheduling.