Project Developer
Resume:
John Goode, Jr.
DOC
RTF
ODT
HTML
TXT
Last updated April 3rd 2012
Resume powered by emurse
-
JOHN GOODE, JR
.
Phone: 540-***-****
Email: ****-*****@****.***
SUMMARY
Motivated and enthusiastic IT Professional with expertise in Extract Transform Load (ETL)
development, database development, system analysis, and requirements management.
Experienced in coordinating and executing all phases of the Software Development Life
Cycle (SDLC). Proven ability to quickly learn and understand new software and
technologies. Excellent written and oral communication skills. Able to work independently
or as part of a team.
TECHNICAL SKILLS
Platforms: Red Hat Enterprise Linux, Ubuntu, UNIX, and Windows.
Databases: MySQL, Oracle, PostgreSQL, and SQL Server.
Programming: CSS, MS-DOS batch, pgSQL, PL/pgSQL, PL/SQL, SQL, T-SQL, UNIX/Linux Shell,
and XHTML.
Development Tools: Cygwin, Hive, Informatica PowerCenter, Nvu, Pentaho Data Integration,
PgAdmin III, SQL Developer, SQL Loader, SQL Plus, Sqoop, Toad for MySQL, Toad for Oracle,
and Tortoise SVN.
Applications: Microsoft (MS) Access, Camtasia, MS Excel, Notepad++, MS Outlook, MS Visio,
and MS Word.
Methodologies: Agile Development, Business Process Modeling Notation (BPMN), ETL,
Rational Unified Process (RUP), Scrum, SDLC, and Unified Modeling Language (UML).PROFESSIONAL EXPERIENCE
Evolvent Technologies, Inc., Herndon, VA
December 2010 - Present
Project: Multidimensional Insurance Data Analytics System (MIDAS)
Role: ETL Developer
Create ETL processes to extract data from sources, load data into targets, perform data
quality checks, perform data transformations, and log results using UNIX shell scripts,
PL/SQL scripts, SQL Plus, and Sqoop.
Create Oracle database procedures, scripts, sequences, tables, triggers, and views used
by ETL processes.
Produce ETL Specifications, Interface Control Documents, and other technical
documentation as needed.
Project: Virtual Lifetime Electronic Record (VLER) - 1c Release
Role: ETL Developer
Created ETL jobs to generate and distribute reports from MySQL database using Pentaho
Data Integration.
Created MS-DOS batch files to execute ETL jobs via Windows Task Scheduler.
Project: Internal Classification of Diseases (ICD) 10 Code Set Analysis
Role: Systems Analyst
Conducted full system analysis of six (6) Military Health Systems by soliciting
information from subject matter experts and reviewing data interfaces, databases, reports,
user interfaces, source code, and business rules.
Identified and documented requirements and made recommendations for migrating the systems
to ICD-10.
Produced Software Requirements Specifications, Requirements Traceability Matrices, Cost
Estimation Parameters, and Migration Plans.
Delta Dental of Virginia, Roanoke, VA
May 2008 - December 2010
Project: DCS Trac Systems
Roles: Database, ETL, and Web Developer
Designed, developed, and administered three (3) web-based systems in a PostgreSQL/Linux
environment.
Created user interface screens, forms, and reports using CSS, XHTML, and pgSQL.
Created ETL jobs using Pentaho Data Integration to handle the maintenance and processing
of data.
Created PostgreSQL database functions, scripts, tables, triggers, and views.
Created MS-DOS batch files to execute ETL jobs via Windows Task Scheduler.
Produced technical and user documentation as needed.
Project: DDVA Management Reports
Roles: Database, ETL, and Report Developer
Gathered requirements from development staff, stakeholders, and system end-users for
management reports.
Created ETL jobs using Pentaho Data Integration to handle the generation and distribution
of reports.
Created Oracle, PostgreSQL, SQL Server database functions, procedures, scripts, tables,
triggers, and views.
Created MS-DOS batch files to execute ETL jobs via Windows Task Scheduler.
Project: DCS Claims and Adjudication
Role:
Business Systems Analyst
Gathered requirements from stakeholders and system end-users for system enhancements.
Coordinated all phases of the SDLC; conducted daily scrum meetings, and tracked
development progress.
Assisted in the design, development, and testing of software and core
application/database components.
Produced Requirements Specifications, Design Specifications, UML Diagrams, and
Implementation Plans.
Project: Pentaho Data Integration Implementation
Roles:
ETL Developer and System Analyst
Gathered requirements from senior developers and stakeholders for implementing Pentaho
Data Integration.
Collaborated with senior developers to define technical specifications and ETL
design/coding standards.
Created ETL jobs using Pentaho Data Integration in an Oracle/UNIX environment.
Created Oracle database procedures, scripts, tables, and views used by ETL jobs.
Created MS-DOS batch files to execute ETL jobs via Windows Task Scheduler.
Project: Production Support Client Liaison
Role:
System Analyst
Triaged production issues, resolved help desk tickets, and conducted weekly status
meetings with clients.
Created ad-hoc SQL queries and reports as requested by system end-users.
Analyzed Oracle databases, system outputs, reports, log files, and system processes.
Created data models, UML diagrams of system processes, and BPMN diagrams of end-user
workflows.
Produced implementation plans and other technical documentation as needed.
Project: Technical Publications
Role:
Technical Writer
Produced mixed-media documentation for software development projects.
Created video demonstrations illustrating software functionality using Camtasia Studio.
PROFESSIONAL TRAINING AND COURSES
Informatica PowerCenter, Informatica - 2011.
UNIX Shell Scripting, Dartmouth College - 2011.
User and System Requirements for Successful Software Development, Learning Tree
International - 2010.
Pentaho Data Integration for Database Developers - 2009.
Oracle PL/SQL - 2009.
PL/pgSQL for PostgreSQL - 2009.
Web Publishing with XHTML and CSS, Ohio University - 2008.
Mastering Camtasia Studio, TechSmith - 2008.
EDUCATION
Virginia Military Institute, Lexington, VA
B.A., English and Fine Arts: Concentration in Writing.
Member of the Air Force ROTC, NCAA Baseball Team, Cadet Newspaper, and English Society.
Recipient of the Dillard Award in 2005 and 2006.
Lord Fairfax Community College, Winchester, VA
Coursework in Business Communication, Research, and Statistics.
Cumulative GPA: 4.0/4.0.
-
Contact this candidate