SUMMARY

• With 15 years of overall IT experience, a progressive, business savvy global IT professional offering proficiency in business analytics and time critical deliverables.
• Oversaw various BI projects in Germany, India, UK and US at different levels.
• My strengths include analyzing the business needs, good communication and technical skills, ability to co - ordinate & work with large teams.
• With good knowledge in Automotive, FMCG & Manufacturing domains,
• 12 + Years of SAP experience which includes 8 years of Onsite experience.
• SAP Certified Application Associate in SAP BW 7.X, SAP HANA and SAP BODS
• Involved in 4 Full Life Cycle Implementations and 3 - Enhancement and Support Projects.
• Experience in SAP BW Implementation, Support, Migration, Rolloutand Outage activities.
• Participated in all phases of life cycle including Requirement Gathering, Design, Development, Testing, Go live, Post Go Live Support and End User Training.
• Experience in Migration of SAP BW systems to SAP BW on HANA
• Expertise in SAP HANA Modeling of Attribute Views, Analytic Views, Calculation Views.
• Experience in full life cycle (SDLC) of software development and in Agile Methodology and played an active role in daily Scrum meetings.
• Extensively worked in SAP HANA Data provisioning activities to provision the data from SAP & Non-SAP sources systems using BODS ETL Based & SLT Based replication.
• Experienced in writing SQL Queries, Database Design, Table Schema, Stored Procedures, Views, Functions, Database Triggers, Cursors, Joins, and Replication in SQL Server 2005\2008\2010, Oracle Pl/SQL Created Measures for the Confidential Continuous Excellence (NCE) daily and weekly Reviews.
• Leverage Aggregate design and BW Accelerator (BWA) to improve response time.
• Hands on Experience in creating BO Reports in Web Intelligence and creating Universe.
• Worked as a Change Coordinator and actively participated in deployment of IAAT Tool.
• Good Knowledge of Tableau reporting tool.

TECHNICAL SKILLS

ERP: SAP R/3 4.6C, ECC 6.0

Data Warehouse: SAP BW 3.0B, 3.1C, BI 7.0, 7.3 and 7.4

Languages: ABAP/4, C, C++, SQL.

Reporting Tools: BEx, SAP BO 4.1, Tableau

Operating Systems: Windows NT 4.0, Windows 98/2000/XP, Windows 7, Unix

Databases: SAP HANA, DB2, DB6, Oracle, MS SQL, Teradata

Tools: & Utilities: HP Service Manager, JIRA, Service Centre, MS Office, MS Visio

PROFESSIONAL EXPERIENCE

Sr. SAP BW HANA Consultant

Confidential, Dallas, Texas

Responsibilities:

• Have experience in preparing project related documents like Detailed Design, Business Requirements, Migration Activities, Technical Specifications and Test Cases Document.
• Ability to propose unique strategy for migrating to BW on HANA specific to clients need.
• Experience in designing the information models - Attribute, Analytical and Calculated views.
• Involved in designing Interfaces on BODS to extract the data from the flat file to HANA.
• The conversion of existing Info Providers to the SAP HANA optimized Info Providers.
• Good knowledge on Importing and Exporting Landscapes, Tables and Models, Documentation, User Management, Backup and recovery in SAP HANA.
• Ability to streamline BW data flows based on LSA++ to take full advantage of SAP HANA
• Actively Participated in daily Scrum meetings and Status calls.
• Knowledge of Data replication Techniques - SLT, DXC & Data Services.
• Knowledge of BW on HANA Modeling - Transient Provider, Composite provider & Virtual Provider.
• Worked on SQL queries to create Information models, tables, and stored procedures.

Environment: SAP HANA, SAP BI 7.3, SAP ECC 6.0, APO, SAP BO 4.0 and SAP BODS 4.x

Sr. SAP BI/BW/HANA Consultant

Confidential, St. Louis, Missouri

Responsibilities:

• Leading Offshore BW-HANA team
• Requirement gathering from Business users for each use case.
• Responsible for designing models in HANA Enterprise system.
• Models creation like Attributes, Analytic and Calculation Views in HANA Enterprise.
• Loading data from different source systems to HANA using SLT and SAP Data Services tools.
• Scheduling various jobs in Data Services Management console based on modules.
• Moving the developed jobs in HANA from DEV to PROD using Export and Import functionality and also Life Cycle Management.
• Experience in working on Local and central repositories.
• Import of query snapshots of Bex queries and generate analytic and calculation views (CE Functions) and provide required result to the user.
• Creating Currency Conversions in HANA to convert the amounts from local currencies USD
• Hierarchy creations in HANA based on the requirement.
• Formulated Analytical views, Attribute views and Calculation views (SQL Script and CE functions) exposed to frontend layer implemented with SAP BO.
• Integrating Data security between HANA and reporting tools like BO Explorer with the help of Analytical Privileges.
• Leading the weekly meetings with IT Head about the progress on tasks in HANA from offshore and monthly interactions with CIO to explain the SAP roadmap in HANA.
• Daily meetings with Project Manager and Business Users to provide the update/progress in HANA on each use case.
• Sound knowledge on Data Integrity, Platform, Data Quality Transformations and SDC types in BODS.

Environment: SAP HANA, SAP BI 7.3, SAP ECC 6.0, APO, CRM, SAP BO 4.0, SAP BODS and SQL

SAP BI Consultant

Confidential, Wichita, Kansas

Responsibilities:

• Involved in analyzing and gathering of work request requirements and worked on all stages like Data Analysis, Modeling, Data Extraction/Uploading, Transports and BEx Reporting
• Creation of generic datasources & enhancing existing datasources based on client requirements.
• Creation of transformations, DTP (Data Transfer Process) and Info Packages
• Interacted with Onsite Team from time to time to discuss open issues proactively and achieved smooth run in production environment
• Analyzed and corrected production support problems as they occur in the SAP BI system
• Carried out data reconciliation between the source system data, target data and analyzed whether the values are populated correctly.
• Involved in validated data consistency in reporting with Data Target against PSA after loading them to data targets

Environment: SAP BI 7.3, SAP ECC 6.0, CRM, SRM, SAP BO 4.0, SAP HANA

SAP BI Consultant

Confidential

Responsibilities:

• Preparing technical specifications of BW Queries, Infoproviders, Info objects, Data sources.
• Identifying the subtasks like BI Content Installation, Modeling, loading data from Data source to PSA,PSA to staging layer, staging layer to final reporting layer.
• Creation of Multiproviders, Info cubes, Info objects, DTP’s, Transformations, and datasources required for data loading.
• Master data and transactional data loading from SAP ECC via PSA, ODS and Info Cubes.
• Creation of Process Chains to automate the data transfer.
• Created Transformations using ABAP routines as per the business requirement.
• Creation of customized BEx queries and testing
• Worked with BO team in creation of BO reports in Web Intelligence
• Based on the complexity of the requirements, created Scripted Calculation Views and Stored Procedures.
• Migrated HANA content from development & testing environments to Production environment using delivery units.
• Worked on currency translation and Input parameters, Decision tables.
• Involved in preparation of RFP to the client.

Environment: SAP BI 7.3, SAP ECC 6.0, CRM, SRM, SAP BO 4.0, SAP HANA

Onsite Coordinator & Change Coordinator

Confidential

Responsibilities:

• Have experience providing first level support for market and second level support to offshore on loading issues.
• Extensively worked on issues related to report inconsistency.
• Experience in resolving functional tickets raised by markets on all critical reports.
• Able to plan, manage and deliver defect free deliverables on time.
• Dashboard maintenance for Senior Management on a Weekly/Monthly/ Quarterly basis.
• Participated in Program Manager Reviews to understand the Project Health.
• Management and planning of import all. Validation of CR contents and creation of tasks. Involved in execution of CR testing with relevant teams.
• Participated in complex change activities, BI Upgrades and Service pack Upgrades.
• Involved in debugging of ABAP code in Extractors and Transformations to find the root cause.
• Provide support to Process Teams for analysis. Was the single point of contact for SD, FI and T&P process areas issues and improvements.
• Technically Co-ordinated the offshore support teams across various zones.
• Involved in BW Accelerator (BWA) initialisation Process in Confidential .
• Solving the High-priority tickets, and deliver the changes within specified SLA.
• Handled Outage Bundles by creating instructions that are needed to be performed by BI Offshore team before, during and After Outage.
• Co-ordination with different project teams to share best practices/re-usable assets
• Involved in Annual and Half yearly project management reviews and audits.
• Initiated DMAIC Project for Time & Cost reduction of change Management activities.

Environment: SAP BI 7.0/3.5, SAP ECC 6.0, APO, CRM, SEM

Project Lead/Team Lead

Confidential

Responsibilities:

• Representing the offshore team (Total Team size - 105 SAP BW Consultants 24/7 shifts).
• Provide support to the Incident Management team to resolve the tickets.
• Post Review of Reassigned / Resolved IM tickets.
• Review of Breached IMs even though SLA is met.
• Arranging the shift handover of various teams for smooth switch-over.
• Work Allocation and Resource Planning.
• Improve team performance by arranging internal KT Sessions to ensure that project deliverables confirm to quality norms.
• Coordinating within the teams for the technical issues to resolve the same.
• Attending daily calls with onsite for the issues faced in data loads and action plan followed by the team to resolve the same.
• Preparation of data for weekly SLA Review and attending weekly review calls.
• Level 2 support for requests raised by the markets and Monthly realignments of COPA and GD Process areas data.
• Process chain and system optimization.
• Assist Change Management Team while importing the transports by performing Pre and Post Transport Manual Actions.
• Follow up with the development teams/ PCI/ RAS teams to fix the issues caused by CRs.
• Level 1 support for Monitoring of Data Loads from various source systems like R/3, CRM, SEM and APO by means of Process Chains.
• Support and Optimization of Scheduling and Monitoring systems.
• Managing master data, texts and hierarchies.
• Managing the data targets by having the correct and up-to-date data like
• Reconstructing the data requests from PSA in case of data load failures,
• Roll up of data from InfoCubes to Aggregates,
• Analyzing the errors in the data loads and report to the corresponding team.
• Error handling and Handling Attribute Change Run issues with hyper care.

Environment: SAP BI 7.0/3.5/3.0B, SAP ECC 6.0, APO, CRM, SEM

SAP BW Consultant

Confidential

Responsibilities:

• Worked in environment where there is tight integration between various my sap components like APO, CRM, SEM and R/3.
• Extracted SAP R/3 data from diverse data sources using LO-Cockpit and LIS info structures for extracting sales order, delivery-billing information.
• Performed day-to-day activities like Attribute Change Run, Handling Lock Problems & managing missing SID’s in order to load Transaction data.
• Managed master data, text and hierarchies.
• Extensively worked on Process chains for sequential background scheduling of master and transactional data uploads and resolved failures of Process Chains.
• Uploaded R/3 data into ODS objects through PSA to perform detailed - level reporting.
• Loaded transaction data from R/3 to BW for sales and master data for customers and vendors on a daily basis using Delta initializations and Delta loads.
• Maintained Aggregates to Rollup the Infocube data and Compression of Info cubes as part of the Infocube Management.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL.
• Reload the data from PSA in case of data request failure and maintain correct and up-to-date data in the data targets.
• Involved in re-initialization of business area in case of inconsistent data targets.
• Working knowledge of Importing Transports to the production system and performed pre-manual and post-manual actions while importing the transports.
• Implementing Hot-fixes during Non-business hours and resolving CR related issues.

Environment: R/3, BW, APO, CRM, SEM

SAP BW Consultant

Confidential

Responsibilities:

• With strong Knowledge in ASAP methodology, actively participated from Realization to Go-live and post implementation support of SAP BW in SD and MM modules.
• Worked extensively on procedures for Extracting data from R/3 using LO-Cockpit
• Installing & Activating Business Content objects related to Material Management Reports.
• Created & Maintained Data targets like Info Objects, ODS, Info Cube, Multi Providers…etc.
• Created Info Source for Transaction Data, Master Data/Text, Attributes & Hierarchy.
• Created Aggregates for frequently used queries.
• Created and Maintained Transfer Structures, Communication Structures and developed ABAP routines in transfer rules and update rules for the key figures as well as characteristics
• Created Process chains for Master data and Transaction data loads to automated the data loading in the organization and these process chains are scheduled for periodic loads.
• Monitored the daily production loads and Fixed failed loads, full and delta.
• Maintained LO extractors in SD & MM by maintaining extract structures, and thus maintained data sources and configuring for initial, delta and full updates.
• Performance Management by creating aggregates based on BW Statistics, compression of InfoCubes and partitioning before data is loaded in Production environment.
• Created generic datasources using ABAP code as per business requirements.
• Worked on BEx Analyzer and BEx Browser in developing flexible queries to facilitate data analysis in a drill down or summarized way to give detailed levels of information.

Environment: SAP R/3, BW, SEM, CRM, APO

CAD/CAM Designer

Confidential

Responsibilities:

• Experienced in Product Modeling, Tool design, Fixture Design and Machines parts of Domestic and Industrial application using CAD CAM software such as PRO-E, Auto CAD 2000
• Well experienced in 2D, 3D, and High speed 5AXIS machining with using PRO-E and Catia 4.0
• Experienced in 3D MODEL constrains and Geometric Dimensioning & Tolerance standards.
• Conversion of manual drawing to digital format according to client’s requirements.
• Creation of Text and Illustrations for Operational and Servicing Publications.
• Annotation and Dimensioning are done according to the standards.
• Creation of illustrations for exploded views in conformity with standard of specification.
• Knowledge of 5 axis Machining Concepts and Tool path creation
• CNC Cutting Tool Design for Special Moulds, Jigs and Fixtures, Production Jobs.

Environment: PRO-E, Catia, Auto CAD 2000