SUMMARY

• 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.
• Extensive experience in multiple Production support projects for SAPBW/BI/BODS/HANA and involved in couple of migration/technical upgrade projects - SAP BW 3.X to BI 7.0; SAP BI 7.0 to 7.31/7.4/7.5;
• 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.
• Experience in creating Business Requirement Document (BRD) and document Business Process.
• Working experience on Agile, Waterfall, Object Oriented Analysis and Software Development Life Cycle (SDLC) processes.
• Experience in Requirement gathering through participating in workshops, and JAD sessions wif clients, developers, and QA Analysts, and referring to existing system documentation and procedures.
• Well-versed in documenting Business Plan, Requirement documents, Functional Specification documents, and Standard Operating procedures.
• 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.
• Involved in BI 7.4 and 7.5 Composite Providers, Transient Provider, Analytical Index,
• Transformations, Data Transfer Process, Data Store Object, Web Application Design, Process Chains, Open Hub Destination, Start Routine, End routine, Field routine, Pseudo delta, BI Content, Visual Composer, Integrated Planning, 7X Bex reporting.
• 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 noledge 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 dat support both manual and automatic data entry and changes to data.
• Expert in analysis and development of ETL data flow design using Business Objects Data Integrator XI 3.x(SAP BODI)
• Experience in SAP Data Migration using Data Integrator as teh tool and Data Cleansing, Address cleansing using Data Quality as teh tool and Pro-Active Data Validation.
• 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.
• HANA modeling - Worked on HANA Studio - developed Analytical, Attribute & Calculation Views, Procedures, CE and SQL Scripting.
• Hands-on experience in HANA Data Provisioning techniques such as SLT, BODS and SDI, involved in table design, used SQL queries/Procedures.
• 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 dat 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 Xcelsius.
• 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.
• Data uploads from Margin Minder text files to BW System.
• 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.5, HANA,BCV, Business Objects Data Integrator XI 3.1

SAP Modules: SD, MM/WM, FI/CO, PP, PM, PPM, QM, HR, CRM4.0, SRM, 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, Margin Minder, 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,Visio

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

QA Testing / Modeling/ Defect Tracking Tools: Test Director, QTP, Quality Center, Quick Test, JIRA, JD Edwards

Requirement Management Tools: JIRA,TFS, Clarity, Siemens Teamcenter, RTC, ITIL Service Management

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/BI/ BOBJ/HANA Lead.

Environment: SAP Net Weaver 2004s BI 7.0, 7.3, ECC 6.0, Business Explorer, SD, FI-CO,ABAP, APO, CRM, HANA, Margin Minder, Business Objects 4.0. Tableau 9.2, 10.0.

Responsibilities:

• Responsible for gathering requirements from Super Users and Functional team and provided teh design options for generating custom extractors and various report design options to meet teh requirements.
• Provided complete solutions in BI in teh following metrics analytics Finance, Account Receivable, Account Payable, and Profit Center Accounting.
• Followed Agile Methodology for project Implementation.
• Primary support in resolving teh issues about Report Requirements for Report Customization team.
• Worked in creating Business Requirement Document (BRD) and document Business Process
• Involved in ABAP coding of transformations, extractors, program, function module and Customer exit.
• Effectively gathered systems requirement from client and taken signoff on approval of Systems requirement.
• Gathered user requirements for analysis and reporting, identified Gaps and created Technical Design documents.
• Worked on enhancing numerous extractors and its data flow for teh data to be extracted by External systems through open hubs.
• Worked extensively on Open hubs, APDs and processed teh data for external interfaces.
• Enhanced teh existing FI reports as per teh requests from business.
• Worked extensively on Finance and Controlling. Created BEx report for FI and CO Consolidation purposes.
• Created Reconciliation reports and Close and Consolidation report.
• Worked extensively on Performance tuning such as Redesign of process chains, collectingStatistics and created indexes.
• Extended Transaction data and Master data by appending new data elements using Enhancement component.
• Created Transformation Routines, Start Routines, end Routines as per teh requirement and forThe lookups from one DSO to other.
• Performed teh data flow from BW to APO and from APO to BW to get teh plan data.
• Involved in Manual Testing of teh application by developing Test Cases, Test Scripts usingQuality Center by reviewing teh business.
• Used agile data model and replicate into HANA Model /View where reported out of Tableau.
• Worked in Hybrid model in HANA and created - Analytical, Attributes and calculation for SAP and NonSAP data extracted through BODS into HANA staging tables.
• Created a dashboard in Tableau tools to generate expenses a detail of internal and external employees of travel expenses across oversees as well as project expenses.
• Used Margin Minder to create Quarterly sales where comparison of last year vs Current year of financial report to support Month end.
• Used Margin Minder for analyzing sales reports like Order to Cash (OTC), Weekly Deliveries, Sales Values, and Incoming Orders.
• Developed and modified various reports as per teh user requirements such as for Goods Receipts and Purchase Orders, Orders Due To Ship, Shipment Summary, Orders Shipped/Invoiced, Customer Sales Report by Sales Organization.

Confidential,Toledo, Columbus, OH

SAP BW/ BI/ BOBJ/HANA Lead Consultant

Environment: SAP Net Weaver 2004s BI 7.0, 7.3, ECC 6.0, Business Explorer, FI-AR, ABAP.BO 4.0

Responsibilities:

• Worked extensively on various Production support issues and administration of BI back-end operations by raising tickets to SAP OSS (Online support system) to teh ensure data is successfully extracted from source systems and reported correctly.
• Created process chains for periodic upload of master data and transactional data and monitored data loads wif delta update and full update mechanisms.
• Redesigned few process chains to improve performance.
• Provided support for data load, validation, performance monitoring and tuning.
• Provided production support for Process chains, loads from ECC to BI, reconciling issues between ECC and BI, and other issues wif teh loads.
• Created process-chains to automate teh Data Loads, Rollups into Aggregates, Creating and Deleting indexes to improve Load performance.
• System testing and UAT developed for teh business user and super users.
• Trained Super Users to develop ad-hoc queries in BI Query Designer. Teh training included creating queries from various sources such as Info Sets, Multi Cubes, creating and restricting CKF’s and RKF’s, use of aggregations and creating input parameters among other items.

Confidential, Brentwood, TN

SAP BW/ BI/ BOBJ Lead Consultant

Environment: SAP Net Weaver 2004s BI 7.0, 7.3, ECC 6.0, Business Explorer, SD, FI-AR, IS-Retail, Oil and Gas (Exchanges), Closing Cockpit, ABAP, Simplified Reporting, SAP Portals, Business Objects 4.0, Xcelsius, and Crystal Reports.

Responsibilities:

• Actively interacted and scheduled meetings wif teh business users to gather teh reporting requirements, performed gap analysis and developed design documents.
• Extracted Standard Data Sources 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL from teh Business Content using LO- Cockpit extraction methods for Transactional data and enhanced them to meet teh reporting requirements. Performed LO - Cockpit extraction for Sales Order, Sales Delivery, and Billings.
• Worked on analysis part to implement Simplified reporting.
• Worked on teh technical design of “Oil and Gas (Exchanges), Closing Cockpit” Standard BI content.
• Extensively created custom cubes and Data Store objects by enhancing teh business content also developed Write Optimized DSO’s for EDW layers and Standard DSO for Consolidation Layers.
• Built User exits for all teh applicable applications using CMOD to populate teh data from teh respective application tables.
• Created Analysis Process Designer (APD) to extract pricing data into CSV file format for further analysis by using data transformations.
• Developed complex ABAP routines to split single records from sales source data to multiple records in teh target by creating Internal table to teh meet teh requirement. Created Update Routines and End routines to count teh instances of Quantity differences and Time concatenation etc. in Inventory Accuracy report.
• Dialog Programming: Designed and developed custom screens for printing labels at different plants. dis functionality is not provided is SAP & hence separate Tables, Data Elements & Domains had to be created.
• Developed Sales Order Status report using Module pool methodology which provides teh list of all sales orders and details including teh line items and its status in teh system when teh customer or date range is selected.
• Created and Maintained DTP and Info Package for Loading. Created, Maintained and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types.
• Performed automated deletion of PSA and Change Log tables using Process Chains to improve teh Data Management.
• Proposed and installed BW Statistics to monitor teh Load and query performance on cubes and enhanced teh performance by building aggregates on required objects. Injected BW statistics event in teh process chain for Data collection.
• Implemented Compression and Partition techniques for cubes to improve teh query response time. Proposed archiving strategy for future based on Time characteristics.
• Worked on teh implementation of BI Accelerator. Involved in identifying cubes for BIA, Creating indexes and performing BIA index reorganization.
• Created reports and structures from purchasing data sources like Purchase Orders Quantities, Purchase Order Values.
• Developed sales reports like Order to Cash (OTC), Weekly Deliveries, Sales Values, and Incoming Orders.
• Developed BEx queries for reporting on Info Cubes, InfoSets, ODS and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting.
• Responsible for teh development of various Test Cases/Scenarios and validation of BI reports at various stages of testing such as Unit Test to validate data load, report testing and delta verification and detailed Integration Testing for various test case scenarios.
• Performed Functional Testing to test teh system settings and custom developments, to make sure dat teh development or configuration works as designed and teh data is accurate.
• Created BI OLAP universes over BEx queries using Universe Designer, published teh reports on teh web using Web Application Designer (WAD).
• Extensively worked on formatting Business Objects reports to meet teh user’s requirements using Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Contexts, Alerts.
• Extensively Worked wif SAP Live Office to create connections between WEBI and Xcelsius Dashboards. Worked on INFOVIEW to create Web Intelligence Reports over BO Universes.
• Worked wif Transport connector for transporting teh BW objects and reports between Development, Test and Production systems.
• Worked extensively on various Production support issues and administration of BI back-end operations by raising tickets to SAP OSS (Online support system) to teh ensure data is successfully extracted from source systems and reported correctly.
• Trained Super Users to develop ad-hoc queries in BI Query Designer. Teh training included creating queries from various sources such as InfoSets, Multi Cubes, creating and restricting CKF’s and RKF’s, use of aggregations and creating input parameters among other items.

Confidential, San Diego

SAP BW/ BI/ BOBJ Consultant

Environment: SAP Net Weaver 2004s BI 7.0, 7.3, ECC 6.0,CRM, Business Explorer, HR, SD, FI-CO, ABAP, APO, WAD, 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, 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.
• 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 Info Cubes.
• 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.
• Created mapping rules for migration of data, upon teh requirements and extensively worked on Data Services XI 3.2 for migrating data.
• Worked wif different Data Quality Transform such as Global Address Cleanse, Data Cleanse and Match Transform and Used Data Quality in data cleansing, standardization, consolidation and enrichment of data
• Responsible for scheduling batch and real time Jobs using Data Services Management Console and also responsible for Debugging and testing of ETL Jobs using Business Object data Services.
• 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, CA

SAP BW/BI/ BOBJ Developer

Environment: SAP Net Weaver 2004s BI 7.0, 7.3, ECC 6.0, Business Explorer, HR, SD, FI-CO,PPM,ABAP, MM,WMS, APO, Integrated Planning, CRM,WAD, 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 Info Cubes to facilitate various reporting requirements like teh Price Purchase Variance and Foreign Exchange Exposure reports.
• Developed a complex dialog program to automate document creation in sales order process.
• Activated Business Content Info Objects, 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 Info Objects, 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 dat 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.
• Created BIAR File using Import Wizard for Deployment of Universes and Web Intelligence
• 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 . Los Angeles, CA

Sr. SAP BW/BI/ BOBJ Consultant

Environment: SAP ECC 6.0, SAP-APO, Integrated Planning, SD, FI, SAP BI 7.0, and ABAP, CRM, PPM, 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 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.
• 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 Info Objects, DSOs and Info Cubes.
• Performed analysis, design, development and implementation of standard/customized Info Cubes 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 Info Cubes.
• Defined transformations, created DTP’s and Info package 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 Net Weaver BI, which includes a fully functioning MDX query builder dat you can use to connect to BEx OLAP-enabled Query Cubes, Info Cubes, 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,WMS, 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 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 InfoSets 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, Colegeville, PA

Sr. SAP BW/BI/BOBJ Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, MM, SD, FI, IS-Retail, 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.