John Oconnor - Senior Designer Resume Simple
Having over 10 years of experience in the IT industry as a SQL developer and software developer. Experienced in all phases of the system development life cycle (SDLC) including requirements gathering, analysis, design, development, testing, implementation and maintenance.
  • automation, oracle, dbms, server, toad, cold fusion, technology, crystal reports, dreamweaver, sql server, sql, reporting, reports, training, design, data warehouse, oracle database, pl sql, security, access, telecom, database, web
  • data analysis, project, oracle, analysis, visual basic, basic, crystal reports, collection, compensation, reporting, sql, dreamweaver, crystal report, excel, apache, inventory, reports, ms excel, web, installation, pl sql, file, access, ms access, data collection, database
  • 2017-12-252017-12-25

    Senior Designer

    Officer Candidate School

    • Developed and maintained the web-based reporting system using Crystal reports, SQL Server database, and Unix/Linux and the project documentation.
    • Developed and implemented ETL processes using PL/SQL to perform database maintenance and data validation. Also, created and maintained documentation for the testing of the application.
    • Worked with the QA team to design and develop a new data warehouse for the inventory of the company. IT was a Linux based system.
    • Worked on the migration of the Lotus notes application to the new intranet and the Oracle database. This was a system of the company.
    • Managed the development of a new intranet application for the company. Created a database for the access control system.
    • Developed and maintained documentation for the web-based application and the infrastructure for the company. I also worked with the QA team to ensure the coding standards are met.
  • 2017-12-252017-12-25

    Database Development Consultant/Application Development Lead

    Port of Subs

    • Created and maintained a Crystal reports for the company. The project was used to generate Excel spreadsheets, and access database using MS Word.
    • Designed and implemented a new database system using Crystal reports, XML, and Excel spreadsheets. Developed and maintained the data entry and reporting.
    • Used Crystal reports to generate Excel file, and create the report Builder, validation, and access control. Created and modified the existing XML schema.
    • Created and maintained a data entry system for the company to generate reports for the clients using Crystal reports, Excel, and Word.
    • Worked on XML and Excel to create and maintain the data entry and validation. This includes the creation of new tables, views, materialized views, and inventory.
    • Designed and developed the Crystal reports using Visual basic and SQL Server database. Wrote complex queries for data manipulation and analysis.

 Image Mentor