SUMMARY

• Seeking the position of SAP HANA/BI Consultant that offers professional growth to utilize my skills and abilities in SAP Business warehouse and HANA 2.0.
• PMP Certified IT Consultant with over 17 years of work experience in ERP and S/W development; of which 10 years of work experience on SAP.
• Over 10 years of Hands on experience as SAP - BI consultant and 5 years of Hands on experience as HANA consultant involving active participation in analysis, design and development of full life cycle implementations coupled with Production support.
• Hands on Experience on HANA 2.0, SAP-SLT, HANA-SDI, SAP-BODS, SAP-BOBJ,
• Experienced on JDEdwards (Worldsoft) ERP Package and developed various business applications on AS400 platform using ILE RPG, RPG/400, CL/400 and SQL400.
• Functional experience in the areas of Production and Marketing.
• Experience with systems development life cycle (SDLC) and ASAP methodologies
• Excellent communication/interpersonal/analytical/ presentation skills with problem solving abilities.

TECHNICAL SKILLS

Data warehouse: BI7.4, HANA 2.0, SAP-BODS 4.x, HANA-SDI, SAP-BOBJ (XI 4.0)

ERP: SAP-CRM, SAP R/3 (SD), JDEdwards (World Soft)

Languages: ABAP/4, RPG/400, CL/400, SQL/400, ILE RPG

RDBMS: Oracle 8 and SQL Server, DB2-400

Operating Systems: Windows NT 4.0, OS/400

Reporting tools: Business Explorer (BEx) Query Designer, Web Application Designer, BEx Analyzer and BEx Browser, SAP-BOBJ

PROFESSIONAL EXPERIENCE

SAP Hana Developer

Confidential, San Rafael CA.

Environment: HANA 2.0 Web IDE, Web Workbench, SAP ECC, SAP-CRM, SAP-SLT

Responsibilities:

• Redesign of QlikView Dash Boards into Hana views.
• Analyze underlying logic of QlikView dashboard measures and implement the same logic in appropriate Hana views.
• Building new views to implement QTD logic of QlikView.
• Created procedures to persist the data from complex HANA views.
• Replicating huge tables from Source systems and validation of tables and fixing issues.
• Involved in Peer review and validation of models.
• Involved in cut over activities for Pre-Production and Production system.
• Resolving Production issues reported by business.
• Facilitate smooth testing by correlating measure values form Hana view and QlikView dashboard.

SAP BI Consulting Contractor

Confidential

Environment: SAP BI 7.4, SAP BaS, SAP ECC, SAP-CRM, SAP-SLT, HANA 2.0 Web IDE and Web Workbench.

Responsibilities:

• Created complex calculation views using multiple source systems like SAP-CRM, SAP- BaS, SAP-BA, SAP-ECC, SAP-PE.
• Extensively worked on HANA stored procedures, table functions
• Implemented SDA and SDI for real time data transfer.
• Created Flow-graphs and Replication tasks
• Created CDS Artifacts like tables, views and Created dynamic partitions for large tables.
• Performance tuning of HANA views using visualize plan analysis.
• Worked extensively on Hana Modelling using Web IDE and web workbench.
• Well Versed with SLT troubleshooting and Replicated SAP tables with huge data like Payment Items, Payment Notes, CDPOS, CDHDR using SLT.
• Analyzed the HANA views using Visualize Plan to see how many records are flowing for each Node to improve the performance.
• Worked on optimizing HANA views by applying filters at lower level, adding input parameters and aggregating nodes.
• Involved in writing table functions to transpose the row data into columns.
• Experienced in developing end to end data flows in BW and in HANA 2.0 using WEB IDE.
• Creation of Functional specifications from business requirements to design and develop BW/HANA objects.
• Extensively Used SAP ABAP in Start, End & DTP Routines while developing dataflows on SAP BI/BW.
• Handled the operational tickets and maintained the work History for all until it is closed down
• Worked as on-call support team member.
• Prepared estimates for the work assigned and submitting detailed resource plan with milestones for the work to be carried forward.
• Selected and implemented agile development practices according to the application requirements for the release and Prepared estimates for the work assigned.

SAP BI Consultant

Confidential

Environment: SAP BI 7.3, SAP ECC, FI/CO, SRM, SD, MM, Oracle, Windows NT

Responsibilities:

• Extracted Supply Network Planning data from SAP SCM into SAP BI
• Created generic extractors based on table and view in SAP SCM system
• Created Open Hub Destinations to Application Server in Flat structure
• Developed the ABAP Code in Info Package, Start Routines, Field Routines and End Routines
• Created Master Data Info objects, Info Cubes, and DSO’s as per the requirement
• Created Queries on business requirements.
• Extensively used Characteristic, Text and Formula Variables using default, replacement path and customer exit processing types
• Collected and transported all the developments from DEV->TST->PRD of SCM & BW without issues
• Maintained Functional Specification, Design and Technical Specification Documents for future reference.
• Helped business users in creation of test plans with respect to changed functionality and imparted training to support team on the changed functionality

SAP BI Systems Analyst

Confidential

Environment: SAP BI 7.1, SAP ECC, FI/CO, PCA, SD, MM, Oracle, Windows NT

Responsibilities:

• Responsible for requirements analysis, process flows, functional configuration and implementation of new requirements.
• Designed and developed Web Intelligence reports using best practices.
• Created complex BEX reports as source for the BO reporting tools
• Modified and developed new dataflow for the backend development
• Combining data from sales and planning info provider with business logic for analytic cube
• Worked extensively in fixing the UAT issues and closely coordinated with business users to solve the issues.
• Provided customer support on the functional/technical issues encountered in the production system.
• Created BODS-Interfaces to fetch data from Flat files and load Oracle tables.
• Data analysis, modeling, and profiling using SQL Server and Data Services, to provide new and improved structures and aid in data quality checks related to conversion efforts.
• Created transforms, used built-in functions, and written scripts to map source data to target tables.
• Performed source data assessment using Data quality & data profiler transforms and validate data by validation transform.
• Set up datastores to connect the source system: database, flat file and excel file.
• Used validation rules to populate messages for mandatory columns.

SAP BW Consultant

Confidential

Environment: SAP BW 3.5, SAP R/3 4.6B, FI/CO, PCA, SD, MM, Oracle, Windows NT

Responsibilities:

• Understanding in existing ABAP logic’s for issue resolution and able to perform the customer exit ABAP
• Designed the Process Chains for job scheduling for all the new developments and adjusted the existing one where necessary
• Created Customer exits, Formula variables, Characteristic variables, Text variables, Hierarchy and Hierarchy Node variables as part of the deliverables
• Created Hierarchies and managed them by direct input & by flat files
• Created customized data sources and designed the flow and Involved in developing the tools to check all the query properties, Query Usage, Variables used
• Created data loading steps, estimates and DB size estimations documents and also estimated effort sheets for the created Change requests
• Extensively involved in enhancing the Data sources, DSO and Cubes
• Participated in Fit- Gap analysis, workshops and KT sessions to users and support team
• Involved in user training for the new reports

SAP BW Consultant

Confidential

Environment: SAP BW 7.0, SAP R/3 4.6B, FI/CO, SD Oracle, Windows NT

Responsibilities:

• Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Monitoring of Process chains and analyzing the reasons for failures of Extractions.
• Maintaining Reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Dealt with custom extracts, DSO, custom data sources, user exits, BEX queries, hierarchies, workbook macros, Web Application Designer and Bex analyzer.
• Involved in extracting non-sap data by creating Generic Extractors using Function Module and view
• Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data. Used jump queries, Restricted Key Figures, Calculated Key Figures, Conditions, Variables, Structures, exceptions and navigational attributes in BEx to facilitate data analysis in a drill down or summarized way to give detailed levels of information.