SUMMARY

• I am an IT professional with over 8 years of experience in various industries including Financial, Pharmaceutical, Services and retail industry
• I have worked extensively on Business Objects Designer, Info View and Web Intelligence. I am well versed in Business Objects (6.X and XIR2, XIR3,3.1, and 4.0) with experience in Supervisor, Designer, Information design tool, Reporter, BCA (Publisher and Scheduler), Web Intelligence, Info View, Dashboards, Auditor and Schema Design. I have an in-depth knowledge in creation of WEBI reports and Dashboards using Crystal Xcelsius. My expertise includes Business Objects Universes, personal data files, stored procedures and free hand SQL methods.
• I have worked in all aspects of creating Universes with measures and dimensions objects, Join conditions, Filters, LOV, cardinality, Aliases, Contexts, Aggregate Awareness using Business Objects Designer.
• Ability to transform powerful complex data into a comprehensive dashboard using Crystal Xcelsius.
• Extensive knowledge in all phases of Software Development Life Cycle (SDLC) with different methodology such as Waterfall.Strong Experience in interviewing End- Users, Stakeholder, Business Owners and Subject Matter Expertise.
• Excellent skills in developing Dataflow Diagram and UML diagrams such as Use Case diagram, Activity diagrams, Class diagrams and Sequence diagrams

TECHNICAL SKILLS

Operating Systems

Windows 95/98/NT/2000/XP

RDBMS

Oracle 10.2g,9i/8.i, MS SQL Server 2000,2005, MS Access, IBM DB2

Languages

SQL, PL/SQL, XML, HTML

Application Server’s

Web logic, OAS, Oracle 9IAS, Apache Tomcat, Websphere

OLAP and Reporting

Business Objects 6.x5, XI R2, XI R3.0, 4.0, Supervisor, CMC, Designer, Information Design Tool, Business Object Desktop Intelligence, Web Intelligence, Crystal Reports 2008, XI/9.0) , Xcelsius 2008, Dashboard 4.0.

Other Tools

Toad, MS Visio, SQL +plus

ETL Tool

Informatica 8.6.0

EXPERIENCE 

Confidential, Kenilworth, NJ May 2010 –Present
Sr. Business Objects Developer,

Responsibilities

• Designed several Universes using Designer according to the requirements
• Created Classes, Dimension objects, Measure objects and Detail objects in the universe
• Resolved issues related to RDBMS flaws such as Fan Traps, Chasm Traps using BO multi parse SQL functionality
• Enable up-to-the-minute information for dashboard with live data using various connections
• Create and modify reports using SAP Business Objects Web Intelligence and Desktop Intelligence.
• Created repository and security domain with user groups and security implementation.
• Prepared different report layouts and blocks like Tables, Cross Tabs and Charts
• Used different functionalities like Breaks, Filter, Sorts, and Ranking to generate reports.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc.
• Used aggregate awareness in universes. Involved in full life cycle of Business Objects reporting Application.
• Updated and maintained Universes based on changing user requirements and data source changes
• Checked Universes for Integrity and exported them to the Repository to make resources available to the users and groups.
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators
• Interactive visualizations were made for executives to visually evaluate different scenarios by adjusting key variables.
• Conducting UAT (User Acceptance Test) and working with QA and QC Teams positive and negative, functionality, object, and regression
• Create documentation including data flow diagrams, batch and online system process flows
• Created work flows and data flows for different batch jobs created using data integrator
• wrote scripts for various procedures with in the batch jobs
• Populated Different Dimensions Using Various Transforms
• Using Data Integrator Loaded data to Destination Tables from Various Types of Data sources, such as Flat Files, Data Base Tables or XML Data Sources.
• Used various techniques such as interactive debugger to examine and modify data row by row for various transform with in a flow

Confidential. Rockford, IL Jan 2009 - Mar 2010
Business Objects Developer

• Gathering Requirements, Drafting specifications, Design, Development, User Acceptance Testing and Production Roll Over.
• Experienced in creating Business Objects universes. Installing and configuring Business Objects, Web Intelligence and other Components of Business Objects.
• Developed Reports with parameters, Sub-Reports, cross-tabs and charts based on Stored Procedures and Queries by using Crystal Reports.
• Generated reports by using Stored procedures and generated Parameterized, Drill down reports
• Create stunning presentations with exciting visual components using Crystal Xcelsius
• Developed Xcelsius presentations/visualizations for profitability Analysis, Distributor Sales Analysis, Monthly Sales Analysis, Forecasted Sales What if Analysis
• Created report templates, developed Ad-hoc reports, complex reports (e.g. reports from multiple data sources, drill down capabilities by using Crystal Reports).
• Scheduled and Distributed reports to different users by using CMC, Info View and Publisher
• Experienced in creating Star Schema for Multi-Dimensional modeling within an enterprise wide Data Warehousing effort.
• 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.
• Created new Business Objects users and User Groups using Business Objects CMC Module.
• Involved in designing and developing complex Web Intelligence, Client, and Ad Hoc reports for corporate data, which was stored in the Oracle database.
• Build the Universes for end user report generation using Designer module
• Detected Joins and checked the Cardinalities
• Resolved Universe problems like Loops, chasm trap fan trap using Alias and context
• Developed and created classes with Dimension, Detail & Measure objects
• Developed Custom hierarchies to support drill down reports
• Created Derived tables in the Designer to enhance the capabilities and performance of the universe
• Implemented cascading prompts in universe
• Worked extensively with @functions (@select, @prompt, @where) to overcome the problems with database when integrating with business objects
• Generated List of Values (LOV’s) from lookup tables
• Check the integrity of the Universes, and export the universes to Repository for making available to users
• Implemented Data warehousing schemas like Star-Schema, Snow-Flake Schema.
• Created the reports using Business Objects functionalities like Combined Queries, Slice and Dice, Drill down, Cross tab, Master detail and Formulae
• Creating complex full client and Web intelligence reports using graphs, pie-charts and multiple data providers on daily, weekly, monthly and quarterly basis Reports using Business Objects XI R2.

Confidential , Chattanooga, TN Mar 2007 – April 2008
Business Objects Consultant

Responsibilities

• Migrated Business Objects 6.5 to XI R2.
• Used Web intelligence to create, edit and set different options for the corporate documents.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Interaction with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.
• Creation of 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
• Actively involved in gathering end user requirements, User/System Documentation, User training and testing developed reports for final deployment.
• Involved in the designing and Building of Universes, Classes and Objects for investment management system.
• Exported the Universes to the Repository to make resources available to the users.
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, parse the Universes, apply Contexts and Alias Tables to remove cyclic dependencies.
• Extensively used PL/SQL to implement cursors, triggers and packages.
• Exported the Universes to the Repository to make resources available to the users.
• Created reports for various Portfolios using the Universes as the main Data Providers.
• Interaction with end users, regularly in order to generate the reports required, these reports were generated using Business Objects functionality such as Slice and Dice, Master/detail, User Responses and Formulas.

Confidential Brooklyn, NY Aug 2004 – Feb 2007
Junior Business Objects Developer

Responsibilities

• Assisted end users with adhoc reports in DeskI
• Gathered report requirement and build various DeskI and WebI reports
• Used MS Visio for Dataflow Diagram, process model and architectural design of the application.
• Reviewed Test Plans and Test Cases for proper implementation and execution.
• Participate in integration testing by developing US specific test cases and actual testing of system design and interfaces
• Conducted GUI and User Acceptance Testing (UAT) to make sure the solution is what clients want.
• Converted several Crystal reports into WebI and DeskI reports
• Trained end users on how to use Business Objects Reporting tools
• Provide on-call and scheduled support, troubleshooting and maintenance on a weekly basis