SUMMARY

• SAP BW/BI/Hana Consultant with 11 years of experience in IT industry which includes 9 years of SAP BW/BO/HANA functional and technical experience, playing various key roles in Design, development and production support, with extensive experience in SAP BI - Data Modeling, Report development and Performance tuning.
• Worked in three full life cycle implementations. Experience in all areas of SAP BW implementation, Front end, Backend, Modeling, Configuration, Reporting and Extraction.
• Excellent exposure in ASAP methodology and SDLC process (Requirements gathering, Gap analysis and Project Realization).
• Hands on experience working in SAP and Non-SAP data integration and ETL processes for data feeding in / out BW and ETL environment.
• Hands on experience in back-end and front-end development objects using various new dimensional skills (SAP BI/BO/Hana, BODS, Lumira, BI Launchpad, Bex suite).
• Experience handling integration between multiple systems for reporting - SAP ECC, SAP BI, Non-SAP BOBJ.
• Good enough exposure in OLAP and OLTP technologies and dimensional modeling. Hands on experience with data warehouse architecture and modeling.
• Experience with SAP HANA data modeling using Attribute View, Analytic View, and Calculation View and data provisioning.
• Expertise in activating standard Business Content, extending and enhancing Info Cubes according to the requirements, Data source Enhancements, User Exit Variables.
• Hands on experience in design and development of Business Objects Reports based out of SAP BI, Hana Oracle, and SQL Server data sources using IDT, UDT, BI Launchpad, and Lumira, Tableau.
• Experience in Production support and issue resolution that involved debugging of data loads, start routines.
• End routines, field level routines, process chains and monitoring and scheduling data loads, Improved data load and query performance by doing Compression and by creating Aggregates.
• Good enough exposure in BEX Query Designer, Bex Analyzer for building Queries, Workbooks, and dashboard design using SAP Business Objects.
• Good enough exposure in SAP functional areas SD, MM, SD,SCM, CRM, FI/CO, APO, SRM and HR
• Participation in complete life cycle implementation of BI 7.x and BOXI 4.0/3.1 reporting.
• Good enough exposure in testing area like prepares test case docs and test scenarios by using HP Quality center/ALM.
• Self-starter, Team player, good Communication skills, can quickly adapt to new technologies.
• Good enough exposure in scoping exercise, create POCs, demos for End-user training.
• Good understanding in databases Oracle, DB2, SQL, MSSQL etc..

TECHNICAL SKILLS

Enterprise Applications Tools: BI 7.3, 7.0, BW 3.5, 3.1C, 3.0, BPS, BO4.0, SEM, ECC 6.0, R/3

Modules: FICO, SD, MM, PM, PS, PP, CRM, SRM, SCM, HR, APO

Operating Systems: Windows, UNIX, Linux and Sun Solaris

Languages: ABAP, HTML, C, C++, Java, SQL, And PL/SQL.

Databases: Oracle, DB2, and SQL Server, Hana

Others: Remedy, Ascendant, HP Quality Center (Test tool), Jira

PROFESSIONAL EXPERIENCE

Confidential, PA

SAP BW/BI Developer

Responsibilities:

• Worked with end users to gather requirements for designing and developing the BW system.
• Translate functional specifications into technical specifications and data warehouse design in PV BOM and BOM ECN Expiry Reports, ECN Work Flow report, PV Recipe report.
• Installed Business content Objects based on user requirement. Enhanced data sources and custom cubes to meet the client’s requirements
• Back-end and front-end development for PV BOM Report, BOM ECN Expiry Report, ECN Work Flow report.
• Working on Data Modeling, Customize Infoset, Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines. Business Content, Generic data extraction, Data Loading, Scheduling, Monitoring and Extracting.
• Creating OLAP Analysis and WebI Reports in manufacturing area. Migrating existing Bex Reports into BOBJ reports using BICS Connection
• Created Reports in BOBJ 4.1 for end user analysis by using IDT and BI Launchpad, Lumira, Tableau.
• Actively involved in GME, GTT back-end and front-end BW/BO development work.
• Create and execute test scripts for the backend and front end and documenting.

Confidential, Draper, UT

SAP BW/BI Developer

Responsibilities:

• Requirements gathering and data analysis. Understand business needs and translate user requirements into business-ready reports using SAP BI/BO tools.
• Good understanding in ASAP methodology and actively involved in Hands-on development activities.
• Designed and developed Back-end and Front-end objects related to Sales Tracker EC View, Total Sales view, Team Manager Sales View, AFE Funding and AFE Reminder.
• Developed BI objects and Open Hub Interfaces for Tool Box Data, CRM data and ECC data integration to feed data in / out BI to Fork-Lift (EDW).
• Design and developed Martiz and FMP Data, CSI, Harmony files, Melissa, Unica data integration in to SAP BI.
• Research data issues in various source systems (SAP and non-SAP) for inconsistencies, enhancements and modifications to existing objects.
• On call support and Production support activities for existing system (Batch network, Trouble shoot daily data loads, Dump Analysis and OSS notes recommendations).
• Troubleshoot reporting and loading performance issues. Responsible for Hyper care support and JIRA, Remedy tickets defects resolution.
• Involved Customer 360 project development and enhancement work related to Subscription History, CRM Sales Orders, and CRM Activities, Order Summery, Interaction History.
• Responsible for preparing Dataflow Documents, Technical Design Documents, Application Design Documents and training Documents for the end users.
• Attend meetings for design reviews, SPRs approvals and CCRB meetings for transports approvals.
• Created Reports in BOBJ 4.1 for end user analysis by using IDT and BI Launchpad, Lumira, Tableau.
• Participation in BI Upgrade 7.x, Hana, BODS and Lumira dashboard visualization proof of concepts.
• Creation of RDDs/L1 and technical specs(MDD/L2) and perform all integration testing and documents the results of all testing in accordance with program procedures and standards.

Confidential, DE

SAP BW/BI Developer

Responsibilities:

• Worked with end users to gather requirements for designing and developing the BI system.
• Involved entire SDLC process. Design, code, test, and document new or modified BI cubes.
• Enhancements to the Inventory, Purchase, Sales, and Billing extractors related to RTP, STC areas.
• BPDM and E-Sourcing design changes and hands on development work.
• Designed and developed interfaces(outbound/Inbound) for legacy data integration to and from BI system.
• Production support activities for existing system (Batch network, daily process chain monitoring, cutover activities).
• Troubleshoot reporting and loading performance issues.
• Worked extensively in front end reporting by using BEX Business Suite.
• Participation in BI7.0 to BI 7.3 upgrade activities.
• Involved in Application stack upgrade and cut over activities. Work with BASIS and the DBA resources to define environment needs and paths.
• Participated in SAP Hana Design and development work related to Global Sales and Financial reports.
• Involved in SAP HANA Data Provisioning and using SAP LT Replication Server (SLT) and SAP ECC table data model and analysis.
• Designed and Created Universe, Classes and Objects for management system to generate adhoc reports.
• Design & build Dashboards, reports using SAP Business Objects Suite of tools such as Web Intelligence, Xcelsius.

Confidential, PA

SAP BW/BI Developer

Responsibilities:

• Worked with end users to gather requirements for designing and developing the BW system.
• Worked extensively on Open hub to distribute BI data to other applications.
• Actively involved in GME back-end and front-end BI development work and GTT BI back-end and front-end deployment work.
• Installed Business content Objects based on user requirement. Enhanced data sources and custom cubes to meet the client’s requirements
• Extensively worked on Modeling, Customize Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines.
• Business Content, Generic data extraction, Data Loading (Full/Init/Delta Up-Load), Scheduling, Monitoring and Extracting.
• Back and front end development for process orders and Material consumption target-actual reports.
• Involving in Release1, 2, 3 developments and handling service requests in Manufacturing, Finance, and Supply Chain areas.
• Create and execute test scripts for the backend and front end and documenting.
• Involved in back-end and front-end enhancement work related to special ledger and project systems.
• Involved in preparing Dataflow Documents, Technical Design Documents, Application Design Documents and training Documents for the end users.
• Responsible for loading Plan/Actual Master data (Texts, Attributes and Hierarchies) / Transaction data from R/3 Data sources and from Flat Files.
• Extensively used Query designer to created queries, variables, filters, calculated key figures (using before and after Aggregation), Restricted key figures, etc.
• Created universes using SAP BW cubes and BEX Queries as Backend
• Created reports using Business Objects functionality like slice and dice, drill down, cross tab, master detail tables and formulas, etc.
• Developed Dashboards in Info view to accomplish launching various Reports.
• Modified Universe after analyzing areas of business and user requirements
• Actively involved in coordinating the offshore and the onsite team by looking into timely deliveries.

Confidential, IL

SAP BW/BI Developer

Responsibilities:

• Actively Involved in coordinating the offshore and the onsite team by looking into timely deliveries
• Involved in full life cycle implementation of Purchasing, Sales order delivery, Inventory Management, finance and SEM BPS.
• Involved in leading the Cutover, rollout and configuration Management, which involved conducting technical meetings and analysis.
• Involved in STC, OTC, and STP, RTR design and development work.LO Cock pit extraction and data loading for BI data targets.
• Dealt with the custom built Cubes DSOs, Multi Cubes, Transformations and Queries depending upon individual requirements.
• Created Generic extractors to satisfy the multitude user requirements, put forth to ensure the visibility for specific data.
• Created enhancements to the extractors and wrote user exits by using ABAP to populate the enhanced fields.
• Created export data sources in BI to loop the data back from the temporary and backup cubes to the standard cubes.
• This ensured security of the historical data and provided a safety blanket in case of future modifications.
• Involved in IT Service Management (ITSM),TPM related to CRM area
• Customized and maintained all the process chains to meet the daily requirements.
• Strong work experience with Business explorer, BEx Query Designer, Web App Designer (Net Weaver 2004s).
• Worked in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using, Xcelsius, Web and Crystal.
• Hands on experience with deploying dashboards to users using portals and different outputs.
• Actively involved in coordinating the offshore and the onsite team by looking into timely deliveries.

Confidential, IL

SAP BW/BI Developer

Responsibilities:

• Responsible for requirement study, gap analysis and data mapping between SAP HR BW and 3rd Party system.
• Prepared technical specifications once business signs off the functional specifications
• Worked extensively on the Mainframe Legacy data integration to SAP BI.
• Analyzed business reporting requirements that could be satisfied with SAP business content and installed the necessary objects.
• Extensively worked on Modeling, Customize Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines.
• Business Content, Generic data extraction, Data Loading (Full/Init/Delta Up-Load), Scheduling, Monitoring Performance tuning and extracting.
• Implemented BW Business Content data source enhancements, generic extractors, user Exits and customized delta built up for the data sources.
• Enhanced the business content Info cubes HR, FI-CO for extraction transformation and loading (ETL).
• Involved in Cutover, rollouts which involved conducting technical meetings and analysis.
• Hands on development work in CRM, Order to Cash (OTC), and Purchase to Pay (PTP) development and reporting.
• Created queries using variables, restricted key figures, filters, exceptions, conditions and free characteristics.
• Involved in entire testing cycle and documented the results.

Confidential, NY

SAP BW Consultant

Responsibilities:

• Involved in gathering Business Requirements from Users & Business Analysts for data modeling and Prepared Business Blueprint, System Blueprint and Operational Documents
• Created & maintained Info Objects, custom data sources, Info Sources, communication structures, transfer structures, transfer rules, update rules, Info packages& Info Packages groups & scheduling the data requests.
• Create Generic Extractors, Datasources, ODS, Cubes for PO accounting details, requisition accounting, EBP SRM system and data extraction from R/3 and EBP source system.
• Managed & Monitored several data Loadings and optimized the performance by adjusting packet Size and data Selections.
• Worked extensively on administration workbench. Analyzed InfoCubes created and maintained aggregates to improve the performance.
• Responsible for activities Statistical update and DeltaQue’s, Setup Tables at the time of release
• Business Content Installation, modifications in user exits according to new requirements and new releases.
• BW daily loadings, monitoring and responsible for Bug Fixes and execute new PTR’s,CR’s
• Built Process Chains for Masterdata, FI Data Load, Purchasing Data load, PO Accounting data load, requisition accounting, EBP data Load.
• Document test plans and complete Unit Testing of developed reports. Work with Quality assurance resources to complete System and Integration Testing
• Responsible for BW Transports objects from Development to Quality to Production.

Confidential, NJ

SAP BW Consultant

Responsibilities:

• Identify and activate Business Content InfoCubes, Update Rules, Info Source, DataSource, InfoObjects, and variables, query elements and workbooks for FI-GL, CO-CCA, PCA, and PC modules.
• Enhanced standard Datasources, programmed user exits for Datasources and variables, customized transfer, Start routines and Update Rules using ABAP routines.
• SAP R/3 data Extraction from modules such as FI-GL, CO-CCA, PCA, and PC
• Transfer of Business Content from FICO, MM, SD modules to active version with all its dependence objects like Info Cubes, updated rules, Info Sources, transfer rules, queries, etc.
• Developed ODS object to load Sales Order Data from the Info Sources. Defined the update rules. Loaded transactional data into PSA and updated data from PSA to ODS and Activated ODS for reporting.
• Queries were developed using Filters, Restricted Key figures, Calculated Key figures and Variables for Characteristics, Key figures, Hierarchies, etc.
• Development of Queries and reports using BEx Analyzer, Browser.
• Created Info Packages and Scheduled loading of data to BW Server and used the BW Monitor to monitor data loading into the Info Cube. Worked extensively in creating Jump Queries