SUMMARY

• Having 8+ years of experience in design, development, implementation, and administration of Database, Business Intelligence tools and ETL tools.
• 4+ years of experience in Tableau Enterprise Environment, with versions 7.0/7.1/8.1/9.0
• Developed Tableau data visualization using Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Mastered in different Formatting techniques, using Annotations and Mark labels.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Experience in custom Geocoding.
• Experience in creating and scheduling tableau data extracts for auto refresh.
• Created different KPI's using Table calculations and calculated key figures (Manipulating strings, arithmetic calculations, aggregation options and Logical functions)
• Familiarity with best practices around visualization and design.
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies and sets.
• Good understanding on Tableau Server, Tableau Reader, Tableau Online and Tableau Public.
• Experience in Installation, Configuration and administration of Tableau Server in a multi - server and multi-tier environment.
• Extensive experience on building dashboards in Tableau and Involved in Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Good understanding of Data warehouse design and dimensional modeling.
• Expertise in Data Warehouse development working with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Data Integrator with DB2 UDB, Oracle, and SQL Server.
• Hands on experience in SQL & PL/SQL.
• Expertise in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Good knowledge of System Development Life Cycle (SDLC), Agile (scrum) and Waterfall development environments.
• Excellent interpersonal and customer relationship skills.
• Ability to handle multiple tasks and work independently as well as in a team.

TECHNICAL SKILLS

BI Reporting/ETL Tools: Tableau Suite of Tools 9.0/8.1/7.1/7.0 which includes Desktop, Server, Online and Public and Administration of Tableau Server, Informatica Power Center

Prog. Languages: SQL, PL/SQL, C and C++

Databases: Oracle 11g/10g/9i, MS SQL server 2012/2008, MS Access

Operating Systems: UNIX, Linux, and Windows

Other Tools: JIRA, TIDAL, Rally, Toad, SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Tableau Developer/ Administrator

Responsibilities:

• Actively involved in business requirements gathering from end users and business analysts.
• Created visualizations reports on sales quotas, attainments and performance on various categories to ascertain the overall sales effectives of each program.
• Developed benchmark ticket price for each market to understand the quality of discounts offered.
• Created report using dual axes to show the gap in performance.
• Responsible for analyzing functional Specs and preparing technical specifications per business needs.
• Installed Tableau Server 8.0 in Dev, QA, UAT and Prod environments, upgraded Tableau 8.0 environment to Tableau 9.0.
• Defined and created procedures to install Tableau desktop in silent mode.
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Created Executive Dashboard Scorecard that provides high level information on ticket sales by different Locations and demographics.
• Created story showing the performance of movies in theaters by citys.
• Developed reports for different sales management hierarchies.
• Created analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• Expirenced in Implemented Data blending to pull data from multiple data sources to compare ticket sales of a movie vs other comparative movies and Genre.
• Developed a POC for User security and implimneted aon the dahsbords to filter the data dynamically based on the user login
• Created internal sales dashbords to compare the revenue and sales across WoW, MoM and QoQ for trend analysis.
• Used joins and applied filters to limit the data sourced into report.
• Created views using various axes like Individual Axes, Dual Axes.
• Used Trend Lines, Reference Lines, box plots and Annotations to describe the data.
• Created Data extracts for better performance and accessing data offline.
• Used parameters and input controls to give users control over certain values.
• Developed Custom Geo-coding for organizational territory alignment requirements.
• Created and Published Tableau Dashboards into Tableau Server.
• Write SQL queries for data validation and data integration where necessary.
• Created incremental refreshes for data sources on Tableau server.
• Work closely with DBA's and ETL teams to meet reporting requirements and improve performance.
• Evaluate live vs extracts connections based on data size and performance requirements.

Environment: Tableau Desktop 8.1/9.0, Tableau Server 8.1/9.0, MS SQL 2016, Oracle 11g, UNIX, MS Access, JIRA, Rally, SQL Developer, MS Excel

Confidential, Houston, TX

Tableau Developer/ Administrator

Responsibilities:

• Involved in business requirement gathering and technical specifications document design.
• Created report on sum of sales for each product name about region.
• Created sum of parts quantity used for each description broken down by machine and parts number vs department date and time quarter and total meter.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
• Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.
• Involved in Installation and upgrade of Tableau server and server performance tuning for optimization.
• Used filters on Date, Assigned to, Priority, Originated from, Property Name, Request Type, State, Sub type and Status.
• For the Performance issue sum of the records broken down by Response Time, Completion Time, and Work Order Volume.
• Created dashboards according to user specifications and prepared stories to provide an understandable visions.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weeklyand monthlyincrementsbased on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user groupdiscussions.
• Worked with testing and production teams for validation and deployment.

Environment: TableauDesktop 7.0/8.1,TableauServer 8.1,MS Office Suite,Oracle, MS SQL Server2000, JIRA, SQL Developer.

Confidential, Franklin, TN

Tableau Developer

Responsibilities:

• Involved in designing and development of tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Creating different types of visualizations on order size vs variance, setup time, run time, downtime, and production for process and production analysis
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Monitoring all relevant production data from a single dashboard.
• Building, publishing customized interactive reports and dashboards, report scheduling using tableau server. Creating New Schedule's and checking the task's daily on the server.
• Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Create and run Batch files on regular basis.
• Creating New Schedule's and checking the task's daily on the server.
• Created number of database Triggers according to business rules using PL/SQL.
• Build complex reports to be re-used by refreshing data that contained advanced calculations, parameters, action filters and table calculations.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel.
• Creation of workbooks and dashboards those are accessible on different environments like any browser or tablet. Developed dashboards for calendar year and fiscal year.
• Implemented new functionality to displays an Error Message on Dashboard when there is no data available.
• Set Up permissions for Tableau Views and Dashboards. Created Users, groups and projects.
• Created action filters, parameters and calculated sets and used URL's, Hyperlinks for preparing dashboards and worksheets in tableau.
• Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
• Effectively used data blending feature in tableauto get data from Access & MS Excel.
• Customized the Geo maps to use custom shapes and converted latitude/longitude sets to City/state using Reverse Geocoding utility.
• Wrote Custom SQL to fulfill user Requirements and used Parameters in custom SQL for the Dynamic prompts as requested by the end users.
• Participated in Preparing Detailed technical documents from the functional specifications.
• Published Reports, workbooks & data source to server and exporting the reports in different Formats.

Environment: Tableau Desktop 7.0, Tableau Server 7.1, Oracle 11g, MS SQL Server 2000, Unix, MS Access, JIRA, Informatica PowerCenter 9.1

Confidential, Chicago, IL

SQL Developer/Data Analyst

Responsibilities:

• Gathering functional requirements from business customers, analyzing and transforming them into technical specifications document.
• Worked on Full life cycle development (SDLC) involving in all stages of development.
• Created Database Objects - Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers,Stored Procedure, Constraints and Roles.
• Reduced report execution time by tuning the Stored Procedures and creating Indexes, Joins etc.
• Used various transforms in SSIS to load data from flat files, Siebel CRM and FTP to the SQL databases.
• Prepared Implementation Guide for Standalone Microsoft SQL Server 2008.
• Designed and developed data load jobs using SSIS package and scheduled in SQL Agent.
• Created Grouping, Sorting columns and writing expressions according to the business requirements.
• Developed tabular queries for efficient analysis of report using Pivot in T-SQL.
• Worked with T-SQL Scripts and established relationships between tables using Constraints.
• Designed, tested (unit testing and integration testing) and implemented stored procedures and triggers for data processing of huge volume of data.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Implemented High availability concepts, Data base Mirroring, Replication and log shipping.
• Provided index tuning as required for performance improvement of the applications (SQL tuning).

Environment: s: Oracle 10g, SQL Developer, Excel, MS Access, MS Excel, Toad, JIRA, Informatics power center

Confidential

SQL Developer

Responsibilities:

• Involved in gathering, analyzing and documenting business requirements, functional requirements and data specifications.
• Create tables, indexes, and stored procedures to load and maintain data.
• Develop file loading scripts for ETL teams and help validate data by writing SQL queries.
• Wrote Procedures and triggers in Oracle for file handling, data validation, Inserting data etc.
• Designed schema/tables to load data from different databases into single database, Oracle. This helped write queries against single database and perform data analysis.
• Involved with making changes to procedures and functions business requirements changed and carry out validation and verification of the reports
• Provide ad-hoc analysis for reporting teams.
• Perform peer code/testing reviews.
• Create test scripts and document test results.
• Migrate code to higher environments and help deploy code into production.

Environment: s: Oracle 9i, SQL Developer, Excel, Erwin, MS Access, MS Excel, Toad.