SUMMARY

• 14+ years of experience in software including 12+ years’ experience in SAP BI (3.X and 7.0,7.3,7.4) as a Techno Functional consultant.
• Certified SAP BW, ABAP, FICO, HANA Consultant
• Seven Full BW Life Cycle project implementation experience in BW.
• Extraction, Transformation and Loading of Data (ETL) - preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads using IDoc and PSA), loading data via flat files and staging BAPI, scheduling and monitoring data loads.
• Expertise in SAP BI/BW development and its components including InfoObjects, InfoSources, ODS/DSOs, InfoCubes, Transformations, DTP’s, Update/Transfer routines, User Exit coding, Function Modules, BEx components and among others.
• ASAP Methodology knowledge and implementation.
• Extensive hands-on experience with R/3 and flat file loading for transactional data, master data- attributes, texts and hierarchies.
• Gathering business requirement, analyze gaps and build Data Model, Design and Development of Enterprise Data Warehouse in Finance, Human Resource area.
• Participated in Design review, POC using various BEx tools, trouble shooting.
• Build Functional specification, technical specification, system test plan execute system test scenarios and Install Business Contents.
• Extensively wrote ABAP in Transformation, End routines and User Exits.
• Extensively used ABAP for Data Source enhancement using BADI, User Exits.
• Extensively wrote User Exits for Custom Variables and Authorization variables.
• Expertise in Report Generation - Worked extensively in BEX Analyzer, Query Designer, Report Designer and Web Application Designer. Created multiple queries using Query Designer,Created multiple workbook using BEx Analyzer .
• Extensively worked on Advanced Excel functionalities, formulas, V-Look up, H-Lookup, Cell referencing and other advanced formulas
• Extensively worked on Performance Tuning, BI Statistics, Query Monitor, Aggregates, Indexes, Cube partitioning, Precalculated Web Template.
• Created and maintained Aggregates
• Created Custom Process chains to automate periodic transaction data loading and monitored data loading for these process chains
• Extensive Production Support experience.
• Used BEx Broadcaster for pre calculating and distributing Web templates, queries and workbooks.
• Extensive knowledge of using Visual Composer for Interactive Hierarchy navigation.
• Used Analysis Process Design to explore and identify hidden or complex relationships between data.
• Working knowledge of Business Object
• Created Crystal Report using SAP BI Queries and Data providers,
• Created multiple universes for Webi Reports.
• Created Xcelcius Dash board from SAP BI data.
• Worked in creation of HANA views and created reports using Analysis for Office Excel tool
• Trained end user and created various document on Functional and Technical Design specification.
• Experienced in Hana Cube Optimization.
• BW Performance Tuning.
• Managed group of Developers and Tester in end to end implementation.
• Created multiple training material for various group of users.
• Created different Hana views.
• Managed group of offshore and onsite developers.

TECHNICAL SKILLS

Data Warehousing: SAP-BIW 3.0B, 3.1C, 3.5 & BI7.0, BW 7.3,7.4 BPC,BPS NW, BO

Cross Application: ALE, EDI, IDOC, RFC and BAPI’s.

Languages: C, C++, Java and ABAP/4

Scripting Language: Java Script, Unix Shell Script, HTML, XHTML

Operating Systems: Windows 2000 Server, Linux(5.2 & 6.2) and MS-Dos

Databases: MS-Access, SQL Server 6.5, Oracle 7.x/8.0

Testing Tools: QTP, LoadRunner, Mercury Quality Center, Test Director

PROFESSIONAL EXPERIENCE

Confidential, Springdale, AR

BW Architect SAP BI/BW Consultant

Environment: SAP BW 7.3(Hana), BPC, SAP R/3 ECC 6.05, FSCM (Dispute), FI-CO, SD,BPC, Vistex, Manu, BOBJ

Responsibilities:

• Working as BI Architect in Tyson Core Project.
• Gathering new requirements.
• Designed and developed backend design.
• Created Functional and Technical Design Specs.
• Creating prototypes for new solutions
• Created new DSO, SPO, Multi-provider.
• Created transformation using routines, start routines and end routines.
• Created ODP datasources from Hana Views.
• Created new SPO and DSO from Hana views and ECC Data.
• Enhanced generic extractor, created custom extractor for Dispute data.
• Extracted data from Legacy Manu system.
• Changed existing Infocube and multi provider design.
• Provided Data for BPC planning system.
• Created multiple queries using Query Designer.
• Designed and developed Webi reports.
• Coordinate and perform different testing cycles
• Created training materials for end users.
• Designed object using LSA++ architecture
• Worked in creation of HANA views Analytical and Calculation views, stored procedures.
• Created Advanced Analysis for MS Office workbooks for business users
• Managed team of developers offshore and onsite.

Confidential, MN

Solution Architect SAP BI/BW Consultant

Environment: SAP BW 7.3(Hana), 7.4,BPS, SAP R/3 ECC 6.05, FI-CO, CRM, SD

Responsibilities:

• Working as BI Solution Architect in TPM Reporting Project
• Designed and developed backend design.
• Created Functional and Technical Design Specs.
• Created new DSO, Multi-provider.
• Created transformation using routines, start routines and end routines.
• Created Datasources from Hana Views.
• Created real time Transactional cube using BADI from CRM data.
• Changed existing Infocube and multi provider design.
• Created multiple queries using Query Designer.
• Managed team of developers offshore and onsite.

Confidential, New York, NY

SAP BI/BW Consultant

Environment: SAP BW 7.1, SAP R/3 ECC 6.05, FI-CO, IS-Retail, SD, MM,PP, Blue Martini, BOBI 4.1

Responsibilities:

• Working as BI Lead Consultant/Architect in Omni Channel Project
• Created Functional and Technical Design Specs.
• Created custom extractor to extract data that from different source system (Blue Martini, Direct).
• Created new DSO, Cubes, Multi-provider.
• Created new transformation using routines, start routines and end routines.
• Loaded the Transactional data from Non SAP system.
• Tailored Transformation using routines and start routines to meet requirements at optimum performance.
• Created multiple queries using Query Designer.
• Created Custom BEx workbook using BI Query.
• Created Multiple Crystal Reports using BEX Queries.
• Worked in creation of HANA views and created reports using Analysis for Office Excel tool
• Created Advanced Analysis for MS Office workbooks for business users
• Managed team of developers.

Confidential, Harrisburg, PA

Architect SAP BI/BW Consultant

Environment: SAP BW 7.3, BWA, SAP R/3 ECC 6.05, FI-CO,BPC,FM,BPC,MM,SD,PP NW10, MS Project, Power Point, MS Office

Responsibilities:

• Working as BI Lead Consultant/Architect in Grant-Treasury Reporting project
• Created Functional and Technical Design Specs.
• Created custom extractor to extract data that from different source systems (SAP R/3 and Legacy Treasury).
• Created new DSO, Cubes, Multi-provider.
• Created new transformation using routines, start routines and end routines.
• Loaded the Transactional data from R/3 and Legacy System.
• Create and manage info objects, DSO and Cubes, Multi Providers, info package, data sources.
• Tailored Transformation using routines and start routines to meet requirements at optimum performance.
• Created multiple queries using Query Designer.
• Created Custom BEx workbook using BI Query.
• Created multiple FM Balance Report.
• Performance tuning with BWA indexes.
• Created APD to generate output files.
• Working as BI Lead consultant/Arcitect in the upgrade project.
• Created Functional and Technical Design Specs for the backend and front end migration.
• Migrated majority of the backend dataflow from 3.5 to 7.3.
• Migrated 1100 BW Queries and workbook to 7.3.
• Created Functional and Technical Design Specs.
• Lead the BW team to migration work.
• Changed most of the old Transfer and Update ruled to Transformation
• Created new ABAP start and end routines for the new start and end routines.
• Worked with the Hybrid Data provider and Semantic Partitioned infoprovider.
• Lead the training activities of end users.
• Provided data for BPC planning.

Confidential, ST Paul, MN

SAP BI/BW Architect

Environment: SAP BI 7.1, 7.3 SAP R/3 ECC 6.0, Hyperion, Mshare, IDM, MS ProjectThe primary objective of this project is to develop SAP BW Daily Sales and Planning reports for Long Term Financial Restructure project.

Responsibilities:

• Working as BI architect in LTFR project.
• Created custom extractor to extract new data that from different source systems.
• Created and added new info objects to existing DSO and Cubes.
• Created new transformation using routines, start routines and end routines.
• Created new Custom-built Hierarchies.
• Loaded the Transactional data from SAP R/3 and different source system using delta update and full update methods
• Loaded planning forecast and estimate data from Hyperion and mShare datamarts.
• Create and manage info objects, DSO and Cubes, Multi Providers, info sources, data sources.
• Tailored Transformation using routines and start routines to meet requirements at optimum performance.
• Enhanced Data Sources using BADI and User Exits.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues
• Created BI Security objects and Security Roles
• Created multiple queries using Query Designer. Custom BEx workbook using BI Query.
• Extensively used ABAP for Variable user exit, Transformations, Routines
• Created Functional and Technical Design Specs.
• Upgrade BI 7.1 to BW 7.3
• Lead the training activities of end users.
• Created APD and Open Hub to generate output files.

Confidential

SAP BI/BW Architect

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, FI-CO,BW-IP MS Project

Responsibilities:

• Working as BI architect in DACF project.
• Created custom extractor to extract new data that DACF company code is reporting.
• Created and added new info objects to existing DSO and Cubes.
• Created new transformation using routines, start routines and end routines.
• Created new Custom-built Hierarchies.
• Loaded the data from R/3 to BW and used delta update and full update methods
• Translated and mapped New GL Data to custom BI objects.
• Create and manage info objects, DSO and Cubes, Multi Providers, info sources, data sources.
• Tailored Transformation using routines and start routines to meet requirements at optimum performance.
• Enhanced Datasources using user exits.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues
• Created multiple queries using Query Designer and custom BEx workbook using BI Query.
• Created BI web reports using web application designer.
• Created planning model and Input Ready Queries for Planning Reports using Integrated Planning.
• Managing Project activities in MS Project

Confidential

BI Architect/Project Lead

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, SD, MM, PP,FI-CO

Responsibilities:

• Working as a BI architect/Project Lead in Confidential West Pharma BI implementation.
• Managing Team of 6 for the west pharma client implementation.
• Managing resource and budget allocation for the project.
• Documenting process and project plans.
• Modified Logistic extractor to extract data from ECC (SD, MM, PP, COPA).
• Created and added new info objects to existing DSO and Cubes.
• Created new transformation using routines, start routines and end routines.
• Created new Custom-built Hierarchies.
• Loaded the data from R/3 to BW and used delta update and full update methods.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues
• Created multiple queries using Query Designer.
• Created Custom BEx workbook using BI Query.
• Created APD to generate interface files

Confidential, New York

Sr SAP BI/BW Consultant/ Architect

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, IS-Media, FI-CO, BW-IP,CRM,ADMARC

Responsibilities:

• Created InfoObjects, Cubes,DSO, MultiProvider,
• Developed Process chains, and worked extensively with daily load errors.
• Worked on the development of Custom-built Hierarchies.
• Loaded the data from R/3 to BW and used delta update and full update methods
• Translated and mapped ADMARC legacy data to IS Media specific BI objects.
• Managed data loading using both full update and delta update. Also, scheduled and monitored data loads to ensure smooth uploads by managing packet sizes and eliminating inconsistencies.
• Create and manage info objects, DSO and Cubes, Multi Providers, info sources, data sources.
• Enhanced CRM data sources using BADI.
• Tailored Transformation using routines and start routines to meet requirements at optimum performance.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues
• Used BI Statistics, Query Monitor, Aggregates and Indexes to enhance query performance.
• Extensively used Query Designer to create queries with Variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Created multiple queries using Query Designer, published them in BI Portal.
• Created Dashboard report using Web Application Designer.
• Extensively used Java Script and HTML/XHTML creating Dash board reports
• Experience in creating Transports requests, collecting objects and transporting from one system to another across the landscape
• Activation of IS- Media Business Content DataSources in BI
• Created Custom Process chains to automate periodic transaction data loading and monitored data loading for these process chains.
• Extensively wrote ABAP codes in Transformation, End routines and User Exits.
• Extensively wrote User Exits for Custom Variables and User Authorization variables.
• Extensively worked on Performance Tuning, BI Statistics, Query Monitor, Aggregates, Indexes, Cube partitioning.
• Used open hub to distribute the data to different external systems like Oracle SQL server
• Handling Post Production issues, load issues and query modification as per user need.
• Created BI Dashboards with Web Application designer.
• Created planning model and Input Ready Queries for Planning Reports using Integrated Planning.
• Created Crystal Report using BI Queries.
• Extensively documented techniques by developing guidelines, composing training materials.
• Created Funcitonal and Techincal document using VISIO/Powerpoint.

Confidential

Sr SAP BI Consultant

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, FI-CO, HR, BPS, Cognos, Visual Composer, BI Accelerator

Responsibilities:

• Extensive use of Process Chains to automate loading of all master and transaction data.
• Worked on the development of Custom-built Hierarchies using flat file.
• Managed data loading using both full update and delta update. Also, scheduled and monitored data loads to ensure smooth uploads by managing packet sizes and eliminating inconsistencies.
• Tailored Transformation using routines and start routines to meet requirements at optimum performance.
• Used BI Statistics, Query Monitor, Aggregates and Indexes to enhance query performance.
• Involved with profit center accounting cubes, accounts payable cubes, account receivable cubes, General Ledger cubes as a part of SAP BW implementation.
• Created queries to generate report in Cognos system.
• Extensively used BEx Analyzer, Web Analyzer created queries with Variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Extensively created various web report using Web Application Designer and Report Designer.
• Developed Process chains, and worked extensively with daily load errors as a part of the production support team.
• Experience in creating Transports requests, collecting objects and transporting from one system to another across the landscape
• Provided Quality Assurance and technical assistance during go-live.
• Handled postproduction support and trained of end-users on query development and trouble-shooting.
• Worked closely with the business user in load testing and performance tuning.
• Extensively worked on Performance Tuning, BI Statistics, Query Monitor, Aggregates, Indexes, Cube partitioning, Precalculated Web Template.
• Extensively created and maintained Aggregates.
• Extensively documented techniques by developing guidelines, composing training materials.
• Performed Technical presentations for the client's employees.
• Activation of Business Content DataSources in BI
• Created Custom Process chains to automate periodic transaction data loading and monitored data loading for these process chains.
• Used BEx Broadcaster for pre calculating and distributing Web templates, queries and workbooks.
• Configured and managed data handling using BI Accelerator.

Confidential

Sr SAP BI Consultant

Environment: SAP BI 7.0, SAP R/3 ECC 6.0, BEx Explorer, SAP- HR, Visual Composer, FI-CO

Responsibilities:

• Involved in Requirement Analysis, data modeling, design, and technical implementation.
• Developed multi-dimensional data models using star-schema and extended star schema techniques.
• Involved in the Design and Development of Cubes, DSO objects, MultiProviders and InfoSets.
• Participated in Design review, POC using various BEx tools, trouble shooting.
• Developed Transformation to extract data from various DataSources into transfer structures.
• Created and enhanced Generic DataSources on tables and InfoSet queries.
• Extensive use of Process Chains to automate loading of all master and transaction data.
• Worked on the development of Custom-built Hierarchies using flat file.
• Managed data loading using both full update and delta update. Also, scheduled and monitored data loads to ensure smooth uploads by managing packet sizes and eliminating inconsistencies.
• Used ABAP extensively to write Start routines, End routines, User Exits.
• Enhanced Generic data sources using User Exits.
• Query Monitor, Aggregates and Indexes to enhance query performance.
• Extensively worked on Performance Tuning, BI Statistics, Query Monitor,Aggregates, Indexes, Cube partitioning.
• Involved with profit center accounting cubes, accounts payable cubes, accounts receivable cubes as a part of SAP BW implementation.
• Extensively created various web report using Web Application Designer and Report Designer.
• Created multiple queries using Query Designer, published them in BI Portal.
• Created multiple workbook using BEx Analyzer using Advanced Excel functionalities, formulas, V-Look up, H-Lookup, Cell referencing and other advanced formulas
• Configured Reporting Agent to run and execute queries during off-peak hours.
• Involved with Basis personnel to transport objects from development to quality environments using Transport Connection.
• Provided Quality Assurance and technical assistance during go-live.
• Handled postproduction support and trained of end-users on query development and trouble-shooting.
• Extensively documented techniques by developing guidelines, composing training materials.
• Performed Technical presentations for the client's employees.
• Activation of Business Content DataSources in BI
• Involved in Performance enhancement features such as Cube Repartitioning, Indexing, Remodeling, maintaining Aggregates, Rollups and cube Compression
• Created Custom Process chains to automate periodic transaction data loading and monitored data loading for these process chains
• Created reports for Number of entries(0PA C01 Q003), Percentage Breakdown of Entries(0PA C01 Q010), Entry Rate(0PA C01 Q022), Net Entry Rate(0PA C01 Q005), Number of Entries FTE(0PA C01 Q017)
• Used BEx Broadcaster for pre calculating and distributing Web templates, queries and workbooks.
• Used Visual Composer for Interactive Hierarchy navigation.
• Used Analysis Process Design to explore and identify hidden or complex relationships between data.
• Extensively wrote ABAP codes in Transformation, End routines and User Exits.
• Extensively wrote User Exits for Custom Variables and User Authorization.

Confidential - Los Angeles CA

SAP BW Consultant

Environment: SAP BI 7.0, BW3.5 SAP R/3 ECC 5.0, BEx, HR, FI-CO, Windows 2000.

Responsibilities:

• Interacted with Subject Matter Experts (SME), Business Analysts and Users for preparation of Data Modeling, Business Content, Granularity, and Query design.
• Loaded the data from R/3 to BW and used delta update and full update methods
• Created the Process Chains for periodic load of Master Data and Transaction Data from R/3 system to Data targets and optimized the load performance by data selections and number of Info Packages
• Created reports using Business Explorer and Web Application Designer (WAD).
• Performed tuning of queries using Cube Repartitioning, Indexing, Remodeling, Aggregates of InfoCubes, rollups and cube compression.
• Used Transport Connection for the transportation of InfoObjects, InfoProvider etc to the Quality Server and Production server
• Extensively used BEx Analyzer, created queries with Variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Processed failed IDocs to ensure successful loading of external data.
• Extensively worked on BEx Analyzer and Query designer and Web application designer to create Queries to forecast and analysis budget using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Created reports for Head Count/Personnel Structure( 0PA C01 Q001), Head Count Part-Time/Full-Time Workers(0PA C01 Q020), Headcount According to Capacity Utilization Level(0PA C01 Q019), Average Length of Service(0PA C01 Q024),Average Headcount FTE(0PA C01 014)
• Used BEx Broadcaster for pre calculating and distributing Web templates, queries and workbooks.
• Used Visual Composer for Interactive Hierarchy navigation.
• Used Analysis Process Design to explore and identify hidden or complex relationships between data.
• Used APD to create different interface files for
• Extensively wrote ABAP codes in Transformation, End routines and User Exits.
• Extensively wrote User Exits for Custom Variables and Authorization variables.
• Upgrade BW 3.5 objects to BI 7.0.

Confidential, GA

SAP BW Consultant

Environment: SAP BW 3.5B, SAP R/3 4.6C, BEx Analyzer, SD, FI/CO,CRM, Windows 2000/ NT.

Responsibilities:

• Involved in identification of business requirements meeting the needs of end-users in sales and distribution.
• Extensively involved in Data Modeling, Installing Business Content, Creating InfoObjects, InfoCubes, and ODS objects.
• Performed Event Scheduling and created Process Chains, and Monitor settings.
• Involved in Reporting Agent configuration and settings, Jump-start and routine build up.
• Extracted data from R/3 using LIS and Generic extractors.
• Performed DataSource enhancements and worked with generic extractors, User Exits and customized delta built up for DataSource.
• Enhanced Data sources using User Exits
• Performed Logistics Cockpit configuration and customization and setting multiple source systems including SAP and Flat Files.
• Responsibilities included fixing and partitioning PSA, setting-up ODS, and combining ODS from different modules, writing Transfer Rules, transfer routines, update start routines and update routines and InfoCube partitioning.
• Tailored Transfer Structures, Communication Structures and Update Rules to optimize performance.
• Uploaded master data and transactional data from SAP R/3 Via Data staging to PSA, ODS and InfoCubes. Analyzed InfoCubes (via RSRV) created and maintained Aggregates (RSDDV) to improve the query response time.
• Extensively used Query Designer to created queries, variables, filters, calculated KeyFigures, restricted KeyFigures, charts and workbooks. Executed Hierarchy/attribute changes for reporting.
• Provided quality assurance and technical assistance during go-live.