Post Job Free
Sign in

Manager Sql Server

Location:
San Francisco, CA
Posted:
February 15, 2015

Contact this candidate

Resume:

Sean Barkow, MCSD

**** ****** **.

Columbus, OH *3228

614-***-****

acobqg@r.postjobfree.com

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