PROFESSIONAL SUMMARY:

• Over 7.5 years of IT experience in developing, migrating and maintaining wide range of reporting systems as a Solution developer, BI/DW developer, Tech Lead for various clients in Retail, Telecommunications and Banking Domains.
• Extensively worked on creating dashboards and reports using Crystal Xcelsius 4.5, Xcelsius 2008, Business Objects XI R2/3.1 and Crystal Reports.
• Proficient in creating Xcelsius dashboards using Live Office and Query as a Web Services and leveraging them to develop reuse strategies.
• Expertise in Universe designing; reports creation using Web Intelligence, Desktop Intelligence.
• Experience in migration of Business Objects from 6.5 to XI R2/3.1.
• Experience in installation and configuration of various versions of Business Objects for project setup that involve creating the groups in CMC, adding users, mapping the row level and object level securities, integration of SAP with SAP - BOBJ tools.
• Good experience as a Content Admin in exporting the Xcelsius dashboards to istore
• Experience in working with various operational sources like Oracle, SQL server and Flat-files.
• Involved in various phases of Software Development Lifecycle including Project Initiations and concept developments (POC Phase), implementation and testing.
• Experience in training corporate associates on various Xcelsius concepts and methodologies.
• Trained on Integration Services, Analysis Services and Reporting Services and deploying them to cloud environment.
• Excellent analytical, problem solving skills and knowledge in DWH concepts in addressing various technical issues at work.
• Dedicated team player and leader with strong interpersonal and leadership skills.
• Ability to prioritize and distribute the efforts to ensure that the team meets the scheduled deadlines.

TECHNICAL SKILLS:

BI Tools: Business Objects XI R2/3.1/4.x, Xcelsius, Live Office, Crystal Reports, BI ondemand (powered by SAP HANA), Oracle BI publisher

Scripting: HTML

Platforms: Windows XP, Windows 2003 Server, Windows 2008 R2 EE

Database: Oracle 9i/10g, SQL Server 2008 R2

Workflow Tools: MS-Office

PROFESSIONAL EXPERIENCE:

Confidential, MN

Sr. Business Objects/Xcelsius Dashboard Developer

Responsibilities:

• Designed a Universe to enable the write back and retrieve functionality using Xcelsius and Web Services.
• Used prompts, filters, Drill downs, calculations at the Universe level to generate Dynamic dashboards using KPIs (Key performance indicators).
• Worked extensively with Xcelsius 2008 to display summary-level business data in a rich and intuitive format.
• Formatted the raw data retrieved from Universe Objects in Xcelsius spreadsheet using formulae/functions that are supported in Xcelsius.
• Developed web services using Query as a Web Service Wizard (QAAWS) and deployed it to the server for developing Xcelsius dashboards.
• Used multiple Flash variables in Xcelsius and used them to pass data from Dashboard to WEBI Report.
• Worked extensively with (@select, @aggregate aware, @where, and @prompt) to overcome the problems with Database when integrating with Business Objects.

Environment: /Tools: BO 3.1(Designer, Web Intelligence, Query as a Web Service), Xcelsius 2008, Oracle 10g, MS-Excel 2007, Windows 2008 R2 Enterprise Edition.

Confidential

BI Developer

Responsibilities:

• Worked on analyzing the solution design / High-level design of the entity interacting with the source system (an Oracle database populated through the batch programs created to upload the csv file data).
• Involved in Understanding the relational data modelling.
• Developed static dashboards using Xcelsius 2008.
• Designed and developed desktop and web intelligence reports.
• Had weekly status meets with Clients to discuss about the work progress and understand the knowledge gaps and the upcoming maintenance releases.
• Conducted knowledge sharing sessions to the project’s new recruits and helped them in resolving their technical issues.

Environment: /Tools: BO 3.1, Xcelsius 2008, Oracle 10g, MS-Excel 2007, Windows 2008 R2 Enterprise Edition.

Confidential

BI Developer

Responsibilities:

• Worked on understanding the database mappings and building various reports in all the modules.
• Worked with the SMEs to create and populate the databases with the sample/test data for a quick start of building the reports.
• Customized the universes to create dashboards.
• Designed and developed Web Intelligence reports.
• Created different types of dashboards using Xcelsius.
• Assisted the team members in writing and analyzing the SQL queries.
• Provided the end-to-end support during Development and tested various reports and dashboards created.

Environment: /Tools: BO 3.1, Xcelsius 2008, SQL Server 2008 R2, MS-Excel 2007, Windows 2003 server.

Confidential

BI Developer

Responsibilities:

• Gathered the required Key Performance Indicators (KPIs) provided by Confidential .
• Developed Reports and Dashboards using Web Intelligence and Xcelsius.
• Designed the Dashboard layouts (GUI) and developed the dashboards in the given timeline.
• Retrieved client requested data from various sources using QaaWS, Live Office and XML data connectivity.
• Developed multiple dashboards in different areas like Finance, Manpower and Operations.
• Scheduled recurring meeting with clients to understand the project scope.
• Installed and configured BO 3.1 and Xcelsius 2008.
• Perform predictive (what-if) analysis observing the daily, quarterly, yearly data.
• Trained the new team members on various Xcelsius concepts

Environment: /Tools: Web Intelligence, Xcelsius 2008, Query as a Web Service, Live Office, XML data connectivity, Oracle 10g, MS-Excel 2003/2007, Windows XP.

Confidential

Solution Developer

Responsibilities:

• Played an important role of developing the Dashboards and reports using Xcelsius, Crystal and BO 3.1.
• Responsible for coordination with SMEs of various streams like Retail, Banking, Insurance, Airlines (T&L) and Finance to gather the customer needs and requirements.
• Extended support to various project teams in setting up and configuring Xcelsius, Query as a Web Service and Live Office in their project environments and providing support in resolving their technical issues in BO Xcelsius.
• Worked on developing reports, dashboards and scorecards as POCs for various customer demos such as OC Tanner, ASDA, Confidential, ACRA, Shoprite, and UOB within a short span of time.
• Developed around 25 dashboards using Xcelsius and more reports using Web Intelligence.
• Provided layouts and reusable Xcelsius dashboards in various domains and helped the team with designing universes using Designer
• Resolved day-to-day maintenance issues and technical requests of the team and provided performance recommendations.

Environment: /Tools: BO 3.1, Xcelsius 2008, MS Excel, Query as a Web Service, Live office, Crystal Reports, Toad, SQL/PLSQL, Oracle 10g, Windows 2003 server, Windows XP.

Confidential, NY

BI Developer

Responsibilities:

• Worked on understanding the user Requirements by communicating with business users and preparing Low level Technical Specification documents for the team.
• Involved in the development of Web Intelligence Reports and Xcelsius dashboards (Standard content) using Rapid marts.
• Used outer joins to retrieve the data and used self joins and sub queries to implement the report requirement. Involved in creation of performance management, Universe, Metrics, Analytics and personal and corporate dashboards.
• Used report level filters, URL reporting using parameters passed by hyper links and report variables.
• Designed reusable interactive objects and used Derived tables and involved in granting access to Universe and Object level security.
• Involved in preparing project metrics, test cases and performed Unit testing, documented the test results, involved in Code reviews.
• Managing the offshore team and worked closely with onsite team to receive daily tasks.

Environment: /Tools: BOXIR2 (Designer, Web Intelligence, CMC, Performance Management, Dashboard Designer), Crystal Xcelsius 4.5, MS Excel 2003, Query as a Web Service, Live office, SQL/PLSQL, Oracle 10g, Windows XP.

Confidential

BI Developer

Responsibilities:

• Involved in performance tuning of BO reports and admin activities including installation of Business Objects repository, creation of user Ids, implementation of security features and management of the repository.
• Developed Xcelsius dashboards with sample data and Business Objects reports like matrix reports, tables, Pareto charts and pie charts.
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colours, etc
• Specified the standards/best practices for universes for maintaining design consistency. Also defined standards for tables, charts, etc.
• Presented the advanced features of Business Objects to users and developers to enable them to develop queries and reports easily

Environment: /Tools: BOXIR2 (Designer, Web Intelligence, CMC), Crystal Xcelsius 4.5/2008, MS-Excel 2003, Oracle 10g, Windows XP.

Confidential, San Jose, CA

BI Developer, Tech Lead

Responsibilities:

• Analyzed and modelled the Client Financial Data.
• Developed Analytics (Dashboards) for Business Objects, eBay, Microsoft, JPMorgan, US State Population and others.
• Trained and led Team of 7 Xcelsius developers.
• Created web services in QaaWS from the pre-built client universes.
• Worked on importing data to excel sheets from Web Intelligence using Live Office and using them to build Xcelsius dashboards.
• Tested the Dashboards that are ready for Production.

Environment: /Tools: BOXIR2 (Query as a Web Service), Crystal Xcelsius 4.5, Live Office, SQL/PLSQL, Oracle 10g, MS-Excel 2003, Windows XP.