Summary

• 7+ years of IT industry experience including experience spanning across SAP [ERP] and Business Intelligence [BW/BI] solutions delivery, Data warehousing using Businesses Intelligence tools integration with Business Objects.
• Expertise on Business Objects XI R2, 6.x, and 5.x Suite (Desktop and Enterprise Server products suite), Web Intelligence, Performance Management and Dashboard Manager. Crystal Reports XI, Xcelsius, Web logic. Experience using Dimensional Data Modeling and Relational Data Modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling and designed Data models using Erwin.

• Involved in multiple life cycle implementations of BI/Portal projects from blue print, gap analysis, system landscape, data modeling, design and development, ETL, validation, reporting and Security, till Go-Live and involved in production support.
• Performance technical training background in ABAP, Business Intelligence Bex reporting, Portal Integration with BI, Performance Tuning, Security, Profile Generator, Transport Management, BW Related Basis.

• Training on broad SAP skills set but specialize in the area of BI solutions and EP and ERP Security with Specialization in BI Security and Portal Security and BI Reporting across multiple cross functional Areas like HR-BI, PP/PI-BI, FI-BI, SCM, CRM.
• Involved in development of FRICE [Forms, Reports, Interfaces, Conversions, and Enhancements]. And Creating Naming Standards, Reporting Test scripts and offshore coordination of development work and production Support.

• I bring over six years of business and systems development experience across multiple industries, Aerospace, Electronics, Pharmaceutical, Gas, logistics and more.

SAP BW Expertise

Technical experience Overview:

Data Modeling Extensive involvement in gap analysis. Design and maintenance of InfoCubes, MulitProviders, Remote Cubes and ODS Objects in consistent with Extended Star schema and efficient Multi-dimensional data modeling techniques.

Data Extraction Create and customized InfoSources/Datasources, Transfer Structures, Extract Structures, Update Rules, Transformations, DTP and Start Routines. Schedule and monitor data uploads into InfoProviders such as InfoObjects, ODS, InfoCubes as well as PSA. Automate data extraction process using Process Chains utility.

Reporting Building custom queries using Restricted and Calculated KeyFigures, Variables, Structures and Exceptions. Extensive experience with Query Builder, BEx Analyzer, RRI - Jump queries, InfoSets and InfoSet Query

BI Security Worked with SAP BI security to implement both role based and data level security using Role maintenance, RSECADMIN (BI7.0) and RSSM (BW 3.X) and enabled object level security both at key figure and Hierarchy level.

Performance Tuning Analyze OLAP and Warehouse Management (WHM) performance using BW Statistics. Improve query and load performance using Aggregates, Partitions, Indices, Packet Size, Data Selection and Data Compression.

Portal Integration Well versed with the integration of BW/BI Web reports (Web Templates) and assigning to the portal roles and worked with installing relevant roles for integrating visual composer to the EP 7.0 and connecting the BI system to the Federated Portal (EP).

Skills

Languages / Development Software’s / RDBMS:

SAP BI 7.0, BW 3.5 (BW-BPS)/3.1C/3.0B/2.1C,
SAP R/3 5.0/4.6C/4.5B, Workplace 2.0, Enterprise Portals 6.0, ABAP/4, C, SQL, HTML, XML, MS FrontPage, MS SQL Server 2000/7.0, Informix, Access, Oracle 10g/9i/8i/8.0.

Operating Systems:

MS-Windows XP Pro/NT/98/95, 2000 Server, Unix, Solaris

Reporting / Designing Tools / Data modeling tools:

Business Explorer, Web Application Designer, Microsoft Visio, Cognos, Business Objects, Crystal reports ETL tools such as Data Junction and Informatica Power Center 7.x. knowledge of data modeling tools include ER/Studio, ERwin, ARIS, Avolution, Aqua Data Studio, dbForge Studio for MySQL, DeZign for Databases, Devgems Data Modeler, MEGA International, OmniGraffle, Oracle Designer, PowerDesigner, Rational Rose, Sparx Enterprise Architect, SQLyog, System Architect, Toad Data Modeler, SQL Maestro, Visible Analyst, and Visual Paradigm.

Additional Skills:

MS-Office Suite (Word, Excel), MS Visual Interdev v6, MS Visual SourceSafe, LAN, WAN, TCP/IP, FTP, ACT2000/6.0, TOAD, IIS 5.0, Rational Clear Case/Quest, Test Director 8.0. System Architect, Hardware and Software troubleshooting.

Having Working knowledge on:

• Developing charts and grouped conditionally formatted charts and mailing label reports etc.
• Good Knowledge and understanding of XML
• Business Objects XI V3 Developer
• Design summary and aggregation processes for data reporting
• Coordinate data warehouse architecture with BI and ETL leads
• Ability to take technical specifications from the User.
• Knowledge on File transfer Protocol(FTP)
• How to work closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain Business Objects, Web Intelligence, OLAP Intelligence and Crystal reports.
• Developing, designing and maintaining new and existing Universes with Classes and Objects using different database.
• Worked on various development platforms like Windows NT 4.0/2000/2003 Server/ XP/98/95, UNIX and RDBMS like Oracle, SQL Server, MS Access, Teradata, DB2 UDB and Sybase.
• Good knowledge in SQL and coding PL/SQL Packages, Stored Procedures, Views, indexes, Function and database Triggers. Experience in using SQL*Plus, Toad 7.6.
• Knowledge in analyzing system needs, discuss desired function with upper management business users, and successfully interchanged programs to meet the needs of the organization.
• Managed and delivered large and complex assignments within time/cost and service level parameters effectively.
• Excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hardworking and high level of motivation

Experience: (Exclusive as a SAP Business Consultant with Confidential.)
(ALL PROJECT REFERENCE WILL REFLECT FROM Confidential
)

Project Consultant with Confidential,
Confidential,Tallahassee, FL 32310 Feb 10– Aug 10
SAP BW/BI Consultant (FI implementation).

Global Engineering is a Multi-disciplinary consulting Engineering Firm that is a Leader in the fields of Forensic Engineering and Forensic Economics. Engineering Specialties include Accident reconstruction, Failure Analysis, Product Design issues, Safety and Standards, biomedical and biomechanics, kinematics.

Project description:
The scope of the project was to implement FI-GL, FI-AP Module and to provide production support in BI 7.0. Responsible for the Data flow Design from R/3 to BI and Data Modeling Using ERWIN.

Responsibilities:

• Participated in the user meetings to gather Business requirements. Analyzed the requirements; modeled the Info cubes & ODS objects; created the Dataflow diagrams and Star Schema Diagrams.
• Design and develop multi dimensional data models for Master Data Ware Housing.
• Based on the GAP analysis, Installed Business content Info objects 0vendor, 0ven_compc to load data from data sources 0VENDOR_ATTR, 0VENDOR_TEXT, 0VENDOR_LKLS_HIER and 0VEN_COMPC_ATTR to generate Vendor Master Reports using Infosets.
• Installed BI Content Info providers – DSO’s like 0FIGL_O02,0FIGL_O06, 0FIAP_O03, 0FIAP_O06 and Info cubes like 0FIGL_C01,0FIGL_CO2,0FIAP_C02,0FIAP_C03 respectively to load data from the data source 0FI_GL_4, 0FI_GL_6 and 0FI_AP_4, 0FI_GL_6.
• Added Custom characteristics, Key figures and made corresponding changes to transformations for BI content Info objects and InfoCubes to accommodate the custom Infoobjects.
• Created Generic Data Source FIAP_T_Checkregister using PAYR table under Accounts Payable to load Payment details.
• Created Generic Data Source to load data from BNKA table.
• Created & maintained Transformation while maintaining Start and End routines, to transform incoming data into suitable format for reporting.
• Created MultiProvider (FI_M01) to generate Vendor Invoice report.
• Created Infosets to generate Vendor master data report.
• Designed and scheduled Process chains for automating the Delta Loads, Aggregate Rollups and Change Runs, Created Hierarchies to display the data in hierarchical form in the reports.
• Monitored BW data loads for Daily/Weekly/Monthly and resolution for the load failures, performances tuning of data load for critical BW applications.
• Collected the Transport Requests using Transport Connection and worked with the Basis team to transport the collected requests into QAS and then into Production.
• Involved in testing business process using Extended Computer Aided Test Tool (eCATT) across system boundaries and also checked authorizations (user profiles).
• Involved in End User Training, Coordinated the migration strategy to move the developed objects across the landscape.
• Created relevant settings to improve performance of the queries by using Number Range Buffering, OLAP cache and setting the read modes of the queries.
• Install and configure SAP Integration Kit in a BOE XI R3.1 SP2 environment. Hence, enabling the SAP users to access Business Objects universes as well as SAP BW universes.
• Involved in creation of BOXI R3.1 Desktop Intelligence and Web Intelligence Reports with different functionalities like drill down, linking reports, charts and graphs, ranking and alerts.

Environment: Business Objects Enterprise XI Release 3.1 (Designer, Desktop intelligence, Web Intelligence, Import wizard, Publishing Wizard, Report Conversion Tool, Web Intelligent Rich Client), Business Objects Integration for SAP Solutions XI Release 3.1, Business Explorer (Query Designer), SDK, Crystal Reports 2008, Crystal Xcelsius, SAP BW,SAP BI 7.0, SAP R/3 ECC 6.0, SAP BI 7.0 BW release 3.5, Sun Solaris, BEx Analyzer, ABAP/4, SAP Web Application Server 6.20.
.

Project Consultant with Confidential,
Confidential,Angleton, Texas 77516 May 08- Jan 10

SAP BW/BI Consultant (SRM implementation , Production support).

Confidential,is a privately owned company formed in 1975 to offer unique process technologies to the oil and gas producing industry. Modular plants are designed and manufactured able to be installed quickly for the recovery of propane and heavier hydrocarbon vapors from natural gas.

Project description:
The intend of the project is to support the implementation their Supplier Relation Management System to SAP SRM and also implement BI as their SRM reporting solution.

Responsibilities:

• Involved in the Production support of their existing SAP SRM system, where I was required to enhance the existing End routine as per the requirements of the user.
• Data modeling using BW extended star schema concepts.
• Design and develop multi dimensional data models for Master Data Ware Housing.
• Created and defined Business Objects Date Structures using Designer to define and access fields from tables in universes
• Involved in creating Full client (Deski) and Web intelligence reports (Webi) using Business Objects enterprise XIr2
• Involved in creation of reports with different functionalities like Dynamic cascading prompts, drill down, linking reports, charts and graphs, ranking and alerts.
• Developed Reports with parameters based on data using Crystal Reports 9, Crystal Reports XI2.
• Developed reports like blank report, cross tab reports, sub reports in Crystal XI2
• Interacted with end users to gather Requirements. Created technical, user documentation.
• Installed custom objects to support the reports, and also developed the routines that would use the newly installed object.
• Actively involved in the resolving the production issues and also developed new reports for Shopping cart according to the user requirements.
• Generated Cycle Time reports for the using the data sources 0BBP_TD_SC_1, 0BBP_TD_PO_1, 0BBP_TD_CONTR_2, and 0BBP_TD_APPR_1.
• Customized the Standard SRM e-Procurement Reports to suit the business requirements gathered from a series of meetings conducted.
• Created Transformation and DTPs for all the data models in BI 7.0
• Involved in the Reloads for the test system, where I was required to Test the enhanced routines, for consistencies.
• Resolved existing production issues, for the cycle time and shopping cart.
• Enhanced the existing DSO (RSO_O07) that would support the Enhanced routines and transported using Transport Connection to the test and production system.
• Created Jump-to reports for cycle time to shopping cart.
• Created a SRM custom report to monitor the variance between Purchase Order value and Shopping Cart and Changes to PO values
• Improved Performance Tuning standards and benchmarks to improve overall performance of extraction, performance-tuning techniques for Process Chains and increase parallel processing.
• Monitored BW data loads for Daily/Weekly/Monthly and resolution for the load failures, performances tuning of data load for critical BW applications.
• Used Extended Computer Aided Test Tool, to remotely test BW/BI and other functional entities.
• Coordinated the Migration strategy to move the developed objects across the landscape.
• Developed on creating BEx Web Application Designer to create custom reports for the Suppliers that assist them with Purchase Order Service Level, Purchasing Groups, and Supplier – Invoice Payment Terms & Payment Date

Environment: SAP R/3 ECC 6.0, SAP BI 7.0 BW release, BEx Analyzer, ABAP/4, SAP Web Application Server 6.20. Crystal Reports 8.5&XI2, Business objects XI2, Remedy, Oracle 9i,10g ,SQL Server 2008, SSRS,TOAD, SQL, PL/SQL, UNIX, Windows 2003 Server

Project Consultant with Confidential,
Confidential,Melbourne, FL Dec06–April 08

Sr. SAP BW/BI Consultant (HR, BI security, Portal)
The Company develops technologies, Graphics products and services that make mobile experiences possible. The Company’s portfolio includes graphics communications infrastructure, enterprise mobility solutions, digital set-tops, cable modems, mobile devices and Bluetooth accessories.

Project Description:
This project is to replace their existing Hyperion Human resource tool for reporting and analytical purpose. This implementation started with upgrade of SAP 4.5 to SAP ECC 6.0 and replaces their existing reporting tool with BI 7.0 and integrates it with the federated portal, which has both ECC and BI reporting. Perform all Data Modeling Using Physical Data Modeling Tools.

Responsibilities:

• I was involved for the initial phase of Requirement gathering to replace their existing GDW (Global Data Warehouse). The requirements include replacing the reporting for Payroll, Performance Management, Organizational Management, Personal Administration and ECM (Enterprise Compensation Management).
• Identified the enhancements for 0EMPLOYEE master data to include custom reporting filters like Pay region, work Region, US salary etc.
• Design and develop multi-dimensional data models for Master Data Ware Housing.
• Developed Reports with parameters based on data using Crystal Reports 9, Crystal Reports XI2, for example like blank report, cross tab reports, sub reports in Crystal XI2, interacted with end users to gather Requirements. Created technical, user documentation.
• Converted reports from Crystal Reports 8.5 to XI2 developed various charts and graphs using Crystal Reports XI2.
• Created Custom Functions in Crystal Reports XI2 to impose Several Joins, Filters to restrict the unwanted data and highlight the required data. Testing the existing reports and modifying according to the requirement.
• Modeling of the data Created for Views, Queries, and Templates to produce the reports. Created Stored Procedures in reports and parameters for filtering data. Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Used generalized formulas using both Crystal and Basic Syntax.
• Worked with different types of variables (Local, Global, and Shared) in writing formulas.
• Scheduling the reports depending on the users request to receive in different formats in Business objects Enterprise using Crystal reports Scheduler and created Data Warehouse development and used ER Studio as a physical data modeling tool.
• Scheduling the reports depending on the users request to different destinations like FTP ,Email
• Work with User to get Technical Specifications.
• Activated the standard business content for Staffing (0PAOS_C01), headcount (0PAPA_C02) cubes to report on Headcount reporting.
• Converted all the Transactional Datasources and Master Datasources using the new BI versions to use the transformations and DTP’s for loading data.
• Installed and enhanced 0HR_PA_0,0HR_PA_PA_1,0HR_PA_1,0PERSON, 0ORGUNIT (HIERARCHY).
• Enabled 0ORGUNIT hierarchy to display and filter HR related reports using Org structure.
• Created custom DSO’s to extract client reporting specific info types (Info type for Basic pay, Schedule, Communication etc) to a first level DSO’s for granular reporting.
• Designed and configured security on Personal Sub Area (ZPSA_SAREA), Country (ZCOUNTRY_ID) level security for data level restrictions on the reports using RSECADMIN.
• Created three level securities on 0employee (Sensitive Users, protected Users, General users) to restrict employee attributes visibility.
• Migrated the web templates for all the reports to Enterprise Portal and assigned them to respective Work areas in the portal.
• Enhanced the standard 0analysis_pattern to client custom look and feel along with relevant functionality.
• Created InfoSets with temporal joins to enable integrated corporate reports like Employee master Report, Employee Separation and Turnover reports, MIP Eligibility report, Req with tree report, Bravo Reporting etc.
• Created ESS and MSS reports and configures to show only data relevant to the employee login id to PERNR.
• Loaded historical info type reports to the level one DSO’s and developed transformation to integrate with the existing time dependent data of the current SAP info type data.
• Coordinated the migration strategy to move the developed objects across the landscape.
• Created relevant settings to improve performance of the queries using Precal Server, OLAP cache and setting the read modes of the queries.

Environment: SAP R/3 ECC 6.0, SAP BI 7.0 BW release 3.5, Sun Solaris, BEx Analyzer, ABAP/4. Crystal Reports 9/10.0/XI, Crystal Xcelsius, Business Objects XI,BO Live Office, Data Integrator, Informatica Power Center Designer 6.2, Oracle 10g/9i, MS Access, SQL Server 2005, Teradata, SDK,SQL, PL/SQL, SSIS,MS Excel, Toad, Windows XP, UNIX

Project Consultant with Confidential,
Confidential,COCOA, FL Apr 06–Nov 06

Sr. SAP BI Consultant (SRM, Performance Tuning, Security)
Confidential,pharmaceutical company more than 570 products to consumers in more than 90 countries across the globe. Their products cover a vast array of therapeutic categories, and offer an extensive range of dosage forms and delivery systems. They provide education and training for the students and other active professionals.

Project Description:
The aim of this project is to implement both their Supplier Relation Management System to SAP SRM and also implement BI as their SRM reporting solution. The BI reporting implementation started with in parallel to the SAP SRM implementation with Bex Reporting and Enterprise Portal as the 2 reporting front-end for all types of users. Project involved in creating universe and reports and to keep track of past and present ongoing case records. Created complex reports to meet the requirement of users using Business objects. This project involved studying the existing BO Environment, Installation of BO XIR2, identifying and resolving the migration issues; build new Universes and reports and also tuning the Existing Reports and implementing best practices.

Responsibilities:

• The scope of the project includes the report consolidation for SAP SRM & R/3 MM using both transactional and master data.
• Successfully completed the Requirement Gathering (Business Blueprint Phase) and the Gap Analysis between SAP BI Content and the existing legacy (As-Is) reporting
• Data modeling using BW extended star schema concepts.
• Customized the Standard SRM e-Procurement and Spent Analysis Reports to suit the business requirements gathered from a series of meetings conducted with Cost Center Owners, Category Managers, Financial Analysts, Suppliers and Buyers.
• Design and develop multi-dimensional data models for Master Data Ware Housing.
• Customized SAP R/3 MM Datasources 2LIS_O2_ITM, 2LIS_02_ACC, 2LIS_06_INV and SRM Datasources to extract Invoice Payment data, Payment Terms, Shopping Cart information for a Purchase Order and vice versa to assist with SUS (Supplier Self Service) configuration.
• Developing Logical Data Modeling and Involved in designing and developing new reports using Business Objects and Crystal Reports XI
• Used Business Objects Universes to develop Reports, Extensively involved in creating Report Formulas, Views for the reports, and Parameters Creation. Created database Objects like Tables, Views, Synonyms and Indexes.
• Implemented web based Crystal Enterprise interfaces for corporate web sites.
• Used multiple sub reports, pass through parameters linking for generating complex reports for management
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Worked with Microsoft Reporting Services. Work with Business Users and team leads to develop system requirements, analyze data Element and continuous end-user support. Wrote SQL Statement, Database Stored Procedures and Views using Oracle
• Involved in Scheduling and publishing reports in Crystal Enterprise Environment
• Created SRM reports using BEx Query Designer to track the approval process of a Shopping cart that included the Bidder/Bid Score, Approvers information, duration of the approval process before it converts into a Purchase Order.
• Created custom report that allows Buyers or Purchasing Assistants to most effectively track the metrics or pull the information they require. Report - the total value of the PO came from (i.e. one shopping cart, multiple shopping carts, PO change shopping carts/purchase requisitions) to ensure total value of the PO was approved and processed the appropriate way.
• Developed on creating BEx Web Application Designer to create custom reports for the Suppliers that assist them with Purchase Order Service Level, Purchasing Groups, Service Master and Supplier – Invoice Payment Terms & Payment Date.
• Extensively worked with ABAP Customer Exits and Custom Enhancement Projects for the BI reports to create Data Level security in the BEx Reports. Created custom reports using SRM Confirmation Approval process data using custom Datasources on SRM Work flow task IDs. Created a SRM custom report to monitor the variance between Purchase Order value and Shopping Cart and Change PO values. Installed Performance Tuning standards and benchmarks to improve overall performance of extraction, which took 6 hours and brought it to 3 hours using extraction performance tuning techniques and Process Chains and increasing parallel processing. Worked with the basis team and BI Business users to identify the Security requirements and designed the security for 400 users across the landscape. Created Data level security on 0plant and Custom Vendor Hierarchy on Region. Extensively used PFCG for role creation and RSECADMIN for the new Authorization

Environment: SAP ECC 5.0, SAP BW Release 7.0, Unix AIX, BEx Analyzer, Web Reports, MM, SRM SD. Crystal Reports XI, Sql Server 2005, SDK, Windows 2000/NT, UNIX, SSRS, Oracle 9i and TOAD.

Project Consultant with Confidential,
Confidential,Melbourne Beach, FL Jan 06–Mar 06

SAP BW/BO Data Modeling Consultant

This Company have been committed to selling top-quality merchandise ranging from Apparel, Bed, Bath to storage and sporting goods, to name a few at tremendous value prices. The Company had grown to become country’s premier business-to-business merchandisers.

Project Description:
The scope of the project was to implement FI-GL, FI-SL Module and to provide production support for CO module in BI 7.0. Responsible for Design of the Data flow and Data Model from R/3 to BW. This project was also intended to bring up their reporting application using Business Objects. Data extraction is done from various data sources, compiled into one standard format in oracle EDW (Enterprise data Warehouse). Star Schema and Snowflake Reports are generated from this data source and the Using Psing data modeling the reports were distributed through the corporate Intranet.

Responsibilities:

• Design and develop multi-dimensional data models for Master Data Ware Housing.
• Involved in end-to-end implementation of FI/GL module reporting.
• Used Designer to create Dimensional, Detail and Measure objects. Development of Dashboards using Crystal Xcelsius 2008.
• Created Dashboard, Chat and Containers, Selectors using the Xcelsius components. Created Dashboards using Filters, List View, table, Line, Column and Pie charts. (Combination bar graphs, combination bar and line graphs, and line graphs will be used to display metrics.) Worked on Dashboard Design and Development, capable of analyzing requirements documentation
• Worked with dimensional modeling and ETL. Worked with performance and scalability issues in the data mart environment
• Automated Excel sheet data using VBA to reflect on power point slides as various data graphs. Used BO SDK to customize reports and in suppressing data though Macros. Administering, Monitoring and scheduling reports in XI environment.
• Participated in the user meetings to gather Business requirements. Analyzed the requirements; modeled the info cubes & ODS objects; created the Dataflow diagrams and Functional & Technical specifications.
• Based on the GAP analysis, activated available Business Content and created necessary custom Objects like InfoObjects, Info sources, ODS, Info cubes.
• Created custom Data source 3FI_SL_0F under Special Purpose Ledger Accounting to load the Plan Data.
• Added custom characteristics, key figures and corresponding changes to update rules for customized Info Cube
• Created & maintained Transfer rules, Update rules, Start routines, to transform incoming data into suitable format for reporting. Creating of Star Schema. Designed and scheduled Process chains for automating the Delta Loads, Aggregate Rollups and Change Runs Created Hierarchies to display the data in hierarchical form in the reports.
• Installed Data sources 0FIGL_7, 0FIGL_4 under Finance (General Ledger Accounting) Module.
• Created Multiprovider on 0FIGL_C02 (Cost of Sales Ledger: Transaction Figures) and 0CCA_O09 (Actual - Line Items) to meet the reporting requirements. Developed BEx Reports like Balance sheet report, Profit and Loss report in financial applications using BEx Analyzer. Modified the existing Cost center Reports like Costs and Allocations Comparison Report, Costs and Allocations Trend Report etc. as per the users requirement.
• Created necessary custom variables and Maintained Jump targets to Drilldown from summary level to line item level.
• Designed Web templates using Web Application Designer. Customized web templates with simple HTML and published the iviews in the portal. Monitored BW data loads for Daily/Weekly/Monthly and resolution for the load failures, performances tuning of data load for critical BW applications.
• Collected the Transport Requests using Transport Connection and worked with the Basis team to transport the collected requests into QAS and then into Production.

Environment: SAP R/3 4.6C, SAP BW Release 3.1 BI Content 3.2, Windows NT, BEx Analyzer, CO-PA,CO,PCA, DB-Connect. Business Objects XiR2, Designer, Crystal Reports, Voyager, VBA, Xcelsius, Live Office, Web Intelligence, Info view, BO SDK, VB Scripting,, Toad, Windows XP, WINS, SQL, Oracle, Unix.

Independent Project Consultant
Confidential,Orlando, FL Feb 02– Dec 05

SAP BW/PP Consultant and Data Warehousing Architect

Confidential, is the world\'s largest full-service restaurant company with annual sales of more than $7 billion. Through subsidiaries, Darden owns and operates 1,800 Red Lobster, Olive Garden, LongHorn Steakhouse, The Capital Grille, Bahama Breeze and Seasons 52 restaurants in North America, employs approximately 180,000 people and serves 400 million meals annually. This is a centralized Data Warehouse where all the different site systems feed data through flat files on daily, weekly basis. SQL*Loader scripts and PL/SQL Procedures have been used to load and validate the data and Cron tab has been used to schedule the shell scripts. Universe, which was built for Business Objects as a reporting tool contains complex, joins, filters and contextsenabling the users to make any kind of report without much effort.

Project description:
The Project requires implementing Production planning processes where Reporting Scope includes using BW as the central data warehouse for analytical reporting and historical data reporting using Bex and web reporting tools.

Responsibilities:

• Involved in developing Test plans under various business scenarios and performing development/SIT testing as per the plans.
• Involved in feature enhancements and bug fixes as per the SLA requirements.
• Developed the Shell Scripts and Cron Tabs for the scheduling the batch processing.
• Participated in the Architecture design for the Global Souring Data warehouse.
• Involved in Star Schema design for the Global Sourcing Data warehouses.
• Involved in design and development of the ETL strategy to populate the Data Warehouse from the various source system feeds.
• Created the sizing estimation for the Global Source Data warehouse.
• Developed the Business Objects Universe for the Global Sourcing Data warehouse.
• Developed the security strategy for the Global Sourcing Data warehouse.
• Generated the dashboard reports and also the Inflation and Deflation Reports in the web and has been scheduled to refresh automatically in the Doc Agent Server.

• Involved in complete Lifecycle of Product Costing
• Created Technical Specification for all the Product Costing Data Models
• Identified number of Info Cubes, Data Store Objects, Data Sources and Master Data based on Functional Specifications
• Designed a complete Data Model for Product Costing
• Installed all the Product Costing related (0CO_PC_01, 0CO_PC_PCP_02, 0CO_PC_ACT_10 and more) Data Source including Master Data in R/3
• Worked with FI/GL, PP-PI and P2P team as Product Costing Data Model design was cross functional and was using data from different models. Identified issues and dependencies on other Data Models (non Product Costing)
• Created Functional Specification for Custom Data Source
• Design and created custom views for MBEW, MBEWH tables in R/3 for Product Costing requirements
• Design and created custom data source by joining MKAL, MAST, STAS, STKO and STPO tables to get BOM related information, Component Quantity and more
• Worked on PP-PI Data Sources (2LIS_04_P_ARBPL, 2LIS_04_P_MATNR, 2LIS_04_P_COMP, 2LIS_04_WCCP)
• Created custom Info Objects based on custom data sources
• Design and created custom Info Cubes (ZCO_C02 – Cost Component Split, ZCO_C04 – Actual Cost, ZCO_C03 – Cost Center Plan Cost and more)
• Design and created DSOs (EDW Layer) as per requirements
• Created Transformation and DTPs for all the data models in BI 7.0
• Created Multiproviders to design queries on it
• Created 15 (Cost Center Variance, Cost Component Split, Yield Report, Production Variance Report, Volume Mix, Government Tomato Paste Report and more) Product Costing Reports using BI 7.0 Query Designer
• Created Workbooks based on business requirements. Designed Report Conversion Tool Folder under Public Folder migrating to R2. Worked under the BO XI Crystal reports (OCLO)
• Worked with the Publishing wizard and changed the scheduling option, moved the objects between the folders, also finalized the objects to be added publishing with CMC. Involved in designing Crystal Reports, Business Views, Dynamic prompts, Formatting reports and creating Corporate Dashboards. Responsible for designing/deploying BoXiR2, Tomcat, Performance Management Framework. Installed and configured Business Objects XIR2 Suite
• Created, modified/maintained Universe. Created and maintained Business Objects & web Intelligence reports
• Added/created complex objects to the universe to enhance the report functionality. Created report templates to maintain same standards across all the reports.
• Also worked on QM(PLM) Info cubes and Multiproviders to create custom reports (Notifications, Inspection Information, Inspection Results) based on business requirements
• Worked with ETL team to identify dependencies of objects and data loads (Full and Delta Loads)
• Created Process Chains for all the model
• Worked with users to identify issues with report and resolved.
• Based on Company policy and requirement, incorporated security on info objects to assign report access to different roles and payment program for customers and vendors.

Environment: SAP R/3 4.7, BW 3.5, SD, FI/CO, MM, HR. Business Objects XiR2, Designer, Crystal Reports, Voyager, VBA, Xcelsius, Live Office, Web Intelligence, Info view, BO SDK, VB Scripting, Toad, Windows XP, WINS, SQL, Oracle, Unix.

Independent Project Consultant
Confidential,Melbourne, FL Jan 01– Nov 01

BW SCM consultant

This is a multinational company, manufacturing products ranging from Aerospace and Aeronautics, Agriculture, Automotive, Pharmaceutical and many more.

Project Description:
The main aim of the project is to implement SAP MM along with other modules and integrate them, and implement change requests and develop new functionalities and incidents as required and the enhance the existing data sources to meet the client requirements. The project is a custom package for facilitate managers to monitor the sales trends, Goal management, manage field force under them in their territory and facilities like hospitals, institutions, clinics, retail pharmacies. Managers can generate reports for their products sales trends, shares by hospitals, institutions.

Responsibilities:

• Data modeling using BW extended star schema concepts.
• Design and develop multi dimensional data models for Master Data Ware Housing.
• Performed detailed analysis in order to identify the suitable business content.
• Worked on BI ETL Extraction, Transformation for data load from R/3 source systems to BI systems.
• Used the data sources 2LIS_03_BF for good movement and made the necessary enhancements.
• Implemented data extraction and data staging using LO cockpit and enhanced the structure using user exists to support the business needs. Used 2LIS_03_BX and 2LIS_03_UM for stock initialization and revaluation respectively.
• Used 0Process keys as a part of data modeling. Installed Process Chains to automate the data load and data target administration. Extensively used Bex analyzer, created queries with variables, filters and used jump queries, Restricted key figures, Calculated key figures , Conditions, Variables, Structures and Exceptions
• Used Web Application Designer, Web Analyzer and customized Standard Web Templates.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Developed Hierarchies to support drill down reports.
• Applied security features of Business Objects like report level & object level security in the universe so as to make the sensitive data secure. Developed Stored Procedures Using Oracle PL/SQL programming to improve the performance of the Reports using complex queries. Created the complex and adhoc reports on the web by using Web intelligence.
• Extensively work on Broadcast Agent for scheduling and distributing the documents. Used the Auditor to trace out the user activities. Used BO SDK in fetching the data using macros. Involved in supporting end users in resolving issues related to BO. Worked on the data provider that forms the basis of the ad-hoc analysis
• Worked in Memory Tuning By sizing our database buffers (shared pool, buffer cache, log buffer, etc) by looking at our wait events, buffer hit ratios, system swapping and paging, etc also pin large objects into memory to prevent frequent reloads.
• Using Oracle tools/ utilities ADDM (Automated Database Diagnostics Monitor) in Oracle 10g to assist with performance monitoring and tuning
• Created Database objects through development, testing and production environments.
• Wrote in-house data entry applications in Visual Basic and Oracle.
• Provided Support and Maintenance to business clients
• Installed programs Restricting user actions.
• Provided assistance to Full time computer operators with tape backups and problem resolution.
• Participated in system construction, analysis, testing and implementation.
• Modified and upgraded database systems to suit company requirements.
• Responsible for the testing and debugging of programs.

Environment: SAP R/3 4.7, BW 3.5, SD, MM, HR. Business Objects XIR2/6.1.2/6.5 (Supervisor, Designer, Broadcast Agent, Web Intelligence, ZABO, Weblogic. Info view, Auditor), BO SDK, VB Scripting, ORACLE, MS Excel, Erwin, SQL, PL/SQL and Windows NT

Education:

Actively pursuing online Post undergraduate and Master’s in Continuing education
Other continuing education includes, SAP Technical Training in Business Intelligence, Business Objects and Basic training in ABAB Programming.
Pursued Bachelor’s Degree
Associates in General Education in Chemical and Biochemical Technology.
Associates in General Computer Science WITH SOFTWARE AND DATABASE APPLICATION.