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 & BI 7.0 and SAPBusiness Objects(SAP BO) XI 3.1
• BOBJ Universes and reports developer with extensive experience working with end users and program managers to define, design and implement enterprise wide reporting solutions
• 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.
• Leverage my knowledge of SAP BW to develop reporting solutions that address user requirements using Query Designer, Report Designer and BEx Analyzer, Report development in WAD and Dashboard.
• Expertise in configuration and implementation of BOE Premium XI 3.x, Crystal Reports 2008, Xcelsius, Voyager, SAP Integration Kit for SAP XI 3.x, SAP systems Authentication, managing Central Management Console (CMC).
• Excellent working knowledge 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) . Experience in installation of DataIntegrationkit
• Implemented the SAP Business Objects using LDAP and SAP
• 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
• Extensive experience in gathering system requirements, defining business processes, identifying risks and Impact analysis
• Developed UAT plans and test case scenarios to guide the focus group of key end-users in testing the user interface
• Experience in SAP BW Functional/Technical upgrade project (BI 7.0 from BW 3.5).
• Experience in complex software projects through all phases of Software Development Life Cycle (SDLC), Post Test Analysis, Object Oriented Design and execution of Software Systems employing Industry proven software engineering best practices.
• Development of mapping structures for ETL (extract, transform, load) processing XML, oracle, db2, COBOL files using Informatica Power Center. Involved with extracting data into SAPBW using Informatica
• Trained in SAP FICO functional configuration also Pursuing PMP certification

TECHNICAL SUMMARY

Data Warehouse SAP BI / BW 7.0, 3.5, 3.1C

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

Reporting Tools Business Explorer, WAD & Designer, Business Objects( BO) XI 3.1 , Crystal Reports, XCelsius and Web Intelligence

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

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

Microsoft Suites MS Project, MS Office 2000/XP, PowerPoint, MS Word, MS EXCEL

Confidential Boston, MASept. 07– June 09

Clients: Confidential Kansas City, KS October 08 to June09
SAP BI (BW/BI) Architect Consultant
Environment: 
Net weaver 2004s ,SAP R/3 6.0, SAP BW/BI 7.0 , Query Designer BEx Analyzer/Browser, Business Objects XI 3.1, , ABAP/4, Workbench, SD, MM, FI/CO-PA, Oracle, Windows 2000/NT.
As a BW/BO 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.
• Installed Business Objects Enterprise (BOE) Premium XI 3.1, Tomcat Application Server, Crystal Reports 2008, xCelsius and corresponding Server and client components, tested, documented, maintained the Database, Application and Web tiers and ensured they are working in Development, Testing and Production environments
• Worked with SAP Basis team and installed Integration Kit for SAP XI, Java Connectors 2.1.8,3.x, authenticated SAP BI systems in Business Objects Central Management Console (CMC)
• Experience in SAP BOE XI Central Management Console (CMC), Central Configuration Manager (CCM), Universe Designer, Web Intelligence (WebI), Java/.Net InfoView, Web Intelligence Rich Client, Desktop Intelligence (DeskI), Xcelsius ,Crystal Reports and Voyager workspace
• Created Xcelsius visualization using live office and also query as web services
• Set the hierarchy at universe level for the scope of analysis (Drilling) in Business Objects.
• Created Reports in Business Objects based on Drill down, Cross Tab, Master Detail and Formulae’s etc
• Configured and Customized delta built up for the Data Sources, LO-Cockpit Configuration and Customization. Customized Business Content and configured Generic Extractors. Expertise in Reports using query Designer, BEx Analyzer, BEx Reporting Tools, WAD (Web Application Design), Broad casting and Report Designer
• 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.
• 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.
• Creation of documents both (Desktop Intelligence and WebI), summary and detail with the functionality of drill down to detailed document.
• 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

Clients:

Confidential , Philadelphia, PA Sept. 07– Sept 08
SAP BI (BW/BI) Architect Consultant

Environment: 
Net weaver 2004s ,SAP R/3 6.0, SAP BW/BI 7.0, SAPBusiness Objects(SAP BO) XI r2, WebI ,BEx Analyzer/Browser, WAD and Report Designer , ABAP/4, Workbench, SD, MM, Oracle, Windows 2000/NT.Crystal reports
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.
• Created SAP BusinessObjects – SAP BI 7.0 Roadmap document, functional and technical specifications for seamless integration and reporting
• Worked with SAP BO, BI, Basis, and R/3 teams and involved in providing integrated solutions.
• Worked with SAP Basis team and installed Integration Kit for SAP XI, Java Connectors 2.1.8,3.x, authenticated SAP BI systems in BusinessObjects Central Management Console (CMC)
• Expertise in creating Reports using query Designer, BEx Analyzer, BEx Reporting Tools, WAD (Web Application Design), Dashboard ,Broad casting 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.
• Created/Edit queries and reports in BOBJ - InfoView for multidimentional analysis and trained users on drill-down, cross-tab, master detail, slicing and dicing, ad-hoc reports by Web Intelligence (WebI), Xcelsius, open document , scheduling and publishing (to BO Inbox, email, FTP, ..) in multiple formats (html, pdf, ActiveX doc,..)
• Created Crystal Reports on queries that were built on BEx Query Designer and wrote complex queries including Sub Queries.
• Formulated Data to appear in Master-Detail, Cross-Tab and Ranking reports.
• Provided Production support and daily monitoring jobs in a production Environment

Developed UAT plans and test case scenarios to guide the focus group of key end-users in testing the user interface

Clone skill corp. NV

Client: Confidential Parsippany, 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
• 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.
• 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.

BSC Consulting, Boston, 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 Marlborough, 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.

Confidential MA
Dec 98 – Jan 00
Sr. Software Engineer/Developer

Environment:
COBOL II, JCL, CICS, DB2, UNIX, PL/SQL , Mainframe

Responsibilities:

• Actively participate in full lifecycle client implementation using mainframe and client server technology. Created TSD and testing documents for technical design.
• 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.
• 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.

Confidential 
Jan 97 – Dec 98
Sr. Software Engineer/Developer

Environment: COBOL II, JCL, CICS, DB2, UNIX, PL/SQL, Mainframe

• Responsible for 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