Alan Barber
A developer of Microsoft .Net & SQL Server Technologies
Contact Information, Social Network Links, Portfolio and Resume
Summary of Qualifications:
|
· Software developer with five years of SQL Server and three years of .NET development skills. |
|
· Specializes in the implementation of enterprise solutions that include data collection, processing and reporting using C# and SQL Server. |
|
· Experience in building complete solutions from the front end web and desktop applications to the backend database structures. |
|
· Strong focus on SQL Server development and administration. |
|
· Design and deploy excellent software and services that provide real positive value to my clients both internal and external. |
Areas of Expertise:
· Database development: creation of normalized table structures for optimal data storage; creation of stored procedures for optimal data access and updating; optimizing and tuning queries for maximum performance.
· Database administration: setting up and managing of database backups; scheduling preventive maintenance processes including rebuilding indexes and updating outdated statistics; monitoring high activity stored procedures and ad hoc queries for targeted tuning and optimizations.
· Backend enterprise applications: using C# to create custom services and applications for database import / export, automating processes to import / export customer data to and from third party systems.
· Front End enterprise applications: creating basic C# ASP.NET Web Forms for data entry and management; creation of C# ASP.NET Web Forms for reporting of customer data; building internal enterprise portals applications for operation of complex enterprise processes including billing and payroll systems.
Technical Skills Summary:
|
Platforms: |
Windows XP / Vista / 7, Windows Server 2003, FreeBSD, Linux |
|
Software: |
Microsoft Visual Studio (6.0, 2005, 2008, 2010), VMWARE Server, Microsoft SQL Server 2000/2005, IIS, Apache Web Server, Microsoft Exchange (2000, 2003), Microsoft Office Suite (Word, Excel, PowerPoint, Outlook, Access) |
|
Databases: |
Microsoft SQL Server 2000/2005 |
|
Languages: |
C#.Net, Visual Basic, ASP, PHP, HTML, JavaScript |
|
Networking: |
TCP/IP, IPX/SPX, Ethernet, Wireless (802.11b/g) |
|
Phone Systems: |
Syntellect Communication Portal, Inter-Tel PBX |
|
Experience Profile |
Quick Solutions, Inc., Columbus, OH 01/2011 – Present
Consultant
· Provide onsite .Net and SQL Server developer services for client projects.
Corporate Research International, Findlay, OH 11/2005 – 01/2011
Senior Programmer 09/2007 – 02/2011
Programmer 11/2005 – 09/2007
· Work on many new client projects as well as maintain current running projects using both new .NET technologies as well as legacy tool sets.
· Take charge of a majority of internal enterprise improvement projects working at all levels of the development process.
· Operate as primary DBA, working with an outsourced DBA consulting service for additional support, and oversee database development and provide guidance and support of the other programmers.
(Corporate Research International, continued)
· Manage the data center containing web (IIS), database (SQL Server), email (Exchange), pbx, phone survey and networking equipment.
· Responsible for day-to-day operations of monitoring and performing proactive maintenance on all data center systems.
· Created custom web forms to collect consumer surveys of client’s businesses.
· Designed custom reporting websites to present survey results to clients.
· Integrated internal reporting systems with third party reporting service companies for clients.
· Provided internal hardware/software/user management and support.
· Worked to resolve emergency situation after lightning strike on building damaged several servers.
· Worked as a team with management to plan and implement the upgrade and replacement of hardware and software in data center as necessary.
· Responsible for maintenance of SQL Server database servers including design, development, query tuning, backups, and index maintenance.
Project: PayPal Payment Option
· Implemented PayPal as a payroll payment option for contractors.
· Built SQL tables structures and stored procedures.
· Modified payroll administration tools to collect and manage PayPal account information.
· Created custom C# ASP.Net based web service to interface with PayPal IPN system for tracking of payment activities.
Project: Social Security Number Validation System
· Modified administration tools to collect and manage SSN validation.
· Created C# service to export new SSNs into correct data file format for manual upload to Social Security Administration and importing of return data file for validation.
Project: Employee phone activity reporting tool
· Created C# service to export text logs from InterTel Axxess PBX and import into SQL database.
· Created series of C# ASP.Net reports for management to track and monitor telephone activity of employees.
Project: Employee Vacation management system
· Created a complete rewrite of a custom employee vacation management system.
· Created all new table structures, reporting views and stored procedures to provide a consistent API for adding, modifying and removing vacation information.
· Created custom algorithm using only TSQL to calculate accrual rates as well as correctly deducting vacation time.
· Reused and overhauled legacy web based front end on company portal.
Ninkybink.com, Bowling Green, OH 02/2005 - Present
Website Designer
· Managed domain name registration and hosting for client website.
· Created the website layout and design.
· Worked with the client to add appropriate content to the website.
|
Volunteer Experience |
Columbus Give Camp 2011, Columbus, OH 05/2011
Website Designer
· Migrated static website for charity, Pets Without Parents, to free Telerik SiteFinity CMS platform.
Grand Rapids Give Camp 2009, Grand Rapids, MI 11/2009
Website Designer
· Created data collection tools as part of team for Volunteer Center of Greater Kalamazoo using .Net Nuke CMS platform.
BlessedJohn.org, Perrysburg, OH 09/2005 – 05/2008
Website Designer
· Managed domain name registration and hosting for client website.
· Designed layout and content.
· Provided general maintenance and site updates.
|
Education & Professional Affiliations |
Education:
· Bachelor of Science in Computer Science, Science minor, Bowling Green State University, Bowling Green, OH
Professional Affiliations:
· Member, Columbus .Net User Group, 2011 - Present
· Member, Findlay Area .Net User Group, 2008 - 2011
· Member, PASS (Professional Association of SQL Server), 2010 – Present
· Regular Attendee of Regional Developer Conferences
