PROFILE SUMMARY

• Certified SAP Business Intelligence consultant with overall 9 years of experience in SAP BI 7.0/3.5 and SAP BO XI 3.1 environment.
• Involved in five end-to-end implementation projects, development and application support projects in various modules.
• Experience in application areas like SD, MM, FI, CO-PA and HR.
• Worked on projects from blueprinting to until go-live. Responsibilities include analyzing business requirements, reviewing functional specifications, performing gap analysis, mapping business requirements to high and low level design documents, technical specifications, development of backend and front-end objects, conducting all phases of testing, producing user training manual.
• Expert in designing, creating, maintaining Info-Cubes, ODS objects, Multi Providers, Info-Sources, Extract Structures, Transfer rules and Update rules/Transformations, Generic data sources and Process chains to automate loads.
• Worked on modeling techniques like logical partitioning, Dimensioning of cubes, pruning and Characteristic Compounding for master data info objects. Involved in different data extraction techniques like Open hub destination, DB/UD connect.
• Developed complex info object routines, Start Routine, End Routines, Info package routines, customer variable exits and user exits using ABAP.
• Created and maintained queries in BEx Query Designer and WAD for web reporting with Calculated and Restricted Key figures, Variables, Restrictions, Filters, Exceptions, Conditions, web templates and published in Portal using Iviews
• Experience in Performance Tuning- Improved data load and query performance by doing compression, aggregates, partitioning, Rollups, Reconstruction, Reorg step in process chains and SQL Trace. Involved in Business Content Installation
• Involved in Reconciliation of data between BW and R/3
• Responsible for Incident analysis and problem resolution, Change Requests, Request for Service, Unit Testing and Integration Testing and Regression Testing as part of Application Support.
• Designed, developed, modified and maintained Business Objects universe using Designer XI R3 for ad hoc and canned reports using source as SAP BEx queries.
• Development and maintenance of universes and WebI reports using exception aggregation techniques, universe creation, merge dimensions and Web broadcasting.
• Used contexts to resolve issues on WebIs.
• Creating customized Prompts and filters as per the user requirement in WebI.
• Good understanding on developing Crystal Reports and Xcelsius dash boards.
• Experience in developing ABAP Reports, Data Dictionary objects, RFC, Scripts, Smart forms, BAPI, RFC and module pool programs
• Worked on Performance tuning techniques in R/3
• She has strong analytical ability, problem solving skills, troubleshooting and debugging skills.

EDUCATION

• Masters Degree in Computer Applications

TRAININGS / CERTIFICATIONS / RECOGNITIONS

• Trained in SAP BI by SAP AG Germany
• Trained in SAP BO XI 3.1 by SAP Germany
• Certified SAP BI Consultant 7.0
• Pat-On-Back Award by Satyam Computer Services Ltd
• E-Awards for Outstanding Efforts by Hewlett-Packard

TECHNICAL SKILLS

• Technologies – SAP BI 7.0, SAP BW 3.5, SAP BO XI 3.1
• Tools – Mercury Test Director, HP Quality Centre
• Case Tools – HP Service Centre, Lotus Notes
• Languages – ABAP/4, C, C++, Java, SQL
• Databases – Oracle 9i, Ms SQL Server 2005, Ms Access

PROJECT EXPERIENCE

Confidential, Atlanta, GA Aug 2010 – Nov 2011
Title: Sr. BIBO Consultant
Project: NABIResponsibilities:

• Work includes main focus on developing POC’s for proposed solution to client, interfacing CCR master and transaction data from .CSV files, deriving orgunit attributes, build combined hierarchy with help of Open Hub Destination and identify hybrid employee.
• Enhanced master data attribute extractors in R/3 to maintain reference key relationship between CCR master data and data coming from R/3
• The transaction data is integrated by loading CCR files into new infocubes and existing multiprovider with translations and transformations routines.
• Load balance techniques PSA maintenance techniques, data load repairing using debugging transformations, creating events for parallel loading, compress master data by using Reorganize master data attributes and text in process chains.
• Batch scheduling techniques to ensure proper sequence of daily process chains loads for master data. Efficiently performed pre-cutover, cut-over and post cut-over activities.
• She was part of a BW team responsible for development and maintenance of Bex queries, SAP universes and WebI reports. Designed, developed, modified and maintained Business Objects universe using Designer XI R3 for ad hoc and canned reports.. Main focus on improving the current BW architecture for query performance by leveraging techniques like logical partitioning, physical partitioning, building secondary indexes etc.

Environment: SAP BI 7.0, ECC 6.0, ABAP/4, BEx, HR, Solution Manager and BO XI 3.1/ 3.2.

Confidential, Atlanta, GA Apr 2009 – Jul 2010
Title: Sr. BI Consultant
Project: PTMSResponsibilities:

• Implemented new solution for the monthly Asset Tax loads in PTMS (Property Tax Management System) application.
• Participated in discussions & meetings with PTMS team to understand the Data flow to be fed to BI system from R/3 and gathered the business requirement to prepare the logical design document and developed POC.
• Prepared technical specs for ETL, Front end changes, estimation of efforts required for new CRs and getting them approved to start the new developments.
• Performance optimization of the R/3 programs to pull the delta Master Asset data using new and modified Master delta FI tables for audit reporting.
• Created Generic Extractor using function module. Generated Data Sources and Extracted Data into Info objects, ODS’s, Cubes, Multiproviders and process chains.
• Loaded Non-SAP assets from JDE flat file data into Master data info objects in BW for property tax returns.
• Created Transformations and customized by adding routines and formulas. Developed start routines and end routine by lookup into Master Data to maintain one - many relationship between SAP Customers and JDE customers.
• Developed BEx reports Assets List, Location Lists and TAX jurisdiction code validation reports. Provided support in the production environment.

Environment: SAP BI 7.0, ECC 6.0, ABAP/4, BEx and FI.

Confidential, Atlanta, GA Jul 2007 – Mar 2009
Title: Sr. BI Consultant
Project: BI Development and Application SupportResponsibilities:

• Responsible for development and maintenance of various applications such as MEM, P2P, BCS, TAX, Prorata, MCP and HR in BW/BI environment.
• Daily activities included monitoring queue for open incidents, analysis of issues, development, testing and closing of tickets with priorities as per SLA
• Worked on new RFS’s (Request for Service) with research and analysis.
• Provided long-term solutions for Problem tickets which are long pending recurring issues by doing RCA Root Cause Analysis (RCA).
• Extensively worked on field level routines, formulas in transformations, start, end routines and custom extractors. Adding variables restricted and calculated key figures, formula variables in the Bex reports and modified WAD reports.
• Enhanced an interface for Asset Master Data load in R/3. Upload legacy logical file supplied by JDE to populate ACN data into PTMS database based on time stamp.
• Involved in enhancement of Prorata application and modified Preprocessor and LHRH reports with YTD information, total consumptions days using variable exits.
• Reconciliation process between R/3 and BW for different loads
• Actively involved in rectification of Load Failure errors like master and transaction data Loads. Data loading was monitored and the failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded.
• Involved in all phases of testing including regression testing by end of every month.

Environment: SAP BI 7.0, ECC 6.0, ABAP/4, BEx, MEM, P2P and HR

Confidential, Santa Clara, CA Jul 2005 – June 2007
Title: BI/ABAP Consultant
Project: BI DevelopmentResponsibilities:

• Involved in development of Defects and enhancement CRs in finance and logistics modules. Responsible for business analysis and negotiating the requirements, design, development, functional and technical spec, code reviews, prepare test cases, all phases of testing and documentation
• Developing ABAP reports, function modules and Data Dictionary objects such as tables, secondary indexes, views, structures, lock objects in BW environment.
• Involved in enhancing MCARS (Metrics Collection and Reporting system) application. It basically incorporated realignment of service area function in the line of business using module pool programming. Modified billing and performance metrics reports with custom exit variables.
• Involved in logical design and development for MRP Forward Looking WOS Report in CPS application. Written complex ABAP logics in start and end routines for average week MRP quantities, adjustment of Fiscal week in accordance with inventory level.
• Developed an ABAP report to display inactive objects for BW cleanup activities.
• Extensively worked on Routines, generic data sources, variable exits and Performance tuning of reports, interfaces, R/3 extractors, function modules.

Environment: SAP BI 7.0, SAP R/3 4.6c, ABAP/4, BEx, SD and FI

Confidential, Indianapolis, IN Oct 2004 – Jun 2005
Title: SAP BW / ABAP Consultant
Project: BI Development

• Responsible for the data extractions from R/3 and external systems to BW for Logistics and FI
• Using Open Hub Service created Info Spoke to load data from Info Cube to a flat file.
• Optimized the load performance by adjusting the packet sizes, data selections and number of InfoPackages.
• Involved in performance tuning aspects like for better query performance created Indexes for Info Provider & created Multi Provider.
• Involved defining queries, changing layouts for formatting reports and saving various queries, workbooks.
• Creating Trouble Tickets and Change Requests, Assigning & salving Problems in Production warranty.

Environment: SAP BI 3.5, SAP R/3 4.6c, ABAP/4 and BEx

Confidential, Santa Clara, CA Dec 2002 – Sep 2004
Title: ABAP Consultant
Project: Magellan GPSResponsibilities:

• Developed a complete interface cycle for Internet sales activities. The interface would upload internet customer, upload Sales Orders, and create Equipment Number using BAPIsanda deletion program for periodically deleting the file.
• Developed an Interface program to create a material document for goods receipt.
• Developed smart form for printing invoice for the customer.
• Developed Smart Form version of Jet form output for Delivery Note
• Developed an ALV report to display the Dispatch Report day-wise for entire month.
• Implemented a BADI, which has additional field to include National Insurance Number for Vendor in XK01 transaction.
• Developed a BDC program to create vendor material info master data using the transaction ME11.

Environment: SAP R/3 4.6, ABAP/4, MM, SD and FI.