SUMMARY

• 9+ years of extensive experience as a SAP BI/BW (7.4, 7.3, 7.0, 3.5, 3.1C, 3.0B) and BO (Xi3.1, 4.0, 4.1) consultant.
• Undergone 4 complete life cycles implementations of SAP BW/BI and 2 SAP R/3 full Implementation which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up - loads), Scheduling, Monitoring, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation and 1 full life cycle implementation in Business Objects XI 3.1 (BOBJ).
• Strong working experience in data analysis, design, development, implementation and testing of data warehousing using data conversions, data extraction, data transformation and data loading (ETL).
• Experienced in Extraction, Transformation, and Loading of data into BW constructs (PSA, DSO, Cubes) and expertise in data extraction procedures for non SAP systems such as third party systems like Teradata, My SQL, Oracle.
• Worked on BODS to load data into BW.
• Expertise in data extraction from Flat files and SAP R/3(SD/MM/FI/CO) using standard and generic extractors
• Extensively worked on FI-GL, LO Cockpit, CO-PA,Generic Data Source, DB Connect customization and extraction.
• Expertise in creating designs of custom extractors for modules like CRM, SD, MM, PP, and FICO using ABAP
• Solid experience in construction of customized Info Objects, Info Cubes, Remote Cubes, Transactional Cubes, Multi Providers, Info sets, ODS/DSO objects.
• Expertise in Transformations, DTPs, Update rules. Transfer Rules, Hierarchies, Routines, Process Chains and Event management.
• Expertise at creating data source connections via SAPI, DB Connect and flat files so as to load data into SAP BW system
• Sound Knowledge on BW 7.3 on new features like Hybrid Providers, Semantic Partitioning Objects, HANA Optimized Cubes.
• Experienced in creating info package to create process chains and scheduling of data loading with Full/Initialization/Delta upload method.
• Worked on performance tuning by using delta loads, process chains and creating aggregates, carried out day -to- day monitoring, fixing loads etc.
• Expertise in creating Generic Extractors and solid experience in ABAP
• Expertise in BEx Analyzer, Query Designer, Web Application Designer, Info-Set queries, Jump Analysis using RRI. Hands on experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures.
• Experienced in using BEx Query Designer for OLAP reporting and for enterprise reporting.
• Expertise in project lifecycle management.
• Had good hands working on crystal reports.
• Expertise in Business Objects which includes building Universes.
• Expertise in BO administration, designing Universes, Webi rich client reports, Webi Reports, Deski reports, Crystal Reports and Full Client Reports (3.1), XCelsius.
• Created Dynamic Xcelisus Dashboards, using QAAWS, Live office and Bi services
• Published reports formed to Xcelsius using BI services,QAAWS and Live office.
• Expertise in Providing support and maintenance including: end-user support, service incidents/problem resolution, and system support processes which include daily job monitoring, coordination with other IT teams and communication with impacted users
• Skilled at creating dashboards using Xcelsius involving all sorts of selectors and prompts with particular focus on dynamic visibility.
• Expertise in working on design studio to create dashboards,for viewing on mobile devices
• Well versed across all packaged XCelsius components.
• Proficient in coordinating and managing the activities between on-site and off-shore teams.
• Excellent communication skills and presentation skills and ability to lead a team.
• Experienced in upgrade from BW 3.5 to BI 7.3.

TECHNICAL SKILLS

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

ETL Tools: SAP BI 7.0,7.3,7.4, BW 3.5

SAP Modules: SD, MM, FI, HR, APO, SCM, CRM

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

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

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

Web Technologies: HTML/Dreamweaver/FrontPage/XML

Documentation: MS-Office

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

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

SAP BW/BI Lead

Responsibilities:

• Interact with business representatives to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BI Reporting and applications
• Work directly with the business and other IT counterparts to prioritize, design, plan, manage, and deliver reporting and analytics solutions.
• Understand SAP standard content to satisfy Business requirements, but also possess the capability to enhance/customize where necessary.
• Responsible for designing, coding, configuring and testing SAP cubes, reports and dashboard solutions to support the user requirements.
• Responsible for the design and development of the data acquisition process, data mapping, SAP extractors, DSO, InfoCubes, InfoObjects, etc. in an SAP BI Netweaver 7.0 environment and will estimate, schedule, design and execute the various reporting projects.
• Perform requirements gathering, analysis and design; write technical specifications; configuration and programming in the SAP/BI environment, including testing and implementation.
• Monitor, communicate and troubleshoot issues with data integrity, data design, and functional and technical software issues.
• Involved in checking BW authorization objects for granting access to InfoProviders for reporting.
• Involved in security analysis by checking profiles for end users and reporting users.
• Design complex, custom BI solutions or component objects translating complex requirements into an optimal BI design.
• Competent in BW authorization in roles, and authorization-relevant characteristics.
• Improved error handling and integration troubleshooting via synchronous interfaces
• Develop and drive the implementation of BI best practices and standards for the team.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Prepare project related documentation (object designs, business rules, technical information etc) during the different stages of the project.
• Developed Pending Order Status Report to display pending Purchase Orders (PO) with drilldowns for material and vendor
• Customized cubes such as Sales Order(0SD C03), Sales Delivery (0SD C05)and Sales Over view(0SD C03)
• Created Custom Multi Cube to support FIAR Users, which is a two-cube structure joining one custom FI (company info) Cube with one Business Content AR Cube, allowing users to drill down the customer details and ledger accounts
• Involved in the migration of BW Database from DB6 to HANA.
• Migrated data flows from 3.5 to 7.x as and when required.
• Implemented Attribute, Analytic and Calculated views using HANA studio and consumed in BW using Virtual providers and Composite providers.
• Worked with Graphical views by using the available nodes such as join, union, projection, aggregations.
• Switch over Bex Query into HANA Views and extensively worked on Calculated Columns, Restricted Columns, Input parameters, filters, expressions.
• Involved in create and maintain script procedures and used wherever calculation views are not enough to meet the business logic
• Worked on Authorization part by creating HANA Analytical Privileges and assigning with procedures.
• Follow HANA Best practices for better performance optimization such as re-usability options.
• Worked on HANA SQL Script, Stored Procedures and debug experience.
• Published HANA Models into BW as Transient Providers.
• Create data models and data flows (extended star schema, ODS, data marts & external data).
• Involved in providing Authorizations by creating Roles and Profiles.
• Highly motivated team player with Strong organizational, Presentation and Analytical skills.
• Extensively used MS Excel skills including PIVOT tables and VLOOKUPs.
• Supports the design and delivery of KPI (Key Performance Indicator) reports, management dashboards, and visual analytics for distribution to analysts as well as executive management.
• Responsible for development of several workbooks using custom VBA code for enhancements.
• Performed performance tuning of queries using indices, aggregates, compression and partition.
• Created intermediate write optimized DSO Structures and APD’s in BI7.4 to improve performance while loading AP data.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA. Created procedures in HANA Database.
• Involved in WAD to design studio migration project and created drilldowns for this wad reports.
• Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts.
• Involved in monitoring the performance of the system and reporting which includes performing OLAP Cache, Aggregates, Indexes, Archiving the non-cumulative info cubes, Partitioning, etc.
• Complex Queries in Sales- Billing reports, Delivery reports etc using Design Studio.
• Created Aggregates on Info Cubes to improve the query performance.
• 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.
• Actualized various types of BEx query variables including User exit, Replacement Path, Text and formula variables. Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Responsible for Developing QA/UA Test Plan, Test strategy, Schedule, resource allocation and approach for testing.
• Extensively used Restricted and Calculated Key Figures, Replacement path Variables, Customer Exit Variables, calculations, variables, prompts, sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Involved in Unit, QAT, UAT and data quality testing.
• Extensively worked in BOBJ 4.1 reporting, in the context of developing the Universe using the Universe Designer and the Analytics using Xcelsius, WebI and Crystal Reports.
• Created seven new complex BEx queries for Xcelsius Dashboards.

Environment: Business Objects XI R3.1,4.1 Enterprise, SAP BI 7.4, Xcelsius, Design Studio, VBA,TOAD, SQL 2008, ActiveX, Microsoft Visio, Access 2000, Windows XP

Confidential, San Jose, CA

SAP BOBJ/BW Lead

Responsibilities:

• Involved in complete Product Development of SAP 3.5 and (SAP Netweaver 2004S)
• Involved in upgradation from BW 3.5 to BI 7.0.
• Performed migration of emulated data source.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
• Used Write-Optimized DSO (DataStore Object) to load data into BI system.
• Enhanced Infocube with remodeling concept to make changes, without having to reload data.
• Used the lock concept to lock tables, characteristics and manage these locks.
• Developed backend work by creating InfoCubes, DSO, InfoObjects as InfoProviders, InfoSets, Open Hub destination, Multiproviders and Process Chains.
• Created complex Start routine in Transformations of DSO and mapped with 3 tables in Data Dictionary and populated data dynamically into the data target.
• Created Hierarchies for all Master Data InfoObjects.
• Developed IMG activities in BI to point the Maintenance Views of tables further created tables and views based on the requirement.
• Created Generic Extractors using Views and Function Modules.
• Created Info Cube for Inventory Management using business content data sources in BW Eq. For Stock balance used 2LIS 03 BX, Movement 2LIS 03 BF, and for Revaluation purpose used 2LIS 03 UM data sources
• Enhanced Master Data sources for 0MATERIAL and 0CUSTOMER
• Used transfer routines for key figure calculations, update routines in the update rules.
• Actively involved in the Front end development using WAD (2004s), BEx Analyzer.
• Developed Workbooks and Web Templates for Web Application Designer (WAD) and posted them in portals as Iview.
• Created Exceptions and send alerts to the users in the format of Email using Broadcasting. Configured Reporting Agent to mail precalculated reports to a variety of targets.
• Created Calculated KF and Formulas to report on Multiproviders.
• Involved in Performance tuning of queries and fixed them by creating aggregates and checking the performance in the query trace.
• Performed BW security and authorizations and created reporting roles and maintained security at InfoObject levels for different dealers.
• Involved in creation of User Exists, Variables, Exceptions and conditions in Reports.
• Designed Technical Specs for back end and Front end development.
• Creation of Data Sources, data extraction and retractions.
• Extensively worked on COPA extractions and retractions.
• Enhanced datasources on r/3 side.
• Worked on Profitability Analysis reports, etc.
• Used generic extractors in BW for datasources from other than R/3.
• Deletion of PSA data and Compression of data content in the InfoCube. Monitored the data loading.
• Providing 24/7-On call support.

Environment: Business Objects XI R3.1,4.1 Enterprise, SAP BI 7.3, Xcelsius, Design Studio, VBA,TOAD, SQL 2008, ActiveX, Microsoft Visio, Access 2000, Windows XP

Confidential, Harrisburg, PA

SAP BI/BOBJ Developer

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Worked with Business Explorer (BEx) and publishing the reports on web using Web Reporting tools
• Created the Process Chains, Meta chains and automated the load process based on the business needs.
• Involved in complete Sales Order Reporting function, complete with Orders, Order Items, and various Key Figures.
• Extensively worked on BEx Analyzer and WAD to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, Formula Variable, Replacement Path, Customer/User Exits, Tables and Charts.
• Implemented Process Chain to schedule automatic data loads and apply business rules for loading data to Info Cubes and ODS.
• Designed universes using SAP BW Info Cubes.
• Designed Universes on Teradata DB platform as per the technical requirements and applied the necessary object level, row level security.
• Designed, developed and managed Universes in Business Objects Designer for generating reports against SAP BW.
• Created the reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Sections, and Master Detail and Formulae’s etc.
• Involved in configuring XCelsius with different Methods to connect to universe.
• Worked on Live Office and QAAWS.
• Created best practices document for universe development and Webi reports against SAP BW
• Collected performance metrics from the various components inside the running Web application, the application server and performance and availability data from the surrounding computing environment Using WILY Introscope.
• Responsible for solving the production issues raised by the business users.
• Preparing test cases for the created Webi and dashboard reports that in corporate application business rules for QA team to perform testing before rolling to production.
• Build SAP BW Reports on the SAP Sourcing and Forecasting modules, including demand planning, Gathering requirements for BI queries and reports, ensuring proper usage, quality and security of the information provided Identify areas of operational improvement by utilizing system functionality and provide end user training programs, report design, and system testing.
• Worked as an Onsite coordinator for converting 3.0 Deski reports to 3.1 Webi reports.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure by creating Users/Groups/Sub-groups & assigning the privileges.
• Enhancing the BW info objects
• Involved in migrating the reports and the universes from DEV to UAT and Prod and vice versa and creating .biar backup files of the production data. Created Reports on CRM, POS, Sales and Orders, Plan, AR, Inventory Modules of SAP BW.
• Involved in the analysis, design, and creation of Accounts Payable Xcelcius/Webi dashboard with SAP BEX queries for facilities/storage management group.
• Created Customer fact sheet Dashboard for Business needs and automated the dashboard using live office.
• Exclusively Used QAAWS, Live Office, XML mappings as per the Dash board requirements.
• Developed web services using Query as a Web Service Wizard (QAAWS) and deployed it to the server for developing Xcelsius dashboards.
• Managed the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CMS.
• Involved in creating User Training document for the end users and the power users in BOBJ.
• Involved in performance tuning of reports, unit testing and documenting the processes.
• Involved in scheduling the Atlantis reports and process them for Business users.
• Responsible for delivery of Business Objects Reports environment on time
• Identifying the risks and issues from team meetings and coordinating with Project manager.
• Created User training documents for BOBJ for end user training to work on reports.

Environment: SAP BI 7.0,Business Objects XI R3.1 (SP4), BO 4.0, LCM, SAP BW 3.5, XCELSIUS 2008, WEBI, DESKI, Designer, Teradata, BCA, CMC, SAP BW, ECC 6.0,Microsoft Visio, Access 2000, Windows XP.

Confidential, Calvert AL

SAP BI/BW Developer

Responsibilities:

• Involved in the design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods.
• I was responsible to work across full sap life cycle implementations like requirements gathering, design, development and post go live support and enhancements.
• Analyzed the Info Cubes and ODS objects to meet the reporting needs of the client.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement.
• Loading of transaction data to the business content Info Cube from Info Sources like 2LIS 11 VASCL, 2LIS 11VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order.
• 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.
• Experience in the creation of the setup tables for the LO Cockpit extraction.
• Created process chains for periodic upload of the master data as well as the transactional data.
• Used ABAP code to write start routines, update routines, end routines in transformations to facilitate reports for Purchase Price Variance, Inventory Accuracy.
• Involved in the monitoring data transfers from source systems into BW using PSA.
• Developed reports on the MM cubes to check the price variance for materials from different vendors.
• Created reports on SD cubes for displaying sales figures and incoming orders.
• Experience in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• 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 within 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.
• Involved in the creation of the dash boards for sales, purchasing and delivery using Web Application Designer.
• Performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
• Used the APD (Analysis Process Designer) feature in BI to perform several look ups to tie the transaction data to specific master data attributes.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as iView.
• Performed extensive unit testing in the development environment for all the objects created.
• Worked with the security team in designing the security strategies for global front end reports and workbooks.

Environment: SAP BI 7.0, ECC 6.0 QAAWS, Business Objects XI R3.1 (sp2) Enterprise, Performance Manager, Dashboard Manager, XCELSIUS 2008, WEBI, SQL Server 2005,Oracle 10g, ActiveX, Microsoft Visio, Access 2000, Windows XP.

Confidential, Phoenix, AZ

SAP BI/BOBJ Developer

Responsibilities:

• Involved in end-to-end design and development of COPA data sources, transformations, DSO’s etc for O-I global implementation project (APAC, EU, LA).
• Involved in end-to-end design and development of COPA dataflow for NA region and loaded data through Flat files.
• As a technical lead I did Lead projects from a development standpoint to ensure that projects are completed on time. Architect solutions from a technical standpoint to make sure that we build the right reporting solutions. Worked on Integration between Business Objects and SAP Business Warehouse Sustainable Long term Strategy around multiple tools and multiple delivery mechanisms.
• Worked from the functional/business requirements to design and develop BW objects (install standard objects, enhance existing objects, and create custom objects) like info objects, business content, info sources, data targets, transfer rules, update rules, etc. Provide support and maintenance of the existing BW and APO environments (development, quality assurance and production).
• Worked in Web Application Designer (WAD) to generate Production Planning reports and publish them on to the Portal.
• Exacted data from 0CO PC ACT 1, to find out Actual Costing / Material Ledger / Costs and generated reports Actual Costs in Current Year, Actual Prices for Cumulated Inventory and Actual Prices for Material in all Currencies .
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed Process Chains for Daily Master data loading and transaction data loading from ECC to BI.
• Created the Process Chains, Meta chains and automated the load process based on the business needs.
• Involved in complete Sales Order Reporting function, complete with Orders, Order Items, and various Key Figures.
• Extensively worked on BEx Analyzer and WAD to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, Formula Variable, Replacement Path, Customer/User Exits, Tables and Charts.
• Implemented Process Chain to schedule automatic data loads and apply business rules for loading data to InfoCubes and ODS.
• Created Query to report on Cost Center Detail that provides Cost Center manager an overview of the planned costs and Variance for the selected cost center.
• Involved in migrating the reports and the universes from DEV to UAT and Prod and vice versa and creating .biar backup files of the production data. Created Reports on CRM, POS, Sales and Orders, Plan, AR, Inventory Modules of SAP BW.
• Designed universes using SAP BW Info Cubes.
• Created best practices document for universe development and Webi reports against SAP BW
• Responsible for solving the production issues raised by the business users.
• Enhancing the BW info objects
• Created Customer fact sheet Dashboard for Business needs and automated the dashboard using live office.
• Managed the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CMS.
• Worked with UD Connect to bring in receivables data from non-sap systems.
• Worked extensively on start routines, field routines and end routines.

Environment: SAP BW 3.5; SAP BI 7.0, SAP R/3 ECC 6.0, SD,QM, PP, PM, BEx, SAP BPC and Windows NT

Confidential

SAP BI/BW Consultant

Responsibilities:

• Involved in the end-to-end implementation of SD in BW.
• Involved in Design and Development of Error log Mechanism to capture error records.
• Design and Development of Custom Info cubes, ODS objects, Multi Providers, Info sets and master data objects.
• Developed Custom ODS objects that captures the erroneous data.
• Development and Enhancement of Info sources, Transfer rules and update rules.
• Created update rules with necessary update routines and start routines.
• Created and activated Communication Structure, Transfer Structure, Transfer Routines, Update Rules (both ODS and Info Cube level). Built and loaded cubes and validated results.
• Involved in creating a Daily Load Process chain that loads the Data files coming from McKesson.
• Created Process chains that will extract data using RSCRM BAPI to EDW and IMS external systems respectively.
• Worked on loads and scheduling with Process Chains.
• Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.
• Solved Chasm Traps, Fan traps and Loops using Contexts and Alias methods.
• Test phase implementation involving Unit & Integration testing the complete interface.

Environment: SAP BW 3.1C, SAP R/3 4.6C, ABAP, MM, FI.