SUMMARY

• 7+ years of SAP Business Objects (BO) experience and Business Intelligence & Business Warehousing.
• Extensive experience in working with multiple projects encompassing multi - cultural teams from diverse geographical regions.
• Experience working for corporations across diversified industry verticals includes Pharmaceutical, Retail, Manufacturing.
• Proficient with Data Services, and also Business Intelligence applications using SAP Business Objects Business Intelligence 4.0 with BI Launch Pad, SAP Business Objects Enterprise XI R3.1/R2, with InfoView.
• Experienced in Analysis, Design and Development of various Data Warehousing projects using SAP Business Objects Data Services 4.0/3.2/3.1, Data Integrator XIR2/11.7/11.5, Business Objects XI 3.1/XIR 2/6.5/6.0/5.1.
• Implemented 2 complete Lifecycle Data Services projects including requirement gathering, data modeling, extractions, data staging, data cleansing, data quality and transformations and reporting.
• Experience with Data Quality Management Metadata Management, Master Data Management, Process Modeling, Data Dictionary, Data Profiling, Data Quality, and Data Model Standards.
• Expert in documenting business requirements, functional, technical specifications and test cases.
• Experienced in Troubleshooting and having good knowledge on Material master Data Management.
• Expert in Data Services Data Quality (DQM) like address cleansing and data cleansing process.
• Experience in SAP Data Migration using Data Integrator as the tool and Data Cleansing, Address cleansing using Data Quality as the tool and Pro-Active Data Validation.
• Data Object Planning, Definition, Mapping, Migration & Consolidation.
• Good Understanding of SAP modules FI/CO, HR etc., Experience in accounting & financial reporting in BI.
• Performed BO Admin duties, Adding New users and user groups, setting up Security Migrating Reports/Universes etc.
• Experience working with Web Intelligence, Web Intelligence Rich Client (WEBI), Desktop Intelligence, Crystal Reports 2008 & 2011, Xcelsius 2008 (Dashboards 4.0), Central Management Console (CMC), Query as a Web Service (QaaWS), Live Office, Publishing Wizard, Import Wizard and Report Conversion Tool.
• Excellent knowledge in implementation of Relational Database (OLTP) and Data Warehousing systems (OLAP) and Data Marts.
• Experience in Business Requirements Analysis and Documentation.
• Used Dashboard design tool to build interactive dashboards to be used by executive management.
• Extensively worked on developing Dashboards, Analytics, and Metrics using Performance Management.
• Used BEX queries developed in SAP BI/BW 7.1 as a data source for the universes built in SAP BO/BI 4.0
• Extensively used Calculations, Variables, Prompts, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business objects reports.
• Expertise in generating the Complex Crystal Reports like On Demand reports, Sub Reports, Drill-Down, Dynamic Grouping, Cross-Tab, Graphical, Ad Hoc Reports, Summary Reports, Linked Reports, Mailing Labels and Aging Reports.
• Good Experience in creating Corporate Dashboards, Scorecards, Performance Metrics, Rules, Alerts, Bar charts, 3D charts, Pie charts, Column chart, Line chart, Bubble chart and Goals using Xcelsius 2008.
• Good Knowledge on SAP HANA.
• Experienced in Business objects universe designing (OLAP Universes), Business Objects Web Intelligence (WebI), InfoView, and BOE.
• Hands on experience in creating BO Xcelsius dashboards and KPI’s to large-scale multi-layer reports.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• Expertise in working with BEx Analyzer in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Extensively worked on publishing reports to roles and portal, broadcasting workbooks, reports to end-users. Experience in providing the security using Authorizations for various requirements.
• Involved in End-User training on Navigating reports, Post Go-Live maintenance manuals, Web Application Designer, Portals.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively with Team members, developers, clients and end users in a diverse environment.

TECHNICAL SKILLS

BO Tools: SAP BO BI 4.0, SAP Business Objects XI 3.1/XIR2, Xcelsius 2008 (Dashboard Design), Crystal Reports 2011/2008, Universe Designer, WebI, DeskI, QaaWS, BIES/BICS, BOBJ Explorer/Polestar XI 3.1, CMC, InfoView, BI Launch Pad, Analysis - Edition for Microsoft Office.

ETL: BODS 4.1/4.0, Xi3.2, 3.1, 3.0, Business Objects Data IntegratorXIR2/11.5/11.7, Data Quality 3.1, Data Insight XI R2, Information steward 4.0

SAP BW/BI: SAP BI 7.3/7.0, SAP BW 3.5

SAP ERP: SAP ECC 6.0

Operating Systems: UNIX, LINUX, Windows

Databases: Oracle 10g/9i/8i/8.0, Sybase, SQL Server 2005, MS Access

Other Tools: MS Office 2010/2007/2003 (Excel, PowerPoint, Word, Outlook, Project), Visual Studio, HP Quality Center, Remedy, SharePoint, Illustrator

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

SAP BOBJ / BODS Consultant

Environment: SAP BO 4.0, Web Intelligence Rich Client, Dashboard Design, BI LaunchPad, QaaWS SQL server2008, Mobile BI, Analysis - Edition for Microsoft Office.

Responsibilities:

• Interfaced with Business Users to write up the functional, technical specification to integrate SAP BW 7.01 with an existing in-house application.
• Architected the data integration framework using SAP BW 7.01, Data Services and Microsoft SQL Server 2008.
• Setup RFC communications between Data Services and SAP BW.
• Designed the PSA's, DSO's to stage, transfer data to support the data integration framework.
• Create the Data Stores, Data Flows, Work Flows, Jobs and Projects following the Client Specific Naming Convention.
• Created mapping rules for migration of data, upon the requirements and extensively worked on Data Services XI 3.2 for migrating data.
• Performed BO Admin duties, Adding New users and user groups, setting up Security Migrating Reports/Universes etc.
• Perform configuration and tests to all business objects, Manage and supervise configuration of all business objects.
• Develop various use cases and provide functional specifications for teams and individuals.
• Documents all business objects data and Meta data and supervise security of all areas.
• Coordinate with various departments and configure all ETL extractors as per SAP requirement.
• Worked with 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 decode, lookup-ext, search replace, index, aggregate, if-then-else, match, match pattern, gen row num, word and date functions as part of transformation, used ABAP data flows, worked on scripts, pre-load and post-load commands.
• Involved in Performance Tuning of BODI extraction programs and reduced execution time of expensive jobs significantly
• Involved in development of Cost Inventory Reports By (Brand/Dept/Store), PO Extract Report, Sales Summary Report, MMPR Report, Age Shipment Report (DC to Store, DC to Store with PO Numbers, Store to Store), and Goods In Transit Report using Crystal Reports 2008. These reports developed using complex formulas with Running Totals based on grouping and transported these reports from DB to QB then PB using SAP BW Publisher and they are developed against SAP BEx queries.
• Once these reports are designed and developed in Crystal, All formatting is validated in DB then to QB and then moved to PB using Import wizard for data validation.
• Designed, developed and managed OLAP Universes using Universe Designer against BEx queries. Created custom hierarchies in OLAP Universes so that user can Drill Down from Company Brand Distribution Channel Merchandise Division Merchandise Department Merchandise Category level. Using this hierarchy’s user can drill down or navigate the data in different levels.
• Developed custom prompts (filters) in OLAP Universe using MDX queries.
• Involved in development Midweek Recap Reports, Daily Flash Reports, Gross Margin Report, Finance Template Report, Inventory Control Template, Monthly MOS Report (Dept/Store), Merchandise Weekly Template, Merchandise Daily Template, Store Hierarchy Report, Stock Ledger Report, PO International Report, Seasonal Merchandise Plan Report (SPRING/FALL), and Sourcing Template Report (Brand/Distribution Channel/Store/Departments) using WEBI Rich Client.
• Involved in defining security roles to the users. At Ann Taylor there are different groups like Back Office, Inventory, Merchandise, Supply Chain, and Flash users. So to get access to their particular folders in Infoview; imported all SAP roles into BOBJ in CMC.
• Involved in training end users from different departments as how to use Crystal and WEBI reports as this is new implementation at Ann Taylor. We trained them how to login into Infoview system, how to get access to the reports, how to save reports to their favorite’s folder, and how to create Ad-hoc reports.
• Performed Unit testing, system testing and user acceptance test for universes, reports and security management.

Confidential, SFO, CA

SAP BOBJ / BODS Consultant

Environment: SAP BO XI3.1, Web Intelligence, Oracle 10g, Crystal Reports 2008, Xcelsius 2008, Import Wizard, and CMC.

Responsibilities:

• Interacted with business end users to gather requirements.
• Prepare High Level ETL design - Process Flow, Source to target mappings, design of data standardization, de-duplication and Cleansing modules for subscriber, data validations, plan for historical data analysis and modification.
• Extracted data from legacy systems to ECC 6.0(SAP R/3) using Data integrator as the ETL tool.
• Used Data cleanse and Address cleanse transforms to correct the Customer Master data extracted from file formats.
• Implemented the application of the Data Cleanse Transform on Customer and Vendor Master data to identify and parse the data to confirm to company standards.
• Used the Data Cleanse Transform on first name, last name, title, phone no, mail id,firm name, etc.and used Match Transform to correct the data by using tailored parsing dictionary PERSON FIRM EN in the Work Flow.
• Used global Address Cleanse transform and USA Regulatory address cleanse transform to parse, correct, complete, and standardized the address components to de-duplicate the address data.
• Data flows were designed by incorporating cleansing transforms on collaboration with match transform with set priorities to consolidate Master data.
• Based on the Data Governance requirements of the project Business validation rules and Audit functions were defined.
• Extracted data from legacy systems to BW system with SAP BODI as ETL.
• Designed, developed, implemented and documented complex Batch jobs and Real time jobs to extract data from deferent data sources.
• Transform the data and load the data to specified destinations using Data Integrator (ETL)
• Define database Data Stores and File Formats to allow Data Integrator to connect to the source or target database and files.
• Created custom functions where needed and used available Built-in Functions with scripting Language and created global and local Variables and parameters.
• Involved in scheduling the execution of the batch jobs and fixed the issues, if the job fails during the scheduled time.
• Used different data integrator transformations, interactive debugger and used logic to cleanse data in DI using proper data types and mappings to parse, and load the data from the source to the target databases.
• Created Workflows using local object library and tool palette to execute data flows.
• Published and scheduled batch jobs and real time services via web services using Data Integrator Administrator.

Confidential, Centralia, WA

SAP BOBJ / BODS Consultant

Environment: SAP Business Objects (SAP BOBJ), Enterprise XI 3.1 SP3 (Designer, Desktop Intelligence, Web Intelligence, Info View, Import Wizard, Report Conversion Tool), Crystal Reports 2008, Xcelsius 2008, SQL Server 2008, Oracle 10g.

Responsibilities:

• Worked closely with the DBA and the functional users to understand and gathered the business requirements for the Silverpop and CCRP projects.
• Prepared technical specifications and high level design documentation for the ETL processing.
• Designed the system architecture to build BO data services on all environments DEV/QA/PROD.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Crystal Reports.
• Involved in designing Universe and migrating existing Desktop Intelligence (Deski) Reports to Web Intelligence (Webi) report.
• Designed and developed the Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of the tables and structures of the Universe.
• Used various Universe optimization techniques to improve query performance.
• Involved in the getting the business requirements from the global users and developed the prototype for different solutions
• Developed the Technical specification based on the functional specification documents.
• Developed the complete solution for internal supplier service level and Back order by pulling the data from the staging layer using the Sales Order, Purchasing and Delivery extractors.
• Developed the custom Function module extractor to get the Standard lead time for the customer material combination.
• Developed generic data sources to get the data from ECC for Sales document category and transportation dates.
• Written start routines, rule level routines and end routines in consolidating the data from all the logistics data sources in to one DSO and then push the data in to second level evaluation DSO and then to the cubes.
• Developed the Bex queries to build BO reports on top of these queries used, Formula variables, Customer exit variables, Replacement path, Restricted Key figures, calculated key figures, structures.
• Developed the process chains for all the new development and also integrated with the existing the process chain for scheduling.
• Designed and developed generic data sources to bring the sales forecast data from flat files. Used expert routines in the transformation to load the data as per the business requirements.
• Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up in Web Intelligence and Desktop Intelligence.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerter, inserted calculations, Filters, Sorts, and Query Prompts.
• Developed physical inventory WEBI report specific to each country and also developed global reports which has consolidated with the client standards. Developed the reports with 2 tabs as per the requirement with and without zero’s in the key figures.
• Involved in Unit testing and Quality testing, created the documentation as required for the all the development. Used HP Quality center and Documentum for testing and uploading the documents.
• Involved in go live and also supported the project after go live.

Confidential, CA

SAP BIBO Consultant

Environment: SAP Netweaver 04s (BI 7.0), ECC 6.0, CO, FI-GL, SD, BEx Analyzer, BO XI R2, Webi.

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Interacted with the Business Users to analyze the business process and gathered the requirements.
• Designed functional and Technical specifications for Implementation and Development of BO XI R2 over SAP BI.
• Extensively worked on SD InfoCube 0SD C03 and data sources 2LIS 13 VDHDR, 2LIS 13 VDITM, 2LIS 13 VCITM and financial data providers, multi provider’s 0FIAP M40 data sources 0FI GL 40 according business needs in SAP BI.
• Involved in development, integration testing, UAT to Go live production support of OTC, RTR reports.
• Created new info providers in SAP BI depending upon the end user needs
• 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.
• Extensively worked on BEx reporting and workbooks using RRI, cell definitions, variable offsets, exceptions, conditions, RKF’s and CKF’s.
• Worked on Central Management Console (CMC) in configuring BO environment.
• Defined BO Classes, Objects in the Universe, defined Cardinalities, Contexts, Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Created Universes over BEx queries and InfoCubes of SAP BI using Universe Designer.
• Extensively worked on Infoview to create Web Intelligence Reports over the Universe Created.
• Created Webi reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked In creating Variables, Prompts in Webi.
• Checked the Universes for Integrity and exported to the Repository to make resources available to the users and groups and Created Adhoc Reports by accessing the Universe.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Created reports with Charts (bar chart, Pie chart, etc.), Cross-tabs and Sub reports.

Confidential, San Antonio, TX

SAP Business Objects Consultant / Reports Developer

Environment: Business Objects 6.5, Crystal Enterprise 9, Crystal Reports 9, Oracle 8i, SQL Server 2000, Web-Intelligence, Full Client (DESKI), Designer 6.5, Toad, Windows NT/2000

Responsibilities:

• Involved in the designing and Building of Universes, Classes and objects for investment management system.
• Involved in Installation and Configuration of all Components of Business Objects.
• Excellent use of graphs and charts with named groups and formula fields.
• Designed and developed Web intelligence.
• Responsible for analysis of the systems, meeting with end users and business units in order to define the requirements
• Created various dashboard reports to measure the performance.
• Responsibilities included imparting training to the end-users and doing the knowledge transfer for reporting needs.
• Solid experience in creating application schema as tables, view and indexes
• Writing scripts to drop the index before and recreating indexes after the data load to increase the performance.

Confidential, Baltimore, MD

SAP Business Objects Consultant / Reports Developer

Environment: SAP Windows Enterprise Server 2003 Apache Tomcat, SAP BusinessObjects (SAP BOBJ) Enterprise XI 3.1SP2 (Designer, Desktop intelligence, Web Intelligence, Import wizard, Publishing Wizard, Report Conversion Tool), BusinessObjects Integration for SAP Solutions XI 3.1, Business Explorer(Query Designer),Crystal Reports 2008, Crystal Xcelsius, SAP BW,SAP BI 7.0, Oracle 10g, Mercury Quality Center 9.

Responsibilities:

• Involved in developing, designing and maintaining new and existing universes with Classes and Objects.
• Involved in migration of Universes, Reports, and Users from BO 6.5.1 to BO XI 3.1.
• Deployed BusinessObjects (BOBJ) Servers in Development, UAT and Production environments.
• Tested and implemented Service Packs and Fix packs to resolve identified issues and bugs in BusinessObjects XI 3.1
• Installed and configured BOBJ desktop applications such as: Designer, Desktop Intelligence (Deski), Web Intelligence Rich Client and Crystal Reports Client.
• Extensively used Designer to design various universes for different groups. Created complex reports using cascading prompts, decode objects etc.
• Debugged issues which resulted from Migration. Provided support in enhancement and maintenance of the BOBJ Reports and Universes.
• Extensively used the Import Wizard to migrate the universes, corporate documents, users and groups from the legacy BO to the XI 3.1 version.
• Used Stored Procedures to create different types of reports with the help of command object.
• Export and Manage reports on the server. Schedule the reports in various formats in Info view for recurring reports.
• Created customized existing reports using sub-reports and charts to present information.
• Created the Crystal reports using Oracle tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.
• Installed Web intelligence on the server and configured the IIS console to define the paths & aliases necessary to run WEBI.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Developed Crystal Reports and formatted the same with respect to the requirements. Added parameters, special fields, formulae and used multiple data sources to create the reports.
• Involved in Full project life cycle (requirement gathering to implementation phase).