SUMMARY:

• 13 years of SAP experience with Netweaver/Business Intelligence (BI) development, implementation, upgrade and integration
• He is Proficient in SAP BW 3.5, 7.1, 7.3, and 7.4, SAP BI - ABAP, SAP Bex, Analysis for office 2.3, SAP BPC and Novice in SAP BO. He has been trained in other tools such as Design Studio tool and SAP HANA.
• Involved in several global R/3 and Business Intelligence implementations and support for the full life cycle of the projects
• Excels in organizational and planning activities meeting difficult technical issues and working closely with team members to meet complex challenges
• Industry background in Oil and Gas, Chemicals, Energy, Dental Care, Automobile, Aerospace, Finance, Insurance etc.
• Awarded from Confidential as Technical Architect and Two Excellence awards.
• Involved in creating and maintaining Info Cubes, Data Store Objects, PSA, Info Objects, Info Areas, Multiproviders, Info Sources, Data Sources, and Info Packages.
• Gathered the requirements from offshore Business Analyst and implemented from start to end.
• Extensively used ABAP in writing customer exist, enhancements, routines.
• As part of Large Enhancement, worked on creating new Data flows in both SAP BW 3.5 and SAP BW 7.01, Writing ABAP code in Start, Field, End routines and Expert routine.
• Proficient in working with Data Source Enhancement in R/3, BADI, Customer exits, Info spokes, open hub, Designing DSO, info cubes, Multi provider, transformation, Info source, transfer rules.
• He worked on Complex Query issues, which involve RKF, CKF, filters, and variables per business requirement.
• Worked on Assignment of roles to user and transporting them to portal in production.
• Proficient in Designing Reports based on business requirement and adding all the functionalities required
• Writing functional requirements and associated test cases. Designed and implemented applications for Planning, Reporting, and Budgeting including application set creation and dimension build
• Provide gap analysis and document the BPC solution options, recommendations and implications.
• Experience in SAP BPC Consolidation: BPF(Business Process Flow), Appsets, Applications and Dimensions, Defining Data Model, Data Management to Finance & Accounting related reports.
• Customizing the SAP BPC reports, Input Schedules, Logic to meet the specific needs of the client using supported functions with BPC
• Experience with configuring Transformation files and data loading packages
• Ability to document functional and technical specifications
• Worked on ECC data sources and non- ECC data sources to load data to BW
• Experience in user training and team leading skills
• Experience in Transport Mechanism from Development to Quality to Production

PROFESSIONAL EXPERIENCE:

Confidential

SAP BI/HANA Consultant

Environment: SAP BI 7.4, BPC 10.0

Responsibilities:

• Worked in SAP BPC planning: Created Basic and Multi Planning Areas, Planning Levels, Planning Functions, Global Planning Sequences, Planning Profiles
• Prepared design document for BPC to implement and provide solutions on BPC Consolidation, planning, budgeting with public budgeting formulation, forecasting using of SCJ sales/customer data from its global operations, PNL, Balance sheet, cash Flow Functional Budget
• Customized the SAP BPC reports, Input Schedules, Logic to meet the specific needs of the client using supported functions with BPC
• Builds the BPC dimensions, models, input forms and reports according to Technical Design
• Developed custom Process chains to support master data and transaction data loads from BI to BPC.
• Builds the transactional and master data integration and automation from sources (BW Info Providers) into SAP BPC
• Extensively used EV functions to create worksheet logic for local calculations. Maintained comments in Input Schedules and report using EVCOM functions.
• Data loaded to BPC info provider, validations done, unit tested and transported to Quality then to production
• Create templates, Queries and Workbooks using SAP Analysis for Office 2.3 on costs. Goods sold, customer summery via Level 1, Level2 etc.
• HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Consumption of HANA information Models in BW by creating Composite and Open ODS Providers.
• Developed multi-data source challenging reports by merging data from multiple Data Sources using Web Intelligence WEBI
• Designed developed cross tab reports, reports with sub reports linked unlinked and charts using Crystal Reports. Responsible to implement NLS using Sybase IQ on BI on HANA 7.4. Develop, Document and Testing was the primary requirement. Developed Test scripts and did the initial testing

Confidential

SAP BI Consultant-Lead & Coordinator

Environment: SAP BI 7.4 NW

Responsibilities:

• Perform and document gap analysis. Prepare estimates for Global SAP and BW system Integration project.
• Setup Table Replication SLT for ECC and 3rd party table's real time into Hana. Data replication enhancements created for custom fields when required during replication.
• Using data provisioning methods like SAP SLT for real time data and Business Object Data Services BODS non sap data Flat file upload and direct extraction connection DXC to acquire the data into SAP HANA Data Mart.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool
• Develop SQL scripts and functions for complex reusable scenarios in HANA.
• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.
• Consumption of HANA information Models in BW by creating Composite and Open ODS Providers.
• Modeling existing and integrated system processes and data flows.
• Develop Info Providers, BEx queries, workbooks, transformations, DTP’s, custom routines.
• Develop Infosources, Data sources, customization of extract structures, customer exits in BW as well as R/3.
• Provide BW BEx Analyzer training and develop training documentation. Training is provided at several remote locations and at the corporate office.
• Support and perform cutover activities and tasks (tasks related to implementation of development objects or project deliverables in multiple systems).
• Business Objects - Familiar with Universes, WebI (Web Intelligence) and Xcesius. Additional time spent on KA (Knowledge accelerator).
• Technical Upgrade - backend objects (infoproviders, all ETL processes, etc.)
• Front-End Upgrade - queries, workbooks web reports.
• Developed training materials, and delivering user training and workshops.
• Coordinate IT/Client testing of SAP GUI rollout with basis.
• Define, develop and use complex Exit Functions.
• Reporting - BEx and Web Reporting, Information Broadcasting.
• Integrated external data sources using: DB Connect, Open Hub, XML using Web Services in BW/BI.
• ABAP - for complex data loads in start and end routines, transformations, update rules, transfer rules. Complex functions
• Strong analytical, multi-tasking and problem solving skills.
• A proven resource in defining systems strategy, developing systems requirements, and implementing practical business solutions under multiple deadlines.
• Worked on HANA test and development in BW on HANA and HANA Studio.
• Provided the estimates for the project depending on the scope of work.
• Imported the Pre-existing info objects, Cubes and DSO into HANA Studio as attribute, analytical and Calculation views.
• Created ADSO and composite providers in HANA Studio under BW Modeling tab and generated HANA Views for the same using Built in functionalities.
• Created graphical Calculation Views on top of the Attribute and Analytic views.
• Hard coded the filters and created restricted and calculated measures using various HANA functions.
• Architecting reporting requirements into technical design and development. Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards.
• Created Info objects, DSO’s, and Cubes & Multi providers as per the data model. Defined several transformations as per the need. Performed clean-up activities for the pre-migration of BW on HANA implementation. Optimized BW cubes for HANA purpose.
• Performed BW functionality, BEx functionality and BPS testing for post migration process of HANA. Interacted with the Finance Business Analysts on a daily basis for their KPI & report requirements. Managed, Configured and Performed Transports between multiple BW environments.
• Maintained custom tables in BW to load Master data. Performed BW Master and transaction data loads on required basis. Created and scheduled Process chain for daily Delta loads.
• Troubleshooting data and technical issues related to SAP BW. Managed Client BW environment to co-ordinate development, testing and transports to Production.
• Offer and CR creation including effort estimation for new requests
• Management of request delivery with on site and off shore team
• Working together with the client on requirement specifications
• Lead creation of Design documentation
• Lead and manage implementation and testing
• Hand over finalized work to client

Confidential

SAP BW/BI Consultant

Environment: SAP ECC, SAP BI 7.0

Responsibilities:

• As a BI Expert, Helped and worked on SAP BI and SAP CRM datasource enhancement.
• Given support in writing BADI to enhance datasource to extract data from CRM.
• Worked on daily reporting of Defect Fixing in CRM and BI area. Support BI Team as a SME and work distribution in CRM Area.
• Worked on BI reporting enhancement and release 4 activities in which Team delivered 93 reports i.e. 15 BI and 78 CRM reports.
• As a Project Manager, Coordinate and bridge between IDC and Onshore Team and support daily status meeting and KT sessions.
• Worked on Quality management reporting and management reporting.
• Written Start routine, End routine to filter the data records and to look up the data from source table and field routine for simple business logics
• Involved in writing the customer/User Exit codes in the FM EXIT SAPLRRSO 001 for time characteristics.
• Reports have been designed in Query designer using variables, restrictions, Exceptions, Exception Aggregations, Conditions, RKF and CKFs.
• Created BEX Reports on top of the Multi providers and Info sets.
• Performance tuning has been done in the BI System using Aggregates, Compression, Pre calculated Web templates, partitioning in Cube and DSO and fine-tuned the ABAP codes.
• Performed Support Activities like Process chain Monitoring and Handling the Incidents.
• Worked on activating the Standard Business Content object like Info Cubes, ODS Objects, Info Objects etc.
• Writing ABAP codes for Function Module based extractors, Start/End routines and BAdIs.
• Performed Unit testing and Performance testing for all new developments.
• Constant interaction with the onsite team on all the requirements, Issues, changes and status updates.
• Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Involved in creating UAT test scripts and Sessions with the analysts and given training

Confidential

SAP BW Consultant(Onsite-Offshore-Lead)

Environment: SAP BW 7.0, SAP BW 3.X

Responsibilities:

• Working on Master Solution design and development.
• Work distribution to the team members. Managing resource based on project requirement.
• Documentation the complete Master Solution and make the library for future rollouts. Documents include technical design, objects used, details of objects, comparison between systems, Test cases etc.
• SMI analysis and fixing them on time.
• Responsible for new company's system setup which include setup of datasources, transformations and complete dataflow.
• Transport management for the new company. Based on master solution, new objects are collected and transported to BI system.
• Working on UC4, third party scheduling tool. Schedule Process chain for the Master Solution of all modules.
• Designed and developed complex Process Chains for Master and Transactional Data.
• Developed and executed Unit and Integration test plans.
• Participated in the full life cycle efforts to design, analysis, Blue printing, technical specification, implementation, Go-Live and deployment of BW solutions and support processes
• Creation of process chains and scheduling according to the client requirement
• Monitoring the data loads and fixing in case of failure without affecting the business
• Successfully implemented solutions to frequently occurring problems like preventing LOCKING due to multiple loading to the same target through process chains, avoiding data inconsistency
• Installed and Enhanced BW statistical technical business content to analyze overall system performance, Info Cubes, Aggregates Status, Queries Run Time, Query usage, Query OLAP time, Query Database Time and Load Time
• Managed and Kept consistency of master and transaction data in Info Cubes through BW RSRV performance tools
• Used the APD (Analysis Process Designer) feature in BI to perform several look ups to tie the transaction data to specific master data attributes
• Enhanced Data Source, Info Source, Update rules, Communication Structure and Transfer rules through Delta Management, RFC, Customer Exit, User Exit, Update rules and Start routines workbooks

Confidential

SAP BW Technical Consultant

Environment: SAP BW 3.5, SAP ECC

Responsibilities:

• Worked as a SAP BI Technical Consultant-Lead.
• Responsible for developing BW data models and designs, configuring custom and delivered content BW objects, analyzing BW reporting requirements, developing detailed reporting specifications.
• Worked on extractions from 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.
• Extensively involved in setting up of procedures for extracting data from SAP ECC by using generic extraction.
• Developed Infosources and Written several routines in Update and transfer rules.
• Developed Info spokes on Premium and Claims Cubes to extract the data so as to correct the data in production system.
• Created extractors to extract CO-PA data for the relevant Operating Concerns from SAP-ECC into SAP BW and created corresponding Infosources, DSO and Infocube in BW.
• Designed and developed process chains (RSPC) for master data loads and transactional data loads with the help of info packages. And these process chains are scheduled for periodically.
• Extensively worked on setting up authorization objects, roles, transporting them, and involved in testing reports based on various roles.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Developed queries on Different Infocube Using Bex Analyzer. Created several Calculated Key figures, Restricted Key Figures, structures, variables to enhance the reporting features.
• Implemented conditions and restrictions in the reports based on the requirements. Used Hierarchies in the reporting to provide drill down features.

Confidential

SAP BW Technical Consultant

Environment: SAP BW 3.5, SAP ECC

Responsibilities:

• Worked as a SAP BI Technical Consultant-Lead.
• Assessed project requirements defined by customer, including desired reports and performance expectations. Involved in Business blue print and technical specification. Developed of Functional Specifications for standard cost reporting. Developed Technical Design Documents including GAP Analysis.
• Handling PM and FIGL Module in BI i.e. Orders, Notification and Confirmation
• Created Multicube to all access reportable Objects on daily and monthly level. Configured, activated and enhanced Business content for base actual cost and project actual cost according to the requirement.
• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Provided production support in BW reporting. Generated reports using BEx Analyzer and Crystal Reports.
• Responsible for ABAP coding for Standard Datasource development and Custom Datasource.
• Developed Process chains.
• Developed the test scripts for the client.
• Responsible for the team status and guidance and day to day meeting with Confidential.
• Participated in identifying and implementing continuous business process improvements, month-end closing, and consolidation. Documented functional and technical specifications for production support and project enhancements. Participated in change management activities.
• Multidimensional Data Model using Extended Star Schema designed and developed Info cubes, DSO, Info Source and Data Source. Used Open Hub for exporting data out of SAP BW into other formats. Created Start Routines, Transformation rules for DSO and Info Cubes.
• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.
• Analyzed OLAP performance using BW statistics. Improved query and load performance using Aggregates, Partitions, Indices, Packet Size, Data Selection, and Data Compression.
• Used SAP BW Business Rules to improve report performance and functionality. Assisted fellow team members in solving their report issues.

Confidential

SAP BW Technical Consultant

Environment: SAP BW 3.5, SAP ECC

Responsibilities:

• Worked as a SAP BI Technical Consultant-Lead.
• Developed Business Blueprint and defined processes for client.
• Developed the Technical Specs for the reports and Data flow design.
• Worked on the custom DSOs, Infoset and Multiprovider.
• Worked on the BOM Extraction from R/3 System. Created the Custom Datasource.
• Worked on Virtual key figure to get the data from different source.
• Developed reports on BO to give Demo on different reporting tools and used some report on Excel and live BI data.
• Developed the test scripts for the client.
• Development of authorization plan based on user requirements and business requirements.
• Created Open Hub, Process Chains to automate the data load and data target administration. Worked with basis and system admin teams to define specifications for frequency and mode of data transfers and setup of batch jobs.
• Configured and activated Business content according to the requirement based on the Application areas. Extracted data from data source 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM to extract an opening stock balance, material movements and valuated revaluations in Financial Accounting.
• Schedule and performance monitor periodic data loads from SAP R/3 to BI.
• Working on Management Reports for decision-making purpose. Creating many Cubes depends on the Reporting needs. Interacted with Business users and collected business information and their requirements for developing different type’s reports using Report Studio.
• Reporting on Infocubes from different Functional areas of BW combining data from multiple datasources. Using the BW Business Rules such as Security (roles), Query variables, Calculated Key figures.

Confidential

SAP BW Technical Consultant

Environment: SAP BW 3.1, SAP ECC

Responsibilities:

• Worked as a SAP BI Technical Consultant-Lead.
• Define project scope, develop project plans, gather and document business requirements.
• Developed Business Blueprint and define processes by using ASAP roadmap.
• A proven resource in defining systems strategy, developing systems requirements, and implementing practical business solutions under multiple deadlines.
• Install standard Cubes of FI module.
• Designed, built, tested, documented and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes; coding in start routines and end routines
• Creation of different BEx queries and workbooks based on the user requirement
• Transporting the BEx queries and other BI objects from development to production
• Given training to the User on Report development.
• Created functional specs and Technical specs layouts.
• Created Queries and workbooks as per the given Template. Worked on WAD and Visual composer.
• Worked on RDA and APD to get the data and provide data to third party system.
• Developed Cubes and ODS for SD and FI modules.

Confidential

SAP BW Technical Consultant

Environment: SAP BW 3.1, SAP ECC

Responsibilities:

• Worked as a SAP BW Technical Consultant
• Provided offshore support to the client.
• Worked as a SAP BW Technical Consultant.
• Worked directly with the client to get the requirement and day to day issues. Worked onsite and offshore.
• Worked on the Blueprinting phase to analyze and documented the BO system and Users requirement. Analyze the universe and reports working in BO.
• Worked on the standards to define naming convention of the reports, Infocubes, DSOs and other objects.
• Extensively worked on Infosets and Multiprovider and supported complete project with the finding and behavior for the same.
• Worked on the generic extractor. Worked on the User Exits to enhance the Notification Header, Notification Item, Task, Causes and Activities.
• Creation of BIA indexes, repair of indexes and include BIA in Process chains.
• Implemented the QM module, Regional wise for Asia, Europe and America and use the Infoset and Multiprovider.
• Developed and maintained the Process chains for SD, FICO, MM, CS, AM, PP, PS and QM.

Confidential

SAP BW Technical Consultant

Environment: SAP BW 7.0, SAP ECC

Responsibilities:

• Worked as a SAP BW Technical Consultant
• Provided offshore support to the client.
• Analyzed and understood functional specifications, designed technical specifications, participated in walkthrough with the client on functional and technical specifications, coding, development, and documentation and wrote test scripts.
• Modified standard, and created custom InfoSource, DataSource, ODS, and InfoCubes that included standard and MultiCube like 0BBP PO and 0FIGL O04
• Created Queries and workbooks as per the given Template.
• Modified and activated communication structure, transfer structure, transfer routine, and update rules at both ODS and InfoCube level.
• Process Chain Design and data load performance tuning.
• Involved in customization of extractors.
• Involved in writing routines.
• Involved in extracting data from finance database tables.
• Involved in creation of Process chains for Transaction and Master Data’s.
• Worked on generation of Reports by using BEx.
• Responsible for Modifying the FDD's and TDD are based on business requirements.

Confidential

SAP BW Consultant

Environment: SAP BW 3.1, SAP ECC

Responsibilities:

• Provided technical onsite support to the Confidential.
• Maintained ALE configuration and delta upload.
• Identified and documented the end-user requirements using ASAP methodology templates.
• Worked for Alinta, Melbourne on demos and identified the client's requirement.
• Analyzed and understood functional specifications, designed technical specifications, participated in walkthrough with the client on functional and technical specifications, coding, development, and documentation, and wrote test scripts.
• Modifying queries based on the user requirement using calculated key figures, restricted key figures, free characteristics, navigational attributes, filters, structures, variables, text variables, conditions, formulas and exception.
• Uploaded Master and Transactional data from flat files and SAP as the OLTP source. Worked on exporting of BW objects (Object Transport) to quality assurance and then to the production environment.
• Created Process Chains for the data loads and to automate it and optimized the process chains by dividing processes chains into level1 and level2 process chains in order to optimize the scheduling and loads in BW.
• Responsible for customizing and activation the Business Content Objects and Loading the data into ODS Object and Info Cubes. Scheduled Extract Jobs, Grouping of extract Jobs, Monitoring of Transfer and Update rules for data Loads, Monitoring of Status display and Load Statistics for Update Process.
• Worked on enhancing business content as per the requirement. Created Aggregates to Improve query performance. Extensively worked on standard and custom defined LIS and LO extractors. Extensively worked on BEx Browser, BEx Analyzer and Info set queries.
• Created calculated key figures, restricted key figures, variables and exceptions. Organized business roles and functions and managed workbooks using BEx Browser.

Confidential

SAP BW Consultant

Environment: SAP BW 3.1, SAP ECC

Responsibilities:

• Implementation of SAP Business Warehouse applications and processes in a global environment.
• Designing complex end-to-end BW applications, integrating multiple ERP and business applications in a global environment.
• Business and data analysis to determine integration issues to provide solutions.
• Responsible for Design the Functional design document and Technical design Document, based on business requirements.
• Involved from Design Phase & involved in creation of specs for all data flows.
• Implementation of hierarchies, virtual key figures and process chains.
• Develop ABAP for update, transfer rules, start routines and return tables.
• Customization of extractors, writing routines, extracting data from finance database tables.
• Deletion & filling up of set up tables and setting up V3 update in SAP R/3 source system during the customization of LO Cockpit.
• Identify and Installing Business contents as per requirement.
• Integrating existing cubes and ODS objects, enhancing to meet business integration needs. Modules: FI, CO, SD, MM.
• Involved in creation of Process chains for Transaction and Master Data’s.
• Involved in building of Data targets like DSO, Info cube and Info objects.
• Setting up procedure to extract inventory data for MM using Lo cockpit.
• Created and maintained DataSources at SAP OLTP source, and extracted data InfoCubes after creating transfer rules, InfoPackages, and update rules.
• Uploaded master and transactional data from files and SAP as the OLTP source, and worked extensively on Administration Workbench (RSA1).
• Worked on ABAP to create report and function module and selection screen.
• Set up flat file extraction for legacy data, assigned DataSources to the InfoSource, defined transfer structure, and maintained metadata for the InfoSource and source system.