Paul Saini

Brampton Ontario 647-***-**** acb538@r.postjobfree.com

LinkedIn: http://ca.linkedin.com/pub/paul-saini/25/163/614/

Education

Graduate degree in Computer Science and Engineering, given full equivalency by University Of Toronto.

Salesforce Certified Developer (DEV 401)

Salesforce Certified Administrator (ADM 201)

Salesforce Certified Advanced Administrator (ADM 301)

Building Cross-Platform XML Applications - Course 544, from Learning Tree International Toronto

Building XML Web Services with NET - Course 508, from Learning Tree International Toronto

SQL Server 2000 Reporting Services: Hands-On - Course 523, from Learning Tree International.

CPA Payroll Compliance Legislation & Payroll Fundamentals 1

Employment Overview:

BlackBerry, Waterloo, Ontario April 2012-Present

Position: Salesforce.com Developer, Contract

BlackBerry is a telecommunication company and manufacturer of Blackberry devices.

• I had worked on several Salesforce.com instances with core tasks ranging from development of

new screens, data integration with internal systems, data upload and data transfer, development

of triggers, visual force pages and apex classes, troubleshooting issues and maintenance of

systems. Used Visualfroce, Apex, JavaScript, Css

• I had worked on integration project to link BlackBerry Account Center with Salesforce.

Salesforce is being used as data repository and all customer interactions are completed in a Java

system. Data integration is done via Web Service calls in a transaction.

I had developed Web Services in Apex, created custom entities for data exchange and all

business processing rules.

• Designed web service WSDL using SOAP editing tools to define web service endpoint operations

and data exchange xml data entities.

• Designed and developed Salesforce.com to SAP MDM bidirectional data flow integration system,

complete with logging, auditing, exception handling, and authentication.

• Service cloud implementation: Setup Knowledge and customize Case and other objects.

Delivered Web to Case and Email to case functions.

• Data Integration with BlackBerry World. Designed and developed a data integration strategy and

web services which retrieve data from BlackBerry World and save into a custom data schema in

Salesforce.

• Salesforce administration tasks and data maintenance and production support.

Technical Environment:

Salesforce.com, Apex data loader, Force.Com IDE,.Net, SOAP, xml, web services, WSDL, XML Schema,

GitHub for version control, MS Visio for workflow authoring, REST API, BlackBerry WebWorks, Visual

Force, Apex Triggers.

Transamerica Life Canada, North York, Ontario August 2011- April 2012

Position: Salesforce.com implementation and data integration developer, Contract

Transamerica Life Canada is a life insurance company.

Transamerica has decided to implement a framework of managing insurance agent’s activities on

Salesforce.com CRM platform.

• Worked as lead developer in design, documentation and development of converting

Transamerica's new Sales & Marketing Workbench CRM using Salesforce.com. System is used

to track insurance advisor activities and monitor their performance and building relationship with

Transamerica to sell insurance policies.

Activities included, business analysis and meetings with different departments, design data

entities, write Apex code, custom Visual force pages, triggers, test classes, reports, dashboards,

develop data integration solution to transfer data between Transamerica’s database servers and

Salesforce.com

• principles to convert data entities like insurance advisors, policies, insurance premiums into

custom objects in Salesforce.com

• Created reports and dashboards in Salesforce.com

• Designed and developed data integration solution using SQL Server Integration Services (SSIS)

and SFDC Apex web services. Insurance and policy related data stored in various data sources

like DB2, SQL Server and Excel sheets is brought into Saleforce.com.

• Designed Single Sign ON (SSO) into Salesforce.com using SharePoint 2010 portal

authentication.

Technical Environment:

Salesforce.com, Apex data loader, ASP.Net 4, MS Visio for technical architecture diagrams,

VMware, Burlington Ontario April 2011-August 2011

Position: Salesforce.com solution developer, Contract

VMware, a global leader in virtualization systems has implemented its CRM and partner relationship

management system on Salesforce.com

• Designed and developed an extension to VMware’s existing partner portal system, to be able to

host widget type mini applications. VMware’s partners are now able to see a customized portal

page. It offers trouble shooting articles, license information based on what a partner is reselling.

• I had analyzed existing support and case tracking system at VMware and designed and

developed a solution to customize Case, Contact and Account objects and create new objects in

Sales force. I had worked with technical support engineers, followed lifecycle of a support ticket in

multiple scenarios and customized Salesforce.com objects based on requirements. All customer

support cases are now routed to the right channel effectively and efficiently.

• As a developer I had created custom objects in Salesforce.com, created triggers and validation

rules, wrote apex code to query data sources external to Salesforce.com, created test classes

and developed mini applications. I had developed mini applications that search VMware’s

knowledgebase content using Google Search Appliance (GSA) and present formatted results in

Salesforce.com visual force pages.

• Designed and developed data restriction strategy for VMware’s knowledgebase content.

• Analyzed VMware’s partners portal system to track VMware’s product reseller’s certifications and

technical accreditations.

Technical Environment:

Salesforce.com, Force.com IDE, Apex classes, visual force pages, MS Visio for technical architecture

diagrams, Google Search Appliance (GSA) query optimization, SVN subversion control.

ADP Canada (Automatic Data Processing), Mississauga Ontario

Position: Senior Programmer Analyst June 2008-April 2011

ADP Canada is a payroll processing company providing payroll and employee benefits services.

• I had worked on integrating Salesforce.com CRM with ADP internal applications.

• Salesforce.com CRM is used by sales agents and I had worked on querying and bidirectional

data transfer from salesforce.com CRM to ADP's internal applications.

• I had worked as senior ASP.Net programmer on project that integrates company’s payroll systems

with employee benefits systems.

• Used Enterprise Library, for data access, logging, and validation and custom rules.

• Designed and assisted development of custom security library, http modules, authorization library

using strategy pattern.

• Utilized entity framework for C# classes for the next release of the payroll application.

• Designed and developed employee benefits reports with payroll data using Crystal Reports

Technical Environment:

.Net 4.0, 3.5, C#, ASP.net, ADO.net, SOA, SOAP, WCF, AJAX, MS SQL, Windows Services, IIS,

Windows Server 2003, 2008, MS-Unit Test framework, SVN Subversion, nUNIT, Microsoft Enterprise

Library 4.1, Salesforce.com, Apex code, SharePoint 2007, Crystal Reports, SSRS

Buchanan Associates, Mississauga Ontario

September 2006-June 2008

Position: Senior Programmer

Buchanan Associates is a software consulting and outsourcing firm. As a software consultant and

application developer I was assigned to in-house projects and external offsite projects on client's location.

Following is a summary of on-site client projects.

Client:

Peel Regional Police, through Buchanan Associates, Brampton Ontario

Position:

Senior Application Developer

Project:

Records Management System (RMS) Reports

Environment:

.Net 2.0, ADO.Net 2.0, XML, C#, Windows Server 2003, Sql Server 2005, SSRS,

Visual Basic (VBA), Ms Access Macros, Share Point, Power Builder, Unix

Tools:

Visual Studio 2005, MSOffice, SQL Server Reporting Services 2005 (SSRS),

UML designer, MS Visio 2007

Description:

Peel Regional Police is in the process of updating its Records Management System. Currently all 911 and

police occurrences are recorded in a Unix based system. Peel Police have purchased a records

management system from a 3 rd party but reports (property, occurrence related) need to be custom

written.

I joined as a reporting developer and designed and developed reporting applications using client's custom

data source. Data Source is a 3 rd party data server using Sql Server 2005. I designed and developed a

data transfer application to be used as a data source using XML web services. There are more than 40

reports categorized into Property Reports, Daily Occurrence Reports, Daily Accident Reports etc. There

was no Business Analyst allocated and thus I had the opportunity to also work as a Business Analyst and

be able to gather and document requirements.

Responsibilities:

* Communicate with business users and gather requirements.

* Create a prototype of desired solution and give presentation about proposed solution.

* Create a high level design and development document about proposed solution containing

system architecture, process workflow and tools used.

* Create input use cases, output use cases and data structure objects.

* Engage in meetings with business users; create a business requirement document containing all

description and purpose of each report, deployment model and database fields as identified in the

main RMS application.

* ASP.Net code development in C# using Visual Studio 2005. I had used dataset designer in Visual

Studio to represent data structures and relationships and c# object inheritance relationships.

* Code development in .Net in a distributed environment using C#, created and consumed XML

web services on a data tier for data exchange.

* Understand data server class hierarchy provided by 3 rd party program and write data retrieval

SQL statements for conforming to data server syntax.

* Report design and development using SQL Server Reporting Services 2005 and ADO.Net

* Report deployment and scheduling using Report Manager and Sql Server 2005

*

Client: Brendan Wood International, Toronto, through Buchanan Associates

Description:

Brendan Wood International examines major financial transactions and sells deduced intelligent

information to its clients. As a senior developer I was deployed on-site at Yorkville location.

Projects:

Designed and developed a charting and data visualization application using 3 rd party charting tool that

plots historical financial deals information on a bubble and bar chart and automatically creates a power-

point presentation.

Environment:

Tools: Visual Studio 2005, Sql Server Reporting Services, 3 rd party Charting control.

Responsibilities:

* Created requirement and development process plan document.

* Windows service project development using VB.Net, Dundas Chart control and Excel.

* Write ad-hoc data retrieval Sql queries using TSQL and .Net CLR functions.

Internal projects for Buchanan Associates

Description:

As a senior developer I was assigned to in-house client projects as summarized below.

* Created an application updater module as Windows service project that allows application to

update itself.

* Converted an asset management and time tracking ASP web portal to .Net framework web portal

using ASP.Net 2.0

* Wrote and modified SQL Server stored procedures, wrote new stored procedures using .Net

CLR. Analyze database queries using SQL profiler.

* SharePoint Services 3 web parts development and installation on Windows Server 2003.

* Code development for ASP.Net web portal using custom web parts.

* Worked on an application that monitors hardware devices on the network and manages device

inventory data, device history and creates automatic alerts if a device is down.

* Created documentation and troubleshooting document using MS Word and MS Visio.

* Provided code documentation and created user help files in .chm format.

Transamerica Life, North York, Ontario

November 2005-September 2006

Position: Senior Programmer

Description

Transamerica Life Canada sells life insurance policies and investment fund products. I joined as a .Net

developer on a contractual basis.

Description:

The client sells insurance policies and a lot of online content needs to be updated by different groups on a

routine basis. I designed and developed a prototype for custom content management system that utilized

Info Path installed on content contributor's machine and publishes it on the web portal.

I had done code development in ASP and ASP.Net, html, JavaScript to maintain AEGON information

portal.

Project: A web portal that keeps track of Insurance agents and their activities.

Description:

The client has advisors and insurance policy brokers that send Excel worksheets to main office and are

dumped on a shared folder and are processed manually. I had done analysis on developing a web portal

that lets insurance brokers log in and update insurance policy content.

Project:

I had worked on reporting portal that lists insurance policies and summarizes data in a drill down

collapsible fashion. Used Sql Server Reporting Services 2000 and ASP.Net 1.1

Bank Of Montreal, downtown Toronto (Sept-2000-Nov 05), Application Developer

As web Developer & Architect, I worked on a totally interactive evaluation system where an employee can

evaluate her peers as well as her managers based on different skill set.

The system also generates reports, which lists the score how others evaluated him or her and how did the

employee evaluated others.

This web application was developed on Windows 2003, using ASP.NET and MS SQL Server 2000,

HTML, XML, CSS, JavaScript, Crystal Reports .Net Responsibilities included functional design, code

development, and testing/quality assurance and support.

I designed and developed an application that captures and reports on historical FX rates.

The bank needs to store historical information on exchange rates on currencies.

FX rates are provided by an external party Tiblink through an excel spreadsheet macro.

I used VBA to extend excel macro to insert FX rates in a Sql Server database on a periodic basis.

This system also has a web front that lets user search historical FX rates.

I helped develop and maintain a web based system for calculating Risk Factor in granting loans.

It replaced the process of manual data collection and analysis by sales people.

This system performs complex calculation and is based on based on SQL Server 2000 and Excel 2003.

The system automated the risk forecasting process and reduced the time spent on data collection.

I extended an existing Siebel based CRM system by giving investment professionals access to client

portfolio information and other key data.

As Internet Developer, I developed Service Catalogue Web Portal which is designed and implemented to

allow different service group users / owners to have quick and user-friendly access to the service level

agreement information through the web browser over the intranet.

The Portal Service is data-driven based on the SQL 2000 Data transformation services.

As an application developer, I developed several Microsoft Access & Excel applications, catering to

internal resource management. The applications were designed to manage internal and external

resources and provide the human resource department and upper management with extensive reports on

candidate’s skills, experiences, and availability.

The applications were developed in MS Access 2000 and included 10 ad hoc and structured reports.

Responsibilities included gathering and analyzing user requirements, performing database design and

tuning, developing dynamic reports, and providing maintenance support.

IMS (Inquiry Management Systems), Mississauga Ontario (Feb-99-Sept 2000)

Internet Applications Developer

IMS is a database company that refines stores and publishes data on behalf of its clients.

As ASP developer I developed several in-house applications that keep track of client orders.

The clients can also log in and query about their order status.

As a Database developer I coded several sql-server stored procedures for data queries, data

correction/data cleaning, data formatting, database server synchronization and data transformation.

As a VB/ASP Developer, I implemented and developed the technical design and database schema for

projects that required to be changed from client-server environment to web based systems.

Other activities included: Design and code software according to specifications.

Work with client's requirements to develop conversion and implementation plans, and provide

programming and technical support to ensure smooth program implementation.

CET (Peel District School Board), Mississauga, Ontario (Nov 1998- Feb 1999) Web Developer

Developed online database publishing, project management system.

The project involved Data Entry Screens, Report generation, automatic email notification.

Skill used: Html, JavaScript, HTML & VBScript, ASP, SQL Server 7.0, IIS 4.0

Vickers & Benson, Toronto, Ontario (July-Oct 1998)

Web Application Developer

I Worked on a web based database-publishing project for Canada Post.

The system tracks, accepts and publishes reservations made by the employees.

The web application allowed customers & employees to subscribe to different email newsletters,

generated the specific email (with dynamic content), and delivered the email to the customers.

This web application was developed on Window NT 4.0, using Cold Fusion 3.0, SMTP service, and MS

SQL 6.5. Responsibilities included: code development, and testing.

Volunteer Work: Our Place Peel: Mississauga, Ontario (Oct 2007- Feb 2008)

Our Place Peel is a registered non-profit charity that provides residential and support services for

disadvantaged and homeless youth 16-21 years of age in Peel Region.

I had volunteered to spend my time designing a data entry and reporting application.

This data entry and reporting system has replaced all manual work of tracking youth stay at the hostel.

This application provides dynamic reporting and creates invoices based on selected time period.

* Created data entry application using C# 2.0

* Created Reporting Application using Reporting Services 2005 and .Net CLR

* Created custom web parts for internal Share Point site.

Hobbies: Snowboarding, listening to music and working-out.

• Annexure – Skill Matrix

o o Last Used •

Progra Version Years’ experience

•

o o

o o Presently •

ASP 2.0, 3.0 9

o Presently •

o

Java 9

o Presently •

o

VB.NET 9

o o 2005 •

Lotus 3.0 1

o Presently •

o

Vb 3

o o 1998 •

BASIC GW, Q 2

o 2000 •

o

C 1

o 2001 •

o

C++ 1

o o 2001 •

Java 1.2 0.5

o 2005 •

o

VBA 4

o o Presently •

ASP.NE 1.1, 2.0 9

o Presently •

o

C# 6

o o •

Last Used

Web Versio Years’ experience

•

o o

o o •

Presently

IIS 3.1, 9

o o •

Presently

HTML 4.0 9

o •

Presently

o

DHTML 6

o •

Presently

o

CSS 5

o •

Presently

o

XML 6

o •

2003

o

Windows 1

o o o

o

AJAX Presentl 4

o o Last Used •

RDBMS/ Version Years’ experience

•

o o

o o o o

Oracle 8i, 9i, Presentl 3

o o o o

MS-SQL 7.0, Presentl 9

o o o o

MS- 97, 2000 Presentl 6

o o o o

Foxpro 2.6 2000 2

o o •

Last Used

IDEs Version Years’ experience

•

o o

o o 2002 •

Visual 5, 6 3.5

o o 2005 •

Lotus 5 2

o o Presently •

Visual 7.0, 8.0 9

o o 2005 •

Lotus 5 1

o o •

Last Used

Group Version Years’ experience

•

o o

o o o o

Lotus 4.5, 5.0 2005 3

o o o o

Domino 4.5, 5.0 2005 1

o

o Versions Last Used •

Network Years’ experience

•

o o o o

Window 3.5, 4.0 2001 4

o o o o

Window 2000, Presentl 8

o o o o

DOS 6.22 2000 5

o o o o

Linux 6.0 – 7.1 2001 2

o •

Versions Last Used

Reporti Years’ experience

•

o o

Crystal Reports 8.0, 9.x 2008 3

o o

SSIS, SSAS, SSRS Presentl 2

o Versions Last Used •

IT Years’ experience

•

o o

Citrix Presentl 2+

o o

SVN, CVS, VSS Presentl 5+

o o

FTP, PGP, SSL Presentl 5+

o o

Release Management Presentl 3+

o o

Change Control/ Request Presentl 4+

Management y

o o

ITIL Process Knowledge 2009 1+

Contact this candidate