vbguy

3 reviews

@vbguy

Vancouver, Canada

Ahli semenjak 26 Mac 2004

0 Cadangan

vbguy

Dalam Talian Luar Talian

MARK PELLETIER VISUAL BASIC PROGRAMMER/ANALYST CREATIVE AND INNOVATIVE IT SOLUTIONS FOR BUSINESS TECHNICAL SKILL SUMMARY: - Visual Basic, VBA, VBScript, C#, .Net - XML, SOAP, SQL, HTML, ADO, ODBC - Advanced Excel macros, spreadsheets, pivot tables and reports - Windows XP, 2000, NT 4.0, 9.x - Basic knowledge of UNIX - SQL Server 2000, Sybase, Oracle , MS Access - Visual Basic 6.0 Enterprise, Visual Studio .Net, Visual Source Safe, MS Office PROFESSIONAL EXPERIENCE MORGAN STANLEY (Keane Canada co-source) Programmer/Analyst: full-time position Apr 2004 – Jul 2005 Morgan Stanley is an investment banking and securities firm. Develop and support custom applications, PassPortXL extensions and reports for institutional equities trading. PassPortXL is a system that enables real-time trading, order management and market data access within MS Excel. - developed Import+, an ActiveX DLL extension for PassPortXL that allows clients to define and save custom XML format files for data sources imported into trading portfolios. As a result, the number of custom macros required to import new file formats was reduced and multiple files could be imported into one or more trading portfolios simultaneously. - created VirtualFix, a client application that outputs real-time fills and market data to a text file. Monitor details, market data fields and export conditions are read from an XML configuration file. - programmed custom Excel macros to support ad-hoc spreadsheet applications THE LAW SOCIETY OF UPPER CANADA VBA Programmer: 3 month contract Oct - Dec 2003 The Law Society of Upper Canada is the self-governing body for lawyers in the province of Ontario, Canada - Designed and developed an AS400/MS Word mail merge application. The program generated form letters and Adobe PDF files. - Created a Microsoft .NET system administration utility program in C# - Converted WordPerfect macros to Word VBA ALLSTREAM INC. (FORMERLY AT&T CANADA) VB Programmer/Analyst: 3 month contract Jul – Sep 2003 Allstream is a communication solutions provider in the telecom and IT marketplace. Project: MS Access to SQL Server database conversion - Designed the initial SQL Server table structure, data types and relationships that were necessary to normalize the data from MS Access - Created stored procedures, ad-hoc reports, queries and mail merges - Developed VB programs and DTS packages to automate SQL Server data imports - Setup automated call center dialer campaigns using Davox GLAXOSMITHKLINE INC. Excel/VBA Programmer: 2 year contract Jun 2001 - Jul 2003 GlaxoSmithKline is a research-based pharmaceutical and healthcare company. - Created enhancements and reports for an Excel based resource management system. This application was used to forecast clinical trial workload requirements and generate reports. - Developed ad-hoc programs, scripts and macros. As a result, the time required to perform many tasks was reduced by up to 75 percent. - Designed and produced an Excel payment tracking system. The application was used to forecast budgets and saved users several days of manual work. - Created business reports using for Excel and PowerPoint using VBA and ADO ONTARIO ENERGY SAVINGS CORP. VBA Programmer: 1 month contract Jul 2002 Ontario Energy Savings Corporation is an independent natural gas marketer. - Automated manual business processes using Excel and Outlook VBA. SPENCER FRANCEY PETERS VBA Programmer: 6 month part-time contract Jan - Jun 2002 Spencer Francey Peters is a brand strategy and design firm. - Developed an application for MS Word that streamlined the process of writing a small business plan. - Created an application that automated the process of building PowerPoint presentations. TD SECURITIES VBA Programmer: 3 month contract Apr - Jun 2001 TD Securities is an investment dealer and brokerage firm. - Developed a PowerPoint presentation builder that streamlined the process of creating brand consistent presentations - Programmed an installer script to enable web deployment LIFEMARK HEALTH Access/VBA Programmer: 1 month contract Mar 2001 LifeMark Health is a health care service organization. - Designed and developed an MS Access database system to maintain financial and operational information on health care clinics throughout North America. The system produced financial reports in Excel, MS Word mail merges and maintained a communication log with each clinic. GOLDMAN SACHS CANADA INC. Analyst, Fixed Income Operations: full-time position Jan 1994 - Feb 2001 Goldman Sachs is an investment banking and securities firm. Worked with the business to automate and streamline business processes. This role involved developing, testing and supporting custom Visual Basic and MS Office applications, reports and ad-hoc solutions. - Developed live Excel spreadsheets and add-ins linked to real-time production databases and market data. - Created custom VBA macros, scripts, ad-hoc applications and reports - Developed a checkdigit calculator program for UNIX and Excel using C and VBA. This program was used to create new issue cusip and isin codes. - Automated daily ledger entries. The result was a significant reduction in accounting breaks. Trade Processing: - Confirm trades with customers, book trades and setup new issue products in firm database - Monitor order matching system and resolve breaks to facilitate the timely settlement of trades. - Reconciled futures positions and trading activity, daily account breaks and broker/dealer confirmations. - Reported bond and money market trading activity to the Bank of Canada for regulatory purposes. WORK RELATED EXPERIENCE ALEXANDRA PARK NEIGHBOURHOOD LEARNING CENTRE Jul - Aug 1998 THE SEEDS OF HOPE LEARNING FOUNDATION Jul - Sep 2000 Alexandra Park and Seeds of Hope are non-profit organizations offering a variety of training programs for adults Computer Tutor: Part-time volunteer position - Taught basic Windows PC skills using MS Office, Lotus 123 and WordPerfect. GEORGE BROWN COLLEGE 1996 - 1997 - Information Technology Systems: C Programming

3 ulasan

1.1

100%Kerja Diselesai
100%Mengikut Bajet
100%Tepat Pada Masa
25%Kadar Ulang Upah

Portfolio

Ulasan Terkini

Bonus for vbaguy on 8/7/2006 1:41:30 PM $7.00 USD
“Rating: 5.0/5.0”
ch006 Aug 7, 2006
Fixing a Pivot table problem in a VBA program (055) $2.00 USD
“Done very quickly indeed”
ch006 Aug 7, 2006
VBA(PowerPoint) macro $2.00 USD
“Very efficient and professional.”
Stefanescu E. Jul 14, 2006