SUMMARY

• 15+ years of SAP BW/BI experience as Senior BW/BO Developer/Architect.
• 1+ year of BW4HANA experience as Senior BW/4HANA Analyst/Developer.
• Six full lifecycle implementation experience in BW/BI, Business Objects, HANA and MS Power BI.
• Proficient in BW7x/3x, BO3x/4.2 and BW/4 HANA design, development, modeling and reporting.
• Modeled E2E data flows in FI/CO, MM, SD, WM, PCM, BPC, PPM GTS, TMS and external systems Astea, SFDC, ServiceMax, ADP and John Galt forecasting.
• Experience gathering business requirements, developing action plans, identifying deliverables and presenting results.
• Ability to work on multiple projects/tasks/assignments concurrently with a sensitivity to time and budget constraints.
• Good understanding of SAP business processes, transaction flows and database tables
• Able to Design high quality flowcharts/technical specifications to map business requirements using best business practices and give development guideline and estimates.
• Deliver Technical Unit using Agile Development model, Waterfall and hybrid project methodologies.
• Strong work ethics, leadership and interpersonal skills.
• Good presentation and communication skills.
• Ability to effectively manage stress and engage in continuous learning.
• Experience working with multi - lingual, multi-currency and time zones.
• Strong debugging/troubleshooting and problem solving skills.
• Customer satisfaction & focus oriented.
• Experience includes all implementation stages: requirement collection, Gap analysis, data model design, configuration, simulation, transport, testing, documentation, modification, Go-live and support.
• Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube,DSO, Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation and Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Proficient in ETL (Extraction, Transformation & Loading) from various SAP & Non-SAP sources. Knowledge of ABAP as relates to BW customization. Familiar with Data Mart and Data Services.
• Experience in reporting using queries on BEx Analyzer, management reports for making business decision, well acquainted with other BEx tools like calculated key figures, restricted key figures, filtering of data, RRI, exceptions, conditions,structures, cell definitions and Web Reporting.
• Expertise in data extraction from SAP R/3, non-SAP systems and flat files by using extraction methods like LO-Cockpit, Generic extraction, and thereby enhancing the Extract structures based on the user requirement as needed.
• Experience in Performance Tuning using Aggregates & Roll-Up, Compression of an InfoCube, Indexes, and BW Statistics. Knowledge of ABAP as relates to BW customization.
• Create & monitor data loadings and automate via process chains.
• Implemented SAP HANA (BW/4HANA) with SAP and non-SAP sources systems and Power BI front end for reporting and analytics.
• Experience in BW/4HANA, SAP Landscape Transformation (SLT), Smart Data Integration (SDI), Operational Data Provisioning (ODP), Delta Que ODQ, Advanced DSO, Composite Providers, Open ODS views. Optimize data tiering across hot, warm and cold data stores.
• Expertise in Universe designing, Infoview, CMS, Desktop Intelligence, Web Intelligence, Lumira, Crystal Reports and BODS.
• Developing and generating complex,Adhoc, dashboard Reports using Xcelsius.
• Building new queries on BEx and converting existing queries for Webi reporting utilization.
• Familiar with SQL and Data Mart/Data Services for Enterprise Data Warehouse (EDW) modeling.
• Six Full-cycle implementation experience in SAP BW & BW4/HANA (BW7.5, BW7.x andBW 3.5 environments and Business Objects (BO XI to to BO/BI4.2).
• Expertise in data warehousing process including data modeling, data extraction, and administration of the data warehouse management processes and Enterprise Data Warehousing (EDW). Experience using Power BI (Microsoft) as front end tool for reporting and analytics.

TECHNICAL SKILLS

SAP BI/BW, BOBJ: SAP BW4HANA 7.5, SAP Netweaver BW7.4, 7.3, 7.0, BW 3.5, BOBJ XI to 4.2

SAP R/3: SAP R/3 4.X, ECC 5.0, ECC 6.0

Front End Tools: Power BI, BEx Analyzer. Query Designer, Web Application Designer, Business Objects XI 3.1/4.2 (Webi, Universe Designer, Xcelsius, CMS), Crystal Reports, Lumira, MS-Excel

Operating System: MS-WINDOWS, Windows 2003/2008/2012 Server, Unix (AIX 4.3.3, Sun Solaris 8,9)

Languages: Java, C, C++, HTML, COBOL, ABAP, PL/SQL SQL*PLUS, VISUAL BASIC, VBScripts, Java Scripts.

Development Methodologies: ASAP, SDLC, AGILE

Databases: Oracle, DB2,SQLServer, and MS Access.

Networking: TCP/IP LAN/WAN, FTP, Telnet.

PROFESSIONAL EXPERIENCE

Sr SAP HANA, BW & BO Developer/Architect

Confidential, Springfield, IL

Responsibilities:

• Managed all aspects of the entire BW & BO Enterprise reporting landscape from design, installation, modeling, data loading/process chains and performance tuning.
• Worked with and managed multiple vendor/clients to for various BW, BO and HANA related projects like BPC, PCM, PPM, GTS, TM and PPM to get data into/out of BW environment.
• Gathered Business Requirements and Conducted Gap Analysis to install Business Content.
• Designed & Developed custom DataSource, InfoSource, Extractor, InfoCube, ODS, Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation and Aggregates, Compressions, Indexes, Multi Cubes and parallel setups for data loading to improve performance and utilize data effectively.
• Experience in BW/4HANA, SAP Landscape Transformation (SLT), Smart Data Integration (SDI), Operational Data Provisioning (ODP), Delta Que ODQ, Advanced DSO.
• Extracted and loaded data from SAP R/3 into Finance Management & Controlling InfoCubes using DataSources.
• Developed Transfer rules, Update rules and Start routines using ABAP to incorporate Business logic and perform data manipulation, used ETL.
• Created process chains for data loading, delta uploading and periodical PSA deletion. Stored data from R/3 tables into ODS objects through PSA to perform detailed level reporting.
• Implemented Business Planning & Consolidation (BPC), John Galt (forecasting), Profitability & Cost Management (PCM) and Project Portfolio Management (PPM) to bring data into BW environment.
• Extraction of Sales Force ( SFDC) via native and Simba drivers.
• 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, Bex Analyzer and Web application designer to create Queries using Restricted Key Figures, Calculated Key Figures,Variables, filters and exceptions.
• Creating and modifying several universes on Bex Reports, in BO Universe Designer, IDT and BODS.
• Extensively created and maintained complex Business Objects Universes and Reports using the Designer and Reporting modules.
• Involved in scheduling, Transports/Promotions and publishing report toBusiness Objectsrepository.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Extensively worked on Query Designer, Bex Analyzer and Web application designer to create Queries to forecast Finance & Controlling, budget and delivery analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Designed Universes in Business Objects (BO) by creating classes, objects and created reports inWeb Intelligence, Crystal Reports and Adhoc interactive reports on Xcelcius.
• Created Multi providers to enhance the reporting base.
• Involved in documentation and end-user training, testing and Quality assurance of the data present in PSA as well as in Data targets.

Sr. Business Analyst

Confidential, Exeter, NH

Responsibilities:

• Gathered Business requirement for SAP BOBJ reporting forSD -AFS module.
• Responsible for requirement definitionto finalimplementation& support.
• Developed reports as per business users/business requirementsusingData Warehouse with SAP BOBJ Sales (SA) Rapid MartswithWeb Intelligence (Webi) report designing.
• Other tasks include supportingthe existing portfolio of 16 differentclientbusiness applications from SAP, Ecommerce as well as outsourced applications like AtTask for Project Mgt (they also use an external vendor for Functional & Technical SAP support).
• A great deal ofinteracting with and managing vendor issues. Majorityof the SAP issuesthat come in are withinFICO and SD.
• The project goal is to develop & enhance BOBJ Webi reports inaddition to supporting the portfolio ofclient'sapplicationsforSAPFICO,SD,MM,PP&WMSlandscapes.

Sr. SAP BI Analyst/Developer

Confidential - Columbus, OH

Responsibilities:

• BI Responsibilities for reporting using BEx Analyzer, Management reports for making business decisions.
• Expertise using other BEx tools like calculated key figures, Restricted key figures, Filtering of data, Exceptions, Conditions, Structures, Cell definitions and Web reporting.
• Master Data Migration/Conversion; BI/BW Responsibility for Manufacturing, Engineering, Spare Parts and Marketing Business Units; Performed data modeling of InfoObjects using the Administrative Workbench.
• Worked closely with Business Users to gather requirements, perform gap analysis, develop solution approach and create functional specifications.
• ECC 5.0 - Adapting business process & Retrofitting custom modifications to maintain standard functionality.
• Responsible for development of back end extractors, process chains cube, queries, and report design using the SAP Business Intelligence toolset while adhering to standard development methodologies and best practices.