SUMMARY:

• Around 7+ years of experience with 3 full life cycles in SAP BI/BW in back end modeling and front end development.
• Nearly 5years of experience in Modeling, 4years of experience in Extraction from ERP, Non SAP Systems, 4 years of Experience in Report Development.
• Experience with BI/BW components including Info Cubes, DSO’s (ODS), Transformations, DTP’s, Info sources, BI content, Info objects among others.
• Daily meetings have been setup with the end users for designing the reports and extensively trained the client on BI 7.0 & BEx Analyzer.
• Analyzed the business requirements and translated into dimensional data models by using extended star schema techniques
• Involved in business process modeling (business goals, objectives, capabilities, processes, organization structure, risks, principles, constraints, etc)
• Excellent cross-functional experience in SD, MM and FI/CO modules.
• Extensively involved in the data extraction of CO-PA, LO, Generic (View, FM, Info set Query) and non-SAP data into SAP BW server.
• Strong experience in working (design, code, test) with custom extractors (using function modules).
• Good knowledge in extending the Business content based on requirements.
• Performed data load management, CTS, experience also in scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full/Delta Up-Load), Monitoring, Remote Cubes, MultiCubes, Data Mart and Open Hub Service.
• Expertise in BW performance tuning: Experience in performance tuning of Queries by maintaining Aggregates, Compression, partition, Process chains, indexing of info cubes and use of statistics for the same. Extensively used variety of techniques to boost the performance of BEx Query.
• BW reporting using BEx Analyzer, BEx Browser, Web Application Designer, and implementing BEx Queries, Calculated and Restricted Key figures, variables, workbooks, security roles and profiles.
• Interacted with users for their feedback for creating reports.
• Developed flexible queries using filters, navigational attributes, variables, in Bex analyzer to facilitate data analysis in a drill down or summarized way to give detail level of information.
• Ability to connect the SAP R/3 and other legacy systems as source systems to SAP BW.
• Customized the postproduction data model and generated Adhoc queries as per the specifications.
• Done implementations using SAP ASAP methodology and through understanding of SAP Best Practices.
• Strong analytical, problem solving, gap analysis, blue printing and debugging skills.
• Strong written and oral communication skills
• Efficiently managed teams of various sizes and worked with the team to achieve company and client’s goals.

TECHNICAL SKILLS:

BI 7.0, BW 3.5, 3.1C, 3.0B, 3.0A, 2.1C, 2.0B.

ERP:

ECC 6.0,ECC 5.0, 4.7, 4.6C,

Front Ends:

BEx Analyzer, Web Application Designer, Net weaver, Crystal Reports (BO),SAP BOXI R3

Languages:

ABAP/4, JAVA, SQL, PL/SQL

Operating Systems:

UNIX, Windows95/98/2000/NT, XP

Scripting Languages:

JavaScript, HTML, DHTML

EDUCATIONAL QUALIFICATIONS:

• Bachelor of Science in Engineering

PROFESSIONAL EXPERIENCE:

Client: Confidential, Austin, TX April 2011 Present

Role: Sr. SAP BI Consultant

Environment: SAP R/3, BW 3.5, 7.0, MM, SD, FI, ABAP, BEx Analyzer.

Responsibilities:

• Responsible for requirement gathering and analysis of the business requirement that could be satisfied with SAP business content and created the necessary objects required.
• Worked on building the technical specifications for the requirements from the client.
• Worked on the MM module for extracting the data by using the custom data sources for the details analysis of the reports like PO line item report and summary reports.
• Developed the custom DSO\'s like goods receipt line items, purchase document line items and PO line item details and used the standard and custom info objects.
• Worked on the enhancement of the GR/IR line item extractor and EDW purchase document item extractor for including the necessary fields from the standard tables like EKPO and EKKO and populated the fields by modifying the ABAP code for satisfying the requirement.
• Worked on the code in the functional module of the extractor to solve the issue related to the values populating in the field used in the SA Summary report.
• Created and modified the necessary transfer rules, update rules and transformations between the DSO\'s and worked on the start routines and end routines in order to modify the data as per the requirement.
• Loaded the data into BI, using info packages by initializing the Full and Delta process. Loaded the data from flat files into BI system. Created DTPs and Error DTPs in BI to load and monitor the data into info providers.
• Worked on the reconciliation to check the data accuracy by comparing the data in ECC and BW.
• Analyzed the errors that occurred during the data loading and solved the issues for that occurred during the activation process of the objects.
• Performed the unit testing after the data has been loaded into the development and released the transports into the Quality after the success of the unit testing.
• Involved in transport collection and release of transports from Quality to production and worked with the basis team for successful release of the transports.
• Involved in solving the tickets in the production depending upon the priority level allotted.
• Worked on monitoring of the process chains, analyzed and solved the frequently occurred errors.
• Worked on the Query designer for building the queries and generated the PO/ SA detail line report and PO/SA summary reports and embedded them into the workbooks.
• Worked on the performance tuning the queries by maintaining aggregates, indexes and compression on Info cubes.
• Fulfilled the reporting requirements by developing the reports with the drill down facility for the Goods receipt quality detail analysis report and summary report after adding the necessary info objects.
• Enhanced the Purchasing 12 month carryover operational analysis report and customer directed supplier SA Detail line report by adding the info objects as per the requirement.
• Modified the Purchasing MPV finance Analysis and MPV operational and purchasing MPV management reports by adding the variables, restricted key figures and calculated key figures for the queries.
• Worked on the total payment term analysis report and sales summary report for populating the missing data in the fields.
• Reviewed all the reports and carried out the necessary modifications as per the requirement and also as per the convenience of the end user.
• Interacted with the end user and solved the issues that occurred during the end user testing and supported the team for releasing into the production successfully.

Client: Confidential,Harrisburg, PA March 2009 April 2011

Role: Sr. SAP BI Technical Consultant

Environment: SAP ECC 6.0, SAP BI 7.0.1, Business Objects BOXI, Business Explorer, Web Application Designer (WAD).

Developed Blueprint documents for data warehouse needed for the State Financial and Purchasing Operations. Involved in Software procurement for Front end reporting purposes. Involved End-to-End Implementation of Proposed Data warehouse solution. Developed Cubes and built reports for Business Requirements.

Business intelligence:

• Activated business content in both 3.5 and 7.0 data flow for Master data and Transaction data. Used Ehp3 content in the areas like Check Register to enable reporting on PAYR tables. UsedEHP3 content for AP, AR and GL areas.
• Activated data sources in ECC, CRM, SRM and LO cockpit scenarios. Created full, Init and Delta loads from Source systems.
• Created generic data sources from views, function modules on Custom tables and Data domains.
• Used efficient methods like Function modules instead of user exits for Custom enhancements to data sources.
• Extracted and built hierarchies like Financial Statement items, cost centers, Material and Product and enabled reporting on them in the latest front end tools like Crystal reports using text and hierarchy variables.
• Developed a custom info cubes for material movement (quantity and value) like Goods receipts, returns and consignment stocks (vendor managed inventories and customer managed inventories) based on plant, storage location, material, material group, vendor and customer.
• Created complex data modeling structures using Start routines from multiple DSOs into single DSO. Used efficient methods like sort and binary search and updated into each individual characteristics using routines without accessing internal tables redundantly.
• Created crosswalk between AR and GL DSOs and enabled revenue source reporting.
• Created custom ODS to enable Grant CMIA reporting by enhancements from AP. AR and GL modules.
• Created budget report having Fund, Grant dimensions with aggregated and detail levels.
• Build Custom cubes for Department of Transportation and Development (DOTD), on Road, Bridge, Projects, LETS/STIP Data in PS module.
• Developed Transfer /Update Rules and ABAP user exits for transaction and master data.
• Created reports out of Custom PS Cubes like Project VS Fed Funding, DOTD Contingent liability Report, HPP Projects Let by Parishes, DOTD Accrued Unbilled Report, FHWA Reporting on Z-Tables, Highway Priority Program in Crystal Reports.
• Designed and implemented a reporting solution for web reporting, information broadcasting, pre-calculated web templates and background scheduling.
• Designed process chains for scheduled loads and enabled batch processing for various administration activities in the data ware housing system.
• Implemented best practices of SAP to improve performance of loading and reporting. Created aggregates for cubes and created Secondary indices in ODSs and updated DB statistics cube. Analyzed BW statistics for optimization of data loads and report performance during production support.
• Developed several reports on BP module such as Commitment and Actuals, Trial Balance By Fund And Fund Type, DOTD Accrued Unbilled Report, Revenue/Expense vs. Budget Report, Budget Amendments with Long Text, Revenue/Expense vs. Budget Report, break-down Grants (Rev & Exp) budget at Program-Activity etc,
• Developed Reports for Agencies, Departments for Capital Projects, Quarterly report Performance at Pgm-Activity and reported on Ranking process, key performance Indicators.
• Worked on Data Conversions from legacy systems called BRASS, BDS, Ecourts, NCourts of Capital outlay and Operating Budget.
• Worked on HR payroll on both custom and business content data targets
• Implemented Cubes on Personnel Administration, Organizational Management, Personnel Development, Benefits, Travel Management, Cross Application Time sheet, Personnel Time Management, Payroll and PE-LSO.
• Built HR reports with various time dependent hierarchies.
• Worked on Roll up structures of Organization Management
• Involved in custom changes of Payroll data and Posting documents datasource

Business Objects:

• Full life cycle Implementation of Business objects was carried out successfully and integrated with SAP BI, by installing and configuring the SAP Integration Kit.
• Involved in the installation of Business Objects repository, creation of user Ids, implementation of security features and management of the repository.
• Involved in Scheduling and publishing reports in Crystal Enterprise Environment/ Business Objects Enterprise XI R3 Environment.
• Created formulas and store procedure and different Alerts based on the conditions.
• Developed advanced Xcelsius objects on concepts like What If Analysis, Dynamic Visibility, narratives, interactive charts, hierarchies.
• Created folders and user groups and applied security access restrictions as per the user roles through CMC. Integrated Crystal Xcelsius 2008 with Business Objects Enterprise XI 3.1.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOVs List of Values.
• Developed Ad hoc reports using Business Objects.
• Installed Business Objects in VMWARE and My SQL Database systems.
• Used SAP BI Integration Kit to connect Business Objects and SAP BI.
• Prepared Master queries by identifying common report requirements in each cube to enable Adhoc reporting on Universes and Webi reporting in Business Objects XI 3.1
• Involved in OLAP Universe life cycle management using SAP BI data sources.
• Worked on MDX query driver to build reports off SAP BI cubes, ODS & published it to BO Enterprise.
• Developed complex queries and reports using different data providers in the same report.
• Created reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc
• Used Nested queries to jump from summarized query on a cube to detailed level ODSs.
• Prepared CAFR reports using Crystal reports in pixel perfect format to match state statutory requirements.
• Created prompts for Webi reports using @prompt functions.
• Created report layouts in Webi and Crystal reports using State of Louisiana logo to achieve common look and feel in Enterprise Reporting.
• Extensively worked on Data federator for capturing long texts and combined with Webi reports for publishing Budget.
• Worked with manual and imported excel data as data source for embedded Xcelsius spreadsheet
• Created Xcelsius visualization from a Live Office enabled excel spreadsheet
• Developed in Xcelsius for Finance and Logistics dashboards with the output templates obtained from BEx analyzer.
• Dynamically pulled data from SAP BI through Web Services (WS).
• Extensively used Web Service connection and also used Flash variable to input values to the dashboard.
• Used multiple WS connection and ingeniously made WS calls for various selections with optimized performance.
• Developed dashboards for budget spending.
• Extensively used various components including Gauges, Scorecards, Charts (Pie, Bar, Column, Line, Combination charts, Maps and other selection boxes) which best suit for the analyzation.
• Made use of alerts in gauges, charts, scorecards and maps with dynamic band ranges which varies with selection made by other components. (what-if-analysis)
• Maintained themes and color coding though out all dashboards.
• Developed Pop-up windows, alerts like traffic light, multi colored line charts (actual in one color and the budget in another from the month where actual ends), User instructions displayed as a dialogue window by hovering on the respective windows help
• Full training was given to the end users development team for the maintenance of the dashboard reports.
• Participated in business objects administration roles in central management console (CMC). Maintained severs of DEV, QA and PROD systems.
• Migrated sap security model to business objects with Business Objects authentication.

Client: Confidential,Melrose Park, IL (IBM) January 2008 February 2009

Role: SAP BI Consultant (Functional)

Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Attended all functional business workshops to gather the requirements and to analyze the gaps.
• Prepared the Business content and BI Strategy documents (Including Customer object standards, Extraction Strategy, Legacy Historical data Strategy, Reporting Strategy e.t.c).
• Created reports related to COPA like sales margin, sales growth, sales trend, P& L, etc reports. Created reports in SD like daily sales bookings, deliveries and billing, monthly sales analysis, etc. using BEx query designer, web application designer (BEx WAD).
• Setup the logistics customizing cockpit by maintaining the extract structures and data sources, activating the update, setting up V3 update for SD documents: sales, delivery and billing orders.
• Designed and developed documents and reviews conducted time to time.
• Created the functional and technical design documents for OTC(Order to Cash),MTS(Make to Ship),PTP(Procure to Pay),ATR(Account to Report),HTR(Hire to Retire),DTB(Demand to Build).
• Extracted and uploaded data into info cubes from data sources 0FIAP_CO2 transaction data, 0FIAP_C03 line items, 0FIAR_C05 and 0C0_OM_CCA_X, 0CCA_11- cost and allocation, 0C0_OM_OPA_X- internal order and customized those using update rules. Created balance sheet, profit & loss reports, trial balance, and cash flow statement on GL info cube.
• Data Logical flow documents created for the developers.
• Coordinated the entire developing process with the Offshore team (India).
• Conducted design reviews with the client for clarifications while developing.
• Installed Technical content.
• Extracted data from the ECC system to BI. Created process chains on daily and as needed Loads.

Client: Confidential,Springdale, AR May 2007 - January 2008

Role: SAP BI Consultant (Onsite Support)

Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Involved in extensively Onsite Support for the Client by coordinating with offshore team.
• Performed Daily Monitoring and Maintenance of Performance of Process chains.
• Performed Data load Monitoring and ongoing Maintenance.
• Identified production problems, issues and suggested fixes.
• Besides Production support Uploaded master and transactional data from flat file and SAP R/3 as the OLTP source.
• Created Info packages for initial, full and delta uploads for both master data and transactional data.
• Developed basic cubes for Customer and Quotations, Created aggregates and indexes for Info Cubes to improve the query performance.
• Generated queries using new BEx Query Designer.
• Designed new applications using new templates in BEx WAD.
• Worked extensively with new BEx Analyzer.
• Worked with BEx Report Designer to create formatted reports.
• Actively worked in designing, formatting and delivering financial statements, using crystal reports
• Executed adhoc query analysis using Web Analyzer.
• Experienced in using BEx information broadcasting to distribute the right information to the right people at the right time.
• Loaded business content, and performed activation of SAP supplied Info Objects.
• Extensively used Process Chains to automate data loading process.
• Transported the objects from Development to QA and then to Production.

Client: Confidential,IL October 2006 - May 2007
Role: SAP BW Consultant

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0/5.0

Responsibilities:

• Identified and activated SAP business content required for the Info Cubes.
• Replicated the data sources into BW, thereby making Metadata related to the data sources available to the BW.
• Enhanced the Info Cubes by adding custom Info Objects to reflect modified R/3 Business Process.
• Created Application Component for the Info Sources and Assigned the Replicated data sources to the Info Sources and Activated the Transfer rules and Communication Structure.
• Created Transfer/Communication Structures, Transfer rules and Update rules for ODS and InfoCubes.
• Created Update Rules for data load into Info Cube from the Communication Structure.
• Loaded Master data (attributes, texts, hierarchies) from flat files to the Info object.
• Extracted data from SD modules and uploaded the data into the procurement cubes via 2LIS_11_VAHDR, 2LIS_11_VAITM, and 2LIS_02_VASCL.
• Created Sales and Delivery, Billing InfoCubes OSD_C01 and OSD_C03 for sales overview.
• Developed ODS object to load SD Sales Order, Delivery note, Billing document Data from Business Content delivered Infosources, defined the update rules.
• The Data was extracted from various SD Tables like VBAK, VBAP, LIKP, LIPS, VBRK, VBRP, etc.
• Loaded transactional data into PSA and updated data from PSA to ODS and Activated ODS for reporting.
• Designed and created all BW components to load the historical data via flat files.
• Enhanced the Business Content Extractors with the user requirements
• Involved in Scheduling data loads and delta data loads into BW from R/3.
• Created Aggregates on info cubes in order to generate reports and improve query performance. RSRT for Query monitoring.
• Designed and developed several BW queries using BEx (Business Explorer).
• Worked on Web Application Designer (WAD) and published reports on web.
• Implemented a framework of templates, restricted key figures, calculated key figures and variables to implement common reporting structure.
• Extensively trained the client on BI 7.0 Data Modeling which includes installing Business Content; creating Info Objects, InfoCubes, DSO Data Store Objects, Transformations, DTP Data Transfer Process, Info Packages, Data Sources, Process Chains, and Source Systems.

Client: Confidential,WI March 2006 September 2006

Role: SAP BW Consultant

Environment: SAP BW 3.0, SAP R/3 4.6C

Responsibilities:

• Gathered Functional requirements, prepared Functional & Technical specifications, and developed blue prints by interacting with the functional experts, business analysts, management and end users.
• Involved in customizing the business content to suit the Company’s specifications.
• Made extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Created a forecast ODS and a billing history cube and extracted data into these data targets from R/3 and other legacy systems.
• Worked extensively on transfer rules, update rules and user-exits for transaction data.
• Developed and enhanced LO cockpit data sources.
• Automated data load processes, maintained BW statistics, did rollup of BW aggregates using Process Chains.
• Executed queries in the BEx with variables, structures, calculated key figures, restricted key figures, exceptions, conditions and RRI features.
• Used ABAP programming in Transfer Routines and Update routines to load and update data into Data Targets to achieve required results at data target and query level.
• Analyzed and Mapped Business Processes to BW and wrote Business Blue Prints using ASAP methodology. Analyzed and activated Relevant Business Content and setup R/3, Flat File and BW as source systems. Reconciliation of data from various sources including legacy systems as Present Data ware houses.
• Created Web templates using Web Application Designer (WAD).
• Transported BW objects from development to QA and Production.

Confidential,India, Client: Nestle, CA July 2005 February 2006
Role: SAP BW Developer

Environment: SAP BW 3.0B, SAP R/3 4.6C

Responsibilities:

• Involved in Analysis, design, development of Info cubes and ODS objects
• Enhanced the update rules for COPA Info Cube to meet the new business requirements for Total Discounts, Gross Trade Sales and Net Sales
• Developed Info objects, Info cubes, ODS, transfer rules, communication structure, update rules and Info packages
• Involved in performance tuning by maintaining aggregates, compression, partitioning, indexing of info cubes and use of statistics for the same
• Worked on info cubes to analyze the accounts receivable transaction figures and line items for the customers.
• Used ODS objects to stage the data before transferring the ODS object contents to the Info Cube.
• Uploaded master data and transactional data from files and SAP R/3 as the OLTP source.
• Using Business Explorer (BEx) created custom queries based on the detailed query and business requirement.
• Created Transfer rules, update rules using ABAP routines and Formula builder while creating Cubes and ODS.
• Used Filtering, Conditions, Variables, and Navigational Attributes.
• Created queries, reports, workbooks and web-reports on Bex Analyzer and posting of reports on the web/portal with drill down and execution capabilities.
• Created variables calculated key figures, formulas and structures in query development, working with workbooks, exception reporting, and conditional reporting.
• Trained users on using BEx reports and explained the functionality of BEx features.