SUMMARY:

• Offering several years of accumulated and diverse experience developing solutions as a Software and Database Developer including seven years total experience in the Aerospace Industry and four years in the Wireless provider industry.
• C# ASP / WIN / Console tools for user interaction, file handling, automated database builds and auditing.
• VB .NET, VBA, VBS and Legacy Visual Basic / COM with versions 3 through 6.
• Microsoft Office Automation with emphasis on dynamic SQL data and Excel Charts.
• SQL Server (T - SQL) with emphasis on coding procedures, creating batch scripts and extracting ad-hoc data.
• ETL using SQL Server SSIS / DTS and custom C#. NET classes.
• Several data and application migration projects involving MS Access and MS SQL Server.
• Database conception, design, implementation, administration and maintenance of SQL Servers.
• Ad-Hoc Reporting
• Application Development
• Client / Server Architecture
• Data Analysis/Auditing
• Data Management
• Data Structures
• Extract / Transform / Load
• Process Reengineering
• Prototyping
• Technical Documentation
• Technical Troubleshooting
• User Interface Desig
• Results-proven professional software and database developer. Proficiency and professional experience in several programming languages. Experienced in numerous industries including marketing, manufacturing, telecommunications, insurance and vending. Performed project life cycle activities from participation in client meetings to obtain requirements definition, tool selection, application design, development, documentation, testing, and deployment. Provided client and technical support.
• Strong analytical skills with proven record of requirement gathering and complex problem solving.
• Expertise in development of technical strategies and solutions, computer programming, application development, documentation and technical support.
• Demonstrated success in all phases of information systems life cycle.
• Highly Skilled in systems analysis/design, client/server applications, client relations, needs assessment, problem resolution, and mentoring.
• Quick study who rapidly assimilates into organization and aggressively employs innovative ideas, concepts, methods and technologies to support business objectives.
• Thrive in both independent and collaborative work environments.
• Very adaptable, rapidly learns new procedures and processes, and quickly adjusts to changes in schedule, team structure, assignment parameters and organizational objectives.

PROFESSIONAL EXPERIENCE:

Programmer / Analyst

Confidential, Seattle, WA

Responsibilities:

• Performed analysis of files requiring code and refactoring and updated command line syntax and switches in over 200 Excel Workbooks, Add-in’s and VBS files as part of a migration to APX from Advent Axys.
• Syntax updates include code used in automated and manual processing of imports, exports and report creation hosted in Excel 2013 Workbooks and Visual Basic Scripting files from data pulled from the new APX System.
• Coded conversion of new XML format to CSV to maintain compatibility with legacy programming.
• Worked with end users to debug issues in a test environment and to achieve sign off.
• Updated syntax errors and code issues that are the result of an upgrade to Office

Tools: MS Office 2013, VBA, VBS, APX, ADO, IMEX and Batch Commands.

Programmer / Analyst

Confidential, Everett, WA

Responsibilities:

• Developed automated reporting system that creates several charts and tables reporting on target performance status, turn time and held time to complete jobs, daily status of jobs which includes backlogs, receiving, completions and age with metrics documenting key performance indicators for time expended and shift performance. This system was developed using C# .NET, batch files, VBA, MS Office and SQL Server where I coded complex Stored Procedures, Functions and designed the databases, views, indexing and tables from the ground up and is mostly self-sustaining running jobs for daily, weekly and monthly reports Confidential various intervals throughout the day.
• Produced a MS Access data entry and reporting application that integrates PowerPoint and Excel for tracking 5S progress by groups. Coded VBA to PowerPoint with MS Access data to create dynamic area mapping of sites identifying manager and 5S scores and a spider chart to display 5S progress for the five topics for each shop.
• Created an Excel based dashboard for a daily management meeting that assists management with status per shift and group by reporting on backlog, received jobs, completed jobs and staffing numbers. Data is pulled from a SQL Server database and is interactive serving as a data entry and reporting tool.
• Designed web based dashboard for the Emergent Operations Industrial Engineering group using Lightbox and Visual Web Developer as the tool used for deployment, sustaining and modifying the current design.
• Other projects including an inventory application with bar code scanning and some IIS and .NET Web based solutions with user interaction to allow parameterized adhoc reporting to CSV, PDF or Excel.

Tools: MS Office 2013, SQL Server 2012, PowerPoint, VS 2010, C#, VBA, Barcode, jQuery, Spry, .NET and Lightbox.

Programmer / Analyst

Confidential, Everett, WA

Responsibilities:

• While with the 787 program I developed Excel extracts, pivots and charts using automation from Access Databases, primarily the Serial Number Control Database. Coded query and VBA modifications to the Access databases owned by the SNC group according to changing requirements. Developed processing that imports data from disparate sources such as ARL
• Velocity and others collecting Serialized Parts and SOI status information. Created SQL Database to import COGNOS data to blend with HR and SRIT data sources while using SQL OLE Automation, VBA and C# to export dynamically created Excel charts and reports based on EPD data with Manager/Employee/Shift information such as route backs, counts, flow time and the various queues.

Tools: MS Office 2007, Cognos, ARL, Velocity and VBA for Excel and MS Access.

Programmer / Analyst

Confidential, Everett, WA

Responsibilities:

• Designed, built, tested, and implemented functions and procedures for SQL Server 2008 to support an automated data load process system supported by the SIP&T - Data Quality & Delivery group using xp cmdshell, BCP, and Openrowset - Bulk with XML format files, to import and export data to and from remote sources or flat files. Developed the ability to automatically backup schema for database objects when a change was made to the schema to a time stamped flat file. Provided the ability to backup data from selected tables by way of BCP using SQL on a nightly schedule. Tools: MS SQL Server, SQL System Procedures and Views, Windows Scripting.

Visual Studio .NET / SQL Server Developer

Confidential, Seattle, WA

Responsibilities:

• Designed a SQL Server merchandising database to support the company’s wireless device sales and Costco Kiosk configurations. Created a Web front end to prove the database provides the data capability to print labels, planograms, POP’s and price guides with sales, rebate and promotion discount figures according to location, carriers and plans. Developed SQL Tables, Stored Procedures for SQL Server 2008 and developed the Web tool prototype to demonstrate the new database and to present user interface ideas using Visual Studio 2010.

Tools: SQL Server 2008, Visual Studio 2010 - C#, ASP.

Software / Web / SQL Developer

Confidential, Mukilteo, WA

Responsibilities:

• Created ASP .NET applications for a fireplace manufacturing company. Developed new online quiz engine for online s Confidential that test skill levels for sales, installation and troubleshooting s for the company's Xtreme Fireplace. Rewrote a visual fireplace configuration tool from static to dynamic HTML with MS SQL backend. Worked with GPS tools.

Tools: VS 2010 ASPX, Ajax, jQuery, JavaScript, C#, VB .net, T-SQL, DHTML, ASP classic, mojoPortal CMS.

Visual Studio .NET Developer

Confidential, Bothell, WA

Responsibilities:

• Created custom UI, Console or Automated solutions and migrated existing VB 6 and MS Access applications, queries and reports into Visual Studio solutions using C#, VB .NET, Crystal Reports, SQL Server 2005, Excel and Outlook or NET Mail for standalone execution and integration into SyteLine 8 ERP, a customizable .NET ERP package. Produced SQL Server objects and authored reports for various departments. Efforts resulted in improved overall application performance and accuracy and ensured legacy applications were upgraded to be SOX compliant.

Tools: Visual Studio 2005 - C#, VB .net, SQL Server 2005, VB6, Crystal Reports, MS Office and MS Access.

Software / Database Developer

Confidential, Redmond, WA

Responsibilities:

• Implemented processes to merge Cingular and Confidential &T Wireless data for the Sales Operations business-to-business division. Built and maintained critical SQL Server databases for testing new applications, pre-production data validation and production delivering user access management, user functions, indexing, stored procedures and tables. Handled challenging ad-hoc data extract requests on a regular basis for higher-level management. Authored complex T-SQL procedures and DTS/SSIS packages for SQL Server ETL processes and created tools using C# for console and Windows development and VBS to automate ETL tasks handle files and audit data.

Tools: Visual Studio - C#, SQL Server 2000 and 2005, VBS, Excel and MS Access.

SQL Server Developer

Confidential, Seattle, WA

Responsibilities:

• Created and modified SQL Server stored procedures against a claims and subscriber based dimensional data warehouse to update fact and dimension tables.

Tools: SQL Server 2000.

SQL / Web Developer

Confidential, Seattle, WA

Responsibilities:

• Aided with development of a tool used in the evaluation of web site hit statistics.

Tools: T-SQL, ASP.Net, XML and C#.

Visual Basic Developer

Confidential, Kirkland, WA

Responsibilities:

• Authored and delivered a Visual Basic server application that searches workstations running a manufacturing program with one initialization file containing proper sections and keys. Successfully devised and launched log files located on a network share for recording usernames, IP addresses and processor speeds. Collaborated with customer, designing and performing acceptance testing based on document requirements.

Tools: Visual Basic.

VB .NET / Access Developer

Confidential, Seattle, WA

Responsibilities:

• Built a reporting tool using Visual Basic .NET and ADO .NET to a model implemented in MS Access. Added functionality to export grid data to Excel spreadsheets. Created drill-down report presentation of hierarchical data representative of cost centers and dependencies using VB .NET.

Tools: MSACCESS, VB .NET.

Visual Basic / SQL Server Developer

Confidential, Seattle, WA

Responsibilities:

• Returned to Washington Dental Service to oversee distribution and testing of a Visual Basic/SQL Server claims entry system.

Tools: VB6, SQL Server.

Visual Basic / Access Developer

Confidential, Seattle, WA

Responsibilities:

• Added enhancements to an existing Visual Basic/MS Access claims management application for Certus Consulting. Tools: Visual Basic, MS Access and Crystal Reports 9.0.

Visual Basic / SQL Server Developer

Confidential, Seattle, WA

Responsibilities:

• Developed solutions to assist in the transition to migrate data systems from a terminal environment to a Windows based network. Created functional specifications, coordinated installation of code and bug fixes, and related testing prior to release. Utilized Visual Basic, Crystal Reports and Win32 API to support user interface, reporting and business object requirements. Developed SQL Server tables, stored procedures, triggers and indexes to manage data access and storage functions. Authored process to extract data from SQL Server into Navision using the OSQL Utility. Converted a claims entry system from
• Visual Basic and MS Access to a client/server operation by incorporating SQL Server, DTS, and Visual Studio tools. Worked extensively with customer to create a claims entry experience like current COBOL program. Authored parsing tools to process data from a SQL Server 2000 database into EDI X12 transaction sets.

Tools: Visual Basic, Crystal Reports, SQL Server 2000.

Visual Basic / Web Developer

Confidential, Seattle, WA

Responsibilities:

• Developed web-based applications accessible to resellers, distributors and customers to process product inquiries, account configuration and customer for Concord’s unified messaging services. Developed SQL Server tables, stored procedures, triggers and indexes. Developed an automated Web based e-mail promotion system for an air miles for referrals program.

Tools: HomeSite, PC Anywhere, Visual Basic 3.0, VB Script, JavaScript, SQL Server, ActiveX Data Objects, COM Objects and ASP technologies.

Visual Basic / SQL / Access Developer

Confidential, Everett, WA

Responsibilities:

• Produced enhancements to a production control application, SQL Server database and MS Access database in use by Solectron, a manufacturer of circuit boards for Confidential . Wrote tested and documented program code and implemented program modifications to interface with subroutines and perform specific functions. Modified MS Access and SQL Server tables, SQL Server stored procedures, and Visual Basic applications to allow extraction/conversion of data into text files for transfer to a product supplier allowing the supplier to receive inventory data for usage analysis.

Tools: Visual Basic 4.0, MS Access, SQL Server 6.5.

Visual Basic / SQL Server Developer

Confidential, Renton, WA

Responsibilities:

• Constructed user interfaces and coded portions of the VendLink wireless vending system. Utilized Visual Basic 5.0 Enterprise Edition to develop interface and COM code components within 3-tier architecture; Created SQL Server stored procedures using RDO for data manipulation, retrieval and display in Crystal Reports and application controls. Coded back office tools used for the configuration of wireless vending machines, inventory and cash analysis, and automatic paging. Maintained the corporate web site updating links and corporate news.

Tools: Visual Basic 5.0, SQL Server 6.5, Visual Intercept, Crystal Reports, and RDO.

Programmer / Analyst

Confidential, Renton, WA

Responsibilities:

• Managed testing and integration processes associated with development of the Non-Conforming materials system for Confidential . Monitored UNIX and NT based systems and application integration development projects. Participated in checkouts and functional testing to ensure the system functioned properly and met client requirements. Followed test data subject through various queues (MQSeries) to destination and documented results to test plans stored in ClearCase. Created FAQ web pages in support of the Non-Conforming Materials system.

Tools: Visual Basic, MS Access 95, Data Access Objects and Crystal Reports, UNIX.