SUMMARY:

• More than 20 years of experience in software design, development, and testing.
• Extensive experience using Data Warehousing Workbench/Administrator Workbench, Business Explorer (BEx) and Data Modeling using SAP extended star schema.
• Expertise implementing BW/BI/HANA/BOBJ, including gap analysis, requirements gathering, data extraction, modeling, and loading (Full /Delta Up - Load), ETL, and scheduling.
• Skilled with designing and implementing BEx queries using calculated key figures, restricted key figures, filters, variables, structures, conditions, exceptions, RRI (Jump Queries), and workbooks.
• Skilled with designing HANA views and report with BOBJ Webi. Expert in onshore/offshore models to manage teams.

TECHNICAL EXPERTISE:

SAP BW / BO: SAP BI7.4, 7.0, BW 3.5, 3.1, 3.0, 2.x, BO XI 3.1, Confidential 7.5, 10, HANA 1.0

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

Tools: BEx Analyzer, Query Designer, Web Application Designer, Universe Designer, Webi, Deski, HANA Studio, Eclipse

Databases: Oracle 10g/9i/8i, MS SQL server 2005/2000, MS Access, DB2

Languages: ABAP/4, VB, Java, JavaScript, COBOL.

Operating Systems: Windows XP/2000/NT, Unix

Software: Microsoft Office Word, Excel, and PowerPoint

PROFESSIONAL EXPERIENCE:

Confidential

Manager/Sr. Application Consultant (SAP BI/HANA/BOBJ)

Responsibilities:

• Work on a reporting solution for ease operating Statement (LOS), AFE vs. Field Estimate v Actual Report. Coordinate work with business users, onshore team, and offshore team.
• Conduct requirement collection, report analysis and testing, walk-through with SIT and UAT users, and user training.
• Development (back end and front end using HANA Views (Standard and Custom) and Webi and Analysis for Office.
• Compose functional and technical documentation.

Manager/Sr. Application Consultant (SAP BW)

Confidential, Atlanta, Georgia

Responsibilities:

• Worked on a reporting solution for Finance, Manufacturing, and other streams.
• Coordinated work with business users, onshore team, and offshore team.
• Worked on ALM for defect resolution of technical and data issues.
• Conducted requirement collection, report analysis and testing, walk-through with SIT and UAT users, and user training.
• Developed back end and front-end Transport Confidential using BEx to move the objects across development, assembly, and quality systems.

Manager/Sr. Application Consultant (SAP BW BCP, HANA)

Confidential, Atlanta, Georgia

Responsibilities:

• Managed upgrade of BW 7.0 to BW 7.4, Confidential 7.5 to Confidential 10.0 and migration project of Confidential - Confidential (BW 7.0/7.4 Confidential 10.0) to HANA.
• Conducted analysis, design, development, and testing of the solution to migrate existing Confidential (PB1), Confidential (PF1) to a combined system Confidential - Confidential on HANA (PHF).
• Led team of onshore, offshore, and sub-contractors for development, testing, go-live, bulk initial loads, KT to support, execution of production cycles (shadowing and reverse shadowing) phases and the successful delivery of the project.
• Developed strategy for testing by identifying the key flows of the existing system and understanding the critical integration points for both the systems for level of testing required. Identified the level of testing required at each cycle for proper integration of the systems being migrated.
• Collaborated with team members, business analysts, and users at various stages of development, testing, and go-live. Involved in modeling, queries, and quality issues.
• Conducted study of requirements, generation of technical design document, development, and quality testing.
• Worked on business content and custom objects including data sources, info cubes, Confidential, multi providers, info objects, sources, and packages, transformations, DTP, and process chains.
• Resolved several issues with data loading (bulk history data) between Legacy-BW-DS- Confidential environments.
• Worked on several Confidential functions including dimensions, applications, transformations, conversions, loading, clearing, compressing, and optimizing data in BW and Confidential objects. Processed and maintained master data and admin activities.
• Established validation document for the procedure to validate the data between various transformations and conversions. Created automatic recon at various stages of the data loads to completely automate the jobs where bulk loads were happening with or without conversions and exclusions in data.
• Trained users and support groups to handle the system. Documented cookbooks, run books, and KT documents.
• Created load sequences by week and by functionality. Automated jobs using Tivoli scheduler.

SAP BW Consultant

Responsibilities:

• Analyzed and mapped business processes to BW for custom reporting needs. Extracted data into BW, developed reports, and conducted end user training.
• Interacted with team members and business users at various stages of development.
• Conducted modeling, queries, and quality issues; requirements studies, technical design document generation; and quality testing. Created and executed test scripts for FI track.
• Worked on business content and custom objects including data sources, info cubes, Confidential, multi providers, info objects, info sources, info packages, transformations, DTP, and process chains; cubes GL, AR, AP, CCA, PCA and custom cubes in GPD; CRM data sources 0BPARTNER TEXT & ATTR and transaction data source 0CRM SALES ORDER I flow into 0CRMSALO( Confidential ) and 0CSAL CO3 (cube). Built a multi provider on 0CSAL CO3 and 0SD C03 for reporting.
• Worked on ABAP based transformations to enhance the code for changed business rules.
• Created customized queries and workbooks using Bex Analyzer and Query Designer.
• Developed reports in BOBJ (Webi) using the queries generated in BEx. Worked on security design for universe and Webi reports. Data security was controlled at application, connection, universe, and report level.
• Conducted training sessions to users for using the queries and creating ad hoc queries.

Confidential, New york, New york

SAP BW Consultant

Responsibilities:

• Analyzed and Mapped Business Processes to BW for custom reporting needs. Extracted data into BW, developed reports, and conducted end user training.
• Interacted with team members and business users at various stages of development.
• Conducted modeling, queries, and quality issues; requirements studies, technical design document generation; and quality testing. Conducted training sessions to users for using the queries and creating ad hoc queries.
• Worked on business content and custom objects including info cubes, Confidential, multi providers, info objects, sources, and packages, transformations, DTP, and process chains.
• Converted business rules as formulae, calculated key figures, and restricted key figures in multi providers to use globally in other queries.
• Worked in Bex Analyzer and Query Designer to create customized queries & workbooks.
• Created business overview reports with various metrics of retail sales, inventory, gross margin, comparisons, and variations of different time periods. Worked on reports in BOBJ (Webi) using queries generated in BEx. Built dashboards in Xcelcius using various BEx queries.

Confidential, Boise, Idaho

SAP BW Consultant

Responsibilities:

• Analyzed and mapped business processes to BW for custom fixed asset reporting needs. Extracted data from Crystal Reports into BW, developed reports, and conducted end user training.
• Interacted with team members and business users at various stages of development. Led the offshore team with development modeling, queries, and quality issues.
• Studied requirements and generated design document; led developing, quality testing, and post production support.
• Worked on business content and custom objects including info cubes, Confidential, multi providers, info objects, Sources, and packages, transformations, DTP, and process chains.
• Created custom data sources, enhanced business content data sources for FI-AA for master data and transaction data.
• Worked on Confidential to extract data from legacy systems maintained in Oracle database; ABAP based transformations to enhance the code for changed business rules; and Bex Analyzer and Query Designer to create customized queries and workbooks.
• Developed Crystal reports using data from different SAP modules including asset accounting, general ledger, purchase docs, and legacy system using Oracle database (warehouse data where assets are in retirement stage while not in use).
• Developed custom reports using data from cubes of BW for various asset accounting needs. Reports included summary of assets, valuation, depreciation values, and comparison of SAP and non-SAP systems information using prompts for various selections and formula for calculations.