SUMMARY

• Certified SAP HANA Application Associate with near to 7 years of experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications. Rich experience in entailing planning, scheduling, negotiations with the client for service level agreements / terms, project progress monitoring and delivery as per quality, time and budgetary norms.
• Adept in creating & testing end - to-end Scenarios in SAP BI/BW, SAP HANA, SAP BOE & BODS following SDLC Methodologies and an eclectic approach utilizing Analytics & interpretation to specific industry scenarios to complete the project based work.
• Insightful knowledge of business process analysis (As-Is, To-Be) and design, application based process reengineering, process optimization, cost control & revenue maximization from SAP HANA system solutions using cutting edge technologies.
• Deftness in understanding business process, study and analyzing workflow to design solutions (To-Be, Why-why Analysis and Freezing); preparing the detailed process flow for functional requirements. Demonstrated excellence in integration with other modules, integration & user acceptance testing & extending post go-live support, including training support to end-users. A focused leader with polished communication skills and expert analytical, relationship management and coordination skills.

TECHNICAL SKILLS

• Supply Chain Analytics, Order to Cash, Procure to Pay, Manufacturing Analytics & Management Reseller Sales/Service Process.
• SAP NetWeaver Business Warehousing 7.0, 7.01, 7.02, 7.3, BW 7.3, BW 7.4 SP6 on HANA DB and Native.
• SAP Business Objects BI 4.0 - WebI/Interactive Analysis, Live Office, Dashboards, Lumira, SAP Business objects design studio, Analysis edition for office, Analysis edition for OLAP.
• BusinessObjects Data Services 3.2, 4.0 mySAP CRM 5.0, 6.0, 7.0 Analytics
• Analytics with SAP ECC 6.0 - MM, PP/PI, SD, PM, QM, CS, PS, FI, CO mySAP SRM Reporting (Classic/Extended Scenario)
• SAP Business One 8.8 OEM - Subsidiary Reporting - B1isn
• Analytics with SAP BW ESA/SOA extraction with SAP Process Integration 7.1, and Non SAP Systems

PROFESSIONAL EXPERIENCE

Confidential

Architect

Environment: SAP HANA 1.0 SPS07, SAP BODS 4.1, SAP BOBJ BI 4.0, SAP SLT Replication over SAP ECC.

Responsibilities:

• Worked closely with the business understanding the Business requirements & defining the Business Blueprint.
• Gather the Business requirements; translate the Business requirements into KPI's.
• Importing the metadata using Data Provisioning Tools like SAP Landscape Transformation and Data Services.
• Configuring, designing and modelling in SAP Landscape Transformation (SLT) and importing the metadata to HANA and subsequently created calculation views for real time reporting.
• Modelling in SAP Data services to ensure the data to be in compliance with quality standards and importing the tables from Oracle, SQL, HADOOP (For Big Data Analytics) to SAP HANA. Also, extracted the LO data sources from ECC using Operational Data Provisioning (ODP) for Sales and Purchasing scenarios and made it available in HANA for modelling and reporting.
• Creation and management of schema - Run Time Objects and package - Design Time Objects.
• Working on the design of SAP BW HANA modeling and optimization scenarios including Hybrid scenarios. Creation of information models in packages like Attribute Views, Analytic Views, Calculation Views, Analytic Privileges and Procedures.
• Involved in assisting and guiding for performing the Back-up and recovery activities of HANA landscape using Backint interface to Third party tools like IBM Tivoli Storage Manager for Enterprise 6.4.
• Assigning SAP HANA Package Privileges to users to control the access for information.
• Importing and Exporting of Delivery Units across landscape.
• Consuming column views created for respective information models (Analytic View, Calculation View) under SYS BIC schema in Information design Tool (IDT) for building the Business Layer subsequently publishing to Central Management Server (CMS).
• Consuming universes created in IDT for Web Intelligence 4.0, Dashboard designer, Advanced Analysis Tools (Analysis Edition for Office and Analysis Edition for OLAP) and Business objects explorer.

Confidential

Architect

Environment: SAP HANA 1.0 SPS07, SAP BODS 4.0

Responsibilities:

• The responsibilities involve designing the technical design documents from functional design and the user requirements.
• Requirement collection from clients and functional consultants for reports. Perform analysis and design; write technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.
• Integration of BW & APO DP.
• Creation of Standard & Generic extractors (Table, Function module) for extraction from ECC in order for the planning relevant materials to be made available in APO DP. Also involved in loading the data from APO DP to SAP ECC for generating the Product Level 1 forecast.
• Creation of custom ABAP interface for users to upload file into APO system. Also involved in creating ALV report in BW which will help the user to view the data and load the same to APO DP after the validation.
• Created Transient Providers via Analytic Index to consume Analytic views and Calculation views from SAP HANA for mixed scenarios.
• Created Composite Provider to combine BW Infoproviders with Transient Providers for Supply chain reporting scenarios.
• Creation of SPO (Semantically Partitioned Object) with DSOs and cubes for partition based on different time zones.
• Design complex, custom BW solutions or component objects translating complex requirements into an optimal BW design.
• Develop and drive the implementation of BW best practices and standards for the team.
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, Extractors, Process Chains.
• Created File paths for outbound interfaces and created scheduling jobs for outbound file generation to the Middleware.
• Created Open hub destination for outbound interface from the BW system and modified the existing program to place the file generated from the open hub tables to the created file path.
• Created virtual providers and multiproviders and identified the infoobjects from various targets to meet the reporting requirements.
• Created BEx queries with restricted keyfigures, calculated keyfigures, formulas and variables and maintained them with correct query property settings for better performance.
• Created RRI (Report report interface) to provide jump-to report functionality from summary report built on Dimensional layer to Flexible layer in the BW architecture.
• Designed and developed process chains for transactional data loads, data archiving, automated program execution and selective deletion of data from DSOs and Cubes.
• Involved in transporting the BW objects from development system to QA for unit testing and integration testing.

Confidential

DataServices SME

Environment: Cransoft, 1SAP, GSAP, DataServices 3.2, 4.0

Responsibilities:

• Review of the Functional Specification documents for information on requirements.
• Transition call with the FS Owners regarding issues in Functional Specification document.
• Preparation of Technical Specification document based on the Functional Specification
• Prepared mapping documents capturing all the rules from the business.
• Created Data Integrator mappings to load the data into flat files, the mappings involved extensive use of simple and complex transformations like SQL Query Transform, Case, Validation, Merge, Pivot, Reverse pivot, lookup etc in Data flows.
• Creating Scripts, Jobs, Workflows, Data Flows and Executing jobs with Data Integrator Designer.
• Doing support and fixing the issues raised by the jobs while running in Data String Test and Mock test using HPQC.
• Tuned Data Integrator Mappings and Transformations for the better performance of jobs.
• Preparation of Test data for design, logic verification and uploading Test cases to HPQC.

Confidential

Senior SAP Consultant

Environment: SAP BI 7.1, SAP ECC 6.0, BO XI R2, Xcelsius 2008

Responsibilities:

• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Interacted with Business Users, Business owners to know their requirements in developing the ETL in SAP DataServices, Universes and WebI Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for BusinessObjects Business Intelligence solutions.
• Configured and installed SAP Business Objects Data Services and Job Server on client systems.
• Created Data Integrator mappings to load the data into flat files, the mappings involved extensive use of simple and complex transformations like SQL Query Transform, Case, Validation, Merge, lookup etc in Data flows.
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Customized the list of values (LOV’s) which helps the end users to select the values.
• Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically
• Created reports using Web Intelligence in BO XI R2 environment.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web XI R2.
• Imported WebI documents, connections, universes and restrictions to BO XI production environment using Import Wizard.
• Published and scheduled Business Objects Reports to users.
• Created WSDLs using Query As a Web Service (Qaaws) from different Data sources.
• Created Xcelsius dashboard for CIF value Analysis, License Utilization, Duty Value calculations for the business function
• Requirement collection from clients and functional consultants for reports. Perform analysis and design; write technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.
• Design complex, custom BW solutions or component objects translating complex requirements into an optimal BW design.
• Develop and drive the implementation of BW best practices and standards for the team.
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains, User Exits, BADI.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Involved in developing front-end queries using Query Designer and Web Application Designer and publishing results on the web.
• Involved in transporting the BW objects from development system to QA for unit testing and integration testing.
• Managed and monitored several data loads, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Created BEx Reports and Workbooks.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.
• Designed and developed process chains for master data loads and transactional data. And these process chains are scheduled for periodically.
• Created several Calculated Key figures, Restricted Key Figures, structures, variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements. Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters and free characteristics. Designed and provided RRI reporting.

Confidential

Senior SAP Consultant

Environment: SAP BODS 3.1, SAP BOE XI 3.1

Responsibilities:

• Performed source data assessment and identified the quality and consistency of the source data.
• Prepared data extract from SAP ERP, CRM, DB2, SQL database C reated mappings using Designer and designed jobs to build DW as per business rules.
• Expertise in working with various transforms such as SQL, Table comparison, History Preservation, Row Generation, Query, Map Operation, Merge, Look Ups, Pivot, Case etc.
• Responsible for creating/implementing both source and target based CDC using time stamp and history preserving transforms.
• Involved in writing DI scripts and also used some built-in functions like Search Replace, Lookup ext and Custom Functions like Sending Email whenever an exception is raised.
• Responsible for Testing and debugging various ETL jobs.
• Involved in linking Job Servers on different machines to a single repository for load balancing using the Data Integrator Server manager.
• Implemented various performance optimization techniques such as caching, Push-down memory-intensive operations to the database server, etc.
• Implemented Server groups to use advance performance tuning feature such as parallel data flow, dividing dataflow in to sub dataflow and Degree of Parallelism.
• Working with Data Integrator Management Console to deploy and schedule batch jobs as Database Administrator.
• Designed Universes, incorporating all the business requirements.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Created the Web Intelligence Report and scheduled the reports for Daily/Weekly /Monthly.
• Extensively used advanced reporting functionalities such as Data Tracking, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Extensive testing and migrating the reports or objects from development to Production system.
• Installation and configuration of Xcelsius, QaaWS Client Server Modules and designing complex reports and dashboards in monitoring business metrics..

Confidential

SAP BW Consultant

Environment: SAP BI 7.1, ECC 6.0

Responsibilities:

• Involved in performance tuning of queries by compression, clustering of Infocubes.
• Created aggregates for Infocubes to improve query performance.
• Created History cubes for historical data maintenance and data purging of standard cubes.
• Creation and maintenance of Process chains including performance tuning activities.
• Involved in creation of Data Sources, InfoSources and PSA for Data extraction, Transformation and loading to SAP BW.
• Analyzed and configured InfoObjects, InfoCubes, InfoSources and Source Systems.
• Used the generic extractor to load data from R3 side into the data model.
• Used flat file interface to test the calculated data. Extensively used data mart interface to load data from one data target to another data target.
• Used aggregates, changed the design to increase the performance of data loading into the cube.
• Used Rules groups, Transformations, Start routines, End routines which are the new feature with NetWeaver 2004s.
• Used Variables, calculated and restricted key figures, conditions, filters and exception for BEx queries.
• Staged Data into the ODS before transformation.
• Done error reporting.
• Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.