SUMMARY:

• Over 7.5 years of experience in teh IT industry with data analysis, design and implementation of Business Objects Reporting Solutions.
• Strong Experience in building Reports retrieving data using Universes, Personal data files, Free hand SQL methods and creating complex reports, ad - hoc Reports using teh Desktop Intelligence and Web Intelligence tools.
• Proven ability to TEMPeffectively handle multi-task levels of project management responsibility with minimal direction from superiors while supervising personnel, providing team leadership, motivation, and development.
• Well versed in Business Objects (XI R3.1, R2 and 5.1) with experience in CMC, CCM, Infoview, Desktop Intelligence, Import Wizard, Supervisor, Designer, Reporter, Web Intelligence, Dashboards, and Scorecard.
• Experienced in Data Extraction, Transformation and Loading (ETL )process
• Expertise in migrating from version XI R2 to XIR3, Business Objects Universes, Users, Report Objects, Personal Data Files.
• Experienced in implementing reporting applications using Crystal Reports, Crystal Enterprise, Xcelsius, Business Objects Enterprise, SAP Business Explorer, Oracle SQL and PL/SQL.
• Experienced in publishing reports, maintaining users using Crystal Enterprise/Business Objects Enterprise.
• Experienced in accessing Enterprise Resource Planning (ERP) data for reporting purpose.
• Excellent SQL, PL/SQL coding, Triggers, Stores procedures, Views development skills.
• Experienced in hyper linking teh objects from crystal reports and webi reports in Business Objects Enterprise.
• Experienced in performance tuning of WEBI reports and involved in crystal reports debugging.
• Experienced using Xcelsius Dashboards, which are used in determining teh performance and progress of teh business.
• Strong RDBMS concepts and working experience using database Tables, Views, Stored Procedures, Functions, and Packages using SQL and PL/SQL.
• Good noledge of Dimensional modeling (Star Schema and Snow-Flake schema Design) techniques of data warehouses.
• Experience using Data Services Designer to build dataflows and configure transforms such as Query and Validation.
• Trained in Business Object 4.0 and have been trained on all teh latest SAP BO releases.
• Experienced in documenting Functional & Technical Specifications as required by SDLC.
• Experience with Central Configuration Management (CCM), change control and source control systems.
• Capable of working as an individual and also as a part of team.
• Quick learner, possess excellent analytical and technical skills, excellent team player.
• Ability to adapt to new technologies very quickly.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, SQL Plus.

Operating System: Windows XP/ Enterprise Server 2003 and 2008/NT, UNIX.

Database: SQL Server 2008, 2005, Oracle 10g/9i, IBM DB2/Sybase, MS Access.

Tools: Business Objects XI 3.1, R2, 6.5, 5.1; Web Intelligence (WEBI); Desktop Intelligence (5.1 Business Objects), Crystal Reports XI and 2008, Xcelsius 2008 and Visio.

Packages: OLTP; OLAP, ODBC/API, ADO, DAO, OLE DB, XML, SSRS, SSIS CSS, CCM, CMS, CMC, ECC, SDK, Ajax; Forecasting, Trend Analysis, Full Life-Cycle Development,Star and SnowflakeSchemas,ExecutiveDashboards,OracleSQLDeveloper 1.5.1, SQL plus, SQL Loader,Microsoft Visual Source Safe, MS Office, Server studio, Data Integrator 11.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Lead Business Object Developer

Responsibilities:

• Involved in requirement gathering with teh business users and designing teh reports using DESKI/WEBI Reports.
• Responsible for analysis of teh systems, meeting with end users and business units in order to define teh requirements.
• Designed and developed Business objects reports using Designer and Reporter XIR2 Version.
• Developed Stored Procedures in Oracle.
• SQL tuning of reports to increase performance.
• Implemented Sub Reports & dynamic cascading prompts for parameter passage.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Handled adhoc reports and formatted to teh users according to teh user requirements using like Slice & Dice, Drill down etc.
• Created Master Detail and Cross Tab reports to view teh data in an analyzed way.
• Resolved teh production tickets within specified time lines.
• Resolved teh testing issues related to teh Dimensions, Contexts and Joins in teh Universe.
• Migration of reports between Development, Test & Production Environments in XI R2.
• Implemented import wizard & publishing wizard for migration of reports & universes.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Used teh formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.

Environment: Business Objects XI R2, Web-Intelligence, Infoview, Xcelsius 4.5, Desktop Intelligence, CMC, Designer, Toad, Oracle10g, SQL, PL/SQL, DB2/Sybase, Windows 2000 and Windows XP, Informatica ETL.

Confidential, Frisco, TX

Lead Business Object Developer

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications for business object universes and reports.
• Designed and developed teh Functional Analysis and Technical Design like Joins, Shortcut Joins, Contexts, and Cardinalities of teh tables and structures of teh Universe.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing teh Universes, applying contexts and alias tables to remove cyclic dependencies.
• Importing and Exporting teh Universes to repository to make it accessible to end users.
• Extensively used QAAWS to retrieve teh SAP BI data from teh universe objects.
• Interacted with teh Business Analysts to gather teh requirements and developed prototypes in teh form of PDF’s or Power Point Slides of teh Dashboards for teh initial presentation to teh users.
• Developed WEBI reports in Business Objects XI R3.1 and Xcelsius Dashboards in Xcelsius 2008.
• Developed multiple dashboards so dat teh user can navigate from one dashboard to teh other.
• Expertise in developing drill down reports and hyperlinked reports.
• Created simple and complex reports including dynamic calculations involving Contexts, Queries, Hierarchies, List of Values (LOVS), local variables, Alerts, Ranking and multiple data.
• Created teh reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Organized data in teh report Inserting Filters, Sorting, Ranking and highlighting data.
• Created reports in table, cross table, 2-D, 3-D Column, Line, Area and Pie charts.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Resolved teh production tickets within specified time lines.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in teh development of teh Dashboards.
• Setting up teh security levels to teh users in universe module like row level and object level security.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Used teh formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors.

Environment: Windows Enterprise Server 2008 Apache Tomcat, SQL, PL/SQL, BOXIR3.1 SP3, Crystal Reports 2008, Oracle 10g, TOAD, DB2/Sybase. Designer XI, Web Intelligence XI, Info View, Designer, CMC, CMS, Xcelsius 2008, OLAP, BO Live office, SAP Business Objects suite.

Confidential, Mount Laurel, NJ

Sr. Business Object Developer

Responsibilities:

• Gatheird Business Requirements from teh end users and clients.
• Involved in designing Universe and migrating existing Deski Reports to Webi.
• Prepared project Documentation based on requirements such as BRD.
• Passed parameters from Summary report to Detail report via OpenDoc syntax.
• Created Prompts filters in teh Universe using complex SQL to filter specific data based upon on user input.
• Created Crystal Reports used in key Factoring Reports.
• Resolving loops in universes using Aliases and Contexts.
• Efficiently designed multiple analytical WEBI reports utilizing key WEBI features including but not limited to Drill Down, Alerts, Input Control and Open Doc.
• Developed Hierarchies to support drill down reports.
• Created teh reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Created Daily weekly monthly, annual and forecasting Reports for fiscal and calendar years.
• As an iterative process updated teh modifications suggested by teh Client.
• Accessed corporate data Using Live Office and Query as Web Service (QaaWS) used them extensively to create visually rich Xcelsius dashboards.
• Developed complex interactive/dynamic dashboards with Xcelsius and implemented prompts, drill down capability and Applied alerts.
• Resolved teh testing issues related to teh Dimensions, Contexts and Joins in teh Universe.
• Fine-tuned teh universe objects in order to improvise teh Query Performance.
• Extensively worked on creating contexts for teh Universe based upon teh Business Flow.
• Updated teh Joins and applied shortcut joins where ever necessary.
• Created filters to drag in teh reports as per user requirement.
• Created teh measure objects as per teh reports requirement.
• Responsible for supporting issues with reports.

Environment: Windows Enterprise Server 2003 Apache Tomcat, BOXI XI 3.1, Oracle 10g and TOAD. DB2/Sybase, Designer, Desktop Intelligence, Web Intelligence, CMC & Info View, Crystal Reports, Xcelsius, SQL, PL/SQL.

Confidential, Rockville, MD

Business Object Developer

Responsibilities:

• Excellent use of graphs and charts with named groups and formula fields.
• Involved in upgrading from Business Object 6.5 to XI R2.
• Analyzed Business Objects old Universes and Reports. Designed and developed new Universe and Reports as per teh requirements.
• Designed and developed Business objects reports using Designer and Reporter XI R2 Version.
• Responsible for analysis of teh systems, meeting with end users and business units in order to define teh requirements.
• Created various dashboard reports to measure teh performance.
• Responsibilities included imparting training to teh end-users and doing teh noledge transfer for reporting needs.
• Developed interactive/dynamic dashboards with Xcelsius and implemented prompts, drill down capability and Applied alerts
• Involved in creating chats & graphs using Xcelsius based on teh user requirements.
• Created Crystal reports using teh Universes as teh main Data Providers.
• Good Business analysis and Application development lifecycle experience.
• SQL tuning of reports to increase performance.
• Solid experience in creating application schema as tables, view and indexes.
• Experience in writing scripts to drop teh index before and recreating indexes after teh data load to increase teh performance.
• Created various reports related to Insurance products and Customer preferences using complex SQL queries.
• Generated various numbers of reports on a daily, weekly and monthly basis using Business Objects Report module.
• Created Dashboard reports in Xcelsius to measure teh performance.

Environment: Business Objects XI R2, Web-Intelligence, Xcelsius 4.5, Desktop Intelligence, Actuate, CMC, Designer, Toad, Oracle10g, SQL, PL/SQL, DB2/Sybase, Windows 2000 and Windows XP, Crystal Reports 10, Informatica.

Confidential, Huntington Beach, CA

Business Objects Developer/Analyst.

Responsibilities:

• Interacted with customer support regularly, in order to generate teh reports required and to resolve teh existing issues.
• Created Universes by defining connections and retrieving data from database.
• Used Built-in and External strategies for creating components of a universe.
• Created Aliases and Contexts for solving teh Join Problems in Business Objects.
• Created New Classes and User Objects in designing teh universes.
• Exported teh universes to teh Repository to make resources available to teh users.
• Generated various trending reports on Daily, Weekly, Monthly and Yearly basis for each Type of Loans and Accounts.
• Created and modified teh WEBi Reports for various financial groups using teh Universe as a main data provider.
• Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs. Some of these reports are extremely complicated and retrieve data from multiple data sources
• Created Charts to display summary data using universe as main data provider.
• Extensively used Calculations, Variables, Drill Down and Slice and Dice for creating Business Objects reports.
• Planned, coordinated and executed Business Objects Deployment for end-users.
• Published reports using Info View, and training users for ad-hoc reporting.
• Examined and transformed teh business logic behind teh existing Crystal Reports into Business Objects environment.

Environment: Business Objects 6.5/XI (Supervisor, Designer, Reporter, Broadcast Agent, Web Intelligence and Info View), MS Access, Oracle 9i, DB2/Sybase, SQL, PL/SQL and Windows 2000.

Confidential, Wheeling, IL

Business Object Developer

Responsibilities:

• Worked with Functional Managers / BA’s / End Users to gather reporting requirements to implement business logic for successfully implementation of reporting system to satisfy teh needs of Business Units and Supplier Partners.
• Extensively worked on Administration of Business Objects 6.5/XI R2 Environments (Supervisor and CMC)
• Worked on Business Objects Desk I and Web I Reports of BO 6.5 and BO XIR2 Environments.
• Worked on User Management, Server Management and Content Management of BOXI.
• Migrated teh Users, Groups, Universes, Personal Folders, Connections, Reports (DeskI & WebI), Excel, PDF and Instances to Production, Development and Test Environments using Import Wizard from BO 6.5 to BOXI R2.
• Converted teh DeskI Reports to WebI Reports using Report Conversion tool.
• Customized teh BOXIR2 Infoview by modifying teh JSP pages, XML files and Jar files for daily updates, replace teh BOXIR2 Logo and banner using Java SDK and API.
• Applied teh hyperlinks to Info view home page using customizing teh Java SDK.
• Added users, user groups and managed teh access privileges of teh user community using teh CMC module of Business Objects XIR2 and Business Objects 6.5.
• Enhanced teh Exiting Universe to speed up teh performance.
• Designed Crystal Reports with formulas, Grouping, Parameters, Selection criteria to handle teh report request.
• Worked on Crystal reports with using features like Cross-tab, Conditional, Top and Drill-down.
• Worked on Implementing teh Lovs, Hierarchy’s, Pre-Defined Conditions, Resolving Data Base Connections, Adding new objects to teh Universes.
• Worked on Developing Confidential & Multi-Dimensional Web I Reports using features like Drills, filters, Sort, Rank, Sections, Breaks, Alerts, merge Dimensions, sub quires and Multiple Data Providers.
• Experience in working and managing in Different Environments simultaneously.
• Worked on creating Derived Tables, Aggregated Tables using Aggregate Awareness concept, creating Indexes, views to increase teh performance of teh universe.
• Extensively worked on Audit Reports and Activity Universe tuned up teh performance issues.

Environment: Oracle 9i, PL/SQL, Business Objects 6.x, Crystal Reports 8.5, BO Supervisor 6.0, Web intelligence 6.0, Broadcast Agent, Windows 2000.