SUMMARY

• I have 12+ Years of Experience in SAP BI/BO and HANA, Experience in SAP BI 7.x/BO 4.x and HANA 1.x - 3 end to end BW Implementations, 4 BW Production Support Projects,1 migration and upgrade HANA project and 1 native HANA project. Consulting responsibilities included Business process mapping, system Configuration, Integration testing and User training.
• Experienced in every phase of BI/BO project implementation (User requirements analysis, data modeling, objects activation and development in BW, enhancements using user-exits, query design and Implementation, user analysis authorizations, Initial load from source systems, periodic update process chains, go-live user tests, data migration from legacy systems, end-user training and support.
• Worked in SAP BW on HANA Features such as Composite Provider, Transient Provider, Virtual Provider, Workspace, SPO etc.
• Worked in HANA View, Data Replication such as SLT, DXC.Worked in HANA DB migration and PCA.
• Expert in creating reports using Web Intelligence 4.1
• Adv exp creating Dashboards using Xcelsius 2008, Dashboard Designer
• Created Universes on Information Designer Tool (IDT) 4.1
• Worked on Lumira reporting tool.Experience of 1 data base migration to HANA project and 1 native HANA project.
• Collections and Disbursements: Lead the development and implementation of the ( GFSR ) Involved in Project planning, Blue Print, Effort estimations, Requirement Gathering, designing Technical specs by Co-coordinating with Business users and Functional leads, Monitored Project development Design, Build, Testing, Reviews, documentation, Test Plans, Transportation, Cutover Plans, Roles, User training and Resource mgmt .
• Manage projects from project scoping, sizing to implementing and supporting through warranty period. I have worked with project teams in USA,Canada and India to implement a project involving worldwide retirement of complex legacy Finance systems and migrating to new FI systems.
• Lead a Team of SAP BI for Application Support (Procter & Gamble), Continuous Improvement, Planning & Controlling, Resource Mgmt, Handled the CR’s and Production support systems, Handled Internal technical Trainings and 24*t shift plans, for L2 and L3 Teams, Prepared Technical and Production Support / Maintenance documents like design, technical and RCA.
• Extensively worked in DataModelling: Creation and Modification of InfoCubes, ODS/DSO, MultiProviders, Update Rules / Transformations, DTP’s and Process Chains.
• Expertise Reporting BEx: Designed Queries, Workbooks, Filters, Conditions, Structures Calculated/Restricted keyfigures and Customer exit Variables and worked on Formatted reports, Report Designer and Web Application Designer.
• Experienced Extraction Processes in Generic, LO Extractions, WEB Service Data Sources,BODS and Data Source Enhancements.
• Experienced in creating complex BO webi reports, Crystal Reports and dashboards using advanced features.
• Implemented BW/BO 4.o best practice for report optimization.
• Good knowledge on designing dashboards using designing studio connecting to BI HANA.
• Gather requirements for BI queries and reports, ensuring proper usage, quality and security of the information provided.
• Experienced from the functional/business requirements to design and develop BW objects (install standard objects, enhance existing objects, and create custom objects) like info objects, business content, info sources, data targets, transfer rules, update rules, etc.
• Good Knowledge in BW Performance Tuning of Queries by maintaining Aggregates, Compression, Partitions, Data packets Increase, Data packet batch parallel process increment and Proficient in Production Support issues and Error Handling.
• Expertise BI Accelerator tool for improve BI reports .
• Exposure to SAP BASIS, SD, MM,PM,PS, HCM and FI Functional modules and worked in Utilities, Retail and Manufacturing Sectors.
• Participate in new projects from a BW development standpoint to ensure that projects are executed in accordance with SAP Best Practices and also completed on time
• Self learner with thirst for increasing knowledge in New Business and Technical Areas

PROFESSIONAL EXPERIENCE

Sap BI Consultant

Confidential

Responsibilities:

• As a Project Lead in the project streamline the entire process and working on survival guide and management related things Conducted SAP HANA Overview session for the customer & done assessment.
• SAP HANA in-Memory Platform core technology, including architecture, landscape design, installation, upgrades, performance tuning, and system integration.
• Strong experience in solution architect on Native HANA & BW powered by HANA .
• Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, DXC
• Experience of working on HANA projects related to Business Suite on HANA ECC
• Experience in extraction of data from Excel, External data base, SAP BW, SAP ECC, SAP LANDSCAPE TRANSFORMATION (SLT) to HANA Data Base.
• Developed HANA model in hana studio like attribute View, Analysitic view, Calculation view.
• Conduct workshop with business users and get KPI'S requirement and define the reporting layout.
• Developed SQl, Sql Script,Stored Procedures and CE Functions as per business requirement.
• Worked on change management process to move the transport requests into Quality system.
• Experience in Creating and executing Data Service Job in SAP BODS to populate HANA.
• Worked on SAP HANA Extended Application Services.
• Extracted data into HANA DB using SLT for Real-Time Data.
• Translated the Business KPIs into HANA & Define the Reporting Layouts .
• Translated the Business KPIs for Dashboards & Define the dashboard Layouts .
• Translated Functional Specifications into Technical Specifications to team members.
• Created Information models for ECC tables and created variables, calculated columns, restricted columns, Applying filters and worked with input parameters
• Configuring and Monitoring work flows in SAP BODS Management Console.
• Transported objects from dev to QA catalog and content objects using developer mode and delivery unit mode.
• Work with the design team to realize the architecture by providing suggestions on design options.
• Involved preparing GAP analysis.
• Involved in data source migration and created data flow for Masters and data Loaded for Vendor, Customers, Profit Center, Cost Center, GL Accounts, Chart of Accounts, Company Code, Plant (Site Area).
• Written logic in SQL as per the reqirement.
• Involved in taking client requirement for BO reporting on top of HANA.
• Involved in Creating Universe and Web intelligence WEBI reports.
• Exported UNIVERSE and WEBI to CMC.
• Transported UNIVERSE and WEBI to DEV to QA using LCM.
• Ability to translate business requirements into a technical solution
• Created the Attribute view, Analytic views, Calculated views.
• Assigning SAP HANA Package Privileges to user to Control access to information
• Combined HANA view is composite provider using transient provider
• Creating SAP HANA Delivery Units and configuring SAP HANA Information Packages that provisioning data
• Importing Range tracker data Metadata into SAP HANA Database using BODS.
• Created the Attribute view, Analytic views, Calculated views (Graphical and SQL)
• Assigning SAP HANA Package Privileges to user to Control access to information
• Good experience in SQL/PL SQL.
• Combined Two different source data and a analytical index for a flat file using Composite Provider
• Combined HANA view is composite provider using transient provider
• Worked on Installation, Configuration, enhancement and Authorization Assistant of HANA Live business suite and worked on SD,MM,PP,FI Virtual data model and Publish report in Webi, Business Explore and Dashboard designer as per business requirement.
• Created geographic hierarchy by country and region using Lumira reporting tool.
• Created report using Tree map based on Product and region in Lumira report tool.

Confidential

BW Powered by HANA Up gradation and Migration Project

Responsibilities:

• Owner for Application development technical processes. Provide process training to development team.
• Rich experience in all aspects of BI from Architecture, data modeling, Configuration, Information Modeling, Data Extraction, DTP, Data Marts, Custom Extractors/Solutions, Trouble Shooting, Performance Tuning and Administration. Loaded data from ECC 6.0 and 5.0 to SAP BI 7.0 and 7.4 for all modules SD, MM, FI.
• Provide expertise with SAP BI integration technologies and enforce interface standards.
• Weekly development meeting with the team to monitor progress.
• Monitor development defects and provided necessary solutions to defect team.
• Estimate annual development resources, timelines and budget.
• Unicode testing performed.
• Worked on BO 4.0 Dash boards, Design Studio, WEBI, Crystal Enterprise, Analysis for Office.
• Involved in migration from ORACLE DB(GRM) to HANA DB(KAD).
• HP Quality Center (HP QC) used for defects for rising and closing defects.
• HP Service manager(HP SM) used for open and close tickets.
• Object validation and verification in HANA quality system.
• Dual maintenance functional validation and verification of all the changes migrated during dual maintenance window in HANA Development system(KAD) & HANA quality system (KAQ).
• Performed testing production systems loads in the quality system.
• Migrated standard info cubes to HANA optimized info cubes and tested performance of reports with Production data in the quality system.
• Worked on SIT and BAT defects.
• Deleting roles from the user menu as per the power user request.
• Worked on open OSS messages.
• Worked on Cut over activities before go live.
• Prioritizing the tasks assigning to Team members and Coordinating with ABAP and BASIS Teams as part of CR handling.
• Worked on security roles testing for L2,L3,Power user and End users.
• we have used the following tools in our project.

Business Warehouse Accelerator

Confidential

Responsibilities:

• Weekly development meeting with the team to monitor progress.
• As a Team lead Involved in due diligence, Estimations, POC for Portfolio, closely worked with Power user.
• Built a high level and low level detailed design documenting the business content changes that were required to SAP BW Contents (Queries, InfoObjects, InfoSources, InfoCubes) to meet the requirements of business users.
• Gather requirements for BI queries and reports, ensuring proper usage, quality and security of the information provided
• Experienced from the functional/business requirements to design and develop BW objects (install standard objects, enhance existing objects, and create custom objects) like info objects, business content, info sources, data targets, etc.
• Created 4 customized WEBI reports based on the client requirement.
• Worked on Dash boards and crystal reports.
• Extracted data from the SAP R/3(HCM module data ) and PLM system.
• Interacted with application owners to understand the report requirements.
• Worked on Business content for installation of the HCM and Project System applications.
• Created design specs and technical specs.
• Involved in the requirement gathering for CPG.
• Designed DSO’s and Info cubes for CPG Modules.
• Involved in Effort Estimations & Allocated Resources for the development of the same.
• Created and maintained the detailed Project Plans, proactively identified the potential deadline problems before they arise as a critical pitfall.
• Continuously involved in defect tracking, foreseen the issues & promptly acted upon them and escalated when required.
• Involved in analyzing Long running and Repeat failure batch BW jobs and provided permanent fixes for those batch Jobs.
• we have used the following tools in our project.
• Weekly development meeting with the team to monitor progress.
• Monitor development defects. Provide input to drive process improvements as necessary.
• Estimate annual development resources, timelines and budget.
• Approve functional specs and technical designs in shipments.
• Weekly development meeting with the team to monitor progress.
• Monitor development defects. Provide input to drive process improvements as necessary.
• Estimate annual development resources, timelines and budget.
• Provide detailed estimates for projects for design and development. Validate estimates from consultants.
• Weekly development meeting with the team to monitor progress.
• Built a high level and low level detailed design documenting the business content changes that were required to SAP BW Contents (Queries, InfoObjects, InfoSources, InfoCubes) to meet the requirements of business users.
• Analyzed the GFSR Reporting requriments and lead the function & technical design as well as the build and testing of Bex Reports and BO Advanced Analyzer.
• Identified existing and new Info-objects and also worked on the data mappings from ORACLE and other source applications for master and transactional data.
• Developed Infocubes, DSO’s and Multiproviders as per GFSR
• OLTP Extraction from SAP R/3 into BW using Generic datasources from ORACLE Tables and Views.
• Pulled data from the web services using RDA info pack from RCA tool.
• Pulled data from the oracle source system.
• Provided necessary help to SAP Basis people to configure RFC connection between oracle sources to sap systems.
• Created info objects for project requirement.
• Created front end and back end design documents.
• Created custom defined ABAP programs as per the requirement.
• Created custom defined ABAP programs to generate the flat files in the application server as per the customer naming conversation guide lines.
• Created Start routines, end routines and field routines.
• Worked on implementing Flip-switch.
• Worked on roles creation testing for L2,L3,end users and application owner.
• Worked on implementing FMR Responsibility to the GFSR report.
• Hyper care activities performed after go live.
• Prepared L2 KT Documents
• we have used the following tools in our project.

Business Warehouse Accelerator

Confidential

Responsibilities:

• As a team lead, i am often involved in direct client interaction, meetings etc required to solve problems and issues. Work demands quick, logical thinking and good communication skills to close issues within an agreed frame of time (SLA’s-Service Level Agreements).
• Extensively worked in extractions, LO-Cockpit extraction using queue update.
• Repair PSA table.
• HP service manager(HP SM)used for open and close tickets.
• Worked on Data reconciliation according to the client requirement.
• Worked on data load validation and Implemented Error DTP stack.
• Involved in data load monitoring and quality maintenance roll-out (QMR) for different source systems delta queue cleanup activity.
• Involved in flat file Loads from application server, Worked on NGDC Implementation.
• Created secondary index for improves data load performance from ECC tables.
• Created process chains for PSA deletion data.
• Worked on 3.5 and BI7 data marts.
• Deactivated aggregates and roll-up to avoid the duplicate records in cube.
• Created custom defined ABAP programs for init without data transfer as per the current logic.
• Created custom defined ABAP program for dynamic selective deletion on info cube
• Enhanced Dependent objects Cube, ODS, User exit, Extract Structure to capture New field (Authorization Indicator).
• Coded Start routines at Update / Transfer rules, and ABAP routines at Info package selections.
• Extracted data using LO and Worked with Enhancements.
• Performed daily administrative activities such as monitoring, scheduling periodic jobs and background processing.

Confidential

Support Project(Finland)

Responsibilities:

• Having Good client interaction experience.
• Good experience on Control M tool, used to scheduled the BW jobs and R/3 related jobs.
• Involved in daily monitoring.
• Worked on calls and handled P1 tickets with in the SLA.
• Worked on Service Break Plan for BW.
• Worked on full loads and delta loads.
• Worked on failed data marts.
• Worked on transfer exchange rates in Sap BW.
• Monitoring Process chains. If the process chain fails doing the loads manually.
• Involved in flat file Loads from application server.
• Enhanced existed Cubes, Processchains, InfoPackages, Reports, Communication /Transfer Structures as Per Kesko business req.
• Developed Flexible Queries in Bex using Filters, Variables, Calculated key figures and Restricted key figures to facilitate dataAnalysis in a drill down or summarized way to give detailed levels of information,
• Involved in developing complex start routines in controlling the flow of data to the data targets and transfer routines and update

Routines in transforming

Confidential

Responsibilities:

• Developed Custom BW Objects ( Char and Key Fig, Info Objects, ODS and Info Cubes )
• Customized Info Object, Transfer Rules, Communication Structure, Update Rules and enhancements.
• Support to Daily Data Loading, Job Scheduling, Monitoring and Trouble-shooting in case of load failures.
• Involved in GAP analysis and in Project High level design Phase 2.
• Created custom Text Data sources based on naming conventions.
• Set up procedure for extracting Collections and Disbursements R/3 data from LO-Cockpit.
• Assigned Data Sources to the Info Source and updated data targets using update rules.
• Involved in Installing Business Content for Standard Info Objects, Info Sources, and Info Cubes.
• Populated custom Info Cubes by using Generic Extractions from Ztables.
• Extracted Data Sources from SAP R/3 CD using ‘LO’ Extraction and generic extraction.
• Creations of Info source and Info packages for data extraction.
• Worked on various SAP Delivered info cubes like Purchasing Data, Vendor Evaluation etc., for the MM module and used SAP delivered info sources, info objects for populating that cubes.
• Extensively involved performance maintenance like Info cube Compression.
• Configured BEx Queries for Calculated Key figures, Restricted Key Figures and Exception
• Troubleshoot security/authorization related problems using SU53 and ST01.
• Transported the generated roles and profiles using SAP transport management system.
• Created users and maintained user master and established security policies and procedures.
• Monitoring R/3 system with CCMS Monitoring short dumps, system logs,db alerts,SQL traces, Lock entries, and Oracle sessions
• Analyzed Performance Problems using Workload Monitor,ST03, monitor the system hourly using ST02 and ST06