Summary
Overview
Work History
Education
Skills
Timeline
Generic

Douglas Fullen

Dayton,OH

Summary

Results-oriented IT professional with 27 years of expertise in SQL and Java development. Demonstrated success in refining SQL development and enhancing database performance. Proficient in advanced technologies like WebSphere and Python, aligning technical solutions with business objectives to foster cross-functional collaboration. Strong mentorship and problem-solving skills with a track record of achieving exceptional results in complex SQL environments and business intelligence. Versatile asset with diverse knowledge of complex reporting, legacy programming languages, and up-to-date tools. Adept at leading software development and troubleshooting.

Overview

26
26
years of professional experience

Work History

Lead SQL Developer

Boeing / Capgemini Contractor
01.2022 - 01.2023
  • Optimized SQL queries for military contracts, enhancing OnePL system performance and reducing response time for critical operations
  • Resolved L2/L3 tickets, ensuring seamless OnePL operations for user satisfaction
  • Improved rule efficiency in OnePL, boosting adaptability and security
  • Aligned SQL solutions with business needs, supporting cross-functional goals
  • Engineered complex SQL and PL/SQL rules for military contracts, optimizing database queries and enhancing OnePL system performance
  • Delivered crucial L2 and L3 support of OnePL, ensuring continuous operation and scalability of OnePL system for military contract management
  • Analyzed existing SQL queries to identify opportunities for improvements
  • Optimized server resource usage by monitoring performance metrics and making necessary adjustments to SQL Server configuration
  • Automated routine maintenance tasks through scripting, freeing up valuable time for higher-priority projects
  • Developed generalized rules for OnePL military contracts, driving substantial improvements in query efficiency and adaptability across platforms
  • Streamlined database queries, leading to measurable improvements in system response time and elevated user satisfaction for OnePL platform
  • Fostered cross-functional teamwork, aligning SQL development with business needs to deliver tailored solutions for military contract management

Lead SQL Developer

Royal Caribbean Inc. / Capgemini Contractor
11.2021 - 01.2022
  • Led SQL query optimization, cutting execution time and boosting system efficiency
  • Resolved complex issues in L2/L3 support, reducing downtime and improving stability
  • Enhanced database architecture, ensuring data integrity and security
  • Mentored junior developers, improving team performance and collaboration
  • Aligned database strategies with business goals, fostering cross-functional teamwork
  • Led L2 and L3 sustainment initiatives, resolving intricate issues and minimizing downtime
  • Fostered interdepartmental collaboration, aligning database strategies with business objectives
  • Mentored junior developers, enhancing team performance, security
  • Implemented comprehensive documentation practices, ensuring sustainable development processes
  • Refined database architecture, bolstering data integrity and security
  • Analyzed existing SQL queries to identify opportunities for improvements
  • Automated routine maintenance tasks through scripting, freeing up valuable time for higher-priority projects
  • Maintained complex T-SQL queries, views, and stored procedures in multi-database environment with little supervision

Tech Lead

GE Aviation / Capgemini Contractor
07.2016 - 10.2021
  • Enhanced aviation software enhancements, streamlining L2/L3 support processes to minimize system downtime and boost operational efficiency
  • Cultivated cross-functional knowledge sharing, mentoring teams to foster collaboration and expertise across diverse aviation software platforms
  • Led transformative improvements in critical systems, maintaining rigorous code quality standards and driving long-term operational excellence in aviation software
  • Optimized support processes for mission-critical systems, minimizing downtime and boosting operational efficiency across aviation platforms
  • Strategically aligned software solutions with evolving industry needs, ensuring cutting edge capabilities while upholding stringent code quality benchmarks
  • Comprehensive documentation develops to facilitate knowledge sharing among team members and support long-term maintenance efforts
  • Established coding standards to ensure consistent quality across the development team's output

Tech Lead

GE Aviation / IGate Contractor
Cincinnati, OH
12.2014 - 07.2016
  • Engineered advanced SQL solutions, elevating data visibility and decision-making processes, resulting in substantial improvements in data quality and operational efficiency
  • Led optimization of data workflows, significantly boosting data integrity and alignment with industry standards, resulting in enhanced operational efficiency
  • Developed SQL control systems, driving measurable improvements in data quality and streamlining decision-making processes organization-wide
  • Guided team efforts in resolving complex system issues, fostering a culture of collaboration and continuous improvement among technical staff
  • Mentored and guided team members, elevating their technical capabilities and driving substantial productivity improvements across projects
  • Spearheaded team efforts in troubleshooting complex system issues, fostering a culture of collaboration and continuous improvement
  • Comprehensive documentation develops to facilitate knowledge sharing among team members and support long-term maintenance efforts
  • Established coding standards to ensure consistent quality across the development team's output
  • Reduced system downtime with initiative-taking monitoring, timely troubleshooting, and efficient issue resolution

Sr. Software Developer

LexisNexis / R Dorsey Pics Contractor
Springboro, OH
02.2012 - 12.2014
  • Pioneered ADF Task Flow enhancements, transforming application performance and user experience while leading UI/UX advancements with 15+ JSF pages
  • Developed JSF and JSP pages using CSS, integrating ADF components for seamless functionality
  • Refined ADF components for optimal integration, boosting Customer Admin application efficiency
  • Accelerated feature development, reducing time-to-market for Customer Admin application updates
  • Aligned development with business goals, delivering impactful solutions through cross-functional collaboration
  • Streamlined feature development cycles, drastically reducing time-to-market for Customer Admin application updates and driving business values
  • Monitored ongoing operation of assigned programs and responded to problems by diagnosing and correcting logic and coding errors
  • Trained new developers and programmers on company standards for design and review

Sr. Software Developer

Cardinal Healthcare / Quick Solutions Contractor
Dublin, OH
12.2011 - 02.2012
  • Developed and supported Java-based security systems, leveraging J2EE, JSP, Struts, and Hibernate
  • Implemented Websphere applications to enhance user authentication processes
  • Spearheaded transition from legacy systems to Websphere applications and proxies, improving efficiency and user experience for EA Admin and CM platforms
  • Utilized Java, J2EE, JSP, Struts, and Hibernate for robust application development
  • Ensured seamless integration and validation of user sign-on, reducing security risks
  • Achieved measurable improvements in system performance and reliability
  • Ensured robust functionality and seamless integration with neighboring complex Java business logic and EJBs using Eclipse IDE
  • Optimized user sign-on validation processes, significantly enhancing system security and reducing unauthorized access incidents for Cardinal Health platforms
  • Monitored ongoing operation of assigned programs and responded to problems by diagnosing and correcting logic and coding errors
  • Trained new developers and programmers on company standards for design and review

Sr. Software Developer

Nationwide Insurance / Quick Solutions Contractor
Dublin, OH
03.2010 - 12.2011
  • Developed and optimized SQL and PL/SQL scripts for DCI Direct and Roloams systems, enhancing data operations efficiency, and system performance
  • Ensured seamless Java to EJB integration in Eclipse, improving system reliability
  • Leveraged MQ Series to establish robust data transfer between web servers and mainframe, ensuring data integrity and cross-platform communication
  • Implemented Hibernate for improved database mapping, significantly enhancing data persistence and retrieval processes in critical systems
  • Streamlined database updates with Groovy and Java, enhancing system performance
  • Integrated Groovy with Java to create dynamic SQL scripts, streamlining database updates and inserts, resulting in substantial performance gains
  • Maintained business logic implementation with WebSphere, strengthening and fine-tuned EJBs in Eclipse IDE and overall system reliability
  • Monitored ongoing operation of assigned programs and responded to problems by diagnosing and correcting logic and coding errors
  • Trained new developers and programmers on company standards for design and review

Sr. Software Developer

Honda Motor Co. / Tek Systems Contractor
Marysville, OH
03.2011 - 07.2011
  • Led eQuote System development, optimizing supplier interactions, and migrating Java code to Websphere 7.5 for enhanced efficiency.
  • Monitored ongoing operation of assigned programs and responded to problems by diagnosing and correcting logic and coding errors
  • Trained new developers and programmers on company standards for design and review
  • Maintained Java business logic for maintenance using Eclipse IDE
  • Implemented innovative solutions for improved system performance
  • Managed critical RCM System backup, ensuring seamless operations
  • Utilized Java, J2EE, JSP, Struts, MQ Series, and Hibernate for robust functionality
  • Achieved measurable improvements in handling quotes for parts and payments
  • Partnered with cross-functional teams to streamline quote processing for parts, tooling, and supplier payments, fostering efficient workflows
  • Leveraged expertise in WebSphere and COBOL to ensure optimal performance and reliability and upgraded Java-based systems, leveraging supported and validated Java and COBOL

Software Developer III

Northrop Grumman
Beavercreek, OH
04.2008 - 04.2009
  • Led development of CFO Reporting System in IBM Websphere using Java, enhancing data accuracy
  • Created comprehensive reports for CFO using Crystal Reports, improving financial decision-making
  • Managed Java business logic and EJBs in Eclipse, ensuring system reliability and performance
  • Utilized complex SQL queries for Oracle databases, optimizing data retrieval processes
  • Supported AFEMS, maintaining equipment management efficiency for US Air Force
  • Led CFO Reporting System development, implementing Java solutions in WebSphere
  • Spearheaded complex SQL queries for Oracle databases, enhancing data retrieval efficiency
  • Improved depreciation management for US Air Force assets, revolutionizing financial tracking
  • Developed Crystal Reports for CFO balancing, improving fiscal transparency
  • Maintained Air Force Equipment Management System, ensuring seamless operations
  • Integrated MQ Series for efficient data transfer between web servers and mainframe
  • Crafted comprehensive business user cases for CFO Reporting System
  • Documented CFO procedures meticulously, facilitating smooth knowledge transfer and process consistency
  • Leveraged expertise in Java, Pacbase, and Struts to drive cross-functional projects
  • Maintained EJBs in Eclipse IDE, fostering collaborative development environment
  • Improved software efficiency by troubleshooting and resolving coding issues
  • Enhanced user experience through designing and implementing user-friendly interfaces

Software Developer III

Lockheed Martin
Fairborn, OH
03.2002 - 03.2008
  • ed development of CFO Reporting System in IBM Websphere using Java, enhancing data accuracy
  • Created comprehensive reports for CFO using Crystal Reports, improving financial decision-making
  • Managed Java business logic and EJBs in Eclipse, ensuring system reliability and performance
  • Utilized complex SQL queries for Oracle databases, optimizing data retrieval processes
  • Supported AFEMS, maintaining equipment management efficiency for US Air Force
  • Led CFO Reporting System development, implementing Java solutions in WebSphere
  • Spearheaded complex SQL queries for Oracle databases, enhancing data retrieval efficiency
  • Improved depreciation management for US Air Force assets, revolutionizing financial tracking
  • Developed Crystal Reports for CFO balancing, improving fiscal transparency
  • Maintained Air Force Equipment Management System, ensuring seamless operations
  • Integrated MQ Series for efficient data transfer between web servers and mainframe
  • Crafted comprehensive business user cases for CFO Reporting System
  • Documented CFO procedures meticulously, facilitating smooth knowledge transfer and process consistency
  • Leveraged expertise in Java, Pacbase, and Struts to drive cross-functional projects
  • Maintained EJBs in Eclipse IDE, fostering collaborative development environment
  • Improved software efficiency by troubleshooting and resolving coding issues.
  • Enhanced user experience through designing and implementing user-friendly interfaces

Software Developer III

Lockheed Martin
Fairborn, OH
03.2002 - 03.2008
  • Led development of CFO Reporting System in IBM Websphere using Java, enhancing data accuracy
  • Created comprehensive reports for CFO using Crystal Reports, improving financial decision-making
  • Managed Java business logic and EJBs in Eclipse, ensuring system reliability and performance
  • Utilized complex SQL queries for Oracle databases, optimizing data retrieval processes
  • Supported AFEMS, maintaining equipment management efficiency for U.S Air Force
  • Led CFO Reporting System development, implementing Java solutions in WebSphere
  • Spearheaded complex SQL queries for Oracle databases, enhancing data retrieval efficiency
  • Improved depreciation management for US Air Force assets, revolutionizing financial tracking
  • Developed Crystal Reports for CFO balancing, improving fiscal transparency
  • Maintained Air Force Equipment Management System, ensuring seamless operations
  • Integrated MQ Series for efficient data transfer between web servers and mainframe
  • Crafted comprehensive business user cases for CFO Reporting System
  • Documented CFO procedures meticulously, facilitating smooth knowledge transfer and process consistency
  • Leveraged expertise in Java, Pacbase, and Struts to drive cross-functional projects
  • Maintained EJBs in Eclipse IDE, fostering collaborative development environment
  • Improved software efficiency by troubleshooting and resolving coding issues
  • Enhanced user experience through designing and implementing user-friendly interfaces

Software Developer Associate

Lockheed Martin
Fairborn, OH
03.1999 - 03.2002
  • Supported technical lead in software system development for Air Force projects
  • Enhanced AFEMS system, improving functionality and user experience
  • Developed and analyzed deployment applications, optimizing processes
  • Implemented and tested backup procedures, ensuring data integrity
  • Authored user manuals, ensuring clarity and accessibility
  • Developed and analyzed equipment deployment application, enhancing Air Force logistics efficiency, and reducing operational downtime
  • Pioneered new backup procedures for online help files, improving system reliability and reducing data loss risks
  • Partnered with Technical Lead to maintain and evolve critical Air Force software systems, ensuring optimal performance and functionality
  • Meticulously updated user and maintenance manuals, facilitating seamless system operation and troubleshooting for end-users
  • Leveraged Pacbase programming to modify existing AFEMS system, delivering tangible improvements in system efficiency and user experience
  • Improved software efficiency by troubleshooting and resolving coding issues
  • Enhanced user experience through designing and implementing user-friendly interfaces

Programmer Analyst

Lockheed Martin
Fairborn, OH
11.1998 - 02.1999
  • Enhanced AFEMS systems for improved functionality and reliability
  • Developed and analyzed equipment deployment application, enhancing operational efficiency
  • Implemented robust backup procedures, ensuring data integrity and system reliability
  • Authored and updated user manuals, ensuring clarity and usability
  • Assessed backup procedures, enhancing data security and integrity
  • Pioneered new macros and programming techniques in Pacbase, streamlining development processes and reducing code redundancy for AFEMS system
  • Meticulously maintained and updated user and maintenance manuals, ensuring comprehensive documentation for system modifications and new features
  • Refined existing AFEMS system, leading to improved performance and user satisfaction
  • Implemented efficient, redevelopment applications for enhanced resource allocation

Consultant

Compuware
Cincinnati, OH
10.1998 - 10.1998
  • Guided Choice Care in mastering QAcenter tools, enhancing software testing efficiency
  • Mentored teams on PowerBuilder, fostering improved application development capabilities
  • Facilitated training on Hyper Station, boosting team ability in network management
  • Mentored and trained Choice Care staff on QAcenter suite, enhancing team proficiency in QARun, QADirector, Load, and Track tools
  • Developed and implemented comprehensive training programs for PowerBuilder and Hyper Station, driving adoption of cutting-edge technologies
  • Analyzed training needs, tailored programs to individual learning styles, ensuring optimal skill acquisition across diverse teams
  • Conducted regular reviews of operations and identified areas for improvement
  • Consult with customers, management, and sales team to better understand customer needs and recommend appropriate solutions

Programmer

Ohio Casualty
Hamilton, OH
01.1997 - 01.1998
  • Developed online billing system, enhancing agency efficiency
  • Analyzed and improved commission reporting processes
  • Converted action memos to digital, streamlining operations
  • Resolved batch JCL issues, ensuring system reliability
  • Developed and analyzed online licensing billing system, enhancing agency operations, and streamlining processes for improved efficiency and accuracy
  • Contributed to unit testing of licensing billing system, ensuring robust functionality and seamless integration with existing agency infrastructure
  • Resolved batch JCL issues in agency system, minimizing downtime and improving overall system performance for enhanced productivity
  • Utilized COBOL, CICS, and SQL to support and modify existing systems, ensuring continued reliability and adaptability to evolving business needs
  • Worked with software development and testing team members to design and develop robust solutions to meet client requirements for functionality, scalability, and performance
  • Reduced system errors and improved reliability, through rigorous debugging processes

Education

Associate degree - Computer Programming

RETS TECH CENTER
Centerville, OH
09.1996

Skills

  • Java Programming
  • Java EE Development
  • HTML Development Skills
  • XML Schema Development
  • Full-Stack Application Deployment
  • SOAP Framework
  • RESTful API Development
  • PL/SQL Development
  • SQL Data Analysis
  • SQL Report Generation
  • Database Migration Expertise
  • Data Backup Management
  • T-SQL Query Development
  • Experience with NoSQL Solutions
  • C# Programming
  • MQ Series Management
  • COBOL Development Expertise
  • Job Control Language Proficiency
  • Proficient in Pacbase
  • CICS Application Management
  • Python Development
  • Hibernate ORM Experience
  • Data Structure Design
  • Object-Oriented Programming
  • Diagnostic Analysis
  • JavaScript Programming
  • User Interface Design
  • User Interface Lifecycle Oversight
  • Version Control Management
  • Agile Process Implementation

Timeline

Lead SQL Developer

Boeing / Capgemini Contractor
01.2022 - 01.2023

Lead SQL Developer

Royal Caribbean Inc. / Capgemini Contractor
11.2021 - 01.2022

Tech Lead

GE Aviation / Capgemini Contractor
07.2016 - 10.2021

Tech Lead

GE Aviation / IGate Contractor
12.2014 - 07.2016

Sr. Software Developer

LexisNexis / R Dorsey Pics Contractor
02.2012 - 12.2014

Sr. Software Developer

Cardinal Healthcare / Quick Solutions Contractor
12.2011 - 02.2012

Sr. Software Developer

Honda Motor Co. / Tek Systems Contractor
03.2011 - 07.2011

Sr. Software Developer

Nationwide Insurance / Quick Solutions Contractor
03.2010 - 12.2011

Software Developer III

Northrop Grumman
04.2008 - 04.2009

Software Developer III

Lockheed Martin
03.2002 - 03.2008

Software Developer III

Lockheed Martin
03.2002 - 03.2008

Software Developer Associate

Lockheed Martin
03.1999 - 03.2002

Programmer Analyst

Lockheed Martin
11.1998 - 02.1999

Consultant

Compuware
10.1998 - 10.1998

Programmer

Ohio Casualty
01.1997 - 01.1998

Associate degree - Computer Programming

RETS TECH CENTER
Douglas Fullen