SUMMARY

• Database Application Engineer with over 11 years of experience working with Enterprise database servers.
• Specialize in troubleshooting and refactoring client - side/server-side applications written in java and C#. Excel at optimizing stored procedures to minimize data latency issues.
• Have experience in designing ETL (extract translate load) applications for cross-database support (SQL Server to Oracle and Sybase to SQL Server).
• Have extensive experience in modernizing legacy systems. Willing to learn and adapt to newer technologies.

TECHNICAL SKILLS

• Programming Languages: Java, C#, Confidential - SQL
• Scripting Languages: Gradle, Bash
• Markup Languages: XML
• Data Exchange Formats: XML, JSON
• Prototyping Languages: Gherkin, UML
• SDE Test Frameworks/Languages: JUnit, NUnit, TestUnit
• Databases: MS SQLServer, Sybase ASE, Sybase IQ, Informix, MongoDB
• IDE: Eclipse, CodeBlocks, Visual Studio, AquaData, NoSQL Manager for Mongo
• Version Control: GitHub, Accurev, VSTFS
• Bug Tracking: Jira, HP Quality Center, GitHub
• Profilers/Debuggers: SoapUI, Ants Profiler, SQL Profiler
• Operating Systems/Platforms: MS Windows, Fedora Linux, OS-X
• Application Software: Vizio, MS Office (Word, Excel, Outlook, Powerpoint), Version One (V1)
• Development Methodologies: Agile (both Scrum and Kanban), ATDD (Acceptance Test Driven Development), TDD (Test Driven Development), Dev-Ops

PROFESSIONAL EXPERIENCE

Confidential, Everett, WA

Senior Software Engineer Contractor

Responsibilities:

• Analyzed Current ETL Process and Made Suggestions on How to Improve the system by batching the data pull from the Informix database to minimize the number of calls made to the system.
• Created documentation to help in-house developers to set up a local copy of the ETL databases for testing new features.
• Created a Logging Apparatus that simplified troubleshooting for batch applications developed.
• Created a Configuration Apparatus that allowed batch application to be modified through configuration changes without having to re-compile the code.
• Created Critical ETL applications that helped facility transferring of Business data to a third-party vendor for processing so that claims could be processed.
• Created a custom profiling utility to performance tune the ETL batch applications.
• Implemented Coding by Contract into ETL applications to reduce semantic defects within the interfaces of the applications.
• Created a Mocking Interface for Unit Testing the ETL application code.

Confidential, Bothell, WA

Business Analyst/DBA

Responsibilities:

• Setup a code repository for the group using GIT.
• Created ETL application that ingested XML files downloaded from Web Application to SQL Server database.
• Created an in-house logging framework (API) to monitor batch processes
• Created Unit and Acceptance test framework for developing in-house applications

Confidential, Seattle, WA

Senior Software Engineer

Responsibilities:

• Designed/developed a java service that monitored critical java services and automatically restarted these services after the end of day processing lockout period. Incidents where critical services were not turned on by operations were reduced from three on a weekly basis to zero since the implementation of the service.
• Designed and developed frameworks for moving legacy systems to AWS.
• Fixed a memory leak issue with Trading Platform service (java service) where threads were not being properly disposed when certain race conditions occurred.
• Designed a unit test data generation API (junit) that increased unit test coverage for Spring Batch applications to over 95%.
• Designed and implemented base tables and CRUD procs for Power of Attorney system that allowed multiple power of attorneys to be applied to an account and vice versa. This system made sure the brokerage was in compliance with government regulations and that future expansion would require minimal base table changes.
• Refactored critical proc in the dividend system that was causing performance bottlenecks due to deadlocks in the service. Since the implementation of the new proc, no deadlocks have occurred within the past year.

Software Engineer

Confidential

Responsibilities:

• Created a new Transfer In process that streamlined process for customers to transfer accounts into the brokerage for the in-house Powerbuilder app increasing revenue for the Brokerage
• Created a Java API to created standardized email summaries sent to Brokerage detailing batch process statuses. This allowed users to quickly identify errors that needed to be handled to prevent government compliance problems.
• Created test scripts using Perl to validate changes being made to critical stored procedures being refactored for performance.

Confidential, Bothell, WA

Software Engineer

Technologies used: MS SqlServer 2005/2008 Rev2; VS 2005; Accurev, XML, CSS, HTML, SOAP Web Services, Jira, Quality Center

Responsibilities:

• Reduced the time to ingest a product file (xml file) into the database from 20 to 30 minutes to less than 2 minutes freeing up the database resources so that users would not be locked out of the system for lengthy periods of time.
• Designed a migration path for converting legacy Windows Form app to Web application.
• Converted the web product catalog’s front end application from a single region app to a multi-region app to accommodate a distributed user base.
• Performance tuned a web proc to reduce execution time from 2 minutes to 10 microseconds. This removed a major performance bottleneck in the web service since the proc was called multiple times per request.
• Implemented the ingestion of a xml ratings document into the web product catalog.
• Created and maintained numerous ETL systems to provide product data to other core systems at Confidential -Mobile and third party vendors. These systems included Oracle databases.

Confidential, Redmond, WA

Technical Writer

Responsibilities:

• Provided complex spatial query examples to demonstrate the capabilities of new spatial curves modifications introduced in MS SqlServer 2012.
• Documented the new memory management used by MS SqlServer 2012.
• Migrated file-based database from Sun Server to MS SQL Server relational database which improved application response times by 50% and reduced errors due to customer data being unnecessarily duplicated.
• Designed and developed an integration suite in C++ to allow in-house ERP application to synchronize with a third-party accounting suite.
• Performance tuned stored procedures in MS SqlServer database so that drag-n-drop operations within the ERP application for the scheduling page went from a 10 minute page refresh to 100 millisecond refresh. This allowed users to instantaneously make adjustments to shipping schedules to provide customers with more flexibility in changing when their goods were moved.
• Migrated database platform from SqlServer 2000 to SqlServer 2005. Required re-writing several procs to resolve performance issues.
• Designed and developed an Invoicing Program in Cobol to facilitate billing between the contract company and Denali Group.
• Designed website (ASP.net, Adobe Flash) where customers could track shipments through the system.