Data System

Peter Bhola

[pic]

** **** ********, *******, ** M1W 3R2, Home 416-***-****, Cell 647-862-

****, *******@*****.***

Team Lead / Technical Architect

SUMMARY

Senior software engineer with extensive experience in all phases of the

software development cycle. Expert knowledge in C#, C++, C, Perl, SQL and

XSLT. Proficient in the design and optimization of databases. Demonstrated

ability to direct and motivate a team of software engineers to complete

projects, meeting specifications and deadlines. Expertise in determining

customer needs and effectively translating those needs into software

solutions. In-depth knowledge of operating system functions of both UNIX

and Windows systems. Successfully completed many projects converting legacy

systems to run in UNIX and Windows environments.

SKILLS

. Programming Languages: C#, C, C++, SQL, PERL, Unix scripts, XSLT

. Operating Systems: Windows7, Windows XP, UNIX (AIX, SCO, HP-UX, QNX,

LINUX)

. Databases: SQL Server 2005, SQL Server 2008, Oracle 9i, Oracle 10g,

Sybase, Informix, SQL, Stored Procedures, ODBC

. .NET Technology: ASPX, AJAX, XSLT, JavaScript, WPF, LINQ, SOAP, WEB

Services, Multithreading.

. UI Design: WinForms, WPF, WEB Pages, Telerik, Infragistics

. Object Oriented: UML, Design Patterns, MVVM

EXPERIENCE

Endo Networks, Oakville, Ontario

Team Lead

2013 August - 2014 Sept.

Technical Architect for a Web based system used in marketing surveys - led

a team of five developers..

. Designed a Web based system using MVC framework and Windows Workflow

where a user of the screens, can adjust the control flow using the

workflow designer. This allowed the application to be modified in the

field without re-compiling it.

. Prepared the design documents and delivered proto-types of all high

risk components of the project.

. The work consisted of 40% front-end ( using the MVC HTML helpers,

JavaScript and JQuery) and 60% back end ( using C# and TSQL) - which

involved bug fixing and product enhancement.

. Based on an abstract model of the screens, used Selenium to automate

the testing of various screen sequences.

. Maintain a program based on the WPF/XPS technology to print customer

applications and coupon offerings for a major merchandiser

. Extended functionality of legacy systems by using WCF and REST web

services.

Technology Skills: MVC, Windows Workflow, Selenium, C#, WPF,WCF, SQL 2012,

.NET 4.5

Research in Motion, Waterloo, Ontario Sept., 2010 to March, 2013

Software Developer

Responsible for the support and enhancement of the

authentication/authorization system, for the software tools, used to test

the handheld devices on the manufacturing line. Participated in Global

incident management whenever remote manufacturing sites were impacted by

the unavailability of the system.

Designed and implemented a sub-system (Test Results Storage Manager) in the

new test framework, to collect and render data, from the board level tests

performed on the assembly line.

. Deployed an Oracle failsafe cluster to handle additional load during

peak manufacturing periods.

. Provided support in all components of the system which included IIS,

Aspx pages, SQL Server 2008 and Oracle 10g.

. Designed a multi-threading system, enabling various test processes to

send data concurrently from all the devices within a test fixture.

Extended the flexibility of the system to write to various data

repositories by the use of plug-ins. This allowed the data to be sent to

the Oracle manufacturing database,local XML files and WCF based

repositories.

. Implemented a WPF interface to configure the storage manager and

view the data generated by a test.

. Designed and implemented new ways of visualizing the data using the

treemap controls and hierarchical grid.

. Technology/Skills: C#, ASPX,WPF,WCF, T-SQL, Oracle Failsafe Cluster,

SQL 2008, XSLT, Multi-threading, .Net thread-pool, .NET 3.5, NET 4.0

Short Term Contracts, Toronto, Ontario 2009 to 2010

Programmer/Analyst

S2h Web

Support and enhance web based hotel management application.

New Horizon System Solutions

Replaced EXCEL spreadsheet incident reporting system with WEB based

application.

Provided support for VB6 and Centura applications.

. S2H Web: Added modules to submit payment to PayPal in various

currencies.

S2H Web: Added feature to allow the user to view historical data

. New Horizon System Solutions: Designed and developed incident

reporting system to log software issues in the nuclear plant.

New Horizon System Solutions: Provided support for VB6 and Centura

applications. Speed up slow running SQL programs.

. Technology/Skills: C#, SQL Server 2008, T-SQL, VB6, Oracle 9i, ASPX,

JavaScript, AJAX

KEANE CANADA, Markham, Ontario July, 2005 to August, 2008

Principal Consultant assigned to Morgan Stanley

Designed and implemented a new Corporate Debt Management System for Morgan

Stanley.

Re-engineered the debt accounting security system

. Designed and implemented the GUI screens for the new Corporate Debt

Management System on the .NET platform. This involved the creation of

screen design documents, the writing of C# programs for Windows forms and

ASP.NET, and providing the backend support by writing over 200 stored

procedures in Sybase. Designed and implemented a Web Based (ASP.NET)

system to allow support personnel to monitor batch and online systems in

the Morgan Stanley Corporate Accounting department.

. Re-engineered Morgan Stanley authorization backend to use the SOX

compliant Web services instead of relational database.

. Provided different ways of visualizing and navigating the data.

Improved the response time of the Web pages by shifting to client side

processing using Ajax and JavaScript. Wrote stored procedures for both

Sybase (SQL) and SQL Server 2005 (T-SQL) databases.

. Technology/Skills: C#, ASPX, JavaScript, SQL 2008, Sybase, SQL, AJAX,

Web Services, SOAP

Infochrome Software, Toronto, Ontario 1992 to 2005

Software Consultant

Provided consulting services in Project Management, designed and developed

software systems for small to mid-range companies in many industries as

itemized in the following sections.

Lombard Insurance, Toronto, Ontario April, 2003 to Sept., 2005

Architect/Developer

Led project, comprising six developers, to re-engineer the automobile

rating system from an IBM mainframe to Web based, service oriented

applications running on a set of Windows servers. Re-distributed the

functionality in XSLT, C#, ADO.NET, ASP.NET, MS-SQL stored procedures (T-

SQL) and used the SOAP protocol to bridge the processes residing in the

different servers.

. Designed and developed C++ parsers packaged as DLL's, to convert the

industry based CSIO standard files to XML format thereby facilitating the

input to be processed as XML data.

Designed and developed data transformation programs in (C# and DTS) to

convert and load ISAM files in SQL server tables.

. Designed the SQL 2005 database to hold the auto rating information.

. Technology/Skills: C#, VB, ASPX, C++, Web Services, SQL 2008, SQL,

Perl

McKenzie Financial, Toronto, Ontario 2001 to 2002

Senior Program Analyst

Provided GAP analysis of existing PL/SQL data cleansing programs. Designed

and implemented improved data cleansing programs in Perl using

sophisticated pattern matching and data correction techniques to fix large

volumes of erroneous data.

Migrated the Oracle 32 bit applications to the HP-UX 64 bit system.

Worked on a project to update the data marts daily, to replace the end of

month process that regenerated them from scratch.

. On a database of over 7 million subscribers, was able to

significantly reduce the cost of misdirected quarterly statements that

were sent in the mail. The program was successfully used in the RESP

system.

. Converted 32 bit C, C++ and Pro C* programs to use Oracle 64 bit

shareable libraries.

. Wrote Perl programs to analyse the SQL statements within each data

mart and, generated filters that exported data that was referenced by

these SQL statements. This avoids the importing of extraneous data in the

data marts.

. Technology/Skills: Oracle 9i, Mod Perl, C, C++, SQL, HP-UX

Purolator Courier, Mississauga, Ontario 1998 to 2000

Senior Programmer Analyst

Played a significant role in the migration of the data and programs of the

existing Honeywell mainframe system to the UNIX based HP-UX system.

. Performed data flow analysis of programs by analysing the JCL using

Perl and AWK scripts. Identified data dependencies and provided

strategies for the data migration.

. Identified and corrected the processes that failed when running

against a database with various integrity constraints.

. In the parallel testing phase, used many strategies to uncover data

inconsistencies which included the use of SYNCSORT program to provide

data snapshots from inter-related files and modified programs to provide

snapshots of high volume data to facilitate subsequent analysis by spread

sheet.

Pharma Plus Drug Stores, Etobicoke, Ontario 1994 to 2000

Senior Programmer/ Analyst

Responsible for advancing the Pharma Plus Drugstore systems, which were

standalone UNIX based systems, to a higher level of integration with

external third party systems. Automated many of the manual procedures

bridging the various systems within the drugstore and the head office

thereby achieving greater efficiencies.

. Automated the client's manual software installation procedure so that

software could be remotely installed from the head-office - removed the

need to send personnel to the stores to install the software.

. Designed and implemented the Pharma Plus Payroll system, using Perl

and C, to collect timesheet information from all the retail stores to

produce payroll data that were uploaded to the Ceridian Payroll centre.

Involved in all aspects of the project from proposal stage right thru to

post implementation.

. Enhanced the standalone systems in the drug store chain to perform

third party submissions to the Ontario Drug Board and other insurance

companies. Analysed and documented the underlying application protocols

and improved their robustness. Participated in the certification sessions

where the software successfully passed a battery of tests prepared by the

Ministry of Health.

. Designed a system that allowed a user in head office to submit price

list updates, store alerts and other information by lotus notes mail.

This information was routed to a central UNIX server and uploaded to the

appropriate stores using the FTP protocol. The lotus user was able to

query the status of the file transfer requests.

. Most of the skills employed were UNIX based C, Perl, AWK, Informix

and various shell scripting languages.

Carried a pager and was responsible for after hours support.

EDUCATION AND TRAINING

University of Waterloo, Waterloo, Ontario

Bachelor of Mathematics (Computer Science)

University of Toronto, Toronto, Ontario

Master of Science, Computer Science

AWARDS

Rim Innovator Award

2012

COURSES AND SEMINARS

Project Management, WPF, WCF, Technical Writing

SPECIAL INTERESTS

Creative Writing, History of Science and Mathematics

COMMUNITY INVOLVEMENT

Secretary for the Toronto Queen's College Alumni Organization

2001-2008

Participated in canvassing for the Kidney, Heart and Stroke Foundation

Participated in the meals and wheels program

Contact this candidate