SUMMARY:

• To work as a SAP HANA consultant to provide functional and technical SAP HANA solutions for enterprise forecast and analytical reports using my functional and technical skills.
• Dedicated Software specialist with 20 years of experience in the IT industry with 15 years of experience in SAP, over 12 years of experience in SAP BW and around 2 years of HANA experience.
• Involved in complete life cycles of SAP BW implementations .Experienced in SAP HANA 1.0, BW. 3.1, 3.0B & 2.1C.
• Very strong Data warehousing concepts and developing custom solution to client specific BW systems.
• Extensive knowledge of report design, query design, report construction, testing and performance tuning.
• Involved with end - users and team leads to gather their requirements.
• Involved in training end-users and project team members. Documented business process.
• Exceptional organizational, analytical, problem solving, debugging and communication skills.

TECHNICAL SKILLS:

ERP: SAP HANA 1.0, SAP BW 7.0/3.0b/2.1c, SAP ECC 6.0, SAP R/3 4.6c/4.0b, ABAP/4

Reporting tools: SAP Report Painter/ Writer, Oracle Reports, Crystal Reports, Lotus Reports

Databases: Oracle, SQL Server, Access, DB2, Sybase, Microsoft SQL server 2000

Data Migration tools: LEI, Notes Pump, ODBC

Groupware: Domino, Lotus Notes R6/5

GUI: Developer 2000, Power Builder 4.0, Visual Basic, .Net, ASP.NET, Visual Studio

Operating Systems: Windows XP/NT 4.0/2000/98/95/3.1 , CISCO UCS, AIR, UNIX.

Language: JavaScript, Java, Lotus Script, HTML, C, COBOL, DHTML, XML, CSS

WORK HISTORY:

Confidential, Arizona

SAP HANA Implementation manager

Responsibilities:

• Review of SOW and Implementation strategy.
• Facilitation of functional and technical team meetings for the better understanding of the requirements.
• Working with stake holders of the project to deliver the project on time.
• Maintaining the project plan, resource plan, project schedule and deliverables.
• Coordination of efforts between the SAP functional, technical teams and BI teams.
• Stake holder updates on the time line and project budget.
• Documentation of technical specification and data flow.
• Involved in monitoring the status of Webi Report development based on the BO universes.

Environment: SAP HANA V1.0(SP08), SAP BO XI 4.0 and ECC 6.0

Confidential, NJ

SAP LEAD HANA Sr. Consultant

Responsibilities:

• Analysis of FI report requirement and SAP delivered content.
• Identified the Gaps in the report requirement and updated the functional specification.
• Created Attribute, Analytical and Calculation views for base data modeling.
• Transported HANA model to QA and Prod by using the packages and delivery units.
• Designed and Created Universe for reporting from information modules.
• Created Webi reports and Dashboard reports using SAP BOBJ.
• Created Webi reports with appropriate filters and prompts for user inputs.
• Expert in using Business Intelligence tools like Business Objects XI4.0 to build complex universes and Reports, Charts on Multiple databases ( Data Providers) . Experienced in development, testing and implementation.
• Deployed universes to different environments like QA, Training and Production..

Environment: SAP HANA V1.0 (SP02), SAP BO XI 4.0 and ECC 6.0

Confidential, CA

SAP BI Manager

Responsibilities:

• Expert in understanding the complete Architecture(Data loading, Data Modeling & reporting)
• Expert in creation of Analytical and Attribute views and Complex models by using SQL script in Calculation views.
• Good understanding of various components of SAP HANA.
• Overview working knowledge with SAP BO Data services and SLT replication methods.
• Created Analytical Privileges and Procedures for modeling.
• Designed and Created Universe for reporting from information modules.
• Design and Implementation of SLT replication Schemas in HANA.
• Expert in SAP BO XI 4.0 . Web intelligence, Crystal Reports and Dashboards.
• Expert in using Business Intelligence tools like Business Objects XI4.0 to build complex universes and Reports, Charts on Multiple databases ( Data Providers) and experience in development, testing and implementation.
• Experience in building and designing Universes based on user requirement and converting the existing .UNV universe to .unx format.
• Experience in working with business objects modules like CMC, CCM, Information and universal Design tools. Info view, web intelligence, import wizard, publishing wizard, supervisors and broad cast agent etc.
• Expert in identification of business and data requirements as well as converting them into concept and logical data models.

Environment: SAP HANA V1.0 (SP02), SAP BI Net Weaver 7.0, CISCO UCS and ECC 6.0

Confidential, Seatle, WA

SAP Functional BW Sr. Manager

Responsibilities:

• Completely Involved in full life cycle implementation including Gap Analysis, Design, Development and Security Authorization.
• Extensively involved in Gap Analysis in analyzing the legacy reports (for e.g. Sales reports, Inventory and Forecast.) and prepared Functional Specification and its Corresponding Technical Specification.
• Developed Proof of Concepts to help understand the requirements with Business users of different BU’s like Home appliances, AV products, computers and Home Equipment.
• Regular interaction with the functional team and end users to understand their Reporting Requirements and creating related informational document
• Worked extensively with Netweaver BI 7.0 BEx Analyzer. Developed queries using BI- Report variables.
• Developed workbooks, info set Queries, structures and used RRI jump queries to drill down from Summary to detail queries
• Created a customer exit variables for different specific requirements. Also customized the system generated BEx messages to Self Explanatory Custom Messages.
• Worked with Security team to Test and Document the access of different Roles (Power user and End user) with Queries and Workbooks on the new Security Authorization in BI (Analysis Authorization)
• Extracted data from the legacy systems like SCM (Supply Chain Management) and Other Excel data into BI by Creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Transformation rules.
• Strong experience in Aggregates, Performance Tuning, Partitioning, Compression, BW Statistics and BW Job Scheduling, Testing, Go-Live, Production Support, End-user training and Documentation.
• Worked with different regions like Europe, NA and Asia pacific to avoid duplicate reports.

Environment: SAP BW 7.0, ECC 6.0 and Business Objects.

Confidential, NJ

DW Functional Lead

Responsibilities:

• Initiated supply chain project in Confidential as part of PRISM (SAP) Phase II implementation.
• Identified the business side functional managers and key users as stake holders of the project.
• Initiated and identified the scope of the project. Agreed with scope of the project and Sign off.
• Conducted GAP analysis sessions to identify the gaps between Global template & North America requirements.
• Produced GAP analysis summaries and presentations to the Snack, Pet and Food functional managers.
• Worked on High level phase by phase approach and presented to the Project sponsors.
• Weekly interactions with Core team to learn and keep SCM DW project in the same page with the bigger PRISM implementation.
• Provided business solution to manage the current inventory, shelf life management and raw material procurement. Worked with Material, Customer master data for attribute extensions and data mappings.
• Worked on Demand planning data marts by integrating SAP data with Apollo tool.
• Confidential Demand planning heavily focuses on Halloween, Christmas and New Year seasons.
• Managed technical team to complete the development. Maintained & monitored project plan to run the project on schedule.
• Monitored and controlled the budget to restrict the project cost.

Environment: SAP BW 3.0/3.5, ECC R3 4.6c, Business Objects and Oracle.

Confidential, NJ

SAP BW Technical Manager

Responsibilities:

• Conducted extensive requirement gathering workshops with the end users in the areas HR.
• Extensive analysis of requirements to identify the data resources.
• Final blue prints developed using the data resources.
• Complete knowledge of SAP Report painter and SAP BW architecture.
• Analysis of current crystal reports to define the existing requirements.
• Installed business content from the Personal Administration module.
• Installed and activated Infocube 0PA C01 and customized.
• Loading strategies of all the employee data from different countries.
• We have used the data sources like Ethnic Area, Payroll area, Education area and other.
• Conducted extensive requirement gathering workshops with the end users in the areas of Sales and distribution, Inventory and FI/CO.
• Designed custom info provider for Delivery analysis and to load large volume of data from SAP R/3 4.6C Source systems.
• Installed and activated standard Inventory cube 0IC C03 and developed transfer rules and updated rules.
• Developed a multi cube on sales and delivery basic cubes to facilitate reporting on sales and delivery together.
• Designed loading strategies for master data, initial load of transactional data and delta loading of both master data and transactional data.
• Defined strategy to set up the historical data to load into BW and improved performance by running parallel setups.
• Designed process chains for master data loading, delta loading and for weekly PSA deletion

Confidential, NJ

SAP BW Techno-functional Consultant

Responsibilities:

• Conducted extensive requirement gathering workshops with the users in the areas of APO, Sales and distribution, FI/CO, and Inventory.
• Designed custom info provider for sales analysis and to feed the info provider from SAP R/3 3.1H and 4.6C Source systems.
• Designed custom ODS for sales order line items relevant to demand planning in APO.
• Designed custom info provider for Delivery analysis and to feed the info provider from SAP R/3 3.H and 4.6C Source systems.
• Designed custom info cube and ODS for vendor invoice and payments.
• Designed process chains for master data loading, delta loading and for weekly PSA deletion.
• Developed Transfer rules, update rules and Start routines to in corporate Business logic for data manipulation.

Confidential, NJ

SAP BW Techno-functional Consultant

Responsibilities:

• Extensively conducted requirement gathering workshops by giving overview of BW architecture, data modeling, Info cubes, ODS objects and reporting functionality. Extensively collected requirements in application areas of SD, MM, FI, APO and PS.
• Designed ODS objects for Forecasting, vendor/material source list, sales order line items and purchase order line items relevant for APO Demand planning.
• Developed Transfer rules, update rules and Start routines to in corporate Business logic for data manipulation.
• Extensively worked on setting up of historical data in SAP R/3 and involved in extraction and loading into data targets in BW.
• Extensively designed delta loading strategies and designed info package groups and scheduled info package groups in batch jobs.