SUMMARY

• 8 plus years of IT experience with almost 7 years of professional experience in SAP - BI/BW as Techno Functional consultant.
• Involved in implementation 2 full lifecycle BW projects and provided key services such as data modeling, design support, data management, design, specification development, reporting, Web publishing, portal integration, performance tuning, testing, documentation, maintenance, global and cross functional metadata definition support
• Having good functional overview of SD/MM/PP/HR/FI/CO/CRM/SCM-APO modules.
• Thorough Knowledge in Supply Chain Management and can design necessary extractors from SAP SCM tables.
• Worked extensively as a Techno Functional Analyst evaluating user requirements, converting business requirement documents (BRD) to Application design document (ADD), designed, developed end to end application in BI 7.0/BW 3.5.
• Experienced in Net weaver 2004s Business Information components, Info Objects, Info Providers, Info Sources, transformations, DTP, DSO, Start and end routine using Data Warehouse Workbench
• Experienced in creating and maintaining ODS objects, Info Cubes and Multi Providers for different application components like SD, MM, PP
• Experienced in writing Update routines and User exits using ABAP
• Expert level skills in extracting data from SAP R/3 systems using different extract structures like LIS, LO Cockpit and Generic extractors
• Experienced in using Delta update mechanism for uploading data to BW from R/3 in specific intervals
• Experienced in ETL Job scheduling and Process Chains
• Extensively worked on Reporting tools like BEx Analyzer, BEx Query Designer and BEx workbooks, Web Application Designer, Business Objects (WebI, Universe Designer and Xcelcius.
• Proficient in BO administration, designing Universes, WEBI rich client reports, WEBI reports, Deski reports, Crystal Reports and Full Client Reports(3.1), XCelsius.
• Expertise in developing the Business Objects Universe(OLAP Universe) and the analytics using WEBI, Crystal Reports, Xcelcius, Live Office and QAAWS..
• Expertise in Report Generation - Worked in BEX Analyzer in building queries and saving in workbooks, created custom queries using Conditions, Query Filters, Exception, Variables, Structures, Calculated Key Figures and Restricted Key Figures
• Also experienced in reporting using Query designer and Web Application Designer (WAD)
• Worked with Xcelsius, Crystal Reports, Visual Composer, Webi and also familiar with SAP Best Practices.
• Good Working Knowledge in Business Objects tools like Webi, Deski, Xcelsius, LCM, Import Wizard, QAAWS, Live office, Crystal Reports, etc.,
• Experienced in Troubleshooting and Production support activities
• Extensively worked in different versions of BI like 3.x and BI 7.0

TECHNICAL SKILLS

ERP: SAP ECC 6.0, R/3 4.7, 4.6C, 4.6 B

Data warehousing: SAP BI 7.0, BW 3.5/3.1C/3.0B, Informatica

SAP Portals: Enterprise Portal 6.0

Programming Languages: ABAP/4, C++, C, PL/SQL

Databases: ORACLE 8i, MS Access, DB2

Reporting Tools: BEx Reporting, Web Reporting, Web Application Designer (WAD), WebIntelligence, Xcelcius, Business Objects (XI R2.1,3.1,4.0), Cognos

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

SAP BI/BO CONSULTANT

Responsibilities:

• Participated in the user meetings to gather Business requirements. Analyzed the requirements; modeled the Info cubes & ODS objects based on queries
• Installed Business content Info objects 0vendor to load data from data sources 0VENDOR ATTR to generate Vendor Master Reports
• Installed BI Content Info providers - DSO’s like 0FIGL O02, 0FIGL O14 and Info cubes like 0FIGL V10, 0FIGL C02 to load data from the data source 0FI GL 4, 0FI GL 10, 0FI GL 14 (new GL reporting) and their related queries
• Prepared various test case documents which contain sample data, data from source system, actual result and expected result.
• Enhanced data sources pertaining to FI-AP(account payables) and FI-AR(account receivables). Tested performance using the transaction RSRT and ST03.
• Involved in testing various BW application data (automated and regression) prior moving to production box.
• Implemented Minute based extraction for old GL reporting
• Added custom characteristics, Key figures and made corresponding changes to transformations for BI content Info objects and Info Cubes to accommodate the custom Info objects
• Created & maintained Transformation while maintaining Start routines, to transform incoming data into suitable format for reporting.
• Created customer exit ABAP routines for generic data sources and data source enhancement
• Involved in migration of 3.x to 7.0
• Designed and scheduled Process chains for automating the Delta Loads, Aggregate Rollups and Change Runs
• Created Hierarchies to display the data in hierarchical form in the reports.
• Monitored BW data loads for Daily/Weekly/Monthly and resolution for the load failures, performances tuning of data load for critical BW applications.
• Extensively used BEX and WAD for different queries according to requirements.
• Worked on complex sales Dashboards, Visualization dashboards in Xcelsius and WEBI reports.
• Used Drilldown, Accordion Menu, Dynamic visibility, tabset, Gauge, Calendars and many more features for the development of Xcelsius dashboards.
• Collected the Transport Requests using Transport Connection and worked with the Basis team to transport the collected requests into QAS and then into Production.
• Involved in End User Training, Coordinated the migration strategy to move the developed objects across the landscape.
• Defined Dynamic Cascading Prompts in Business Views for crystal reports development.
• Involved in developing complex MM related Bobj Webi reports with different metrics.
• Used Import wizard to migrate the Bobj reports to different environments.
• Creation of reports like Reports by Period, Demographic reports and Comparative Reports.
• Defined custom hierarchies for implementing drill down, drill up capabilities In Business Objects.
• Created WEBI reports and Crystal reports and deployed them through info view with BI universe as source and created Inventory accuracy dash boards using Xcelsius.
• Involved in Day to day activities like scheduling, performance tuning and production support.

Environment: SAP R/3 ECC 6.0, SAP BI 7.0 BW release 3.x, Sun Solaris, BEx 7.0, Business Objects XI R3/XI R2, Crystal Reports, ABAP/4, WEBI, Xcelsius 2008.

Confidential, Marysville, OH

SAP BI Consultant

Responsibilities:

• Involved in all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
• Meetings on status, issues, and overall progress. Involved in implementation of Reverse Logistics project in MM.
• Designed the project flow according to ASAP methodology.
• Prepared the BW project plan by gathering Business requirements, analyzed requirements and developed data modeling extended star schema.
• Involved in complete SDLC from Extraction, Transformation and Loading data into BW.
• Successfully implemented a full life cycle implementation including Gap Analysis, Blue-Printing, Report Design, Development
• Experience in Upgradation of SAP from BW3.5 to BI 7.0 and migration of components of conceptual design from SAP BW3.5 to BI7.0.
• Maintaining the transformations and DTP’s and in migrating the new and existing queries in both BEx and WAD. Interpreting and writing complex ABAP routines.
• Created WEBI reports and formatted Crystal reports and deployed them through info view with BW universe as source.
• Created Standard reports, Cross-tab Reports, Sub Reports and Drill Down Reports using Crystal Reports 2011 and published it onto the BI Platform.
• Regularly interacted with the functional core team (SD, MM, PP, HR, FI and PM) and end users to understand their Reporting Requirements and created function specifications.
• Worked on balance sheet reports and income statement reports
• Involved in monitoring the performance of the system which includes performing OLAP Cache, Aggregates, Indexes, Archiving the non-cumulative info cubes etc…
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Info set and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP) etc.
• Developed many complex ABAP enhancement like User Exit Functions, Generic Extractions and also in BI data modeling like Start Routines
• Designed and created many process chains to automate the data load and data target administration
• As a part of Production support involved in Debugging and monitoring load failures, Delta loads, planning ECC Outage for filling up of setup tables, Minimizing the Init load and setting the v3 jobs
• Extensively worked on many Production high priority support tickets by working with the clients and satisfying their needs.
• Also monitoring the Daily loads/Weekly loads into the BI system from different source systems
• Worked on different data sources under customer services and plant maintenance
• Worked on SAP BI Integration with the Legacy data Base DB2.
• Extracted consolidated data from different SAP and non-SAP systems as project required
• Involved in integrated testing like string, FUT, UAT and Recursive
• Extensively used Bex analyzer, created queries with variables, filters, CKF’s and RKF’s.
• Created Web Templates ZPRINV0055001 WT, ZPRINV0072001 WT as desired by the user.
• Involved in Day to day activities like scheduling, performance tuning etc
• Monitored and analyzed the Extraction and Data load process using BW Monitor.
• Participated in QA and UAT process and implemented bug fixes and updates requested by QA and Business users.
• Created integration test cases to test and improve data quality, data loading and process chain related issues.

Environment: SAP ECC 6.0, SAP BI 7.0, BEx Analyzer, Query Designer, Crystal reports.

Confidential, Salem NJ

SAP BI/BW Consultant

Responsibilities:

• Involved in Full Life Cycle of BI implementation from blue print, realization, user training.
• Interacted with Business Users to understand their business needs and requirements for developing and modifying reports.
• Interacted with management and end-users about the requirements and made GAP analysis.
• Direct experience using data sources within LO Cockpit and FI-GL extractors, Generic Data Extractors and Master data extractions from R/3 to BI.
• Researched and resolved issues related to FI-General Ledger, Controlling, Special Purpose Ledger, such as configuration problems in material master, General Ledger, authorization, automatic account determination, organizational settings
• Extracted data form FI data sources to load data into custom infocubes.
• Worked in developing Custom infocubes using business content infocubes.
• Performed various financial reconciliation analyses, such as business area balancing, financial statements and consolidations.
• Involved in the implementation and customization of FI Info Cubes.
• Installed CO-PA cubes from Business Content and customized cubes to suite the end user requirements.
• Created FI-GL extractor using Totals Table in R/3 for extraction and loading into BW.
• Provided first line functional support for SAP FI module. Responsibilities included configuration of GL, AR and AP, evaluating and reviewing testing and implementation.
• Extensively worked with asset accounting.
• Provided configuration knowledge for General Ledger, Special Purpose Ledger and Enterprise Controlling -- Consolidations.
• Reviewed business requirements and determined configuration changes to be done. Made recommendations based on findings.
• Extensively used Bex Analyzer to build queries, worksheets and accessed data from BW data targets. Used ABAP coding whenever required.
• Generated reports using Bex (Business Explorer) with exceptions, conditional formatting, restricted and calculated key figures.
• Upgraded, enhanced and supported activities from BW 3.5 to BI 7.0 in Nw2004’s.
• Modified existing queries on various Info Cubes related to SD and HR-Payroll.
• Extensively worked on Query building, Filtering, Free Characteristics, Restricted Key Figures and Variables, Query variants using BEX Analyzer.
• Extracted data from R/3, Non-R/3 (SQL Server) and flat files. Scheduled and monitored the data loads in production.
• Performed detailed analysis to improve the performance using Info Cube Compressions and Aggregates.
• Scheduled extract jobs, grouping of extract jobs, monitoring of transfer and update for data loads.
• Participated in workshops to define requirements and develop to-be processes in 4.6 for General Ledger.
• Created Generic Data source using DB View Extraction method for CRM Master Data.
• Interacted with CRM Marketing and Sales Business users, attended Workshops and analyzed business requirements for design and development of Pipeline reporting.
• Enhanced Activity data source (0CRM SALES ACT 1) in CRM to add custom fields like owner Id and buyer contact fields.
• Worked with BI different kind of testing phases like Functional Unit Testing, Data Validation, System Testing, & Integration Testing...etc
• Handling of day-to-day BW problems and reporting issues raised by business key users. Involved in different testing in BW data loads and performance tuning.
• Involved in full cycle of the project including go live to postproduction support.

Environment: SAP BW 3.5, SAP ECC 4.6C, COPA, FI/CO, CRM, Modules.

Confidential, Deerfield IL

SAP BW Consultant

Responsibilities:

• Involved in Full Life Cycle of BW SD/MM implementation from blue print, realization, user training
• Conducted requirement gathering workshops for business users on BW functionalities and reporting functionality.
• Extracted data from MM modules and uploaded the data into the Procurement cubes.
• Created Info Cubes, ODS, Info Sources and data sources from Business Content and LIS extract structures for SD modules.
• Worked with modeling and reporting of CRM, SD, Purchasing and Production Planning modules
• Have worked extensively in their Procurement Division, in particular Order Items, Schedule Lines and Vendor Evaluation systems.
• Have extracted generic R3 data from scores of tables like EKPO, EKKP and Info Cubes of 0PUR C01 and ODS’ 0PUR O01, and Goods Receipt in setting queries and workbooks for the Strategic Buyer group.
• Worked on sales order info sources 2LIS 11 VAHDR, 2LIS 11 VAITM and also on sales delivery info sources 2LIS 12 VCHDR and 2LIS 12 VCITM
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors
• Extensively worked on Data Source Enhancement of Business Content cube by appending structure, User Exits & Customized Delta built up for the data sources.
• Enhanced new Info Objects to be attached/mapped in Info Sources/Communication structures. Changed transformation rules as per customer requirements
• Designed, developed ETL, extracted BW Data to Non- SAP System using Open Hub service
• Activated LO Cockpit, extract structures and data sources in Sales Order management to facilitate the data extraction to BW.
• Extended the extract structures by adding new fields and populating them with the user/function exits.
• Created transactional info cubes for BPS and created Multi providers integrating actual and plan data.
• Created BPS queries using most current data variables on the request ID. Created variants for converting Basic cube to transactional and vice-versa to be used in process chains
• Developed Transfer /Update Rules and ABAP user exits for transaction and master data.
• Extensively worked on SAP BW delta load, Info package creation, updating Update rules, Modifying communication structures and Day to day Data Load support.
• Scheduled periodic data loads from SAP R/3 to BW and also schedule periodic data loads into the Info cubes.
• Used Bex analyzer to create various reports based on the different Info cubes, created calculated key figures and restricted key figures to improve report output.
• Involved in technical upgrade from BW 3.5 to BI 7.0.
• Created Dashboards and Business Presentations by importing data fromExcel sheetsusing XCelsius.
• Worked on different phases of testing like Integrated Business activity string test (IBAST), Technical string Test (TST), Business process integration test (BPIT), and Stress test to validate the design and business process flow.
• Application Support, development, providing strategic planning for data management
• Monitored user background jobs. Performed workload analysis of sap servers

Environment: SAP BW 3.5, BI 7.0, EP7.0, ECC 6.0, SEM 6.0, BPS, Oracle11i, SOL.MAN 4.0, SD, CRM and MM.

Confidential

Jr. SAP BI Consultant

Responsibilities:

• Involved in business requirement gathering and development part of the project.
• As a part of implementation team, involved in gathering user requirements and data modeling using ERM, Star Schema Concepts.
• Involved in the Architecture and blue printing of the HR, PA, OM, components and business content activation/installation.
• Responsible for preparing the Technical specifications, Design documents
• Review reports, integration and stress tests in QA, Extensively worked in the Enhancement of Info Cubes, Creation of Update Routines, Conversion routines and BAPI’s..
• Used ODS to stage data before transferring ODS contents to Info Cube..
• Worked on activating the standard business content info cube 0IC C03 Material movement and 0PUR C01 Purchasing data.
• Activated Business Content for HR PM, Benefits, Payroll, etc. and enhanced extractors.
• Involved in SAP BI integration with SAS, DB2, SRM and ECC PS module.
• Created Multi cube based on Sales order and Billing cubes.
• Responsible for design, development and extraction of data from R/3 Source System and Flat Files to the BW system and created various Info package to enable data transfer.
• Worked on creation of Aggregates and hierarchies for the Info Cubes to access data in an efficient and ordered level.
• Analyzed custom Infosets and reports in R/3 HR created over the years to imbibe the functional logic into BI backend modeling and reports.
• Mapped characteristics, key figures required for APO, developed info cubes for historical data and transaction data.
• Developed various reports for forecast comparison.
• Integration between APO and R/3 for Vendor-Managed Inventory process.
• Designed the Integration of the Systems of APO-DP, BI and BPC to combine the data for Analysis and Planning in these systems.
• Activated Finance and Rate Application sets for forecasting and Analysis of Unit Prices and Revenues in BPC,
• Created Info sets, Queries and workbooks; used variables, calculated key figures, restricted key figures, structures, conditions, exceptions and reporting agents.
• Resolved, implemented BW Query faults and change requests.
• Used Web Application Designer to develop web reports for Supply Chain operational reference model (SCOR).
• Created Infospokes to extract Material Classifications, Purchasing and Financial data data from the BI system to a Third-Party System (Teradata) via Datastage.
• Loaded Initial and delta loads for Purchasing, Inventory, Financial to Third-Party system.
• Created Process Chains to automate the loading Process.
• Created Forecast ODS and Billing History cube using data source from R/3 and Lotus Notes.
• Monitoring daily /weekly/monthly loads and solving loading issues.
• Training end-users on utilizing, developing and creating BW Queries.

Environment: SAP R/3 4.7, BW 3.x, APO 3.1, BPC 5.0 (OutlookSoft), HR, Bex Analyzer, Windows 2000/NT, Ascential Datastage 7.5x.