We provide IT Staff Augmentation Services!

Tableau/ Database Developer/ Admin Resume

PROFESSIONAL SUMMARY:

  • Over 10 years of experience implementation & administration of Tableau Business intelligence solutions and Microsoft SQL server 2012/2008 - R2/2008/2005 in development, testing & production environment
  • Deep experience with the design and development of Tableau visualization solutions.
  • Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies.
  • Expert in evaluating data models to design Tableau solutions.
  • Responsible for developing interactive data visualizations.
  • Extensive Tableau Experience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
  • Broad experience on building dashboards using Tableau and Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
  • Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
  • Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
  • Expert in Developing, Designing and supporting interactive Tableau Dashboard reports
  • Professional in communicating Dashboards per Tableau visualization features
  • Proficient in Building compelling, interactive dashboards in Tableau that answer key business questions
  • Installed and upgraded 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.
  • Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison.
  • Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
  • Highly proficient in using T-SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
  • Strong ability in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation.
  • Proficient in Creating, Configuring, Deploying and Fine-tuning MS SQL Server Integration Service (SSIS) packages.
  • Installation and Configuration of Tableau Server and Tableau Desktop on Windows.
  • Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools like BCP utility, DTS and SSIS 2005/2008 Packages with proper control flow and data flow elements by using MS SQL Server 2012/2008-R 2/2008/2005.
  • Experienced in Alteryx to prep, blend, and analyze data using a repeatable workflow, enabling deployment and sharing analytics for deeper insights in hours.
  • Good experience in generating Sub-Reports, Drill down reports, Drill through reports, and Parameterized reports using SSRS 2012/2008-R 2/2008/2005.
  • Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi-user environment.
  • Self-learning ability, Leadership Quality, good team player and determination to learn new technologies and maintain positive relationships at all business levels.
  • Senior BI consultant with strong background and experience in Business Intelligence and Data Warehousing/Teradata domain.

TECHNICAL SKILLS:

  • Tableau Desktop 6/7/8/9
  • Tableau Server 5/6/7/8/9/10 Tableau Online
  • Tableau Public
  • Tableau Reader
  • Cognos
  • TabCmd
  • Microsoft SQL Server 2012/2008-R2/2008/2005
  • MS SQL Server Integration Services (SSIS)
  • MS SQL Server Reporting Services (SSRS)
  • MS SQL Server Analysis Services (SSAS)
  • Informatica Power Exchange
  • Alteryx
  • T-SQL
  • PL-SQL
  • OLAP
  • OLTP
  • Erwin Data Modeler v7.0/v4.x
  • Teradata
  • Microsoft Visual Studio 2010/2008/2005
  • Microsoft Access
  • Microsoft Office(MS Word/ Excel/Power Point)
  • MS Project
  • Power BI
  • HTML
  • XML
  • Java
  • C++
  • C#
  • Visual Basic 6.0
  • Microsoft Office Visio
  • Windows 2008/2003/2000 Advanced Server
  • Windows NT/95/98/2000/XP/7
  • Ultra Edit Text Editor

PROFESSIONAL EXPERIENCE:

Confidential

Tableau/ Database Developer/ Admin

Responsibilities:

  • Designed reports/graphs/presentations using Tableau for specified projects. Produced accurate analyses of project datasets as defined by the required specification.
  • Developed the business logic and the design of data queries and calculations used to extract and format data for project reports and external presentations.
  • Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.
  • Installed and upgraded 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.
  • Involved in Tableau installation and configuration with Single Server System and Three Node Server System.
  • Configuring Users based on Active Directory and logged in through Run as User account.
  • Maintaining SSL Certificates for windows users and Mac Users.
  • Working on Tableau User based Licensing and Core based licensing.
  • Creating Users, User Groups and Projects through Tableau server Web and assigned roles and permissions for Tableau Users.
  • Created batch scripts for tableau Server backup atomization on weekly basis and save the backups in particular folder.
  • Maintaining Tableau data source connections and scheduled refreshes and updates.
  • Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
  • Published Tableau workbooks (.TWB) and Tableau data Extract (.TDE) from Tableau desktop to Tableau Server.
  • Involved in end to end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
  • Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
  • Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
  • Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
  • Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
  • Produced Crosstabs to display underlying data based on various graphs and charts created for further data analysis.
  • Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
  • Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.

Tools: & Technologies: Tableau Desktop 9/10 Tableau Server 9/10, Alteryx, T-SQL, PL-SQL, OLAP, OLTP, Teradata, Microsoft Visual Studio 2010/2008, Microsoft Access, Microsoft Office (MS Word/ Excel/PowerPoint), MS Project, Power BI, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2010, Oracle 10

Confidential

Tableau Developer/Admin

Responsibilities:

  • Created visually appealing and actionable dashboards that communicated financial results and enabled improved Business Metric data analytics at Verizon.
  • Built dashboards utilizing Tableau for FP&A Business Intelligence Unit for DMA Analysis and 24 Months Engagement Reports.
  • Created Impactful OneEX Tableau Dashboard for Senior Executives Business Reporting/Analysis and 4Q16 Postpaid Analysis.
  • Designed and produced Relevant Dashboard for Prepaid KPI’s for the Months Report Analysis for internal business and client facing technology.
  • Built dashboards for Marketing department for Low/Zero usage Analysis and Promo Campaigns.
  • Worked with database developers to define, create, and optimize data sets for data visualizations and deep dive analysis.
  • Work with Data Warehouse engineers to define and obtain reporting data view models.
  • Identified opportunities to improve data visualization capabilities for Financial Planning and Analysis department.
  • Was Involved in Building and maintaining Market Impact, Events and Promo, Pricing, Prepaid and Revenue Tableau dashboards.
  • Performed performance tuning of dashboard in Tableau desktop and managed user access on Tableau Server and FP &A Business intelligence portal.
  • Designed Prototype dashboard using Tableau and Revenue dataset, to demonstrate the capabilities of the tool and provide the opportunity for Revenue to assess the tool and more insights.
  • Worked closely with key stakeholders to understand Metrics, data and developed meaningful and interactive dashboards to enable actionable insights.
  • Designed, developed, tested and deployed various reports and dashboards using Tableau.
  • Responsible for integrating data into the Teradata enterprise data warehouse by leveraging the IBM Information Server/DataStage Extract-Transform-Load (ETL) software.

Tools: & Technologies: Tableau Desktop 8/9, Tableau Server 8/9, TabCMD, Alteryx, MS SQL Server 2012, MS SQL Server Integration Services, MS Visual Studio 2010, Microsoft Office Visio, Power BI, Cognos, Talend, Microsoft Safe Source 2005 (VSS),Teradata, Informatica Power Exchange, Erwin r8, Ultra Edit tool, Google Big Query, SharePoint, C#.

Confidential

Tableau Developer/ Data Visualization Expert

Responsibilities:

  • Designed Excellent Tableau dashboards for IT Procurement to visualize Spend, Maintenance & Contract Renewals, Order Status, Invoice Status and Wireless.
  • Developed interactive data visualizations Proof of Concept and developed automated processes for Human Resources (HRRP) leveraging Tableau Technology.
  • Partnered with HR services to deliver on business driven results by conducting initial analysis on what it would take to develop a Front end solution that would enable them integrate various data sources to support end customer reporting visualization needs.
  • Reviewed existing HR data sources, current Report samples of existing reports and Built compelling, interactive dashboards in Tableau that answer key business questions.
  • Created Tableau Dashboard for Compliance Analytics team in support of SIFI reporting initiative.
  • Designed Prototype dashboard using Tableau and Retirement dataset, to demonstrate the capabilities of the tool and provide the opportunity for Retirement to assess the tool.
  • Created Tableau Visualization that calculated Performance for each business within Prudential International Investment (PII) as well as overall performance statistics applying the calculation of MTD, YTD, 1 Year and 3 Years Performance reporting.
  • Was involved in the creation of Tableau Hosting Site EBCM.tb.reports and created active directory group to control user Access. Also created a High impact initiative report for the Given Url.
  • Obtained 3 named user access to Global Business and Technology Solution Shared Tableau infrastructure
  • Set up Tableau Server instance for Prudential Capital Group on the Shared infrastructure hosted by GBTS. This instance was configured to support 4 named Users.
  • Created Tableau instance that incorporated Tableau Server into Global Marketing Communication’s platform of online applications reporting tools and production modeling capabilities, allowing users to access shared dashboards and data visualization from their browser.
  • Designed new shared Service Tableau environment for Prudential Investments Mutual Funds, Established Tableau connectivity to data Sources, Provided Tableau & Cognos developer resources. Also improved the GBTS functional technical requirements section Project objective Enhance SIRG platform to provide executive team an advanced analytical platform that delivers data from various data sources quickly and easily for decision support.
  • Was instrumental/Involved in Internal Audit estimated cost of acquiring two Tableau Enterprise Licenses along with a secure data repository
  • Audited Long Term Care Tableau Project basic Analytics visualization for GBEI data licensing.
  • Created Visualization to cover Licensing requirements and Tableau on boarding including creation of AD groups and the new site with proper authentication
  • Developed story telling dashboards for Privacy Group 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
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on IT Procurement business changes to ensure that the views and dashboards displayed the changed data accurately
  • Worked closely with business stakeholders to design the dashboards, extract data from a variety of sources and manipulated the data for dashboard consumption
  • Worked closely with key stakeholders to understand the data and developed meaningful and interactive dashboards to enable actionable insights.

Tools: & Technologies: Tableau Desktop 8/9, Tableau Server 8/9, TabCMD, Alteryx, MS SQL Server 2012, MS SQL Server Integration Services, MS Visual Studio 2010, Microsoft Office Visio, Power BI, Cognos, Talend, Microsoft Safe Source 2005 (VSS),Teradata, Informatica Power Exchange, Erwin r8, Ultra Edit tool, Google Big Query, SharePoint, C#.

Confidential

Tableau Developer/ Admin

Responsibilities:

  • Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
  • Held responsibility for integration points and the order in which these must be executed.
  • Built compelling, interactive dashboards in Tableau that answer key business questions.
  • Audited the datasets and data analyzed as required ensuring their continuity, accuracy and consistency.
  • Mentored less experienced Tableau reporting specialists.
  • Performed administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance
  • Accomplished development activities from gathering requirements and designing solutions, through developing code/reports, to testing and release/deployment.
  • Reviewed, assessed and promoted adoption and standardization of Tableau support solutions.
  • Generated insights out of voluminous and complex datasets and built story lines.
  • Produced complex table calculations, use of parameters, actions, filters and other advanced options in Tableau.
  • Designed excellent tableau dashboards and presented correct decisions independently based on what different kind of visuals would make sense for the business.
  • Involved in reviewing business requirements and analyzing data sources from 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.
  • Formed Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users using Tableau.
  • 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 keys from each database for data validation.
  • 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.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed 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.

Tools: & Technologies: Tableau Desktop 8, Tableau Server 8, TabCMD, MS SQL Server 2012, MS SQL Server Integration Services, MS Visual Studio 2010, Microsoft Office Visio, Power BI, Microsoft Safe Source 2005 (VSS), Informatica Power Exchange, Erwin r8, Ultra Edit tool, SharePoint, C#.

Confidential

Tableau Developer/ SQL Server Developer

Responsibilities:

  • Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
  • 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.
  • Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
  • Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
  • Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
  • Found efficient ways to make tables and graphs which were visually easy to understand and at the same time maintaining the accuracy of the core information content.
  • Created visualizations for logistics calculations and departmental spend analysis. Utilized sample data to create dashboard while ETL team were cleaning data from source systems, and was responsible for replacing the connection to Oracle 10g
  • Used Sql Queries at the custom Sql level to pull the data in tableau desktop.
  • Validated the results in Tableau by running Sql queries in Oracle Sql developer.
  • Attended daily standup meetings to update scrum master with what is achieved, what is being done and is there any impediment.
  • Conducted user acceptance testing and mentored business users how to slice and dice data using filters and parameters.
  • Created and maintained issue log where business users enter their feedback by working on dashboard in test environment. Implemented the feedback and incorporated the necessary changes.
  • Developed tableau functional design document.
  • Performed performance tuning of the dashboard in Tableau desktop.
  • Published the developed dashboards into production and ensured the data was up to date by scheduling extract refreshes.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Involved in the development of SSIS Packages for cleaning and scrubbing of data using Lookup and Fuzzy Lookup transformations to validate the data.
  • Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tools: & Technologies: Tableau Desktop 6/7, Tableau Server 7, MS SQL Server 2008 R2, MS SQL Server Integration Services, MS SQL Server Reporting Services, MS Visual Studio 2008, Erwin r7

Confidential

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems for mortgage loan products.
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
  • Elaborated in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Developed various types of complex reports like Drill Down, Drill through, linked reports, cascading parameter reports for business loan, first time buyer or refinancing home mortgage.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Perfected in designing Parameterized Reports and Matrix Reports for generating Ad-Hoc reports as per the client requirements.
  • Coordinated with front-end for implementing logic in stored procedures and functions.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Elaborated in upgrading from SQL Server 2005 to SQL Server 2008.
  • Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Tools: & Technologies: SQL Server 2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS),TSQL,C#, .Net framework, XML, MS Visual Source Safe, MS Visio 2007.

Confidential

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications
  • Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction
  • Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements
  • Optimized existing stored procedures and various T-SQL queries
  • Wrote Dynamic Store Procedure to move data from Staging to Application
  • Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler
  • Added more audits and alerts in SSIS Packages in case of package failure
  • Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data in to the tables from Text files
  • Managed index, statistics and optimize queries by using execution plan for tuning the database
  • Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc. to clean data
  • Developed Master Child package using variables and Execute package task in SSIS
  • Scheduled jobs to call the packages and Stored Procedures as per business requirement
  • Deployed, tested and scheduled SSIS packages using SQL Agent
  • Designed and deployed reports with Drill Down, Drill Through and Dropdown menu option and Parameterized and Linked reports
  • Deployed and scheduled Reports using SSRS to generate all reports including current status
  • Used Execution Plan a and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases

Tools: & Technologies: MS SQL Server 2008, SSRS, SSIS, SSAS, VB.Net, EXCEL, MS Access, ORACLE 10g, Erwin Data Modeler v7.0/v4x.

Hire Now