download Word doc

 

Tom Staresinic
551 Gilmour St
Ottawa, ON K1R 5L5
as488@ncf.ca

Primary tel & voicemail: (613) 236-3490
Cell & voicemail: (613) 322-3681
U RL: http://www.ncf.ca/~as488

 

 

Software Programmer / Developer / Analyst (1998-2007) / Construction Management  (1994-1997)

Skills:

8 years of professional experience in programming languages. VB.Net/4/6 (3 years), VB Script (2 years), ASP.Net/Classic (2 years), .Net 2.0 Framework, .Net Web Service, SOA, Windows Forms (4 years), Databases (7 years), IIS (HTTP web server, FTP, SMTP mail server), SQL (5 years), RDBMS (relational databases): Oracle 8/9, SQL Server 2000/2003/2005, DTS (Data Transformation Services)/SSIS, HTML (3 years), JavaScript (3 years), Crystal Reports, DOS command line batch scripts, client service skills (4 years), 3-tier distributed client-server applications (3 years), OOP object-oriented programming (2 years), Dreamweaver 8.

 

 

ETL, Visual Foxpro VFP (2 years), Oracle PL/SQL, MS Access, data acquisition automation w/GPIB & IEEE 488 (1 year), sub-contractor coordination (1 year), cost estimating and contract bidding (1 year), Filemaker, Unix command line (telnet, SSH, Putty), Visual Studio .Net/8/6 (6 years), Citrix.

 

Security Clearance:

Secret Level II (2006-2016) #95029622, and Enhanced Reliability

 

French Language:

Good reading and listening comprehension.

 

 

 

 

WORK HISTORY

12/2007 – 6/2008

Nav Canada

Ottawa

 

 

CS-03 Programmer/Analyst (VB.Net, SQL server, T-SQL)

 

 

Developed custom data parsers (ETL), which extracted, validated, transformed, and loaded (airplane flight) data in SQL Server 2005 databases and plain text file sources. Extended the functionality of existing parsers by retrieving Visual Source safe code, analyzing it, communicating comments and suggestions to the manager, and writing new code.

Used VB.Net (used .Net Form and data access), C#.Net (created a multi-threaded object-oriented Windows service; used sockets/ports), Windows services, Remedy, SSIS, VB6, Microsoft Visual Studio 2005, and SQL Server 2005  (Created tables and constraints; wrote T-SQL stored procedures). Drew diagrams in Visio. Very strict adherence to SDLC (system development life cycle) methodology and documentation.

 

 

8/2007 – 12/2007

Treasury Board Dep’t

Ottawa

 

CS-02 Programmer/Analyst (ASP.Net, SQL server, RDMS, T-SQL, .Net Framework 2.0)

 

 

Designed and developed a new bilingual ASP.Net data-centric web application with extensive use of new .Net Framework version 2.0 classes and web & data controls. Coded in VB.Net. Functionality was to track candidate selection processes for numerous department committees; included contact, candidate, and department records management; document upload/storage and retrieval, reports, data entry validation, database integrity (constraints and relationships), codifying business rules, and reports (on-screen/HTML and MIME export). Developed UI (user interface) in Visual Studio and a relational database in SQL Server Enterprise 2005 Manager (databases diagram and modifications) and Query Analyzer (T-SQL procedures). Communicated directly with client to define and clarify requirements.

 

 

2/2007 – 7/2007

Dep’t of National Defense

Ottawa

 

CS-02 Programmer/Analyst (ASP.Net, SQL server T-SQL, DTS, CLF, VBA/VBScript)

 

 

Performed System design analysis, resolved bugs in existing ASP.Net and ASP classic bilingual web applications, implemented enhancements, and wrote technical documentation and functional specifications. Performed unit testing of VB.NET modules. Performed T-SQL procedure programming and SQL Server Enterprise Manager DTS packages residing on RDMS SQL server 2000 to import and transform data.

 

 

3/2006 – 12/2006

CTS Software

Ottawa

 

 

Intermediate Software Developer (VB.Net, SQL server, Web Service)

 

 

Implemented a distributed client-server application written in programming language VB.NET using the VB.NET framework. Data downloads to client application to enable: POS (point of sale) invoices, sales receipts, truck inventory tracking, purchase orders stored in RDMS SQL server database. Client re-synchronization with central Microsoft Great Plains (SQL Server) database using XML data transfers, SQL Server stored procedures (Transact-SQL / T-SQL), and a middle tier Web Service and Microsoft eConnect (Great Plains SQL Server database ETL interface). Performed Change Request development and System design analysis. Implemented technical specifications, Automatic client (executable) update using Microsoft Application Blocks. Created system test and user acceptance plans and performed unit testing; used VPN and Dameware. Involved in system development life cycle (SDLC). Used VSS (Visual Source Safe) version control. Member of a development team. Used Click Once deployment and created Installer packages (using Microsoft building blocks).

 

 

3/2001 – 3/2006

Global Logistics

Ottawa

 

Programmer/Analyst (VB.Net, ASP.NetOracle PL/SQL, ETL)

 

1) Lead person responsible for integrating ETL data imports and data conversions (CSV, EDI messaging, SQL data file formats) centered on a mission-critical sales and fulfillment system (“Securkey”, “SecurWarehouse”). Provided guidance to the Systems Manager and Help Desk staff. Investigated and fixed system problems, both internal and external/client-side. Communicated database and application architecture to Cognos BI developers.
Developed and maintained (trouble shooting and debugging) internal and external B2B ETL data import/export software programs and scripts (Visual Foxpro 6, DOS Foxpro 2.6, Quick Basic, Softshare Delta/ECS software), including CSV and EDI formats. Communicated with internal/external clients to define/clarify data format specifications and file transport processes. Performed problem debugging and resolution.

2) Designed and programmed a VB.Net application for Oracle database to manage the distribution process of printed goods. The program included creating VB Windows Forms and Crystal Report v9 (invoices, shipping pack slips, etc.), linking the data with the courier’s (UPS) shipping software, Oracle RDMS database PL/SQL stored procedures coding and testing. Merged a Lotus Notes database into an Oracle RDMS database; designed, tested, and coordinated the process; advised, trained, and collaborated with the non-technical Customer Relations Manager. Provided end-user support. Implemented new features; performed Change Request analysis and development. Used Toad and SQL to export Oracle data into Excel spreadsheet reports, and do special database updates. Supported the system (VB client GUI and oracle database) in test and production environments.

3) Created a Windows ASP.Net web application (hosted on IIS web server) with COM middle tier object (Active X DLL) to interface to a legacy DOS application’s database hosted on a Novell file server. Used ADO and SQL for database logging, managing user accounts, and application configuration.

4) Programmed Excel spreadsheet macros (VBScript):
- ETL process to transfer inventory data from a Bill of Materials stored in Excel into a fulfillment SQL database
- Automated price data lookup for invoices.

 

12/1999 - 1/2001

Nortel Networks

Ottawa

 

Test Software Developer (Test Automation, Desktop Support & Database applications)

 

1) Automated test stations using GPIB/IEEE488 instrumentation interface standard and Visual Basic: Controlled motor movements to position devices, retrieved data from measuring instruments, and stored test data to a database.
2) Maintained Visual Foxpro relational database (file backup and user accounts)
3) Programmed forms to filter and display data (tables and graphs), perform verification engineering assessments (pass/fail calculations),  SPC (statistical process control) for hardware testing.
4) Provided first-line Windows computer networking and desktop support to a staff of 20.
5) Programmed scripts and forms in Filemaker 5 (database application)

 

 

 

 

11/1998 - 7/1999

CryptoCard

Ottawa

 

Software Tester & Database Application Programmer

 

• Performed verification and validation of Cryptocard’s retail software suite of security applications. Included: GUI functionality testing, installation and various configurations, load testing the Oracle database, and recording bugs into BugTracker software.
• Programmed C language script using Visual C++ IDE to verify Windows DLL API input/output.
• Software testing on Windows, Linux, and Solaris platforms.
• ETL process to transfer client contact information from an HTML web page form to Goldmine enterprise contact manager software. Used VB and DDE.
• Administered build scripts to generate new software releases
• Two-month co-op placement was extended to full-time after I proposed and successfully implemented the above-mentioned Goldmine web integration.

 

1/1994 - 1/1998

 

 

 

Construction Project Coordination, Contract Administration, Sales Engineering

 

• Ensured construction adhered to specifications and drawings • Scheduled inspections by inspectors, engineers, architects. • Supervised and assigned a daily work schedule of 3 assistants. • Supervised up to 10 concurrent projects up to $0.5 million each in value. • Assisted construction manager to prepare price bids on tendered projects • Represented private project owners; worked for general contractors and project managers. • Worked for a construction material manufacturer.

 

VOLUNTEER

Created and maintain a local online tennis club www.ncf.ca/~as488/tennis.
  • HTML, CGI, Perl scripts, Unix web server host, and JavaScript (algorithm to rank people, and web form validation).
  • Organize a monthly league (group players, record standings).
Technical advisor to a web publishing/development team of a local charity.

 

EDUCATION

 

 

• .Net (VB.Net, ASP.Net, C#, ADO.Net) 6-week full-time study, 2005

• 36-week fulltime program in Software Programming (C, C++, VB6, Java) and Database Development (Oracle, SQL, Access). Praxis Training Institute, Ottawa, 1998

 

• 16-week fulltime program in project Cost Estimation. Project Management Level I and II Courses. (Timberline, MS Project). 1994 / 1996, OCA, Ottawa, Canada

 

• Bachelor's Degree, Bachelor Of Civil Engineering
Carleton University, Ottawa, Canada, 1985-1990