PROFESSIONAL EXPERIENCE

• 11+ years of SAP experience specializing in SAP BI/BW, SAP HANA, Business Objects, and ABAP with focus on delivering SAP solutions for Business Issues.
• Expertise in Architecture, Data Modeling of Business Intelligence and Front End Reporting tools.
• Implemented full life cycle projects in SAP BI/BW with different versions BI7.4, 7.3, 7.0, BW 3.5 and 3.0B. Extensive knowledge in different SAP functional areas, integrating BI various versions of ECC, CRM, SRM, SCM, Business objects and BPC.
• Been part of multiple types of projects: Implementation, Roll - outs, Upgrade, Enhancements, Support & Agile methodology development.
• Experience across various industries like Pharmaceutical, Retail, Public Sector, Logistics, Customer service and more.
• Providing assistance to various teams by understanding the business process and requirements of the users at a depth sufficient to design and implement an appropriate BI Architecture and solution to meet their needs.
• Having Lead Experience with good technical, business presentation, communication and time management skills.
• SAP Certified Application Associate SAP HANA 1.0.
• Expertise in SAP BW/BI (3.5 thru 7.3), SAP R/3 (4.6 thru ECC), SAP CRM 7.0, SAP GTS 10.1.
• Expertise in all areas of SAP BW implementation, Extraction, Data Modeling, Conversions, Front-end Reporting using BEx, WAD and SAP Business objects.
• Experience in implementing SAP provided standard business content Extractors/Data sources (LO Cockpit, COPA, CRM, GTS) and implementing Customer exists, BADI to enhance standard data sources to fulfill the business requirements.
• Worked extensively on SAP BW Data model: Multiprovider, Infoset, InfoCubes, ODS/DSO and Aggregates, DTP’s, Transformations, User exits using ABAP.
• Experience in developing Transformations, DTP routines, Start routines and End routines using ABAP to incorporate Business logic and perform data manipulation.
• Worked in Index Creation, Aggregates, statistics, Partitioning and Compression of Cubes, performance tuning at the Query level as well as the Data target level.
• Worked extensively on BI Reporting and Broadcasting of BEx Queries, automating it through Process chains, WAD, security roles and profiles.
• Experience in SAP-BIBO (UDT, IDT, WEBI), SAP-BOBJ (XI R2 thru SAP BOBJ 4.0), Universe Designer, WEBI (Web Intelligence Reporting), XCELSIUS 2008 and Tableau.
• Provide proactive investigation, review, assessment, design and implementation of methods to improve existing processes and performance.
• Assess existing and available data warehousing technologies and methods to ensure solutions that meets the needs of the business unit
• Worked on APD’s, Open Hubs and BI Accelerator.
• Expertise in trouble shooting and performance tuning by providing proactive investigation, review, assessment, design and implementation of methods to improve existing process. Assess existing and available data warehousing technologies and methods to ensure solution that meets the needs of the business unit that meets the needs of business unit.SAP HANA SKILLS Summary
• Good Understanding of SAP In-Memory Computing Architecture, Column store, Row store tables inSAP HANA Studio, different kinds of Perspectives.
• Developed Information models on top of SAP HANA tables: Attribute Analytic, Calculation Views, Restricted and Calculated Measures, Decision Tables with update and Return values.
• Experience working with data replication to SAP Hana using Data provisioning tools such as DXC.

TECHNICAL SKILLS

SAP Technologies: SAP HANA 1.0 SP05, SAP BI 7.1, SAP BI 7.0, BW 3.5(BW-BPS)/3.1C/3.0B/2.1C, SAP R/3 (4.6 thru ECC), Enterprise Portals 6.0, ABAP/4.

SAP Modules: CRM 7.0, ECC 6.0 (FI-CO, SD, MM, PP, CS, PM, HR), GTS 10.1, SCM, BPC 10.0.

Reporting/Designing Tools: Web Application Designer, MS Visio, Business Objects, Crystal Reports 8.0/9.0/X/XI/XIr2/2008, Business Objects XI R3.0/ 3.1/ 4.0, Business Objects Universe Designer, SQL, Tableau

Operating Systems: MS-Windows XP Pro/NT/98/95, 2000 Server, HPux11v3, AIX, Linux.

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

SAP BI HANA Architect

Environment: ECC 6.0 with BI 7.4, HANA SP05, BPC, MSCRM.

Responsibilities

• Analyze the current high visibility reports and redesign the data flow to make them available faster accurate and with better user experience to business.
• Worked on integration of Fusion IO and retail sales, delivery and financial solution with existing Confidential BI/BW Business reporting system.
• Performed data modeling, application development, technical product assistance and tuning to meet customer performance and functional requirements.
• Co-ordinate with team for requirement specifications and issues.
• Supported BW BPC planning and Consolidation Cubes, Extracted AOP/QRF Planning data into BI for further data modeling and Reporting.
• Implemented Booking Billing Backlog and Revenue reporting solutions for sales finance and sales business team.
• Utilized Data provisioning tool such as DXC (Direct Extractor) Mechanism to load data in to SAP Hana which intern creates tables for further data modeling.
• Created Attribute, Analytic view on sales, delivery and billing entities as part of customer portal project and provided reports where user can analyze open orders, Backlog quantity and other business analysis in SAP HANA.
• Created Calculation view to join data from various entities such as BGF, CSF, FSF, and AOP/QRF for TAM-SAM-SOM Reports as part of market model reporting.
• Created new reports and modified existing reports to meet Fusion IO and Confidential business reporting solutions.
• Worked on Business objects OLAP Reporting systems based on BEx Reports.

Confidential, Long Beach, CA

SAP BI Architect

Environment: ECC 6.0 with BI 7.3, BOXI/R3.1, GTS 10.1, SCM.

Responsibilities

• Worked on Tinta blue phase 1 and 2 Projects contributing to all aspects of SDLC, including gathering of requirements, business and technical assessments.
• Analyzed Various KPI Requirements from Business units to design efficient data model using SAP BI reporting solution as backend and BO as front end for the Analytic reports satisfying business needs.
• Designed and developed data model for Key performance Reports such as
• Late Tracker Report, Warranty Claims, Warranty Parts Details, Repair Yield, BOM Usage, Invoice detail, Service Order detail, Production order.
• Using Standard data sources such as 2LIS 17 I3OPER, 2LIS 17 I3hdr, 2LIS 04 P MATNR, 2LIS 04 P COMP and custom data sources build on tables such as Reservations, Warranty claims, Confirmations.
• Developed new infoproviders, data source in SD, MM, PP, CS & GTS to fulfill the business requirements.
• Utilized Transformations and DTP’s for leveraging data from various data providers.
• Implemented various performance tuning activities to Stream lined data loads by identifying parallel execution of chains, implementing Pseudo delta for data sources where it doesn’t support delta mechanism and handled huge volume of data.
• Developed Open hub interface to transfer data from various infoproviders from BI to flat files to load into an external system.
• Developed BEx and Webi Reports as per the business requirements using single data source (Universe), Multi Data sources using Merged Dimensions, Complex Functions/ Variables at the report level as per the needs from business.
• Provided End User training by organizing class room training to enable business users to have hands on Business objects tool.
• Applied OSS notes and opened tickets with SAP as part of trouble shooting and problem resolution.
• Resolved post go-live issues in Data extraction, Loading and reporting by analyzing various factors in source system and BW.
• Created HANA optimized Cubes.
• Worked on SAP based HANA Models (Attribute, Analytical views).SAP BI 7.3 Upgrade Project:
• Lead SAP BI 7.3 upgrade project, performed initial configuration of new BI7.3 landscape, analyzed impacts and resolved issues after upgrade to BI7.3.
• Coordinating with Basis team to resolve memory, table space issues, applying required sap notes, establishing RFC Connections with various source systems.
• Worked with security team to evaluate and create the required Roles and authorization and related issues.

Confidential, San Diego, CA

SAP BI Lead

Environment: ECC 6.0, CRM 7.0 with BI 7.0, BO XI/R3.1

Responsibilities:

• Responsible for analyzing the functional inputs by interacting with business and converting them into technical design.
• Design and developed data model for Key performance indicators such as delivery Performance to Customer by quantity, drop ship visibility on purchase order using 2lis 02 itm, 2lis 02 SCN, 2lis 02 CGR, 2lis 02 SGR.
• Designed and Developed Infrastructure for Cerner Change Log report.
• Utilized Analysis Process designer (APD) to perform snapshot of beginning monthly Goal Buckets by providing in order to build Collections-Portfolio performance Report.
• Customized and Enhanced Data sources such as 0CRM SALES CONTR I, 0CRM SRV IBASE ATTR, 0CRM SALES ACT 1, 0CRM SRV REQ INCI H Using BADI Implementation as per business requirement.
• Developed Custom BW Extractors based on Function module interface for applications such as IObject Qualification, Time allocations (WFM), Incident Case extractor for HR.
• Worked with Open Hubs for sending data from BW system into other Logical systems such as North Star, GCS and Genesys.
• Used BI Accelerator (BIA) to optimize BEx query performance.
• Developed BW-CRM Analytics Reports using BEx Query designer Such as
• Collection-Portfolio Specialist Performance Report
• Cerner Change Log Report
• All Units Report
• Monthly Ageing Trend Report
• Evergreen Block Report
• Created Universes, Classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Used @ functions like @select, @where and @prompt function to create prompts which helps user to select values dynamically.

Confidential, Rochester, NY

SAPBI Lead

Environment: ECC 6.0, CRM 7.0 with BI 7.0

Responsibilities:

• Responsible in discussing business solutions for KPI-C with Business Analysts.
• Involved in Design and development of the infrastructure for KPI-C metric Analytics Project for the live perfect order percent.
• Perfect order metrics were derived out of the 2lis 11 VAITMP1960 Project
• Responsible for Data Modeling in the Data Warehousing effort of the CRM (IBase, Service Contracts, Service Order, and Service Order Confirmations) and Master data(Business partner) for the SAP BW.
• Based on the GAP analysis, activated available Business content and created necessary custom Objects like Info objects, ODS and InfoCubes.
• Installed CRM BW Extractors 0crm srv ibase0crm srv contract h, 0crm sales contr i, 0crm srv process h,0crm srv process i, 0crm srv confirm i and 0crm srv confirm h. attr,
• Written Data Transformation Rules with ABAP to combine the data from different Sources to remain Consolidated into Info cube.
• Created Generic data source CRM Finance internal order using table VIAOM CRMSRV OBJ.
• Created and Loaded hierarchies using flat-file to display the Service Code data in hierarchical form in the reports.
• Implemented various performance tuning activities to increase the performance of Queries by creating Secondary indexes, Aggregates and Compression.
• Worked with Open Hub Service for sending the data from BW system to Data services for data cleansing and data Integration purpose.
• Developed BW-CRM Analytic Reports using the BEx Query Designer such as
• Installed Bases without Service contracts,
• Number of Service Contracts Per Installed Base Category,
• Remaining Term of Service Contracts,
• Expiring Service Contracts item.
• Designed SAP universe over a consolidated BEx query and developed reports using WEB-I and BEX query as data source to address reporting needs such as Contract availability for an IBase.
• Used WEB-I for Adhoc reports and XCelsius to generate corporate Dashboards for reporting Time and Material and Entitlements.

Confidential, Austin, TX

Sr. SAP BI CONSULTANT

Environment: ECC 6.0, SAP BI 7.0

Responsibilities

• Analyzing the functional inputs by interacting with functional team for requirements gathering, development and implementation of BI in the SCM Area.
• Participated in the End User discussions to get a thorough understanding of front end reporting requirements.
• Involved in Data design, Data modeling, Data extraction, Data loading and Reporting.
• Worked extensively on Data warehouse workbench and customized Info objects, Info cubes, DSO’s, data sources, DTP’s, Transformations and Multiprovider.
• Extensively worked on LO Cockpit and performing the necessary procedures like setting up of update mode, deleting the Setup tables, filling up of setup tables and loaded data from SAP ECC to SAP BI and used initialization update and delta update mechanism.
• Performed Master data and Transaction data Extractions (SAP, Non-SAP) and automated the data loads using process chains.
• Involved in data integration which is concerned with the bringing data from wide variety of sources (databases, flat files, applications and unstructured data) and normalizing it.
• Enhanced InfoCubes with Remodeling concept to make changes, without having to reload data.
• Involved in Performance tuning by creating Aggregates, Compression, Optimizing the code, refreshing the statistics etc.Reporting:
• Modified the existing reports with the new fields and transported to Production system.
• Used Structures, Calculated Key figures, restricted Key figures, selection, formula, Exception and conditions.
• Developed SD reports like billing detail by customer, Top 50 customer based billing and products,
• Backorder processing reportStock in transit,Stock transfer order.
• Used BEx analyzer/Query designer: developed reports by enhancing the standard queries for Stock management, P&L report, gross margin analysis actual versus budget reports.

Confidential, Houston, TX

Sr. SAP BI CONSULTANT

Environment: ECC 6.0, SAP BI 7.0

Responsibilities:

• Extensively involved in Production support by monitoring Daily/Weekly/Monthly data loads into the BI system from different source systems.
• Handled the tickets of priority 3 and 4 by following (SOP) Standard operating Procedures and never missed the (SLA) Service level Agreement.
• Monitoring of Infopackages and analyzing the reasons for frequent failures of Infopackages.
• Performed Reconciliation to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Performed Data load monitoring and failed data packets were analyzed and if possible manually maintaining work history for all the tickets until it is closed.
• Implemented various performance tuning activities to increase the performance of Queries by creating Secondary indexes, Aggregates, Partitioning/ Repartitioning and compression.
• Error Debugging and Rectification, Solving issues, problems faced during data loads.
• Analyzed PSA table growth and scheduled weekly PSA and Change Log deletion jobs.
• Data load Performance analysis/Optimization of data warehouse through BI statistics and Used Remodeling functions on Info Providers through redesigning.
• Solving incidents raised by the Business users pertaining to the Repots.
• Developed Ageing Reports like Stock ageing report, Vendor ageing report, Stock in transit, Stock transfer order and Self Billing Reconciliation.

Confidential, Racine, WI

Sr. SAP BI Consultant

Environment: ECC 6.0, SAP BI 7.0, EP 7.0

Responsibilities:

• Involved in full cycle implementation including gap analysis, blueprint, design, development and testing, participated in the project planning sessions with project managers, business analysts, and team members to analyze business requirements and proposed solution.
• Designed, developed and modified Info Objects, DSO Objects and Info Cubes using Administrator Workbench (AWB). Loaded these objects with Master data and Transactional data from SAP ECC and flat files using full/delta loads by creating Info Packages and Data Transfer Process (DTP’s).
• Developed the complete data model involving QM Notification (Activities, tasks, Item and Cause) and inspection results (General and Quantitative data).
• Developed the standard reports for Quality Management Such as
• Defect Analysis
• Vendor Analysis/ Evaluation
• Material Analysis
• Usage Decision
• Provided support for the existing SAP BW data model based on SD and FICO by tuning the transfer/Update rule and aggregates to improve performance.
• Written complex Data Transformation Rules with ABAP to combine the data from different source system to remain same and get the date range automatically based on the fiscal year.
• Developed and maintained queries with Restricted Key figures, Calculated Key figures, Selection, Formulas, Variables, Conditions and Exceptions.
• Worked on Planning Modeler and Configured Real-time InfoCubes, Planning Functions, Planning Sequences for financials and sales.

Confidential, Waltham, MA

SAP BW ABAP Consultant

Environment: SAP R/3 4.6C, SAP BW 3.1c, FI/CO, HR.

Responsibilities:

• Performed post-upgrade activities such as Replication of data sources, Activation of Transfer Structures etc.
• Monitoring of daily loads and analyzing the reasons for frequent load failures.
• Maintain reconciliation’s to verify the data in SAP R/3 with SAP BW.
• Implemented a BW data warehouse solution for reporting HR and CCA data.
• Implemented InfoCubes for Payroll, Headcount, and Personal actions, Staffing Assignments, Appraisals and Recruitment.
• Responsible for designing and development complex Extractors using Functional modules for various HR areas.
• Worked in the area of Cost Center Accounting, Personnel Cost Planning, HR Payroll and Personnel Time Management.
• Responsible for designing and development complex extractors using functional modules for various HR areas.
• Extracted data from Data Sources like 0HR PACP 1, 0HR PT 1, 0HR PT 2 and 0HR PY 1.
• Created an Interactive and ALV Reports for displaying Vendor Information based on the selection made by the corresponding Vendor Bank Details.
• Maintenance of various Data Object definitions like Tables, Data Elements, Domains. Transfer data from Legacy to SAP using SQL queries.
• Involved in Debugging using ABAP debugger, runtime Debugging Analysis, solving problems, including research, driving to Root Cause, and creating efficient solutions.
• Created an interactive report, which lists the customer details in the basic list.