Simon Mestetsky

317-***-**** ***** Salamone Way, Carmel IN 46074 ac0e4t@r.postjobfree.com

Objective and Summary of Qualifications

Seeking to fill a company’s need for an SQL developer, application developer, programmer analyst. I am a dedicated and reliable IT professional with over twenty years of experience in all aspects of application development, testing, troubleshooting, and implementation, including expertise in workflow development and quality assurance. I have superior communication, presentation, analytical, and problem-solving skills. Most importantly, I pride myself in my ability to work either alone or with a team to ensure programs are error free and are completed prior to deadlines. I am reliable and detail oriented. Computer Skills

Programming: Oracle SQL, PL/SQL, SQL*Plus, T-SQL, Teradata SQL, UNIX scripting, Speedware 4GL, COBOL, Informatica, MicroStrategy

Operating Systems: UNIX HP9000, MPE HP3000

Database: Oracle 12, Teradata 13, MPE Image

Other: SVN, Track-It, Jira, Confluence

Professional Experience

hhgregg, Inc., Indianapolis, IN 1999 – Present

Application Developer

Designed, developed, and implemented various applications (including report, menu and screen programs) like Time Clock In/Out, Delivery Truck Check-In, Inventory, Spec Order and others

Created numerous SQL and PL/SQL programs and reports on Unix using SQL*Plus interface as well as stored procedures, functions, triggers written directly in Oracle database

Created detail test plans as well as executing test cases with Sql or Unix test scripts for each assigned project

Created batch processes to transfer/ftp data to 3rd party companies, updated Oracle data for Month End process and ETL data from Oracle to Teradata

Modified and migrated hundreds of Speedware 4GL programs from old MPE HP3000 (Image database) to Unix HP9000 (Oracle database) system

Created reports using MicroStrategy tools and Informatica workflows to transfer data between Oracle and Teradata

Wrote dozens commands and tools on HP9000 now used company wide OneAmerica Financial Partners, Inc., Indianapolis, IN 1997 – 1999 Application Developer

Designed, developed, and implemented numerous programs in COBOL and Speedware 4GL Education

Ivy Tech Community College, Indianapolis (Programming classes, COBOL, RPG) 1995 – 1996 Novocherkassk Polytechnic University, Russia (B.S., Computer Science) 1976 – 1981 Kiev University, Ukraine (Math Programmer Associate Degree) 1972 – 1974 Additional Training

T-SQL and SSRS Courses for SQL Server Administrator (Udemy) 2017 Oracle University - SQL Optimization Course, Chicago (week-long) 2014 Informatica Course, Chicago (week-long) 2011

Oracle University - PL/SQL Database Course, Indianapolis (week-long) 2010 MicroStrategy Course, Washington DC (week-long) 2006 Speedware Course, Montreal, ON (week-long) 1998

Languages – Native Russian and Ukrainian