SUMMARY:

Senior Database Architect/Analyst with over 30 years of experience in design, development and maintenance of both scientific and business Database powered systems for various industries and applications, using SQL Server, C#, .Net, NoSQL with strong Scientific skills

TECHNICAL SKILLS:

Database suite: MS SQL Server (expert), SQL 2017, Power BI, SQL Azure, SQL Server Analysis Services(SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), most previous SQL versions

No SQL/Big Data: MongoDB (multiple servers, database sharding), Graph databases (OrientDB), Cosmos DB/Document DB (including JavaScript stored procedures), Azure Table storage.

Database Design and Business Intelligence: Meticulous database design based on deep studying of business process, Data normalization, Spatial data types (Geometry, Geography), Database Replication and Mirroring, Kimball methodology, Data Stewardship, Best practices in Data Warehousing, Establishing KPIs, ETL process design, High availability databases, Data mining models, Predictive models, Association models

Data Analytics: R services (in SQL), prediction models

Database performance (expert): Tables and indices design for performance, Execution plans, SQL Trace analysis, Performance related Data management views analysis, Code reviews for performance, Index and Statistics maintenance, Locking analysis, Extending SQL Server with .Net code for higher performance

Cloud technologies : Microsoft Azure, SQL Azure, Cosmos DB (Document DB), Azure Tables, Power BI, Azure Data Factory, Azure Functions, Azure REST applications

Development: Advanced SQL coding (complex stored procedures, functions, triggers), .Net, C#, Visual Studio, LINQ to Entities, Entity Framework, ADO.Net, ADOMD.Net, Git, GitHub, Visual Studio Team Services (VSTS), Subversion (SVN), NUnit, .Net based SQL (SQL CLR) stored procedures, functions, types and aggregates, SQL Spatial data types (Geometry, Geography) programming

Languages: T - SQL, DAX, MDX, DMX, C#, XML, R

Operating Systems: Windows Server 2016, Windows 10, Windows 7, Windows XP, Windows NT, all previous Windows family

Technical Writing : Technical Specs, Project Documentation, User guides, online Help content, Sand Castle

WORK EXPERIENCE:

Confidential, Rochester, NH

Senior Database Architect/Developer

Responsibilities:

• Redesigned databases to improve structure and performance
• Did data analysis and provided guidance for data normalization
• Did SQL performance analysis and optimization on ongoing basis
• Developed Dashboards and Data visualizations on cloud using Power BI
• Worked with cloud data services such as Cosmos DB/DocumentDB and Azure Tables
• Implemented LINQ powered Data Layer for C# based business application
• Was working with Business intelligence tasks utilizing Multi-dimensional cubes and Data mining models
• Built prediction models based on R services (in SQL)
• Designed data models
• Developed ETL tasks using SQL Server Integration Service
• Developed advanced reports within SQL Reporting Services based both on SQL and MDX queries
• Developed OLAP client based on ADOMD.Net
• Was responsible for series of pilot projects utilizing and exploring of NoSQL and Big data solutions
• Did modeling of clusters movement and evolution using OrientDB
• Used MongoDB for handling of configuration data

Software platform: T-SQL, SQL-Server 2008-2017, DocumentDB, MongoDB, SSAS, SSRS, SSIS, DAX, MDX, DMX, Power BI, Visual Studio, C#, .Net, ADO.Net, SVN, Git

Confidential

Senior Database Architect/Developer

Responsibilities:

• Designed and optimized enterprise level database including structural changes to improve performance, advanced query optimization, SQL code review
• Analyzed business requirements and offered solutions (multiple options), which would address all current requirements, provide flexibility for future growth and allow smooth transition between old system and new system
• Did general business modeling and design of N-tier web application
• Designed various business reports using SQL Reporting Services and provided data structures and stored procedures for fast reporting on large amount of data
• Did SQL performance tuning
• Designed data models using Oracle SQL Developer Data Modeler
• Developed ETL tasks using SQL Server Integration Service
• Designed C# classes, which constituted Business layer and Data layer of N-tier web application
• Developed advanced database high availability mechanism
• Developed advanced mechanism of data synchronization between different databases
• Did basic Web design
• Developed large ASP.Net based application
• Developed service oriented Web application using WCF
• Wrote C# code
• Wrote abundant number of SQL stored procedures and triggers
• Built Business Intelligence models based on Multi-dimensional cubes and Data mining
• Used Math Optimizations methods to develop advanced strategy planning tools
• Managed team of up to 5 people

Software platform: ASP.Net, C#, .Net 2.0, Net 3.5, SQL-Server 2008, SQL-Server 2005, SQL Analysis service, Business Intelligence Development Studio, MDX, DMX, SSIS, SSRS, LINQ, WCF, ADO.Net, Visual Studio.Net, JavaScript, AJAX, JQuery, HTML, DHTML, Visual Source Safe, XML, Windows 2003 Server, Windows XP Professional, Windows 7

Confidential

Senior Software Engineer

Responsibilities:

• Provided database support for .Net based product, which controls chargecard based phone network
• Processed phone network notifications
• Dealt with calls reconciliation and automatic billing
• Wrote SQL stored procedures
• Wrote C# code
• Developed middle tier using object remoting and reflection
• Developed .Net based Windows services
• Developed advanced automatic querying system based on Web services

Software platform: C#, .Net, Visual Studio.Net, Visual Source Safe, MS SQL-Server 2000, XML, ADO.Net, Windows 2003 Server, Windows XP Professional

Confidential

.Net Solution Architect

Responsibilities:

• Produced Database design and .Net Development Standards for the whole company
• Designed SQL database
• Was responsible for building of Data Warehouse
• Designed classes architecture
• Wrote C# code
• Developed .Net Web application
• Wrote VBScript and JavaScript based scripts
• Managed and mentored team of developers

Software platform: C#, .Net, ASP.Net, Visual Studio.Net, Visual Source Safe, MS SQL-Server 2000, XML, ADO.Net, VBScript, JavaScript, Windows 2003 Server, Windows XP Professional

Confidential

Senior Software Engineer

Responsibilities:

• Wrote SQL stored procedures
• Wrote C# code
• Provided all database needs for .Net Web application
• Designed and developed .Net Web controls
• Designed web-pages and wrote HTML code
• Wrote VBScript and JavaScript based scripts
• Dealt with internationalization issues

Software platform: C#, .Net, ASP.Net, MS SQL-Server 2000, XML, ADO.Net, VBScript, JavaScript, Windows 2000, Windows XP

Confidential

Senior Software Engineer

Responsibilities:

• Wrote SQL-Server stored procedures and triggers
• Analyzed business processes and wrote specs (both text-based and UML-based)
• Designed system components using OOD, Rational Rose
• Developed VB + MTS N-tier application
• Developed C# applications
• Resolved advanced MS SQL-Server problems
• Managed team of 7 people

Software platform: C#, .Net, ASP.Net, MS SQL-Server 2000, Rational Rose, UML, Visual Basic 6.0, XML, ADO, Windows 2000

Confidential, Salem, NH

Senior Software Engineer

Responsibilities:

• Provided Database support for C++ based application
• General project management and design
• Analyzed business processes and wrote specs
• Wrote C++ code, using MFC and Win32 API
• Wrote VB Scripts for ASP based solutions

Software platform: VC++, MS SQL Server, IIS, ASP, VBScript, Win32 API

Confidential

Senior Scientist

Responsibilities:

• Leaded a team of developers/researches
• Provided general project design
• Wrote Specs and Technical documentation
• Wrote C++, VB, Pascal (Delphi) code. Used Win32 API, MFC, JDK, VCL
• Designed and developed embedded software code for software-hardware medical oriented system
• Designed and developed system based on N-tier architecture
• Provided Database design
• Wrote Transact SQL code (stored procedures, triggers)
• Managed team of up to 15 people

Software platform: Delphi, MS Visual C++ with MFC, VB, MS SQL-Server, Windows NT, Win32 API, Embedded software

Confidential

Senior Software Developer

Responsibilities:

• Wrote SQL-Server stored procedures
• Was used as a consultant for resolving of advanced MS SQL-Server problems
• Provided fulfillment of some recurring tasks in the database, carried out management and monitoring of some features of the client part, which are currently in the process of changing and further extension

Software platform: Visual Basic 6.0, MS SQL-Server 7.0, ADO, Windows NT

Confidential

Chief of Software Development division

Responsibilities:

• Developed accounting and management software for small business applications
• Developed software for Travel Agencies
• Developed software for Real Estate Agencies
• Developed software for Marketing researches
• Developed software for Goods Accounting
• Developed software for Car-care Service centers
• Wrote technical documentation
• Demo versions of these programs are available upon request

Software platform: Delphi, MS Access, MS SQL-Server, Interbase Database, Windows NT, Win 32 API

Confidential

Senior Software developer

Responsibilities:

• Developed Shareholders accounting software
• Developed Securities Deposytory software
• Provided software support

Software platform: MS Access, Delphi, Windows 95.

Confidential

Senior Lecturer

Responsibilities:

• Taught students of programming and programming languages, algorithm design

Software platform: Pascal