Create, maintain and update scripts to alter data in an aircraft maintenance, repair and overhaul Oracle 19 database using TOAD 17 IDE.Promote scripts to be deployed in QA, Test and production environments through DBAs using RTDs.Automate reports for data quality using TOAD’s Automation Designer and batch scripts.Gather requirements and develop project plans for new scripts or modifications to existing scripts.Use of JIRA for creation and tracking of stories, epics and bugfixes.Utilize SourceTree with git for source control.Use BitBucket for peer code review.Coordinate with various sites/stakeholders on new releases prior to deployment.Document releases and procedures utilizing Confluence.Connect to various Oracle databases through VMWare virtual machines, VDI and NCMI and DISA secured VPNs.

Create, maintain and update scripts to alter data in an aircraft maintenance, repair and overhaul Oracle 12 database using TOAD 13 IDE.Promote scripts to be deployed in QA, Test and production environments through DBAs using SharePoint.Automate reports for data quality using TOAD’s Automation Designer and batch scripts.Gather requirements and develop project plans for new scripts or modifications to existing scripts.Use of JIRA for creation and tracking of stories, epics and bugfixes.Utilize SourceTree with git for source control.Coordinate with various sites/stakeholders on new releases prior to deployment.Document releases and procedures utilizing Confluence.Connect to various Oracle databases through VMWare virtual machine and NCMI and DISA secured VPNs.

Created, maintained and updated reports/KPIs in an Executive Dashboard reporting system using LogiAnalytics.JavaScript and .css used in formatting and enhancing the processes of the Executive Information System.Used the SDLC process to ensure prompt completion of projects with minimal conflict.Administered security profiles and user access to ensure sensitive data is viewable by the appropriate users.Maintained and updated a MySQL 5.7/5.8 data warehouse for the Executive dashboard system.Used SAS 9.3 to ETL EDI data from TMS/AS400 into a MySQL 5.7/5.8 data warehouse.Gathered requirements and developed project plans for new reports or modifications to existing reports.Tracked tasks and Bugfixes using JIRA.Utilized SourceTree and Stash with git for source control.Performed UAT on new releases prior to deployment.Documented releases and trained users on updated features.

Used T-SQL in MS SQL 2008 R2/2012 environment to create multiple complex stored procedures, view and functions.Published SSRS reports into SharePoint intranet sites per business requirements utilizing MS SQL 2008 R2/2012.Queried MS SQL/Oracle databases on ad-hoc basis for business using T-SQL/PL-SQL.Created SSIS packages using MS SQL 2008 R2/2012 for ETL from Oracle database into EDW.Transitioned over 50 SSRS reports to work in MS SQL 2012 PDW.Utilized MS TFS for source control.Performed UAT on new releases prior to deployment.Documented releases and trained users on updated features.Team lead for 6 developers.

Supported MS SQL 2008 database for US Navy’s Fleet Readiness Center SE training department.Managed SSIS and DTS packages for ETL to/from other military systems.Queried database on ad-hoc basis for client using T-SQL.Utilized SourceGear’s Vault for source control with remotely located programmer.Updated and enhanced database’s user guide for training department employees.

Converted Excel and Access based plant production and classification reports into MS SSRS 2008 R2.Used T-SQL in MS SQL 2008 R2 environment to create multiple complex stored procedures, view and functions.Developed dashboard reporting using Dundas Dashboard for Land Sales System.Created and maintained MS SSIS packages for plant production systems using MS SQL 2008 R2.TortoiseSVN and Redgate used as source control for procedures, reports and database updates.

Created ad-hoc reports using Crystal 8.5 and SQL Navigator connected to Oracle 10 database for internal and external clients under tight deadlines.Developed daily reports for distribution to state agencies using MS SQL 2008 SSIS packages and SFTP upload.Conversion of Crystal 8.5 reports to MS SQL 2008 SSRS for system conversion project.

Created SSRS reports for Inventory Management Planning

Updated and stabilized outgoing MS Access 2003 database prior to replacement by proprietary system.Created complex T-SQL stored procedures and views in MS SQL 2005 to support MS Access 2003 database.

Automated 53 legacy MS Access 2003 quarterly, monthly, weekly and daily reports using T-SQL stored procedures, views and functions in MS SQL 2005 and MS SSRS 2005 accessing data from AS400/DB2 mainframe or BOXI data warehouse.Updated legacy ETL DTS packages moving data from AS400/DB2 to MS SQL 2005 server through implementation of SSIS packages in MS SQL 2005.Generated and ensured accuracy of annual reporting to Texas Department of Insurance and Florida Department of Insurance including Florida Hurricane Catastrophe Fund and the company annual statement.Saved company $180,000 in FHCF refilling fees by thorough analysis, finding errors and correcting prior to next filing.Collaborated with developers, business analysts and QA testers using some Agile environment style methodologies.Provided ad-hoc reports as necessary for finance, claims and executives using T-SQL in MS Access and MS SQL 2005/2008 with MS SSRS 2005.Implemented Business Objects XI using a data warehouse in MS SQL 2005 and generated reports using Crystal Reports.Reviewed XML claims files prior to uploading into MS SQL 2005 database.Collaborated with state and financial auditors to supply data and procedures used in all reporting.Documented all projects, ensuring timely completion using SDLC techniques.

Updated Process Management software based on tickets through Serena Helpdesk.Created T-SQL scripts and stored procedures for processing database changes using MS SQL 2005.Implemented changes to MS SQL 2005 T-SQL scripts with extensive cooperation of DBAs.Used some Agile based methodologies for collaboration with teammates, DBAs and mangers to ensure timely completion of projects.Created reports for clients using Crystal Reports, Business Objects X, and MS Access 2003.

Directed vendor catalog integration with automated sourcing systems.Administered MS SQL 2000/2005 based supplier catalogs and purchase history detail.Daily use of MS SQL 2000 DTS packages for ETL within VLDB SQL and Oracle databases.Migrated existing MS SQL 2000 databases to MS SQL 2005 standards.Created ad-hoc reporting using MS Access 2000 for managers and executives.Implemented several VB.Net based automation programs.Troubleshoot and maintained existing MS Access 2000 based legacy systems.Maintained .PHP based purchasing website for a worldwide company with over 5,000 users.Coded VBA within MS Excel 2000 to develop and automate data transfer and processing for clients and customers.Used DOS scripting to modify and move files throughout the network for use in MS SQL 2000/2005 databases and .PHP and HTML based websites.Supervised completion of various sized projects using SDLC techniques.

Coordinated multiple deliveries to various locations as efficiently as possible.Interacted with customers to provide professional and prompt service.Supported daily technical needs of Windows 98/NT/XP computers/network.Queried Oracle SQL database using MS Access 97 and MS Excel 97 for reporting distribution and delivery volumes.

Coordinated multiple associates for the entire city in an efficient and timely manner.Created various databases and reports using MS Access 97 and MS SQL 2000 for tracking employee progress.Resolved customer complaints quickly while providing win-win solutions.

Utilized UML diagramming techniques and RUP for efficient and timely completion of medium sized projects for manufacturing and distribution.Developed and installed VisualBasic6 and VB.Net based front-end applications using MS Access 97 and Oracle database backend tables and T-SQL stored procedures in MS SQL 2000.Created and supported VBA applications capable of importing data from AS400/DB2 or client based sources.Automated manual FTP file transfers through applications developed in VisualBasic6.Developed and installed VisualBasic6 and VB.Net based front-end applications using SourceSafe for retrieving data from manufacturing equipment.Implemented additional VisualBasic6 and VB.Net applications utilizing schedulers for automated overnight operation of daily, weekly, monthly and specialized scheduled operations.Troubleshooting and maintenance of existing VisualBasic6 based legacy systems.Integrated existing legacy systems into new VisualBasic6 and JavaScript based applications to increase functionality and maintain user familiarity.Created and shared comprehensive user guides and troubleshooting manuals for all systems with users and peers.Automated overnight FTP transfer of generated files to HTML based intranet and internet sites with email to affiliates worldwide.

Coordinated with numerous vendors to develop, test and implement applications for single or multi user environments.Supervised completion of multiple medium sized development projects using MS Project and LotusNotes within strict deadlines.Automated MS Excel spreadsheets through the use VisualBasic6 and VBA.Created various reports for managers using Crystal Reports.Effectively communicated user's desires to developers for an effective and useful application.Automated manual downloads through applications developed in VisualBasic6.Supported and adapted various systems to end-users needs while maintaining daily functions.Created and implemented training for incoming associates to perform various current and prospective job functions.Compacted, repaired and normalized Access databases proactively to prevent system outages.Researched, tested and reported on new UNIX based software applications prior to implementation.Streamlined of current procedures through extensive automation and creative concepts realizing cost savings to the business.Maximized all supported systems strengths while overcoming weaknesses.

Automated a daily 50-page report using VisualBasic5 and UNIX based applications for multiple managers including several Vice Presidents.Analyzed daily incoming call volumes for forecasting necessary staffing requirements using applications developed with VB5.Created ad-hoc reports on daily call volumes and staffing needs using PowerBuilder.Implemented training for incoming associates to perform various current and prospective job functions.