SUMMARY

• Building analytical business solutions, solutions - focused, team oriented SAP HANA Certified Consultant of broad-based experience and hands-on skill in the successful implementation of highly effective SAP HANA BW BO BODS and ERP Implementations, Migrations and Technical upgrades.
• Proven ability to successfully analyze an organization's critical requirements, identifies deficiencies and potential opportunities, and develops innovative solutions for increasing reliability and improving productivity. Complete understanding in data warehouse, management, trouble-shooting, and support.
• I have also involved in training activities and speaker in college organizing events.
• Comprehensive experience in handling the full life cycle implementation of SAP BODS BW, ERP and HANA and providing Business Solutions as an architect and lead developer.
• Involved in Data Warehousing Lifecycle, ETL data load process, analysis, design, data mappings, review mappings, Data Proofing, tuning of data loading using SAP Data Services tool and ABAP/4 jobs for ETL process.
• Proven experience in SAP Business Objects Data Services (BODS), IDocs, LSMW, ETL specialist, database designer and implementer.
• Good understating in estimation of user, resource requirements and create plans, timelines, milestones, user approvals, and proper documentation of all kind of specifications.
• Good Working knowledge on SAP BOBJ Suite using HANA Information models.
• Integration knowledge on SAP Business Objects Data Integration with HANA Information models.
• Expert in SQL Server and various source targets
• Excellent technical writing and oral communication skills
• Expert in SAP data mapping and data cleansing
• Fluent in SAP Rapid Marts, maintenance, and extension
• Initiator of Legacy to SAP Data Mapping with functional SMEs Demonstrated excellence in supporting management and team efforts globally
• Created Xcelsius Dashboards provided results with Hyperlink enabled values through users can jump to Web I report.
• Developed functional and technical specifications for Legacy to SAP conversions
• Overcame data cleansing obstacles by developing a mapping and loading strategy with thorough error collection and correction using Business Objects Data Services (BODS), T-SQL, Python Scripts, and in-house tools
• Provided resolutions in SAP Data Services and ETL Process with TSQL (Transactional SQL).
• Provided early-and-often test loading by mapping and loading legacy data to SAP
• Developing functional and technical specifications, saved rework time
• Wrote input/output device drivers in C/C++ within the Windows Driver Model (WDM), preventing third party external intervention
• Provided expert data access services and consultation across the enterprise: finance, EVMS, manufacturing, and timecard tracking, improving colleagues skills through mentoring
• Envisioned, wrote, and presented a RAIT user’s operations manual and training seminar for Worked across business areas to create a new RFP pricing model that supported current finance procedures using Visual Basic and T-SQL, enabling more accurate pricing data for customer approval
• Created an efficient parts configuration database, which shifted the database development paradigm to a relational model
• Corrected and applied industry-standard data efficiency methods to the parts management system using T-SQL, resolving numerous configuration errors, and reducing data access times by 50% - 70%; received awards (Spirit of Excellence and Silver Achievement Award) for innovation
• Good Understanding and working knowledge in EDI (Electronic Data Interface)
• Created and involved in designing the Business, Functional architecture and ER-Diagrams using VISIO tool.
• Involved in conducting user requirements and create functional requirement deliverables of BOBJ reports.
• Good Working experience in SAP Business Objects BI 4.1 Platform and BW 7.4 version.
• Thorough knowledge in creation of ABAP Data flows for Batch jobs and Table Creation.
• Involved in creating crystal reports based on BEx queries.
• Involved in creating Universe on top of BEx queries and published the universe to BOE and designed Webi reports and saved into Info view.
• Good knowledge and working knowledge in Object oriented concepts and issues.
• Proven ability to handle multiple tasks with strong technical aptitude and learning skills to adapt the rapid changing technologies and implementing the same at work.
• Aspiring for challenging position as a professional in Analytical Solutions. Seeking quality environment where my knowledge and experience can be shared and enriched. Looking for an opportunity where I can improve my quality and technical skills.

TECHNICAL SKILLS

Domain Modules: MM, SD, FI (AP, AR, GL, AA) CO, WM, QM and VMS

Languages: SAP ABAP, PL/SQL, SQL, TSQL, JAVA, .NET and C#

Database: ORACLE, HANA

GUI: SAP BODS and Data Services Designer SAP HANA StudioSAP BW Modeling WorkbenchSAP BO Universe/Report DesignSAP ABAP Development WorkbenchSAP Lumira

Tools: MS Office 2007/2010, Visio, BMC Remedy, HPQ, VM Ware

ERP: SAP ECC

PROFESSIONAL EXPERIENCE

Confidential - San Jose, CA

SAP HANA BODS BO Architect

Responsibilities:

• Estimation of user, resource requirements and create plans, timelines, milestones, user approvals, and proper documentation of all kind of specifications.
• Involved in gathering reporting requirements from Business users and documenting the same in form of FD’s.
• Configured SAP Data services and HANA for data provisioning.
• Worked on SAP BOBJ Suite using HANA Information models.
• Escalation handling (internal and external) while conducting the team meetings and periodic reviews with Client team.
• Worked on FI, MM, SD table’s replication using SAP Data services and HANA for BO Reporting.
• Involved in architecture and framework of the BOBJ reports; Created and involved in BOBJ reports.
• Involved in Architecting the HANA solution with mixed approach data Flow design involving SAP ECC and other legacy systems as source systems.
• Formulated Analytical views, Attribute views and Calculation views (Using HANA Studio/Modeler Perspective) further exposed to frontend layer. (Implemented with SAP BO)
• Provided SLT configuration for CO-PA tables (CE1-CE4) to enable faster and real time reports.
• Working knowledge in LT replication server configuration and Functional usage of SLT.
• Involved in conducting user requirements and create functional requirement deliverables of BOBJ reports and Created functional specs of BOBJ reports/charts.
• In order to improve the performance of data processing by creating complex SQL procedures in HANA and triggered the same from ABAP Programs.
• Experience in adding the system, configuration files, and Monitoring logs. Index server, CPU and Memory utilization, Host, Port and other HANA Services.
• Good knowledge and Involved in HANA Administration. (i.e. stop and start server, upgrading the HANA to latest version includes HANA DB)
• Followed SAP best practices and adopted LSA++ concepts.

Confidential - San Jose, CA

Lead SAP BODS BW HANA - ABAP Developer

Responsibilities:

• Escalation handling (internal and external) while conducting the team meetings and periodic reviews with Client team.
• Involved in gathering BO reporting requirements from Business users, Data Provisioning processes using SAP Data Services and documenting the same in form of FD’s.
• Analyzed existing BW environment for issues related to readiness of environment for BW database migration to HANA.
• Estimation of user, resource requirements and create plans, timelines, milestones, user approvals, and proper documentation of all kind of specifications.
• Extensively involved in Pre and Post Migration process and actively took care of steps involved.
• Involved in architecture and framework of the BOBJ reports and Created and involved in BOBJ reports.
• Involved in Architecting the entire BW-HANA solution with mixed approach data Flow design involving SAP ECC and other legacy systems as source systems and using BW powered by HANA as Enterprise Data warehousing application by utilizing existing extractors to load transactional data into DSO objects to formulate Analytical views, Attribute views and Calculation views (Using HANA Studio/Modeler Perspective) exposed to frontend layer implemented with SAP BO.
• Involved in gathering reporting requirements from Business users and documenting the same in form of FD’s. (Functional Specs)
• Involved in migrating existing standard InfoCubes, DSO’s and SPO’s to HANA-Optimized InfoCubes, DSO’s and SPO’s respectively.
• Good exposure in Data Extraction, Database Migration and HANA Studio Modeler.
• In order to improve the performance of data processing by creating complex SQL procedures in HANA and triggered the same from ABAP Programs.
• Involved in consuming HANA models in BW by publishing them as Transient providers.
• Exporting and Importing of HANA models using HANA Lifecycle management.

Confidential

SAP BW BODS Consultant

Responsibilities:

• Estimation of user, resource requirements and timelines, milestones, user approvals, and proper documentation of all reports.
• Conducted Workshops that would focus on gaining cross-functional alignment around the business and transactional stage gates required to create and maintain the master data elements in support of relevant business processes, analytic requirements, and compliance needs.
• Created and Defined Data Quality Metrics.
• Escalation handling (internal and external) while conducting the team meetings and periodic reviews with Client team and SLA’s.
• Working knowledge of Extracting the data using DB connect as a Source system connection in BW 7.3.
• Involved in creating BEx workbooks (3.x & 7.x) by using BEx Analyzer (Used BEx Macros)
• Involved in creating web reports by using different web items and integrating them to EP.
• Extensively involved in creating crystal reports based on BEx queries and publishing the .rpt files to custom portal built with JSP and to Info View by using BW publisher.
• Involved in creating Universe on top of BEx queries and published the universe to BOE and designed Webi reports and saved into Info view.
• Created Xcelsius Dashboards provided results with Hyperlink enabled values through users can jump to Web I report.
• Working knowledge in creation of Universes in BO reporting.
• Worked with different types of Transformations like Direct assignment, Routine, Formula, Initial, Read Master Data and Constant.
• Worked with Start Routine, End Routine, Expert Routine, Multiple Update Groups and also Temporary storage of standard DTP.
• Worked with different types of Cubes and DSOs like Standard Cube, Real Time Cube, Remote Cube with Direct Access DTP, Standard DSO, Write Optimized DSO, Direct update DSO.
• Worked with monitoring the Temporary storage of standard DTP when data loading to Target.
• Developed the infosets with Inner join, Left outer join and Temporal Join with Derived Key date.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEx reporting features like variables, exception and conditions in Sales and Purchasing areas.
• Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing, Tuned queries using Partitioning, Aggregates and Multi-providers.
• Involved in Analyzing the Performance of the BEx queries and improving the query performance by analyzing the Cardinality of the Dimensions of the Info cube by using the Function Module - RSDEW INFOCUBE DESIGN.
• Involved in reducing the Cardinality of the Dimension by Redesigning the Dimensions of an Info Cube, identified the Line Item Dimensions and also suggested for Partitioning as most of the time of the query is spent on DB time.
• Involved in creating input ready queries and provided web based & excel based input layers for planning for Market, Regional & Central planners.
• Extensive use of ABAP/4 for Transformations (Start Routine, End Routine, Expert routine), Dynamic file selection, Dynamic DTP Selections, Variable customer exit, Custom extractors.
• Proposed & implemented a BW based tool called “Inactive object Tracker” to stabilize the BW Systems.
• Involved in Designing Info cubes, DSO objects and also the data flow for different source applications / interfaces
• Extracted data from different source system based on different technology (Mainframes, Oracle databases, SAP R/3, Java) by using the Interfaces like (Myself Connection, SAP Connections, DB Connect)
• Expertise & Extensively involved in creating BEx queries by using almost all the functionalities of BEx Query designer - (CKF,RKF,NF,NS, Variables, Cell Definitions, Structures, Conditions, Exceptions, restrictions)
• Involved in extracting data from SAP R/3 for Cost Center Accounting data by using custom extractors.
• Involved in extracting Purchase Requisitions, Purchase Order & Invoices for analyzing the data based on the MG Departments & Buyers.
• Implemented OSS notes for query failures
• Created own Process types for implementing process chains.
• Involved in performance Tuning aspects like Aggregation, Compression, partitioning, OLAP cache, indices, Line item dimension, Read mode of query, Repair of objects in RSRV to check the consistency in the entire Schema.
• Involved in Working with advance modeling aspects like APD, Information broadcasting Visual composer, Reporting agent.
• Involved in Debugging the Update rules and transfer rules.
• Involved in providing L2, L3 & Maintenance support for BI-ABAP applications.
• IM(Incident) tickets and Tivoli management tool used - BMC REMEDY Tool
• Handled loading issues
• Monitoring of Data loads using Process chains.
• Monitoring of System and loading performance
• Consistency checks and Data Validations
• Deleting data in PSA to free the Tablespaces
• Converting Info package Groups to Process chains
• Ticket Handling of different priority
• Suggested the process improvements by performing the structural changes in the process chains to provide permanent solutions.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Resolved many Data Mismatch tickets by doing Back fills.
• Involved in Debugging Update Routines, Start routines, Transfer Routines.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of the support team.
• Involved in maintaining lot of documentation for all the Support Activities.

Confidential

SAP BW BO and ABAP Developer

Responsibilities:

• Worked with functional consultants for mapping the source data (R/3, Non R/3) to target data sources.
• Worked with Error handling, Error Stack, Error tolerance And Running Error DTPs.
• Worked with different Types of DTPs like Standard DTP, Error DTP, Direct Access DTP and RDA (Real time Data Acquisition) DTP.
• Monitor the Temporary storage of standard DTP when data loading to Target.
• Worked with Delta processes like Only Get delta Once, Get Data by Request.
• Worked with functional consultant for mapping the source data (R3/Non R3) to target Data Sources in BI. Defined the initial sizing requirements based on source data volume estimates.
• Configured Custom cubes, Transformations, Multiple Update Groups, ODS, Cubes, Aggregates, queries and workbooks.
• Involved in Configuring the BAPI connection in Visual composer for enabling BAPI programs in Visual composer.
• Developed the BAPI programs on Active data table of Standard DSOs and Write optimized DSOs to provide required data for reports in Visual composer.
• Developed the Generic Extraction with Function module.
• Extensively Involved in Setting up of Procedures for LO Extraction, which includes the Inactivating the Data Source, Customizing the Data Source, Generating the Data Source, Activating the Data Source, Running the Statistical Setup, Deleting the Setup tables, Replicating the Data Source, Setting up the V3 Update job and enables delta Loads.
• Used process chains to schedule the infopackages and data transfer processes. Also customized primary LO-Cockpit structures 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 11 VASCL, 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM and set the extraction process using LO cockpit and V-3 updates. Also configured BW objects. Including generic data sources to extract data from R/3 systems.
• As part of Information Consumer Layer designed BEx Reports providing insight of Business Intelligence for Business Analyst for Decision making using Formulas, Selections, Structures, Calculated Key Figure, Restricted Key Figure and Used Variables with User Entry/Default Value, Replacement Path and Customer Exit.
• Involved in Designing Web Templates by using Web Items and Assigning the BEx Report as the Data Provider and Save the Web reports and integrating / Publishing the Web Reports to portals as iViews.
• Involved in documenting the complete Step by Step procedure for Information Broadcasting with Distribution types as - Broadcasting to Email, Broadcasting to Email (Bursting).
• Involved in Performing Stress testing, Unit testing, Integrated Testing and User Acceptance Testing.
• Reviewing the Technical and ETL Documents.
• Data Loading and Load Monitoring.
• Extensively Involved in Creation of BW Objects like Info Objects, Info Cubes, ODS, Mapping of Info Source to Data Source using Transfer rules, mapping of Info Source to Data Targets using Update rules.

Confidential

SAP ABAP Developer

Responsibilities:

• Worked as SAP ABAP/4 Developer and Faculty trainer
• Developed Reports and Forms
• Prepared assets of SAP ABAP for training purpose.
• Involved in training and faculty activities.