Developer Software

Michael Van Zandt

Lewisville, TX ***** • 682-***-**** • **********@*****.***

PL/SQL Developer

9+ years of success optimizing system performance through expertise in analysis, design & development

Motivated, results-oriented, and dynamic IT professional with diverse range of experiences and proven expertise in implementation and execution of best practices. Skilled communicator able to build collaborative relationships with cross-functional peers, engage end-users and clients, and motivate team success. Analytical and organized as well as highly adaptable, proactive, and pragmatic in approach to solving problems.

Areas of Expertise

Software Development Life Cycle • Requirements Gathering • Software Design & Development

Testing & Coding • Client-Server Architecture • Database Development • Writing Packages & Procedures

Schema Structure Design • Data Storage Optimization • Performance Tuning & Optimization

PROFESSIONAL EXPERIENCE

Senior PL/SQL Developer (8/2012 – 10/2016) Epsilon – Irving, TX

Technical Environment: Oracle 11g, PL/SQL, Toad, SQL Developer, Unix/Linux, Shell Scripting, Perl Scripting

Directed seamless implementation of tasks and optimization of existing framework through creation of tables, procedures, functions, and triggers.

Completed design and implementation of partition methods for Oracle tables and indexes.

Performed build and maintenance to switch data mart database model for marketing campaigns.

Created SQL Loader scripts to insert data content from client flat files to data stage table set.

Led diverse aspects of development including Kems/Kraft server code build and management, and Cablevision server code build and campaign data reorganization.

PL/SQL Developer (1/2010 – 8/2012) Sherwin Williams Paint & Coatings HQ – Cleveland, OH

Technical Environment: Oracle11g, PL/SQL, Unix/Linux, Shell Scripting, SCSI/SSA devices, Industrial Hardware

Created PL/SQL stored procedures and packages to insert data content from remote user machines to streamline performance and client support.

Tested new vehicle mount terminals for connectivity, and long term industrial viability.

Debugging of vehicle mount terminals using Java with a PL/SQL backend.

Resolved multiple major issues preventing optimal service and performance through analysis and expertise.

Create new GUI style screens to project specification.

AWCS Support Tech (1/2007 – 12/2009) Sherwin Williams Paint & Coatings HQ – Cleveland, OH

Technical Environment: Oracle11g, PL/SQL, Unix/Linux, Shell Scripting, SCSI/SSA devices, Industrial Hardware

Served as Release Coordinator to lead implementation, and software migration practices for 22 servers.

Helped to bring 3 servers online with initial data setup, and in go live operations.

Collaborated with AWCS users, development team, and site administrators to identify and resolve software issues, resolve vehicle mount and handheld hardware issues, and eliminate warehouse setup issues.

Used Peoplesoft to open help desk tickets and learned best practice method for issue resolution.

Wrote, and maintained documentation on Falcon handheld initial setup as well as connectivity resolution.

Played key role in UAT testing and bug repair, including migration of data from development to testing.

Developed and implemented tools and practices to proactively identify and remove outdated files, directories, objects, and code.

Warehouse Technician (7/2001 – 12/2006) Sherwin Williams - Waco, TX

Experience using, in-house software sysltem, AWCS.

Became familiar with Shipping and Receiving practices.

Preformed forklift and product picking procedures daily.

Became familiar with Sherwin Williams business rules, and best practice environments.

EDUCATION

Associate of Applied Science, Concentration in E-Commerce Programming Technology

Texas State Technical College – Waco, TX

TECHNICAL PROFICIENCIES

Languages:

PL/SQL, Shell Scripting, SQL Scripting, Javas Script, Web Authoring, Visual Basic 6, XML, HTTP, Visual Basic

Systems Software:

AWCS, AOM, OnBase, Business Objects

App Software:

Oracle (9i, 11g), MS SQL Server 2000, Visual Studio 6

OS:

Windows XP, HPUX/Unix, Linux, 2000, 2000 Server, 2003 Server

Hardware:

Vx4, Falcon 4420, Falcon 345, Intel PC, AMD PC

Contact this candidate