EXPERIENCE SUMMARY

Having 8 years IT experience as SAP BI/BW consultant within the SAP based moderate to complex data warehouse solutions for multiple industries with back end and front end techno functional experience including Healthcare, Oil and Gas, Manufacturing etc.

CAREER SUMMARY

• Have good understanding of all facets of SAP BI including data acquisition, transformation, loading, data modelling, query definition, web application designer, report designer and performance tuning.
• Experience working as a Business analyst, Capturing and documenting requirements, understanding business impacts, conducting interviews and workshops, proposing solutions, documentation and process mapping, etc.
• Experience in designing and delivering BI/data warehousing/analytics solutions from the business perspective
• Excellent understanding of business intelligence technologies, concepts, architectures and methodologies.
• Excellent techno-functional skills and knowledge of FICO, GL, SD, MM, HR, and PP modules and general business process of SAP R/3.
• Experience in all phases of the project Life cycle from blue print, gap analysis to customizations, Go-Live, Post Live Production support, User training documentations., i.e. one-full life-cycle of implementation using ASAP methodology.
• Extensively worked on LO-Cockpit extraction and enhancement of LO-Cockpit data sources.
• Extensively interacted with business users, gathered requirements, developed designs, and documented functional and technical specifications based on the requirement and the design.
• Designed and developed several Info providers such as DSO, Info Cubes, Multi Cubes and Info sets.
• Used ABAP conversion routines extensively in transformations, transfer rules and update rules.
• Have theoretical knowledge about HANA.
• Excellent project management skills and experience in a complex, fast-paced organization - defining project charters and business cases, scoping, communications and full lifecycle project management
• Worked on multiple projects that involve development of Complex APD's and Open hub's.
• Worked on projects migrating BI 3.x objects to 7.x. Also 7.3 to 7.4.
• Have good experience in using BEx analyser. Navigating in reports, restricted Key Figures, calculated Key figures, structures and cells, properties of Attributes and Characteristics, hierarchies, Variables, exceptions conditions, report to report interface RRI BEx Analyser and BEx Web Analyser.
• Expert in performance tuning of BEX queries using Indexes, aggregation, rollup, Cube compression and partitioning.
• Worked on BO 4.1 tools, Webi, Analysis for OLAP and Design studio 1.2 Re-wrote BW content in Design Studio
• Strong, hands on BO technical knowledge with Business Object Suite - Universe Design Tool, Information Design Tool, Webi and Xcelsius/Dashboard design.
• Worked closely with Basis and Security teams to redefine existing data models and suggested ECC enhancements.
• Experience working in SAP Solution Manager Environment.
• Conducted training for end-users and provide technical directions to associate developers and contractors.
• Exceptional organizational, analytical and communication skills.
• Adept in analysing project situations and implementing solutions.
• Defined, planned and implemented solutions on assigned moderately complex projects.
• Followed the established processes, policies, standards and procedures to assure compliance with corporate and regulatory policies and standards.
• Key expertise in problem analysis and delivering solutions. Energetic and creative with a special talent for troubleshooting and resolving complex technical problems and escalated issues. Good learner and excellent team player.
• Have good understanding of business processes in Business Intelligence.
• Hands on exposure in Implementation and Maintenance of SAP Business Warehouse Applications.
• Good team player, Strong team orientation leadership qualities, hardworking and enthusiastic.
• Very good logical skills suitable for process design, development implementation.
• Good communication and presentation skills interpersonal Skills.
• Willingness to learn and grow with the new Business Processes and Technology.
• Proven Team player with strong attention to detail and client focus. Having
• Effective Analytical and troubleshooting abilities with good interpersonal and verbal/written communication skills.

TECHNICAL EXPERTISE

• ERP : SAP ECC 6.0/5.0, R/3 4.7, R/3 4.6C.
• ETL Tools : SAP BI 7.0/7.3, BW 3.5.
• SAP Modules : HR, SD, MM, PP, FICO, COPA, .
• Reporting : BEx Query Designer BEx Analyzer BO 4.1.
• Operating Systems : Windows XP, Vista, MS DOS.
• Additional technical skills : ABAP/4, MS Excel, outlook, MS Access, MS PowerPoint.

KNOWLEDGE OF SAP ABAP

• Experience involved working on following ABAP and related developments
• ABAP Reports
• Function Modules
• Development of ABAP data Dictionary objects.
• Creating Technical and Functional Documents.
• Creating SAP-BW Generic Extractors
• Enhancement of standard SAP extractors
• Performance Tuning of the Program codes
• Experience of using Workbench tools like screen painter, debugger, runtime analyzer, dump analyzer.
• Automation the BI Production support Activities through ABAP etc.

PROFESSIONAL EXPERIENCE

Confidential

Role: Sr. SAP BI Consultant

Responsibilities:

• Actively involved in life cycle implementation of SAP BI upgrade and migration project.
• Worked on around 450 objects. Migrating 3.x flow to 7.x flow and retrofitting the objects with new flow, re written the start and end routines.
• Migrated the existing BW 3.5 reports to BI 7 reports and made the data available in BI 7 reports without interruption to the availability of the reports.
• Created / modified Open hubs, APD's to send SAP BI data SD, FI, MM etc. to different systems.
• Loading Master data, Transaction data and hierarchical data into the SAP.
• Worked on Initialization of Data Sources Full/Init/Repair full request/Delta Upload .
• Migrated Update Rules, Transfer Rules into transformations and adjusted the ABAP User Exits for transaction and master data in start/end and update routines according to 7.x flow.
• Extensively worked on SAP 7.3 with back end as DB2 system.
• Worked on different modules FI, SD,HR, COPA, MM, PS, CO etc.
• Also worked on PTP Procure To Pay , OTC Order To Cash MTB Manage The Business . Worked on PTP datasources 2lis 02 HDR, 2lis 02 ITM 2lis 02 SCL.
• Worked on FI datasources 0FI GL 14, 0FI GL 10, 0FI AR 20, 0FI AR 30, 0FI AP 20 0FI AP 30. Also worked on traditional FI datasources.
• Worked on Tax related datasources like 0FI TX 4.
• Extracted the TAX related data into DSO's ZMTB O34, ZMTB O35, ZMTB O36 ZMTB O37 , Info cubes ZMTB C66, ZMTB C67, ZMTB C68, ZMTB C69 and the Multiprovider ZMTB M23 .
• Worked on datasources related to Cost Center 0CO OM CCA 9 Actual cost Order actual cost 0CO OM OPA 6.
• HR DataSources like 0HR PA 0, 0PAYRL AREA TEXT, 0SALARYLV ATTR, 0ORGUNIT ATTR, 0ORGUNIT HR01 HIER, 0HRPOSITION ATTR etc.
• HR InfoCubes like 0PA C01, 0PAOS C01 etc.
• Created generic datasources: Z HRP1001, Z HRP1002 and Z CSKT for Operations
• Performance tuning of BEx queries using Indexes, aggregates, Cube compression and partitioning.
• BI development and modification which involved creation of Info Objects, Info cube, ODS, Infosets etc.
• Worked as a Business Analyst Capturing and documenting requirements, understanding business impacts, conducting interviews and workshops, proposing solutions, documentation and process mapping, etc.
• Analysed, designed and configured delivered, generic and custom BW data sources. Resolved issues of BW data extraction, data loading and reporting when integrating new development into a production environment.
• Created BI reports related to PTP.
• Working on Implementing BO 4.1 for current Client.
• Created BI reports in design studio and Webi.
• Designed and developed BW reporting architecture for an organization on an enterprise level, creation of functional requirements documents, design documents, tech and functional specs, pseudo code for ABAP development, test scripts and interfacing requirements with business users as required.
• Worked in SAP Solution Manager Environment.
• Involved in development/debugging of BI Extractors.
• Modifications according to design changes in BI environment.
• Creations of BI BEx queries Workbooks as per the specifications. Worked extensively on ageing reports.
• Lead project communications, release planning, change management and post-go-live support activities
• Worked on adding report to the portal.

Environment: SAP BW 7.0, ECC 6.0

Confidential

Role: Sr. SAP BI Consultant

Responsibilities:

• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements and developing detailed reporting specifications.
• Uploaded master and transactional data from Flat File and SAP R/3 to BW system.
• Development with Business Content as well as Creating Info sources, Info objects, Info cubes, DSO Objects, Transfer/update rule, uploaded master and transactional data from files and SAP as the OLTP source, monitoring, reporting. Worked extensively on administration workbench.
• Create / modify Open hubs, APD's to send SAP BI data to different systems.
• Worked with users for defining reporting needs and pre-calculated reports.
• Worked extensively on LO-Cockpit Extraction.
• Worked on different modules FI, SD,COPA, MM, PS, PP, CO etc.
• Worked on FI datasources 0FI GL 14, 0FI GL 10, 0FI AR 20, 0FI AR 30, 0FI AP 20 0FI AP 30. Also worked on traditional FI datasources.
• Involved in development/debugging of BI Extractors.
• Worked as a Business Analyst in documenting the requirements from the end users and developing new BI models to support their reporting needs.
• Creations of BI BEx queries Workbooks as per the specifications. Worked extensively on ageing reports.
• Monitored data loads with full update and delta mechanism and optimized the performance by adjusting packet size and data selections.
• Maintained Process Chains to automate and schedule background performance tuning jobs of BI query using Indices, Aggregates, Compression and Partition.
• Worked on User Exits, Function module enhancements, start routine and end routine in transformations using ABAP as per project requirements.
• Used BEX Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI Info Providers to Generate Reports.
• Scheduling daily, weekly and monthly reports, adding users and folders and assigning security rights in CMC.
• Lead project communications, release planning, change management and post-go-live support activities

Environment: SAP BW 7.0, ECC 6.0

Confidential

Role: Sr. SAP BI / BW Analyst

Responsibilities:

• Working as an onsite project coordinatorto coordinate between the clients and the offshore team.
• Worked extensively on a project which involved gathering the requirement from the end users and creating Open Hub Service, to distribute the data related to SD, FI, MM to other EDW systems.
• Worked on FI datasources 0FI GL 14, 0FI GL 10, 0FI AR 20, 0FI AR 30, 0FI AP 20 0FI AP 30. Also worked on traditional FI datasources.
• Capturing and documenting requirements, understanding business impacts, conducting interviews and workshops, proposing solutions, documentation and process mapping, etc
• Also worked on PTP Procure To Pay , OTC Order To Cash MTB Manage The Business . Worked on PTP datasources 2lis 02 HDR, 2lis 02 ITM 2lis 02 SCL.
• Created BI reports related to PTP like vendor evaluation, Invoices payments etc.
• Scheduled, monitored both Master Data Transactional data flows through Process Chains on a daily basis throughout the life cycle of the project in each environment.
• Worked on the various developments and testing activities which moved from development to quality and to production.
• Extensively worked on different types of Info objects, Data sources, Info Sources, Info packages, PSA, Info Cubes, ODS, Multi providers, Info sets, Business content, Update rules, Communication Structure, Transfer rules.
• Identified data modeling techniques, and designed InfoCubes and ODS objects, as well as different aspects of time-dependent and non-time-dependent master data attributes.
• Created Info Packages to do Full, Initial, and Delta extraction for both Master data and Transaction data with dynamic selection criteria where needed.
• Coordinated with project teams to define data analysis requirements for projects, identified relevant data tables, extracted data from SAP systems for data analysis.
• Worked closely with the corporate consultants in providing Functional specifications to enhance the current model and develop new ODS and Info Cubes. Defines custom cubes and Multiproviders for the business scenarios along with aggregates. Defined guidelines to Basis team for Aggregates and data loading.
• Designed Info Sources, activated transfer and update rules, scripted extraction routines for master data Texts and Hierarchies.
• The main cubes developed are Customer 0SD C01 , Sales Overview 0SD C03 , Delivery Service 0SD C04 , Purchasing Data 0PUR C01 and Vendor Evaluation 0PUR C02 .
• Maintained Data Sources such as billing 2LIS 13 VDHDR , Sales Order 2LIS 11 VAHDR and Delivery Order 2LIS 12 VCHDR for the SD module and Purchasing Order Item 2LIS 02 ITM for MM.
• Monitored the development of data model to satisfy the various functional requirements by implementing queries and cubes using business content.
• Worked on different modules FI, SD,COPA, MM, PS, PP, CO etc.
• Performed concept, design and development of SAP BI-IP applications BI 7.0 with NW 2004s
• Ongoing integration of reporting and planning applications using SAP BI 7.0 BW and IP .
• Worked extensively on the Open Hub Service, created Info Spokes to distribute the data to other EDW systems.
• Created Info Packages to do Full, Initial and Delta extraction for both Master and Transaction data with dynamic selection criteria as per the requirement.
• Used Process Chains to schedule the Info Packages and data transfer processes.
• Worked with users for defining reporting needs and pre-calculated reports.
• Used BEx and Web Application Designer, Web templates extensively for publishing, broadcasting of web reports.
• Worked extensively on a project which involved gathering the requirement from the end users and creating Open Hub Service, to distribute the data related to SD, FI, MM to Vendavo which is a pricing tool used in Honeywell.
• Strong data and BI analysis skills - detailed analysis and definitions of KPIs, measures, business logic and calculations, hierarchies and aggregations, source system analysis, reporting requirements, etc.
• Worked on existing APD's and Openhubs.
• Create logical path physical paths for the openhubs.
• Create process chains for the Openhubs created to send data from BI into the App Server.
• Work with Autosys team to move the file generated through the openhubs and APD's to the share location.
• Add/remove fields to the existing Openhubs.
• Test the openhubs in Dev and QA system.
• Create documentation related to the openhubs.
• Handled Performance tuning at data loading, reporting before Go-Live, post- production support.
• Lead project communications, release planning, change management and post-go-live support activities

Environment: SAP BI 7.0/BI 7.3, SAP BW 3.5, ECC 6.0, ECC 5.0, Enterprise Portal reports , BI Acclerator 7.2 and BEx.

SAP BW 7.0, R/3.5.0

Confidential

Role: Sr. SAP BI Consultant off-shore

Responsibilities:

• Actively worked on Designing, Modeling, data loading and testing of Master Data and Transactional data of content areas in SD Sales Distribution , Demand Planning etc.
• Involved in installing business content from a request imported in development server
• Analyzed, designed and configured delivered, generic and custom BW data sources. Resolved issues of BW data extraction, data loading and reporting when integrating new development into a production environment.
• Understand the requirement of data from the end users and created Openhubs and APD's to send data from SAP BI to other systems.
• Designed and developed BW reporting architecture for an organization on an enterprise level, creation of functional requirements documents, design documents, tech and functional specs, pseudo code for ABAP development, test scripts and interfacing requirements with business users as required.
• BI development and modification which involved creation of Info Objects, Info cube, ODS, Infosets etc.
• Worked extensively on LO-Cockpit Extraction
• Involved in development/debugging of BI Extractors.
• Modifications according to design changes in BI environment.
• Creations of BI BEx queries as per the specifications. Worked extensively on ageing reports.
• Testing of data compatibility between SAP R/3 and BI environment for all content areas
• Analysing and providing the solutions to defects created by the testing team during IC1, IC 2 and IC 3.
• Reviewer for Technical Specification and Coding tasks.
• Developed detailed documentation for BW architecture designs and support procedures, issue and resolution logs in ISEdoc and Eroom internet document storage

Environment: SAP BW 7.0, R/3 5.0

Confidential

Role: Sr. SAP BI Developer off-shore

Responsibilities:

• Providing offshore support to the onsite team.
• Verification of Content used by onsite team against the Standard content.
• Providing support regarding development of Authorization Objects.
• Coordination of activities between the onsite and offsite teams.
• Providing support regarding the source tables of various standard Data Sources.
• Project activity related documentation.
• Technical Support to all Upstream, Downstream environments of IS-OIL Module
• Handling BI Support activities like Load Monitoring, PC Failure handling, Peer Review and Reconciliations
• Handling support Incidents like Extractor modification, Data source enhancement/creation, Modeling, PC creation/scheduling, Adhoc loads, Query/Workbook creation and/or enhancements.
• Understand the requirement of data from the end users and created Openhubs and APD's to send data from SAP BI to other systems.
• Design and Development of new Info providers as per requirements.
• Involved in New BI and ABAP Development and providing the solution for the previous problem which occurred during the implementation
• Primary Checks: Includes essential checks to be carried out
• Data loads: Monitor daily process chain for data loads
• Communication: Defines the system messages and emails to be send to the customer for the status of the loads data
• Participation in Process Improvements by continuous recommendatations on processes to help in achieving error free data loads, better Peer review process and achieving SLA targets.
• Peer Reviewer process automation through ABAP related developments.
• Filling of the setup tables and Delta pointer initialization.
• Various tools like Trend Analysis, PIS, Remedy, ITSM support, Interwise, and Net meeting were used for development and communication activities.
• Handling ADM tasks of Estimation, Technical specification preparation, coding for various functional areas, unit testing, quality reviews.
• Involved in creating, debugging and fine tuning of the Extractors, Routines, Update rules and Transfer rules
• Resolving change request tickets of the Lnt InfoTech roles and reports Performing Transport activities which involved releasing standard BEx request and assigning new one ,creating request for the Queries and its related elements, releasing it and making available for approval
• Provide solutions to the customers with issues related to BEX reports 3.x and 7.0.
• Handling tickets of priority 1,2,3 and never missed the SLA
• Monitoring daily process chain as well as performing special month end activities
• Created many aggregates depending on the drill down request of the client
• Validated data consistency in reporting with data target against PSA after loading them to data targets
• Suggested and implemented the process improvement to stabilize the system by the way of monitoring

Environment: SAP BW 3.5/7.0, R/3 4.7, 5.0 R/3 ECC 6.0

Confidential

Role: Sr. SAP BI Developer off-shore

Responsibilities:

• Primarily involved in Designing and development of ABAP Dictionary objects customized tables and programs.
• Preparation of Technical specification, Functional Specs, User manual, Test scripts etc.
• Replication of all the scenarios which were present in Production system in the Staging system for the purpose of testing which includes:
• Creation of process chains.
• Activation and correction of Info providers, Transformations, Transfer rules, Update rules, Datasource etc.
• Scheduling them as they are in the production systemetc.
• Taking corrective actions in case of failures when the process chains were executed in Staging.
• Unit Testing of those program in development.
• Transporting them to staging followed with rigorous testing.
• Transporting the changes to production.

Environment: SAP R/3 ECC 6.0

Confidential

Role: Sr. SAP BI / ABAP Developer off-shore

Responsibilities:

• Worked with different users to gather business requirements and transformed them into a data model using Extended Star Schema Model.
• Development of BI generic Extractors Backend design using Info sets and Function modules.
• Enhancement changes to other STAR extractors.
• BI development and modification which involved creation of Info Objects, Info cube, ODS, Transformations, Cubes, Multiproviders, Queries, workbooks etc.
• Testing both in development and staging environment for both R/3 and BI changes.
• Development of UTP, Technical Specification, and review checklist according to the quality norms.
• Involved in Performance tuning by creating Aggregates, load balancing, compression, optimizing the code, refreshing the statistics etc.
• Query development using BEx Analyzer/Browser, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.
• Provided high level of customer service to end users, business units and groups.

Environment: SAP BW 7.0, R/3 ECC 6.0

Confidential

Role: Sr. SAP BI Analyst off-shore

Responsibilities:

• Gathering the requirement from the end users and creating Open Hub Service, to distribute the data related to SD, FI, MM,PP etc. to other systems for reporting
• Create modify existing APD's and Openhubs.
• Create logical path physical Path for the openhubs.
• Test the opehubs in Dev and QA system.
• Create Documentation related to the openhubs.
• Create process chains for the Openhubs created to send data from BI into the App Server.
• Work with Autosys team to move the file generated through the openhubs and APD's to the share location.

Environment: SAP BI 7.0, ECC 6.0