Professional Summary:

• Over 7 years of experience in DSS Application development and Data Warehouse developments. Expertise in developing solutions in Business Objects various versions 5.x/6.x/XiR1/R2 on both UNIX and NT environments.
• Expertise in developing Universes from different databases including Oracle, SQL server, DB2.
• Created few hundreds of reports in both thin client and full client.
• Completed SA310 from SAP in Administering and Configuring servers in Business Objects Enterprise XI R3.
• Created Crystal Reports and Distributing through Business Objects Enterprise XI.
• Designed and Linked Universes for query, reporting, and analysis using
  Designer Module.
• Experience in Crystal Reports 8.5, 9.0 and XI.
• Expertise in gathering, analyzing and documenting Business Requirements, Functional Requirements, and Data Specifications for Business Objects Universes and Reports.
• Expertise in working with operating Systems like Windows NT 4.0 and UNIX.
• Extensively utilized databases ORACLE 8.X, 9I, 10G, SQL server, MS SQL 6.5/7.0,DB2, PL/SQL and MS_Access.
• Expertise in Universe designing, developing and generating complex, Adhoc, dashboard Reports, Business views, List of values along with User Acceptance Test and data accuracy Test.
• Extensively used Oracle Database design, database migration, data warehousing, ETL process and related maintenance tools using Oracle and SQL databases.
• Good knowledge on Data modeling using Erwin.
• Experience in creating and transforming business requirements into software requirement specification (SRS).
• Extensive experience in Reporting interfaces such as Web Intelligence, Desktop Intelligence, Crystal Reports
• Technically sound, Result-Oriented with strong Problem Solving skills.
• Capable of working as a Team Member or Individually with minimum supervision.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.

Professional Skills:

Report/ETL Tools/OLAP/DSS Tools:

Business Objects XI R2/XI R1, 6.x/5.x, web intelligence (ZAB0) 2.6/2.7, BCA/DAS, SDK, BO-AFS Suite, Dashboard Manager, scorecards, Crystal Reports XI, AB Initio, XIR2, Tomcat 4.0.6,5.5.26/5.5.27 Apache 1.3.x, Informatica Power Mart 5.0/6.0, Power Center 2.0/3.0

Oracle Utilities:

TOAD, SQL * Navigator, Developer 2000, SQL*Loader

Databases:

ORACLE 8i/9i.10g, MS Access, MS SQL Server 2005, DB2, Sybase.

Languages:

SQL, PL/SQL, C, C++, C# and Visual Basic 6.0.

Web Technologies:

VBScript, ASP, ASP.net, HTML 3.2/4.0,IIS 4.0/5.0.

Operating Systems:

UNIX, MS-Dos, Windows 3.1/95/2000/XP, Windows NT 4.0/2000

Professional Experience:

Confidential,Falls Church VA Jan 2009 to Dec 2009
Sr. Business Objects Developer

Description: Confidential,maintenance support for the Expense Assignment System used in military treatment facilities worldwide. The Expense Assignment System IV (EAS IV) is a cost allocation tool that assists Military Health system (MHS) in identifying the total cost for providing health care to beneficiaries. EAS IV provides DoD decision-makers with improved business case analyses and decision support capabilities to maximize cost-effective health care delivery. EAS IV provides standardized reporting of workload, expense, and manpower data at the medical and Dental treatment facility level.

Responsibilities:

• Migrated Business Objects 6.5 to XI R2.
• Interacted with Business Users, Database Team to know their requirement in developing and updating universes.
• Responsible for providing the impacts, and risks on the upcoming requirements.
• Created Universe after the XIR2 upgrade, so the canned reports work without incompatible error.
• Installed BOXI R2 in 4 Business Objects Server.
• Responsible for resolving the production problems with the Repository and Application Servers.
• Converted Webi reports from the Deski Reports using Report Conversion tool in Business Objects XI R2.
• Documented procedure for the whole team, participated in creating Functional Users guide.
• Created functional specifications from the Business Requirements Document.
• Analysed the pro’s and con’s of Business Objects XI R2 vs Business Objects 6.5.
• Created reports in XI R2 to test functionality.
• Created reports with Multiple Data Sources, Drill Down, Slice/Dice and Charts.
• Created new Business Objects Users and User Groups using Business Objects Supervisor Module.
• Designing multiple Universes for user Reporting.
• Responsible for maintaining all the eight Servers, so that they look alike.
• Performed daily tasks like Tomcat Restart, OAS restart, Users Password reset.
• Created trace logs of the Problematic servers to find the root cause of the problem.
• Worked simultaneously on Reports (as per user needs) as the reporting environment was being migrated to Business Objects.
• Involved in providing the complete Business Objects XiR2 reporting solution and during the course of action have build Universe using Designer, Business views using Business View Manager, Analytical reports using Desktop Intelligence and Webi.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Variables, Break, Alerter.
• Imparting training the end user in basic and advanced Ad Hoc reporting as well as creating queries, formatting results, and share them with others using Web Intelligence.
• Unit tested reports to track possible defects.

Environment: Business Objects XI R2/R1, 6.5, Web Intelligence, Desktop Intelligence, Crystal Reports XI R2, ESP, Data Integrator 11.5, Sybase, PL/SQL, SQL Scripting, UNIX, Oracle 10g, MS SQL server, Windows NT.

Confidential,Raleigh NC Jun 2008 to Dec 2008
Business Intelligence Consultant

Description: Confidential,is one of the biggest implementers of BUSINESS OBJECTS complete product suite. The two projects I was involved was Migration and Presales reporting. Main focus of Verizon Business is to maintain the log and presales information of managed and Unmanaged Networks, through the Enterprise Service portal (ESP), which is basically provided to Verizon’s Clients for the adhoc reporting.

Responsibilities:

• Upgraded to XI R2.
• Interacted with Business Users, Database Team to know their requirement in developing and updating universes.
• Created functional specifications from the Business Requirements Document.
• Analysed the pro’s and con’s of Business Objects XI R2 vs Business Objects 6.5.
• Created reports in XI R2 to test functionality.
• Created Custom Macros, and Add-Ins to customize reports.
• Created reports with Multiple Data Sources, Drill Down, Slice/Dice and Charts.
• Created new Business Objects Users and User Groups using Business Objects Supervisor Module.
• Designing multiple Universes for user Reporting.
• Responsible for resolving loops and traps like Fan and Chasm using Contexts and Aliases.
• Migrated Business Objects 6.5 to Business Objects XI R2.
• Creating ad hoc reports in Business Objects for various internal client groups
  Modified List of Values (LOV’s) to make it easy to understand by the end users.
• Worked on Business views and Universes to Business Objects XI.
• Involved in Retrieving and Publishing Documents from and to Corporate Repository
• Responsible for Scheduling the Documents and distributing the Documents through Broadcast Agent Server.
• Worked simultaneously on Reports (as per user needs) as the reporting environment was being migrated to Business Objects.
• Involved in providing the complete Business Objects XiR2 reporting solution and during the course of action have build Universe using Designer, Business views using Business View Manager, Analytical reports using Desktop Intelligence and Webi.
• Generated complex reports including Formulas, Variables, Cascading prompts and Alerters.
• Developed complex reports and some of which span multiple databases, multiple universes & multiple data providers.
• Worked extensively to overcome the performance issues, which was achieved by creating few specific views, indexes, aggregate tables and hints.
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Variables, Break, Alerter, Master Detail and Formulae’s.
• Imparting training the end user in basic and advanced Ad Hoc reporting as well as creating queries, formatting results, and share them with others using Web Intelligence.
• Unit tested reports to track possible defects.
• Involved in migration of reports from 6.5 to XI for Presales department.
• Done Unit Testing for Universe and BO Reports and interaction with end users.

Environment: Business Objects XI R2/R1, 6.5, Web Intelligence, Desktop Intelligence, Crystal Reports XI R2, ESP, Data Integrator 11.5, Sybase, PL/SQL, SQL Scripting, UNIX, Oracle 10g, MS SQL server, Windows NT.

Confidential,Alpharetta GA Feb 2006 to Jun 2008
Business Objects Consultant

Description: Confidential,is one of the biggest implementers of BUSINESS OBJECTS complete product suite. The two projects I was involved was Customer Information Board and KRONOS. The main focus of Customer Information Board is to provide analysis about the traffic and road constructed statistics as requested by the customer and STB (State Transportation board). KRONOS is a data warehousing building and report generating project successfully implemented by GDOT.

Responsibilities:

• Involved in Full life cycle of Business Objects reporting Application.
• Installation of Business Objects and repository Creation.
• Responsible for Collecting report requirements from users/business owner.
• Frequent updates between requirements between team and users.
• Worked in Analyzing the requirements team.
• Sharing work with rest of the team depends on the schedules and priorities.
• Responsible for Developing and maintaining Universes as per user new report requirements.
• Involved in Installation of Web Intelligence and Broadcast Agent server.
• Involved in Configuring WEBI and BCA.
• Published Documents to Broadcast Agent Server.
• Upgrading BO environment.
• Responsible for designing and creating Universes.
• Reports requirements gathering and designing technical and functional specifications.
• Design and development of Full client CAN reports and WEBI reports.
• Responsible for Maintaining supervisor by creating user accounts and privileges.
• Implemented complex security setup in supervisor.
• Scheduled full client reports and WEBI reports through BCA.
• Created drill-down reports.
• Created reports from OLAP cube.
• Extensively used Data warehouse Analysis – Business area analysis and scope analysis.

Confidential,Chicago IL Dec 2004 to Jan 2006
Business Objects Consultant
Description: Confidential,is a leading financial institution involved in personal and institutional lending, mortgages and banking. The project scope is to design and build a warehouse for decision support for personal and institutional loan data. The warehouse is built from data received from various branches and offers summarized view for optimized decision making. The key objective of the project is to migrate and scheduling reports and generating reports as per business requirements.
Responsibilities:

• Involved in defining solutions that supports the information and reporting requirements of the organization
• Installed and configured Business Objects 6.
• Created Repository, Users and User Groups using Supervisor.
• Created Universes and Reports using Business Objects 6.0
• Implemented Object level security, Row Level security using Business Objects.
• Designed and created Universes by defining Joins, Cardinalities between tables, and linking the existing Universes.
• Resolved Loops in Universe by creating Aliases, Contexts and aggregate awareness to remove dependencies.
• Developed various complex reports with drill through capabilities, summarized, group and filters.
• Created ETL Jobs using Data Integrator .
• Involved in Planning and deployment of Business Objects XI universe, Web Intelligence and Crystal Reports XI business intelligence solution throughout enterprise.
• Created simple to complex reports using Crystal Reports XI.
• Generated List of Values (LOVs) from lookup tables.
• Defined Business Views for crystal reports development
• Scheduled crystal reports and Implemented dynamic cascading prompts
• Exported Business Objects reports to Web Intelligence to be published on the Intranet and created thin client reports through Info View.
• Successfully built SQL and PL/SQL scripts to maintain Order information consistently in multiple systems with great accuracy. Packages, Procedures and Functions were extensively used to improve the functionality of the program.
• Involved in design and documentation of mappings and sessions to build and run them in scheduler and monitor for the successful loading of data into Data Mart.
• Exported reports to different formats (Excel, PDF, word) based on the user requirements.
• Exported the Business Objects reports to WEBI XI to be viewed by all users on the web.
• Created ETL jobs using Informatica.
• Created Shell scripting for the application.

Environment: Business Objects 6.x, Crystal Enterprise ,Web Intelligence, Data Integrator, Informatica, oracle 9i, SQL, PL/SQL, Windows 2000/NT,Ratiol Clear Case, Visio.
Confidential,Chicago IL July 2003 to Nov 2004 Business Objects Developer
Description: Confidential,one of the leading wireless service providers deployed the project to keep track of the calling trends among the Cellular users across regions spanning several states. Worked in Billing Department to analyze information and generate management reports.
Responsibilities:

• Involved extensively in creation of Universes using Business Objects Designer.
• Involved in taking requirements and writing specifications for designing the Universes and Created Business Objects Universes to get the data from Data Warehouse.
• Involved in designing Billing Star Schema and universe based on this schema.
• Created complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionalities like Combined Queries.
• Designed complex schemas using various @ functions like prompt and aggregate Awareness.
• Responsible for publishing and broadcasting business intelligence documents to large number of end users.
• Generated and Designed Report and Report exporting to PDF using Crystal Reports.
• Created reports using Crystal Reports with Grouping, Sorting, Formula fields and Parameter fields.
• Created a set of Dynamic cascading prompts and scheduled the list of values for the same.
• Created Business Views using Business View Manager for Reports.
• Implemented row level restrictions according to different business group requirements.
• Involved in migration and deployment of the universes and reports across multiple domains.
• Generated reports with 2D, 3D and pie charts for business query results.
• Used WEBI to create, analyze and publish reports to various user groups.
• Generated various reports with “prompt” functionalities at both universe and report level to enhance end-user interactivity.
• Did multi-dimensional analysis using slice & dice, drill (up, down, through and across) by setting up different hierarchies and defining the scope of analysis.
• Responsible for maintaining the Development, Testing and Production repositories and providing support during the production stage.
• Involved in scheduling of documents monthly, weekly and daily through Broadcast Agent Server.
• Worked with other business analysts to interview clients and capture basic to moderately complex business requirements. Collaborated with business technicians to research existing business and system processes.

Environment: Business Objects 6.5(Designer, Reporter, Web Intelligence, Broadcast Agent), Crystal Reports, Oracle 9i, PL/SQL, TOAD, Informix.

Confidential,Hartford CT July 2002 to June 2003
Business Objects Consultant

Description: Confidential,is an innovative leader in the health and well-being industry. This project I have extensively worked with all aspects of BO from installation to post production support. Consistently met goals and time-lines at clients in developing universes and reports.

Responsibilities:

• Involved in Full life cycle of Business Objects reporting Application.
• Installation of Business Objects and repository Creation.
• Responsible for Collecting report requirements from users/business owner.
• Frequent updates between requirements between team and users.
• Worked in Analyzing the requirements team.
• Sharing work with rest of the team depends on the schedules and priorities.
• Responsible for Developing and maintaining Universes as per user new report requirements.
• Involved in Installation of Web Intelligence and Broadcast Agent server.
• Involved in Configuring WEBI and BCA.
• Published Documents to Broadcast Agent Server.
• Upgrading BO environment.
• Responsible for designing and creating Universes.
• Reports requirements gathering and designing technical and functional specifications.
• Design and development of Full client CAN reports and WEBI reports.
• Responsible for Maintaining supervisor by creating user accounts and privileges.
• Implemented complex security setup in supervisor.
• Scheduled full client reports and WEBI reports through BCA.
• Created drill-down reports.
• Created reports from OLAP cube.
• Extensively used Data warehouse Analysis – Business area analysis and scope analysis.

Environment: Oracle 9i, Business Objects (Supervisor, Designer, Reporter), WEBI,BOSDK, Crystal Reports , Visual Basic 6.0, Toad, Word, Excel, UNIX, and Windows XP.