Summary Profile

Highly motivated and skilled technical professional with more than 6+ Years of experience in IT industry with around 5 years of experience in SAP BI/BW and SAP ABAP

Worked on various implementation stages in SAP BI 7.0 /BW 3.5 areas. Gained good exposure to plan and execute all phases of software life cycle starting with Requirement Study, Analysis, Design, Development, Testing, Implementation and Maintenance, Performance tuning, documentation, maintenance and trouble shooting

Experienced in implementation of complete life cycle of BW that includes Data-Modeling, Data Extraction, Generic Extraction, BEx Analyzer, BEx Query and Web Reporting

Experience in developing different BW objects (Info Objects, ODS Objects, Info Cubes, Data Sources) and being responsible for data loading (master data and transactional data)

Experienced in gathering requirements from business process owners, functional & technical specs, writing up development requests, draw program logical flow diagrams, and test scripts for custom programs, reports & enhancements

Experience in Global Delivery Model handling 7- 8 member team at Offshore & Onsite

SAP Skills Profile

SAP BI 7.0 & SAP BW 3.5
SAP R/3 4.7 & 4.6c, ECC 5.0, ECC 6.0
SD, MM, FI, CO, PP modules
ABAP/4

Technology Profile

ERP			: SAP R/3, SAP ECC, SAP BI 7.0, SAP BW 3.5, SAP Dashboard
Languages			: ABAP/4, COBOL, CICS, REXX, C and C++
Operating Systems	: MVS, Windows NT, Windows XP
Databases			: DB2, Oracle 8i
Front-ends			: SAP GUI, VB
Web Technology		: ASP, HTML, Java Script, CSS 
Quality Technique		: Six Sigma

Education Profile

Bachelor Of Engineering in Information Technology

Experience Profile

•	Yash Technologies  -    Jun 07 – Current
•	Infosys Technologies Ltd  - Sep 03 – Jun 07
•	Global Industries - Nov 01 – Sep 03

Career Profile

Jun 07 - Present
Client     : Kraft Foods Inc.
Location: Chicago, IL
Role      : SAP BI/BW Technical Consultant
ERP   SAP BI 7.0

Responsibilities:

Successfully managed and participated in all development, maintenance and support phases of the project. Work involves in creating new objects and changing existing objects, creating and changing the reports as per user requirement.

•	Requirement gathering
•	Analysis & Design
•	Implementation & Support 

SAP BI Area working:

•	Interacting with end users to understand their reporting requirements and creating document of understanding
•	Involved in data design, data modeling, data extraction, data loading, reporting and production support
•	Designed developed and modified Info Objects, Info Sources, ODS Objects and Info Cubes. Loaded these objects with Master data and Transactional data from SAP R/3 and flat files using full/delta loads by creating Info Packages
•	Enhanced the business content data sources and added new fields
•	Created process chains for parallel data loads, and scheduled them at off-peak hours to reduce the system load 
•	Designed and developed reports using the query designer, BEx analyzer, and BEx browser. The reports included variables, variants, restricted key figures, calculated key figures, formulas, structures, exceptions and filters

Nov 06 – Jun 07	
Client       : Analog Devices.
Location  : Norwood, MA 
Role        : SAP BI/BW Technical Lead		     
ERP SAP BI 7.0

Responsibilities:

•	Requirement gathering
•	Analysis & design
•	Unit Testing & Performance tuning 
•	Implementation & Support
•	Estimation, Scheduling & task allocation to resources & tracking the same
•	Status Reporting to client
•	Documentation & User training

SAP BI Area working:

•	Actively involved in production support issues
•	Fine tuned the BI System by using various Performance Tuning techniques 
•	Developed BI objects (Info Objects, ODS Objects, Info Cubes, Data Sources) and being responsible for data loading (master data and transactional data)
•	Created reports using BEx Analyzer and publishing queries in web.
•	Have worked extensively with SAP dashboard using web templates.
•	Extensively used Open Hub Services to send selected data from data providers to DB tables and flat files 
•	Monitoring the Process Chains for daily, weekly and monthly loads

Oct 05 – Nov 06	
Client      : Hughes Networks Systems. 
Location : Germantown, MD 
Role       : SAP BW Technical Lead		     
ERP SAP BW 3.5

Responsibilities:

•	Analysis & design
•	Implementation & Support
•	Estimation, Scheduling, Work Allocation and Tracking 
•	Status reporting, Metrics & Milestone generation
•	Ensure process & quality of deliverables

SAP BW area working:

•	Involved in the day to day activities of logistics side of R/3 related to extraction and report development
•	Extracted data from FI, SD modules of SAP R/3 and from flat files into SAP BW system using Generic Extractors
•	Created custom Info Sources & Info Objects in BW and mapped them with R/3 fields using transfer rules and Generic extractors
•	Used Delta Update process for loading the data to BW from R/3 in specific intervals
•	Created Restricted  key figures and calculated key figures to satisfy the reporting requirements
•	Enhanced the business content data sources and added new fields
•	Designed, optimized the queries and created reports using BEx Analyzer and Browser

Jan 05 – Oct 05	
Client      : Hughes Networks Systems. 
Location : Germantown, MD 
Role       : SAP BW Technical Developer
ERP SAP BW 3.5

Responsibilities:

•	Analysis & design
•	Unit Testing & Performance tuning 
•	Implementation & Support
•	Documentation 

SAP BW area working:

•	Created info cubes in SD, FI, and Purchasing to load data from R/3
•	Worked extensively with Business Content for Designing, Sales and Financial Info Cubes to meet the End-User Requirements
•	Designed AP, AR cubes for reporting purposes
•	Created Multi Cube for specific queries of SD, FI, and Purchasing. Incorporated transfer rules for Info Cubes and customized update rules using ABAP/4
•	Improved performance of existing SAP BW Queries and reports by creating Aggregates, Compression and Partition etc
•	Developed the Process Chains to automate the data upload and aggregates

Aug 04 – Jan 05	
Client      : Sidmar Manufacturing, Inc.
Location : Princeton, MN 
Role       : SAP ABAP Technical Lead		     
ERP SAP R/3 4.7 & 4.6C
Module SD, MM, PP, FI, CO

Responsibilities:

Successfully managed and participated in all development phases in SAP R/3 4.6c. 

•	Requirements gathering
•	Analysis, High level & low level Design
•	Code Review, Unit Testing & Performance tuning of the code delivered
•	Integration testing 
•	Implementation & Support
•	Estimation, Scheduling,  Task allocation to resources & tracking the same

ABAP Areas working:
Data transfer using BDC & LSMW:

•	Data uploading is done for all master Data and transaction data
•	Work involved in developing BDC programs for posting the document in the general ledger account and reversal the posted document in G/L Account
•	LSMW tool as well as BDC program has been used for converting data from legacy system to SAP system
•	Used both Batch input sessions as well as Call Transaction methods to import converted data into SAP R/3 system

  
User Exit Routine:

•	User exit to populate error message on sales order for the field reason for rejection
•	User exit generated on the sales order for material determination selection if the material has a material determination record

Sep 03 – Aug 04	
Client      : Sidmar Manufacturing, Inc.
Location : Princeton, MN   
Role       : SAP ABAP  Technical Developer		     
ERP 4.6C             
Module SD, MM, PP, FI, CO

BDC & LSMW:

•	Work involved in transporting data from legacy system to the SAP R/3 system for sales order creation, material creation, purchase order creation, posting the document, cancellation of the posted documents 
•	Involved in preparation of technical specifications and coding for material procurement conversions from legacy system to SAP R/3 system
•	Developed BDC program & used LSMW for the conversion process to read the sequential files created from legacy system

Reports:

•	Work involved in creation and modification of new and existing report based on client requirement 
•	Created reports that display month wise sales details by comparing with previous month and yearly sales details with selection criteria based on date
•	Generated reports using ABAP list viewer (ALV)



Nov 01 – Sep 03	
Client      : Sysco Corporation.
Location : Houston, TX       
Role       : Mainframe Developer		     
MVS, COBOL, DB2, REXX

Highlights:

•	Created new regions for system testing, User acceptance testing and Training purpose in mainframe as per client needs. This project includes creation of new CICS region, DB2 region, customization of jobs, procs, control cards and other source programs
•	Successfully implemented SCLM (Software Configuration and Library Management) in Client’s mainframe which brought in a systematic approach for move system and served the purpose of version control tool in mainframe. 
•	Implemented bill back claim system for the client which was a major change in the flow of Client’s business
•	Designed and implemented ‘retransmission of customer orders to vendor thro EDI and to process the EDI confirmation from vendor’ as per the business needs