Bojidar Dimitrov Raytchev

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

Aurora, CO 80015, USA

Cell Phone: 303-***-****

E-mail: acrkik@r.postjobfree.com

CANDIDATE PROFILE:

I have more than 19 years IT experience in USA, all of them with PowerBuilder, more than 12 years with Oracle, and more than 5 years with MS SQL Server. I also have some experience with some other database management systems – Informix, Sybase Adaptive Service Anywhere (ASA), Sybase Adaptive Server Enterprise (ASE), DB2, and My SQL. I have great experience in designing, developing and supporting client server applications programs for a variety of industries. I have broad exposure to all aspects of applications programming including configuration, maintenance, design, implementation and documentation. I always provided on time and accurate, complex programming services for designated projects, and ensures a high level of quality control and quality assurance. During my career I performed a lot of activities related to software design and development during the entire applications life cycle:

Complex product design activities requiring extensive research and analysis.

Design, implementation and maintenance of complex, multiple product modules and sub-systems.

Participating in design meetings.

Unit testing and integration testing for functionality and limits.

Design and implementation in order to meet project objectives.

Documentation of development work.

END USERS:

Varian Medical Systems/UPMC(University of Pittsburgh Medical Center) (2014-2015)

Planet Consulting /TransFirst (2013 – 2014)

Texas Department of Transportation (2012-2013)

Starz Entertainment, LLC (2012)

Stone River (2011-2012)

Bank of America (2010-2011)

Stone River (2010)

State of Colorado, Department of Corrections (2009-2010)

Starz Entertainment, LLC (2009)

Steel Dynamics, Inc. (2008)

Kingsway America (2008)

Fiserv Insurance Solutions (formerly InsureWorx, Taliant Software) (2006-2008)

City of Los Angeles, Taxation Office (2006)

CalPERS (2005)

Taliant Software (2002-2005)

IDOM, Inc. (2000, 2001)

Bank of Paribas (2001)

Dresdner Bank (2001)

McKesson HBOC (2001)

Street Bank Boston (2001)

Circle.com (2000)

Ryder TRS, Inc. (1999, 2000)

State of Louisiana, Department of Public Safety (1999)

Mattel Toys (1999)

Nissan North America (1998)

Deloitte & Touche (1996, 1997)

PRIMARY SKILLS:

Development of client-server applications, reporting and imaging:

PowerBuilder 3, 4, 5, 6, 6.5, 7, 8, 9, 10, 11, and 12 (19+ years)

InfoMaker (8+ years)

C/C++ (2+ years)

ObjectStart (2 years)

PowerImage (1+ year)

Oracle Reports 6.1 (3 years)

Crystal Reports (1+ years)

Brio.Report, SQR (9 months)

LawPack (9 months)

Visual Basic (6 months)

Development of Web applications, application servers and distributed systems. Web-enabling of existing client-server applications:

Java (2+ year)

Web Services (2+ years)

JDeveloper 10g (1+ year)

PowerJ (1+ year)

Java, SWING, servlets, JSP, Struts, EJB, J2EE (2+ year)

HTML (4+ years)

XML (1+ year)

JavaScript (4+ years)

Tomcat (1+ year)

PowerBuilder Distributed Programming and Web.PB (2+ years)

Sybase EAServer (2+years)

Jaguar CTS (2+ years)

Perl (2+ year)

ActiveX, COM/DCOM, ADO, CORBA (1+ year)

OLE (5+ years)

Development of stored procedures and triggers:

Oracle 7, 8, 8i, 9i, 10g, and 11g (12+ years)

MS SQL Server (5+ years)

Sybase Adaptive Server Enterprise (ASE) (6 months)

Sybase Adaptive Server Anywhere (2+ years)

DB2 (1+ year)

Informix (7 months)

PL/SQL Developer, DBArtisan, SQL Navigator, SQL*Plus, SQL*Loader, Enterprise Manager, TOAD (8+ years)

Object-oriented application design (5+ years):

UML

Rational Rose

Data modeling, databases logical and physical design:

ERwin/ERX (8+ years)

PowerDesigner/AppModeler (1+ years)

Development of data warehousing applications based on OLAP and OLAP Analysis Services:

MS OLAP Analysis Server 7 and 2000, Data Transformation Services, MDX (2+ years)

Deployment Tools:

InstallShield (4+ years)

Source Control Systems:

StarTeam (7+ years)

PVCS (4+ years)

MS Team Foundation Class (10 months)

MKS SCC Integration (7 months)

Subversion SCS, Tortoise (3 months)

Surround SCM (6 months)

Office Management (10+ years)

MS Word

MS Excel

MS Access

MS PowerPoint

Visio

Business Analyze (6+ years)

Insurance

Accounting

Portfolio Management

Banking

Time Budgeting and Reporting

Entertainment

Full system development lifecycle, including requirements, design, coding, testing and implementation (13+ years)

Project Control

SCRUM (3+ years)

SECONDARY SKILLS:

In-depth understanding of accounting and great experience in design and development of accounting systems.

Good hands-on experience with Windows Sockets.

Good hands-on experience with Telephony API.

Good understanding of applied cryptography and its implementation in Internet and E-commerce supporting systems.

In-depth understanding and hands-on experience with statistics, computer simulation of discrete (GPSS) and continuous (CSMP) systems with application in queue systems, biophysics, medicine, mechanics and microelectronics.

Understanding of Rational Unified Process and UML (Rational Rose, HOW).

Understanding of J2EE.

INDUSTRIES:

Financial industry and accounting.

Insurance.

Transportation.

Government information systems.

Distribution industry.

Pharmacy.

Justice and legal matters.

Software industry.

E-commerce.

Entertainment industry.

SOFTWARE:

PowerBuilder, incl. PFC

ERwin/ERX

InfoMaker

PowerJ (Java)

JDeveloper (Java)

JBuilder (Java)

Sybase EAServer (Jaguar CTS, Sybase Anywhere Adaptive Server, etc.)

SQR (Brio.Report)

Oracle Reports

Crystal Reports

PVCS

MS Team Foundation Class

PL/SQL Developer, SQL Navigator, SQL*Loader, DBArtisan, TOAD

PowerImage

LawPack

ObjectStart

Rational Rose

Visual Basic

Visual C/C++

Watcom C/C++ and C/C++ Class Builder

MS Word

MS Excel

MS PowerPoint

Visio

IBM CICS/370

IBM General Purpose Simulating System (GPSS)

IBM Continuous Systems Modeling Program (CSMP)

DATABASES:

Oracle, incl. PL/SQL

MS SQL Server, incl. T-SQL and OLAP

Sybase Adaptive Server Enterprise (ASE), incl. T-SQL

Sybase SQL Anywhere (ASA)

DB2

Informix

MS Access

LANGUAGES:

PowerScript

SQL

Java

HTML

XML

JavaScript

Perl

UML

C/C++

Modula-2

Basic

OPERATING SYSTEMS:

Windows (all versions)

MS DOS

UNIX

OS/400

MVS

VM

EMPLOYMENTS AND WORK EXPERIENCE:

E25

4/2014 to 8/2015

Sr. PowerBuilder and SQL Developer

Varian Medical Systems, Inc. (project for UPMC, Pittsburgh, PA)

ARIA - Application supporting hospital management

Development and support of client-server application for hospital management. The ARIA is a family of applications for various aspects of hospital management. ARIA MO (where MO stays for Medical Oncology) is the version specifically designed for the Cancer Center of UPMC (University of Pittsburgh Medical Center). The ARIA NO application supports patient information, doctor visits, prescriptions, medical treatment, patient test data, treatment plans, regimens, etc. PowerBuilder 12.5, MS SQL Server 2010, MS Team Foundation Class, MS Visual Studio.

E24

8/2013 to 1/2014

Sr. PowerBuilder and SQL Developer

Planet Consulting, Lincoln, NE (project for TransFirst, Broomfield, CO)

Applications supporting electronic payments

Development and support of client-server applications for management of electronic payments with credit cards to merchants. PowerBuilder 12.5, MS SQL Server 2010, Team Foundation Class.

E23

12/12 to 8/2013

Sr. PowerBuilder and SQL Developer

Texas Department of Transportation, Austin, TX

Application for Management of Building Contracts

Development and support of client-server application for management of building contracts and payment to the vendors. PowerBuilder 12.5, Oracle 10g, Adaptive Server Anywhere, MKS SCC Integration.

E22

11/12 to 12/2012

Sr. Computer Programmer

Starz Entertainment LLC, Englewood, CO

Applications for Movie Distribution

Development and support of client-server application for distribution of movies. PowerBuilder 11.5, Adaptive Server Anywhere, Adaptive Server Enterprise, Subversion SCS, Tortoise.

E21

05/11 to 11/2012

Sr. Software Engineer

Stone River Insurance Solutions (formerly Fiserv), Denver, CO

PowerComp - Insurance Information System

Design, development, enhancement and support of client-server system for insurance industry (PowerBuilder 9, PFC, Oracle 9i and 10g, PL/SQL Developer, Rational Rose (UML), Erwin/ERX, Power Designer, Star Team).

E20

09/10 to 04/11

Sr. Software Engineer

Bank of America, Newark, DE (remote position, I worked from my home in Aurora, CO)

Customer Service Support System (related to credit cards)

Design, development, enhancement and support of a client-server system used by Bank of America customer service representatives working with clients having credit cards issued by Bank of America. (PowerBuilder 12.5, PFC, Oracle 9i and 10g, MS SQL Server, DB2 on IBM mainframe, .NET).

E19

03/10 to 09/10

Sr. Software Engineer

Stone River Insurance Solutions (formerly Fiserv), Denver, CO

PowerComp - Insurance Information System

Design, development, enhancement and support of client-server system for insurance industry (PowerBuilder 9, PFC, Oracle 9i and 10g, PL/SQL Developer, Rational Rose (UML), Erwin/ERX, Power Designer, Star Team).

E18

08/09 to 03/10

Computer Programmer

Colorado Department of Corrections, Colorado Springs, CO

Various Client-Server Applications

Design, development and support of various client-server applications. Implementation of recent changes in the Colorado law related to activity of Department of Corrections. PowerBuilder 11.5, PFC, Informix, Microsoft Visual Source Safe.

E17

07/09 to 08/09

Computer Programmer

Starz Entertainment LLC, Denver, CO

Applications for Movie Distribution

Development and support of client-server application for distribution of movies. PowerBuilder 11.5, Adaptive Server Anywhere, Adaptive Server Enterprise, Subversion SCS, Tortoise.

E16

09/08 to 12/08

Computer Programmer

Steel Dynamics, Inc., Columbia City, IN (Structural Steel and Rail Division)

Bundle Tracking Application

Gathering requirements, design and development of an application to track bundle modifications and to register and control re-bundling activity. Produced beams are packed in bundles for sale and delivery. Sometime it is necessary a bundle to be disassembled and new bundle(s) to be created to satisfy the sale order. These operations could include cutback, splitting, combining, scrapping of some pieces and adding additional pieces produced “from heat”. The Bundle Tracking application should register and manage all this activity, printing new Bundle labels, tracking of material loss, etc. This application was challenge for long period of time. PowerBuilder 10.5, PFC, Oracle 9i, Toad for Oracle 9.5, Surround SCM.

Corporate Customer Maintenance Application

Gathering requirements, design and development of an application to maintain correspondence between Division Level Customer Numbers and Corporate Level Customer Numbers. PowerBuilder 10.5, PFC, Oracle 9i, Toad for Oracle 9.5, Surround SCM.

E15

06/08 to 09/08

Computer Programmer

Kingsway America, Mobile, AL

Kingsway Information System (KIS)

Development and support of Kingsway Information System (KIS) – a PowerBuilder application for auto-insurance. PowerBuilder 9, MS SQL Server 2005, Jaguar, Surround SCM.

E14

09/06 to 05/08

Sr. Software Engineer

Fiserv Insurance Solutions (formerly InsureWorx), Denver, CO

PowerComp - Insurance Information System

Development and support of client-server system for insurance industry (PowerBuilder 7, 8, 9 and 10, PFC, PowerBuilder Distributed Programming, Jaguar CTS, Oracle Reports 6.1, Oracle 8i, 9i and 10g, PL/SQL Developer, Rational Rose (UML), Erwin/ERX, PowerDesigner, Star Team).

Migration of PowerComp application from PowerBuilder 7 to PowerBuilder 8, 9 and 10.

E13

06/06 to 09/06

Computer Programmer

City of Los Angeles, Taxation Office, Los Angeles, CA

LATAX Project

Development and support of 3-tier taxation system (PowerBuilder 8, Jaguar CTS, EAF Framework, Oracle 9i, PL/SQL Developer, Erwin/ERX, PVCS).

E12

06/05 to 06/06

Sr. Software Engineer

InsureWorx (formerly Taliant Software), Denver, CO

PowerComp - Insurance Information System

Development and support of client-server system for insurance industry (PowerBuilder 7, 8, 9 and 10, PFC, PowerBuilder Distributed Programming, Jaguar CTS, Oracle Reports 6.1, Oracle 8i and 10g, PL/SQL Developer, Rational Rose (UML), Erwin/ERX, PowerDesigner, Star Team).

Migration of PowerComp application from PowerBuilder 7 to PowerBuilder 8, 9 and 10.

E11

02/05 to 05/05

Computer Programmer

SoftSol Resources, Freemont, CA (End User: CalPERS, Sacramento, CA)

Various Applications for Portfolio Management (End User: CalPERS, Sacramento, CA)

Development and support of client-server applications for portfolio management (PowerBuilder 9, Oracle 9i, MS SQL Server 7 and 2000 (incl. Analysis Services/OLAP), Toad, Pervasive, Visio).

Data analysis and development of data warehousing components (OLAP)

Development and support of WEB applications for portfolio management (Java, JDeveloper 10g, SWING, servlets, JSP, BC4J, Tomcat, Oracle 9i, Toad, Visio).

Migration of PowerBuilder applications to Java (see above).

E10

03/03 to 01/05

Sr. Software Engineer

Taliant Software LLP, Denver, CO

PowerComp - Insurance Information System

Development and support of client-server system for insurance industry (PowerBuilder 7, 8 and 9, PFC, Oracle Reports 6.1, Oracle 8i, PL/SQL Developer, Rational Rose (UML), Erwin/ERX, PowerDesigner, Star Team).

Migration of PowerComp application from PowerBuilder 7 to PowerBuilder 8 and 9.

E9

02/02 to 03/03

Sr. Software Engineer

Computer Enterprises, Inc., Pittsburgh, PA, USA (End User: Taliant Software, Denver, CO)

PowerComp - Insurance Information System

Development and support of client-server system for insurance industry (PowerBuilder 7, PFC, Oracle Reports 6.1, Oracle 8i, PL/SQL Developer, Rational Rose (UML), Erwin/ERX, PowerDesigner, Star Team).

E8

10/01 to 01/02

President and Sr. Developer

AbleSoft, Inc., Aurora, CO, USA

Internet Voice Mail System Tapir (Version 2)

New version of Internet Voice Mail System Tapir with improved functionality.

Implementation SMTP and POP3 protocols for sending and receiving voice messages through the regular E-mail infrastructure to permit usage of Tapir servers without permanent IP-address (Perl, ASP).

PowerQ –Accounting System

Design, development and support of desktop accounting system (PowerBuilder 11.1, HelpMaker). Own implementation of OLAP architecture (cubes).

E7

10/00 to 10/01

Sr. Developer

IDOM, Inc., Newark, NJ, USA

DOC-Tracker Version 3 (remote position, I was working from my home in Aurora, CO)

Data modeling and database design of a very specific database structure intended to provide high level of flexibility and adjustment to requirements of different users (ERwin).

Development from A to Z of client-side application for data acquisition, data validation, data support, reporting (PowerBuilder, Crystal Reports), and imaging (PowerBuilder, PowerImage), stored procedures and triggers (MS SQL Server 7 and MS SQL Server 2000).

Development of data warehousing components based on MS SQL Server 7 OLAP and MS SQL Server 2000 Analysis Services.

United Nations Web Site for Bank of Paribas (remote position, I was working from my home in Aurora, CO)

Created couple of reports regarding some specific daily activities of Bank of Paribas (PowerBuilder, InfoMaker, and Crystal Reports).

Extended functionality of DOC-Tracker Version 2 for saving the reports in two different specific formats.

Designed and developed Java-applet to publish reports on the United Nations web-site (Java, HTML, XML, JavaScript).

RED Rover and OSCAR for McKesson HBOC (Work Location: Dallas, TX)

Migration of OSCAR from PowerBuilder 5 to PowerBuilder 6 and 7.

Architectural design of the RED Rover and web enabling of its functionality. Applied Rational Unified Process and J2EE. Analyzed Web.PB, Jaguar CTS, Perl, Java Servlets and Java Applets.

Designed the application protocol for interaction between a Java servlet and a client working in different environments (PowerBuilder application (OSCAR) and Web Browser).

Developed modifications to OSCAR for RED Rover functionality (PowerBuilder).

Developed a Java applet for Web RED Rover client (Java, HTML, XML and JavaScript).

Developed prototype back-end application (PowerBuilder Web.PB, Sybase SQL Anywhere, Oracle, and DB2) to test and demonstrate the protocol between RED Rover client and Java servlet (HTML, XML and JavaScript). It was necessary because development of the proposed Java servlet was supposed to be developed by another group.

Data pipelining between the existing Oracle database and prototype Sybase SQL Anywhere database (PowerBuilder).

DOC-Tracker Version 2 Imaging Facility (remote position, I was working from my home in Aurora, CO)

Added imaging functionality to the existing DOC-Tracker Version 2 to support scanners, acquisition, annotation, visualization of images, and storing images (PowerBuilder, PowerImage, and Crystal Reports).

SQR Report Manager and Wall Street Reports for State Street Bank, Boston (Work Location: Boston, MA)

Installed Oracle 8 and created a developer’s database. Loading data from production database to developer’s database.

Implementation of SQR (Brio.Report) reporting system for producing a set of reports for integration of State Street Bank data into existing Wall Street system.

Migrating some existing reports from Crystal Reports to Brio.Report.

Developed SQR Report Manager to conveniently manage and execute SQR-reports.

Migrated data from existing Oracle.

DOC-Tracker Version 2 for Dresdner Bank (remote position, I was working from my home in Aurora, CO)

Modification of DOC-Tracker Version database structure for specific needs of Dresdner Bank (ERwin, MS SQL Server).

Modification of DOC-Tracker Version 2 to address the database changes (see above) and specific needs of Dresdner Bank (PowerBuilder, Crystal Reports).

Time Budgeting and Reporting System (TBRS) for Circle.com (remote position, I was working from my home in Aurora, CO)

Data modeling and logical design of TBRS database structure (ERwin, MS SQL Server).

Installation of MS SQL Server and physical creation of TBRS database and it’s structure.

Development from A to Z of TBRS – GUI application (PowerBuilder), stored procedures and triggers (MS SQL Server).

E6

07/99 to 10/00

Sr. Technological Specialist/Expert

Cambridge Technology Partners (MA), Inc., Cambridge, MA, USA. (Work Location: Aurora, CO)

National-Wide Online System for Truck Rentals (Ryder TRS)

Performance monitoring and tuning of Dealer Processing - a set of huge stored procedure and triggers for nightly validation and processing of incoming data (Oracle, PVCS).

Fixing a lot of normalization, referential integrity, performance and reliability issues in Dealer Processing (Oracle, ERwin, SQL Navigator, PVCS).

Design of some specific parts of the database structure (ERwin).

Entirely re-design and development of entirely new version of Dealer Processing decreasing the processing time from couple of hours to couple of minutes. Applied specific system architecture called Status Reflection (Oracle, ERwin, SQL Navigator, SQL*Loader, PVCS).

Support and essential improvement of various front-end applications for data manipulation (PowerBuilder, Oracle, Oracle Financial, PVCS).

Development of Web-enabled applications (Java, HTML, JavaScript, Jaguar CTS).

Development of 3-tier systems and Web-enabled applications for E-Commerce (Jaguar CTS, PowerJ, PowerBuilder, ActiveX).

Development and support of Unix-scripts for managing of time-controlled Unix processes.

E5

08/98 to 06/99

PowerBuilder Developer

IDOM, Inc., Newark, NJ, USA

Criminal History System for Department of Public Safety and Corrections of the State of Louisiana (Work Location: Baton Rouge, LA)

Analyzing and essential improvement of referential integrity and normalization of Criminal History System (ERwin, Oracle).

Repairing a lot of inconsistent data in accordance with the improved referential integrity (Oracle, SQL Navigator, DBArtisan, TOAD)

Performance monitoring and tuning of Criminal History Database (Oracle). Fixing of various performance issues.

Developed and implemented back-up/restore procedures (Oracle).

Support and essential improvement of various front-end applications for data manipulation (PowerBuilder, Oracle).

Migration of various front-end applications from PowerBuilder 5 to PowerBuilder 7.

Architectural design of a future Web-enabled application based on PowerBuilder 7, Jaguar CTS 3 and Java.

Internet Voice Mail System Tapir (Hobby Project) (Work Location: Aurora, CO)

Developed a set of PowerBuilder applications for: (a) acquisition and recording of voice messages; (b) sending the voice message file through the Internet; (c) calling the receiver and playing the voice message (PowerBuilder, MS Telephony API, Sybase SQL Anywhere).

Developed ActiveX controls to support the TAPI callback function in PowerBuilder environment (Visual C/C++ and Visual Basic).

Developed Perl scripts for implementation SMTP and POP3 protocols for sending and receiving voice messages through the regular E-mail infrastructure to permit usage of Tapir servers without permanent IP-address.

Credit Memo System for Mattel Toys Corporation (Work Location: Torrance, CA)

Developed a front-end application for Credit Memos (PowerBuilder).

Improvement of referential integrity and normalization of existing database (Sybase System 11).

Information System for the Legal Office of Nissan North America (Work Location: Torrance, CA)

Developed the main front-end application (PowerBuilder, LawPack).

Developed various stored procedures and triggers (MS SQL Server).

Developed various reports and integrating of reports into LawPack environment (InfoMaker).

E4 - deleted

E3

02/96 to 10/97

PowerBuilder Programmer

IDOM, Inc., Newark, NJ, USA

GlobalAdvantage (Work Location: Dallas, TX)

Developed essential parts of the main front-end application (PowerBuilder, ObjectStart, and PVCS).

Logical design of some specific parts of the GlobalAdvantage database (ERwin, Sybase System 10, and Oracle).

Participation in back-up/recovery and other physical support activity of then database (Oracle).

Development and implementation (ERwin, Oracle triggers) of new conception for database design supporting time dependencies (Time Based Referential Integrity).

E1 and E2 - deleted

EDUCATION:

PhD in Computer Science

Central Institute of Computing Technology, Sofia, Bulgaria; 1977

Bachelor/Master in Electrical Engineering

Technical University, Sofia, Bulgaria; 1970

PROFESSIONAL CERTIFICATIONS:

Certified PowerBuilder 6 Developer (2000).

Digital Think’s E-Commerce Fundamentals (2000).

Certified PowerBuilder 4 Developer (1997).

TRAINING COURSES IN USA:

SL-314 WEB Component Development with Servlet and JSP Technology (2005, ExitCertified Authorized Sun Education Center, Sacramento, CA).

E-Commerce Fundamentals (2000, Digital Think, Cambridge Technology Partners)

New Economy Fundamentals (2000, Digital Think, Cambridge Technology Partners)

PowerBuilder 5 Distributed Programming (1997, Deloitte & Touche)

Building Applications Using the PowerBuilder Foundation Class Library (1997, Sybase)

Building Object Oriented Applications in PowerBuilder (1997, Sybase)

Moving from PowerBuilder 4.0 to 5.0 (1997, Sybase)

Impromptu (Cognos, 1996)

REFERENCES: Available upon request.

VISA STATUS: USA citizen.

Contact this candidate