CONTACT INFORMATION:
View contact information...
QUALIFICATIONS SUMMARY
* Extensive experience in data analysis, report and queries design and implementation
* Seven years of experience in Database and Application Development and Support
* Knowledge of testing methodologies and techniques
* Excellent academic background in computer science, mathematics, combinatory and statistical algorithms for data processing
* Solid experience in analyzing, supporting and building of applications, databases, and algorithms in following fields: accounting, inventory/stock management, and administrative management.
* Strong analytical and problem solving skills, quick learner
* Excellent communication, interpersonal and team skills. Self-starter, with positive attitude and sense of humor.
* Ability to work independently or as team member under intense pressure
Programming Languages: C#, VB.NET, VB 6, SQL, Visual C++, Delphi
Internet Programming: Java-Script, VB-Script, HTML/DHTML, and CSS, XML
RDBMS/Databases: MS SQL Server, Oracle, MS Access, Visual FoxPro
Operating Systems: Windows 2000/XP, DOS, UNIX, Linux
Applications: MS Visual Studio, MS Exchange 5.5/2000, Borland Java Builder, and PowerPoint
Technologies: ASP/ADO,. NET, ODBC, OLEDB, ActiveX, COM, DAO
Network Systems: Cisco Routers & Switches, 3Com Switches
PROFESSIONAL EXPERIENCE
Analyst, American Express, Canadian Solution Centre, Toronto, ON
Oct 2006 – present
* Gathering system requirements. Planning, prepare and execute system changes.
* Provide data analysis and build SQL queries, stored procedures and reports.
* Provide daily operation support for international HR database and applications.
* Monitor, analyze and documenting system requirements and changes.
(HR database, medical benefit system, Cost centers)
* Executed test cases and entered detected defects in the bug tracking system.
* Assist in planning and managing database and application updates
* Tested the products according to the test plans, populated data base applications for entering and tracking the identified defects.
* Maintain project management schedule
(Working environment: MS SQL server, Mercer PRISM, Crystal report, Windows 2000 / XP / 2003, Lotus Notes, ADO.NET, VB.NET, C#.NET, Perl, Visual Studio. NET 2003 / 2005 and embedded tools)
Business Analyst, BMO Financial Group, Toronto.
Fixed Income Operations Technology and Solutions.
March 2005 – July 2006
* Provide data analysis and build SQL queries, stored procedures and reports.
(Prepare reports for risk management utilize MS Access)
* Provide daily operation support and asset management. Build and distribute report on daily basis (more than 200 reports daily for different departments such as trading floor, risk management, etc.).
* Prepare and execute test cases and entered detected defects in the bug tracking system.
* Assist in planning and managing database and application updates
* Build application for Depositories vs. ICI vs. ADP reconciling, ICI vs. IBUK reconciling, ICI vs. CDS Location clearance, BONY vs. ICI reconciling for accounting group.
* Tested the products according to the test plans, populated data base applications for entering and tracking the identified defects.
(Working environment: MS SQL server, Crystal report, Windows 2000, Windows XP, MS Exchange, MS Access 2000, ADO.NET, VB.NET, C#.NET, Visual Studio. NET 2003 / 2005 and embedded tools, Showcase and Report Writer, MS project and MS Visual Studio, Case studio)
Operations analyst, EZTel-GMBH, Toronto, ON
May 2004 – October 2004
* Provide data analysis and build SQL queries, stored procedures and reports (utilizing Crystal report, MS Access and SQL report system).
* Provide daily operation support and asset management.
* Work with vendors and customers to determine data availability.
* Coordinate work technical teams in internationals offices of company
* Provide 2nd and 3rd level.
* Configured and performed troubleshooting of Group Policy Objects
* maintain the directory services and network infrastructure
* Performed trouble-shooting of the server farm and print server
* Support and maintain databases used by the unit.
* Configured LAN and programmed CISCO routers (5300 and AT-186)
* Resolved end-users' issues with access to network resources and e-mail
* Built and support database utilize MS SQL server, MS ACCESS and VB.NET, Cristal report
* Build SQL queries, stored procedures and reports.
* Analyze system requirements, design, develop, test and implement VOIP technologies
(Working environment: Windows 2000 server, Active Directory, Windows XP workstation, MS Exchange, Crystal report, SQL server, MS Access 2000, MS Visual Studio, Case studio, C#.net, VB.net)
Network Support Analyst, System Network Integrations, Toronto
June 2003 – Apr 2004
* Administrated Windows and SQL server
* Executed test cases and entered detected defects in the bug tracking system.
* Administered users and access to network resources in windows domain
* Optimized Domain Controllers placement and Active Directory performance
* Configured and performed troubleshooting of Group Policy Objects
* Resolved end-users' issues with access to network resources and e-mail
* Performed trouble-shooting and maintenance of the server farm
* Built and adjusted Windows server with TCP/IP Network
* Configured LAN and programmed CISCO routers
(Working environment: Windows NT4/2000 server, Windows XP/ 9x/Me workstation, Novell NetWare, IIS4/5, MS Exchange, MS SQL Server 7.0/2000, MS Access 2000, Novell Netware 6 and GroupWise 6.5 )
Database Support, Culture Link, Toronto
Apr 2002 – Feb 2003
* Provided advice and training to users in response to identified technical difficulties;
* Resolved end-users' issues with access to network resources and e-mail
* Consulted user guides, technical manuals and other documentation for research purposes and developed and implemented solutions;
* Performing desktop support and general troubleshooting in a Windows NT/2000 network environment;
* Designed, set up and administered user account groups and security policies for Windows NT Server and Windows 2000 Active Directory Services;
* Modified database structure to enhance links between database tables and to eliminate duplication of information.
(Working environment: Windows servers and workstation, IIS4/5, MS Exchange, MS Access 2000)
Web Developer, RoboWebsites Inc., Toronto
Aug 2001 – Jan 2002
* Designed and implementation of Web Store Manager Project with distributed sales management system.
* Tested the products according to the test plans, populated data base applications for entering and tracking the identified defects.
* Tested web-based applications that were created using the JSP (Java Server Pages) technology with real time link to back-end SQL production server.
* Performed functional, configuration and regression testing on assigned components.
* Developed client/server web applications using MS Visual InterDev 6.0
* Integrated and unit testing using: Visual Basic 6.0, VBScript, ASP/ADO, and ActiveX.
* Implemented databases access using SQL Server 7.0/2000 and ADO/OLEDB technologies.
(Working environment: Windows NT4/2000, Windows XP workstation, IIS4/5, MS SQL Server 7.0/2000, MS Access 2000, MS Visual InterDev 6.0, MS FrontPage 2000, VB, VBScript, HTML/DHTML, JavaScript, ASP/ADO, DOM, OLEDB)
System Analyst / Consultant, City state treasure / Tax Office, Ukraine
1995 - 2001
* Provide daily operation support and asset management.
* Executed test cases and entered detected defects in the bug tracking system.
* Assist in planning and managing database and application updates
* Build SQL queries, stored procedures and reports utilizing SQL and Cristal report
* Performed installation and testing software for Taxes Administration Office
* Analyze and defined system requirements for software
* Addressed customers and quires.
* Provided user-trained.
(Working environment: MS SQL server, Crystal report, Windows 2000 / NT, MS Exchange, MS Access, Visual Studio and embedded tools, Informix 7.3, FoxPro, clipper 5.2)
EDUCATION AND TRAINING
Applied mathematics with major in computers science, St. Petersburg University, 1994
CISCO Certify Network Program, CCNA
MCSE, A+
ACHIEVEMENTS
MSDN Canada2005 Inter User Group Competition Sep 2004 – Apr 2005
Project: TVBUG Pocket Builder, a layered application for automating, monitoring and tracking. NET builds.
* Developed Pocket PC Smart Client application
* Developed Web UI layer for ASP.NET application
* Utilized asynchronous Web Services calls for getting remote data and sending messages
* First place among the 5 users group entries
(VB.NET, C#, XML, VS.NET, ADO.NET, XML Web Services,. NET Compact Framework)
Participant of user group:
Toronto VB.NET user group
Share Point user group
Biz Talk user Group
REFERENCES AVAILABLE UPON REQUEST
View contact information... |