SUMMARY

• Over 12+ years of relevant experience on Information Technologies, 10+ of them dedicated to SAP technologies as part of Support, development and implementing projects for BW (3.X, 7.X and lately SAP BW on HANA 7.5), Azure Data lake, Synapse, Power BI, ABAP modules performing all the relevant technical activities and documentation for the projects.
• Proven ability to Lead and engage business counterparts to understand and capture business requirements, communicate project purpose and progress, design and present plans of execution, and present deliverables that include project scope documentation, testing and user verification, technical and functional documentation, user, and knowledge transfer.
• Skilled in ASAP and SCRUM methodology, able to work in multiple commercial and industrial disciplines including Food and beverage, Pharmaceutical, Retail, manufacturing and Automotive.
• Highly experienced in creating complex queries in BEx Query Designer using Conditions, Exceptions, Filters, Calculated Key Figures, Restricted Key Figures, Variables, Structures, time hierarchies and RRI, and creating WAD reports, developed workbooks for ease of broadcasting.
• Experienced in Support tools used for tracking issues and SLA’s like Remedy, Change Management tools like CHARM.
• Working mainly with ASAP and AGILE Methodology
• SAP BW Models Implementation, experience in gather requirements from key users to under - stand and create an appropriate solution for customer needs, development of the Model, testing, transporting, documentation, and the management of all the process involved in all the development lifecycle.
• Trained on SAP BW on HANA and standalone SAP HANA data models using Advanced DSO, Open ODS View, and Composite Info Providers (mixed modeling HANA and BW data) using HANA Views.
• Experience in creating Reporting models for OTC, SCM, etc.
• SQL experience, queries, DB administration features.
• Experienced on Extracting SAP and non-SAP data into SAP BW via views, function modules, flat file interfaces and generic data sources from SAP.
• Expert on ABAP programing language for SAP BW, able to handle complex scenarios for data transformation routines (start, field or end) and debugging.
• Expert on generate all the relevant SAP BW Objects like; PSA's, DSO's, Info Cubes, Multi providers, Composite-Providers, Info objects with all the transformations, DTP's, IP’s, Open Hubs.
• Production Support: Extensive experience in support, Data loads, Validation and troubleshooting of transaction data and Master data, Debugging, Change management, Transport Management, Roles & Security, System Checks, Performance tuning and process chains.
• Experienced in Power BI reporting.

TECHNICAL SKILLS

Primary Profile: SAP BI/BW/HANA

Secondary Profile: ABAP developer, Software Developer and test Engineer, Azure Datalake, Synapsis, Power BI

Hardware: Windows XP and older versions, Solaris 10, Digital Circuit Programmer, Electronics, Network adapters, Full knowledge of hardware in a common computer.

Operating Systems: Windows XP and older versions, Solaris 10, Linux

Programming Languages: ABAP, Java, Jscript, HTML, PL/SQL, ABAP, Flash Mx

Databases: MS Access, MySQL, SQL server 2005, ORACLE

App. Servers: SAP BW 3.7 and 7, SAP ECC

PROFESSIONAL EXPERIENCE:

Confidential, Richmond

BI Lead

Responsibilities:

• Managed both project and support teams working onsite & offshore, complete, prepared project plans, resource schedules and planned cut - over activities during go - live phase.
• Responsible for collecting the requirements, performing of gap analysis, creating, functional & technical and LSA architectural procedures. Covering the Full spectrum of activities in the development cycle on SAP BW with AGILE Methodology, from requirement collection to support. Combining the entirety of technical and functional tasks, from record to report
• Provide technical assessment to the ongoing requirements for multiple projects
• Converting the business gap/solutions into business opportunities
• Worked data replication from R/3 system to HANA system using SLT replication.
• Worked SLT system configuration and setup.
• Worked on loading data/replicating data from R/3 system to HANA and created calculation views on top of these tables
• Replicated all tables related Financial P&L like BKPF, BSEG etc.
• Worked on basic and advanced replication settings based on field edit/delete and routines for event-based calculations.
• Created BW HANA objects like aDSO’ s, composite Providers for reporting
• Created native HANA calculation view by consuming BW objects.
• Implemented complex business logic using HANA table function
• Created data model to support historic master data with time dependency.
• Worked on HANA sequence key generation
• Created process chains for daily and weekly data loads
• Performance optimization of HANA views using Plan viz output.
• Integration of BW and HANA models for reporting
• Performed the BW activities for data extraction
• Report creation using BW4HANA query designer
• Working on new enhancements and ongoing support activities
• Worked with various standard as well as custom BI/BW (7.4) objects and SAP data sources
• Main projects Sales, Distribution, HR and FInance KPI’s
• SAP BW on HANA modeling
• Designed and developed various Multiple Reports and Info providers like DSO, Info cubes, Info objects, Composite providers. Developed various transformations to perform multiple user requested processes and enhance the master and transaction data using start and transfer routines with ABAP to suit the business requirements.
• Creation of Process chain to populate various data targets like Info objects, Info providers, with Master data and Transactional data from ECC and legacy systems using flat file interface via Data Staging area (PSA).
• Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production. Reconciliation of BI reports with the ECC & legacy data as wells as the reports.
• End user Facing and

Confidential

SAP BI / BW Architect

Responsibilities:

• Responsible for collecting the requirements, performing of gap analysis, creating, functional & technical and LSA architectural procedures. Covering the Full spectrum of activities in the development cycle on SAP BW 7.5, with AGILE Methodology, from requirement collection to support. Combining the entirety of technical and functional tasks, from record to report.
• Worked with various standard as well as custom BI/BW (7.5) objects and data sources coming from SAP modules like HR, SD, FI, PM, PP, MM, PUR and Data Services also non-sap systems like SQL DB, TPM and FlatFiles.
• Main projects PM reporting suite, Budget control for FI with IP, HR dashboards PP Scrap analysis, SCM (supply chain) and OTC.
• Designed and developed various Multiple Reports and Info providers like DSO, Info cubes, Info objects, Composite providers. Developed various transformations to perform multiple user requested processes and enhance the master and transaction data using start and transfer routines with ABAP to suit the business requirements.
• Creation of Process chain to populate various data targets like Info objects, Info providers, with Master data and Transactional data from ECC and legacy systems using flat file interface via Data Staging area (PSA).
• Optimization of current generic Extractors, Start routines and End routines through Debugging
• Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production. Reconciliation of BI reports with the ECC & legacy data as wells as the reports
• Creation of BOBJ reports with Web Intelligence.
• Performed several reloading processes without disrupting the delta queues via ad hoc data analysis
• End user on report navigation, end user on call support and ad hoc data reloading.

Tools: SAP BI 7.5, ABAP, SD, PP, MM, FI, PM. IP, TPM

Confidential

SAP BI / BW HANA Architect

Responsibilities:

• Working as a Business Analyst / Tech Lead
• Responsible for understanding architecture of SAP BW HANA - HADOOP Integration for Data Archiving.
• Understanding the technical challenges and providing solutions.
• Working closely with team members in providing techno functional solution.
• Having experience on Data Archiving process from BW powered by HANA to HADOOP.
• Having experience on Data Retraction process from HADOOP to BW via SDA.
• Having experience on Reporting on live (BW) and archived data (HADOOP).
• Worked on different replication methods.

Confidential

Sr. SAP BI/BW Consultant

Responsibilities:

• Offshore Team Lead for production Support and Enhancements for BI and ABAP.
• Responsible for Incident management and delegation of support activities to offshore team.
• Responsible for analyzing Scope, Requirement and Impact analysis for all major enhancements.
• Accountable for meeting Internal and external quality standards and process.
• Responsible for various performance optimizations in production system such as data load optimization, report performance, Space maintenance.
• Mentoring the team members as well as resolving issues and performing enhancements according to requirements.

Confidential

SAP BI/BW Consultant

Responsibilities:

• Actively participated as a SDM Delegate to regulate transport management system across the landscape.
• Actively and regularly involved in monitoring of Daily, Weekly, and Monthly data Loads using Process Chains.
• Implemented SAP Notes to correct few issues in BW system after performing system copy.
• Maintained Info Packages and scheduled them in order to load Master Data and Transactional Data from various Source Systems and Handling Errors.
• Reconstruct the data requests from PSA in case of data load failure.
• Actively involved in rectification of load errors like Master Data Loads and transaction loads.
• Report to management and customer on weekly and monthly trends in loading and performance tuning.
• Measuring query performance and aggregate effectiveness on monthly basis and suggesting customer for better performance.
• Roll up data from info cubes to aggregates, edit and maintain the aggregates.
• PSA deletions and Compression of cubes weekly basis by maintaining multiple retention periods.
• Handling performance related tickets raised by end users by giving expert support.
• Creating and maintaining secondary indexes on data targets to improve load performance.
• Partitioning of the existing huge cubes and tuning them if required.
• Worked with RSRT to change query read mode to improve query performance.