T. MARK FINK

Sanatoga, PA

H: (***) -***-****

C: 610-***-****

ac5xu1@r.postjobfree.com

SUMMARY

Hardworking and dedicated professional with excellent analytical skills and 20 years of hands-on experience in logical design, testing, and implementation of information systems, combined with supervisory and management experience

OBJECTIVE

To provide value, experience and dedication to an employer who can challenge and grow my professional career by providing opportunities to learn and contribute to a dynamic team environment.

TECHNICAL EXPERTISE

Databases: Microsoft Access / SQL Server 2000 / SQL Server 2005 / SQL Server 2008 R2 / SQL Server 2012 / Data General Info II

Development Tools: Visual Basic. NET / Access / Excel /Visual Studio 2010 / SQL Server SSIS / SSRS / Tableau

Operating Systems: AOS/VS / Windows XP PRO / Windows NT / UNIX

Back Office Tools: Microsoft Office – Excel / Word / Access / Project / Power Point / Adobe Photoshop

EDUCATION

Computer Learning Center

Diploma

Ursinus College

Continuing Education, Computer Programming

App Dev Training

Microsoft SQL Server 2005, SSIS, SSRS, VB.NET, ASP.NET

Pragmatic Works Master SSIS Workshop

2-day training workshop

Edx

Developing SQL Databases, SQL Server 2016

PROFESSIONAL EXPERIENCE

Oct 2017 – Apr 2018 TW Metals, Exton, PA – Report Developer / SQL Developer DBA

Short term contract. – Debug Financial Reports and the SQL code building the data.

Develop SSIS packages and job Agents. Improve accuracy and reliability.

Sept 2017 – Oct 2017 DMW Direct Worldwide, Wayne, PA – SQL Developer DBA

Short term contract. – Automate SQL and SSIS packages and job Agents.

Assist in the running of Production processes.

Sept 2016 – Jan 2017 – HighPoint Solutions, Plymouth Meeting, PA – Senior Consultant

Created stored procedures for DimCalendar project with Holidays and weekends set for years

Reviewed documentation and data structures for upcoming projects

Jan 2014 – Sept 2016 – Rodale, Emmaus, PA – Business Intelligence Systems Analyst

Created data sources for Tableau

Gathered data for an E-tailing project using SSIS to retrieve files from various methods (FTP SFTP API)

Built reports for an E-tailing project using SSRS that were published to SharePoint and the report server

Created subscriptions in SharePoint and Report Server to regularly distribute reports

Created data points that are directed to Tableau for better data visualization

Used SSIS with configuration files to load staging and the data warehouse on a virtual SQL2008 R2

Utilized the Agile Scrum with JIRA ticketing system

Developed stored procedures, triggers, functions, views, Dynamic SQL, T-SQL

Designed and wrote SSRS reports

2008 – 2014 – DMW Direct Worldwide, Wayne, PA – SQL Developer DBA

Created a process in conjunction with a vendor using SP_OAMethods to standardize USPS addresses

Developed ETL process using both T-SQL and SSIS

Established ETL process using just T-SQL reading Excel / Access / Text input

Devised T-SQL ETL process

Served as a Satori Mailroom Toolkit Architect

Established core process on a newly installed system

Completed Data Replication between SQL2005 and SQL2005 express

Set up and created SSRS reports

Performed daily, weekly, monthly and annual backups

Executed database restores as needed

Conducted regular checks on SQL Server agent jobs

Archived files and data by developing job agents to perform regular data and file archiving

Constructed stored procedures, triggers, functions, views, Dynamic SQL

2007 – 2008 – Accounts Recovery Bureau Inc Wyomissing, PA - Programmer

Built SQL 2005 databases

Loaded Databases using SQL Server Integration Services

Created MS Visual Studio 2005 Business Intelligence Development Studio SSIS to read an AS/400 database

Developed a VB.NET process to create Microsoft Excel Workbook

2006 – 2007 – Affordable Oil Spring City PA – Interim Position

Served in an interim non-Information Technologies related capacity

1998 – 2006 - Info Technologies, Inc., Ajilon DE, System Staffing Group, CIGNA - Consultant

Converted claim letters into a document management package

Performed coding in a Visual Basic formatted language

Provided computer services to support small businesses and personal computing needs

Wrote, tested, and implemented Automatic Document Generator, Word 97 Macros & VBA, WordPerfect Macros

Delivered error tracking and resolution efforts in multi-tier environment

Created testing environments for full automation of document publishing conversion

Redefined, rewrote, tested, installed macros for firm’s entire airline system

Designed, wrote, verified, and implemented a Word-to-Web Questionnaire system in Visual Basic

Planned the functional re-organization of mailroom facility, including software and workflow

1995 – 1998 Provident Indemnity Insurance Norristown PA - Programmer Analyst Technician

Conceptualized, wrote and tested in COBOL for a Loss Ratio System

Provided full-time technical support to operations and field customers

Performed INFOS Database Administration, including logs, backups, differentials, and space management

Formulated & tested COBOL programs for macro merges of print documents on Xerox copier equipment

1991 – 1994 Independent Consulting - Programmer Operations Associate

Formulated a contract scheduling system

Conducted an Operations Department review

Printed large mailing documents

Installed networks

Wrote a marketing production system

1982 – 1991 World Life and Health Insurance Company - King of Prussia PA - Operations Manager Programmer

Designed and established a new computer operations department

Performed and conducted Administrator Database batch jobs, backup, batch, printing, and distribution procedures

Provided INFOS Database Administration, including logs, backups, differentials, and space management

Administrated 13 database systems for daily, weekly, monthly and annual operations

Completed projects, eliminating paper printouts in favor of sending files electronically to internal company departments, credit card companies, banks and office support organizations

Wrote and tested COBOL programs for macro merges of print documents on Xerox copier equipment

Hired, trained and evaluated employees

Designed and implemented multiple systems including Tape library database system

Controlled the Mailroom Instant Label System, Agent Production, New Business Products, Card Embossing

Managed the printing of Policies, Premium notices on a Xerox 4050

PERSONAL ATTRIBUTES

President Phoenixville Jaycees 2000-2004

Phoenixville Fire Department - State Certification – 20 years Emergency response

Organized Annual Dogwood Parade with over 20,000 attendees for 5 years

Center for Arts & Technology Hall of Fame Member 2005

2008 Phoenixville Citizen Recognition Award

Philadelphia SQL Server Users Group (Director)

Contact this candidate