SUMMARY:

• Almost 17+ years of total IT experience with around 15 years of extensive and in - depth SAP experience in SAP HANA Development/Modeling, SAP BI & SAP BW which covers all aspects of SAP BI projects like Requirement gathering, Technical Analysis, Estimation, Design, Development & implementation in variou­s SAP Modules like FI, FICO, SD, MM, IM, WM and HRM.
• Strong functional foundation in Finance, Sales & Material Management with MBA specialization in Finance & Marketing.
• High experience in designing, developing & maintaining SAP HANA Information Models (Attribute Views, Analytic Views & Calculation Views including SQL Script based Calculation Views & Decision Tables)
• Experience with advanced HANA data-modelling using SQL Script, SQL CE Functions, SQL Script Scalar/Table Functions, SQL Script Procedures, Advanced Joins (Reference/Temporal/Text), Hierarchies & Text Search (Full text search, Freestyle search, Fuzzy Search)
• Strong modelling & business analysis experience in industries like pharmaceutical, Manufacturing, Services, Public sector, Aerospace & defense, Banking & finance etc.
• Extensive experience with Business Objects Reporting Tools including WEBI Reports, Crystal Reports, Dash Boards, Analysis for Office, Lumira Visualizations/Stories & Report Conversion Tool
• Experienced in Creating Business Layers, Data Foundation Layers, Multi-source Universes, Parameters, LOVs in SAP Business Objects Information/Universe Design Tool (IDT/UDT), Design studio, Webi, SAP BO Explorer, SAP BO Analysis for Office, SAP BO Analysis for OLAP.
• Experience with implementation and customization of SAP HANA Live views
• Worked on SAP HANA Security including User Management, Roles, and Privileges
• Experience with SAP HANA Data Administration including managing schemas/data model objects & import/export of HANA Catalog Objects/Content objects
• Strong Business Objects Administration experience including BO Tools Installation/Configuration, Setup and Maintenance of BO Enterprise environment, Creating & Managing groups/user profiles, migrating universes using Promotion Manager.
• Completed three implementation projects in Native Hana and BW on HANA.
• Excellent working knowledge of SAP BW on HANA with new features: Composite provider, Open ODS View, Advanced DSO, Building Hana calculation Views, Extraction from SAP HANA Views .
• Working knowledge of SAP HANA Data provisioning tools like SAP BODS, SLT, Direct Extractor Connection, Flat file Uploader and SDA.
• Working knowledge of SAP BODS integration with HANA.
• SAP BW - HANA Mixed scenarios, Publishing Data from HANA Calculations views into BW, semantically partitioned Objects, Graphical Data Flow, Hybrid Providers, LSA++, Generation of HANA models from BW Objects, Operational Data Provisioning using HANA Information Models etc.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Lead SAP HANA/BI Developer

Responsibilities:

• Designed and Developed Data Models for Advanced Asset Analytics capturing Asset Telemetry and Residual Life Analytics, Asset Risk Portfolio and What-if Analytics and Asset Failure Analytics on SAP HANA.
• Designed and Developed Data Models for Meter to Cash Analytics capturing Meter Event Analytics and Customer Consumption Analytics on SAP HANA Studio.
• Delivered several SAP HANA data modeling projects using attribute View, Analytic View and Calculation Views
• Worked on SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and performed performance testing.
• Good exposure on Schemas, table definitions, Attributes, Measures and Hierarchies in HANA.
• Created Hierarchies in HANA.
• Consumed HANA views in Open ODS views.
• Created attribute, analytic and calculation views for FI,CO, MM, Sales and Procurement modules.
• Replicated data from SAP or Non-sap source systems to HANA Database using SLT and Business Objects Data Services.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Experienced in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads
• Migrating standard Infocubes to Inmemory optimized Infocubes using migration Tool.
• Migrating standard DSO's to In-memory optimized DSO's using migration Tool.
• Importing the BW Models in to HANA using HANA Studio.
• Consuming the HANA Models in BW by creating the Transient Providers.
• Used smart data access (SDA) to migrate data from SAP Ariba to HANA database.
• Experienced in BW 7.5 version to work with BWMT eclipse modeling tool to create composite Provider, Advance Data Store Objects, Open ODS Views to integrate with BW back end objects.
• Experienced in SAP BW on HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Developed complex SQL scripts in Calculation Views.
• Consumed HANA views in Open ODS views.
• Worked on Life Cycle Management (LCM) and Solution Manger (ChaRM) to transport HANA objects.
• Good Knowledge in SAP HANA security including User Management, Roles and Privileges.

Confidential, San Diego, CA

Enterprise Data Architect/Senior SAP HANA Developer

Responsibilities:

• Gathered Business requirements and extensively contributed to HANA Modeling.
• Expertise in Creating the Technical Document based on Functional Document.
• Design and development of HANA attribute, analytic and calculation view to meet reporting requirements of supplier on time and days' supply computation.
• Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Worked extensively on SLT to replicate the data from BW to native HANA.
• Demonstrated to the end user's utilization of the HANA views in the front end tools such as Tableau and SAP Business objects - Web Intelligence.
• Loaded the Data from Different Files such as Flat Files, Spread Sheets, and XML Files etc. to SAPBW on HANA.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
• Developed various HANA Models/Views, using non SAP Source system for real time data reporting requirement in Financial Month End Closure reporting
• Design, build and deploy the provisioning of SAP data into SAP HANA platform to support real time report replacing BW extractors.
• Design, build and maintain virtual data model (SAP HANA views) using SAP HANA Studio.
• Developed Virtual Provider with BW objects upon HANA Models to use Navigational attributes and Master data related to BW Objects.
• Responsible for building different Data Models (Attributes, Analytical and Calculation Views) in SAPHANA extracting data from multiple sources.
• Developed Composite Provider to combine both data from BW & HANA and designed BEx queries upon these Composite Provider.
• Transported various HANA views to higher landscapes.
• Worked on Performance Optimizations by using Input Parameters to avoid the performance breakdowns.

Confidential, San Diego, CA

SAP HANA/BI/BW Sr. Developer

Responsibilities:

• Gathered and analyzed the requirement for central data warehousing project.
• Designed SAP BW on HANA Composite Provider as semantic layer using BW on HANA Modelling tools in HANA Studio.
• Generated SAP HANA Analytic Views for standard DSO's in HANA and used them in calculations Views.
• Enhanced Loading performance by Pushing down ABAP Logic into SAP HANA Script Based calculation view and improved performance by 40%. Reduced loading time by 3 hours.
• Loaded data into SAP BW with SAP HANA Calculation View as source using Confidential Connect.
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Worked extensively on HANA modelling for BW Objects.
• Created SAP BO Analysis for Office Reports for analytical reporting.
• Designed webi reports with complex formatting.
• Designed SAP BO design studio Dashboards for Sales and Procurement.
• Loaded data from legacy BW system into BW on HANA using BODS for history data.
• Migrated HANA content from development, testing environment to Production environment using Charm integrated LCM Process.
• Extensively working on SAP BODI Designer Components - Projects, Jobs, Workflows, Data Flows, Data Store and Transformations, Formats.
• Using designer to create source definitions, design targets, create jobs and develop. transformations in BODS.

Environment: SAP ECC 6.0, SAP BW 7.4, SAP HANA 1.0, SAP BO 4.0, Dashboards

Confidential, Swiftwater, PA

SAP BW Business Objects solution Architect

Responsibilities:

• Created Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Providers to load Master and Transactional data from SAP R/3 system into BW system.
• Performed analysis, design, development and implementation of standard/customized Info Cubes and ODS objects for MM and SD modules.
• Enhanced Business Content Data Sources as per the business requirements using User - Exits.
• Extensively used BEX Analyzer to build queries, queries with charts and worksheets to access data from BW data targets to generate reports.
• Identified the extractors on the R/3 OLTP systems and defined the Transfer structures on the source and target systems.
• Created various transfer rules with and without PSA update.
• Modified Update rules, Transfer rules, Update routines, and Transfer routines as per client requirements.
• Managed and monitored several data loads. Optimized load performance by adjusting the packet sizes.
• Worked on Info Set queries for reporting on master data and calculated key figures.

Environment: SAP BI 7.0, SAP R/3 4.7, BEx, FI-CO, SD and ABAP.

Confidential, Minneapolis

Senior Principle Consultant (SAP BW)

Responsibilities:

• Gathered Business Requirements from SAP ISU module and Conducted Gap Analysis to install Business Content.
• Designed & Developed custom Datasources, InfoSources, Extractor, InfoCubes and ODS to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to in corporate Business logic and perform data manipulation.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Created Multiproviders on sales, delivery and billing cubes to assist reporting on sales, delivery and billing together.
• Created reports using BEx Reports, Workbook, and Queries for the required sales order queries with exceptions, conditional formatting, restricted key figures and calculated key figures.
• Extensively worked on Query Designer and Web application designer to create Queries to perform sales, delivery and billing analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Involved in documentation and end - user training.

Environment: SAP BI 7.0, SAP R/ 3 4.7, business Object designer, SD, ABAP/4.

Confidential, Harrisburg, PA

SAP BW Technical Lead

Responsibilities:

• Involved in the Business Process study and identifying the reporting requirements.
• Worked on Front end, Queries, BEx Analyzer and presenting the result in workbook for Reports based on InfoCubes, ODS Objects and published the Web with Drill down features.
• 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.
• Analyzed, Enhanced Infocubes, ODS in standard delivered Business Content in SD (sales & distribution), MM (material management) and FI/CO(Finance/Controlling) with specific requirement to the client's business process.
• Created custom cubes, MultiCube for customer and vendor cycle core returns, sales order item/quantity Sales order header for fill rates, custom ODS, Custom Info Sources.
• Worked on standard InfoSources from the Business Content for MM - Purchasing for Transactional data
• Created Aggregates, worked on Performance Tuning and Production Support.
• Worked on R/3 Data Extraction Enhancements.

Environment: BW 3.5, SAP IS-Higher Education, SAP R/3 4.6C, SD, FI-CO, BEx Analyzer, Query Designer.

Confidential

SAP BW Developer

Responsibilities:

• Performed analysis, design, development and implementation of standard/ customized InfoCubes, Multiproviders and ODS Objects
• Analyzed business reporting requirements that could be satisfied by Business content info cubes and Installed BW standard business content
• Logistics Cockpit configuration and customization, good Knowledge of delta management
• Enhanced standard Data sources and developed custom Data sources
• Good Knowledge in creating and transporting of BW objects
• Done Performance Optimization by creating Aggregates and compressing Info Cubes
• Created BW user profiles using the Profile Generator and performed user related tasks, role assignments for different types of information consumers

Environment: : BW 3.5, R/3 4.6, mySAP ERP 2004

Confidential

SAP BW Consultant

Responsibilities:

• Scheduled & monitored daily/weekly/monthly loads.
• Managed Process chain activities like monitoring process chain, restarting failed process chain, process chain logs, scheduling the process chain etc.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.

Confidential

Business Analyst

Responsibilities:

• A business initiative to transition to a modern E-commerce platform in order to increase the functional capabilities of our systems and provide the business with more flexibility as it relates to their strategies and direction.
• During this initiative I worked with an implementation partner to communicate current functional requirements and business rules within the legacy system that were to be implemented in the new system.
• Analyzed and assessed functional and technical specifications of the new system to ensure it met our current business needs