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