C

Craig Willcox

About

Detail

California, United States

Timeline

work
Job
school
Education

Résumé

Jobs verified_user 0% verified
  • Peraton
    Software Development/Senior Associate
    Peraton
    Jan 2023 - Feb 2024 (1 year 2 months)
    Developed and maintained database objects for the Data Migration project at Oregon Health Authority. Created ETL procedures in PL/SQL to efficiently extract and load data into new table structures. Refactored existing database objects to enhance application performance and support new features. Skills: Oracle, PL/SQL, JIRA, Toad, JSON, SQL Developer, Team Foundation Service (TFS)
  • K
    Data Entry Specialist
    Kenlore Inc
    Sep 2018 - Aug 2021 (3 years)
    • Performed routine data entry into Excel spreadsheets to track and log completed tasks. • Assisted with general administrative tasks including documentation, photocopying, and digital file management. • Generated and distributed reports using SQL queries to support internal stakeholders. • Maintained high levels of accuracy and attention to detail in all entries.
  • A
    Data Analyst
    AWS Elemental
    Dec 2016 - Jan 2017 (2 months)
    • Reviewed, cleaned, and prepared large datasets in Excel for upload. • Identified and corrected duplicate or erroneous entries, ensuring clean data flow. • Uploaded validated client data into proprietary systems for video streaming services.
  • Providence Health & Services
    Membership Enrollment Specialist
    Providence Health & Services
    Sep 2016 - Oct 2016 (2 months)
    • Entered and validated Medicare enrollment data using FACETS system. • Resolved discrepancies in applications and assisted members with re-enrollment. • Maintained compliance with organizational and HIPAA standards.
  • Iron Mountain
    Data Entry Technician
    Iron Mountain
    Jun 2016 - Jul 2016 (2 months)
    • Scanned, categorized, and filed large volumes of confidential medical records. • Utilized Microsoft Excel for tracking file status and managing entry logs. • Troubleshot data import/export issues between Microsoft Office applications.
  • D
    Database Developer
    Apr 2016 - Jan 2017 (10 months)
    Defined application requirements for the Las Vegas gaming user survey, ensuring alignment with business objectives. Interpreted complex business logic to develop efficient dataflow and dependencies, enhancing data integrity. Modeled and designed a robust application database, optimizing performance and scalability. Developed advanced SQL programming, functions, and procedures, streamlining software operations and improving user experience. Skills: PL/SQL, SQL, Microsoft Excel, Microsoft Access, Microsoft SQL Server, Oracle Explain Plan (OEP), Data Modeling
  • S
    Software/Database Developer
    Jun 2015 - Aug 2015 (3 months)
    In my role at AUTOSKED, I contributed to the development of an automotive maintenance and repair application. I designed a new menu interface and created efficient database stored procedures, significantly improving application performance and user engagement. My work involved utilizing PHP, HTML5, CSS, and MySQL in a collaborative environment, which enhanced my technical skills and project management abilities. Skills: PHP4/5, HTML5, CSS, MySQL, SQL, Apache
  • D
    Database Developer
    Nov 2012 - Oct 2013 (1 year)
    Evaluated Oracle Application Express (APEX) applications for auto maintenance, enhancing functionality and performance. Reviewed stored procedures, forms, and tables to identify optimization opportunities, leading to improved efficiency. Provided strategic recommendations for porting applications to modern platforms, including HTML5, PHP, and JavaScript. Delivered accurate time estimates to clients, ensuring transparency and effective project management. Skills: Oracle 11g, PL/SQL, MySQL, PHP, HTML, TKPROF, Apache, CSS, Oracle Explain Plan (OEP)
  • D
    Database Developer
    Jan 2010 - May 2012 (2 years 5 months)
    Maintained and enhanced a web store application for adaptive office equipment sales, ensuring optimal performance and user experience. Executed modifications in PHP, HTML, and JavaScript to improve functionality and responsiveness. Developed and optimized stored procedures and triggers in MySQL, enhancing database efficiency and data integrity. Skills: PHP, MySQL, SQL, JavaScript, CSS, Apache
  • D
    Database Developer
    Jan 2008 - Apr 2010 (2 years 4 months)
    I successfully developed an innovative logistics application that streamlined customs processes and enhanced user experience. Leveraged Oracle E-Business Suite to create a robust solution encompassing CRM, GL, AR, AP, SCM, and ERP functionalities. Enhanced data processing through the creation of efficient T-SQL queries and stored procedures, improving system performance. Collaborated with diverse teams to ensure seamless integration and user adoption, leading to increased operational efficiency. Skills: Oracle, T-SQL, PL/SQL, SQL*Plus, Oracle Forms, ADO.NET, OLE DB, ODBC, JSON, Oracle Reports TKPROF, Microsoft SQL Server, Oracle Application Server, Oracle E-Business Suite (Oracle EBS) Oracle Explain Plan (OEP)
  • S
    Senior Development Analyst
    Aug 2007 - Jan 2008 (6 months)
    Customized applications to meet specific departmental needs, enhancing operational efficiency. Developed ad-hoc queries to support data-driven decision-making processes. Conducted thorough test planning and unit testing for T-SQL and Oracle SQL queries, ensuring high-quality deliverables. Skills: Oracle 10g, SQL*Plus, T-SQL, Jet SQL, MS Access, Visual Basic, FoxPro, Crystal Reports, ADO.NET OLE DB, ODBC, Oracle SQL*Loader, Microsoft SQL Server, Visual Basic for Applications (VBA) SQL Server Integration Services (SSIS), Oracle Explain Plan (OEP), TKPROF
  • P
    Programmer Analyst
    Jan 2007 - Jun 2007 (6 months)
    Developed and maintained the Retirement Savings Center web application, enhancing user experience and accessibility. Executed ETL processes to migrate data from SQL Server to Oracle Data Warehouse, ensuring data integrity and efficiency. Utilized T-SQL and Oracle SQL to create complex queries and stored procedures, optimizing performance and reporting capabilities. Skills: Oracle 10g, SQL Server, PL/SQL, XML, SOAP, ADO.NET, OLE DB, ODBC, Visual Basic.NET Oracle SQL*Loader, SQL Server Integration Services (SSIS), Oracle Explain Plan (OEP)
  • Wells Fargo
    Programmer Analyst
    Wells Fargo
    Jul 2006 - Dec 2006 (6 months)
    Developed comprehensive reports for international direct deposit accounts, enhancing data visibility and decision-making. Modified the Customer Contact web application to improve user experience and streamline operations. Utilized Oracle 10g, PL/SQL, and Visual Basic .NET to deliver high-quality software solutions. Collaborated with cross-functional teams at Wells Fargo in Portland, Oregon, to drive project success. Skills: Oracle 10g, PL/SQL, SQL*Plus, Visual Basic.NET, Crystal Reports
  • U
    Senior Programmer Analyst/DBA
    UPS Supplychain Solutions
    Dec 2004 - Jul 2006 (1 year 8 months)
    In my role, I was responsible for leading application development and database maintenance, focusing on optimizing performance and ensuring seamless operations. I organized a steering committee to upgrade our shipping application, which significantly improved our logistics efficiency. Additionally, I implemented robust ETL processes that enhanced data mapping and architecture design, contributing to better decision-making across the organization. Skills: Oracle, Oracle PL/SQL, Oracle SQL*Plus, Oracle Warehouse Builder (OWB), Oracle SQL*Loader Oracle Discoverer, Oracle Applications Express (APEX), Oracle Designer, Oracle Forms & Reports Oracle SQL Developer, Oracle Explain Plan (OEP), Oracle SQLDBA, SQL Server, Transact SQL (T-SQL) SQL S
  • Menlo Worldwide
    Senior Systems Engineer
    Menlo Worldwide
    Apr 2001 - Dec 2004 (3 years 9 months)
    In my role at Menlo Worldwide Forwarding, I was instrumental in leading application development and support initiatives. I successfully managed the migration of legacy systems to modern platforms, significantly enhancing system performance and reliability. My expertise in database development and data modeling allowed optimized data workflows, contributing to improved decision-making processes. Skills: Oracle, SQL Server, SQL*Plus, PL/SQL, ADO.NET, OLE DB, ODBC, SQL Developer, Quest Toad Crystal Reports, Oracle Designer, Transact SQL (T-SQL), Oracle Forms & Reports, SQL Server Integration Services (SSIS) Oracle SQL*Loader, Oracle Applications Express (APEX), SQL Server Reporting Services (SSRS) Oracle Discoverer
  • E
    Senior Programmer Analyst
    EMERY WORLDWIDE
    Sep 1997 - Mar 2001 (3 years 7 months)
    Provided comprehensive user support for the Ocean Shipment & Tracking System, enhancing operational efficiency. Developed and maintained MS Exchange Forms, streamlining communication processes within the organization. Administered SCO UNIX systems and Oracle databases, ensuring optimal performance and reliability. Utilized Oracle 6i, PL/SQL, and Visual Basic 6 to create robust applications, contributing to a 20% reduction in processing time. Skills: Oracle, SQL*Plus, Oracle Forms, Oracle Reports, PL/SQL, SQL*Reports 1.0, Oracle SQLDBA, Visual Basic 6 Crystal Reports, SCO UNIX, ADO.NET, ODBC, OLE DB, Microsoft Exchange Forms Designer
Education verified_user 0% verified
  • Portland Community College
    Computer Information Systems (CIS)
    Portland Community College
    Jan 2010 - Jun 2011 (1 year 6 months)