EXECUTIVE SUMMARY:

• 12 Years and 06 months of Experience in Information Technology.
• 9 Years & 03 months of experience in implementation of SAP BIW.
• Handled 2 full Life cycle BW implementations, with Lead experience.
• Involved in three full life cycle implementations for different modules in Sap BW like SD, MM, FI - CO, PS and PP which involves all phases like Gap analysis, Blue Printing, Realization, Data extraction, Data Modeling, Data loading, Production Support, Testing, Documentation, Requirement analysis, End user documentation, Reporting and Go-Live Check.
• Proficient in Data Extraction from SAP ECC (FI/CO, MM, SD, PM and PS), flat files and BW using extractors such as LO Cockpit, CO-PA, FI and Generic Extractors.
• Extensively worked on Business Information Warehouse Info cubes, SPO’s, DSO’s, and Info-objects.
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques.
• Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer, Web Application Designer, Web Reports & WEBI) for Queries, workbooks, calculated key figures, restricted key figures, filters, conditions, exceptions and have good knowledge on variables and its processing types.
• Extensively worked as a Business Intelligence Developer on Data Warehousing projects.
• Actively contributed in cutover activities for SD, MM, PS and FICO modules.
• Good skills in dealing with production support issues, which involved debugging of data loads, process chains and monitoring and scheduling data loads.
• Strong planner and organizer with demonstrated ability to develop business solutions that increase productivity, efficiency and profitability.
• Excellent team player with good analytical and problem solving skills, Good Technical writing skills.
• Good communication skills, strong decision making skills, organizational skills, and customer service oriented.
• Worked on Integrated Planing.
• Expert knowledge in InfoCubes (Customized/Standard), MultiProviders, RemoteCube, DSO (Standard, Write optimized).
• Expert knowledge in Infosets, Open hub destinations, BEx query designer, Analyzer and workbooks.
• Expert knowledge in Web application designer, Process chains(Creation/Monitoring) and Hierarchies.
• Expert knowledge in BW Reporting Authorization(3.5) & Analysis authorization in 7.0.
• Worked in Product costing-COPA extractions into BW.
• Expert knowledge in data modeling of LO Cockpit (MM, SD).
• Modification and enhancement of SAP standard functionality extensive knowledge on system defined and custom defined structures.
• Worked on Analysis Process Designer.
• Published Articles and Blogs in SAP SDN related to “Demystifying aggregates in SAP BI 7.0”
• Performance Tuning: Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning.
• Worked on BW Accelerator to boost BW Performance and Query Performance through sophisticated in-memory data compression and horizontal and vertical data partitioning.
• SAP BO Enterprise Reporting
• Business Intelligence / Enterprise Reporting
• Semantic layer (Universes and metadata layer) creation
• Semantically partitioned objects.
• HANA Modeling Techniques.
• Data warehousing workbench modeling techniques.
• Data extraction in SAP BI.
• BEX Query designer, BEX Analyzer.
• Business Content.
• BPC Integration with BI.

TECHNICAL SKILLS:

Others/Tools: SAP R/3 4.5, 4.6C, 4.7, ECC 6.0Net WeaverSAP BI 7.4/7.3, BW 3.5, SAP HANA.

Other Tools: SQL*Plus, MS Office XP & MS Visio

Programming Languages: SQL and PL/SQL

Data bases: DB2, SQLServer and MS Access

BI Tools: BW, BEx Query designer, BEx Analyzer Web Intelligence.

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, MA

Senior SAP BI BO Developer/Architect

Environment: SAP BI 7.4 on HANA, SD, FI-CO, HR and PS.

Responsibilities:

• Currently working on SAP BI 7.3 on HANA platform.
• As SAP BI/BO Solution Developer worked with functional users to gather the requirement for new reporting solutions and enhancements to the existing solution.
• Involved in creating various reports in front end in different areas like SD, MM, FI-CO, Project Systems and Manufacturing.
• Worked on data sources 0FI GL 10 and 0FI GL 14 data sources.
• Worked on 0FI AR 4 and 0FI AP 30 data sources for customer and vendor line items extraction.
• Worked on enhancement of 0CO OM CCA 40 data source for the extraction of Cost center line items.
• Worked on creating various generic extractors in Operate to Maintain area for Plant Maintenance.
• Involved in mirror validations of data in ECC and BW on different environments.
• Worked on transports to different environments till production.
• Involved in giving to the end users for the report interface.
• Involved in collecting all the developed objects and releasing the TR’s.
• Created Transformations and involved in debugging the code.
• Involved in installing Business Content.
• Worked on different update modes for uploading the data from SAP ECC to BW.
• Participated in the failures occurred when delta update is going on from one data target to another data target.
• Involved in rectification of different failures in the data loads and rectifying data issues.
• Mapping and GAP analysis is done for each module, I have seen people defining integration after mapping, gap analysis and configuration is done, but as per my experience in implementation, it is a simultaneous process.
• Evaluate current architecture and solutions to recommend the best approach or actions to improve the BW/DW environment.
• Design a Data Repository that provides the needed and accurate data to the business.
• Lead the team of around 4 resources and assigning work to the team and getting the daily status and provide regular status report to stakeholders.
• Development of backend design, Data modeling, Query design and development, Performs data extractions, Performance tuning on queries, working on enhancements.
• Performs regular administration and maintenance.

Confidential, California

SAP BI Senior Developer

Environment: SAP BI 7.3, Finance and General Ledger Accounting

Responsibilities:

• Before starting configuringfuture business processes in SAP, the FS/TS are prepared, which can be also said as the result of mapping and gap analysis.
• Understanding the data that will be available in BW in business terms.
• Identifying the way end users want to analyze the data in BW.
• Designing the data access solution to satisfy defined business requirements.
• Planning the business requirements gathering sessions and process.
• Coordinating all business requirements gathering efforts with the BW Project Manager.
• Facilitating the business requirements gathering sessions.
• Capturing the information and producing the deliverables from the business requirements gathering sessions.
• Understanding and documenting business definitions of data.
• Developing the data model.
• Ensuring integration of data from both SAP and non-SAP sources.
• Fielding questions concerning the data content, definition and structure.
• Designing the data solution to satisfy defined business requirements.
• Identifying the data in the source environment.
• Mapping the data to the BW environment.
• Worked on Inbound and Outbound interfaces. Used Open hub service to distribute data to other systems (Hyperion and BPC).
• Involved in collecting all the developed objects and releasing the TR’s.
• Created queries using BEx, and then generated Universes and reports using WEBI.
• Creating BI reports on Business Objects tools like Webi, crystal and design studio and see to the performance issues on both of them.
• Involved in enhancing FI-GL data sources and populated the data from them.
• Worked on transformations and writing simple routines in ABAP.
• Developed and modified Universes using BO Universe Designer to get data from BW Info Cubes and Queries, and created reports using Web Intelligence.
• Creating BEx reports on Business Objects tools like Webi, crystal and design studio and see to the performance issues on both of them.
• Involved in performance tuning by creating indexes, aggregates.
• Involved in creating financial and accounting reports in BEx query designer in BI.

Confidential, Bentonville

SAP BI Senior Developer

Environment: SAP BI 7.0, FI-CO, SD & MM

Responsibilities:

• Identifying data quality gaps.
• Developing a plan to close data quality gaps.
• Developing the required extraction programs, if necessary.
• Developing the associated interface programs, if necessary.
• Testing of all developed programs.
• Ensuring integration testing of data from various sources .
• Developing a production support plan
• Sometimes expected to prepare test scripts for testing the configured scenarios.
• End user manual and user is also expected.
• Responsible for Handling tickets and application support to the end users.
• When an issue comes diagnose, analyze and solve the issue.
• Responsible for any enhancements.
• Interacting with Abapers to develop any user exits.
• Worked on different update modes for uploading the data from SAP R/3 to BW.
• Configured Data sources in R/3 by using LO Cockpit (LBWE), Initialized the setup tables.
• Participated in the failures occurred when delta update is going on from one data target to another.
• Involved in rectification of Database errors and Timestamp errors.
• Involved in performance tuning by creating indexes, aggregates.
• Checked the consistency of Info Object in RSRV.
• Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
• Informed the onsite people if there are any deadlocks and communicated with the customer.
• Improved Query performance using various performance tuning methods.
• Involved in resolving tickets regarding extractions, Performance Issues and also load failures.

Confidential, NJ

SAP BI Developer

Environment: SAP BI 7.0, FI-CO, SD & MM

Responsibilities:

• Worked on estimations of various projects.
• Worked on COPA cost based flow analysis.
• Designing the cost based copa flow.
• Worked on GL redesign.
• DSO splits for different regions.
• Provide solution to the end users how to determine requirements for operating concern, reports, analyses, data quality and performance.
• Validate the COPA data with SAP BI data.
• Work with architects to translate requirements into functional specifications.
• Recommend appropriate scope of requirements and priorities.
• Analyze business information requirements.
• Understand the data structure and meaning in both the source and the target BI systems.
• Design and specify source data detection and extraction processes.
• Developed several customized Info objects, Info cubes, DSO and Multiprovider according to the specifications provided by the client.
• Involved in data loading, Job monitoring and created process chains for automating the process.
• Involved in installing Business Content.
• Worked on different update modes for uploading the data from SAP R/3 to BW.
• Configured Data sources in R/3 by using LO Cockpit (LBWE), Initialized the setup tables.
• Participated in the failures occurred when delta update is going on from one data target to another data target.
• Involved in rectification of Database errors and Timestamp errors.
• Involved in performance tuning by creating indexes, aggregates.
• Checked the consistency of Info Object in RSRV.
• Involved in Load Monitoring Using RSPC, RSMO, SM37, and SM50.
• Informed the onsite people if there are any deadlocks, and communicated with the customer who posted the Ticket.

Confidential

SAP BI Developer

Environment: SAP BI 7.0, FI-CO, SD & MM

Responsibilities:

• Provide solution to the end users how to determine requirements for data, reports, analyses, metadata, service levels, data quality, and performance.
• Work with architects to translate requirements into functional specifications.
• Recommend appropriate scope of requirements and priorities.
• Analyze business information requirements.
• Discover business transformation rules.
• Understand the data structure and meaning in both the source and the target BI systems.
• Design and specify source data detection and extraction processes.
• Train BI consultants.
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as source.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.

Confidential

SAP BI Developer

Environment: SAP BI 7.0, FI-CO, HR

Responsibilities:

• Designing the data solution to satisfy defined business requirements.
• Worked on Integrated Planing.
• Identifying the data in the source environment.
• Mapping the data to the BW environment.
• Knowledge of the customer’s current business processes.
• Detailed knowledge of the data required to be extracted.
• Identifying data quality gaps.
• Plan acceptance test.
• Developing a plan to close data quality gap.
• Developing the required extraction programs, if necessary.
• Testing of all developed Objects.
• Ensuring integration testing of data from various sources.
• Developing a production support plan.
• Understanding the data that will be available in BW in business terms.
• Identifying the way end users want to analyze the data in BW.
• Designing the data access solution to satisfy defined business requirements.
• Testing of all developed solutions.
• Managing the SAP BI team to provide the deliverables in time to client.
• Ensuring integration testing of data access solution.
• Granularity of data and the potential for multiple levels of granularity.
• Fielding questions concerning the data content, definition and structure.
• Ensuring integration of data from both SAP and non-SAP sources.
• Test Components and Architecture of the test landscape.
• Technical Requirements for Implementing for project.
• Working with development to include data access solution in BW course materials.

Confidential

SAP BI Developer

Environment: SAP BI 7.0, FI-CO, SRM

Responsibilities:

• Troubleshooting the process chains and keeping track of the issues that occur and trying to find long term solutions for them, that task could also involve the functional team as they would have a better idea of the business requirements of the client.
• Modified Standard & created custom info sources, data sources, ODS & info cubes.
• Worked extensively on BEx query Designer and Developed flexible queries using navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information. Created custom queries using variables and structures.
• Worked with Restricted key figure, calculated key figure, new selection, new formula, structures, exceptions and conditions. Worked on report-to-report interface (RRI), Trending reports.
• Worked on Spend performance management(SPM).
• Broadcasting of Reports.
• Taking care of Daily / Weekly / Monthly Sales Flash and other Flashes as per client requirements.
• Making sure of the background jobs and processes.
• Maintenance of documentation of the daily loads, process chain status, etc.
• Communicating with the client about the robustness of the chains and the system in general.
• SAP R/3 and BW application knowledge in the business process area.
• The ability to develop a solution using BW to solve a company’s business requirements.
• The ability to work effectively in a diversified team.
• Strong analytical skills.
• The ability to work independently and as a team member
• Strong time management skills and multi-tasking capabilities
• Knowledge of application software tools, including presentation, spreadsheet, and word processing applications.
• Experience in the customer’s industry.
• An understanding of the source data (both SAP and non-SAP data).

Confidential

SAP BI Developer

Environment: SAP BI 7.0, FI-CO, HR and IP

Responsibilities:

• Worked on Integrated Planing.
• Worked on Communication structures, transfer structures, transfer rules & update rules for the info cubes & ODS.
• Created several Aggregate Cubes, time dependent hierarchies, navigational objects etc.
• Uploaded data from R/3, flat files using PSA. The data loads for master as well as transaction data into Info cubes.
• Define and Establish external data sources.
• Generate Info sources in R/3 source systems and migrate them into BW.
• Development of New Info Objects for additional or transactional data.
• Worked with ETL tools in data staging, extraction, storing and presentation.
• Monitored data load process to upload Historical data.
• Development of report workbooks and design Queries using BEx Analyzer and for publishing the reports in BEx Browser.
• Done data analysis for data models for info cubes & ODS.
• Involved in enhancement of Datasource.
• Responsible for design and development of BW and BI objects.
• Involved in creating and moving Transports from Development to Production.

Confidential

SAP BI Developer

Environment: SAP BI 7.0, FI-CO, SD & MM

Responsibilities:

• Developed options for data access (i.e. web solution, R/3 drill through, ODS reporting, master data reporting, 3rd party tools).
• Ensuring overall integrity of all BW Models.
• Worked on Communication structures, transfer structures, transfer rules & update rules for the info cubes & ODS.
• Created several Aggregate Cubes, time dependent hierarchies, navigational objects etc.
• Uploaded data from R/3, flat files using PSA. The data loads for master as well as transaction data into Info cubes.
• Define and Establish external data sources.
• Generate Info sources in R/3 source systems and migrate them into BW.
• Development of New Info Objects for additional or transactional data.
• Worked with ETL tools in data staging, extraction, storing and presentation.
• Monitored data load process to upload Historical data.
• Development of report workbooks and design Queries using BEx Analyzer and for publishing the reports in BEx Browser.
• Done data analysis for data models for info cubes & ODS.
• Created queries for reporting from the info cubes.

Confidential

SAP BI Developer

Environment: SAP BW 3.5, FI-CO

Responsibilities:

• Involved in using the business content Sales, Billing, Shipping info cubes.
• Extensively involved in customizing and activating standard delivered BW business content in the area of FI extraction.
• Designed Process Chains for Batch job Scheduling for Data Loads & Updating Data Targets. Handling the dependency of BI loads on extraction jobs using process chains.
• Modeled DSO’s to stage the data before transferring into the data warehouse layer.
• Worked on BPS cube.
• Worked on Analysis process designer (APD).
• Worked on Communication structures, transfer structures, transfer rules & update rules for the info cubes & ODS.
• Created several Aggregate Cubes, time dependent hierarchies, navigational objects etc.
• Uploaded data from R/3, flat files using PSA. The data loads for master as well as transaction data into Info cubes.
• Define and Establish external data sources.
• Generate Info sources in R/3 source systems and migrate them into BW.
• Development of New Info Objects for additional or transactional data.
• Worked with ETL tools in data staging, extraction, storing and presentation.
• Monitored data load process to upload Historical data.
• Development of report workbooks and design Queries using BEx Analyzer and for publishing the reports in BEx Browser.
• Done data analysis for data models for info cubes & ODS.
• Created queries for reporting from the info cubes.
• Daily Monitoring of Process Chains.
• Monitoring the daily as well as periodic data loads.

Confidential

SAP BI Developer

Environment: SAP BW 3.5, FI-CO, SD

Responsibilities:

• Modified Standard & created custom info sources, data sources, ODS & info cubes.
• Worked on Communication structures, transfer structures, transfer rules & update rules for the info cubes & ODS.
• Created several Aggregate Cubes, time dependent hierarchies, navigational objects etc.
• Uploaded data from R/3, flat files using PSA. The data loads for master as well as transaction data into Info cubes.
• Define and Establish external data sources.
• Generate Info sources in R/3 source systems and Migrate them into BW.
• Development of New Info Objects for additional or transactional data.
• Worked with ETL tools in data staging, extraction, storing and presentation.
• Monitored data load process to upload Historical data.
• Development of report workbooks and design Queries using BEx Analyzer and for publishing the reports in BEx Browser.
• Done data analysis for data models for info cubes & ODS.
• Created queries for reporting from the info cubes.

Confidential

SAP BI Developer

Environment: SAP BW 3.5, FI-CO

Responsibilities:

• Involved in the complete BW Data Modeling including creation of InfoObjects specific to the Business needs.
• Analysis of the current reporting requirements being satisfied by legacy systems, identifying the expectations of normal and power users, arriving at an Implementation Plan based on ASAP.
• Involved in Mapping the Data elements from the 24 Instances Data to get the Homogenized data in the BW environment.
• Involved in Third level production support.
• Modified Standard & created custom info sources, data sources, ODS & info cubes.
• Involved in the maintaining Role & Authorizations on the InfoObjects.
• Creation of multiple ODS for intermediate storage of all the Tax data, Infospokes for ODS joins, Infocubes and Queries, automatic scheduling of Infopackage upload through events and Process chains, providing relevant inputs to ABAP resource for creation of routines. Integration Testing.

Confidential

SAP BI Developer

Environment: SAP BW 3.5, FI-CO, SD

Responsibilities:

• Designed BEx Queries, R/RI’s and Workbooks.
• Creation of ODS, InfoSources, Creation of Export DataSources.
• To cater the changing needs of the User Created Web Templates.
• Created variables, Calculated Key Figures, Restricted Key Figures.
• Modified Standard & created custom info sources, data sources, ODS & info cubes.
• Define the gap between current reports and those reports needed to provide the benefits metrics listed.

Confidential

Developer

Environment: ORACLE 7.0/PB 4.0

Responsibilities:

• Coding, Testing, Implementation, User Interaction

Confidential

Developer

Environment: ORACLE 7.0/PB 4.0

Responsibilities:

• Requirement Study, Design, Coding, User Interaction, Implementation.

Confidential

Developer

Environment: ORACLE 7.0/PB 4.0

Responsibilities:

• Design, coding, Testing, Implementation, User Interaction