SUMMARY:

• Over 5 years of IT experience in SAP BW, BO and R/3 implementations, SAP HANA custom development involving all phases of the package development life cycle to meet the business needs.
• Over 5 years of experience in software design, analysis and development in SAP BW/BI.
• Worked on SAP BW / BO production support and implementation as well as migration projects.
• Experienced in - Data Modeling, Report development and Performance tuning.
• Extensively worked on SAP BW Modeling, Remodeling and maintenance of InfoCubes, DSOs (Standard, Write-optimized and Direct Input), InfoObjects, Data Flow 3.x (Transfer rules, Update rules),Data Flow 7.0 (Transformations, DTP), Info packages, Extractors, InfoSources, InfoObjects Catalogs, InfoAreas, DataSources, Data Extraction, Business Content, DataMarts, Process Chains, MultiProviders, InfoSets, Open Hub Destination.
• Worked on SAP BW on HANA (7.4) Info providers such as Composite Providers, Transient Providers, Semantic Partitioned Objects .
• Creating Transformations and DTP. Creating Start routines, end routines, expert routines.
• Building Process chains for Data Load Automation. Process chain maintenance. Worked on resolution of Data load failures and Data load optimization.
• Creation and maintenance of open hub destinations, APDs for file generation and transfer
• Experience in Maintaining LO Cockpit, COPA Extractors, Creation of generic Extractors
• Worked on SAP BW On HANA (7.4) models such as composite providers, Transient Providers, Hybrid Providers, SPO ( Semantic Partitioned objects )
• Extraction: Data extraction from R/3 systems (LO) as well as non R/3 systems such as Flat Files, Enhancements of Data Source through Extract Structures.
• Bex Reporting: Worked in BEx Analyzer and Query Designer with User Exits for Variables, Formulas, Hierarchy, and Calculated and restricted key figures, Structures, Exception aggregation and Conditions.
• Worked on the upgrade of BW 7.0 to BI 7.3 on HANA i.e. HANA Migration Project
• Worked as Business Analyst in the legacy retirement projects.
• Good functional knowledge of SD, Vistex, MM and general business process of SAP R/3 system and ECC.
• Worked extensively on Chargebacks area thus knowing the business process of Chargebacks area.
• Worked on SAP ABAP more specific to SAP BW such as writing start routines, end routines, expert routines.
• Experience with upgrade from BOBJ 3.x to 4.x
• Experience in Creating universe in IDT and UDT on top of both OLAP and RDBMS data sources and as well as multisource universe.
• Well versed in Data modeling and extraction of data through SLT and BODS in SAP HANA.
• Created rich visualizations using SAP Lumira to analyze the commits and forecasts for finance reporting.
• Created Dashboards and Stories using Tableau for Finance and Services analysis.
• Understanding of HANA views
• Created connections to BEx queries using Business Intelligence Consumer Services (BICS) in IDT.
• Created universes on BW infoproviders using IDT.
• Expertise in using Universe Designer over BEx queries and InfoCubes to migrate & model data from BW to BO for reporting. Excellent skills to develop reports using WEBI.
• Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/ BEx Queries. Valuable Knowledge on Xcelsius Dashboard Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.
• Proficient in Business Objects Reporting using Web Intelligence, Crystal Reports, WEBI Rich Client, Live Office and Xcelsius for both SAP and Non SAP sources.
• Strong knowledge In creating connections using Data Connection manager like Live Office, Query As A Web Service (QAAWS), Flash Variables, SAP BI connectors, UD connecters, DB connectors.
• Created complex ad-hoc reports using BusinessObjects and Web Intelligence tools. Synchronized queries from multiple data providers. Used drill-up, drill-down and drill-by features using BusinessObjects reporting tools.
• Proficient in creating Information spaces based on universes and created Exploration views and View sets in BO Explorer.
• Hands on experience in designing custom Queries, Query Views, Web Templates defining Conditions, Exceptions, Variables (User Entry, Replacement Path, User Exit & SAP Exit) Structures, Cell Editor, Calculated Key Figures (CKF), Restricted Key Figures (RKF), RRI (Jump Target),Filters, Free Characteristics and Selections.
• Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer, BEx Web Analyzer and BEx WAD
• Hands on experience in various cross functional modules such as: SD, MM, PP, FI-CO and HR.
• Involved in 3 full life cycle implementations
• Developed Routines (Start, End and Expert) during the creation of Transformations and DTPs using ABAP
• Hands on experience in enhancement of BC extractors for both master data and transaction data sources via User Exits.
• Experienced in Performance Tuning, Aggregates, Rollups, Partition, Compression & ABAP Tweaks.
• Experienced in improvement of data loading performance by PSA partitioning & parallelization of loads
• Hands on experience in the BW Upgrade from 3.5 to BI 7.0 as well as 7.0 to 7.4 BW on HANA.
• Worked on SAP HANA 1.0 for POC this comprised of Data modeling and creation of Joins. Information Modeler. Creation of Analytic, Attribute and calculation views, Schema mappings, Simple Measures, Calculated Measures and Private measures
• Created dashboards using Design Studio, Crystal Xcelsius 2008 and QlikView.
• Excellent grasp of various methodologies like AGILE, SDLC, Waterfall.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, documenting and rolling out the deliverable.
• Self-motivated and good team player with excellent communication skills and interpersonal skills and also capable of working independently even under high-pressure challenges.
• Strong problem solving and logical reasoning skills. Ability to understand new ideas and technical concepts quickly and produce meaningful results

TECHNICAL SKILLS:

BI Reporting tools: BO 4.1 BO 4.0, BO 3.1, WEBI, Lumira (Visual Intelligence), Information Design Tool, Universe Design Tool, Dashboard Design Tool (Xcelsius), Explorer, Business Objects Analysis for Microsoft, Data Federator Admin Tool, Crystal Reports, Tableau Desktop/Server 7.0/8.1/8.3 versions.

ERP Modules: SAP R/3 (4.7) FICO, SD & MM, PS ECC 6.0

Data warehouse: SAP BW 7.4, SAP BI 7.0, SAP BW 3.5

Bex Tools: Query Designer, Bex Analyzer, Web Analyzer, Web Application Designer, Visual Composer.

Database tools: Oracle 9i, 10g, 11g, Microsoft SQL Server

Tools: Microsoft Office, HPQC, Mercury Quality Center.

Operating System: Unix (HP), Linux, AIX, Win2k Servers/NT, XP, Vista, Windows 7

Languages: SQL, ABAP, C, C++, JAVA

PROFESSIONAL EXPERIENCE:

Confidential, Bergen, PA

Sr. SAP BW Consultant

Responsibilities:

• As part of the HANA migration team, converted reports for OTC, PTP, FPM areas.
• BO integration with SAP BW 7.3 to 7.4 on HANA migration.
• Responsible for SAP BW Support activities like process chain monitoring, Performance tuning, Data Load automation .
• Creation of Info Objects, Info object Catalogs, Info cubes, DSO objects, Info Sets, MultiProviders, Application Component, Info Sources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, Info Packages, Info Package Groups, Process Chains, PSA, Transformations, Data Transfer Process (DTP) etc.
• Creation of Batch process and scheduling load jobs in parallel. Process Chain Maintenance.
• Worked on SAP BW on HANA migration for migrating objects from SAP BW 7.0 to 7.4.
• Worked on Legacy Retirement Project which comprised of migrating old reports and Data flow from Legacy systems to SAP
• Extensively worked on Open Hub Destinations, APDs for generation of Legacy files through SAP
• Worked on Minor enhancement projects which focus on Datasource enhancement, Extractor changes
• Worked on End to End Implementation of Chargebacks area which comprised of creation of Datasources, DSOs and Complex Data flow designs.
• Also made use of composite providers to improve performance of existing data flow
• Used Business Content extensively, loaded statistical data using (BC) Technical Content. Extracted data from ECC, classification system, through Web service and Flat File. LO Cockpit Extraction, Generic Extraction, Flat file Extraction for Master data and Transactional data, and Activating Data structure, transporting data sources, customizing and Enhancement of Extract.
• Expertise in Reporting with Business Explorer using BEx Analyzer, BEx Query Designer, Web Application Designer, Condition Reporting, Exception highlighting, developed Queries, queries using Filters, Free Characteristics, Calculated Key figures, and Restricted Key figures, Variables, Structures and RRI (Report to Report Interface).
• Worked on Production Support and managed tickets using ConnectNow.
• Created Self servicing universes which acted like report builders for users to create their own reports.
• Managed Solman to maintain technical and functional design documents.
• Worked with the Business Transformation team to track the progress of ongoing projects.
• Charm Management - Extensive use of Charm to migrate objects from one environment to next environment .
• Onsite - Offshore Co-ordination - SPOC for Functional areas like Chargeback and SD and managed offshore teams by conducting daily status call
• Requirement Gathering from Client and passing the information to Offshore team
• Creation of Technical Design Documents as well as DFDs.

Environment: Netweaver 2004S, SAP BW 7.3, ECC 6.0, HANA Studio, Microsoft SQL Server, Business Areas: OM, SD, SCM, BEx, BO 4.0, BO 4.1, WEBI, IDT, BO Explorer Confidential Consultancy Services

Confidential

SAP BW / BO Consultant

Responsibilities:

• Interacted with the business to gather requirements for profit and loss reporting for Finance division
• Created Webi reports, Document Linking and Dashboards for COPA reporting on Commits, Forecast and Actuals for Products and Product Lines while integrating business Units
• Led the team in upgrade testing of the BOBJ environment from for service pack upgrades and system upgrade from 4.0 to 4.1
• Created HANA views for the material master tables for master data reporting.
• Created multiple publications for Engineering reports to meet user requirements, where the reports were pushed to vendor inbox.
• Architectured the Development of 27 reports and 2 dashboards for Project Systems reporting under aggressive timelines with Unit Testing/ UAT and Production migration
• Developed Dashboards using live connections and BIWS for Operations analysis
• Acted as SME for Installation & Warranty reporting under Project Systems
• Created queries to determine spend by excluding partial months in the system’s life cycle for Operations Reporting
• Created visualizations for finance team for commit and forecast analysis using SAP Lumira.
• Developed audit reports to monitor the usage of over 700 webi reports and 80 dashboards over the NorthAmerica, Europe and APAC.
• Created Bex Reports as per business needs to build Webi Reports using BICS connections
• Developed Restricted and calculated key figures to be used with flexibility for various reports across a single query
• Created Analysis for Office workbooks on Bex Queries for Services Reporting
• Implemented insightful reporting in Webi where the user is able to Identify the selection parameters in the report
• Extensively worked with Business and functional team to implement reporting for Financial Supply Chain Management (FSCM) and Bill to Cash (BTC).
• Extensively used HPQC for Quality Assurance and Control in the development to go-live cycle, while monitering the integration of newly acquired Business Units.
• Implemented Conditional Formatting in Webi reports for Service Delivery team to easily identify the performance and life-cycle of the Opportunities.
• Created Functional and Technical Specification documents for Reporting in COPA, Project Systems, and Operations
• Worked as Production Support Lead for BOBJ and managed BW support team as well

Environment: Netweaver 2004S, SAP BW 7.3, ECC 6.0, Oracle 11g, Microsoft SQL Server, Business Areas: MM (Purchasing), SD, BEx, BO 4.0, BO 4.1, WEBI, IDT, Dashboard Design Tool, BO Explorer, AAOE

Confidential

SAP BW / BO Consultant

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements. Document reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects in IDT
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Created user Prompts, List of Values (LOVs) and Restrictions for reporting parameter specification as per user requirement
• Established connectivity to SAP BW system through BICS to directly access BEx queries.
• Modified BEx queries in to generate WEBI reports in BO 4.0 to meet user requirements.
• Created Multi-Source universe using relational connection based on SAP BW, MS Access and Flat files.
• Created and configures Information Spaces for time-based data based on Universes using BO Explorer.
• Scheduled indexing for these Information Spaces.
• Created Inventory Accuracy Dashboards and for Management Reports for Inventory Management, and Wages and Cost report from Cost Center Accounting data.
• Worked on Dashboard Design Tool development using web service on top of SAP BW
• Created queries to determine No. of PO items for a particular Material Group and Type and quantity of material ordered by a vendor and other custom queries meeting end user requirements.
• Developed flexible queries with variables using filters, Navigational attributes and Reusable structures.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Used Cell-Definitions, Structures, Exceptions, Conditions, and various User Exits in the Reports.
• Designed global structures to in corporate query requirements.
• Extracted data from MM modules and uploaded purchasing DSO objects 0PUR O01, 0PUR O02, 0PUR DS03 via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL
• Successfully loaded data into Purchasing item service level cube 0PUR C08 and Purchasing data cube 0PUR C01
• Created and maintained multiple InfoCubes for the SD module.
• Updated data into these InfoCubes via DataSources 2LIS 11 VAITM, 2LIS 11 VAHDR, 2LIS 13 VDHDR, 2LIS 13 VDITM.
• Created InfoPackages for Full, Initial, and Delta extraction for both Master data and Transaction data with dynamic selection criteria where needed.
• Created Process Chains to automate the data load and data target administration and monitored the processes.
• Scheduled process chains for performance tuning jobs like creating Aggregates, Rollups, Indices and compression techniques.

Environment: Netweaver 2004S, SAP BW 7.3, ECC 6.0 Business Areas: MM (Purchasing), SD, BEx, BO 4.0, WEBI, IDT, Dashboard Design Tool, BO Explorer

Confidential

SAP BW Developer

Responsibilities:

• Created Universes over BEx queries and MultiProvider of SAP BW using Universe Designer.
• Created Detailed, summarized and Aggregated tables to improve query performance.
• Created Multi Tab Ad-Hoc report according to user requirements.
• Experienced in working with different templates like horizontal table, vertical tables, Cross tab tables and charts.
• Proficient in using Break points, Functions, Slice and Dice, Variables, Filters, Calculations and Alerts for creating complex reports in WEBI
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as source.
• Extensively worked on creating Prompts at universe level and Webi query level.
• Worked on creating Query filters, quick filters and Input controls in Webi reports.
• Experienced in working with grouping, ranking, report variables and different functions in WEBI.
• Worked on performance tuning of Webi report and BW backend design.
• Developed custom queries and used standard queries for Inventory Management, Procurement, and Order Fulfillments.
• Created reports to monitor Material Movements, Dead Stock, and Stock over Flow slow moving items and stock quantity
• Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Analyzed and Designed queries for open order values to incoming order values and credit memos to billing document.
• Involved in extracting SD and FI data from SAP ECC to SAP BW.
• Performed LO-Cockpit extraction to extract the Header and Line item data from the Sales and Distribution.
• Enhanced InfoProviders, MultiProviders and Transformations.
• Created queries for Top Customer, proportions of credit memos to billing documents, Quotation success rates among others
• Created and maintained multiple InfoCubes for the FI module.
• Analyzed Business needs for procure to pay (PTP), Order to cash (OTC) work streams and created business events to meet solutions.
• Created Non-Cumulative key figures, InfoObjects, DSO, InfoCubes and MultiCubes.
• Used DSO to stage the data before transferring the DSO contents to the InfoCube. Done DSO reporting to give details of delivery items and schedule line items.
• Created a start routine to restrict material movement data while loading Inventory Management InfoCube .

Environment: SAP BI 7.0, BO XI R 3.1, ECC 6.0, ABAP/4, Oracle and Windows XP, Business areas: FI, SD, MM