SUMMARY

• Successful information technology professional with more than 13 years of diverse and extensive experience focusing on systems analysis, design, training, documentation, Development and systems migration.
• Around 11 Years of experience in SAP BW/BI, SAP HANA and Proven achievements in providing hands - on guidance with SAP BW /BI, HANA and other software applications deployment.
• Excellent professional experience in Software Development Life Cycle that includes requirement gathering, design, project implementation, system testing, user support and training.
• Extensive experience in HP Application Lifecycle Management (HP ALM) and change Management(Remedy) control
• Good in integrated understanding of various aspects of business processes.
• Good interpersonal, analytical and technical skills.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Understanding the scope of MMD-GSS Project and prepare the high-level Design document and get it approved from the stake holders and Business.
• Involved in Preparing the functional and Technical specs based on Design document.
• Developed New Generic extractors, DSO’s, Cubes, Advanced DSO’s, Composite Providers, Open Hub Destinations, Calculation views
• Creating HANA Views by importing BW models to get info objects description to fields labels in HANA.
• Replicated multiple ECC tables to Hana studio through SLT and Physicalized the data in HANA tables to provide faster reporting results in Analysis for office and Design Studio

Confidential

Responsibilities:

• Developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Created Joins, Calculated, Restricted columns, Variable and filters in views, Analytical Privileges, Procedures and decision tables when HANA server splited.
• Validated SQL scripts in HANA studio.
• Responsibilities from onsite, Preparing Test Plans, Test cases and Test Scripts for Unit, Regression, User Acceptance and Performance Testing based on business requirements in HP Application Lifecycle Management (HPQC) and Involved in Incident Management, Problem Management, change Request and Service request meetings
• Responsible for Defects Management and daily defect triaging.
• Conducting the Project status meetings and run through the Defects status updates.
• Responsible for reporting Daily / weekly status report for all enhancements and projects.

Confidential

Responsibilities:

• Interact with management and business Decision-makers to identify business requirements. Documented the reporting needs of the Business Service and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Responsible for analyzing the scope of Requirement and the Impact analysis for all major enhancements & incidents.
• Prepared functional and technical specifications based on the business requirements.
• Attended MIM (Major incident Management) calls and meetings to update the status of the major incidents.
• Extensively worked on Business Information Warehouse Info Cubes, DSO's, Info Objects, Multi providers, Data Sources, Transformations and DTP's.
• Extensively used Open Hub Service functionality to distribute data from SAP BI to other non-SAP data systems.
• Expertise in maintaining Process Chains & Meta Chains for automating data loads.
• Extensively involved in creation of BEx Reports. Worked on Calculated Key Figures Restricted Key Figures, Free Characteristics, Filters and Customer Exists.
• Good understanding and experience of various components of SAP HANA,
• Extensively Worked on SAP HANA Data Modeling using Attribute Views, Analytic Views and Calculation Views (both Graphical & SQL script based) & SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Extensively worked on Analytical Privileges, Procedures and decision tables.
• Extensively involved in writing SQL scripts in HANA Studio.

Confidential

Responsibilities:

• Involved in BW Implementation which includes, gathering requirements, design specification, Modelling, data extraction, reporting, unit testing, and user acceptance testing, documentation and maintenance.
• Monitoring the process chains, executing the Monday Morning Reports and sending them to the specified end users.
• Conducting and monitoring weekly performance tuning activities, comparing BI Data with R/3 and sending the reconciliation report to the business on daily basis
• Extracted the data from ECC, POSDM and GTS systems to BI and used to send the detailed status mails to the end-users
• Extensively worked on BO3.1 to BO4.0 technical and functional upgrade projects and delivered successfully without any issues.
• Worked on BOBJ Security Testing, as a part of testing Basis & Security teams has granted the access for different end users as per my inputs and document.
• Extensively trained on SAP BODS, SLT and HANA and attained SAP HANA Certification from SAP.
• Efficiently worked on advanced analysis for web and advanced analysis for excel and on HANA POC
• Successfully created Data Flow Model from BI to HANA and from HANA to BO as a part of HANA POC.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Migrating standard Info cubes to in memory optimized Info cubes using migration Tool.
• Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.
• Importing the BW Models in to HANA using HANA Studio.
• Consuming the HANA Models in BW by creating the Transient Providers
• Trained interns in SAP BW and utilized them in SAP BW support activities.

Confidential

Responsibilities:

• Interacted and prepared the FS document by gathering the requirements from business users.
• After proper sign off from the business users started developing the objects as per the FS and prepared the technical specification document.
• As part of development, installed standard SAP BI content info Cubes, data store Object, Info objects, Queries and web templates.
• Created info Cubes, DSO’s, Multi-Providers, Transformations (both ODS and Info Cube level), DTP’s and conversion techniques.
• Involved in writing ABAP Routines (Start, End & Expert) during the creation of Transformations & DTPs.
• Experience in extracting data from SAP R/3 using LO Cockpit, FI-SL, CO-PA and generic extractors (Table, View, FM, and Infoset Query)
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Performed various tuning techniques (aggregates and partitioning) to optimize the query performance
• Worked on RRI jump queries
• Created process chains and transported across the landscape.
• Collected all the development system objects into Transports and moved them to all the systems in the landscape.
• Developed Universe using Designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies in Universe.
• Created user defined @prompts and complex conditions at Universe level for better performance.
• Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
• Created KPI’s using Xcelcious.
• Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
• Attended trainings and gained knowledge on SAP BW on HANA, BODS, SLT and HANA.

Confidential

Responsibilities:

• Worked extensively on Administration workbench. Customized Info Objects, Info Sources and Info Cubes.
• Upload master and transactional data from Flat files and SAP R/3 as the OLTP source.
• Maintained Transfer rules, Update rules, Info Packages and Info Package groups and scheduling the Info packages.
• Checked for data Consistency and modified the data in PSA before loading them to data targets.
• Resolved data load issues.
• Worked on selective deletion and selective loading in production client.
• Performed Basic functionality testing, Regression testing, Query testing and captured the testing results in HPQC.
• Created communication, transfer structures, transfer rules, update rules, conversion techniques and User Exits using ABAP (Routines).
• Designed and making extensive use of ODS capabilities and update rules keeping query performance in view.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.

Confidential

Responsibilities:

• Scheduled Daily/ Weekly & Monthly Data loading using process chains, corrected & maintained work log for data loading errors in a shared folder.
• Prevented activities of errors which occurred repetitively, maintained and redefined aggregates if required on weekly basis
• Initiated performance tuning activities related to reporting as well as loading and possess good experience of creating process chains
• Interacted with end users by giving expert support and was involved on migration project
• Checked the Info Packages, scrutinized the reasons for frequent failures of info packages and maintained queues related to the system generated tickets and customer generated tickets
• Efficiently maintained work history for all the tickets until it was closed down, validated data consistency in reporting with data target against PSA after loading them to data targets
• Proactively involved in maintaining documentation for all the support activities
• Conducting and monitoring weekly performance tuning activities, comparing BI Data with R/3 and sending the reconciliation report to the business on daily basis.

Confidential

Responsibilities:

• Involved in developing Multi-Dimensional Data Models like Info Cubes, Multi-Providers, Operational Data Store (ODS), Aggregates, Info Objects, Data Sources, Info Sources, Transfer rules, Update rules, generic data sources.
• Worked extensively on LO Cockpit and loaded data from SAP R/3 to BW by initializing of delta update by filling the setup tables.
• Extracting data from custom table using Generic Extraction.
• Developed flexible queries using Filters, Variables, Exceptions, Conditions, restricted key figures and calculated key figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Transporting the Queries and workbooks from Development to Acceptance and Quality.
• Scheduling and Monitoring the Data loads in Acceptance and Quality systems.
• Created Process chains for Master data and Transaction data loads and Prepared the Design document for the same
• Testing the queries in various servers like Development, Acceptance and Quality.
• Involved on BW3.5 to BI 7.0 Functional upgrade.
• Used Mercury Quality tool for project tracking and defect resolution activities.
• Involved in QA Process after development before delivering the objects to the MI team.
• Resolving defects arising at Acceptance and Quality systems.
• Involved in writing the Technical Specifications for the Objects.
• Collected & transported objects throughout BW system Landscape with RevTrac Transport tool.

Confidential

Responsibilities:

• Performing the Load flow analysis and determination of technical losses Collection of Energy sales feeder-wise and consumption and segregation of Technical and Commercial Losses and performing energy auditing Reconfiguration as HVDS to achieve Loss Reduction studies by load center & demand.
• Overseeing evacuation of power and maintenance of adequate asset management system to all the Substations and Developing and maintaining client requirement Database and data dictionary as per tender document. Team recruitment for Data Processing and GPS Survey. Verification & Certification for GPS survey and Consumer Indexing Preparation & submission of project report.
• Building Distribution Network GIS, Customer Indexing Energy Auditing and Accounting, Asset Management, Network Refurbishment Management, Technical Audit of Distribution Transformers.