Paul Usalko

**** ******* **. ********, ** *****, Home 859-***-**** Cell 859-***-****, y35i35@r.postjobfree.com

Work Experience

Systems Analyst

**** ** *******

Convergys Corporation

Activation Manager analyst supporting the Convergys provisioning solution

" Install and configure provisioning systems

" Execute validation testing

" Used UNIX tools to test and debug configuration tables

" Specification analysis and live testing with the client

" Worked on network element transactions for AWCC, Cricket and C-Spire interfaces

Migration developer supporting the migration of external client data to Convergys solutions. Responsibilities of this role include:

" Data mapping

" Code customization particular to the client

" Source extract validation

" Performing migration processes using Unix scripting and Oracle procedures

Technical lead supporting the UAPM Asset Management system at Convergys. The system is interfaced with other Convergys applications extracting and warehousing asset information. Responsibilities of this role include:

" Manage system development activities while working with the customer, Project Manager and Business Analyst to set up release schedules based on development capacity and customer priority.

" Act as technical lead supporting the development of requirements and subsequently designing the associated system changes.

" Develop applications using Oracle PL/SQL, MS Access SQL, Visual Basic, DOS batch Scripts and SQL Loader scripts based on the design and requirements.

" Provide second level production support for the application and Convergys customizations.

" OLAP Administration involving UNIX.

Provided PARIS/NUMIS legacy system support after Convergys began the development of the new Convergys Billing System (CBS). Responsibilities of this role included:

" Sole design, development and production support person for two internal billing systems (PARIS and NUMIS).

" Responsible for configuration management using Visual SourceSafe and implementation of application changes into a Citrix environment.

" Troubleshoot production issues and provide temporary workarounds and subsequently permanent bug fixes.

Assisted with the design and development of system enhancements interfacing Convergys financial systems with Ketera which is an eProcurement solution used by Convergys. This role included designing and developing PeopleSoft system changes using SQL and PeopleSoft Application Designer.

Programmer Analyst

1999 to 2002

Convergys Corporation

Programmer Analyst working on the PARIS and NUMIS Convergys billing systems. Responsibilities of this role included:

" Design and develop system enhancement and modifications using Visual Basic, SQL, miscellaneous report writers.

" Assisting with System and Integration testing of application changes.

" Primary and secondary production support during the time sensitive monthly revenue and billing period.

Intern

1997 to 1998 Convergys Convergys Corporation

Development in Visual Basic, SQL, Crystal Reports, designed and developed Lotus Notes databases, created Excel pivot table reports

Accomplishments " Was the sole technical support person for a billing system responsible for millions of dollars of company revenue.

" Was the sole technical support person for an asset management system responsible for tracking all company's IT assets.

" Working as an intern, redesigned an HR report that was done via manual subtotaling to use Excel pivot tables saving hours of manual processing.

" After regular expressions were introduced in Oracle 10g, rewrote numerous existing SQL queries using regular expressions eliminating many lines of code.

" Designed a way to send print output from a DOS-based applicatiod into a pdf printer via PCL. Previously this was considered unfeasible as DOS applications do not communicate with Windows virtual printers.

" Continually sought to identify inefficiently written code to improve existing processes. For example, replaced the Oracle IN statement that was slowing down a query with the EXISTS statement that uses indexes.

" Designed a way to update legacy dBase tables from inside Visual Basic code such that indexes are simultaneously updated. Previously this required post-process manual reindexing.

Computer Experience

Hardware

" PC running Microsoft Windows NT, 2000, XP

" Workstation running Unix

" Windows 2000 and Windows 2003 Server, Citrix Terminal Server

Software

" PL/SQL Developer, Oracle SQL Developer, TOAD, Visual Basic, Crystal Reports, Microsoft Office (Word, Excel, Access, Visio), PuTTY, vi, XML, WinSCP, Cygwin, Microsoft Visual SourceSafe, StarTeam, Synergy.

Programming " Oracle PL/SQL and MS Access SQL, Oracle database, Visual Basic, DOS batch scripting, SQL Loader scripting, SSH, Unix

Education

Bachelor of Science in Information Systems, minor in Business Administration Northern Kentucky University 1998, 3.8 GPA

Courses included System Analysis and Design, Data Modeling, SQL, Visual Basic, PowerBuilder, HTML, COBOL, Accounting, Finance

Professional Seminars " SQL: Advanced Query Techniques

" SQL Programming in ORACLE

" Working with Oracle Tools

" Server Programming in ORACLE

" Visual Basic 6.0 Application Development

" Programming in .NET

" HP Service Manager suite

" PeopleSoft Application Designer and PeopleCode

" Crystal Reports

" Function Point Analysis

References Bill Stock Sr Manager, Convergys, 513-***-****

Ralph Greene Sr Manager, Convergys, 513-***-****

Mark Kneip Sr Consultant, Convergys, 513-***-****

Contact this candidate