Alexander Borodin

5740 Lunsford Rd., #2124

Plano, TX  75024

(972) 898-6190  alexander@borodin.info

 

 

SUMMARY:             Software engineer with 6 years of design and development experience on J2EE and .NET platforms; experience spans full development cycle: business requirement analysis, design, development, implementation and maintenance.

 

 

TECHNOLOGY EXPERIENCE:

 

Technologies and Frameworks:

J2EE:

Servlets/JSP

JDBC

EJB

.NET:

ASP.NET

ADO.NET

O/R mapping:

Hibernate/NHibernate

iBATIS

Struts

OpenPGP

POI

Reporting:

Active Reports

Crystal Reports

Languages:

Java

C#

Perl

 

Web/Database/Application Servers:

Apache HTTPD

Apache Tomcat

MySQL

PostgreSQL

Microsoft IIS

Microsoft SQL Server

 

Development Platforms:

Netbeans

ItelliJ IDEA

Visual Studio 2005

 

 

WORK

EXPERIENCE:        C. Pitman Baker & Assoc.

Employed:  from January 2006 through present.

Position held: Software Engineering Consultant

Task summary:

-       designed and developed software from initial requirements documented in use cases

-       communicated with clients directly, analyzing feedback to formulate project requirement and design changes

-       provided technical guidance to development team

-       worked on improving development processes in-house by contributing to re-usable components, training, and process definition

 

Major project: GroupOne Background Check System

Role: worked from an initial set of use cases to architect the system; interacted with client to refine requirements and integrate feedback in an iterative development process.

Environment: ASP.NET 2.0 web application developed in C#; data access performed through NHibernate 1.2 O/R mapping framework.

Background:  The client provides background check services to health care industry customers; due to the dynamic nature of the services offered, the client desired a data-driven system, which would allow user-definition of the background checks offered; the system need to facilitate employee, vendor, and end-user functionality.

Description: The web-based portal allows administrators to fully configure the system (including research services offered, pricing and cost, customer data, etc.), researchers and vendors to track and process research tasks, and healthcare clients to submit and review background research requests; the system manages the full lifecycle of the research process and data involved - submission, research, reporting, and dispute resolution.

 

Major project: DFW Hospital Council Salary Survey

Role: worked from an initial set of use cases to architect and develop the system.

Environment: ASP.NET 2.0 web application developed in C#.

Background:  The client provides statistical analysis of healthcare job salaries to its members;  salary data is provided by each specific member, in return for statistical summaries of the data for all members; strict rules govern the validity and lifespan of the data submitted and disclosed.

Description: The web-based portal allows healthcare members to submit their individual salary data, and request statistical reports; administrators are able to administrate members and rules governing the validity of data.

 

Other projects:

-       legacy data migration for a major project roll-out

-       Change Request implementation and maintenance for a variety of applications in production

 

 

Available Mortgage Funding, LLC

Employed:  from November 2001 through present.

Position held: Senior Developer

Task summary:  As the sole developer, analyze business processes in place to expose development needs; work with various departments to define requirements and design programming solutions; develop, test, and implement applications; iteratively enhance and maintain applications.

 

 

Major project: Broker Customer Portal

Role: researched mortgage loan components and business lifecycle; designed an OO model of the mortgage loan and its various components; abstracted and integrated this domain model with companyÕs legacy mortgage software - DataTrac, and its SQL Server database; developed Struts actions and JSP pages for the user interface; deployed web application; maintained application, adding requested features and changes.

Environment: application developed in Java; data access performed via JDBC; Struts actions and JSP pages served by Apache Tomcat integrated with IIS, hosted on a Windows 2003 Server. 

Background:  This company is a mortgage lender; its customers are real-estate brokers who submit loans to be funded; as a particular loan gets processed, much peripheral information is assimilated about the borrowers, property, and loan terms; brokers desire access to this information, and their loan status real-time.

Description: The web application allows a broker to log in via the company website, and gain access to their active loan pipeline information; major features include pipeline search, and individual loan detail.

 

Major project: B2B exchange with First Collateral Services, Inc.

Role:  researched First CollateralÕs B2B interface; designed and developed application to extract, encrypt and transmit needed data, and receive, decrypt, process and distribute returned reports; developed Struts/JSP web interface to expose this functionality to employees.

Environment:  application written in Java; used the iBATIS O/R mapping framework to access the SQL Server database; used open-source PGP framework to encrypt/decrypt data transmissions; used Struts/JSP web layer for user interface.

Background:  First Collateral Services is the bank providing this companyÕs warehouse line. When a loan needs to be funded, this company communicates loan details to First Collateral, which in turn wires the funds.  This B2B application automated the exchange of this information.

Description:  web user interface includes funding queue management, b2b transmission initiation, search of archived transmission details and confirmation reports; application gathers funding queue details, packages, encrypts and transmits this data to First Collateral; transmission details are archived, along with confirmation reports returned.

 

Major project: Commission management/reporting tool

Role:  researched sales commission structures, and commission calculation processes in place; developed application to administer employeesÕ commission plans, calculate commissions, and distribute/archive commission reports for the accounting department.

Environment:  application written in Java; used the iBATIS O/R mapping framework to access the SQL Server database; used Struts/JSP web layer for user interface; used Jakarta POI framework to generate Microsoft Excel reports.

Background:  Account executives get paid commission for every loan they bring to this company; the commission plans are extensive, considering volume levels, loan program types, lien types, and other factors.  These calculations had to be performed manually in the past.

Description:  Web user interface includes commissioned employee roster and commission plan management, employee and department commission reporting, archiving and retrieval; application gathers production information and commission plan details, to produce per employee and department wide compensation reports.

 

Major project: Windows Server administration

Role:  Administer Microsoft IIS, SQL Server, Exchange Server, ISA Server, Terminal Services, and other components of Microsoft Small Business Server environment.

Environment: Dell PowerEdge servers running Windows 2003 Server.  The systems support around 40 internal and remote users.

 

Other projects:

- various web-based tools exposed through the company intranet portal

- various reporting using Crystal Reports

- migration from SBS 4.5 to SBS 2000, SBS 2000 to SBS 2003

- migration to Terminal Services environment

 

 

Citizens Communications, Inc.

Employed:  from April 2001 through November 2001

Position held: Web Developer/UNIX Administrator

Task summary: As part of a team of 8 developers and administrators, developed web-based tools to enhance/automate administration of web, email, DNS, database, and other services for companyÕs Internet Access division.

 

Major project: MySQL driven Radius log storage/query tool

Role:  designed a database to hold Cistron Radius log data; wrote scripts to import 12 months of logs into the database; wrote web-based tools to provide querying capabilities.

Environment:  used a MySQL database to store Radius log records;  used Perl scripts to parse and load text logs, and Perl CGI to provide web-based search capabilities for this data.

Background: Prompted by a court subpoena for user access information, this project was requested to allow easy access and search capabilities of Radius log data, which holds information about user access sessions.

Description:  Once the text logs were imported, the web tools allowed searching of records; based on supplied combination of user-name, time, IP address, etc., matching user access sessions could be extracted.

 

Major project: UNIX system administration

Role:  performed general maintenance of web, email, DNS, database, and other servers:  prepared and deployed servers, maintained DNS, performed tape backups, and provided on-call support; developed Perl scripts to automate administrative tasks.

Environment: DEC/Compaq servers running Tru64 and RedHat Linux;  servers supported over 71,000 customers, and hosted every service needed to create and provision the Internet access accounts (billing, authentication, email, etc.).

 

Other projects:

- Big Brotherª web-based configuration tools

- MySQL/Perl driven DNS record maintenance

 

 

Worldcom, Inc.

Employed:  from June 1999 through March 2001.

Position held: Web Developer.

Task summary:  Working with a second developer, designed, developed, and maintained various web-based tools to assist engineers in Data Systems Integration and Verification lab.

 

Major project: Trouble Ticket Manager

Role:  Oversaw the complete life-cycle of the application:  assessed the functional requirements; designed the structure and logic of trouble tickets; developed the web-based UI for reporting and tracking trouble tickets, as well as the persistence, retrieval, and query code; tested the application and launched into production; maintained the application and added requested features; presented the Trouble Ticket Manager to other groups in the company, and deployed the application for other groups, after its success internally in the Data Systems Integration and Verification lab.

Environment:  The Trouble Ticket Manager is a collection of 30+ CGI scripts, written in Perl; data was originally stored in flat files, later an Oracle 8i database; application served by the Apache web server, on a Sun Ultra SPARC workstation, running Solaris 8; system supported 50 end-users with login access, as well as over 150 email notification contacts.

Background: Prior to the development of the Trouble Ticket Manager, tickets opened against outside vendor products - RVAÕs - were documented and tracked manually via email: individual engineers were responsible for composing ticket structure, keeping track of ticket count, and notifying everyone concerned of progress on a particular problem.

Description:  The Trouble Ticket Manager provided a web-based, form-driven interface for reporting, updating, and closing tickets; sending out email notification of changes to a ticket; and running queries on ticket content and status.  The purpose of the Trouble Ticket Manager was to standardize and centralize the reporting, storage, and tracking of tickets; and to provide data for statistical analysis of ticket content and status;  the web-based application allowed access from any terminal with Internet access - from workstations in the lab, to PCÕs in cubicles.

 

Other projects:

- web-based file exchange system.

- web-based employee directory.

 

 

Web America Networks, Inc.

                                    Employed:  from July 1997 through May 1999.

                                    Positions held:

Customer Service: selling, servicing dial-up Internet accounts.

                                                BizPlace Operations: web design; quality control.

Billing:  Tracing, rectifying billing errors; issuing credits; VISA, MASTERCARD, VARTEC liaison for company.

Technical Support:  troubleshooting Internet connection problems for Win95/98 customers.

Network Operations: monitoring server activity; minor troubleshooting; replying to technical support e-mail.

 

 

SELECTED

INDEPENDENT

CONSULTING:       ISI Training Services

                                    Employed:  November 2005.

                                    Project:  web-based customer portal

Role:  designed and developed web application facilitating user registration, approval, and access to secured sections of the web site, and administration of user accounts and calendar events.

Environment:  ASP.NET pages hosted on Microsoft IIS, using ADO.NET for data access to an SQL Server.

 

 

Dakotas Restaurant

Employed:  September 2005.

Project:  web-based menu, news, events and recipe management

Role:  designed and developed web application to administrate restaurant menus, news, events, and recipes in an SQL Server database, and expose this information on the clientÕs public website.

Environment:  ASP.NET pages hosted on Microsoft IIS, using ADO.NET for data access to an SQL Server

 

 

Pony Printing

                                    Employed:  December 2003.

                                    Project:  web-based artwork gallery exposition and management

Role:  designed and developed database driven web-based artwork gallery, including artwork management, keyword search and category browsing, and thumbnail previews.

Environment:  application written in Java; iBATIS O/R mapping framework employed for data access to a PostgreSQL database server; Struts actions and JSP pages exposed functionally in a web-based user-interface.

 

 

Dallas Swing Dance Society

                                    Employed:  December 2003

                                    Project:  Dallas Lindy Exchange 2003 website

Role: worked with customer to design site theme, structure, layout; designed and developed web application and database to accept and manage registrations, integrate with PayPal web services to collect payment, and query/export registration records.

Environment:  application written in Java; servlets and JSP pages served by Apache Tomcat, integrated with Apache web server, hosted on a Linux server.

 

 

Dollar Auto

                                    Employed: September 2002.

                                    Project:  web-based inventory access, management

Role: designed database to store car, customer, and sale records; developed servlets and JSP pages to search and manage dealership inventory; deployed database and applications to customerÕs Application Service Provider.

Environment:  application written in Java; servlets and JSP pages served by Macromedia JRun, integrated with IIS, hosted on a Windows 2000 Server.

 

 

Land the Job

                                    Employed: March 2002.

                                    Project:  Land the Job website

Role:  worked with customer to design website structure and layout; designed and developed web application and database to facilitate online resume-preparation services, including collection of customer information, integration with PayPal web services to collect payment, and customer interaction.

Environment:  DHTML; Perl CGI scripts; MySQL database; served by Apache web server, hosted on a Linux server.

 

 

Career Sports, Inc.

                                    Employed:  from February 2000 through March 2000.

                                    Project:  Career Sports, Inc. website.

Role:  designed the layout and structure of the company website; assessed the requirements for, designed and developed a login-based authentication system, web-based resume creation, hosting, and management tool, and query tools used to search resume account information.

Environment:  20+ HTML pages, and 90+ Perl CGI scripts, protected by a custom authentication scheme, served by Microsoft IIS, interfacing with Microsoft SQL Server, hosted on a Windows NT server; website supported over 250 user login accounts, and 10 query login accounts.

 

 

EDUCATION:          University of Texas at Dallas

Working toward: B.S. in Software Engineering

Sun Education:  Introduction to JAVA

Oracle Education:  Introduction to Oracle:  SQL and PL/SQL