Andrey Levichev

OBJECTIVE

Experienced software engineer is looking for a C#/.NET contract position in New York area. Available to start on 6/5/06.

SUMMARY

• 9 years of experience in development of commercial applications.
• Proficiency in full application development lifecycle – analysis, design, coding, testing, support.
• 4 years of working experience with C#, .NET, ASP.NET, WinForms; background in C++/COM/ATL/MFC development; deep understanding of relational databases such as Oracle and SQL Server; extensive experience with web development.
• Problem solver and good team player. Can get things done. Excellent communication skills with business and technical people.
• Financial knowledge including fixed income securities, hedge funds and derivatives.

TECHNICAL SKILLS

WORK EXPERIENCE

As a lead programmer in software development startup, designed and developed Names & Brands - a online service that helps people to come up with business names such as company or brand names. This service is used by entrepreneurs looking for a new company name or by marketing professionals who need names for new products and services. Names & Brands uses sophisticated algorithms to come up with nice-sounding and trademarkable names.

Achievements:

• Performed market research, designed algorithms for generating business names.
• Coded program logic in C# using SQL Server 2005 as back end, created and executed test scenarios.
• Designed and developed a e-commerce web site and order processing system using ASP.NET and SQL Server 2005. Integrated with PayPal and 2Checkout to perform credit card processing.

Technologies: C#, .NET, Visual Studio 2005, ASP.NET 2.0, ADO.NET, SQL Server 2005

Open Solutions is a leading provider of financial software for banks and credit unions. In an effort to standardize on .NET platform Open Solutions hired an offshore company to convert an existing CRM application called cView from Java to .NET. This is a complex ASP.NET web application that is designed to work with Oracle or SQL Server database.

Responsibilities:

• In a team with another developer fixed bugs in the code delivered by the offshore team to bring the quality to the “production ready” level.
• Communicated with offshore developers to coordinate work.
• Developed new features after production release.
• Provided support for a data migration tool designed to prepare data for cView by converting it from the legacy applications.

Achievements:

• Rewrote poorly designed report generation module of cView application to improve performance and stability, especially for large reports. Previously, report generator stored data in memory and under heavy load web server often ran out of memory causing data loss and user frustration.
• Moved report generation from memory to Oracle database. Changed the program logic to prepare report data using temporary tables and SQL statements. This solved memory consumption problems and improved performance.
• Wrote sophisticated C# and SQL code to create reports from multiple queries, calculate computed fields and subtotals, perform paging and value formatting. Performed report computations using nested queries and Oracle analytical functions.
• Rewrote non-functional module for PDF report generation. Wrote C# code to read report data and render a PDF document using DynamicPDF library.
• During two months fixed more than a hundred defects in C# and PL/SQL code. Met the timeframe and quality requirements for delivering the production release.
• Fixed critical bugs in the data conversion tool. Timely resolutions of the problems helped convince big clients to purchase the main cView product.

Technologies: C#, .NET, Visual Studio.NET 2003, ASP.NET, ADO.NET, Oracle 9i – 10g, PL/SQL

Cendant Mobility is a world leader in providing employee relocation services. Its clients include companies such as GE and IBM.

Responsibilities:

• Participated in migration of business critical web application to a new enterprise database.
• Worked with offshore team and business analysts to make sure that offshore code meets the requirements and doesn’t contain defects.

Achievements:

• Rewrote 70 stored procedures in Transact-SQL when migrating existing application to a new database.
• Wrote sophisticated SQL queries to verify the results of data conversion performed by offshore team.
• Adapted C# and legacy C++ code to use the new database.
• Created 5 new screens for ASP.NET web application. Created middleware components in C# using technologies such as remoting, ADO.NET and Transact-SQL.
• Fixed defects and performed builds using NANT scripts.

Technologies: C#, .NET, Visual Studio.NET 2003, SQL Server 2000, Transact-SQL, ASP.NET, ADO.NET, NANT

As a lead programmer in software development startup, designed and developed a product called ADO.NET Express (www.adonetexpress.com). This product helps increase the productivity of .NET developers who write a lot of data access code. ADO.NET Express is an add-in for Visual Studio.NET that generates ADO.NET code for calling stored procedures and executing common types of SQL statements. It supports C#/VB.NET and SQL Server/Oracle.

Achievements:

• Performed market research and created technical design specifications.
• Coded program logic, wrote about 350Kbytes of sophisticated C# code in two months.
• Created and executed test scenarios.
• Designed and developed an e-commerce web site and order processing system using ASP.NET and SQL Server.

Technologies: Visual Studio.NET, C#, VB.NET, WinForms, ADO.NET, ASP.NET, SQL Server 2000, Oracle 8i - 10g, HTML, JavaScript.

Cendant Mobility is a world leader in providing employee relocation services. Its clients include companies such as GE and IBM.

Responsibilities:

• Participated in development of relocation consultant’s web portal. This portal is a major effort of Cendant Mobility to consolidate its existing applications, add new functionality and rewrite legacy applications using C# and .NET framework.
• Participated in creation of architecture guidelines for in-house developers and contractors including authentication/authorization infrastructure; guidelines for data access, COM+ transactions and remoting; guidelines for implementing optimistic concurrency.

Achievements:

• Using C# created an authorization component to control access to web application based on user’s roles.
• Created a “codes component” to get data from code tables and cache it in the application state.
• Developed ASP.NET pages and business logic components using C# and ADO.NET.
• Wrote technical design specifications with UML diagrams based on information from the use-cases.
• Wrote stored procedures in Transact-SQL for SQL Server 2000.
• Developed enterprise application integration solution using BizTalk 2002 to exchange data between invoice entry and accounting applications. Created orchestrations to represent business processes. Coded message processing logic using C# and Visual Studio.NET. Used XSLT for data transformation.

Technologies: C#, .NET, Visual Studio.NET 2003, SQL Server 2000, Transact-SQL, ASP.NET, ADO.NET, BizTalk 2002, XML, XSLT.

Participated in development of a web-based application that allowed US Customs to inspect UPS packages imported into the US more efficiently.

• Developed ASP pages with VBScript, business logic components with Visual C++, COM+ and ATL. Used ADO for data access.
• Wrote stored procedures and queries in PL/SQL for Oracle 8.
• Used XML/XSL to create a web page with a table that can be sorted on a client without making requests to web server.

Using C# and Visual Studio.NET, developed a program to perform analysis of data obtained from sensors on an oil drilling rig. Developed sophisticated user interface using WinForms and third-party data grid control. Wrote code to perform calculations and store results in SQL Server database using ADO.NET.

Participated in development of software to manage Worldport – world’s biggest parcel sorting facility built by UPS in Louisville, KY.

• Developed mission critical software that published information about how parcels must be sorted to the automated sorting equipment such as conveyor belts and optical address scanners.
• Created a multithreaded Windows service in Visual C++ that received data using sockets and published it to the automated sorting equipment via UPS custom messaging software.
• Used events and critical sections for thread synchronization. Applied techniques like thread pooling to improve performance and scalability.
• Using Visual C++, COM, ATL and ADO developed business logic and data access components for sort plan creation application. Wrote SQL queries and stored procedures in PL/SQL for Oracle 8.
• Improved performance of existing application by 20 times by applying techniques like multithreading, batch inserts and prepared SQL statements.
• Performed object-oriented design by creating UML diagrams in Rational Rose.
• Wrote client/server Visual Basic application for time reporting and project management.

Past experience is available on request.

EDUCATION & CERTIFICATIONS

NOTES

Authorized to work in the US (Green Card). References available on request.