PROFESSIONAL SUMMARY:

• Having total 7+ Years of experience in SAP BI/ BO and HANA.
• Good Knowledge in SAP HANA data modeling using Attribute View, Analytic View and Calculation View.
• Good Knowledge in SAP HANA Data Provisioning Methods like Flat file loading, SLT and BODS.
• 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.
• 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).
• Experienced in SAP BW on HANA and migrating standard SAP Models to In - memory optimized models and Performance testing.
• Experienced in loading data from tables in HANA Database to BW data marts.
• Proactive team player with good interactive and interpersonal skills to communicate with team members, developers, clients and end users at all levels.
• Implemented 2 full life cycle implementations for different modules in SAP BI/BW which involves Requirement analysis, Development, Testing, Documentation, End user documentation, Data extraction, Data modeling, Data loading, Reporting and Production Support.
• Worked extensively in business processes across various SAP functional modules like FICO, SD, MM, Vitex and Veritas.
• Expertise in BW/BI components like Info Cubes, DSO, Transformations, Data Transfer Process, Remodeling of the Info Cubes, Data Sources, Data source enhancement, multi-providers, Info sets, Transfer Rules, Update Rules, PSA, Open Hub Service, Data Mart, BW Transports, andBIcontent.
• Experience in Performance Tuning using Aggregates, Rollup, Multi Providers, Indexing, Partition and Compression.
• Involved in building reports using SAP BO 4.0 and integrating BO with BIand HANA.
• Experience in the front-end business warehouse components like BEX analyzer, Query designer, Universe, Web Application Designer, Web & Lumera Reports.
• Generated reports on the Multi Providers, info Providers and Info Cubes using Restricted key Figures, Calculated Key Figures, Structures, Characteristic Variables, Text variables, Formula Variables, Cell Editors, Exceptions, conditions, RRI to Jump queries etc.

TECHNICAL SKILLS:

SAP BW: BW 7.4/7.3/7.0/ 3.5 , SAP BW 7.4 on HANA, SAP HANA1.0, SAP BPC10.X and SAP APO

SAP Business Objects: SAP BI 4.X, BO Data Services 4.X

SAP R/3: SAP ECC, Vitex & Veritas

Reporting Tools: BEX, Business Objects, Lumera & MS-Excel

Operating Systems: UNIX, Linux, Windows 98/2000/NT/XP, 2000/2003/2008 SERVER

PROFESSIONAL EXPERIENCE:

Confidential, Waltham, MA

Sr. BI Analyst

Responsibilities:

• Interacting with client and onshore HANA architect for business requirements gathering, functional and technical design, data model and UAT.
• Modeling Info cubes, DSO, Staging cube, composite provider and BPC consolidation cube based to reporting requirements.
• Converted Level of Hierarchy to Flat hierarchy data using routine in transformation level and loaded to info objects.
• Expertise in creating start, end and field level routines at transformation level.
• Expertise in writing DSO lookup and field routines in transformations level to get data for derived field.
• Involved in integrating source systems (SAP ECC, BW and Flat files) to SAP HANA database using SAP Data services and SLT.
• Imported data from Flat files directly into HANA tables.
• Involved in Designing and Creating Schema’s, Tables, SAP HANA models like Attribute views, Analytical views and calculation views for data modeling and consume using different BI tools.
• Created SAP HANA views / HANA Information models using SQL Script and graphical interface.
• Created models & build EPM reports for Balance sheet, Cash Flows, Sales revenue and P&L...etc.
• Designed Process Chains for Batch job Scheduling for Data Loads & Updating Data Targets.

Confidential, San Jose, CA

Sr. BI Analyst

Responsibilities:

• Implemented LSA++ in BW 7.4
• Created Interfaces in ECC to exact data from legacy tables which are replicated by PI and extracted using Data sources of type FM into BW.
• Involved in Proto type document preparation
• Installed, copy and enhanced the business content to Client name space
• Implemented Custom Data flow to load data from legacy source systems like Flat files etc.
• Extensively involved in BEx Query creation
• Creation of BW on HANA objects both within BW and using HANA Studio.
• Understanding the business requirement and deploying in HANA live functionality for areas MM, SD & FI.
• Created Attribute views Analytical view and Calculated views using Graphical designer view.
• Publishing Universes built on HANA views as Queries in BO (Web and Dash Board).
• Involved in transporting HANA models from one environment to another.

Confidential

BI Analyst

Responsibilities:

• Direct Client communication.
• Interaction with onsite coordinators and the client for resolving issues.
• Requirement gathering for various reports and technical feasibility with users.
• Implemented BI for the application areas of SD & MM.
• ETL development (Cube, DSO, Transformation and Data source), Query design and development (BEx & Web), Enhancement for different modules like SD, MM.
• Debug ABAP routines, write variable customer exits.
• Transported the objects from Dev to Prod and monitoring target system.
• Has done the Regression testing, Unit testing, performance testing and integration testing.
• Creating process chains, performance tuning.
• Involved in creating Generic Extractors with Delta Mechanism and created different customized reports.
• Creation of reports using BEX Analyzer using Conditions, Exceptions, Filters, Free characteristics, Restricted Key Figures, Calculated Key Figures and Variables.

Confidential

BI Analyst

Responsibilities:

• Daily monitoring of Process Chains and data Loads.
• Handling the issues on data loading and end user issues on reporting.
• Resolved different priority issues assigned without missing SLA.
• Created Aggregates on frequently using characteristics like Material, Sold-to-party, Business Area, Sales organization.
• Involved in weekly/monthly outages in BW systems as a primary resource.
• Enhanced/Adjusted Process Chains to insert newly created objects.
• Worked on generic extractors to correct the reporting data issue.
• Worked on Housekeeping activities to Improve Loading performance.
• Customized queries using filters & Variables and used customer exits as per client requirements.
• Performed various tuning techniques (Index, aggregates, Compression…etc.) to optimize the query performance.