SUMMARY

• Eight plus years of real time IT experience in Business Intelligence Reporting Tools (Business Objects, OBIEE, Tableau) in USA.
• Two plus years of experience in Tableau 8.2.4/7.x
• Three Plus years of experience in Oracle Business Intelligence Enterprise Edition (OBIEE) 11g/10g.
• Five Plus years of experience in Business Intelligence and Data warehousing using Business Objects XI (R2 & R1)/6.x/5.x.
• Expertise in Tableau 8.2.4/7.x dashboards (Connections, Extracts, Filters, data blending, Parameters, Sets, Groups, Dashboard/Worksheet Actions, Visualizations, Hierarchies) and Tableau Server (User set up, user security, workbook Security, Usage Statistics, Schedules, Subscriptions)
• Knowledge of Java script API and interfacing tableau sheets, dashboards with custom built web portal developed using java script.
• Expertise in Oracle Business Intelligence tool OBIEE 11g/10g (Answers, Dashboards, ibots), Oracle User Productivity Kit (UPK) 3.5.1.
• Expertise in creating Interactive Dashboards with drill - down, hyperlinks and guided navigation capabilities (Sections, columns, Tables, Pivot Tables, Charts/Graphs).
• Expertise in investigating data related issues in reports/dashboards and/or identifying if the issue is with report or in ETL or in Source and recommend solutions accordingly.
• Experience in migrating process of obiee reports/dashboards between various environments like DEV, STAGE, UAT and PROD.
• Configuring Delivers (iBots) and administering Web Catalog Objects (Dashboards, Folders, Reports, Pages)
• Knowledge of Physical, BMM and Presentation layers of OBI Metadata Repository.
• Knowledge of configuring analytics Metadata Objects (Subject Area, Table, Column), Answers (ad hoc queries, answers reports), Variables (Repository, Session, Presentation).
• Knowledge of BI Publisher.
• Expertise in Business Intelligence tools using Business Objects XI R 2/6.5/6.1/5.1.7 (Supervisor, Designer, Reporter, Broadcast Agent, ZABO, Web Intelligence), Application Foundation, Performance analysis, Goal Management.
• Knowledge of BO XI R3 and BO XI 4.0, Xcelcius (Dashboards)
• Experience in modifying & maintaining Universes, retrieving data using Universes, Personal data files (MS Access, Excel), Free hand SQL methods and Creating complex ad-hoc Reports using the Business Objects/Full Client & Web Intelligence modules.
• Scheduled and published reports using Broadcast Agent server.
• Worked with Business users to analyze the business process and made necessary changes to the schema objects.
• Knowledge in Data warehouse concepts like Star Schema, Snowflake Schema and Multi-Dimensional Model in relation to query and analysis requirements.
• Knowledge in databases like ORACLE 11i/10g, SQL 200x, DB2, PL/SQL and MS-Access.
• Experienced in writing SQL queries to debug data and to analyze query performance.
• Excellent communication, interpersonal skills and a team-worker with good customer/User interaction.
• Knowledge in Oracle Applications.
• Experienced in interfacing and coordinating multiple teams across multiple geographical locations.
• Self-Starter, quick learner, Strong sense of responsibility, adapt to new environments and integrity in work.

TECHNICAL SKILLS

Business Intelligence Tools: Tableau Desktop 8.x/7.x, Tableau Server 8.x/8.0, Oracle Business Intelligence tool (OBIEE) 11g/10g (RPD, Answers, Dashboards, iBots), Business Objects XI R1/R2/6.x/5.x, Web Intelligence 6.x/2.x, WEBI SDK, Info view 2.0/1.0, Designer, Supervisor, Broad Cast Agent, ZABO, Application Foundation 6.x/2.5, Business Objects Reporting.

Databases: Oracle 11i/10g, SQL Server 200X, MS-Access, Teradata

Database Tools: SQL Navigator, TOAD, MS SQL Query Analyzer, Teradata SQL Assistant

Programming/Web Technologies: C, C++, Java 2.0, Java script, PL/SQL, SQL, HTML, Apache Web Server, IIS 5.0/4.0, TOMCAT 4.1.30

Other Tools and Utilities: Adobe Works, MS-Office Suite 2010/2007/2003 (Word, Access, PowerPoint, Excel, outlook), MS Visio, Oracle User Productivity Kit (UPK), Oracle Applications

Operating Systems: Windows XP/2000/9x. MS-DOS, UNIX.

Methodologies: SDLC/Prototyping, Waterfall; Agile/Scrum

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Engineer - Developer

Responsibilities:

• Responsible for gathering requirements from business users and transformed them into specification requirement document.
• Involved in war room discussions/brain storming session for User Stories, metrics analysis, dashboard/report layouts prior to development.
• Responsible for the development of below listed dashboards & reports using Tableau Desktop 8.2.4/7.x.
• Responsible for creating new/Enhancing existing tableau workbooks using Tableau Extracts, Live Connection, Custom SQL as links to data sources.
• Using Oracle, Teradata, Excel, Tableau Workbooks as data sources.
• Acted as Tableau Admin (Application level) to Create/Add Users, grant permissions to users for accessing workbooks/views, Publish/Schedule workbooks/dashboards and to generate Statistical data related to Usage and Performance.
• Applied hyperlinks to navigate to different dashboards and sheets/tabs using Actions, used filters to filter the data on the dashboard reports, used parameters to change to different views or hide views on the dashboard in tableau workbooks.
• Applied blending on common columns in the tableau extracts from different data sources to pull data from multiple data connections.
• Involved with Java scripting team to apply the Java Script API and interface tableau dashboards and sheets developed.
• Responsible for Unit Testing, UAT and generating test scripts.
• Responsible for migration of workbooks/dashboard per different phases of the project (development to testing to production).
• Responsible for developing GMI Mobile dashboard/reports using OBIEE for users to demo know-how and to provide the look and feel of dashboards/reports on Apple iPad using OBIEE.
• Involved in modifying Finance subject areas in RPD (Presentation Layer) by adding new objects required for report development.
• Created several compound layouts in reports with different views using View Selector, Column Selector, Narrative with HTML, Static with HTML, Views involving presentation variables, Charts, Pivot Tables with and without Charts, Hyperlinks and Column/data level guided navigation/hyperlinks.
• Created complex reports involving UNION, MINUS and UNION ALL reports with custom SQL implementation.
• Responsible for creating multiple dashboards involving multiple pages, guided navigation from one page to another, hyperlinks to navigate from Summary reports to Details report and to Ad-hoc/stand-alone reports.
• Used Javascript in obiee dashboards & reports to include some of the extra functionalities such as spark lines which are not part of out of box capability in obiee.
• Performed Unit Testing and data integrity testing for the reports/dashboards developed.
• Involved in knowledge transfer sessions to testers, Analysts and business Users.

Environment: Tableau Desktop 8.x/7.x, Tableau Server 8.x, OBIEE 11g (Answers, Dashboards, iBots, Repository), Teradata, Oracle, PL/SQL, Clarity-PPM, Rally Software, MS Office 2007/2010, Windows XP, SQL Assistant for Teradata, TOAD.

Confidential, Brea, CA

Sr. Applications Architect

Responsibilities:

• Conducted interactive sessions with business users to gather requirements for new reports and to finalize requirements for existing BO reports for conversion to obiee reports.
• Participated development of OBIEE Service subject areas in RPD (Physical, BMM, Presentation layers) for Global Service Department.
• Participated in interactive analysis of current and required reports.
• Participated in metrics analysis, Story board design and KPI analysis of OBIEE Phase I Out of Box reports.
• Involved in validation of OBIEE Data Models in reference to business objects universes.
• Participated in recommending modifications to Global Service related OBIEE subject areas in RPD (Physical, BMM, Presentation).
• Continuous support for Global Service Reporting Team creating stand-alone reports, dashboards.
• Created several compound layouts in reports with different views using View Selector, Column Selector, Narrative with HTML, Static with HTML, Views involving presentation variables, Charts, Pivot Tables with and without Charts, Hyperlinks and Column/data level guided navigation/hyperlinks.
• Created complex reports involving UNION, MINUS and UNION ALL reports with custom SQL implementation.
• Responsible for creating multiple dashboards involving multiple pages, guided navigation from one page to another, hyperlinks to navigate from Summary reports to Details report and to Ad-hoc/stand-alone reports. Created links to navigate from a dashboard to hidden dashboard pages.
• Performed Unit Testing and data integrity testing for the reports/dashboards developed.
• Responsible for functional and technical documentation including Unit test Documents, UAT scripts, MD050s and MD070s.
• Responsible for migrating reports/dashboards between various environments (DEV, INT, UAT and PROD).
• Involved in knowledge transfer sessions to testers, Co-Analysts in other teams and business Users.
• Provided technical assistance/support to analysts, business community/business users and responded to inquiries regarding errors, problems or business/OBIEE related questions.
• Created and developed reports in BO6.5 and WEBI XI R2.
• Developed service/cost analysis reports using WEBI XI R2.
• Modified existing reports depending on the user requirements.
• Developed highly complex reports using reporter and used various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking.
• Responsible for self-debug the errors occurred in Web Intelligence.
• Created reports and generated graphs for multi-dimensional analysis using Slice & Dice functionality.
• Scheduled and monitored reports using XI R2 Scheduling.
• Published various reports to different users/groups in XI R2.
• Responsible for Unit Testing of the reports, both canned and ad-hoc, developed.
• Involved in knowledge transfer sessions for testers, business analysts, business Users.
• Provided technical assistance/support to analysts, business community/business users and responded to inquiries regarding errors, problems or questions.

Environment: OBIEE 10.1.3.4.1 (Answers, Dashboards, iBots), UPK 3.5.1, Informatica 8.1, Business Objects XI R2/6.5 (Designer, Desktop Intelligence, Web Intelligence/Infoview), Oracle Apps, SQL Server 2000 with SP3,Oracle 11i, MS Office 2010/2007/2003 , Windows XP, TOAD for Oracle 8.6.0.38.

Confidential, Los Angeles, CA

Business Objects Consultant

Responsibilities:

• Involved in creation of reports in full client using BO 6.5
• Involved in modification of Universes, creating Classes, Objects and hierarchies for the multidimensional analysis of database.
• Worked with @ functions while modifying the universe accordingly.
• Reports involved master-detail sections, drill-up/drill-down functionalities, alerters, filters, ranking and sorts.
• Built queries by creating and applying complex conditions and sorts, User Object, LOVs and by writing free hand SQL.
• Published reports via full client to various users.
• Scheduled reports on daily/weekly/monthly basis using broadcast agent
• Created and maintained users/user groups using Supervisor 6.5.
• Involved in set up of user accounts, setting up passwords using Supervisor 6.5.
• Involved in creating ad hoc reports using WEBI and scheduled them to user inboxes via Info view.

Environment: Business Objects 6.5 (WEBI/Infoview, Supervisor, Designer, BCA), Business Objects Data Integrator 6.5, Oracle 10g, SQL Server, PL/SQL, TOAD, Windows Professional, MS Access & MS Excel 2002.

Confidential, Los Angeles, CA

BO WEBI REPORTS DEVELOPER

Responsibilities:

• Responsible for gathering the business requirements and in documentation.
• Developed highly complex reports using reporter and used various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking.
• Responsible for self-debugging of the errors occurred in Web Intelligence.
• Developed and modified reports in Versions Business Objects XI R1 & R2.
• Involved in building reports based on the data marts APDM, HPDM & MLCDM
• Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up/Down functionality.
• Responsible for unit testing of the reports, both canned and ad-hoc, developed.
• Scheduled and monitored reports in WEBI to other Users/Developers/Power Users.
• Published various documents/reports to different users/groups.
• Researched on how to get the Meta Data (Data Definitions) from Informatica tool into Business Objects Universe.
• Responsible for unit testing of reports developed.
• Responsible for writing queries in DB2/SQL.
• Responsible for creating test database in Access and test the reports accordingly.
• Tested reports for data consistency, tested Universe table joins, contexts, defects in reports/fixed the defects in reports.
• Interacted with ETL Team and Testing team to fix the data defects in the reports.
• Performed knowledge transfer for other team members working on separate project.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems or questions.

Environment: Business Objects XI R1 & R2 (Designer, WEBI), TOAD for DB2 V 8.2, DB2, AIX server, Informatica V7, MS Access, Excel, Word, Windows XP.

Confidential, SANTA ANA, CA

OPEN SYSTEMS DEVELOPER W/BUSINESS OBJECTS

Responsibilities:

• Modified the existing reports depending on the user requirements.
• Maintained and Modified Universes using Designer and exported them to the Repository.
• Developed highly complex reports using reporter and used various techniques like Master-Detail, Sectioning, Filters, Slice and Dice, Ranking.
• Responsible for the Up gradation of the repository from one version to the other.
• Migrated Universes, Reports from one version to the other.
• Responsible for self-debugging of the errors occurred in Web Intelligence.
• Created reports and generated graphs for multi-dimensional analysis using Slice & Dice, Drill Up/Down functionality.
• Scheduled and monitored reports using Broadcast agent Console.
• Published various documents/reports to different users/groups using BCA publisher.
• Used BO Supervisor for creating the repository, creating users and groups, assigning privileges to them, creating categories and setting permissions for various users.
• Responsible for the safe recovery of the bomain.key file.
• Responsible for Uninstalling, Installing and Configuring Business Objects 6.5.
• Responsible for Installation and Configuration of Application Foundation 6.5.
• Created Dashboards from the existing metric universes using Dashboard Manager.
• Responsible for unit testing of the reports, both canned and ad-hoc, developed.
• Performed knowledge transfer for other team members working on separate project.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems or questions.

Environment: Business Objects 6.5.1/6.1.3 (Designer, Supervisor, Web Intelligence 6x, Broad Cast Agent, Publisher, ZABO), Application Foundation 6.5, SQL, Windows Professional, SQL Server 2k3 (Advanced) with SP4.

Confidential

BO Developer

Responsibilities:

• System study, business Requirement analysis & documentation.
• Responsible to design the reports by sitting with the business users.
• System Analysis and appropriate design of the reports to use daily reporting purposes.
• Extensively used Business Objects Designer to maintain the Universes.
• Designed, developed, tested and supported highly complex reports in Business Objects.
• Extensively used various techniques like Sectioning, Ranking, Filtering to develop the reports.
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice and Drill up/down functionality.
• Worked extensively with the major functionality of BO like Breaks, Alerter, Filters, Sorts, Query Prompt and Drill filters.
• Scheduled and monitored reports using Broadcast Agent Console.
• Web Intelligence was used to create the reports and to test the reports.
• Responsible for unit testing of reports.
• Responsible for writing queries in SQL.
• Used Business Objects supervisor for creating, users, and categories & to provide access permission for the users.
• Used the BO Auditor to audit users and user activity
• Responsible for the unit testing of the reports developed by the team.
• Worked with other team members and performed the knowledge transfer.
• Provided technical assistance/support to analysts, business community and responded to inquiries regarding errors, problems, or questions with programs/interfaces

Environment: Business Objects 5.1, Web Intelligence Server, Designer, Supervisor, ZABO, Informatica 5.1, Oracle8i, PL/SQL, Info View, SQL Server 7.0,Windows NT, UNIX.