SUMMARY

• 15 years of extensive experience in SAP BI (BW, BW on HANA, Native HANA, ABAP, HANA SQL, HANA XS, SLT, SDI/SDA, BODS, BOBJ, BPC/IP, CDS Views, HANA Performance Tuning, S/4HANA Embedded Analytics, Lumira, Web Intelligence, Analysis Office, Power BI, Tableau, Hadoop, SAP - ECC-SD-MM-FI) in all aspects of Analysis, Design, Development and Support.
• SAP-HANA-ECC-BW-S4HANA-Functional: Worked Extensively in Sales & Distribution, Supply Chain, Purchasing, Inventory, CRM, APO, Vistex, Finance (GL, AR, AP, CO-PA) & S/4 HANA Finance/Logistics.
• Worked Extensively in SAP HANA-BW Data Modeling, Extraction, ABAP Programs, HANA Stored Procedures/AMDP, HANA SQL Scripts, SQL Exception Handling, Table Functions, Transformations, Performance Tuning, Function Modules, Enhancements, Production Support, Upgrades, User exits, Transports, Authorizations, Info Objects, Info Sources, Aggregates, Open hubs, APD’s, Routines, Partitions, Hierarchies, BI Technical content, BTE, Process Chains, DSO’s, SPO’s, Info Providers, Multi Providers, Composite Providers, ADSO’s, Open ODS Views, HANA Views (Calculation Graphical/Scripted, Attribute, Analytic), AMDP’s, Virtual Providers, ODP, LSA++, HALM, Delivery Units, HANA Live, HANA XSA, Workspaces, BPC/IP, HAP, CDS Views, HANA Authorizations, LO-Cockpit, SDI, SLT, Hybrid Scenarios, Enterprise HANA Cloud & S4HANA Data Migration Cockpit.
• Strong ABAP/HANA SQL Stored Procedures/AMDP’s: Worked extensively building Start/End/Expert Routines/AMDPs with complex business calculations, Function module extractions.
• SAP-HANA Performance Tuning & Optimization: Worked extensively on Optimizing HANA SQL Scripts, SQL Traces, Runtime Analysis, Debugging, Explain/Plan/SQL Monitor and Code Inspector/ATC.
• BW-HANA 2.0 Security/Authorizations: Worked on HANA User Accounts, Database/Repository Roles, Privileges (Object, Package, Analytic and Application), Tracing and Trouble Shooting.
• Reporting-BOBJ-Webi-Analysis-Office/BW-BEx: Worked extensively on Web Intelligence, Analysis Office, Lumira, Tableau, BEx Query Designer/Analyzer building Queries, CKF, RKF, Formula Variables, Conditions, Exception aggregations, Complex customer Exit Variables and Structures.
• SAP BW Data flow Design, Architecture, Support, Transport Management and Security: Worked extensively on all project architectural decisions, Design reviews, Project developments, Deltas loads, Process chains, Generic extractions, Troubleshooting, Fixing, Aggregation, User administration, OSS Notes, Debugging ABAP routines, Data load Monitoring, Troubleshooting, Transaction/Master Data, Change Management, Process Chains Monitoring, Transport Management and Security.
• HANA- SAP Landscape Transformation-SLT: Worked extensively on LT replication server configuration, Functional usage of SLT, Timestamps, Logging Tables, Load/Replication Jobs, Activate/Deactivate Configs, SLT Server Jobs/Data loads, Type Mapping, LT Cockpit, Config and Monitoring Dashboard.
• Worked on 4 Full Dev. Life Cycles in SAP BW-HANA-Native HANA (7.4 & 7.5).
• SAP HANA Data Virtualization-SDI: Worked on Installing/Configuring SDI Agent, Hana Web IDE, Hana Monitoring Cockpit, SQL Commands, Adaptors, Virtual Tables, Performance Aspects, Reading Remote/Batch Data, Real time Replication/Transformations and hdb flow graph Editor.
• SAP-BODS-Data Services: Worked extensively Connecting to different source systems ERP, SQL Server, Flat Files, Importing Excel/XML Files, Creating/Scheduling/Sequencing ETL Jobs, Built-In/Custom Functions, CDC, Tracing Jobs, Setting up Error Handling, Debugging & Auditing Data Flows,
• SAP BPC/IP: Worked on Planning functions, Layouts, Aggregations, Sequences, Cost Center Planning with Input Enabled Queries, Fox Formulas and Optimized Formulas.
• Excellent Communication, Interpersonal and Problem solving skills.
• Passionate Building strategies, Proof of Concepts, Road maps towards vision of the organization.
• Outstanding problem solving skills identifying root cause and estimating magnitude/impact of issues.
• Trained on BW310, BW360, HANA100, HANA300, HA360, HA400 and HA355 from SAP Education.

TECHNICAL SKILLS

SAP/ BW/HANA: SAP BW 7.4/7.5, HANA 2.0, HANA Design Studio, SLT, BODS, BODS, Fiori 2.0 ABAP,T-SQL, PL/SQL, Java Script, SAP R/3, SD, MM, CRM, FI (GL, AR, AP), CO-PA

Reporting/Environment: Web Intelligence, Lumira, Tableau, Analysis Office, IDT, SAP BEx Query Designer Windows, HANA, Oracle, SQL Server, Hadoop, Vora, Big Data Solutions

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

HANA Modeler/Solution Architect

Responsibilities:

• Project-Finance Analytics: Designed & Developed framework moving/transforming/loading data (EDW to KPI Framework - 9 Stored Procedures) and 7 HANA Views for Business Reporting.
• Worked extensively on Billing/Demand Steams converting/optimizing BW Data Flows to HANA Calculation/Scripted Views and Table Functions.
• Project-Pricing Simulator: Designed & Developed complex SAP BW data flows for Pricing Simulation.
• BW-HANA Objects: Worked extensively on Composite Providers, ADSO’S, SPOs, Open ODS Views, AMDPs, CDS Views and HANA Stored Procedures /SQL Scripts.
• HANA Authorizations/Security: Worked on setting up HANA Roles & Authorizations. Developed framework dynamically converting SAP BW Authorizations to HANA Roles & Privileges.
• Performance Tuning & Optimization: Extensively worked on Designing & Optimizing HANA data models
• Native HANA/HANA SQL: Worked extensively on HANA SQL Procedures, Transporting Objects, Table Functions, Optimization, Hybrid Scenarios and Exception Handling.
• Worked on HANA XS Job scheduler to define and schedule regular/recurring/configuring jobs.

Confidential, Glendale, CA

HANA Modeler/Solution Architect

Responsibilities:

• Client: Confidential Project Vistex Transactional and Master Data: Worked on business requirements for Master Data (ECC / Vistex Customer Master, Material Master), COPA, Credits/Invoices, Claims, Pricing, Bill backs, Incentives, Direct/Indirect Sales & End Customer Reporting.
• Reporting Strategy: Pricing Analytics: Designed/Developed/Delivered HANA/BO Reporting Solution with Generated HANA Views, Composite Providers, Advanced DSO’s and Open ODS Views, Calculation Views, Web Intelligence and Analysis Office.
• Native HANA/HANA SQL: Designed/Developed/Delivered solution with Calculation Views, HANA SQL Scripts, AMDP’s, Decision Tables and Authorizations. Worked on the exception handling with HANA SQL scripts. Importantly developed framework testing data covering all scenarios.
• HANA Views Generation for BW Objects: Version BW 7.5 SP5: Developed ‘UTILITY’ to generate HANA Views in Production. That helped to avoid importing extremely critical objects info objects like 0MATERIAL, 0MAT SALES, 0CUSTOMER and 0CUST SALES from development to Production.
• Transports: Worked on delivery units collecting and importing HANA Objects-Calculation Views.
• BW Data flows/HANA SQL: Developed HANA Scripts from Complex BW Transformations/End Routines.
• SAP SLT: Worked extensively replicating all the Master Data and Transactional data for Pricing Analytics.
• Delivered Technical Specs with ER Diagrams, Build Instructions, Field Mappings, Rules, Filters, Joins, Cardinality, Process Flow and Business Test Scenarios.
• HANA Support & Tickets: Worked on Production Support (HANA) and End user training.
• S/4 HANA/SDA: Worked on fetching data from S/4 HANA/ECC to BW through SDA. Worked on migrating data issues with S/4 HANA Migration Cockpit, LSM Work Bench and SCAT.

Confidential, Louisville, KY

HANA Modeler/Sr. Consultant

Responsibilities:

• Client: Kindred Health Care: Project: “Patient Census”: Main objective of this project is Building an Optimized/Efficient/Scalable frame work leveraging real time data for Nursing Centers.Developed ABAP Programs through AMDP Classes/ HANA Stored Procedures/ HANA SQL Scripts optimizing data latency from 6 hours to 20 minutes.
• HANA Stored Procedures: Developed complex business calculations in ABAP and HANA SQL Scripts.
• HANA Studio: Provided concrete framework with Eclipse Neon, ADT and BW-Modeling Tools.
• HANA Objects: Worked on HANA Authorizations, Composite Providers, ADSO’s, Open ODS Views, Calculations Views (Graphical/Scripted), Work Spaces, APD’S, HAP (HANA Analytic Process) and LSA++.
• Business Objects: Worked extensively on Web Intelligence, Query Designer, Lumira and Analysis Office.
• SAP HANA Smart Data Integration: Worked extensively on reading remote data from SQL Server handing performance aspects of reading remote data with Real time Replication/Batch.
• HANA Transports: Developed strategy collecting HANA transports with regular CTS and Delivery Units.
• Business Alignment: Worked on fulfilling business requirements, scheduling alignment meetings and back ground jobs for business requirements.
• SAP SLT/Hybrid Scenarios: Worked on replication tables covering Hybrid Scenarios/Census Reporting.

Confidential, Cincinnati, OH

Sr. SAP BW HANA Consultant

Environment: SAP BW 7.4, Native HANA, HANA SQL, ABAP, BEx.Qry Designer, Webi, AO

Responsibilities:

• SAP BW Data flow Design and Architecture: Developed complex data flows with the objects DSOs, Info sources, ADSOs, Info cubes, SPOs, CPs and BEx Reports. Designed and developed very complex transformations calculating 29 KPIs using end routines.
• Project: Global Supply Chain: Worked extensively with business on OTC complete end-to-end cycle.
• Project: Techno-Functional: Rental: Worked with business building solutions in functional areas of SD, CRM and FI that includes reports on Route Analytics, Intercompany Transfers, Consolidating Class/ECC Billing, New Business, Power Adds, Deep Clean, Price Renewal Reports, Weekly Operational reports, WOR Agreements, Peripherals, Portrait, President Club and Spend Analytics etc.,
• KPI’s: Translated multiple Business KPIs into BW Backend calculations and HANA Analytical views.
• Strong ABAP: Developed complex business KPIs with ABAP routines (Start, End and Expert).
• Worked extensively leveraging HANA Engines with AMDP, CDS Views and SQL Scripts.
• Extensive HANA Modeling: Worked on HANA Design Studio modeling ADSOs, Composite Providers, Attribute, Analytic, Calculation Views with complex calculations, Stored Procedures and SQL Scripts. Pushed many complex BEx Query calculations to Calculation views.
• BPC/IP: Worked on Planning functions, Layouts, Aggregations, Input Enabled Queries and Formulas.
• Strong BEx Query and User Exits: Worked on SAP BEx Formulas, Structure, CKF, RKF, Customer Exit Variables (used function modules approach), Conditions and Exceptions.
• Reporting-BOBJ: Worked extensively on BO reporting tools Web Intelligence, IDT, Design Studio dash boards, Analysis for Office. Has good understanding on Lumira and Tableau.
• Business Content: Worked on Business Content, functional tracks likeSD, CRM, master data, Generic extraction, FI-AR (Accounts Receivables), FI-GL, SD Vistex data sources and data ware housing team.
• Data Validation: Designed and developed strategies validating data saving lots of business time.
• SDLC: Responsible for SAP BW/BI, SAP BO and SAP HANA Projectdevelopment lifecycle from Project preparation, Blue Print, Realization, Requirements gathering, Functional technical design documents, Development, Unit testing, Integration testing, Use Acceptance Testing Go-live and Post Go-live support.

Confidential, Marysville, OH

SAP BI Lead, Senior Analyst

Environment: SAP BW 7.3, Native HANA, BODS, BEx. Query Designer/Analyzer, ABAP, BI Accelerator, Web Intelligence, Lumira, HANA Design Studio, Tableau, BPC, IP

Responsibilities:

• SAP BI/BW Data flow Design and Architecture: Developed data flows with custom solution for Point of sales for BIG 4 customers like Wal-Mart, Lowes, Home Depot and Costco. Design accounted for errors in Master data with provisions for restatement.
• Mini 16 projects for Secondary Sales Customers: Designed and developed template for 16 secondary sales customers like Ace, Big Lots and more across North America, Europe and APAC.
• Project: Data Stabilization for Canadian Customers: Resolved all data issues for 6 Canada customers.
• Techno-functional: Worked on transforming business requirements to technical specs.
• New Acquisitions: Designed and consolidated historical data with new acquisitions for business.
• HANA Design Studio: Worked on HANA design studio with calculation, attribute and analytical views.
• Strong ABAP: Extensively developed/optimized complex ABAP routines fulfilling business requirements.
• Strong BW/BO Reporting: Worked extensively in Web Intelligence reports and Dash Boards.
• HANA Migration: Worked extensively on HANA migration strategy, pre and post activities of migration.
• HANA Re-Design: Re-designed existing BW data model replacing cubes with HANA Advanced DSOs.
• Long Term Foundation for Organization: Mentored team effectively handling BW Production Support. Developed 20 short videos with audio (8 to 11 minutes) through screen recording guiding step by step to ensure 100% data accuracy with junior BW resources.
• BPC/IP: Worked on Planning functions, Layouts, Aggregations, Sequences, Cost Center Planning with Input Enabled Queries, Fox Formulas and Optimized Formulas.
• Service Level Agreements: Worked with leadership team ensuring data available for cross leads meeting.
• Data Quality Checking Tools: Developed a tool checking quality of Production system by checking objects across development, quality and production systems to increase organizational productivity.
• Production Support and Deloitte Audit: Part of regular production support and change request process worked with audit department. Reconciled data flows of sales orders, deliveries, billing, purchasing and inventory. Automated complex BW data loads saving lots of manual effort.
• Process Chains: Developed and optimized 50+ process chains scheduling BW jobs with required alerts.
• Transports Impact: Designed a utility to identify/monitor impact of transports on production system.
• Upgrade: Worked with Basis upgrading HANA with Rev 82 patch and created all test scenarios.
• Year-end Activities: Handled BW Quality refreshes, month end and year end activities.
• Worked with functional team developing planning functions, layouts, aggregation levels and sequences.
• Tableau: Worked with Tableau developers providing required inputs from BW backend for Advance analysis Actions, Calculations, Parameters, Background images, Maps and Scoreboards.

Confidential, Miami, FL

SAP BI/BW Lead Consultant

Environment: BI 7.0, BEx Query Designer, ABAP, BEx Analyzer, Solution Manager, APO, IP

Responsibilities:

• Designed data flows for Europe and involved in the process of OTC, FTS, PTP and RTR. Handled issues due to modification of source system connections with deep product knowledge. Prepared functional, technical and Unit test specifications. Designed & developed data flows from R/3 => BW => APO => BW.
• Designed and developed four generic extractors for data requirements. Developed and modified the BEx. Queries to meet the business requirements. Designed and developed History data loads (BW => APO) for Orders/Returns/ Market Intelligence. Developed open hubs to avail data from SAP BI to Microsoft BI.

Confidential, WI

SAP BI/BW Consultant/ Business Analyst

Environment: BI 7.0, BW 3.5, BEx Query Designer, BEx Analyzer, ABAP, WAD, Portals, IP

Responsibilities:

• Project: US Chemicals: Enhanced the transactional data flows (Invoices, AR and Inventories) from ETL to SAP-BW-Regional (US Country and NA Regional Cube) and Global. Handled all project issues associated with data flow routines, master data, Authorizations, process chains, DTP’s and Info packages. Translated all the business calculations to coding and coordinated with the ETL team. Debugged the complex ABAP routines to ensure business functionality.
• Designed four data quality monitors to enable the business users to perform checks at a faster and more efficient way. It provides more visibility and reduces the errors in the current SAP-BW reporting data by alerting business and support. Proposed landing slot monitors to business which captures and alerts all the modifications of both process chains and data flows to the support team.
• Intergrated Planning: Scheduled data loads ensuring the functionality of planning layouts.

Confidential, Greensboro, North Carolina

SAP BI/BW Consultant

Environment: BI 7.0, DW Workbench, Query Designer, ABAP, ESP Scheduler, SD, AFS

Responsibilities:

• Worked on SD and AFS module. Handled the activities of both ‘Production Support’ and ‘Project Development’ together during the tenure of this project including onsite/offshore coordination.
• BI Production Support: Resolved and handled all the issues like missing data packets in the stream of total packets, delta load failures, selective deletions, repair full loads and performance tuning.
• Project: ‘BW Count Cross Check’: Designed a utility program to find the missing documents from SAPR/3 to SAP-BI in the functional areas of sales, delivery and billing. And this interface generates an email with the record counts of both SAP-R/3 and BI.
• Enhancement: ‘Title transfer date’: Handled all activities starting from analyzing the requirements to delivery. Coded complex ABAP extractions involving the tables of billing and document flow.
• Project: ‘Preview Date’: Handled the manipulation of preview data DSO’s new data table to match the business’s inventory data.

Confidential

Responsibilities:

• Developed generic programs with all possible options for inbounds and Out bounds which reduce 80% of development time, Testing time. Developed outbound interfaces for Purchase order, Job master, Model accumulate quantity for the requirement of HIMEX and CHASIS plants. Developed inbound interfaces for the Purchasing view of vendors and vendors creation. Fixed many issues on various Reports, SAP Scripts, Transactions, BDC, and ALV by extensive debugging in all possible ways to analyze and fix issues.
• Developed report to verify the data values across all plants, Distribution Channels and Sales Organizations are kept in synchronization for a material. It displays all the error records with details. Converted the functional documents to the technical specifications by debugging the standard transactions as part of the onsite-offshore co-ordination. Involved in activities of FS to TS, TSR, CWT, UTD, ITP, FTP and PODC.Developed RFC function modules to support sales details for the web application server.
• Handled code walk through for more than 100+ objects working in Intelligroup (Currently NTT DATA).