Description
SUMMARY Senior Computer Programmer / Analyst with 14+ years hands-on experience in analysis, design, development, testing, implementation, and maintenance of numerous business applications, covering all stages of full project life cycle. years), quality control reports applications - Wrote new programs and optimized existing MS Access and VB6 code in VB.NET and C# - Created tables, stored procedures, views and user defined functions in SQL Server * Created hundreds of DTS packages to transfer data from Macola system to company ERP system and scheduled them to run daily * Created hundreds of DTS packages to export data to Excel spreadsheet per clients' requests * Designed and deployed hundreds of SSIS packages to merge data from heterogeneous data sources into SQL Server * Created, upgraded, developed and maintained company key software applications * Analyzed, coded, built, tested, debugged, documented and deployed programs * Performed systems analyses and gave direction to enhance and upgrade legacy systems * Provided technical expertise to assist other members of the IT staff * Designed, managed and maintained solid core relational databases * Developed database services including views, functions, stored procedures, triggers and constraints * Ensured data security, synchronization and optimization * Scheduled database backups and performed recovery as necessary * Developed and implemented data models to support client/server and n-tier applications Alliance Manufacturing Software Inc. 5638 Hollister Ave. Suite 300 Goleta CA 93117 * Provided back-end relational databases design normalization and maintenance * Successfully migrated an MRP system from Access to SQL Sever. This included testing and modifying thousands of SQL statements * Designed front-end interfaces and facilitated communication with SQL Server databases * Wrote hundreds manufacturing and custom financial reports using Crystal Reports and Visual
Accomplishments
Highlights:
Keywords
- Applications
- C++ Programming Language
- C/C++ Programming Languages
- Installshield
- Software
- Active Server Pages
- Adobe
- Adobe Acrobat
- Adobe Photoshop
- sql
- linux
- javascript
- java
- c#
- c++
- html
- ASP
- Access
- VBA
- Visual Basic
- .NET
- Agile/Scrum
- Crystal Reports
- Visual Studio 6.0
- Visual Studio .NET
- T-SQL
- Assembly
- Pascal
- VBScript
- Windows 7/8/10
- ComponentOne Studio
- Infragistics NetAdvantage
- Team Foundation Server (TFS)
