SUMMARY:

• A dynamic professional with around 10 years of rich experience in IT Software, Program Management, Business Intelligence, Data warehousing, Product Development, Application Architecture, Application Delivery and Support, Business Planning in the IT Software Industry in implementation, enhancements of SAP BW projects using SAP BW 7.x, SAP BO 4.x and SAP HANA technologies in various roles as a
• Consultant and Technical Lead. An Efficient planner, strategist & implementer with demonstrated abilities in providing actionable business information and accelerating the business growth. Expertise in managing Data warehousing, Business Intelligence and Master Data with key focus on top line profitability through good knowledge of IT, Software, Project and Program Management. Demonstrated abilities in cementing healthy relationship with key towards accomplishing business and corporate goals. An effective communicator with excellent relationship building & interpersonal skills. Strong analytical, problem solving & organizational abilities.
• In - depth knowledge of IT, Software, Product Development, Application, DW Development & Delivery
• Agile/SCRUM and best practices namely TDD (Test Driven Development), Continuous Integration
• Business Intelligence Architecture
• Business Case Preparation and Presentation to C-Level Executives
• ASDA
• Enthusiastic, goal oriented and ability to work under pressure
• Possess excellent organizational and presentation skills
• Developing relationships with key decision makers in target organizations for business development.
• Building and maintaining healthy business relations with major stakeholders, ensuring maximum customer satisfaction.
• Mapping client’s requirements & providing expert advisory services.
• Cementing healthy relation with customer, enhancing customer satisfaction matrices by achieving delivery & service quality norms.
• Overseeing customer service operations for rendering and achieving quality services.
• Assessing feedback, evaluating & providing critical feedback on areas of improvements.
• Business Level Presentations
• Managing the tasks including planning, motivating the induction and of Teams.
• Creating an environment that sustains and encourages high performance, motivating teams in optimising their contribution levels.
• Performance Management & Appraisals
• & Career Development
• Extensively worked on all phases ofSAPBW/BI project lifecycles including Analysis, Architecture, Design, Development, Data Extraction, Staging and Storage, Transformation, Presentation, Testing, Cutover/Go-Live Planning, User, Knowledge Transfer, Deployment, Production Support, Change Control, and Change Management.
• As a techno functional consultant, he was involved in all facets of SAP BI including modeling, extraction and reporting.
• Extensive knowledge base in SAP involving Netweaver BW, SAP Business Objects Suite ABAP, HANA and Data Services (ETL).
• Demonstrated experience in all phases of systems SAP implementation- Requirements gathering, Blueprint, Architecture, GAP Analysis, Actual Build and Post Production Support phase.
• Extensively involved in integration projects where there are requirements for both inbound and Outbound from SAP BW environments to the third party applications.
• Implemented Open hub/Info spokes/APD’s for sending the data from SAP BI System to external applications.
• Exceptional skills lie in Architecting SAP BW data models and taking on challenging projects, tuning performance by analyzing the ABAP code and resolving the support issues. Mentoring team members.
• Experience in handling ABAP code for data source enhancements, transformations, user exits, start and end routines, BADIs.
• Worked extensively with BEx Analyzer and Query Designer for developing and analyzing reports. Built front-end queries, using filter, condition, exception, hierarchy and variables (User Entry, Customer Exit)
• Involved in end user, architecting the warehouse layers for new requirements, understanding customer issues and troubleshooting the same, conceptualizing design and has been involved both on the technical and functional aspects of the same.
• Enhanced standard data sources, programmed user exits for data sources and variables, customized transfer, start routines and end routines using ABAP routines.
• Expert in use of process chains to automate loading of all master and transaction data.
• High-volume data load management and improvements to data load performance.
• Performance tuning of queries by maintaining aggregates, compression, partition, indexing of Info Cubes and use of statistics for the same.
• Extensively involved and led the technical and functional BW migration projects from 3.0B till 7.3 Version.
• Strong SAP functional experience such as FI-GL, FI-AP, FI-AR, FI-AA, COPA, P2P, PS, PM, SD and MM.

PROFESSIONAL EXPERIENCE:

Confidential

Sr SAP BI/BW/BO Consultant

Responsibilities:

• Lead Reporting projects, working with customer, collecting requirements, analysis, designing, developing and testing of BI projects.
• Performed Requirements Gathering & Analysis by actively soliciting, analyzing and negotiating customer requirements while leading the technical requirements analysis, driving the system design and construction
• Designed and developed software applications using Software Development Life Cycle (SDLC) method and conducted user and business meetings.
• Collaborated with key internal and external decision makers to recommend process enhancements
• Worked with the Power Users, Data modelling team, ETL team and Higher Management to define the requirements. Review the requirements and convert them into design specifications.
• Built BW models using LSA architecture.
• Involved & guided the team to generate FDs, TDs, DFDs and other needed documents for the implementation.
• Designed, Developed & Enhanced Info cubes and Reports for FI GL, Product Costing, COPA, SD.
• Extracted data, Logistics (SD, FI, Generic Data sources and Flat Files).
• Provided data to External using Open Hub Destination for consumption of BW data by Teradata.
• Developed Analysis Process Designer (APD) and custom Programs to generate files from queries and Multi providers.
• Expertise with BEx reporting & BW Web reporting and developed reports with replacement path, Exceptions, Conditions, Variables, Structures, Calculated & Restricted Key figures, Cell Definitions, Exceptional aggregation, RRI Jump Queries, etc.
• Extensively worked on different areas of FI and COPA Modules.
• Created various interfaces from BW to various non-SAP systems using APD and OPEN HUB.
• Worked with ETL teams for extracting the data from Legacy systems.
• Worked on Agile scrum methodology implementation.

Confidential

Sr SAP BI/BW Consultant

Responsibilities:

• AsSAPBILeadhandled globalBWproject management/implementation, QA testing, offshore coordination and production support with hands-on technical and functional expertise on Enterprise Data Warehouse (EDW) and Enterprise Reporting & Analysis.
• Extensively involved in preparing the data models for Procure to pay, Source to Contracts Modules.
• Developed the data integrity pattern for the inbound data from third party applications to SAP BW environment.
• Extensively involved in sending the data to Web focus environment using Outbound objects in SAP BI environment.
• Extensively involved in developing multiple custom extractors based on the standard SAP ECC tables, View and complex function modules using ABAP coding.
• Performed multiple roles in the project at different phases to support Realization and testing phases.
• Extensively worked as a liaison between the technical and functional team across all the phases of projects.
• Involved in developing the complex reports using the Exception aggregation, RKF’s, CKF’s and various query elements to meet the business requirements.
• Independently driven the cutover activities for all the non-production and production environments.
• Worked extensively on the LO extractors to get the Purchasing and Invoice details into BW environment.
• During performance testing, extensively involved in optimizing the data load and query performance..
• Load performance analysis/optimization of data warehouse during the performance testing phase through BI Statistics, Semantic Partitioning/Repartitioning &Remodelling functions of Info Providers through redesigning.
• Involved in extraction of data from plant maintenance 2LIS 17 I3HDR - Plant maintenance orders and 0PM OM OPA 1 - Maintenance Orders: Costs and Allocations
• Good understanding and knowledge on BI - PM (Plant Maintenance Implementation & Extraction)
• Involved in enhancing the FI and LO extractors to meet the Business reporting requirements.
• Worked with multiple downstream applications such as EDW, Data stage and terra data to send the data out from BW system for further reporting purposes.
• Effectively handled the Data load issues after completing the technical upgrade.
• Suggested to Implement the SAP notes for few of the known BW issues post upgrade activity.
• Have involved in testing the environment both backend data models and front end reporting post upgrade.

Confidential

Responsibilities:

• Responsible for developing the BP Finance BW LSA SAP BI systems and enhancements to the application.
• Involved in implementing FI GL, FI AR, FI AP new extractors.
• Analyzed and mapped financial business processes to BI and wrote Technical Designs using ASAP methodology
• Extensively involved in creation of Info Cubes, DSO, Info objects, Transformation rules, Extractors, Info sources, Info packages, DTPS, Data Sources, Data Extraction, Characteristics and Key figures.
• Used ODS objects to store external data and updated into various data targets based on the requirement using update rules.
• Involved in creating Generic Extractors using Views.
• Installed relevant Business Content Objects where and when required.
• Knowledge on Planning and Loading cubes in IP
• Extensively involved in providing the logic for Routines and also Exits which are used to get the status of the Work Order based on different criteria.
• Developed Info sets (using new capabilities of BI 7.0 to join Info cubes).
• Carried out Transports of all the Contents from development system to entire landscape.
• Created process chains and event triggers for job scheduling.
• Loading data via flat files into respective data-targets and consolidated into a single data-target..
• Maintained issue list, defect lists, support documents, end user documents, review list.
• Scheduled data loads to BI from other BW systems, Monitored data loads which are running hourly, daily, weekly & monthly basis and solving errors when errors occurred.
• Involved in Validated data consistency in reporting with Data Target against PSA, source systems after loading them to data targets.
• Expertise in BEx-Analyzer, Condition reporting, Exception highlighting, Restricted key figures, Calculated key figures, Variables, Filter, Free Characteristics, Variants, Structures and RRI (Report to Report Interface).
• Developed critical reports like Work Load Status Report, KPI Report, Notifications Report & Costing report which is based on Day to Day Work Orders over a date range through Web Application Designer.
• As part of Data Provider Layer migrated data from SAP R/3 using LO Cockpit and Generic Extractor.
• Designed various types of Queries on SD and PM cubes and generating reports using BEx Analyzer & Web Application Designer.

Confidential

Sr SAP BI/BW Consultant

Responsibilities:

• Designed, developed and supported BW solutions based on requirements gathered from the business in the area of Finance.
• Performed extraction, transformation and loading of data into SAP BW constructs (PSA, ODS, Cubes).
• Programmed custom user-exit extract function modules to include data missing from SAP Business Content.
• Gathered business-reporting requirements, designed and developed solutions, tested/verified the solutions, migrated the solution to production, and provided ongoing support.
• Designed and created new BW objects (Info packages, ODSs, Cubes, Info objects, Transfer structures, Data sources).
• Extensive experience with the BW Administration Workbench and LO Data Extraction Cockpit.
• Designed and created BW Queries using Business Explorer (BEx).
• Developed complex WebI reports on top of multiple BEx queries - merged dimensions, drill down to detailed reports using the hyper link functionality.
• Used SAP BW statistics to improve performance of SAP BW system.
• Involved in production support activities such as data load failures, bad data analysis and other backend issues.

Confidential

SAP Business Intelligence/BW Consultant

Responsibilities:

• Designed, developed and supported BW solutions based on requirements gathered from the business in the area of Finance.
• Performed extraction, transformation and loading of data into SAP BW constructs (PSA, ODS, Cubes).
• Programmed custom user-exit extract function modules to include data missing from SAP Business Content.
• Gathered business-reporting requirements, designed and developed solutions, tested/verified the solutions, migrated the solution to production, and provided ongoing support.
• Designed and created new BW objects (Info packages, ODSs, Cubes, Info objects, Transfer structures, Data sources).
• Extensive experience with the BW Administration Workbench and LO Data Extraction Cockpit.
• Designed and created BW Queries using Business Explorer (BEx).
• Developed complex WebI reports on top of multiple BEx queries - merged dimensions, drill down to detailed reports using the hyper link functionality.
• Used SAP BW statistics to improve performance of SAP BW system.
• Involved in production support activities such as data load failures, bad data analysis and other backend issues
• Oversaw a technical migration to BI7.0 and subsequently did a functional migration to the new data flow.
• Demonstrated expertise in managing data warehouse performance at all levels
• Supporting the Month-End Closure activity to ensure that the month-end activities are performed smoothly.
• Using Analysis Process Designer (APD) to fetch data from Query Data source and persisting in the DSO/Cubes.
• Extensively worked on BI 7.0 Archiving process to archive the data from huge DSOs and Cubes.
• Developed customer exits for various reporting requirements
• Developed Start routines, Update routines, End Routines, Transfer routines etc. for all stages of the data flow in BI 3.x and 7.0

Confidential

SAP BI/BW Business Analyst

Responsibilities:

• Responsible for developing SAP BI Applications
• Analyzed and documented the high level design of the Current and Future State of the System for full understanding of the business.
• Involved in Functional analysis and prepared functional specification documents for technical designers.
• Analyzing the Business needs and converting them into the technical deliverables.
• Participated in the Mini Steering meetings with the Senior Stakeholders of the company in the Review and Status Meetings. Tracked Issue logs and generated Project Plans.
• Maintenance of data sources at SAP OLTP source
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure,
• Installation of relevant SAP business content as when required.
• Data extraction into info cubes after creating transfer rules, info packages and update rules.
• Creation & Maintenance of Standard & customized Info Objects, Info Sources, Info Cubes, ODS, Info sets and info providers using administration workbench (RSA1).
• Created aggregates to improve the query response.
• Created & modified queries based on the user requirement using Calculated Key Figures, Restricted Key Figures, Formulas, Exceptions, Conditions and Variables
• Involved in Monitoring of Daily, Weekly & Monthly Loads.
• Participated in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.
• Handled Tickets of Priority 4 & 5.
• Maintain list of all the activities for all the tickets until it is closed.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Monitoring of info packages and analyzing the reasons for frequent failures of info packages.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Unit and Integration Testing