We provide IT Staff Augmentation Services!

Sap Resume

TX

Professional Summary

  • SAP Business Objects Consultant with 9 years of experience in IT as a Data Warehouse Professional and Developer with very strong SAP Business Objects BI 4.0, SAP Business Objects Data Services 4.0, along with SAP BI Integration Experience.
  • Knowledge of HANA and ability to create attribute views, analytical views and graphical calculation views utilizing functional knowledge of various SAP modules. Implementing data level security and model level security using analytical privileges and package privileges using Information modular in HANA modeling studio. Practical expertise in utilizing SLT and BODS for data provisioning from various sources. Expertise in utilization of business objects BI4.0 for the reporting on models built in HANA
  • Expert in analysis and development of ETL data flow design using Business Objects Data Services XI 3.x(SAP BODS). 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. LSMW, ALE, BDC, IDOCs, BAPI’s, Uploading Data Object to SAP.
  • Worked on all areas of BI/BW such as Data Modeling/Build and Reporting tools(Bex analyzer & Query designer)
  • Expert in BW front end query designing and reporting in COPA, SD, MM and HR modules
  • Experience in Integrating SAP BW with BOBJ and worked on all reporting tools (WebI, Crystal and DeskI & Dashboards) in the BOBJ suite and Universes according to requirements.
  • Involved in multiple end to end Implementations, up gradations and Production Support
  • Expert in building SAP BW based BOBJ solutions and also using Oracle and SQL Server as a backend for Universe Designer, IDT, Web Intelligence, Crystal Reports 2011 and Enterprise, Xcelsius/Dashboard Designer, Live Office, QaaWS, InfoView/BI LaunchPad, Data Federator
  • Have good understanding of Business Objects(BOBJ) 3.1/4.0 architectures and functionality.
  • Experience in maintenance of security, migration of Business Objects servers.
  • Worked on development, administration, maintenance and troubleshooting of Business Objects Enterprise using Business Objects(BOBJ) 6.x, Business Objects(BOBJ) Enterprise XI R2 & XI R3, 3.1 suite of products on Windows platforms.
  • A Team Player with good Communication and Inter-Personal skills; Excellent analytic and problem solving skills, Quick learning capacity and positive attitude towards new challenges.

Education

Bachelors of Technology

Technical Skills

BI/BOBJ Tools: BOBJ BI 4.0, Business Objects XI 3.1/3.0/XIR2, Xcelsius 2008/4.5, Dashboard Design, Crystal Reports 2011/2008, Universe Designer, WebI, DeskI, Live Office, QaaWS, BICS, BOBJ Explorer/Polestar XI 3.1, CMC, CMS, InfoView, BI Launch Pad, Import Wizard, Upgrade Management Tool, LifeCycle Manager (LCM), Report Conversion Tool, Analysis - Edition for Microsoft Office, Integration Option for Microsoft SharePoint IOMS
SAP ERP: SAP ECC 6.0/5.0, R/3, 4.7/4.6c
Operating Systems: Windows, UNIX, LINUX
ETL Tools: SAP BI 7.0(BW 3.5), SAP BODS XI 3.x/4.0, Informatica
Databases: SAP HANA 1.0, Oracle 11i/10g/9i, MS SQL Server 2008/2005, MS Access 2000, My SQL and Oracle DBMS, Sybase
Language: ABAP/4, C, C++, HTML, SQL, PL/SQL, XML, Tomcat

Project Experience

Confidenital, (Jun 11 Present)
Role: SAP BI / BOBJ Lead Consultant
Responsibilities:

  • Involved in installation and configuration of BO Enterprise XI 4.0 components, BI Launch Pad, Dashboard Designer, Crystal Reports for Enterprise, Live Office, Webi, Advanced Analysis for Microsoft office and OLAP.
  • Interacting with users for customized and standard reports, gap analysis and associated solutions. Designed and developed functional specifications, technical specifications for BOBJ reporting on top of SAP BI/BW, PCM and HANA as per the system landscape.
  • Interacted with Project manager and end-users in architecting reporting solutions by understanding the requirements and writing universe, report and Dashboard specifications.
  • Created OLAP Universes on SAP data (Info cubes / BEx queries) using the Information design Tool
  • Designed and Developed BEx queries against the cubes and multi providers from GL, AR, AP, HR, Payroll and budget areas
  • Created detailed Crystal Reports using Formulae, Parameters and Grouping functionality using the New BICS Protocol
  • Scheduled and Broadcasted reports (Crystal and Webi) to individual recipients using BI Launch padscheduling functionality.
  • Installed and configured the BI BOBJ 4.0 client tools for use by developers and business users
  • Trained the in-house developers to work with all the SAP BI BOBJ toolset.
  • Worked on CMC to create User-groups and worked on security rights.
  • Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and BI Launch Pad for end user access.

ENVIRONMENT: SAP HANA 1.0,SAP BI Net weaver 7.3, SAP PCM, SAP BOBJ Enterprise BI 4.0, Business Explorer (BEx), Crystal Reports Enterprise, Information Design Tool, Webi, Dashboard Designer, Advanced Analysis for OLAP and Microsoft Office, BI Launch Pad, QAAWS, Live Office

Confidenital, SANTA Ana (OCT 08 MAY 11)
Role: Sr. SAP BI / BOBJ Consultant
Responsibilities:

  • I was involved in the Proof of concept of Business objects 4.0 at the client location, implementing the various tools and co-relating them to Business use cases.
  • Created OLAP Universes on SAP data (Info cubes / BEx queries) and Relational Universes on Non-SAP data using the Universe designer Tool
  • Created detailed reports with Drill-down capability using Interactive Analysis, worked on Ad hoc Query, Reporting, and Analysis
  • Broadcasted and scheduled reports (Crystal and Interactive Analysis) to individual recipients using BI Launch pad scheduling functionality.
  • Worked on CMC to create User-groups and worked on security rights.
  • Worked with Admin Team to integrate Dashboards, Reports into Enterprise Portal and BI Launch Pad for end user access.
  • 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 BW publisher
  • 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 hierarchies user can drill down or navigate the data in different levels.
  • 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 Info view; imported all SAP roles into BOBJ in CMC.
  • Involved in training end users from different departments as how to use Crystal and WEBI reports.
  • Performed Unit testing, system testing and user acceptance test for universes, reports and security management.
  • Set-up, presented and created reports on SAP Mobile platform using the SBO Explorer and Webi application on the Apple I Pad and I phone.

ENVIRONMENT: SAP BI Net weaver 7.0/7.3, SAP BOBJ 3.1 and Enterprise BI 4.0, BOBJ Mobile, Business Explorer (BEx), Crystal Reports Enterprise 2011, Information Design Tool, Interactive Analysis, Dashboard Designer

Confidenital, TX (oct 07 oct 08)
Role: Sr. SAP BW / Business Objects Integration Technical Consultant
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.
  • Design and develop simple and complex transformations in Data Flows.Performed code reviews, and SQL tuning to improve performance.
  • 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.
  • Created Crystal Reports based on the requirements, involved in designing cross tab, summary reports using Crystal formulas, parameters, selection criteria, sub reports based on Command Objects, Tables and Views.
  • Extensively used formula fields, parameter fields, Running Totals, Sorts, Group selection and Record selection in Crystal Reports, Published and Scheduled them within Info View.
  • Scheduled the reports to run at a daily/weekly/monthly basis and email the results to the users in the required format.

ENVIRONMENT: SAP BW 7.0 and Business Objects(BOBJ) XI 3.1, Business Objects Data Integrator XI 3.1

Confidenital, CA(Jan 07 Oct 07)
Role: SAP BW / Business Objects Integration Technical Consultant

Responsibilities:

  • Involved in gathering requirements from business end users.
  • Designed and developed the dataflow diagrams, data validations, data cleansing, data mapping and trace them to the DWH.
  • Involved in data extract process from ECC 6.0(SAP R/3), Legacy systems to BW 3.5 system using Data integrator (SAP BODI) as the ETL tool.
  • Actively involved in improving query performance and system performance by Identifying long running queries.
  • Used Transport connection to move objects from development to quality environments.
  • Worked extensively in building queries in the Bex Query Designer. Involved in creating variables, calculated and restricted key figures, variable offsets, conditions, exceptions and extensive work with the query properties.
  • Worked with Bex analyzer for formatted excel reporting, Created and formatted the reports using the Live Office in Excel and power point for presentations.
  • Designed BO Universe on SAP BW Queries & Info Cubes and developed WebI reports.
  • Created WebI reports & Crystal Reports and deployed them through Info View
  • Hands on experience with CMC and CCM XI 3.1.
  • Developed the Crystal Reports using the SAP Bex Reports as the database.
  • Identified various Management, Analytical and Operational Report requirements for HR Module and prepared Technical and functional documents.
  • Developed dashboard to provide analysis within GSK based on breakdown of the measure at a given levels of the organization. Developed complex Headcount & Personnel Actions dashboards to track the movement of employees from various portfolios.
  • Developed various Ad-hoc reports with complex functions including aggregate aware, @prompt, report level objects, filters and Derived Tables to speed up and fine tune the performance.
  • Created ad-hoc reports with multi prompts to retrieve required data for the user and to minimize unnecessary load on server
  • Created Crystal reports with cascaded multiple prompts and Created Reports with heavy conditional formatting and functions to meet user requirement.
  • Crystal Reports with Top N and Bottom N to highlight the demand of the clients line of Business.
  • Exported and published Crystal reports to the Business Objects Enterprise portal for the scheduling and publishing.
  • Actively involved in improving query performance and system performance by Identifying long running queries
  • Used Transport connection to move objects from development to quality environments.
  • Worked with Transport organizer to migrate the newly developed queries for testing and then migrated to production on SAP BW.

ENVIRONMENT: SAP BW 7.0 and Business Objects(BOBJ) XI 3.0, Business Objects Data Integrator XI 3.0

Confidenital, CA (mar 06 Jan 07)
Role: Sr. SAP Business Objects(BOBJ) Consultant

Responsibilities:

  • Performed Business Analysis and Requirements gathering from high-end users and managers.
  • Worked extensively in building queries in the Bex Query Designer. Involved in creating variables, calculated and restricted key figures, variable offsets, conditions, exceptions.
  • Worked with Bex analyzer for formatted excel reporting, Created and formatted the reports using the Live Office in Excel and power point for presentations.
  • Designed BO Universe on SAP BW Queries & Info Cubes and developed WebI reports
  • Primary responsibilities include project-based Webi, Deski, and Universe development, enhancements, troubleshooting, and business user support.
  • Managed all CMC content including reports, universes, folders, scheduling and Business Objects application and content access levels.
  • Created Ad-hoc reports using Business Objects functionalities like Cross Tab, Master Detail and Formulas, Alerts, Slice and Dice, Drill Down, and @Functions.
  • Wrote documentation for users on how to select necessary parameters and date frames for different selections.
  • Determined the Dimension, Measure and Detail objects and the scope of analysis for all the users.
  • Developed reports in Web Intelligence Rich Client using Excel as data provider and exported as Webi documents into the repository.
  • Designed and developed dashboards using Xcelsius by scheduling the Web Intelligence reports using Live Office and Created score cards in the Xcelsius.
  • Created Xcelsius dashboards using charts, bar graphs, selectors, Container, Single Value, Accordion menu and map Components and exported to InfoView.
  • Developed Executive Level Reporting Dashboards using Business Objects Enterprise and Xcelsius with Live Data Connectivity and passed parameters to Web Services in Xcelsius to generate Critical Business Flow Reports.
  • Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.
  • Responsible for the performance tuning of SQL queries on Oracle database by using features like creating the materialized views and function based indexes depending on the reporting requirements.

ENVIRONMENT: SAP BW 3.5, Business Objects XI R3, Crystal Reports, Xcelcius, Live Office, Oracle 9i, SQL Server 2005, and PL/SQL.

Confidenital, Easton, PA (Feb 06 Aug 07)
Role: SAP Business Objects (BOBJ) Consultant

Responsibilities:

  • Worked on gathering requirements from end users in one-to-one meetings. Involved in the prototyping, effort estimate, User Acceptance Testing (UAT) and user support phases of project development.
  • Worked extensively on modules CMC, Designer, Web Intelligence, Desktop Intelligence, Crystal, Crystal Xcelsius, Auditor, Infoview, Import Wizard and Report Conversion Tool.
  • Developed Reports with Parameters, Sub-Reports, Cross-tabs and Charts based on Stored Procedures and Queries by using Crystal Reports.
  • Developed Deski & Webi reports by using advanced functionalities like Optional prompts, Data tracking, merge function, CustomSQL at Report level and report level contexts and Created users, user groups and managed access privileges using Business Objects Supervisor.
  • Resolved loops and traps using aliases and contexts. Created complex joins like outer joins and equi join & theta joins and checked the integrity of Universes.
  • Created Complex Reports by using multiple data providers to combine 3 reports as a single Report in Deski, Webi and Crystal.
  • Implemented Single Sign on (SSO) functionality on windows AD using LDAP (Light Directory Access Protocol) and Created Dashboards using metrics and Analytics.
  • Involved in performance tuning of Business Objects Full Client and Webi reports.
  • Converted Desktop Intelligence reports to Web Intelligence Reports, using Report Conversion Tool and run them successfully upon refreshing.
  • Plan and write test cases based on the requirements or defects corrections, supervise their execution by the testing team, perform complex and sensitive tests.
  • Exported the universes to the Repository for making resources available to the users.

ENVIRONMENT: Business Objects XI R2, Universe Design, Web Intelligence, Crystal Reports, Windows2003/XP.

Confidenital, (Oct 04 Jan 06)
Role: Business Objects (BOBJ) Developer

Responsibilities:

  • Creating reports using Business Objects.
  • Analyzed and explored the reports using Slice and Dice and Drill Down.
  • Created various reports using Freehand SQL and Stored Procedure as data providers.
  • Created complex reports using multiple queries and involved in tuning the reports in order to increase the accessing speed.
  • Used breaks on reports to get desired results after converting the documents.
  • Modify the format and structures according to the end-user requirements.
  • Used the Powerful business objects functionality\'s like @functions, Variables, user response and formulae.
  • Published existing reports to corporate intranet through Web Intelligence.
  • Involved in creation of Reports, Formatting reports, generation of charts, as per user requirements.
  • Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
  • Trained the users about all the functionalities and analysis of the reports for their applications.
  • Interacted with the users to analyze the changes for improvement they need in existing reports and developed the reports to satisfy their needs and requirements.

ENVIRONMENT: Business Objects 6.5/XI R2 (Designer, Supervisor, CMC, Webi, BCA Scheduler) Crystal Reports 9.0, SQL Server, Oracle 8i, PL/SQL, UNIX.

Hire Now