PROFESSIONAL SUMMARY:

• Senior technology expert with 12+ years of Dynamic SAP experience in delivering cost - efficient and leading-edge solution using SAP Native HANA as Data Mart, Data Base, Platform.
• Experience in information and data architecture, system upgrades, requirement analysis, solution design, enhancements, implementation and support models.
• Deploying and Designing SAP Solutions using ASAP, Agile Methodology and LSA++ Architecture.
• End to End SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes.
• Publishing HANA Model in SAP BW, Import SAP Net Weaver BW Model to HANA.
• Script based calculation views creation for different complex requirements.
• Adept at SAP HANA data modeling using Attribute View, Analytical View and Calculation view.
• Developed Stored Procedures, Used Joins and Table functions, Table Types and Views.
• Replication of data to HANA from both SAP and non-SAP Systems using Flow graphs, SLT, BODS.
• Created, Importing, and Exporting SAP Native HANA Data Models
• Responsible for analyzing data loads, DTP behavior and scope for notes in HANA Parallel scenario to compare production systems with HDB and DB2 in Parallel.
• Experience in SQL trouble shooting and performance tuning.
• Created Native HANA modeling scenarios and activities such as adding system, creating schemas, content models, attributes and measures.
• Migrated the developed Native HANA models cross the system landscape from Dev to QA etc.
• Migrated HAWK models to Hana by using Script based Calculating views.
• Techno Functional expertise in implementing SAP HANA, BI/BW (BI-ABAP (ETL) BW-ABAP (ETL)), SD, MM, PS, HR, WM and FI-CO (GL, AR, AP and Assets).
• Success fully delivered 6 full life cycle implementations (including SAP BI 7.4 edition for HANA) from blue-print to Go-Live.
• Proficient in Requirement Gathering (from process design owners, Business Groups, power Users and End users), Business Blueprint (Identifying Reports, Gap Analysis, Enhancements), Realization (Design and Deployment of BI objects) and Post Production Support.
• Expertise in OLTP extractions from SAP ECC using LO Cockpit, FI CO-PA and Generic Extractions.
• Enhancement of DataSources using User Exits and BADI as per the business requirements.
• Basic understanding of ETL tools like Informatica.
• Extracted data from Salesforce and created models, worked on Hana integrating with Mule soft.
• Extensive experience in Business Objects Client tools; Crystal reports, WEBI, Analysis, BO Explorer.
• Proficient in Business Objects (BOBJ) - SAP BI Integration and BO Admin activities
• Developed and modified Dashboards using Xcelsius and Design Studio and Crystal reports.
• Designed, developed and deployed using BI 4.1 Tools like BI Launch Pad, Web Intelligence Rich Client and Central Management Console (CMC) & BO Analysis
• Created data models for Tableau reports and dashboards.

TECHNICAL SKILLS:

Languages: ABAP/4, C++, PL/SQL, Java Script.

Operating Systems: XP/ 7,2000,2008,2012, DOS.

Data Base: Oracle 7x, SQL 2005/ 2008, HANA.

ERP: SAP EHP 7, EHP6, ECC6.0, ECC4.7 B& C.

ETL Tools: BW3.5/BI SAP BW3.x/7.x/ 7.3.7.4.

Reporting Tools: BOXI 3.1/3.2/4.0, Xcelsius/Dashboard builderCrystal report, SAP BEX Analyzer, WEBI, Analysis.

WORK EXPERIENCE:

Confidential

SAP BW HANA Developer

Responsibilities

• Gathered Business requirements and created Business requirement document and respective FSD, TSD based on BRD.
• Developed end-to-end solution and create Balance Sheet and detail P & L Statements report by joining Bank Analyzer and Banking Services data and created respective SQL script based and graphical Calculation views
• Developed End to end solution for PM Schedule Compliance, PM's Overdue, and Corrective using SQL Script based Calculation views created a mixed model.
• Designed and implemented SAP HANA data modeling in HANA Studio using Calculation Views (Graphical and SQL Script base).
• Expert in resolving transport issues, process chain failures, data load errors.
• Verified, proposed and Implemented SAP notes for different application and DB issues.
• Created Hana Script based calculation views for HAWK data base procedures and implemented the same logic to optimize the performance.
• Created Hana Script based calculation views for TABLEAU & BOBJ for point calculation project by extracting data from different sources.
• Created Bookings vs Opportunity Hana Script based calculation views to compart Bookings vs Opportunity on sales force data.
• Created Analytical privileges and SQL Analytical privileges for different Calculation views as per the requirement.
• Replicated Master and Transaction data from different systems like SAP and NON SAP using SLT and SDI

Confidential, Kansas

SAP HANA Senior Consultant

Responsibilities

• Gathered Business requirements and created Business requirement document and respective FSD, TSD based on BRD.
• Developed Customer Master reports by combining data from different views PTM Services data and created respective SQL script based and graphical Calculation views
• SAP HANA Live rapid-deployment solution to support faster, easier analysis of operational data on in-memory platform.
• Created Calculation views for Sales Reports Daily, Weekly, Hourly, Monthly and yearly with underlying Hadoop data using Flow graphs.
• Created Events, Folders and Connections, Users, recursion and Groups in CMC for BOBJ Framework.
• Data replication from S4Hana using SLT based table Data Provisioning and performed operations like, Load, Replicate, Stop, Suspend and Resume as part of Data Provisioning.
• Replicated Master and Transaction data from different systems like SAP and NON SAP using SLT and SDI
• Created Procedures to updated Hana tables which will be used by other systems for data population.

Environment: SAP S4 HANA, HANA Live SD, MM, Simple Finance 1.0, BOBJ 4.2 BW4 Hana

Confidential, California

SAP HANA Senior Consultant

Responsibilities

• Designing and developing the functional specification as well as Technical specification document based on the Document for both Native HANA and BO Requirements.
• Responsible for blueprinting, requirement gathering, design, strategy and eventually the build Of Dashboards for all departments with initial ETL Extractors and routines.
• Worked on Post go live production support in monitoring data loads, fixing and improving performance of load issues and investigating in finding root cause for data issues and worked extensively on support tickets.
• Created Sales Forecasting Reports for Marketing Department in BEX by Extracting date from LO Extractors from SAP.
• Developed GTS Daily and monthly reports for Material import and export as per business requirement.
• Developed End to End ETL in BW for Finance reports for Department Fixed cost and Cost Centre in BEX.
• Developed BEX Queries with ABAP variables using filters, Navigational attributes, Restricted Key figures, Calculated Key figures.
• Extracted data from legacy system to HANA database using Data services.
• Developing many Generic Extractors using Function Modules and Views for POC use by Analysts.
• Enhanced Standard Extractors using User-Exit and BADI with BW ABAP or BI ABAP coding.
• Data Providing solutions for various scenarios on loading/replication of data to HANA from both SAP and non-SAP Systems using SLT, SDA, Flow graphs.
• Developed advanced SQL Script Stored procedures for integrating SAP and non-SAP data into Unified Native HANA Model.
• Performed activities for BW on Native HANA implementation and optimized BW modeling objects as per the need for BW on HANA.
• Developed Bex Queries, Reports for SD/LO, MM, SCM, PP, FICO, SCM. Also created End to End Data flows by installing standard content and enhanced Extractors with ABAP.

Environment: SAP BI 7.31 on Hana, SAP S4 HANA, HANA SP12/8, Simple Finance 1.0, EHP7 SD, PM, QM, FI, HR.

Confidential

SAP Analytics Consultant

Responsibilities:

• Involved in Full cycle Implementation of Integrating the functional areas MM, SD and FI/CO with BI BW. Responsible for Design of data models, comparing the model with delivered contents and implementing the business logic with delivered contents along with modifications.
• Good functional knowledge of Sales & Distribution (Sales Orders, Deliveries & Billing), MM (Purchasing), FI and general business process of SAP R/3.
• Activated Sales and Distribution, Purchase Info cubes and DSO objects from the Business content and customized according to business needs.
• Performed statistical setup for purchase, Sales, Billing and Shipment and extracted the data to BI.
• Customized Lo Cockpit data source to include custom defined fields and populated those fields using customer exits before the setup.
• Worked on CRM-Sales, Marketing Analysis, Account Plan, Lead Management, Opportunity Management, Activity Management and Interaction Center verticals BW Reports for different Departments.
• Created complete data flow from SD, CRM which includes extractors, Infoproviders, Transformations, DTP’s and Process Chains for BEX Queries which intern populate WEBI Reports for Xcelsius Dashboards.
• Worked on Extractors 0CRM SALES ACT 1, 0CRM LEAD H, 0CRM LEAD I, 0CRM OPPT H, 0CRM OPPT I, 0CRM ACCPLN ATTR, 0CRM SALES ORDER I using BW ABAP or BI ABAP.
• Worked with the data source 0BPARTNER HIER to load Account Hierarchy data into 0BPARTNER and involved in extracting the Marketing attributes data using the data source 0CRM MKTATTR ATTR.
• Enhanced the extractor 0CRM SALES ACT 1 to pull the ‘Activity Completion Date’ and ‘Account Plan ID’.
• Used LO extract structures for extracting sales order, delivery-billing information.
• Extended standard Business Contents using ABAP User Exit, BADI and Function Module enhancement.
• Created and scheduled BW InfoPackages for Full, Delta Initialization, and Delta updates to load both master and transaction data. Created BI process chains to automate the data load and data target administration.
• Created and delivered BEX reports like Region-wise Sales, HR Manpower Actual, Plan and Customer Rebate.
• Extensively optimized Xcelsius Dashboards performance and created Dashboards for Management use.
• Created Reports in BO/BOBJ Analysis to for Business user Market analysis with underlying BEX Queries.
• Created and Enhanced Extractions for BPC for reporting related requirement.
• Created Month wise Quarter wise BO reports in WEBI with underlying BEX Queries.
• Handled postproduction support and development of new design cycles simultaneously.
• Created several Calculated Key figures, Restricted Key Figures, structures and variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements.
• Extensively involved in transporting objects from Development to Quality and then moved to Production.

Environment: SAP BI 7.0, BO3.2, SAP ECC 6, CRM, SD, MM and FI modules, Windows 2000/NT.

Confidential

SENIOR SAP BW BO CONSULTANT

Responsibilities:

• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed Bex reporting specifications.
• Thorough understanding of the Functional specifications and outstanding issues related to specifications.
• Frequent meeting with the functional team to resolve the outstanding issues and regular updating of functional specifications.
• Responsible for developing High level Data flow and revising the Gap Analysis.
• Worked on BI ABAP extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Developed basic BW cubes for Premium’s, Claim’s, and Sales data for BEX Queries.
• Dynamic file names creation in INFOPACKAGE using abap to access files from Applicant server.
• Created abap Routine to replace special characters with blank space characters in an Info Object.
• Enhanced the BW Data sources with fields which are not part of source table using BADI and abap Exits.
• Extensively optimized BO Dashboard performance by modifying Bex queries and Cubes.
• Monitoring Process chains in BI daily weekly. Yearly plan data gather from end users and upload accordingly.
• Created several Calculated Key figures, Restricted Key Figures, structures and variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements.
• Enhanced BPC Extractors with business requirement to optimize schema load.
• Used LO extract structures for extracting sales order, delivery-billing information.
• Activated SD, MM, FI flows in RSA7 and RSA5 and schedule respective jobs in SAP.

Environment: SAP BI 7.0, BO4.0, SAP ECC 6, CRM, SD, MM and FI modules, Windows 2000/NT.

Confidential

SAP BW CONSULTANT

Responsibilities:

• Review and analyze functional design given by functional consultant.
• Client interaction and feasibility of the developments.
• Develop and review of technical design document for the purpose of BI development.
• Work with team members to develop new programs in BEX to fulfill specific business process requirement.
• Installing Bex Queries and Reports from business content as per requirement.
• Created and modified routines & User exits using ABAP as per BI/BW Requirement.
• Monitoring Process chains in BI/BW Daily weekly and yearly and load Plan data as required.
• Installed BW standard Data Sources as per requirement from Business content.
• Created and Modified BW Routines & User Exits using abap programming language.
• Created generic Data Sources with fields which are not part of source table till Process chain.
• Created Process chains for Master and Transaction data.
• Created Customer wise Quarter wise Sales order Report in BEX.
• Created several Calculated Key figures, Restricted Key Figures, structures and variables to enhance the reporting features. Implemented conditions and restrictions in the reports based on the requirements.
• Business Contents modification using ABAP User Exit, BADI and Function Module enhancement

Confidential

SAP BW/BW-ABAP CONSULTANT

Responsibilities:

• Responsible and managed maintenance and support activities within the SAP BW system and SAP ECC.
• Responsible for develop BW ABAP custom enhancement and new developments from different Modules.
• Daily involved in production data load monitoring from SAP and Non SAP Systems and debug the issues.
• 24/7 production call support as Client business spread across different continents especially USA and UK.
• Created Process Chain in SAP BW, which deletes the PSA Data based on the Retention Periods.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• 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.
• Resolving the issues that occur during the Loads based on Severity Level.
• 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.
• Enhanced Standard Data sources using ABAP User Exit, BADI and Function Module enhancement
• Extensively worked on BEX Reports designer to develop formatted reports and web reports.
• Involved in unit testing and code testing for developments done by subordinates or teammates.
• Created Generic Data sources or Extractors for different modules as standards not required and tailored tables in DDIC.
• Transport the objects from Development to QA for testing.

Environment: SAP BW3.5, SAP R/3 4.6C/4.7, ABAP/4, FI/CO modules, Windows 2000/NT.