Walter | Pangian
Change your cover photo
Change your cover photo
I create compelling and visually motivating dashboards and reports.
This user account status is Approved

This user has not added any information to their profile yet.

United States Of America
United States Of America
Metropolitan State University
Masters of Management Information Systems
Down-to-Earth, Innovation, Integrity, People

Are you looking to bring the benefits of data analysis to your business? Or maybe you already have analytics implemented and you are looking for eye catching reports to display your metrics.

Working with Tableau, Excel, Microsoft Business Intelligence Studio (SSIS, SSAS, SSRS), MS SQL Server and MySQL. I build solutions to suit your business needs.

My job is to take your data and visually convey it in a way that entices, engages and moves your audience to an action.

My specialties are:
-Captivating, data driven visualizations that catches and keeps your audience's attention
-Data Analysis, Data Warehouse and Data Marts built to solidly support your visualizations
-Custom queries and procedures designed for real time blazing fast performance
-Identifying, designing and building you dashboards that really matter
-Teaching SQL to students in a fun (NON-bore-you-to-death) kind of way. It's my passion.

So the why not focus on running your business and let me take care of the headache creating queries, mind numbing ETL processes, hair loss data warehouses and data marts and create your stunning data visualization dashboards.

Kind Regards,

Walter Shields
Principal |

Business Intelligence, Data, Data - Data Center Construction, Data Analysis, Employee Interaction - Employee Training, SQL
Data Analysis/Visualization
> 10 Years of experience
Full-Time, Part-Time, Contract

Primary Skills
Tableau Developer, Data Analyst, DBA, SQL, SQL Server, SSRS, SSIS, Excel, ITIL, JavaScript, HTML5, CSS

● Analytic and innovative Tableau Expert | Data Analyst | Tableau Desktop| Tableau Server Administration with nineteen+ years of professional IT Experience in Relational Database Management Systems (RDBMS), SQL Server Data Tools with extensive expertise in Transact SQL and Tableau Reporting using SQL Server 2017/2016/2012/2008/2005, Enterprise Manager, Salesforce, Oracle Eloqua, MYSQL, SSRS, SSIS, Azure Cloud Services, Azure SQL, Azure Data Sync and Tableau Desktop. ● Experienced in mediation between business and technology staff, accurately gathering requirements and applying full life cycle development frameworks to deliver comprehensive technology solutions, using SQL Server 2016/2012/2008/2005/2000 Tools, Business Intelligence, SSIS, SSRS, EM and Tableau. ● Expert in database optimization using normalization principles, efficient Transaction SQL scripts, batches and objects ● Experience developing SQL Server objects relevant to efficient system design. These objects include; Tables, Views, Stored Procedures, Triggers, (UDFs) User Defined Functions and complex T- SQL statements (Variables, Input/Output Parameters, Temp Tables, Full/Inner/Outer joins, etc.). ● Extensive experience in Extraction, Transformation and Loading (ETL) of data from various external databases (Oracle, SQL Server, Dbase, MYSQL, Eloqua) and flat files (TXT, XLS, XLSM, CSV). Proficient in packaging these extractions using SSIS. ● Expert in report development using Tableau Desktop and Tableau Server. Dashboards, Gauges, Charts, Tubular, Matrix, Dynamic Matrix, Sub-reports. Drill Down, Parameter, Cascading Parameter, etc. ● Worked in the capacities of IT Manager, Business Analyst, Data Analyst, Project Manager and Technical Solutions Developer within team and individual environments leading or taking direction with minimal supervision. ● Expert in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities. ● Firm understanding of Legal, Shipping, Health, Accounting, HR, Mass Transit and Retail domains

Masters of Management Information Systems – Metropolitan State University, MN Bachelor of Computer Science – New Jersey City University, NJ

Datadecided, New York, NY January 2012 – Present
[Remote] CEO | Founder | Tableau Development Services is an expert in Tableau development and we help medium and large companies leverage their data with actionable data visualizations. Datatadecided works as the outsourced Business Intelligence team for businesses, we do everything; discovery, data preparation, dashboard development, distribution, and documentation so our clients don’t have to.

SQL Training Wheels, New York, NY March 2017 – Present
Meetup Organizer | Teacher | Coach
● Create, manage and teach in person and online courses in Data Analysis, Business Intelligence | Tableau and SQL ● Conduct weekly classes and workshops teaching attendees fundamentals of SQL scripting, Data Analytics, Relational Database concepts and data visualization using Tableau Public and Tableau Deaktop ● Work with and teach students, managers, marketing and financial analyst etc. to educate and build their confidence in SQL query writing, data analysis, database management and data visualization using Tableau Desktop ● Event Planning; work with recruiters and other industry relevant guests to present and give current trends and insight on where data analysis and Tableau development skills can take you professionally ● Create manage and maintain company website with custom coding (HTML, CSS, Custom Scripts). ● Create funnel automations with measurable KPIs.

Sojourn Solutions, Fort Worth, TX October 2018– June 2019
[Remote] Tableau Developer
• Successfully conduct full life cycle design and development of Tableau visualization and dashboards • Manage requirements gathering initiatives that secure alignment of goals and objectives to dashboard insight • Employ best practice design concept geared toward the delivery of informative and actionable visualizations • Shaped and configured underlying data from multiple sources; Tableau Server, Salesforce (SFDC) and MySQL • Align with Business Analyst and Project managers to ensure feasibility and accurate delivery of requested dashboards • Present created visualization to multiple tiers of audiences including executive level management

NYC Administration for Children Services, New York, NY January 2018– February 2019
[Remote] Tableau Project Manager | Tableau Developer
● Spearhead planning, design and implementation of Tableau project ● Installed and configured Tableau Server and Tableau Desktop ● Ensure project requirements and tasks align with Citywide best practices ● Design and implement each phase of Tableau Server installation and configuration ● Interview user base and gather AS-IS report visualization for current state ● Design and built predictable and scalable Tableau content management framework inclusive of groups, projects and permissions ● Connected multiple data sources(Oracle, SQL Server, CSV) workbooks, with both live and extract data refresh schedules ● Develop and implement (TO-BE) new Tableau report visuals, KPIs and dashboards ● Conduct Tableau user training sessions for both View and Publisher site roles

Private Client, New York, NY November 2017 – August 2018
[Remote] Azure SQL Server Database Developer| Data Solution Architect
● Convert MS Access 2003 Database to SQL Server 2017 and Microsoft Azure cloud databases ● Implement Azure Data Sync to synchronize Cloud Database with On Premises Databases in multiple geographic locations ● Implement strategic plan to move all MS Access Tables and Queries to SQL Server tables, Views and Stored Procedures ● Performance tune converted views and stored procedures using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). ● Reconfigure Report, Macros and Modules to function with the new upsized SQL Server 2017 database environment ● Manage and administrate upsized database, monitoring and making recommendations for performance improvement ● Create data packages with SSIS. Using Data Flows to extract data from remote to local SQL Server database, applying sorting, filtering, merging and data type conversion. Storing the transformed data in a local SQL Server 2012 data warehouse.

Girling Health Care, Brooklyn, NY September 2017 – January 2018
[Remote] SQL Server Database Administrator | Tableau Developer
● Migrated SQL Server 2005 to SQL Server 2016 Enterprise Edition on Windows Server 2012 ● Converted SSIS packages from SQL Server 2008 R2 to SSIS 2016. ● Built Tableau dashboards including Tableau Server configuration ● Created 40+ Tableau reports including their supporting SQL Server objects (stored procs, functions and views) ● Configuration and installation of McKesson health care application as a remote application ● Troubleshoot and fine-tune databases for optimal performance and concurrency ● Manage users, permissions and implement data security best practices ● Design and implement comprehensive Backup plan and disaster recovery strategies Implemented. ● Provide production support for SQL Server databases on Clustered Servers ● Created dashboard prototypes with software and Tableau

Ropes and Gray LLP, New York, NY May 2014 – March 2017
[Remote] MS SQL | SSIS | Tableau Developer | Data Analyst

Ropes & Gray LLP is a global law firm with 11 offices located in the United States, Asia and Europe. Its clients include corporations and financial institutions, government agencies, universities, and health care organizations. My duties here were to model and develop SQL Server databases, develop Tableau dashboards and SSIS packages.
● Design and develop database and report models that support partner facing Firm applications ● Created multiple Tableau dashboards summarizing survey responses and KPIs by geographic location ● Worked extensively in Query analyzer and Profiler for tuning queries using variable for characteristics and query costs. ● Monitored and modified Performance using execution plans and Index tuning. ● Transferring the data (ETL) to Data warehouse using SQL Server 2016 Integration Services. ● Rebuild indexes at regular intervals for better performance. ● Work with web development team, creating and optimizing underlying application dependent SQL scripts and Tableau Reports ● Managed and maintained client facing MS Azure SQL Server database (on-site/off-site deploy, backup, restore) ● Created complex Stored Procedures and views involving multiple table joins (Union, Left, Right, Full, Inner and Outer). ● Designed numerous virtual tables and Common Table Expressions CTE, to efficiently process data within Stored Procedure objects ● Some technologies used include, Microsoft SQL Server 2008 R2, 2012, 2014, 2016, Microsoft Visual Studio

NYK Business Systems America, Secaucus, NJ October 2011 - October 2013
SQL Server Developer | Data Analyst | Tableau Developer

Nippon Yusen Kaisha (NYK Line) is a leading shipping company, offering premium transport services to a global customer base. The project involved performance tracking and reporting of IT services delivered to support global business objectives, mainly employing ITIL framework principles to do so.
● Actively interacted with business managers, project managers, technical managers, DBAs and users to fully understand system requirements. ● Designed interactive Tableau dashboards allowing department heads and executive management to clearly visualize ITIL based KPIs and make solid data based decisions ● Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. ● Rebuild indexes at regular intervals for better performance ● Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented ● Designed T SQL scripts, joining and aggregating tables as necessary (Left, Right, Inner, Outer, Group By, Sum, Avg, etc.) to query repository (above) using SQL Server 2012 objects (Views, User Defined Functions and Stored Procedures) ● Developed Tableau Key Performance Indicator (KPI) dashboards in alignment with ITIL focus areas relevant to business stakeholders’ interests. Displaying graphically, metrics such as (Outage Durations, Critical Incidents Logged, Mean Time to Resolve Critical Incidents, etc.) using Tableau Desktop.
Conti Group Companies, New York, NY October 2010 - October 2011
MS SQL Server | SSIS | VBA Developer

Conti Group Companies is one of the largest privately held companies in the world, operating in investment and diversified operations. The project involved the development and maintenance of an integrated Human Resource Management System (HRMS), using SQL Server 2012 to develop a full life cycle employee benefits administration module.
● Created a multi-layer User Interface (UI) for data entry using Microsoft Access Forms, Subforms, Select, Crosstab and Append queries in conjunction with underlying VBA coding. ● Created SQL Server 2008 data warehouse building Dimension tables for sorting and filtering and assembling data from multiple sources (MS Access, CSV Flat Files, Excel and Oracle Database). ● Designed strategies to Extract Transform and Load Employee Benefit data to the data warehouse using SSIS Data Flows. ● Created multiple User Defined Functions (UDF, Stored Procedures and Views) to apply proprietary decisive formulas, categorizing Active and Retiree employee populations and applying appropriate benefits to them. ● Designed and developed tabular and graphical SSRS reports using Grouped Tables, Calculated Fields, Conditional Formatting, Gauges, Drop Down and Cascading Parameters within the Reporting Services environment. Reports clearly illustrated allocation of employee benefits to correct employee bases as determined by HRIS system logic mentioned in previous bullet point. ● Improved report execution times by 20% via altering underlying Stored Procedures T SQL scripts and scheduling SQL Server jobs to trigger data refreshes during off peak hours.

Anthem Inc., Brooklyn, NY October 2009 - October 2010
SQL Server | SSIS | Tableau Developer | Business Analyst

Anthem, Inc. is one of the largest health benefits companies in the United States; an independent licensee of the Blue Cross and Blue Shield Association. My responsibility here was to support the financial reporting of national sales data for various health plans and packages.
● Designed precision critical SQL Server 2008 Stored Procedures Views, Triggers used as dataset inputs for Tableau online reports. ● Created and modified SSIS packages to import data from SQL Server, Oracle, comma and tab delimited external data sources; extracting, transforming and loading (ETL) to a SQL Server 2008 data repository. ● Performance tuned existing stored procedures and functions improving report generation time. ● Used Tableau Desktop to create new SQL Server online reports displaying summary data in dashboard format. Build into dashboards clickable drill thru functionality to view related detail data in tabular format. ● Worked closely with business managers and produced technical requirement documents citing report design, performance standards, SQL Server object selections and hardware specification for new Tableau report development.

LumiData Inc., Minneapolis MN March 2008 – January 2009
Manager of Software Development | SQL Server Developer | DBA

LumiData is a specialist in demand intelligence architecture, analytics and applications for retail team members and executives of consumer goods companies. My role at the company was to work directly with retail client data, designing Data solutions using SQL Server 2008.
● Installed, configured numerous SQL Server installations at client locations, with custom user permissions ● Analyzed and Upgraded SQL Server 2005 test servers to SQL Server 2008. ● Created custom relational database structures using SQL Server, capable of processing Point of Sale (POS) retail data for various vendors of major discount retailers. ● Analyzed data content specific to individual vendors, creating strategic table indexes to optimize the processing 10+ million rows of data. ● Developed extensive Views and Stored Procedures to query and process POS data in preparation for SSRS report data set inputs ● Created online SSRS reports using Reporting Services to display business critical product sales data, critical to vendor product placement. ● Developed VBA Scripts within Microsoft Access and Microsoft Excel environment to provide supporting reports for select clients.

Target Corporation, Minneapolis MN July 2006 – March 2008
SQL Server Developer | Report Developer

Target Corporation is the second-largest discount retailer in the United States. My role at the company headquarters was to design and develop full life cycle applications that assisted business stakeholders to become more efficient in their daily tasks, improving productivity using SQL Server 2005.
● Reviewed, developed and designed applications, data models and reports using Logical Data Modelling, SSRS and User Interface prototypes. ● Translated requirements into physical client server relational database applications using VB6 and SQL Server 2005. ● Optimized application performance via applying non-clustered and clustered indexes to appropriate tables and indexing views. ● Created complex Stored Procedures and views involving multiple table joins (Union, Left, Right, Full, Inner and Outer). ● Automated inter departmental processes with systems as described above; effectively improving speed, accuracy and communication of time sensitive business functions. ● Installed configured and administered SQL Server 2005 software on Microsoft Windows Server 2008.

New York City Transit Authority, New York, NY July 2001 – July 2006

Database and Application Developer

● Maintained payroll database housing financial data for entire transit organization; 40,000+ employees ● Developed and maintained applications using VB, COBOL, JCL and AS400 ● Designed SQL Server SQL Scripts and DTS packages across Server/Mainframe environments ● Created scheduled SQL Reports to quantify and visualize large datasets