SUMMARY

• Skilled in full life - cycle implementation of various versions of SAP viz. SAP R/3, ECC6.0, SAPBI, SAP BW 4.0, WebI Rich Client, Xcelcius, SAP R/3+SAP BW, SAP BASIS, SAP Security, SAP BI and SAP Business Processes (Order to Cash, Procure to Pay and Production Planning & Control), SAP BW 4.1
• Experience in developing data models in HANA 1.0 SP2
• Hands on experience on PL SQL
• Strong understanding of OLAP, In-memory methodology
• Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe,Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards)
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Sound understanding of full SAP BW / BI Solution Design & Development from business requirements analysis stage to architecture design including development, assessment of existing SAP BW / BI implementations, and providing advice on structural improvements in the areas of performance, usability, architecture, processes and organization.
• Proficient in working on SAP BW/BI components and ETL Process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, ODS (DSO), Update Rules, Routines, Transfer Rules, Process Chains and Event Management for Automation Process, Transformations in BI 2004s
• Knowledge in BW Accelerators, Star Schema, Extended star schema, Dimensional and Fact tables.
• Experience in the OLTP extraction of data of SAP LO-Cockpit, MM,generic extractions, Enhancements and extraction from flat files, non-SAP systems and DB connect.
• Expertise in the front end business warehouse components like BEX analyzer, Query designer, Universe,Web Application Designer, Web Reports, WEBI, XCelsius (Dash Boards), Analysis for Office.
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
• Good knowledge in Direct Extractor Connections.
• Exposure to Data Lake concept(Big Data)
• Exposure to SAP BW Integrated Planning(IP) and fox programming in IP
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Strong experience in using BODS as an external system for ETL between ECC and BI
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Experience in HANA Side Car approach.
• Loading data into table definitions, suspending data loads, resuming data loads. Creating information objects (packages, attribute views, analytic views, calculation views Graphical and SQL script based)
• Have good hands on experience in ETL a nd Data Cleansing applications using Infomatica Power Center, Oracle Warehouse Builder, Data services/ BODI, and PL/SQL
• Experience with SDI/SDA and ETL process using Data Services
• Ability to work directly with business analysts to translate functional design into technical specifications. Excellent client interface skills as a trusted advisor while leading an implementation team through all the phases of project delivery and maintaining constant alignment of the solution to changing business needs
• Strong leader and a team player with strong analytical, problem solving, interp ersonal skills resulting in on-time and on - budget delivery.
• Exposure to BPS on BW
• Involved in data extraction and conversion between BPC and non-ERP systems with extractors and ETL tools.
• Developed custom Process chains to support master data and transaction data loads from BI to BPC.
• Created Package links to bundle more than one packages and to run sequentially.
• Used Modeling functions such as Spread, Trend and weight to distribute the allocation to base members.
• Exposure to Tableau

PROFESSIONAL EXPERIENCE

Confidential

Digital Bus Integration Consultant

Responsibilities:

• Involved in all stages of solution design from solution blueprint to completing the design of the Invoice without receipt reports at Xcelenergy client for both their corporate and nuclear environment. This entailed creating custom extractors, advanced DSO, custom info-objects and c omposite providers.
• Using BEx queries to meet the custom requirements.
• Creating and maintaining process chains in staging environment.
• Maintenance of certain existing reports were also performed by fixing in development and transporting to higher environment.
• Development activities including Data Modeling, Datasource enhancements, BEx queries; BI Development activities including Dashboards using Design Studio, Webi, Analysis for OLAP, Explorer. FUT, PIT, UAT, Performance testing, Stress Testing and cutover/go-live activities
• Solution design using Composite providers and HANA modelling.
• Used advanced DSO’s and open DSO as info providers
• Extended the Business Content Data sources using Enhancements and populated the appended fields using User Exits. Created custom Info Source/Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW
• Designed customized data sources in ECC based upon the user inputs.
• Creating BO Webi reports, BOBJ universes on top of HANA views using IDT
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau .
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending

Confidential

SAP BI Analyst

Responsibilities:

• Designing, configuring, implementing & supporting complex SAP’s BW solutions, front-end to back-end; designing, implementing & supporting complex extraction, transformation and loading of SAP BW Data. Designing and developing reports using BW.
• Solution design using Composite providers and HANA modelling.
• Used advanced DSO’s and open DSO as info providers
• Extended the Business Content Data sources using Enhancements and populated the appended fields using User Exits. Created custom Info Source/Data Source, ODS, and Info Cubes for Data extraction, transformation and loading from SAP R/3 system to SAP BW
• Designed customized data sources in ECC based upon the user inputs.
• Creating BO Webi reports, BOBJ universes on top of HANA views using IDT
• Worked on Design studio and created reports.
• Process chain monitoring creating alerts and broadcasts.
• Worked on Design studio and tableau for reporting solutions.
• Worked on Integrated Planning on planning functions