PROFESSIONAL SUMMARY:

• 12+ Years of software development experience in SAP Native HANA/SLT/BODS/BW/ABAP/Tableau.
• Around 4 years of experience in SAP Native HANA (Modeling/Performance Tuning/SQL).
• Around 4 years of experience in SLT and BODS(Config/Replication/Monitoring/Transformations).
• Around 8 years of experience in SAP ABAP and BW.
• Involved in all the phases of the project like Gathering Business requirements, User meetings, Analyzing the Business process, Implementation, Designing, Preparation of Technical specs, Configuration, Customization, Unit/Integration testing, Go - live and Post-go-live support.
• Worked on 3 Hana Implementation projects.
• Expertise in SAP Hana Modelling.
• Migrated Attribute, Analytical Views to Calculation Views.
• Proficient in Variables, Input parameters, Calculated columns, Filter expressions, Input Parameter mappings with procedures.
• Good hands on experience in Procedures, Table Functions and Hana SQL.
• Worked on HANA Cloud Platform (HCP) and On-premise environments.
• Created Input Parameters and applied filter expressions at DB level and replacing Variables with Input Parameters.
• Usage Left-Outer-joins/Referential Joins, maintain cardinality and Join Properties.
• Handled complex transformations and complex logics in BODS.
• Creation of Calculated columns at top level node of the Logical View.
• Handled complex logics in Table Function where graphical modeling is not supported.
• Table partitions and Table Re-distribution with admins co-ordination.
• Expertise in Performance Tuning of HANA models by implementing all the Best practices.
• Configured SAP ECC and CRM systems to HANA
• Configured ECC and CRM table settings and applied Event/Field related rules in LTRS
• Replicating/Drop/Suspend and monitoring the tables in LTRC
• Created complex Jobs, Work Flows, Data Flows, and Scripts using various Transforms (Integrator, Quality and Platform) to successfully load data from multiple sources into a desired target.
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting
• Extensively worked on Data Source Enhancement using Customer Exit (FMs and Classes) and Badi (Multiple Implementations).
• Worked Routines (Start, Field, End and Expert routines). Ability to identify the suitable routine based on the scenario.
• Expertise in design and development of Generic Data Source Extraction using Table, View, and Info set Query, Domain and Function Module with Full and Delta functionality.
• Extensively worked on Customer Exit Variables using Customer Exit (Dynamic FM, Dynamic class and Dynamic Subroutines approaches) and Enhancement Spot/New Badi (Multiple Implementations).
• Migration of Customer Exit to BABDI’s.
• Expertise in Info Package and DTP routines, Debugging, Performance tuning of various objects, Code reviews and designed the documents for best practices in BW environment.
• Extensive experience in BI Architecture, Extended Star-Schema, Multi- Dimensional Modeling, Data Flow Strategy, Defining Dimensions, InfoCubes, Composite Providers, Hybrid InfoProviders, Virtual Providers, Advanced Datastore Objects, Open DSO, SAP HANA-optimized DSOs, SAP HANA-optimized Infocubes, MultiProviders, Symantic Partition Objects (SPOs), InfoSets, DataSources, InfoSources, InfoObjects, PSA and DSOs.
• Expertise in designing, developing, configuring, installing SAP BW objects DataSources, InfoSources, InfoObjects, ODS/DSO, InfoCubes, MultiProviders, InfoSets, InfoSpokes / Open Hub destinations, APDs, Transfer Rules, Update Rules, Transformations, Start / End / Expert Routines, DTPs, InfoPackages, Process Chains and Activation & enhancing the business content.
• Experience in activating standard business content, extending and enhancing InfoCubes according to the requirements, Datasource enhancements, User Exit Variables (CMOD), Virtual Key Figures and Start Routines.
• Extensive experience in designing and developing Extractors, Tables, Views, Extract Structures, Function Modules in SAP ECC/CRM and legacy systems.
• Solid experience in Data Modeling, Extraction, Cleansing, Loading, Scheduling, Monitoring, Delta Management and Reporting.
• Characteristic relations, Data slice, planning functions, planning sequence, FOX coding
• Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, R/RI, Ad-hoc Queries and Web application designer, Web Items.
• xtensive experience in support, Data Loads, Validation and Troubleshooting of Transaction and Master Data, Change Management, Transport Management, Roles & Security, System Checks, Performance Tuning and Process Chains.
• Tables, Data Elements, Views, Domains, Search Help, Lock Objects, Table Maintenance Generator.
• Extensive experience creates and using Internal Tables.
• Subroutines, Function Modules, Macros, INCLUDE Programs
• BAPI’s, ALES’s, IDOC’s
• BDC (Call Transaction/Session Methods), File Handling, LSMW (Using BAPI/IDOC)

PROFESSIONAL EXPERINCE:

Confidential

Senior HANA Developer

Environment: Hana 2.0(SP2), SLT, BODS 4.2

Responsibilities:

• Replicated 175 CRM tables to HANA system using SLT in DEV, QA and Production systems.
• Developed HANA Models for Service Orders, Service Request, Service order quotations, Service Confirmation and billing request for Tableau reports.
• Developed HANA foundation Models for Service Contract Quotations, Service Contracts, Service Agreements, Service Plans, Service Plan Simulation and pool contracts for user tableau reports
• Developed HANA Models for Complaints and returns and in-house repairs for user tableau reports.
• Developed HANA Models for Service Operations-Billing-documents, billing requests, billing due list items and service Monitor for tableau reports.
• Success factors will send data to shared drive everyday midnight by using scripts.
• From Share drive, BODS job will post data into oracle tables (around 70 tables)
• From Oracle tables data loads to HANA system through BODS
• The following HANA models created for User Tableau Reports
• Student Completion Status
• Student Component Master
• Student Curriculum Master
• Student Enroll Seat
• Student Master Data
• Student Org Master
• ISU
• Developed data foundation for Hyperion Buffer and Demand planning user upload the forecast data for Accessories, Instruments, SYSKAD and Systems
• Developed data foundation for inventory projection data.
• Developed HANA Simulator Model for Confidential Surgery System.
• Load SFDC Account, Install Base and Contact data to HANA system using BODS for creating Simulator Models.

Confidential

HANA Developer

Environment: Hana 2.0, SLT, BODS 4.2

Responsibilities:

• Developed HANA Models for Confidential Statistical and Safety Reports.
• Developed Multiple HANA Models, Procedures and Table function using Maintenance Plan, Task List, Operations, Functional Locations, Schedules, Calls, Work Order data.
• Worked on AMBBS Asset Management for Gas and Electricity.
• Create custom HANA SQL and stored procedures.
• Assist in creating transports, maintain change list, move views from one environment to other environment using HALM.
• Worked on SAP-PM extractors 2LIS 17 I3OPER, 2LIS 18 I3OPER, 2LIS 17 NOTIF and 2LIS 8 NOTIF
• 0UC MTR DOC, 0UC BILLORD

Confidential

HANA Developer

Environment: HANA SPS08

Responsibilities:

• Technical Upgrade of the existing SAP ECC system to the latest release and database migration from the existing database to SAP HANA.
• Technical Upgrade of the existing SAP CRM system to the latest release and database migration from the existing database to SAP HANA.
• Closely worked with BASIS team pre-and post-upgrade for successful deployment.
• Created multiple landscapes and tested before go-live.
• Applied several notes after post upgradation to avoid the dumps.
• Created multiple calculation views graphical modes and SQL scripted models.
• Prepared pre and post upgrade checklists.
• Closely worked with CRM users after post go-live.

Confidential

Sr. SAP BW Consultant

Environment: SAP BW 7.5

Responsibilities:

• Involved in designing Functional specs and writing technical specs.
• Requirement gathering and gap analysis.
• Implemented LSA (layered scalable architecture) for data historical data retention
• Designed the technical document for the entire solution.
• Used DTP routines, filters and OLAP variables for loading current and previous week data.
• Involved in preparing test data for the solution for testers.
• Created process chains for master data and transaction data.
• Collected transports for the entire solution.
• Involved in the cut-over activities for loading data in quality.
• Used DSO look-ups at start routine and end routine.
• Created Bex Reports for Business objects universe.
• Created structures and variables for the reports.
• Involved in integration testing and reconciliation testing for the entire data set.
• Involved in fixing defects raised by the business users.

Confidential

Senior Software Engineer

Environment: SAP BW 7.5

Responsibilities:

• Created planning queries on top of aggregation level
• Created planning sequence, planning filter, planning functions using RSPLAN
• Define locking mechanism using data slices.
• On top of retile planning queries, created the Microsoft office work books
• Extensively worked with FOX coding

Confidential, Huston, TX

Senior Consultant

Environment: SAP BW 7.2

Responsibilities:

• Worked as a SAP BI/BW/BO consultant for utility project.
• Involved in support tickets analysis and assign tickets to relevant team member as priority.
• Worked on issues as a support team member in order to resolve the tickets in different modules SD, PM and FI-CO
• Contribute and provide extensive support to team members where ABAP coding required.
• Worked on SAP BO report issues and provide my support in BO to my team members.
• Create OLAP connections to SAP BW using BICS connections.
• Create WEBI reports on SAP BW Bex queries.
• Prepared the resolution documents, test scripts and update the FS and TS documents.
• Worked on move the transports from development to quality and production systems without fails and check the dependent objects.
• Monitoring the daily scheduled jobs and clear the failed process chains in production.
• Prepare and update the daily status to onsite team members.

Confidential

Senior Consultant

Environment: SAP BW 7.2

Responsibilities:

• Involved in designing Functional specs and writing technical specs ISU(Electricity)
• Requirement gathering and gap analysis
• Implemented LSA (layered scalable architecture) for data historical data retention
• Designed the technical document for the entire solution
• Used DTP routines, filters, and OLAP variables for loading current and previous week data
• Created unit test document for the entire solution
• Involved in preparing in test data for the solution for testers
• Involved in writing start, end routines and filed level routines for fetching the data according to the requirement
• Created process chains for master data and transaction data
• Collected transports for the entire solution
• Enhanced data sources for according to the gap analysis
• Involved in the cut-over activities for loading data in quality
• Maintained manual configuration of master data
• Used DSO look-ups at start routine and end routine
• Created Bex Reports for Business objects universe
• Created structures and variables for the reports
• Used BADI’s for data source enhancement and front-end variables

Confidential

Senior Consultant

Environment: SAP BW 7.2

Responsibilities:

• Implemented in newer SAP version 7.4
• Involved in modeling the standard DSO’s, Direct update DSO, Basic info cube.
• Designed Reports in query designer using CKF, RKF, Formula, variables.
• Extracted transaction and Master Data from ECC and Flat files.
• Retraction data from BPC to BW for various modules like SD, Finance and project systems by using APD tool
• Create the Data source using Function Modules
• Developed the Hierarchy files by using ABAP program
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
• Used Direct Update DSO in the process of APD (Analysis Process Designer).
• Used Write-Optimized DSO (Data Store Object) to load data into BI system.