Software Engineer / SQL Server DBA

TECHNICAL HIGHLIGHTS: Software and Database Design (14 yrs), C/C++/C#(12 yrs),
SQL Server Development and Administration (10 yrs), Microsoft Certified SQL Server DBA.

SUMMARY: Expert software engineer and database architect with strong analytical skills and ability to translate business level requirements and specifications into detailed system design and architecture in the scientific, software or financial development fields.

QUALIFICATIONS: Have over 15 years of enterprise application development experience in C++/.NET and Java environments, with strong knowledge of computer technologies, relational database design and implementation, object-oriented programming and software creation methodologies. As a consultant, gained experience in the full cycle of software and database systems product development and re-engineering, networks and hardware infrastructure planning and deployment, creation of complex Internet-based systems.

Languages: C/C++/C#/VB(.NET/WinForms), PHP, Java, JavaScript, Perl/shell scripting.

Databases: Design, development and administration - SQL Server (6.5, 7.0, 2000-2008) - DTS, SSIS, SSRS, CLR. Sybase, Postgres 7.x, mySQL, Oracle 8i.

Operating Systems: Windows Server (2003,2008), Linux (Red Hat, Suse, Android), Solaris, FreeBSD, BSDi.

System Software: IIS (2.0-7.0)-based web services, .NET environment, LAMP stack, Exchange Server (2005,2007,2010), custom smtp servers, apache, transactional systems, open source software, WordPress, Drupal, dashCommerce, DotNetNuke.

Development Tools /Environments: Microsoft Visual C++/C# (4.0-6.0, 2005/2008), oss/gcc, Rational Rose, Together, Microsoft Visio, ERStudio, Data Architect, Jbuilder (6.0-7.0), Eclipse, KDevelop, Visual SourceSafe.

Technologies: .NET (2.0-3.5), MSVC (WIN32, ATL, COM/COM+, ADO.NET, ISAPI, ODBC, MFC, STL), J2EE (EJB,JMS, JDBC, RMI, JSP, JNI, servlets, JSP/ASP, SOAP/web services, device driver development (Linux,Windows NT).

Protocols/Networking: TCP/IP, SNMP, RFC-compliant (SMTP, POP3, IMAP, LDAP), knowledge of firewalls, methods & algorithms required to implement various levels of secure computing environments.

EDUCATION: 1995-2000 - BS degree in Computer Science (Software Engineering) from Brooklyn College

EXPERIENCE - Consulting projects:

Confidential, October 2007-present
President

Over the last 5 years executed number web-related .NET(2.0, 3.5)/Microsoft SQL server, LAMP and other consulting projects for various clients. Building innovative, easy to use and navigate interfaces using ASP.net AjaxControlToolKit as well as a number of 3-rd party off-the-shelf controls ( Exchange, Chat etc. ) to assemble unique functionality and interoperability into workgroup collaboration applications. Real-time information delivery mechanisms and customized SQL server-based solutions developed around AJAX and JSON, dealing with significant amounts of information. Mobile devices interaction, simple, secure and effective solutions to share and use internal workspace tools and information in the office and on the go. CMS/E-commerce projects, intranet and internet web applications, Win Forms applications.

Confidential, May 2006-May 2007
Consultant

As part of the Alliance consulting team performed support and development of the Moody's Investor Services billing system. Visual C++ 6.0 with Sybase-based (700 tables, 1200 stored procedures) system required detailed knowledge of the business to maintain and develop the application. Over 12-month period gained understanding of the trade necessary to keep the system up and running and keep demanding business users happy.

Confidential, December 2002-May 2006
Technical Lead

Designed, implemented and supported number of databases/ecommerce systems for various clients - March of Dimes, Babyage.com, Agora Media. Responsibilities included MSSQL Server (2000, 2003) development, maintenance and integration of the existing data with the new products and services. Technical support for multiple application development groups in QA and production environments. Schema design, interfaces, backup/recovery plans, troubleshooting performance issues, tuning queries and execution of the stored procedures, 24/7 availability, clustering, locks, queues, load balancing, replication policies. At the same time continued to support and develop the .NET and VC++ based code from number of clients.

Confidential, January-December 2002
System Architect/Development Lead

Served as project lead in the development of scalable multi-tiered credit-card processing engine - created the overall system architecture, J2EE framework and database design. Physical and logical layouts of the databases, data access and data integrity layers for Postgres/MySQL and messaging facilities. Backend consisted of 4 logical databases with over 350 tables and offered expandable structure, and a reliable and secure processing environment. Overall system consisted of a complex mixture of application servers, JMS servers, DB and web servers with a heavy accent on security and reliability concerns. As project lead was extensively involved in interactions with clients, software specifications, project scheduling and documentation of the system. Created presentations, charts, use cases and was responsible for other project flow-related tasks. Software and system design was created with the aid of Together and Rational Rose and database design - with DataArchitect. The resulting secure, reliable, scalable J2EE-based (EJB, JMS, JDBC, XML) distributed system running RedHat Linux, Apache, Websphere, Jboss, PostGres/MsSQL. Initial requirement for the application - 50 credit-card transactions per second at peak loads.

Confidential, July-December 2001
Consultant

Designed and developed extensions for Summit - X-Windows trading software developed with C++. Using Perl and C++ implemented a cross-platform solution to enhance application\'s reporting abilities and import/export modules. Required knowledge of finance and technical abilities to analyze existing architecture and find quick and efficient solution. Sybase, Oracle 8i, Solaris-based development.

Confidential, January-July 2001
Sr. Consultant

As hands-on System Architect in a consulting team of 4 developers, designed and developed an application to perform automated compliance testing of a complex message routing system. Responsibilities included analysis of existing C-based Unix software with multiple code branches, creation of software specifications, system design, and development of testing scenarios. The resulting solution allowed the company to simplify and to automate system compliance verification for various Wireless/Internet protocols and specifications (WAP, WMAPI, SMPP, SMTP. Implemented a number of COM controls, used Rational Rose and Visio for software design and use cases. The software was developed using Visual C++/C# with extensive use of COM+/MFC, .NET, and XML.

Confidential, January-December 2000
System Architect/Sr. Developer

With a development team of 5 people built a commercial software system ("Rainbow") for use with an existing pharmaceutical process, worked with a team of physicists and chemists to understand existing workflow and procedures. Accurately translated requirements into software terms and created an appropriate architecture and implementation roadmap. The process required in-depth understanding of physics, chemistry and mathematics in order to ensure software conformance to the set requirements. Software is found to be compliant with FDA's CFR 21 Part 11 (Electronic Records; Electronic Signatures) specifications and delivers information used by FDA in pre-market approval of drugs. Java-based based software allowed chemists to perform spectral analysis (dissolution testing) and perform mathematical and physical modeling with the gathered data. Visual C++ (COM+,DLLs), Java with Jbuilder (JNI, RMI) development on Windows NT, utilizing Oracle 8i, device driver development.

EXPERIENCE - Full-Time Positions:

Confidential, July 96-January 2000
Software Engineer/Junior DBA

Being full-time student pursued a full-time employment opportunity with an Internet startup company. Participated in a number of projects designing and implementing various Unix, Window NT, and Internet-based solutions to create and extend company-provided services. Extensively developed in Visual C++ on NT and C/C++ on Linux with heavy use of multithreading (POSIX, NT), kernel modifications, TCP/IP (design of custom protocols, reverse-engineering), MFC/STL applications, distributed applications (COM/socket-based), ISAPI/IIS programming, homegrown NT STL-based C++ library, Perl/shell scripting, JavaScript, Java and HTML. As a Junior DBA, designed and implemented a number of databases, various interfaces, and replication for large distributed databases. Tuned DB performance, and carried out other DBA-related tasks with MS SQL(6.5-2000), Sybase and MySQL.

References: Available upon request