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 experience as SAP - BI/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 Confidential (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), Confidential (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 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.
• Created procedures to persist the data from complex HANA views.
• Created virtual tables using SDA connection to read the master data virtually.
• Involved in validation of models.
• Involved in cut over activities for Pre-Production and Production system.
• 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
• Conducted the workshop for requirement gathering and designed the SAP APO BI data flow
• 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 BODS Developer

Confidential

Environment: SAP BO Data Integration Designer XI 3.2, Oracle, Flat File System, Windows NT

Responsibilities:

• 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.
• Configured SAP BW/Application datastore to connect SAP BW/ECC data
• Set up RFC server in both BODS and BW sides, created infosource and open Hub in BW side.
• Created Fact & Dimension tables and written scripts and using functions for transforms.
• Used interactive debugger, setting up of error handling and audit to ensure correct data transformation.
• Completed the transforming and loading of Fact & Dimension tables to the target.

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.

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.

SAP BW Consultant

Confidential

Environment: SAP Netweaver 2004S BI-7.0, SAP R/3 4.6B, FI/CO, SD, Windows NT

Responsibilities:

• Enhancement of SD data sources 2LIS 13 VDITM, 2LIS 12 VCITM and 2LIS 11 VASTI.
• Broadcasting the SD reports to the customer
• Outbound Billing Item data to other environment.
• Month end and yearend Financial closing support
• Implemented strategy to Migrate 3.x Data Sources to 7.x Data Sources.
• Involved in Migration of all 3.0B Queries to BI 7.0.
• Testing of Frontend and backend functionalities in the new environment.
• Did extensive stability and regression testing of the 3.x front end of BI7.0 (Excel analyzer and Query Designer)
• Did regression testing of the Enterprise portal interface to BI
• Enhanced query performance using BW Statistics, query read modes and aggregates
• Activation of Standard Business Content, Customizing and creating Custom Cubes according to the Functional Requirements.
• Created and Modified Multiproviders, Infocubes, DSOs, InfoObjects and Infosets in order to meet the end user reporting requirements

SAP BW Consultant

Confidential

Environment: SAP Netweaver 2004S BI-7.0, FI/CO, SD Windows NT

Responsibilities:

• Extracted data from SD Module like Order, Delivery and Billing Data sources using LO Cockpit.
• Developed ODS objects to load delivery item Data from the Info source 2LIS 12 VCITM, defined the update rules.
• Scheduled data loads from R/3 to BW and optimized the load performance by adjusting the packet size, data selections and number of Info Packages.
• Extensively used calculated and restricted key figures, structures, variables and conditions for the queries.
• Involved in escalating high-prioritized tickets regarding extractions, performances issues and also load failures.
• Working extensively on the development of Process Chains for Master and Transaction Data and invoking various follow up actions.
• Develop BEx Queries using Free Characteristics, Filters, Calculated Key Figures, Restricted Key Figures, and Variables in BEx Query Designer.
• Create Transports to Transport BI Objects to Quality and Production environments

AS400 Consultant

Confidential

Responsibilities:

• Designing and developing data entry programs for Accounts receivable module
• Sub file programs for master data listing and transaction programs
• Extensively developed interactive user-friendly screen programs including Subfiles to feed data into their Batch processing application.
• Writing functional specifications, technical specifications
• Developed reports making use of AS400- RLU utility.