SUMMARY

• Over 7 years of experience in working wif SAP BI/BW and BO XI, EDW and ETL.
• Experience in 3 full life cycle implementation for different modules in SAP BI/BW following ASAP methodologies which involves Documentation, Requirement analysis Blue Printing, Gap Analysis, Realization, Data extraction, Data modeling, Data loading, testing, production Support, End user documentation, Reporting and Go - Live check.
• Experience in Installation and Configuration, Creation of repositories and security configurations. Performance tuning and optimization of BI solutions including capacity planning, migration procedures, and usage analysis.
• Expertise on OLTP extractions from SAP R/3, and new products like CRM and SCM using LO Cockpit, CO-PA, LIS, Generic Extractors and non-SAP R/3 extractions like Teradata using DB connect and also extracting data from flat files.
• Experienced in interacting wif Business Users to analyze teh business process and requirements and transforming requirements into screens, designing/analyzing database and documenting.
• Expertise in business warehouse components - Info Objects, Standard and Custom Info Cubes, DSO’s, Info packages, DTP’s and Transformations.
• Experience in ABAP/4, Update/Transfer Routines.
• Worked on BW system, Data Warehousing concepts including data modeling, ETL, Query, Report Design, BW Web Reporting and Open Hub Service.
• Worked on various kinds of Performance Tuning techniques such as Aggregates, Rollups, Indexes, partitions, and Info cube compression techniques.
• Good knowledge of Dimensional modeling, Data migration, Data cleansing, Data profiling, Data mining, Data audits and Web reporting features of data warehouses.
• Responsible for design and configuration of Cost Centerplanningmodel.
• In teh BEx Analyzer and Web Application Designer, build planning applications that support both manual and automatic data entry and changes to data.
• Experience in Design and Development of Universes using Business Objects Enterprise products namely - Business Objects XI R3/R2, Crystal Reports and Xcelsius.
• Worked extensively on Designer, Web Intelligence (webi), Desktop Intelligence (Deski), Crystal reports and Central Management Console (CMC).
• Developed various reports using Desktop Intelligence and Web Intelligence using teh Universes built.
• Experience in implementing Business Objects report management wif Finance, Sales and Marketing, Pharmaceuticals and Retail.
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created different types of reports like Master/Detail, Cross Tab and Chart.
• Designed and Developed extensive Business Objects reports using multiple Queries, combination of chart and tables.
• Imposed several Joins, Filters, and Alerter to restrict teh unwanted data and highlight teh required data.
• Provided Technical Assistance/Support to analysts, business community and responded to inquiries regarding errors, problems, or questions wif programs/interfaces.
• Created teh Universe and report check list templates, which are used as check points before moving teh migrated objects into QA and Production environments.
• Worked closely wif teh Architects to address teh performance issues from teh server side.
• Created teh reports using Crystal Reports functionalities like Add Queries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along wif Dropdown lists etc.
• Generated reports wif complex, business views, ad-hoc reports, dashboards, list of values (LOV) along wif user acceptance test (UAT).
• Published Crystal Reports on to Business Objects Infoview and provided access to teh end users.
• Expertise in using Import Wizard to migrate reports and universes between different environments like development, testing and production.
• Experience in creating users and user groups, restricted access of teh users as needed using Central Management Console (CMC). Involved in managing users, groups, folders and published reports.
• Experience in Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling.
• Migrated Business Objects environment from Business Objects Enterprise from XIR2 to XIR3.
• Experienced on creating dashboards using Crystal Xcelsius 2008 by importing data files to create teh visualization utilizing QAAWS and Live Office.
• Experienced to support teh issues wif reports on teh crystal enterprise environments.
• Experienced to Sign-Off on teh crystal enterprise and Ad-Hoc application after teh release.
• Created Executive dashboards for teh upper management showing summary metrics for teh Key performance Indicators (KPI’s).
• Strong planner and organizer wif demonstrated ability to develop business solutions that increase efficiency, productivity, and profitability.
• Created WEBI reports and Crystal reports and deployed them through info view wif BW universe as source and created Inventory accuracy dash boards using Xcelcius.
• Resolved performance issues by writing stored procedures and command objects in crystal reports and performed unit testing, system integration testing, and user acceptance testing at various levels.
• Worked on pre-calculated web templates and used control queries to increase teh performance of teh query and also worked on OLAP cache.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Built, designed, and tested various levels OLAP and OLTP reporting systems using Business Objects product suite. Strong skills in interfacing Business Objects wif Databases like Oracle.
• Articulate wif excellent communication and leadership skills and teh ability to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

ERP: SAP ECC 6.0/5.0, R/3 4.7

ETL Tools: SAP Netweaver 2004s BI 7.0, 7.3,BW 3.1C, 3.5, 7.0

SAP Modules: SD, MM/WM, FI/CO, PP, QM, HR, CRM4.0, SCM 5.0, APO 7.0, Integrated Planning.

Reporting: BEx Reporting (BI 7.0/BW 3.5), BO XI 3.1, 3.0, 4.0, Xcelsius, Crystal Reports.

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

Operating Systems: Windows 9x/2000/XP/Vista/7, Ubuntu, Mac

Web Technologies: HTML/Dreamweaver/FrontPage/XML

Documentation: MS-Office, Quick Test Pro

RDBMS/DBMS: Oracle/ MS-Access/ My SQL/ Windows 2003/ Apache Tomcat

PROFESSIONAL EXPERIENCE

Confidential - San Diego

SAP BW/ BI/ BOBJ Consultant

Environment: SAP NetWeaver 2004s BI 7.0, 7.3, ECC 6.0, Business Explorer, SD, FI-CO, ABAP, Business Objects 4.0, Xcelsius, and Crystal Reports.

Responsibilities:

• Understood teh business challenges and translated them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
• Activated teh Business Content for Accounts payable (AP), Accounts Receivable (AR), Cost Center Accounting (CO-CA) and customizing them as per teh client requirement.
• Created Generic extractors using Info set queries.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multiprovider, 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.
• Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C03, and ODS such as 0FIAR O03, and 0FIAP O03 wif proper transfer rules and update rules.
• Extracted Master and Transaction Data from Flat files and loading into Info Objects, DSOs and InfoCubes.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC Generic Extractions and also in BI data modeling like Start Routines and End Routines.
• Created Aggregates on Info Cubes to improve teh query performance.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions wifin queries, maintained Query settings and tuning.
• Created Daily Sales Reports which involves Daily Sales Orders, Order Reasons, Customer Group and other important sales data.
• Worked on Business Objects using Universe design, Dash board reporting.
• Defined BO Classes, Objects, in teh Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and Info cubes of SAP BI using Universe Designer.
• Created universes, classes and objects by retrieving teh data from data sources like BW queries and defining necessary connections.
• Involved in teh migration and deployment of teh universes and reports across multiple domains.
• Customized LOVs in Universes for quicker performance of reports.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Extensively used teh wizard in WAD and published teh reports on Enterprise Portal as iView.
• Extensively Worked in SAP Live Office to create connections between WEBI and Xcelsius Dashboards.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Developed performance testing on all application servers.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.

Confidential, Los Angeles, CA

Sr. SAP BW/BI/ BOBJ Consultant

Environment: SAP Net Weaver 2004s BI 7.0, 7.3, ECC 6.0, Business Explorer, HR, SD, FI-CO, ABAP, MM, APO, Integrated Planning, CRM, Business Objects 4.0, Xcelsius, and Crystal Reports

Responsibilities:

• Involved in full life cycle implementation, which includes Requirements gathering, Gap Analysis, Blue printing, and Development, Testing, Reporting, Go-live and Post Go-live support.
• Gathered user requirements, mapping against deliveredSAPcontent, and translating into a coherent design document.
• Extracted teh data from HR modules and uploaded teh data into HR Info Cubes for 0PY C02 Payroll data, 0PABN C01 Benefits, Staffing Assignments 0HR PA OS 1, 0HR PA CM 1, and 0PT C01 Time and Labor Data and worked on transformations.
• Extracted data from ECC and other data sources by creating custom data source.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Worked on teh enhancement of teh business content data sources by using ABAP in append structures and user exits from transactions CMOD.
• Involved in preparing Use Cases and Business flow diagrams for FICO applications
• Worked on FI - GL, FI-AR, FI- AP, FI- AA, COPA data sources for extraction and loading of data from FI to BW.
• Installed Business Content for Financial and Profit Center Accounting Info Cubes and customized teh FI-GL, FI-AR, FI-AP business content cubes for meeting teh business requirements
• Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes; coding in start routines and end routines.
• Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in teh InfoCubes to facilitate various reporting requirements like teh Price Purchase Variance and Foreign Exchange Exposure reports.
• Activated Business Content InfoObjects, Info sources, data sources, DSOs, Info cubes, and Multi-providers.
• Designed teh Data flow for extracting Sales and Shipment Data from ECC to APO/BI and extracted data from teh Planning Area.
• Master and Transaction Data extraction from Flat files and loading into InfoObjects, DSOs and Info cubes.
• Compressed teh Info Cube data for better performance.
• Created Planning/forecasting models, aggregate plan/forecast data, evaluate plan/forecast results, info cube settings, planning applications through WAD, Data Slicing and input ready queries.
• In teh BEx Analyzer and Web Application Designer, build planning applications that support both manual and automatic data entry and changes to data.
• Performed performance tuning of queries using indices, aggregates, compression and partition
• Provided production support for Process chains, loads from ECC to BI, reconciling issues between ECC and BI, and other issues wif teh loads.
• Worked on SCM APO integration wif BI, demand planning (DP) and designed remote cubes for APO Forecast analysis, and Multi cubes to facilitate reporting combining history and forecast.
• Generated reports on Multi cubes to compare teh plan/Actual production quantity.
• Designed BI queries on Demand plan data to check for availability of products, TLB and managing of stock in warehouses.
• Used teh APD to perform several look ups to tie teh transaction data to specific master data attributes.
• Developed Business Intelligence (BI) Reports and Structures via BEx. Developed BW reports using Bex analyzer, created queries wif variables, restricted key figures, calculated key figures, conditions, exceptions etc.
• Developed planning book wif several custom macro for smoothing teh forecast, alerts and DP-BOM functionalities
• Created Universe based on two different data sources.
• Design and developed WEBI query and WEBI reports from standard and custom universe.
• Enhanced teh standard universe for teh webi reporting.
• Generated Webi Reports using teh Universe as teh main Data provider and also using teh personal data files provided by teh users. Designed Universes for Financial billing system, Sales Order processing and Sales analysis by location, Sales Analysis by country reports.
• Build teh new universes as per teh user requirements by identifying teh required tables from Data mart and by defining teh universe connections.
• Demonstrated experience using Business Objects Universe Designer to create BO universes against BW as a data source (MDX and non-MDX methods)
• Used Business objects Security on report using CMC and setting up profile options.
• Created Web Intelligence Documents using Multiple Queries, filters, formulas, cascading parameters etc.
• System testing and UAT developed for teh business user and super users.
• Performance tuning of webi reports was performed for all teh reports developed using Info view webi.
• Performance testing developed in all teh application servers.
• Worked on Mobile Server Support, Data Federation.
• Worked on Lifecycle Management Console.
• Knowledge on SAP BW Publishing Server.
• Created BIAR File using Import Wizard for Deployment of Universes and Web Intelligence
• Worked on Information Design tool.
• Backup plan for execution created for teh client development and production system.
• Involved in all phases of migration from Crystal Enterprise 10 to XI R2.
• Used Crystal Reports 10 as teh reporting tool for teh web interfaces
• Created Crystal Reports using MDX query.
• Published Crystal Reports in web based environment using Crystal Enterprise.
• Generated number of query reports such as Master/Detail, Cross Tab and Chart (for trend analysis) using Business Objects Report Designer
• Used Multi-Dimensional Analysis including slice-Dice, Drill up/down/across/through methods
• Resolved loops wif Aliases and Contexts.
• Business user Training and Best practice developed for teh client BOBJ XI 3.2 and BI Universe, Java Info View.
• Responsible to support teh issues wif reports on teh crystal enterprise environments (Development, UAT, Test and Production).
• Responsible to Sign-Off on teh crystal enterprise and Ad-Hoc application after teh release.
• Developed reports for Weekly Schedule, Monthly Schedule and Quarterly Reports like Production Plan Vs Actual Plan reports.
• Used Xcelsius in creating dashboards from teh universe.
• Worked on Xcelsius for interactive Dashboards for analysis of Quarterly and Yearly sales.

Confidential, Houston, TX

Sr. SAP BW/BI/BOBJ Consultant

Environment: SAP ECC 6.0, SAP-APO, Integrated Planning, SD, FI, SAP BI 7.0, and ABAP, BEx query Designer, BEx Analyzer, Business Objects, Xcelsius, and Crystal Reports.

Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Interacted wif teh end users to understand their reporting requirements and creating document of understanding.
• Extracted data from standard Business Content sales, PO and Inventory extractors and custom-built extractors depending on requirements.
• Worked on LO-Cockpit Extraction and customized extractors.
• Extracted data from teh finance modules like AR, AP and GL and enhanced teh standard data sources 0FI AP 04, 0FI AR 04 to meet teh client requirement.
• Expertise in DataSource 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.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC generic extractions and also in BI data modeling like Start Routines and End Routines.
• Built User exits for all teh applicable applications using CMOD to populate teh data from teh respective application tables
• Master and Transaction Data extraction from Flat files and loading into InfoObjects, DSOs and InfoCubes.
• Performed analysis, design, development and implementation of standard/customized InfoCubes and DSO Objects for SD, FI and SCM modules.
• Created intermediate write optimized DSO Structures and APD’s in BI7.0 to improve performance while loading AP data.
• Worked on customized and standard InfoCubes.
• Defined transformations, created DTP’s and Infopackage for scheduling loads to data targets.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads wif full update and delta mechanisms.
• Generated regular and customized data sources from APO DP planning areas. Used Multiproviders and Infosets to extract data from tables and table joins.
• 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.
• Created Calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions wifin queries, maintained Query settings and tuning.
• Involved in designing and implementing user security at query level and cube level.
• Developed Universes using SAP BI/BW Queries as Source Data.
• Worked on NetWeaver BI, which includes a fully functioning MDX query builder that you can use to connect to BEx OLAP-enabled Query Cubes, InfoCubes, and MultiProviders.
• Experienced wif Xcelsius Content Management solution, Crystal Reports, Business Objects XI (Premium, Metadata Mgmt.), Business Objects Data Services and Objects Xcelsius Enterprise.
• Created Objects and prepared Reports like financial reports, standard and ad-hoc reports, and universes.
• Imported/ Exported teh Universes from/ to repository to make them accessible to end-users.
• Developed planning book wif several custom macro for smoothing teh forecast, alerts and DP-BOM functionalities.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for Creation of teh universe wif Classes, Objects and Condition Objects.
• Customized LOVs in Universes for quicker performance of reports.
• Created WEBI reports & Crystal reports and deployed them through Info View wif Universe as Source.
• Created Crystal Reports using MDX query.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Responsible for developing Analytical Reports wif multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using teh Business Objects Enterprise XI.
• Publishing reports using Infoview and categorized it for different department to improve teh performance and trained users for ad hoc reporting.
• Created reports using having Alerter, Ranking, Multiple contexts, custom built Hierarchies, Multiple sorts, filters and reports having complex formulae and logic.
• Created reports like, Reports by Product, Reports by Customer, Reports by Period, Demographic reports and Comparative reports.
• Created Inventory Accuracy Dash boards and for Management Reports for Inventory Management, and Wages and Cost report from Cost Center Accounting data.
• Worked on Xcelsius dashboard development using web service on top of SAP BW Trained Power Users on teh new reporting tool-Business Objects.

Confidential, Canonsburg, PA

Sr. SAP BW/BI/ BOBJ Consultant

Environment: SAP ECC 6.0, BW 7.0, (BOBJ) Business Objects XI 3.1/ 3.2, Designer, Info View, FICO, COPA, MM, SQL Server 2008 and Windows 2008 Server

Responsibilities:

• Responsible for gathering requirements from Super Users and Functional & ABAP team and provided teh design options for generating custom extractors and various report design options to meet teh requirements.
• Loaded teh data from ECC to BI and used initialization wif delta update and full update methods.
• Completely designed and implemented teh financial reporting requirements for teh user.
• Provided complete solutions in BI in teh following metrics analytics Finance, Account Receivable, Account Payable, and Profit Center Accounting.
• Implemented CO-PA, FI Modules and extensively involved in extracting and defining Hierarchies for Account Groups, Profit Center Groups etc.
• Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C02, and DSO such as 0FIAR O03, and 0FIAP O03 wif proper transformations.
• Developed basic cubes for financial and controlling areas like cost center cube, order status cube.
• Developed transformations wif start routine, update routine and end routine and involved in teh creation and maintenance of DTP and InfoPackages for loading data in to data targets.
• Activated Sales, Profit Center Accounting, Accounts Payable, Accounts Receivable cubes as a part of cross-functional requirement.
• Created custom Multi Provider to support FIAR users, which is a two-cube structure joining one custom FI (company info) cube wif one business content AR cube, and allowing users to drill down teh customer details and ledger accounts.
• Scheduled jobs using Process Chains for Data Load, Compression, Aggregates and Information Broadcasting.
• Coordinated wif teh Payroll manager on customizing queries on posting documents, auditing information and Payroll data and developed reports in AR, AP and PCA functional areas.
• Extensively used BEx analyzer, created queries wif variables, filters and performed detailed reporting, published several web reports and worked on InfoSet queries using BEx analyzer.
• Created reports Workbook, and Queries for teh required sales order queries wif exceptions, conditional formatting, restricted key figures and calculated key figures.
• Used BI Broadcasting services for teh distribution (Print & E mail) of exception reports to key business users.
• Provided production support and administration of BI back-end operations to ensure data is successfully extracted from source systems.
• Responsible for developing Analytical Reports wif multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using teh Business Objects Enterprise XI.
• Integrated and extracted data into BO Crystal Reports to generate reports from SAP BI system. Developed Business Objects Universes wif classes, objects and condition objects.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, Functions and more.
• Created reports, cross-tab reports using WebI rich client by utilizing prompts, alerter etc and provided Executive Summary report of Managers and representative performances to Directors as dash boards in Xcelsius bound to Live Office using prompts.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Created financial reports, charts using Universes as teh main data provider and reports such as Quarterly variance, Regional, Actual vs. Forecast, Balance sheets etc were developed.

Confidential, Kalamazoo, MI

Sr. SAP BW/BI/BOBJ Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, MM, SD, FI, SAP-APO, Business Objects 3.1, BEx Analyzer, Net weaver 2004s, Oracle, WAD.

Responsibilities:

• Involved in complete lifecycle implementation of teh project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing to go live and production support.
• Developed BI solutions such as data models, information objects and info cubes for projects to fulfill business needs and requirements.
• Involved in complete life cycle implementation of SAP BI in SD, MM and FI modules.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Worked extensively wif LO Cockpit structures such as 2LIS 13 VDHDR, 2LIS 03 BX and 2LIS 03 BF.
• Extracted data from teh finance modules like AR, AP and GL and enhanced teh standard data sources 0FI AP 04, 0FI AR 04 to meet teh client requirement.
• Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes; coding in start routines and end routines.
• Used ABAP code to write start routines, update routines, end routines in transformations to facilitate reports for Purchase Price Variance, Inventory Accuracy.
• Created process-chains to automate teh Data Loads, Rollups into Aggregates, Creating and Deleting indexes to improve Load performance.
• Established standards, reusable data models and best practices for designing information cubes and objects for BI/BW landscapes.
• Worked on SCM APO integration wif BI, demand planning (DP) and designed remote cubes for APO Forecast analysis, and Multi cubes to facilitate reporting combining history and forecast.
• Designed teh Data flow for extracting Sales and Shipment Data from ECC to APO/BI and extracted data from teh Planning Area.
• Generated reports on Multi cubes to compare teh plan/Actual production quantity.
• Designed BI queries on Demand plan data to check for availability of products, TLB and managing of stock in warehouses.
• Used teh APD to perform several look ups to tie teh transaction data to specific master data attributes.
• Developed flexible queries using filters and navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized fashion and also created Calculated and Restricted Key Figures, Structures, Conditions and Cell Definitions wifin queries, maintained Query settings and tuning wherever necessary.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, Functions and more.
• Created reports, cross-tab reports using WebI rich client by utilizing prompts, alerter etc and provided Executive Summary report of Managers and representative performances to Directors as dash boards in Xcelsius bound to Live Office using prompts.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Responsible for developing Analytical Reports wif multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using teh Business Objects Enterprise XI.
• Integrated and extracted data into BO Crystal Reports to generate reports from SAP BI system. Developed Business Objects Universes wif classes, objects and condition objects.
• Created financial reports, charts using Universes as teh main data provider and reports such as Quarterly variance, Regional, Actual vs. Forecast, Balance sheets etc were developed.
• Resolved performance issues by writing stored procedures and command objects in Crystal reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.
• Provided Process documentation, which includes data flow and how to guides to end users for post production support.
• Coordinated teh technical activities of building BI solutions, and coordinating wif contractors and consultants, both onshore and offshore.

Confidential, Dallas, TX

SAP BI/BW Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, FI-CO, PCA, DB2, and BEx Analyzer.

Responsibilities:

• Responsible for gathering requirements from Super Users and Functional & ABAP team and provided teh design options for generating custom extractors and various report design options to meet teh requirements.
• Loaded teh data from ECC to BI and used initialization wif delta update and full update methods.
• Completely designed and implemented teh financial reporting requirements for teh user.
• Provided complete solutions in BI in teh following metrics analytics Finance, Account Receivable, Account Payable, and Profit Center Accounting.
• Implemented CO-PA, FI Modules and extensively involved in extracting and defining Hierarchies for Account Groups, Profit Center Groups etc.
• Implemented FI cubes such as 0FIAR C02, 0FIAR C03, 0FIAP C03, and DSO such as 0FIAR O03, and 0FIAP O03 wif proper transformations.
• Developed basic cubes for financial and controlling areas like cost center cube, order status cube.
• Developed transformations wif start routine, update routine and end routine and involved in teh creation and maintenance of DTP and Info packages for loading data in to data targets.
• Activated Sales, Profit Center Accounting, Accounts Payable, Accounts Receivable cubes as a part of cross-functional requirement.
• Created custom Multi Provider to support FIAR users, which is a two-cube structure joining one custom FI (company info) cube wif one business content AR cube, and allowing users to drill down teh customer details and ledger accounts.
• Scheduled jobs using Process Chains for Data Load, Compression, Aggregates and Information Broadcasting.
• Coordinated wif teh Payroll manager on customizing queries on posting documents, auditing information and Payroll data and developed reports in AR, AP and PCA functional areas.
• Extensively used BEx analyzer, created queries wif variables, filters and performed detailed reporting, published several web reports and worked on InfoSet queries using BEx analyzer.
• Created reports using BEx Reports, Workbook, and Queries for teh required sales order queries wif exceptions, conditional formatting, restricted key figures and calculated key figures.
• Used BI Broadcasting services for teh distribution (Print & E mail) of exception reports to key business users.
• Provided production support and administration of BI back-end operations to ensure data is successfully extracted from source systems.