SUMMARY:

• Over 15 plus years of experience in IT Industry with 9 years as Data Analyst, Reporting Analyst for Data Visualization on Tableau 10, Tableau Desktop, Tableau Server and SAP Business Objects 4.1, XI R3.1/XIR2/6.5, BO 4.1 UDT(Universe Design Tool),BI Launch Pad, IDT(Information Design Tool) worked on Universe Designer, Web Intelligence (Webi), Desktop Intelligence (Deski), Info View, CMC (Central Management Console ), CCM (Central Configuration Manager),Supervisor,Publication,Broadcast Agent, Import Wizard, Dashboards and Crystal Reports, Xcelsius 2008, Tableau, Live Office, SQL, Oracle 7.3, 8, 9i, 10g, 11g, PL/SQL Scripts Server 6.5,7.0,2000,2005,2008, Transact - SQL (T-SQL), MS Access, Excel, VBA,Macros
• Over 6 years of experience in Data Visualization with Tableau Desktop, Tableau Server and Tableau Online in various versions of Tableau 10,9,8,7 versions. Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the potential revenue change, destinations flown cross different geographic markets, time-series statistics for price variance across different vendors, heat maps for shopping activities across business units. Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform
• Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects.
• Experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive dashboards with Page and dashboard Prompts.
• Experience in creating different visualizations using Bar, Line and Pie chart, Background Maps, Box plots, Scatter plots, Gantt charts, Bubble charts, Histograms, Trend lines & statistics, Bullets, Heat maps and Highlight tables.
• Efficient management of Tableau Server by managing & setting permissions, publishing various data sources and workbooks to Tableau Server.
• Extensive experience in preparing dashboards using calculated fields, parameters, actions, groups, sets and hierarchies in Tableau Desktop and defined best practices for Tableau report development.
• Hands-on experience with SQL scripts like stored procedures and data validation.
• Experienced in creating Universe Designer in development process created classes, objects, measures, join conditions, Filters, checking cardinalities, defined hierarchies, checking the integrity of the universes. Used contexts, aliases, shortcut for resolving loops of the Universes and exported the universe to repository
• Experience in Installation, Configuration, Administration and Security of SAP Business Objects, Crystal Reports, Web Intelligence, Xcelsius
• Reported KPI's to internal and external account managers, directors, and senior management on a daily, weekly and monthly basis.
• Extensively worked on Web Intelligence used advanced reporting functionalities such as Master Detail, Cross-Tab, Drill, Filters, Ranking, Graphs, Breaks, Alerts, filters, Prompts, Variables, Formulas, calculation Contexts in building reports, multi-tab report and Scheduling of the reports etc.
• Developing complex universes by using advanced features in SAP Business Objects like Lov’s, prompts and resolving the loops using aliases and contexts.
• Extensive experience in Migrating Business Objects 6.5.2 to BO XI R2, BOXI 3.1
• Excellent Knowledge with Star Schema and Snow Flake Schema Data Models
• Installing Business Objects BI4 & BOXI 3.X server as Administrator, configuration of BO tools, set up and maintenance of Business Objects Enterprise environment, creating and managing groups and user profiles.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)
• Worked on Cognos 10.2 suite, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio and Framework manager
• Experience in VBA for MS Access, Excel (Macros), pivot tables, vlookup and macros
• Data Warehouse and Data Mart Design and (Ralph Kimball) Data Warehouse architecture
• Worked on OLAP (online analytical processing) and OLTP (online transaction processing)
• Experienced on Remedy Incident Management, Change Management, Problem Management, Asset Management, SLA and Advanced Health & Care for Business Objects reporting
• Creating dashboards in line with analytical uniformity using the Advanced Analysis of Tableau Desktop, organizing Dashboard views, objects
• Worked on ITSM Universe to build reports using Web Intelligence and Desktop intelligence
• I have given Interview on BBC World Service Radio, London, UK i.e. 7th February 2003 at 10:45, live discussing on German Confidential site Google 'death penalty', how to get companies onto top of the listings(organic) on Search Engines like (Google, Yahoo, MSN), how to get popularly ranked and improve their presence on search engines.
• Brainbench certified in Active Server Pages (ASP), VBScript 5.5, HTML 4.0, Microsoft Visual InterDev 6.0, Visual Basic 5.0,6.0 (VB)and Microsoft Internet Information Server (IIS) 4.0 etc.
• Excellent documentation and writing skills
• Certified in Aviva Business Protection and in Aviva Anti-Bribery and Corruption
• Worked on Oracle Applications R12/11i as a Technical Consultant. Worked full life cycle implementation experience of ERP (Oracle Application R12/ 11i) Technical (GL, AP, AR, INV, PO, OM) and exposure to functional as well
• Worked on Oracle PL/SQL and SQL Server T-SQL programming Stored Procedures, functions, Triggers, Packages, SQL Scripts etc.
• Preparing the MD070 and MD0120 Documents after completion of the component and CV60, MD70 using AIM 3.0.
• Worked as Business Development Manager managed over 15 members of the SEM team. Primarily working on SEO and Internet marketing taking care of clients Sponsored Ads, Search Marketing, Link Building, and optimization
• Created dashboards in Google Analytics for ecommerce sites and Provided both internal performance reporting and web analytics
• Worked on SEO, Content, Link Strategies, Keyword Analysis and Pay per click (PPC).
• Involved in Software Testing, QA, Debugging, Manual and Black box and White box testing.

TECHNICAL SKILLS:

• SAP Business Objects (BI) 4.1, XIR3.1, R2,6.5, Designer, Desktop Intelligence (Deski), Web Intelligence (Webi), CMC (Central Management Console), CCM (Central Configuration Manager), UDT (Universe Design Tool), BI Launch Pad, IDT (Information Design Tool) Crystal Reports, Xcelsius 2008, Query Builder, Tableau, Live Office, Qlikview, QAAWS, Dashboards, Oracle, SQL Server, SQL, PL/SQL and Informatica
• ERP Oracle apps (Oracle Applications R12/11i Financials) and R12 Technical Consultant (GL, AP, AR, INV, PO)
• Oracle 7.3, 8, 9i, 10g, 11g, PL/SQL, SQL Server 6.5,7.0,2000,2005,2008, SQL, Transact-SQL (T-SQL), SSIS, SSRS, SSAS, Unix, MS Access, Developer/2000, Oracle Forms 4.5,6i, 10g(web), Visual Basic 5.0,6.0, ASP.NET, Oracle Reports 2.5,6i, Crystal Reports, Oracle Discoverer, TOAD, Excel, VBA Access, SQL*Loader, XML
• MS Active Server Pages (ASP), Cold Fusion 4.5, HTML, XHTML, VBScript, JavaScript and CSS, Microsoft Visual InterDev, Dream weaver MX, Microsoft Visual Studio, Microsoft Internet Information Server (IIS), FTP, Magic (frontend), FrontPage 2000, FoxPro, Cute FTP, MS Office Word, Excel, PowerPoint

CAREER HISTORY:

Confidential, Oakland/Pasadena, California

Tableau Developer

Responsibilities:

• Created Rich dashboards using Tableau Dashboard with metrics, attributes and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created visualization for decision support generated Dashboards with Quick filters, Parameters and preparing dashboards and worksheets in Tableau.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Delivering reporting for revenue cycle clients reports, Summary reports, dashboards, monthly reports such as Bar charts, 3D charts.
• Developed dashboards in Tableau Desktop on Metrics Mart and published them on to Tableau Server which allowed end users for decision support
• Developed Tableau data visualization using Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms and build dashboard using SQL etc.
• Building, publishing customized interactive reports and dashboards in Tableau, report scheduling using Tableau server.
• Developed Tableau dashboards to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Confidential, Alameda, California

Business Intelligence Report Developer / Tableau Developer

Responsibilities:

• Created dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights and clear visualizations of various KPIs
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps
• Developed OPC Dashboard and G&A Dashboard for decision makers
• Performed Tableau Server Admin duties that comprised configuration, adding users, groups, data connection, scheduling tasks on Tableau Server.
• Developed complex reports in Webi Cross tab, Charts, Drill through and ad-hoc reports using BO Web Intelligence.
• Designed and developed the most suitable user interface such as Tableau dashboards, multiple charts types, trends

Confidential, Oakland, California

Tableau Developer/ Report Developer

Responsibilities:

• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Delivering reporting for revenue cycle clients reports, Summary reports, dashboards, monthly reports such as Bar charts, 3D charts.
• Partner with business analysts to understand requirements, source systems, and perform data analysis
• Worked with the Business users to understand report requirements based on existing reports/dashboards in source systems and other teams on dependencies, timelines, testing, and technical delivery.
• Prepared Business Requirement Document and converted business requirements into Technical Specification documents.
• Worked closely with business power users to create reports/dashboards using Tableau Desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Performed Tableau Server Admin duties that comprised configuration, adding users, groups, data connections, scheduling tasks in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server
• Creating dashboards in line with the analytical uniformity using the Advanced Analysis of Tableau Desktop, and organizing Dashboard views and objects
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting in Tableau, Business Objects
• Created and developed Parameterized, Drill Down and AD Hoc Reports in Tableau
• Worked on designing, developing on new report in Tableau based on legacy reports
• Developed reports in Tableau, Business Objects reports Revenue cycle decision support
• Responsible for creating reports using Webi (Web Intelligence) and Dashboards
• Developed complex reports in Webi standard reports, ad hoc reports. Setting up report schedules daily, weekly and monthly

Confidential

Tableau Developer/ Business Objects

Responsibilities:

• Participated in admin activities including improving the scalability of the Tableau Server environment by distributing server components across several machines.
• Configured distributed Tableau Server environment for real-time replication and failover support.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data connections, scheduling tasks on Tableau Server
• Developed formatted and complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, and multiple grouping reports in Tableau.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Involved in designing, developing, maintaining new and existing universes by required tables, creating joins and checking cardinalities responsible for creation of the universe with classes, objects and condition objects.
• Responsible for creating reports using Webi (Web Intelligence), Desktop Intelligence and Dashboards
• Delivering reporting for company clients Monthly reports, Summary reports, Detail reports, created graph reports such as Bar charts, 3D charts and Pie charts.
• Developed complex reports in Webi standard reports, ad hoc reports. Setting up report schedules daily, weekly and monthly
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the organization.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, custom requests for Excel Export
• As Business Objects Administrator managing users and groups, including access rights and security, instance manager on BO Central Management Console (CMC) and monitoring BO services
• Developed report using Desktop Intelligence (Deski) Free-hand SQL report and Ad Hoc report developed in Webi
• Installed Business Objects XI 3.1 Enterprise Suite on Windows 2003 server on SQL Server, complete backend server administration from installation to deployment
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Generated Tableau Dashboard with quick, context, global filters, parameters and calculated fields on Tableau reports.
• BO Administered users and groups using LDAP authentication and monitor server activities using Auditor
• Prepare Dashboards using calculations, parameters in Tableau.
• Deployed all the reports and deployed on production environment.
• Trained end users to use Infoview with various functionalities of Business Objects and provided support.
• Interfaced with business users to prepare and update Business Requirement Documents ( Confidential ).
• Ensured all requests complied with corporate SDLC Policies and guidelines.
• Build reports based on Remedy environment as well

Confidential

Senior MI Analyst/MI Manager

Responsibilities:

• Created Universe and Developing Canned/Ad-hoc Reports, Scheduling and processing of reports.
• Experience with universe designer, desktop intelligence, web intelligence, analytics, Xcelsius and dashboard development tools
• Developed Tableau data visualization using Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Responsible for SAP BO administration and security activates related to the project.
• Extensively used Business Objects reporting functionalities such Slice and Dice, Drilled, Filters, Ranking, Sections, Graphs and Breaks and creating Xcelsius Dashboards
• Developed complex reports in Webi Cross tab, Charts, Drill through, Master-Detail and Cascading and ad-hoc reports using Report studio.
• Worked on Congo’s report studio scheduling reports, filters, static prompt conditions and building Cognos reports using CDL Strata environment

Confidential

Data Analyst

Responsibilities:

• Responsible for understanding end user requirement and convert into functional requirement and develop reports
• Created complex Master/Detail, cross tab reports with different data providers using universe and free-hand SQL and implemented various functionalities like Breaks, Alerters, variables.
• Created the reports using Business Objects Crystal Reports inserting filters, sorting, ranking etc.

Confidential

Business Objects Developer/ MI Analyst

Responsibilities:

• Created Universe user objects including Dimensions, Details and Measures. Resolved the loops using aliases and contexts. Check the integrity of the Universes.
• Building, publishing customized interactive reports and dashboards in Tableau, report scheduling using Tableau server.
• Installed and configured SAP Business Objects XI 3.1 Enterprise Suite on Windows 2003 servers on SQL Server 2008, complete backend server administration
• Extensively worked on Web Intelligence used advanced reporting functionalities such as Master Detail, Cross-Tab, Drill, Filters, Ranking, Graphs, Breaks, Alerts, filters, Prompts, Variables, Formulas, calculation Contexts in building reports, multi-tab report and Scheduling of the reports etc.
• Developed reports in Webi from designing, development to production and scheduling reports through CMC or Info view on Daily, Weekly, Monthly scheduled reports.
• Experience in Installation, Migration and Administration of Business Objects
• Build Web intelligent report with daily scheduling in .csv format and place the .csv file on external remote server using .bat (batch file)
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Developed complex Reports using Webi like Cross Tab, Slice and Dice, Drilled, Functions, Master Detail and Breaks
• Responsible for creating universe and reports for policies, quotes and claims
• Created Multi tab reports in Webi for multiple requirements and applied different Webi functionality summary, filtering and specific prompt
• Developed report using Desktop Intelligence (Deski) Free-hand SQL report and Ad Hoc report developed in Webi using Excel data

Confidential

Business Objects Developer

Responsibilities:

• Involved in gathering the user requirement, analysing business requirements, gathering reporting requirements and prepare specifications document. This involved interviewing the business users and understanding the current reporting system.
• Created the SAP BO Universe and Reports using Deski, Webi
• Extensively used Business Objects reporting functionalities such as Master Detail, Slice and Dice, Drilled, Filters, Ranking, Sections, Graphs and Breaks
• Responsible for creating Dashboards using Webi (Web Intelligence)
• Involved in formatting reports, generation of charts as per user requirements.
• Generated various reports on Daily, Weekly, Monthly and Yearly basis.
• Created publications in Business Objects 3.1 to distribute mass user’s users Inbox (Microsoft Outlook) with data in the body.
• Successfully deployed all the reports and deployed on production environment.
• Developed and managed MS Access database and used generate reports using macros
• Developed reports in reports SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Developed dashboard reports using Reporting Services(SSRS), Report Model and ad-hoc reporting using Report Builder