Profile

• Over 13 years of consulting and project management experience within IT to include two years of SAP HANA.
• Expertise in SAP HANA, SAP Data Services, Data Warehousing and Oracle.
• Successfully implemented a HANA project as well as a HANA POC.
• Experience leading large onshore and offshore teams with end to end responsibilities for deliver and client management.
• Worked on various Software Development models such as Waterfall, Agile and Scrum.

Technical Skills

Experience/Project Work

Confidential

Role: Senior SAP HANA Consultant

Responsibilities/

Deliverables:

• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Loading Data into the SAP HANA Database using SLT, BODS and DXC. Bringing Data from ECC, Oracle and Flat files, also implemented ABAP Data Flows in BODS.
• Interfaced with SAP BW to bring in Data
• SAP HANA Security activities like User Management, Assigning Roles to users and Managing Analytical Privileges to enable course gained and fine grained access control.
• Creating Hierarchical views
• Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, business rules for finance, sales and marketing domains.
• Created a high-level and detailed HANA implementation and migration plan and develop a training plan for the current development resources
• Leveraged knowledge of data ware house, ETL and software development methodologies to contribute to the overall planning by recommending approaches, identifying resources and developing timelines
• Used HANA data as Pivot tables in Microsoft Excel through via MDX provider
• Transported HANA content from development, testing environment to Production environment using delivery units.
• Integrating HANA views with Reporting tools like SAP Lumira, MS Excel, AAO, IDT and Crystal Reports, Design Studio for BOBJ
• Troubleshooting the Performance Issues

Confidential

Role: Senior SAP HANA Consultant

Responsibilities/Deliverables:

• Conducted Discovery session: Proof of Concept scenario and success criteria. Storyboarding, validating user requirements and defining use cases.
• Prepared the Blueprint of HANA Proof of Concept scenario
• Implementation
• o Extract Source Data using BODS and SLT
• o Data modeling in HANA Studio using Attribute, Analytical and Calculation views
• o Review, Refine and Validate Data Generated Reports in Excel and SAP Lumira
• Client Testing Step by Step Business Review with the Client and IT Team.
• Evaluation and Decision Detailed Presentation to compare As-is and proposed HANA Scenario
• SAP HANA Roadmap for the client and next steps on the project.

Confidential

Role: SAP Data Services Consultant

Responsibilities/Deliverables:

• Created Repositories, Users assigned the security in the Multi-Team Environment.
• Worked in the BODS4.0 Environment, the entire project implementation was on 4.0
• Worked on the IDOC'S, Batch/ real time jobs to extract the data from the SAP/ECC system, and load into the staging data-base for the multiple projects.
• Worked on the BW open Hub tables to extract the data from the BW.
• Extracted Data from all the Relational Databases including oracle, Microsoft SQL server and loaded in different environments which include BW, ORACLE, SQL SERVER, and .txt .CSV files.
• Worked on the DI scripting prepared a standard Incremental load template which enables the job failure/success notifications.
• Created Global variables to read the files from the shared location from the BODS Designer Also worked on the FTP process to put get the files on the data-exchange servers.
• Worked on all the standards guidelines Best practices Documentation, and also the functional Technical design specification documentation.
• Migrated all the Projects of the team from DEV TO TEST TO PS TO PROD, scheduled the jobs as part of the Administrator.
• Worked on the Data Quality, Address cleanse transformations for cleansing the data
• Provided the technical guidance knowledge transfer of effectively using BODS4.0

Confidential

Role: SAP SD Practice Member

Responsibilities/Deliverables:

• Managed the consulting practice for SAP Sales and Distribution module.
• Prepared responses to client Requests for Proposals, communicating HCL's capabilities, approaches, methodologies, and tools for prospective clients
• Interviewed potential consultant candidates for various SAP requirements in the staff augmentation side of the business
• Authored practice management and growth strategies for the Enterprise Applications consulting practice
• Completion of the Business Blueprint phase of an SAP SD project. Established project management and governance processes based upon PMI/PMBOK principles.
• Successfully assisted in the sales process by analyzing customer's business requirements, architecting IT solutions, presenting the solutions to customer senior management, and addressing detailed technical questions from client IT staff

Confidential

Role: Project Lead

Responsibilities/Deliverables:

• Manage a large Data Warehousing project.
• Worked on ETL tool - Ab Initio with Oracle and Teradata.
• Working with business users and business analyst for requirements gathering and business analysis. Converted business requirement into high level and low level design.
• Extracted data from different flat files, MS Excel, MS Access and transformed the data based on user requirement using Ab Initio and loaded data into target, by scheduling the sessions.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database and for Testing Purposes.
• Supporting daily loads and work with business users to handle rejected data.
• Onsite offshore team coordination. Implementing successful migration of processes to offshore facilities of HCL by working closely with Solutions Leaders and Subject Matter Experts to achieve goals with efficacy.

Confidential

Role: Project Lead

Responsibilities/Deliverables:

• Life cycle activities to accomplish the design, development, and implementation of data structures data extraction, transformation, and load of data ETL from multiple, heterogeneous, transaction-based systems to Data Warehouse. Data cleansing testing and development of backup and recovery strategies and maintenance procedures.
• Organizing, leading, and facilitating the planning process, including strategic planning, organizational planning, communications and budget management for the Project.
• Working very closely with cross functional business areas and functions to ensure the smooth daily operations and effective communication of project deliverables.
• Overall responsibility for the data warehouse, defining and planning the project, Create a delivery schedule, recruit the team, coordinate the team activities , estimates the cost and expenses, act as a quality reviewer of the deliverables, ensure the production of project deliverables, measure the costs and benefits, makes improvement recommendations, communicate with the management. Development and maintenance in this project involved tools like Ab Initio, Teradata and Oracle.

Confidential

Role: Lead - Enterprise Data Warehousing

Responsibilities/Deliverables:

• Coordinated offshore team for requirement gathering, development/coding, testing, change management and implementation.
• Managing Data Warehouse program releases through all phases of SDLC.
• Involved both as technical and functional Subject Matter Expertise concerning DW methodologies, and practices.
• Worked on tools including Informatica, Brio and MicroStrategy.
• Responsible for the analysis, design, and implementation of the systems and network infrastructure needed to support all aspects of the DW development, testing, and production environmental requirements

Confidential

Role: Technical Support

Responsibilities/Deliverables:

Technical support for Laptops, Desktops, Printers, Servers, Operating Systems and other Dell equipment of US Enterprise Customers.