SUMMARY:

• Over 13 years of IT experience including 10+ years of SAP BW/BI experience in design and development in APO, SCM, SD, MM, FI and HCM modules.
• Four full life cycle implementation of BW
• Experience in BW 3.5, BI 7.0, 7.3 and 7.4
• Experience of upgrading BW system to BI 7.0 and 7.3
• HANA Certified from SAP.
• HANA Cloud Migration Expert.
• Sound knowledge of SAP Enterprise Information Management (EIM).
• Involved as a key member of project teams through all phases of realization, go - live, rollout and post implementation support of SAP BW in SD, HCM, APO and FICO modules.
• Extensive knowledge of Business Objects WebI and Xcelsius to create web based reports and Dashboards.
• Proficient with BOBJ Data Services 4.1 ETL tool.
• Played vital role in the configuration and deployment of Business Intelligence Accelerator (BIA) and Pre-Calc server for more efficient report delivery to end users.
• Knowledge of SAP ASAP methodology in Software Development Life Cycle.
• Experience in working with standard and custom InfoCubes, InfoObjects, InfoSources, ODS, MultiProviders, Extraction Process (LO Cockpit, FI/GL), and performance tuning.
• Worked with Business Explorer and Web Application Designer for integrating reports to web.
• Sound knowledge of various data design models- Entity Relationship (ER), Multi Dimensional/ Star Schema and Extended Star Schema models.
• Excellent communication skills to interact with business representatives while gathering key development requirements.

TECHNICAL SKILLS:

Business areas: Sales & Distribution Billing, Accounts receivables/payables, Shipments, Funds Management, FI and HR.

BW interfacing: Extracting data from multiple R/3 systems, flat files, legacy systems.

BW modeling: Designing Info-cubes, Info-sources, DSO objects, Multi-providers, Transformations, Update/Transfer rules, Info-Packages using Administrative Work Bench (AWB).

NetWeaver / BW reporting: Business Explorer Analyzer, BEx Query Designer, Designing variables, Restricted key figures, Conditions, Exceptions, variables using customer exits, Reporting on Hierarchies, Navigational attributes, Cell reporting, Web Application Designer, Jump queries, BI and Enterprise Portal, Business Server Pages.

BOBJ reporting: BusinessObjects Enterprise reporting tools, including Web Intelligence (WebI), Xcelsius dashboards, Universe Designer, QAAWS, LiveOffice, InfoView, BI Launch Pad, Dashboard Builder, Design Studio 1.5.

R3 Skills: Activation/Enhancement of business content data-sources, LO cockpit customization related to BW, ST06, ST05 traces, .

Data load monitoring: Info-Package grouping, Info-package scheduling, experience in scheduling data loads using Process chain of events such as OLTP extractions, delta/full updates, ODS data activation, data load in cubes, aggregate roll-ups, creating/deleting Indexes.

ABAP skills: Start routines in transfer rules & update rules, customer exits to populate query variables, function modules, user exits for Data-Source enhancements, conversion routines, BAdIs.

Performance tuning: Using BW Statistics, Work Load Monitor and Query Monitor.

SAP BW versions: 3.5, 7.0, 7.3, 7.4

SAP R/3 versions: 4.6B, 4.6C. 6.0

Business Objects: 3.X and 4.1

Data Services: BODS Designer, BODS Workbench

HANA: 1.0 SP3, SP6, SP7, SP8, SP11.Reporting Tools: BEx, OLAP Analysis, WebI, Xcelsius, Crystal Reports (2011, 2013, for Enterprise), SAP Lumira, Dashboard Design, Design Studio 1.5, BO Explorer, Tableau 9.0 and Qlik Sense.

PROFESSIONAL EXPERIENCE:

Confidential

BI/BW Architect/Team Lead

• Working on database migration project for BW and BOBJ systems from Oracle to HANA database on cloud.
• Performed pre-migration activities like, system logs clean up, OSS note application, consistency check and repair of all DDIC and relevant objects etc., to prepare SAP BW systems for migration.
• Evaluated system’s 1400+ ABAP programs and subsequently performed remediation to make them HANA database compatible.
• Executed post-migration activities like, system sanity check, OSS notes implementation, post migration ABAP remediation, Infocube conversion to HANA optimized cubes etc.,
• Took sanity check and testing steps to evaluate BOBJ and Portal systems before and after the migration process.

Confidential

BI/HANA Lead

• For the project, my primary focus was on the front-end. I worked for Confidential team to design dashboards using SAP Design Studio 1.3 and 1.5.
• Also worked on Lumira, Qlik View for certain specific dashboard requirements.
• HANA was the source database, which I leveraged to bring information into dashboards to create interactive reports with “Whatif” analysis.
• Created complex information models using Stored Procedures, CE functions, and SQL Scripting in HANA 1.0 SP.
• Data was brought in from multiple legacy systems into HANA database using BO Data Services.
• Implementation was done using Agile Methodology.
• Did analysis on existing HANA models for data validation and performance of models.

Confidential

BI/BW Architect/Team Lead

• Primary role was to lead SAP team of Sr. Developers to perform day-to-day production support and development activities as well as work with client to plan future strategy and vision.
• While leading the team, I also worked on HANA sizing for BW on HANA as well as HANA as a sidecar scenario.
• Successfully converted two BW report and one ECC report, based on Funds Management tables, to HANA report by using SLTs, Summary Tables and triggers with HANA studio tools. Report was finally displayed using BOBJ WebI platform.
• Fixed multiple BW issues related to data load performance resulting in decrease in daily batch load timing.
• Played significant role in BW 7.1 to 7.3 environment upgrade.
• Did analysis to identify 14 extractors that needs optimization either by changing ECC code or BW code.
• Identified design issues in BW and provided recommendation for optimization.
• Clear understanding of BW on HANA migration options. Configuration and procedure for converting the BW InfoCubes and DSOs to HANA optimized.

Confidential

Sr. Developer

• Worked on CRM and BPC related extractor’s enhancements for Project and Opportunity applications. Created new process chain and optimized existing process chain by doing parallelization of variants where necessary. Also worked on the transformation code to them more efficient for the loading.

Confidential

Sr. Developer

• Converted Legacy report to BI report by gathering business specific process flow information and converted it into BI report based on available standard extractors and creating generic extractors with function module to bring data from ECC to BI.
• Worked on Process Order Component extractor to make it run in delta mode instead of full load on daily basis.
• Also worked on creating Dataflow diagram for entire BI landscape using Visio.

Confidential

Lead Developer

• Worked as a technical consultant on HCM Benefits and Personnel modules for Confidential ’s internal project. Current project involves enhancing 0employee to bring in additional fields to fulfill business needs. Also looking into the possibility of optimizing HCM data loads to reduce load time.
• In parallel, also worked on Proof of Concept (POC) project which is a service centric sales data solution using HANA. Solution works on the concept of predictive analysis based on customer’s prior buying experience.
• Solution required creating tables, Attributes views, Analytic views and calculation views to create data model. It also required using SQLSCRIPT to come up with predictive analysis solution.
• The project involves loading data from SAP BW using Data Services 4.0 for data extraction, HANA technology for modeling (using HANA Studio) and storage of data and BO 4.0 Xcelsius and WebI for front end reporting.

Confidential

Lead Developer

• Created Global Executive Dashboard using BOBJ Xcelsius with multiple KPIs to give a snapshot of how the company is generating revenue across different Hemispheres, Region and Geo-Markets across the world. Main dashboard gives a summary snapshot which executives can drill down on to go to different dashboards to get more information about Revenue, Field Margins, Operating Expenses etc,
• Worked on major backend project to create customized Shipment Cost detail report by bringing most of the customized fields from ECC because shipment procedure has been highly customized to meet company’s needs. I achieved this task by enhancing few standard extractors and creating two generic extractors and populating them using function modules and BAdIs.
• Worked on BOBJ WebI to provide web reports using InfoView for Business Process Instrumentation data, which was using Web-Methods to pull data from ECC and Hyperion.
• Daily Data load was a big issue where process chains were running for an average of 14 hours a day. I did a thorough analysis of the system and came with the strategy of how we can reduce the timing to acceptable time period. First change cycle is about to be implemented and will reduce the load time by about 6 hours.
• I also got a chance to work on Spotfire, which is another tool like Xcelsius for creating dashboards for drilling related data.
• Created a dashboard to display BI Reports Usage metrics to users and managers. I used BOBJ Data Services to extract BOBJ reports statistics from InfoView and Portal.
• Currently in the process of creating a dashboard to give users real time information about the status of daily BI data loads and upcoming loads for the day.

Confidential

Lead HCM Developer

• Played the role of a Lead developer for HCM Module.
• Activated Personnel, Benefits, and Payroll Business Content in BI and relevant datasources in HCM system.
• Enhanced key master data objects such as 0EMPLOYEE, 0PERSON, 0HRPOSITION through custom coding using subroutine pool to bring in several fields such as Hourly rate, Salary per pay, Employment Date, Adjusted Seniority date…etc.
• Enhanced Benefits and Payroll transaction datasource to bring in Bonus, 401k percentage, HSA Savings Election, Medical Premium, Flex Dependent care and several pension related fields.
• Created Z objects and entire ETL structure, followed by process chains to bring in HR data to BI.
• Finally created several reports based on the extracted data.
• Currently in process of designing Xcelsius dashboards and WebI reports to provide reporting solutions for multiple end user groups.

Confidential

Lead Business Analytics Analyst

• Leveraged on already developed SPM system that brings spend data into BI.
• Created custom queries to feed the dashboard for display of 8 KPIs.
• Built complex Xcelsius dashboards to provide interactive user experience.
• Used dynamic visibility and interactions to show several “what if” scenarios.
• Used Stacked Column Chart, Pie Chart, Gauge, Combo Box, Radio Buttons, Line Chart and Background objects to build the dashboard.
• Led the GSNOP project with two other consultants to bring data from EMEA, APAC and LAAM regions.
• Data is provided by business in the form of flat files on an FTP site by business, which is picked up by Process Integration (PI) team to bring into BI apps server directory for loading.
• Built custom ETL process to load data from flat files to InfoCubes.
• Built BEx reports to support reporting requirements.
• Built extensive customization into staging layers to consolidate and prepare data for reporting purposes. This includes writing start and end routines for transformations to performing look ups to calculate values before loading them to DSO or cube.
• Total of about 66 cubes and DSO objects were built for this entire project.
• Data is presented to users using BEx reports, WebI and Xcelsius dashboards.
• In order to speed up the data extraction process for WebI, Analysis Process Designer (APD) is used to pre-calculate some queries and push the data to DSO(s), which loads the data to Cubes for final extraction.
• Led the POS project to bring in data from EMEA and APAC regions two divisions.
• Data is provided as flat files on an FTP site by business, which is picked up by Process Integration (PI) team to bring into BI apps server directory for loading.
• Built custom ETL process to load data from flat files to InfoCubes.
• Built BEx reports to support reporting requirements.
• Built BOBJ Universes and WebI reports to display data to users and executives.
• Built Analysis Process Designer (APD) processes to populate dashboard-specific data marts in order to optimize WebI report performance.
• Successfully managed team of 4 offshore consultants (India) to take care of daily Batch loads from R/3, APO and SRM systems. Batch load on-time success rate of greater than 95% for all areas.
• Managed Service Desk (SD) Tickets in Solution Manager (SAP Product) and assign to offshore and onshore team for fixes.
• Played the lead role in deployment and configuration of BIA, which included sizing, Number of Blades and working closely with Basis team to install, test and deliver for Production system.
• Worked closely with Basis team in the deployment, configuration and testing of Pre-Calc server for automated delivery of BI reports to end users.
• Responsible for performance tuning; resolving loading issues and Query performance issues.
• Solved SD tickets on a regular basis as a part of Production Support Team for quick turnaround.
• Developed, tested and implemented BW Objects for Newell Rubbermaid Inc in SD, FICO and BI Statistics cubes.
• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube 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.
• Enhanced master data sources 0Customer, 0Material, 0Mat Plant, 0Ven Compc to meet custom reporting requirements.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Worked on Creating Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer and Web application designer to create Queries to forecast sales, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Involved in documentation and end-user training.

Confidential

Project Coordinator

• Responsible for the Implementation of Meditech Electronic Medical Record System (EMR) in six regional hospitals in Texas and Louisiana.
• Manage a team of eighteen professionals.
• Maintain server based Microsoft Project Plan.
• Coordinate software-testing activities (Unit Testing, Integration Testing, Parallel Testing, and Stress Testing).
• Coordinate Implementation, training and GO LIVE activities.
• Ensure proper documentation for internal Audit and steering committee meetings.
• Gather weekly status reports from all project managers (12 managers) and consolidate it for executive level review.
• Serve as a liaison between clinical teams and technical teams
• Provide Technical and Administrative support to the Regional Project Manager (RPM).

Confidential

Project Coordinator

• Managed fifteen people distributed in three development teams.
• Defined project plans, scope, activity sequencing, and implementation procedure.
• Estimated project requirements scientifically, assign tasks to team members, review progress weekly and reporting the project progress to program manager and client.
• Responsible for project deliverables and target dates.
• Responsible for the quality and completeness of all the deliverables through every stage of the development cycle and ensure that the deliverables meet the expectations and needs of the customer.
• Test, audit and review the code and assess the quality of the deliverable at periodic intervals and provide proper feedback to the team and to the Program Manager.
• Provide BEx training sessions to end users.

Confidential

Project Coordinator

• I was involved in the development of WriteMD and Click and Claim which is an Electronic Medical Records (EMR) application. My team and I worked in collaboration with a Houston based company called Medinformix to develop a HIPAA compatible EMR software.