Software Engineer Sql Server

Expertise

Over (**+) years of professional experience as a SQL Server DBA and developer with Software Engineering in .NET IDE

Expert working knowledge in the areas of MS SQL Server

Proficient in RDBMS design and optimization

Hands on experience in complex T-SQL scripts for data EML and database management

Extensive use of SQL Server Management Studio tools including SSIS, SSRS,

Experienced software engineer with knowledge of many OOP technologies including standalone applications, custom built libraries, reporting tools

Proficient working knowledge with all the projects participation in full life-cycle of software development (SDLC) from gathering product requirements in order to define the software requirements that were written in SRS, risk analysis, test cases, traceability matrices, to software architecture, database development, documentation to code writing with bug-tracking and peer-review activities as well as writing test cases for unit testing

Strong working knowledge within the areas of executing verification protocols along with documenting the results in the initial release and support of the product as well as collecting user input on the product usage

Strong working knowledge with the Agile methodology for the client

Proficient with documenting the SCRs, analysis, implementation, incremental testing of SCRs and new release management as well as backward compatibility support

Comprehensive knowledge of relational databases, including architectural design, normalization, implementation of constraints and triggers, optimization and indexing

Excellent maintenance of multiple SQL Server databases for storage and query of clinical devices data

Expert.NET SW developer using Visual Studios (VB, C#)

Strong working knowledge in the areas of BI tools such as Crystal Reports for the client

Excellent analytical, troubleshooting and time-management skills

Expertise in data reduction and function fit

Technical Skills

Tools, languages and technologies MS SQL Server 2000/2008/7.5, database design, support, query optimization, DTS, SSIS, SSMS, ADO, DAO, ODBC connectivity, Crystal Reports XI / 8 for Window, Visual Studio 2010, Visual Basic, C#, 2005, VB6, Third party GUI components, Component One, SAX SmartUI, Olectra Chart, VBA (Excel, Access), XML, C/C++, Software Version Controls, SVN, Win CVS, Visual Source Save, ActiveX, TFS, Agile, Web Service, SDLC

Operating Systems Windows XP/ 7 custom image creation with deployment

Education/Certification

MS in Biophysics Moscow Institute of Engineering Physics, Moscow, Russia

PhD in Molecular Biology Institute of Genetics and Selection of Industrial Microorganisms, Moscow, Russia

Software Quality Learning, Gaithersburg, MD USA Java Professional development

Certified Visual Basic Programmer 2000

Experience

Software Engineer

Wellstat Diagnostics Corporation (Gaithersburg, MD)

August 2007 – January 2015

Supported multiple interdisciplinary groups of scientists, engineers, quality control for feasibility, alpha-design, data collection, storage and analysis of the instrument for clinical assay development

Served as DBA for multiple databases on the single server with user role restrictions and compartmentalization

Provided .NET software development for the biotech companies which was completely based on the Agile process paradigm

Used SSIS to create temporarily storage of combined data from different database sources to satisfy compliance with FDA regulations

Designed and implemented Visual Studio 2010 based application with extensive use of third-party GUI components and MS SQL Server 2008 database connectivity

Provided subsets of the combined data were presented in Crystal Report charts, ComponentOne graphs and MS Excel

Full life-cycle development of Visual Studio 2010 software applications included customer support for the released products

Utilized and supported .NET, VB6 applications were in use for the clients application development which included new functionality

Supplied additional data management as needed and processing for released applications for the client

Provided the additional features that were needed for the implementation process as required for each user initiated SCRs with verification along with providing documentation to the client

Development of software for the new product (FDA CLIA-waived POC diagnostics device) was done in VS 2010 sp1 which was .NET 4.0 compatible

Provided the company’s top management and researchers access to on-demand reports of the instrumentation quality and assay performance without compromise of protected information

Utilized D/A and A/D controllers data flow analysis, storage, retrieval with mathematical analysis and graphical presentation

Provided the data collected by the software applications from the devices that were both for unit testing and the analyzer as a whole which was stored in the MS SQL Server database

Designed, documented and supported the databases that was used by multiple groups within the companies for engineering, chemical compatibility, assay development and manufacturing departments on the SQL Servers

Worked with the MS SQL Servers on the SSIS functionality that had been utilized to mitigate the requests of system integration, manufacturing and the QA departments for performance traceability as well as the reliability of the studies

Performed work with versions of MS SQL Server 2000, 2005 which were recently transitioned to 2008R2

Used spline and function fit in data reduction improved precision of the clinical reportable by 70%

Designed, implemented, and maintained on several Widows OS platforms the application used in FDA CLIA-waved clinical lab device

Participated in SDLC with a full life cycle of Agile software development including SRS, SDD, SOP documentation, coding, version control, change implementation and testing for deployment

Worked on the POC analyzer in order to develop a distributed application that was accessed through the network by IP address of the SBC for the client

Performed front end installation on the users' desktops and the Instrument back end components resided on the SBC as well as embedded firmware

Provided serialized commands that were sent via packets with checksum integrity algorithm verification

Handled the responds that were interpreted by the .NET DLLs and returned via events to the remote client application

Software Engineer

BioVeris Corporation (Gaithersburg, MD)

April 2004 – July 2007

Designed and developed software applications for feasibility, alpha-design, and verification of instrument used by DoD for pathogenic agents detection

Created multiple Visual Studio 6 and VB6 based applications with extensive use of third-party components and MS SQL Server 2000 database connectivity

Custom designed ActiveX components for USB communication with the device microcontroller

Provided .NET development for feasibility study, and sub-components designs

Worked with .NET development for characterization support, and bio-agent detection plate reader application

Intensive mathematical data analysis of the data both on-line streaming and post-processing

Used approaches that included linear and function fit, cubic spline, and RMS of oscillating arrays

Implemented software part of company’s quality system initiative for ISO 2000 and FDA regulated industries such as ISO 13485 compliance

Created programs that were written in VB6 were and then converted them to .NET version 2.0 under Visual Studio 2005 professional edition

Software Engineer

IGEN International (Gaithersburg, MD)

December 2000 – March 2004

Developed software for feasibility, alpha-design, and verification of subcomponents for the instrument utilizing proprietary ECL technology

Used Visual Basic 6 based application with MS Access databases connectivity were used in engineering, manufacturing and service departments

Provided custom designed Crystal Reports for presentation

Developed custom-designed applications were used for feasibility study, unit testing, system integration within engineering, assay development and manufacturing groups under the project umbrella of M1M analyzer for DoD, which utilized VB6 development

Software Engineer

Augmentation Corporation (Rockville, MD)

September 2000 – December 2000

Developed custom-made VB6 applications for IGEN International client during feasibility

Designed stages of M1 series instrument in engineering group

Software Engineer

NIH-NICHD Laboratory of Integrative / Medical Biophysics (Bethesda, MD)

November 1999 – July 2000

Developed custom built VB6 based software for the automated data collection

Provided mathematical data analysis for the innovative pulse-heat calorimeter

Contact this candidate