SUMMARY:

• SAP HANA certified consultant.
• Overall 15 years of IT industry experience out of which 13+ years in SAP technology with ASAP methodology, including project preparation, requirement gathering, gap analysis, As - Is, business blueprint, realization, post Go-Live user support and end user documentation and training under deadlines.
• Extensive experience in business processes across the following modules: MM, SD, and PM, QM, HR, FI/CO (COPA, AP, AR and GL) and APO Demand Planning functions.
• 11+ years of experience as a SAP BI/BW Consultant, 5 years as BOBJ Consultant, 2 years as native HANA1.0 consultant and 4 years as ABAP/4 Technical Consultant.
• Involved in 5 full life cycle BI/BW/BO implementations, 2 enhancement projects and 2 post Go-Live support projects in BI/ BW and 2 SAP R/3 ECC implementations.
• Proficient in analyzing and translating business requirements to technical requirements.
• Executed software projects for Automobile, Consumer Packaged Goods, Pharmaceutical, Textile, Pulp & Paper industry. Very strong experience in the Consumer Products Industry.
• Proficient in Data Extraction from SAP R/3 (FICO, MM, SD, PM and QM,HR), UD & DB, flat files and BW using extract structures such as LIS, LO Cockpit, CO-PA, FI and Generic Extractors using function modules and Views.
• Extensively worked in Net Weaver 2004s Business Information components in Data modeling for Info Objects, Info Providers (InfoCubes, DSOs), MultiProviders, MultiCubes and Info Sets, transformations and Transformation routines (field routines, start and end routines), DTP’s.
• SAP BW 7.4 on HANA: Based on LSA++ architecture developed Advanced DSOs, Composite Providers and Open ODS views. Converted InfoCubes to in-memory cubes and have working knowledge of Virtual Providers & Transient Provider. Understanding new SAP BW on HANA Layered Scalable Architecture concepts (LSA++).
• BW enhancements: Customized standard business content extractors and enhanced data sources in various applications using BADI / user exits. Extensive experiences in Transfer rules/ update rules. Writing exits for the purpose of master data reconciliation using APD (Analysis process Designer).
• BW Transports: Extensively involved in monitoring the extractors, data loads and reports before going into production and transporting the BW objects from development into quality and finally to production systems.
• BW Reporting: Expertise in Front-End Business Warehouse components like Query designer, BEx analyzer, Reporting agent, Variables, Jump query analysis using RRI. Created custom queries using conditions, exceptions, variables, structures, Restricted and calculated key figures.
• Performance tuning: Extensive experience in query and load performance using aggregates, Rollups, Indexes, Partitions and Info-cube Compression techniques. Evaluated statistical performance on OLAP using BW statistics. Proficient in interpreting and writing complex ABAP routines to improve the load performance.
• Testing: Performed unit testing on the complete data flow of the model developed from source system through BI, UAT (user acceptance testing) and data validation testing and prepared documentation. Planned the cut over activities before go live and performed the downtime activities.
• BOBJ: Experienced in Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info View, and Business Objects Enterprise (BOE), Dashboards (formerly Xcelsius), experienced with design mobile applications.
• Having conceptual knowledge of Analysis for Office, Design Studio and Lumira.
• Trained in Tableau and having conceptual knowledge in tableau dashboards.
• Worked on SAP BO connectivity with HANA.
• Experienced in designing and developing the Universe and updating the existing Universes, using Business Objects 3.1/4.0/4.1. Working knowledge of the Information Design Tool, Universe Design tool and the Central Management Console.
• Demonstrated understanding of Data Warehousing concepts and practices Demonstrated understanding of the functions of a data warehouse in the corporate environment Demonstrated understanding data warehousing processes, such as dimensional data modeling and data acquisition methodologies, data staging, cleansing, and transformation Proven track record of developing and managing ETL and DW deliverables. Strong analytical skills.
• Created various WEBI reports using SAP BW backend for SAP MM, SD and PM modules and also worked on WEBI reports using Oracle database.
• Experienced on RDS (Rapid Deployment Solution) for Asset analytics module using SAP BW7.4 and BO4.1.
• HANA: Experienced with SAP HANA data modeling and creation of Attribute View, Analytic View, and Calculation View by using HANA Studio and External HANA views.
• Experienced with connectivity to HANA from SAP BOBJ 4.0 suits of products.
• Working knowledge on Schemas, table definitions, Attributes, Measures and Hierarchies in HANA.
• Knowledge of SAP HANA security management including user roles and privileges.
• Experienced with creation of SQL Function and Procedure in HANA Studio.
• Experienced with universe creation from Information design tool on HANA database.
• Experienced on connecting various reporting tool to HANA database using MDX and BICS connection.
• Experienced with SAP HANA Replication Technologies. Triggered based (SLT) and ETL based (BODS 4.0).
• Worked on POC for 5 dashboards using Design Studio 1.2.
• Knowledge on RDS (Rapid Deployment Solutions).
• Experienced on SAP HANA Enterprise Edition.
• Working knowledge of Data Loading to HANA using SLT, Flat File and BODS.
• Creation of Universe on top of Analytics and Calculation views using Information Design Tool.
• Involved in documenting functional specifications, technical specifications, test cases, test results and production support documents.
• Good communication skills, interpersonal skills, self-motivated, quick learner, and team player.
• Involved in recruitment, technical interviews and presenting the final hiring recommendations for team members to meet overall project objectives, provides recognition and feedback on team member’s performance.

TECHNICAL SKILLS:

DATA WAREHOUSE: BI 7.X and BW 3.5.

ERP PACKAGES: SAP ECC 6.0/ 5.0, SAP R/3 4.7/ 4.6C.

REPORTING TOOLS: BEx Reporting, Report Designer, Business Objects ( 3.1, 4.0 & 4.1), SAP business objects WEBI, Dashboards (previously Xcelsius), Crystal reports (2008, 2011 and Enterprise) and BODS4.0 (Business objects data services).

HANA: 1.0 SPS7.0 and SPS8.0 and SAP BW7.4 on HANA.

FUNCTIONAL MODULES: Material Management, Sales and Distribution, Plant Maintenance, Quality Management, FI/CO, Human Resource, SAP APO.

RDBMS: Oracle 10g, MS SQL Server 2005.

LANGUAGES: ABAP/4.

OPERATING SYSTEMS: Windows 9x/ 2000/ XP/ Vista/ 7, MS DOS.

PROFESSIONAL EXPERIENCE:

Confidential, Muskego, WI

Business analyst cum senior

Responsibilities:

• Participate in Data Mapping workshops and follow-up meetings with the client business and IT teams. Assists in data mapping and GAP analysis between source and target data in BODS as per the blueprint.
• Created 8 SAP BW BEx queries using BEx Designer for Sales and Distribution and Materials management modules especially for procurement process. Also created SAP WEBI reports using BOBJ 4.0 using BICS connection for all the BEx queries.
• Worked on complex WEBI reports using cross tab reports.
• Well versed in utilizing formulas, sections, bookmarks, breaks and filters for WEBI report development.
• Experience using both BEx Queries and Universes (unx) as a data source.
• Worked closely with business and technology partners to seek and provide smart resolution to business issues. Adhere to BI/BW best practices and standards to maintain a stable Business Information environment.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing. Design processes to minimize data quality risks and proactively identify potential data issues. Prepare project related documentation (technical design and test scripts) during the different stages of a project job requirements.
• Worked in BW Governance team formulating processes, procedure and housekeeping activity.
• Used new SAP BW on HANA Layered Scalable Architecture concepts (LSA++). Utilized new BW Modeling Tools within HANA Studio.
• Worked on integrating solutions between native HANA and HANA on BW.
• Identified various reports in the functional areas of FICO, SD and MM, which are crucial for the business to run their day to day activities like Sales report, Bookings report and GL wise account balances.
• Interacted with business to gather requirements, prioritize work, develop enhancements to the existing system, and perform change management/training for BO Reporting and applications.
• Worked on advanced DSOs, Composite Providers and Open ODS views. Converted infoCubes to in-memory cubes and have working knowledge of Virtual Providers & Transient p rovider.
• Enhanced standard SAP BW data sources for various modules using BADIs (ABAP/4). Worked extensively on user exits using CMOD for BW BEx queries.
• Performed routine program modifications, performance tuning, problem solving, debugging, and unit testing. Worked on Optimizing end-user data access response times.
• Created various queries in SAP SD and MM modules using SAP query development tool.
• Worked on various WEBI reports on top of HANA database using HANA tables and various types of views.
• Transport Management in BI i.e. collecting SAP BI objects into transports.
• Worked on extraction of data from source systems using Delta Management and validation of the reports with source data.
• Designed and developed solutions for SAP SD, MM, HR (PA, TM, OM), and FICO reports including COPA on SAP HANA in Sidecar to SAP ECC 6 (HANA Studio modeling, calculation and analytical view design, using SLT.
• Worked on SAP HANA1.0 data modeling and creation of Attribute View, Analytic View, and Calculation View, Analytic privilege by using HANA Studio.
• Worked with SAP HANA Replication Technologies. Triggered based approach (SLT) and BODS 4.0.
• Performed necessary validations on source system tables in HANA database.
• Worked on loading data from SAP and Non-SAP sources using SAP data services and SLT into HANA Database.
• Worked on 5 dashboards using Design Studio 1.2.
• Worked on creating Column and Row tables in HANA database. Worked on SAP BO connectivity with HANA.
• Created Schema in HANA Studio. Worked on creating universes directly on HANA tables and views.
• Worked on creating views by executing complex SQL Statements in SAP HANA Studio
• Used HP QC as a defect logging and tracking tool along with Application Lifecycle Management ( ALM ).

Confidential

Senior SAP BO/HANA Consultant cum Team lead

Responsibilities:

• Worked on 10 WEBI reports for the ministry of Service Alberta on top of HANA database in a side car approach.
• Worked on SAP BW modeling of complex data flows for building cubes, DSO’s, Open ODS views, Composite providers and BEx reports on ERP modules like Finance, Controlling, COPA, Special Purpose Ledger, Sales and Distribution, Material management AR and AP etc.
• Worked on BW side complex routines using ABAP/4 code.
• Created several custom data extractors for full and Delta Management mode in ECC side using Function modules and Views using ABAP/4 BADI’s and User Exits.
• Prepared technical specs and business user documents for all the objects worked.
• Collecting transport requests for the objects developed using transport connection and transport error resolution.
• Activated standard business contents on SAP BW and ECC side.
• Created relational universes on top of database tables for developing WEBI reports.
• Created several complex and critical reports using WEBI, which includes tabular reports, pie characteristics, line charts etc.
• Worked on SAP HANA1.0 data modeling and creation of Attribute View, Analytic View, and Calculation View by using HANA Studio.
• Strong functional knowledge to understand business processes and work with functional consultants.
• Worked on documentation for capturing reporting requirements and getting sign off.
• Worked with SAP HANA Replication Technologies. Especially Trigger based (SLT).
• Expert in writing ABAP/4 code in BW specific needs for BW and ECC side requirements.
• Worked on POC of various BO WEBI reports for ministry of Service Alberta using HANA database.
• Ability to format reports in Web Intelligence for publication and distribution.
• Well versed in utilizing formulas, sections, bookmarks, breaks and filters for WEBI report development.
• Used HP QC as a defect logging and tracking tool along with Application Lifecycle Management (ALM).
• Scope of the work includes feasibility study of the reports, development, and Unit testing.
• Created WEBI reports for “incorrectly categorized Tickets” for daily, weekly, monthly and Quarterly data which involves navigation and drill down with Webi.
• Having Exposure to QC as I was involved in QA testing before moving objects to Test environment.
• Created WEBI reports for “Open Tickets by status” for daily, weekly, monthly and Quarterly data.
• Worked on 4 dashboards using Design Studio 1.2.
• Created WEBI reports for “incidents resolved by a resolver group” for daily, weekly, monthly and Quarterly data.

Environment: SAP Business Objects Web Intelligence 4.0, Lumira1.2, Design Studio 1.2, SAP BW 7.4 on HANA and HANA 1.0, SLT, BODS 4.0.

Confidential, Salisbury, MD

SAP BW/ ABAP/4 Consultant

Responsibilities:

• Worked on dataflow for manugistics and Rolling forecast InfoCubes which includes creation of real type InfoCubes and underlying data sources.
• Worked on trade rate promotions data flow.
• Worked on initial budget upload program for supplying data to CRM system.
• Worked on various complex start and end routine for feeding data to the various info providers.
• Created 5 SAP BW BEx queries for Sales and purchasing modules.
• Worked on BW data modeling including Business installation.
• Adhere to BI/BW best practices and standards to maintain a stable Business Information environment.
• Performed analysis and design; written technical specifications; created test scripts; configuration and programming in the SAP/BI environment, including testing and implementation.
• Enhanced standard data sources using BADIs (ABAP).
• Worked on various standard and custom function modules to enhance existing functionality of standard functions modules by creating wrapper programs from standard function modules. For example worked on Unit of Measure (UOM) function module for converting base line volume and total volume from CS to LB and vice versa.
• Created various process chains for master data and transaction data.
• Collected various types of BW standard and custom objects in transports for the team and worked on transport errors.
• Prepared technical spec and business user documents for all the objects worked.
• Participated in Unit Testing in DEV system and Integration Testing in QA system.

Environment: SAP BW 7.3, BEx Designer, BEx Analyzer.

Confidential, Milwaukee, WI

SAP BW/ BO Consultant

Responsibilities:

• Worked on enhancement of ‘District Special Pricing Performance’ data flow, scope includes enhancement of existing data Source on ECC side, enhancing BW data dataflow and creating new BEx queries and creation of BOE 3.1 Universes on top of BEx queries.
• Worked on enhancement of ‘POS/ Billing’ data flow, scope includes enhancement of existing BW data dataflow and creating new BEx queries using BEx designer and creation of BOE 3.1 Universes on top of BEx queries.
• Worked on various data sources for AR, AP and GL modules in SAP FI.
• Worked on data modeling using Star Schema and Extended Star Schema concepts.
• Written BW side complex transformation routines using end and start routines.
• Prepared technical spec and business user documents for all the objects worked.
• Participated in unit testing in DEV system and integration testing in QA system.
• Request to create BIAR file for collecting Universes and different WEBI’s for moving from BOE DEV to QA and Prod systems.
• Created 5 SAP BO WEBI reports on top of OLAP Universes using BO 3.1.
• Pointing of BOE Universes to the right systems after migration of Universes from DEV to Quality and Prod systems.
• Knowledge transfer to the Production Support team for all the developments worked.
• Completion of user accepting testing and final sign off after objects moved to Production system.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, BOE 3.1

Confidential, Racine, WI

SAP BW Consultant

Responsibilities:

• Worked on data modeling flow for Sales forecast VS actual sales using APD’s.
• Worked on 5 reports for inventory management using BEx7.0 and BO4.0 WEBI 4.0 reporting tools.
• Created various data flows using DSOs, InfoCubes, and Multi Providers.
• Written BW side complex transformation routines using end and start routines.
• Prepared technical specs and business user documents for all the objects worked.
• Worked on BEx variables for EU sales reports.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, BOE 4.0

Confidential, Milwaukee, WI

Senior SAP BI/ BO Consultant

Responsibilities:

• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• To activate Business Content Objects (Data Sources, Info Objects, InfoCubes, and DSOs) and also developed customized objects as per the requirement.
• Worked on Redesign of the COPA dataflow in order to provide additional flexibility, sustainability and improvement in load performance. Worked on various data sources for AR, AP and GL modules in SAP FI.
• Worked on extraction of data sources 2LIS 11 VAITM, 2LIS 11 VAHDR, 2lis 13 vdhdr, 2LIS 06 INV, 2LIS 17 3HDR, 0VENDOR ATTR, 0VEN COMPC ATTR, 0MAT PLANT ATTR, COPA extraction.
• Worked on Web-service data sources for Inbound (PI to OPS) and outbound flow for Demand Planning and Vehicle forecasting data in APO system.
• To create Technical Specs in accordance with the client’s requirements for SAP MM, APO, PM and COPA modules.
• Created SAP BW BEx queries for SAP COPA, MM and PM modules.
• Created OLAP universes on top of BEx queries and also created WEBI report on top of universes for SAP COPA, MM, HR (PA, TM) and PM modules.
• Designed custom extractors for MM,PM,HR and APO modules for Master and Transaction data using Function Modules, Web service, export method and Views & Activation of standard Extractor for data extraction from customized applications as well as standard applications, Implemented the delta functionality.
• Used HP QC as a defect logging and tracking tool.
• To create SAP BI queries, and Process Chains.
• Worked on OLAP variables and TVARVC variables, BI side Transformation level field routines, Start routines and End routines.
• Worked on DTP level routines for deleting overlapping and selected data requests based on time period.
• Collecting transport requests for the objects developed using transport connection and transport error resolution.
• Well versed in utilizing formulas, sections, bookmarks, breaks and filters for WEBI report development.
• Created 12 BOBJ Webi and Crystal Reports.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0,SAP BO3.1.

Confidential, Pittsburgh, PA

Senior SAP BI/ BO Consultant

Responsibilities:

• Created technical specs in accordance with the client’s requirements for SD, MM, HR, and QM modules.
• Worked on extraction of data sources 2LIS 12 VCITM, 2LIS 11 VAITM, 2LIS 11 VAHDR, 2lis 13 vdhdr, 2lis 13 vditm.
• Activated Business Content Objects (Data Sources, Info Objects, InfoCubes, and DSOs) and also developed customized objects as per the requirement.
• Created SAP BI queries, web templates, and process chains.
• Designed entire dataflow for conceptualization of solution.
• Carried out unit testing and integration testing after the developments.
• Coordinated and worked with the onsite and client teams on daily basis.
• Enhanced standard data sources using BADI for HR (PA, TM, and OM), QM, and SD modules as per the business requirement.
• Created generic data sources for HR module for master and transaction data using function modules and views.
• Worked on BI side transformation level field routines, start routines, and end routines.
• Worked on DTP level routines for deleting overlapping and selected data requests based on time period.

Environment: SAP BI 7.0, SAP R/3 ECC 6.0.

Confidential, Longmont, CO

Senior SAP BW Consultant

Responsibilities:

• Process BW Support: Participated in support issue resolution on daily basis, system administration, data load monitoring.
• Handled change requests for any modification in existing functionality, and handled service calls for issues encountered in production system for reports and data loads.
• Created generic data sources using FM and Views, and carried out enhancement of standard data sources using BADI and user exits.
• Evaluated statistical performance using BW Statistics and suggested recommendations for performance optimization. Improved data load and query performance by doing compression, creating aggregates, indexes.
• Reviewed work done by other team members (code review and TS review).
• Updated technical specifications as per the change request, and prepared support and end user training documents.

Environment: SAP BI 7.0, SAP R/3 ECC 5.0.

Confidential

Senior SAP BW Consultant

Responsibilities:

• Participated in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, integration testing, unit testing (UAT) to Go-Live production support.
• Extensively worked on SD info cube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Worked in business content activation for Data Sources, Info Packages, Info Objects, InfoCubes, DSOs and DTPs, and transformations.
• Enhanced various data sources using CMOD and LBWE.
• Wrote various complex routines (field routines, start routines, and end routines).
• Worked on various OLAP variables and DTP level routines.
• Created new Info Providers in SAP BI depending upon the end user needs.
• Extensively worked on BEx reporting and workbooks.
• Extensively worked on RRI, cell definitions, variable offsets, exemptions, conditions, RKFs, and CKFs.
• BW Transport: Worked on collecting transports via transport connection, error resolution in transports.
• Participated in unit and integration testing, UAT to Go-Live production support of OTC, RTR, APO reports.

Environment: SAP BI 7.0, SAP R/3 ECC 4.7.

Confidential

SAP BI/ BW Consultant

Responsibilities:

• Worked on the standard extractors for FI/CO, MM modules. Enhanced business content extractors using LBWE and CMOD transactions. Deleted and installed data from setup tables for specific application components.
• Developed extract structures and Data Sources in Financial Accounting to facilitate the data extraction to BW and to report using classification of various data elements. Extended the extract structures by adding new fields and populating them with the user exits.
• Designed queries, reports, and workbooks. Used calculated key figures and restricted key figure conditions, exceptions reporting, and customer exits for calculating the YTD and JTD values.
• Created process chains and Meta chains to automate the data loads for periodic upload of text data, master data, and transactional data.
• BW Transport: Transport connection, error resolution in transports.
• BW Support: Process chains, data load monitoring, support issue resolution, atomizing data loads, system administration.

Environment: SAP BW 3.5, SAP R/3 ECC 4.7.