PROFESSIONAL SUMMARY:

• 15+ Years of software development experience in SAP Native HANA/SLT/BODS/BW/ABAP/BOBJ.
• 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.
• Worked on XSA and HDI and GITHUB Repositories.
• 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.
• Understanding the Migration strategy from HANA studio to HANA Web IDE
• Good hands-on experience in XS Advanced and HDI
• Hands on experience in SAP HANA Database development and technologies such as: AMDP's, ADBC, ABAP, HANA CDS, Calculation Views, Tables, synonyms, sequence, triggers, table functions and procedures using SQL/PL SQL scripts
• Change management of HDI objects and Deployment
• Code promotion, Remote branch and Jenkins
• Working knowledge of SAP HANA CDS
• 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 access plan jobs for huge tables calculations
• BODS
• 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.
• Good experience in custom functions
• Hand on experience on profiling, writing data quality rules, developed score cards and match reviews.
• Hands on experience data quality transformation of SCD to maintain the history of dimensional data.
• Good knowledge on data warehousing and database concepts
• Hands on experience in debugging execution errors using data service logs
• Hands on experience on CMC, creating users and assign right roles to users
• Extensively used Data Services Management Console to schedule and execute jobs, manage repositories and perform metadata reporting
• SDI
• Install the Adapters from SDI configurations system settings
• Register the agent server to setup the flowgraphs scheduling’s and tasks
• Creating the replication tasks for replicating the remote tables to HANA DB Tables
• Creating and scheduling the flowgraphs for remote tables transformations.
• 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.
• Modeling - 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.
• Customizations - 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.
• Extensively working on BW on HANA new developments creating HANA models, and Optimized BW modeling objects like Advance DSO, Composite Providers, Open Views etc. Rectifying the alerts on HANA studio.
• Data Modeling (Business Content and Customized BW Objects): Expertise in Installing Business Content and worked extensively on developing complex data flow structures based on multiple source systems, with customizing Info Objects, Info Cubes, DSO layers as staging, DTP, Transformations, BIA Indexes, Complex routines in transformations, Open Hub Service, Process Chains, Info Sets and Multi providers, Virtual Providers, Hybrid Providers.
• SAP BW IP - Characteristic relations, Data slice, planning functions, planning sequence, FOX coding
• BEx Reporting - 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.
• Designed, developed reports and Dashboards using the BO Dashboard designed, Design studio 1.6.
• Extensively worked on the WEBI reports, interrogation reports and Drill down reports.
• Production Support - Extensive 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.
• Data Dictionary
• Tables, Data Elements, Views, Domains, Search Help, Lock Objects, Table Maintenance Generator.
• Extensive experience creates and using Internal Tables.
• Modularization Techniques
• Subroutines, Function Modules, Macros, INCLUDE Programs
• Cross Applications
• BAPI’s, ALES’s, IDOC’s
• Data Transfer Techniques
• BDC (Call Transaction/Session Methods), File Handling, LSMW (Using BAPI/IDOC)
• Excellent hands on experience in ABAP Code Optimization and ABAP performance tuning.

PROFESSIONAL EXPERINCE:

Confidential, Houston, TX

Senior HANA /HANA XS Developer

Environment: Hana 2.0(SP5), BW 7.5/SLT, BODS 4.2, ABAP, SQL, SAP Business Objects 4.2

Responsibilities:

• Experience in providing analytical solutions in Modern Data warehousing concepts by implementing SAP-HANA Advanced Modelling, SAP Native Hana Modelling, SAP HANA 2.0 Web IDE Modelling and SAPBW/4HANA.
• Design and Build Hana objects such as Flow Graph, calculation views, core data services views, table functions and stored procedures for complex calculations.
• Monitor and Optimize performance of HANA objects, Use visualize plan to identify the performance impacting factors in development, quality and staging environments.
• Design and support analytics in different platforms for Costing, Earning volumes platform (EVP) and Datahub.
• Involved in integrating multiple systems (SQL Server, Oracle, HANA, BW) into one big umbrella for major FTP (Financial Transformation Project) Project using HANA tools (Web IDE,XSA SLT, SDI, Flow Graphs etc.)
• Worked on XSA and advanced HDI and cloning objects into GITHUB Repository
• Enablement of Navigational attributes in local composite provides
• Worked on Direct access to any Smart Data Integration (SDI) remote source via Open ODS View
• ABAP-managed Database Procedure (AMDP) available for start, field, and end routines
• Optimizing the models, plan viz and performance tuning.
• Integrated data from different systems SAP, and Non-SAP using SQL Data hub. Migrated objects using the GITHUB.
• Extensive experience in HANA SQL stored procedure (SP’s).
• Worked on SQL performance optimization and scripts.
• Created and maintained the BODS jobs for ATP and ASR projects
• Created the BODS custom functions for goods delivery dates.
• Worked on BODS transformations (Map operations, query’s, table comparison’s etc..) and scheduled the jobs in CMC and JSF’s.
• Extensive experience in creation of JSF jobs and schedule the JSF’s
• Design and develop SAP HANA security models including analytical privileges.
• Design the reports in the SAP HANA analytics space including BI BOBJ (4.2) Enterprise.
• Designed, Built, tested & debugged Hana based XSOdata web services and exposed it.
• Modelled and Created Artifacts- packages, attribute views, analytic views, calculation views, Analytic Privileges, Security, Procedures, Functions, Sequences, Views, Synonyms, Triggers, Decision tables, CE Functions, Attribute Mapping, Constants, and Hana CDS Views to support the application development effort.

Confidential, Sunnyvale, CA

Senior HANA Developer

Environment: SAP BW 7.3/7.5(SP4) Hana 2.0(SP2), SLT, BODS 4.2, SAP Business Objects

Responsibilities:

• Replicated 175 CRM tables to Native 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 Native 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.
• Create new multi-layer reports through Business Objects (SAP BOBI) suite.
• 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
• 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 Da Vinci Surgery System.
• Load SFDC Account, Install Base and Contact data to HANA system using BODS for creating Simulator Models.

Confidential, San Ramon, CA

Native HANA Developer

Environment: SAP BW 7.3/ Hana 1.9, SLT, BODS 4.0

Responsibilities:

• Developed HANA Models for CPUC 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

Native HANA Developer

Environment: HANA 1.0 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 (DataStore Object) to load data into BI system.

Confidential

Senior Consultant

Environment: SAP ABAP-HR

Responsibilities:

• Implement the SAP HR modules Personal Administration (PA), Organizational Management (OM), Payroll (PY), Time management and Travel management.
• Payroll programming using Logical Database
• Worked on Indirect evaluation and Dynamic Actions
• Uploading of data using HR function modules
• Implement the HR ABAP code in PA, OM, and TM Modules using LDB’s
• Creation of custom Infotypes and Enhancements to standard Infotypes
• Developed Classical, Interactive report and ALV reports.
• Developed HR master and cluster Developments Interactive ALV Reports
• Developed few mass data upload programs using BDC’s Session, Call Transaction, and LSMW and
• Developed an Inbound Interface to upload HR Master Data to infotypes like recurring payments/deductions, date specification of employees using transaction code ‘PA30’.
• Worked on different wage types and generate employee tax reports for different countries
• Payroll Calculations,Payroll Schemas, Payroll Areas
• Off-cycle Workbench.
• US Benefits, Enrollment, Plan Categories, Plan Types.
• Wage types, wage type controls

Confidential, Richmond, VA

Analyst Programmer

Environment: SAP ABAP

Responsibilities:

• Involved in writing Batch Data Communication programs for transferring the vendor master legacy data to SAP R/3 system using Batch Input method.
• Designed BDC programs to upload customer master data.
• Developed reports to list Sold-To party and Ship-To party based on sales area Data Conversions & BDC
• Developed BDC Programs to update and change Customer Master Data by Call transaction for transactions XD02 and FD32 to update KNA1 and KNKK tables retrieving from MS Excel Sheet
• Developed ALV reports for purchase orders to compare the ordered quantity with the received quantity.
• Developed an Interactive Report that displays all the sales orders for one particular customer, items for that particular order, quantity ordered, goods issue date, and contact information about that customer.
• Developed reports in SD open sales order that covers all organization levels, delivery status Shipping details and partner function details.
• Using SMART FORMS HR F03 PPFF for the function module FB MIGRATE FORM which migrates all SAP SCRIPT forms automatically.
• Developed an interface using IDOC and ALE to pass out the goods issue data from SAP to the legacy systems
• Set up and monitored the communication links between SAP and other systems using IDOC/ALE for Master Data maintenance and EDI Transactions.
• Worked on up gradation project and upgraded ABAP objects from enterprise 4.7 version to ECC 5.0 version