TECHNICAL SKILLS:

Databases: Microsoft SQL Server 6.5, 2000, 2005, 2008, 2012 & 2014, VLDB, MySQL, stored procedures, triggers, SSIS, SSAS, DTS, ETL, log shipping, replication, mirroring, Backup and Recovery, performance tuning, Sybase, Oracle

Programming Languages: Visual Studio, C#, Visual Basic 4, 5, 6 & .NET, ASP.NET, Team Foundation Server, AJAX, XML, XSLT, WSDL, VB Script, Dexterity, COM, COM+, ASP, CSS, Javascript, PHP, DHTML, HTML, MS SQL, PL - SQL, EDI 810, 812, 820, 850, 852, 855, 856 & 997 documents

Network Administration: MS-DOS, Windows 3.11, 95, 98, NT, 2000, XP, 2003, Vista, 7, 8 and Server 2012, Microsoft Exchange 2003 & 2005, Windows IIS, Windows Terminal Server, Citrix, Novell, Symantec Endpoint Server, AVG Anti-Virus, SSL, Dell Network Switches, SonicWALL, Ironport, Active Directory, Nortel Phone Switch, Kronos, Veritas

Reporting: SQL Server reporting services (SSRS), Crystal Reports, ADP Payroll & Benefits

Application Support: Microsoft Great Plains 5.5, 6.0, 7.5, 8.0, Dynamics GP 9.0, 10, 2010 & 2013, Microsoft Dynamics Integration Manager, Microsoft FRx 6.5 & 6.7, Microsoft Office, Microsoft Access, Gentran Server, nSoftware IP Works, FedEx Ship Manager, Veritas Backup, Easylink Mail Transport, AS2 Complete, EDI Complete, Symantec Backup Exec, Highjump (previously BelTek)

WORK EXPERIENCE:

Confidential, Conshohocken, PA

Sr. Dynamics GP Developer

Responsibilities:

• Instrumental in moving of datacenter to cloud provider.
• Supported all production and UAT environment operations with Dynamics GP 10.0, FRx & eConnect
• Provided technical guidance for design documents while planning the data center migration
• Created an Integration Package to export Invoices & Orders in digital format, CSV or XML
• Created numerous new report from a flat file we received from FDR.
• Modified and enhanced automated process to drawdown funds from customer accounts for prepaid cards.

Confidential, Dallas TX

Sr. Developer

Responsibilities:

• Created numerous integration for Microsoft Dynamics GP using SQL Server Integration Services (SSIS) with C# and VB on SQL Server 2005, 2008, 2008 R2 & 2012 utilizing Dynamics GP eConnect
• Created an Integration Package for distribution to multiple clients using Dynamics GP 10.0, 2010 & 2010 R2 for SQL Server versions 2005, 2008, 2008 R2 & 2012 using Visual Studio with C# and Visual Basic
• Provided advanced troubleshooting for SQL Server 2000, 2005, 2008, 2008 R2 & 2012 issues with numerous customers
• Designed, created and deployed numerous customizations created based on customer requirements. Many of these solutions were in the Aztec Systems Cloud solution for their clients
• Provided support to numerous Microsoft Dynamics GP companies for multiple versions of GP
• Identified and resolved performance issues for numerous customers
• Provided technical support to consultants as required by clients need
• Modified a custom web site for a client that included Classic ASP and Visual Studio.NET using C# and Javascript
• Team member creating a new web site for a client using Visual Studio.NET with C# and included numerous integrations to Dynamics GP. Also created numerous SSRS Reports to support this application
• Created an application to communicate with an SFTP site using Visual Studio.NET with C#

Confidential, San Diego, CA

Sr. BI Consultant

Responsibilities:

• Programmed using Halo BI Source, Prism, Hierarchy Builder and Role Manager
• Installed, configured and programmed SQL Server all versions
• Troubleshoot SQL Server performance issues and apply solutions
• Trained clients on the use of the Halo BI toolkit
• Trained clients on SQL Server setup and management
• Trained clients on basic t-sql commands and syntax
• Trained client on the Kimball Dimensional Data Warehousing
• Designed and developed numerous end to end BI solutions for clients
• Worked on client projects that consisted of various connection methods and numerous cloud solutions.
• Worked with Google Web services, providing client access to this information. This included translating address to Geocoded information, integrating Google Docs and Google Analytics
• Created numerous SSIS solutions for client integrations using Visual Studio with C#

Confidential, Carrolton, TX

Sr. Developer

Responsibilities:

• Created numerous integration for Microsoft Dynamics GP using SQL Server Integration Services (SSIS) with C# and VB utilizing XML and XSLT on SQL Server 2005 & 2008 utilizing Dynamics GP eConnect
• Created an Integration Package for distribution to multiple clients using Dynamics GP 10.0, 2010 & 2010 R2 for SQL Server versions 2005 & 2008
• Provided advanced troubleshooting for SQL Server 2005 & 2008 issues with numerous customers
• Designed, created and deployed numerous customizations created based on customer requirements. Many of these solutions were in the Aztec Systems Cloud solution for their clients.
• Created and maintained Dexterity modifications to Microsoft Dynamics GP versions 10 & 2010
• Created and maintained Modifier modifications to Microsoft Dynamics GP windows, forms and reports
• Created and maintained .NET add ins to Microsoft Dynamics GP using Visual Studio.NET with C# and Microsoft Dynamics GP Visual Studio Menus for Microsoft Dynamics GP
• Assist help desk with customer issues as needed
• Provided support to numerous Microsoft Dynamics GP companies for multiple versions of GP
• Accomplished numerous upgrades to Microsoft Dynamics GP from versions 8, 9 and 10 to versions 2010 & 2010 R2 including upgrading SQL Server from 2000 & R2
• Provided advanced troubleshooting for technical issue resolution escalating issues to Microsoft where appropriate
• Created added functionality to Microsoft Dynamics GP for standard modules and third party products
• Identified and resolved performance issues for numerous customers
• Provided technical support to consultants when as needed based on client needs and requirements

Confidential, Nashville, TN

Sr. DBA and Database Developer

Responsibilities:

• DBA for SQL Server 2000, 2005 and 2008
• Support for Microsoft Dynamics 9.0 and FRx worldwide (USA, Europe and Asia)
• Support for multiple custom applications written with Visual Studio.NET with C# and Visual Basic
• Support for Manufacturing (Great Plains Manufacturing module)
• Support worldwide Replication
• Support for all data integrations utilizing stored procedures, SSIS and DTS packages using Visual Studio with C# and Visual Basic
• Implemented a Backup and Restore process
• Optimized multiple databases on many servers for better performance and reduced record locking
• Created a production test environment for testing production fixes
• Managed and created Crystal and SSRS Reports
• Established a new process for accounting that allows monthly inventory Cost Rollup and Revalue
• Working with accounting established a new Year-End closing procedures
• Modified Fixed Assets setup to allow simpler reporting
• Maintained numerous Dexterity modifications to Great Plains
• Instrumental in rebuilding the server that hosted the core business functions after the old server stopped functioning

Confidential, Las Vegas, NV

IT Manager / DBA / Lead Business Analyst

Responsibilities:

• Hired by Goldman Sachs to standardize all IT functions and resolve IT issues
• DBA for SQL Server 2005 (Microsoft Dynamics GP 9.0 and BelTek)
• Completed a new SQL Server build with Microsoft Dynamics GP 9.0 to accommodate significant increase in daily transactions
• Stabilized the existing EDI integrations to reduce the number of errors requiring manual resolution
• Implemented numerous EDI connections to handle new customers as required
• Created numerous SSIS procedures to accommodate EDI transactions from numerous companies using Visual Studio with Visual Basic
• Implemented automated network and database backup solutions
• Implemented a standardized reporting application utilizing SSRS, SSL and Visual Studio.NET with Visual Basic for Microsoft Dynamics GP
• Configured SQL Server mail to accommodate email reporting
• Implemented automated reporting solution to email business critical reports daily and weekly
• Implemented numerous Microsoft Dynamics GP Integrations to reduce the amount of manual data entry using Visual Studio with Visual Basic, XML and XSLT
• Created and Automated numerous SSIS packages using Visual Studio with Visual Basic
• Created and Automated numerous Dynamics GP integrations using Visual Studio with Visual Basic, XML and XSLT
• Tuned databases for optimal performance
• Managed multiple VAN services for EDI transactions
• Implemented Gentran Server to accommodate integrated EDI transactions with Microsoft Dynamics GP
• Mentored and coached Business Analyst and Network Administrator on SQL stored procedures and Reporting Services reports
• Created complex stored procedures for reporting and BI
• Created new FRx Reports for accounting
• Created new ADP reports for HR
• Implemented a custom order application to accommodate Kmart / Sears business model complete with EDI and Microsoft Dynamics GP integrations using Visual Studio with Visual Basic
• Installed and configured a new SQL Server with Microsoft Dynamics GP 9.0 and FRx to accommodate increase in daily transactions
• Day to day support of all Microsoft Dynamics GP users and functions
• Renegotiated all Vendor contracts to streamline IT functions and saved the company thousands per month
• Managed enterprise Nortel phone switch
• Installed and Managed SonicWALL for network security and EDI transmissions
• Installed and Managed Ironport for email spam filtering
• Managed ADT Security for the building
• Managed Motorola handheld computers with BelTek software
• Implemented Microsoft Exchange 2005 for enterprise email
• Managed Xerox network printers
• Provide 24 / 7/ support for all applications and systems
• Managed server and application maintenance as required
• Managed company wide security for all networks, servers and applications

Confidential, Miami Beach FL

Senior Database Developer and Architect

Responsibilities:

• Migrated a custom accounting software application to Microsoft Dynamics GP by creating a new web based application using Visual Studio.NET with Visual Basic
• Created numerous tables and stored procedures to accommodate customized extensions to Microsoft Dynamics GP
• Built new servers (Microsoft SQL Server 2005 & middle / front end server) to accommodate upgrade of Microsoft Dynamics GP from version 8.0 to version 9.0
• Day to day support of all Microsoft Dynamics GP users and functions
• Mentored and coached Junior developer on programming, SQL stored procedures and Reporting Services reports
• Created a custom application to gather weather information pertaining to each port of call for the cruise lines they supported. This data was saved to custom tables for reporting and business analysis.
• Created a custom application to gather currency exchange information each day and stored this for future reporting use
• Tuned databases for optimal performance
• Managed server and application maintenance as required
• Mentored junior programmer

Confidential, Indianapolis, IN

Sr. Programmer Analyst

Responsibilities:

• Created a middle tier / front end server to accommodate numerous applications required for current business functions
• Created a Web Service to manage inventory for Microsoft Great Plains (Microsoft GP Integration) using Visual Studio.NET with Visual Basic
• Created a Web Service to manage sales and returns in Microsoft Great Plains (Microsoft GP Integration) using Visual Studio.NET with Visual Basic
• Created a Web Service to manage Cash Application in Microsoft Great Plains (Microsoft GP Integration) using Visual Studio.NET with Visual Basic
• Utilizing custom Web Services, implemented a custom site substitution to accommodate restructured Dynamics GP General Ledger accounts
• Created a 3 tier web based application to manage all Gift Shop functions using Visual Studio.NET with Visual Basic. This included inventory and sales management with Dynamics GP integrations including customized reporting
• Created a 3 tier web based application to manage all Food & Beverage operations using Visual Studio.NET with Visual Basic. This included inventory and sales management with Dynamics GP integrations including customized reporting and commission management
• Created a 3 tier web based application to manage all of the Catering operations using Visual Studio.NET with Visual Basic. This included a browser based POS application that included inventory and sales management with Dynamics GP integrations inventory forecasting and customized reporting
• Created a 3 tier web based application to manage cash operations for accounting using Visual Studio.NET with Visual Basic. This included double entry tracking and included Cash Application to appropriate sales documents in Microsoft Great Plains
• As the Microsoft SQL DBA I tuned all of the applications to accommodate 3.5 to 4 million transactions each day.
• Upgraded Microsoft Great Plains from version 5.5 to Microsoft Dynamics GP 7.0.
• Upgraded Microsoft Great Plains for Clabber Girl manufacturing from version 5.5 to Microsoft Dynamics GP 7.5
• Day to day support of all Microsoft Dynamics GP users and functions
• Managed server and application maintenance as required
• Developed a clustered SQL Server solution in a test environment to accommodate increase in transactions but this was never utilized

Confidential, Indianapolis, IN

Project Manager

Responsibilities:

• Designed, implemented and managed project to create a web based application to manage the residence halls at Western Michigan University using Visual Basic. This require a team of 10 programmers for a period of one year after which was supported with 2 programmers for updates and enhancements
• Designed and created an automated room assignment module to assign the students to rooms using Visual Basic
• Tuned databases for optimal performance
• Managed numerous projects through out the Midwest consisting of Windows, Microsoft Access and browser based applications.
• Created a web based Suggestion Management application at Western Michigan University using Classic ASP

Confidential, Indianapolis, IN

Analyst Programmer

Responsibilities:

• Maintained Clarion Developer application for the Confidential
• Project Manager of a VPN solution for AIMCO in addition to Tier II help desk support