We provide IT Staff Augmentation Services!

Business Objects Lead Consultant Resume

Arlington, VA

SUMMARY:

  • Over 11 years of experience in IT including over 8 years in Business Objects Bi 4.0 XI R3.1/R2/6.X, Business Objects Designer, Reporter, Supervisor/ CMC, Import Wizard, LCM, Info View, launch Pad, Web - Intelligence, Xcelsius, SAP Dashboard and Design, Crystal Reports.
  • Proven track record of successful implementation of Full Lifecycle (Requirements gathering through Implementation and enhancement) of Business Objects reporting.
  • Hands on experience in all the phases of Migration from SAP Business Objects XI 3.1 to BI 4.0.
  • Hands on Experience with BI 4.0 including Migration of Unive ses, Webi Rpeorts, Crystal Reports and Dashboards from XI 3.1 to 4.0.
  • Expertise in using LCM to move documents within the 4.0 and performed Administrator duties such as creating and managing User Profiles, Assigning Rights and security to user groups.
  • Expertise in Data Source Migration Wizard, Central Configuration Manager, Report Conversion Tool.
  • Experience in implementation of Business Objects management in Federal, Financial, Banking and Pharmaceutical sectors.
  • Expertise in Designing, Building and Maintaining the Universes, resolving the issues like loops and Traps using Alias and Context, designing complex objects using @prompt, @ Aggregate aware function & Cascaded List of Values & Prompts.
  • Experience in creating Universe by using views created over different data providers SQL Server, Oracle, DB2, MS Access.
  • Extensive experience in building and managing Universes, creating Complex, Ad-hoc Reports and/ or Charts using SAP Business Objects BI 4.0.
  • Developed complex reports in WEBi and DESKi using date functions, Calculations, formulas & Filters and link reports and perform drilling using Open Doc function in InfoView. Performed Slicing/Dicing, Multi Tabbing, Cross Tabbing, Drilling, and Scheduling and created Master Detail Reports
  • Involved in designing Universe and creating reports on XIR2/R3.0/R3.1/BI4.0
  • Expertise in using various data providers like Universes, Personal Data Files, Stored Procedures and Freehand SQL to generate reports.
  • Proficiency in Scheduling, Publishing and Distribution of Business Objects reports using Broadcast Agent server and experience in creating Repositories, Folders, Groups, Users, assigning privileges to users and maintaining the Repository.
  • Demonstrated understanding of Dimensional Modeling (Star Schema and Snow Flake) and other Data Warehousing Concepts.
  • Highly experienced in Handling Live Office, QAAWS, using Xcelsius, SAP Dashboard & Design and Webi Integration..
  • 5+ Years of experience of Production support in various client Environments and experience in Life Cycle Manager Tool and Import wizard Tool.
  • Diversified domain experience in Federal, Finance, Banking, Pharmaceuticals and Retail.
  • Able to work on own initiative or as part of a team, backed by excellent organizational and communication skills along with the capability to solve problems as they arise.

TECHNICAL SKILLS:

OLAP Tools: SAP Business Objects BI 4.0,XIR3/XIR2/6.5, Designer, Supervisor, Desktop Intelligence, Web-Intelligence, InfoView, LaunchPad, Broadcast Agent, CMC, Performance Management, Report Conversion tool Import Wizard, LCM, Crystal Reports 2008, Xcelsius 2008, SAP Dashboard and Design.

RDBMS: Oracle 11g/10g/9i/8.i, Informix, IBM DB2, MS SQL Server 2000, 2005, MS Access, PL/SQL, Lotus NotesApplication Servers: Apache Tomcat, Websphere, WeblogicOperation Systems: Windows Server 2003, Windows XP, Windows 7, Unix, Linux

Applications: MS Word, Excel, WordPerfect, Power Point, Access, Peachtree, QuickBooks, Quicken, ATB, CFS Payrolls, Profax System, MS outlook, Lotus Notes, MS Project Management, MINA, PCR, D&B. Ariba Buyer, Travel and expenditure, web inquiry, Remedy, PC anywhere, TBA system, Mainframe, HRO Workbench. Maestro. JAVA.

EXPERIENCE:

Confidential, Arlington, VA

Business Objects Lead Consultant

Responsibilities:

  • Involvement in all the phases of Migration from SAP Business Objects XI 3.1 to BI 4.0. Hands on Experience with BI 4.0.
  • Creation of Business requirement Specification, Functional Specifications and technical Specifications. As well as Design, Build, Test and Post Go live support.
  • Enabled successful completion of scope, delivery, quality, and acceptance of the team's technical design .
  • Experience with SAP BI 4.0 including Migration of Unive rses, Webi Reports, Crystal Reports and Dashboards from XI 3.1 to 4.0. Expertise in using LCM to move documents within the 4.0 and performed Administrator duties such as creating and managing User Profiles, Assigning Rights and security to user groups.
  • Developed universes, Webi Reports, District & ITD Performance Metric Dashboards using Business Objects Crystal Xcelsius 2008 and Sap Dashboard and Design.
  • Developed Universes by retrieving the data from various data sources, defining the connections necessary. Generating various numbers of reports on a daily, weekly and monthly basis.
  • Created Cardinalities, Contexts, Joins, External Strategies and Aliases for resolving Loops and checked the Integrity of the Universes. Exported the Universes to the Repository to make resources available to the users.
  • Created predefined conditions in the universe level to restrict the volume of data to be pulled in the report.
  • Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with Business Objects.
  • Participated in business process redesign, and work closely with the data owners, consultants, and Project Managers and Worked with technical teams around planning, design, development, testing, and deployment of the, Universes, Webi Reports and the dashboards,
  • Designed and implemented reports and dashboards with a variety of advanced visualization techniques to assist users in identifying critical data quickly and accurately according to specifications
  • Created universes, several Crystal reports, Webi Rich client reports and utilized Xcelsius 2008 and Dashboard Design tool for dashboard reports and graphical presentation.
  • Used QaaWs (Query as a Web Service) & live office connector to feed data into Xcelsius.
  • Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.

Confidential, Skillman, NJ

Business Objects Lead Developer

Responsibilities:

  • Involved in Full development life cycle of Universe design in SAP business Objects XIR 3.1.
  • Developed Universes and multiple reports using Universe designer and web intelligence in Business Objects XIR3.1.
  • Created several Crystal reports, Webi Rich client reports and utilized Xcelsius for dashboard reports and graphical presentation.
  • Worked side-by-side with client resources to Develop 2-4 pilot dashboards on existing (client installed) Xcelsius platform.
  • Designed the Universe by creating the Business Objects data model selecting and providing joins between the tables, Indicating cardinalities.
  • Created reports using Business Objects functionalities like Slice and Dice, Drill Down, Cross Tab, Alerter and Formulae etc
  • Scheduling daily, weekly and monthly reports using BO XI Scheduler using Events, creating Calendars
  • Formatted Reports as per the User requirements using extensively the functionalities in Business Objects, which allows the users to analyze the data.
  • Solving performance issues in reports using SQL queries and tuning of reports. Extensively used Calculations, Variables, Break points, and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
  • Created Reports using the Universe, Stored Procedures and Free Hand SQL as the Data providers.

Confidential, CT

Business Objects Senior Developer/Admin

Responsibilities:

  • Designed, Developed and implemented around 300 plus Ad hoc reports.
  • Fulfilled end user reporting requirements with Crystal Reports 2008.
  • Worked on new Complex Reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) development as well as production support for existing reports.
  • Developed complex Webi reports with report level context to control numbers according to user’s requirements.
  • Created Reports by using Desktop Intelligence from stored procedures.
  • Performed Administration tasks like setting up user profiles, assigning rights and privileges for groups, setting up categories using CMC, and maintenance of BO servers in XI R2.
  • Scheduled reports from CMC and monitored if critical reports ran successfully.
  • Aided project manager in managing programmers to develop and implement customer information system.
  • Helped develop detailed project plans for multiple simultaneous projects, resulting in increased visibility of inter-project dependencies and improved development efficiency.
  • Performed on call support to cater report level issue.
  • Wrote a full functional specification document for the security to be implemented in Business Objects
  • Resolved Loops using Aliases and Context, Addressed chasm trap and Fan Trap using Multi Parse SQL. Created Custom Hierarchies for several groups
  • Created complex Xcelsius dashboards to reflect User Adoption Metrics.
  • Used fact tables, dimension tables to design specific Universes and subsequently created Business Objects Reports and Crystal Xcelsius Dashboard.
  • Performed Live Office Connections From BOBJ Technologies to Dashboards through Xcelsius 2008

Confidential, Princeton, NJ

Business Objects Developer

Responsibilities:

  • Involved in Full project life cycle (requirement gathering to implementation phase)
  • Created Universes from scratch using Designer for various departments.
  • Responsible for designing and developing Universes for reporting purposes. Universes were created for post and pre - analysis of the marketing data through in-house Structure Business Objects methodology.
  • Familiar with Dimension modeling using Star Schema while creating Universes.
  • Created new Business Objects users and User Groups using Business Objects CMC.
  • Extensively used Designer to design various universes for different business groups, created classes, aliases, help text, simple reports and complex reports using cascading prompts.
  • Interacted with end users, regularly in order to generate the reports required. Various Business Object reporting functionalities were used such as Slice and Dice, Master/detail, User Response function and different Formulas.
  • Created several Webi & Deski Reports and Dashboards based on user requirements.
  • Created Slice and Dice, Drill down and Cross Tab reports to full fill requirements.
  • Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
  • Creation of different types of reports, such as: Standard reports, Cross Tab, Mail tab, use of Filters, Conditions, Calculations, etc.
  • Created Drill down Reports, On Demand Sub Reports, Sub Reports for the Business Needs.
  • Created linked and unlinked Sub Reports to create applicants experience/Qualifications reports. Troubleshoot Reports performance issues.
  • Involved in testing universes and reports for correct mapping of the objects and data correctness.
  • Wrote Crystal Syntax Formulas to calculate the Percentages and Summaries based on the group levels. Developed ad-hoc reports for end users.
  • Developed various Dashboards for What if Analysis, Interactive Dashboards, Decision Support and other purposes for the end users and managers.
  • Provided on call support when it’s required, to maintain BOE production environment to meet SLA expectations.

Confidential, Boston, MA

Business Objects Developer

Responsibilities:

  • Created repository using Supervisor, created users and groups, assigned rights to users and groups
  • Created Universes, Classes and Objects for management systems.
  • Resolving Loops using Aliases and Contexts and check Integrity of the Universe and exported them to the Repository to make resources available to the users and groups.
  • Updated and maintained Universes based on changing user requirements and data source changes.
  • Developed and Deployed complex reports. Used multiple data providers, Union, Intersection, minus and Master/Detail, cross tab, Charts.
  • Using report wizard generated reports in crystal reports
  • Worked with report formatting such as combined database fields using text objects as well as mapping old fields to new names using crystal reports
  • Created OLAP-only reports based solely on the cube in crystal reports
  • Linked sub reports to display related data elements from more than one database table
  • Using Business Objects created users and their profiles and applied securities to them
  • Created templates for standardizing the Structure of our Corporate Documents.
  • Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
  • Created Report level variables by using Used Variable Editor
  • Analyzed the reports using the Drill Through, Slice and Dice
  • Created reports on web using web intelligence, distributed the reports to different users.
  • Scheduled and monitored reports using Broad Cast Agent (BCA).
  • Worked on using the import wizard in moving reports and universes from Dev to UAT and to Production environments.

Confidential, Hackensack, NJ

Business Objects Developer

Responsibilities:

  • Involved in Full project life cycle (requirement gathering to implementation phase).
  • Worked very closely with upper management to get detailed information on what information they require in each report
  • Created/Modified Universes and linked with the existing Universes with Oracle backend and exported to repository.
  • Created Users and implemented security features.
  • Created Slice and Dice, Drill down and Cross Tab reports.
  • Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
  • Various ad hoc reports were created using User module in Business Objects according to the given requirements.
  • Extensively used Designer to design various universes for different business groups.
  • Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
  • Implemented row and object level security in business objects supervisor module.
  • Worked with Dimension modeling using Star Schema (ROLAP).
  • Managed the scheduling options stored in the repository and also involved in changing the document descriptions.
  • Created Business Objects reports, Queries with constant interaction with the end users.
  • Trained end users in understanding the reports.
  • Functionalities such as Slice and Dice, Drill mode and Ranking were used for Multidimensional Formatting.

Hire Now