WALTER A SHIELDS

Cell: 347-***-****

ac4kqf@r.postjobfree.com

http://www.linkedin.com/in/waltershields

https://www.sqltrainingwheels.com/

Primary Skills

Data Analyst, DBA, SQL Server, SSRS, SSIS, Tableau, VBA, Excel, MS Access, ITIL, JavaScript, HTML5, CSS

RESUME DETAILS

PROFESSIONAL SUMMARY

●Analytic and innovative Data Analyst / Database Developer/ Database Administrator (DBA) with ten+ years of professional IT Experience in Relational Database Management Systems (RDBMS), MS Access and SQL Server Data Tools with extensive expertise in Transact SQL and Reporting using SQL Server 2017/2016/2012/2008/2005, Enterprise Manager, SSRS, SSIS and Tableau.

●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, AS400) and flat files (TXT, XLS, XLSM, CSV). Proficient in packaging these extractions using SSIS.

●Expert in report development using SQL Server Reporting Services (SSRS) and Tableau. 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

EDUCATION & TECHNICAL SKILLS

Masters of Management Information Systems – Metropolitan State University, MN

Bachelor of Computer Science – New Jersey City University, NJ

PROFESSIONAL EXPERIENCE

SQL Training Wheels, New York, NY March 2017 – Present

Meetup Organizer / Teacher / Coach

https://www.meetup.com/SQL-Training-Wheels/

Responsibilities:

●Conduct weekly classes and workshops teaching attendees fundamentals of SQL scripting and Relational Database concepts

●Work with students, managers, marketing and financial analyst etc to educate and build their confidence in SQL query writing, data analysis and database management

●Event Planning; work with recruiters and other industry relevant guests to present and give current trends and insight on where SQL Skills can take you professionally

NYC Administration for Children Services, New York, NY January 2018– Present

Tableau Project Manager / Tableau Developer

Responsibilities:

●Spearhead planning, design and implementation of Tableau pilot

●Establish and manage project roadmap

●Ensure project requirements and tasks align with Citywide best practices

●Design each phase of Tableau Server installation and configuration

●Interview user base and gather AS-IS system and report visualization for current state

●Design and built predictable and scalable Tableau content management framework inclusive of groups, projects and permissions

●Connected multiple datasource(Oracle, SQL Server, CSV) workbooks, with both live and extract data freshness schedules

●Develop and implement (TO-BE) new Tableau report visuals and dashboards

●Conduct user training sessions for both View and Publisher site roles

Samelson-Chatelane-Coral, New York, NY November 2017 – Present

SQL Server Database Developer/ Data Solution Architect

Responsibilities:

●Convert MS Access 2003 Database to SQL Server 2017 and Microsoft Azure cloud databases

●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

SQL Server Database Administrator / Data Analyst

Responsibilities:

●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 SSRS reporting environment including Reporting Server configuration and mail settings

●Created 40+ SSRS 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 Cumul.io software and Tableau

Ropes and Gray LLP, New York, NY May 2014 – March 2017

MS SQL/SSIS/SSRS/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 SSRS reports and SSIS packages.

Responsibilities:

●Design and develop database and report models that support partner facing Firm applications

●Created Tableau dashboard report summarizing survey responses 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.

●Rebuilding the indexes at regular intervals for better performance.

●Work with web development team, creating and optimizing underlying application dependent SQL scripts

●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 2008, 2010, 2012, SQL Server Tool Belt, JavaScript

NYK Business Systems America, Secaucus, NJ October 2011 - October 2013

SQL Server Developer/Data Analyst/DBA

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.

Responsibilities:

●Actively interacted with business managers, project managers, technical managers, DBAs and users to fully understand system requirements.

●Database Administrator, Database Programming.

●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)

●Created SSRS Key Performance Indicator (KPI) reports 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 SSRS Gauges, Indicators, Charts, etc.

●Developed interactive features for SSRS reports allowing user to filter, sort and drill thru to related detail data sets; using Drop Down List Parameter, Cascading Parameters, Linked Reports, Subreports and Dynamic Matrix.

●Created supporting MS Access and Excel reports using Macros with complex VBA Scripting (IF, Then, Do, While Loops, Names Ranges) and advanced formulas (VLOOKUP, SUMIFS, INDEX + MATCH, SUMPRODUCT)

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.

Responsibilities:

●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 of 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 bulleted 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/SSRS 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.

Responsibilities:

●Designed precision critical SQL Server 2008 Stored Procedures Views, Triggers used as dataset inputs for SSRS 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 Reporting Services 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 SSRS 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.

Responsibilities:

●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 / DBA

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 by 30% using SQL Server 2005.

Responsibilities:

●Reviewed, developed and designed application and data models using Logical Data Modelling, Visio 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.

Contact this candidate