Summary:

• Around 6 years of IT experience with strong background in various Business Intelligence tools likeBusiness Objects reports generation, publishing and migrate reports using Info View, Import Wizard, Web Intelligence (WEBI), and Desktop Intelligence (DESKI).
• Exposure toBusiness Objects XI Enterprise suite release 3usingDesktop Intelligence, CMC, Designer, Web Intelligence reporting. Experience in designing Universes, retrieving data using Universes, Personal data files, Stored procedures, Free hand SQL and creating complex ad-hoc Reports using Desktop Intelligence (Full Client), Web Intelligence and Crystal
• Worked with the whole spectrum of Software Development Life Cycle, including requirement gathering, system designing, data modeling, application development, enhancement, deployment, maintenance and support.
• Extensive experience in development of OLAP and OLTP technologies.
• Proficient in creating reports using Business Objects XIR3/XIR2/6.x functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Proficient in designing and building universes by selecting and joining tables, setting cardinalities and resolving loops by using aliases and contexts.
• Worked withOracle,Microsoft SQL Server,MicrosoftAccessdatabases, andExcelspreadsheet
• Created reports using the universes, personal data files and freehand SQL as the data providers.
• Used Infoview to view DESKI reports and to generate WEBI reports and Created Users Prompts, conditions and filters to improve the report generation
• Good experience in creating reports using Business Objects XIR3/XIR2/6.x functionalities such as Queries, Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts.
• Created cross-tab, drill-down, Charts and sub reports using Crystal Reports for all the reports that had performance issues in BO.
• Experience in defining Hierarchies based on Business logic and creating drill down reports.
• Good understanding instar schemamodeling and snowflakedimensional modeling.
• Worked on Xcelsius for presenting dashboards to End-users.
• Worked on Performance management to meet the requirements of higher level analysis.
• Knowledge on using Import Wizard to migrate reports and universes between different environments like development, testing and production.
• Knowledge inSQLand codingPL/SQL.
• Experience in Unit testing which includeddata validation using SQL scripts.
• Highlymotivated team player and aQuick Learnerwith good communication, strongproblem solving skillsand excellent in presentation and interpersonal skills. Extremely well organized, meticulous and highly self-motivated.

EDUCATIONAL QUALIFICATION:

Bachelors of Technology, Computer Science and Engineering

TECHNICAL SKILLS:

Business Objects XI 3.1, XI R2,6.x/5.x, Desktop Intelligence, Import Wizard, Central Management Console (CMC), Designer, Web Intelligence 6.x/2.x, Info View, Report Conversion Tool, Data Source Migration Wizard, Performance Manager, Xcelsius 2008

Database:

Oracle 10g/9i/8i, MS SQL Server 2000 and MS Access, DB2

Other/Tools :

IBM-Rational Rose

GUI Tools:

TOAD, SQL Plus, PL/SQL Developer

Languages:

C,C++, Java, ASP, SQL, PL/SQL.

Web Technologies :

HTML, XML,DHTML,Java Script

Operating Systems:

Windows 2000/XP, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential,Denver - CO May 10 - Present

Business Objects Developer

Confidential,a financial services company based in the United States. Western Union allows users to send/receive money, pay bills online, in person or by phone. It also offers to purchase prepaid cards and personalized gift cards. This Project is for supporting the Western Union Global cash Money transfer services applications and maintaining/developing new software for Western Union Sales and Market Data warehouses and providing transactions information in the form of reports. Below are the key tasks handled as part of this project.

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Extensively used Business Objects Designer to extract data from data warehouse to be loaded into the centralized system Universe.
• Created New Universes and managed existing ones to implement Parent-Child Universes.
• Migrate, upgrade and test the Business Object XIR3 content/environment
• Setup, execute, and test the assigned programs utilizing BO XIR3 Webi and DeskI tools
• Creation of multiple Universes and Linked Universes.
• Design complex, midlevel and simple Web Intelligence Reports based on user requirements.
• Plan the implementation of migration to different Environments in Business Objects.
• Involved in the Data Warehouse design process.
• Develop Dashboards for higher management of the company.
• Provided end user training for basic and advanced reporting skills on how to use templates to create their own reports and explained the hierarchy levels and incompatibility between the objects to make sure users take advantage of the existing universes.
• Trained users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report.
• Worked on extensive features of Business Objects XI including Index awareness, Derived tables and Input Controls.
• Extensively Created number of formulas, conditional display of fields for complex calculations and used them in different sub reports.
• Creation of reports, working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created reports using WEBI, DESKI, full client.
• Created derived tables & Aliases at Universe level and implemented Security Permissions based on user’s Profile.
• Analyzed the reports using Drill Through, Slice and Dice.
• Developed more than 35 Full client and thin client (WebI) reports for all modules and update to different versions. Exporting universe to the repositories to make resources available to the users.
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Designed, developed, tested and maintained highly complex reports.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Createdcustomized LOV’s and cascading promptsfor easy access to business users
• Deployed the reports by using Import Wizard (between DEV and UAT) and archived the reports.
• Optimized database performance by using shortcut joins. Shortcut joins provide an alternative path between two tables. Shortcut joins can improve query performance by using shorter paths and bypassing intermediate tables.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.

Environment: Business Objects XI 3.1(Web Intelligence/Desktop Intelligence), Designer, Import Wizard) Performance Management, Oracle 9i, DB2, AS/400,SQL Server, Windows XP.

Confidential,IA Jan 09 – Apr 10

Business Objects Developer

Confidential,is one of the largest health care companies in the United States, delivering its products and services all over the United states and other countries. Data model was created for the development of interactive Dashboards and BO reporting is used for testing the dashboards and warehouses were developed using the ETL Tool and Teradata . Project deals with modifying existing data mart, Designing Universe, canned reports and adhoc purpose.

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in the designing and Building of Universes, Classes and objects
• Worked on Master and Component approach during the linking of universes.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Experience in universe migration across repositories
• Set up Universe level conditions to restrict data based on report requirements.
• The project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Created reports using Desktop Intelligence(DESKI)
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Migrated reports from Development/Testing environment to Production Environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures.
• Created dynamic LOV’s based on report requirements.
• Worked extensively on Multiple Universes.
• Used Aggregate awareness functions of Business Objects to route the query objects through most appropriate path while selecting from multiple contexts.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Coordinating with DBA and general supervisor for resolving technical issues
• Upgraded Business Objects Universes, Users and user groups, and reports from older versions to newer version XIR3.

Environment: Business Objects XIR2/XIR3, Performance Management, Business Objects Designer, Web Intelligence, Desktop Intelligence, PL/Sql, Windows NT, Windows 2000 Server.

Confidential,IL Nov 07 – Dec 08

Business Objects Developer

Confidential,is the nation\'s eighth largest wireless telecommunications provider & provides its customers with many different wireless products and services. Scope of the project was to design and build reports for Wireless Number Portability. Wireless Number portability makes it easy to bring current phone number to U.S.Cellular without having to give up current phone number.

Responsibilities:

• Involved with Business users and Process Technology groups to structurally define the business rules and their successfully implementation in the project.
• Installed business objects desktop versions on windows NT system
• Designed and Created Universes using joins, measure objects and aggregates.
• Created Contexts for resolving Loops in the Universes
• Implemented different level of hierarchies for drill down reports.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Involved in developing both static and dynamic reports.
• Analyzed Data using Slice and Dice and Drill Mode.
• Created Master/Detail Reports, Cross-tabs, Matrix and Charts etc
• Controlling Reports data by working with Universe and queries. Using Filters, Sorts and Rankings.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Automated document Scheduling, Publishing and Distribution for WebI and Info view clients, using the Broadcast Agent for Web-Part Reports.
• Applied breaks on Fallout Reason Report, Carrier Fallout Report, Carrier Porting Report, etc., to get appropriate results.
• Applied Sectioning on Port In and Port Out reports to get the required result.
• Tracked the issues and comments of the reports through Lotus Notes.
• Created and Developed Stored Procedures, Packages and Triggers for Oracle 9i Databases using PL/SQL.
• Involved in resolving issues relating to pre implementation of Reports.
• Worked with Developers for performance tuning of the queries to improve user experience.
• Provided end user training for basic and advanced reporting skills.

Environment: Business Objects XIR2/ 6.5.1, Designer, Supervisor, Web Intelligence XI R2, Broadcast Agent Server, PL/Sql, Oracle 9i, MS SQL Server 2000, Windows NT, Windows 2000

Confidential,FL Sep 06 – Oct 07

Business Objects Developer/Analyst

PSI-3 is an In house project of IT Software Solutions Inc, Company. The main objective of PSI-3 (Portable Insurance Systems) project mainly deals with Data collected from different subjects and Insuring Environments. The source data is consolidated into the data mart, which is used for the report generation. Therefore Reporting System includes analysis, design, development, test, and maintenance.

Responsibilities:

• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in Install and configure Business Objects XI R version along with Designer tool
• Designed Universe for standard reporting and ad-hoc reporting requirements.
• Created Aliases and Contexts for solving Join Problems in the Universe.
• Created derived tables at the Universe level.
• Aggregate awareness functions of Business Objects are used to route the query objects through most appropriate path while selecting from multiple contexts.
• Created a wide variety of charts like2D and 3Dline charts,bar chartsandpie charts.
• Used many Business Objects functionality\'s like slice and Dice, Drill Down, Cross Tab, Master Detail, Alerters, calculation contexts etc.
• Create Report templates to ensure uniformity of reports throughout the organization.
• Interacted with Informatica Developers understanding the Data load process to resolve data quality issues.
• Write test-case scenarios, develop test plans and conduct user acceptance testing & training.
• Provided end user training to make sure users can build their own reports
• Developed and prepared logic tests, unit tested the final product.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Responsible for production support services and project development and implementations relative to Business Objects application.
• Communicate effectively with all groups of users during design, testing and implementation phases regardless of background and skill.

Environment: Business Objects Versions 6.x & XI , Designer, Web Intelligence, Desktop Intelligence, PL/Sql, MS SQL Server 2000, Windows NT, Windows 2000