SUMMARY

• 8 years of total IT experience in the field of Information Technology, expertise in Business Intelligence, Data Warehouse and Data Visualization, having in depth knowledge in system study, analysis, design, development and implementation of SAP HANA, SAP BW, SAP EIM, SAP BODS, Qliksense.
• Having 4+ Years of experience in SAP HANA on SPS 08/09/10/11/12, SAP BODS (ETL), SAP SLT, SAP Power Designer, 3+ Year in SAP BW and 1 year of Qliksense dashboards
• Been part of different projects encompassing requirements gathering, analysis, design and testing.
• Strong experience in Data profiling and Data Analysis using SAP BODS and SAP Information Steward
• Have good knowledge in understanding leading edge Technologies like Data Warehouse and Business Intelligence Concepts and BI Tools.
• Experience in developing and implementing Enterprise DW and BI Solutions that provides strong governance to facilitate business change.
• Experience in developing the enterprise data architecture/model and worked closely with the client heads, Business and IT.
• Implemented SAP Dynamic Tiering (DT) using SAP Data Warehouse Foundation (DWF SPS 05/1.0 SPS/05)
• Strong experience SAP SLT, SAP BODS, SDA/SDI, SAP Information Steward
• Defining Master Data for Products, Customers and Manufacturing Location
• Capable to guide project teams on design and development aspects in terms of best practices, estimation, and process adherence.
• Ability to present and articulate technical architecture as well as conceptual subject data models.
• Strong Experience in end to end Data warehouse design and development experience for large size enterprise data warehouses.
• Strong Experience in SQL and PL/SQL and Query Optimization.
• Extensive experience in HANA data modeling and BW using extended star schema and entity relationship model. Involved actively in enterprise data warehousing (EDW) strategies
• Extraction of data from MM, SD, FI/CO, HR, SCM, LO Cockpit, Generic data sources and Flat File data loading (Full/Initialization/delta upload).
• Extensively worked on activating standard Business Content, extending the delivered
• Expertise in front - end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer.
• Implemented Virtual Key Figures and characteristics, Customer Exit Variables, Formula Builder and Bex broadcaster.
• Involved in OLAP universe designing, IDT, well versed with Business Objects XI 3.1, Universe Designer, Web Intelligence, Xcelsius.

TECHNICAL SKILLS

Languages: SAP HANA SQL, MSSQL, PL/SQL.

Databases: SAP HANA, MSQL Server 2005, MSQL Server 2012, 2014.

BI Tools: SAP HANA, SAP BW, Qliksense 1.1/2.1.1, SAP BOBJ

Data Modeling: SAP Power Designer, ERWIN 4.0

ETL Tools: SAP SLT, SAP BODS, SAP SDI/SDA, SAP Information Steward

SQL Tools: SAP HANA and MS SQL Server Management Studio

Operating systems: WINDOWS 2003/08/08 R2 Server and WINDOWS XP

Project Management Tools: JIRA

PROFESSIONAL EXPERIENCE

Confidential, CA

SAP HANA BODS EIM BW Consultant

Responsibilities:

• Leads the strategic design, development and delivery of variable annuity hedging data architectures.
• Perform assessment with the client on Performance optimization on existing model which has issues.
• Migrating legacy data from RDBMS to HANA.
• Created conceptual, logical and physical models for OLTP and OLAP systems using SAP Power Designer
• Implemented 3rd Normal Form in OLTP and Ralph Kimball method of designing (Fact & Dimensions).
• Create complex graphical calculation, scripted and UDF view using dynamic tiering pruning views, virtual tables and schema tables
• Experience in writing SQL, and PL/SQL Stored Procedures and experience in Performance Tuning and Query Optimization.
• Migrated the developed HANA models/procedures, SDA (virtual tables), SDI (Jobs), Dynamic Tiering files and Data Services jobs/scripts across the system landscape.
• Performing Functionality, User Acceptance Testing (UAT) and creating Test Scenarios
• Gathered end user and customer feedback per the system and conducted meeting for continuous improvement when needed.
• Helping production users in troubleshooting their problems and providing the workaround solution.
• Managing Off-Shore and On-Site teams on development and reporting

Environment: SAP HANA, SAP SLT, SAP BW, SAP ECC, SAP BODS, SDI, SDA, SAP Information Steward, MSSQL Server 2014

Confidential, CA

SAP HANA ETL EIM

Responsibilities:

• Leading the technical team to provide end-to-end solution for enterprise subscription analytics.
• Involved in design discussions and responsible for preparing business process documents, source data discovery documents, gap analysis documents, use case documents.
• Strong understanding of RDBMS, Data warehousing concepts, Data mart development, ER Modeling and Data-Flow Modeling
• Experienced in Extraction, Transformation and Loading data from ECC, Flat Files, BW (via Open hubs), MS SQL, HANA, HDFS and Datamarts
• Proficient in creating Jobs, Workflows, Dataflows, Query and other Transforms in SAP Data Services
• Worked extensively with Data Extraction, Data Profiling, Data Cleansing, Data Enrichment, BAPI & IDocs
• BODS Performance Optimization for Source DB, Operating System, Target DB, Network, Job Server OS, BODS Repository database.
• Experience in writing SQL, PL/SQL and experience in Performance Tuning and Query Optimization.
• BODS Repositories back-up and recovery process.
• Performing Functionality and User Acceptance Testing (UAT)

Environment: SAP HANA, SAP BODS (ETL), SDI, SDA, MSSQL Server 2014, HDFS, Jira

Confidential, CA

SAP HANA BODS EIM BW

Responsibilities:

• Leads the strategic design, development and delivery of variable data architectures.
• Responsible for designing the ETL architecture and data modeling using SAP power designer.
• Responsible for data mining, data discovery and data definition.
• Create and maintain data architecture project artifacts, Includes data store documentation and source to target data transform rules.
• Responsible for creating Mater Data for Customer, Product, Fab locations and Fid’s.
• Designing complex end-to-end EDW applications, integrating multiple ERP and business applications in a global environment.
• Designed and developed HANA Artifacts (models) like attribute views, analytical views, calculation views (Graphical/Scripted), stored procedures using SAP HANA Studio and Data services jobs for ETL.
• Involved and Implemented end-to-end SAP Dynamic Tiering solution (DT 2.0 SPS 0.0), (DWF SPS 05/1.0SPS/05) (HA SPS Rev 110/120) and worked closely with SAP America while implementing.
• Extracted data using various SAP tools like SAP SLT, SAP SDI and SAP SDA
• Building complex calculation views based on virtual tables using SAP SDA
• Migrated the developed HANA models/procedures and Data services jobs/scripts across the system landscape from Dev to QA etc.
• Strong Experience in Performance Tuning and Query Optimization.
• Worked on HANA XS, extracting the data for Fiori App via web services like OData and Server Side JavaScript (XSJS).
• Defined web-based data access by building consumption models in HANA XSJS (server-side JavaScript) exposing HANA artifacts to client applications.
• Used SAP HANA Web-Based workbench to create XS control-flow
• Worked on creating XS SQL Connections
• Creating Sales Order BOM level using XSJS and ODATA, HTTP Request Handling, XSJS Session API, extracting the data from Hana information models
• Worked on scheduling the XS jobs.
• Performed XS Unit Testing for SAP HANA XS Applications
• Deep understanding and development of SAP Logistics Reporting.
• Working closely with business and identified, analyzed the core requirements and key features of the Dashboards
• Translating high-level business and user requirements into functional requirements in the form of Functional Specification Document and Use Case Documents.
• Identifying different tools / techniques that can be used to structure requirements; demonstrating the ability to develop a basic use case.
• Providing functional inputs to the development team, testing team and functional testing.
• Knowledge of Producing user cases and the story board.
• Design the dashboard Prototypes and help development team in designing the dashboard.
• Prepared product backlog by working with product owners and SMEs and prioritized user stories assigning them to different sprints
• Following agile scrum methodology for building dashboards.
• Reviewing Test Cases prepared by the Testing Team and Carried out exhaustive functional and UI testing.
• Performing Functionality, User Acceptance Testing (UAT) and creating Test Scenarios
• Gathered end user and customer feedback per the system and conducted meeting for continuous improvement when needed.
• Helping production users in troubleshooting there problems and providing the workaround solution.
• Used JIRA tool for managing project task.

Environment: SAP HANA, SAP SLT, SAP BW, SAP ECC, SAP BODS, SDI, SDA, SAP Information Steward, MSSQL Server 2014, Qliksense 2.1.1

Confidential, CA

SAP HANA BW BODS Techno Functional Analyst

Responsibilities:

• Extensively involved in Project design, roadmap, detail designs and Development approaches.
• Extensively worked on Hana Modeling like Graphical views, writing stored procedures, HDB views, HANA SQL, SAP SLT, SAP BODS
• Involved in the integration of the SAP Business Warehouse and ESSAR Business Warehouse.
• Integrating existing cubes and DSO’s objects, enhancing to meet business integration needs. Modules: FI, SD, MM, CO.
• Writing complex transformations using routines
• Testing and implemented existing extractors to ensure error free data loads.
• Business and data analysis to determine integration issues to provide solutions.
• Used NetWeaver Business Process Management (BPM) for data mapping, assigning tasks
• Develop extract processes from BW using BODS (ETL tool)
• Translating business requirements into technical design.
• Created connections in IDT using BICS connectivity to create Webi reports directly on BEx queries of Quality management and used the scheduled instances data of the Webi reports as a source for Xcelsius dashboards
• Performing Functionality, User Acceptance Testing (UAT) and creating Test Scenarios

Environment: SAP HANA, SAP BODS 4., SAP BW, SAP ECC, and SAP BOBJ

Confidential, CA

Sr. SAP BW Developer

Responsibilities:

• Extensively worked on process chains for sequential background scheduling of Master and Transactional data and several subsequent processes.
• Set up procedure for extracting R/3 data for Customers, Sales Order in Sales and Distribution using LO-Cockpit.
• Setup the Statistical Setup for the LO-Cockpit and used the V3 Update for Delta Management.
• Created & Implemented Info Objects (Characteristics & Key Figures), DSO & Infocubes.
• Uploaded data for analysis into Info Cubes, ODS Objects and Master data tables by triggering initialization, delta and full update methods to implement a periodic data transfer.
• Transformations using Start routines, End routines, Experts Routine.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, Partition and indexing of Info cubes.
• Implemented SAP BW delta load, Info package creation, transfer rules, update rules and modified communication structures to determine the frequency of data upload and update to the data targets.
• Involved in both the Activities - monitoring the loads by using process chains and Ticket handling.
• Involved in handling incidents regarding extractions, Performance Issues and also load failures like monitoring of Info packages and analyzing the reasons for frequent failures of Info packages.
• Extensively worked with PSA in Monitoring the Data Transfer from Source Systems into BW
• Involved in solving high-prioritized tickets regarding extractions and load failures.
• Developed flexible queries using filters, free characteristics, Navigational attributes in Bex analyzer to facilitate data analysis in a drill down version to enable easy access of Information at various levels.
• Created Universe, IDT and WEBI reports to full fill business user’s ad-hoc requirements.
• Created standard cross-tab reports for Supply/Demand, Allocation/Actual type in Dash Boards

Environment: SAP BI 7.0, BO 4.0, SAP R/3, MM, FI/CO, & SD modules.

Confidential

SAP BW/BOBJ

Responsibilities:

• Worked extensively on Administrative Workbench (RSA1) and customized different Info cubes, Transfer rules, Update rules, Routines etc., according to the client requirements.
• Created Cubes, ODS and Multi providers for the Progress Governance Reporting.
• Used ODS to stage the data before transferring the data to Infocubes.
• Worked with Generic Data Extraction by creating a Generic Data Source as per the Business Requirements, Coded Exits using ABAP and extracted the data from R/3.
• Created Inbound Delivery and Outbound Delivery ODS and Cubes, extracted data from R/3 by creating Generic Data Sources and created various BEX Reports.
• Extensively carried out LO extraction, involved in creating data sources, activating the business content, replicating data source, mapping of the same, creating Info Cube, update rule, initializing Delta Method and Delta Loads to extract transaction data regularly.
• Involved in extracting Shipment Header data from 2LIS 08TRTK using LO Extraction tool.
• Involved in Enhancing LO Extractors to suit the Business Requirements using ABAP.
• Involved in Process Chains creation, Scheduled and monitored the same.
• Checked the Index status for all the info providers using DB02 and make sure that everything is Green.
• Generated a Report which checks the consistency of data between Info cube and PSA by creating a Remote Cube based on PSA data.
• Analyzed the BW Objects using RSRV and repaired if there are any issues.
• Worked with Report Agent to email the information about the Exceptions raised in the Queries.
• Created Queries and Aggregates to improve the Query Performance.
• Extensively used different transactions RSA1, RRMX, RSA3, RSA7, RSO2, SM13, RSMO, RSRT, SBIW, SPRO, SM37 etc.
• Involved in 24X7 Support project and resolved the issues as a part of Daily Monitoring Process.

Environment: SAP-BW, SAP R/3, SD, MM, FI.