Achievements

SAP Certified Solution Consultant

• Certified in HANA version 1.0 service pack 6 from open SAP.
• Presented a white paper on loading data to HANA through BODS for complex transformations.
• Displayed leadership qualities and managed a team of BOA project that resulted in the Applause Award .
• Received Technical Eminence award from client for high number of defect closures.
• Identified as KEY Associate in the organization of Mahindra SATYAM and was rewarded with the Key Associate Retention bonus.

BW/BPC/HANA Expertise

• Certified consultant in SAP HANA 1.0 SP06 from open SAP.
• Hands on experience on the SAP BO reporting tools like WEBI, dashboards analysis edition for OLAP.
• Extensively worked on SAP reporting tools like BEx analyzer, BEx query designer, work books, WEBI and Dashboards.
• Created RKFs, CKFs, and Variables with User Entry/Default Value, Replacement Path and Customer Exit, Formulas, Selections, Structures, RRIs, Authorizations, Filters and Web templates.
• Worked on performance tuning aspects like creating aggregates, indices, partitioning and compression of cubes, Installed technical content cubes, multi provider and generated queries.
• Worked on BI 7.0 Data warehousing workbench: Production support of Info objects, Info Cubes, Data Store Objects DSO , Multi providers, Info Sets and Open Hub Services.
• Extensively worked on DTPs, Transformations, Start, End and Expert routines, Info Cubes, DSO Objects, reconstruction, remodeling, repartitioning, open hub destinations, multi providers, Info sets and BI Accelerator.
• Migration of DSO's and Cubes to In memory optimized info providers to support HANA database.
• Experience of pre and post migration activities of database migration option to HANA.
• Created process chains for deleting and recreating the indexes and for loading master data texts and attributes and the transactional data.
• Involved in Transactional/Master data loading, Scheduling, creation/monitoring of process chains and resolving of various data load errors.
• Experience in transporting objects from Development to Production.
• Ability to coordinate with users in business requirement gathering.
• Ability to co-ordinate collaborative efforts, meet deadlines and manage time efficiently.
• Having good skills in analysis and designing the technical specifications of the process.
• Create packages to copy the forecast, plan and budget data.
• Configure data manager extraction from ECC and BI system for the actual, plan data.
• Utilize transformation files for the data management process.
• Extract master and transactional data to SAP BPC from Legacy systems.
• Create and Maintain custom dimension/ info object , dimension property, dimension hierarchy for entity, account, product, time
• Correspond with SAP on the product bug, defects, apply the OSS note.
• Maintain the exchange-rates in the rate-application based on TCURR tables in SAP BW.
• Developed BPC process chains to support master and transactional data loads from BW Info Providers/Info Objects and Legacy flat-files to BPC-models and dimensions.
• Optimize models based on light and full optimization techniques.
• Experience with SAP Business Objects 4.0 IDT, UDT, Web Intelligence, Explorer .
• Designed information models like analytical view, attribute view, calculation view in SAP HANA Studio.
• Implemented BODS ETL jobs to Load data into SAP HANA Database from source system.
• Designed data flows in SAP BO Data Services for different source systems and merging them.
• Experience in handling challenges related to the migration of BW powered on HANA.

Projects Executed

Confidential

Responsibilities: Handled the following tasks:

• Up gradation of the SAP BW system from 7.0 to 7.3.
• Migration of the database from Oracle to the SAP HANA after upgrade.
• Involved in the pre cutover activities of the HANA migration.
• Used SAP best practice of System creation via production copy safe side approach.
• Designed BO WebI reports for info providers using BICS connection.
• Involved in Unit testing, System testing and User acceptance testing.
• Involved in Customer presentations from Onsite and working on the modifications.
• Worked on the conversion of selected info cubes and DSO's to In memory optimized .
• Actively participated in the post migration activities.
• Removal of unnecessary info cubes to improve the query performance.
• Consistency check of various objects of BW after migration to the HANA database.
• Identification of bottlenecks in the migration process.
• Enhancement of the existing master data transaction data extractors.
• Building interfaces like APD's for the outbound systems like AURORA LEGS.
• Created the Safety stock optimization dashboard for the inventory analysis.
• Created the BOBJ transports in the development system through Central Management Console CMC .
• BOBJ transport movement from development to the quality and production systems.
• Created various BOBJ reports for the LEGS project using WEBI as front end tool.
• Worked on the BW related ABAP, wherever customizations are necessary.
• Worked on end to end implementation of the Historical inventory project with BW as back end and BOBJ tools at the front end reporting.
• Educating the end users and provide the necessary training in accessing the newly created BOBJ reports through BI Launch pad.
• Interacted with users in understanding the requirements and build SAP BW data flows and BO reports.

Confidential

Responsibilities: Handled the following tasks:

• Loading Transaction Data using a Flat File, NW BI Info Cube using Standard Data manager Packages.
• Exposure in extracting data from Heterogeneous data sources like R/3 BI servers
• Created Data manger packages for data loading activities and used to call script logics to perform complex calculations.
• Created multiple models and dimensions based on business requirements.
• Maintained master data and created required properties in Dimensions.
• Prepared the Business user training manual for interfaces have done.
• Provided user training about to explain planning templates.
• Involved in preparing technical documentation for all BPC objects
• Design and develop the BPC reports and input schedule according to business requirements.
• Created the technical specifications from the functional specs received.
• Worked on EPM reporting to drill through from balances to line items.
• Exposure in extracting data from Heterogeneous data sources like R/3 BI servers.
• Transported various objects from Development to Production.
• Performed the regression testing to check the consistency of the data in special use system.
• Worked on the SPO's for different partitioning criteria.
• Prepared the Business user training manual for interfaces have done.
• Involved in preparing technical documentation for all BW objects.
• Created Process chains for loading both Master data and Transaction data
• Worked on creation of roles and authorizations to business users.
• Report development according to technical specifications which includes Hierarchical functionality, prompts, formatting features of the tool.
• Development of objects like info cubes, DSO's, SPO's and Open hubs.
• Transport repackaging during go live time.
• Sending Effort estimates for the new change requests.
• Developed complex reports using query designer and reported through WEBI and Bex analyzer.
• Involved in Performance Issues like Creation of aggregates, Partitioning and Compressed the Info cube to improve the query performance
• Created Process chains for loading both Master data and Transaction data
• Created transformation and conversion files to import data into BPC from data in any format from any source system

Projects Executed

Confidential

Responsibilities : Handled the following tasks:

• Worked on EPM reporting to drill through from balances to line items.
• Writing Test Scripts, conducting Unit Testing and documenting the results.
• Created the technical specifications from the functional specs received.
• Exposure in extracting data from Heterogeneous data sources like R/3 BI servers
• Transported the objects from Development to Production.
• Performed the regression testing to check the consistency of the data in special use system.
• Worked on the SPO's for different partitioning criteria.
• Prepared the Business user training manual for interfaces have done.
• Provided user training about to explain planning templates.
• Involved in preparing technical documentation for all BW objects
• Involved in Performance Issues like Creation of aggregates, Partitioning and Compressed the Info cube to improve the query performance
• Created RKFs, CKFs, and Variables with User Entry/Default Value, Replacement Path and Customer Exit, Formulas, Selections, Structures, RRIs, Authorizations, Filters and Web templates.
• Created Process chains for loading both Master data and Transaction data
• Worked on creation of roles and authorizations to business users.
• Report development according to technical specifications which includes Hierarchical functionality, prompts, formatting features of the tool.
• Performing pre post implementation maintenance activities, when there is a system down time for maintenance.
• Updating the Process Chain status in the portal.
• Developed complex reports using query designer and reported through web and Bex analyzer.
• Sending Effort estimates for the new change requests.
• Transport repackaging during go live time.
• Development of objects like info cubes, DSO's, SPO's and Open hubs.
• Experience in transporting objects from Development to Production.
• Handling CRs for enhancing the process chains, data flows and queries.
• Resolved the reporting related defects and coordinated with the users.
• Handled post cutover and pre cutover release management activities.

Projects Executed

Confidential

Contribution:

• Monitoring tickets
• Working on incidents raised by Production and Preproduction monitoring teams.
• Ad hoc activities.
• Service pack implementation
• Outage bundle activities
• Housekeeping
• COPA and GD Realignments
• Extra COPA load
• Costing
• Execution of requests raised to offshore
• Setup table filling
• Flat file loading
• Aggregates deactivation and rebuilding.
• Selective deletion from specified targets.
• Weekend activities
• Sending status mail
• Follow up and technical support
• Proposing resources for weekend activities
• Communication
• During import all Prod and Pre-Prod , assist with PMA's Pre-Manual and Post-Manual Actions
• Providing technical support to resources in addition to Production and Pre-Production monitoring teams for the problems in data load monitoring.
• Reviewing tickets before resolving and reassigning.

Confidential

Responsibilities:

• Involved as part of the tech spec preparation activities.
• Developer role for creating various objects in SAP BW.
• Participated in the FUT TUT and worked on the bug fixes.
• Actively involved in the pre cutover and post cutover activities.
• Provided an excellent Hyper care support after go live.
• Created the technical specifications from the functional specs received.
• Writing Test Scripts, conducting Unit Testing and documenting the results.
• Resolved the reporting related defects and coordinated with the users.
• Created the process chains for automate the data loads.
• Transferred various Queries from Business Content.
• Involved in developing different type of objects like Basic cube, Real time Cube, DSO, Multi provider, Info set, DTP of type Standard, Direct Access, Error DTP and Info packages.
• Used Restricted Calculated Key figures.
• Created start, end and filed level routines for customized logics.
• Scheduled and monitored periodic data loads from R/3 to BW.
• Involved in Installing and Customizing the Business Content Objects.
• Created aggregates to improve the query response.
• Effective and smooth transition to the support team after hyper care support.

Confidential

• Description : Applied Materials, Inc. has planned to implement SAP BI which includes 50 of Customization and 50 Standard contents. The aim of the project is to provide accurate, timely, and actionable information to key decision makers. The Business Transformation project will result in the definition of new reports, key performance indicators KPIs and metrics to support ongoing business operations.
• Responsibilities:
• Development of objects like info cubes, DSO's, SPO's and Open hubs.
• Transport repackaging during go live time.
• Sending Effort estimates for the new change requests.
• Developed complex reports using query designer and reported through web and Bex analyzer.

Confidential

Responsibilities

• Customizing requirements and preparing the blueprint in SD Module.
• Installed Business Content Data sources and Business Content Objects.
• Identifying the subtasks like BI Content Installation, Modeling, filling setup tables, loading data from Data source to PSA, PSA to staging layer, staging layer to final reporting layer.
• Worked on Standard Infoproviders and Customized Infoproviders.
• Created Process Chains for all data loads.
• Testing of business content queries. Creation of customized queries, testing them and finalized with the designated users of the queries.