Gerrard Misquita
Lasalle, PQ
ac03ml@r.postjobfree.com
www.linkedin.com/in/gerrard-misquita
SUMMARY
I am a Software Developer with over 20 years of IT industry experience in ASP Classic, VBA Access, VBA Excel, Excel Pivot Tables, Visual Basic 6, mainframe applications and support and maintenance of SQL Server, Data bases and Small Business Server 2008.
Completed a course in Java, Java script and Android at the Herzing College March 2013.
Development Skills:
Languages PC: Java, Java script, Android (Mobile), Visual Basic, VBA (Access and Excel), VB Dot Net, ASP
Microsoft SQL DB (2008, 2005, 2000)
Creating DB objects (Tables, Views, Stored Procedures, Triggers, T-SQL etc.)
BI (ETL, SSIS, SSAS, SSRS, Data Mining)
T-SQL experience
Visio
MVC Design concepts, Eclipse, UML
Microsoft Visual Studio 6.0
Web site application support.
Internet information services (IIS)
FileMaker
Mainframe (COBOL, JCL, IMS, IBM Utilities, SyncSort, Ucandu, Remedy, Endeavour, Xpeditor, APLM, ACF2, ISPF, Clists, etc.)
PROFESSIONAL EXPERIENCE
SATREP/VOINET 2012-Present
Consultant – Analyst/Programmer (Contract work)
Maintain and Development of new functions in a CRM based application, debug problems as identified by the clients in an ASP Classic WEB environment using Access database.
Optimize and mechanize processes
Developed and tested new code as per client request
Analyze and debug code to identify and fix logic problems
Modified and added new functionality to the application
Mechanize application code to make available prompts to minimize client effort and ensure consistency
Design and re-design client Billing reports etc. (new and old)
Proactive suggestions for new ideas to improve customer application usability
Walkthrough all new application requirements with clients and acquire a sign off before promoting to production
Classic ASP, SQL, Access, Excel Pivot reports, IIS, MS-Office (2007/2010)
Freelance Consulting 2013-2015
Consultant – Analyst/Programmer (Contract work)
Maintain and Development of new functions, debug problems as identified by the clients in an MS Access Client/Server based environment using Access database.
Optimize and mechanize processes
Developed and tested new code as per client request
Analyze and debug code to identify and fix logic problems
Modified and added new functionality to the application
Mechanize code, made application more user friendly.
Design and re-design client reports (new and old)
Proactive suggestions for new ideas to improve customer application usability
Walkthrough all new application requirements with clients and acquire a sign off before promoting to production
Reversed engineered the application (TSR and Design)
Support of Small Business server 2008 (Maintenance, security issues and responsibilities)
Excel Pivot Tables and Reports
SQL, Access MS-Office (2010)
EPICOR Inc. 2011
Computer Technician (Contract work)
Coordinate, test, and debug the installation of software and hardware of cash registers/Point of Sale (POS) for various companies in the USA and Canada.
Build and test (PCs and Cash registers) as per client specks before shipping
CGI Inc. 1997 - 2009
Consultant Application Programmer Support
Support and maintain PC (Windows/Web) and mainframe applications for several client groups within the BCE family.
Trouble shooting and Bug fixing
Unit testing and coding software programs and applications according to specifications
Database development and design with MS SQL Server 2000, 2005.
Development in Visual Basic for legacy application for tax deductions at the provincial level for training customer employees
Mechanized a manual process creating a VB program where previously the SAP security staff would create records one at a time in a file for add or delete rules for thousands of their clients
Communicated with client and assisted them in their concerns and specks
Database administrator – Microsoft SQL (users’ authorizations. backup and restore etc.)
MsSQL (2000, 2005, 2008), IIS, Visual Basic 6, VBA Access, VB Dot Net (2005), Access, MS-Office, FoxPro, Remedy, Endeavour, All Fusion, Mainframe Apps, Cobol, JCL, IBM Utilities, SyncSort, Ucandu, IMS.
Bell Canada 1989 – 1997
Consultant Application Programmer Support/Development
Mandate was to develop, maintain and support applications for several client groups within the BCE family in the Mainframe environment.
Debugging Tools trainer to peers
Developed, maintained and supported billing applications
Mainframe Apps, COBOL. JCL, IBM Utilities, SyncSort, Ucandu, IMS, Remedy, Endeavour, Xpeditor.
EDUCATION AND PROFESSIONAL DEVELOPMENT
Herzing College, Canada
Java, Java script, Android, Eclipse 2013
HOTT Institute, USA
SQL2005 Administration and Programming 2008
C# dot Net 2007
CGI in house course
A+ (Computer Hardware and Operating systems) 2002
Control Data Institute, Montreal
Computer Operations (DEC)
Concordia University
Visual Basic (Advanced) 2000