Over 12 years of software experience in IT and professional with more than 5 years of SAP BW/BI and SAP CRM implementation, configuration and customizations.
Good knowledge of BW Data Architecture, various data design models and Extended Star Schema models.
Active participation in all phases of a project : This includes requirement gathering, modeling, design and development, extraction of data, reporting, performance tuning and transportation of objects.
Technically sound in Modeling designed and developed Infoobjects, InfoCubes, Multicubes, InfoSources, DSO Objects, Update Rules and Transfer Rules.
Worked with Business content and enhanced business content as per client specific needs.
Experience in 2 Full life cycle implementations of BW.
Experience with initial and delta loads from R/3 systems. Experience in scheduling and monitoring data loads.
Involved in the creation of Generic data sources with views and function modules on the R/3 side.
Enhanced the standard extractors by adding new fields and wrote user exits for that purpose. Good understanding of before/after images.
Experience in using ABAP/4 to create Function modules, start routines, transfer routines and update routines.
Performance tuning of Queries by maintaining Aggregates, roll-up, Compression, partition, indexing of info cubes and use of BW Statistics for the same.
Experience in various BEx Components - Building Queries and saving in Workbooks, BEx Analyzer, Filters, Calculated and Restricted Key Figures, RRI Jump queries, Structures and Variables.
Good understanding of displaying data using remote cubes and pulling data from SAP BW using Open Hub Service using Infospokes.
Used Transport connection to transport objects from Development to Testing environment.
Good experience upgrading system from BW 3.1 to 3.5.
Good knowledge of data extraction from SAP-R/3 LO-cockpit, CO-PA and Generic extractors and non-SAP systems like flat files and legacy systems.
Created process chains for scheduling of various load processes.
Business content activation experience, Metadata repository usage experience, Translation, Reporting agent experience.
Proficient skills in SAP implementations for Sales, Marketing and CIC.
Working experience in implementation, upgrade and in support and maintenance type projects.
experience in Data Analysis, Data Mapping and Data Conversion.
Role in project development which includes Client Interaction, Testing and preparing functional test plans and documentation.
Worked on the life cycle of a SAP BW development using ASAP methodology Project Preparation, Business Blueprint, Realization, Final Preparation and Go live and Support.
Worked as a Team Leader and Team Member in projects.
Possess excellent analytical, logical and communicational skills.
SAP BW : SAP BW
BI7.0, 3.5, 3.1C, SAP R/3 4.7C, 4.6, ABAP/4, SAP R/3 SD, MM, FI-CO modules.
SAP CRM : mySAP CRM 4.0 CIC, Sales, Marketing.
OS : WIN NT/98/2000, Unix, MS-Dos.
Languages : Clear Basic, C, C++, PL/SQL, Visual Basic 6.0, Html, Java, JSP, XML.
Database : Oracle 7.X or 8 or 9.2, MS-Sql Server 7.0/2000, UDB 7.2/8.1
Middle Tier : Tuxedo 8.1, Bea Web Logic Server 8.1.
Software : MS-office, MS-Project, Visio.
CRM Modules : mySAP CRM, Clarify CRM, Siebel.
Reporting Tools : Actuate Reports, Crystal Reports, BEx Business Explorer
HP Invent, August 06 to Still Continuing
Houston, TX
Project : iGSO project implementation for EMEA, NA and Latin America HP services
As a BW Consultant, I was responsible for
Worked closely with the client to understand the requirements. Had several sessions scheduled to understand the existing data warehouses and their expectations from BW.
Identified and Documented the End-user requirements.
Worked extensively in Order Fulfillment area by using 2LIS_11_VAITM 2LIS_11_VASCL 2LIS_11_V_SSL 2LIS_12_VCITM and 2LIS_13_VDITM standard extractors. Developed Backlog Order Summary Cube ZSSDGC01, Backorder Delta ODS ZSSDGO05, NA/Mexico - Backorder Detail ODS ZSSDGO12, MultiCube and Infoset ZSSDGI01, Delivery item ODS ZSSDGO03 and Billing ODS ZSSDGO06.
Worked on Business content for extractors in Finance areas. Activated, 0FI_GL_4, 0FI_TAX_4, 0FI_AR_4 and 0FI_AP_4.
Extracted the data from Legacy system for Proof of delivery information from both DHL and TNT/UNAS services.
Activated Business Content objects and created custom Info objects Asset sub-no, Company code, Asset class etc to load master data.
Created process chains for daily master data loads full update and delta loads for the transaction data
Extensively used Open Hub Service to send data to external destination flat file.
Created DSO objects to store data and update into data targets.
Created query variables and enhanced the query functionality with the use of Customer-Exits Exit_SAPLRRSO_001
Code ABAP Routines for transfer rules, update rules, conversion routines in BW system.
Worked on BI-7.0 and developed front end queries and reports using BEx Analyzer, BEx Browser and InfoSet Query.
Resolved all the issues during Integration test phases on time.
Managed and monitored several data loads, captured the errors and corrected the bugs.
Worked with Process Chains in order to automate the Process of loading.
Monitored transaction and Master Data loads during Integration testing.
Monitoring data loading and fixing the data load issues for production support.
Successfully transported all objects from Dev to Quality and Production environments.
Involved in planning Cut-over tasks for Integration tests and actual Go-live.
Documented all the development done and maintained technical specs up to date.
Environment : SAP BW 3.5 and BI7, Oracle, Unix
Advanced Micro Devices AMD, CA, July05 to July 06
AMD is the world's second-largest supplier of x86based processors and the world's third largest supplier of graphics cards and CPUs, after taking control over ATI in 2006. AMD owns a 21% share of Spans ion, a supplier of non-volatile flash memory. In 2006 the company ranked eighth among semiconductor manufacturers.
As a BW Consultant, I was responsible for
Gained a good understanding of most of the new features of NW2004S BI.
Wrote functional specs for Infocube partitioning and shopping cart report SRM.
Gained good understanding of BBB Bookings, Billings and Backlogs in SD.
Analyzed the existing data model for Backlog and redesigned the Backlog data flow to simplify current logic, remove all the redundant code.
Created process chain for the new Backlog data flow.
Tested the flow successfully in 2 Integration test Phases.
Activated SRM Business content to see Shopping carts reports provided by standard Business content.
Incorporate variable ZSOLDCE in queries where sold-to look-up is required variable user exit. This reduced the number of sold-to-party roles assigned to users 1 role for each sold-to-party was maintained earlier.
Took charge of Regression testing after upgrade to check all the data flows in SD, MM, FI and meet deadlines for all the 3 phases of Integration testing.
Followed all the procedures in Clarify, created Problem tickets and Changes requests to move changes in Development to Quality and Production SOX compliance
Involved in the generation of cut-over plan and performed dry-run before the actual Go-live.
Environment : SAP BW 3.5 and BI 7.0, Oracle.
All State - North brook, Jan04 to June 05
Chicago. IL
As a SAP BW Consultant, I was responsible for
Design and Setting up of Enterprise structure
Setting up configuration for Deliveries to Goods Issue, Shipments and Cost documents.
Unit testing and participation in Integration testing and User acceptance test.
BW Configuration, Modeling, AWB, BC installation, Enhancements to standard BC, Customization, Scheduling and Monitoring of ETL jobs, Performance Tuning, Testing and post implementation support and maintenance.
Responsible for Sales - Orders, Deliveries, Contracts, Billing, Purchasing, Inventory Management, FI Info Cubes which are Fulfillment.
SAP BW Functional experience includes Requirements gathering, Analyzing Reporting needs Requirements analysis, End-User interaction, Design Specifications and Technical Documentation.
Extraction for LO Cockpit, FI, CO and CO-PA application modules.
Used BW Content extractors to extract data from SAP R/3 to BW.
Generic R/3 Data Extraction for LIS, CO-PA.
Extracted the data from Non R/3 system using flat files.
Implemented Process Chain feature for Daily Master Data ATTR Process Chain, Daily Master Data text Process Chain and Daily Transactional Data Process Chain.
Using Process chains loaded transactional data into PSA and updated data from PSA to ODS and activated ODS for reporting.
Loading Data in ODS Objects and Info cube, Delete Indexes, Creating Indexes and Activation of ODS objects Using Process Chains Feature.
Using New Feature of 3.0 B Open Hub Services Data is transferred from SAP BW system to Non sap systems.
Open Hub Extractors ACC_TRANS_OHUB, MM_EXTRACT_OHUB, SD1_TRANS_OHUB AND SD2_EXTRACT_OHUB Info Spokes are Created using Data sources Info cubes, ODS Objects, Info Object Attribute and Text. After Data Loads are done in Info spokes data is transferred in to Down Streams.
Multitudes are Created using Info cubes NA/EMEA, ODS Objects NA/EMEA and Info objects NA/EMEA Which are useful for Global Reports For All Regions.
Created/Modified Info Sources for Master Data Attribute and text and Transaction Data.
Created/Modified and activated Transfer Rules and maintained Communication Structures.
Created and Scheduled Info Packages for Data extract.
Set the Update Rules for Info Cube and uploaded data into the Info Cube.
Developed ODS object to load transaction data from Info Source and defined update rules.
Created Info Package group to schedule Info Packages to load regularly and triggering the attribute change run.
Extensively used calculated and restricted Key Figures. Created variables for the queries.
Created Drill through Queries from summarized Info Cube to detail ODS data.
Performance Tuning in BW.
SAP BW Unit Testing, Integration Testing and maintenance.
Environment : SAP R/3 4.6C, SAP BW 3.1C, Oracle, UNIX Sun Solaris.
Caterpillar, Aug03 to December 03
Chicago, IL
Project : Enterprise CRM Sales and CIC.
Caterpillar is the worlds leading manufacturer of construction and mining equipment, diesel, natural gas engines and Industrial gas turbines. Caterpillar, in partnership, with its worldwide dealer network is driving positive and sustainable change on every continent. Caterpillar has implemented SAP SD and SAP CRM for its engine division. The implementation of these modules helped Caterpillars dealers to manage their entire quotation sales process. in this Project my prime responsibility is to ensure the CRM team and I should meet all the deadlines in terms of CRM Tickets and service requests.
Responsibilities
Involved in the Knowledge Transfer sessions, where in I was the sole responsible for preparing the required CRM documentation for onsite offshore Knowledge Transfer, Giving constant consulting services to the client.
Understanding Business Process Requirements and driving the analysis, process finalization, resolving process and technical issues.
Knowledge Bridge between USA and technical team offshore.
Providing support and working on Severity 1 to Severity 5 issues related to various objects in CRM space.
Monitoring the BDocs and queues on a regular Basis. Ensuring the quotations created in ISA reach successfully into SAP R/3
Conducting initial, Delta downloads whenever necessary.
Working on Various Change Requests.
Environment : SAP CRM 4.0 Sales, Customer Interaction Center, SAP R/3, Oracle 9, UNIX.
AT and T, April 99 to June03.
Middletown, NJ
Project : Order management System Business IP Customer Care Applications
AT and T orders are submitted using order submission forms over the Internet and the data is moved to the Clarify system using the interface MS VC ++ programs. The processing of orders is completed by creating Cases and Subcases that are worked on by the agents until the order is completed. The orders are created as contracts in the Clarify system. The pricing of the orders and creating schedule line items are created and billing is generated on the screens and transferred to third party applications..
As a CRM Consultant, I was responsible for
Customization and modifying various forms in the application according to business requirement.
Developed a new DNS form for displaying DNS information.
Developed the DSL forms along with modifying the interface code API to accommodate the DSL functionality.
Making enhancements and changes to the interface programs.
Involved in Upgrading clarify from 6.0 to 8.5 and 8.5 to 11.5
Testing the functionality after upgrading is done.
Enhancement of Managed Firewall Service for subsystem MIS Managed Internet Service.
Resolving Productions bugs and fixing them in Production database.
Preparation of Technical design document.
Environment : Clarify Sales, Contracts, Logistics, Support, Clear Basic, Windows 2000, Oracle 8, Toad, JSP, XML, Clarify11.1 DDE, UIE, Cbex.
Specialized Software intl Feburary 97 to March 99.
Worcester, MA
As an Analyst/Programmer : Designed and developed Application for client nationwide insurance for Auto insurance. This is loss reserving system which calculates losses in various states monthly and quarterly basis. This application is useful in preparing new quotations and calculating premiums for the next period for existing customers and discounts for the customer based on previous driving history.
Environment : Visual Basic 5.0, SQL server, win95, Crystal Reports.
STPH
July94 to October 96
INDIA
As an Analyst/Programmer Involved in developing an EHTP information system for Software Technology Park Hyderabad STPH which provides The Information regarding Company details, their imports, DTA sales and performance reports. The basic objective of the Electronic Hardware technology Park EHTP Scheme are to provide a flexible Policy Environment that would enhance the ease of doing business This package has developed in Visual Basic 5.0 using Oracle as back end..
Environment : Visual Basic, Oracle, Windows.


Certified In SAP.Certified In Clarify CRM.


SAP BW 3.5, 3.0B and BI7.0 SAP BW Configuration, Modeling, AWB, BC installation, Customization, Enhancements to standard BC, Scheduling and Monitoring of ETL jobs, Open Hub extractors Info Spokes and Process Chains. Working knowledge of SAP BW and SAP CRM. SAP CRM 4.0, R/3 4.6B. Creating a CIC profile, Action Box, Email Management add Custom BOR objects Used in SAP CIC. Configuring front office Framework like Window Titles, Frame work ID, Visible and Hidden Components providing functionality Specific to user needs in CIC



BTech Mechanical Engineering.
M. Technology Chemical Engineering.