Profile

• Over 15 years of IT result oriented experience in financial, oil gas, telecommunications, human resources & manufacturing industries in IT environment including over 5 years in SAP/ BW BI and 2 years in Business Objects Enterprise XI 3.1 environment.
• Experienced SAP/BW 3.5 BI 7.0 BOBJ XI 3.1 & IBM Mainframe developer/architect with expertise in business warehouse data modeling, support development, administration, internal & external communications, user training & support. .
• Experience in BW/BI Data Modeling, ETL, BEX Reporting, Data Extraction, and Testing and knowledge on standard data sources & objects from ( HR, SD, FI) modules.
• Involved in QA activities such as code review, technical specification reviews and have experience in support as well as development activities.
• Worked in both front & back end BW / BI modeling, ETL & R3 / ECC .
• Worked on development & support of 1 full cycle (go live) large scale projects with large datasets in order to gather the requirements to develop a data model worked with the business analyst & users to analyze, define functionality & develop business warehouse back & front end systems.
• Using Designer from SAP & non SAP data sources created universes. Resolved loop using context & aliases, SQL traps, created classes and objects by retrieving the data from various data sources and crated the necessary CMS server connections. From backend cubes & multiproviders data developed Bex queries & on top of that using these queries developed universes & subsequently developed Webi & Crystal reports.
• Proficient in developing Web Intelligence (WebI), Desktop Intelligence (DeskI), & Crystal Reports, and exposure in developing Xcelsius Dashboards.
• Worked on developing Xcelsius dashboards against the data from MS Excel sheet & SAP data (BI) based on the BI query with BO-Xcelsius using the SAP Net Weaver BIConnection connectivitypresent within Xcelsius.
• Created universes, classes and objects by retrieving the data from various data sources and defining the necessary connections.
• Back end environment developed generic & custom extractors from R/3 & ECC6.
• Front end BEX environment developed queries, business reports & analytical processes.
• Exposure to DataStage ETL tool.

• SAP-BW 3.0 B, 3.5, SAP-BI 7.0, SAP R/3 4.6x , ECC6, Net Weaver 2004 Portel,

BOBJ XI 3.1, SOLMAN .

• Cross Ffunctional Applications: SD, SCM,HCM(PA,OM), FI
• Reporting tools : SAP- Bex Query Designer, BEx Analyzer, BEx Web( Web Analyzer, Web Application Designer(WAD), Report Designer, Visual Composer.

, SAP-BOBJ 3.1 (Designer, WebI, Live Office, Java InfoView, Crystal Reports,QWAAS, & Xcelsius), Hana training.

• Languages : ABAP/4
• RDBMS : DB2, IMS, MS Access
• Operating Systems : MS-DOS, WINDOWS (98, NT ,XP ,Vista.)
• Other Applications: Ms-Excel, PowerPoint, Word, MDM, VPN, Secude, Remedy, Net Meeting, Telnet, Lotus Notes, Visio, Communicator, IPRO, AutoSys, IPRO, SharePoint, MS Lync.
• IBM Mainframe Software: COBOLII, VSAM, DB2, CICS, IMS, MVS/TSO, ISPF, MVS/JCL

Experience/Project Work

Industry: Confidential,Folsom, CA
Project Description/Scope: Nov 2011- Nov 2012
Role: SAP BW/BI BOBJ Consultant Duration: 12 Months
Responsibilities/Deliverables

• As a consultant/developer working on providing end user day to day support by resolving production system issues of the SCM Demand Planning & MM applications.
• Worked on the extraction & reporting of data from DP & SNP planning areas of APO. Generated the data source for Planning Area. Created transformations and DTP process to transfer data from source to destination. Monitored that info cube created has all the info objects that are used in POS of APO. Conducted data transfer from internal BI/BW of APO to external source. Loaded the data from ECC6 to APO-BW cube using generic & standard extractors. In case of load failures monitored data load via process chains & fix extractor errors by running consistency checks on the planning areas & versions. Worked on developing BEX reports.
• Worked daily with Extractors, Generic Extractors, Data sources, Info sources, Transfer Rules, Update Rules, Info packages, Info package groups, Info objects, ODS, Info cubes, BEX Queries, Variables, Calculated key figures, Infoset Queries, Workbooks, Analyzer, Browser, Process chains Autosys, IPRO etc.
• Working on developing ABAP field, start & end routines.
• Worked on developing & supporting the front end BEX queries to build BOBJ XI 3.1 Universe & Webi reports.
• Conducting analysis to recommend SAP best practices & improving system performance.
• Working on upgrading the SAP BW 3.5 ETL processes to SAP BI 7.0 environment.
• Using AutoSys for job submissions, monitoring & IPRO to support production tickets & SharePoint to document system scripts.

Industry: Confidential,San Francisco, CA.
Project Description/Scope: April 2011- Oct 2011
Role: SAP BW/BI BOBJ Consultant Duration: 5 Months
Responsibilities/Deliverables:

• Worked on Global Demand & Supply Planning, Requisition to Check, Order to Cash & Master Data(MDM-Demand Planning, MDM-Sales & Distribution) . Developed staging write-optimized & standard DSO for demand history & forecast to APO, region monthly shipments, future & cancel orders. Also developed extractors & DSO for monthly inventory. Developing analysis & design documents using Microsoft Visio.
• Worked on developing OLAP universe & specification, design & development of WebI reports.

Employer: Confidential,Minneapolis, MN
Industry: Medical Instruments
Project Description/Scope: Aug 2010- Feb 2011
Role: SAP BW/BI BOBJ Consultant Duration: 6 Months
Responsibilities/Deliverables:

• Worked on the analysis & enhancement of the bank end COPA sales data DSO, Cubes & Multi Providers & front end development of business explorer(BEX) queries used to developed the business objects (BOBJ XI 3.1) Universe & Web UI reports for the NMD system.
• Worked on developing Xcelsius dashboards against the data from MS Excel sheet & SAP data (BI) based on the BI query with BO-Xcelsius using the SAP Net Weaver BIConnection connectivitypresent within Xcelsius.Worked with IBM Data Stage (ETL tool) to extract the data from non SAP data source & run it thru validation process to be finally loaded in SAP/BW DSO or Cubesvia Info Source.
• Worked on developing analysis & design documents using Microsoft Visio.
• Working on specification, design & development of WebI reports.

Employer: Confidential,Denver CO
Industry: Confidential,
Project Description/Scope: SAP BI Support Logistics System Aug 2009 – Jun 2010
Role: SAP BW BI BOBJ Consultant Duration: 11 Months
Responsibilities/Deliverables:

• Created Process chains for Master data and Transaction data loads to automate the data loading in the organization and these process chains were scheduled for periodic loads.
• Configured and extracted Inventory management data from LO Cockpit extractors by making use of the SAP defined data sources.
• In the BOBJ XI 3.0 environment developed Universe from SAP(BEX Query) & non SAP datasource (Access, Oracle database) & developed WEBI reports & Crystal Xcelsius dashboard.
• Development of Transformations, DTP, Data Sources (flat file source system), Update Rules and Transfer rules for BI data flow and 3.x data flow.
• Creation and maintenance of BI objects (Info Cubes, DSO objects, Infoset, Multi Providers).
• Scheduling and periodic monitoring of extractions through Info Packages and Process Chains
• Involved in documentation for the mapping, technical specifications, data validations and Test cases
• Worked on translating the legacy systems reporting into developing SAP front end BEX queries.
• As a team member worked on developing the functional & technical specifications of the new reporting system developed in BEX.
• Worked on daily basis with Extractors, Generic Extractors, Data sources, Info sources, Transfer Rules, Update Rules, Info packages, Info package groups, Info objects, ODS, Info cubes,
• Supported the production system trouble tickets.

Employer: - Confidential,Toronto, Canada Feb 2008 – Jul 2009
Industry: Confidential, Duration: 16 Months
Project Description/Scope: Support & Upgrade of SAP BW BI Telecom system
Role: SAP BW BI Consultant
Responsibilities/Deliverables:

• Supported the production logistics (SD) & financial (FI) system’s remedy tickets.
• Worked on BI upgrade project from BW to BI (version 3.5 to 7.0).
• As a team member worked on providing end user day to day support by resolving production

System issues by extracting data from HR (PA & OM) modules in SAP R/3 & ECC, subsequently loading data into BW & BI.

• Worked on daily basis with Extractors, Generic Extractors, Data sources, Info sources, Transfer
• Rules, Update Rules, Info packages, Info package groups, Info objects, ODS, Info cubes, BEX Queries, Variables, Calculated key figures, Infoset Queries, Workbooks, Analyzer, Browser, Process chains etc.
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
• Extended the extract structures by adding new fields and populating them with the user/function exits.
• Worked on developing the planning components (Area, Level, Package, Layout, Function, Parameter Groups, Folders etc.) of the BPS-SEM system. Help resolve user’s day to day issues.
• Via Net Meeting conducting meeting with users & fellow team members.
• Used Lotus notes for email communication.
• Used Yahoo messenger to communicate with users & other team members on hourly basis.
• Throughout the length of assignment worked closely with the end customer.

Employer: Confidential,Saudi Arabia
Industry: Oil & Gas Industry,
Project Description/Scope: Conversion of M/F Legacy Payroll System Jun 2004 – Dec 2007
Role: SAP BW Architect Duration: 42 Months
Responsibilities/Deliverables:

• As a U.S. expatriate worked overseas on projects to convertmainframe legacy Payroll system to HCM (PA & OM), CRM & Logistics (SD) systems of the petroleum company to SAP/BW BI system. The objective of the project was to decommission the mainframe and make use SAP BW functionality. As a leadingsystems analyst was to analyze the legacy systems, gather user requirements and develop a SAP/BW data model. My area of responsibility was primarily for systems conversion from legacy to SAP/BW platform and it covered data modeling, extraction of data from SAP R/3, datatransformation data loading & performance tuning. Assuch I was a member of the team responsible for designingback end ( Info Objects, Info Cubes, ODS, queries,info sources, data source, info package, process chain , data extraction/loadingand performance tuning and query optimization etc.) , \'Go Live\' & post production support. ThroughoutIworked closely with the end customer developingBEX & crystal reports to improve the look & feel of thereports to meet their requirements.
• Worked on the full lifecycle implementation of payroll & medical systems.
• Involved in Data-modeling, Data Extraction, Generic Extraction, Data Loading, Scheduling, Monitoring and Reporting.
• On top of BEX query worked on developing Crystal Reports.

Employer: Confidential,Dhahran, Saudi Arabia
Industry: Oil & Gas Industry
Project Description/Scope: Payroll, Medical Pharmacy System Sept 1993 – Jun 2004
Role: IBM Mainframe EDP Systems Analyst Duration: 129 Months
Responsibilities/Deliverables:

• As a U.S. expatriate worked overseas on the support, coding, testing in development environment, production support, requirement study, documentation of the IBM mainframe Payroll & Medical (Patient Care) & Pharmacy (Pharmakon In-Patient/Out-Patient by Mediware) systems.

Education & Certification:

• M.S. Degree, Computer Science