PROFESSIONAL SUMMARY

• 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.
• Worked extensively building Start/End/Expert Routines/AMDPs with complex business calculations, Function module extractions.
• Worked extensively on Optimizing HANA SQL Scripts, SQL Traces, Runtime Analysis, Debugging, Explain/Plan/SQL Monitor and Code Inspector/ATC.
• Worked on HANA User Accounts, Database/Repository Roles, Privileges (Object, Package, Analytic and Application), Tracing and Trouble Shooting.
• 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.
• 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.
• 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 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.
• 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,
• 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/ Confidential /HANA: SAP Confidential 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:

• 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 Confidential Data Flows to HANA Calculation/Scripted Views and Table Functions.
• Designed & Developed complex SAP Confidential data flows for Pricing Simulation.
• Worked extensively on Composite Providers, ADSO’S, SPOs, Open ODS Views, AMDPs, CDS Views and HANA Stored Procedures /SQL Scripts.
• Worked on setting up HANA Roles & Authorizations. Developed framework dynamically converting SAP Confidential Authorizations to HANA Roles & Privileges.
• Extensively worked on Designing & Optimizing HANA data models
• 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:

• 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.
• 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 Confidential Objects: Version Confidential 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.
• Confidential Data flows/HANA SQL: Developed HANA Scripts from Complex Confidential 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 Confidential 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:

• Main objective of this project is Building an Optimized/Efficient/Scalable frame work leveraging real time data for Nursing Centers. D eveloped ABAP Programs through AMDP Classes/ HANA Stored Procedures/ HANA SQL Scripts optimizing data latency from 6 hours to 20 minutes.
• Developed complex business calculations in ABAP and HANA SQL Scripts.
• Provided concrete framework with Eclipse Neon, ADT and Confidential -Modeling Tools.
• 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++.
• Worked extensively on Web Intelligence, Query Designer, Lumira and Analysis Office.
• Worked extensively on reading remote data from SQL Server handing performance aspects of reading remote data with Real time Replication/Batch.
• Developed strategy collecting HANA transports with regular CTS and Delivery Units.
• Worked on fulfilling business requirements, scheduling alignment meetings and back ground jobs for business requirements.
• Worked on replication tables covering Hybrid Scenarios/Census Reporting.

Confidential

Sr. SAP HANA Consultant

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

Responsibilities:

• SAP Confidential 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: Translat ed multiple Business KPIs into Confidential 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 like SD, 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 Confidential /BI, SAP BO and SAP HANA Project development 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 Confidential 7.3, Native HANA, BODS, BEx. Query Designer/Analyzer, ABAP, BI Accelerator, Web Intelligence, Lumira, HANA Design Studio, Tableau, BPC, IP

Responsibilities:

• SAP BI/ Confidential 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 Confidential /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 Confidential data model replacing cubes with HANA Advanced DSOs.
• Long Term Foundation for Organization: Mentored team effectively handling Confidential 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 Confidential 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 Confidential data loads saving lots of manual effort.
• Process Chains: Developed and optimized 50+ process chains scheduling Confidential 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 Confidential 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 Confidential backend for Advance analysis Actions, Calculations, Parameters, Background images, Maps and Scoreboards.

Confidential, Miami, FL

SAP BI/ Lead Consultant

D 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 => Confidential => APO => Confidential .
• 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 ( Confidential => APO) for Orders/Returns/ Market Intelligence. Developed open hubs to avail data from SAP BI to Microsoft BI.

Confidential Sturtevant, WI

SAP BI/ Consultant/ Business Analyst

Environment: BI 7.0, Confidential 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- Confidential -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- Confidential 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

SAP BI/ 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: ‘ Confidential 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.

Confidential

SAP BI/ Consultant, Business Analyst / Onsite coordinator

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

Responsibilities:

• Project: ‘SAP BI New Data Elements’. Analyzed the business requirements/impact analysis of associated master data info objects, across all BI systems. Implemented all the activities without affecting the existing developments associated with Info cubes of 26 countries includes APAC, LATAM, NAM, DSO’s, Navigational attributes, Transformations, DTP’s, Corrections, Missing objects, UAT, Production transports, Process chains and Data loads.
• Project: ‘BI AR Aging Reports’. Analyzed and developed reports for the bad debtor buckets (31-60, 61-90, 91-130, 131-365) and top ‘N’ customers for the outstanding receivables to sustain in recession. Handled all BI back-end activities including data modeling, SAP R/3 extractions and start routines.
• Fixed the root cause of few issues in BI-Production, Performance Tuning and Landing Slots.

Confidential

SAP BI/ Consultant

Environment: BI 7.0, Confidential 3.5, BEx Query Designer, BEx Analyzer, Informatica

Responsibilities:

• Analyzed the ETL- Informatica Chargeback/Adjudications application to migrate the data with the combination of SAP-XI (3.0) and SAP-BI (7.0). Identified the Deltas, Master data equivalent BI Tables, Business Logic, Transformations, Tables with fields of Input/Output/Lookups, Staging Structures, Router and Mapping Designer. Developed a utility to track changes in Initialization’s, Delta’s, Process Chains and Data flows.Handled issues like reconciliation of data between R/3 and BI, LO-Cockpit setup table issues, adjusting data base tables and BI Steps before and after apply R/3 patches etc.

Confidential, San Diego, CA

Role

SAP BI/ Consultant

Environment: BI 7.0, Confidential 3.5, DWWorkbench , ABAP, Query Designer , Analyzer, EWM

Responsibilities:

• Developed Functional and Tech. Specs (Mappings) to extract data for Inventory Adjustments, Deliveries, Shipments and Billing from the systems of Confidential, R/3 and EWM for the Confidential G1, G2 and G3 requirements.
• Handled periodic moving of BEx Query results from spool to other systems for backup.

Confidential, Phoenix, AZ

SAP BI/ Confidential Consultant

Environment: BI 7.0&BW3.5, DW Workbench, Query Designer, BEx. Analyzer, ABAP

Responsibilities:

• Analyzed the Client/End user reporting requirements and identified the Standard Business Content. This project Fill Rate can be defined from the Supply chain management stand point as Order fulfillment rate / order life cycle span till invoiced. KPI’s involved are Customer request date vs. Actual available date, Customer request date vs. Delivery date, Customer request date vs. Billing date etc., attaining global picture of the supply chain at Orders - Delivery - Billing level- Forecast-Picking. Converted the SAP std. BEx. User exit methodology to dynamic function module capability. Appended and populated fields to standard logistics structures/Extractors/Data.

Confidential, San Diego

Skill set: ABAP Reports, SQL, SAPScripts, Samartforms, Inbound and Outbound Interfaces, BDC, SAP Administration, Applied knowledge of ABAP on SD, MM and FI

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).