EDWARD A. SOBANSKI

*** ********* ***** ~ Michigan City, IN 46360

219-***-****/219-***-**** (home/cell)

zgrzk2@r.postjobfree.com

OVERVIEW

Solutions-focused, team oriented Computer Technician, Technical Support Analyst, Computer Hardware and software installations, Application and Database Developer and Designer using PL/SQL in windows and UNIX environments. I have broad-based experience and hands-on skill in the successful implementation and support of vendor/custom applications as well as the cost-effective management of innovative customer and technical support strategies. Proven ability to successfully analyze an organization's critical support requirements, identifies opportunities for enhancements, and develops innovative solutions for increasing reliability and improving productivity. I have an understanding of computer hardware and software, including installation, configuration, management, SQL creating, troubleshooting, support and team leader.

DETAILED SUMMARY

• Experience in Relational Data Modeling to design and maintain Oracle and SQL Server database models

• Unix shell scripting using the vi editor

• Oracle databases in a UNIX environment

• Data warehousing experience

• Database design experience

• Experience in OLTP Performance Tuning and Explain Plan, SQL Loader, DBMS, Indexes, Import and Export utilities, functions, packages, procedure, tables, views, materialized views and triggers

• Over 12 years experience in PL/SQL queries and reporting

• Over 12 years of documenting application and processes

• Worked in a SQL server, Oracle 7, Oracle 8 and Oracle 9i databases environment

• Installation of computer memory, power supplies, Hard Drives and peripherals.

• Virus Removal and operating system support

• Used toad application to support Oracle development and implementation of databases objects

• Mentored Junior members in PL/SQL report writing, query building and data modeling

• Supported website written in ASP and JavaScript

• Supported an application written in VB6

• Over 15 years experience in analysis, design, coding, testing, implementing and supporting applications of various architecture

• Used Visual Studio .net 2003 and 2005 with source safe to develop and maintain C# web pages that were added to a vendor application

• Worked with the budgeting process to estimate the time and resources needed to complete a project

• Managed project implementations, creation of business requirements, lead small development group and mentored junior developers

• Worked with Microsoft Word, Excel, Access, Project and PowerPoint

• Used Artinsoft software to help convert VB6 application to VB .net using Visual Studio 2005

• Analyzed and modified web configuration files XML tag

• Self-starter learning and analyzing unfamiliar architecture to support existing applications with little or no prior training.

• Used Crystal Reports accessing Oracle database

• Supported the analysis, integration and implementation of vendor purchased applications

EDUCATION

• Masters of Technology Degree from Purdue University – (estimated completion date 5/12)

Published and presented 2 papers for the 2011 IEEE Global Humanitarian Technology Conference (GHTC 2011)

• Bachelor of Science in Network Systems from Purdue University – 1995

• Associate of Applied Science in Application Programming from Purdue University – 1992

TECHNICAL SKILLS

Operating Systems UNIX Sun Solaris, MS-DOS, Windows 9x/NT/2000/XP/Vista, Lotus Notes, Linux

Dynamic Page Generation IIS

Scripting Languages UNIX Korn Shell

Languages ASP, C#, VB .Net, VB6, PowerBuilder, PL/SQL

Database Software Oracle 7, Oracle 8, Oracle 9i, MS-Access, SQL Server

Reporting Software Crystal Reports, Excel, Word, PL-SQL, Business Objects

PROFESSIONAL EXPERIENCE

VINZANT SOFTWARE – HOBART, IN APRIL 18, 2011 TO OCTOBER 21, 2011

Vinzant Software Company develops the GlobalECS scheduling system. I worked in the customer support department, where I tested various versions of GlobalECS and answered customer questions.

SPRINGFIELD ELEMENTARY – MICHIGAN CITY, IN SEPTEMBER 7, 2010 TO APRIL 18, 2011

Lunch aid and elementary school soccer coach.

3DogNet LLC – Hobart, IN June 6, 2009 to December, 2010

3DogNet is a local PC support service for home and small business users. They clean machines and update software, setup servers and networks both wired and wireless.

2009 – 2010(contract basis)

• Clean Desktops and printers

• Installation of memory, power supplies, mother boards, Hard Drives and peripherals for Desktop and laptops.

• Add and remove software and hardware

• Virus removal

• Printer and Network setup

• Application Development

JP MORGAN CHASE –Chicago, IL 1995 - December 2008

JP Morgan Chase is a worldwide banking institution in which I worked for its commercial banking group: supporting the financial tools used by its middle market business. The aspects of my job ranged from the development and support of various applications to the management and mentoring of resources for projects to enhance and update the financial tool applications.

2006-2008

• Mentor/Lead Developer for custom application written in VB6 and using an Oracle 9i database

• Mentor/Lead Developer for custom website written in Asp and JavaScript used for gathering customer loan requests

• Mentor/Lead Developer for vendor application Riskanalyst

• Project Management for implementation of vendor customized application

• Gather requirements for application enhancements and design

• Conduct monthly meetings with business partners to set priorities and projects

• Helped in budget process to identify projects and estimate the time and resources needed to complete project

• Worked with other developers to ensure projects were completed successfully and on time.

• Used PL SQL to create Ad Hoc and custom reporting.

2004-2006

• Lead Database Developer responsible for design and support of Oracle database for web and client server application

• Team Lead for RiskAnalyst application responsible for project and project resources

• Interfaces with business to gather requirements for projects

• Analyses of multiple databases application structure and functionality to merge into a single application

• Mentor junior database developers in UNIX, Oracle and database design

• Database support of client server applications built in PowerBuilder

• Database design and support of web applications developed in Java

1995 - 2004

• Development and design of PowerBuilder applications using Oracle 7 database

• Installation and development of vendor applications across various locations in the Midwest

• Oracle database analyst and development supporting and developing tables, indexes, packages and batch procedures in UNIX Korn shell scripting for a client server application

• COBOL mainframe development

WARSHAWSKY AND COMPANY-CHICAGO, IL 1993-1995

Warshawsky and Company is a mail order auto supply distributor. I was responsible for the development and support of the call center order entry and batch processing of orders.

1993 - 1995

• Worked with COBOL

• Learned CICS development

• Supported EDS development

GRANT HOSPITAL-CHICAGO, IL 1991-1993

Medical Billing Agent

1991 - 1993

• Processed Payments

• Sent out and posted bills to insurance companies and patients

VOLUNTEER EXPERIENCE

IBT (INDIANA BALLET THEATER)- MERRILLVILLE, IN 2005 - PRESENT

Help with the Nutcracker and annual Spring Ballet productions for the IBT dance company.

2005 - Present

• Stage setup and tear down

• Security

• Boy Room Dad

Contact this candidate