
@vbguy
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
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”
ch006Aug 7, 2006
-
Fixing a Pivot table problem in a VBA program (055) $2.00 USD
“Done very quickly indeed”
ch006Aug 7, 2006
-
VBA(PowerPoint) macro $2.00 USD
“Very efficient and professional.”
Stefanescu E.Jul 14, 2006
Pengesahan
-
Facebook Disambung
—
-
Freelancer Keutamaan
—
-
Bayaran Disahkan
—
-
Telefon Disahkan
—
-
Identiti Disahkan
—
- E-mel Disahkan
Kemahiran Teratas Saya
Cari Freelancer yang serupa
Pengguna Sebelumnya
Pengguna Seterusnya