A & V Consulting, Inc. 231 Sycamore CircleLanghorne, PA 19053 [Send email to request phone number] 42-0309
[Send email using form at bottom]
Alan Kovtun
PowerBuilder/Java/.Net Consultant
Profile:
Alan Kovtun is an accomplished Senior PowerBuilder Developer with broad
experience in all phases of Client Server and Web Applications including over 4
years of recent J2EE development experience. His areas of expertise are:
· Total of 18 years of experience with over 12 years of experience with
PowerBuilder, PFC, Jaguar CTS, DB2, Oracle, SQL, PL/SQL, Microsoft SQL Server,
Sybase SQL Server, Transact – SQL , Sybase SQL Anywhere, PowerScript, Windows and
NT operating systems
· Expertise in design and development of various web and enterprise
Applications using JAVA/J2EE technologies like JSP, Servlets, EJB,
Struts, JDBC, JMS, JTA, JNDI, Java Mail API, JAXB, SAX, DOM,
Java Bean, IBM MQ Series, JAX-RPC, WSDL, RMI and Web Services
· Experience with building Microsoft Access, Excel, Word 97/2000/2002/2007
applications
· Conversion expertise from older Microsoft products applications to newer
versions
· Experience with PowerBuilder Events, Global and Window Functions, Global
External Functions(API), Embedding SQL in Powerscript, OLE, Pipeline
· Experience with creating windows using different controls and data window
objects with different presentation styles, dynamic data windows/data stores and
HTML data window
· Experience with building MDI applications , 3+ Tier Distributed applications,
Project Security Aspects and Web Development
· Object Oriented Programming: Inheritance, Polymorphism, Encapsulation and
Function Overloading
· Strong knowledge and extensive experience of RDBMS Concepts, Views, Stored
Procedures, Packages, Triggers, SQL Server and Sybase Mobile Deployment and
Replication
· Strength in Relational Database Management Systems: DB2, Oracle, SQL Server,
SQL Anywhere and Sybase
· Extensive use of PFC Services provided by PowerBuilder
· Extensive use of OLE programming for MS Word and Excel
· Strong Unix Shell Scripting Skills
Alan has excellent communication skills and is a strong team player. He is
highly motivated and has the ability to work independently and adapt quickly to
new and emerging technologies.
Technical Skills:
Languages: PowerBuilder 4.x/5.x/6.x/7.x/8.x/9.x/11.x, Jaguar CTS 3.6.1, Visual
Basic 5.x/6.x/7.x, VBA, HTML 3.2/4.0, DHTML, DOM, JAVA, JSP, JavaScript, ASP,
VBScript, CSS, SQL, PL - SQL , Transact - SQL, C++, UNIX, C#
Operating Systems: UNIX, Windows NT/95/98/2000/XP
Hardware: Hardware, IBM PC compatible (standalone and network)
Databases: Oracle 7.0/7.1.1.3/8.0.5.0/ 9.0.1/10.x, DB2, Microsoft SQL Server 6.5
– 7.0 – 2000-2008, Sybase SQL Server 10.x/11.x, SQL Any 5.0/5.5/7.0/11.x,
Pervasive SQL
GUI: PowerBuilder 4.0 – 11.5.1, Visual Basic 5.x/6.x/7.x, Microsoft Office
97/2000/2002/2007, Visual Interdev 6.0/7.0, IBM Web Sphere Application Developer
5.x/6.x/7x, Erwin 3.5, Infomaker, PL/SQL Developer, Delphi 7.0-2010, Visio, UML
modeling
J2EE Technologies: JDBC 2.0/3.0, Servlets 2.3/2.4/2.5, JSP 1.2/2.0, EJB
2.0/2.1/3.0, JNDI 1.1, JMS 1.1
Web Technologies: XML, SAX, DOM, SOAP, JavaScript, HTML, DHTML, CSS, Asp .Net
2.0 – 3.5
Professional Experience:
TSPartners, Inc, King of Prussia, Pennsylvania (August 2009 – Present)
Senior Programmer/Business Systems Analyst
Responsibilities:
· Design Development and implementation of existent Client Server legacy
applications (Delphi system)
· Architectural and design considerations to facilitate rewrite project to .Net
of major concepts of Stock Transfer Software
· Translation and conversion of SQL modules from transaction database
· As web developer team member done major development of Web module (.Net 3.5,
C#, some Ajax work)
· Changes and additions to backend (Oracle 10g and MS SQL Server 2008)
processing included but not limited to Conversion, Views, Stored Procedure,
Triggers
LeMans Corporation, Janesville, Wisconsin (May 2009 – July 2009)
Senior Programmer/Business Systems Analyst
Responsibilities:
· Modifications to existent Client Server applications (PowerBuilder 9.3 and
11.0)
· Responsible for business analysis, system design and document management for
legacy to web rewrite project
· Integration and system testing procedures
· As web developer team member done major development of Web module (.Net, C#,
WebServices - WSDL/SOAP and XML)
· Extensive changes and additions to backend (MS SQL Server 2008) processing
included but not limited to DTS, Views, Stored Procedure, Triggers
Independence Blue Cross Insurance Company, Philadelphia, Pennsylvania (February
2005 – April 2009)
Senior Programmer/Systems Analyst
Responsibilities:
· Major functionality changes, modifications and support were done for several
client server Applications written in PowerBuilder 9.0 and Oracle 9.i including
conversion to PowerBuilder 11.x and Oracle 10g, DB2 databases
· Responsible for conversion from PowerBuilder client server to Java J2EE Web
Application
· Front-end/presentation tier development using Struts Framework that included
Tiles Framework, Validation Framework, JSP, Custom Tags, JavaScript, CSS and some
AJAX
· Designed, developed and deployed web and enterprise applications using Asp.Net
- C# and JAVA/J2EE technologies like JSP, Servlets, EJB, Struts, JDBC, JMS,
JNDI, Java Mail API, DOM, Java Bean, IBM MQ Series, WSDL and Web Services
· Developed integration services in SOA by offering Web Services based on XML
communication on SOAP Layer with client calls from web application as well as
from client server
· Responsible for some middle tier Java business logic development, along with
requisite Oracle SQL implemented through data access objects
· Major use of CSS and JavaScript (DOM) to include files with some XML
application capability
· Responsible for system business analysis, writing and executing unit,
integration and system testing routines.
IBM - ACE-INA Insurance Company, Philadelphia, Pennsylvania (May 2000 – February
2005)
Sr. Programmer/Systems Analyst - Project Leader
Responsibilities:
· Technical Lead for a group of four to six programmers/business analysts
· Maintained and developed the Property Division system, which consisted of six
applications designed for Property & Power Generation policy underwriting, B&M,
reporting and system maintenance in 12 branches around the USA and Home Office
· Used PB 6.5 - PB 7.3.5 – PB8.0.3 with extensive use of PFC based on major
Object Oriented concepts (Inheritance, Polymorphism, and Encapsulation), multiple
document generation available through the application using macros written in VB
and Sybase SQL Server 10x-11.x with intense replication of data from branch to
Home Office and Home Office to other branches
· Most applications used multiple triggers and stored procedures written in
Oracle 8.0 (PL-SQL) for complicated premium calculations, updates and data
presentation
· All of the database maintenance and support was handled through Erwin 3.5
· Participated as a team member in Intranet development using JSP, VBScript,
JavaScript and some Java 1.2 for user interface development in Oracle 8.0
database
· Created a series of Spreadsheet applications on Customer Information/Rating
System for Property subdivision using macros and VBA programming
· Followed full Software Development Life Cycle
· Wrote reporting system in PowerBuilder using stored procedures as Data window
Source and Crystal Report 9.0
AstraZeneca Pharmaceuticals USA – Andersen Consulting, Inc., Wayne, Pennsylvania
(December 1999 – May 2000)
Sr. Programmer/Analyst
Responsibilities:
· Managed a group of seven programmers/business analysts
· Developed CDAP (Contract Development, Approval and Production) PFC based
application in PowerBuilder 6.5-7.0 with Oracle 7.3 – 8.0 and Sybase SQL Server
· Used PVCS Version Manager as well as PB Native functionalities for source code
protection
· Extensively used PFC services especially to Datawindows, Tabs and Tree Views
· Was responsible for the development of Account Analysis subsystem, including
organizational overview, products and services and analysis of competitors,
delivery and control
· Actively participated in the design and development of “Replication Process”
to keep the interaction between Sybase and Oracle data bases
· Developed a complex reporting system for different departments using Seagate
Crystal Report 7.0
The Hibbert Group, Trenton, New Jersey (February 1999 – December 1999)
Sr. Programmer/Analyst
Responsibilities:
· Responsible for the participation and development of new systems as well as
supporting existent application in PowerBuilder 6.5 and Oracle 7.3 – 8.0
· Acted as team leader in analysis, development and implementation of Hibbert’s
internal use Timecard & JAS(Job Accounting Systems) using framework and multiple
PFC services
· Major work that was done in Oracle included development of packages and
standalone stored procedures written in PL SQL; special programs were written in
Oracle acting as generic functionality to execute packages and procedures
including different utilities to keep the interaction between Client/Server and
Mainframe (VSE/ESA) environment
· Used Unix (Sun Server) for creating, exporting and importing data files,
primarily for warehouse use, doing inventory and accounting applications
· Multiple triggers were created to update Oracle tables
· A series of reports in different formats and presentation styles were
developed using Seagate Crystal Reports 7.0
Global Systems Technology, Inc., Yardley, Pennsylvania (June 1998 – February
1999)
Sr. Programmer/Analyst
Responsibilities:
· Acted as Project Leader in Design, Development and Implementation of EXXIS
Project (Human Resources Management System and Client – Server Application) using
PowerBuilder 6.0 and SQL Server - SQL Anywhere 5.5(GUI based system)
· Performed and was solely responsible for security system(front and back ends)
for the project
· Analyzed and generated formatted report systems for easy process management
using Seagate Crystal Reports 6.0; used API and Global External Functions
· Designed and developed dynamic system that allowed user to generate, modify
and upload web pages using Powersite, HTML, JavaScript and VBScript
· Responsible for CD Image creation and final user distribution
KLA Navigation Co., Allentown, Pennsylvania (January 1996 – May 1998)
Programmer/Analyst
Responsibilities:
· Participated in full project life cycle, including physical and logical
design, programming, testing application, promotion and implementation
· Maintained existing applications
· Provided application support and assisted end user with software related
issues
· Created documentation and was involved in security system for the project
· Worked as a member of a team to design and develop business application using
PowerBuilder 5.x, PFC 5.x and Oracle7.2-7.3
· Worked with different services provided by PFC
Novastar Consulting, Inc., Plymouth Meeting, Pennsylvania (August 1994 –
December 1995)
Programmer/Programmer/Analyst
Responsibilities:
· Created PowerBuilder applications (Using PowerBuilder 4.x) for a Quality
analysis system which allowed the production of multiple reports for the
Purchasing department with data related to products returned during the
manufacturing process by internal quality Control and returned by customer; both
systems used Sybase and Oracle7.1 database
Micron Co., Kiev, Ukraine (1991 – 1994)
Software Engineer
Responsibilities:
· Worked on schedule development and control programs for electronic equipment
production using FORTRAN and Pascal on PDP-11 computers
· Involved in maintenance, support and troubleshooting of existing manufacturing
software written in FORTRAN
Professional Certifications and Training:
· Windows Professional Install Shield 7.x, Advanced SQLServer 2000 training, IBM
(2003)
· Oracle PL/SQL Advanced Programming (2000)
· Sybase & Oracle Database and Development Tools (May 1996)
· Extensive training in PowerBuilder 4.0 provided by Novastar (1994)
Education
· Bachelor of Computer Science
Kiev State University – Kiev, Ukraine (1991)
|
