Sap Resume
Malvern, PA
Summary:
- Over 7 years of experience in Implementation of Business Applications and Client/Server applications Business Objects.
- Installation and Configuration of Business Objects (4.0/R3/R2/R1)
- Evaluated SAP BOBJ 4.0 enterprise.
- Business Objects configuration with various web servers including Web logic, Web sphere and Tomcat.
- Experience in Migrating Business Objects from BOBJ R2 to BOBJ 3.1 and BOBJ R3.1 to BOBJ 4.0 on a huge environment.
- LCM implementation.
- Designed Business Objects security model for a huge environment.
- Implemented both Single Pass Method and Incremental Method for Migrations.
- Developed various Business Objects format reports including Webi, Crystal and Deski
- Experienced in developing Universes from different databases including Oracle, SQL server, DB2, Informix.
- Expertise in designing Universes for Xcelsius Dashboards and Performance Management Dashboards
- Qaaws, XML, Live Office have been used to refresh Xcelsius dashboards
- Experienced in developing Desktop Intelligence, Web Intelligence and Crystal Reports using different Data Sources.
- Experienced in developing Dashboards and Scorecard using Dashboard manager to effectively represent KPI’s and visually accentuate critical business controls.
- Configuration of CMS Ports and various server configuration using CMC
- Created different users/groups/folders and assigned the rights using CMC
- Defined Back-up and recovery methods for Business Objects
- Post-Production Support for 24/7 system
- Server Intelligent Agent (SIA), Central Configuration Manager, Central Management Console, Business Objects Enterprise, BO Performance Management, Auditor, Crystal Reports, Crystal Xcelsius, Query as a Web Service (Qaaws), Voyager, Live Office, Dashboard Manager.
- Experienced in Designing/Developing BO Universes, Canned/Ad-hoc Reports, Scheduling the BO processes using Broadcast Agent Server, Document Agent Server, bursting/broadcasting the reports using Broadcast Agent Scheduler and Broadcast Agent Publisher.
Technical Summary
OLAP/DSS ToolsBusiness Objects XI 3.1(R3.1)/R2/R1/6.x/5.x/5i/4.x, SDK, Crystal Reports XI, SIA, Central Management Console, Central Configuration Manager, Designer, Desktop Intelligence, Web intelligence, Webi Rich client, Translation Manager, Crystal Xcelsius 2008/4.5, Query As A Web Service (Qaaws), Performance Manager, Deployment Tool , Dashboard manager, Scorecards, Tomcat 4.0.6,Oracle Warehouse Builder, Apache 1.3.x, Business Objects JAVA SDK, CMC, CMS,
RDBMS
Oracle 10G/9.x/8.x/7.x/5.x, DB2/400, SQL Server 2000/2005, MS Access 2000
Languages
C, ASP, VB Script, HTML,JAVA,JSP, PL/SQL, SQL, Shell Scripting
GUI
Oracle Developer 2000, Visual Basic 5.0/6.0,Power Builder
Utility Tools
Erwin, TOAD, SQL* Navigator, Developer 2000, SQL*Loader
Operating
System
MS-DOS, Windows 2003/XP/NT/2000/98/95, Unix, HP- Unix, Sun Solaris
Web Technologies
VBScript, HTML 3.2/4.0, IIS 4.0/5.0
Education: Bachelor’s in computer science
Professional SummaryConfidential, Malvern PA Nov11 Present
SAP BI/BW Consultant
- Involved in the analysis and developed few wireframes for the customer.
- Involved in the Data layout sessions for database and the dashboards.
- Designed the entire dashboard with static data and had the interactions work for detail view.
- Used Dashboard Designer 4.0 (Xcelsius) to developed the dashboards and made the dashboards go live with the Dynamic/Live data using a new connection Query Browser.
- Using Query Browser designed the queries that hit the database through a universe(.UNX).
- Involved in developing aggregated universe(.UNX) using the Information Design Tool(IDT) which is a new tool out of the box in BOXI 4.0/BI 4.0.
- Developed/Designed the dashboard to be more dynamic by keeping the data limitations in mind and Dynamic Visibility.
- Explored the new BI Launchpad, which replaced Infoview in BOXI 3.1.
- Deployed the dashboards into the launchpad.
- Designed the opendoc links in the dashboard to view the related WEBI reports for selected parameters with in the dashboard.
- Installed the Add-on components for the dashboard development.
- Involved in migrating the universe(UNV) to (.UNX) using the new Information design tool-IDT in BI 4.0.
- Created cascading list of values in the business layer using IDT.
- Created Data foundation and Business layer also published IDT universe using secured connection.
- Modified the connections in the Data foundation layer.
- Worked on the same universe along with the developer’s team using shared project in IDT.
- worked on SAP issues like LOV’s, ISNULL and NOT NULL functions that works in BO 3.1 but not in BO 4.0/SP2.
- Performed formal testing, unit testing, component level testing and performance testing throughout the development process
- Developed few standard scenarios and best practices for the user to develop a new dashboard or customize the existing dashboard.
Environment: Business Objects XI 4.0/BI 4.0, LDAP, Crystal Xcelsius/ Dashboard Designer , SQL Server 2008, Windows 2003, Windows XP, Query Browser.
Confidential, Richmond VA Dec10 Sep11
Business Objects Consultant
- Evaluated SAP BOBJ 4.0 enterprise for enhanced futures Solaris
- Migrating BOBJ content(users, universes, reports, userfolders, repo objects)
- Running ImportWizrd from command level using script to generate incremental loads.
- Resolved all the migration issues.
- Interacted with Users to know their Business views while gathering the Report requirements and provided Several Report Mock-ups to finalize the requirements.
- Converted business requirements in business/technical requirement documents.
- Integrated Business Objects Reports and Dashboards to Third Party Portal using OpenDoc functionality.
- Implemented Row Level, Object Level security for data restriction at Universe level.
- Developed Webi, Deski , Crystal , Webi Rich Client and Xcelsius Dashboards
- Developed BOBJ 3.1 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls and Merge Experienced in developing complex reports using Business Objects Webi Rich Client & Crystal Reports Enterprise having Parameter/Formula Fields and Selection Formulas, Grouping and Sub reports.
- Tuned and Enhanced Universes with SQL Queries for the Report Performance.
- Created Web Intelligence Ad-hoc and canned reports.
- Deployed Business Objects Universes and Reports in a Secure Environment from One Dimensions
- Created Xcelsius Dashboards for Sales and Product level data based on Product Age & Usage using various components of Xcelsius.
- Created WSDLs using QaaWS (Query as Web Services) and implemented into Xcelsius dashboards.
- SAP BW integration (installation and configuration)
- Open Document functionality from Dashboard to Webi Report.
- Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
- Written SQL queries have been used on the Universe and created as Derived Tables.
- Wrote Complex SQL Queries for Data validation purpose.
- Tuned and Enhanced Universes with SQL Queries for the Report Performance.
- Created Views, Stored Procedures and validated data for the Performance.
- Created Web intelligence reports in Advanced and Interactive mode using all the functionalities
- Developed Business Views on top of universes
- Created complex reports in Deski, using multiple Data providers.
- Converted Deski Reports to Webi using Report conversion tool for enhancements
- Created Derived Tables in Universe to meet specific requirements for Webi Reports and Dashboards.
- Used Open Doc functionality to drill down from Xcelsius dashboard to Webi Reports.
Environment: Business Objects XI R2, 3.1, LDAP, Crystal Xcelsius , Oracle 10g, SQL Server 2000 & 2005, Web logic 10 and Windows 2003, SAP 4.7, Oracle 9i, Windows XP.
Confidential,TX Jul 08 Nov 10
Business Objects Administrator / Developer
- Installed & Configured Business Objects XI 3.1 Enterprise
- Worked in BOBJ Migration from X1R2 to XI 3.1
- Configuration of Business Objects with third party Web Servers
- Worked in BO Administration using CMC to manage/setup securities for all Business Objects documents (Users/Groups/Folders/Universes/Reports and more)
- Expertise in Business Objects Production Environments Maintenance in UNIX and Windows Platform.
- Maintained different Business Objects on different platforms and different networks
- Deployed the Universe, report content over one environment to other using Import Wizard / BIAR method Involved in Production Support role 24/7 to resolve the Issues.
Created and Modify the Existing Shell scripts accordingly. - Managed CMS (Central Management Server) from Server Intelligence Agent
- Developed different types Web Intelligence Reports in different Template formats (Chats, Cross tabs etc) and maintained CMS server and WebI report server.
- Developed reports for region wise and exported them to PDF/Excel format.
- Developed and maintained Graphical Dashboards in Xcelsius 2008 to integrate ODE Portal
- Created different categories and implemented securities for region wise and granted access
- Worked in QAAWS for Dashboard Implementation. Developed Dashboards foreach regionusing Business Objects Universe
- Scheduled on Daily basis /Distributed all to Regions
- Access granted permissions to concern region folks throw CMC
- Worked in BO Migration between Dev, Test and Production
- Developed SQL programs on SQL Assistant to perform Unit test on WebI Reports.
- Manipulated data through various presentation styles such as charts, cross tabs, slice and dice, alerts, prompts, nested loops, and filters. Implemented Cascading prompts in Universe for filtration in filters.
- Created derived tables for Universe design to meet specific results in Web Intelligence.
- Implemented Web Intelligence Reporting on Universes; Developed ad-hoc/Complex reports
- Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods.
- Creates Cascading prompts in Global report for User selection.
- Scheduled all region reports daily and saving them into Objects package.
Environment:Business Objects XI 3.1/R2, Web Intelligence, Crystal-Xcelsius 2008, Teradata V2R6.1, SQL Server 2005, PL/SQL, ER-Studio7.5, MS word, Ms Excel, Windows XP/2000.
Confidential,Marysville, OH Oct 06 Jun 08
Sr Business Objects Consultant
- Implemented Cordiality settings, Joins, Conditions and Global Filters in Universe.
- Worked in Aliases and Contexts to resolve looping problems and used Derived tables methods.
- Technical expertise in Analyzing, Design, Implementation and administration of security models with row level data security, role based security etc in Business Objects Universes and Central Management Console (CMC)
- Used Breaks and Sections in Webi reports and used different graphical charts and bars.
- Scheduled Webi reports on daily basis and exported them in Excel/PDF format.
- Implemented SQL/PLSQL programs/Stored procedures/Views to test ad hoc reports
- Created Dashboard Templates with Visualization for different group’s usage for their Best Practices.
- Designed Visualizations for Operational and Financial groups.
- Created WSDLs using query as web services and implemented WSDLs into Xcelsius dashboards
- Created WSDLs using Query As a Web Service (Qaaws) from different Data sources.
- Integrated Dashboards into External Portal Applications using Qaaws.
- Created customized Web Intelligence reports as a source data for Live Office to Integrate Xcelsius on Corporate dashboards.
- Deployed Qaaws from One server to other server.
- Using Flash variables passed the parameters from Parent Dashboard to Child Dashboard.
- Created Hyperlinks on Dashboard to drill down for Detailed Analysis Reports.
- Converted Deski Reports to Web Intelligence using Report Conversion Tool.
- Created hundreds of reports in Webi and Deski using all the functionalities
- Designed Universes using different data sources.
- Created Classes and Objects for management system based on the warehouse schema in Universe.
- Designed aggregated tables on the most frequently queried data for Monthly & Yearly based reports.
- Created hierarchies for drilldown paths.
- Supported universe maintenance.
- Involved in dashboard design and supported dashboards universe.
- Involved in creating Query as web services query’s for dashboard.
- Implemented row level security using manages security in Designer.
- Created and maintained standard reports.
- Helped users for creating adhoc queries.
Environment: Windows, Business Objects XIR2/3, CMC/CMS, Designer, Web Intelligence XIR2/3, Info view, HTML, JSP, SQL Server 2005,XCelsius, Query as web service.
Confidential,MD Oct 05 Sep 06
Responsibilities:
- Involved in development and maintenance support for the Net system
- Created universe using Designer and enhanced existing sales, Market universes as required and Participated in the analysis and design of the Net system.
- Extensively Used Designer as a part of Universe development, created Classes, different kind of objects, cardinalities, Strategies. Resolved the loops using contexts. Check the Integrity of the Universes. Export the Universes to Repository for making available to users.
- Involved in troubleshooting report issues, including poor performance and bad data.
Controlled implementation of changes to the Net Universe required for reporting. - Converted existing Sales, Marketing, and GPO reports to Net reports.
- Automation of periodic reports in Net model design and implement dynamic calendar table with data load algorithm
- Manage periodic reports bursting to corporate user groups including sales force
- Involved in bursting weekly and monthly reports using BCA server
- Created Adhoc Reports using User modules (Webi, Reporter) in Business Objects. Created different types of simple and complex reports like Master/Detail, Cross Tab, used Slice and Dice and Drill down. And also used Union, Formula’s, and contexts .And created reports using multiple universes.
- Extensively used Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
- Involved in training end users on Net reports.
Environment: Windows 2000, Business Objects 6.X, Broadcast Agent, Business Objects Auditor, Web Admin tool, Application Foundation, Supervisor, Designer, Web Intelligence6.1/Infoview, Oracle 9i/8i, SQL Navigator 4.x, SQL*Net 8, Oracle warehouse Builder,PL/SQL,VB6.0, Erwin, SQL Scripting, Unix Scripting .