SUMMARY:

• Dedicated SAP BW/BOBJ/BODS certified consultant with 16 plus years of overall IT experience, which includes 10 plus years of SAP BW and 6 plus years of legacy mainframe experience
• Worked with Top Four consulting companies like Deloitte and CapGemini serving SAP BW consulting services to their prestigious clients
• Excellent professional experience in Software Development Life Cycle that includes requirement gathering, design, project implementation, system test and implementation, user support and training
• Involved in full life-cycle implementations of multiple SAP BI/BW projects using ASAP methodology
• In depth technical experience in SAP BI/BW and good functional knowledge in FI/CO, SD, MM, SRM(EBP) CRM,CATS and EM modules
• Well experienced in Data warehousing concepts, Designing effective client specific BW systems, Data Modeling, Performance Tuning, Data Extraction and Data loading for both application specific as well as generic from R/3, ECC, CRM, SRM and Non SAP systems like Maximo, other legacy applications like Mainframe systems
• Functioned various pre and post activities of the Upgrade project from BW 3.5 to SAP BW 7.0 (SAP Net Weaver 2004s)
• Extensive experience with SAP BW Accelerator (BWA) setup and index creating as well as the new features like Transformations, end-routines, DTP, Data acquisition etc.
• Extensively worked with Basic Infocubes, Real time Infocubes, DSOs, Multi Providers, Infosets, Data validation and error- handling, Start routines, update rules, transfer rules, APD and Open hub.
• Implemented Multi-provider model to include current and last 2 years cubes in the reporting key. At year end, data flow will automatically adjust to move to required cubes
• Enhanced the Business Content data sources and extended the structures using user exits to support the business needs
• Created various types of customer exit variables for Bex query designer and populated these variables using Enhancement user exits
• Experience with SAP Business Objects, Xcelsius, Crystal reports, Live Office and SAP BEx Analyzer, BEx Browser, Query Designer, Web Application Designer and other reporting tools
• Involved in the SAP Business objects Data services (BODS) implementation and POC and exposures to the components like Designer, Job server and Engine and Repository. Key role played in Integration of Business objects and BODS with SAP BW and POC at DTE Energy
• Expertise in executing SAP BW-BPS functionality, creating Planning objects like Planning Areas, Planning Packages, Planning Functions, layouts variables using Panning workbench. Also worked with retraction from SAP BW to ECC and CRM systems
• Proficient in developing various project deliverables like Functional and Technical specs etc.
• Excellent communication, interpersonal and project management skills
• Strong ABAP4 programming, analytical, problem solving, and debugging skills
• Performance Tuning: Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning
• Expert in trouble shooting and bringing necessary solutions to various SAP BW related issues
• Extensive experience in client training in Data Warehousing and Reporting Analytics. Conducted trainings and workshops for end-users and project team members
• Efficiently managed and worked with the team to achieve company’s as well as client’s goals
• Positive attitude and very open minded in Sharing and Transferring both the technical as well as the business knowledge to peers and other project members
• Mentoring BW action learning consultants

EDUCATION: Bachelor of Science in Engineering

STATUS: US Citizen

SKILLS: SAP BW 7.1, BWA, BW 3.5/3.1/3.0B/2.1C, SAP R/3 versions (3.0 - ECC 6.0), SAP CRM, SAP SRM, Maximo, SAP Business Objects, SAP BODS, SAP BW BPS, Business Explorer (BEx), BEx Analyzer, BEx Browser, WAS 6.2, PL/SQL, Oracle 9i/8i/8x, Perl, XML, UNIX, OS400, AS400, Linux, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows XP/NT/2000/98/07, Mercury, Service center, Kintana, Test director, Solution Manager, IBM 3090, COBOL, CICS, DB2, VSAM, IMS DB/DC, EASYTRIEVE, TSO/ISPF, JCL, MVS, RC Update, Endevor, Intertest, Spufi, Expeditor, Net wise, Visio, Power Builder, Share Point, Microsoft Outlook, Office Communicator, Cognos and MS office 2007 & 2010

HIGH LIGHTS:

• In Year 2009, Trained in SAP Business objects, SAP Business objects Data services and SAP BW BPS conducted by SAP Chicago and sponsored by DTE Energy and also played a key role in the Implementation of Business Objects and Integration with SAP BW and also successfully presented the proof of concept with various SAP BOBJ/BODS features using various DTE’s BW data sources via BO universes

• In Year 2005, Trained in BI-accelerator, BI-Delta Reporting & Enterprise Data Warehousing SAP Net Weaver 2004s BI 7.0, SAP BW (3.5), Advanced BW Reporting (3.5) and SAP BW Performance & Administration (3.5) conducted by SAP Atlanta and sponsored by Deloitte Services LP

• In Year 2005, Presented the proof of concept on Open Hub Service (2004s) & APD (Analysis and process designer) to Deloitte Services LP
• In Year 2004, Trained in Cognos Reporting sponsored by Limited Brands
• In Year 2004, Trained in SAP Net Weaver \'04 – Ramp up training conducted by SAP Philadelphia and sponsored by Cap Gemini. Attended and got certified the SAP BW Certification exam conducted by SAP Philadelphia and sponsored by Cap Gemini
• In Year 2004, Attended and got certified the SAP BW Certification exam conducted by SAP Philadelphia and sponsored by Cap Gemini
• From Jan 2002 to Mar 2005, Involved in various workshops conducted by Cap Gemini, giving presentations on SAP BW to various clients for promotion, providing BW assistance in various pursuits made by Cap Gemini and mentoring BW action learning consultants

WORK EXPERIENCE: Senior SAP BW Consultant Confidential, Nov 2011 – Present

Environment: SAP BW 7.1, BW 3.5, SAP R/3 versions ECC 6.0), SAP CRM, Maximo, Business Objects, BPS, Business Explorer (BEx), BEx Analyzer, BEx Browser, WAS, Oracle, UNIX, AS400, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows XP/07, Mercury, Service center, Share point, Visio, and MS office 2010

Responsibilities:

• Played the BI/BW Senior developer role for the client GMI’s Campaign Management Conversion project, which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, conversion of the existing models to enhanced model with additional features right from Coupon planning to execution as wells as the unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and transition
• Worked on understanding and analyzing the CRM Market Campaign Planner process as well as the related data in the CRM, ECC and legacy BW systems. Raising the required questions.
• Key role played in the Business objects reporting requirements, design sessions and the Gaap analysis
• Worked on analysis of the AS IS existing complicated model to convert it into an enhanced model for all the stages which includes the Planning, Projection, Settlement, Redemption, Distribution and Reporting
• Key role played in reviewing, understanding, analyzing the existing complex BPS functions. Layouts and

Other BPS related objects and suggested the necessary inputs to BPS developers

• Designed the new BW model to satisfy the old features as well as enhanced features and integrate with front end like CRM planner and Business objects as well as the source systems CRM, ECC, legacy BW and Flat files
• Developed various documents like Data flow, Data mapping, Data dictionary, Functional and Technical specs to support the enhanced design
• Created various BW backend objects which includes real time cubes, Basic cubes , DSOs, Datasources, Infosources, Transformations, DTPs, Open hub spokes and Process chains
• Developed complex ABAP code in the end routines and start routines of the Transformation to satisfy the existing BPS functions and latest business needs
• Developed DTPs and Infopackages and created various routines with ABAP for the selections. Used semantic keys.
• Developed Classes and Methods and included in the End routines, Start routines and DTP routines to avoid redundant code.
• Created 16 complex Bex queries on the Multiproviders to support BOBJ universes. And also created various other Bex queries on the others Infoproviders to support the business needs
• Created various Customer exit variables to support the queries. Used ABAP in the enhancements to fill these variables. Rolling 12 is one example with these variables
• Supported BPS developers whenever required while development as well as testing phases.
• Involved in the Retraction and Extractions process from and to between real time cubes and source systems
• Handled the huge loading for historical conversion from the CRM, ECC and the legacy BW systems in D and Q environments
• Identified, designed, developed and loaded the required Master data objects to support the new model
• Involved in Unit and QA testing and performed the tuning to improve the query as well as the loading performance. Created and refreshed the BWA indexes as well as DB stats.
• Used the issue log on the share point to communicate the status as well as issues to the team members and business owners
• Created various transports, collected the required objects and migrated to the target systems
• Developed, conducted and presented various training to the users as well as the project members

Senior SAP BW/BOBJ/BODS Consultant Confidential,, Detroit, MI Apr 2008 – Oct 2010

Environment: SAP BI 7.0 (2004S), BW 3.5, SAP R/3 versions ECC 6.0), SAP SRM, Maximo, Business Objects, BODS, BPS, Business Explorer (BEx), BEx Analyzer, BEx Browser, WAS, Oracle, UNIX, AS400, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows XP/NT/2000/98, Mercury, Service center, Kintana, Solution Manager, DB2, Visio, and MS office 2007

Responsibilities:

• Played the BI/BW Senior developer as well as the BI architect role for the complete client DTE’s BW system which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, Redesigning the existing models as wells as the Reporting structures, Unit testing, trouble-shooting, integration and user acceptance testing, documentation, training and maintenance
• Worked with the legacy systems users to understand the huge volume of legacy data stored on the oracle systems as wells as Mainframe DB2 systems and designed the arching structure on the BI system to store the huge volume of legacy data
• Involved in the integration and implementation of SAP Business objects and SAP BODS with SAP BW and also prepared and presented POC
• Designed and developed Universes in Business objects on various Infoproviders and presented the reports to users
• Designed and developed the process for extracting, transforming, and loading data using the SAP Business Objects Data Services into SAP BW Data targets. Transformed the data to suit to business needs. Verified and improved the quality of your source data
• Performed various FI and Maximo related huge data loadings from legacy systems to BI system
• Worked with several users both at the execute as wells as non executive levels to gather requirements and transformed them into a data model using extended star schema concept
• Coordinating and helping the client’s developers on various BI technical as well as application aspects
• Representing DTE’s BI system and coordinating with SAP on the road mapping setting done by SAP
• As a part of the BW 3.5 to BI 7.0 upgrade team performed various Pre and Post upgrade activities supporting the basis teams as wells user groups
• Developed various deliverables like BBP, Functional and Technical specs, Data mapping and Data flow documents, Gaap & Impact analysis documents, Step by step solution and Transport seq
• Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects
• Worked with Non-SAP Maximo team to understand the data and converted the data to suit to BI
• Designed, developed and implemented new BI model using NW 2004s features like Transformations, end-routines, DTP, Data acquisition etc.
• Worked with various standard as well as custom BI/BW objects for SRM and FERC,FI (GL/AP/AR), CO,SD, MM, HR and EHS of ECC.
• Worked on customization and enhanced the extract structure to support business needs
• Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (EDW, RSA1)
• Developed Transfer Rules and Update rules to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
• Populated various data targets like Infoobjects ,ODS and Infocubes, with Master data and Transactional data from ECC 6.0, legacy systems using flat file interface via Data Staging area (PSA)
• Debugging the Extractor checker, Transfer rules and Update rules
• Worked with Datamarts, Myself source, Generate export Datasource and Replication
• Created Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data
• Created process chains using various process to automate data loading, activation of ODS, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Extensively performed huge data loads into ODS and Infocubes from ECC as well as the legacy systems
• Developed Queries to access data from various BW Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer
• Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures
• Collecting and Releasing transports (BI and BEx). Worked with basis team for space related issues, establishing RFC connections to various source systems, applying required notes, moving objects from development box to QA and Production,.
• Prod support (on call) by monitoring the daily loads, trouble shooting the issues & fixing the errors
• Reconciliation of BI reports with the ECC & legacy data as wells as the reports
• Performed the analysis for loading and query performance
• Trained the client’s technical as wells as the business teams on how to use the ongoing application
• Worked with the security team to evaluate and create the required Roles and authorization and other related issues

Senior SAP BI Consultant Confidential, Wilmington, OH Jul 2007 – Mar 2008

Environment: SAP BI 7.0 (2004S), ECC 6.0, Business Explorer (BEx), BEx Analyzer, AS400, XML, OS400, Linux, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows XP/NT/2000/98, Solution Manager, Visio, and MS office 2007

Responsibilities:

• Played the BI lead as well as the BI architect role for the complete full life cycle BI Implementation which includes conducting AS-IS and TO-BE sessions, gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, unit testing, trouble-shooting, integration and user acceptance testing, documentation and maintenance
• Worked with several users to gather requirements and transformed them into a data model using extended star schema concept
• Developed various deliverables like BBP, Functional and Technical specs, Data mapping and Data flow documents, Gaap & Impact analysis documents, Step by step solution and Transport seq
• Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects
• Worked with legacy AS 400 team to understand the data and converted the data to suit to BI
• Designed, developed and implemented new BI model using NW 2004s features like Transformations, end-routines, DTP, Data acquisition etc.
• Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR) of ECC. Worked on customization and enhanced the extract structure to support business needs
• Designed and developed various Datatargets and Infoproviders like DSO (ODS), Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (RSA1)
• Debugging the Extractor checker, Transfer rules and Update rules
• Post Go-live support (on call) by monitoring the daily loads, trouble shooting the issues & fixing the errors
• Reconciliation of BI reports with the ECC & legacy data as wells as the reports
• Performed the analysis for loading and query performance
• Trained the client’s technical as wells as the business teams on how to use the ongoing application
• Created Open Hub interface to transfer data from BI to Flat Files to load to an external system
• Performance Tuning - Evaluated statistical performance and suggested recommendations to basis support for optimization. Improved data load and query performance by doing compression, aggregates, and partitioning
• Customizations - Enhanced the Business Content Objects data structures of FI related and customization; configuration, update/transfer rules creation

Senior SAP BI Consultant Confidential, Nashville, TN Apr 2005 – Jul 2007

Environment: SAP BI 7.0 (2004S), BIA, BW 3.5/3.1/3.0B, SAP R/3 versions (4.7 - ECC 5.0), SAP CRM, Business Explorer (BEx), BEx Analyzer, BEx Browser, WAS 6.2, PL/SQL, Oracle 9i/8i/8x, Perl, XML, UNIX, Linux, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows XP/NT/2000/98, Kintana, Test director, Visio, Solution Manager, Visio, and MS office

Responsibilities:

• Involved in complete life cycle Implementation which includes gathering requirements, analysis, data modeling, design specification, development, data extraction, reporting, performance tuning, unit testing, trouble-shooting, integration and acceptance testing, documentation and maintenance
• Worked with several users to gather requirements and transformed them into a data model using extended star schema concept
• Developed various deliverables like Functional and Technical specs, Data mapping and Data flow documents, Gaap and Impact analysis documents
• Supported and performed various pre and post upgrade activities related to NW 2004s BI Upgrade
• Designed, developed and implemented new BI model using NW 2004s features like Transformations, end-routines, DTP, Data acquisition etc.
• Used NW 2004s BI Open Hub service to develop various spokes with Transformation and DTP
• Involved in the implementation of BI Accelerator and have good exposure to BIA index maintenance, BI Accelerator monitor and BIA TREX admin tool. Performed the activities like building, filling, dropping and monitoring the indexes in various environments throughout the landscape for the BI Accelerator implementation
• Worked with Kintana work bench and Test director for logging various ongoing issues and resolutions
• Involved in preparing Business Requirement Documents and checked Business Content to identify necessary Business Objects
• Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR), CATS, EM and LO (SD & MM) of R/3, and Sales analytics modules of SAP CRM. Worked on customization and enhanced the extract structure to support business needs for the Vendor analytics from the information captured from the system Ariba
• Designed and developed various Datatargets and Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using Admn workbench (RSA1)
• Developed Transfer Rules and Update rules to cleanse the data and enhance the master and transaction data using Formula Builder and start and transfer routines with ABAP4 to suit the business requirements
• Populated various data targets like Infoobjects ,ODS and Infocubes, with Master data and Transactional data from SAP R/3, SAP CRM, legacy systems and file interface via Data Staging area (PSA)
• Debugging the Extractor checker, Transfer rules and Update rules
• Worked with Datamarts, Myself source, Generate export Datasource and Replication
• Created Infopackages for Full, Initial, Early init, Delta and Full repair loads for both Master data and Transaction data
• Created process chains using various process to automate data loading, activation of ODS, compression, drop and create indexes, init fills, roll up, attribute change run and DBstats etc.,
• Extensively performed huge data loads into ODS and Infocubes
• Developed Queries to access data from various BW Infoproviders like ODS, Infocubes, Infoobjects, Multiproviders and Infosets using BEx query designer
• Created Jump queries (using RRI), Restricted Key Figures, Calculated key Figures, Filters, Conditions, Variables and Structures, Exceptions, Pre-calculation of Web templates & value sets using reporting agent.
• Analyzed, designed and developed Infospokes for both Master and Transaction data to support MDR (Master Data Repository)
• Created Hierarchies both internal and external. Populated them using file interface, R/3 and also updated them manually. Worked with Navigational attributes both time dependent and independent
• Created Generic Datasources using Database Views, Tables, Infoset queries and Function modules
• Involved in Performance tuning: Created Aggregates, Drop and Create Indexes for Infocubes, Buffering, Partitioning, DBSTATS, Compression, Delete PSAs and Temp tables to improve loading as wells as query performance. Worked with various transactions like RSRT, RSRV etc., for analyzing queries, cache and repairing various BW objects. Worked on Global work process overview to monitor the work process load and identify locks
• Worked with Technical content for loading the content from R* tables and analyzing the content to improve the system performance. Used various function modules to copy aggregates, delete logs etc.
• Collecting and Releasing transports (BW and BEx). Worked with basis, transport and security teams for space related issues, moving objects from development box to QA and Production and authorization issues etc. Production support (on call) by monitoring the massive process chains, trouble shooting the issues & fixing the errors
• Involved in an Upgrade project from BW 3.0 to BW 3.5 and performed the pre and post upgrade tasks

Senior SAP BW Consultant Confidential, Columbus, OH Oct 2004 – Mar 2005

Environment: BW 3.5, SAP R/3 versions (4.7 - ECC 5.0), Business Explorer (BEx), BEx Analyzer, BEx Browser, WAS 6.2, PL/SQL, Oracle 9i/8i/8x, Perl, XML, UNIX, Linux, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows XP/NT/2000/98, Kintana, Test director, Visio, Solution Manager and MS office

Responsibilities:

Enhanced the complete FI reporting structure to suit the new structure after the business was reorganized.Modified various infoProviders and data targets and converted the current data to match the new structure within a very tight time frame
Succesfully implemented FI/CO reporting solution.Installed, activated, implemented and enhanced various Business content objects for FI (GL/AP/AR), and MM of R/3. Worked on customization and enhanced the extract structure to support business needs
Worked on the Vendor analytics of SAP SRM (EBP) to support the reports like E-Procurement Account Assignment,Bid Invitations and Bids,Procurement Process–Single Documents,Purchase Contracts – Single Documents and Shopping Carts – Single Documents
Stabilized the extraction process by modifying the process chain and set up for error handling
Modified user exits of Master and transaction extractors, start and transfer routines both in update and transfer rules. Configured and Appended various extractors and used user exits to fill the appended fields.Formulated strategy for transports and made cut over plans. Handled different load, data and reporting issues on a need basis
Mentored the action learners on BW project

SAP BW Consultant Confidential, Philadelphia, PA Apr 2004 – Sep 2004

Environment: SAP BW 3.1, SAP CRM 4.0, SAP R/3 4.6C, BEx Analyzer, BEx Browser, WAS 6.2, SD, MM and FI modules, Oracle 8i/8x, ABAP4, IDOC, BAPI, ALE, User exits, TRFC, DDIC, Windows 2000/NT and Lotus notes

Responsibilities:

• Analyzed user requirements, finalized reporting structure, resource planning and cut over and project planning. Conducted workshops, created templates for testing and initiated user training. Identified users, roles, and formulated the realization strategy
• Identified key reports from business content. Installed and configured the extractors, Data sources, info sources, and info providers of Service analytics and Interaction center modules of SAP CRM. Extracted and loaded these objects with data from SAP CRM systems
• Reviewed the complete existing design, data modeling and the process chain design. Create the cutover plan and support plan. Formulate the restate strategy and made recommendations to modify the design wherever required

SAP BW Consultant Confidential, Syracuse, NY Jan 2002 – Mar 2004

Environment: SAP BW 3.0,2.1C, SAP R/3 versions (3.0 – 4.6), BEx Analyzer, MM, SD and FI modules, Oracle 8.0, Windows NT and Lotus notes

Responsibilities:

• Performed different activities for the upgrade from BW 2.0 to BW 3.0
• Changed read mode for the queries, improving the query performance.
• Monitored performance with statistics cubes; this analysis will be used for building aggregates.
• Used Init, Delta and Full repair Update process for loading the data to BW from R/3 in specific intervals
• Created Hierarchies both time dependent and time independent
• Developed strategies to reduce the initial set up time for extraction, data load procedures and processes to maximize automation of transactional and master data
• Extracted data from SAP R/3, Flat Files and Legacy Systems
• Developed various Generic DataSources on R/3 for both the Master data and Transactional data
• Designed and developed queries on various InfoProviders suitable for different business scenarios using BEx Analyzer
• Created various reports using Variables, Restricted Key figures and Calculated Key Figures
• Provided Drill-Down functionality in reporting

Mainframe Consultant Confidential, Santa Fe, NM Jun 1999 – Sep 2001
Mainframe Consultant Confidential, Concord, NH Jan 1996 – May 1999

Environment: IBM 3090, COBOL, CICS, DB2, VSAM, IMS, EASYTRIEVE, TSO/ISPF, JCL, MVS and Windows98

Responsibilities:

• Involved in the development phase in developing and reviewing the program specifications for both online and batch programs using the tool Visio. Involved in the development of online line and batch programs using Cobol II, CICS, Db2 and JCL. Involved in the unit testing of the developed programs using Tools Inertest, Expediter, RC update (Platinum) and File-aid
• Involved in converting the IDMS programs to DB2 using the tool REVIVE
• Involved in technical support and production support for the end user
• Involved in analyzing the service requests given by end user and fixing the production problems and data changes in the database and program changes for the existing systems
• Developed NETWISE structures and procedures to facilitate communication between Power builder and CICS to call Remote procedures