Summary:

• 7 years of experience in software development, design and implementation in SAP BI / BW.
• 5 full life cycle implementation experience in BI 7.0
• Planned , managed and executed cutover activities for all implementations
• Performed the roles of Onsite / Offshore stream leads for various projects, have good experience in Production Support, Transition to Support , Due diligence activities.
• Extensive data modeling experience on BW3.X / B.I 7.0 Administrator workbench.
• Sound Knowledge of BW Architecture, Data Flow Strategy.
• Experience in Data loading, Data load optimization, BEx Reporting 3.X / 7.0., Web reporting, Transport management.
• Have good experience in ECC to BW Data extraction using LO, Generic, FI, COPA Extractors and experience in Enhancement of Data Sources (Customer Exits/BADI’s).
• Worked on COPA BW Reporting
• Good knowledge in ETL areas like Data loading using Process Chains, DTP’s Info packages and Data load optimization by tuning start routines & update routines, creating index for DSO and info package/DTP parameters etc
• Good Functional Knowledge in various SAP modules like PM, SD, FI , P2P , etc.
• Good process knowledge, experience in Requirements Gathering, Gap analysis, Technical Specs, Blue Printing, SIT, UAT, PVT.
• Good team player, Strong team orientation & leadership qualities, hard working and Enthusiastic
• Very good logical skills suitable for process design, development & implementation.
• Excellent communication and presentation skills.
• Customer Oriented attitude.

PROJECT DETAILS

Confidential,

Duration

Ongoing

Project

Global Financial Service management

Position

SAP BI Consultant

Contribution

• Analysis and performance tuning of the J&J Production environment such as (NRIV Buffering of SID and DIM , Building index on EDIDC table , compression , partioning of cubes, deleting empty partitions, building useful aggregates, setting delta limit parameter for aggregates )
• Enhancements to the intercompany finance BI models of J&J
• Enhancements to the AP Data flows of J&J
• Production support during Quarter & Year Close.
• Reorganization of Batch Schedules
• Development of Custom BI cockpit Reports to provide BI Data Load Monitor & Query Usage Metrics Dashboards

Environment

SAP BI 7.0 ECC 6.

Confidential,

Duration

1 year and 6 months

Project

Implementation

Position

SAP BI Team Lead at Client Site

Contribution

1) Plant maintenance reporting in BI 7.0
Designed and modeled Plant Maintenance Reports for Advanced Metering Infrastructure Field Deployment Project. Developed Dashboards in BI 7.0 WAD. Carried out requirement gathering workshop with business and performed GAP analysis, blueprinting .Modeled and designed a robust
Solution which was performance optimized. Single handedly handled all phases of the project – Design , Build, Unit Test ,Integration Test , Reconciliation test, Pre Go live check list . Move to Production , Post go live activities, PVT .
2) Asset Accounting Implementation Reporting in BI 7.0:
Designed and Modeled the entire Asset Accounting suite
of reports in SAP BI 7.0. Carried out requirement
gathering workshop with business and performed GAP
analysis, blueprinting .Modeled and designed a robust
solution which was performance optimized. Mentored a
young team of 5 to execute the design. Conducted several
rounds of reviews and tests (Unit test, SIT, UAT, PVT)
before going live with the project. Developed 18 very
complex Asset Accounting reports in BEX Analyzer
workbooks.
3) AMI Reporting enhancements:
Worked in enhancing the existing AMI (Advanced
Metering Infrastructure) solution built in SAP BI with
CIS/OV as source system. Built several new models over
the existing design to handle new reporting requirements.
4) Performance Tuning of the existing Production
Landscape :
Analyzed the existing BI production system and suggested
several methods to improve the load and reporting
performance of the production system by using
compression, aggregates , caching , partitioning ,
secondary indexes etc.

Environment

SAP BI 7.0 ECC 6.

Confidential,

Duration

6 months

Project

Implementation and Production Support

Position

Offshore Team Lead

Contribution

Worked as a stream lead for various mini projects
Responsible for Requirement and GAP Analysis, Technical
specification based on functional requirements, Data model
designs, High level designs, project plans etc.,
Extensive involvement in development of various BI reports, which
involved Creation of DSO’s, Cubes, Datasources, Info sources,
Transformations, DTP’s, Bex Reports.
Involved in enhancement of Data sources for FI / LO extractors, Coding in
Customer exit for complex user requirements
Responsible for ABAP Coding in Customer Exits, Transformation routines for
realizing complex business requirements.
Created generic extractors based on ECC tables/views and function modules.
Responsible for the Transports for various ECC and BI object.
Coordinated the UAT process for various streams and closure of
reports for Move-To-Production
Coordinated all activities for Move-To-Production and successful G-Live
Handled UAT and ensured faster closure of various issues related to Data loads,
Data integrity, Design etc.,

Environment

SAP 4.6B

Confidential,

Duration

3 Months

Project

Global Financial Service management

Position

SAP BI COPA Consultant

Contribution

• Enhancement of the existing COPA-BW reporting solution to report on extra fields in the Operating Concern and end to end implementation of the changes.
• Production Support – Managing deltas that get loaded everyday into the BI 7.0 box from
• Regional boxes.
• Info spokes – Monitoring and supporting delta Info spokes to output data weekly via CSVFiles to an external warehouse.

Environment

SAP BI 7.0 ECC 6.

Confidential,

Duration

1 year 3 months

Project

Implementation / Enhancements

Position

SAP BI Consultant for Implementation and Production Support . Onsite Coordinator

Contribution

1 .East Sussex County Council
BI- SRM Solution- Modeled and designed a SRM Reporting
Solution in BI 7.0 that draws data from both ECC 6.0 and SRM
4.0 .The solution incorporates workflow reporting in BI to report
on both Vendor and PO WF data.
Project Systems Reporting Solution - Designed a bespoke
solution to report on Virtual Key Figures.
2.Worcestershire County Council (WCC)HR Implementation
Designed an HR Solution in BI 7.0 environment to meet the
WCC Reporting requirement across areas of Appraisals,
Extended HR, Time and Extended Payroll. This mainly involved
installation and bespoking BI content.
3.London Borough of Enfield (LBE)
Supporting Two people Implementation- Designed a
purchasing solution for LBE that revolves around master data
management in BW 3.5.
4.Bedfordshire County Council – Due Diligence - Performed
an assessment of BI landscape and submitted an assessment
report raising all the non compliances
5. Production Support Activities in Serco Solution
Linking BW/BI and R/3 after system Refresh/copy back in either
BI, R/3 or both
Support Pack application and testing for Serco Solutions
Various Customers
Changing logical system names to realign out of line
landscapes
Other usual production support activities – Daily, Weekly
Monitoring Process chains and resolving data load failures then
and there.
Worked on SLA to solve both Incidents ( Failures ) and Service
Requests ( Enhancement tasks )
Analysis and data reconciliation between R/3 and BI

Environment

SAP 4.6B, Microsoft Commerce Server 2000, ASP. Microsoft DCOM connector.

Confidential,

Duration

8 months

Project

Production Support

Position

Module Leader

Contribution

Single point production support from offshore
Monitoring the daily, weekly, monthly and on demand
loads
Providing daily Production Support from Offshore
(Approximately 200 Daily Jobs to monitor and send the
status sheets daily)
Maintaining the Log sheets updated on a daily and
weekly basis online
Working on the enhancement tickets which are done on
a regular basis to keep the system updated and error free.

Environment

BW 3.5 / BI 7.0

Bachelor of Technology