Skills

·          Over 15 years experience in Software Development, Business Analysis and QA.

·          Extensive experience in VB6, VB/ASP.Net, SQL Server 2000, Oracle 7/11, data governance, Windows/web services, ADO.XML, HTML, UML (R. Rose), Web Servers/IIS, Crystal and Reporting Services, n-tier apps. 

·          Databases – SQL Server 2000 (6 years), DTS, Oracle 8/11i, Oracle Forms/FA, DB2 (QMF), MySQL, Teradata (3 years), Access (7 years), ERWIN (data modeler), Quest TOAD, PL/SQL, TSQL.

·          Technologies – .Net, ADO, SOAP, System Development Life Cycle (SDLC), SQL, HTML, Webforms, COM/MTS, ActiveX, VBScript, IIS, Visual Studio, Visual SourceSafe, WinCVS , Macromedia (MX), FrontPage;

·          Applications – N-Tier Architecture, distributed components programming using Microsoft DNA and Windows Architecture, Remedy, CRM, Microsoft Great Plains, MS SharePoint, MS Project, Enterprise Resource Planning (ERP), Web/Windows services, Custom MIS applications, full life cycle development (SDLC), Citrix, Crystal Reports 7-10, Business Objects XI, Reporting Services, VMware, Red Hat 9, Windows NT, XP and Windows Server.

Professional Experience

Ministry of Government Services – Downtown Toronto                                                                                February 2008 – present

Business Analyst / Programmer Analyst

Vision FM – Facility Management Solution

·          Understand business and process flow of VisionFM software, document core system flow, functions, data model. Customize Vision FM module and add new functions as per client needs - Lease, project plan, invoicing and site plans (Oracle 91, SQL Server 2000, VB Script, VBA, Business Objects / Crystal Reports 9, 10, XI). 

·          Developed maintained and automated SQL jobs for data integrity and cleansing.

·          Customized Vision FM Project, WO, Invoice, Space, Assets and Capital modules to comply with business needs.

Maritz Canada – eBusiness Team – Mississauga, ON                                                                                August 2007 – February 2008

Business Analyst / Programmer Analyst

Marketing Solutions / Incentives and Rewards – Scotia, HSBC, Aeroplan,

·          Recognized and documented Vault core system (reverse engineering), reward procurement and redeeming process to ensure effective reward delivery to this organization or direct to participant. (ASP.Net, VB.Net)

·          Developed, maintained, and automated jobs/reports to monitor redemption level and product lifecycles to appropriately refresh online catalogues on a regular basis (SQL Server, DTS, Citrix, Reporting Services).

·          Participated in client presentations, gather requirements, training and meetings as required, provide consultative support, leadership and proposal content for all rewards proposals. In charge with SDLC documents (business requirements, functional requirements, proposal, technical specification, process flow diagrams, etc)

·          Collaborates with e-Business team members to ensure delivered solution fulfills original solution concept.

·          Works with e-Business team to ensure that code changes are made and re-tested when errors are found. Created and executed test scripts and test cases strategies (UAT) to ensure that application software is bug free.

Ministry of Education - Information Management Branch - Toronto, ON                                  April 2006 – July 2007

Business Analyst / Programmer Analyst

Ontario School Information System Project – ONSIS project

·          Recognized ONSIS System, financial and statistical analysis, decision making and policy development process.

·          Enhanced integrity of data collection system at elemental and aggregate level, detailed system requirements.

·          Integrated web based system for collection, validation, tracking, performance management and reporting of education related information (Oracle 11, ASP.Net, VB.Net, HTML, VMware, VSS, Remedy, and Quest TOAD).

·          Designed, developed data collection and management solutions for data tracking and validation (ASP.Net, VB.Net, Oracle 10g), web services

·          Enhanced and Improved query performance (ONSIS core system) to improve accuracy, completeness of data collected from boards, districts and schools, and eliminates redundant data collected by existing system.

·          Improved batch electronic file submission process for better data consolidation from boards, districts and schools.

·          Developed analysis reporting system for Boards, Districts, Students systems (data collection, data management, scheduling, repository, business rules, security, and system interfaces – Crystal Reports XI, ASP.Net, VB.Net).

·          Performed UAT, QA, test case for develop apps, full SDLC documentation, created Visual Studio test projects.

TD Canada Trust - Corporate Real Estate - Toronto, ON                                                            Sept. 2005 – April 2006

Business System Analyst / Programmer Analyst

Occupancy Model, CAPEX Planning, Depreciation and Forecast - Business Intelligence Tools

·          Understand CREO financial system, all business aspects of CREO functions.

·          Developed business cases, UML, evaluate outcomes, test assumptions, identify benchmarks, created project plan, conducted ongoing evaluation of business performance, recommend appropriate action to management (SDLC).

·          Designed, developed and integrated new database for the CREO system, BI and automation tools, and ETL script tuning (Oracle 11i, SQL Server 2000, DB2/QMF, VB6/Access, Visual Studio 2005, and Crystal Reports 10).

·          Developed flexible, efficient and accurate forecast model and asset depreciation, web services, created user all forms (GUI).

·          Developed SDLC documentation, UAT (new, regression, limited), QA, test cases, data integrity.

·          Provided Oracle support for all Corporate Real Estate.

PBB Global - Clarke Logistics - Toronto, ON                                                                                 2005 June – Sept. 2005 Programmer Analyst

TMS - Transportation Management System (SQL Server 2000, LoadTech – Logistics app, Crystal Reports 8.5, OLAP)

·          Recognize supply chain management process covering all aspects of operations, dispatch, rating, and payroll, accounting and total logistics.

·          Worked with the customers to identify specific business process for PBB Global Logistics system. Analyzed business requirements identify technical components and interfacing needs for report development in Crystal Reports 8.5.

·          Prepared and customized data collection flat files (TTX) and reporting sub-systems templates for transportation chain management system.

·          Developed and customized full range of reports (Crystal Reports 8.5) to reflect each aspect of Logistics systems - Automatic Order Entry, Enhanced Dispatching, Freight Billing, Accounts Receivable/Payable, Commission Statements, Broker Payments, Complete Customer Analysis, and Carrier Searches.

·          Test and integrate reports into production system, ensuring they perform as required. Assist users in integrating reports into LoadTech PBB Global Logistic System

Jonah Group – CIBC – Toronto, ON                                                                                                                2004 July – June 2005

Business Analyst / Programmer Analyst

Reciprocal Referral project (VB.Net, Oracle 9, Crystal Reports Enterprise .Net, OLAP, Visio)

·          Worked with the business users to identify business needs, gather requirements, define plan for FSRFileLoad application (VB.Net, SOAP, HTML) and Reporting Tool (Crystal Reports 10, Enterprise .Net). Designed data model, UML, triggers/views/ procedures (PL/SQL), populate data according to client business rules, created test scripts for data integrity.

·          Worked on the design and development of FSRFileLoad (OLAP) and Reporting Tool web service. Setup, migrate, and integrate core components to the server, deployed both systems to production data. Execute unit testing, review test results ensure system works as per specifications.

·          SDLC - design documents, business and process flow, UAT (new, regression, limited), test scripts, fixed bugs.

Canada NEWSWIRE – Toronto, ON                                                                                               2003 August – 2004 June

Business System Analyst / Programmer Analyst

Microsoft Great Plains (SharePoint portal) & Microsoft CRM integration into Work Order fulfillment system

·          Identified Microsoft Great Plains & CRM system components, data mapping requirements. Set up project expectations with customers and managed them throughout the process (Visio, MS Project 2000), identify business and data flow for new system, developed plan for system triggers and data migration.

·          Created plan for data synchronization process using custom data migration tool for both Microsoft systems (SQL Server 2000), created test scripts for data integrity.

·          Worked on the design and development of Work Order fulfillment system, account integration with Microsoft Great Plains and Microsoft CRM. Designed and developed functional components for email router, wire and fax integration, windows/web service for WO automation with GP accounts. (VB6, ASP, HTML, and SQL Server 2000).

·          Created detail design documentation (SDLC) on functional components, UAT, business and process flow, WO integration plan with GP (Visio and ERWIN). Developed diagrams for WO automation delivery life cycle and data model.

Aseco Integrated Systems - Oakville, ON                                                                                      2002 September – 2003 June

Business Analyst / Programmer Analyst

SAP - Beaming Manufacturing System - Conversion phase

·          Worked with the business analyst and the customer to resolve functional issues. Integrated all functions as per client's request into a single software app - Dupont (ERP). Evaluate pros and cons of alternative architectures and technologies (UML, Visio, MS Project).

·          Developed functional specifications for the data collection and reporting sub-systems. Designed and defined database entities as well as system triggers, web services and stored procedures for ETL.

·          Development of code in accordance to selected technologies and applicable standards (VB6, VB.Net, HTML, ADO, Web forms, Crystal Reports Enterprise 8, PL/SQL, Oracle 8, and SQL Server). Performed QA testing, UAT, scripts tests, review test results and ensure the system is performing as required. Assist factory installation and factory assistance testing of the system.

·          Participated in developing system design, data modeling, potential re-use for previous designs, plan and lead design reviews.

SAP - Beaming Manufacturing System - PLC's and System interfaces

·          Provided analysis of requirements and interfacing needs to existing legacy systems including documentation for functional requirements and technical specifications

·          Developed written design documentation and project expectations (MS Project 2000). Ensure design is thorough, high quality, conforms to applicable standards and will provide a robust and maintainable system.

·          Developed system interfaces code in VB6, VB.Net, Web Forms, HTML, Crystal Reports Enterprise 8, Oracle 8, and SQL Server. Performed QA testing, UAT, developed test cases, reviewed test results and ensure the system is performing as required. Assist factory installation and factory assistance testing of the system.

Stirling Douglas Group - Markham, ON                                                                                          1998 August – 2002 September

Business Analyst / Programmer Analyst

Forecast and Prompt projects – Data Warehouse

·          Provided software solutions for business requirements and estimates project deadlines (Visio, MS Project).

·          Designed and implemented N-tier prototype for new clients for Automatic Replenishment solutions.

·          Prepared design, security options (using Visual Basic 6), implementation process, and test cases.

·          Designed N-tier components (user/business/data tiers) for custom requirements (Visual Interdev - ASP, SQL Server, and Oracle), data analysis and modeling.

·          Developed and optimized ‘Forecast Solutions’ (retail companies) for quality and high performance using Visual Basic 6.0, ASP/VB.Net, MTS, SQL Server, PL/SQL, Oracle, UDB, Teradata, Citrix, and Win NT & 2000.

·          Provided complete program specs with the business unit, defined requirements for improving systems for PROMPT apps (Profile Solutions, Purchase Order, Contribution, Automated Replenishment).

·          Created technical and resource documentation for source code, test cases, data security, code bugs solving procedures. Performed QA testing, UAT, developed test cases, Unix shell scripts, reviewed test results

DeHavilland – Bombardier Regional Aircraft Division – Downsview ON                                                1998 March - 1998 May

Programmer Analyst

ERP – MMS project

·          Developed Custom Intranet applications for Dash8 Series 100, 300 and 400 projects (Visual Basic 5).

·          Developed, optimized and integrate business apps for performance and stability (Visual Basic 5, Oracle 7).

·          Developed components and GUI forms for Placard Manufacturing process using Visual Basic 5, SQL Server 6.5. ADO 2.1 ODBC and Oracle 7. Provided security by restricting the user/group access to specific data level.

·          Developed web application for Interior Design Department HTML, ASP – Manufacturing management software

·          Developed Label Design Generator software for Dash8 Series 100, 300 and 400 projects using Visual Basic 5, SQL Server 6.5 and, Fox Pro, Access 97.

Orion Bus Industries - Scarborough ON                                                                                         1997 May - 1998 March

Programmer Analyst

AFC and System Reporting tool Project

·          Developed Intranet/Internet application software for Automatic File Conversion (AFC) using Visual Basic 5, HTML, VBScript, ADO 2.5, IE, SQL Server 7 under Windows NT environment.

·          Prepared design, security options (restricting the user/group access to specific data level) implementation process and test cases for AFC application.

·          Designed and developed end-user components and GUI forms for system reporting tool using Visual Basic 5, Oracle 7 and Internet components.

Motorola – ROKURA Ltd. – Romania                                                                                              1995 March – 1997 March

Business Analyst / Programmer Analyst

CRM application project – App development (GUI, queries, COM, VB5, SQL Server), CRM intranet, Contract Management

TEKNION Ltd. – Romania                                                                                                                 1992 Sept. - 1995 March

Programmer Analyst

Enterprise Resource Planning application project (VB5, SQL Server, MS Access – design, development and integration.

Education

Ministry of Education

ONSIS – Ontario School Information System                                                                              2007

TD Canada Trust

Oracle FA (fixed assets), DB2 system access procedures                                                    2006

Jonah Group                                                                                                                                        2005

Procedural Language extensions to SQL (PLSQL)

ASECO Integrated Systems                                                                                                              2003

Visual Basic .NET - Microsoft Official Curriculum

Stirling Douglas Group                                                                                                                      2000

Component-based distributed systems development using Microsoft DNA (Distributed Internet architecture)

Stirling Douglas Group                                                                                                                      1999

Online Analytical Processing (OLAP)           

British Columbia Software Training Alliance                                                                                 1998

Using Microsoft Visual Basic Enterprise edition for enterprise application development (Visual Basic 6.0, ADO, 2.5, COM, SQL Server 7)

Orion Bus Industries                                                                                                                          1997

Customer Relationship Management (CRM)

University of Bucharest - Romania                                                                                                  1994

Client Server - Database programming using Visual Basic – On-site training

University of Bucharest – Romania                                                                                                                 1992

Faculty of Engineering – Master Degree