SUMMARY

• SAP BW/HANA Consultant (SAP Certified - BI & HANA) with 11 years of Information Technology experience with expertise in interpretation of business requirements, design of optimum solutions, Implementation, Upgrade and Production Support for various business processes in SAP BW & HANA.
• Designed solutions and implemented end-to-end data flows for various modules in SAP BI/BW (NetWeaver), SAP BW on HANA and Native HANA as per business requirements.
• Experience in client facing roles involving requirements gathering, understanding, analyzing and designing and implementing optimum solutions.
• Experience in leading teams through successful implementations, migrations, sustain, maintenance and support engagements.
• Experience in setting up data extraction from SAP and non-SAP source systems.
• Experience in implementing Warehouse and Reporting Solutions (Analytical, Operational & Strategic) for various ECC functional areas like SD, MM, FI(GL, AR & AP), CO, PP, HR(PY, PT, PA & OM etc.), POS, O2C, OTIF, P2P, FDP etc.
• Extensive experience in version migrations from SAP BI/BW 3.x to 7.x(7.0, 7.3, 7.5).
• Good experience in ABAP to deal with BW-ABAP requirements.
• Good knowledge of SQL Script and experience in creating Stored Procedures, Scripted Calculation Views, Function Calls etc.
• Hands on experience in data provisioning with DXC, SLT, SDAQ and BODS.
• Expertise designing Warehouse with BW on HANA objects such as Composite Providers, Hana Views, Transient providers, SPOs, ADSOs, CDS Views, Open ODS Views etc.
• Highly self-motivated, very eager to learn and work on new technologies, keen on handling challenging assignments and capable of working on multiple engagements simultaneously.

TECHNICAL SKILLS

Domain Application Knowledge: SAP BW-3.5/7.3(NetWeaver), SAP BI-7.0/7.4, SAP BO-4.X, HANA 1.X(SPS 13), SQL, ABAP (BI perspective), SAP ECC(4.5 & 6) and Bank Analyzer.

Tools: Used Teddis, BIWAC, RMS, Teamforge, Clarity, ResolveIT, OPTIS, SAMT and Service Now, Service Center.

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/BO/HANA Architect

Responsibilities:

• Designed and implemented data flows for PoS (DSiM) modules.
• Designed and implemented data flow for FDP consuming BW and HANA objects.
• Designed and implemented Custom Calendars and Custom Hierarchies solutions to meet Retailer Team’s reporting requirements.
• Created an ABAP Utility programs to create Custom Calendars and load Custom Hierarchies.
• Created Attribute, Analytical and Calculation Views to meet new reporting requirements in HANA Studio using different joins(inner join, outer join, referential join etc) and union to connect tables to meet Cross Retailer Reporting requirements.
• Leveraged the methods like SLT & BODS, for data provisioning from SAP and non-Sap sources (TradeEdge & Shiloh) into DSR.
• Created Design Studio Dashboard applications for ExoV Reporting.
• Extensively used BW Modeling tool, Hana Modeler and Hana Development perspectives to create objects like ADOs, Composite Providers, Transient Provider, SPOs, Open ODS Views, CDS Views, Calculation Views(scripted & graphical), Stored Procedures, Hana Tables, to consume persistent and virtual BW datasets into HANA and vice versa.
• Worked on Export/Import(LCM) of HANA Models across HANA landscape.
• Created Functional & Technical Specs, Usage Documents & conducted User Trainings.

Confidential

SAP BW/BO/HANA Consultant

Responsibilities:

• Managed Sap Practice at Achala for client Confidential .
• Extensively involved in creating optimized HANA Models as per user requirements.
• Created Attribute, Analytical and Calculation Views to meet new reporting requirements in HANA Studio using different joins(inner join, outer join, referential join etc) and union to connect tables.
• Created SQL Stored Procedures to implement solutions for complex business scenarios.
• Involved in carrying out pre-migration and post-migration activities for SAP BW on HANA.
• Extensively worked on post migration Hana Optimization on HANA Studio.
• Extensively used new objects like Composite Provider, Transient Provider, SPOs & ADSO etc. to build HANA optimized models replacing the existing models.
• Fine-tuned the transformations via SQL script Expert Routine.
• Worked on Data Provisioning with BODS and SLT.
• Created new data flows as per LSA++ architecture.
• Created Business Layers in IDT as per reporting requirements.
• Worked on building dashboards in Design Studio.
• Created and maintained WeBI and Crystal Reports for new reporting requirements.
• Created and scheduled the WeBI reports on daily basis to share the outputs to Users via mail.
• Led sustain and support teams that support BI solution for ECC modules like Purchasing & Inventory.

Confidential

SAP BI Senior Consultant

Responsibilities:

• Led a team of 4 Consultants for this AMS Engagement from Offshore.
• Worked on Support and Maintenance of BI-BO solutions for modules like ALM, FI, Payroll, HR & SD during this engagement.
• Responsible for resolution of tickets (IM & PM) of various priorities raised in “Service Now” by Users.
• For CRs, involved in requirements gathering with client. Later, designed solutions, prepared TS and FS and got them implemented.
• Built multisource Universes in IDT to meet the business reporting requirements.
• Created & maintained BO Reports of flavors like Crystal & WebI to report data from SAP BW and legacy sources.
• Prepared Weekly and Monthly SLA reports.
• Conducted daily D-Stum meetings within team to discuss about work progress and issues related to work and identify remedies.
• Proactively proposed lots of CRs both Process and Performance Improvement related and got them implemented with high customer satisfaction.
• Was awarded with “Team Star Award” twice in Support Engagement by the client for my swift responses towards analyzing and fixing issues and quality of deliverables.

Confidential

SAP BI/BO Senior Consultant

Responsibilities:

• Led a team of 3 from Onshore for a successful BW Upgrade from version 3.5 to 7.0.
• Post upgrade, involved in the implementation of BO reporting solutions with Crystal reports 2008 and WeBI.
• Participated in workshops with users to understand their business processes, current usage of BI and their expectations out of Upgrade.
• Later, involved in preparation of Upgrade Blueprint doc. Created detailed BI Upgrade Plan in MPP.
• As Team Leader, delegation of work, seeking status, tracking work progress, timely review of Plan, submitting Weekly Status Reports, risk identification, impact assessment of risk, timely escalation to management, working towards risk mitigation, working on day-to-day upgrade activities were primary tasks.
• During the upgrade of Dev, Quality and Pre-prod systems, carried out pre and post-upgrade activities documenting accurate timelines and issues with solutions.
• During UAT, was responsible for fixing the defects raised by Users and uploading, updating the solution document in Solution Manager.
• Carried out final upgrade successfully with very less defects thus releasing the system to users two hours before the agreed timeline.

Confidential

SAP BI Consultant

Responsibilities:

• Implemented BI Solutions & Bex Reports for HR, Payroll, FI and Procurement Modules.
• Created Generic Data sources of FM/View/Infoset Query to facilitate custom extractions as per Business needs.
• Was nominated as SPOC for all transports within the Team.
• Installed and customized new Technical Content Data flows and reports to suit user requirements.
• As part of Support worked on Incidents, Service requests, and designed and implemented solutions for CRs.
• Was awarded the “Project Star” during this engagement.

Confidential

SAP BI Consultant - Consultant

Responsibilities:

• Involved in discussions with clients and onsite coordinator to understand the business process. Client’s legacy system was AS400. Data was supplied to BW in the form of flat files (.CSV).
• Prepared the blueprint for OTC and FI flows.
• Involved in design and realization of the warehouse data flows for OTC (Orders, Dispatches & Invoices), Finance and Promotions Modules.
• Extensively used Start, Expert and End Routines to implement business logic in BI and transformed data as per business requirements by merging Header and Line Item files using Intermediate DSO and parallel cursor logic etc.
• Created trending Bex Reports for Sales & Forecast modules.
• Created Crystal Reports to report FI after creating semantic layer in UDT.
• Carried out rigorous testing at different stages like System Testing, Integration Testing, and Regression Testing as the data flows were complex.

Confidential

SAP BI Consultant - Consultant

Responsibilities:

• Involved in implementation of MM (Purchasing & Inventory) & FI-GL Modules.
• Prepared Technical documents based on Functional documents and HLD’s.
• Created BW data flows to hold Inventory, Purchasing and FI - GL data.
• Extracted the Inventory data and loaded it into Non-Cumulative cube for Stock Reporting.
• Created YTD and Jump Reports for MM and FI.

Confidential

SAP BW Consultant

Responsibilities:

• Worked on scheduling, monitoring and error-handling of Process Chains.
• Responsible for sending out periodic status reports to Business.
• Worked on tickets (Incidents and Service Requests) of different priorities created by Users following SOPs, confining to SLA.
• Extensively worked on analyzing and fixing failed loads, jobs and other processes within the PCs.
• Worked on performance improvement of queries and data loads.

Confidential

SAP BW Associate Consultant

Responsibilities:

• Involved in implementation of warehouse for SD and FI modules.
• Extensively used SAP BW Administrative Work Bench for installing BI content, creating custom BW objects and building data flows for different Modules.
• Used ODS to stage the data before transferring to Info Cube to use it’s overwrite functionality.
• Used LO Cockpit to extract logistics data by maintaining extract structure running statistical setup, scheduling V3 jobs to collect deltas.
• Created Bex Reports using Calculated and Restricted key figures, Variables, Exceptions, Conditions, RRI and Filters etc.
• Involved in carrying out testing and preparation of Test Scripts.
• Created various Project related documents like FS, TS & Test Scripts etc.
• Worked on Post Go-live support.