Manager Sql Server
Resume:
Sean Barkow, MCSD
Columbus, OH *3228
********@*****.***
LinkedIn Profile
Career Objective:
I am a Microsoft Certified Solution Developer with 15 years of experience
in software development and relational database design. I am well versed in
both Microsoft .NET and COM technologies. My goal is to land a position
that allows me to use the latest technologies, apply my current skills, and
also gives me the opportunity to expand the scope of my current technical
knowledge. I have spent the last four years working various short term
contracting positions which have given me exposure to new industries. I am
very adaptable to new work environments and I've worked in development
groups of all sizes while currently working in the capacity of team lead.
PROFESSIONAL EXPERIENCE:
FacilitySource- Columbus, OH
Senior Software Developer Team Lead - Client Onboarding
July 2014 - Current
. Supervise a group of local and offshore developers in Costa Rica.
. Delegate work tasks to developers as appropriate and oversee
progress of work being done.
. Lead daily scrum meetings to ensure that we are on schedule to meet
our release deadlines.
. Organize initial setup for new clients coming onboard including
data migration and application customization.
. Attend management meetings to stay informed of new endeavors and
the impact this will have on my group.
. Handle miscellanies managerial tasks for my manager when he is busy
with higher level responsibilities.
. Interview prospective candidates for new developer job openings and
assist in making hiring decisions.
. Perform custom enhancements for clients as required.
Red Roof Inn Corporate (via Sabre Hospitality) - Columbus, OH
Independent Consultant - Senior .NET Software Developer
January 2014 - June 2014
. Manage the Red Roof Inn Property Management System, StayMgr, used
by all RRI Hotels.
. Complete bug fixes in the C#.NET PMS system as needed.
. Modify and enhance PMS custom reports to client specifications and
create new reports via Crystal Reports.
. Handle high level escalations from the RRI tech support group which
require code enhancements/bug fixes.
Abbott Nutrition - Process Research Center (via American Cybersystems) -
Columbus, OH
Independent Consultant -Senior Programmer Analyst
June 2013 - August 2013
. Administrator of the .NET DevEX proprietary software system.
. Make enhancements to DevEX software system via customization of
user controls and config files.
. Assist DBA with Teradata query optimizations for DevEX CRUD
functionality.
Cardinal Health (via Unicon International) - Dublin, OH
Independent Consultant - Senior Applications Developer
January 2013 - April 2013
. Created a Patient Care Portal web application designed for United
Health Care pharmacy clients to manage patient healthcare adherence
programs primarily geared towards diabetes patients.
. Implemented bug fixes on web applications which were causing
usability issues for end users which involved making code logic
changes to accommodate multi user environments.
. Designed a console batch application for obtaining daily sales
statistics which auto emails results to management.
Maximus/Q2Administrators - Westerville, OH
Independent Consultant - Senior Web Applications Developer
June 2012 - December 2012
. Enhanced ASP.NET 2008 Qic Quality auditing software by extending
its current capabilities enabling auditors to more quickly complete
the auditing process.
. Extended QIC Quality software classes to calculate various
statistical data such as appeal entry errors and created reports
for tracking top findings and entry errors.
. Extended Qic Letter middle tier module used for auto generating MS
Word Medicare documents by adding new letter templates and linking
document fields to new database fields which auto fill the
documents data.
. Corrected calculation bugs in the Qic Stats ASP Classic application
resulting in valid, reliable information being displayed in real
time which is monitored by claims adjudicators.
. Successfully upgraded ASP.NET 1.1 Qic Recon application to ASP.NET
4.0 and added additional fields to various data screens as well as
modified the SQL Server 2008 schema to accommodate the new fields
and altered all stored procedures for performing all CRUD
operations.
. Designed an ASP.NET 4.0 new hire onboarding application for
tracking common tasks involved in the hiring process for contracted
employees.
. Designed the data schema in SQL Server 2008 and wrote all stored
procedures related to the onboarding system.
Nationwide Insurance - Columbus, OH
Independent Consultant - Senior Programmer Analyst
February 2011 - December 2011
. Successfully completed a Proof of Concept to demonstrate the
ability to move legacy data from COBOL to a RDBMS system, i.e.
Oracle, using C#/. NET and COM technologies.
. Analyze the auto line's rating engine business logic written in C++
to prepare for a migration to C#.
. Assist COBOL developers in the rewrite of existing COBOL
application interfaces to the .NET platform.
. Write Ruby/Cucumber acceptance test scripts.
. Participate in a team effort using agile methodologies on a team of
25+ developers, BA's, RA's etc.
. Design software components by following existing agile user story
cards.
. Participate in pair programming with other developers for cross
training.
. Mentor COBOL developers on object oriented concepts via C#
programming.
Butler Schein Animal Health - Dublin, OH (Formerly Butler Animal Health
Supply, LLC)
Senior .NET Developer
November 2006 - December 2010
. Manage VB6/C++ DVM Manager client/server veterinarian practice
management software and integrate .NET add on components as
required.
. Successfully coordinated and implemented 4 major DVM Manager
Software releases.
. Designed a C# based Treatment Sheet application which integrates
with DVM Manager for the purpose of enabling a complete electronic,
paperless medical record.
. Developed components for the C# WCF rewrite of DVM Manager, named
Companion/Triple Crown, and lead a team of 6 to 8 developers, 2
testers, and 6 over seas developers.
. Lead daily SCRUM meetings, mentored junior level programmers,
delegate work tasks, and ensure that incremental test release
deadlines were met.
. Extensive use of C#, VB 2005, ASP.NET, ADO.NET, SQL Server 2005,
stored procedures, Active Reports.NET/2.0, Visual Studio 2005/2008,
frameworks 2.0/3.0/3.5, NUnit, as well as Infragistics and Telerik
control suite.
. Designed C#/ASP.NET/SQL Server 2005 knowledge base intranet
application used by the technical support team.
. Designed a C#/ASP.NET/SQL Server 2005 reporting system for the
sales management team for statistical reports from the Goldmine
database utilizing Active Reports.NET.
. Designed an ad hoc query/reporting system for sales management team
using Stonefield Query which empowered users to easily design their
own custom ad-hoc reports.
. Manage and enhance the existing ASP DvmMgr.com and AccessButler.com
web sites being a hybrid of ASP Classic and .NET technologies.
. Managed existing InstallShield 6.5 projects for DVM Manager
installer programs as well as design and modify new InstallShield
12 projects for the Companion/Triple Crown winforms product.
. Fielded escalated software support calls for advanced software
issues from the software support team.
AMC Registry Inc. - Upper Arlington, OH
Programmer Analyst
June 2005 - November 2006
. Managed VB6 Chest Pain Registry Xpress client/server application
used by hospital emergency rooms for data collection and monthly
data updates to AMC for analysis and reporting.
. Developed VB.NET Winforms upgrade to the Registry Xpress
application which utilizes XML export files in place of comma
delimited text files, and a new SQL Server 2005 Express database in
place of MS Access.
. Designed and maintained the AmcInc.us ASP.NET website.
. Migrated/converted data from MS Access to SQL Server 2005
databases.
. Designed a VB.NET hospital data import system to pre-process
hospital XML upload files to ensure that only valid and complete
data gets imported into the master database system for reporting.
. Create InstallShield 11and 11.5 installers for client updates and
full installs which implement VB.NET dll's and exe's for additional
custom functionality.
. Developed the Information Management Action Request (IMAR) ASP.NET
intranet application which utilizes master pages, custom user
controls, web parts, stored procedures, and custom views.
. Designed the ASP.NET/VB.NET/SQL Server 2005 EKG/Symptom reporting
system which uses Active Reports.NET for process improvement
statistic reporting on the master data set.
. Created help files and documentation for all software applications.
. Managed the VB6 Society of Chest Pain Centers Accreditation
software and redesigned it to accommodate multi-cycle functionality
and created custom ad-hoc reports using Active Reports 2.0.
. Fielded escalated software support calls for advanced software
issues.
World Travel BTI - Dublin, OH
Programmer Analyst
January 2001 - June 2005
. Designed an ASP.NET/C# UI and middle tier for the Client
Information System linking to a SQL Server 2000 back end utilizing
ADO.NET, ODBC, forms authentication and stored procedures.
. Developed a MS Access tracking system for managing monthly
reporting processes for report coordinators to track their own
progress utilizing tables, queries, forms, reports, and VBA
modules.
. Designed an ASP.NET front end and middle tier management utility
enabling managers and supervisors to monitor the activity and
progress of the report coordinators during the reporting cycle.
. Created automation VBScripts for the AS/400 Personal Communications
Emulator to automate the generation of data integrity verification
reports used by the coordinators.
. Created VBScript prompting scripts to run various common AS/400
reports within the emulator program which dramatically reduced the
time it takes a coordinator to run these reports manually.
. Designed custom Excel VBA macros to perform special formatting on
Excel reports as well as created templates for other custom report
formats.
. Perform bug fixes on various applications as needed.
DIRECTV Inc - El Segundo, CA
Developer - Sales Division
July 1994 - January 2000
. Designed a VB6/MS Access 97 Dealer Tracking System for tracking new
prospective dealers and existing dealers which are used by the
dealer services representatives and the sales support department.
. Developed a VB6 process for importing weekly commission data,
provided by the accounting department in Excel format, into the
Tracking Systems master database.
. Developed a VB6/MS Access 97 Escalation Tracking System for
tracking fraud related issues.
. Managed a group of 12 contractors for a commission reconciliation
project that took 4 months to complete.
. Created AS/400 VBScript scripts to extract specific customer
account information that were saved to comma-delimited files and
used by other scripts to perform the actual reconciliation process.
. Created AS/400 automation scripts to automate many of the common
tasks performed by dealer services representatives resulting in
higher productivity.
. Provided staff training on the use of the various software systems
and added new functionality as needed.
. Fielded and logged all escalated fraud issues and acted as liaison
between the sales department and the fraud department.
Sunrider International - Torrance, CA
Supervisor - Customer Service Department
March 1990 - July 1994
. Responsible for supervision, training, and quality assurance of a
team of 8 employees within the order entry department that consists
of approximately 50 employees.
. Delegate work assignments and coordinate work schedules.
. Attend weekly management meetings to review department related
issues.
. Conducted first level interviews with job candidates.
. Monitored calls to ensure that guidelines were being followed for
quality assurance.
. Performed annual reviews with employees and provided reports to
manager on their performance.
EDUCATION:
TechSkills - Columbus, OH
Microsoft Certification Program - January 2000 - December 2000
COMPUTER SKILLS/OS/LANGUAGES/APPLICATIONS:
OPERATING SYSTEMS: Windows 7/Vista/XP/2000/ NT/98/95 and Macintosh Snow
Leopard
LANGUAGES: C#, VB.NET, Visual Basic 6, VBA, VBScript, C++, Javascript,
Objective-C, Java, Ruby, PHP
TECHNOLOGIES: ASP.NET, ASP Classic, ADO.NET, ADO Classic, Web Services
1.1/1.0, SQL, T-SQL, PL-SQL,
. NET Frameworks 4.0/3.5/3.0/2.0/1.1/1.0, LINQ, ORM, DAO, SOAP, XML, HTML,
AJAX, WCF, Entity Framework
DATABASE SYSTEMS: MS SQL Server 2012/2008/2005/2000, Oracle 10g, MS Access,
MySQL
SOFTWARE:
Visual Studio .NET 2013/2010/2008/2005/2003/2002, Microsoft Office (all
versions), MS Outlook, AS/400 Emulators, IIS, Adobe Acrobat Professional,
InstallShield 12/11.5/11/6.5, HelpScribble, Visio, Microsoft Project, Front
Page, Subversion, Source Safe, NUnit, Stonefield Query, Goldmine, Active
Reports 3.0 .net/2.0, SSRS, Crystal Reports, Inno Setup Installer, Cold
Fusion, RubyMine 3, Cucumber, Citrix, XCode, SQL Tools 1.5, Apache Web
Servers, IIS Web Servers, DevEX, Team Foundation Server
CERTIFICATIONS:
MCSD (Microsoft Certified Solution Developer)
MCP (Microsoft Certified Professional)
Contact this candidate