PROFESSIONAL SUMMARY:

• Holds Bachelor's Degree in Computer Science with 11 years of experience in Tableau, Business Objects, Business Intelligence and Data Warehouse applications within the finance, sales and marketing, healthcare, and entertainment industries.
• Created Dashboards for the top level Management using Tableau, QaaWS Live Office.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created Dashboards for the top level Management like the Trend Analysis, What-if Analysis using Tableau and BO Dashboards.
• Exported Xcelsius to repository to make it available for users through BI launchpad.
• Created WSDLs using Query as a Web Service Qaaws from different Data sources and implemented WSDLs into Dashboards.
• Creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution
• Transformed Tableau into a managed service offering for consumption across marketing teams.
• Hands-on with creating solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop versions 8.1 and 8.2.
• Migrated Business Objects environment from SAP Business Objects Enterprise 6.5 to XIR2 and also from XIR2 to XI 3.1 XI 4.0 and from XI 3.1 to XI 4.1
• Involved in the planning, sizing, installation, configuration, monitoring of SAP Business Objects Enterprise XIr2/3.1/4.0/4.1 on Windows and Unix platform.
• Hands on experience in administering, monitoring and troubleshooting BO servers.
• Solid understanding of Business Objects Enterprise servers, CMC.
• Proficient in creating users and user groups, restricted access of the users and managing user groups, folders and published reports using Central Management Console.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Strong work experience with SAP Business Objects 6.5, XI R2, 3.1, 4.0, 4.1 Enterprise Architecture, Webi, Crystal Reports XI, 2008 , Web Intelligence Rich Client, Xcelsius, Performance Manager Dashboards, KPI's ,Live Office, QaaWS, Teradata, Oracle, SQL Server.
• Well-versed in implementing and configuring the SSO with Windows NT/AD and migrating Crystal Reports, WEBI Reports and DESKI Reports using Import Wizard, Copy Data Source and Life Cycle Manager. Worked with SAP BO SDK of both Java and .NET and configuring of IIS 6.0, Tomcat 5.5. Adept at performance testing and capacity planning. Assisted in implementation of Enterprise Data Warehouse and Data Marts, dimensional tables Star Schema with identification of measures and hierarchies.
• Experience on WAS with BO cluster communication using TCP/IP.
• Experience in working ITIL based service organization.
• Experience in complex BI Reports, Dashboards, Project Management, Change/Incident Management
• Analytical thinker and good problem solving skills with good oral and written communications skills. Ability to adapt quickly in the environment and possesses flexibility in working hours.

TECHNICAL SKILLS:

BI Tools: Tableau 7.0, Tableau 8.2, Business Objects XI3.1-R2/6X,4.0,4.1, CMC, Import Wizard, Copy Data Source Conversion tool and repository monitoring tool, Upgrade Management Tool, Information Design Tool, Universe Designer, WEBI, Xcelsius, Performance Manager Dashboards, KPI's ,Live Office, QaaWS, Web Intelligence Rich Client, SAP BW, Supervisor, Crystal Reports 10/2008, Desktop Intelligence.

Operating System: Windows 98, Windows NT, Windows 2000, Windows 2003, Windows 7, UNIX/AIX/Solaris.

Reporting Tools: Tableau 7.0, Tableau 8.2, SAP Business Objects 5.1.7, 6.5, XI r1, XI r2, 3.1, 4.0, 4.1 , Crystal Reports, WebI, Desktop Intelligence, Business View Manager, BCA, SSAS, Cognos 8

Languages: SQL, PL/SQL

Database: Oracle9i, Oracle 10g, Oracle 11g, SQL Server 2000, 2005 , Teradata, MS Access, Netezza

ETL Tools: Genio Designer, SSIS, DTS

Other tools: TOAD 8.5, MS Office, SQL Plus, SQL Assistant

CASE Tools: Microsoft Visual Source Safe, PVCS, Version Manager

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Objects Lead Consultant

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and store spend analysis.
• Generated KPI for customer satisfaction survey results.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. Published Workbooks by creating user filters so that only appropriate teams can view it.
• Creating Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau users.
• Maintained Test log and Wrote test Evaluation, Summary Reports
• Performed requirements gathering, analyzing BO 3.1 reports and collating inputs into BI 4.1 and worked on estimates, impact analysis, development, UAT, production and post-production support.
• Created Dash boards for the top level Management like the Trend Analysis, What-if Analysis using the data visualization and infographics.
• Exported Xcelsius to repository to make it available for users through BI launchpad.
• Created WSDLs using Query as a Web Service Qaaws from different Data sources and implemented WSDLs into Dashboards.
• Implemented Open Doc to drill down to detail webI report from Xcelsius Dashboard.
• Migrated/Upgraded 1000 reports Crystal Reports/WEBI/DESKI /universes, from BO XIR3.1to XI 4.1 using Import Wizard/Copy Data Source/Upgrade Management Tool approach.
• Involved in managing users, groups, folders and published reports using Central Management Console.
• Converted few reports from DESKI to WEBI using the report conversion tool. Involved in the deployment of the reports across different environments using Life Cycle Manager. Was responsible in restructuring of the Security in BO 3.1 before migrating to BO 4.1. Involved in Planning and implementing patches and hot fixes as and when required.
• Involved in implementing and configuring the SSO with Windows AD using NTLM, Kerberos and Siteminder Authentication.
• Responsible in maintaining the Server Intelligence Agent SIA which contains the Central Configuration Manager CCM .
• Setting up the security based on the different Access Levels ACL's in BO 4.0/4.1. Implemented the Folder Level Security in BO 4.0/4.1.
• Worked extensively on the metadata CMS tables like CI Infoobjects, CI SystemObjects using the Query Builder.
• Worked on developing Backup, Replication and Disaster Recovery Plan.
• Worked on scheduling of reports in BO 3.1/4.0/4.1 based on Events, Calendars.
• Performed fine tuning of the job servers for improving the performance of the scheduled jobs.
• Responsible for configuring the SMTP/FTP servers on the job servers by coordinating with the System administrators.
• Coordinated with users to know the business usage of their reports that exists in their favorite's folder and explained them the need to move the reports to the central repository.
• Implemented the report bursting mechanism on the 4.0/4.1 reports using the BI publications.
• Responsible for SQL tuning and optimization using Explain Plan, TKPROF, Indexes and optimizer hints.
• Customized the Infoview of 4.0/4.1 by changing the preferences. Maintained the CMS DB as well as the different services in CMC of 4.0/4.1.
• Responsible for the configuration of IIS 6.0, Tomcat 5.5.
• Worked on the web content folders of both Java and .NET versions for configuring opendoc links, hyperlinks, SSO.
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Extensively used breaks for white spaces and sections for better navigability.
• Created the Web I reports using Business Objects functionalities like Queries, Slice and dice.
• Tested all the reports with different scenarios like query balancing, look and feel and formatting of the reports based on the specifications.
• 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.
• Provided end user and production support after deploying the application into the production environment.

Skills Utilized: Windows 2003/ Windows 7 Server, Tableau Desktop 8.1 and 8.2, Tableau Server 8.1 and 8.2, BO XI R3.1, BO XI 4.0, BO 4.1, Crystal Reports Enterprise, Web Intelligence, CMC, Xcelsius, Performance Manager Dashboards, KPI's ,Live Office, QaaWS, Tableau Data Extract TDE , Upgrade Management Tool, SQL Server2008, Oracle 11g

Confidential

Sr. Business Objects Administrator

Responsibilities:

• Worked on the analysis phase of the migration from SAP BO 3.1 hosted on Windows environment to SAP BI 4.0 hosted on Windows and Linux environment.
• Migrated the BO 3.1 WEBI and Crystal reports from 2 different environments to a single BI 4.0 environment.
• Worked on the installation and testing of the BI Mobile, Live Office and BI Explorer.
• Restructured the entire security model in BI 4.0 due to the organizational changes in bringing two divisions together by creating Custom Access Levels in the CMC.
• Tested all the WEBI, Crystal reports with different scenarios like query balancing, look and feel and formatting of the reports based on the specifications.

Skills Utilized: Windows 2003/ Windows 7 Server, Solaris, BO XI R3.1, BO XI 4.0,Crystal Reports 2011, Business View Manager, Web Intelligence, Info View, CMC, Xcelsius, Performance Manager Dashboards, KPI's ,Live Office, QaaWS, Upgrade Management Tool, Information Design Tool, Repository monitoring tool, Web Intelligence Rich Client, Netezza

Confidential

Sr.Business Objects Administrator/ Lead Developer

Responsibilities:

• Worked on full life cycle of the project including requirements gathering, prototyping, Effort estimate, Impact analysis, development, UAT, Production and Postproduction support. Migrated several reports/universes from BO XIR2 to XIR3.1 using Import Wizard and converted Desk I to WEBI reports using Report Conversion tool. Imported/ Exported the Universes from/ to repository to make them accessible to end-users.
• Handled the Audit Database of the SAP BO Enterprise system. Worked on performance tuning of the reports and monitoring of AIX servers/platforms.
• Customized the Infoview of 3.1/4.0 by changing the preferences. Performed in maintaining the CMS DB as well as the different services in CMC of 3.1/4.0.
• Responsible in maintaining the Server Intelligence Agent SIA which contains the Central Configuration Manager CCM .
• Performed in integrating the third party application with the BO reports using the JAVA SDK code. Worked on developing Backup, Replication and Disaster Recovery Plan.
• Performed fine tuning of the job servers for improving the performance of the scheduled jobs.
• Worked on scheduling of reports in R2 as well as BO 3.1/4.0 based on Events, Calendars.
• Responsible for configuring the SMTP/FTP servers on the job servers by coordinating with the System administrators.
• Coordinated with users to know the business usage of their reports that exists in their favorite's folder and explained them the need to move the reports to the central repository.
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Extensively used breaks for white spaces and sections for better navigability.
• Created the DESK I and Web I reports using Business Objects functionalities like Queries, Slice and dice.
• Tested all the reports with different scenarios like query balancing, look and feel and formatting of the reports based on the specifications.
• 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.
• Provided end user and production support after deploying the application into the production environment.

Skills Utilized: Windows 2003/ Windows 7 Server, Linux, BO XI R2, BO XI R3.1, BO XI 4.0,Crystal Reports 2011, Business View Manager, Desktop Intelligence, Web Intelligence, Info View, CMC, Xcelsius, Performance Manager Dashboards, KPI's ,Live Office, QaaWS, Upgrade Management Tool, Information Design Tool, Repository monitoring tool, Web Intelligence Rich Client, SQL Server2005, Oracle 9i, Oracle 10g, Oracle 11g

Confidential

Sr. Business Objects Administrator/Lead Developer

Responsibilities:

• Converted few reports from DESKI to WEBI using the report conversion tool. Involved in the deployment of the reports across different environments using Life Cycle Manager. Was responsible in restructuring of the Security in BO R2 before migrating to BO 3.1. Involved in Planning and implementing patches and hot fixes as and when required.
• Involved in managing users, groups, folders and published reports using Central Management Console.
• Worked on the implementation of full project lifecycle starting from planning, sizing, installation, configuration of BO 3.1. Performed requirements gathering, analyzing R2 reports and collating inputs into 3.1 and worked on estimates, impact analysis, development, UAT, production and postproduction support.
• Created Web Intelligence and Desktop Intelligence reports with multiple data providers like Universes, Personal Data Files and free-hand SQL and published them to corporate repository to share the resources between the user communities.
• Worked in the designing and building of Universes, Classes and Objects for casino management warehouse. Designed, Developed and Maintained Universes by defining joins, cardinalities between tables applying contexts and alias tables to remove cyclic dependencies.
• Created complex reports using complex variables, multiple breaks, sorts, cascading prompts, decode objects etc. Extensively used breaks for white spaces and sections for better navigability. Tested business objects reports for data validation and compared results with DB. Responsible for SQL tuning and optimization.
• Tested all the reports with different scenarios. Provided end user and production support after deploying the application into the production environment.

Skills Utilized: Windows 2003, Solaris, BO XI R2, BO XI R3.1, Desktop Intelligence, Web Intelligence, Info View, CMC, SQL Server 2005, Genio

Confidential

Sr. Business Objects Administrator

Responsibilities:

• Worked on the functional architecture of the project. Interacted with Business Users to know their Business needs to effectively develop and modify Universes and Reports.
• Created Web I reports with multiple data providers and synchronized the data using merge dimension option in BO XIR3.1. Tested business objects reports for data validation and compared results with SQL Server 2005.
• Linked reports using Open Document syntax to link master report to a detail report by creating hyperlink objects in the Universes and Reports.
• Performed in creation of reports with different functionalities like Dynamic cascading prompts, drill down, linking reports, charts and graphs, ranking and alerts.

Skills Utilized: Windows 2000, BO XI R2, SQL Server 2005, MS Access

Confidential

Business Objects Administrator/Developer

Responsibilities:

• Responsible for the assessment, consist of interviews with key business users who clearly articulated their current stock of business objects reports and usage both in the central server as well as adhoc reports created by them and stored in their common drives.
• Performed in migration path alternatives to XIR2 and the required steps to complete the migration from BO 5.1.7 and XI R1 to one single instance of XIR2. Developed a recommended strategy for migration from BO 5.1.7 to XIr2 and BO XI R1 to XIr2
• Confirmed that the hardware and software infrastructure e.g., equipment, OS, RDBMS, Web Servers and Application Server technology is sufficient to complete migration to XIr2 and to handle the forecasted growth of the system
• Worked on statements of work for all the required migration projects that need to be performed. This would include the planning and execution of the BO 5.1.7 and BO XI R1 migration effort to XI R2. Obtain recommendations of other work or projects that need to be performed and their dependencies on the migration effort

Skills Utilized: Windows 2000, BO 5.1.7, BO 6.5, BO XI R1, Oracle8i, Oracle 9i, Oracle 10g, SQL Server 2000, MS Access

Confidential

Business Objects Administrator

Responsibilities:

• Responsible for the evaluation of current user access requirements and migration plan for the consolidated instance and create/modify the project plan and re-visit the Estimation. Designed and development of the Universe in Business Objects to modify universe structures by creating new Objects / Modifying existing objects based on functional requirements
• Created of reports in Business Objects and Web intelligence based on functional requirements. Migration of securities, Universes and reports from BO 6.5 to BO XI. Performed in debugging the queries between the BO 6.5 and BO XI reports for the data mismatch.
• Worked on the Supervisor of BO 6.5 and changing the Object level Securities in the Universe. Responsible for the Unit and System Integration testing of the reports.
• Responsible for scheduling of reports. Played the role of Module lead in the conversion of the DESKI reports to WEBI. Prepared test scripts for Unit, SIT, UAT and Migration testing. Responsible for the review, validation the project deliverables to get the signoff.
• Responsible in communicating with the clients regarding the requirements and acted as a Module lead from Onsite. Performed in the Unit and Integration Testing to meet the requirements.

Skills Utilized: Windows 2000, BO 6.5, Supervisor, Oracle9i, Windows 2000, BO 6.5, BO XI R2 DESKI, WEBI , Oracle10g