Summary

• More than 8 years of IT experience in various roles such as Software Engineer, BI Consultant & Reports Analyst.
• Over 7 years of experience in Business Objects Enterprise and Crystal reporting tool and Business Intelligence.
• More than 3 years of experience in Scorecard and Dashboard Development using Crystal Xcelsius, Performance Manager and Dashboard Manager.
• Technical hands-on experience using BI tool such as Business Objects XIR3.1/XIR2/6.X(Reports, Designer, Web Intelligence, Desktop Intelligence, Infoview and Supervisor) and Crystal Reports 10/XI/XIR2/2008
• Involved in various end to end implementation and development of Crystal Xcelsius based dashboards.
• Integrated Crystal Xcelsius Dashboards with various web applications and incorporated real time data using QAAWS, LIVE OFFICE and Web Services (WSDL)
• Strong Experience in Business Objects Installation, Configuration, Maintenance, Support and Migration of Reports over shared Environment.
• 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.
• Proven abilities in creating complex reports by linking data from multiple data providers, using free hand SQL, stored procedures and functionality like Combined Queries.
• Extensively used Business Objects reporting functionality such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks
• Experience in all stages of the Software Development Life Cycle(SDLC) including Requirements Analysis, Data Modeling, Object-Oriented Analysis, Design, Programming, System Integration and Software Configuration Management.
• Prepared Functional and Technical documentation and system design documents.
• Database experience in Oracle, MS SQL Server and related tools.
• Experienced in Oracle 9i/10g, SQL, PL/SQL, stored procedures, triggers, SQL * Loader.
• Experienced in designing Star Schema, Snow Flake Schema, Data modeling, and ODS
• Procedures, triggers, SQL * Loader, Enterprise Manager, Erwin, Shell Scripts and TOAD.
• Fluid understanding of multiple programming languages, including C#, C, C++, JavaScript, HTML, and XML.
• Excellent communication skills with strong background working directly with coworkers and clientele to identify business objectives and establish requirements.

Technical Skills

Business Objects XIR3/XI R2/6.5, Crystal Reports 10/XI/XIR2/2008, Crystal
Report 2008, Crystal Xcelsius designer 4.5 (QAAWS, Live Office, Xcelsius SDK)
& 2008, Dashboard Manager & Performance Manager

Database

SQL and PL/SQL - Oracle 8, 9i and 10g & MS SQL Server 2005, MS Access

Languages

Java,C, C#, C++, ASP, JavaScript, HTML, XML.

Platforms

Windows 2000/NT/XP, UNIX, Linux, Sun Solaris2.8

Software

Toad,MS Office Suite, Version Control Systems (CVS, PVCS, Clear Case), Load Runner.

Company: Confidential, San Mateo, CA Feb 12 to Present
Role: Sr. Business Object Consultant
Description:
Confidential, is a Real Estate & Property Management. Prometheus is the largest private owner of multi-family properties in the San Francisco Bay Area. We specialize in the acquisition, development and management of high quality residential and commercial properties. Prometheus used Business Objects XI 3.1 for reporting across Finance, Booking & Billing, and Sales subject areas.
Responsibilities:

• Involved in the Installation and Configuration of Business XI 4.0.
• Interacted with users to gather requirements and specifications for creating the 360 reports using slice and dice and drill down features in the reports
• Created Business Objects Reports and used Web services option to dynamically update the Xcelsius dashboards.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Designed, developed and tested the application against the real-time data.
• Designed operational dashboards based on the KPI\'s and metrics.
• Created Executive Dashboards using SAP BO Xcelsius.

Environment: Business Objects XI R3/XI4.0, WEBI, Infoview, SQL/PL/SQL, Oracle 9i/10g, SQL SERVER 2008 and Win XP/2000.

Company: Confidential, CA March 11 to Dec 11
Project: JARVIS
Role: Sr. Business Object Consultant
Description:

Confidential, is designed to vitiate the Life Technology DW historic and real time sensitive data from the source of SAP and delivered the relevant data to ABISCIEX using Business Objects Report tool.
Responsibilities:

• Involved in the analysis, requirements gathering, Specifications, Development, Testing, Training End Users and Business Group.
• Installed and configured the BO servers on Windows environment .
• Created Universes in Business Objects and coming up with the OLAP reports as per the detailed requirement specifications with proper formatting standards and data quality.
• Also involved in administrating and maintaining the BO servers for 24/7 availability.
• Created Reports in various formats using Web Intelligence (thin client) and full client.
• Involved in creating Users, User group, Setting Privilege, Security and Roles using BO Supervisor.
• Worked on Cross Module linkage between DataMarts through BO Designer.
• Created and Published Standard BO / WebIntelligence reports.
• Worked with End-users to fix BO issues for the reports moved into production recently.
• Involved in detecting and checking the Joins, Loops, Cardinalities, Alias and Contexts.
• Tuning of the SQL Statement which takes long time to process the request using Tkprof to reduce the response time.

Environment: Business Objects XI R3, WEBI, Info view, Erwin, PL/SQL, Oracle 9i/10 g and Win XP/2000.

Company: Confidential, CA Jun 10 - Jan 11
Project: Information Technology Business Operations Management (IT BOM)
Role: Business Intelligence Analyst/ BI Development
The IT BOM project is designed to manage IT as a business with real time reports and dashboards which provides multidirectional & accurate view of the business parameters using Business Objects software. My role is to design, implement and standardize various executive level reports using Business Objects Web Intelligence, Crystal Reports & Interactive dashboards using Crystal Xcelsius 4.5 and 2008.

Responsibilities:

• Installed and configured the BO servers on Windows environment with Oracle 10g as the backend database.
• Gathered and assessed business information needs and prepared system and reporting requirements .
• Interacted with end users and analysts the business requirement and developed canned and adhoc reports and front-end screens according to functional specifications.
• Conceptualized, designed and optimized the universe for better performance.
• Built Reports with Crystal Reports using heavy drill-down and slice and dice methodologies which provide 360 views.
• Built interactive and drill down enabled Xcelsius Dashboards using Xcelsius 4.5 and later migrated them to Xcelsius 2008.
• Built customized scorecards for managers using Performance Manager Dashboard capabilities.
• Responsible for creating the reports and Dashboards in the development environment and then migrating them over to the production using the import wizard
• Used multiple data-providers like stored procedures, free-hand SQL apart from the core universe.
• Created templates to customize style and structure according to the employer\'s needs.
• Troubleshoot business reporting issues and implemented applicable solutions.
• Provided technical consulting to users of the various data warehouse and reporting solutions and advise users on conflicts and inappropriate data usage.
• Executed reporting performance tuning and optimization.
• Ensured the consolidation of existing IT and business reporting solutions into a single source of trusted business information .
• Worked collaboratively with Infrastructure teams to maintain the Business Object Enterprise serve and configuration landscape.
• Held training and educated the technical staff on the usability and development of reports using Crystal Xcelsius 4.5 and 2008.

Environment: Business Objects Enterprise XIR2/XIR3.1, Deski, WebI, Crystal Reports, Universe
Designer,Crystal Xcelsius 4.5 and 2008, Performance and Dashboard Manager, Live Office, QAAWS,
Excel Database

Company: Confidential, Palo Alto, CA Sept 08 to May 10
Project: Clinical Analytics and Reporting Environment (CARE)
Role: Business Intelligence Analyst/ BI Development
Description:CARE is designed to provide SHC (Stanford Hospital and Clinics) Quality Information and Patient Safety (QIPS) & SHC leadership with clinical & business metrics to improve quality reporting, business analytics & data mining and provide a self service data mining & ad hoc reporting environment to support reporting of clinical and quality performance measures and Establish the first generation enterprise data warehouse (EDW).

Responsibilities

• Involved in the analysis, requirements gathering, Specifications, Development, Training End Users and Business Group.
• Created Universes i.e. the semantic layer, (CARE universe and UHC universe) for the CAREDW, UHC and MEDSDW data warehouse to retrieve data from CAREDW. Developed classes and objects within Universes for reporting needs for analysts and the management.
• Created POC for the application, designed the architecture to meet the requirements for dynamic data, and built a real-time web based application based on the POC.
• Extensively used calculations, variables, breaks, sorting, drill down, slice and dice, alerts, Cross Tab, Master Detail for creating Business Objects reports.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Designed, developed and tested the application against the real-time data.
• Created Business Objects Reports and used Web services option to dynamically update the Xcelsius dashboards.
• Designed operational dashboards based on the KPI\'s and metrics.
• Created Executive Dashboards using SAP BO Xcelsius

Environment: Business Objects Enterprise XIR2, Crystal Report 2008, Crystal Report 2008,Crystal Xcelsius 4.5, Web Services, Live Office, Excel database, Oracle 10g.

Company: Confidential, San Jose CA Jan 08 to Aug 08
Project: BO Migration
Role: Architect and Developer
Description:Power Integrations used Business Objects 6.5.1 for reporting across Finance, Booking & Billing, Sales subject areas. Power Integrations planned to migrate the 6.5.1 infrastructure (platform, universes and corporate documents) to Business Objects XI R2 platform.

Responsibilities

• Architect and Installed XI R2 platform on Power Integrations Dev/QA/Prod environments.
• Designed general architecture of 4 BO systems (DEV/TEST/PROD). Clustered and load balanced between 2 PROD BO system.
• Backup the universe, reports (WEBI and DESKI), users, Groups and Security and restore in different BO system.
• Monitored CMS, FRServer, both input server and output server.
• Created auditing reports using XI R2.
• Assessed, consolidated and recommended reports usage and criticality via eLustro based surveys.
• Migrated identified universes to XI R2.
• Designed and Setup security based on XI R2 model.
• Migrated corporate documents to XI R2.
• Created complex universe by joining the various schema according the business requirement.
• Tested Universe and documents for accuracy and formatting
• Created flash based demonstration scripts for self service user training on usage of XI R2
• Coordinated with offshore team in India for the manual universe testing.
• Conducted class room/web based training

Environment: Business Objects XI R2/6.5, InfoView/WEBI, Oracle 10g and Window 2003.

Company: Confidential, Sunnyvale, CA Jan 07 to Dec 07
Project: Partner Profiling Reporting System
Role: BO Developer
Description: The purpose of the Partner Profiling Project is to capture new and updated Partner information to build partner repository so corporate and regional channel teams can access the information via Business Objects.

Responsibilities

• Interacted with users to gather requirements and specifications for Partner Profiling Reporting System.
• Prepared business and functional requirements.
• Created Universe for Partner Net application to create the adhoc and canned report against Oracle database.
• Involved in detecting and checking the Joins, Loops, Cardinalities, Alias and Contexts.
• Created Standard and Ad-hoc BO Reports in XI R2.
• Created simple and complex reports using Web Intelligence in XI R2.
• Involved in testing the reports against the database.
• Scheduled the WEBI and DESKI report to the repository using INFOVIEW.
• Involved in creating the users and giving access privilege to the user.
• Training end users and business group to access the reports.
• Wrote complex functions and stored procedures to implement the metrics in the universe.
• Tuning of the SQL Statement which takes long time to process the request using Explain Plan, Autotrace, Hints to reduce the response time.
• Tested the Stored Procedures, Functions and Unit/ Integration testing of universe metrics.

Environment: Business Objects XI R2, WEBI, Info view, PL/SQL, Oracle 9i and Win XP/2003.

Company: Confidential, San Jose, CA Oct 05 to Dec 06
Project: Customer Support - Business Objects
Description: Project deals with the various issues faced in installing, configuration, customization and general functions of the Business Objects suite of products at the client location.

Responsibilities:

• Troubleshooting client side installation and configuration problems.
• Identifying the product related issue and escalating it appropriately for a fix.
• Providing workarounds for users for issues faced.
• Giving high level training to the customers for better understanding of the BO product.
• Replicating the client side issues using VM Ware and thus provide solution/workaround

Project: Confidential
Description: Customer Support Intelligence universe provides the business users with clean and integrated customer support data for analysis and reporting across US and Canada for the PeopleSoftCustomerSupport application. This project was developed using Business ObjectsXI, and provides the Case Management and the Incident Management.

Responsibilities

• Involved in the Installation and Configuration of Business XI R2.
• Interacted with users to gather requirements and specifications for Customer Support Intelligence Universe.
• Migrated Business Objects 6.5 to BO XI R2 using Import Wizard.
• Created Universe for PeopleSoft Customer Support application to create the adhoc reports against Oracle database.
• Involved in detecting and checking the Joins, Loops, Cardinalities, Alias and Contexts.
• Created Standard and Ad-hoc BO Reports in XI R2.
• Created simple and complex reports using Web Intelligence and Desktop Intelligence.
• Convert Desktop Intelligence and Web Intelligence report from 6.5 to XI R2 using Report conversion Tool.
• Created Multi Dimensional analysis using Slice/Dice and Drill methods to organize the data along a combination of "Dimension" and "Hierarchies" giving the ability to the end-users to observe data
  from various viewpoints
• Organized data in the reports by using Filters, Sorting, Ranking, Breaking and highlighted data with Alerts.
• Created Tables, Forms, 3D bar charts, Stacked Area charts, Pie charts and 3D surface charts using WEBI.
• Scheduled the WEBI and DESKI report to the repository using InfoView.
• Wrote complex functions and stored procedures to implement the metrics in the universe.
• Created Materialized View to fetch data from the source system.
• Tuning of the SQL Statement which takes long time to process the request using Explain Plan, Autotrace, Hints to reduce the response time.
• Tested the Stored Procedures, Functions and Unit/ Integration testing of universe metrics.

Environment: Business Objects 6.5/XI R2, WEBI, Info view, PL/SQL, Oracle 9i and Win XP/2000.

Company: Confidential, Walnut Creek, CA Jan 05 to Sept 05
Project: Pharmacy Supply Chain Data Warehouse
Role: Sr Business Objects
Description: Pharmacy Supply Chain Data Warehouse provides business users with clean and Integrated Pharmacy supply chain data for analysis and reporting across NCAL and SCAL. The project involves data extraction from the Mainframe/Oracle/DB2 UDB and transforming them specifically for query and reporting purposes.

Project: Remedy Universe
Remedy is a suite of software applications that allows KP_IT to manage changes to Configuration items in a controlled manner with a minimum disruption of service. KP-IT uses the Remedy for the following business processes: Change Management, Incident Management and Problem Management.
Responsibilities:

• Interacted with users to gather requirements and specifications for Pharmacy Supply Chain Warehouse.
• Worked on creating the table structures in DB2 UDB using the ERWIN
• Created the user name and password using BO Supervisor and give them the privileges.
• Responsibility for the technical transfer to the users
• Created Universe for Remedy application to create the adhoc reports against the DB2 and Oracle database.
• Created the Stored Procedure in DB2 UDB for converting the date format.
• Created Context and Aliases in the Remedy Universe.
• I was involved in the technical support for Remedy Universe
• Creating multiple Universes in Business Objects and coming up with the OLAP reports as per the detailed requirement specifications with proper formatting standards and data quality.
• Creating Unit test cases for the reports of simple and complex nature (graphical) executing them and validating results.

Environment: Business Objects 6.5, WEBI, Infoview, Erwin, PL/SQL, DB2 UDB, Oracle 9i and Win XP/2000.

Company: Confidential, Bangalore, India Sept 04 - Dec 04
Project: Online Financial Transaction processing
Role: Developer
Description: Developed online transaction processing accounting system to capture all financial
transactions in a financial firm. The system maintains all journals, account receivable and account payable
information. It also closes cash book and balances bank account. Ledger and trial balance preparation
constitute the month end processes. This multi currency system supports all automated payments and check
printing.
Responsibilities:

• Involved in requirement analysis and prepared system design documents.
• Involved in designing forms, validating form objects including ActiveX components, Data access using Oracle as the backend and ADO and RDO as data facilitating objects.
• Designed and developed table structures, Stored Procedures and Database triggers to implement business rules.
• Designed User Interface Screens and involved in coding and testing of the applications.
• Created multiple PL/SQL procedures, functions and Cursor as stand-alone schema package spec/body.
• Created a PL/SQL table with indexing it using BINARY_INTEGER to handle a table record in PL/SQL block. Designed Visual Basic classes for UI and database access modules.
• Designed Editor Screen using ASP that enables a user to create multiple trunks at a time. It has an editor capability (like Java editor), which will parse, validate, debug and execute a query.

Environment:
Windows NT, Oracle 7.3.4,PL/SQL, SQL, SQL*PLUS,ASP and Visual Basic 6.0

Professional training in Oracle Corp.: Introduction to Oracle9i for Experienced SQL Users.
Professional training in Oracle Application 11i (OM,INV,WIP,BOM modules) from Amfasoft Inc.
Business Objects Certified Professional (BOCP) -Business Object Enterprise XI R2.

Master in Computer Science
Advance Diploma in Oracle, VB, India
Oracle Application 11i (OM)

Visa Status
Green Card.