Summary
Overview
Work History
Education
Skills
Certification
References
Additional Information
Timeline
Generic

Ronald L Jaramillo

Portland,OR

Summary

Very experienced and versatile software developer and team lead.

Overview

57
57
years of professional experience
1
1
Certification

Work History

Professional Genealogist; Paleographer

Self
Saint Helens, OR, OR
01.2018 - Current
  • I collaborated with Genealogical Researchers to transcribe ancient Spanish documents (civil, legal, Catholic Church Sacramental) to provide primary source references for Ancestry.com and FamilySearch.org databases. This provided Professional genealogists with tools and data for completing family trees and supporting documentation saving time and expense for genealogists.
  • As a Professionsal Genealogist, I researched genealogy for individual clients creating trees and supporting documents that reconnected them with lost siblings and their family history.
  • I served as a boardmember of the New Mexico Genealogical Society (NMGS) and assisted members with their research. I created and supported the NMGS website prividing membership with online access to a multitude of genealogical research resources such as primary sources, documents, and oral histories.

Contractor Team Lead, Senior Software Developer

TEKsystems, Inc, Bonneville Power Administration, BPA
Portland, OR
09.2014 - 12.2017
  • Supervisor: Jason Stabe, ( BPA - JSI) Hours/Week: 40 Introduction I was technical team lead for systems 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 included 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, Internet, and the BPA desktop.
  • The components of the Pisces system include desktop applications, web applications, web and Windows services, console applications, portals for smartphone applications, and the Pisces database.
  • My team has varied in size from three to eight members depending on the extent and criticality of current user needs.
  • I use the following technologies in my day-to-day work: Microsoft Team Foundation (TFS) Server 2010, C# and VB.NET programming languages; Windows Server 2005 & 2008; SQL Server and Oracle databases, Microsoft .NET Framework 4.0, 3.5; Windows Communication Foundation (WCF); XML web services; ASP.Net; XML, HTML, JavaScript client-side scripting; Microsoft Visual Studio 2010 development environments; and data replication services using Microsoft Distributed File System Replication (DFSR).
  • I use the following methodologies and practices daily: Agile best practices, test-driven development, object-oriented programming, and continuous integration.
  • Responsibilities (40%) Convert Pisces Desktop to Web: 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 was 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, portals for smartphone applications, and the Pisces database.
  • I was the technical lead in charge of a team of developers that converted the Pisces Desktop application to the Web.
  • As team lead representing BPA's interests, I interacted with a team lead of the Sitka Technology Group which was the firm contracted to produce the convert the elements of the Pisces system.
  • I consider several factors in developing technical specifications, refining functional requirements, developing design specifications and implementing the various components:.
  • Pisces System interaction involves management servers, database servers, and web servers through three security zones: the external Internet, the demilitarized zone (DMZ), and the.
  • Internal BPA intranet and server network.
  • User access to the Pisces system components and data stores and needed to consider database and services, Pisces user, and standard Windows login.
  • 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.

Senior Software Developer, Lead Developer

FIOS, INC
PORTLAND, OR
06.2001 - 10.2004
  • I was lead developer for a web application development project built on an n-tier architecture and utilizing Microsoft SQL Server 2000 and .NET technology.
  • The project team consisted of four developers.
  • The application enables clients to organize, search, and process documents related to the legal discovery process.
  • Input is both electronic and hard copy.
  • Electronically based documents are collected, organized, transformed to HTML.
  • Paper documents are transformed to image.
  • Metadata is extracted and stored for both images and electronic documents.
  • Content and metadata is indexed.
  • Metadata, textual indexes, and concept index references are stored on a database.
  • Images, HTML renderings, and the original files are stored on Blue Arc servers for access via the web application.
  • The user interface offers a wide variety of options for searching, sorting, categorizing, processing and reporting this document information.
  • Database Designer: I design, develop, and implement SQL Server databases.
  • I define the database objects (tables, views, column/field types), accessibility and performance features (indexes, indexing schemes, and foreign keys), data storage arrangements (server locations, file groups, database instances), and interaction between several databases and servers to support such features as replication and full-text indexing.

Senior Developer

PASSPORT ONLINE, INC
PORTLAND, OR
07.1993 - 05.2001
  • Analyzed and designed 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.
  • The OLAP databases were designed using a dimensional database strategy to resolve the original OLTP structures into star schema s.
  • (SQL Server 7, Embarcadero ER/Studio).
  • Analyzed, designed, developed and implemented extract, transform and load (ETL) processes to transfer customer activity logging data to data warehouse (OLAP database) supporting reports, ad hoc queries, and historical analysis for marketing, sales, and management.
  • (Data Junction, Visual Basic, ADO, SQL Server 7).
  • Led the development and provided technical leadership for n-tier, component-based applications.
  • I was managed program design, coding, testing, debugging, and documentation.
  • These applications facilitated Business-to-Business (B2B) interactions between leisure travel suppliers and retailers.
  • The functions of the web-based applications included: (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 site administrator 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.
  • (4) A supplier interface that provided travel suppliers with statistical reports and a web-based interface to manipulate their data.
  • (ASP, JavaScript, VBScript, MS SQL Server, COM, ADO).
  • Analyzed, designed, and developed MS Windows application software for leisure and commercial travel.
  • I managed program design, coding, testing, debugging, and documentation.
  • These applications utilized a local, desktop database to provide leisure travel shopping and an avenue for booking the latest travel offers.
  • Data was maintained centrally at Passport Online, and updates were facilitated through automated FTP between a customer's desktop and the Passport central site.
  • 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 updated their local database.
  • (Visual Basic, MS Access, ActiveX, C++, InstallShield).
  • I Managed and supervised the development staff.
  • The development staff consisted of three Windows and Web developers skilled in Structured Query Language (SQL), Microsoft SQL Server and Access databases, Active Server Pages, Component Object Model (COM), Visual Basic, and C++.
  • I Managed and supervised customer technical support staff.
  • The technical support staff, consisting of five people, serviced a user population of several hundred travel agencies that installed and used our applications software in a Microsoft Windows environment.

Owner Manager, Database Administrator, Senior Programmer/Analyst, Computer Instructor

AQE INTERNATIONAL, INC
01.1985 - 01.1993
  • Annual Budget: $400,000.

Job Titles, Program Manager, Supervisory Systems Analyst

BONNEVILLE POWER ADMINISTRATION
01.1981 - 01.1982
  • Planned, managed, and provided technical leadership for the implementation of a region-wide distributed processing system.
  • Managed the implementation of electronic mail and file distribution network.
  • Established and managed region-wide computer technical support operation.
  • Managed national computer training program.
  • Coordinated implementation of national engineering graphics computer systems.
  • Managed U.S.
  • Forest Service/ Bureau of Land Management interagency study for combining information systems functions of the two agencies.
  • Analyzed and cataloged national-level information flow for upward reporting.
  • Proposed new database structures and procedures for streamlining the national information system.
  • Analyzed system requirements for distributed computer networks at the regional and national levels.
  • Supervised the regional systems support group.
  • Of People Supervised: 4; Annual Budget: $280,000.

Systems Analyst/Programmer

WASHINGTON COUNTY, OREGON
01.1980 - 01.1981
  • Analyzed, designed, and developed online data entry/edit, online inquiry, and reporting programs for financial management system and database.
  • I was responsible for program design, coding, testing, debugging, and documentation.

Analyst and Developer

01.1970 - 01.1980
  • Performed database administration (contract) for large government agency using Oracle database in Unix environment (U.S.
  • Army Corps of Engineers).
  • Designed and developed customer problem resolution and tracking database.
  • (U.S Army Corps of Engineers).
  • Designed and developed a micro-to-mainframe interface for converting personnel tracking data.
  • (ESCO Corporation).
  • Developed fisheries database management and reporting system.
  • (Oregon Department of Fish & Wildlife).
  • Designed and developed a job applicant database.
  • (National Image, Inc.).
  • Conducted needs assessments and proposed recommendations for computer training.
  • (U.S.
  • Army Corps of Engineers).
  • Designed and developed a Forest Fire Accounting System.
  • (Oregon Department of Forestry).
  • Designed and developed The Client Tracking System.
  • (Washington Country Community Action Organization, Oregon Kidney Association), U.S.
  • FOREST SERVICE, PACIFIC NORTHWEST REGION # of People Supervised: 7; Annual Budget: $7,000,000.

Supervisory Systems Analyst, Computer Programmer, Computer Operator

U.S. FOREST SERVICE, PACIFIC NORTHWEST REGION AND ALASKA REGION
01.1970 - 01.1980
  • Managed and provided technical leadership for a National Forest level organization.
  • Analyzed requirements, designed, and coded natural resource, engineering, and business related applications.
  • Supervised computer operations.

Computer Instructor

US MARINE CORPS, MARINE CORPS SUPPLY ACTIVITY
PHILADELPHIA, PA
01.1968 - 01.1969
  • Developed Curriculum and Training Manuals for UNIX, Oracle, C Programming, and MS Windows applications.
  • Conducted training seminars on UNIX, Oracle, C Programming, MS/PC-DOS and Microsoft Windows applications., Hrs# of People Supervised.
  • 2.

Software Developer

  • I develop web, client-server, and console-based applications interfacing with databases on the "backend" through a business and data access layer.
  • My activities include all aspects of the software life-cycle: defining system requirements, design, coding, testing (unit, regression, integration), quality assessment, and deployment.
  • I develop and implement user interfaces, business rule logic, data access layers, and database processing logic.
  • The following is a summary of the languages, technologies, and methods I use:.
  • Database Logic: SQL Server 2000 stored procedures, user-defined function, triggers, views.

Supervisory Systems Analyst

Job
  • Led the development and analyzed requirements for a management information system related to information technology management.
  • I was responsible for program design, coding, testing, debugging, and documentation.
  • Analyzed and proposed project management tools.
  • These included both software, and libraries of standards and methodologies.

Systems Programmer

JOB TITLE
  • Developed operating system logic tape, card, and disk I/O on IBM/360's.
  • Converted operating system logic from tape operating system (TOS) to disk operating system (DOS).

Education

Bachelor of Science - Chemistry, POSTGRADUATE STUDIES Management Info. Systems, Education Administration

Portland State University, U. of Alaska, Northwestern School of Law

Skills

  • T-SQL
  • 4 Years
  • Advanced
  • Visual Basic 3,4,5,6
  • 8 Years
  • Advanced
  • VBScript
  • 3 Years
  • Advanced
  • Active Server Pages
  • 3 Years
  • Advanced
  • Shopify/ Liquid
  • 6 Months
  • Beginner
  • TOOLS AND
  • INFRASTRUC-TURE: MS NET Framework
  • 3 Years
  • Advanced
  • MS Visual StudioNET
  • 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
  • DracoNet Build Integration
  • 2 Years
  • Intermediate
  • MS Project
  • 5 Years
  • Advanced
  • OPERATING SYSTEMS: MS/Windows XP, 2000, 98, NT
  • 2 Years
  • Advanced
  • AdoNET and SQL,
  • Web Logic: Visual BasicNET, C#NET, ASPNET, JavaScript, HTML, XML, VBScript, Microsoft Message Queue Service, DTSearch Text Search API, Engenium Concept Search API, Blue Arc file service
  • Client-Server and Console Logic: Visual BasicNET, C#NET, and Microsoft Message Queue Service
  • Unit Testing: NUnit unit-testing framework for NET
  • Build and Deployment: SourceForge NAnt, SourceForge Draco
  • Source Code Control: Microsoft Visual SourceSafe
  • Methodologies: Object Programming, Agile Methods, and eXtreme Programming
  • NET, ASPNet, Microsoft NET, VBNET, C#NET, Visual BasicNET, Accounting System, Active Server Pages, ActiveX, ADO, Ad, Agile, API, Army, ASP, Agency, Avenue, B2B, Book, Branding, Budget, Business intelligence, C Programming, C, Client-Server, COM, Computer networks, Computer operations, Computer training, Concept, Content, Course Development, Client, Clients, Data entry, Data management, Data warehouse, Database administration, DATABASE, Databases, Database management, Debugging, Documentation, DOS, Edit, Electronic mail, Email, ETL, XML, Features, Financial management, FTP, Functional, Gateways, GIS, Government, Graphics, HTML, 4, HTML, IBM/360, Image, Indexing, Information systems, Information technology, InstallShield, Instruction, JavaScript, Leadership, Team lead, Legal, Logging, Logic, Mainframe, Marketing, Marketing materials, Access, MS Access, C#, Office, MS Project, SQL Server 2000, SQL Server 7, Microsoft Windows, Windows, MS Windows, 2000, 98, NT, Windows XP, Management information system, Modeling, Microsoft Message Queue, Natural, Enterprise, Network, Object-oriented programming, Operational data store, ODS, OLAP, Operating system, OPERATING SYSTEMS, Oracle, Oracle database, Developer, PC-DOS, Personnel, Pricing, Problem resolution, Processes, Program design, Coding, Programming, Project Management, Quality, Reporting, Sales, Seminars, Servers, Scripting, Software Development, Sorting, Visual SourceSafe, MS SQL Server, Microsoft SQL Server, SQL, Structured Query Language, SQL Server, Strategy, Supervisor, Systems Analysis and Design, Systems development, Tables, Technical support, Systems support, Training Manuals, T-SQL, Transaction processing, UNIX, User interface, VBScript, View, Visual Basic, Visual Basic 3, Microsoft Visual Studio, MS Visual Studio, Web applications, Web application development, Web servers, Web site, Windows Server

Certification

C#.NET 3 Years Advanced Visual Basic.NET 3 Years Advanced ADO.NET 3 Years Advanced ASP.NET 3 Years Advanced SQL Server 2000 Stored Procedures, User Defined Functions, Triggers 4 Years Advanced SQL Server Database Admin 2 Years Intermediate HTML 4 Years Advanced JavaScript 3 Years Advanced XML 3 Years Advanced

References

REFERENCES MATT DENISTON CEO,Sitka Technology Group 920 SW Sixth Ave. Suite 111 Portland, OR 97204 (800) 808-1204 Matt@sitkatech.com DAL MARSTERS 920 SW Sixth Ave, Suite 111 Portland, OR 97203 (503) 808-1241 dal.marsters@sitkatech.com MICHAEL FERRANTE .Senior Software Engineer (503)475-9748 Michael.henning.ferrante@gmail.com JASON STABE 905 NE 11th Ave Portland, OR 97232 jstabe@bpa.gov

Additional Information

  • MILITARY SERVICE , U.S. Marine Corps, 1968-1970 Viet Nam Era Veteran.

Timeline

Professional Genealogist; Paleographer

Self
01.2018 - Current

Contractor Team Lead, Senior Software Developer

TEKsystems, Inc, Bonneville Power Administration, BPA
09.2014 - 12.2017

Senior Software Developer, Lead Developer

FIOS, INC
06.2001 - 10.2004

Senior Developer

PASSPORT ONLINE, INC
07.1993 - 05.2001

Owner Manager, Database Administrator, Senior Programmer/Analyst, Computer Instructor

AQE INTERNATIONAL, INC
01.1985 - 01.1993

Job Titles, Program Manager, Supervisory Systems Analyst

BONNEVILLE POWER ADMINISTRATION
01.1981 - 01.1982

Systems Analyst/Programmer

WASHINGTON COUNTY, OREGON
01.1980 - 01.1981

Software Developer

Supervisory Systems Analyst

Job

Systems Programmer

JOB TITLE

Bachelor of Science - Chemistry, POSTGRADUATE STUDIES Management Info. Systems, Education Administration

Portland State University, U. of Alaska, Northwestern School of Law

Analyst and Developer

01.1970 - 01.1980

Supervisory Systems Analyst, Computer Programmer, Computer Operator

U.S. FOREST SERVICE, PACIFIC NORTHWEST REGION AND ALASKA REGION
01.1970 - 01.1980

Computer Instructor

US MARINE CORPS, MARINE CORPS SUPPLY ACTIVITY
01.1968 - 01.1969

Similar Profiles

CREATE PROFILE
Ronald L Jaramillo