Summary:

• 8 years of Experience in SAP BI/BW and SAP-BOBI 4.0/ XI 3.1/3.0/R2/6.5 with 2 full life cycle implementations. Expertise in Backend (Modeling/Designing, Transformations, Extraction) and Frontend (Report designing).
• Expert in following SAP ASAP Methodology and understanding Best Practices.
• Experience in creation of BW/BI Components Info cube, ODS/DSO, Infosource, Multiprovider, Infoset, Info objects, process chains, DTP, Transformations.
• Experience in SAP BO Universe designing and Reporting (WEBI, DESKI, Crystal) based on OLAP and OLTP Systems (SAP BW/BI).
• Experience XCELSIUS/ Dashboard Design Tool to develop the dashboards using LIVE OFFICE, QAAWS, and BIWS Data connections.
• Knowledge on HANA (Learning).
• Extensive knowledge of SAP BI 7.0 integration with BusinessObjects Enterprise.
• Experience on and BO OLAP Analysis tools - Web Intelligence, Dashboard Design Tool (SAP BOBI 4.0)/Xcelsius 2008 (Dashboard), Live Office, Information Design Tool (SAP BOBI 4.0)/Universe Designer, BI Launch Pad (SAP BOBI 4.0)/InfoView.
• Experience in writing Functional, Technical Specifications and designed dimensional models by using Start Schema Data model.
• Experience on QM, DM, SD, MM, FICO functional Modules.
• Experience on data extractions of CO-PA, LO, Generic and Business Content Extractions.
• Experience on writing transformations (Transfer rules, Updated Rules, End Routine and Expert Routines) and User Exits using ABAP programming.
• Experience on process chains designing, scheduling and modifications using and monitoring full and delta loads.
• Experience on BEx Analyzer, BEx Browser, WAD (Web Application Designer), Designing BEx Queries, Calculated and Restricted Key Figures, Variable, workbooks, Profiles and Roles.
• Experience on BO Universe: Identifying Joins, Cordiality, Loops and Resolving them using Aliases and Context, Creating Cascading Prompts, Hierarchies and @Functions.
• Experience on BO Reporting: Web Intelligence, Desk Top Intelligence, Crystal Reports, Ad-Hoc and Canned Reports. Experience on different functionalities like Master Detailed/ Section, Break, Input control, Data Tracking, Report filter and query filters, Drill Down, Ranking, Sections and Charts/ Graphs, Hyperlinks.
• Experience on performance tuning in BW, BO. BW: Design Aggregates, Compression, Partition and Indexing on Info cubes. BO: using @ Functions, identifying and resolving loops, Joins, Cordialities.
• Report scheduling, Event Creation, Busting/Publication Program to Schedule Reports to run on periodic bases in SAP BO.
• Experience on Unit, UAT and Regression Testing.
• Experience in conducting Training for End-users, Project Team Members and preparation of Best Practices. .
• Excellent Analytical & problem solving skills, can work effectively an individual and team environment.
• Excellent Team player and can handle projects independently.
• Good communication skills and presentation skills.

Education:

• M.C.A (Masters in Computer Applications)

Technical Skills:

Tools:

Business Objects (4.0/XI 3.1/XI 3.0/XIR2/XIR3/6.5), Universe Designer/Information Design Tool, Info view/ BI Launch Pad, Desktop Intelligence, Web Intelligence, Crystal Reports, CMC, CCM, Crystal Reports, Xcelsius / Dashboard Design Tool.

ERP:

SAP ECC,BW/BI,HANA

Functionalities:

Master/Detail, Slice and Dice, Drill up/down, Conditions, Filters, Charts, Alerts, LOV, Context, Aliases, Universes, Reports, @Functions, Formulas, Scheduling, Cross tab, Joins, Data Tracking.

Database :

Oracle, MS SQL Server 2000/2005, DB2,MS Access

Languages:

C,C++,SQL, PL/SQL, Java

Operating Systems:

Windows 95/98/2000/XP/NT, MS DOS and Unix.

Packages:

MS-Office

Professional Experience:

Confidential, US
Sr. Software Developer Apr 11 Till Date

• Working with End Users and Functional Team.
• Working on Functional and Technical Specs designing.
• Working on SAP-BI extractions, Generic, Standard Extraction and working on Standard Extraction Enchantments.
• Working on standard extraction to extract ISU Device master.
• Working on working on Custom extractions to extract inspection test results of Meter and MTU’s because we have the reports that is going to show the data for each characteristic levels (Lot Characteristics).
• Working on Custom/ Generic extraction to pull the meter status data which is available in a Z-Table.
• Working on Custom/ Generic extraction to pull the data from EGLO Table after identifying the PMC Meters.
• Working on Info cube, DSO, Multiprovider and Info Object Creations.
• Working on performance increase techniques like Aggregate creations, Info Cube compression and indexing.
• Working on designing BEx queries using CKF, RKF and variables.
• Working on Universe Designing based on SAP BI (Cubes, BEx queries).
• Working on WEBI reports for meter and MTU statutes data that is used to keep track of number of meters currently in premise and removed this year, Inspection results of Meter and MTU, Yearly Reports, PMC (Planned Meter Change Reports).
• Working on meter removal reason codes to classify all the removed meters into buckets to show the count of all the removals, this helped the management to decide which meter families to be removed from service.
• Working on WEBI Reports for Meter and MTU Performance data (QM Data).
• Working on WEBI Reports for Planed Meter Change (PMC).
• Developed SAP BOBI 4.0 Universe and WEBI Reports for PMO’s using Information design tool.
• Experience on writing SQL queries and creating derived tables.
• Developed SAP BOBI 4.0 WEBI reports on project status data to know the each project financial status, each release performance like how many Tasks, Risk for each release and work group.
• Worked on LCM ( Life Cycle Management) to migrate the objects from DEV to QA to PROD.
• Developed XCELSIUS dashboard for the top management to analyze the meter data and performance data (Test Results), the dashboard contains the meters installed in individual Region and District, all the removals by family, region and district. Also has a tab for all the planned meter changes for next year.
• Developed XCELSIUS dashboard using XELSIUS DASHBOARD DESIGNER (SAP BOBI 4.0) for the PMO’s to analyze each project status, performance of the each release like Number of Tasks, Issues and risks by priority and groups. Each project financial status for labor and non-labor planned and Actual amounts.

Environment: SAP BI 7.0, SAP BOBI 4.0, 3.1, SAP ECC 6.0, SQL 2008, Crystal Reports, DM, QM, Xcelsius2008 and Dashboard Design Tool.

Confidential, WV
SAP Consultant Sep 10 to April 11

Responsibilities:

• Involved in project plan preparation and systems (Landscape) designing.
• Interacted with Users and Business Analysts in gathering requirements and translate them to Technical specifications.
• Involved in preparation of project plan and installation of software’s.
• Worked on developing universes based on SAP BW/BI BEx queries, Info cubes.
• Worked on developing WEBI, Crystal Reports for Sales and Distribution (SD), Finance and Control (FICO), Production and Planning Modules.
• Worked on Crystal Reports using formulas, Grouping, Parameters, Hyperlinks, Sub Reports, Running Totals and Hierarchies to handle the end user requests.
• Worked on publication to scheduled reports to run on a periodic basis.
• Worked on XCELSIUS Dashboard development using QAAWSon Production Lead Time data to know the Actual and Target Lead times for each MRP Control and Material Groups by Yearly and Monthly.
• Worked on Days overdue analysis dashboard.
• Used CMC to Import BW roles into BOE, create new Users, Groups, andFolders and assign them appropriate Log In and access rights depending on their Profiles ( As per BW Roles).
• Documented use cases, Best Practices and involved in Unit Testing.

Environment: SAP BI 7.0, Business Objects XI 3.1, SAP ECC 6.0,Webi, Crystal 2008, Xcelsius 2008, Live Office.

Confidential, TN Apr 10 to Sep 10
Programmer Analyst

Responsibilities:

• Experience working with Users and Business Analysis in gathering requirements and translate them to Functional and Technical specifications.
• Designed and developed Universes based on DB2.
• Worked on Identifying Joins, Cardinality, Loops, Resolved loops using Context and Alias methods, created derived tables, used @ functions.
• Worked on WEBI Reports development, Cascading Prompts, Prompts (Optional and Mandatory), alerts, hierarchies and Merge dimensions.
• Designed and developed a set of Crystal Reports on DB2 database. Reports developed include Drill-Downs, Hyper linking reports, formulas, Grouping, Multiple-Grouping, Cross Tabs, Running Totals, and Conditional suppressing formulae, Sorting, Sub-Reports and Parameters.
• Worked on WEBI, Crystal reports (Canned and Ad-hoc reports) to know the VIN deficiency, Title Registrations, Renewals and Back Room reports.
• Set security rights for objects at row/column level, created custom, hierarchical List of Values (LOV’s) and stored onto the Repository. Developed both Static and Dynamic Dashboards like trend analysis, alerts, drill downs and charts like Line Charts, Area Charts and Column Charts, using Xcelsius 2008.Used QaaWS and LiveOffice.
• Experience on Import wizard to migrate the objects from DEV to QA to PROD.
• Extensively worked in different Environments of State of Tennessee like DEV, UAT and CNV. Working extensively in handling different tasks like report development, publishing and scheduling, migrating and documenting and fixing the production issues.
• Responsible in trouble-shooting, Knowledge transfer to Business-users and trained them on various Crystal/Business Objects Enterprise features.

Environment: IBM Mainframes, DB2 9.2, TOAD 4.6, SQL, PL/SQL, Business Objects Enterprise XI 3.0/3.1 Crystal Reports 2008, Xcelsius 2008 SP3, Live Office, QaaWS, Windows NT.

Confidential, CA Feb 10 to Apr 10
Sr.BusinessObjects Developer

Responsibilities:

• Met with Users and Analyst team to gather requirement and documented technical specifications.
• Designed, Developed and MaintainedUniverses by defining joins cardinalities between tables applying contexts andalias tables to remove Loops/cyclic dependencies.
• Checked the Integrity of the Universes/ Linked Universes and exported the Universes to Repository for making available to users.
• Reports were formatted according to the user requirements using Business Object functionalities like Queries, Slice and Dice, Drill Down, @Functions and Formulas etc.
• Created Master Detail and Cross Tab reports to view the data in an organized manner.
• Created templates for standardizing the structure of corporate documents.
• Organized data in the reports inserting Filters, Sorting, Ranking and highlighting data using Alerts.
• Worked with Hierarchical grouping and drill down reports to analyze the data at micro level.
• Worked on WEBI and Crystal Reports (Ad-hoc, Canned Reports) and Merge Dimensions on lab data, when the lab test was happened, in which building, how many sample did they test and etc.,
• Involved in Unit and UAT Testing, Documented Test cases.

Environment: Business Objects XI 3.1 WebI, Designer, Infoview, Oracle 9i.

Confidential, VA Dec 09 to Feb 10
Sr. Business Objects Developer

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications and uploaded to Share point portal.
• Developed universe based on DB2, Oracle.
• Extensively used Web Intelligence, Crystal Reports to develop reports to know IVR system performance Data.
• Created different types of reports such as Aging, Master/detail, Cross Tab, Ad-hoc, canned andCharts.
• Involved in Unit Testing and documented test cases.

Environment: Business Objects XI 3.1(Deski, WebI), Designer, Infoview, Crystal Reports, Oracle 10g, TeraData, DB2.

Confidential, IN Jan 08 to Nov 09 Lead

Responsibilities:

• Interacted with Business Users and Business Analysts to gather and document the Requirements and translate these to Technical specifications.
• Worked as a lead and Involved in Requirement gathering, Development, Test and Go-live phases and interacted with end users and Maintain two separate teams one is on SAP BO and Second one was SAP BW Production support.
• SAP BW Production support team was working from Offshore.
• Created severalUniversesusing Designer according to the Requirement based on SAP-BW 3.5 and Oracle.
• Experience on Webi Reports, Crystal Reports and Xcelsius Dashboards on SAP BW.
• Updated andmaintained existing Universes based on changing user requirements and based on changes in data source.
• Implemented cascading prompts, Row and Coolum level securities.
• Created new classes, objectsandmade structural changes to Universes/ Metric Universes in Designer which includes adding new objects, updating tables and joins.
• Involved in performance tuningandoptimization on Business objects Universes by creating Aggregate tables.
• Improved the performance with the use of @functions (@aggregate aware, @select, @prompt, @where).
• Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master Detail and Formulas etc.
• Involved in CMC (Security Administration) and User administration.
• Developed xcelsius dashboard for sales, purchase and finance data.
• Documented all the changes made to the Universes and Reports for future references.

Production support Lead

• Process chains Monitoring, Scheduling, Creation, and Modification.
• Worked on remedy tool for Ticket tracking.
• Monitoring of Infocubes, DSO Objects requests, PSA, Info packages and analyzing the reasons for frequent failures of Info packages.
• For scheduling the process chains we used REDWOOD Product CRONACLE.
• Interacted with Basis People for connection issues with Cornacle and BWP.
• Extensive working knowledge in fixing the errors.

Environment: Business Objects XI 3.0/R2 (Deski, WebI), Designer, Infoview, Crystal Reports 2008, SAP BW 3.5, SAP ECC 6.0,Oracle 10g, Xcelsius 2008.

Confidential,India
SAP BW Consultant Aug 06 to Dec 07
Responsibilities:

• Experience on Writing Technical and Functional Specifications.
• Experience on Analysis, design, development of Infocubes, ODS, Multiproviders and Infoset objects.
• Experience on creation of Infoobjects, writing transfer rules, update rules and Creation of Infopackages.
• Experience on replicating the datasources into BW systems and making Metadata related to the datasources available in BI.
• Experience on info cubes to analyze the accounts receivable transaction figures and line items for the customers.
• Experience on using ODS objects to stage the data before transferring the ODS object contents to the Info Cube.
• Experience on performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes and use of statistics for the same
• Experience on Enhancing the Cubes by adding custom Info Objects to reflect modified R/3 Business Process.
• Experience on Data Modeling which includes installing Business Content; creating InfoObjects, InfoCubes, DSO Data Store Objects, Transformations, DTP Data Transfer Process, Info Packages, DataSources, Process Chains, and Source Systems.
• Experience on writing transformation rules to load the data into cubes from DSO as per the business requirements.
• Worked on business content, LO extractions to load Master and Transactional data from ECC to BW Systems.
• Worked extensively on Finance, Sales and Distribution and Material Management Modules as a part of reporting.
• Extracted data from SD modules and uploaded the data into the cubes via 2LIS_11_VAHDR, 2LIS_11_VAITM, and 2LIS_02_VASCL and the data was extracted from various SD tables likeVBAK, VBAP, LIKP, LIPS, VBRK, VBRP, etc.
• Created Sales and Delivery, Billing InfoCubes OSD_C01 and OSD_C03 for sales overview.
• Experience on creating doing the enhancement to standard datasources as per business requirement.
• Experience on creation of process chains to load the data into the data targets and process chain scheduling.
• Worked on FI-AP Business content and installed Line item and transaction data cubes (0FIAP_C03, 0FIAP_C02) from Data sources (0FI_AP_4, FI_AP_1) respectively.
• Involved in identifying the data sources like 0FI_GL_4, 0IF_AR_3 and enhanced according to the user requirements.
• Worked on MM and installed 0VENDER_ATTR, 0VENDER_TEXT, Purchasing group 2LIS_02_S011 and etc.
• Experience on the production support and project enchantments.
• Experience on conditional and exception reporting.
• Experience on working on BEx designer to building Queries and saving in Workbooks (Excel work sheets) and created Custom Queries using Conditions, calculated key figures, restricted key figures, Exceptions, Variables & Structures.
• Transported BW Objects developed in Development System by creating Transport requests on Transport Connection of Data Warehousing Workbench, Released the Workbench Requests in SE10and imported into Quality and Production by using STMS.
• Experience on creation of openhub services, RRI (Report to report interface) and DB connect.
• Created queries, reports, Workbooks and web-reports on Bex Analyzer and posting of reports on the web/portal with drill down and execution capabilities.
• Trained users on using BEx reports and explained the functionality of BEx features.
• Monitoring of Infocubes, ODS, Objects requests, PSA, Info packages and analyzing the reasons for regular failure.
• Process chains Monitoring, Scheduling, Creation, and Modification

Environment: SAP BI 7.0, ECC 6.0, SD, MM, FICO,

Confidential,India
SAP BW Consultant Oct 05 July 06

Responsibilities:

• Done a full life cycle implementation from gathering the requirements, analysis, preparation of blue prints, designing, and coding, testing and post productions supports.
• Experience on SAP ASAP methodology (Project Plant, Blue Print, Development, Testing and Go-live).
• Experience on designing Infocube, ODS, Multipoviders, Infoobjects, designed Dimensions in InfoCubes, Partitioned InfoCube by 0CALYEAR.
• Expert in data loading from Data Staging PAS, ODS, Infocube and Designed Transformations between DSO objects and InfoCube.
• Worked on FI-AP Business content and installed Line item and transaction data cubes (0FIAP_C03, 0FIAP_C02) from Data sources (0FI_AP_4, FI_AP_1) respectively.
• Extracted the data (Delta Load) using extractor (LO, COPA Extraction) 2LIS_12_VCSCL (Sales-Shipping: Schedule Line Delivery), 2LIS_13_VDITM (Billing Document Data: Items), 2LIS_11_VAITM (Sales Order Item Data), 2LIS_03_BF for material movement, 0PUR_C01 Purchasing to Data Targets in BW and enhanced the data source with required fields.
• Created new infocubes as per client ZSD_CQ01, ZSD_CQ02 Cubes.
• Designed and executed queries in the BEx with calculated and restricted key figures, variables, structures, exceptions, conditions and RRI features.
• Created Web templates using Web Application Designer (WAD).
• Query performance improvement and monitoring using aggregates and RSRT transaction.
• Worked with security people to create new Roles for BW.
• Involved in Transport Request, Developed technical specifications, worked on RRI, web reporting.

Environment: SAP BW 3.1c, SAPR/3 4.6C, SD, FICO.

Confidential, India
SAP BW Consultant Sep 04 Sep 05

Responsibilities:

• As a BW consultant I have involved in full life cycle implementation. As per ASAP methodology (project preparation, Blue print, Analyzed the requirements, designing, Development and go_ live).
• Involved in Data Modeling, Extractions, creation of Open Hub services, lodes the data from flat file.
• Created Process chains for back ground process and effective scheduling of various processes.
• Involved in creation of RRI (Report to Report interface), Multi providers and infocube partition for increase performance.
• Customized Infocube created for SD modules, standard business content install and data loading extracted the data (Delta Load) using extractor (LO Extraction) 2LIS_12_VCSCL (Sales-Shipping: Schedule Line Delivery), 2LIS_13_VDITM (Billing Document Data: Items), 2LIS_11_VAITM (Sales Order Item Data).
• Created a generic Data Source structure to extract data from Custom tables.
• Modified the User exit programs to accommodate the additional fields in the SAP data extract structure of the data source and User profile maintenance.
• Developed ABAP/4 routines for data manipulation in Transfer / Update rules, Involved in Userexits creations.
• Used different types of methods to extract the data from SAP R/3 those LO, Generic, Business Content Extractors and loaded data into SAP BW.
• Data Loading, Job Scheduling, Data Modeling for new customized info cube.
• Created Bex Report and Work Book and Supporting the BW system.
• Modified InfoObjects, InfoCubes and Designed, developed and modified InfoObjects, InfoCubes, ODS Objects, InfoProviders, InfoSources, Transfer rules, Update rules.

Environment: SAP BW3.5, SAPR/3 4.6C, SD, ABAP