Thomas Williams

** ****** ******

Farmington, CT 0632

860-***-****

acxqy8@r.postjobfree.com

CAREER OBJECTIVE:

Obtain a position as a team-player in a people-oriented organization where I can maximize my 20 plus years of systems development experience in a challenging environment to achieve the corporate goals.

CAREER SUMMARY:

I am an accomplished Database and Systems Designer, Data Modeler, Data Analyst, Business Intelligence Specialist, and Report Writer with over 20 years of experience in developing systems for several business sectors in the Connecticut area including Health Care, Insurance, Banking/Financial and Government Contractor firms. I am a dynamic, detail-oriented systems professional known for delivering high quality database and B.I. application solutions and designing and building complex database solutions and multi-dimensional Data Warehouse Systems and E.D.I. solutions.

PROFESSIONAL EXPERIENCE:

Community Health Center, Inc. Middletown, CT 5-2016 - Present

As Senior Business Intelligence Architect I performed data analysis and met with business partners to determine and document their requirements for changes to the existing environment as well as new systems needed.

I documented current system ETL flows, and database schemas. I also made changes and enhancements to existing databases, SSIS packages, SSRS and Excel Reports. I also worked on ETL interfacing with the company’s external systems including NovaTime, Workday, Great Plains, IVR, and MailChimp.

Software Utilized: SQL Server Management Studio 2014, Visual Studio 2013, SSIS, SSRS, SharePoint.

The Farmington Company 8/2015 - 03/2016

As a Senior Database Developer and ETL Architect, and Data Analyst I worked on the "Electronic Billing System" here at The Farmington Co. It is being designed to replace and enhance a current manually done process.

My tasks include creating and maintaining a Microsoft SQL Server 2013 Database, as well as data analysis from outside vendor files, mapping data into a new database, writing ETL using Visual Studio 2013 SSIS packages. I also create extract files to be sent to the billing department for payment processing. Interfaced with the company’s E.R.P systems and created interfaces and extracts from them.

Software Used: Visual Studio 2013, SSIS, SAAS, Microsoft SQL Server 2013, Visual C##

Robert Half Technologies, Hartford, CT Feb 2015 - May 2015

Data Warehouse and SQL Server System Data Integrator.

• I worked as the technical lead, database developer, and data analyst on the "Profitability Reporting" System.

• This involved coordinating and integrating data from different Systems and database into a new data warehouse to track, record, and report on personnel income, expense and profitability to the company.

• I also designed and created a new database and tables for this data and the wrote ETL (Extract Transform and Load) scripts, as well as creating complex reusable SQL Queries and Report Programs.

• Interfaced with the company’s E.R.P systems and created interfaces and extracts from them.

• Software Utilized: Microsoft SQL Server 2013, SSIS, SSRS, Oracle, DB2, Management Studio, Access (VBA), ANSI SQL, Excel, Microsoft Office Suite

United Technologies, South Windsor, CT May 2014 - January 2015

Data Warehouse and SQL Server System Data Integrator and Report Developer

• I worked as the technical lead, data warehouse developer and data analyst on the "Operational Excellence" computer Inventory and Reporting System.

• This involved coordinating and integrating data from different United Technologies and database into a new database to track, record, and report on computer inventory and software compliance.

• I also created a new database and tables for this data and wrote ETL (Extract Transform and Load) scripts, as well as creating complex reusable SQL Queries and Report Programs. Interfaced with the company’s E.R.P systems and created interfaces and extracts from them.

• Software Utilized: Microsoft SQL Server 2012, SSIS, SSRS, Management Studio, Access (VBA), ANSI SQL, Excel, Microsoft Office Suite, Perl scripting.

Hartford Hospital Group, Hartford, CT Sept 2013 - Nov 2013

Data Warehouse and SQL Server System Data Integrator and Report Developer

• I worked as the technical lead on the "Healthiness Together" Employee

health incentive data warehouse system.

• This involved coordinating and integrating

data from different Hartford Hospital Systems into a new database to

track, record, and report on Employee's compliance with Wellness

incentives and determine qualifications for financial rewards based

on the completion of wellness based incentive activities.

• I wrote extensive ETL (Extract Transform and Load) scripts, as well as creating complex reusable SQL Queries and Report Programs.

• Interfaced with the company’s E.R.P systems and created interfaces and extracts from them.

• Software Utilized: Microsoft SQL Server 2012, SSIS, SSRS, Management Studio, Access (VBA), ANSI SQL, Excel, Microsoft Office Suite

Fallon Community Health Plan, Worcester, MA March 2013 - May 2013

Data Warehouse and SQL Server System and Report Developer

• I worked as a lead data warehouse developer on a “Client Enrollment Census and Status” system/

• I also met with business users to gather and document their requirements for changes and corrections to production reports that had errors.

• I provided standardized E.D.I. data transfers of member census update data for clients.

• Corrected Crystal Reports with SQL/Oracle backend databases to correct errors and enhance them according to business requirements.

• Developed complex SQL and stored procedures to extract data from the databases, and created extract files and reports to deliver data to the business users.

• Interfaced with the company’s E.R.P systems and created interfaces and extracts from them.

• Software Utilized: Microsoft SQL Server 2010, SSIS, SSRS, Management Studio, ANSI SQL, Oracle10G, Crystal Reports, Excel, Microsoft Office Suite.

United Technologies, East Hartford, CT May 2012 - Dec 2012

Data Warehouse and SQL Server System and Report Developer

• Met with business users to gather and document their requirements for data from various sources and systems from within the organization to be and loaded into databases for corporate security analysis and reporting.

• Created databases, tables, and ETL processes to house corporate data to meet the corporation’s business requirements.

• Provided standardized E.D.I. data transfers of computer inventory and trouble ticket data.

• Developed complex SQL queries and stored procedures to extract data from the databases, and create extract files and reports to deliver data to the business users.

• Interfaced with the company’s E.R.P systems and created interfaces and extracts from them.

• Software Utilized: Microsoft SQL Server 2005, 2008, 2010, SSIS, SSRS, Management Studio, ANSI SQL. Crystal Reports, Excel,, Access (VBA), Microsoft Office Suite, Perl scripting.

Cigna Healthcare, Bloomfield, CT Mar 2012 - May 2012

Data Warehouse and Senior Programmer/Analyst

• Developed complex programs to extract data from DB2 databases, create extract files and Excel files using SAS.

• Analyzed programs that other programmers wrote and created application design specification documents for the team.

• Interfaced with the company’s E.R.P systems and created interfaces and extracts from them.

• Software Utilized: SAS 9.2, ANSI SQL, Unix, and MS Word,, Access (VBA).

Nestle Waters, Stamford, CT Jun 2011 - Feb 2012

Data Warehouse Developer/Analyst

• Performed database and Database Analysis with large corporate databases.

Provided standardized E.D.I. data transfers of delivery and timekeeping data.

• Created complex queries and stored procedures to produce extract files, data feeds, and reports.

• Met with business users to gather and document new data, report, and cube requirements. Wrote new reports utilizing Crystal Reports, Excel, and SQL.

• Performed troubleshooting and correcting of data, database, and reporting issues.

• Software Utilized: SQL Server 2008, SSIS, SSRS, Management Studio, ANSI SQL, Microsoft Query Analyzer, Analysis Manager, SSIS, DTS, Crystal Reports, and Business Objects,, Perl scripting.

Northeast Utilities, Berlin, CT Aug 2010 - Apr 2011

Data Warehouse Developer/Analyst

• Met with business users to identify system and data resources to fulfill business requirements. Conducted requirements gathering sessions, weekly status meetings, and technical walkthroughs with various business and technical team members.

• Performed database analysis and write complex SQL queries to deliver data to statistical analysts for forecast modeling projects.

• Hardware Utilized: IBM UNIX servers, IBM workstations.

• Software Utilized: Informatica 9.0.1, MS SQL Server 2005/2008; DTS; SSIS; SSRS; SAS; SQL; ANSI SQL, Oracle, DB2, Transact SQL; AQT; SAS 9, Perl scripting.

Citizens Bank, Bridgeport, CT Jun 2009 - Feb 2010

Senior Database Analyst/Developer

• Met with business systems users to identify system and data resources to fulfill business requirements.

• Conducted requirements gathering sessions, weekly status meetings, and Technical walkthroughs with various business and technical team members.

• Senior Relational Database Designer/Modeler/Programmer for the Everyday Points Multiplier project.

• Performed database modeling, design, and implementation for the DataMart.

Provided standardized E.D.I. data transfers of customer account and transaction data.

• Wrote SSIS packages and complex SQL queries to extract and move data in the data warehouse storage facility to provide reports to meet the business partner’s requirements.

• Produced technical documentation for the project.

• Also served as a Data Quality Analyst for the KPF Data Mart project.

• Reviewed and analyzed data after it has been loaded into the staging layer of the data mart to ensure data quality standards were being met. Took note of data integrity issues and informed the ETL developers and technical project managers of anomalies found between different database tables in the data mart.

• Hardware Utilized: IBM UNIX servers, IBM workstations. • Software Utilized: MS SQL Server 2000/2005; DTS; SSIS; SSRS; SSAS; SQL; Transact SQL, ANSI SQL, Toad; SAS,, Access (VBA).

Cigna Health Insurance Company, Bloomfield, CT Sep 2006 - Feb 2009

Database Developer and Data Strategist

• Lead the QA, testing, and development effort to upgrade a large database application from Microsoft SQL Server 2000 to 2005. This involved converting many complex DTS jobs and stored procedures to SSIS packages as well as converting the data into the 2005 database platform, database testing/quality assurance.

• Created and executed test plans and test cases as a quality assurance team member. This included Database, Data Mart, and White Box testing.

• Built and managed test data for enterprise wide database applications.

• Database design, modeling, and implementation.

• Developed complex SQL queries/procedures with MS SQL Server.

• Maintained communications between quality assurance and development teams.

• Hardware Utilized: IBM UNIX servers, IBM workstations, 390x mainframes.

• Software Utilized: MS SQL Server 2000/2005; DTS; SSIS; SSRS; SSAS; Oracle 8.0; DB2, QMF Mainframe/Windows for DB2; Stored Procedures, PL/SQL, ANSI SQL.

General Electric Asset Management Company, Stamford, CT Mar 2006 - Aug 2006

Senior Data Warehouse Developer/Analyst

• Completed a large Business Objects report migration project. Responsibilities were to revise and test corporate reports to run off a new database platform. Also responsible for tracking the detailed progress of the project and communicating this to project management.

Provided standardized E.D.I. data transfers of customer and transaction data.

• I also created and modified many Business Objects Webi reports.

• Hardware/Software: Business Objects 6.5, Webi, Oracle9i, Embarcdero Rapid SQL, Oracle PL/SQL, ANSI SQL,, Access (VBA),

Perl scripting.

Pratt & Whitney Aircraft, East Hartford, CT Sep 2005 - Dec 2005

Senior Data Warehouse Developer/Analyst

• Wrote many complex reports using Business objects Reporter. Created new data warehouse databases and performed data modeling and created database objects including tables, keys, and indexes. Developed SQL transact-sql stored procedures to Extract, Transform, and Load data into this new data warehouse database.

• Created reports and data extract programs to provide data per business user’s requirements.

• Hardware/Software: Business Objects, Microsoft SQL Server, Microsoft DTS, Transact-SQL, DDL, and SQL Stored Procedures, ANSI SQL, Perl scripting.. Also, I had heavy usage with Microsoft Enterprise Manager, Query Analyzer, and Visual Source Safe.

OTHER EMPLOYERS:

Pratt & Whitney Aircraft Jan 1998 - Jan 2000

Shawmut/Fleet Bank Apr 1993 - Jan 1998

Ames Department Stores Jul 1991 - Apr 1993

Kaman Aerospace Jan 1990 - Jul 1991

EDUCATION:

Charter Oak College, New Britain, CT

Degree in Business Administration. June, 1987

Rensselaer Polytechnic Institute, Hartford, CT

Certificate in I.T. / Computer Programming - July, 1987.

Industry training:

Certifications in various software packages and languages including;

SQL, Cognos, Business Objects, Crystal Reports.

Contact this candidate