SAP BI/BW Technical Summary:

Over 13 Yrs of Software Experience with 6 Full Life cycle implementations using ASAP methodology, Modeling, Business Content, LO Data Extraction (SAP R/3, Flat Files), Data Loading, Scheduling, Monitoring and Reporting using BEx Analyzer.

Modeling: Process chains, Info Cubes, MultiProviders, ODS Objects, InfoSets, InfoObjects, InfoSources, Data Sources, Update Rules, Transfer Rules, Communication Structure, Transfer Structure, InfoPackages..

Extraction: LO and Flat file data Extraction for Master and Transactional data. Generic Extraction, Activating Data sources, deleting setup tables, filling up of Cluster tables, Setting up of V3 update Customizing and Enhancement of Extract structure / Enhancements for Datasources.

Reporting: BEx-Analyzer, Condition reporting, Exception highlighting, Restricted key figures, Calculated key figures, Variables, Filter, Free Characteristics, Variants, Structures and RRI (Report to Report Interface).

Performance Tuning: Aggregates, Indexes, Compression, Partitioning and Statistics.

SAP WORK EXPERIENCE: (Beginning with most recent project)

Confidential Minneapolis, MN, USA 
Period:January‘08 to date
Role: Sr. BW Consultant 
Environment: BW 7.0/3.5, SD, MM, FI, CO (ECC 6.0)

• Effort Estimation and Project Cost Management.
• Participation in Business blueprint and Requirement Gathering Discussions with End Customer, and transforming to Technical Designs.
• Functional feasibility analysis and translating the Specifications to the team members.
• Responsible for the deliverables for Datasource development, Enhancements, design and development of end to end BI solution, Process chains, Open Hub destination and report development.
• Managing Problem tickets during the support phase after Go-live and ensure Smooth Go-Live and Transition to Sustain
• Managing Project Metrics like Object Development/Delivery, Cost, Utilization
• Team Management in terms of Training/Mentoring and Delivery Management with Status and Escalation Reports, Change Management, and Weekly Conference Calls with End Customer

Confidential Milwaukee, WI, USA 
Period: Nov ’05 to January 2008 
Role: Sr. BW Consultant / Data Architect 
Environment: BW 7.0/3.5, FI-CO (ECC 6.0)

• Started as Consultant and ends up performing the role of a Data Architect and managed Estimation.
• Asa Sr. Business warehouse Consultant core responsibility was Preparation of Data flows, functional feasibility analysis, Post go live support, Preparation of cutover activities, System configuration checks, Quality Assurance to improve performance of the system,
• New solution handovers in Controlling and Profitability analyses (internal accounting, budgeting and management reporting on financial performance), General Ledger, Accounts Receivables, Accounts payables and Project systems.
• Prepare and plan for Post production roles (once the development was completed), Knowledge transfer issues & trainings.
• Preparing System Volume Testing, Regression test cases to check the parameters with production server.
• Development of Process Chains for Automated Scheduling of all Data Loading Jobs
• Customer Interaction, ticket resolution / Issue tracking

Confidential Port Sunlight, U.K. 
Period: Dec ’04 to October ‘05 
Role: Sr. BW Consultant 
Environment: BW 3.0B, SCM, ESAP – SU/MI, CL, FI-CO, APO, R/3 4.6c

• Onsite/ Offshore Coordinator for Global Data Warehouse Team.
• Project for Reconstruction of Delta Queues for LO & Extraction.
• Development of Process Chains for Automated Scheduling for the new projects.
• Performance Tuning Activities in coordination.
• Monitoring and Corrective actions in Business Warehouse
• Responsibility of Promote to Production migrations.
• Ticket Handling / Issue Tracking for Global Support.

Confidential MN, USA 
Period: July ’04 to December ‘04 
Role: SAP BW Media Consultant 
Environment: BIW 3.0b, R/3 4.6c SD, MM, PP.

• Created Master data InfoSources for uploading attributes, texts, and hierarchies from SAP R/3 system
• Involved in escalating prioritized tickets regarding extractions, performance issues and load failures.
• Monitoring of daily loads and analyzing the reasons for frequent load failures
• Maintaining Reconciliation’s to verify the data in SAP R3 with SAP BW
• Maintaining the queue - related to system generated tickets and customer generated tickets.
• Maintaining the Work History for all the tickets until it is closed down.

Confidential, MN, USA 
Period:Nov ’03 to July ‘04 
Role: SAP BW Media Consultant 
Environment: SAP BW 2.1c; IS Media M/AM 4.62; MM, FI/CO, PPI, PAM**

• Worked with Business Content as well as creating Info sources, Info Objects, Info cubes, ODS Objects, Transfer/Update Rules.
• Extensively involved in setting up of procedures for extracting data from SAP IS Media - Extracted Logistic Data like Customer, Sales Order, Delivery and Billing from SAP R/3.
• Setup Flat File extractions for legacy data,Assigning Data Sources to the Info Source, Defining Transfer Structures, and Metadata maintenance for the Info Source and Source System. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the Source System.
• Involved in Creating and Maintaining Info Cubes, Operational Data Store, Data Sources, Transfer Structures, Communication Structures, Transfer Rules and Update Rules, Info Packages.
• Involved with PSA in Monitoring the Data Transfer from Source Systems into BW. For Flat file extraction, did Partitioning of the PSA, setting the frequencies of Info-IDocs, adjusting data packet sizes and number of records to be moved

Non-SAP WORK EXPERIENCE:

Confidential , MN, USA 
Period:Sept ’98 to November ‘03 
Role:Consultant 
Environment: AIX UNIX, Windows OS/2, Oracle, PL/SQL, DB2, Power Builder 4.0/5.0, C, C++, MQ Series

Confidential MN, USA 
Period:Feb ’97 to August ‘98 
Role:Consultant 
Environment: Sybase SQL Server, PowerBuilder, Win-NT

Confidential MN, USA 
Period:Jan ’96 to February ‘97 
Role:Consultant 
Environment: Sybase SQL Server, PowerBuilder, Win-NT

EDUCATION:

• B.S in Computer Science