Abdul Afzal Mohammed SAP S/4 HANA Architect

Specialization: HANA sidecar and BW S/4 HANA implementations

abdulafzal7272@yahoo.com
M: 281-823-9678 / 510-371-2479 LinkedIn: https://www.linkedin.com/in/abdulafzal11

Profile Snapshot

SAP S4 HANA / BW / Lumira Certified Consultant, and delivery lead with expert knowledge in deploying business warehouse
solutions for analytical reporting in the areas of SD, MM, CRM, FI, PM, ICM, HR and Retail. Background includes 12 years of
varied exposure in high level design and implementation of SAP HANA / BW / S4 / HANA Live solutions for clients, an experienced
HANA data modeler in creating attribute, analytical and calculation views and implementing HANA RDS. Well versed in working in
a fast-paced technical environment with other developers, product managers, consultants, and Business Users (Customers).
Strong technical exposure in BW 7.3 / 7.4 / 7.5 data modelling techniques, latest support packs and new features, optimization for
HANA database, architecting and deploying global EDW solutions by following SAP best practices including LSA and LSA++
architecture, utilizing the standard business content, and SAP recommended landscape and platform standards, hands on with
HANA Admin cockpit of SP 11 / 12, user creations, Analytical privileges, security.

Skill Set

 SAP HANA Modelling & BW Modelling in HANA studio using BWMT on aDSO, OODS, Composite Providers.
 Multi-Temperature Data Management using cold data in SAP IQ & hands with remote data source using (SDA)Smart data
access.
 Connected LUMIRA story boards with SAP HANA Live Browser.
 Created all the roles and privileges required to create CDS views, created HANA XS application using studio.
 with the help of Core Data Services (CDS) created database schema, tables, views, and sequences as design-time files in
the repository.
 Hands with ABAP CDS views ( inner, left-outer, right-outer)
 Hands on with Design studio 1.6
 Hands on with Analysis components like e.g. Crosstab and Chart
 Created Container components, Basic components with data bound properties
 Created Scorecard component for highly formatted tables, Icons and Images
 Expertise in client interactions, Business requirements gathering and client workshops and discovery.
 Optimizing BW 7.5 Data Management based on Dynamic Tiering as well as Active/Non-Active Concept
 Optimizing BW Data Management based on Near Line-Storage
 Review of Layered Scalable Architecture (LSA), From LSA to LSA++: Streamline Core Layers
 LSA++: Open Operational Data Store Layer (Open ODS Views) , LSA++: Agile Data Mart & BW Workspace Layer
 Generation of HANA-Views for BW Info Providers, Mixed Scenarios, SAP HANA Live, HANA-Optimized BI Content
 SLT Replication into SAP HANA, SLT Replication into SAP BW, Operational Data Provisioning into SAP BW
 DB-Connect and Open Hub Destination
 Info Object Enhancements, Authorization Enhancements, Process Chain Monitoring, HANA-Optimized BW Search
 SAP LUMIRA Solution expert with SAP / Non-SAP Source systems
 Hands on with LUMIRA TEAMS Installation and Administration.
 SAP Reporting Tools BOBJ / Tableau, Jasper Analytics solutions
 SAP BW 7.4 Data warehousing best practices with Open ODS & ODP, Smart Data access
 SAP domain knowledge Toll Tax Logistics / SD / MM / Retail / CRM / FI / ICM
 Business Process Reengineering as per business reporting requirements
 Hands on with Open HANA and BW on HANA implementations and expertise with HANA Live and RDS
 Expertise in creating ODP Framework, joint modelling environment from backend BW system & HANA Eclipse for direct
access to data without latency.
 Converted DSO and Cubes to aDSO.
 HANA Admin Skills, User Creations, Authorizations, granting privileges, hands on with Admin cockpit of SP 11 / 12.

Key Result Areas

 Handling project planning, execution and management in tune with the core business objectives (including risk management,
effort / time / cost estimation)
 Setting-up of master data and function locations, importing the relevant data, task lists and maintenance orders of system as
per functional requirement
 Developing all relevant reports per user requirements including maintenance notifications, activity and malfunction reports
 Implemented POC on Crime Analytics, Genome Sequencing on HANA.
 Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting).
 Expert in creation of Analytical and Attribute Views and complex models by using SQL script in Calculation Views.
 Created Analytical Privileges and Procedures for modeling
 Strong Exposure in Data Replication Methods such as SLT, DXC. Data Provisioning using SAP BODS. Experience using
Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake Modeling, Fact & Dimensions tables.
 Good understanding of various components of SAP HANA.
 Designed and Created Universe for reporting from Information models.
 Establishing project plans within pre-set budgets and deadlines as well as monitoring project progress as per scheduled
deadlines for various tasks and taking necessary steps to ensure completion within time, cost and effort parameters
 Planning various activities involving resources management, project expenses, etc., while analysing user requirements in order
to understand the problem domain and suggesting the alternatives available for a solution to them
 Performing configuration of various documents, reports and configuration of different accounts as well as reviewing various
alternatives available and choosing the best solution available
 Providing an appropriate solution to client to meet business needs and guiding the setup and customization of release
procedures for classification of various internal & external documents, etc.
 Coordinating with the development team for development / customisation of software, while ensuring integration with other
modules, integration & user acceptance testing & extending post go-live support, including training support to end-users
 Supporting and monitoring for preparing help manuals for all modules to reduce queries from implementation sites and
conducting internal audits to ensure on-going improvements in the quality assurance systems.
 Proactive team player with excellent interactive and interpersonal skills to communicate with team members, developers,
clients and end users at all levels. 

Highlights
 Implemented HANA Live, Extended HANA Live and customised standard content with business requirements
 Implemented Toll Tax Reporting solution on Lumira Teams, extensively worked on LUMIRA 1.10 - 1.30 versions, hands with
chart extensions of LUMRIA and implemented Integration of WEBI to Lumira.
 Implemented BI Adoption RDS for Reliance JIO Telco on SAP America Project. CID-5179911
 Implemented new SAP Retail tool SAP CAR (Customer Activity Repository) on HANA and LUMIRA Dashboards
 Implemented SAP HANA / Lumira for SATYAMEVJAYATE TV show
 Implemented BW on HANA for Johnson & Johnsons
 Delivered SAP HANA – CRM integration project for SAP Global Delivery, Bangalore.
 Managed 3 Implementations in a single year in Robert BOSCH.
 Essayed a key role in administering Mind tree, Bangalore on Talent Acquisition, Zafco, Dubai on CRM BW integration Projects.

IT Skills

Business Intelligence: SAP (HANA / BW / BODS / BO) ERP SAP R/3, HANA Live
Reporting Tools: BEX Analyzer, Query Designer, WAD, Design Studio 1.6, WEBI, SAP LUMIRA, Bo explorer,
Tableau, Jaspersoft
Predictive Modelling & Data Mining: Boosting, Association Rule Mining, Clustering, Neural Networks, Regression, Support
Vector Machines, Time Series Analysis, Decision Trees, Bayesian Inference.

Certifications

 Certified Project Manager: Prince2 Practitioner

 Certified Six Sigma Black Belt Lean Quality
 ITIL V3 Certified
 SAP HANA Certified
 SAP BW 7.3 Certified

Academic Qualifications
 CBA (Business Analytics) from ISB (Indian School of Business), 2013
 MCA , Bangalore University in 2002
 EMBA from National Institute of Business Management,2008

Personal Details

Date of Birth: 15th June 1978

Residential Address: #715, RR 2222, Austin, Texas, Zip-78730

Citizenship / Visa
 H1B
 Europe-Schengen B1
Mobility: Willing to travel

Languages: Written and spoken fluency in English & Hindi, Telugu, Kannada

Employment Details

May’14 - Till Date Saven Technologies, USA SAP S4 HANA Architect

May’13 - May’14 Persistent Systems, Bangalore Solutions Architect
Nov’11 - Apr’13 Robert Bosch, Bangalore BI Associate Project Manager
June’05 - Oct’11 Numantra Technologies, Mumbai BW Consultant
Jan’03 - June’05 2S Consulting, Mumbai BW Associate Consultant

(Refer to annexure for Projects)

Annexure: Key Projects Handled

Project: Implementation
Client: Elizabeth River Cross Tunnels, Virginia (COGNIZANT ID 511546)
Industry: Toll collection
Environment: HANA / BODS / Lumira / Jasper / Design Studio 1.6
Role: SAP HANA/ Lumira Solution Architect
Period: Sept 2015 to till Date

Highlights:
ERC is an automated toll collection system used for collecting automatic toll tax at Tunnels in this project, we do the identification
with radio frequency with transponders. A vehicle will hold an RFID Tag, this tag is nothing but unique identified number assigned
by VDOT (Virginia Department of transportation). Readers will be strategically placed at toll collection centre, whenever the vehicle
passes the toll collection plaza the tax amount will be deducted from the prepaid account or a tax amount will be invoiced on
number plate.

Roles/Responsibilities:
 Extract requirements: determined project’s requirements by extracting them from business as well as from current and
future users, through interaction and research.
 Organize requirements:  organized requirements into related categories to effectively manage and communicate them.
Managed project requirements from becoming overlooked, and optimum use of time and budgets.
 Translate requirements - adept at translating business requirements to technical requirements, this includes using
powerful analysis and modeling tools to match strategic business objectives with practical technical solutions.
 Managing requirements - delivered formal requirements presentation, review and approval sessions, where project
schedules, costs and duration estimates are updated and the business objectives are revisited, upon approval, transitions
into requirements management activities for the rest of the IT solution life cycle.
 Design end to end solution from requirement gathering to Post live support, which includes Blue print design and project
delivery with resource plan considering the budget. Maintaining daily / weekly tracker and end client meetings on each
phase sign off.
 Conducted workshop with client admin team to scale existing Oracle system sizing and created landscape design
considering DB size and yearly incremental data growth for next 5 years.
 Created Users, Roles, Privileges, Packages, Schemas as part of HANA security on HANA life cycle management in SP11
environment.
 Designed and implemented SAP HANA data modelling technics using Attribute View, Analytic View, and Calculation
Views.
 Developed complex Calculation views, Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to
import csv files into SAP HANA tables to maintain reconciliation between reject tolls from VDOT.
 Involved in SAP HANA Security including User Management, Roles, and Privileges using Life cycle management of
SP11.
 Involved in Information Design Tool Creation of Data Foundation, Universe for HANA- BI reporting.
 Worked on DB sizing, hardware and software licenses, installation and configuration of Lumira Teams.
 Implemented solution to capture toll plaza life cycle revenue collection from Roadside portable server, Integrated and
transformed data with BODS edge server and maintained separate Reporting DB to improve reporting performance,
introduced LUMIRA TEAMS server for reports consumption.
 Automatic vehicle identification with Tag and Non Tag analytics to adjust Peak / off peak plan.
 Automatic vehicle classification commercial / private with revenues.
 Video enforcement system records plate and Identifies the EZ pass insufficient fund/Violation accounts.
 Created operational reports on TTH (Toll Transaction Host) and reconciled with IPS(Image Processing system), BOS
(Back Office system)
 Created reconciliation reports to address financial loss, incorrect / Dispute reads.
 Refunds paid efficiently with Lumira report which pulls on last toll utilization date.
 Built analytics on Lane utilization / Clerk efficiency
 Monthly fee statements, weekly traffic census, Revenue reports, traffic count report, discrepancy report, operator
efficiency report, daily Ez pass / plate reports, IP based reports.
 AR / GL aging reports on toll revenues, created bucket reports for invoice aging.
 Created users and authorizations on LUMIRA Teams with user groups.
 Conducted work shop on End user training on accessing Lumira stories on portal.

Project: Implementation
Client: Reliance JIO Telco, SAP America, CA (Sap ID: C5179911)
Industry: Tele Communications
Environment: SAP HANASP 9 / BW 7.4 / Lumira / Design Studio / Webi
Role: SAP HANA BW Architect
Period: Nov 2014 to Aug 2015

Highlights:
  SAP BIA (BI adoption) RDS implementation. The SAP Business Intelligence Adoption rapid-deployment solution is a
comprehensive package that helps customers make the right choice of the right reporting tool for the right reports. Software
content helps to serve as a starting point for building better reports. As well, data reconciliation and availability helps users
gain trust in the data warehouse environment serving as a catalyst to adopt BI tools. Simple visualization of data in desktop
and mobile devices provides easy access to enterprise data. Applications covering Purchasing, Manufacturing, Sales,
Finance, Executive Analytics ,Human Capital Management Analytics,CRM Analytics, Trade Promotion Effectiveness, Track
Analytic Data, Business Intelligence Analytics with Operational Data Provisioning.
 Implemented BPS add on at BW 7.4 , successfully imported RDS(Tgz) file to Hana and worked on BOBJ Biar file to map
connection to BW system.
 Participated in Business Blueprint and design sessions, review options and provide recommendations while communicating
the benefits, risks, and constraints to both the business and IT stakeholders
 Instrumental in standardizing the Implementation process in data modeling in sap HANA from ERP, Integration with CRM-
ICM to generate settlements and remuneration Liability reports.
 Customized universe and modified webi, Dashboard as per business requirements.
 Facilitate modeling sessions and design walk-through with the development team members
 Work across business/technology teams to ensure alignment between business solution definition & technical architecture to
meet project requirements on Procurement, Inventory Management and Finance, CRM, Plant & Maintenance, Sales &
distribution, fixed gaps on every application to meet customer reporting requirements.

Project: Implementation SAP CAR / SAP HANA / LUMIRA

Client: Brooks Brothers, SFO, CA
Industry: Retail
Environment: SAPCAR/ SAP HANA / Lumira
Role: Technical Architect
Period: May’14 to Oct’2014

Highlights:

Implemented SAP Customer Activity Repository on HANA, a new innovation tool from SAP. Customer Activity Repository is
intended to help retailers become more customer-centric by bringing together customer, sales, and inventory information from
siloed applications.
 Accountable for successful delivery of functional and technical components of Business Intelligence (BI) reporting solutions
using SAP HANA
 Participate in blueprint and design sessions, review options and provide recommendations while communicating the benefits,
risks, and constraints to both the business and IT stakeholders
 Instrumental in standardizing the Implementation process in data modeling in sap HANA from ERP and POSDM systems
using HANA-LIVE and SAP CAR RDS, extracted data into HANA using SLT and BODS work flows and re-design the
universes that support WebI and Dashboard reports
 Facilitate modeling sessions and design walk-through with the development team members
 Work across business/technology teams to ensure alignment between business solution definition & technical architecture to
meet project requirements
 Benefitting with the knowledge of various aspects of HANA modeling including creating schemas and importing source
system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views,
Analytical Views and Calculation Views.
 Communicate with customers and partners to understand, document and align the business and technical objectives of key
programs
 Provide SAP HANA subject matter expertise and understand the latest architectures, technologies, external forces and
market trends, as well as competitive offerings to proactively build, sustain and manage a differentiated solutions roadmap
 Involved in handling the design of BOBJ / LUMIRA reports on multi channel sales analytics, inventory visibility, Point of sales
data management

Project: Implementation SQL / SAP HANA / LUMIRA

Client: STAR TV
Industry: Media & Entertainment
Environment: SAP HANA / Lumira
Role: Solutions Architect
Period: Feb’ 2014 to May’14.
Highlights:
It is a HANA / Lumira implementation project for a TV show called SMJ. It aims at extracting the Information about social
problems, insights over missed calls, Twitter, Face book, Site comments, SMS, video views, petitions...etc. after broadcasting
every episode, data formats are structured and un structured. Social media sentiments are categorized with algorithms, and
data transformed with BODS and stored in HANA Data base. SAP LUMIRA used for Analytics
 Led development of conceptual and architectural solution blueprint for assigned projects to meet business requirements while
ensuring compliance with established architectural principles, standards, and processes.
 Provided deep SAP technical/architecture guidance to project teams in areas of BI and Analytics
 Involved in the identification of assets and services that were re-used by the project teams to drive consistency, cost
reduction, and increased speed to market within assigned architecture and functional domains
 Participated on architectural governance team and processes to guide and sanction critical architectural decisions
 Advocated the communication of and adherence to defined application architecture strategy.
 Proactively monitored strategic direction of SAP Vendors, technology and market trends, and determined their potential
impact and value to the enterprise.
 Researched and led the development of prototypes to assess and build new capabilities in the enterprise.

Project: Implementation (SAP HANA)

Client: Johnson & Johnson , SFO , CA
Industry: Health Care
Environment: SAP HANA / Micro Strategy
Role: Solutions Architect
Period: Oct’ 2013 to Feb’2014

Highlights:
Accounts harmonization from JD Edwards, SAP BW to SAP HANA. Johnson & Johnson has acquired two companies DEPUY
and SYNTHES, they have different business verticals and running on SAP BW and JD Edwards DW technologies. There are
maintenance and harmonization problem in maintaining accounts, and sales, product hierarchies were not giving drilldowns to
all the levels, reports were not reconcile with source data, hence proposed single system to integrate, harmonize accounts of 2
companies with SAP HANA Solution.
 Lead SAP BW/HANA related activities which includes technology innovation, training enablement, demand fulfillment in
related technologies, CoE members career progression & talent management
 Research, develop and document SAP BW/HANA solution alternatives, approaches and recommendations that address
approved project scope and business requirements, align with IT’s Target State Architecture and Technology Roadmap, and
leverage IT investments across the enterprise
 Bring technology leadership in HANA including BW on HANA
 Conduct risk assessments (risk identification, risk analysis, mitigation strategy) to assist the business in selecting the most
appropriate solution.
 Present to senior management and the Architecture Review Board to gain buy-in and acceptance of solution approaches, and
to ensure that decisions are made with the interest of the enterprise vision in mind (e.g. align with strategic business and IT
direction).
 Lead and define project designs like Infrastructure Designs, High Level Designs, and Detailed Designs, Test Definitions and
Implementation Strategies, and stay involved throughout project life cycle to ensure projects deliver according to the
approved designs.
 Involved in providing advice to onsite SAP HANA consultants and customers and resolve solution design issues throughout
the project lifecycle

Project: Implementation (Genetics – SAP HANA)

Client: Internal Product SANGENIX, China
Industry: Bio-Tech Lab
Environment: SAP HANA / SAP BO
Role: Solutions Architect
Period: May’2013 to September 2013

Highlights:

 Gathered Business requirements and proposed solutions in business intelligence

o Proposed Visual Intelligence solutions and Business executive’s dashboard and midlevel dashboards, analyst level
data presentation
o Responsible for designing ETL (extraction, transform, load) the data, building queries on data, scheduling data loads
on daily, monthly, weekly decision making reports
 Built SAP Business Intelligence competency for Persistent Systems
 o Conducted interviews, identified suitable candidates in different levels of experience
 Consulted Business users on requirements, suggested business analytics solutions in SAP HANA, and explained to the
Business In-memory data base model where terabytes of data can be loaded in the memory and queries can be retrieved from
in-memory rather disk, allowing reports to be run in milliseconds
 Conducted trainings on Business Intelligence, Business Objects Reporting tools, SAP HANA

Project: Implementation (PRM Module)

Client: SAP Global Delivery
CUID: C5179911
Industry: IT Service
Environment: SAP HANA, SAP BI 7.3, SAP BO & SAP BODS
Role: SAP HANA & BI Consultant
Period: Oct’12 – Apr’13

Highlights

 Streamlining reuse & enhancement of existing data sources for Service ticket related data and conceptualized Data Source for
Knowledge Articles
 Enhancing T- and D-Layer DSOs for Campaign, Activity, Services, Partner, Membership
 Conceptualizing consolidated DSO & Cube for campaigns, activities, leads during loading of data
 Creating multi-providers on the cubes, necessary BEx queries for the requested reports, PIC Authorization concept by
leveraging the existing PRM Reporting concept
 Developing BOBJ Universes for the requested reports on top of BW queries, WebI Reports, Analysis Authorization Profile for
the End Users
 Diligently preparing reports for:
o Campaigns Interaction Summary, PSA Team's Partner Assignments and Interactions Summary,
o My Partner List Interaction Summary, Open Activities, My Planned Interactions, Global and My Local Campaigns
o PSA’s Market Unit's Action Plan Status, Summary of Closed Tasks, My Interactions Summary, Interactions Reports
o Campaign Progress per Month Week, Global Local Campaigns List, Campaigns Closure Report per Market Unit, PSA’s
Progress Report on Campaigns

Project: Implementation (CRM module)

Client: Zafco, Dubai
Industry: Automobile Sales & Service
Environment: SAP BI 7.0, CRM, ECC
Role: Senior SAP BI Associate Project Manager
Period: Apr’12 – Jul’12

Highlights

 Assesed Business Requirements from CRM Functional Team and analyzed reporting requirements and building SAP BW Data
Model, while interacting with CRM Functional Team on Reporting requirements and developed a SAP BW Data Model
 Customized data sources, created Generic data sources in CRM System and extracted data from ECC and CRM Systems.
Developed evaluation criteria and test plan, Creation of Info Objects, Transformations, DSO, Cube, and MultiProvider
 Verified Content Activation Result, Data Loads in development system and reconcile data with CRM, along CRM Team
 Worked on Transports from Dev to Q-system. Data loads in Q-System-System, created plant level authorization
 Prepared Reports on Total Sales-Services, Sales-Products, Operating Profit % to Net Sales, Turnover Service % from
Total, Invoice Analysis, Brand-wise Analysis, Utilization Report, Employee-wise Profitability

Project: Implementation (HR & Talent Acquisition)

Client: Mind Tree, Bangalore
Industry: Pharmaceuticals
Environment: SAP BI 7.0, ECC, Hire Craft
Role: Senior SAP BI Consultant
Period: Nov’11 – Mar’12

Highlights

 Handled wide gamut of tasks encompassing end-to-end implementation and understanding of business requirements from
Talent Acquisition Team
 Diligently Analyzed the requirement and developed a blueprint of data model for the requirement in SAP BW
 Finalized a list of Custom Data Target, Info Objects, Queries and Roles and developed Evaluation Criteria and Test Plan
 Assessed database parameter setup for performance and prepared end-user training modules
 Created Info Objects, Transformations, DSO, Cube, MultiProvider and verified content activation result
 Prepared reports on:
o TA Metrics, Offer Trend, Offer Break-up by Practice/IG & Offer Break-up by Competency Wise
o Offer Break-up by BU (People–Owner), Selection Data & Summary - NHR VS
o Offer – Business – People Owner Wise and Decline Analysis Reports

At Numantra Technologies
Project: Implementation & Support (HR Module)
Client: Essar, Mumbai
Industry: Steel Manufacturing
Environment: SAP BI 7.0
Role BI Consultant
Period: Jun 2005 to Oct 2011

Highlights

The Sap BW/HR implementations primarily intend to satisfy the global HR reporting requirements. Client Reporting
requirements are focused on the areas of Personnel Administration (PA), Payroll (PY), and Organizational management
(PAOS), Time Management (PT), etc.
 Interacted with customers and Developed a high level implementation plan, selected project team, training plan
 Determine Landscape and Transport Strategy along Basis team, Acquire, Install and Test the Technical Environment
(hardware, software, database, desk top and connectivity - Basis)
 Finalized a list of pre-delivered business contents to be activated by functional components, data sources, Info Cubes, Info
Objects, Queries, and roles
 Assigned responsibility for each components Agree upon the instrument (template) to record the test result and additional
requirements, Develop evaluation criteria and test plan, Check database parameter setup for performance Prepare end user
training material
 Spearheaded Business Contents Activation, Populate SAP delivered business contents with customer data, Verify the content
activation Result, Conduct End User Training
 Conducted System Tests with End User Feedback, Conduct Volume Test, System Performance Tuning,
 Coordinated and Implement Production Scheduling, Develop a BW Operations Guide
 Enhanced Operations Guide, Monitoring and addressing production issues, if any. End user support, Project Go-live
Review, Define the Scope of next Iteration of Implementation

Project: Production Support

Client: Wockhardt Hospital, Mumbai
Industry: Health Care
Environment: SAP BI 7.0
Role: SAP BW Consultant
Period: Jan 2005 to Jun 2005

 Responsible for the Production Support Activities performed at Offshore

 Monitored the Loads of master data and transactional data through process chains
 As part of loading we schedule the process chains on daily, weekly and monthly basis to load the data into respective targets
 Monitored Process Chains and Meta Chains, worked to fix errors; Sid issues, duplicate data records, Activation of DSO errors,
memory issues and Timestamp errors, etc. with respective corrections
 Performed Data Extraction and Data Staging using LO Cockpit (LBWE), loaded the data from ECC6.0 to BI7.0 used
Initialization with Delta Update methods
 Involved in planning of Data reloads activities
 Worked on Broadcasting and pre calculation servers, Created Broadcast setting for queries and workbooks to publish the
reports to the users via E-Mail
 Performing test data loads in mirror systems before transporting changes to production server.
 Involved in solving tickets regarding extractions, Performance Issues and also load failures.
 Worked on BI stabilization project where the teams from SAP and service teams are involved to stabilize the system and
improve the data load SLA’s.

Project: Implementation / Production Support

Client: NPIL (Nicholas Piramal India Ltd.) - Development/Support , Mumbai
Industry: Pharmaceuticals
Environment: SAP BI 3.5
Role: SAP BW Consultant
Period: April 2004 to Dec 2004

Highlights

 Worked on LO-Cockpit Extraction for the Inventory Management, Sales and Distribution
 Developed queries based on the user requirement using Calculated Key Figure, Restricted Key Figure, Formulas, Exceptions,
Conditions, different variables and Used RRI feature
 Complete automation of all BW daily, weekly and monthly loads to load master data and transactional data
 Maintain Daily data load error spreadsheet for each BW system ticket. Purpose is to record failed data loads ensure visibility of
issues and its correction
 Performed Data Extraction and Data Staging using LO Cockpit (LBWE) and extended the Structures using enhancements to
support the business needs
 Replicating the data sources in BW side and activating the inactive transfer structures using ABAP Program and ensured
performance tuning of Queries by maintaining Aggregates. Worked on Info cube Compression and rollup of aggregates

At 2S Consulting

Project: Production Support

Client: Lupin Pharmaceuticals Inc, Mumbai
Industry: Pharmaceuticals
Environment: SAP BI 3.0
Role: SAP BW Associate Consultant
Period: Jan 2003 to March 2004
Highlights
 Monitoring Data load activities and recovered failures in Dev., Quality system as a part of unit testing.
 Preparing the process documents for each and every enhancement.
 Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
 Working on process chains to automate the Deleting indexes in Info cubes, Process of info packages, creating indexes, ODS
activation, further updating, PSA request deletion and Attribute change run so on.
 Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
 Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
 Enhancing the existing reports as per the new requirement.
 Monitoring the daily loads to various data targets in the system. 
 Monitoring the process chains on the basis of daily, weekly & monthly.
 Manual loading and rolling up the data into data targets. 
 Maintaining the logs for each manual load.
 Creating aggregates to improve the query response.