PROFESSIONAL SUMMARY

• Having 9+ years of experience in IT as SAP BI/BW Lead consultant which includes 8+ years of experience in SAP Business Information Warehouse and 1 year in ABAP.
• Extensively worked on implementation, upgrade, support and maintenance projects.
• Played a vital role in all phases of a project: This includes requirement gathering, modeling, design and development, extraction of data, reporting, performance tuning and transportation of objects.
• Extensively worked on Pre and Post Upgrade activities for BI 7.0
• Experienced in handling projects as a team member and team lead as well as a Quality Coordinator for technical specification and code reviews
• Well experienced in working on BI for Service Industry, Supply chain, Manufacturing, Pharma, Medical and retail industry sectors
• Hands on experience with BOBJ XI 3.1
• Organized weekly and monthly meetings for project status updates and high visibility.
• Managed BW team members from the offshore and onshore team in solving technical issues and provide programming guidance.
• Proficient in coordinating and managing the activities between on-shore and off-shore teams.
• Experience in initiating meetings with the client for requirement gathering, detailing and deliverables
• Extensive experience in handling both support and development projects.
• Very good logical skills suitable for process design, development, and implementation.
• Good team player, strong team orientation & leadership qualities, hard working and enthusiastic.
• Worked as a key person in successfully coordinating and managing offshore-onshore model
• Excellent communications and presentation skills and customer oriented attitude.

TECHNICAL SUMMARY

• Expertise in all the technical capabilities of SAP BI 7.0 and SAP BW 3.1C like Transformations, DTP’s, Multi providers, DSO, InfoCubes, remote cubes, real-time cubes, ODS, Transfer rules, Update rules, Info sets, Info Sources, DataSources.
• Developed Function modules, Start, End, Update, and Transfer Routines in BI/BW to implement business rules and conversions while extracting data from R/3
• Experience in scheduling and monitoring data loads for Production support environment
• Worked extensively on Analysis Process Designer (APD) and Data Mining for month end data analysis
• Extracting data using Open Hub Service using Info spokes
• Used Transport connection to transport objects from Development to Testing environment.
• Experience in data extraction from SAP-R/3 (LO-cockpit, CO-PA, FI, SD, and Generic extractors) and non-SAP systems like flat files and legacy systems.
• Experience in Business content activation, Metadata repository usage, Translation, Reporting agent.
• Experience in reporting tools like BOBJ XI 3.1 and various BEx Components - Building Queries and saving in Workbooks, Filters, Calculated and Restricted Key Figures, RRI Jump queries, Structures and Variables, Query jumps, Exception reporting, conditions, BEx Design Tools (BEx Query designer, BEx Report Designer, BEx Web Application Designer).BEx Reporting Tools (BEx Browser, BEx Web Analyzer, BEx Analyzer), Information Broadcasting Creating Re-usable structures, Copying queries between Cubes.
• Created web reports using Web Application Designer and saved them as I-views to leverage SAP-Enterprise Portals.
• Worked on SAP BI/BW Security and Authorizations
• I got hands on experience with BOBJ XI 3.1 Enterprise and tools including Crystal Reports, Xcelsius, Web Intelligence, Universe Designer, Desktop Intelligence

education

• Bachelor of Technology (B.Tech) in Electronics and Communication

PROJECT Experience

2011 May – Till date Confidential,Chandler, AZ

Project: Supply Chain, Purchase Global, TOP 10 sales, backlogs, orders and shipments –
Production Support/Enhancements/Projects
Role: Technical Lead Consultant
.
Project Details: Confidential,is a privately owned holding company whose operating subsidiaries are innovators in the design, development and production of technologically advanced base materials used to manufacture complex, multi-layered printed circuit boards. Isola, which is headquartered in Chandler, Arizona and employs approximately 2100 people, operates manufacturing, research and development facilities, as well as sales offices, in Asia, Europe and the United States.
Isola\'s investment in research and development, technology and state-of-the-art manufacturing facilities provide value to our customers through innovative and cost-effective solutions for the most demanding applications. Isola’s broad range of products are used in sophisticated electronic applications in the communications infrastructure, computing/networking, military, medical, aerospace and automotive industries.
This is an Enhancement/Support Project to maintain existing applications like Business ware house environment for the client.

Responsibilities

• Extensively involved in all segment of the project from requirements gathering, data modeling, design, extraction of data, reporting, performance tuning.
• Data Modeling responsibilities – Data collection and analysis to set up appropriate staging area ODS’s, InfoCubes, navigational attributes.
• Extensively worked on write optimized DSO, direct DSO, Transformations, DTP’s, InfoCubes, Info sets, Multi providers, Business contents installation.
• Production support activities on a daily basis like scheduling, monitoring daily data loads, troubleshooting the process chains, resolving data load issues proactively, tracking the issues and finding a long term solutions for them.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Worked with users to identify and advise on existing info structures updated by business events in R/3. Identify potential uses and conduct functionality gap-analysis. Identify potential solutions, implement enhancements to existing functionality.
• Worked on generic data extractors. Customized the transaction and master data sources. Data extraction from flat files, standard and custom R/3 tables and non-R/3 systems
• Worked on Function modules, CMOD, SMOD, start routines, transfer routines, update routines, and end routines.
• Modified existing process chains to incorporate the new Brokerage redesign. Developed new process chains for data loading, delta uploading and periodical PSA deletion.
• Worked on BW security and authorizations
• User acceptance tests of BW reports
• Created Reports and worked extensively on distributing reports with SAP Information Broadcaster
• Trained Power Users on creating reports using BEx Designer and its usage in BEx Analyzer.
• Experience with initial and delta loads from R/3 systems. Involved in the creation of Generic data sources with views and function modules on the R/3. Enhanced the standard extractors by adding new fields and enhanced user exits.

2009 Oct – 2011 May Confidential,Dublin, OH

Project: Confidential,Production Support/Enhancements/Projects
Role: Technical Lead Consultant
.
Project Details: Confidential,is a Fortune 17 company that improves the cost-effectiveness of healthcare. This is an Enhancement/Support Project to maintain existing applications like Business ware house environment for the client.

Responsibilities

• Extensively involved in all phases of the project from requirements gathering, modeling, design, development, extraction of data, reporting, performance tuning and transportation of objects.
• Experience in scheduling and monitoring data loads. Troubleshooting the process chains. Tracking the issues and trying to find long term solutions for them.
• Maintaining the Clarify queue -- related to the system generated tickets and customer generated tickets. Analyzing the load failures and providing RCA to the client.
• Experience with initial and delta loads from R/3 systems. Involved in the creation of Generic data sources with views and function modules on the R/3. Enhanced the standard extractors by adding new fields and enhanced user exits.
• Worked on Function modules, start routines, transfer routines, update routines, End routines, and Expert Routines.
• Involved in Data Modeling, Data Extraction, and Data Loading(Full/Delta Upload).
• Enhanced InfoCube withremodelingconcept to make changes, without having to reload data.
• Worked extensively on write optimized DSO, direct DSO, Transformations, DTP’s, InfoCubes, Info sets, Multi providers, Business contents installation.
• Effectively tuned Performance of existing Queries to a great extent by maintaining Aggregates, Roll-up, Compression, partition, indexing of InfoCubes and use of BW Statistics for the same.
• Extracted data through Open Hub Service Info spokes to the database tables, Files etc
• Worked in various BEx Components - Building Queries and saving in Workbooks, Filters, Calculated and Restricted Keyfigures, Worked withReport to Report Interface (RRI)to drill down from InfoCube to DSO item and schedule line level information, Structures and Variables, Query jumps, Exception reporting, conditions, BEx-Analyzer, Query designer, BEx-Browser, BEx-Web Analyzer, Information broadcasting, and WAD.
• Experienced in usingBExInformation Broadcastingto distribute the right information to the right people at the right time.
• ExecutediviewsinPortal.
• Created Process chains for Master data, Transaction data, APD’s, Open Hubs loads to automate the data loading in the organization. Scheduling and periodic monitoring of extractions through Process Chains.
• Played a vital role in Support Package upgrade in BI 7. Applied OSS messages.
• Developed the APD’s for General Ledger Data, Accounts payable and for reconciliation. Applied the options of Aggregation, Filters, data base tables as filters, Variable exit, Join/Union from different data sources, UsedDirectUpdate DSOin the process ofAPD (Analysis Process Designer). Developed ABAP Code, Sort, Formulas, and Transformations when needed.
• Enhanced the Dispute data source 0DPM_0 for transaction data and master data. Created a new function module. Developed a new DSO, InfoCube, Multi provider, maintained the hierarchy values, report, variables, calculated Keyfigures, and restricted Keyfigures.
• Enhanced COPA data source 1_CO_PA1001000 by adding text field. Developed code in the function module to pull the information from BSEG, COBK and COEP tables.
• Enhanced standard data source 1_CO_PA1001000 by pulling COST ELEMENT data to table CE21000 for the CO Document number, Budget version, and Plan value type for COPA Budget Report. Worked on WAD and displayed reports in the portal
• Enhanced the GL Customized Data Source ZGL_TRAN_01 which contains FAGLFLEXA table to pull the right cumulative balance values
• Created a generic extractor to pull the CASH Application trend summary information from customized table to SAP BI
• Modified the master data and maintained a transformation to look up from master data object 0WBS_ELEMENT information and reloaded the data to different data targets.
• Prepared data load plan, Performed reload activities and selective deletion as per the plan for the Fixed Assets, COPA, Disputes, FI, AP etc.
• Took the ownership in resolving issues of critical/High Priority in a timely fashion.
• Involved in documentation for the field mappings, technical specifications, data validations and Test cases.
• Excelled as a Quality-Coordinator by creating and maintaining documents related to enhancements, bug fixes, daily loads, process chain status, Test scripts and change control related.
• Supported the CTS, BCS, APO, third party tool daily jobs.
• Effectively worked and handled ‘On site - Off shore Model’ by training, communicating, distributing tasks to consultants and analysts.

2005 May – 2009 Sep Confidential,Stamford, CT

Project 1: Customer Segmentation
Role: Technical lead

Project Details: Confidential,provides office technologies and services that help companies gain efficiencies and capitalize on opportunities. Pitney Bowes solutions include a wide range of mailing and document technologies, efficiency management services and one-to-one management expertise.
The purpose of the project is to make the required data available for analysis and build the solution which will allow the business stake holders to do the necessary analysis on the profit and loss to gross
Margin Lines by customer segmentation. This will enable the organization to determine future key opportunities across customer segments.

Roles and Responsibilities

• Played a vital role in requirements, analysis, and design of the data model.
• Enhanced the existing Data Source 2lis_13_vditm in R/3 to get the G/L Accounts (Cost G/L Account, List price G/L Account, Freight G/L Account) Created a New DSO to maintain a Customer Segmentation data to support the P&L report which comes from CARIS system.
• Using Data Warehousing Workbench developed BW InfoCubes, Multi providers, Data Stores objects, Key Figures, and Transformations
• The detailed IMS along with Customer Segmentation data is maintained in a new DSO for the P&L Report.
• The summary and detailed IMS, SAP along with Customer Segmentation data is maintained in new InfoCubes and Multi providers for the P&L Report.
• Developed Reports based on requirements from functional departments using FI/CO (G/L & AR)

Project 2 G/L Account Reconciliation
Role: Technical Lead

The purpose of this project is to provide reporting by Opening Balance, Original doc no, Reversal and Exchange rate to have BW and SAP R/3 to match with regard to GL Account. Extraction of data into BW from both US and EAME and validate data with R/3 and generation of Reports.

Roles and Responsibilities

• Actively involved in requirements gatherings & Gap Analysis
• Involved in preparing Technical specs , Design Document, Unit test Cases & System test cases
• Enhanced standard 0FI_GL_4 General Ledger: Line Items.
• Involved in enhancing User exits, creating function modules, transfer rules, update rules, start routines & update routines.
• Generated Reconciliation report using BEx report & Web Reports using WAD.
• Involved in unit testing, System Integration Testing and in Post – Go live activities

Project 3: HR Additional Fields and Revised Refresh Strategy
Role: Technical Lead

The purpose of the Enhancement involves the design of the system to extract and map the Data from SAP HR R/3 and to provide means of reporting by Operating Group code and Region from the HR Headcount and personnel Actions and the employee object.

Roles and Responsibilities

• Involved in preparing Technical specs, Design Document, Unit test Cases & System test cases.
• Enhanced standard 0Employee_Attr extractor by adding Region field from table T500P using user exits.
• Enhanced customer extractor Zemployee_9000_Attr by adding Operating Group code.
• Enhanced customer extractor ZJob_Attr by adding Amount & percentage fields using function modules in R/3.
• Developed new master data texts extractors for BUSINESS UNIT TEXT& OPERATING GROUP TEXT.
• Extensively involved in modifying existing process chains with the new requirement.
• Developed reports for Operating group based on employee.

Project 4: BI 7.0 Functional Upgrade
Role: Module Lead

Functional Upgrade from BW 3.1 to BI 7

Roles and Responsibilities

• Executing the test cases in all environments
• Created a demo DSO, Cube, DTP, Transformations, Migration of Objects from BW 3.1 to BI 7
• Migration of Front end tools like WAD, Analyzer, Query Designer
• Tested all the BI 7 objects like loading through DTP
• Converted all the Business Intelligence systems of Pitney Bowes SAP BW 3.1c old functionalities with all new SAP BI 7.0 functionalities like Information Broadcasting, SAP BI Accelerator, Data Transfer Process, and Transformations.
• Creation of Info sets, Info spokes, process chains, Drill down, filters, Exceptions, RRI, Printing jobs Comparison of BW and BI objects.
• Converting old SAP BW report functionalities of Pitney Bowes into all the new SAP BI reporting functionalities.

Project 5 BI 7.0 Technical Upgrade
Role: Module Lead

Technical Upgrade of BI 7.0 from BW 3.1c

Roles and Responsibilities

• Supporting BASIS team during the Post Refresh and pre-upgrade activities of the Development, Quality and Production Environments.
• Make sure that all transports in DEV system should be released and imported to all downstream systems QA and PRD systems. Checked for Inconsistent Info Objects and repair inconsistent Info objects as much as possible. Cleaned up inconsistent PSA directory entries and consistency of PSA partitions. Checked compounding consistency in Multi providers.
• Creating Transport Requests to get the Source System Connectivity to SAP BI Info Sources.
• Deletion of all incorrect requests from Info providers, Check the complete system for consistency of Pitney Bowes.
• Preparation of Test Plans, Test Cases and Review, executing the test cases, Capturing test case results and documentation.
• Resolving all the issues which are occurring when time to time.

Project 6 Canadian SBS Freight cost
Role: Module Lead

To provide the clearer tracking of freight costs associated with office direct products from mail finishing products

Roles and Responsibilities

• Understanding Functional Specification and done Gap analysis
• Prepared Technical Specifications, Low-Level Design documents, Unit test cases and
• Integration test cases
• A new ODS is created to receive the Delta Data from existing ODS and added DATA OBEJCTS in the existing ODS. Modified BW existing data
• Worked with transactional data Info Sources to load data from SAP R/3 systems into SAPBW
• Worked on administrator workbench (AWB), business explorer analyzer (BEx), created update rules, enhanced the data source 2lis_12_vcitm, created transfer and update routines, replicated data from R/3 to SAP BW. Transported the objects to Production
• Involved in loading and testing the data in BW DEV, BW Quality, and BW Production.
• Worked on VSS and Ecube tool to maintain the quality in project as a Quality Coordinator.

Project 7 JDEdwards Accounts Payable
Role: SAP BW consultant

This project is charted for providing further data from JDE other than the existing data in the BW that are required for the Power Users to prepare a full suite of reports.

Roles and Responsibilities

• The identification of the tables from which the data are required in the JDE system
• Creation of new extractor for Accounts Payable Data
• The urgency with which the data is extracted and loaded into the data warehouse (time frame for loading)
• Led the team successfully in creating Info sets, 4 new ODS and 200 Info objects. Loaded data from JD Edwards to SAP BW through Data Stage. Developed Transfer routines for error handling and to change date format.
• Designed and Developed BEx queries

Project 8 ADM Support and Maintenance
Role: SAP BW consultant

Roles and Responsibilities

• Daily Monitoring of Process Chains .Taking care of Daily / Weekly / Monthly Jobs as per client requirements.
• Involved in Handling change requests, tickets & solved performance related issues.
• Installed BI statistics cubes, Filled the RSDDSTAT, Loaded the BI statistic data, Created a query for statistics - Significantly contributed in the PBS estimation
• Maintenance of documentation of the daily loads, process chain status, etc.
• Service request for loading data and to fix the bug in data transformation,
• DBA issues like space/Memory overflow/Deadlock/some oracle issue.
• Regularly maintained Issue Tracker Involving Tickets & Change requests.
• Service request for creating queries, and Involved in ADR Enhancements.
• Had close coordination with Basis and DBA to smooth line the Production Process.

Project 9: AR sales area BW reporting
Role: SAP BW consultant

Provide Sales Division Reporting within SAP BW Accounts Receivable.

Roles and Responsibilities

• A new ODS is created to receive the Delta Data from existing ODS
• Added DATA OBEJCTS in the existing ODS
• Modified BW existing data
• Worked with transactional data Info Sources to load data from SAP R/3 systems into SAPBW
• Monitored the data transfer from source systems into BW through PSA
• Worked on administrator workbench (AWB), business explorer analyzer (BEx)
• Used ODS to stage the data before transferring the ODS contents to the InfoCube
• Combine data from several InfoCubes into single multi cube to compare related information from the areas of sales, incoming orders and billing
• Transported the objects from BWD to BWQ
• Involved in testing the BW data and preparation of unit, system, integration test cases
• Used the info spokes to import the data to DB2
• Worked on process chains to delete the PSA\'s in production system using through maestro job schedule.

Project 10: ADR sales forecast accuracy
Role: SAP BW consultant

To provide a forecast accuracy report comparing the forecast of the current month, and the month before lead time.

Roles and Responsibilities

• Created the Keyfigures ZI_SALFLT (Sales forecast quantity with firm zone), ZCFFIRMZN (Forecast Firm Zone) and added in the subsequent InfoCube/ODS are ZWWGDPD1 (ODS), ZWWGDPF1(cube)
• Created calculated key figures for Forecast accuracy with firm zone
• Transported objects from BWD to BWQ
• Involved in loading & testing the data in BWD,BWQ,BWP
• Applied the routines
• Involved in testing the BW data and preparation of unit, system, integration test cases
• Worked on BEX analyzer

_____________________________________________________________________
Eismann Food Products, Germany
Duration: 2003 Nov – 2005 April
Role: SAP BW consultant

Roles and Responsibilities

• Worked extensively on AWB, customized info objects, Info Sources and InfoCubes
• Installed relevant SAP business content
• Used LO structures for extracting sales order, delivery-billing information
• Actively involved in monitoring the data transfers from source systems into BW with the help of PSA
• Built the following custom InfoCubes: Profitability Analysis (Costing – Based) Extraction using multiple custom characteristics and key figures (co/pa extraction)
• Worked extensively on BEx analyzer. Developed flexible queries using filters, navigational attributes in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information’s. Used ABAP/Info set query
• Used ODS to stage the data before transferring the ODS contents to the InfoCube. Done ODS reporting to details of delivery items and schedule line items. Delta updates for ODS
• Involved in installing business content for standard Info objects, Info Sources and info cubes
• Combine data from several InfoCubes into single MultiCube to compare related information from the areas of sales, incoming orders and billing
• Performed various tuning techniques (aggregates, statistics and partitioning) to optimize the query performance
• Worked on open hub services
• Worked with reporting agent in creating and scheduling packets for background exception reporting and printing jobs.

_____________________________________________________________________________
Armstrong, Lancaster
Duration: 2002 Dec – 2003 Oct
Role: SAP BW consultant

Roles and Responsibilities

• Designed and developed custom Info Objects, InfoCubes, ODS Objects, Data Sources, User Exits, Info Sources, Update Rules, Transfer Rules, and Communication Structures.
• Worked with transactional data info sources to load data from SAP R/3 systems into SAPBW.
• Monitored the data transfer from source systems into BW through PSA.
• Generated and maintained aggregates and rollup activities on InfoCubes as part of the InfoCube management.
• Created ODS update rules and info package to load data.
• Used report monitor to debug queries.
• Worked extensively on standard and custom defined LIS extractors.
• Used LO-Cockpit structures for delivery services, sales trace overview to facilitate the data extraction to BW.
• Worked on administrator workbench (AWB), business explorer analyzer (BEx), including knowledge of SAP\'s extended star schema modeling.
• Involved in BEx Query Design and worked with variables.
• Taken reports using BEx analyzer and saved them in workbooks.

_____________________________________________________________________________
BHEL, India
Duration: 2002 Jan – 2002 Nov
Role: ABAP Programmer

SAP implementation at Bharat Heavy Electrical Limited, Hyderabad – Gas turbine division project assistant. I have been assigned the task of analyzing, designing and developing reports, dialog transaction and SAP scripts. The project involved in the implementation of SAP R/3 4.6C. SAP is
being implemented by Price Waterhouse Coopers Pvt. limited (Currently IBM business consulting services).

Roles and Responsibilities

• As a developer, was responsible for spec reviews, developing and testing
• Majority of the development done was in SD, MM, functional areas with a variety of objects in following areas, report generations, conversions, interfaces, LSMW and involved in the modification of scripts as per the client requirement
• To develop SAP R/3 objects as per the specifications given by functional consultants.
• Modifying and fine-tuning classical and interactive report programs.
• Defined variants for reports for outputting lists.
• Batch input methods used to upload material master, bill of material, purchase order,
• Customer master, sales order, shipping and billing
• Classical method, call transaction method for data migration.
• Designed and developed layout sets in SAP script for purchase orders, invoices and goods receipt slips.
• Modification of SAP script for commercial invoice, etc