SUMMARY:

• A well - rounded technology and management SAP professional, who obtained skills through hands-on projects experience and through a degree in Master of Science in Technology Management (MSTM), an 18-month Executive IT Management program.
• Strong project delivery skills with 20+ years of experience (14 years in US) with expertise in delivering both SAP Data warehouse/Analytics applications (BI/BW, BO, HANA) and Enterprise Resource Planning (ERP); Six full life-cycle implementations experience in developing Data warehouse and ERP applications in SAP FI/CO, SD, MM, PS, QM, PP, and HR modules.
• Total IT industry experience includes: Service Delivery/Project Management experience for delivering large & complex projects in both Application Maintenance (AM) and Application Development (AD); hands-on experience as SAP HANA/BI Architect/Business Objects Developer; also hands-on experience as SAP ABAP ERP Analyst - SAP R/3 (ECC 6.0, 5.0, 4.7, 4.6C, 4.6B, 4.0B, 3.1X, and 3.0 X).
• Project Management experience as Delivery Lead, both in Offshore/onshore business model and Managed Services model. Delivery management of large clients such as Shell Oil & Gas, US Army, Kimball, etc.
• Senior SAP HANA/BI/BW/ABAP consultant with extensive experience in BI/BW Integration, Reporting, Security, Testing, Operations, and Support; creation of Functional designs to support global customer reporting.
• Led requirements gathering workshops, conducted gap analysis, converted business requirements into Functional specifications and technical design, coded, unit tested, integration tested, documented and provided production support; involved in performance management, data management, and data consistency.
• Excellent experience in BW HANA modelling, Data source enhancement, PSA, DSO, CUBE, Multi provider, Info set, Transformation, DTP, APD, Open hub, Update rules, Transfer rules, Aggregate, Roll-up, Enterprise Portal, BEx, RRI, Broadcaster, BI content objects and Openhub.
• Expertise in report generation in BW worked extensively on BEx Analyzer, Query designer, Variables, condition and exceptions.
• Experience in extracting data from MM, SD, QM, PP, PM, AM, PPM, PPDS, and EHS.
• Extensively worked on Roles & Authorization and Transportation of objects.
• Good experience in performance tuning and structural fixes for repeated issue using Problem Management.
• Generation of Service Delivery reports and report out to the client stakeholders & internal stakeholders.
• Automation of repetitive tasks to reduce non-value added time and improve productivity and profitability.
• Flexibility to adjust to multiple demands, shifting priorities, ambiguity and rapid change.
• Qualified Six Sigma specialist with experience in improving processes using Six Sigma (6σ) Methodology.
• Involved in Product Testing, user acceptance testing, transports support and cut-over support during Go-Live.
• Experience working with Big 4 consulting firms in the US.
• Excellent communication skills both verbal and written.

TECHNICAL SKILLS:

ERP: SAP R/3 ECC 6.0, 5.0, 4.7, 3.1X, SDLC

Data warehouse: SAP HANA, HANA Studio, BW on HANA, BI/BW 7.0, 3.1, 3.0B, BOBJ XI R3, BWA, Decision tables

SAP Modules: FI/CO, SD, MM, PP, QM, HR

Reporting tools: Lumira, AOLAP, WebI, Design Studio, BEx Analyzer, Portal, WAD, ALV

Tools: SLT, BODS, Service Now, Remedy, Control-M

Languages: ABAP/4, SQL, PL/SQL, SQLScript

MS Office: Excel, PowerPoint, MS Project, Visio

PROFESSIONAL EXPERIENCE:

Confidential

Senior Manager

• Gathered reporting requirements from the business users, provided estimates for the delivery, proposed design based on the requirements, developed prototypes, validated the development and tested before working on the production version.
• Worked on Functional and Technical documents, Unit testing, System Integration Testing (SIT) and User Acceptance testing (UAT) for developed objects.
• Proposed design and worked on the development of HANA objects such as Information views modeling using HANA Studio / Eclipse environment, data provisioning (SLT, BODS, DXC, Flat files), User Interface (Design Studio, Lumira, Webi, Analysis for OLAP, Crystal reports, etc.), User Management & Security (Analytical privileges, users, roles, etc.).
• Extensively involved on data modeling: Attribute, Analytical, & Calculation views using Graphical/SQL Script in HANA Studio. Developed models on top of HANA tables; written stored procedures, designed tables.
• Developed hierarchies and currency conversions as per the business need.
• HANA Security: developed Analytical privileges to define row-level security on HANA views at User level.
• Transport of HANA objects from development to Testing and Production environment using Delivery units.
• Developed BW architecture objects such as Infoobjects, InfoArea, InfoSource, InfoCube, InfoPackage, DSOs, ODP, DTP, OpenHub, and process chains for data loads.
• Enhanced data sources as per the requirement; worked on field level routines, start routine and end routines.
• Involved in performance tuning for optimizing data models, load performance and query performance.
• For ETL, worked with sources such as Microsoft SQL Server 2008, CSV flat files using BODS for data provisioning. Scheduled jobs for hourly and daily loads of the jobs into HANA tables/database.
• Developed Time dimensions, decision tables.
• ABAP on HANA - stored procedures development using SQL script and CE functions.
• Performance improvement of Open SQL Script code using ABAP Test Cockpit (ATC) and ABAP code using Code inspector.
• Reports development by integrating HANA with various reporting tools such as Analysis for Office, Design Studio, Lumira, Explorer, Excel and WebI.
• Performance tuning of the data models. Data loads/Process chains using batch scheduling tool Control-M.
• Performed technical design QA role for the delivered objects.

Confidential, Alexandria, VA

Sr. SAP BW/BO Architect Developer

• Led user requirements gathering workshops, business blueprint design, analysis and design of the data model using Star Schema methodologies.
• Worked closely with business users, sponsors, and other stakeholders to identify and maximize opportunities for BW; oversaw and coordinated BW design, development and testing for Funds Management (FM) and Cost Management (CO) functional areas reporting needs.
• Preparation of data flows, functional feasibility analysis, and prototype solutions for proof of concept.
• Developed cutover plans and activities and coordinate resources for go-live; provided support for knowledge transfer and transition of the BW system from development to production support.
• Data mapping between the Legacy and ECC data fields and BW InfoObjects for the data modeling and extraction.
• Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, InfoCubes, and Multi-Cubes; coding in start routines and end routines.
• Master and Transaction Data extraction from Flat files and loading into InfoObjects, DSOs and InfoCubes.
• Activated Business Content InfoObjects, InfoSources, DataSources, Operational Data Store/DSOs, InfoCubes, and Multi-providers.
• Installed BI Administrator Cockpit by activating business content InfoProviders and queries.
• Provided production support for Process chains, loads from ECC to BI, reconciling issues between ECC and BI, and other issues with the loads; performance improvement by building aggregates and roll ups; DB statistics.
• Developed reports using BEx Query Designer and published them on Web; built OLAP Universes based on BEx Super Queries, and built WebI Reports using OLAP SAP BW queries as DataSource.
• Developed following BOBJ WebI reports: Status of Fund Report, Open Obligations Report and P2P Report, and published them on the Portal for end user access.
• Designed Test Cases and Test Plans using Mercury Quality Center for the Unit Testing and Integration testing of the programs coordinating with Business folks.
• Performance improvement of queries using aggregates, indices on DSOs, DB Statistics, and Production support for the data loads; developed process chains for automating the data loads.
• Written programs to reconcile data between BW and R/3 using RFC and ABAP programs.
• Other general Project related activities such as Process compliance, time tracking, status reports, etc.

Confidential, Reston, VA

SAP BW Developer

• Led user requirements gathering workshops, business blueprint design, analysis and design of the data model.
• Preparation of data flows, functional feasibility analysis, and prototype solutions for proof of concept.
• Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, InfoCubes, and Multi-Cubes; coding in start routines and end routines.
• Lead developer for the Requisition-to-check (RtoC) team reporting needs.
• Provided production support for Process chains, loads from ECC to BI, reconciling issues between ECC and BI, and other issues with the loads; performance improvement by building aggregates and roll ups; DB statistics.
• Developed reports using BEx Query Designer and published them on Web; built OLAP Universes based on BEx Super Queries, and built WebI Reports using OLAP SAP BW queries as DataSource.
• Provide Technical Quality Analyst (TQA) role for the technical objects that are ready to be migrated to production to ensure they are Integrated Product Development System (IPDS) process compliant and Sarbanes-Oxley compliant.
• Involved in development of critical design documents, scheduling design reviews, technical documentation, coding, unit testing, Integration testing and support of migration of objects to production environment.