SUMMARY

• Around 11+ years of SAP Experience in SAP Business Intelligence tools of SAP BW/BI, HANA, Business Explorer and Bex Designer and BO - Dashboards this includes good exposure to Implementation and Support projects and covering part of SAP BI, BI-HANA Technical development, Transition management, solution consultant, and Leadership management/Offshore Coordinator.
• SAP BW on HANA with Hands on project Experience in SAP BW 7.5 SP12.
• Involved in full life-cycle implementations of multiple SAP BW-HANA,BO, Design Studio, Lumira and HANA projects using ASAP & Agile methodology.
• Involved as a Architect role in previous assignment to propose the End-to-End solution using BW on HANA for the Plant Maintenance business to get the Equipment Expenditure Replacement Cost at Functional location.
• Proposed a complex solution for towards the Service line Deliveries Tolerance report by using multiple calculation views of Graphical & SQL based on the Factory calendar of the plant.
• Extensively worked on data modeling- info cubes and DSOs, SPO, designing custom info objects, Data Sources, Transformations, Info packages, DTPs and Multi providers.
• Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries and Web application design or automating data loads.
• Well experienced in Data warehousing concepts, Designing effective client specific BW systems, Data Modeling, Performance Tuning, Data Extraction and Data loading for both applications specific as well as generic from R/3, ECC, CRM, and Non SAP systems.
• Defined SAP BW data models for EPM-APO.
• Involved in creating and managing of Info Areas, Info Object Catalogs, Characteristics, Key Figures, Application Components, Transfer Rules, Update Rules, PSA, DSOs, Info Cubes, DTP, Info package, transformation, Info Sources, Multi Providers, Info sets and Process Chains.
• Created Semantic Partition object based on the year.
• Experience in Logistics (SD,PM,PP,) and Financial controls (FI, COPA) to extract the data from different source systems (SAP/NON-SAP).
• Designed the HANA modeling views for the financial internal and external cost tracking to analyze on Profitability Analysis and Inventory management.
• Created open hubs to distribute the BW system data to the external systems.
• Experience in Configuring and Consuming SAPBW objects and HANA models/views clients such as BO (Dashboards, Design Studio & WEBI), SAP Lumira for Visualization &Predictive Analysis and AO- Analysis Office.
• Good understanding on Star Schema and Extended Star Schema.
• Worked on BO(UDT, IDT, and WEBI) more on visualization .
• Good Understanding of the SAP BW architecture and able to realize complex BI solutions.
• Experience in installing Standard Business Content objects, customizing the Business Content objects, custom data warehouse development.
• Experience in ABAP with Routines, Start routines and Functional modules.
• Solution optimization and performance tuning expertise
• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO’s, Transient, Composite, Composite Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Good in integrated understanding of the various aspects of business processes.

TECHNICAL SKILLS

Operating System: Windows NT 4.0, and Windows 2000 to XP.

ERP: SAP R/3 (Version 4.7E, Ecc5.0 and ECC6.0)

Database: SAP Hana (Certified), Oracle 8i. MS SQL, MS-AccessBusiness Intelligence Tools: SAP BW3.5, Bi 7.0/ 7.3/7.4,Bex Analyzer & Designer BO 4.0/4.1, and SAP HANA, Lumira

Other(Ticketing Tool): Solution Manager, BMC Remedy

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/HANA Consultant

Environment: SAP BW 7.5, HANA Studio, WEBI, SAP Lumira & AO.

Responsibilities:

• Involved in the all the stages of the product life cycle. Performed requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and performance tuning.
• Experience in different methods of Data Provisioning techniques like SLT, Flat File and DXC.
• Designing the Information models &views using HANA Studio based on the BW models.
• Ex pe ri en c ed in configuring B W 7. 4/HA N A o bj ec ts - Ne w C om po s i te Pro v i de rs, A d v an c e d D S O s.
• Designing the Transient and Composite providers to publish the required user specific reports.
• Involved as a Architect role in previous assignment to propose the End-to-End solution using BW on HANA for the Plant Maintenance business to get the Equipment Expenditure Replacement Cost at Functional location.
• Proposed a complex solution for towards the Service line Deliveries Tolerance report by using multiple calculation views of Graphical & SQL based on the Factory calendar of the plant.
• BI Design - Info Cubes design, Composite Providers, Advanced DSO, ODS Objects, Proficient in Data modeling using MDM and BW extended star schema models.
• Experience in ABAP with Routines, Start routines and Functional modules.
• Experience in Logistics (SD,PM,PP), Finance control to extract the data from Source system(SAP/Non SAP).
• E x ten si v e E T L knowledge with good understanding of latest best practices
• Solution design/modelling, op t i m iz ati on an d p erf or m an c e t uni n g e x p erti s e
• Experience in ETL i.e. Data Extraction, Data Transferring, Data Loading such as SAP BI.
• Primarily focused on Front end reporting (BEX, Dash Boards, and Lumira).
• Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.
• Extensive experience with SAP BW administration using the BW Administrator Workbench, installing Standard Business Content objects, customizing the Business Content objects, custom data warehouse development, managing ETL jobs, troubleshooting failed processes.
• BI Reporting - Experience in Design and Development of Queries, Reports, Workbooks, Business Explorer Analyzer, Query Builder, Info Set Query, Web Reporting, RRI.

Confidential

Senior BW/BI Consultant

Environment: SAP BW 7BEX Analyzer/Designer.

Responsibilities:

• Extensively worked on designing/creating InfoObjects, Standard and Custom InfoCubes, Data Store Object (DSO) for SPO.
• Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BExAnalyser.
• Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction.
• Expertise in Report Generation. Worked extensively on BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
• Knowledge On WEB Reporting, Reporting Agent, Open Hub Concept.
• Experience in Data loading, Monitoring and Scheduling using Process Chain.
• Having ability to communicate effectively at all levels of Application Development phases in the Company.
• Accessing the data from BW to APO for EPM reporting.
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.
• Extensively worked on designing/creating Info Objects, Info Sources, Transfer structures, Communication structures, Standard and Custom Info Cubes, Data Store Object (DSO).
• Having precise expertise in understanding the R/3 and ECC 6.0 System and considerable experience in SAP BW/BI, documenting, design and Analysis of reports Using BEX Analyzer.
• Performed LO Cockpit extraction, Knowledgeable in LIS, Generic and CO-PA extraction.
• Expertise in Report Generation. Worked extensively on BEx Analyzer in building Queries using Filters, Variables, Structures, Restricted Key Figures, Calculated Key Figures, Conditions, Exceptions and created aggregates for frequently used queries.
• Knowledge On WEB Reporting, Reporting Agent, Open Hub Concept.
• Experience in Data loading, Monitoring and Scheduling using Process Chain.
• Having ability to communicate effectively at all levels of Application Development phases in the Company.
• An excellent team player as well as an individual contributor with good communication and interpersonal skills.
• Quick learner and stronger desire to master in new Technologies.

Confidential

Sr SAP BW/HANA Consultant

Environment: SAP BW 7.4, Design Studio 1.0& BEX Designer.

Responsibilities:

• Good exposure in designs developed for the project will pertain to SAP, and is to be implemented using ASAP methodology, showcasing strength in delivering end-to-end SAP implementations across the globe, thus requiring highly technical skills and background essential for project completion.
• Extractions: LO, FI, CO-PA,CRM, Master data Extractors (BI Content & Generic), Set-up Tables, Delta management (Update methods), Delta Queues etc.
• Involved in tasked to interact with the project users to understand the business requirements as well as to provide knowledge and skills transfers to company and client local employees. He is tasked to study the existing applications to come up with an optimal program design for the new applications that needs to be developed and transferred to offshore functional and technical teams who will use this design as the primary input document for their development.
• Involved in SAP BI will likewise be heavily involved in executing the Integration and Acceptance Testing, performing the role of onsite coordinator for the various business and technical users at customer end on day-to-day basis, making it more efficient and cost effective to work from client’s worksite.
• Experienced in the analysis of business needs to build a single best practice solution and the ced in requires all the standard SAP implementation methodologies as well as extensive use of Capgemini Tools in Solution Management for all the documentation tracking and reporting, requiring the skills in handling complex deliveries and subject expertise on SAP SD, PP, FI CO and MM Expertise in understanding the R/3 System and considerable experience in BW development, and also possess good functional knowledge in the various areas of business process.
• Extensive knowledge of EDW design and implemented layered and scalable architecture to 24/7 reporting requirements globally. The Issues that are addressed by the Client, which in turn need to be investigate on Process & Execution.
• Maintain documentation of issue tracker on deliverables and prioritization of the workload balancing.
• Ability to work well in co-ordination with team members from various locations and very large teams
• Experience in Requirement Gathering in new process, Fit-Gap Analysis Study, Process Mapping, Post Implementation Support, Production Support, Testing and End User Training.

Confidential

SAP BW/HANA Consultant

Environment: SAP BW 7.5, Hana Studio - Eclipse, SAP Lumira & AO.

Responsibilities:

• Played BI lead role for the complete full life cycle BI Implementation which includes, gathering requirements,, design specification, Modelling, data extraction, reporting, unit testing, and user acceptance testing, documentation and maintenance.
• Worked with several users to gather requirements and transformed them into a data model.
• Developed various deliverables like Functional and Technical specs, Data mapping and Data flow documents, Gaap & Impact analysis documents, Step by step solution and Transport sequence.
• Displayed excellence in understanding client specific implementation processes and client specific tools and working single handedly in identifying and resolving the issues.
• Extracted the data from ECC, GTS systems to BI and used to send the detailed status mails to the end-users
• Created universe, designing the report in WEBI and making Crystal Reports, Dashboards using Xcelcious (Dashboard Designer).
• Extensively worked on BO3.1 to BO4.0 technical and functional upgrade projects and delivered successfully without any issues.
• Developed WEBI report/dashboards/Universes (using IDT) in BI4 Environment.
• Worked on BOBJ Security Testing, as a part of testing Basis & Security teams has granted the access for different end users as per my inputs and document.
• Efficiently worked on advanced analysis for web and advanced analysis for excel and on HANA POC
• Successfully created Data Flow Model from BI to HANA and from HANA to BO as a part of HANA POC.
• Contributed significantly in all life cycles of the project for delivering good support to the clients, by effectively coordinating with Client IT Team / Business Team/ Onsite-Offshore Team as well as improving the quality of the application and optimizing results for end-customers.
• Sound knowledge about all Data Warehouse Tools which are introduced from SAP Family.
• Monitoring the process chains, executing the Monday Morning Reports and sending them to the specified end users.
• Conducting and monitoring weekly performance tuning activities, comparing BI Data with R/3 and sending the reconciliation report to the business on daily basis