SUMMARY

• Confidential is a certified SAP professional and an expert at managing and delivering SAP projects with a focus on SAP BI/BOBJ and SAP HANA for over 8 Years.
• Confidential is a technical and functional expert with experience in all phases of the project life cycle, from initial assessment and road mapping to feasibility analysis and conceptual design through Implementation and enhancement and on various project management methodologies.
• SAP HANA certified Application associate edition 2015.
• Extensive Experience in Native Hana and Hana Studio all aspects Data modeling scenarios (Attribute View, Calculation View, Analytical view)
• Multi - dimensional modeling using new HANA features like star-join.
• Extensive Experience in activities of developing schemas, importing table definitions, adding connections.
• Experience using SDQ and SDI for data cleansing in HANA from remote sources.
• Experience with HANA scripts while creating complex SQL views for custom based HANA applications including BO integration with SAP Native HANA.
• Developed views in HANA with various scenarios including multiple parameters, variables, binding parameters/variables from top to bottom and vice versa
• Expert in Modeling for complex situations with utilizing all types of views including script/GUI, procedures, SQL scripts, CE Functions.
• Experience on SLT and Data Service Models to import data into Native HANA system
• Lumira and WebI reports creation on top of HANA calculation views.
• Flat file data source creation in Business Objects Data services (BODS) and also imported the SAP BI tables into BODS which serves as the BI data source including importing the HANA tables. Extensively worked in the replication technique using SAP BODS for creating data flows, build HANA models, front end BO tools - IDT, Web Intelligence and BO business explorer.
• Hands on Experience and Technical Proficiency in Data Modeling - Info objects, DSO, Info Cube, Multi-Providers, APD’s, Data Loading and Delta Management.
• Experience creating BW on HANA artifacts like ADSO, Open ODS, composite providers.
• Reporting using BEx Analyzer such as Free characteristics, Restricted Key Figures, Calculated Key Figures, Variables, Exceptions, Filters, Conditions
• Worked on different extractors (Flat file, LO, FIGL etc.)
• Writing ABAP codes for Start and End routines, BEx customer exit variables.
• Involved in various development, enhancement and upgrade projects.
• Performance tuning of infocubes by Compression, partitioning the cubes, BW statistics and BEx query reporting.
• SAP BPC creating models, dimensions, script logic and EPM reports.
• SAP BW Accelerator (BWA) and creation of BIA Indexes.
• Housekeeping activities like PSA deletion, change log deletion, BIA Index creation and deletion for Info cubes
• Managing large volume of data with yearly or quarterly DSO’s, Infocubes and adding new objects to multiproviders to make sure the un-interrupted reporting to end users
• Solving high-prioritized tickets regarding extractions, load failures and reporting issues.
• Presenting weekly status reports to the Project Management, informing them on the status of each deliverable.
• Responsible for effective communication between the project team and the customer and providing day to day direction to the project team and regular project status to the customer.
• Having good Analytical, Problem solving, Communication and Interpersonal skills with ability to interact with individuals at all levels.

PROFESSIONAL EXPERIENCE

Confidential, Bartlesville, Ok

Sr. SAP HANA Developer

Responsibilities:

• Involved in end to end process from the requirement gathering to the front end BI report generation for data analysis.
• Interaction with business user to gather the functional requirements.
• Converting the functional requirements into technical requirements.
• Organizing meetings with business to eliminate the road blocks for achieving the desired functionality.
• Built information views out of data extracted using BODS and SLT.
• Created multidimensional modeling involving data from BW generated models and BODS schema objects.
• Created multiple levels of views as a best practice, which involved calculation views of type dimension as master data objects, star-join based calculation views as intermediate reusable queries and final reporting objects as calculation views of type cube.
• Created star joins to improve the performance of calculation views.
• Created counters and complex expressions for calculated columns and filters.
• Running Explains and Visualize plans to improve and optimize the performance of views.
• Involved in creating Tableau visualizations/dashboards.
• Created WebI reports/universe on top of HANA views.
• Enhancing the existing calculation views and improving the performance.
• Creating Jobs, Work flows, data flows using BODS to pull data from the legacy systems and load the data into target database. Worked on Source to Target Mapping design.

Environment: SAP HANA SPS 11, SAP BO

Confidential, Bartlesville, Ok

Sr. SAP BI Developer

Responsibilities:

• Interact closely with the Business team and functional consultant on getting the requirements
• Understanding the business process and creating the specifications document and get it reviewed before starting the development
• Creation of generic extractor for master data Attributes, Text and Transactional data based on the table view
• Creation of Generic datasource, Info objects, Transformations, DSO, Infocube and Multiprovider
• Replicated data using SLT and BODS and created models as per business requirement.
• Creation start routines, End routines, field routines for the transformation
• Worked on transformation routine ABAP codes to lookup master data and DSO’s.
• Bex reports and APD’s creation
• Scheduling the Data loads using Process Chains
• Creation of generic extractor for master data Attributes, Text and Transactional data based on the table view
• Creation of Generic datasource, Export datasource, Info objects, Transformations, DSO, Infocube and Multiprovider
• Creation start routines, End routines, field routines for the transformation
• Worked on transformation routine ABAP codes to lookup masterdata and DSO’s.
• BEx reports creation
• BEx query customer exit variables, calculated keyfigures, and restricted keyfigures.
• Scheduling the Data loads using Process Chains

Environment: SAP BI 7.4 and SAP Bex

Confidential, St.Paul

SAP BW/HANA Developer

Responsibilities:

• Converted existing Bex queries to HANA information views.
• Point of contact for all the hana modeling development in MTO module.
• Created OLAP reports on top of information views and trained the power analysts in creating adhoc reports.
• Created reports in OLAP analysis.
• Created analytic and complex calculation views using SAP HANA modeler.
• Used currency conversion from local to USD in calculation views.
• Mapping the input parameters to underlying views and pushing filters to foundation tables.
• Created composite providers and analytical privileges.
• Imported analysis authorizations to HANA as analytical privileges.
• Transported development objects to Quality system using developer mode.
• Experience in reporting techniques such as creating calculation views, managing attribute mappings, creating analytic privileges, adding variables.
• Information Modeling in SAP HANA and Report Generation for Sales and Distribution module towards Comparative Analysis for pricing conditions.
• Worked on SAP HANA transports, Delivery Units and Schema Mapping.

Environment: SAP BW 7.4 on HANA, SAP HANA 97.02, SAP BO

Confidential, Arkansas

SAP HANA Developer

Responsibilities:

• Involved in the Automation Project.
• Worked on complex SQL scripts in HANA.
• Built information views out of data extracted using SRS.
• Organized brainstorming meetings with the other developers for performance optimization of Modeling objects.
• Built models on time dependent master data using temporal joins.
• Involved in meetings with business users for gathering technical requirements.
• Prepared technical specifications based on the functional requirements gathered from the business users.
• Involved in WebI reporting for the components which are automated using Information Models in HANA.
• Created Complex Information Models based on the KPI’s and restricted key figures required by the user.
• Presented business demos to the users for all the components that are automated to explain the working of Information Models.
• Organized meetings with the other users and involved in reviewing the development work done for the Project.

Environment: SAP HANA SPS 09, SAP BO

Confidential, Austin,TX

SAP BI Developer

Responsibilities:

• Extensively involved in Activating the Business Content for Info cubes, Data Sources, Multi providers
• Created APD’s to transfer data from Info Providers to Flat Files & to databases.
• Configured BEx Queries for Free Characteristics, Calculated and Restricted key figures
• Scheduling and Monitoring Extractor schedules and monitoring data load.
• Performed various data load (Init, Delta, Full & Repair full)
• Involved in changing the existing data model of an Info cube by adding new characteristics and key figures with initialization of data source in SAP R/3.
• Created process chains, scheduled Daily/Weekly/Monthly data loads and monitored the loads
• Error Rectification during data load ( Manual update, Re construction, Checking TRFC connection, Processing failed IDOC, DSO Activation, Editing invalid characters in PSA )
• Involved in performance tuning activities using Rollups and Compression. Involved in the performance tuning of info cubes, BW statistics and Bex query reporting.
• Worked on BI Accelerator
• Involved in identifying performance issues and coordinating with the team members to bring back the system to normal condition
• Creation of Ad-hoc queries to get the historical data for business users
• Involved in housekeeping activities like PSA deletion, change log deletion Index creation and deletion for Info cubes
• Performed Unit, Integration & UAT Testing.
• Involved in solving high-prioritized tickets regarding extractions, load failures and reporting issues.
• Presenting weekly status reports to the Project Management, informing them on the status of each deliverable.
• Managing this offshore team in support activities
• Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

Environment: SAP BI 7.2, Bex

Confidential

SAP BI/BOBJ Consultant

Responsibilities:

• Designed, developed and implemented COPA and GL Infoproviders and their reports in BEx and BO reporting tools
• Following reports are implemented from COPA Infoprovider
• Income Statement Monthly - YTD
• Margin Income Country Monthly - YTD
• Quarterly Comprehensive Report by Product
• Worked on cost center and profit center master data objects including their hierarchies.
• Designed, developed and implemented Infoprovider and its reports based on 0FI GL 4 extractor.
• Worked on the Purchase Price Variance (PPV) report with the extractors 2LIS 02 SCL, 2LIS 02 HDR and 2LIS 02 ITM.
• Worked on extractors 2LIS 03 BX and 2LIS 03 BF to load the data in Material Stocks/Movements and Material Stocks/Movements - Line item.
• Develop new roles to control the authorizations of users on the BEx and Administrator workbench.
• Interacting with users for customized and standard reports, gap analysis and associated solutions. Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, R/3 systems as per the system landscape.
• Interacted with Project manager and end-users in architecting reporting solutions by understanding the requirements and writing universe, report and Dashboard specifications.
• Designed, Created, and implemented Universes, WebI Reports, Crystal Reports, and Xcelsius Dashboards using best practices.
• Involved in installation and configuration of BO Enterprise XI components, InfoView, Xcelsius, Crystal Reports, Live Office, SAP BI/ BOBJ Integration Kit.
• Created OLAP Universes on SAP data (Infocubes / BEx queries) and Relational Universes on Non-SAP data.
• Creating multi-layered Xcelsius dashboards to display various components and included Filters, List View, table, Line, Column and Pie charts.
• Created detailed reports with Drill-down capability using Web Intelligence in InfoView, worked on Ad hoc Query, Reporting, and Analysis.
• Broadcasted reports (Crystal and WebI) to individual recipients using InfoViewscheduling functionality.

Environment: Business Objects Enterprise XI 3.1, SAP BI 7.0, ECC 6.0, Business Explorer (BEx), Crystal Reports 2008, Universe Designer, Web Intelligence, Xcelsius 2008, InfoView, QAAWS, Live Office.