SUMMARY

• 7 Plus Years of experience in SAP BW / BI & SAP HANA.
• Experienced in BW Implementations (Total 3 BW Implementations and (BI 3.5 - BI7.0, SP05 to SP13, SP14) Upgrade, 3 Support Projects ).
• Familiar and working knowledge all the Concepts of SAP HANA.
• Working in Hana Implementation Project.
• Extensive knowledge of Attribute view, Analytical view, Calculation view, Decision view and complete Modeling knowledge of SAP HANA Tool.
• Extensive knowledge of Hana Servers.
• Extensive knowledge of Hana Securities.
• Performed SAP BW upgrade from 7.4 SP05 to SP14.
• Strong experience with Scrum methodology and well versed in writing user stories.
• Excellent understanding of Business Requirements Gathering, Translating Requirements into Specifications and Application Design.
• Proficient in using Agile Scrum methodologies, followed sprint/standup sessions.
• Worked on 3 Implementation and 3 Support Projects for various clients in Retail, Warehousing, Energy and Utilities Domain.
• Expertise in Advance Query Development and Optimization for performance, Performance Tuning, Data Modeling, Data Objects (Infoobjects, DSOs, Infocubes), Generic Data Extraction, Logistics (LO) Cockpit, FI-CO Extraction (including New GL), BEx and Portal Config / Web Reporting,
• Worked on BW with BWA to configure Infoproviders for BWA.
• Requirements gathering and Architecting them into meaningful Reports and Data Models in a Highly Customized Environment
• Experience in SAP ECC and extracting and modeling that data in BW
• Strong in ABAP related to ECC Datasources and BW (Transformations and user exits).
• Validation of BW data for many purposes
• Knowledge of new features of BW7.3 such as Master Data Deletion, Data Flow Copy, Process chain from Data Flow, Hybrid Providers, In-Memory options for DSOs, Read DSO in Transformations, Init. W/o Data in DTP, SPOs (Semantic Partitioning Objects), DSO Partitioning, Multiprovider as datasource etc.
• Worked on BW with BWA to configure Infoproviders for BWA.
• Extensive knowledge of SAP BW / BI components like InfoObjects, DataSource, Multiproviders, Infopackage, DSO, Infocube and Process chains .
• Good knowledge of SAP ABAP specific to SAP BI usage.
• Extensive experience in BI Support related work
• Debugging Data load errors, Delta Queue monitoring and Extractor Checker process.
• Good analyzing skills in understanding the impact of a change in BW system.
• Excellent communication skills, Client Interaction, Work Management and leadership qualities.
• Ability to work well with all levels of the organization.
• Superb coaching and mentoring skills.
• Prioritizing important tasks and ensuring they get done first.
• Excellent oral and written communication skills.
• Allocating daily jobs and workloads.
• Training new team members.
• Acting as a resource for other staff members.
• Managing team performance and progress.

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Team Lead SAP BW Developer

Responsibilities:

• Gather requirements and convert them in to Data Models
• Data Modeling - Convert Logical and Physical Data Models in to BW Designs
• Extract data from Flat Files received from Market Data Providers like IMS
• Performed SAP BW upgrade from 7.4 SP 05 to SP 14.
• Created document for all the pre-upgrade and post-upgrade activities.
• Apply SAP Note required for SAP upgrade and resolved all the issues while doing upgrade.
• Generate Reports for Marketing Plans for Representatives (By Territory, Division etc.)
• Work on proposals (effort and cost) for various phases of the project
• Using the Agile methodology and well versed in writing user stories.
• Strong experience with Scrum/Sprint and Story writing methodology.
• B W: Expert in BW and worked on all aspects of BW configuration involving InfoCube, Data Store Objects (DSO), BWA (BW Accelerator), Multi-Providers, InfoSets, Aggregates, Analysis Process and Design (APD), BW Administration, DTP, Process Chains.
• BEx Reporting - Worked extensively with BEx Analyzer, Query Designer in building Queries, Variables
• Interacting with Client and Users for new requirement and new recommendations.
• Preparing Estimate documents. Efforts needed.
• Involved in creation of Reports by using BEX-Designer.
• Involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Resolution and analysis of priority tickets.
• Implementing Change Requests.
• Involved in requirement gathering, preparing technical specs.
• Extensive use of free characteristics, Restricted key figures, Calculated Key figures, Structures, Exceptions, Conditions and Variables.
• Worked extensively on Administration work bench. Customized Info Objects, Info sources, Data sources and Info cubes.
• Enhancement of BW Solution for Performance - Volume of Business
• Enhance BW Designs for faster performance of Volume of Business Reporting - Report runtime target of under 10 seconds
• Create Highly Aggregated Levels with Counts and Quantities.
• Create Process Chains and Meta Chains.

Confidential, Chicago, IL

SAP BW Developer

Responsibilities:

• B W: Expert in BW and worked on all aspects of BW configuration involving InfoCube, Data Store Objects (DSO), BWA (BW Accelerator), Multi-Providers, InfoSets, Aggregates, Analysis Process and Design (APD), BW Administration, DTP, Process Chains.
• BEx Reporting - Worked extensively with BEx Analyzer, Query Designer in building Queries, Variables
• BW-CRM: Used Marketing, Sales and Service Analytics in CRM space for clients. Also knowledgeable on Cross-Application Analytics covering Customer, Product and Channel Analytics.
• Security: All aspects of HANA Security.
• Data Services: All aspects Data Migration.
• Preparing Estimate documents. Efforts needed.
• Involved in creation of Reports by using BEX-Designer.
• Using the Agile methodology and well versed in writing user stories.
• Strong experience with Scrum/Sprint and Story writing methodology.
• Involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Working on SAP HANA Studio for Modeling and with the SLT/DXC for Data provisioning. Experience with Modeling the HANA views - Attribute view, Analytical views and Calculation views.
• Working on SQL and SQL Scripting in HANA
• Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Resolution and analysis of priority tickets.
• Implementing Change Requests.
• Involved in requirement gathering, preparing technical specs.
• Extensive use of free characteristics, Restricted key figures, Calculated Key figures, Structures, Exceptions, Conditions and Variables.
• Worked extensively on Administration work bench. Customized Info Objects, Info sources, Data sources and Info cubes.
• Worked on critical P2 incidents and their resolutions.
• Worked with 3.x flows and the data load issues.
• Have been a part of critical releases and refreshes.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Extract Blocked Import and Export Document Details by creating Generic, Function Module based Extractor.
• Leveraged standard SAP Transactions to extract data, theirby ensuring accuracy.
• Create Process Chains and Meta Chains.
• Enhance BW Designs for faster performance of Volume of Business Reporting - Report runtime target of under 10 seconds
• Create Highly Aggregated Levels with Counts and Quantities.
• Create Process Chains and Meta Chains.

Confidential

SAP BW Developer

Responsibilities:

• Gather requirements and convert them in to Data Models
• Data Modeling - Convert Logical and Physical Data Models in to BW Designs
• Extract data from Flat Files received from Market Data Providers like IMS
• Generate Reports for Marketing Plans for Representatives (By Territory, Division etc.)
• Work on proposals (effort and cost) for various phases of the project
• Query Tuning using RSRT / RSRT2
• Troubleshooting using RSRV
• Partner Profile and Source System Config.
• Log Management (SLG1) and other tasks
• BW Statistics and Tech. Content
• Re-alignment of data using Mapping Infoobjects
• Analyze reports available in FI-CO, SD and MM
• Data extraction from FI Line items using coupled extraction of data sources (0FI GL 4. 0FI AR 4 and 0FI AP 4) “As is” and “To be” analysis.
• Data Modeling: Creation of Infoobjects, Infocubes, DSO, Multiproviders, Infopackages, Transformations and Process chain.
• Created generic data source on Views, tables, Domains
• Enhancement of standard as well as Generic Data sources.
• Written ABAP codes for Enhanced fields in datasources.
• Involved in transportation of BI objects from development to quality to production.
• Reconciliation of data from R/3 to BW after replication of data sources.
• Creation of Process Chains.
• Routines: Written various routines including Master Data Look up, Read from DSO.
• Been Part of User Acceptance Testing and Prepared Documents for the same.

Confidential

SAP BW Developer

Responsibilities:

• Actively and regularly involved in daily, weekly and monthly load monitoring using Process Chains.
• Analyzing and rectification of the reasons for frequent failures in load monitoring.
• Handling tickets of priority 1, 2 and 3.
• Reconciliation of data from R/3 to BW after data loads.

Confidential 

SAP BW Developer

Responsibilities:

• Enhancement of existing Data sources (standard as well as Generic Data sources) of Origin BW landscape.
• Data Load Monitoring and solving Production load failures.
• Monitoring Process Chains and Data Quality activity.
• Analyze the errors in the data loads.
• Finding the root cause for the Errors of the chains if they have not started in time.
• Reconstruct the data requests from PSA in case of data load failure.
• Manage the data targets by having the correct and up to the data.
• Resolved and fixed complex and medium complexity tickets.
• Performed RCA for incidents / problems and documented the same.
• Daily/Weekly/Monthly update to productivity tracker/timesheet.
• Timely reporting of issues to project lead / PM.
• Code and test enhancements/CRs.