PROFESSIONAL SUMMARY:

• Certified as SAP Business Information Warehouse (BW 7.0), HANA Consultant with 10 Years of professional experience.
• Certified as SAP ABAP Development consultant.
• Have 10 yrs experience as a BI/BW,HANA, BOBJ and ABAP Technical Consultant with hands on implementation, ongoing support and enhancement activities in the application areas SCM - SAP supply chain process - Inventory Management, Order to cash, Procure to Pay, SRM, FI,SD,MM and CRM.
• Supported sales enablement in the Analytics space with hands on Data modelling using HANA SPS 6 and SPS 9, BW and reporting on BO.
• Experience in interacting with clients to gather requirements and translate into Data mapping document and report wireframe development and delivery.
• Extensive working knowledge for designing and developing of both BW Back-end side and Front-end and HANA back end modelling, HANA XS and reporting on BO.
• Extensively worked on HANA SQL, SQL Script, PL/SQL, Stored Procedures, Function Calls, Designing tables.
• Designed HANA views, Data Flow for ER model.
• Worked on HANA procedures, Variables in SQL.
• Followed the best practices for using SQL scripts
• Worked in BODS extraction from flat files, BW, SAP to HANA system.
• Worked in HANA Data Modeling using Attributes
• Views, Analytic Views and Calculation Views (both Graphical & SQL script based) & HANA Data Provisioning using SAP LT Replication
• Server (SLT).
• Good exposure on Schemas, table definitions, Attributes, Measures &
• Hierarchies in HANA.
• Good Knowledge in HANA security including User Management, Roles and Privileges.
• Good Knowledge in Direct Extractor Connections.
• Loading data into table definitions.
• Actively participated in Code reviews and Data governance Meetings.
• Involved in Development of SRM BI reporting for a Cross Industry Asset. Lead the team in end to end implementation of BI .
• Worked for Confidential POC and lead the team in building the KPI's for the functional areas: Inventory, Transportation, Distribution, Revenue.
• Have knowledge in Scripting and can write routines in ABAP.
• Strong knowledge in SAP BW Administrator workbench, Extraction using Generic, COPA and LO extractors, FI-GL, FI-AR, FI-AP, Modelling, BEX reporting, Production Support environment- Process Chains, Data Loading, Scheduling, Monitoring.
• Have created Functional specifications, Technical specifications, HDD and Test scripts in BW.
• Having knowledge on BO Dashboards, WEBI and Universe.
• Having ability to communicate effectively at all levels of Application Development phases in the Company.
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.
• Quick learner and stronger desire to master in new Technologies.

TECHNICAL SKILLS:

ERP: SAP BW 7.3/7.0, HANA 1.0 SPS 09, ECC 4.7, 6

Languages: ABAP/4, Java 2.0

Databases: SQL Server 2000 - project experience

Tools: & Utilities: Reporting tools: BEX, Business Objects, Microsoft Excel,Microsoft office - Project experience, Microsoft Visio 6.0, PowerPoint

Operating Systems: Windows 95, 98, 2000, XP

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, New Jersey

SAP BW IP, HANA, HANA XS Developer

Responsibilities:

• Created high level design documentation for the back end HANA data model using SPS 9.
• Created Data modeling objects: In HANA( Attribute views, Analytic Views and Calculation Views) Extraction of data using SLT.
• Loaded data into HANA tables
• Worked on HANA procedures, Variables in SQL.
• Followed the best practices for using SQL scripts
• Used HANA best practices and performance tuning.
• Consume HANA models in BW using providers.
• Info Cube, MultiProvider, DSO, Info Objects,Data Marts, Data source, Transformation & DTP, Process Chains for Data loads. Enhanced some Master data Datasources and data flows.
• Developed and Enhanced ABAP logic for transformation routines: Start routines, End routines, transformation routines. Peformance tuning and followed best coding standards.Debugging routines.
• Worked on Transport management. Followed the best practices and transport sequences. Creation of transports, movement to test environment.
• Created meta chains, process chains for BVP PDC: Costs,Compression of cubes, Rollup and back up of cubes, Auto save, etc.
• Developed BW IP planning application: Aggregation level, Planning function, filters, planning sequence, Enhancement of FOX formulas.
• Loaded Master data: Attributes, texts and Hierarchies. Monitored Process chains:Early and daily, Validation of data and Error Diagnosis through debugging of transformation routines.Resolved data load failures, ABAP Debugging, solving the report issues by interacting with the client, trouble shooting.
• Involved in Sprint test 2 and 3.

Environment: SAP BI 7.3, BOBJ 4.0, 4.1, HANA XS, ECC 6

Confidential, Phoenix, Arizona

Sr Developer

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, and Reporting and Testing process.
• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and creation of USERs and ROLES, etc.
• Developed HANA Column based tables and SQL Script Procedures, Loading data into table definitions, suspending data loads, resuming data loads.
• Expert in creation of Attribute Views, Analytical Views and Calculation views Graphical and SQL Script - CE Functions and Stored Procedures.
• Designed and developed reports, Planning templates in BW BEX, and using Design studio.
• Worked on HANA XS environment.

Environment: SAP BI 7.3, BOBJ 4.0, 4.1, HANA SPS 6, ECC 6

Confidential, Connecticut

Architect/ Lead

Responsibilities:

• SAP BI/HANA Team Lead/ Architect in analytics space, working in the Confidential ’s Enterprise Analytics offering within the Resources industry and supported multiple engagements like Confidential.
• SRM BI
• Involved in Development of SRM BI reporting for a Cross Industry Asset. She was leading the end to end implementation of BI .
• Gathered the SRM reports needed and designed the ER model and Dimensional Model.
• Designed and developed the multi dimensional model using attribute views, Analytical views and calculation views using SQL scripting flows
• Loaded data into HANA tables
• Worked on HANA procedures, Variables in SQL.
• Followed the best practices for using SQL scripts
• Reporting using BO WEBI.
• Confidential
• Worked for Confidential POC and lead the team in building the KPI's for the functional areas Inventory, Transportation, Distribution, and Revenue.
• Translated Business and Functional requirements to Data mapping document
• Designed and developed ER model and dimensional Model
• BODS extraction from flat files, SAP System, BW to HANA
• Created high level design documentation for the back end HANA data model.
• Extraction of data using SLT.
• Loaded data into HANA tables
• Worked on HANA procedures, Variables in SQL.
• Followed the best practices for using SQL scripts
• Used HANA best practices and performance tuning.
• Reporting using BO WEBI.
• Confidential
• Being the lead, Gather Requirements from the Client Confidential, Prepare Functional specification Based on the Requirements Gathered from Client.
• Prepare High Level Design Documentation of the BW design, Involved in preparing the Technical specification document . worked on BW on Hana data modelling .Also developed Composite and Hybrid providers to utilize HANA data in BW.
• Designed Back end models in Revenue space in HANA and consumed using Composite providers.
• Created HANA models.
• Reported on the data models using Lumira.

Environment: SAP BI 7.3, Lumira, HANA SPS 6, ECC 6

Confidential, San Diego, CA

Architect

Responsibilities:

• Extraction and Modelling
• Gather Requirements from the Client, Prepare Functional specification Based on the Requirements Gathered from Client.
• Prepare High Level Design Documentation of the HANA design, Involved in preparing the Technical specification document.
• Created SCM (MM, PP, QM) Attribute Views, Analytic Views and Calculation views using SQL scripting for sourcing the reports
• Worked on HANA procedures, Variables in SQL.
• Followed the best practices for using SQL scripts
• Created test scripts and involved in TUT, FUT, SIT and UAT.
• Helped Other Team members in achieving their tasks.
• Reporting:
• Created Multiple Queries on FICO and SCM
• Created reports on BO tools and Lumira.

Environment: SAP HANA 1.0 SPS6, SAP APO, FI, SCM, ECC 6

Confidential, Dallas, Texas

Team Lead

Responsibilities:

• Provide Custom solutions to restrict user’s access by cost center.
• Perform Changes to Existing Report (includes changes to existing user exit)
• Customizing standard BI user exit, so the exit contains a variable which will pass the cost center value that the user is authorized for.
• Prepare Functional specification Based on the Change Requirements Gathered from Client.
• Created custom Table in ECC to Maintain User IDs to Cost Center Mapping
• Create Custom transaction code(s) (T-Code) to Maintain/View Custom Table
• Create a Generic table extractor to load User IDs/Cost center mapping to BW
• Created DSO's, Transformation for loading the Costcenter data.
• Created process chains for regularly loading the User data.
• Monitored the process chain loads.
• Prepare High Level Design Documentation of the BW design.
• Preparing the Technical specification document .
• Developed complex ABAP logic for the Custom User Exit in BW report.
• Created test scripts and involved in TUT, FUT, SIT and UAT.
• Production support.
• Daily Status reporting.

Environment: SAP BI 7.0, ECC 6

Confidential, Charlotte, North Carolina

Module Leader

Responsibilities:

• Review Functional specification and create Communication Log for clarification from client.Preparing the Technical specification document basing on the functional specification document
• Mainly involved in Conversion and Reconciliation of data in General Ledger.
• Master Data Management: Created Hier/Attr/Text dataflows to load master data pertaining to bank.Developed complex ABAP logic to load Hierarchies and add versioning, Validate source and BW data.
• Created Process chains
• Created DSO’s & Master data Infobjects Etc
• Enhanced some Master data Datasources
• Developed complex ABAP logic for trigger based invoking of process in process chains.
• Installed and activated dataflows in FI,MM,SD.
• Developed and Tested the Objects in BW using some test data and transported them into the Quality keeping in view the dependency of objects. performed TUT, FUT, SIT.
• Involved in the cut over and go live activities.
• Production support
• Interacted with the client team and delegated work to the team mates, helped them achieve their tasks, provided them technical assistance when needed.

Environment: SAP BI 7.3, ECC 6

Confidential, Charlotte, North Carolina

Team Member

Responsibilities:

• The Samlerhuset Group B.V. is a global coin collection company. First established in Norway in 1994, it has expanded into 14 different markets within Europe. Worked in the areas SCM, Sales, FI and CRM
• Prepared TDS,UT documents.Identified &Installed standard BI content objects in area of SCM, Sales, FI & CRM
• Migrated & enhanced flows to achieve desired results,Developed process chains for automated loads
• Designed and maintained the required Info Objects, Info Sources, Transformations, ABAP Routines, ODS Objects, Info Cubes, Info Packages and Process chains
• Activated standard Logistic datasource content on R/3 for sales order items, header & item statuses, Deliveries, MM (Purchasing) & FICO (GL, AR & AP). worked on enhancing the extract structures based on the Client requirement and populated data to those particular enhanced fields by using User exits.
• Involved in Extraction, Transformation and Loading of Data (ETL) - preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads; loading data from flat files and SAP ECC, scheduling and monitoring data loads.
• Activated available business content on BW side for SD. Created custom InfoObjects, InfoSources, ODS objects, Infocubes and complex transformations.
• Created Aggregates for the Info Cubes to increase Query performance and taken care of all performance related issues.
• Developed several process chains to automate the data flow and data extracts.
• Responsible for enhancing the performance of system by addressing time consuming loads by fine tuning code or system parameters based on situation.
• Involved in Performance tuning of routines in Transformations for loading (ABAP).
• Rectified the inconsistency data between R/3 and BW done the reconciliation.
• Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression etc.

Environment: SAP BW 7.3, IP, BEX 7, SAP ECC, CRM

Confidential, Charlotte, North Carolina

Team Member

Responsibilities:

• Involved in preparing the Technical specification document basing on the functional specification document
• Responsible for design, development and extraction of data from R/3 Source system and Flat files to the BW system.
• Extraction of various master data datasources.
• Involved in designing data flows from BW objects including extracting, transforming, and loading data into info providers like DSOs, Cubes
• Involved in creation of different InfoCubes, ODSs, Master Data Objects, extracting data from R/3 and scheduling of Data Extracts.
• Have used different extractors for data from R/3 to load detailed data to the ODSs and summarized data to the InfoCubes and applied various transformations using ABAP to make the data in consistent with the other systems.
• Have used various extractors like 0FI GL 4, 0FI GL 14 for General Ledger reports, 0FI Gl 10 for Trial Balance
• Created Process Chains to schedule the data loads in to the data targets including realignment runs, info cube rollups.
• Scheduled and monitored the data loads from OLTP systems and Flat files.
• Created Info Spokes/Open Hub interface to transfer data from BI to Flat Files to load to an external system.
• Mainly involved in Conversion and Reconciliation of data in General Ledger.
• Developed and Tested the Objects in BW using some test data and transported them into the Quality keeping in view the dependency of objects.

Environment: SAP BI 7.3, ECC 6

Confidential

Team Member

Responsibilities:

• Integration and regression testing.
• Work on HPQC for test script upload, defect creation and reports. Escalation of issues as need be.
• Monitored the process chains for loading FI, SD and MM data.
• Fixed process chain issues.
• Involved in TUT, FUT, SIT and UAT tests.
• Testing the Web Reports using HP Quality Center tool,Monitor Process chains. Error Resolution.
• Creation of Test Scripts, testing BPS Reports,testing BPM Scenarios like Expense Planning, Revenue planning, Test Planning, Allocations etc.

Environment: SAP BI 7/BW 3.5, ECC 6

Confidential

Developer

Responsibilities:

• Create test data for BI and Basis and execute them.
• Work on HPQC for test script upload, defect creation and reports. Escalation of issues as need be.
• Daily status reporting
• Perform Integration and Functional Unit Test.

Environment: SAP BI 7/BW 3.5, ECC 6