Summary

• Over 6 years of experience in Information Technology with strong work experience as Business Objects Developer.
• Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) and its deployment.
• Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
• Experience in creating Adhoc reporting ready universes using Business Objects Universe Designer.
• Extensively used various features like Joins, Alias and Contexts in Universe designer to overcome various traps (Chasm, Fan) and Loops.
• Excellent data-analysis skills and ability to translate specifications into a working Universe and/or Report.
• Experience in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Extensively used advanced reporting functionalities such as Master Detailed, Drill, Filters, Ranking, Sections, Graphs and Breaks.
• Installation and configuration of Xcelsius, QaaWS Client Server Modules and designing complex reports and dashboards in monitoring business metrics.
• Hands-on experience in developing Analytical Dashboards using Xcelsius with QaaWS and Live Office connectivity.
• Experienced in Training & Supporting end-user reporting needs using Business Objects.
• Strong database experience in using Oracle 10g/9i/8i, MS SQL Server 2008/2005, MS Access.
• Very good understanding of Data Warehousing Design Methodology, Data Warehouse Concepts, Database design/architecture including both OLAP & OLTP data and complete lifecycle of project from design to development and implementation.
• Exposure to Dimensional Data modeling- Star Schema modeling and Snowflake modeling.
• Participated in all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation).
• Possess excellent communication, decision-making, Problem Solving, Analytical, and Interpersonal skills with result oriented dedication towards goals. 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.

Technical Summary:

Business Objects Tools : Business Objects XI 3.1/3.0, XI R1/R2,6.5, Web Intelligence XI 3.1/3.0/XI R2, Universe Designer XI 3.1/3.0,XI R2, Desktop Intelligence, InfoView, CMC, Import wizard, Report Conversion Tool, Data Integrator 11.5/XI 3.0, Xcelsius 2008, Query as a Web Services(QaaWS), Live Office.
Databases : Oracle 10g/9i/8i/8.0, MS SQL Server 2008/2005, MS Access, Siebel, Sybase, Teradata, Informix.
Data warehousing : Star-Schema Modeling, Snowflakes Modeling, FACT, dimension tables.
Operating Systems : Windows Server 2003/2000/NT, Windows Vista/ XP/ME/98/95, DOS, UNIX.
Windows Utility : MS-Word, MS-Excel and MS-PowerPoint.
Programming Languages : SQL, PL/SQL, JAVA, HTML, C, C++, C#, .NET
Dimensional Data Modeling Tools : Dimensional data modeling using Erwin modeling (Erwin 4.1/4.0/3.5.5/3.5.2), Physical & Logical Data Modeling, multidimensional modeling, Snowflake Schema/ Star Schema modeling (Normalization / De-Normalization Techniques), Erwin, Visio.
Query Tools : TOAD, SQL*PLUS, SQL*Loader, SQLNavigator.

Experience

Role: Sr.Business Objects developer Aug 2011 - Till date
Client: Confidential, VA
Inova Health Systems is a major health care provider in Northern Virginia. The Supply chain Data Ware House receives data feeds from disparate clinical, financial, and operational information systems. Business Objects suite is used to mine, analyze and report on this data to retrieve the key metrics required to measure and thereby reduce costs, streamline operations and improve patient care by management.

Responsibilities:

• Inventory, Accounts Payable and Purchase Orders were the different subject areas within the data warehouse.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Participated in the complete development lifecycle: analysis, design, build and test reports
• Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created User Prompts, Conditions and Filters to improve the quality of report generation.
• Scheduled Reports using scheduler Infoview as well as CMC.
• Key metrics ‘procure to pay cycle times’, ‘diversity spend’, ‘cash discounts captured and missed’
  spanning across different subject areas has been re-created using Xcelsius.
• Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
• Providing support for the users on application usage and conducting training walk through of salient features of the application.

Environment: Oracle 10G, Business Objects XIR2, Web Intelligence and Infoview XI R2, Desktop Intelligence, CMC, Import Wizard, Universe Designer, Java script, PL/SQL Developer, Windows 2003 advanced server.

Role: Sr.Business Objects Developer May 2010 – July 2011
Client:Confidential, VA
Capital One is a leading financial institution involved in personal and institutional lending, mortgages and banking. The project scope is to design and build reports for decision support for personal and institutional loan data. The reports are built from data received from various branches and offers summarized view for optimized decision making

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Designed and maintained complex Universes, resolved loops by creating aliases and contexts.
• Exported the ad-hoc ready universes to the for making semantic layer available to the users.
• Extensively used the @functions and Aggregate Aware feature. Worked on back end views, tables required by the business objects universes.
• Created and defined the Hierarchies for various reports based on the Business rule of the Organization.
• Created Xcelsius dashboard for executive view covering selected KPI for the business function
• Created WSDLs using Query As a Web Service (QaaWS) from different Data sources.
• Migrated Xcelsius dashboards and deployed QaaWS to the new servers and fixed the hyperlinks and excel spreadsheet to be compatible in new environment.
• Troubleshoot errors for reports, dashboards, and universes. Fixed them to work as per the business needs.
• Created complex reports by linking data from multiple data providers, stored procedures and functionalities like Union Queries, Drill Down, Master Detail, Custom Sorts etc.
• Extensively worked with Ranks, Alerter, filters, prompts, variables and calculation contexts in designing reports.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Set up groups and users for Business Objects deployment.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Extensive testing and migrating the reports or objects from development to Production system.
• Developed testing scripts and test cases. Extensively tested Business Objects reports, dashboards and other Business Objects Applications in new environment.
• Involved in performance testing of all the reports, which helped in analyzing its performance before moving into production.

Environment: Business Objects XIR3.1, WebI, Xcelsius, Universe Designer, Oracle 8i/9i, PL/SQL, Windows XP/7.

Role: Business Objects Developer Dec 2008 - Apr 2010
Client:Confidential, California
IHOP (International House of Pancakes) is a leading chain of restaurants with more than 1000 outlets in USA and Canada. The data warehouse is developed to analyze Sales and financial data for both franchise as well as company owned stores on a periodical basis.

Responsibilities:

• Involved in understanding the end-user requirements and business processes in creating and designing universes, queries and reports.
• Designed Universes, incorporating all the business requirements.
• Implemented object level security universe to incorporate security for sensitive information.
• Worked in migration of universe and reports between environments.
• Designed universes, solved loops by creating aliases, contexts and resolved traps.
• Created complex variables, breaks, sorts, filter and conditions for various reports.
• Created complex reports involving master/detail and cross-tab and Combined queries and sub-queries
• Linked multiple data-providers and Used calculation contexts/extended contexts
• Coordinated with DBA and Business objects designer group in solving various technical issues.
• Created multiple contexts for catering different functional areas in a single user query.
• Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts..
• Used prompts in the reporter as well as in the universe to create more interactive reports for running different kind of campaigns.
• Extensively used scheduler for report scheduling and deployment
• Generated various report templates for standardizing the reports throughout the organization.
• Involved in end user training and documenting the procedures.
• Involved in developing the financial reports for the Financial services Dept and successfully published the highly formatted reports and met with the end user requirements
• Resolved Year Ago Variance Calculation, Percentage Calculation in Cross Tab in Web I XI R2.
• Scheduled pre-canned reports through Scheduler for distribution and printing.

Environment: Business Objects XI3.1, Web Intelligence, Xcelsius 2008 Oracle 9i

Role: Business Objects developer Jan 2008 - Nov 2008
Client: Confidential, CA
Verizon operates the most reliable wireless network in the U.S., an extensive global Internet backbone network and an advanced broadband network. The project involved using the Business Objects suite to integrated solutions for reporting, planning, budgeting, analyzing of sales.

Responsibilities:

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed several universes and used various methods to optimize queries on database, universe and reporting level.
• Worked towards optimal development of universes by removing loops through the use of aliases and contexts.
• Creating Universe with number of Classes, many objects, Derived Tables using inner/outer and equiv. joins as per requirement.
• Created and tested classes and objects to organize the universe.
• 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.
• Created the reports using Business Objects functionality’s like Queries, Cross Tab, Master Detail and Formulae’s etc.
• Applied drill-up and drill-down techniques in master detail reports for multi-dimensional analysis of retrieved data.
• Extensively worked with Ranks, alerters, filters, prompts, variables and calculation contexts in designing reports.
• Created Business Objects Repository while building Business Objects solution.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Created Derived tables, Developed Stored Procedures, Packages and Triggers database using PL/SQL.

Environment: Business Objects XIR2, Web Intelligence, Universe Designer, Oracle 8i/9i, Windows NT.

Role: Business Objects developer Jan 2007– Dec 2007
Client: Confidential, Denver, CO
DCP Midstream segment is one of the nation's largest natural gas gatherers and processors, andone ofthe largest natural gas liquids producersand NGL Services. The company changed its name from Duke Energy Field Services. The purpose of this engagement is to upgrade the existing 6.5 business objects environment to XIR2 and validate the converted reports and rebuild the reports.

Responsibilities:

• Information gathering - interacted with the end user to understand the requirement and business logic
• Analyzed the existing OLTP system and designed and managed universes based on the Business Requirements
• Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies
• Used @functions like @select, @where and @prompt function to create prompts which helps the user to select the values dynamically
• Customized the list of values (LOV’s) which helps the end users to select the values.
• Created complex Condition Objects for easy reporting, Aggregate-Aware objects for better performance
• Developed Business Objects Universes with classes, objects and condition objects and developed hierarchies to support drill down reports.
• Created reports using Business Objects functionality like slice and dice drill down, cross tab, master detail tables and formulas, etc.
• Created complex reports by linking data from multiple data providers, using free hand SQL and functionalities like Combined Queries.
• Working on the SQL tuning and optimization of the Business Objects reports.
• Scheduling reports from the Broadcast Agent Server to only requested users.
• Worked extensively on Web Intelligence for any new requests and performance issues.
• Involved in installing Web Intelligence, creating users, user groups and categories
• Generated reports for web users using Web Intelligence and Info View.
• Created Web Intelligence documents and published them to corporate documents.
• Worked with Installation and configuration of Business Objects XI R2 using Tomcat and Apache as Application and Web Servers.
• Migrating Business Objects 6.5.1 version reports to new version XIR2.
• Converted the existing full client reports to WebI reports using Report Conversion Tool.
• Imported existing users, groups, categories, WebI documents, connections, universes and restrictions to BO XI environment using Import Wizard.
• Created reports using Desktop Intelligence and Web Intelligence in BO XI R2 environment.
• Synchronized queries from multiple data providers by linking the common dimensions using merge dimensions option in Web XI R2.
• Extensive testing and migrating the reports or objects from development to Production system

Environment: Business Objects 6.5.1 (Supervisor, Designer, Reporter), Web Intelligence 2.x/6.x, BCA, BOXI R2 (CMS, CCM, CMC,), Oracle 10g, PL/SQL, SQL Server 2000, Windows 2000, UNIX, Crystal Reports XI/9.0, Crystal Xcelsius, PeopleSoft FMS 8.9.

Role: Business Objects Developer March 2006 –Dec 2006
Client: Confidential, Hyderabad, India.
Ananth Technologies provides electrical materials to both internal and external customers. They have the Global material services for their customers. GMS acts as a distribution center by sourcing the materials from the suppliers (internal and external) and shipping it to customers of Ananth Technologies.

Responsibilities:

• Analysis of Business Objects environment, Universes, Reports.
• Add more groups and change the profile of users via supervisor.
• Developed Universe using Designer module in Business Objects.
• Developed and created classes with Dimension, Detail & Measure Objects and specified the hierarchies.
• Specified the Joins and checked the cardinalities.
• Implemented User Objects in Reports.
• Created Condition in Universe.
• Ad-hoc reports were used for Business Objects user modules for various portfolios using the Universes as the main Data providers.
• Resolved loops by creating Aliases and Context.
• Organized data in reports by using filters, sorting, ranking and highlighted data with alerts.

Environment : Business Objects 6.5, Web Intelligence, Oracle.
Education:

• Bachelors in Electronic and communication