PROFESSIONAL SUMMARY

• SAP BI/BW consultant with over 8 years of experience, which includes experience in Business Objects as a technical and functional consultant playing various key roles in Design, development, Production support and reporting techniques across modules including modules FI/CO, HR, SD, PP, MM, WM Possessing expert technical skills with excellent communication, inter personal and analytical skills seeking a challenging position where the skills will be fully utilized.
• Exceptional record of delivering effectiveness, in design, development and implementation of business applications as Techno Functional consultant.
• Extensively worked in designing and configuring back - end components including infoset query Extractors, InfoObjects, Start and end routines, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, InfoCubes, MultiCubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, ODS/DSO, InfoSets, InfoPackages, and Data Transfer Process (DTP) and their types.
• Expertise in OLTP extraction from SAP R/3 using LO Cockpit, CO-PA, FI AR, AP, IM and Generic Extraction also data from the flat files.
• Expertise in Data Source Enhancement, User Exits, Loading, Scheduling, Monitoring, Process Chains, Open Hub Service, Authorizations, User Profile Maintenance, Reporting Agent, Enterprise Portal Integration, Information Broadcasting and alert monitor.
• Proficient in writing ABAP User exits for transaction data and complex routines in start routine, end routine and update routines.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• Evaluated statistical performance using BW Statistics for optimization. Improved data load and query performance by using BI Accelerator (BIA), Compression, Aggregates, Indexes, optimizing Data packet size.
• Expertise in Production Support 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 Analyzer in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Experience in Analysis Process Designs (APD), Real Time Data Acquisition.
• Designed Complex and Ad-Hoc queries in BEx Query Designer and created workbooks using BEx Analyzer using Conditions, Exceptions, Variables, Structures, Restricted and Calculated Key Figures.
• Extensively worked on Business Objects (BO) integration with BW for reporting requirements.
• Experienced in Business objects universe designing (OLAP Universes), Business Objects Web Intelligence (WebI), Business View Manager, InfoView, and Business Objects Enterprise (BOE).
• Hands on experience in creating BO Xcelsius dashboards and KPI’s to large-scale multi layer reports.
• Involved in End-User training on Navigating reports, Post Go-Live maintenance manuals, Web Application Designer, Portals.
• Documented functional specifications, technical specifications, test cases, test results and production support documents.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively with Team members, developers, clients and end users in a diverse environment.

TECHNICAL SKILLS

RP: SAP R/3 (4.5B, 4.6C, 4.7), SAP-SEM 3.5, CRM 4.0,SCM 5.0

Reporting Tools: Bex Analyzer, Excel Analysis, Bex Broadcaster, WAD, Report Designer, Webi, Crystal Report.

Data Warehousing: SAP BOBJ, SAP BW 7.0, 7.3, HANA (3.0B, 3.5B, SAP Netweaver 2004s/BI7.0)

Business Areas: MM, SD, CS, CO-PA, FI-GL, CRM, SCM, HR, FI-CO, SEM

Information Delivery: SAP Bex, Crystal Reports 2008, Web Intelligence Designer, and Universe designer, Business Objects Explorer, Xcelsius and Voyager.

PROFESSIONAL EXPERIENCE

SAP BI/BO Consultant

Confidential, CA

Responsibilities:

• Responsible for coordinating with IBM offshore support team to fulfill the production support requirement as a SAP Business Analytics team lead from Bio-Rad.
• Responsible for Change request Management for new Change request by the business users also responsible for analysis and fix of Defect and Incident resolution.
• Worked on optimizing the of asset accounting process chain 0FI AA 11- FI-AA Transaction, 0FI AA 12- FI-AA Post Depreciations.
• Involved in the production support responsibilities like monitoring the daily scheduled process chains using IBM TIVOLI, Managing the process chain sequence for dependent meta chains.
• Involved in the Quality system refresh by replicating the production data also responsible for re-init of data sources and dropping and filling up the set up tables for LO data sources.
• Responsible for Transport management system and approvals and validation.
• Responsible for deployment of production support work for off shore and work assessment.
• Involved in the Cost based (1 CO PA BR00) COPA redesigning using Composite providers to optimize the performance in the transpose.
• Responsible for fulfilling the business needs for Invoice History report, Final shipment report, Open orders/ back orders and Rental reagent report on 2LIS 13 VDKON, 2LIS 12 VCITM, 2LIS 11 V SSL, 2LIS 11 VASCL.
• Worked on Open Hub destination for APD’s using Wright optimized DSO to capture the snap shots for FTP (File transfer protocol) interface.
• Actively interacted and scheduled meetings with the business users to gather the reporting requirements, performed gap analysis and developed design documents.
• Collaborated with SD, MM and FI functional consultants to resolve business and configuration issues.
• Responsible for development and extraction of data from ECC source system into BI from SD, MM and FI modules.
• Extracted Standard DataSources 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL from the Business Content using LO- Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements. Performed LO - Cockpit extraction for Sales Order, Sales Delivery, and Billings.
• Involved in upgrade the project and performance issues and rectified data load failures.
• Involved in standard SAP modules such as SD, PP, FI/CO, MM.
• Monitoring of Info packages and analysing the reasons for frequent issues of Info packages.
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Involved in Transporting the BW objects from development server to quality server for Regression testing and Unit testing.
• Develop simple Routines in Update rules and transfer rules for the key figures of Info Cube.
• Responsible for Job schedules for loading Master data (Texts, Attributes and Hierarchies) for financial and sales areas and Transaction Data into the corresponding ODS Objects and Info Cubes.
• Worked on Data Maintenance (Compress, Rollup, Rebuild, Request and Content).
• Gathered user requirements for analysis and reporting, identified Gaps and created Technical design documents.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Stored data from SAP R/3 tables into ODS objects through PSA to perform detailed level of reporting.
• Created Info Cubes, ODS, Multi Providers, Transformations, Update Rules, Transfer Rules, Communication Structures, Transfer Structures, DTPs, Info Packages, Process Chains, BEX Queries etc.

Confidential, Beaverton, OR

SAP BW/BO SME Consultant, Business System Analyst

Responsibilities:

• Responsible for SAP Business Warehouse Support includes application support, troubleshooting the BW system and implementing corrective actions based on the BW application SLA/OLA.
• Involved in overall system performance of BW and its key components are inline with benchmark standards. Among key components are: BWA, Near line Storage.
• Supported the overall design and provide technical recommendation to the Business Warehouse project/development team in establishing corresponding data models, usage of front-end reporting tools, ETL tools, and technical infrastructure.
• Monitor and review BW technical design to ensure they are inline and support our current BI Strategies.
• Manage all technical development for BW system, which includes the Staging Area and Data Extraction Services.
• Definition and maintenance of service level agreements (SLA’s), ensuring the SLA’s are achieved, that service quality and client expectations are met or exceeded as well as cost-effective.
• Responsibility of the successful operation of the load process to ensure the overall performance of the system. The incumbent will do capacity planning and performance management for the BW system. Responsible for managing the production data loads and production support schedule
• SAP BI reporting and solutions SAP Implementation methodology and best practice Working on techniques of Data lineage and tracking the data from source system to its target, working with types of SAP BI data models like relational, Star Schema etc.
• SAP BI/ BEX upgrade from 3.X to 7.0. Migration of reports and testing in HPQC also involved in UAT test.
• Managing the classic software build, deployment, and release cycle between the software development, QA, and operation environments using Kintana Change Manager.
• Understood the Client requirement, prepared the technical specification of the report requirements.
• Involved in the new requirement gathering for DC3 (Distribution Centers) project, which relates to warehouse management and inventory management for ABC Slotting.
• Responsible for Reporting on DIFOT (Delivered In Full On time), SIFOT (Shipped In Full on Time), DOPS (Daily Operational Report).
• Created interactive reports in SD module by extracting the information on delivery and invoice status, shipping details and partner function details.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Designed and developed custom ODS objects, InfoCubes for Inventory data and activated Update rules for these data targets.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies) for Materials and Sales arenas.
• Extracted the data using logistics from Sales and Billing DataSources to populate the Custom InfoCubes that evaluates quantities and values for sales orders, deliveries, returns, and invoices.
• Worked on Inventory cubes for business content DS. Analyzed the requirements to implement Snapshot scenario for cumulative key figures. Worked on 2LIS 03 BX and 2LIS 03 BF Data Sources.
• Statistical Data upload to LIS info structures S260, S261, S262 & S263 for S&D module within SAP R/3 OLTP.
• Installed the Business Content as well as created Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains.

Confidential, Morgantown, WV

SAP BW/BO SME Consultant, Business Analyst

Responsibilities:

• Worked on Gross to Net Project closely with Financial Business systems team to prepare Functional and Technical specification documents (FSDs, TDS,).
• Involved in migrating the Returns, Chargebacks, direct and indirect sales data from CARS (Contract Administration and Reporting System) and MARS (Mylan Automated Returns System) systems into SAP ECC and BI.
• 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.
• 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.
• Monitoring Process chains, daily loads, and production support includes the optimization of the query performance using Performance tuning techniques and working with BWA.
• Worked with FICO to develop an automated Accrual process in the SAP system.
• Involved in Blueprinting for Gross to net project.
• Created Business explorer reports on Sales Returns Allowance (contra asset accrual for returned merchandise) on Credits issued information Cube.
• Worked on Costing reporting to create BEX report on Inventory narrative report, WIP report, Cycle count report, CO-PA.
• Activated the business content for FI AR & GL, SD Sales and Billing & Product Costing.
• 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.
• Developed an interactive report to list the purchase orders details for a vendor that has interactive drill down options to give the details of vendor from vendor master.
• Designed making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Involved in some performance tuning technics to optimize the query performance.
• Production support on inventory narrative report by testing in HPQC with corresponding ABAP reports in ECC.
• Collected and analyzed users business requirements, identified and defined areas for improvements, prepared specifications for development, configured, troubleshooting and supporting for systems users.
• Worked on HPQC Defect Resolution followed by Data fixes & Documentation for User acceptance tests (UAT) and also generate integration test scripts.
• Created exception aggregations, cell editors, formula variables, RFK’s and CKF’s in the queries.
• Extensively worked on RRI, cell definitions, variable offsets, exemptions, conditions, RKF’s and CKF’s.
• Extensively worked in INFOVIEW to create Web Intelligence Reports over the Universe Created.
• Extensively worked on SAP Life Cycle Manager (LCM), transported objects from one environment to another using this brand new tool.
• Extensively trained the end used for BEX and BOE reporting capabilities also delivered a BEX and BOE Power user and end user training materials.
• Responsible for migrating and validating the BO reports from Charge back enterprise data warehouse to SAP Business explorer.
• Creating Adhoc reports for the Power users and end users according to their requirement.
• Testing and creating adhoc queries that are migrated from Business objects XI 3.0 to 4.0

Confidential, Washington D.C

SAP BW/BO SME Consultant

Responsibilities:

• Involved in full life cycle implementation of BI 7.0, ECC 6.0 in SAP CRM Services (Customer Interaction center), Product Master, and FI modules.
• Involved in Blue printing of Functional Specification Documents (FSDs) and Technical Design Specifications Documents (TDS), Business Process Documents (BPDs) for Product Master, Business Partner, Farm Records, and Security for Market sensitive data.
• Involved in writing white paper on requirement to implement SAP HANA for MIDAS Project due to heavy volume of data.
• Worked with BPO’s to capture the actual functional requirements into business process documents in blue printing stage.
• Interacted with Subject Matter Experts (SME), Business Analysts and Users for preparation of Data Modelling, Business Content, Granularity and Queries design. Worked extensively on customization of SD Info Cubes as per the User Requirements.
• Worked on complicated system landscape architecture to consolidate MIDAS data model into FMMI and O&M landscape environment.
• Designed Data flow architecture for Master & Transaction data.
• Worked on Extracting Business partner master data from CRM coming from SCIMS legacy system Maintained in MDM the system of entry.
• Worked on custom extractors as well as business content extractors for both master data and transaction data.
• Enhanced the Data Source for adding new fields in the Extraction Structure according to requirement through User Exit CMOD.
• Worked on Data flow architecture of Business partner for master data reporting requirements.
• Worked on CRM WEB Client UI creating test data in the development to leverage the data model according to Business Partner reporting requirements.
• Created and Scheduled Info Packages for Delta Initialization (Full Load + Selection Conditions) and Delta data loading in to Info Cubes Via PSA, ODS objects.
• Developed Master data flow, reporting on Business Partner Fiduciary relationship, common eligibility, Compliances and non-Compliances reports for deployment 1.0.
• Worked closely with CRM ABAP for AET fields to enable SAP BW relevant.
• Developed BW Content for Business Partner, Product Master, Farm Records, Security for market sensitive data based on technical specifications.
• Involved in Data Source enhancements using user exit to restrict the data for certain limit of time from users.
• Created process chains, variants to automate the manual loads.
• Worked on writing baseline configuration, unit test, string test and integration testing scripts and uploading and executing in Solution manager & HPQC.
• Worked on HPQC Defect Resolution followed by Data fixes & Documentation for User acceptance tests (UAT) and also generate integration test scripts for Customer, Corporate product master, Business Partner, Farm Records.
• Reviewed all SAP BP, PM, Farm records reports and carried out modifications as per Clients requirements.
• Prepared Production cut-over activities & transports strategy for smooth migration to QA & Regression box.
• Used BEx Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI/BW Data Targets to Generate Reports.
• Tested all query performance using RSRT debug mode and executed.
• Worked on tickets and tasks such as load monitoring issues, user issues and enhancements of existing objects.
• Designed and deploy ad-hoc reporting functionality using WebI.

Confidential

SAP BW/BO Consultant1

Responsibilities:

• Worked on three STP data Sources from Non SAP (Flat Files), UD Connect, SAP Controlling and profitability Analysis (CO-PA) Cost based Profitability.
• Worked on See-Through Profitability, a Strategic initiative that will deliver benefits across the organization ranging from sales initiatives that focus more on profitable products to improve product planning to meet the cost objectives.
• Assisting with Annual Strategic Review of Products planning and product positioning.
• Profitability Management- Understanding and managing the key profit drivers (Sales, transfer costs, other cost of goods sold (OCOGS), Operating expenses) and for controlling the product cost structure and improving long-term margin management.
• Building Standard Staging DSO’s as look up tables used in the transformation for master data.
• Participated in Data retention and Archiving managed by Source system team to store the historical transfer files prior 3 fiscal periods.
• Monitoring the info objects updates like 0Material and 0Mat plant before data loads to upper level DSO’s
• Worked on Complex Central FTP Servers (Windows based Central FTP, UNIX based Central FTP) Landscape for Non SAP data from 23 countries and monitored Jobs in Central FTP server.
• Validated and merged the Data from flat files through Central FTP into STP BW- Folder Structure.
• Worked on STP BW High level data flow for master data like corporate product data, corporate product Publishing, Product cost data, Customer data, Unit of Measure Conversion factor, and STP sales data.
• Used start routines, Field routines, and End routines for Unit of measure conversion factor, currency Translation to process transformations.
• Complex custom End Routine created to propagate missing Material Valuation records during DSO updates for Purchase Price Variation Calculations (PPV). Created End routine to calculate PPVbetween the Standard Material cost and Actual Material Purchase Price.
• Fixed BW Test Data fixes like Net value currency translation, code fix for trimming 0’ for Material number, Change of COPA key figures transformation from over written to summation, Unit of measure Description mapping, Invoice quantity field change,
• Worked on HPQC Defect Resolution followed by Data fixes & Documentation for User acceptance tests (UAT) and also generate integration test scripts for Customer, Corporate product master, Unit of measure conversion factor, Product cost.
• Collected and analyzed users business requirements, identified and defined areas for improvements, prepared specifications for development, configured, troubleshooting and supporting for systems users.
• Implemented verification script for BW objects imported. Also Participated in Cut over Transports and Data load Execution.
• Participated in Post Go-Live support and Go-Live Cutover plan with BI support Team, Validate STGP Reports against Previous reports backup. Reviewed STGP Reports with Business and explained any variances.
• Worked on Data Enhancements at post Go-Live in Webi reporting by joining the two queries, STP Sales and STP Product cost to report on material level sales.
• Provide day to day Post Go live support includes scheduling and monitoring data loads, report processing, supporting report developers, performing requirements gathering and data modeling for system enhancements and future releases, addressing production break and fix issues, managing transport migration process, recommend and implement performance tuning enhancements as needed and researching OSS notes.
• Used BEx Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI/BW Data Targets to Generate Reports.
• Migrated Bex Queries from old development and to new development which is service pack 3 (Fix Patch). Established the QAAWS connections by applying filters and user privileges.
• Performed GAP Analysis between existing STP Webi Universe with new STP Dashboard universe.
• Involved in the migration and deployment of the universes and reports across multiple domains.
• Designed and implemented training materials for End Users highlighting upgrade enhancements andnew functionality.
• Monitoring daily, weekly and monthly loads and sending the load status reports to business users.
• ConocoPhillips is an international, integrated energy company. As of Dec. 31, 2010, it is the third-largest U.S. integrated energy company, based on market capitalization, as well as proved reserves and production of oil and natural gas, and the largest refiner in the United States. ConocoPhillips is the seventh-largest holder of proved reserves and the fourth-largest refiner worldwide, of nongovernment-controlled companies.
• Involved in full life cycle implementation of BI 7.0 in SD, MM, AND FI modules.
• Worked on Data Modelling, Data Extraction, Data transformation, Data Loading, Scheduling jobs, Monitoring data loads and Reporting.

Confidential, Bartlesville, OK

SAP BI/BW Consultant

Responsibilities:

• Customized Info Cubes, Info Sources, Multi Providers, Update Rules, and Start Routines. Installed Business Content, Performed Generic data extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring, Performance tuning and extracting.
• Worked extensively on Data Modeling design like creating Info Objects, Info Catalog, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Extensively Worked on SAP ECC Extraction of Financial data, CO-PA and Sales & Distribution Lo-Cockpit.
• Worked on generic data extraction in CO-PA. Extracted Line Item data from GL, AR and AP.
• Extracted data from MM (Stock Initialization - “2lis 03 BX” data sources). Extensively worked in performing customer, vendor analyses in BW, and integrating data from Teradata to BW using UD Connect.
• Created Custom DataSources and enhanced datasources where even necessary and populated those fields using customer exits.
• Customized existing financial Info cubes, ODS and Multi providers according to business needs in SAP BI.
• Debugged Data load errors, Delta Queue Monitoring, and Extractor Checker to trace and fix errors.
• Created DTP’S to load data from Flat File via Data Source into Staging DSO and initialized it by using Full & Delta process.
• Worked with FI Cubes to enhance the performance (Modeling, Data load) from other systems and did currency conversions for Country specific data sets.
• Improved performance by managing Info cube, which involves Info cube content, monitoring performance issues like Indices, Statistics, compression of Info cube and rolling up the data to the aggregates.
• Used start routines whenever possible to process transformations. Activated and Customized profit center accounting cubes, accounts payable cubes/accounts receivable cubes. Created Multi-Providers on Sales, Deliveries and Billing Info cubes.
• Involved in the design and development of Profitability Analysis (PA) Cube in Controlling (CO) and Profit Center Accounting (PCA) as part of SAP FICO implementation.
• Created Process Chains to automate the data load and data target administration and monitored the processes.
• Worked on BEx Analyzer, BEx Browser and WAD (Web Application Designer) tools to generate reports related SD, MM, and PP.
• Involved in Ad-hoc query development and data mining.
• Extensively worked with queries, workbooks and created Ad-hoc queries in WAD.
• Used BEx Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI/BW Data Targets to Generate Reports.
• Worked on WebI components to develop reports on universes using Universe Builder XML components.
• Performed on pre calculated Web templates and also OLAP Cache.
• Designed Universes and classes by Business Objects XI 3.1 enterprise tool and build all the objects required for WebI reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions.
• Reviewed all SAP MM reports and carried out modifications as per Clients requirements.
• Developed customer exit for variables and coded in user exit for BEX reporting.
• Created Training Documents with step-by-step procedure and with screen shots on Data Modeling in BI 7.0.
• Handled performance tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes.
• Involved in transportation of objects to target systems and handled transport related issues.

Confidential, Carlsbad,CA

SAP BI/BO Consultant

Responsibilities:

• Involved in the full life cycle implementation, which includes Gap Analysis, design, development, testing, implementation and support.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA) and customized them as per the client requirement.
• Developed write optimized DSO’s for EDW layers and standard DSO for consolidation layers and created direct update DSO’s and APD for creating history data and for snapshot scenario reports.
• Developed transformations with start routine, update routine and end routine and involved in the creation and maintenance of DTP and InfoPackages for loading data in to data targets.
• Created generic data sources with Function module extraction method.
• Enhanced master data and transaction data sources with Z-fields and are populated them using User Exits.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement. Dealt with extractions involving standard COPA data sources, PCA, CCA.
• Enhanced the business content data sources by appending structures, User Exits and customized delta built up for the data sources
• Worked on Accounts payable cubes and accounts receivable cubes and enhanced the performance (Modeling, Data load) from other systems and did currency conversions for Country specific.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEx queries to facilitate reporting on InfoCubes, InfoSets, ODS and MultiProvider
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source.
• Generated month to date and year to date reports for MM and FI and monthly distribution reports for Human Resources
• Created formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Created exception aggregations, cell editors, formula variables, RFK’s and CKF’s in the queries.
• Extensively used WAD and published reports on Enterprise portal as iView
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created inventory accuracy Dash Boards (Xcelcius) and for management reports for inventory management and wages and costs report from cost center accounting
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business.
• Involved in the migration and deployment of the universes and reports across multiple domains.
• Implemented analytics across the organization and used tabs on company performance via flexible management dashboards and implemented index awareness.

Confidential, Hillsboro, Oregon

SAP BI/BO Consultant

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing (UAT) to Go live production support.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
• Extensively worked on SD info cube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR, APO reports.
• Created new info providers in SAP BI depending upon the end user needs.
• Extensively worked on BEx reporting and workbooks.
• Extensively worked on RRI, cell definitions, variable offsets, exemptions, conditions, RKF’s and CKF’s.
• Extensively worked on Central Management Console (CMC) in configuring Bo environment.
• Defined BO Classes, Objects, in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and Infocubes of SAP BI using Universe Designer
• Extensively worked in INFOVIEW to create Web Intelligence Reports over the Universe Created.
• Created Web I report with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Extensive experience in creating reports with Charts (bar chart, Pie chart…etc), Cross-tabs and Sub reports.
• Extensively worked on SAP Life Cycle Manager (LCM), transported objects from one environment to another using this brand new tool.
• Transferred objects from Development to Quality and to production using SAP LCM, including security rights.

Confidential, GA

SAP BI/BO Consultant

Responsibilities:

• Involved in the knowledge transfer sessions from business users/application owners for the Catapult project.
• Understanding the Business process, Business requirements and landscape of BW system; involved in data model design and documentation.
• Extensively worked on service desk tickets, development and production support.
• Activated the business content for FI AR & GL, SD Sales and Billing & Product Costing.
• Enhanced the Customer master with Credit Limit field for Customer payment analysis.
• Worked on Sales document Header, Item, and Schedule line items data sources and ODS objects.
• Developed ODS object to load transaction data from Info Source and defined update rules.
• Created various Info Cubes (Billing Cube, Delivery Cube, and Sales overview cube), assigned dimensions to the characteristics and activated Update rules for the Info Cubes.
• Created and Scheduled Info Packages for Delta Initialization (Full Load + Selection Conditions) and Delta data loading in to Info Cubes Via PSA, ODS objects.
• Enhanced the Cost of Production cube with SCOP Type based on combination of Cost Element and Procurement type in BW.
• Worked on custom extractors as well as business content extractors for both master data and transaction data.
• Debugged and modified ABAP routines for user exits start routines, update rules and transfer rules.
• Modified data sources and Info sources to add new characteristics.
• Created process chains, variants to automate the manual loads.
• Extensively worked on BEx reporting.
• Worked on Cost of Production report, which shows the variance from target to actual.
• Created restricted key figures and formulas in the reports.
• Modified Status Code/Follow Up report to populate the right status codes on the report.
• Monitored the COAP loads closely as there were few errors in the initial design.
• Monitoring daily, weekly and monthly loads and sending the load status reports to business users
• Involved in Delta issues, process chain failures and table space issues.
• 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.
• 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.
• Designed Info cubes with daily and Monthly Granularity, extraction from PSA.
• Extensively involved in debugging ABAP Routines.
• Developed routines to implement complex pricing requirements not handled by standard SAP.
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries.
• Improved the query performance by creating aggregates.
• Worked on Query development Templates and Workbooks in BEx Analyzer.
• Created interactive reports in SD module by extracting the information on delivery and invoice status, shipping details and partner function details.
• Extensively used BEx Analyzer, created queries with Variables, restricted key figures, calculated key figures, conditions, exceptions etc.,
• Designed documentation for queries using BEx Analyzer Reporting tool for presentations.
• Extensively involved in the job scheduling and monitoring of info packages using SAP BW Administrator Workbench.