SUMMARY

• 7+ years of SAP BW/BI, and SAP Business Objects (BO) experience which includes 3 End to End implementations.
• Expertise in Requirement analysis, Functional Specs, Prototype development, End to End Testing, and Post Product Support.
• Worked in multiple industry verticals such as Financial Services, Pharmaceutical, Retail, Manufacturing. Worked with Fortune 500 Clients and BIG 4 consulting & System Integrator firms.
• Extracted data from LO - Cockpit, SD, FI, and MM using Business content data sources. Experience in extracting non-SAP data i.e. flat files & using DB Connect for legacy data.
• Extensively worked configuring back-end components including Extractors, Info Objects, Hierarchies, Info Sources, Update Rules, Transfer Rules, Transformations, Info Cubes, Multi provider, ODS/DSO, Info Sets, Info Packages, and Data Transfer Process (DTP).
• Expertise in Data Source Enhancement, User Exits, Loading, Scheduling, Monitoring, Process Chains, Open Hub Service, Authorizations, User Profile Maintenance, Reporting Agent, Enterprise Portal Integration and alert monitor.
• Excellent in BW backend and Front-end. Proficient in writing ABAP User exits for transaction data and complex routines in start routine and end routine.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads during System Integration Testing and Production Support.
• Experience in resolving Go Live issues which involved debugging ABAP routines, Data loads, Validation and trouble shooting of Transaction Data and Master Data, Change management, Process Chains Monitoring, Transport Management, Roles & Security, System Checks.
• Expertise in working with BEx Query Designers in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Customer Exit Variables and Structures for developing complex custom reports.
• Experience in Business Objects Enterprise. Worked using full-client and web-based thin client reports and Universe, WEBI Queries, Crystal. Worked with BASIS in Installation, Administration, Troubleshooting, Scheduling, Publishing and Security.
• Strong experience in analysis, designing, creating/enhancing Universes and retrieving data from Universes, stored procedures, personal data files and free hand SQL.
• Good technical and working experience with Crystal Enterprise, Central Management Console, Central Configuration Manager.
• In-depth experience with enterprise BI data presentation and developing standard reports, Ad-hoc reports, complex reports by linking data from multiple sources and Multi-dimensional analysis using functionalities like Slice and Dice, Drill Down, Master Detail etc depending on the user requirements.

TECHNICAL SKILLS

Data warehouse: BI 7.0, BW 3.5, BW 3.X

Language: SQL, PL/SQL, ABAP/4

ERP Packages: SAP ECC 6.0, R/3 4.7

Reporting Tools: BEx Reporting, Business Objects XI 3.1, 4.0., Crystal Reports 2011 Web Reporting.

PROFESSIONAL EXPERIENCE

Confidential, Glendale, CA

SAP BI/BOBJ Consultant

Environment: SAP Netweaver BI 7.0, ECC 6.0, SAP SC, FI, BEx

Responsibilities:

• Involved in gather requirements, developing proto-type, identify gaps, testing, reporting.
• Worked on 0FI AR 4, 2LIS 11 VAITM, 2LIS 12 VCITM.
• Created a Custom Data Source SWMS, TMS 3rd Party Data Sources.
• Worked with Functional Teams and developed reporting requirements.
• Designed and developed custom DSOs and Transformations for these data targets and evaluate data.
• Created Generic Extractors by using views.
• Worked on Start Routines and End Routines in Transformation to ensure proper loading of data, to first layer DSO and second layer DSO.
• Designed process chains for daily master data loading, transactional data loading from ECC
• Created Info Spokes using Open Hub service to extract data from BW into table.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes.
• Created variables with user/sap exits, calculated key figures, formulas and structures in query
• Responsible for compression and partition of certain cubes for enhanced performance. Proposed archiving strategy for future based on Time characteristics.
• Improved query performance and data load using OLAP cache.
• Meet project standards using proven data load tools and methodology.
• Prepare technical specification document.
• Execute Transformations.
• Identify data quality issues, provides recommendations for improvement / resolution.
• Monitoring data loads.
• Designed BEx queries using BEx Designer for SAP related Data and created Universes on top of BEx Queries.
• Created Web Intelligence reports/ Ad hoc reports using Universe.
• Worked in coordination with the basis team to Transport (DEV to PROD) the objects.
• Created necessary documentation throughout the project implementation. Conducted User Training for end users about the navigation features possible in the reports.

Confidential, Dallas, TX

SAP BI/BOBJ Consultant

Environment: SAP Net weaver BI 7.0, ECC 6.0, SC, BEx, BW ABAP/4

Responsibilities:

• Worked 2LIS 02 ITM, 2LIS 02 SCN, 2LIS 02 HDR, 2LIS 02 SCL
• Worked with Functional Teams and developed reporting requirements.
• Designed and developed custom DSOs, Info Cubes and activated transformations for these data targets and evaluate data.
• Created Generic Extractors by using Info set Queries.
• Migrated Data Sources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Designed making extensive use of the DSO capabilities, delta management functionality and optimal use of transformations keeping query performance in view.
• Designed process chains for daily master data loading, transactional data loading from ECC.
• Created Open Hub service to extract data from BW into .CSV format to a folder location.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes.
• Created variables with formulas, calculated key figures and structures in query
• ABAP User exits for transaction data and complex routines in start routine and end routine.
• Development, working with workbooks, exception reporting, conditional reporting.
• Performed Remodeling on already existing Info Cubes to add new key figures and characteristics.
• Responsible for compression and partition of certain cubes for enhanced performance. Proposed archiving strategy for future based on Time characteristics.
• Improved query performance and data load using OLAP cache.

Confidential, IL

SAP BI/BOBJ Consultant

Environment: s: SAP Netweaver BI 7.3, ECC 6.0, SAP FI, SD, MM, BEx, Business Objects 4.0

Responsibilities:

• Involved in Blue-printing, gather requirements, developing proto-type, identify gaps, testing and reporting.
• Activated Business Content for FI- Accounts payable (AP), Accounts Receivable (AR), SD - Billing, ales, AB- Agency Business.
• Activated standard Queries for Post Depreciation and also we created a custom Query for Transaction.
• Worked with SD Functional Team and developed reporting requirements for Sales Reports.
• Extracted data form SD Billing 2LIS 13 VDITM, Sales 2LIS 11 VAITM and Agency billing 2LIS 45 ITM to BW, reconciled of BI reports with SD.
• Designed and developed custom ODS objects, InfoCubes for Sales data and activated Update rules for these data targets that evaluate quantities and values for sales orders, deliveries and returns, and invoices.
• Created Generic Extractors by using tables Invdtl, Invhdr.
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
• Worked on creating Routines in Transformations to ensure proper loading of data, because we have some data issue unknown symbols are generated by Idocs coming to BW where SAP BW will not allow, # as a first character in a string.
• Created Purchase order control report, this report will show the statuses of Purchase orders and Sales orders in particular the third party purchase orders and sales orders.
• Extensively worked on Info Cube maintenance like Compression and Roll- ups.
• Designed process chains for daily master data loading, transactional data loading from ECC.
• Created reports using APD (Analysis Process Designer) on top of these reports developed InfoSpokes using Open Hub service to extract data from BW into .CSV format to a folder location.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes.
• Created variables with user/sap exits, restricted key figures, formulas and structures in query
• Development, working with workbooks, exception reporting, conditional reporting.
• Involved in Installing & Configured Business Objects 4.0 Enterprise
• Managed CMS (Central Management Server) from Server Intelligence Agent.
• Access granted permissions to concern region folks throw CMC.
• Created reports in Crystal Reports by using BEx Queries from SAP BW.
• Developed complex reports using functionality’s like Drill down, Cross Tab, Master detail and Formulae’s etc.
• Worked on Netweaver Portal like publishing Reports Creating iViews Roles Work sets, Authorizations.

Confidential, IL

SAP BI/BOBJ Consultant

Environment: s: SAP BI 7.1, SAP ECC 6.0, SAP FI, BEx.

Responsibilities:

• Involved in Blue-printing, gather requirements, developing proto-type, identify gaps, testing and reporting.
• Activated Business Content for FI- Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL).
• Worked with FI Functional Team and developed reporting requirements for financial statements.
• Worked on Financial Accounting (New Ledger). Extracted data for leading and non-leading ledgers to BW, reconciled of BI reports with FI.
• Extracted 3FI GL xx TT data sources to extract non-leading ledgers to BW. Also used EHP3 FI datasources for proto-typing Trial Balance, P&L Statements (Income Statements) and Balance Sheets.
• Created custom Infoproviders and worked with the BW Architect to develop the landscape.
• Migrated DataSources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Designed process chains for daily master data loading, transactional data loading from ECC.
• Developed Universes using BEx query as source and WEBI reports. Used BO Advanced Analytics for reporting.
• Worked with Security Team to develop roles and authorizations.
• Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in the Info Cubes to facilitate various reporting requirements like the Price Purchase Variance and Foreign Exchange Exposure reports.
• Generated Cost Center “Internal Order” report which provides an overview of the incurred costs and consumption quantities on an internal order group during the reporting timeframe and the fiscal year. Also developed reports such as Actual costs, Plan/Actual, Target/Actual, “Overdue analysis (Aging report)”, “Payment History”, and “Due date for net payment”.
• Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BW Queries. Built code for specific User exit variables and replacement path variables to capture the requirement for Year-to-date, Quarter-to-date and Month-to-date.
• Worked on Dimension Management and Application management such as creation, maintenance, additions and deletions.
• Performed Remodeling on already existing InfoCubes to add new key figures and characteristics.
• Responsible for compression and partition of certain cubes for enhanced performance. Proposed archiving strategy for future based on Time characteristics.

Confidential, GA

SAP BI/BOBJ Consultant

Environment: s: SAP BI 7.0, SAP ECC 6.0, SD, MM, FI, Business Objects 3.1.

Responsibilities:

• Involved inanalyzing, gatheringBusiness requirements to design BRDs fordata specifications and Business ObjectsWebireports.
• Developed the Reports for End-client Users using Business Objects XI 3.1.
• Detected/resolved data Cardinalities and loops, checked integrity of Universes.
• Created custom List of Values and exported to the Repository with the Universe and Implemented dynamic prompts and cascading list of values.
• Involved in developing Universe and reports on SAP BI/BW including ODS, Info Cubes, Multi-providers and BEx Query development.
• Created calculated measures in SAP BW Universes in order to avoid creating additional calculated key figures in the SAP BW query.
• Merged Data between SAP BI/BW and other external data sources (Flat files).
• Measure Objects and dimension objects were created keeping in view of the end-user requirement.
• Exported the Universes to the Repository to make resources available to the users.
• Developed complex reports using multiple data providers in Web Intelligence Rich client.
• Defined business objects standard reports & ad-hoc reports and Created report templates for consistency in the look and feel of the reports.
• Created reportsfor various portfoliosusing universe and free hand SQL as main data providers.
• Responsible for Unit testing and validating the reports data with the actual data in Teradata database.
• Developed complex reports using Business Objects functionality’s like Slice and Dice, Drill down, Cross Tab, Master detail and Formulae’s etc.
• Developed all reports based on ETL jobs Audit tables to track records submission, loaded records, errors in records and error details.
• Worked with Multiple Data Providers including personal Data files, Stored Procedures and Freehand SQL to create Reports.
• Responsible for Business Objects trouble shooting issues and scheduling the reports.
• Used Web Intelligence for web based query and reporting and customizing the reports.
• Edited and formatted reports in interactive view using Crystal Reports 2008.
• Involved in deployment of Universe and Reports from development environment to production environment.

Confidential, VA

SAP BI/BOBJ Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SAP FI, SD, MM, HR, BEx, Business Objects (XI)

Responsibilities:

• Involved in full cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL), Purchasing and customized them as per the client requirements.
• Responsible for loading time dependent and time independent master data and hierarchies. Responsible for data extraction, reconciliation and reporting of FI data in BI.
• Developed InfoSpokes using Open Hub service to extract data from BW into .CSV format.
• Created custom Info Cubes for companywide Purchasing with various aggregate periods (business day of the year, business day of the month etc.)
• Migrated Data Sources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in the InfoCubes to facilitate various reporting requirements like the Price Purchase Variance and Foreign Exchange Exposure reports.
• Performed Remodeling on already existing InfoCubes to add new key figures and characteristics.
• Designed process chains for daily master data loading, transactional data loading from ECC.
• Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression and other performance improvement techniques.
• Responsible for compression and partition of certain cubes for enhanced performance. Proposed archiving strategy for future based on Time characteristics.
• Improved query performance and data load using OLAP cache.
• Created Price Purchase Variance (PPV) and Foreign Exchange Exposure (FX) reports. Created FI reports “Overdue analysis (Aging report)” “Payment History”, “Due date for net payment”.
• Generated Cost Center “Internal Order” report which provides an overview of the incurred costs and consumption quantities on an internal order group during the reporting timeframe and the fiscal year. Also developed reports such as Actual costs, Plan/Actual, Target/Actual.
• Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BW Queries. Built code for specific User exit variables and replacement path variables to capture the requirement for Year-to-date, Quarter-to-date and Month-to-date.
• Created BW OLAP Universes on top of BW Queries to access the BW data in Business Objects. Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source.
• Designed and developed Business Objects Universe for Aging report.
• Published iViews and embedded in the portal in the respective business roles..
• Worked in coordination with the basis team to Transport (DEV to PROD) the objects.
• Created necessary documentation throughout the project implementation. Conducted User Training for end users about the navigation features possible in the reports.

Confidential, PA

SAP BI Consultant

Environment: R/3 4.6, ECC5.0, BW 3.5

Responsibilities:

• As a technical consultant, involved in gathering user requirements related to reporting using BW.
• Identified and activated SAP business content required for the Info Cubes.
• Replicated the data sources in to BW, thereby making Metadata (which is data about data) 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 Info Cubes.
• Created Update Rules for data load into Info Cube from the Communication Structure.
• Involved in Logistic Information System (LIS) Extraction process, scheduling initial upload and V2 updates through system created transparent tables.
• Created Sales and Delivery, Billing Info Cubes 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 Info sources, defined the update rules.
• The Data was extracted from various SD Tables like VBAK, VBAP, LIKP, LIPS, VBRK, VBRP, etc.
• 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).
• Implemented a framework of templates, restricted key figures, calculated key figures and variables to implement common reporting structure.

Confidential, San Jose, CA

SAP BW/BI Developer

Environment: R/3 4.6C, BW 3.X

Responsibilities:

• Interacted with the project team and end users for designing the data models. Analyzed the business requirements and translated into dimensional models.
• Managed and monitored data loads with full update and delta mechanism and optimized the performance by adjusting packet size and data selections.
• Created aggregates and hierarchies for the Info Cubes in order to access the data in an efficient and ordered level. Involved in customizing the business content to suit the company’s specifications.
• Responsible for design, development and extraction of data from R/3 Source system and Flat files to the BW system.
• Enhanced existing transactional data extractors.
• Created and Modified User Exit program to accommodate additional fields in the extract structure of the data source.
• Automated BW jobs using Process Chains.
• Designed and developed ODS objects and build Info Set queries.
• Customized Data Sources, Info Objects Info Sources and Info Cubes.
• Made extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Developed SAP BW queries using the tools like Business Explorer.

Confidential

SAP BW Developer

Environment: SAP BW 3.0, SAP R/3, SD, Flat files

Responsibilities:

• Understood the Client requirement, prepared the technical specification of the report requirements.
• Installed the Business Content as well as created Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains.
• Worked on 2LIS 12 VCITM, 2LIS 12 VCHDR and 2LIS 12 VCSCL extractors.
• Worked on filling setup tables.
• Created Custom extractor by using Views.
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
• Created restricted key figures, variables, and exceptions and calculated key figures in queries.
• Improved the query performance by creating aggregates.
• Created interactive reports in SD module by extracting the information on delivery and invoice status, shipping details and partner function details.
• Designed documentation for queries using BEx Analyzer Reporting tool as per client requirements.
• Extensively involved in the job scheduling and monitoring the loads from ECC to BW and within BW.