PROFESSIONAL SUMMARY

• Over seven years of experience in Information Technology field with strong emphasis in Data Warehousing and Business Intelligence.
• Over five years of experience with Business Objects as an OLAP tool for building report, designing universes and managing user profiles.
• Involved in full lifecycle Planning, development of various assignments including Data Warehouse projects.
• Very good domain knowledge aiding in detail analysis of Business requirements and preparation of Analysis documents.
• Experience in Business Objects XI 3.1 (Central Management Console (CMC), Central management server (CMS), Central Configuration Manager (CCM), Designer, Desktop Intelligence, Web Intelligence, Import wizard, Report Conversion Tool, Performance Management).
• Expertise in using Business Objects XI 3.1/XI R2/XI/6.5/6.1a/5.1.7, Business Objects Desktop products (Supervisor, Designer, Reporter) and Business Objects Server Suite (InfoView, WebI, ZABO, BCA).
• Knowledge of Business Objects Full client & Thin client environment.
• Expertise in migration from Business Objects 5.1.7 to XI 3.1 using Import Wizard.
• Proficient in using both 2-tier and 3-tier reporting tools like Desktop Intelligence, Reporter and Web Intelligence.
• Expertise in retrieving data using Business Objects Universes, personal data files and free hand SQL methods.
• Experience in creating Repositories, designing Universes, Full Client/WebI reports, publishing and scheduling using Broadcast Agent for publisher and scheduler.
• Worked on developing reports using Crystal Reports XI using Business views and Universes as data providers.
• Hands-on experience in Installation and Configuration of Business Objects Enterprise XI 3.1/XI R2/XI/6.5.
• Experienced in developing Universes, Reports and Dashboards as well as defining meta-data for end user reporting.
• Experienced in creating Metrics and Analytics to create Dashboards for better decision purpose.
• Good understanding of ETL tool like Informatica Power Center / PowerMart.
• Worked extensively on SQL, PL/SQL and very good exposure to Oracle 10g, 9i, 8.x, 7.x and MS SQL Server 7.0/2000/2005, MS Access 2000, DB2 UDB 8.0, Sybase.
• Proven track record of successful implementation of all project life cycle stages from requirements gathering through implementation and enhancements.
• Self-motivated, Result oriented team player and quick learner of new concepts and technologies. Excellent interpersonal, project management, communication and documentation skills.

EDUCATION

• Bachelor of Science in Information Technology.

TECHNICAL SKILLS

BI Tools:

Business Objects XI 3.1 (Central Management Console, Central Configuration Manager, Central Management Server, DeskI, Import Wizard, WebI, Designer, InfoView, Performance Manager, Dashboard Manager, Crystal Reports), Business Objects 6.5/ 5.1.7 (Reporter, Designer, Supervisor), Broadcast Agent (Document Agent/Publisher), WebI X1 3.1/XI R2/R1/6.5, BCA, InfoView, 3 Tier BO, Crystal Xcelsius 4.5/2008, Live Office.

Operating Systems:

Windows NT/98/95/2000 server/XP /Pro, UNIX, Sun Solaris.

RDBMS:

Oracle 8i/9i/10g, MS Access 2005, DB2 UDB SQL Server 2000/2005, Sybase.

Front End Tools:

SQL*Plus, TOAD.

Reporting Tools:

Crystal 2008/XI R2/XI/10, Developer 2000 Forms and Reports/Oracle Reports.

ETL Tools:

Informatica Power center 6.x/7.x.

Data Modeling Tools:

ERWIN 4.0, MS Visio.

Languages:

C++, Visual Basic, Java, SQL, PL/SQL.

Others:

MS Office-2003, MS Project.

PROFESSIONAL EXPERIENCE

Business Objects Developer
Project: SAPBO Migration

This project involves migration of the existing reports from BO 5.1.7 to Business Objects XI 3.1 / XI R2.The type of reports vary from normal reports accessing various universes to reports using free form SQL and Stored Procedures.

Responsibilities

• Involved in gathering the Reporting requirements from Supplier Quality Engineers who are the key users of the QPM system.
• Modified the existing Universes according to the Specifications, which were from different data sources like Oracle/SQL Server.
• Involved in the designing and Building of Universes for new Components.
• Involved in creating Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.
• Extensively used various techniques like Sectioning, Ranking, Filtering, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc to develop the reports.
• Created reports using multiple data providers such as Universes and personal data files in generating reports.
• Created Reports with graphical representation such as Bar charts, Pie charts for multidimensional analysis.
• Validating and Verifying Universes and Reports created by the Off Shore team and making the Necessary Changes if needed.
• Involved in Migration of Business Objects system from version 5.1.7 to Business Objects XI 3.1.
• Involved in Performance Testing for Testing the Performance of the Reports created by the SMA team and suggested solutions to improve the Performance.
• Involved in managing key component of QPM which is a custom built SDK application, AutoConfigurator that integrates with the BOBJ Dashboard.
• Created Rules in the Dashboard Manager to Run the Control Charts that is created by designated QPM Administrators in the AutoConfigurator application.
• Created Rules in the Dashboard Manager for the Control Charts Scheduled to run daily.
• Monitoring the Alerts sent to QPM users who subscribed to Lotus Notes e-mail alerts when an out of control condition exists on a control chart for a supplier of a given commodity.
• Created new Metric Universes specifically designed for creation of Dashboards.
• Developed Quality Performance Management Dashboards for the Users to view all the QPM Reports.
• Was involved in the BOBJCOE meetings to upgrade to Business Objects XI 3.1.

Environment: Business Objects XI 3.1 / R2 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, InfoView, Dashboard Manager, Performance Manager, Import Wizard), Crystal Reports 2008/ X1 R2, Xcelsius 2008, Business Objects SDK, Live Office, Oracle 10g, TOAD, SQL, PL/SQL, Windows XP.

Business Objects Developer
Project: Ciber – Risk Management

Confidential,is a global information technology consulting, services and outsourcing company. Services include application development and management, ERP implementation, change management, project management, systems integration, infrastructure management and end user computing.

Responsibilities

• Interacted with Business Users and Business Analysts to gather the Requirements and Business logics.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Involved in the designing and Building of Universes from different data sources like Oracle/SQL Server.
• Linked Universes to share the Universes, which had common dimension tables and the classes and objects.
• Applied row level and object level securities to different groups and users using Designer component.
• Resolved loops by creating alias and contexts to remove the cyclic dependencies between the tables.
• Worked extensively with @Functions (@Select, @Prompt, @Where) to filter the data.
• Resolving join path Problems like ‘Chasm Trap’ and ‘Fan Trap’ and loops by creating Context and Aliases.
• Modified Universes with pre-calculated aggregates from summary tables.
• Created cascading list of values to enable cascading prompting in the reports using Designer.
• Generated reports using free-hand SQL, which had complex Business Logics.
• Involved in postproduction Support and gave training to the end users to create adhoc reports.
• Created full client and WebI reports. Modified the existing by adding new columns based on the result set.
• Design the Conversionproject for the existing Legacy Reports in to the Business Objects Webi Reportsandwork closelywith Architects to upgrade the existing BO version to BO XI R2 system. Interpreted meaning and relevance from raw data and perform detailed analysis and transforming in to the powerful Webi Reports.
• Created WebI reports with more than 10 data providers and synchronized the data using the merge dimensions option.
• Created cascading list of values to enable cascading prompting in the reports using Designer.
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects connected to Oracle 10g data sources.
• Created Crystal Reports using Universes and Business Views as the data sources based on the business requirements.
• Published Crystal Reports to Business-Objects Enterprise System using publishing wizard.
• Generated dynamic cascading values in the process of building Crystal Business Views.
• Created interactive Dashboards and Business Presentations by importing data from Excel sheets using Crystal Xcelcius.
• Created new Universes specifically designed for creation of Dashboards.
• Developed Performance Management Dashboards to set Goals, Measures and monitor KPI for Balance Scorecard initiatives.
• Created Interactive Metric Trends (IMT) and scorecards using Performance Management according to the user requirements.
• Created highly formatted reports to visually represent data using Crystal Xcelcius.
• Imported data from Excel sheets using Crystal Xcelcius for Creating interactive Dashboards and Business Presentations.

Environment: Business Objects XI 3.1 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, InfoView, Dashboard Manager, Performance Manager, Import Wizard), Crystal Reports 2008/ X1 R2, Business Objects SDK, Live Office, Crystal XI, Crystal Xcelsius, Oracle 10g, SQL Server 2005, TOAD, SQL, PL/SQL, Windows XP.

Confidential,is a leader in the design and manufacture of high performance analog semiconductors. Intersil products address three of the industry’s fastest growing markets - flat panel displays, optical and power management. Intersil is a semiconductor company with substantial revenues, leading global customers, a strong balance sheet and exciting growth potential.

Responsibilities

• Involved in functional requirements gathering, meeting different Business Groups and preparing the Technical specifications.
• Involved in the designing and Building of Universes from different data sources like Oracle/SQL Server.
• Created Universes from the underlying Oracle Apps HR and Finance Data marts based on the business requirements.
• Linked Universes to share the Universes, which had common dimension tables and the classes and objects.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Modified Universes with pre-calculated aggregates from summary tables.
• Exported the universes to the Repository to making resources available to the users.
• Involved in Writing Detailed Level Documentation for reports and Universe design.
• Responsible for designing the reports according to client’s requirement using Business Objects XI R2.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
• Tuned the queries to improve the Performance of the existing Reports for various functional areas.
• Used multiple data providers such as Universe and personal data files in generating report.
• Responsible for developing all types of reports including Cross-tab reports using Crystal Reports XI.
• Generated reports using free-hand SQL.
• Responsible for designing and development of on demand sub reports.
• Involved in production Support and gave training to the users.
• Scheduled Business Objects reports through Schedule manager in on regular basis.
• Created full client and WebI reports. Modified the existing by adding new columns based on the result set.
• Involved in Migration of Business Objects system from version 6.5.1 to Business Objects XI R2.
• Responsible for migration of Users, Universes, Connections, Full Client / Web I Reports from the existing version 6.5.1 to XI R2.
• Involved in testing (Users, Universes and Reports) throughout the migration process.
• Created Crystal reports using Business Views and Universes as data providers.

Environment: Business Objects XI R2 (CMC, CMS, CCM, Designer, DeskI, Web Intelligence, InfoView, Dashboard Manager, Performance Manager, Import Wizard), Crystal Reports XI R2, BusinessObjects6.5.1 (Supervisor, Designer, Reporter, Web Intelligence), Business Objects SDK, Broadcast Agent & Publisher, Crystal XI, Oracle 9i, SQL Server 2000, TOAD, SQL, PL/SQL, Windows NT.

Confidential,New Jersey, NJ Feb ’07 to Oct ’07

Business Objects Developer
Project: TDBNJBO-Project

Confidential,is one of the 15 largest banks in the United States, and provides Customers with a full range of financial products and services. Business also includes TD Financial and TD Wealth Management.

Responsibilities

• Interacted with Business Users to gather, analyze and record requirements/specifications.
• Maintaining customers Issue log and responding to issues.
• Detected Cardinalities and Loops. Resolved loops using aliases & contexts.
• Tested and migrated universes and documents across testing/production repositories.
• Created complex reports using Business Objects functionality like Slice and Dice, Drill Down, Drill Up and Ranking.
• Aggregate awareness functions of Business Objects are used to route the query objects through most appropriate path while selecting from multiple contexts.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Alerters, inserted Calculations, Filters, Sorts, and Query Prompts.
• Managing users and groups and data security mechanism with multiple repositories/domains.
• Applied breaks on reports to get appropriate results and created cross tabs.
• Created different types of reports like Cross Tab, Charts, and Master Detail using multiple data sources.
• Setting up and administering the Broadcast Agent. Worked with BCA to schedule reports on monthly and weekly basis.
• Created reports using full- client and web intelligent and crystal reports.
• Gave my thoughts and ideas to the data-modeling team in designing a new data mart for future reporting applications.

Environment: Business Objects 6.5, Broad Cast Agent, ZABO, Crystal 9, Oracle 9i, MS SQL server 2000, Sybase 12.0, TOAD, ERWIN, Windows 2000/NT, UNIX.

Confidential,Charlotte, NC. Jan ’06 to Jan ’07

Business Objects Developer
Project: PIC Core Migration (Division of Tokio Marine Group)

Confidential,is a member of Tokio Marine Group. Philadelphia Insurance Companies designs, markets, and underwrites Commercial Property & Casualty and Management & Professional Liability insurance products tailored for the unique exposures of niche markets, providing competitively priced policies, local service relationships, and differentiated coverage features.

Responsibilities

• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects universes and reports.
• Involved in creating repository and setting up of groups and users for Business Objects users.
• Created and set User profiles to grant user permissions for querying.
• Designed Financial Universe to deliver analytical reports across the enterprise.
• Involved in creating Universe, Classes, Measure Objects, Dimension Objects, and Detail Objects and applied Hierarchies based on Business logic.
• Created Cardinalities, Contexts, Joins and Aliases for resolving loops and checked the integrity of the universes.
• Created hierarchy and conditions in the universes.
• Designed, developed and tested reports based upon data generated by enterprise transaction, customer information system using Business Objects 6.5.
• Generated complex cross-tab reports with multiple queries, conditions, global filters and multiple data providers.
• Created reports for various product lines using the universe as the main data provider.
• Used Business Objects functionalities like Drill Down, Cross Tab, Functions and Master Detail etc.
• Created links in BO reports to link summary and detail reports using open document syntax.
• Generated reports using personal data files like MS Excel.
• Scheduled the WEBI reports using InfoView.
• Generated reports having charts.

Environment: Business Objects 6.5 (Supervisor, Designer, Reporter), Web Intelligence 2.x, Oracle 8i, BCA, MS SQL Server 7.0, Windows 2000\\98, UNIX.

Confidential,Banglore, India. Oct ‘04 to Dec ’05

Business Objects Developer
Confidential,is Software services consulting company. TCS is the largest provider of information technology and business process outsourcing services in Asia. TCS is a flagship subsidiary of one of India\'s largest and oldest conglomerate company, the Tata Group.
Responsibilities

• Involved in Full life cycle design and development of Business Objects reporting Application.
• Designed and developed Business Objects Universes to support the new sales reporting requirements of business users.
• Used the Universes, Stored Procedures as source for Business Objects Querying, analysis and reporting.
• Extensively used Report Writer and Broadcast Publisher deployment.
• Created complex reports and published on Web using Web Intelligence.
• Created Ad-hoc reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master Detail and Formulas etc.
• Developed Revenue reports by region, by quarter using Business Objects.
• Creation of reports like Residential and Business Customers reports, Service charge validation Reports, Consumer STFS usage Reports, Monthly paper bill Reports, and Tax Summery Reports, IPL Reports, Affiliated, Non-Affiliated Reports, Status Reports, Daily/Monthly Orders Reports, and Customers detailed Reports.
• Importing and Exporting of universes into repository.
• Developed the UNIX shell scripts in order to run the Daily Cycle reports.
• Troubleshooting and customization of reports after upgrade.
• Generated reports using business Objects Reporter.
• Created PL/SQL procedures for processing business logic in the database.
• Creation of different types of reports, such as Master/Detail, Cross Tab and chart (for trend analysis).

Environment: BusinessObjects6.0, Info view, BO Designer, WebInteligence2.x, Broadcast Agent, Supervisor, Oracle8i, MS Access 97, Windows NT.

Confidential,Hyderabad, India Jul ’03 to Sep ’04

PL/SQL Developer

Confidential,is the world\'s most sophisticated banking and insurance software company. Polaris is the chosen outsourcing partner for 10 of the top 15 global banks and 6 of the 10 top global insurance companies. Polaris offers state-of-the-art, comprehensive solutions for core banking, corporate banking, wealth & asset management and insurance.

Responsibilities

• Database Design and Application programming.
• Integration/System Testing of the application.
• Was involved in quality related activities like defect tracking.
• Writing Database Packages, Stored Procedures and Triggers.
• Unit Testing and Tuning of SQL Statements.
• Support and maintenance of the Application Database.
• Database servers and backup server’s installation.
• Support of Production, Development and Test Environments of Oracle and Sybase Databases for multiple applications.
• Troubleshooting and Performance tuning of SQL Servers and applications.
• Backup and Recovery procedures for Production and Development servers.
• Running DBCC and fixing database consistency and allocation errors.
• Creating databases, tables, indexes, new logins, users etc.
• Monitoring performance of Oracle database.
• Physical resource management: device and segments creation.
• Statistics maintenance. Writing shell scripts to schedule tasks. Creating stored procedures and triggers.

Environment: Oracle 8i, Shell Scripting, Developer 2000, PL/SQL, Designer 2000, Sun Solaris, Windows 95.