SUMMARY

• More than 6 years of IT experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6/7/8.
• Strong experience in SQL Server development, System Analysis, Design, Development and Support of MS SQL Server 2012, 2008, 2005 and 2000.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Extensively worked on Tableau 6.x/7.x/8.x (Desktop, Server, Mobile, and Public), Micro Strategy.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Expert in creating universes on OLAP SAP BW, Oracle, SQL server, DB2
• Extensive knowledge on visualization of data and knowledge of tools such as tableau.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts etc... Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on different table calculations for different Scorecards.
• Published dashboards on Tableau public.
• Worked closely with Tableau support team during tableau server upgrades to 8.1
• Worked on data blending and increased the dashboard performance by extracting data.
• Worked on Data Model design, Data Extraction, Transformations and Loading, Mappings & Workflows, Customized Analytics Reports.
• Broad experience in resolving universe issues like Loops and Traps using Alias and context.
• In - depth knowledge in building/maintaining Repository and creating adhoc reports.
• Working in both Semantic layers of Business objects like Universes and Business views as Data source for Crystal reports.
• Exposure with Advanced Analytics using SAP BO Explorer.
• Highly Proficient in Agile and Waterfall software development life cycle.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

Programming Languages: MySQL, XML, Oracle

Business Intelligence tools: Tableau, Business Intelligence Development Studio (SSIS/SSRS), Informatica Power Center 7.1/8.6/9.1, and Crystal Reports 2008 XI.

Data Base: Server 2000/2005/2008/2008 R2/2012, MS Access

Operating Systems: XP, Windows NT / 2000. Windows Server 2003/2008/2008 R2, Linux

Reporting Tools: Tableau 8.x, Excel

SDLC tools: Perforce, HP Quality center

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Sr. Tableau Report Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for BML eBay & PayPal. Worked on various data sources such as Oracle, SQL Server.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and dashboard using KPI’s.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 7.0 in Dev, QA, and Prod environments.
• Installed patches on the server and documented upgrade plan from tableau 8.0 to 8.1
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop Expert in generating complex, dashboard reports, adhoc, business views along with user acceptance test and data accuracy test.
• Access dashboards from any browser or tablet.
• Created incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Converted existing Crystal Reports and Xcelsius into Tableau Dashboards
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, SQL developer, SQL 2008,Oracle 10g, DB2, Microsoft Excel 2007, MS Access, Teradata, ETL, Windows 2007 server, Microsoft office 2007, Business objects 4.0.

Confidential, Detroit, MI

Tableau Developer

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Expert in info graphics and Dash boarding for data visualization.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Involved in license management SLA's with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Defined best practices for Tableau report development.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Provided 24/7 production support for Tableau users.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Experience in providing Tableau server and tableau desktop training.

Environment: Tableau Server v6/v7, Tableau Desktop v6/v7, Windows Server Standard, Clear case, Oracle 11i, Excel, JAVA, J2EE, ETL, Tomcat., UNIX.

Confidential

Tableau Reports Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development lifecycle.
• Installation, maintenance and administration of Tableau Servers.
• Experience in Marks, Publisher and Security.
• Experience with creating Worksheets, Dashboarding and infographics.
• Working with Multiple data Connections.
• Used Snow flake and Star Schema Designs for data modelling.
• Experience with troubleshooting.
• Experience in tableau created Rapid Analytics and Reporting.
• Experience with Tableau for Data Acquisition and data visualizations for client and customers.
• Involved in Custom Geocoding.
• Expertise in Tableau Analysis.
• Experience in BI interactive Dashboards and Tableau Publisher.
• Experience in developing Dashboard using OLAP cubes.
• Experience of Client-Interaction on onsite/Offshore.
• Involved in Test Evaluation, Summary Reports.
• Live, optimized connections to Teradata to leverage the investments.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Server 6, Tableau Desktop 6, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008 SSAS, Oracle 11i, Sybase, Crystal XI, Info view, ETL, Excel, JAVA, J2EE, Tomcat., UNIX.

Confidential

Tableau Reports/Business Objects Developer

Responsibilities:

• Designed and developed Universes by defining joins, cardinalities between tables, linked the existing Universes using Business Objects.
• Created Aliases, Multiple contexts for catering different functional areas in a single user query.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports
• Interacted with the Business Users to analyze the business process and gathered the requirements made necessary changes to schema objects to fulfill their reporting and business needs.
• Experience in universe migration across repositories
• Performed queries to fetch new data, and create reports in Business Objects 6.5 by connecting to Oracle Data Sources
• Created various reports like Master/Detail reports, Cross Tab reports, Slice and Dice reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created complex reports using multiple queries and sub queries.
• Used calculations, variables, breaks, sorting, filters, alerts and prompts while developing and creating reports.
• Involved in migrating reports and universes from 5.x to 6.5 and WebI reports using the report migration utility.
• Created and maintained Business Objects & Web Intelligence reports
• Created reports based on PL/SQL
• Published existing reports to corporate intranet through Web Intelligence.

Environment: Business Objects 6.5.1, Informatica Power Center, Oracle 9i, Windows XP, Win 2000 Server, Sun Solaris 2.8.