SUMMARY

• Total IT experience 10 Years 2 Months in SAP BI in Data Extractions, Reporting, and Modeling and focused on Implementations, Support Maintenance and expertise in Performance Tuning.
• Proficient with SAP HANA and SAP BW on HANA.
• Experience in 4 full life cycle implementations including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Training Documentation and end user training.
• Experience on Change Management process involving Test plan, Change Plan, Test Scripts, Unit Testing, Integration Testing SIT and User Acceptance Testing UAT .
• Created and maintained Info Objects, Data Sources, Info Sources, Info Cubes, ODS objects, Communication structures, Transfer structures, PSA, Business content Transfer rules, Update rules, Info packages, Process Chains and Scheduling the data requests.
• Expertise in complete life cycle implementation in SAP BI 7.0 module which includes Data Modeling, Data Extraction LIS, LO Cockpit, Generic and Flat File extraction , Data Loading Full /Delta Up-Load , Scheduling, Monitoring, Report generation and Production Support.
• Extensively involved in setting up the procedures for LO Cockpit, involved in Activating the Business Content Data Sources, Maintaining the Extract Structures, generating the Data Sources, Activating the Data Sources, Enhancing the Data Source by using the Enhancement RSAP0001 to fill the data into the Enhanced Fields.
• Involved as a team member in BEx Reports and worked extensively on Bex Analyzer in building Queries for Decision making using Formulas, Selections, Calculated Key Figures, Restricted Key Figure and User Variables with User Entry Default Value and RRI Report to Report Interface .
• Involved in changing the Existing Data Model of an Infocube by adding new Characteristics and Keyfigures. Involved in Re-Intialization of Data Source from SAP R/3.
• Performance tuning using Aggregates, Rollups, Cube Compression, Index Maintenance and Partitioning to achieve best possible performance.
• Worked on Business Objects BO 4.1 using Web Intelligence directly on Bex Queries, Experience using Universe Designer, and BW OLAP Universes.
• Involved in the initial design, development of standard Info Cube and ODS Object which involves interaction with SD, MM, QM, POSDM, IS - Retail, PP, FI-CO and SCM APO PPDS SNP .
• As part of Quality management standards to deliver the objects in quality performed Unit testing and recorded the test results in unit test cases documents.
• Excellent experience in activating enhancing the standard Datasources with structural changes User Exits with ABAP coding, Extracted Data from Flat files DB Connect source systems for legacy data.
• Hands-on experience in ABAP in building Routines, also Enhanced Data Source using advanced ABAP Technique BADI

TECHNICAL SKILLS

Data warehouse: SAP BW 3.5, SAP BI 7.0, SAP BI 7.3, SAP HANA, SAP BO

ERP: SAP R/3 4.7 ECC 6.0

Databases: MSSQL 2008, ORACLE 7.x, MS Access

Languages: Java, C, C , ABAP/4

Management and Project Tools: MS Word, Excel, Project, Visio and Access, SAP Solution Manager

Operating Systems: MS-DOS, MS Windows 9X, 2000, XP.

Projects

Confidential

Roles and Responsibilities:

As Sr. SAP BW/BO/HANA consultant

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Development, Testing, User Training, Go-live.
• Understood the business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Had discussion with functional team and created business blue print and data flow diagrams.
• Converted the Functional Specifications to Technical Specification.
• Worked on COPA Extraction and converted key figure based CO-PA model to account based CO-PA model.
• After completion of SAP BI configuration based on SAP BI as source creating Webi reports on top of BI queries and placing all this reports in corporate dashboard and presenting these dashboards through info view to the management.
• Worked on converting the non-cumulative key figures to cumulative key figures model for the inventory management to improve the reporting performance.
• Migration of the SAP BW objects in HANA optimized objects like DSO and Infocube
• Designing the HANA Information Models like Attribute Views, Analytical Views and Calculation Views.
• Experience with different types of joins and cardinality.
• Experience with the SAP BW system on the top of SAP HANA data base, WEBi Reports on the top of HANA models
• Some Important dashboards developed on KPIs are Financial Salvage reports, Inventory Turn Analysis, Shrink reports and analyzed in three dimensions Clubs, Regions, Zones.

Confidential

Roles and Responsibilities:

As Sr. SAP BW/BO consultant I was:

• Involved in BPC product implementation in conjunction with SAP Business Warehouse where Excel pivot table reporting is required.
• Involved in the requirement gathering for Data ware house Environment for FI and CO applications.
• Had discussion with functional team and created business blue print and data flow diagrams.
• I have been part of BPC project and working closely with the business team in development of the functional specs.
• Designed functional specification and technical specifications as per the business requirement.
• Worked on Creating Universe using Information design tool by using SAP BI as a Data source and developed Dashboards and deploy them in BI launch pad.
• High performance KPI dashboards have been created for Decision Support System.
• Involved in creation of Unit test script templates and executed of those scripts and ensured there are no gaps between functional and technical aspects.
• Worked on BI objects for GL, AP and CO-PA and MS-SQL to load the data from BI system to SQL using SSIS
• During the testing phases took up more responsibilities in all the activities related to defects resolution and coordinating with the BPC development team and focusing on solution and working towards the closure of the defects.

Confidential

Roles and Responsibilities:

As Sr. SAP BW-BPC/BO consultant I was:

• Involved in the requirement gathering for P F Environment and validation tool.
• I have been part of BPC project and working closely with the process team and Deloitte on-site team in development of the P F specs.
• Involved in the end to end SAP BI-BO implementation project which includes giving SAP BI-BO Demos to Client and Identifying the KPIs by taking requirements from the management.
• Mapping KPIs with Standard SAP business content and doing GAP analysis.
• Preparing business blueprint based on the clients requirement, based on it designing, modeling and identifying the standard cubes and queries and customizing the data sources.
• After completion of SAP BI configuration based on SAP BI as source creating Universes on top of BI queries and developing the BO dashboards, WEBI reports and placing all this reports in corporate dashboard and presenting these dashboards through info view to the management.
• During the SIT phases took up more responsibilities in all the activities related to defects resolution and coordinating with the CR team / DGBI team and BPC development team and focusing on solution and working towards the closure of the defects.
• Participated in BPC P F knowledge sharing session with BACI team
• Working closely with Deloitte on-site / process team on comm. log items and getting the right requirements for BOR release.
• Had discussion with functional team and created business blue print and data flow diagrams.
• Designed functional specification and technical specifications as per the P F environment and validation tool requirements
• Involved in helping the team members to create custom objects and review objects for the validation tool requirements.
• Created various validation reports between BW systems and BPC system
• Worked on various Basis activities like import of transport request, short dump analysis, memory utilization and jobs related activities.
• Involved in creation of Unit test script templates and executed of those scripts and ensured there are no gaps between functional and technical aspects.
• Involved in FUT and SIT testing cycles and resolved the defect during the testing phases.
• Involved in cut over activities for two releases during the business go-live

Confidential

Roles and Responsibilities:

As Business Analyst consultant I was:

• Responsible for conducting workshops, requirement documentation, design and configuration of Sales Order process OTC and configuration changes in Logistics and Execution.
• Involved in the requirement gathering for floor care, production planning supply network planning,
• Instrumental in preparation of Blue print and data flow diagrams.
• Designed Functional and Technical Design according the Project Requirements.
• Involved in activating SAP Business Content objects and prepared custom objects where necessary.
• Developed Custom BI Queries like SIOP, actual VS planned production quantities reports as per Customer Specific requirements.
• Involved in show and tell of BI reports to the end users.
• Involved in preparing the test scripts, designs and test execution in HPQC testing tool.
• Involved in product test by running the test scripts.
• Client Liaison Documentation, Internal and External presentations.
• Technical mentor to team members.
• Understanding and ensuring implementation of quality standards QMS

Confidential

Roles and Responsibilities:

As SAP BW consultant I was:

• Responsible for stabilization of the BI system.
• Worked on roles and authorizations in SAP BI.
• Creation of queries based on business requirements.
• Building the custom objects like DSOs, Cubes and multi providers according to the specification of the Functional documents.
• Worked on Unit testing and maintain the Unit testing documents and Technical design specifications.
• Monitor and Support Troubleshooting of Existing Data loads by using Process Chains.
• Monitoring process chain and query performance.
• Involved in Init set up for SD related data in R/3 side.
• Experienced in Process chains creation, Created Process chains for Master data loading and transaction data loading.
• Worked on system generated tickets and customer generated tickets as per the priorities.
• Fixed the Data load errors and interacting with onsite people to speed up the error correction.

Confidential

Roles and Responsibilities:

As SAP BW consultant I was:

• Involved in OOTD activities.
• Involved in archiving the ODS objects using SARA t-code.
• Involved in monitoring of daily process chains, weekly chains and monthly chains.
• Involved in production requests by loading customer requested flat files.
• Involved in change requests by changing the existing data models like process chains and reports
• Involved in solving the customer posted tickets with in the SLA's.
• Involved in maintaining the documents and excel files like MoM, way of working documents, query cook books, work instruction documents and status update sheets.

Confidential

Roles and Responsibilities:

As SAP BW consultant, I was:

• As a BI developer involved in development activities of the project.
• Involved in creation of FD's, TD's based on Business requirements of the client and designing the template for Unit testing.
• Building the objects according to the specification of the Functional documents.
• Maintained Data Sources, transformations and Info Packages for Data Targets in BI 7.0.
• Created custom DSO's and cubes for the specific requirements of the client.
• Involved in extraction of data by customizing predefined extract structures LO Cockpit , generating Data Sources, Update mode as Queued delta and setting up of V3 Update and created generic data sources.
• Involved in data source enhancements and activation of master data in ECC 6.0.

Confidential

Roles and Responsibilities:

As SAP BW Consultant, I was responsible for:

• As a BW developer involved in development activities of the project.
• Building the objects according to the specification of the Design Document.
• Designing Templates for Unit Testing and TDS.
• Writing the Technical specification from functional specification Unit test documents and getting it revived by the client.
• Created custom ODS for the specific requirements for the delta loads to be uploaded to cubes.
• Extensively involved in creation and maintenance of Update rules, transfer rules as per client requirements.
• Created financial Multi cube in order to obtain the desired result.
• Extensively used Process Chains for master and transaction loads.
• Created a Meta Chain for all the sub process chains for a smooth run.
• Involved in Go live environment for 4 countries including the monitoring activities for the process chains.