SKILLS

CORE SKILLS
SQL Server Visual Basic .NET MS Access Crystal Reports

DATABASES

• Developed and maintained over 40 databases with sizes up to 120 GB
• Created data architecture for databases having hundreds of tables
• Coded complex stored procedures and triggers for data access, audit logs, and data verification
• Transferred legacy data from MS Access, Progress, AS/400, and other SQL databases using SSIS, DTS, BCP, and other methods
• Performance-tuned databases and servers to optimize information access for users
• Designed reports in Crystal Reports, Infomaker, and MS Access accessing SQL Server data
• Set up international synchronization to satellite offices and sales laptops
• Remotely maintained SQL Server and Sybase databases

Microsoft Access and Visual Basic for Applications

• Proficient in Access 2.0, 95, 97, and 2000, 2002, 2003 and Visual Basic for Applications
• Created and maintained over seventy database applications with up to 150 users
• Created databases with ODBC to AS/400, SQL Server 6.5, 7.0, 2000, 2005

PROGRAMMING LANGUAGES

• Collaborated on Vehicle Engineering software using VB .NET 2008 and Crystal Reports 2008
• Developed issue tracking software in VB .NET 2005 with SQL Server 2005 database
• Designed integrated Crystal Reports in Crystal Reports 2008, XI
• Created over 10 applications with multiple users and database functionality
• Transformed MS Access programs to more stable VB .NET and Visual Basic 6.0

• Created corporate IT support pages and developed web page for local musician

• Created over 15 applications in C/C++ and four years training in C/C++ development

APPLICATION ADMINISTRATION AND DEVELOPMENT

• Implemented and administered task management system for IT and Programming teams
• Developed work request forms, web entry forms, and email notifications

• Administered ERP system and assisted users
• Created reports in Crystal Reports to retrieve financial and inventory information

• Implemented, upgraded, administered, and maintained Customer Relations Management program for 70 users in 5 countries and 16 remote salesmen

ACCOUNTING, FINANCE, and HUMAN RESOURCES

• ACCPAC/SBT - Peachtree Complete - UltiPro PEO

DATABASES

• SQL Server 2005, 2000, 7.0 - MS Access 2003, XP, 2000 - BTrieve
• Pervasive - FoxPro - AS/400

REPORTING

• Crystal Reports 2008, XI, 10.0 - Infomaker

MICROSOFT OFFICE SUITE AND APPLICATIONS

• Project - Excel - Word
• Front Page - PowerPoint - Outlook

Confidential, Southfield, MI
As the Lead SQL Server Database Developer, was lead architect for all SQL Server project development for CIBER client.

• Responsible for development, testing, and implementation of all SQL Server Projects
• Worked with end users to develop project specifications, requirements, and timing.
• Designed tables, stored procedures, and SQL Server jobs
• Created and modified DTS and SSIS packages
• Automated data transfer between SQL Server installations and AS/400.
• Coordinated cross-country move and renaming of vital SQL Server installation
• Developed automated order entry system to standardize customer orders and reduce overhead
• Technical Environment: SQL Server 2005/2000

(September 2009 – Present)

Confidential, New Hudson, MI
As the SQL Server Database Administrator for Purchased and Internal Applications, responsible for database design, performance tuning, and server administration for SQL Server installations.

• Gathered requirements, designed database architecture, created security, performance-tuned, and developed stored procedures, UDFs, and triggers for databases for internal applications
• Responsible for databases for all purchased applications, including installation, user and group security, and monitoring
• Maintained database servers, including memory and physical data storage allocation, performance monitoring and tuning, disk and tape backup, and replication
• Helped develop SQL coding standards for internal and commercial applications
• Upgraded SQL 2000 databases to SQL 2005 and migrated to new server
• Migrated data to SQL Server from other DBs using SSIS, DTS, and other methods
• Reporting expert for software development team
• Developed issue tracking and race engineering applications in VB.NET 2008, 2005, and 2003 and SQL Server 2005 & 2000.
• Improved efficiency of IT and development groups by implementing Alexsys Task Management System.
• Administered Global Shop, an Enterprise Resource Planning (ERP) system.
• Created financial and inventory reports in Crystal Reports.
• Created inventory and time tracking MS Access databases.
• Provided IT support for 70 users and four servers.
• Managed security and fire systems, Telrad phone system and voicemail, and Nextel phones and Blackberries.
• Technical Environment: SQL 2000/2005, SQL Server, SSIS, DTS, Crystal Reports 10/XI/2008, Visual Basic .NET 2003/2005/2008, MS Access 2000/2002/2003, Alexsys Task Management System, Global Shop ERP, Windows Server 2003, Telrad

(January 2003 – August 2009)

Confidential, Pontiac, MI
As Database Application Developer, created software for financial department

• Developed financial application to estimate vehicle prototyping costs.
• Transferred data to Microsoft Access from Oracle, Excel, and other MS Access databases.
• Technical Environment: MS Access, Oracle, Excel

Confidential, Troy, MI
As Database Administrator, coordinated move of data to new Human Resources system

• Upgraded payroll and benefits system.
• Transferred data to SQL Server using DTS, BCP, and other methods.
• Tuned DB applications.
• Technical Environment: SQL Server 2000, MS Access

EMPLOYMENT

EDUCATION

• purchased applications
• Traveled internationally to set up Connect-Care installations.
• Using DTS, migrated data to SQL Server from older applications
• Setup synchronization of data between Sybase and MS SQL databases
• Ran overnight remote upgrades of database and software on five servers and 70 users
• Led conversion of financial systems to ACCPAC/SBT
• Created Infomaker reports to track CRM and financial information for management
• Technical Environment: SQL Server 6.5/7/2000, MS Access, Connect-Care, Infomaker

(September 2000 – January 2002)

KMART INFORMATION SYSTEMS Troy, MI
On the SQL Server Database Administration Team,

• Worked with end users to develop SQL Server databases.
• Managed multi-gigabyte SQL Server database, ensuring proper balance between servers, correct server tuning, proper indices on tables, and appropriately tuned stored procedures
• Designed tables, views, and stored procedures for internal applications
• Designed databases in MS Access and SQL Server to create and track invoices for 2,100 Kmart stores
• Lead programmer on vendor compliance project that saved Kmart $180 million throughout their supply chain
• Developed reports in Crystal Reports
• Rewrote MS Access applications in Visual Basic to ensure stability.
• Technical Environment: SQL Server 6.5, MS Access, Visual Basic, Crystal Reports

(May 1998 – September 2000)

ELECTRONIC DATA SYSTEMS (EDS) Troy, MI

• Redesigned and administered Microsoft Access databases to track installation of computer systems at General Motors dealerships.
• Maintained Access databases with over 100 users.
• Created plan and supervised 200 employees on conversion from Access 2.0 to Access 97.
• Technical Environment: MS Access

(January 1997 - May 1998)

INTEGRATED MANAGEMENT SYSTEMS, INC. Ann Arbor, MI

• At General Motors, applied Project Management skills to create and maintain schedules and track development of automotive projects from development to production.
• Developed databases to automate weld tooling schedules using MS Access and MS Project.
• Technical Environment: MS Access, MS Project

(August 1994 - August 1996)

Bachelor of Science in Engineering