SUMMARY

• Software Professional with 9 years of experience includes two year SAP HANA, 7 years Business Intelligence Tools.
• All aspects of the SAP implementation process from proof of concept development and business process analysis, complete system configuration, testing, end - user and project-team training, and production support.
• I have good functional knowledge in SAP functional modules SD,MM,FI and PP, also includes extensive business process knowledge in areas such as Business intelligence reports development and data modelling, Data loads monitoring and support issues resolution.
• I am expertise in the SAP BI/HANA Modules and development of business intelligence reports Configuration along with a working knowledge of the integration areas including the Business objects and business objects reports development.
• Good knowledge and experience in gap analysis along with suggestions for business process re-engineering to align business processes with SAP best business practices. I have multiple years of project experience in a variety of industries and implementation strategies.
• Created Technical specifications and standard modeling documents for HANA.
• Involved in business and blueprint gathering discussion.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed complex calculation view using SQL and CE-Function.
• Developed data models for the operations, PP, MM, Quality management tables in HANA.
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 HANA 2.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Created Users, Roles, privileges, Packages, schema as part of HANA security and development.
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Developed Webi reports and dashboards for different operations and finance KPI'S like Project planning, quality management, warehouse management, Material management, Global Sustainment, Value management.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool .
• Involved in developing test scripts and assisted UAT on SAP net weaver portal using Test ID's for super users, and end users.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Good knowledge in SAP BW 3.5, BI7.0 and BI7.4 Products and their features.
• Good knowledge in SAP BW Objects leveraging LSA/LSA++ Architecture and SAP BW best practices
• Expertise in BW modelling and development of complex designs.
• Expertise in BW ABAP routines implementation and extractor enhancements.
• Experience in SAP BW Modeling, Extraction and Reporting (BW on HANA as DB and BW on Oracle & DB2 as DB)
• Worked in the Functional area of FICO (GL/AR/AP/CO-PA), MM (Purchasing/ Inventory), SD and HR (HCM).
• Good experience in setup of extraction process from different sources systems SAP & non-SAP.
• Good experience in integrating data migration tools SLT and BODS, to leverage external data in BW reports.
• Good knowledge and experience in development of custom business rules in BW using transformation routines and customer exits.
• Worked on SAP BW components including Extract Structures, Extractors, Data Sources, Transfer rules / Transformations, Info Sources, Update rules/Transformations, Info Objects, ODS (DSO), Info Cubes.
• Expertise in development of new BI data models using ADSO, Composite Provider, Open ODS view, ODP data sources, BW query, HANA transformation.
• Expertise in using BW modelling tools to develop BI advance data models.
• Experience in writing SAP ABAP Routines, Customer Exits and Function Modules in Back End and Front End.
• Extracted data from SAP and non- SAP Source Systems and modeled Process Chains to automate Data loads.
• Experienced in Database Performance Tuning, Data Load Performance Tuning, and Query Performance Tuning by using Partitioning, Indexing, DB Statistics, Data Packet Sizing, Compression and Aggregates.
• Worked on standard and custom defined LO Cockpit, Flat-file and Generic extractors.
• Extensively used BEx Query Designer and BEx Analyzer to build Queries and Workbooks.
• Development of interactive WAD reports.
• Created Dashboard using Web Application Designer, Report Designer.
• Implementation experience in various BI7.0 Projects.
• Good Knowledge in BI 7.0 data modelling, ABAP routines, enhancements.
• Data extraction knowledge and acquired good experience in writing enhancement programs in ECC and BI.
• Good experience in Bex report development using Bex query designer and WAD.
• Process chains development and troubleshooting skills.
• Transporting of BI objects across system landscape and troubleshooting skills.

TECHNICAL SKILLS

ERP: SAP R/ 3 4.7, ECC 6.0 and S/4 Hana

Data warehousing: SAP BW 3.5, BI 7.0 /7.3/ 7.4 / 7.5 , SAP HANA 1.0 / 2.0, SAP BODS

Databases: Oracle, SAP HANA 1.0 /2.0

Reporting: SAP Business Objects BI Launch pad, WEBI, Dashboards.

Testing: HP Quality Center

Functional: SD, MM, COPA, SPM

PROFESSIONAL EXPERIENCE

Confidential, Ohio, Dublin

SAP HANA Development & Configuration Lead

Environment: HANA 2..3 SP10, SD, MM, AR, AP,GL, ECC 6.0, BEx, Web application designer, Business Objects XI, GCP, terradat

Responsibilities:

• HANA Database development experience (schemas, database tables, database views; SLT data replication concepts)
• HANA Modeling experience (calculation view development, performance analysis and optimization; SQLScript; Stored Procedures; Security concepts)
• Managing HANA transports using HALM/CTS+
• Overall lead for HANA, Business Objects and Google Cloud change management using CTS+, BO code migration and GitHub for GCP
• HANA 2.0+ experience
• Good communication and coordination skills to manage, lead and execute the change control and transport management handling multiple onshore teams like Developers, Testing teams, security team, cutover team and senior management
• Handling testing teams during project delivery timelines to handle multiple changes and overall change control
• Managing and leading the HANA go live cutover tasks as a single point of contact

Confidential, Dallas Texas

HANA Modeler

Environment: HANA 1.0 SP5, SAP BI 7.3, SD, MM, AR, AP,GL, ECC 6.0, BEx, Web application designer, Business Objects XI .

Responsibilities:

• Developed business model and reports, include Purchase Order Analysis, Goods Movement Analysis, Invoice Analysis, and Order History Overview.
• Created Attribute views, Analytical views and Calculation Views using database tables. Created calculated measures, restricted measures and columns, input parameters to satisfy reporting requirements.
• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements using SAP HANA studio.
• Created Attribute views, Analytical views and Calculation views. Created SQL script for calculation views in order to address complex business requirements of extracting purchase orders information with respect to invoiced amounts, delivered amounts based on the PO history category type and debit/credit indicator.
• Extracted the information of down payments and net ordered amount for every purchased order line item that was not deleted. Involved in data loading using BODS from flat files to SAP HANA DB.
• Used Information Design Tool IDT to create Relational Connection, Data Foundation and Business Layer and publish these connections and layers to SAP BO Repository.
• Created reports with appropriate filters and prompts for user inputs by connecting to SAP Business Objects Explorer. Involved in Accessing Analytic and calculation views from Business Objects Analysis via ODBC connection BOBJ Integration . Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
• Imported data through flat files into SAP HANA and created schema and required tables.
• Used Information design tool to create connections to SAPHANA databases, Create data foundations, Create Business Layer and publish these connections and layers to the SAP BO repository.

Confidential

SAP BI-HANA Consultant

Environment: SAP HANA, SAP ECC 6.0, SAP BI 7.4, Business Objects

Responsibilities:

• Created various use cases and related data models in HANA for Sales and distribution, Finance, MM
• Created ADSO, Open ODS views, Composite providers and new features of BW 7.5
• Converted Enterprise Data Management based Schema views such as Analytical/Attribute views to Calculations views.
• The EDM layer sources data to several applications such as PPS, TBM and BW.
• Delivered Reports for Trade analytics which pulls the information from Sales Incentives logs, Sales Rebates logs, Claim logs and COPA. These reports explain in detail information of the overall Trade process for all the IP Documents created.
• Developed Sales View by Billing and Delivery KPIs that gives a comprehensive understanding of the Sales Orders with respective to the Billing and Delivery status.
• These reports are built with standard structure as well as adhoc basis to give feasibility for the Business to view sales order at different granularity.
• Has extensively involved in Migrating BW 7.3 to BW 7.5
• Created various use cases and related data models in HANA for Sales and distribution, Finance, COPA and Material management including Inventory.
• Created complex Calculations views with lot of customization to deliver the KPIs specific to each functional area.
• Involved in Blue print design and Functional and Technical specs development.
• Created various Views like Analytic, Attribute and Calculated and Analytic privileges.
• Leveraged the features like calculated columns and restricted columns to perform various operations to finalize the data models.
• Integrated BW Imported DSOs to use them as Analytical views to combine them in different calculated views to suit to the data model.

Confidential

Sr. SAP BI/BW Consultant

Environment: SAP HANA, SAP ECC 6.0, SAP BI 7.4, Business Objects

Responsibilities:

• Worked and handled Change requests.
• Involved in development phase, testing phase with high responsibility and technically validating the changes.
• Developed Info objects, Data store objects, Data source, Process chains
• Developed transformations, Data sources, Info packages and Data transfer processes.
• Developed master data and transactional process chains
• Developed Data Targets, ODS, Multi cubes, aggregates and create Transfer rules, update rules, Data sources and
• Involved in handling Daily and Weekly calls.

Confidential

Sr. SAP BI/BW Consultant

Environment: SAP HANA, SAP ECC 6.0, SAP BI 7.0, Business Objects

Responsibilities:

• Worked extensively on Data warehouse workbench (RSA1) and customized Info Objects, Info Cubes, DSOs, Data Source, DTP’s, Transformations, and MultiProviders.
• Activated Standard data sources of SD & MM application areas.
• Extensively worked on LO Cockpit and performing necessary procedures like setting up of Update Mode, deleting set up tables, filling up of set up tables and loaded the data from SAP ECC to SAP BI and used Initialization update and delta update. Extracted data using LO-Cockpit Data sources from R/3 like 2LIS 11 VAHDR (Sales Order Header data)
• Created Custom Info Objects, DSO, DTP’s and Info Cube - Sales data.
• Scheduled DTP for loading Transactional Data from PSA to Info Provider using process chains.
• Actively involved in monitoring the data transfer from source system into PSA with the help of Info package.
• Extensively worked on DTP’s, Transformations, Info Packages and PSA.
• Enhancement of Data Sources.
• Created and scheduled the Error DTP to handle the error records in the Error Stack.
• Implemented BI Statistics and involved in performance tuning of Queries by maintaining Aggregates, Compression, Partition and indexing of Info cubes.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Involved in submitting the Ticket Status (Open/Close)
• Involved in performing Production Support Activities.
• Involved in maintaining lot of documentation for all the Support activities.

Confidential, Atlanta

SAP BW/BI Consultant

Environment: SAP ECC 6.0, SAP BI 7.0

Responsibilities:

• Involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions
• Extensively involved in modifying the mappings that generated after migration from 3x to 7x BI
• Fixed errors related to transformations.
• Complete migration of 3x dataflow to 7x.
• Used latest features of SAP BI 7.3 like data flows, Semantic Partitioned Objects and Optimized info cubes and DSOs.
• Create Query and process chain log documents.
• Created and maintenance of Info Objects, DSO, Cubes, Transformations, DTPs, Data Sources.
• Developed Custom Generic Data Sources through Views
• Worked with Early Watch Reports for improving the loading and Query Performance
• Extensively worked with FSCM end to end Testing using HP QC
• Interacted with Client very frequently understanding the requirement for creating various type of reports
• Worked with Performance related issues like Aggregates, Partitioning and Compression
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages
• Developed load strategy and created process chains to schedule the loads on daily, weekly and monthly
• Created and maintained queries in BEx Query Designer and BEx Web Application Designer for analysis and web reporting respectively which are published in Enterprise Portal
• Developed Custom Generic Data Sources through Views
• Involved in escalating prioritized tickets regarding extractions, performance issues and load failures. Analyzed and corrected production problems as they occur in the SAP BI
• Successfully scheduled repair full loads for master data attributes and master data texts whenever new attributes or texts enhanced.
• Fine tuning of the performance issues by handling the indexes, aggregates and compression
• Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork
• Attending day by day meetings like Internal Review Meeting, Quality status and Client Review Meetings.
• Interaction with users to resolve BW reporting issues
• Enhancement of Data source
• Installed Business Content Objects when required
• Changes made to existing reports as per requirements of users
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly Data Loads using Process Chains
• In case of data load failures, involved in analyzing the errors, and took corrective actions
• PSA Data Deletion on weekly and monthly basis
• Involved in submitting the Ticket Status (Open/Close) report
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets
• Extensively worked on modeling SAP BW objects like Info Objects, Info Cube, ODS, Info Source, Transfer Rule, Update Rules, Multi Provider.