SUMMARY

• Around 12 years of experience in Business Intelligence & Business Warehousing (BI/BW),SAP Business Objects Data Services, HANA,SAP MDM. Certified by SAP in SAP NetWeaver7.0 - Business Intelligence and ETL framework. Trained by SAP in MDM and BO Crystal Reports .Worked on multiple industries like Manufacturing, Retail and Telecom Industries.
• Expertise in design, development and delivery of successful cost-effective SAP implementation & Data warehousing solutions.
• Experience in full lifecycle implementations including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Training Documentation and end user training & Support projects.
• Hands on experience in ETL - SAP Data Services (Designer, Repository manager, Job server, Management Console, Address Directories, BODI, BODS, Migration)
• Experience in Information Technology industry with SAP HANA, SAP BW (BW7.4,BW 7.3, BI 7.0, BW 3.5), SAP BO(4.1, 4.0,XI3.1), SAP ABAP/4.
• Hands-on experience in Data migration and Data profiling experience from Oracle, SQL Server, & DB2, source systems including Flat Files, Legacy systems and SAP using SAP Data Services and Integrator.
• Worked on integration of Business Objects Data services with SAP modules, and Non -SAP Data sources like Oracle 11i/10g/9i, SQL server 2008/2005/2000, DB2
• Experience in Scheduling Jobs, Validation, Tracing and debugging Batch job; creating projects, Jobs, Data stores, Data Flows, Work Flows, Transforms and Functions; writing Data Integrator Scripting languages and variables; Installing Functions on the SAP Server Connecting to SAP Applications
• Experienced in SAP HANA data modeling using Attribute View, Analytic View and Calculation View Procedures Decision Tables, Package & Schemas and Analytic Privileges.
• 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 methodologies.
• Involved with ASAP methodology for implementations right from Project preparation, to Post-Live Production support with LSA landscape.
• Worked extensively on various Businesses functional Areas like SD, SRM, CRM, FI, MM, PP, CRM, QM and HR-Payroll modules Related to SAP BW/BI Reports implementation.
• Worked with HANA-Optimized Info Cubes by migrating the Standard Info Cube to In-Memory by using T-code RSMIGRHANADB. Extensively Involved in re-Converted Hana-Optimized DSO to Classical DSO.
• Experience in BO 4.1 Reporting Suite Webi (Structured, Ad-hoc and drill-down reports), Crystal Enterprise (operational reports), Dashboards (executive dashboards with drill down to Webi Reports on BI Launchpad), Analysis for OLAP.
• Designed and developed queries for reporting usingBEx Analyzer, Query Designer and Web Application Designer
• Extensively worked in BEx Reporting of Selections, Formulas, RKF, CKF, Variables, Processing Types, Conditions, and Exceptions. RRI &Bex Broadcasting.
• Extensively worked in BW 7.3 components (Transient Provider, Composite Provider, Virtual Master Data Info Objects, and SPOs).
• Extensively involved in SAP BI-BW Production Support in handling daily batch jobs, load failures, delta failures, Performance issues, BIA issues, System issues, reporting issues, locking issues, resource bottleneck issues.
• Extensively involved in Data load & Report Performancetuning Techniques (Partitioning, Parallelization, Aggregates, CubeCompression, Line Item Dimension, and Indexing).

TECHNICAL SKILLS

SAP Tools: SAP BODS 4.2,4.1.3.x, SAP HANA, SAP BW 3.5, BI 7.0, BW 7.3, BW 7.4,BW 7.5, SAP BO4.1,4.0, XI3.1 Solution Manager

ERP Integration: SD / SRM / MM / FI-GL,AP, AR / CO / PP / QM / PM / HR modules

Reporting Tools: BEX, Information Design Tool, Dashboard, Crystal Reports and Business Objects XI R3, BOBI4.1,BOBI 4.0.

Databases: Oracle 9i/10g, Oracle 11g, MYSQL,HANA, DB2 and MS Access

Languages: C, C++, Java, SQL, PL/SQL, ABAP/4

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SAP BW HANA Migration Support Consultant

Responsibilities:

• Reviewed themigrationcutover plan from BW stand point (preparation steps, postmigrationtasks, validation steps) and ensured that the necessary cutover steps were existing in order to ensure a smoothmigrationprocess.
• Revisited the issues faced during the migrations done on their Sandbox and QA systems and provided recommendations.
• Extended support to solve issues raised duringmigrationand in validation by coordinating with BASIS and Security teams.
• Provided recommendations on best suited transportation process forHanaobjects.
• Provided recommendations on design standards on BWHanaobjects adhering to LSA++ architecture.
• Provided recommendations onHanaSecurity model, package structure organization and on Dynamic tearing options withHanaoptimized BW modeling objects.
• Suggested to leverage PAL in BW usingHanaAnalysis process (HAP) for their financial forecasting solution based on actuals loaded in BW.Creating setup tables using 0LI7BW based on the document range for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BW system.

Environment: SAP BW 7.4 on Oracle, SAP BW 7.4 SP 13 onHANAUnicode.

Confidential - Houston, Texas

SAP BW /HANA Lead Consultant

Responsibilities:

• Having excellent Experience in BW on HANA Models and Native HANA Models.
• Involved in information gather phase
• Migrated MS SQL Database into SAP HANA
• Created Users, Roles, Privileges, Packages, Schemas as part of HANA Security and Development
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Developed complex SQL scripts in Calculation views
• Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0 to import csv files into SAP HANA tables to reflect exchange live rates application
• Involved in SAP HANA Security including User Management, Roles, and Privileges
• Reporting, Accessing Analytical and Calculation views from EXCEL.
• Involved in Information Design Tool Creation of Data Foundation, Universe for HANA reporting.
• Having excellent Experience in BW on HANA Models and Native HANA Models.
• SAP BI environment-BW on HANA and Native HANA along with BOBJ and BODS ETL Tools.
• Developing and handling BW data models and HANA views as per the business requirement.
• Developed WEBI reports to assist with Data Quality and Business/Functional Requirements validations
• Advising the Client regarding the Performance Improvement.
• Good in SAP BW on HANA, SAPBOBJ implementations using SAP HANA.
• Good in BW on HANA Models and Native HANA Models.
• Experience in indepth knowledge of SAP BW and working on mixed scenarios using both HANA as data mart + BW on HANA solutions.
• Designed and developed functional specifications, technical specifications for HANA Modeling and BOBJ reporting.
• Expert in data modeling, development of attribute, analytic, calculation views using HANA Studio Should have programming experience in HANA, using SQL, SQL and CE scripts. Should be able to understand database schemas in SAP and also from different 3rd party legacy source systems.
• Familiar with deployment of HANA Live virtual data models.
• Developed Attribute views, Analytic views and Calculation views for Sales, and Finance tables replicated from ECC to HANA via SAP LT Replication Server (SLT), SAP Business Objects Data Services (BODS/DS), Direct Extractor Connection (DXC), Sybase Replication.
• Developed multiple attribute views to use them in the analytic views to avoid using physical tables and optimize the performance.
• HANA system creation - Data provisioning - Modeling - Consumption.
• Using SAP Business Object data services 4.0, replicated data from both ECC and the Flat files into the SPA HANA database.
• Created Info Cubes, DSO Objects, Data Marts, Multi Providers, Info Sources, Info Objects, ODS Objects, Transformations and Start Routines. Data Staging & Loading, PSA maintenance, Info Packages, Data Transfer Process (DTP), Delta functionality and debugging loads using the Data load Monitor.
• 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.
• Involved in ETL Based replication to provision the data from ECC to HANA system through BODS
• Experience in Creating Attribute views, Analytic views, and calculation views as a part of SAP HANA Modeling.
• Created the Analytic Views using Transaction tables in Data foundation and joined the Attribute views in the logical join section.
• Imported and exported the business models from Development - quality and Development - production systems using Delivery units and Developer mode options.
• Used the Advance Replication Settings to Map, Transform the Data during Replication in the SLT Server.
• Prepared the mapping documents for data sets from each source systems, by conducting multiple workshops with the business users and respective technical teams.

Environment: SAP BW 7.3, SAP BO 4.1, SAP HANA 1.0, SAP ECC 6.0 SAP BODS.

Confidential - Houston, Texas

SAP BI Upgrade Lead

Responsibilities:

• Involved in Technical Upgrade as a team member.
• Upgraded the system BW 3.5 to BW.7.3 and 7.4
• As a Upgrade consultant involved in the Prepare activities, Pre Upgrade ASU activities, Post upgrade ASU activities,
• Involved in the Defect creation in HPQC tool.
• Worked on resolving defects and upgrade issues.
• Created SAP messages to SAP for the issues encountered
• Involved in the Integrated and Performance testing.
• Supported 24/7 during Mock Cutover activities.
• Coordinated during Load testing with ART team.
• Attending the meetings with IBM Management and Client Management
• Use to prepare the Test cases for all the phases of testing on time.
• Use to raise proper risks and defects and continued to work on resolving them
• Worked on performing the upgrade tasks
• Performed discussions with team for resolving issues and use to communicate required information to the team.
• Experience in moving objects between Dev, UAT, Test and Production environments
• Involved in creation of Unit test script templates and executed of those scripts and ensured there are no gaps between functional and technical aspects.
• Experience in writing test scenarios for Integration testing and User acceptance testing.
• Gave smooth transition to the support team.
• Coordinated with other teams like (Functional, Security and Basis).
• Making sure HPQC and SAP notes are updated on time

Environment: SAP BW 7.3, SAP BO 4.1, SAP HANA 1.0, SAP ECC 6.0 SAP BODS.

Confidential - Chicago, IL

SAP BW/HANA Consultant

Responsibilities:

• Involved in requirement gathering successfully passing on the information and requirement details to offshore to develop the requirement
• Coordinate the activities between offshore and the onsite development team
• Peer review and knowledge transfer to assure quality of work delivered.
• Familiar with deployment of HANA Live virtual data models.
• Developed Attribute views, Analytic views and Calculation views for Sales, and Finance tables replicated from ECC to HANA via SAP LT Replication Server (SLT), SAP Business Objects Data Services (BODS/DS), Direct Extractor Connection (DXC), Sybase Replication.
• Created Attribute views, Analytical views, Calculation views Graphical and Calculation views of type SQL.
• Calculation view for Stock Overview to build a BO Explorer for Stock overview
• Analytic view for Sales Order Analysis to build multiple WEBI reports and dashboard for Open Sales Order analysis.
• Involved in connecting the multiple source systems like SAP ECC, Legacy systems, Flat Files, Oracle, SQL Server to get the data from different individual organization and merging the data into one single SAP System.
• Extensively used the SAP best practices methodology extract, convert and load legacy data to SAP
• Worked on performance Tuning of long running jobs used techniques like pushing down operations to database level, using cache memory, Degree of Parallelism, collect statistics to monitor jobs.
• Extensively used Query Transform, Map Operations, Table Comparison, Merge, Case, SQL, and Validation Transforms in order to load data from source to Target Systems.
• Defined separate data store for each database to allow Data Services to connect to the source or target database. Created Scripts like starting script and ending script for each job, sending the job notification to users using scripts and declaring the variables local and Global Variables.
• Extensively worked with HANA-Optimized Info Cubes by migrating the Standard Info Cube to In-Memory by using T-code RSMIGRHANADB.
• Involved in Re-Converted Hana-Optimized DSO to Classical DSO.
• Designed Universes using relational, OLAP & Legacy data sources.
• Designed Crystal Reports using SAP/Oracle/Universes/Repository sources.
• Designing and enhancement of universes using IDT, UDT as per project demands.
• Worked on BO 4.0, 4.1 Reports on HANA database.

Environment: SAP BW 3.5, SAP BO XI R/2, SAP HANA 1.0, SAP ECC 6.0, SAP BODS.

Confidential

SAP BW/MDM Lead Consultant

Responsibilities:

• Identifying existing production issues and fixing the same.
• Involved in Issues regarding Performance and also load failures like monitoring of Info packages and analyzing the reasons for frequent failures of Info packages, Maintaining Work History for all the tickets until it is closed down.
• Worked on moving objects between Dev, Test and Production environments
• Involved in creation of Unit test script templates and executed of those scripts and ensured there are no gaps between functional and technical aspects.
• Experience in writing test scenarios for Integration testing and User acceptance testing.
• Creating and controlling several interconnected processes using Process Chains.
• Ensure that all periodic schedules like Daily, Weekly and Monthly are successful.
• Scheduling the failed packages, analyzing the errors and giving permanent fix if applicable.
• Ensure data is send to Info providers and ready to Reporting by agreed time if not then update the user group on the same.
• Worked with repair full request for Full loads without disturbing delta loads.
• Worked on Variables, calculated and restricted key figures, conditions, filters and exception for BEx queries.
• Training of new team members into the team
• Coordinate the activities between offshore and the onsite team.
• Peer review and knowledge transfer to assure quality of work delivered.
• Detailed analysis of issues raised by Customer and taking needed actions to rectify.
• Maintaining documentation of the each and everything related to project.
• Maintaining the Queue - related to system generated tickets and customer generated tickets.
• Informing the status, after completion of critical data loads from time to time to the end users.
• Periodically preparing the status reports of loads, tickets and updating that in client meeting.
• Educating new users to how to effectively run the report faster- User Training Program.
• Supported the client by providing long-term solutions to the tickets by doing Root cause Analysis.
• Involved in the Handovers to Application Maintaince (AM) team
• Performing SLA (Service Level Agreements) audits for the tickets.
• Involved in End-to-End implementation and support activities.
• Worked with Adapter Monitoring, Message Monitoring, Performance monitoring, message archiving and end-to-end Performance.
• Analysis of the functional specifications provided by the client.
• Preparation or updating, reviewing of Technical specifications as per the requirements.
• Configured IDOC, RFC’s in Integration directory.
• Undertake all tasks allocated by the Project Manager as per the Project requirement
• Monitor and follow up the tasks assigned to associates.
• Prepare the timesheet and review
• Track progress of the development & update client proactively.
• Escalate issues, risks and changes to the respective Escalation Managers for resolution
• Participate in review / status meetings.
• Maintain and communicate weekly status reports.
• Worked on the import manager tool by which the data has been imported from SAP R/3 and Flat files into the data manager.
• Master Data Consolidation and storage of master data imported from data sources.
• Master data harmonization i.e., distributing consolidated data. Map fields, map values, convert data types, split a single field into multiple fields.
• Combined fields to create value combinations.
• Matched records and combined fields to merge values.
• Combined fields to create a multi-valued field.

Environment: SAP BW 3.5, SAP R/3,SAP CRM,DB2,SAP MDM

Confidential

SAP BW/MDM Consultant

Responsibilities:

• Worked on solving Issues raised by customer by analyzing on both CRM and BW systems and to find out where exactly the problem is and to resolve it.
• Performing selective deletion in ODS and Info Cubes loading with same selections on special request.
• Worked on objects like Info objects, Info cube, ODS object, Info Source, Transfer rules, update rules.
• Improved query performance using Aggregates, Indexes, Data Compression .
• Involved in performance tuning of loading by parallelizing the load processes and changing loading parameters.
• Worked on loading Full loads, init loads and delta loads
• Worked on scheduling periodic schedules like Daily, Weekly and Monthly .
• Actively Involved in Rectification of Load Failure errors in Master Data Loads, Transaction Loads.
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Worked on the import manager tool by which the data has been imported from SAP R/3 and Flat files into the data manager.
• Master Data Consolidation and storage of master data imported from data sources.
• Master data harmonization i.e., distributing consolidated data. Map fields, map values, convert data types, split a single field into multiple fields.
• Combined fields to create value combinations.
• Matched records and combined fields to merge values.
• Combined fields to create a multi-valued field.
• Data Mapping, Data Conversion, Cleansing
• Normalizing, Aggregation, Data Import

Environment: SAP BI 3.5, SAP R/3,SAP CRM,DB2,SAP MDM .