SUMMARY

• Over (Nine) years of experience in design, development, implementation and administration of various Business Intelligence tools and expertise in implementing various functionalities of Data Warehouse
• Extensive experience using Tableau Server, Tableau Desktop and Tableau Public
• Experience in SQL Server development, Analysis, Design, Development and Support of MS SQL Server 2012, 2008 and 2005
• Proficient in Installing, Configuring and Administration of Tableau Server
• Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the business/client requirement
• Expertise in Tableau Data Extracts, Data Blending, Dashboard actions, Row Level Security etc.
• Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint
• Involved in publishing of various kinds of interactive data visualizations, dashboards and workbooks from Tableau Desktop to Tableau Servers
• Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters
• Experience in creating, filters, quick filters, data source filters, global filters, context filters and user filters
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop
• Experience in Data Modeling using Dimensional Data Modeling, Star Schema modeling, Fact, Measures and Dimensions tables, and Physical and Logical data modeling
• Experience in Alteryx for data preparation and generating automated tableau data sources and extracts.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)
• Experience in implementing Customized queries and advanced custom visualizations in Tableau.
• Experience in designing stunning visualizations using tableau software and publishing and presenting dashboards on web and desktop platforms
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services (SSRS)
• Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Detail-oriented problem solver, quick learner, and flexible team player
• Excellent skills in communication & collaboration, interest & ability to learn new technologies in short time

TECHNICAL SKILLS

• MS SQL
• Oracle SQL
• PL/SQL
• Tableau Desktop
• Navicat Data Modeler
• PC Installations and Configuration
• MS Office Suite
• Process Documentation
• MS Visio
• Windows 2008
• Windows 2000/2003 Server
• UNIX
• Linux
• Tableau
• Toad
• OEM
• Citrix
• Reflections for Unix
• Business Objects
• Oracle 11g/10g/9i/8i/8
• MS Access
• MySQL
• UML
• RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Tableau Developer

Responsibilities:

• Developed Outside plant status report for regional officers to know the status of HFC construction, HFC miles and passings.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.
• Interacted with the existing database developers and DBA to understand the existing schema.
• Performed data preparation for tableau workbooks using Alteryx and Sandbox tables.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Prepared dashboards using calculation fields, parameters and Action Filters.
• Created visualizations for Polaris job usage report to know the number of jobs across all the divisions and regions.
• Developed dashboards to show survey, design, construction and information to field contractors
• Developed Construction Detail report, where all the construction information like nodes, footages and passages can be viewed all together.
• Created Hyper build report where we can get all the open tasks, estimated cost and jobs.
• Modified existing reports to remove duplicate footages for all construction reports.
• Created Polaris financial reports, forecasting reports, capital tracking reports.
• Implemented Row Level Security for all the divisions.
• Scheduled extract refresh for daily, weekly and monthly reports.

Environment: Tableau Desktop 9.2/10.1, Tableau Server 9.2/10.1, MS Excel, PostgreSQL, DBeaver, Alteryx/Tableau Performance Recorder.

Confidential, Columbus, OH

Tableau Developer

Responsibilities:

• Requirement gathering and analysis for HR Analytical Reports and Dashboards
• Maintain Data Extracts and perform Data Blending to prepare data for data analysis and reporting
• Combined various data sources into single source of truth using data prep tools like Alteryx.
• Point of contact for Tableau related HR reporting implementations.
• Publish and distribute dashboards via Tableau Server.
• Support and Maintain Tableau reporting solutions.
• Design and Development of Tableau Visualizations like Succession dashboards, My Career dashboards.
• Dashboards will help understand the talent Confidential have today.
• Manage risks created by leadership vacancies.
• Drive accountability for developing Confidential leader.
• Ensure leadership pipeline is ready to accomplish Confidential ’s current and future strategies.
• Created Internal Workbooks, for My career - content specific (Education, Professional memberships, Skills & Expertise, License & certifications, Assessment)
• Experience with creation of user, groups, projects, workbooks and appropriate permissions sets for tableau server logons.
• Scheduled data extracts on weekly basis.
• Developed various types of charts and graphs like donut charts, funnel charts, bar charts, line graphs, pie charts.
• Created groups with users in tableau server.
• Created customized and interactive dashboards (data from multiple data sources).
• Created workbooks with complex calculation fields, parameters, filters, sets.
• Created actions in worksheets and dashboards for interactivity and to compare data against different view.
• Implemented user level security with Tableau Sets to restrict leaders to see their corresponding department information.

Environment: Tableau Desktop 9.2/8.3, Tableau Server 9.2/8.3, MS Excel, Oracle11g, Oracle SQL Developer, Alteryx, Tableau Performance Recorder.

Confidential, Fairfax, VA

Tableau Developer

Responsibilities:

• Responsible for requirement gathering and analysis and in charge of providing LOE for Tableau reports and dashboards
• Developed Travel and Expense dashboards for Confidential employees
• Confidential uses Travel and Expense dashboards to track the spending of its employees
• Dashboard encompasses various types of charts like bar graphs, line graphs, word cloud with filters and actions
• Incorporated user level security, which allows employees to see their own data, and managers to see data of just their reportees.
• Developed functionality to show hierarchies in tableau for all levels of employees
• Enabled actions to filter data in sheets in dashboard based on selections in particular sheets as well as to provide navigations across multiple sheets
• Frequently met with business partners to demo the dashboard and to get the feedback.
• Mentored interns who are new to tableau to be able to bring them to speed for supporting existing dashboards.
• Made refinements and modifications to existing dashboards such as Enterprise dashboards and 360 view dashboards.
• Modifications include adding new sheets and new features which provide additional information to users
• Developed dashboards on employee engagement survey data.
• Developed dashboards with layout containers to be able to hide/show sheets in dashboard based on dropdown selection
• Tested performance of tableau dashboards using Interworks workbook performance tools
• Created user and groups on tableau server to provide access for dashboards.
• Scheduled workbooks and extracts on tableau server to refresh latest data from databases
• Performed POC on various data sources to pick a highly performing data source
• Did Alteryx evaluation for data preparation, integrity to populate tableau workbooks
• Did performance improvements using context filters and tableau extracts

Environment: Tableau Desktop 9.2, Tableau Server 9.2, Tableau Desktop 8.3, Tableau Server 8.3, MS Office Suite, SQL Server, SQL Server Management Studio, Amazon Redshift, Aginity workbench, MS Excel, Online Smart sheets, Interworks Workbook /Alteryx tools for Tableau

Confidential, Englewood, CO

Tableau Developer

Responsibilities:

• Involved in business requirement analysis and responsible for providing LOE for Tableau reports and dashboards
• Created various Tableau dashboards and visualizations using filters, custom calculations, parameters and dashboard actions etc
• Developed Critical Performance dashboards in Tableau for Dish external Regional Service Providers RSP and Sub-Contractors SUB
• Created Daily Average, Weekly Average, Day of Week averages, 8/16 week Averages and various other custom calculations to show the performance for RSP’s and SUB’s
• Reported on various other metrics such as Daily work order completion rate, Survey Scores, Trouble call work order rates etc.
• Executives use the performance dashboards to give incentives and bonuses to RSP’s and SUB’s
• Leveraged user level security for Tableau Dashboards to be able to display data pertaining to RSP’s/SUB’s who logged in
• Implemented tableau data extracts and created dependencies to trigger subscriptions once the extracts are finished through TABCMD utility
• Increased the existing dashboards performance by decreasing the report rendering time from 3 mins to 15 sec.
• Created tableau visualizations for Sales Channel training groups
• Dashboards show the training quizzes completion rate and scores obtained by users, their supervisors and also aggregated by the locations
• Leveraged tableau built in graphical capabilities to create bar charts, tree maps, area charts and also created custom visualization like donut charts, trellis plots etc
• These dashboards also contain drill down capability to be able to drill down from country to state to city to Supervisors to individual users level
• Created Tableau dashboards and reports for Dish Retailers to show their daily, monthly activations over the course of 24 month period
• Various Slicing and Dicing capabilities like by the Activation Plan, Credit Score Buckets, Language etc. are provided in the form of filters to give adhoc reporting capability
• Leveraged dashboard actions to provide drill through capability to individual account level
• Implemented Row level security for the reports to be able to restrict data related to a particular retailer who logged in
• Responsible for administrative tasks like creating schedules for subscription, extracts etc
• Imported users and groups and provided permissions in Tableau Server manually and though TABCMD scripts

Environment: Tableau Desktop 8, 9.1, Tableau Server 8.0, 9.1, MS Office Suite, Teradata, Oracle, SQL Server, MS Excel.

Confidential, Broomfield, CO

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle/SQL Server for design, development, testing and production rollover of reporting and analysis projects within Tableau Desktop
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions
• Developed Courses sales reports, best course sellers’ reports and marketing campaign reports for Marketing department.
• Created Heat Map showing course sales by color that were broken into regions allowing business user to understand where we have most sales vs. least sales
• Created dashboard using parameters, sets, groups and calculations
• Created drill down and drill up in worksheets
• Involved in creating a dual-axis bar chart with multiple measures
• Created report schedules on Tableau server
• Projected and forecasted future growth in terms of number of subscribers by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle, SQL Server and MS Excel
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• 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
• Created monthly, quarterly and yearly financial reports for Finance department.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based 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 group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle, SQL Server, Salesforce, Microsoft Dynamic CRM.

Confidential, Paramus, NJ

Tableau Developer

Responsibilities:

• Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1. Also involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features
• Worked closely with all team members in implementing Tableau BI tool in all IT projects
• Generated reports using SQL queries in Tableau 5.1/6.0/7.0 and published them to users in online thru Tableau server
• Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop
• Managing the Metadata associated with the ETL processes used to populate the Data Warehouse
• 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
• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Assisted users to publish and collaborate reports via a web browser embed Tableau views in other web applications like SharePoint
• Worked on Business Objects Universe development with Universe Designer tool and Document development primarily with Web Intelligence, Dashboards for executive management decision-making tools
• Used Flash Variables, Extremely Extensive Dynamic Visualizations, Chart and Map Drill Downs
• Used Open Docs to allow users to move from the Dashboard to its related detailed Webi report and also from Webi reports to another reports using hyperlinks achieved through using OPEN Docs
• Used User row level security for data in the Dashboard
• Enabled Dashboards on mobile devices

Environment: Tableau 7.0, 6.0, 5.1, Teradata, Oracle 10g, Oracle SQL Server R2, MS Office Suite.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification
• Filtered bad data using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used MS access in test environment
• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistency Data entry into the database
• Carried out a Developer’s role on MS SQL Server, MS Access Databases (Stored Procedures and Views)
• Involved in developing the SQL code for the application
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks
• Created and automated regular Jobs such as Daily/Weekly Report Generations
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties
• Managed and resolved design issues during development
• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Ensuring compliance with database vendor license agreement
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database

Environment: T-SQL, SQL Server, MS ACCESS, SSMS, Oracle

Confidential

SQL Server Developer

Responsibilities:

• Created T-SQL scripts to generate all the tables and relationships based on the finalized ER-Diagram
• Created Stored Procedures, Views and User Defined Functions to facilitate the automation of data entry by a front end application
• Utilized the Dynamic SQL for user customizable queries to be answered by the SQL Server
• Created database documentation for table and column dictionaries and other reference material
• Implemented indexes on tables and views for optimum performance tuning
• Involved in dimensional data modeling and story boarding ETL processes
• Designed the ETL process using different data sources include Flat files, Access, Excel, SQL Server
• Responsible for identifying sources, creating staging database, data warehouse dimensional modeling (Facts and Dimensions)
• Involved in the creation of scheduled jobs for Extracting, transforming and loading operations and database maintenance tasks like de-fragmentation, re-indexing, and recompiling
• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality
• Optimized the existing queries to improve performance with the use of Profiler and Execution Plans

Environment: MS SQL Server, SQL Server Management Studio, Crystal Reports