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 SKILLS

SAP BW / BO: SAP BI7.4, 7.0, BW 3.5, 3.1, 3.0, 2.x, BO XI 3.1, BPC 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

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.

Confidential, Atlanta, Georgia

Manager/Sr. Application Consultant

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 Express using BEx to move the objects across development, assembly, and quality systems.

Confidential, Atlanta, Georgia

Manager/Sr. Application Consultant

Responsibilities:

• Managed upgrade of BW 7.0 to BW 7.4, BPC 7.5 to BPC 10.0 and migration project of FDW-BPC (BW 7.0/7.4 BPC 10.0) to HANA. Conducted analysis, design, development, and testing of the solution to migrate existing FDW (PB1), BPC (PF1) to a combined system FDW-BPC 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, DSO, 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-BPC environments.
• Worked on several BPC functions including dimensions, applications, transformations, conversions, loading, clearing, compressing, and optimizing data in BW and BPC 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.

Confidential

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, DSO, 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(DSO) 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

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, DSO, 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

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, DSO, 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 DBCONNECT 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.

Confidential

SAP BW Consultant

Responsibilities:

• Analyzed and mapped business processes to BI for custom reporting needs for drug distribution data, call activity of representatives, and sales analysis data. Testing & Documentation - Generated as per CSV requirement.
• 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; conducted developing, quality testing, and post production support.
• Worked on business content and custom objects including info cubes, DSO, multi providers, info objects, Sources, and packages, transformations, DTP, and process chains.
• Populated info cubes and verified data consistency was verified. Troubleshot various issues in loading cubes with data.
• Worked in Bex Analyzer, Query Designer to create customized queries and workbooks; APD to create a flat file from query output with some business rules; and ABAP based transformations to enhance code for changed business rules.

Confidential

SAP BI Consultant

Responsibilities:

• Analyzed and mapped business processes to BI for AR/AP/GL reporting needs for Russian Operations.
• Interacted with team members and business users at various stages of development.
• Involved in study of BRD, ADD generation, development, quality testing, and post-production support. Represented the development team in testing phase as Team Lead.
• Worked on Product Costing - plan/actual data - loaded 0PC C01 cube using D.S. 0CO PC 01; business content data sources and custom data sources 0FI AR 4, 0FI AP 4 and 0FI GL 4; and custom and business content objects including info cubes, DSO, multi providers, info objects, sources, and packages, transformations, DTP, process chains.
• Populated info cubes and verified data consistency. Troubleshot various issues in loading the cubes with initial data.
• Created customized queries and workbooks in Bex Analyzer, Query Designer, Web Application Designer, NW 2004s.
• Worked on Query Design including restricted and calculated key figures, conditions, exceptions, and variables.
• Generated reports for AR payment reason code analysis, AR/AP aging analysis for trade and Internal customers, AR Collection Performance Metrics, Query MS (Listing of docs with Header Text), and Query 51 (Listing at item level).
• Experience in Backend modeling / production support.