SUMMARY:

• Business Data Analyst Tableau / SQL Developer (T - SQL/ SSIS- ETL/ Developer)
• Degreed Professional with experience in project management, database design, development and administration. healthcare and health clinical research, call centers, customer service/CRM applications, ERP/Lean Manufacturing, Knowledge Management and enterprise document management, electronic publishing, and technical writing.
• Experience in computer manufacturing, oil & gas, construction and health clinical research industries.
• Advanced knowledge of business database design and architecture and data analytics and statistics.

TECHNICAL SKILLS:

• Project Mgt
• Project Lead Various Projects
• Agile / SCRUM / Waterfall
• Designed UI/UIX screens various applications; maintained system documentation; designed backend processes supporting web applications using web services. Led several development efforts and applications.
• Database
• SQL Server 2014/2012/2008/2005/2000/6
• Vertica 7 ( query/architecture design only)
• Microsoft Access 2010
• MySQL 5.6
• Toad
• ETL Development / SSIS; T-SQL;
• SSAS, SMS, SSRS; Architect experience table design, procedures, views, functions, triggers; administration; tuning; backup; DTS and SSIS packages Data Analysis; natural language processing. Experience with Big Data Databases and large datasets.
• Development
• PHP 5.6/7.0, C# (.NET 2.0/3.5/4.0 )
• MS Powershell
• HTML5 / Javacript
• Microsoft Excel Power Query
• Microsoft Access 2013
• Microsoft Team Foundation Server (contributor) Subversion Git
• Script experience VB, PowerShell, bash
• Eclispe; Netbeans 8.2; Visual Studio 2012/2010
• Javascript, HTML 5.0
• Operating Systems
• Platforms
• Microsoft Windows 8, 7, Server 2012; Sharepoint 2012
• Fedora 16-25 Server; Centos 7/6
• IIS Administration
• Web publishing Site Maintenance
• Apache PhpMyAdmin MySQL Workbench
• Scripting VBScript/Linux Bash Shells
• Reporting
• Tableau 10.0.3/9.0 / 8.2 / 7 / 6 ;
• Fusion Charts MS SSRS
• Tableau Dashboard / workbook authoring. Tableau Admin data sources/users.
• Microsoft Office
• 2000 - 2016
• Sharepoint 2013
• Excel ( ODBC/Vlookups/Pivots/VBA);
• Data extraction from/to SQL using ETL; VBA;
• Word: Automation / VBA
• PowerBI
• Eric Moore (p. 2)

PROFESSIONAL EXPERIENCE:

BI Datawarehouse SQL / Tableau Developer Analyst

Confidential

Responsibilities:

• Developed SQL Procedures, Queries and objects for consumption by Tableau
• GE Centricity Financials Health Database
• DSAT Financial Revenue Cycle Team
• Developed Tableau Visualizations in support of Financial and Healthcare initiatives.
• Mentored, trained and led Tableau classes for colleagues.
• Designed and documented branding for Tableau design to assist institution in deployment.
• Processed data workflows using Alteryx 10.6 supporting analysis of health care data.
• Used Python to support data processing steps/sentiment analysis from Alteryx.

Senior HDC Data Analyst

Confidential

Responsibilities:

• Supported Medicare ACA reporting initiatives leveraging Tableau as primary tool.
• Developed and maintained daily executive level Tableau dashboards that supported call center operations of ACA/Medicare 1095 Support initiatives for CMS.
• Developed dashboards in support of call center operations helping management analyze staff performance issues, case management and issue resolution.
• Worked with management answering questions and identifying issues with the data using Tableau.
• Suggested improvements in ongoing Tableau dashboards to meet changing system and business requirements.
• Published reports in Powerpoint to Sharepoint.
• Provided analysis on data issues relevant to ongoing operations.
• Administered Tableau 9.2 configuring users, data sources.
• Took on special reporting projects as needed.
• Cleaned and prepared data for various system initiatives
• Utilizing MS Excel Power Query/PowerPivot/VBA
• Microsoft Access to clean and fix data.
• Microsoft Word to document Tableau workbooks.

Confidential, Houston, Texas

Data Analyst/Tableau Developer

Responsibilities:

• Worked with managers and client managers to develop natural language processing applications to assist in identification and analysis of call center data issues. Success rate approached 60/70% beating other tools by 30-50%.
• Developed Tableau workbooks/dashboards against Excel, SQL Server 2012 and Vertica 7/6.5.
• Utilized Tableau best practices to improve performance.
• Worked with end users to develop effective dashboards workflows.
• Administered Tableau Server configuring user roles and publishing of data sources.
• Participated in Agile/SCRUM development practices to manage projects
• Designed process to analyze data using natural language processing using Tableau to validate data
• Worked with management and project leads to develop KPI’s, Dashboard layout and flow.
• Built Consumer Tableau workbooks for worldwide client base.
• Created SSIS/ETL, procedures, views, functions to load and clean large amounts of data from variety of sources into SQL Server and/or Vertica.
• Developed SSIS/ETL projects to load weekly customer data into Vertica.
• Developed SSIS/ETL, T-SQL Procedures/Functions in support of natural language processing application.
• Developed natural language application using SQL, Tableau and Excel to clean, validate, analyze and categorize data.
• Created categorization and data structures to define and identify support issues.
• Worked with offshore teams to identify correct data for data model and feeds into Vertica.
• Analyzed and developed data models and documented in Wiki Tools.
• Took initiative to build first set of Tableau Workbooks for client teams as HP rolled out Tableau.

Confidential, Houston, Texas

Project Manager/Lead Architect

Responsibilities:

• Facilitated meetings with internal/external clients to
• Gathered requirements and analyze business processes.
• Capturing business requirements from external clients.
• Facilitated meetings to present design documentation and discuss functionality.
• Gathered ongoing functional requirements and changes to project plan.
• Gathered requirements from external users in support of marine aspects of application.
• Wrote and maintained system design documentation and specifications.
• Led development team and worked with clients to develop web based document management system utilizing HTML5/JSON Rest Service.
• Built mockups and detailed workflow presentations, screen design, and system documentation for developers, management and clients.
• Design and architecture of SQL database (2008R2)
• Designed UI screens working with development team.
• Designed, wrote and implemented T-SQL objects (procedures, views, functions, tables) for design efforts.
• Used TOAD SQL to document databases and database related business requirements.
• Implemented SSIS/ETL packages to automate and populate document data for system.
• Created processes to bulk load client data in support of operation objectives.

Confidential, Houston, Texas

Web Developer II

Responsibilities:

• Worked with support staff and educators to design training module and extend system functionality.
• Evaluated requirements and implemented new intranet solution using jQuery and ASP.NET
• Designed, documented and deployed hierarchical database including tables, procedures, triggers, views and functions.
• Developed data flow diagrams, data dictionary information on all database objects.
• Implemented security roles for student and administrator sections of website.
• Designed and deployed C# n-tier Web forms ADO.NET intranet replacement site using CSS to ensure cross browser compatibility to section 508 specifications.
• Created system documentation
• Developed documentation for students.
• Implemented open source SVN (Subversion) version control.

Confidential, Houston, Texas

Data Analyst/ETL Developer

Responsibilities:

• Supported DSMB Major Medical Study migrating Access 2007 database to SQL.
• Set up and administered security roles.
• Created customized stored procedures for external DSMB report exhibits.
• Developed objects for Educational Data Warehouse project including ETL-SSIS objects.
• Managed data migration to and from SAS 9.2, SQL 2005, and Access 2007.
• Scrubbed data for import into data warehouse.
• Developed token process using fuzzy matching to resolve issues with Federal and State data source names/address of entities achieving nearly 95% matching success.
• Participated on DBMS study migrating Access DB to SQL.
• Eric Moore (p. 4)

Confidential, Houston, Texas

Web /Database Developer

Responsibilities:

• Development of web-based enterprise wide financial reporting application to display financial KPIs and measures.
• Gathered requirements, defined financial formulas, created dynamic SQL to produce and implement dynamic financial KPIs and measures.
• Built web based application providing capability to drill down into KPI and worldwide financial reporting metrics down to individual pieces in a specific plant.
• Used CSS, DHTML, Javascript libraries to implemented Fusion Charts XML Developed worldwide purchasing and Sales/CRM applications.
• Utilized Yahoo YUI library to provide in place document editing and the ability to view worldwide inventory and financial calculations Developed internal sales support tool.
• Other projects included MSDS data sheet delivery, currency conversion, material cost calculations, warehouse barcode implementation and migration of classic ASP to .NET pages.

Confidential, Houston, Texas

Developer III

Responsibilities:

• Interacted with manager and project leads to
• Analyzed business needs and requirement, creating proposals and documentation for process improvements.
• Developed Web/SQL applications supporting ERP manufacturing environment.
• Developed, tested and deployed applications.
• Monitored website metrics.
• Wrote DTS ETL packages to load SAP Data into SQL databases and integrate Primavera Project Data and SAP Data. Received a performance award for this project.
• Developed QA application for tracking material through QA department. Cut avg handle time from 45 days to 15.
• Developed Excel bar coding application using dynamic HTML/CSS and developed Reporting Services/CSS in VB.NET.