TECHNICAL SKILLS:

Languages: SQL (and variants T - SQL, PL/SQL), Java, some C#

Operating Systems: Microsoft Windows, Ubuntu, RedHat Linux, Mac OS/X

Scripting Languages: Unix shell (bash, csh, ksh/korn)

Platforms: LAMP (Linux, Apache, MySQL, PHP)

Cloud computing: AWS, Microsoft Azure, Google Cloud Services, Digital Ocean

Databases: Oracle 11g, 12c, SQL Server 2012, MySQL

Tools: Alteryx, Tableau, Toad, SQL*Plus, SQL*Loader, Autosys

Virtualization: VirtualBox, VMware ESXi

Version Control Systems: Git, CVS

Reporting: Tableau, Alteryx, Microsoft SQL Server Reporting Services (SSRS)

Content Management Systems: WordPress

PROFESSIONAL EXPERIENCE:

Confidential

Software Developer

Responsibilities:

• Created new and updated PL/SQL packages, procedures, functions, tables, views, scheduled jobs, and indexes, based on client requirements
• Created a proof of concept to move on-premises UNIX servers and Oracle databases to AWS EC2 and Amazon RDS for Oracle
• Created Alteryx workflows to extract, cleanse, and/or blend data from Cosmos DB, SQL Server, and/or Oracle databases, which then fed into Tableau reports
• Created Tableau dashboards and reports to visualize data for various operations
• Ensured the smooth operation and upgraded Sabre AirVision Revenue Manager and AirVision Fare Manager
• Created Azure data factories and Azure functions to extract, modify, and insert data into Cosmos DB, Azure SQL Server, an on-site Oracle database, and Azure Blob Storage
• Created UNIX shell scripts to send extracted data from UNIX application server to Azure Blob Storage
• Created UNIX shell scripts to integrate with the Azure deployment pipeline for continuous integration and deployment
• Created process for business users to upload data into Sabre AirVision Revenue Manager tables and fire off the Automated Seasonality Tool (AST) on demand
• Assisted in merging Virgin America Revenue Manager data into Confidential Revenue Manager system
• Assisted in the creation and deployment of an airport lounge admission app on iOS
• Create, update, maintain, and monitor Autosys jobs

Confidential

PL/SQL Developer

Responsibilities:

• Created new and updated PL/SQL packages, procedures, functions, tables, views, scheduled jobs, and indexes, based on client requirements
• Created Java packages to connect and extract data from Teradata databases
• Created PL/SQL packages for pruning airplane BOMs of non-metallic product, and product information for export to Oracle Agile PLM
• Created PL/SQL packages for extracting data from other databases using database links for import into SAP
• Created ad hoc reports as needed by the business
• Created and maintained user interface deployed on JBoss/Wildfly, utilizing JSP, jQuery and CSS for user interface, JasperReports for reporting purposes, and Java for database queries and data manipulation
• Modeled new SAP implementation with existing systems using Rational Software Architect
• Co-ordinated quarterly raw material forecast run - verifying all supplier information has been entered and validated; data from financial and delivery schedule databases have been exported and loaded into raw material database, executing Oracle packages for the forecast run, and extracting forecast data for the supplier management group
• On-boarded new Boeing employees and consultants to the forecasting group and the forecasting process

Confidential

Software Engineer

Responsibilities:

• Created interface with truck load management system and their WMS through XML and flat file data exchange
• On-site implementation support of automated storage system during go-live
• Determined root causes to problems in the WMS, proposed solutions, and implemented fixes to bugs in various Oracle packages
• Documented various customized sub-systems for several client sites
• Tested bug fixes before rollout onto customer’s production systems

Confidential

PL/SQL Developer Consultant

Responsibilities:

• Primary technical point of contact for implementing and supporting the real-time encryption of personal sensitive information in an Oracle database using SafeNet DataSecure (previously known as Ingrian DataSecure)
• Created and modified Oracle PL/SQL packages and UNIX korn shell scripts to create new functionality for Commercial Master Billing account system
• Assisted in the automation of customer loyalty system through the use of Autosys, re-writing of UNIX shell scripts, and new PL/SQL packages
• Designed and created specifications for user interface of sales tax rebate application for hand off to other programming consultants

Confidential

Volunteer IT Consultant

Responsibilities:

• Developed, implemented, and supported organization’s website and intranet using DotNetNuke, Drupal and WordPress
• Created new Drupal and WordPress themes
• Primary lead for developing, implementing and maintaining the wired and wireless network infrastructure in the organization’s new office
• Created and maintained Windows domain to control network logons, and implement and control computer and group policies for all computers
• Created automated application installation scripts using logon scripts, and domain and group policies
• Recommended and implemented new hardware or software based solutions for the organization to reduce costs, and maintenance calls
• Implemented and trained staff on using SalesForce.com to manage contact information for students, volunteers, and donors
• Customized SalesForce.com to meet the organization’s needs by creating and customizing new input fields, reports, and forms
• Primary responsibility for user and security administration of SalesForce.com
• Created and updated detailed documentation of the entire IT network infrastructure from design to workstation installation and maintenance
• Maintained a pro-active and aggressive approach to security threats such as spyware, worms, trojan horses, viruses, and unauthorized changes to the entire network, thus, significantly reducing the organization’s prior problems to these threats
• Occasionally taught classes in Microsoft Word or Excel
• Created VMware Workstation environment to test changes to domain controller and workstations
• Provided pro-bono IT support and service for volunteers, staff, and students
• Advised and assisted in updating the organization’s educational curriculum

Confidential

Application Programming Specialist

Responsibilities:

• Created new and modified existing EDI interfaces between the WMS and PeopleSoft using Visual Basic
• Determined root cause of problems in the WMS and created SQL scripts and PL/SQL procedures to correct problematic data
• Primary code reviewer and mentor for Oracle PL/SQL scripts, procedures, functions, and packages
• Updated and created new Unix korn shell scripts for batch processing, backups and patches to the WMS
• Mentored new colleagues and interns Unix korn shell scripting and Unix internals
• Lead team in creating and implementing standards for PL/SQL and T-SQL scripts
• Created and implemented standards for documentation, and test procedures for other IT teams within the department
• Technical point of contact for converting existing Crystal Reports 8.5 to Microsoft SQL Server Reporting Service (SSRS) Reports
• Creating and maintaining a wiki based knowledge base for information regarding the WMS and its interaction with other systems
• Mentored and managed new hires and interns for their success in maintaining WMS
• Worked with and mentored colleagues in both PL/SQL and T-SQL code optimization for other applications within the department