R E S U M E

Ronald L. Jaramillo

*** ***** **** ******

Saint Helens, OR 97051

Cell: 503-***-****

Home: 503-***-****

adc7p6@r.postjobfree.com

https://www.linkedin.com/in/ronald-jaramillo-b87933/

Personal Goal/Objective: Apply my knowledge of proven new technologies and Agile team practices to further the goals of the organization where I might land

Certifications: Microsoft Certified Professional, ITIL Certificate

Targeted Objective: I wish to provide technical leadership for providing life-cycle support for software applications at Bonneville Power Administration. (GS-13)

PROFESSIONAL PROFILE

I am a Software Developer with thirty-plus years of experience. I have an outstanding record of success delivering enterprise applications and architectures for federal and private business organizations and possess in-depth experience establishing best practices and guidelines for selecting, developing, and implementing information systems within the enterprise. Also, I have extensive experience developing and recommending alternatives for short and long term Information Technology (IT) projects, strategies, practices, policies, and metrics for highly technical and agile organizations in both the public and private sectors.

I am experienced in all phases of the Software Development Life Cycle (SDLC) from requirements analysis through user acceptance and operational support. I have a combination of results-oriented technical team leadership skills with expert technical knowledge of software, hardware, network, and IT service offerings to recommend and deliver best value solutions. I am a decisive and participatory leader with motivating leadership skills and extensive knowledge of emerging trends in the information age.

EXPERTISE

Architecture and Design: I work with stakeholders to develop architecture frameworks that align strategies, processes, and technologies with business goals. I have in-depth experience in establishing best practices and guidelines for selecting, developing, and implementing information systems within the enterprise.

Team Leadership: I apply industry-standard best practices in technical team leadership to ensure the success of applying existing and new technologies to new initiatives and operational support.

System Development Life Cycle (SDLC): I lead full life cycle software development projects for federal and commercial applications.

IT Operations Support Leadership: I lead teams involved in enterprise data, computing, and networking operations whose objective is to meet evolving organizational needs.

Federal and Private Sector Acquisitions: I apply my expertise and knowledge to advise and recommend solutions for acquiring and deploying new technologies to federal and commercial procurements.

Software Developer: I have a wide range of experience, knowledge, and skill in software development standards, practices, database development, application development, and computer language technologies. I continue to apply these to developing software applications engineering, design, development, operations, and maintenance.

.

KNOWLEDGE AND SKILL:

Description

Experience

Skill Level

Professional & ARCHITECTURAL

Skills:

Project Management

8 Years

Advanced

Software Development Life Cycle

12 Years

Advanced

Systems Analysis and Design

12 Years

Advanced

Software Development

15 Years

Advanced

Data Architecture and Modeling

3 Years

Intermediate

Curriculum/Course Development

3 Years

Intermediate

Team Leadership

5 Years

Intermediate

Test Planning

8 Years

Advanced

Object-Oriented Analysis Design

9 Years

Advanced

Web Architecture

5 Years

Advanced

Computer Instruction

3 Years

Advanced

test-driven development

9 Years

Advanced

continuous integration

7 Years

Advanced

pair programming

10 Years

Advanced

Extreme programming practices

10 Years

Advanced

Agile

15 Yeara

Advanced

Software Development and Database:

C#.NET

3 Years

Advanced

Visual Basic.NET

3 Years

Advanced

ADO.NET

3 Years

Advanced

ASP.NET

3 Years

Advanced

MS SQL Server,

12 Years

Advanced

T-SQL

5 Years

Advanced

JavaScript

5 Years

Advanced

C++

3

Intermediate

MVC

3 Years

Advanced

Web Design

5 years

Advanced

Web Development

5 years

Advanced

User Designed Function, Triggers

5 years

Advanced

SQL Server Stored Procedures

4 Years

Advanced

SQL Server Database Admin

2 Years

Intermediate

Ajax, jQuery,

3 Yeaars

Intermediate

Cascading Stylesheets (CSS)

5 Years

Advanced

HTML and HTML5

5 Years

Advanced

XML

3 Years

Intemediate

SOAP

3 Years

Intermediate

REST API

3 Years

Intermediate

Web Services

6 Years

Intermediate

TypeScript

2 Years

Intermediate

JavaScript

3 Years

Advanced

PHP

2 Years

Intermediate

MySQL

2 Years

Intermediate

XML

3 Years

Advanced

T-SQL

4 Years

Advanced

Visual Basic 3,4,5,6

8 Years

Advanced

VBScript

3 Years

Advanced

Active Server Pages (ASP.NET)

3 Years

Advanced

MVC, MVVM

Shopify/ Liquid

6 Months

Beginner

Tools AND

INFRASTRUC-TURE and Frame-works:

MS .NET Framework

3 Years

Advanced

MS Visual Studio.NET

3 Years

Advanced

MS Visual SourceSafe

3 Years

Intermediate

MS SQL Server (2000 and V7)

4 Years

Advanced

NUnit Test

2 Years

Advanced

Nant .NET Build Tool

2 Years

Intermediate

Draco.Net Build Integration

2 Years

Intermediate

MS Project

5 Years

Advanced

React

1 Year

Intermediate

Node.JS

1 Year

Intermediate

AngularJS

1 Year

Intermediate

Microsoft Team Foundation Server

5 years

Advanced

Operating Systems:

MS/Windows XP, 2000, 98, NT

2 Years

Advanced

Unix

3 Years

Intermediate

xUnit, Microsoft Test (TFS)

10 Years

Advanced

SVN

KNOWLEDGE AND SKILL

Testing

and

CODE VERSION CONTROL

SKILL

EXPERIENCE

LEVEL

XUnit

10 YEARS

Advanced

Microsoft Test

5 Years

Advanced

Subversion (SVN)

10 Years

Advanced

Microsoft Version Control(TMS)

5 years

Advanced

134

121

+13

WORK HISTORY

Employer: Bonneville Power Administration (BPA), US Department of Energy

(Contractor with TEK Systems, Inc.)

Employer Address: 905 NE 11th Avenue, Portland, OR 97232

Position: Team Lead for the Pisces Team, Senior Software Developer

Dates: 9/14/2009 to 01/03/2018 (8 years, 6 months)

Introduction

I managed application development and operations support of the Pisces system. This system is a multi-tier suite of applications that work together to accomplish the objectives of BPA’s Fish and Wildlife program. The user base of 1,900 active users consists of personnel from external Federal and State agencies, private contractors, educational institutions, and BPA employees. Access to the Pisces system is available through the internal BPA Intranet, external Internet, and the BPA desktop. The components of the Pisces system include desktop applications, web applications, web and Windows services, console applications, and portals for smartphone applications.

I use the following technologies in my day-to-day work:

Microsoft Team Foundation (TFS) Server 2012 and Microsoft Visual Studio 2012 development environments;

C# and VB.NET programming languages;

Windows 7/XP/Server 2005 & 2008; SQL Server 2005/20082012,

Microsoft .NET Framework 4.0 and 3.5;

Windows Communication Foundation (WCF); XML web services;

And ASP.Net; XML, HTML, JavaScript client-side scripting;

I use the following methodologies and practices daily: Agile best practices, test-driven development, object-oriented programming, and continuous integration.

Responsibilities

(40%) Integrate Pisces into BPA Enterprise: I incorporate the elements of the Pisces system into the IT infrastructure of the BPA Enterprise System. I consider several factors in developing technical specifications, refining functional requirements, developing design specifications, and implementing the various components:

-Pisces System interaction with management servers, database servers, web server through three security zones: the external Internet, the demilitarized zone (DMZ), and the internal BPA intranet and server network.

-Access to the Pisces system components and data stores by users and services. These include considerations for database access, service access, Pisces user access, and standard Windows login access.

-Server and connection configurations for leveraging database server failovers.

-Design for database mirroring across several database servers, and data replication for development, test, and production environments.

-Pisces deployment schemes that employ replication of system components and their security access across the boundaries of three security zones (internal Intranet, external Internet, and the DMZ).

-Integration with external GIS mapping services and databases that reside at external sources within the federal and commercial sectors.

-Integration with other external commercial and data providers and services in the federal, state, and private sectors.

(40%) New Application Enhancements: I analyze requirements, create technical specifications, refine functional requirements and design specifications, and participate in planning for new application development and incorporation of new technologies to the Pisces system. I lead the Pisces team in developing a code solution and performing unit, system, performance, and compatibility testing. Also, I provide leadership for deploying the applications that provide tools for creating, maintaining, monitoring, and measuring contracts related to fish enhancement and protection on the Columbia and Snake River Basins.

(10%) Work Planning: I actively participate with project managers and Fish and Wildlife managers in evaluating, estimating, prioritizing, and scheduling work effort.

Key Accomplishments:

Pisces System Infrastructure: I led my team in successfully implementing solutions for the Pisces system to operate within the IT infrastructure of the BPA Enterprise System. This required that I actively participate in the infrastructure planning at the enterprise level, that I effectively articulate the requirements of the Pisces system within that environment, and that I negotiate a working solution within the available alternatives.

Build, Test, and Deployment: I designed and developed an effective approach for automating tests, builds, and deployments to the Pisces development, test, and production environments. These deployments include system applications, Windows and Web services, database objects, and database logic. Deployments distribute these components to the appropriate security zones within the BPA Enterprise System.

Pisces Enhancements and Features: I led my team in successfully developing and implementing many new features and capabilities on time and on-schedule. These include:

-Integration of Pisces components into the BPA Enterprise System

-Leveraging new security schemes for data access, service access, and Pisces application access.

-Integration of Pisces mapping components with external GIS and Google mapping systems.

-Adding new features for capturing external data and exporting to external data stores via new or existing services.

-Adding new features for capturing and reporting BPA Fish and Wildlife contractual data, land acquisition data, contract monitoring and measurement data, and data related to the Biological Opinion on the Federal Columbia River Power System.

Conversion to New Technology Base: I led my team in successfully converting the Pisces system source components to newer technology bases for the Microsoft .NET environment, SQL Server database, and Enterprise GIS mapping.

Employer: Hollywood Entertainment Corp

Employer Address: Wilsonville, OR

Position: Technical Lead for the Store Systems Team, Senior Software Developer

Dates: 11/22/2004 to 8/21/2009 (4 years, 9 months)

Supervisor: Phil Harbeck, IT Manager (adc7p6@r.postjobfree.com)

Introduction:

Hollywood Entertainment, Inc. comprised a corporate office and a national chain of 2,700 video stores. All stores used a common Point of Sale (POS) system that was created, enhanced, maintained, supported, and deployed by a staff of fourteen developers and technicians. I was the technical lead for that team.

The POS system was a critical business application that provided the essential business-to-consumer interface for Hollywood Entertainment’s sales and movie rental transactions. It was built on a composite of technologies ranging from legacy MS-DOS to state-of-the-art Microsoft Windows and .NET. The POS leveraged both text-based and Windows-based user interfaces (UI’s). These UI’s, in turn, were supported by personnel data, inventory data, and sales transactions stored on flat files, indexed sequential files, and relational databases (Oracle and Microsoft SQL Server). Computer systems, services, and databases at the stores communicated with corporate office systems through a complex of web services. This corporate enterprise system was constantly evolving and offered challenging scenarios for meeting customer support, and corporate business, financial, and reporting needs. Weekly deployments of the POS application and database deployments to each of the 2,700 stores added to this complexity.

Responsibilities:

(40%) Evolve the POS: I led the Store Systems team through the technical evolution of the Hollywood Entertainment POS system. I led the planning, design, and specification, development, and implementation of new technologies for hardware and software. It was a transition from a legacy system written in COBOL, C, and C++ to a Microsoft .NET system written in C# using object-oriented architecture. Data storage was transitioned from text-based flat and indexed sequential files to relational databases managed through Oracle and Microsoft SQL Server. Delivery of our financial data dictated a requirement for guaranteed delivery and error correction. Thus, we replaced our video store-to-corporate office messaging to leverage the Transmission Control Protocol (TCP) instead of the User Datagram Protocol (UDP). All these changes generated new requirements for servers, network service providers, networks, and database management systems. I was instrumental in refining these requirements and the alternatives to these requirements and presenting them to management for their evaluation and decision.

(15%) Sarbanes–Oxley Act Requirements: I managed a team that developed technical specifications, functional requirements and design specifications for modifying the Hollywood Entertainment Corporation’s IT Enterprise infrastructure to comply with the Sarbanes–Oxley Act of 2002. Central to this effort was the need to implement sufficient security enhancements to protect financial and personal information assets. We applied these design specifications to corporate systems including the Hollywood Entertainment POS System.

(30%) New Applications Development: I analyzed requirements, created technical specifications, refined functional requirements, and design specifications, and planned new applications development. I offered recommendations for new technology solutions to support new applications and to help meet increased load on our corporate-to-store networks.

(15%) Store Systems Team Work Processes and Planning: I led the Store Systems team in developing code solutions, and performing unit, system, performance, and compatibility testing. This I did through one-on-one sessions with team members, conducting formal and informal discussions of new and existing technologies, design and code walk-throughs, and daily standup meetings. I conducted release, customer support, and deployment planning sessions that included “walkthroughs” and management briefings.

Key Accomplishments:

Migration of Legacy System to New Technology: I successfully led the Store Systems team through the conversion of the legacy POS and store inventory systems to new systems leveraging state-of-the-art technologies. I applied the principles and methods of service-oriented architecture (SOA) to leverage the use of Linux, Windows, and web services in the overall context of the POS.

Logging and Outage Management: I was the primary designer and lead my team in developing the following customer support tools:

- Automated logging for POS transactions. Using that data, I was able to proactively detect and respond to user issues that were occurring at the stores.

- An automated logging system for POS system deployments. The data provided a means for me to monitor POS system deployments thus alerting me to issues with deployments.

- A diagnostic system that showed me discrepancies between standardized store system configurations and actual in-store system configurations. This capability provided real-time background essential to resolving issues at a given video store.

Store-to-Store Message Delivery: I successfully led the development of a store-to-store message delivery system using .NET 3.0 (WCF) and service-oriented architecture.

Mentorship and Training: I trained and converted COBOL developers to develop object-oriented applications using C#, ADO.NET, Windows Services, Web Services, and SQL Server.

Sarbanes–Oxley Act Requirements: Our team’s technical specifications, functional requirements, and design specifications were approved by management and were implemented into the IT Enterprise. The resulting security enhancements passed all private audits.

Standards and Best Practices: I established coding and design best practices for the POS development team by applying Information Technology Infrastructure Library (ITIL) and Microsoft development standards and practices. I successfully incorporated automated unit testing, continuous build integration, source control, and automated deployments into the software development and maintenance life cycle.

Workflow and Outage Reporting: I analyzed, developed, and planned workflow processes for incident and outage reporting. This activity included an analysis of our existing service request (SR) process. My resulting proposal was reviewed and adopted IT management.

Employer: Fios, Inc.

Location: Portland, OR

Position: Technical Team Lead, Senior Software Developer

Dates: 6/18/2001 to 10/22/04 (3.5 years)

Supervisor: Matt Deniston (Project Manager, 503-***-****)

Introduction:

I managed a team that developed web-based legal discovery tools collectively known as Prevail. Prevail was the core business system for the Fios enterprise. This critical business application was targeted for sale and use by small to large legal organizations and was the primary source of income for Fios, Inc. Its purpose was to process, integrate, categorize, and present legal documents of many different. Documents were ultimately presented by a web application as HTML, PDF, or one of several graphics formats.

I participated in the analysis and design specifications to Prevail. These offered several challenges. (1) A document rendered in HTML needed to look identical to the original document in its native format. (2) Users needed the ability to edit, redact, organize, and search documents by content and context. (3) Rules were fluid for IO access to documents. They were governed by the client’s role concerning a particular legal matter. This role was subject to change on a day-to-day basis. (4) The system needed to be able to quickly produce hard copies of documents in high volumes. All these factors combined dictated the use of the latest technologies for searches, document conversion, document presentation, document and data storage and retrieval, and document indexing across several infrastructure boundaries.

Responsibilities:

(100%) Team Leadership: I led a team of developers, business analysts, and a database administrator that employed agile methodology to develop a system based on n-tier architecture. My team leveraged Microsoft .NET technologies, SQL Server 2000, and web services to produce a client interface, business rule tier, database back end, and service layer. I developed the technical specifications, refined the functional requirements with users, and created the design specifications.

The resulting application enabled clients to organize, search, and process documents related to the legal discovery process. The input was both electronic and hard copy. Electronically based documents were collected, organized, transformed to HTML and their content was indexed and stored to a database. Paper documents were transformed into an image format. Document metadata was extracted, stored, and indexed for both images and electronic documents.

Key Accomplishments

My technical specifications, functional requirements, and design specifications for the Prevail were adopted by management and utilized for successfully implementing an operating infrastructure and automated system for electronic legal discovery. This system was purchased and used by clients large and small including the U.S. Department of Justice, the California Department of Justice, and many private legal firms.

Employer: Passport Online, Inc.

Location: Portland, OR

Position: IT Manager

Dates: 7/1993 to 6/2001 (Eight years)

Introduction:

I established the IT organization and created the computing infrastructure for Passport Online, Inc. I led the development of the company’s flagship product that collected, stored, distributed, and presented information related to the sales and fulfillment of leisure travel. Our clients were travel agencies and other providers of leisure travel including tour companies, cruise lines, and travel brokers.

Responsibilities

(60%) IT Manager: As IT manager, I hired staff to provide ongoing assistance for our system development and support efforts, and I arranged contracts with technical developers to assist when a high level of effort was needed. I brokered agreements for offsite data storage and processing with organizations such as Intel Online. I developed requirements and specifications for internal computing needs and proposed these to the company’s board of directors.

(40%) Technical Lead: I developed the technical specifications, functional requirements, and design specifications for an n-tier, web-based application that offered search capabilities for real-time leisure travel offers and specials. To support this application, I designed an extract, transform, and load (ETL) process that retrieved data from the various leisure travel sources, processed the data, stored the results on offsite provider databases, and presented the data to potential travel customers via a web page.

Key Accomplishments

Application Infrastructure: My technical specifications, functional requirements, and design specifications were successfully translated into applications that facilitated Business-to-Business (B2B) interactions between leisure travel suppliers and retailers. The functions of the web-based applications included the following features: (1) a consumer interface that obtained up-to-the-minute travel content and pricing data from suppliers and displayed this information into uniquely branded programs for the agent and consumer; (2) a web-based administrator that enabled travel retailers to utilize web portals for their customers, manage their fulfillment office and affiliation company profiles, choose which suppliers and offers would appear on their web site, and manage the display of their special offerings; (3) an agent interface that enabled individual travel agents to book offers, disseminate marketing materials, and view customer activity reports; and (4) a supplier interface that provided travel suppliers with statistical reports and with a web-based interface to manipulate their data.

ETL: I analyzed, designed, and developed extract, transform and load (ETL) processes to transfer customer activity logging data to database supporting reports, ad hoc queries, and historical analysis for marketing, sales, and management.

Database Architecture: I developed enterprise data architecture for travel information databases. This architecture included components for on-line transaction processing (OLTP) to support operations, on-line analytical processing (OLAP) to support business intelligence and analysis, operational data store (ODS) components to enable data management, and gateways to the external cruise, tour, and vacation package databases and applications. The databases stored new and existing travel offers; supplier profiles and branding; travel agency profiles and branding, and customer profiles; supplier/travel agency preference relationships; unit and sale pricing; customer activity tracking; and agency web site customization features for consumer views.

Desktop Applications: I led the development of MS Windows application software for leisure and commercial travel of which 4,000 copies were sold to leisure travel companies. These applications utilized a local, desktop database to provide leisure travel shopping and an avenue for booking the latest travel offers. Data were maintained centrally at Passport Online, and updates were downloaded to the customer site through an FTP. Customer travel requests were forwarded to a preferred agent list via an automated email interface. Customer activity was stored at the local desktop and forwarded to the central site whenever a customer emailed a booking request to update their local database.

Employer: AQE International, Inc

Location: Portland, OR

Position: Owner and Manager

Dates: 1985 – 1993 (7 years)

Supervisor: Self-employed

Introduction:

I established, owned, operated, and obtained venture capital for a company that provided technical training and computer technical consulting

Responsibilities

(20%) Proposals: I was the primary proposal writer for my company. I wrote responses to requests for proposals to perform state and federal contracts with the State of Oregon, U. S. Forest Service, U.S. Army Corps of Engineers, and U.S. Bureau of Indian Affairs.

(20%) Computer Training Curriculum: I developed curriculum and training manuals for UNIX, Oracle, C Programming, and MS Windows applications.

(20%) Technical Lead: I performed as a lead systems analyst and developer on several contracts awarded to my company. These customers included the U.S. Forest Service, U.S. Army Corp of Engineers, U.S. Bureau of Indian Affairs, the Confederated Tribes of the Warm Springs Indian Reservation, the Oregon Department of Forestry, and the Oregon Department of Fish and Wildlife.

(20%) Technical Trainer: I conducted training seminars on UNIX, Oracle, C Programming, MS/PC-DOS, and Microsoft Windows applications. My customers included the U.S. Forest Service, U.S. Army Corp of Engineers, Intel Corporation, U.S. Bureau of Indian Affairs, the Confederated Tribes of the Warm Springs Indian Reservation, and the Oregon Department of Forestry.

(20%) Oracle Database Administrator: I performed database administration for the U.S. Army Corps of Engineers government agency using Oracle database in a UNIX environment.

Key Accomplishments

Venture capital: My proposals for establishing a computer training facility and office were successful in obtaining the necessary financial base to operate and grow my company.

Government contracts: My proposals to federal and state agencies were successful in obtaining contracts from the U.S. Forest Service, the U.S. Bureau of Indian Affairs, the U.S. Army Corps of Engineers, the Oregon Department of Forestry, and the Oregon Department of Fish and Wildlife.

Systems Analysis and Development:

I designed and developed customer problem resolution and tracking database. (U.S Army Corps of Engineers)

I designed and developed a micro-to-mainframe interface for converting personnel tracking data. (ESCO Corporation)

I developed a fisheries database management and reporting system. (Oregon Department of Fish & Wildlife)

I designed and developed a job applicant database. (National Image, Inc.)

I conducted needs assessments and proposed recommendations for computer training. (U.S. Army Corps of Engineers)

I designed and developed a Forest Fire Accounting System. (Oregon Department of Forestry)

I designed and developed a Client Tracking System. (Washington Country Community Action Organization, Oregon Kidney Association)

Employer: U.S. Forest Service, Pacific Northwest Region

Location: Portland, OR

Position: Supervisory Systems Analyst, GS 12 - 13

Dates: 9/1982 – 9/1985 (3 years)

Supervisor: William Funk 503-***-****)

Introduction

I managed the Region Six (Oregon and Washington) Systems Support Group which provided region-wide technical support for computer acquisition and deployment, and for computer training. I managed a core team of eight people and coordinated with seven at-large teams totaling sixty people.

Responsibilities

(75%) Regional Distributed Processing Systems: I coordinated the planning and implementation of the Pacific Northwest Region’s distributed processing system at Regional, Forest, and District offices. The scope of the project included site planning, security planning, information dissemination, information systems requirements, software requirements, hardware requirements, and planning for system installations.

I estimated the project resource needs and worked with Regional Office and Forest managers to recruit members to fill the at-large teams. The project plan I developed was reviewed and approved by Forest Service line management. Due to the wide organizational scope of the project, I published progress reports in the Forest Service newsletter, and I conducted periodic management and vendor briefings.

The project’s time and budget constraints were based on annual Congressional funding. This funding was tied to national Forest Service procurement for distributed systems

Contact this candidate