Software Engineer Resume
Cheshire, CT
SUMMARY
Software Engineer specializing in Java and SQL but able to work on any aspect of a complex software solution from database design and querying, to support systems such as web servers and mail servers, all the way to GUI design and development both in the web and natively.
TECHNICAL SKILLS
Primary Language: Java especially Java Web; i.e. JSPs, Servlets, some command line scripting.
Databases: Extremely proficient with SQL development. Able to write very complex queries for data retrieval, spot opportunities for performance optimization in both SQL queries and database design itself, i.e. indexing and table relationships. Able to design normalized databases from scratch for good performance and data integrity.
Traditional Web Development: HTML, CSS, Javascript, JQuery, JQuery plugins such as JQueryMobile, DataTables, JqueryUI.
Linux System Administration: Perl, Bash, Expect, Crontab scheduling, networking
Windows Development: C#.NET, VB.NET, Microsoft Visual Foxpro
Mobile Development: Some Objective - C, some Android development(Java).
Database: PostgreSQL, Microsoft SQL Server
Platforms: Linux(OpenSuse typically), Windows, Mac OSX
Source Control: Github
Project Management: Jira, OnTime
PROFESSIONAL EXPERIENCE
Software Engineer
Confidential, Cheshire CT
Responsibilities:
- Converted simple ASP web application to Java Web Client running on Apache Tomcat. Advanced web applications to a point where the Windows front-end could be retired, greatly simplifying development and software releases. All front end clients for our system are now sites I developed using primarily Java.
- Combined Apache proxy and Tomcat web server to create a two-host cluster for load sharing and redundancy using sticky sessions and session sharing.
- Designed and implemented new tables, queries and views within highly complex PostgreSQL database supporting the telemetry system.
- Often called upon to create very complex queries for data retrieval both as dynamic SQL within the websites and as stored procedures within our database.
- Have spotted fixed numerous bugs in existing SQL code as well as implemented optimizations to improve query performance such as indexing and rewriting queries.
- Completed and deployed scripting to enable automated failover between master database and slave in the case of a network outage.
- Completed and deployed scripting to automatically add or remove replicated slave databases from read-query load sharing based on replication lag time using a combination of Slony, Bash, and Expect scripting
- Created scripting and jobs to automatically feed telemetry data and other information into various external systems including creating automatic orders in an SAP system. Work required significant coordination with external teams for network access, data formats, and communication related to system issues or software releases that might impact data feeds.
- Worked with VP of Confidential to develop special site to help with employee compensation reviews and to help justify compensation decisions to corporate.
- Maintained and developed C#.NET based server and User Client as front end for telemetry system.
- Did some basic research into Apache Cassandra for a NO-SQL distributed database to improve scalability.
IT Leadership Program
Confidential, Shelton CT
Responsibilities:
- Managed project to migrate Salesforce.com web site from sandbox to production. Produced detailed documentation for the site and for the deployment process.
- Presented project tollgate slides to IT leadership including the CIO
- Managed Mobile Device Management project until it was placed on hold for budget reasons
Database Analyst
Confidential, Hamden CT
Responsibilities:
- Assembled data from various sources to support custom sales reporting for clients
- Managed scripting to import the data into supporting databases, process the data, and export it in the appropriate format to generate automatic excel reports
- Often communicated with clients directly(phone, email, and onsite meetings) to determine requirements and timelines for reporting upgrades
- Gained understanding of:
- Client sales team organization for accurate data alignment and reporting
- Custom business rules for every project
- Structure of various data feeds from both the clients and large prescription sales data providers