| PROFILE |
Computer professional with
10+ years of database management software development experience, hands-on
experience in .NET, MS SQL Server in client/server and
multi-tier environments. |
PROFESSIONAL EXPERIENCE (SKILLS MATRIX)
| 2011 - Present |
Systems Development Manager
Interfleet Inc. a WebTech Wireless Company (former Grey Island Systems International Inc.), Toronto, Canada |
| Projects: |
Web-based GPS vehicle tracking for fleet management solutions.
|
|
|
| Env. & Tools: |
MS SQL Server 2008/2005, MS Visual Studio 2008/2005/6.0,
ADO.NET, IE 7.9, IIS 5.1/6.0, XML, MS Office 2003, MS Windows Server 2003
|
| 2008 - 2011 |
Development Team Lead
Grey Island Systems International Inc., Toronto, Canada |
| Projects: |
Web-based GPS vehicle tracking for fleet management solutions.
|
|
|
| Env. & Tools: |
MS SQL Server 2008/2005, MS Visual Studio 2008/2005/6.0,
ADO.NET, IE 7.9, IIS 5.1/6.0, XML, MS Office 2003, MS Windows Server 2003
|
| 2006 - 2008 |
Senior Software Engineer
Sequoia Retail Systems Inc., Mississauga, Canada & Mountain View, California |
| Projects: |
Implementation of comprehensive technical solutions for the following Retail Management Systems:
University Retail, Textbook Management System, Point-Of-Sale, Inventory Control, e-commerce.
As a senior team member on multiple projects was responsible for various aspects of software development lifecycle, such as, software design,
development, testing and deployment; as needed, performed hands-on coding and customization.
|
|
- Performed refactoring of database and retail management system software solution
- Reengineered VB6 based RMS software solution moving it to .NET platform (C# and VB.NET)
- Developed new modules and maintained existing code using VB.NET, C#, MS SQL Server 2005 (various editions), MS Visual Studio 2005/2008, VB6, etc
- Designed, configured and deployed data repository and reporting framework based on MS SQL Server 2005 Reporting Services, to satisfy complex functional and advanced technical requirements
- Created versatile database reports using Crystal Reports XI (11)
- Migrated reports from Crystal to SSRS format
- Performed database development: created and modified diagrams, tables, triggers, stored procedures, views, functions
- Developed and modified Windows services and Web services
- Developed GUI using Infragistics NetAdvantage and Windows Forms
- Contributed to systems architecture design
- Resolved issues discovered during unit testing and after QA system integration tests
|
| Env. & Tools: |
MS SQL Server 2005/2000, MS Visual Studio 2008/2005/6.0,
ADO.NET, Crystal Reports XI(11), IE 7.9, IIS 5.1/6.0, XML, MS Office 2003, MS Windows Server 2003, MS Windows 2000/XP, Subversion 1.4.2,
NSIS 2.38
|
| 2005 - 2006 |
Senior Programmer/Analyst
Executive Concepts Inc., Markham, ON, Canada |
| Projects: |
Information system solutions for medium-sized businesses
|
|
- Implement new functionality and customized existed ones for accounting management systems
AccountMate,
Accpac and other using T-SQL, VFP, Crystal Reports, VBScript, ODBC
- Developed new modules for ACCU-DART (real-time inventory control solution) using VFP, T-SQL
- Created DTS packages to perform migration full amount of enterprise data from CSV and XLS format into MS SQL Server 2000 database
- Created and prepared versatile database reports using Crystal Reports
- Modified MS SQL Server database for more than 10 enterprises (created and changed tables, triggers, T-SQL stored procedures)
- Created WorkWise (Mandis) scripts for complicated multi-steps tasks such as:
- Trace MS SQL Server database for changing status of data, such as creating new documents (PO, SO)
- Once new document generated run VBScript for generating PDF file
report (Crystal Report)
- Merge data and report file into email messages Pass data, files, and
messages to the end customer and management and print document on
specified printer
- Maintaining clients databases using MS SQL Server Enterprise Manager
toolkit
- Provided technical training session for resellers about embedding
a new module into existing framework
|
| Env. & Tools: |
Microsoft Visual FoxPro 8.0, MS Visual Studio 6.0, AccountMate 6.5,
Crystal Reports 8.5, MS SQL Server 2000, IIS 5/5.1, MS Office 2003, MS Windows 2000/XP
|
| 2005 - 2005 |
Software Developer
Marlborough Stirling, Toronto, ON,
Canada |
| Projects: |
Broker Origination Solution - MorWEB,
Multi-Channel Loan Origination Solution - Omiga - projects for CIBC, Equitable Trust, First National Financial Corporation, Laurentian Bank, Maple Trust, MCAP Mortgage Corporation, MRS Trust, ResMor Trust Company. |
|
- Created and modified non-visual MTS/COM+ components using VB6 to implement complex algorithms for XML data processing
- Designed and developed customized shared software modules for MTS/COM+ components
- Provided multi-tier XML programming, XSLT data transformation using XML, XPATH, XMLDOM, XSL, DTD, XSD technologies
- Created MS SQL Server stored procedures and views
- Performed data transformation from MS SQL Server creating DTS packages and using VB.NET
- Developed report packages using Crystal Reports 9
- Created test automation scripts for non-visual MTS and COM+ components, using VBScript
- Automated data transformation from MS Excel to XML format
- Provided ad-hoc analysis for data migration purposes
- Contributed to systems architecture design
|
| Env. & Tools: |
MS Visual Studio 6.0, XML Spy
4.4/2004/2005, Microsoft Visual SourceSafe 6.0, Visual InterDev 6.0, VBA,
Crystal Reports 9, MS SQL Server 2000, IIS 5/5.1, MS Office 2003, MS
FrontPage 2002, MS Windows 2000/XP, VMware Workstation 4.5.2
|
| 2003 - 2005 |
Programmer Analyst
TheNorns® Laboratories, Mississauga, ON,
Canada |
| Projects: |
SME IMS (Information Management
System for Small and Medium Enterprises) |
|
- designed and implemented various
customized db-aware, visual and non-visual components
- created cross-browser web-interface using ASP.NET/VB.NET, XML, VBScript and
JavaScript coding
- developed small applications in MS Access and Visual Basic
- created MS Access interface to manage items, orders
- created DTS packages and VBScripts to automate data extraction from
local MS Access database, transformation and loading into remote MS SQL
Server 2000
- wrote T-SQL stored procedures
- developed client/server VB interface that allows batch run of all or
only selected SQL procedures
- responsible for supervising the day-to-day flow of application
requests and management of problem tickets
- worked on data transformations and conversions for large range of
relational databases
- designed tested and implemented GUI for database applications
|
| Env. & Tools: |
Microsoft Visual Studio .NET/6.0,
VBA, ASP.NET, XML, VB Script, JavaScript
SQL, Jet SQL, Transact SQL, Sybase PowerDesigner, Crystal Reports 9
MS SQL Server 2000/7.0, MS Access 2000/7.0
MS Office XP/2000/98, MS FrontPage 2002/2000, Adobe Photoshop 6.0
MS Windows XP/2000/NT/Me/9x
|
| 1997 - 2003 |
Application Developer
Soft-Navigator Ltd., Simferopol, Ukraine
Information Systems Department |
| Projects: |
Enterprise Data Management
Systems, Inventory Databases, Web-Distributed Databases, Enterprise
Database, Orders System, Company Web Site |
|
- provided QA and software testing actions
- automated financial planning and data processing
- communicated with users to clarify their needs and requirements and
write specifications
- designed MS SQL Server database for more than 20 enterprises (created
tables, triggers, T-SQL stored procedures)
- built logical data model, designed third normal form compliant
physical database structure using SQL Server 2000 and MS Access
- wrote MS Access/VB interface that facilitated running of frequently
used queries and SQL procedures in order to make the whole process more
efficient, end-user friendly and to produce reports in timely fashion
- responsible for supervising production support issues and the group's
resources for projects and ad-hoc tasks
- developed application to collect and manage accounts payable and
receivable information for the companies and provided data migration from
the old system
- developed and implemented migration of data between different
platforms and databases
- developed report packages for various enterprises
- developed front-end GUI interfaces for data input, processing and
output
- performed applications development
to provide the web access to the products database
- developed and maintained
web site
|
| Env. & Tools: |
Microsoft Visual Studio .NET/6.0/5.0/4.0,
VBA, VB Script, ASP, XML, HTML, JavaScript,
SQL, Transact SQL, Sybase PowerDesigner, Crystal Reports
MS SQL Server 2000/7.0, MS Access 2000/7.0/95
MS Office XP/2000/98/95, MS FrontPage 2002/2000/5.0/4.0, Adobe Photoshop 5.x
MS Windows XP/2000/NT/Me/9x
|
EDUCATION
Soft-Navigator Training Center, Simferopol, Ukraine
Computer Programming (continuous education)
|
State Technical University, Sevastopol, Ukraine
Computers Science Department |
CERTIFICATIONS
MEMBERSHIP
REFERENCES AVAILABLE UPON REQUEST
SKILLS MATRIX
Level for General categories
- Training only, no practical experience.
- Fair, can do work with minimal guidance.
- Good, can do work independently.
- Excellent, can do work independently and guide others.
Year and level of experience
| Area |
Skill |
Level |
Years of Experience |
Last Year of Experience |
| Business Processes |
Information Systems |
3 |
15 |
2011 |
| Business Processes |
Technical Support |
3 |
10 |
2006 |
| COTS |
MS Excel |
4 |
10 |
2011 |
| COTS |
MS Outlook |
4 |
10 |
2011 |
| COTS |
MS PowerPoint |
4 |
10 |
2011 |
| COTS |
MS Publisher |
4 |
3 |
2005 |
| COTS |
MS Word |
4 |
11 |
2011 |
| Databases |
MS SQL Server |
4 |
7 |
2011 |
| |
SSRS |
4 |
3 |
2008 |
| |
SSIS |
4 |
3 |
2009 |
| |
SSAS |
3 |
2 |
2007 |
| Databases |
Oracle |
3 |
3 |
2010 |
Databases |
MS Access |
4 |
7 |
2008 |
| Databases |
MySQL |
1 |
1 |
2003 |
| Databases |
Clipper |
1 |
1 |
1995 |
| Databases |
FoxBase/FoxPro |
4 |
4 |
2006 |
| Databases |
Sybase |
1 |
1 |
2003 |
| Databases |
Interbase |
1 |
1 |
2003 |
| Databases |
Postgres |
1 |
1 |
2003 |
| Development Tools |
Crystal Reports |
4 |
7 |
2008 |
| Development Tools |
MS Visual Studio |
4 |
7 |
2011 |
| Development Tools |
MS Visual FoxPro |
4 |
5 |
2006 |
| Development Tools |
MS Visual SourceSafe |
4 |
5 |
2011 |
| Development Tools |
MS FrontPage |
4 |
3 |
2008 |
| Hardware |
IBM Mainframe |
2 |
4 |
1993 |
| Hardware |
IBM PC/Clones |
4 |
15 |
2006 |
| Languages |
ADO/RDO/ADO.NET |
4 |
3/3/5 |
2011 |
| Languages |
XML |
4 |
5 |
2011 |
| Languages |
HTML |
4 |
6 |
2011 |
| Languages |
JavaScript |
3 |
2 |
2011 |
| Languages |
ODBC |
4 |
5 |
2011 |
| Languages |
Visual Basic |
4 |
9 |
2011 |
| Languages |
Delphi |
1 |
1 |
2002 |
| Languages |
C++ |
1 |
1 |
2002 |
| Languages |
T-SQL |
4 |
7 |
2011 |
| Languages |
PL-SQL |
3 |
3 |
2010 |
| Languages |
ASP.NET |
4 |
3 |
2011 |
| Languages |
VB.NET |
4 |
3 |
2009 |
| Languages |
C# |
4 |
3 |
2011 |
| Languages |
VBScript |
4 |
5 |
2011 |
| OS |
MS Windows 2000/XP |
4 |
6/5 |
2011 |
| OS |
MS Windows 95/98/Me |
4 |
6/4/2 |
2002 |
| OS |
MS Windows NT |
4 |
6 |
2002 |
| OS |
MS DOS 6.x/5.x/4.x |
4 |
2/3/4 |
2006 |
| OS |
Linux |
1 |
1 |
2003 |
| Responsibilities |
Client/Server Applications Developer |
4 |
7 |
2011 |
| Responsibilities |
DataWarehousing Developer |
3 |
2 |
2011 |
| Responsibilities |
DBA |
3 |
3 |
2008 |
| Responsibilities |
HelpDesk |
3 |
2 |
1998 |
| Responsibilities |
Network Administrator |
4 |
4 |
1999 |
| Responsibilities |
Technical Writer |
3 |
2 |
1998 |
| Responsibilities |
Web Application Developer |
4 |
3 | 2011 |
| Responsibilities |
Windows Administrator |
4 |
7 |
2009 |
|
