Andrew Lyzlov

Millbrae, CA ***** tel. 650-***-**** email: acafhh@r.postjobfree.com

Objective: Position of Software Developer / Analyst.

Summary: Software Developer with 7+ years of experience with Microsoft technologies

including SQL Server and Visual Studio. Have working experience in all phases of software

development including design, coding, testing and deployment. Able to work under tight deadlines and

rapidly changing priorities. Liaise with business analysts, project and QA managers and user

representatives in application design and document reviews. Work well individually or within a team

environment. Well organized, and capable to quickly learn new technical skills and work within groups.

Technical Skills:

Programming: T-SQL, VB.NET, Visual Basic 6.0, VBA, C#, ASP.NET, C/C++, Java,

VB Script, JavaScript, HTML, XML, ASP, Ruby (basics)

Software: MS Visual Studio 2008 / 6.0, TFS, MS Office 2003-2012, Visio 2007, MS

SharePoint, Beyond Compare 3, SnagIt, Bugzilla, Borland Delphi, Jira,

YouTrack

Networking: HTTP(S), TCP/IP, UDP, FTP, LAN, WAN, POP, IMAP/POP3, DNS, DHCP

RDBMS: MS SQL Server 2008/2012, Oracle 10, MySQL 5.5

Employment History:

McKesson Corp. San Francisco, California

February 2012 ? Present SQL Server Operations Engineer (contractor)

? Responsible for running, tuning, on-going maintenance and support of SQL Server Applications

that generate Supplier Rebates in monthly amount of 200 million dollars in Production environment.

? Managing a team of 5 people responsible for eliminating a backlog of 2000 Issues for Prior

Period Adjustment calculations. Maintaining and supporting the runs on 2 Servers and 5 Virtual

machines.

? Modifying, testing and executing MS SQL Server objects such as stored procedures, views,

triggers, functions, jobs on a scheduled basis, and ad hock querying. Performing data analysis;

running and testing of the reports using SSRS. Gathering business requirements from accounting

department. Preparing Bills, Journal Entries, and billing backup. Populating and retrieving data using

SSIS ? running existing and creating new packages. Working on data issues using SharePoint Server.

Environment: MS SQL Server 2008/2012, MS Visual Studio 2008/2012, TFS

?

Danielson Services Limited, Nicosia, Cyprus

January 2008 ? October 2011 Financial Analyst / IT Consultant

? Designed and implemented database of client?s group of companies? liabilities using SQL Server

2008. Designed advanced queries and stored procedures. This effort resulted in the idea and

implementation of automated payment system which was released in VB.NET. Optimized day-to-day

work using MS Access and advanced Excel techniques including Macros and VBA.

? Worked in group responsible for creating and optimizing of financial flows: drawing up and

repayment of Loans, payment of interests, increase of share capital, dividend payments, promissory

notes payments, etc. Prepared, and approved Loan Agreements with and between our clients.

Arranged and controlled the executions of payments under Loan and Sales-Purchase Agreements.

Reviewed financial statements, trial balances, sales and activity reports.

? Environment: MS Visual Studio .NET 2008, MS SQL Server 2008, MS Access, MS Office

2003/2010, Quickbooks, 1C.

LLC ?Publishing House Optsion Moscow, Russia

April 2005 - December 2007 Software Developer

? Designed and implemented software application which served as a reference catalogue of

construction elements using VB.NET and SQL Server 2000/2005. Designed both interface and

database. This application helped users (appraisers) to get faster and easier access to reference data.

Implemented printable exports of data into Excel and PDF. Participated in preparation of print

catalogues. Supported previously developed application written in Borland Delphi and MS Access

2000. Merged existing databases. Joined data from MS Excel files into SQL Server database using

VBA technics. Designed and implemented the software system for job accounting and project

management using Access 2003. Worked in close collaboration with appraisers applying practically

VBA in Excel sheets and preforming selection and sorting in Access. Consulted the users on Excel

matters like functions, macros, and optimization. Created and maintained Q&A reference file on

reference catalogue application and MS Excel and Access.

? Environment: MS Visual Studio .NET 2003/2005, Visual Basic 6.0, MS SQL Server 2000/2005,

MS Office 2003, Borland Delphi.

LLC Business Plus, Moscow, Russia

October 2003 - April 2005 Junior Programmer / QA Engineer

? Participated in testing of client/server applications. Designed appropriate test cases to provide

optimal test coverage. Performed black-box testing and white-box testing. Reviewed and analyzed

system?s functional specifications. Developed and implemented test plans. Wrote and executed test

cases for acceptance and regression tests. Worked closely with development team to accurately

classify, describe and monitor product engineering problems in the corporate tracking system

? Environment: MS Visual Studio 6.0, Visual Source Safe, Windows 2000

LaSalle College International Toronto Toronto, Canada

March 2003 ? September 2003 Computer Programmer (internship)

? Modified college database, added several tables of MS Access. Designed and implemented

several graphical interfaces for workstations of different departments using Visual Basic allowing

interaction with the college DB. Created several code examples using Java AWT/Swing and examples

of multithreading applications.

? Environment: MS Windows 2000, MS Access, MS Visual Studio 6.0, BlueJ.

Education:

March 2012 Computer Educational Center San Francisco, CA

Advanced Quality Assurance Engineering

June 2005 LaSalle College International Toronto Toronto, Canada

Diploma in Computer Programming and Information Technology

June 2003 Moscow State Technological University ?Stankin? Moscow, Russia

BS (Engineer of Computer Science) (GPA: 3.8)

Languages:

? English ? fluent;

? Russian ? native

Contact this candidate