leslie gannon

Successfully led the cross functional efforts to migrate client data and code from a single Oracle server to multiple servers for improved overall platform stability with minimal production downtime and with no loss of data. - Mentored and trained other Database Programmers.

* Developed PL/SQL procedures and utilized the company’s proprietary tools and technology to successfully execute and deploy e-mail marketing campaigns in a fast-paced environment. * Worked with Database Administrators to manage user privileges and to monitor database performance. * Improved database performance by tuning SQL queries and by creating indexes and partitions. * Focused on improving data processing workflow efficiencies for our clients. * Participated in code reviews with other Database Programmers and Business Systems Analysts. * Provided on-going maintenance and technical support. * Supported a $2.5 million client account as the lead programmer on the team, managing large data sets for 26 million customers and implementing campaigns resulting in 15,000+ mailings annually. * Promoted from Database Programmer to Senior Database Programmer in July 2010, becoming one of the eight senior-level programmers (out of 35 total programmers). * Participated in technical roundtable discussions with the Senior Database Programmers.

* Developed, modified and maintained client databases for company’s proprietary Compensation Planning application by applying knowledge of Oracle and database design standards to code and configure databases based on client functional specifications. * Worked closely with Project Managers and Business Analysts to analyze, review and modify database programs based on client requirements. * Performed SQL tuning to improve performance of database views and queries using Explain Plan in Oracle. * Prepared flowcharts in Visio to illustrate sequential processes. * Wrote documentation to describe programming logic, coding, data mapping, and defect resolutions. * Provided post-production maintenance and support. * Experience with software development lifecycle and deployment management. * Mentored and trained Database Developers. * Promoted from Database Developer 2 to Database Developer 3 in 2007.