TECHNICAL SKILLS

Proficient In: Business process management and automation, Project Management (waterfall, agile) and SDLC, MS SQL Server, Oracle and Oracle Forms, MS Access, MySQL, Database Modeling and Design, Data profiling and analysis, data cleanup, data standardization, and data mining.

Data warehousing/ETL, data migration, data Interfaces, master data management, KPI definition and reports generation: SQL/T - SQL, SSMS, BIDS, Toad, Erwin, DBDesigner, SSRS, C#, JavaScript/jQuery, VB.NET, VBScript, VBA, VB6, ASP, ASP.NET, AJAX, XML/XLST, SSIS, SSAS, CSS 3, HTML 5, web services, WCF, web forms, UI Design. MS Visual Studio.NET, MS Project, MS Visio, MS Office Suite, AutoIt 3 automated scripts, PhotoShop, ClearQuest, Image Editing/Graphic Design tools, developed JavaScript library frameworks, MS Excel, Excel Applications, Microsoft Windows, some Linux/Unix, Internet Information Services (IIS), Apache Web Server, Active Directory, SharePoint, server/desktop support.

N-Tier Application Design: OOP/OOD, UML, scripting, work-flow/business process design

Familiar: PHP, Java/JSP, PL/SQL, Perl, PowerShell, XML, XLST, some basic C++, TFS, SOAP. ITIL and similar frameworks. Master Data concepts.

Skills: Instructor, training and curriculum development, technical writer, team supervision, quality assurance/improvement/auditing, capability maturity model, Six Sigma, finance bookkeeping/ budgetary management.

PROFESSIONAL EXPERIENCE

Database/Application Developer

Confidential, Federal Way, WA

Responsibilities:

• Analyzed data and developed and implemented data alignment strategies including transactional databases, data marts, and data warehousing structures. Developed and modified Sql Server and MS Access applications. Developed databases, code libraries, stored procedures, and user defined functions. Used master data concepts. Provided application technical support for developed applications.
• Developed data mining strategies. Developed many SSRS reports for internal business management and to provide KPI status using multiple data sources. Developed charts and graphs, and KPI performance metrics dashboards.
• Developed several MS Excel spreadsheets and MS Excel applications using background SQL Server databases.
• Developing business support applications, business rules, work-flow modeling, and business process interfaces for Time Management/Payroll Support, project management, request/process approval, work-flow management, automated software licensing and download, employee purchase request management, finance accounting distribution and internal communication, other financial support applications, and several web applications for AD support, customer surveys, employee interface, etc. using n-tier design. Designed/Developed transactional databases and reporting data structures.
• Developed web and Windows application interfaces for legacy databases and data warehousing. Developed several development support tools. Developed several WCF applications and web services. Applications globalized for international use.
• Used Visual Studio 2013, SQL server 2014, Sql Server Management Studio, C#, jQuery, AJAX, JavaScript and developed a specialized JavaScript framework, Infragistics controls, MS Visio, and Office 2010. Used Gemini Issue and Task Manager. Developed many stored procedures, views, functions, using schema-based approach. Set and maintained standards for coding and data structures.
• Managed many Agile projects for software development defining business need, designing prototypes, ensuring user acceptance, implementing, testing, and coordinating user final acceptance. Handled all aspects of development from requirements gathering and solutions design to implementation and life-cycle management.

Database/Application Developer

Confidential, Bellevue, WA

Responsibilities:

• Implemented two projects in Oracle 10g, PL/SQL, and Oracle web forms. Maintained Oracle Product Illustration Tracking System (PITS) application system. Provided customer service, troubleshot and implemented solutions. Documented Maintenance technical information. Modified web services.
• Optimized database processes, analyzed and cleaned data. Redesigned management procedures and rewrote DTS packages and portions of the ETL process, validation processes, stored procedures, database scripting, and Perl scripts. Assisted in upgrading from MS Access 2003 ADP files to MS Access 2007. Troubleshot problems and Implemented solutions for customers.
• Assisted in migrating Electrical Wiring Information Tracking System (EWITS) from Sql Server 2000/DTS/ETC to Sql Server 2008 and its Windows Application interface. Developed SSIS packages. Developed database job tracking system.

Software Engineer/Database Engineer

Confidential - Tacoma, WA

Responsibilities:

• Established business process models and interfaces for Intranet web based Criminal Case Management System (C2MS), interfaces, and support applications using Classic ASP/ASP.NET/JavaScript/ VB.NET/VB/VBScript, PowerShell. Created database design for complete replacement of existing legacy database system. Implemented data warehouse and ad-hoc query module for legal data.
• Modeled and implemented standard interfaces to two major external data systems, WebRMS at LESA (Law Enforcement Support Agency) and Pierce County JMS (Jail Management System). Designed and implemented issue reporting and administrative requests system. Established business/software development metrics and management reports. Developed project plans, technical specifications, use cases, test plans/scripts, implementation plans, user manual, technical support manuals, etc.
• Project Manager for C2MS Version 2 Implementation project (Waterfall) and several agile projects. Performed needs assessment, developed business process/data/application/ infrastructure models, developed technical specifications, use cases, project/testing/ Deployment plans, and other project documentation.
• Developed data mining strategies, data marts, and ETL process to provide reporting data, including many specialized business reports based on performance metrics.
• Designed/developed/maintained Intranet legal case management system, with Sql Server database systems and classic ASP/ASP.NET for criminal prosecution and courts. Designed/implemented data interfaces to other law enforcement database systems. Developed interfaces to municipal courts, the police department, LESA records, and other external organizations. Fully documented interfaces.
• Modeled/designed and implemented Sql Server database systems for transactional, historical, and data management requirements. Designed and implemented a data-mart of legal case data for management reports and developed many management reports. Developed coding standards and implemented best practices. Developed many stored procedures, user defined functions, tables, and views using Sql Server Management Studio. Developed performance standards, measured database performance, established targets for improvement, and optimized performance. Developed Intranet ad-hoc reporting system for accessing historical data. Established user access, access rights for all database objects, database jobs, trusted servers, database backup/maintenance plans, and all other database management tasks. Developed SSIS packages and ETL processes. Developed data warehouse for legal data.
• Developed fully automated jobs system for database management, including process to define all database tasks for the next month and automatically establish a task queue that runs throughout the month. System encompassed standard processes for hourly, daily, weekly, monthly, quarterly, and annual maintenance procedures that ran against all databases. Established automated email notification system for standard tasks, errors encountered, special notifications, etc., and a standard set of management tables that identified errors, issues, and events that affected the database status.
• Developed automated problem/issue reporting system to fix customer problems and developed an automated user request system for action by application and database administrators. Developed automated system for handling queued background application tasks every ten minutes.
• Developed management reports that showed data-mart data by week, month, quarter, and year, and reports that showed current status and real-time data. Developed standard reports used to balance staff work loads. Used MS Excel to access data, BIDS, SSIS to migrate data from previous basic Sql Server 2000 database, and SSAS. Developed prototype for MS Reporting Services module for managers.
• Administered IIS and Sql Server development environment at my work site and a separate development environment within the hosting environment. Legal Department SharePoint site administrator and Legal Department public Internet site developer/administrator. Technology advocate, researching and recommending changes in technology for Legal Department. Developed Auto-Keys application utilities using AutoIt3.
• C2MS application manager from 2007 on, defining manual business processes to in corporate into application, and coordinating user acceptance/training, and designing/coordinating interfaces with DISCIS/other external systems. Trained users in application use and in using MS Office Suite 2007/2010.
• Developed extensive documentation in support of computer use within my division, including a comprehensive user’s manual, a manual of standardized codes, a data dictionary, and an extensive and detailed technical maintenance manual for each application I developed.
• Provided divisional desktop support for 1 ½ years. Developed MS Access database management system for computers/servers assets and maintenance.
• Managed source control management system.

Team Leader

Confidential - Lacey, WA

Responsibilities:

• Project Manager and team leader for MARS team designing management reports for Oracle and SQL Server database systems. Project Manager. Developed reporting process models, data mapping and database design, use cases, test plans/scripts/data, designed changes to database maintenance processes, and lead team implementing management reports.
• Implemented JAD (Joint Application Design) within ESD for projects to standardize customer interface, including business requirements, technical specifications, and final customer acceptance.
• Analyzed manual business processes, then designed and implemented digital application replacement.
• Part of team implementing Oracle system upgrade. Helped develop test plan/test scripts/data.
• Developed reporting data sources, and SSRS reports to support critical business processes.
• Project Manager for initial portion of the Get Competitive project implementing ITIL structures in ESD. Helped establish software development management metrics.

Data Warehouse Engineer

Confidential - Lacey, WA

Responsibilities:

• Designed/implemented Extract, Transfer, and Load (ETL) process updating central data warehouse from multiple mainframe/transactional databases. Modeled processes and data structures. Developed weekly snapshot processes for unemployment compensation data based for historical needs and fraud investigator. Designed and implemented data warehousing dimension standards/processes for managing slowly changing dimensions. Designed/tested flattened table and data cube structures and ETL processes to support them. Designed/Implemented performance metrics.
• Part of team developing automated job services support system, developing ASP.NET/JavaScript/Sql Server applications and VB.NET support applications. Worked on CMR project, designed/developed work queues for managing audio unemployment compensation requests/background maintenance utilities. Modeled processes/data structures. Developed test scripts and MS Reporting Services management reports. Used SSIS, SSAS.
• Developed SSRS reports for data warehouse data and from other data sources.

Internet Web Developer

Confidential

Responsibilities:

• Established commercial web site design, database model using DBDesigner, technical specifications/use cases/testing plan, coded web site in PHP/JavaScript with MySQL database, tested, and coordinated customer acceptance. Developed user and technical support manuals. Administered Apache Web Server and MySQL development Environment. Developed PHP/JavaScript/MySQL based project management application.
• Defined, modeled, and analyzed business processes, and performed risk analysis.

Applications Development/Software Technical Manager

Confidential - Olympia, WA

Responsibilities:

• Managed all standard prison software for six months, evaluated COTS software, performed risk analysis, and implemented software replacements.
• Developed models and designs for business systems, modeled business processes, applications, data marts, and databases. Designed and implemented Windows Applications and Web Intranet applications/back-end database systems, using Classic ASP/JavaScript/Sql Server/Oracle/MS Access. Including modeling business processes and data structures involved. Designed and implemented SQL Server databases and management reports. Applications Development Project Manager, managing teams of 2-5 members. Developed project plans, technical specifications, use cases, test plans/scripts/data, and implementation plans. Managed entire software life-cycle for standard applications used in all state prisons. Evaluated COTS software for use in prisons, established RFPs/RFQs for third-party software. Completed projects to define total cost of ownership and risk for existing systems/COTS and proposed software application systems. Developed user and technical support manuals.
• Part of OMNI team developing and implementing mainframe database and application front-end for DOC offender management system.
• DOC’s Webmaster for one year, developing and maintaining public site. Administered IIS and Sql Server Development Environment.
• Part of team establishing project portfolio management and standardizing IT procedures.
• Designed and implemented systems for management offender property, staff rosters, prison tool control, staff training, equal opportunity surveys, and other state prison software applications. Developed data models, technical specifications, use cases, project plans, test plans/scripts/data, user manuals, and deployment plans. Used VB, Visual Studio, and Sql Server databases.
• Led team developing application for managing offender Hepatitis-C care in Confidential prisons. Developed database design, technical specifications, use cases, test plans/scripts/data, project plan, deployment plan. Developed using Java Server Pages, JavaScript, Java, Sql Server, and WebSphere.
• Completed data cleanup Project for Department of Health LEAP Program (Licensing and Enforcement for health care professionals). Modeled existing VSAM data and designed RDBMS replacement. Developed data cleanup/standardization process. Tested applications and utilities. Designed data warehouse to house health professional licensing data. Evaluated COTS software.
• Rewrote electronic prison security audit system for DOC prison facilities.
• Part of Capability Maturity Model for Software Development Assessment Team and After-Action Team, assessing DOC’s software development systems and establishing policies and procedures to ensure repeatable & standardized results. DOC’s representative for state-wide Windows 2000 Infrastructure Implementation.
• Café Project Software Developer for two years, designing/implementing software application/ databases to manage prison offender meals, manage food procurement, and ensure nutritional standards were maintained. Established standard nutritional reports. Developed standard testing/scripts/data. Developed user and technical support manuals. MS Access, Sql Server.

Bookkeeper/Computer Administrator

Confidential

Responsibilities:

• Accounts receivable, accounts payable, Payroll, club operations, office manager, etc. Used QuickBooks.
• Developed and managed $200,000 annual budget using QuickBooks.
• Modeled business processes, designed, and instituted electronic applications for Elks Membership and office management. Developed management metrics.

Aviation Administrationman Chief Petty Officer/Data Analyst

Confidential

Responsibilities:

• Aviation Data Analyst for 18 years. Analyzed trends, produced reports, and made presentations, recommended action, developed presentations, etc.
• Developed several computer programs. Supervised between 6-21 staff.
• Navy Inspector for accounting, computer, and data analysis for three years.
• Instructor for general aviation, leadership, and computer topics.