SUMMARY

• 10 years of overall IT experience, which includes 8 years of strong experience in SAP BW/BI, BO, Data Services and HANA.
• Experience in process consulting and preparing project road maps
• Experience in conducting workshops with business users for requirement gathering.
• Experience in preparing business process documents, functional and technical documents.
• Experience in End to End implementation, Business consolidations, upgrade, acquisition and mergers.
• Extensively worked on SAP BW versions like BW3.5, BI7.0, BW7.3 and BW7.4 and BO 4.0 & 4.1.
• Extensive modeling experience in handling InfoObjects, Hierarchies (time dependent & independent), InfoSources, DataSources, InfoCubes, RemoteCubes, Standard & Transactional ODS, Data Store Objects (DSO), Multi - Providers, ADP s, Open Hubs and InfoSets.
• Experienced with two Upgrade projects of NW 2004s BW3.5 to BI7.0 and BI 7.0 to BW 7.3 and successfully migrated the custom components, developed new functionality with the BI 7.3 features.
• Experience in data extraction from flat files, and SAP R/3 using extract structures such as LO-Cockpit, COPA, FI-GL etc. as well as from other database sources using DB & UD Connect.
• Solid Experience in enhancing LO-Cockpit data sources and generic extraction using function modules.
• Worked on preparing SAP BW Technical specifications, Unit & Integration Test Scripts.
• Worked on SAP Transports Management Tool (TM tool) and experienced with Solution Manager System.
• Experience in entire BI-ABAP scenarios like writing Start Routine, End Routine, Expert Routine, Enhancements, User Exits, Variable Exits and Data Extraction using Function Module.
• Worked on Infospoke and Open Hub Destination to extract data from Cube /ODS/DSO to file and External systems.
• Expertise in BW reporting using BEx Analyzer, BEx Query Designer, Web Application Designer and implementing Calculated & Restricted Key figures, variables, workbooks.
• Implementing Information Broadcasting in BW for sending the reports to Business users through e-mails. Used Reporting Agent for scheduling the Queries in the background.
• Demonstrate understanding of how and when production issues should be escalated, proactively identify and resolve potential system problems.
• Worked with flat file extractions of Data from third party systems using new methodologies like DB Connect, UD Connect, XML uploads and carried out transports to staging and production environments.
• Worked with Non SAP Systems like, Oracle, Workday, SQL, Trackwise, Sales Force and MSBI Systems
• Expertise in BI-BODS (Data Services) integration with End-to-End implementation of the entire ETL process.
• Experience in providing required training to client technical team and end users before and after go live.
• Strong knowledge on SAP BI Security Roles and Authorizations.
• Handled performance issues on various levels such as, Reporting Level & Data Level.
• Expertise in Report Generation as per user requirements using BEx/WAD/Business Objects such that the execution time is evenly distributed throughout the report by using free characteristics, Restricted key figures, Calculated key figures, Variables, formula variables, Exceptions and Conditions.
• Experienced working with both onshore and offshore environment.
• Good knowledge of Star Schema, Snowflake modeling, Fact, Dimensions Tables, Data Purging, ETL(Extract, Transform and Load)Processes, Data Mining, Data Audits and other Data Warehousing concepts.
• Good knowledge on Business Server Applications (BSP).
• Performed implementation and Production support on BW/BI for clients with various businesses such as Government Public Sectors, Medical & Health Care and Manufacturer & Electronic Industries.
• Extensively worked on SEM-BPS & IP planning functions, planning Areas, planning levels and Aggregate functions.
• Got trained on SAP HANA, BPC and BO Tool’s like Xcelsius, Webi, Live Office, BO Explorer, BO Dashboard.
• Experience with Tableau dashboard reporting tool.
• Very good knowledge and understanding of BPC.

TECHNICAL SKILLS

ERP Language : ABAP

SAP BW/BI : BI, BW, BEx Tools, Web Application Designer, BEx Report Designer.

Planning : SAP-BPS

BO Reporting Tools : Crystal Reports, WebI, Xcelsius, Universe Designer, Live Office

BO ETL : Data Services, Rapid Marts and Data Federator

Tableau: Tableau (version 8.3)

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. SAP BW Consultant

Responsibilities:

• Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, Testing, Reporting, Go-live and Post Go-live support.
• Project Involves Extraction of SEM-Business Consolidations (BCS) and General Ledger (GL) and it also involve Extraction of FI FSCM and COPA data.
• Created InfoObjects, Datastore Objects (DSOs), Infocubes, MultiProviders, InfoPackages, Data Transformation (DTPs), Transformations, APDs and Open Hubs etc.
• Experienced with ABAP objects like, Start Routine, End Routine, Expert Routine and User Exits.
• Created Test Scripts and worked on Unit Test, Integration Test and helped End Users during UAT signoff.
• Worked with BEx Query Designer, BEx Analyzer, Web Application Designer (WAD), RRI, Information Broadcasting, Work Books and iViews.
• Development of Reports using WebI (BO Tool) and SAP BW BEx according to Requirement.
• End to End Design and Implementation of Data Services 4.0 in order to replace the existing Data Stage environment.
• Used Data Services to extract data from BI and uploaded to other databases. Sources and destination databases used with Data Services are SQL, Oracle, Flat File and Quick Base.
• Designed and developed Technical Specifications for BCS and created BW queries for month/Quarter/year end consolidations.
• Designed and developed Process chain for batch job scheduling for Master and Transactional data.
• Extensively worked on SAP GL, BCS and ECC data reconciliations during month/quarter/year end financial close periods.
• Development of Reports using WebI (BO) and SAP BW Bex according to Requirement.
• Ensured that the entire team followed the quality processes for tracking & completed all the assigned work.
• Performed Performance tuning activities to reduce data load run time and accelerate BW reports execution.
• Executed two POC Projects on SAP HANA as per the client reporting requirement.
• Created Attribute views, analytical views and calculation views and worked on data provisioning.
• Created few reports using Tableau reporting tool using SAP BW Cubes and excel files as per business needs.
• Created simple dashboards using Tableau 8.3 version and published for business users.
• Involved in Building of Universes, Classes and Objects.
• Involved in Creation of Aliases to resolve the loop, while designing Universe.
• Created reports using Business Objects functionality’s like slice and Dice, Drill Down and Cross Tab.
• Extensively used Data Services (ETL) tool to pull data from non-SAP system to SAP BW system.
• Experience with BO tools like Webi, Dashboard, Live Office for excel, design studio.
• Data Services tool used for sending BW outbound files to third party applications.
• Worked on two SAP HANA POC projects as per client requirement.
• Experience with HANA modeling activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Loading data into table definitions, suspending data loads, resuming data loads.
• Experience with information objects packages, attribute views, analytic views, calculation views Graphical and SQL script based
• Involved working with content models, attributes and measures, hierarchies.

Confidential

Sr. SAP BW Consultant

Responsibilities:

• Being a Senior BW/BO Consultant, responsible for the development, support & maintenance of SAP BI/BW version 7.3 connected to ECC 6.0 system with the following SAP modules: MM, MM-PUR, SRM, FI. BW/BI developer will be responsible for analysis, design, and development of SAP BW backend components and front end reports and dashboards.
• Adhere to good systems development methodology
• Prepared project related documentation (functional design, technical design, test scripts) during the different stages of a project.
• Analyze and configure BW/BI 7.3 data environment to facilitate custom reporting and data analytics solutions.
• Build and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, ODS, Extractors, Info sets, Aggregates, Process Chains, User Exits, Function Modules.
• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW Reporting and applications.
• Perform analysis and design; write technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
• Design complex, custom BW solutions or component objects translating complex requirements into an optimal BW design.
• Created Generic extractors using tables/views/FM to pull data into SAP BW system from SAP and non-SAP systems.
• Worked on SAP HANA POC project and created webi report on top of it.
• Used Data Service tool (ETL) to pull data from non-SAP systems.
• Develop and drive the implementation of BW best practices and standards for the team.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Support the on boarding and training of BW Power Users. This includes providing technical training of key BW toolsets such as BeX web analyzers, query designers, Business Objects.
• Worked on SAP BW Security Roles and Authorizations.
• Designed and developed Process chain for batch job scheduling for Master and Transactional data.
• Used Data Services (ETL) to load data from non-SAP systems and Flat File uploads.

Confidential, CA

Sr. SAP BI Consultant

Responsibilities:

• Project Involves Extraction of SD, MM, CRM, SRM, FI, COPA, AR, AP, GL, FSCM, GTS, I&W and Project system data. It also involves production support, enhancements and maintenance.
• Involved in the production support, Scheduling Start Process and Process Chains of Events, Data source Enhancement, Remote Cubes, MultiCubes, Data Mart and Open Hub Services, fixing errors and daily ETL Data load (Full/Delta up-load) Monitoring of the BW jobs and designed Process chains for Daily, Weekly, Bi-Monthly and Monthly data loads.
• Created reporting authorizations and user profile maintenance.
• Daily coordinate with the offshore team to assign the tasks.
• Daily involved in production data loading and monitoring.
• 24/7 production database on call support.
• Created a Process Chain, which deletes the PSA Data based on the Retention Periods.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Worked on Remedy and Snow to handle Production support tickets and track support tickets and root cause analysis for resolution.
• Worked on Process chains, maintenance and data load schedules like daily/weekly/monthly.
• Worked Information broad casting to schedule reports on daily and weekly basis.
• Designed and developed Process chain for batch job scheduling for Master and Transactional data.
• Performed Performance tuning activities to reduce data load run time and accelerate BW reports execution.
• Handled Production support Errors like, Data loading issues, Users reported issues and Analyzed issue on the fly and provided solutions immediately.
• Expertise in BW Performance Tuning: Performed tuning measures of Queries by maintaining Aggregates, Roll up, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Also, used variety of techniques to boost the performance of BEx Query.
• Configuration of Batch jobs, Process Chain, event management, and Report to report interface and roles.
• Managed and monitored several data loads, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Checking the system performance and database size through DB02 and cleansing the PSA Data Accordingly.
• Resolving the issues that occur during the Loads based on Severity Level.
• Develop and drive the enhancements of BW best practices and standards for the team.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Support the on boarding and training of BW Power Users. This includes providing technical training of key BW toolsets such as BeX web analyzers, query designers, Business Objects.

Confidential, CA

Sr. SAP BI Developer

Responsibilities:

• Project Involves Extraction of CRM Service Data which includes Orders, Contracts, Quotations, Confirmations and Opportunities. It also involves Extraction and maintenance of SD, MM, PS, FI and CO modules.
• Technical and Function Specification Preparation and maintain them in the Solution Manager.
• Extensively worked on Unit Testing, System Testing and End User Testing.
• Implementation of Information Broadcasting in BI7 environment for CRM Reports.
• Provided training for the end user after successful implementation of Information Broadcasting.
• Extensively worked on BI-ABAP scenarios, like writing routines, function module enhancements, data source enhancements and user exit Variables.
• Extensively worked on Performance Management to improve the existing reporting performance.
• Developed Start Routine and Characteristic Routines for customizing the data in the process of extraction from different source tables in BI.
• Worked on BEx Query Designer, enabled for BOBJ Webi& Dashboard reports.
• Worked on Transport Connection for collecting and releasing Objects from Development to Quality and then to production system.
• Created Generic Datasource by using Tables/Views and created Custom Infoobjects, Infocubes, DSO s for CRM.
• Conducted end-users trainings and developed business process documentation.

Confidential

SAP BI Sr. Developer

Responsibilities:

• Implemented Data warehouse in BI for reporting purposes on FICO, SD, MM and FSCM data from SAP.
• Involved in business requirement gatherings, closely interacted with functional teams and prepared functional documents.
• Prepared technical documents uploaded in solution manager and distributed with in team for developments.
• Worked on Unit test, functional test and user acceptance test (UAT).
• Prepared Unit test scripts and regression test scripts for different BW reports.
• Prepared End to End documentation for all BW developments, maintained all test scripts and results in solution manager.
• Created, Modified and Activated Business Content extractors, Info Objects, Datasources, InfoCubes, Multi providers, Open Hubs, ADPs, Data Transfer Process, Transformations, InfoPackages and DSOs according to project requirements.
• Created Generic DataSource as per the requirements on top of ECC tables/views.
• Stored transaction data in InfoCubes, staging DSO and Master Data in InfoObjects. Used MultiProviders for reports on several InfoCubes.
• Created Process Chains for master data and transaction data.
• Worked on Transport Connection for collecting and releasing Objects from Development to Quality and then to production system.
• Migrated BW 3.x flow objects into BI 7.0 flow for application areas like, FSCM, FI, SD and MM.
• Created Generic Datasource by using Tables/Views and created Custom Infoobjects, Infocubes, DSO s for FI, SD and FSCM.
• Activated Vistex datasources, Deleted setup tables and filled setup tables through Vistex ABAP programs in SE38.
• Worked on SAP HR module and Infotypes to extract data from SAP ECC system.
• Created Employee Headcount report, compensation, payroll and leave reports.
• Created reports by using Exceptions, Conditions, Variables, Restricted Key figures, Calculated Key figures, on BEx Queries.

Confidential

Sr. SAP BW Developer

Responsibilities:

• Interacted with Functional groups to understand the business requirement and Performed GAP analysis. And created Technical Specifications document as per the Functional Specifications.
• Implemented Data warehouse in BI for reporting purposes on SRM, WFM, CRM, HR, FI, SD, MM, EHS & LSO, data from SAP.
• Creating, Modifying, and Activating Business Content extractors, Info Objects, datasources, InfoCubes, Multi providers, and DSOs according to the reporting requirements.
• Created Generic DataSource as per the requirements on top of R/3 tables/views/FM.
• Enhanced standard datasources using ABAP code as per requirement.
• Stored transaction data in InfoCubes, staging DSO and Master Data in InfoObjects. Used MultiProviders for reports on several InfoCubes.
• Created Process Chains for master data and transaction data.
• Worked on Transport Connection for collecting and releasing Objects from Development to Quality.
• Interacted with clients on various occasions (via conf calls, during on-site camp) to develop a thorough and deeper knowledge on assets.
• Possess the ability to analyze issues thoroughly and quickly, helped in on-time delivery of all assigned tasks.
• Have good ability to manage time and prioritize work.
• Created Initial Object Reviews (IOR's) for maintaining the quality standards.
• Generated reports with replacement path adjusted exceptions for detailed reporting and designed Exceptions, Conditions, Variables, Structures, Restricted Key figures, Calculated Key figures, RRI on BEx Queries.
• Integrated SAP BI content to the SAP Enterprise Portal using BEx Query Designer and BEx Web Application Designer (WAD).
• Prepare Production Cut-Over plan while transporting from Pre-Production to Production box.
• Involved in Production support that includes monitoring of Process Chains and Data Loads.
• Migration of 3.x flow to BI 7.0 flow (SRM, WFM, CRM, HR, FI, SD, MM, EHS &LSO).
• Reports are published into KM through Information Broad casting.
• Created Generic Datasource by using FM and created Custom Infoobjects, Infocubes, DSO s for CRM.
• Worked on SAP HR Head Count, Pay Roll and Training tracker reports for business requirements.
• Worked on SAP HR Infotypes and extracted data from multiple Infotypes to feed data to all HR reports.
• Installed BI content Statistics Cubes and activated statistics for all data targets, reports and Web Templates.

Confidential

SAP BW Developer

Responsibilities:

• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications.
• Thorough understanding of the Functional specifications and outstanding issues related to specifications.
• Performed analysis, design, development and Implementation of standard / customized InfoCubes and Data Store Objects for business requirement in the application areas of SD and CRM using BW7.0.
• Worked on extractions from heterogeneous Source System including SAP and non-SAP, Developing SAP BW Objects, applying Extended Star Schema modeling principles in Data Design, and used expert knowledge of data warehousing concepts.
• Responsible for developing High level Data flow and revising the Gap Analysis.
• Involved in creating and maintaining Info Cubes, DataStore Objects, Info Objects, Info Areas, Data Sources, Transformations, Data Transfer Process and Info Packages.
• Installed Business Content Sales and Sales Details, sales and Trade promotion (plan), Sales & Trade Promotion (Actual), Promotion knowledge base InfoCubes and designed and activated Brand Plan Budget InfoCubes to meet user needs.
• Migrated DataSources from 3.x version to BI7.0 version and created several DSO objects which act as data staging engine.
• Data extraction from R/3 to BW by using LO Cockpit (LBWE) initialized the setup tables. Scheduled and Implemented delta mechanism for periodic loads.
• Designed and developed process chains (RSPC) for master data and transaction data loads with the help of DTP and these Process chains are scheduled for daily, weekly and monthly loads.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Variables, etc. For customized reporting using BEx Analyzer, BEx Query Designer. Designed and developed several web reports using web templates in Web Application Designer.
• Created Planning Areas, Planning Levels, Multi Planning Areas and Manual Planning for the Sales & Trade Promotion (Actual + Plan) and created Variables in BPS.
• Worked on transports, user roles and authorizations.