SUMMARY

• SAP BI 7.0 and HANA Certified consultant has over 14 years of experience in SAP experience in Implementation, Support, Upgradation and SAP application development, ETL process, data modeling, reports, web application development and Dashboard designing.
• Experienced in two Full life cycle Implementations, Support and Upgrading BW 7.0 to BW 7.3 and HANA Implementation, BO and ABAP.
• Highly motivated, energetic, individual and a team player with good communication and interpersonal skills
• Excellent communication skills, systematic approach and ability to work effectively in fast paced environments Interpersonal, managerial skills and self - motivated to work independently and as well as in a team. Good Understanding of both business processes and technical development.
• Experienced in BI7 implementations and Integrated planning (IP), WAD and knowledge on BIA,BO/BOXI and BPC.
• Knowledge on Lumera.
• Experienced in BW 7.30 on HANA with Analysis Office 1.3
• Expert in analysis, design and delivery of complex business requirements to support BI analytics for both batch and real-time data using SAP HANA.
• Extensive SAP experience with SD, SCM, PM, PP and FI/CO Modules.
• Expert in optimizing HANA views for best performance to reduce data latency, memory consumption and enhance report performance.
• Strong experience in modeling HANA views, data provisioning using SLT and BODS, user management, setting up security by assigning analytical privileges both static and dynamic, migrating HANA artifacts across the landscape.
• Worked on multiple projects with end to end solution including Business Requirements, Data Modeling, Data Architecture, Application Design, Infrastructure Planning, Project Management, Prototyping, ETL Design, Reporting Architecture, Development and maintenance.
• Good Experience on Universes, Infoview, Live Office, WebI, QAAWS and Xcelsius Dashboards using Business Objects Enterprise.
• Extensive experience in SAP BI 7.4/7.3/7.0//3.5/3.1 configuration, OLTP Extraction and Reporting.
• Worked on BW upgrade from 3.5 to 7.0 as well as 7.3 include Web templates and BEx Reports.
• Worked extensively on CRM, BPC, CO-PA, FI, LO Cockpit and Generic data Extractions
• Expertise in designing SAP BW interface requirements with both R/3 source systems as well as Non R/3 source systems in modeling of InfoCubes, Info sources.
• Worked extensively on performance tuning, BW Statistics, Indexes, Data Marts, process chains, Error handling in subsequent processing, Business content installation, data cleansing in PSA, Error handling is using PSA, Multi-Cubes, Query development, RRI and Documentation.
• Worked on reports using BEx Query Designer, BEx Analyzer and Web Application Designer.
• Created and enhanced Data Sources using database views, InfoSets, and function modules. Hands on ABAP coding on extractions.
• Experienced in ABAP programming techniques including Reporting, Dialog Programming, ALE, SAP Script and user exits.
• Excellent technical, business, communication and time management skills.

TECHNICAL SKILLS

HANA Skills: Working experience on HANA modeling studio, Publishing BW models into HANA studio, set up ETL process and data loading to HANA tables, table creation, Importing flat files data to HANA, experience in creating attribute view, Analytical view and Calculation view, Calculation measures, transporting, Knowledge on HANA SQL scripting, procedures, schema creation, SLT configuration, data services and DXC.

SAP BW Skills: DSO, Cube, Info object creation, Transformation and Data loading into BI system (Flat file &R/3), Master data loading from Flat File, Transaction Data Loading from Flat File to Info cube and DSO Configuration, Business content Extractors, Logistics Extraction, Generic Extraction, Enhancing Standard Data Sources, Open Hub Destination, Reporting Performances, Line-Item dimension, High cordiality dimension, Process chain monitoring, data transfer processes, Query Design: Defining Exceptions, Conditions, Restricted and Calculated Key Figures, various types Variables, query Properties, Converting Cube and DSO to In memory optimized, Semantic partitions, composite provider.

BODS Skills: Repository creation, flat files, configuring data store, data flow, Query transform various transforms, debugging and data base loading, transformations, scripting, delta handling (source, time stamp and target based CDC), various recovery mechanisms, implemented push down operations and performance optimization.

PROFESSIONAL EXPERIENCE

Confidential

Consultant

Responsibilities:

• Requirement gathering & requirement analysis.
• Manual Testing of interfaces between SAP ECC, POS - POSDTA, E2E & Regression testing with other downstream and upstream applications
• Responsible for Test plan creation and Test design analyzing the requirements
• Test execution based on the Test plan devised
• Gathered requirements from client and assisted client functional team in understanding reporting needs of the ERP Integration Project.
• Prepared Functional specs, Technical specs, time lines for blue printing, realization, testing, go-live and cut-over activities.
• Designed HANA Models for OTC and FI-AP/AR/GL business cases.
• Designed and implemented Complex HANA view data Models (Stacked, Cube, Dimension - Calculation views).
• Converted Multiproviders to Composite providers and built the BEx query logic in HANA views.
• Developed Join Composite provider and HANA views for replacing existing Infosets.
• Created SQL Analytic privileges for row level security on HANA views.
• Created restricted columns, calculated columns, Scalar functions, procedures, expressions, Input parameter, Input Variables, Currency conversion, RANK, exception aggregation etc.
• Creation of Table Functions based and HANA CE function based calculation views
• Performance tuning in HANA views.
• Analyzing the issues with various SQL query’s
• Mapping the Input parameters/variables in the SQL scripts and Mapping the Input parameters/variables to BO reports
• Formatting the reports in Calculation views
• Time generation in HANA studio and creation on SQL scripts for calculating time characteristics in HANA views
• Provided best practices and recommend solution for enhancing architecture between SAP BW as well as SAP ECC.
• Programmed several Start routine, end routine and field routines in Transformations at various level to meet business requirements.
• Interacted with business to analyze the requirement and prepare business process design document for client ERP / SAP-BW Integration Project.
• Preparation of QA summary for Go/No Go meetings
• Preparation of daily/weekly status reports to onshore coordinator and client Sponsor
• Creating and updating defects status in JIRA
• Resolved Critical and High priority defects during the Integration Test while UAT.
• Extencevely worked on FERC module.
• Preparation of Technical Design Specification documentation.
• Modeling & development of BW objects like info objects, DSO’s, Infocube’s & Multiprovider.
• BEx Query designing using Query designer which involved creation of Structures, Calculated key figures, restricted key figures, Variables, customer exits etc.
• Development of UDT universes on top of SAP BW BEx queries.
• Development of BO4.0 WEB Intelligence reports which included creation of various types of reports like vertical/Cross-tabs, different types of graphs, Query prompts, Query filters, report filters, input controls, Sections, scheduling, publications, complex formulas, merging different types of source like universes/BEx etc.
• Development of BO4.0 Dashboards on top of webi using BIWS.
• Involved in Unit testing, integration testing, performance tuning of reports & User Acceptance testing.
• Working with TCoE team and Assisted in Performance testing.
• Involved in bug fixes during UAT & Post production stabilization.
• Created User Training materials on BO4.0 webi.
• Working on Data loads optimization and improve the load performance.
• Trained around 80+ Business users on BO4.0 webi like thought them on using webi tool & customization of reports & developing ad-hoc reporting.
• Co-ordination with various teams like Basis, Security, BO Admins, IT team etc.
• Working with Onsite-Offshore team and measure to deliver the things on time.
• Key member in Production support team and handling with Incidents/Work orders /FINANCE On call.

Confidential

Consultant

Responsibilities:

• Leading the offshore BI team of members and responsible for the deliverables in BI.
• Played as Key technical resource in BI and resolved the major technical issues while build, defects and transports.
• Data Modeling: Creation of Info Areas, Info Object Catalogs, Info Objects -Characteristics and Key Figures, ODS, Info Cubes, Multi Providers.
• Transformation and Loading (ETL): Creation of Data Flow, i.e., Transformations andData Transfer Processes, Data sources, Info Sources, Info Packages, Creation ofProcess Chains, Analysis and Resolution of errors arising due to data loads, etc.Management of Data Targets, Maintenance of Process Chains.
• Involved in resolving performance tuning & memory management issues.
• Project Documentation: Project related Documentation such as TechnicalSpecifications, End User Training Documents, cut over plans, etc.
• Monitor the data loads from various source systems like R/3, CRM, and SEM APOby means of process chains.
• Monitoring process chains and scheduling jobs.
• Incident Handling.
• Extensively Worked on SAP BW HANA views.
• Involved in SAP HANA upgrade Testing.

Confidential

Lead Consultant

Responsibilities:

• Played as Key technical resource in BI and resolved the major technical issues while build, defects and transports.
• Involved in Cutover activities and issues fixing during go-live.
• Good Understanding of various components of SAP HANA.
• Performed regression testing and issue fixing during UAT.
• Executing post migration programs related HANA Database.
• Loading data from flat file to HANA system.
• Publishing BW models into HANA modeling studio.
• Designed TDs for the RFCs’ and do peer review of the Objects done by others within the team.
• Attending the high level business meeting for understanding the third party systems like FiT, VOLT etc.
• Identify the non-sap reports for automation.
• Involved in deep drive sessions for requirement gathering with business users.
• Prepared and approved BRDs from Mondelz team.

Confidential

Sr.Consultant

Responsibilities:

• Played as Key technical resource in BI and resolved the major technical issues while build, defects and transports
• Generated BO Web Intelligence reports using BI Launch pad. Involved in testing Universes and Reports.
• Designed Dashboards on top of Web Intelligence reports
• Resolved Critical and High priority defects during the Integration Test while SIT
• Created and used Local selections and Local formulas, Structures in the query build.
• Involved in the business meetings and getting the requirements for legacy systems like CMIS, AGRIES, JDE World, KAW, Sprit wood etc.
• Worked on FTM, Vistex,E-source and Tax Reports.
• Performed regression testing and issue fixing during UAT.
• Extensively worked on Production cutover.