Sql Server Developer
Resume:
T. MARK FINK
Sanatoga, PA
C: 610-***-****
********@****.***
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