Sql Server Software Engineer
Resume:
RESUME
Sergey Kanovka
Springfield, VA
******@********.***
SUMMARY OF QUALIFICATIONS
. Overall 20 years of experience in IT industry
. Relational database meta data design, normalized and multidimensional
data modeling at conceptual/logical and physical levels
. Development, optimization and support in moderate-volume transactions
production environment with up to 15,000 hits/day
. Multidimensional data analysis and definition, OLAP, ETL, data
warehouse, and data cubes
. Multi-tiered front-end applications design, development and support
. Large IT projects with full life cycle ownership of a significant part
of a project, and small projects with full ownership
. Government/DoD/DLA projects experience
AREAS OF RESPONSIBILITIES
. Collaboration with business users to identify and analyze problem
areas and assess requirements
. Systems architecture and design based on business processes and
information flows patterns
. Different stages of Systems Development Life Cycle: coding,
testing/debugging, optimization, documenting, deployment, and
technical support
WORK EXPERIENCE
Senior Business Intelligence/Data Architect at Thalassa Technologies (as
subcontractor for SAF/AQXR Acquisition Division via Segue Technologies)
October 2007 - August 2010:
. Business Intelligence projects (SQL Server 2000/2005/2008, DTS, SSIS,
DDL, Full-Text Search, Oracle (Hyperion) Essbase, Visual Studio 2008,
Surround SCM/TestTrack, ER/Studio, MS Excel, Essbase Excel Add-In,
Delphi 2009, DoD legacy: ABIDES, CRIS, AFM, IDECS)
. performed analysis of subject area, data sources/formats, and
business rules
. defined overall strategy for BI/Data Warehouse components
implementation, including meta data standards
. provided subject matter mentoring to other team members
. instrumental in functional blocks identification and logical
level data modeling in ER/Studio
. performed data reconciliation of raw source data
. designed and developed SQL Server databases metadata (tables,
views, stored procedures, UDFs)
. designed and developed Oracle Essbase cubes (ASO/BSO cubes,
dimensions building rules, data loading rules, MaxL scripts)
. designed and developed ETL objects and processes (SQL Server
DTS, SSIS, Full-Text tables search, jobs) including data quality
and testing
. instrumental in implementing Version Control practices &
procedures
Senior Software Engineer at Ruesch International, April 2006 - July 2007
. OFAC/PEP scanning suite (Delphi 7, Visual C++ 2005, COM,
Thomson/Accuity scanning engine, ADO, SQL Server 2000, MKS
Integrity/Source Manager)
. Electronic Funds Transaction, Client Manager (Delphi 7, SOAP services,
ADO, 3-tier model, SQL Server 2000)
. E-Debit/AR (SQL Server 2000, Borland C++)
. instrumental in logical system design, architecture, functional
data models
. designed, developed and enhanced SQL Server databases metadata
. designed and developed front-end application to process and
analyze international payment data for OFAC compliance
. integrated front-end with Thomson/Accuity OFAC database engine
. supported and enhanced applications per business requirements
Senior Software Engineer at Thalassa Technologies (as contractor for
Andrews USAF Base) February 2004 - July 2005:
. USAF Badge Management System (Client/Server, Delphi 7, InterBase 7)
. Access Management System (Client/Server, Delphi 7/2009, InterBase 7)
. instrumental in logical system design, architecture, functional
data models
. designed and developed InterBase databases metadata (tables,
views, stored procedures)
. designed and developed front-end application to collect data,
capture and process digital photographs and signatures
Principal Software Engineer at Segue Technologies, June 1999 - April 2006
. Productivity Enhancing Capital Investment Program Data System
(Client/Server, Delphi 6, Firebird 1.5/InterBase 7)
. Budget Document Support System (n-tier, briefcase model, Delphi 6, MS
Access, SQL Server 2000, ModelMaker, ER/Studio)
. Case Management System (Client/Server, Delphi 7, InterBase 7)
. participated in project planning, business requirements and
workflow analysis, design specification reviews
. instrumental in logical system design, architecture, functional
data models
. developed internal middle-tier front-end application objects
library to reflect business processes and workflow
. integrated front-end application with Windows and Citrix
security subsystems
. analyzed and imported legacy data, redesigned and optimized
metadata to improve efficiency of data processing, re-factored
legacy code
. redesigned databases metadata
. supported and enhanced application per business requirements
Additional information for period 1990-1999 is available upon request (out
of USA experience).
EDUCATIONAL BACKGROUND, CERTIFICATIONS
. Borland Certification, 2003: "Delphi 7 Studio Advanced Developer"
. Brainbench Master Certification, 2002: "Delphi 6 Fundamentals"
(transcript available at
http://www.brainbench.com/transcript.jsp?pid=832675)
. Certification, 1998: "Professional Application Developing using
Borland Delphi and Client/Server technology" (Moscow, Russia)
. Degree, 1990: Master of Science in mathematics, major in computer
science, software engineering and analysis. Thesis: Software and
Hardware Supply for Automatic Control Systems.
. 1990: Graduated from Higher Aviation Engineering Military Academy
(Kiev, Ukraine), diploma with honor.
PERSONAL
. Recognized by clients/customers for professionalism, thoroughness,
passion for software quality
. Able to work independently with minimum or no supervision, have been a
contributing member on various project teams
. Troubleshooting and analytical skills with capacity to accurately
identify and assess problems before providing expert solutions
. Able to assume multiple responsibilities and remain productive within
time-sensitive and fast-paced environments
. Continually upgrade my education to remain competitive, learn new
technologies fast and in-depth
. Flexible, self-starter, and enjoy new challenges
. Earned reputation by proven working ethics with integrity, diligence,
responsibility, dependability, and loyalty
References are available upon request.
Contact this candidate