Sql Server Developer

Bob Gaydos

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

Macedonia, OH ***56-1813

home: 330-***-****

mobile: abqbks@r.postjobfree.com

Suitable Roles

Data Analyst, Developer

Background,

Skills & Tools

• Industries: Banking, Manufacturing, Legal, Healthcare, dotcom, Higher Ed, non-profits, Retail

• Coding in SQL, PL/SQL, Transact-SQL, sh/bash, Perl, VBA, Java, Javascript, HTML, CSS, C

• Attentive customer service; Articulate, considerate communication; Engaged in the Big Picture

• Business/systems analysis and documentation; UI design, usability studies; Front- and back-end application development, application ownership and ongoing 24x7 production support

• Data collection, management, analysis & reporting using MS Access, SQL Server, Oracle, DB2, Excel, XMLSpy and Windows/Unix/Linux XML- and text-based tools and scripts (perl, awk); ETL, data scrubbing, QA, migration, transformation; DOM APIs; UltraEdit; ad hoc custom tools

• Database and data warehouse modeling, design, development & support; DB administration of Unify DBMS, DB/C, Access and SQL Server; JDBC, ADO, DAO; ODBC; Toad, WinSQL

• Windows and Unix help desk, desktop support and training; writing of user documentation.

• Web development using Java servlets w/JDBC, Javascript, JBoss, Tomcat, ant, Eclipse

• Web site setup, design and content maintenance; Manage domains, subdomains, SSL certs; DNS configuration; Site traffic and user activity analysis of Apache & IIS logs using SQL, Perl

IT Experience

Database Developer, MediQuant, June 2012 – Present

• Analysis, transformation and loading of client (hospital or medical practice) data into the DataArk application using SQL Server 2008 R2; validation of data throughout the process.

• Perl and bash scripting to build analytical and file processing tools.

• Conception, design and development of a web-based Query Management System used for common tasks of data validation and database configuration. Results recorded for statistics.

Contractor

Developer, Dealer Tire, Apr 2012 – May 2012

Maintenance of a tire pricing application in SQL Server 2008 stored procedures and Excel VBA. Conversion of a table maintenance utility from an ASP web app to an Excel 2010 VBA application.

Contractor

Data Analyst, PNC Bank, Oct 2011 – Feb 2012

QA/validation/reconciliation of loan data ETL processes using SQL, PL/SQL, Toad, UltraEdit, cygwin

Contractor

Java Developer, SparkBase, June – July 2011

Maintenance of SparkBase transaction server. Config/troubleshooting of JBoss v5, PostgreSQL v9.

Contractor

SQL Server Developer, Icon Technology Solutions, May – June 2011

Development on an ETL process for Forest City Enterprises to sync enterprise real estate property data to a property valuation system. Data mapping with SQL Server 2005 T-SQL procedures.

Contractor

Unix C++ & Java, VB Developer, Goodyear Tire & Rubber Co, June 2008 – Oct 2008

• Development and maintenance on the Tactical Pricing System, which services pricing requests from SAP and the legacy mainframe for Goodyear’s North American Tire division.

• Pricing engine written in C++ and Java, runs on HP-UX and Oracle 9; TPS UI written in VB 6.

• Coded Unix shell scripts daily to analyze code, data and test results, and to manage builds.

• Wrote SQL queries to confirm test results and to gain insight into database relationships; Built MS Access tool with VBA/SQL, providing a UI to streamline the database relationship queries.

Contractor

Access Developer, National City Bank, January 2008 – May 2008

• Maintained Access-based system for retail employee incentive payout and reporting system, primarily coding T-SQL pass-through queries in Access against SQL Server 2000 databases.

• Built data mart with Access front end and direct output to Excel for sales trend analytics.

Revised Sep 2012

IT Experience

(continued)

• Designed/developed a flexible dialog-driven sheet comparator in Excel VBA to assist in QA.

Contractor

Database Analyst, Hospice of the Western Reserve, July 2007 – Nov 2007

• Analyzed black-box volunteer management system to determine options for improving functionality and to help Hospice Volunteer Dept staff make better use of existing capabilities.

• Designed and built MS Access application to supplement VolunteerWorks for improved querying, reporting and with additional data elements not provided for in the base system.

• Designed and coded a geolocator module with adaptations of spherical coordinates formulas.

• Provided technical leadership and training to Hospice staff and volunteers, promoting standards of practice for consistency and improved data integrity.

• Developed and presented a proposal for a custom solution to meet Hospice needs, based on existing Hospice infrastructure of MS Access over SQL Server, with Word & Excel integration.

• Assisted in the migration of several organizational database apps from Access to SQL Server.

Contractor

Java & Javascript Developer/Business Analyst, Key Bank, April 2006 – February 2007

• As member of dedicated project team using Agile development methods, built support for marketing promotion system into new-account application logic on key.com web site in Java. Patched C++ logic in analogous client/server system.

• Development and production support on SB2 small business loan underwriting system; analysis/coding/testing of server-side Javascript (Rhino engine) business logic using Provenir Studio; ad hoc analytical DB2 and Oracle SQL queries; dynamic PDF forms using iText.

• Assumed additional Business Analyst role on dedicated project team adding support for a new credit product. Facilitated communication and coordinated with lines of business and owners of multiple interfacing applications; managed timelines; maintained documentation; ensured compliance with corporate information security standards; defined QA parameters and tested.

• Developed an IE browser extension written in Javascript and VBScript to automate parsing of the XML data island from the loan document source for testing and prod support diagnostics.

• Performed system maintenance tasks on Linux decision engine; wrote numerous sh scripts.

Developer, 2Xi Solutions/ImageNet Litigation Support, July 2005 – April 2006

• Developed secure order entry web site to facilitate submission and tracking of incoming client (law firm or corporate legal dept) data discovery projects. System implemented as SQL Server-driven Java servlets using JDBC, running on Apache Tomcat with SSL security.

• Designed, developed and supported several in-house productivity tools in VBA which maintained multiple concurrent ADO connections to operational databases:

MS Access utility to de-duplicate client records spanning dozens of databases.

It replaced a vendor-supplied equivalent by running 25-30 times faster, in hours vs days.

Interactive visual reporting tool detailing the current progress/statistics of client projects.

DB-connected Excel macros to automate labor-intensive data processing by the QC staff.

Contractor

Database Developer, United Jewish Appeal of Greater Toronto, Nov 2004 – Nov 2005

• Completely overhauled MS Access application to manage several hundred volunteers staffing the 2005 General Assembly, an international conference held in Toronto that year. The 2005 version of the application doubled in scope in comparison to 2004 (see below).

• As the sole IT person on the project and veteran of the 2004 event, served as event advisor, providing technical leadership, design, development, training and support of the volunteer management system. As in 2004, the system assisted in the recruitment, scheduling and balanced deployment of the volunteers throughout the convention center, as well as generating email, correspondence, literature, color- and bar-coded ID badges and reports.

• Provided on-site support and training throughout the event in November 2005 and afterward.

Contractor

Database Developer, Jewish Community Federation of Cleveland, Aug 2004 – Nov 2004

• Rebuilt MS Access application to manage several hundred volunteers staffing the 2004 General Assembly, an international conference held in Cleveland that year.

• The application provided tools to assist in the recruitment, scheduling and balanced deployment of the volunteers throughout the convention center, as well as generating email, correspondence, literature, color- and bar-coded ID badges and various reports.

Revised Sep 2012

IT Experience

(continued)

• Coded an interface to the organization’s Oracle fundraising database providing consistency and efficiency, aiding in correcting and deduping records in the origin fundraising system.

• Provided on-site support and training throughout the event in November 2004.

Contractor

Web Designer, Western Reserve Geriatric Education Center, June 2001 – Sep 2001

Redesigned site, graphics and logo using UltraEdit & Macromedia HomeSite/Freehand/Fireworks.

Part-Time Instructor, Cuyahoga Community College, June - July 2000

Taught the course Visual Basic - Introduction at Tri-C's metro campus.

Data Analyst, PlanSoft Corporation, July 2000 - May 2001

• Responsible for producing analyses/reports from numerous web sites run by PlanSoft,

an Internet application service provider to the hospitality and meeting planning industries; supported Sales & Marketing and data acquisition efforts.

Tools - Access, SQL Server, Excel, UltraEdit, Perl, WebTrends, Acrobat

Data sources - flat IIS log files, database records written as log entries by

ASP scripts to record session activity, and the corporate Siebel CRM database

• Created/maintained data marts/warehouses to improve query performance.

• Produced and monitored queries/macros to detect theft of corporate assets.

• Development & support of multistage ETL processes.

• Dynamic business environment required primarily ad hoc queries, but many

sub-processes automated using Access and Excel VBA, macros, SQL and Transact-SQL.

• Email list management (privacy, unsubscription, validation, filtering).

Database Administrator, Health Design Plus, December 1998 - April 2000

• Responsible for maintaining claims system database files for Health Design Plus,

a Hudson, OH based third-party healthcare administrator with a satellite office in Findlay, OH.

• Maintained client relationships for technical support and data exchange.

• Production support of in-house solutions and third-party software products.

• Frequent/daily face time with end users for training, to discuss enhancements & bug reports.

• Extensive use of Perl for manipulating data files; developed processes/software tools in Perl, bash and C to automate data preparation and analysis tasks, such as ETL and merge/purge of healthcare eligibility data originating in various clients' HR systems.

• Created and maintained web pages for corporate intranet; maintained Perl CGI scripts.

• Linux/HP-UX/SCO UnixWare system and network administration; 24x7 software and hardware maintenance of file and application servers, web server, network printers and LAN/WAN equipment; desktop support of Windows PCs.

• Advanced initiatives for adoption of document imaging and fax server technology.

Contractor

Database Developer, Kent State University Apple Store, Nov 1998

Built purchase financing module for POS system in FileMaker Pro v5 on a Mac.

Revised Sep 2012

Kent State University, December 1984 - October 1998

Systems & DB Administrator/Analyst, Campus Bus Service and University Information Systems

• Analysis of multi-departmental requirements; Development and production support of relational database (Unify, MS Access) applications involving inventory management,

service billing, retail operations, purchasing, scheduling, transportation and telephony.

• Frequent face time with end users for training, to discuss enhancements, bug reports and to elicit suggested changes to the user interface.

• Database design and administration using SQL DDL/DML and vendor tools; daily coding of sh and C with db API for business logic support and operational/administrative automation.

• Unix systems administration with 24x7 hardware/software/network support; email admin; server hardware maintenance & operations; systems programming; kernel parameter tuning.

• Recruitment, evaluation, supervision and mentoring of student programming staff.

Education

Ongoing Continuing Education, 1986 – Present

Credit and non-credit coursework at KSU, Cleveland State University and Cuyahoga Community College. Ongoing self-directed technical study; currently studying Meaning from Data: Statistics Made Clear.

Kent State University, 1980 - 1986

Undergraduate and graduate-level coursework in Computer Science/Mathematics

Revised Sep 2012

Contact this candidate