SUMMARY
Over 12 years of experience in delivering high value to clients through consulting engagements in multiple project domains including SAP implementations, Mainframe Technology, Informatica ETL and business process re-engineering. Experience in various industries (e.g. Financial, Insurance, E-commerce, Pharmaceuticals, Chemical, Medical, Engineering and Electronics). Fulfilled several roles as a SAP functional analyst, SAP BI/BW consultant, and Project Management utilizing SAP Methodology

• 7 years of back-end and front-end Techno-functional, Experience in BW architect as well as SAP BI (Business Intelligence)/BW (Business Information Warehouse)/ABAP. Implemented SAP BI/BW through 2 full lifecycles in multi-industry global deployments of SAP BW version 3.x. and BI 7.0
• Involved in 2 full life-cycle implementations; with focus on BW Analysis, Architecture, Design specifications (GAP analysis) (KPI analysis), configuration, modeling, testing and documentation. Performance Tuning, Go-live and support activities
• Hands-on expertise in all stages of SAP BI/BW rollouts i.e. Data Extraction, Staging and Storage, Transformation and Presentation. Experienced in Data Extraction from SAP ECC (CO/PA, FI, SD, HR , MM,IP-Vistex , IP, BPS( SEM modules )) , flat files using different extraction structures.
• Extensively involved in reporting and developed web reports using Web Application Designer (WAD), Web Application server, SAP Query Designer, Analyzer (BEx), Report Designer, Visual Composer.
• Experience in OLAP processing, Data Modeling, Business Analysis, System Analysis, System Design, Development, process modeling, process flow, quality assurance testing and implementation of projects.
• Good understanding of Project Management and System Development Life Cycle.
• Team player and a self-starter with excellent communication, coordination, documentation, project planning and interpersonal skills. Experience in leading and co-ordination onsite and offshore team
• Experience in SAP BW Functional/Technical upgrade project (BI 7.0 from BW 3.5).
• Knowledge of Business Objects( BO) XI 3.1 , Crystal Reports, XCelsius and Web Intelligence. also with (SAP BO) XI 3.1 tools Universe, Universe, WebI, DeskI, Voyager, Dashboard and Analytics, Xcelsius, Crystal reports, Live Office, Qaaws ( Query as web service) and Data Integration kit for SAP BI and BO.
• Knowledge of SAP FICO configuration that includes FI-General Ledger, FI-Accounts Payable, FI-Accounts Receivable also Pursuing PMP certification
• Development of mapping structures for ETL (extract, transform, load) processing XML, oracle, db2, COBOL files using Informatica Power Center. Involved in extracting data into SAPBW using Informatica ETL tool

TECHNICAL SUMMARY

Data Warehouse

SAP NetWeaver BI 7.0 ,BW 3.5 , 3.5, 3.1C

ERP

Netweaver 2004s ,SAP R/3 6.0, 4.7, 4.6C, , PeopleSoft 3.5

Reporting Tools

Business Explorer, WAD & Report Designer, Business Objects( BO) XI 3.1

ETL TOOLS

SAP BW/BI 7.0/3.x , Informatica 8.x/7.x , Mercator 6.7,

Languages

COBOL II, JCL, CICS, PL/SQL, ABAP/4

Databases

DB2, IMS, Oracle, MS-SQL, Adabas

Platforms

Windows NT4.0/2000/XP, UNIX, IBM MAINFRAME

Microsoft Suites

MS Project, MS Office 2000/XP, PowerPoint, MS Word, MS

Confidential,Boston, MA Sept. 07– June 09

Clients: Amsted Rails, Kansas City, KS June 08 to June 09
SAP BI (BW/BI)Architect
Environment:
SAP NetWeaver BI 7.0 ,SAP R/3 6.0, SAP FICO,SAP BW/BI 7.0 , BEx Analyzer/Browser, WAD and Report Designer , ABAP/4, Workbench, SD, MM, FI/CO-PA, Oracle, Windows 2000/NT.INFORMATICA 8.6
As a BW Consultant my responsibilities including design, development and supporting SAP BI in the areas of SD, MM and FI/CO.

• Responsible for extracting FIGL, FIAR , FIAP, SD,MM into BW
• Responsible for enhancing and customizing extractor for FI-AR and AP Datasources, LIS (BX and BF) and enhanced several fields according to Users requirements.
• Expertise in Reports using query Designer, BEx Analyzer, BEx Reporting Tools, WAD (Web Application Design), Broad casting and Report Designer .
• Configured and Customized delta built up for the Data Sources, LO-Cockpit Configuration and Customization. Customized Business Content and configured Generic Extractors.
• Involved in customizing the Heavily Involved in Data warehouse design reviews for other modules and suggested effective ideas.
• Expertise in Configuring and creation of BW components Info Cubes, Multi-Cubes, Info Sets, Info Objects, ODS objects (Data store objects), Update rules and Transfer rules.
• Worked on DTP, Error DTP, Standard DSO, Bex Queries, Migrated DataSources, Transformations, Variables, Calculated Key Figures, Write Optimized DSO, Reference IO and Debugging tool in DTP.
• Created Communication structure for Info Cubes, AP,AR, Inventory Management .
• Created the Process Chains for the Custom cubes, for loading master data and Transactional data which is used for the daily loads.
• Analyzed OLAP performance using BW statistics. Improving query and load performance using Aggregates, Partitions, Indices and Data Compression.
• Developed UAT plans and test case scenarios to guide the focus group of key end-users in testing the user interface.
• Ensured that all end users and stakeholders reviewed the prototype solutions and provided feedback and these changes were incorporated into the final design.
• Managed all business, technical, and communication issues between the configuration and the business team
• Involved with extracting data into SAPBW using Informatica ETL tool
• Provided Production support and daily monitoring jobs in a production Environment

Confidential,Philadelphia, PA Sept. 07– June 08
(Medical retail company)
SAP BI (BW/BI) Lead Consultant
Environment:
Net weaver 2004s ,SAP R/3 6.0, SAP BW/BI 7.0, BEx Analyzer/Browser, WAD and Report Designer , ABAP/4, Workbench, SD, MM, Oracle, Windows 2000/NT.
As a lead BW Consultant my responsibilities including design, development and supporting SAP BI in the areas of SD and MM modules.

• Responsible for development and configuration of BW, BEx reporting utilities and ETL of production delta updates to ODS, Info Cubes and hierarchy structures.
• Expertise in creating Reports using query Designer, BEx Analyzer, BEx Reporting Tools, WAD (Web Application Design), Dashboard ,Broad casting and Report Designer .
• Converted Crystal reports into BW web report using WAD and Report designer
• Experience in extracting SD, Vistex-IP into BW.Proficient in extracting data from LO-Cockpit, SD,MM and Flat Files.
• Configured and Customized delta built up for the Data Sources, LO-Cockpit Configuration and Customization. Customized Business Content and configured Generic Extractors.
• Expertise in Configuring and creation of BW components Info Cubes, Multi-Cubes, Info Sets, Info Sources, Info Objects, ODS objects (Data store objects), Update rules and Transfer rules.
• Analyzed OLAP performance using BW statistics. Improving query and load performance using Aggregates, Partitions, Indices and Data Compression.
• Created Info Sources, Info Cubes , ODS for incoming sales orders according to sales organization, distribution channels, ship-to-party customers and material.
• working with Integrated Planning(IP) and Business Planning and Simulation module(BPS) including Balance Income Statement Planning (Sales, Discounts, Prices, Overheads, Expenses and Taxes)
• Developed UAT plans and test case scenarios to guide the focus group of key end-users in testing the user interface.
• Ensured that all end users and stakeholders reviewed the prototype solutions and provided feedback and these changes were incorporated into the final design.
• Managed all business, technical, and communication issues between the configuration and the business team
• Provided Production support and daily monitoring jobs in a production Environment

Confidential

NJ
Mar 05 – Aug 07

Environment:
Net weaver 2004s ,SAP R/3 4.6C,6.0, SAP BW/BI 7.0 /3.5, BEx Analyzer/Browser, ABAP/4, Workbench, SD, MM, FI/CO, Oracle, Windows 2000/NT. Informatica 7.1

• Involved in complete life cycle implementation of BW 3.5, which includes Data-modeling, data extraction, generic extraction, data loading, scheduling, monitoring and Report Designer.
• Responsible for extracting FIGL, FIAR, FIAP,COPA ,HR , SD data into BW.
• Responsible for overseeing upgrades from BW 3.5 to BI 7 and converted all 3.5 functionality into 7.0.
• Responsible for creating logical systems for R/3 client and BW client, installing business content objects to load R/3 data. Setting up BW Authorizations and Security in BW Systems
• Developed the Data Sources for the CO-PA on basis of operating concern (Account based or Cost based) and developed ODS objects for the Data sources.
• Worked extensively in Enterprise Reporting, Query and Analysis BEx Design Tools , BEx Reporting Tools and Information Broadcasting.
• Worked extensively in modeling the Enterprise Data Warehouse.
• Expertise in configuring and creation of BW components Info Cubes, Multi-Cubes, Info Sets, Info Sources, Info Objects, ODS objects (Data store objects), Update rules and Transfer rules.
• Analyzed OLAP performance using BW statistics. Improving query and load performance using Aggregates, Partitions, Indices and Data Compression
• Used Informatica to create custom level Mapping and analyzed mapping.
• Development of mapping structures for ETL (extract, transform, load ) processes using Informatica Power Center and loaded data into SAPBW
• Responsible for creating mapping documents for Informatica and BW conversion project
• Developed BW Data Models, Data source Mapping and ETL strategy for loading data from external systems sources also explored additional data usage and depth to achieve further higher levels of accuracy.
• Developed UAT plans and test case scenarios to guide the focus group of key end-users in testing the user interface.
• Ensured that all end users and stakeholders reviewed the prototype solutions and provided feedback and these changes were incorporated into the final design.
• Managed all business, technical, and communication issues between the configuration and the business team
• Responsible for Providing Production support and daily monitoring tickets in a production Environment, Identify and troubleshoot system issues as they occur in SAP BW.

Confidential,MA June 03 – Feb 05
SAP BW Consultant
Environment:
SAP BW 3.1C, 3.5, R/3 4.7, BEx, ABAP/4, Oracle 9i, Windows NT
Responsibilities:

• Expertise in Configuring and creation of BW components Info Cubes, Multi-Cubes, Info Sets, Info Sources, Info Objects, ODS objects (Data store objects), Update rules and Transfer rules.
• Data Extraction from R/3 and flat files.
• Developed various data extraction procedures for master and transactional data for full and delta load using LO Cockpit and generic extractors and BW Enhancement for R/3 data.
• Involved in extracting data from SAP R/3(FI-CO,COPA,SD, MM) and extracting legacy data
• Developed reports using Business Explorer that had exceptions, conditional formatting,
  restricted key figures and calculated key figures.
• Created Aggregates and Multi Cubes for performance and efficient utilization of data.
• Responsible to Provide Production support and daily monitoring of Data loads for Summary Cube. This Data Target is used to validate and consolidate customer data across all municipals and districts.
• custom and standard extract structures for export file and 15 import files to synchronize both BW and external legacy systems.
• Developed BW Data Models, Data source Mapping and ETL strategy for loading data from external systems sources also explored additional data usage and depth to achieve further higher levels of accuracy.
• Responsible for Providing Production support and daily monitoring tickets in a production Environment, Identify and troubleshoot system issues as they occur in SAP BW.

Confidential,MA
Jan 00 – April 03
SR. Principal Software Engineer

Environment:
Oracle 9i, Windows NT, 2K COBOL II, JCL, CICS, DB2, UNIX, PL/SQL, MERCATOR 6.7 (Data stage TX), INFORMATICA 7, Mainframe

Responsibilities:

• Actively participate in full lifecycle client implementation using mainframe and client server technology. Created TSD and testing documents for technical design.
• Development of mapping structures for ETL (extract, transform, load) processes using Informatica Power Center.
• Lead a team to convert extraction program into ETL Informatica Tool. Involved in design, development and implementations of various clients
• Developed full work Informatica Work Flow for client’s indicative and financial data in the system using ETL Tools and also extract from DB2 Data base using Mainframe (COBOL, JCL) using PL/SQL.
• Hands on experience in writing Test Scripts, Test Data and implementation of PL/SQL Procedures & Functions and in testing Informatica Mappings.
• Created error and control report to the client feed for user review.
• Converted XML (SAP idoc) file format to fixed flat financial format using MERCATOR Integration Tool, COBOL, and DB2.
• Lead role in development and implementation of full cycle DB Client routine project for Critical business solution, which includes developing IOM online, batch Modules Using CICS, COBOL, DB2, JCL.

EDUCATION

• Bachelor of Engineering.