Senior Sap Bi/bo Consultant Resume
Los Angeles, CA
SUMMARY
- More than Six (6+) years of experience in SAP BW/BI as a Technical Consultant alongwith 2 years experience in SAP BOBJ. With strong SAP business user relationship.
- Experience in Identifying reporting requirements with prime end users and translating teh user requirements into technical documentation and into BW data warehouse models.
- Experience in activating and enhancing standard ECC data extractors and developing customized extractors using tables, views, and function modules.
- Experience in extracting data using Flat files, Standard extractors, Customized extractors.
- Experience in writing ECC User Exits to enhance teh standard extractors in FI, SD and MM and HR.
- Experience in SAP BW multidimensional Data Modeling and BW Customizing.
- Experience in developing Info Cubes, Multi providers, Aggregates and ODS/DSO objects.
- Experience in developing Transformations and DTP’s with start & end routines in BI 7.0.
- Experience in performance tuning of BW systems. Evaluated statistical performance and improved data load, query performance by using compression, aggregates, partitioning techniques.
- Created/Modified teh complex BEx queries which use Exceptions, Filters, Variables, Structures, Hierarchal info objects, calculated and restricted key figures.
- Knowledge in SAP Business Objects tools like Universe, Web Intelligence, Crystal Reports, and Xcelsius.
- Experience in creating process chains and scheduling batch jobs.
- Production support experience in handling batch jobs, load failures, delta failures and system issues.
- Expertise in Unit Testing, Regression, Integration, UAT (User acceptance testing), E2E testing, Defect documentation and problem log retesting using Mercury.
- Experienced with ASAP Methodologies (Project Plan, Requirements Gathering, Gap Analysis and Project Realization).
- Strong Basis & database knowledge and created roles for different users with different security levels.
- Extensive experience in Business Analysis, GAP Analysis, Requirement Gathering, and Solution Delivery.
- Working experience of Onsite - Offshore modeling.
- Excellent communication, presentation and interpersonal skills a total team player. Self-starter with drive, initiative and a positive attitude.
TECHNICAL SKILLS
ERP: ECC 6.0, 5.0, SAP R/3 4.7, 4.6c
Business Intelligence: BI 7.0, Netweaver2004s, BW 3.5, 3.1c
Programming Languages: SQL, PL/SQL, ABAP/4.
Databases: Oracle 10g, DB2 V9, SQL server, MS Access, and MS-SQL Server
Reporting Tools: BEx Analyzer, WAD,MS Office, Business Objects
Scripting Languages: XML, HTML, and VBScript
Protocols: TCP/IP, FTP, SMTP, POP and HTTP
Operating Systems: Windows 95, 98, 2000, XP, AND UNIX
PROFESSIONAL EXPERIENCE
Senior SAP BI/BO Consultant
Confidential, Los Angeles, CA
Environment: SAP BI 7.0, ECC 6.0, DB2 V9, BEx Analyzer, Windows NT, BO XI 3.1, SD
Responsibilities:
- Gathering Business Requirements from Users & Business Analysts for data modeling.
- Identified teh gaps and suggested necessary enhancements for transaction data and master data extractors.
- Performed extractions from multiple source systems including SAP, (using LO, LIS, Generic extractors) XI, Ascential and flat files.
- Used LO extract structures for extracting sales order, delivery-billing information.
- Involved in customizing extract structures for SD data sources like 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 03 BF.
- Worked extensively with payroll results from cluster, headcount and Personnel actions Extractors and enhanced respective cubes & DSOs. Installed Time Sheet Data cubes & Multiproviders 0CATS C01, 0CATS C02, 0CATS MC1 in CATS.
- Installed Payroll and Personnel Time Management cubes 0PT C01, PY C02 & 0PY MC02. Extracted Payroll data using teh Payroll Data sources.
- Worked extensively on transfer rules, update rules and user exits for transaction data.
- Creation of Info packages for scheduling data load process with Full and Delta update mode. Created transformations and DTPs for teh necessary objects in development.
- Worked extensively on BEx Query Designer. Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
- Expertise in Reports Generation using BEx Analyzer, building Queries and saving Workbooks (Excel Work Sheets), creation of Custom Queries using conditions, exceptions, variables & structures and created aggregates for frequently used queries.
- Used RRI feature to jump between teh Queries to analyze teh data efficiently.
- Worked extensively on Data warehousing workbench and managed and monitored data loads with Full update and Delta mechanism.
- Handled performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
- Performed data integrity testing by executing Bex Queries validating against teh backend ECC System.
- Created Drill through queries from summarized Info Cube to detail DSO data.
- Worked effectively on BOBJ (Creating Universes, creating reports through WEB Intelligence).
- Worked on ABAP coding in BW, Start Routines, Update Rules, Transfer Rules and Customer Exit variables coding. Also Start Routine and End Routine in BI 7.0.
SAP BI/BO Consultant
Confidential, San Dimas, CA
Environment: SAP ECC 6.0, BI 7.0, BEx, BO XI 3.1
Responsibilities:
- Involved in gathering Business Requirements at ADP (Tax and financial services) from Users & Business Analysts.
- Analyzed Functional specs and created technical specs and Unit Test scripts for Client fund obligation project.
- Prepared teh sizing chart for CFOP project to handle huge volumes of data and prepared blue prints.
- Involved in migrating mainframes data to BW through flat files for ADP tax services.
- Customized Business Content InfoSources, InfoCubes and activated Business Content to meet business requirements.
- Designed and created time dependent master data objects as per teh project needs
- Involved in using teh new functionalities of BI 7.0 like creating write-optimized DSO’s for staging raw data.
- Designed Datasources, Transformations, and DTP’s and activated teh same.
- Written routines at different levels like start routines, end routines and field level routines.
- Written extraction routines using ABAP for master data, texts and hierarchies
- Created MultiProviders for specific queries of FI and SD
- Created Process chains for effective scheduling of various Daily and weekly loads.
- Modified teh application-specific and generic data extractors in FI and SD.
- Modified and wrote user Exits using ABAP to fill teh appended extract structure with teh data and extensively involved in developing queries for populating dates.
- Extensively used BEx Analyzer to design complex queries related to Payroll, Receivables, profitability, obligation and audit reports.
- Created BEx reports with cell definitions, conditions, exceptions, replacement path variable, calculated key figure, restricted key figure and user exits
- Created complex BEx reports using different kinds of variables like Characteristic, Hierarchy, Hierarchy Node, Text and Formula.
- Activated teh BEx broadcaster and information broadcasting.
- Used RRI jump queries for drilling down to other queries and ECC transactions.
- CreatedOSS Ticketsto report issues to SAP regardingBusiness Objects Integration.
- Interacted with user to gather reports requirements and designed technical and functional specifications.
- Installed Xcelsius 2008 with SAP3 on teh server and handled using teh Xcelsius 2008 to develop teh executive Dashboards.
- Built Universes and Created Complex and Ad-Hoc Reports using Web Intelligent, Live Office, Xcelsius and CMS XI.
- Involve in building financial & budgeting reports and applying functions based on requirements.
- Managed Transport Procedure through different environments. Thoroughly examined transport log for failures and fixed them accordingly.
- Involved in activating teh BI Statistics and running teh statistic reports for performance issues.
- Worked in Production support and handled batch jobs, load failures, and system issues.
Senior SAP BI/BO Consultant
Confidential, Sparks, MD
Environment: SAP ECC 6.0, BI 7.0, BW 3.x, BEx, BO XI 3.1.
Responsibilities:
- Team member of SAP BI 7.0 implementation.
- Involved in gathering Business Requirements from Users & Business Analysts for designing functional and tech specs.
- Customized Business Content InfoSources, InfoCubes and activated Business Content to meet business requirements.
- Extensively involved in creating InfoCubes in teh areas of HR, SD and FI modules.
- Worked extensively with payroll results from cluster, grievance, headcount and Personnel actions Extractors and developed respective cubes & DSOs.
- Assisted teh Business Process Team in creating Functional Design Specs for Conversions and Interfaces
- Worked extensively in teh HR functional areas of Benefits, Employee Job History, Work Unit Seniority, Disability, Payroll, Grievance, Training, Resumix, Spot Bonus, Ace Awards, PTS, Exam Interactions, Qualifications, E-Recruiting, Questionmark.
- Designed InfoSources, activated transfer and update rules, scripted extraction routines using ABAP for master data, texts and hierarchies.
- Enhanced teh Info cubes by adding custom InfoObjects to reflect modified ECC business process.
- Created MultiCubes for specific queries of SD, HR and FI.
- Extracted transactional data like sales order and delivery-billing information etc data using LO cockpit extract structures.
- Created master data InfoSources for uploading master data and hierarchies.
- Modified teh application-specific and generic data extractors in FI, SD and Logistics and cross-application generic extractors, and customized delta built up for teh data sources.
- Modified and wrote user Exits using ABAP to fill teh appended extract structure with teh data and extensively involved in developing queries using filters.
- Created Process chains for effective scheduling of various processes.
- Worked in Production support and handled batch jobs, load failures, delta failures and system issues.
- Handled data migration from different SAP systems to a Single Global system.
- Extensively used BEx Analyzer to design complex queries.
- Created reports where cell definitions, conditions, exceptions and virtual key Figures were used.
- As a Business Objects Admin created rolls and groups in Central Management Console and based on teh profile give access to Business user.
- Designed and Created reports using Crystal reports XI /10
- CreatedAd hocReports using End User module in Business Objects.
- Developed dashboards usingBusiness Objects Xcelsius.
SAP BW Consultant
Confidential, Detroit, MI
Environment: SAP R/3 4.6C, BW 3.5, BEx Analyzer, Web Reports.
Responsibilities:
- Responsible for overall master data and transaction data.
- Developed multi-providers and created reports on them.
- Responsible for developing and maintaining Process Chains.
- Configured Reporting Agent for Exception Handling.
- Extensively involved in teh enhancement of BCT Data Sources and development of Generic Data sources.
- Used both initializations with delta update and Full update methods depending on teh business requirement.
- Created Info-Packages group to schedule Info-Packages to load master data.
- Prepared Dataflow Document, Technical Design Documents, Application Design Documents
- Involved in teh Unit testing, System testing and Integration Testing of teh BW configurations.
- Developed a number of transaction Cubes and basis cubes.
SAP BW Consultant
Confidential, Omaha, NE
Environment: SAP 4.6c, BW 3.5, BEx.
Responsibilities:
- Participated as member in pilot BW implementations team in USA and contributed towards logical data modeling of Info cubes and ODS.
- Document reporting to teh needs of teh business service and support organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
- Developed ODS and InfoCubes for sales and controlling areas like procurement, cost center, order status and sales overview.
- Designed InfoSources, activated transfer and update rules, scripted extraction routines using ABAP for master data, texts and hierarchies.
- Used LO extract structures for extracting sales order, delivery-billing information.
- Extended standard Business Contents based on client requirements using User Exit and Function Module.
- Enhanced and Modified teh application-specific and generic data extractors
- Extensively involved in creating InfoCubes in teh areas of SD, MM and FI modules.
- Set up source systems to load both SAP/R3 and non-SAP transaction data to BW.
- Created and scheduled Info Packages for Full, Delta Initialization, and Delta updates to load both master and transaction data. Created process chains to automate teh data load and data target administration.
- Written routines (start routines, update routines) using ABAP in update rules and transfer rules to update key figures in teh InfoCubes.
- Created Multiproviders, assigned user groups to teh Multiproviders. Created exception evaluations for queries. Designed multiple drill-through reports from BEx Queries.
- Extensively involved in designing complex queries for open sales order analysis, Vendor performance analysis, delivery analysis, past-due sales orders, outbound shipping, and General Ledger reports.
- Created formula to calculate profits, % variance and YTD Actual.
- Created complex reports where cell definitions were created in teh queries for explicit formulas.
- Used conditions and formula variables for Top NN reports and Exceptions were used as per teh requirements
SAP BW Consultant
Confidential
Environment: SAP R/3 4.0B, SAP BW 3.0B, BEx.
Responsibilities:
- Involved in SAP BW implementation, support post production.
- Involved in gathering Business Requirements from Users & Business Analysts for sizing & data modeling.
- Administering through BW workbench. Involved in end to end design and construction of BW objects.
- Designed, developed and modified InfoObjects, InfoCubes, ODS Objects, InfoSources, Transfer rules, Update rules to suit teh business requirements.
- Involved in creating Sales, Billing, Shipping, Finance and Profitability Analysis InfoCubes.
- Involved in creating Multicubes, Infosets based on teh requirements and reporting on them using BEx.
- Extracted data from SAP R/3 using LO Cockpit, CO-PA, Generic, Business Content Extractors and from flat files.
- Enhanced extract structures using User exits in ABAP.
- Used Delta Update process for loading teh data to BW from R/3 in specific intervals. Used interface DB connect to get data from external sources.
- Populated teh Info Objects, ODS Objects and InfoCubes with Master data and Transactional data from SAP R/3 via Data Staging area (PSA) by creating InfoPackages.
- Created Process chains for effective scheduling of various processes.
- Wrote ABAP/4 routines to enhance Business Content Data Sources to meet teh business requirements.
- Created Drill through queries from summarized InfoCube to detail ODS data.
- Transported InfoObjects, InfoCubes, Queries, update rules, Multi cubes from Development to Quality.