Post Job Free

Resume

Sign in

Sql Server Developer

Location:
Mississauga, ON, Canada
Posted:
November 19, 2013

Contact this candidate

Resume:

Pras Biswas BizTalk Architect

Contact Integration Analyst and Developer with over 17 years of IT

industry experience. Over 7 years of BizTalk and ESB

E: experience in over 8 projects. Currently specialized in

aca25e@r.postjobfree.com implementing application integration with a focus on the

M: 1-905-***-**** integration technologies and methodologies (BizTalk, WCF,

T: 1-905-***-**** SSIS, Windows Workflow and the ESB pattern)

W:

blog.percepsys.com

W: LinkedIn Highlights

http://tinyurl.com/

prasb Deep experience with the full spectrum of Enterprise

Information Systems accumulated over 17+ years in IT

Consulting - EAI, B2B, A2A, portals, business

Essays intelligence, workflow, e-Learning, content management,

information architecture, Web Analytics, CRM, etc

SOA - what it's not

Significant experience with middleware and integration

tinyurl.com/isnotso technologies (.NET based - BizTalk, WCF, SSIS) - over 7

a integration projects completed since 2005

Why SOA? Full lifecycle experience architecting scaleable

tinyurl.com/whysoa applications built using the SOA paradigm; with the last 2

Microsoft Data projects major SOA implementations

Access strategies

tinyurl.com/msdataa Sensitive practitioner of architecture practice balancing

ccess stakeholder desires, defining structure, focusing on

EAI or ETL? significant elements, guiding behaviour, and conforming to

tinyurl.com/eaioret proven styles

l

Domain expertise in Insurance (Travel, Life, P&C, Titles),

Business Data Supply Chain, Human Capital Management and Training, Call

Dictionary from Centers, Banking, etc

Schemas

tinyurl.com/bizdata

dic Relevant Experience

Manulife Financial Solution Architect

. . . . . . . . . . Mar 09 - Dec 10

. . . . . . . . . . $600 million Business Unit with 550+ employees

. .

Re-architected Manulife's Affinity Business Unit Travel

Insurance systems from scratch due to end-of-life systems

Paradigms (currently Canada's no 2 Travel insurer, with revenues of

$600 million)

Service Orientation

Envisioning the future state while articulating

Enterprise Service architectural principles, SOA best practices to shape

Bus system architecture which is very integration intensive

Master Data Mgmt (with legacy systems integration)

Business Rules Architected the ESB (Enterprise Service Bus) for Future

Mgmt State, using BizTalk and the ESB Toolkit 2.0

Business

Intelligence Developed the Travel Insurance Service Contracts (based on

Information the OpenTravel standard) using BizTalk Schema Builder

Architecture

Responsible for the technical output of over 30 developers

from 3 different vendor teams (Web, Policy Admin,

Recommendations Integration)

tinyurl.com/prasbuz

z Engaged in architecting and development of the E-Commerce

website coverme.com for marketing and selling insurance

plans using a Commerce Server 2009 accelerator built on

SharePoint 2007

Mohsin Khalil hired

Pras as an Technologies: EA, SOA, ESB, BizTalk, WCF, .NET 3.5,

Integration SharePoint, PCI, SAML

Architect in 2008

"Pras demonstrates First Canadian Title Solution Architect

a high level of Nov 2007 - Jan 2009

technical $380 million with 300+ employees

competence in

BizTalk and other Provided Technical Leadership in a large project with over

MS technologies. He 25 developers to build a low-touch, paperless "technology

possesses practical highway" between lenders and lawyers

hands-on experience

and keeps informed Interacted with business to align solutions to

of the latest requirements. Socialised the Architecture with the Business

integration tools and the Architecture Review Board

and technologies.

He gladly shares Responsible for creating and maintaining the

ideas and displays solution/application concepts/architectures, technology

a harmonious and reference implementations, architectural guidance, schemas

cooperative spirit. and interfaces, application tiers, frameworks, software

I would recommend factories mostly using .NET

him for any

integration project Defined, consolidated and standardized the technology for

without a second EAI and B2B integration into a unified ESB Architecture

thought." pattern

September 21, 2009

Defined the Non Function Requirements for performance,

Top qualities: scalability, maintainability etc

Great Results, On

Time, Creative Created and maintained relevant Standards and Guidelines

. . . . . . . . . . and ensured their governance while recommending appropriate

. . . . . . . . . . SDLC toolsets

. .

Worked with Security Officer to model the threats and

address the vulnerabilities discovered on the web tier

Kelly Andrew Heard

, Software Technologies: BizTalk 2006 R2, SaaS, SOA Factory, ITIL,

Development Lead, WCF, UML, ESB

Cactus Commerce

managed Pras at Adea Solutions (Dallas) Integration Architect Mar

Cactus Commerce: 2007 - Dec 2007

USD $400 million with 200+ employees

"Pras produced

complex Involved in a SeeBeyond migration project for a

architectures for Dallas-based large US Environmental client in a large

integration project with over 10 developers

components under

very tight time As an EAI Architect, my job was to participate in deciding

constraints. His the migration strategy, translate complex business

design documents requirements into technical architecture; produce

were clear, concise high-level designs and architectural blueprints that was

and provided for a used by the technical team to implement solutions

very good starting

point for further Provided Conceptual/Logical data for specific

development. If solution/application in an architect role involved in

extra time was evaluating migration strategies, and translating e*Gate to

required to finish BizTalk

a task, there was

no hesitation in Interfaced with SAP using the BizTalk adapter to exchange a

putting in the variety of customer, contract, service, pricing and billing

additional effort. data with SAP

I would not

hesitate to Performance Lab I led in this project was involved with:

recommend Pras." Identifying the performance testing strategy and acceptance

criteria

. . . . . . . . . . Performance testing methodology: tools & processes

. . . . . . . . . . Analyze and Recommend: provide guidelines for

. . infrastructure architecture, clustering, load balancing,

performance tuning, etc

Technologies: BizTalk 2006, SUN SeeBeyond, SAP adapter,

Oracle, .NET

Sean Chard managed Maple Leaf Foods ETL Developer (freelance) Jun 2007

Pras as a BizTalk - Dec 2007

Consultant at

Chapters Indigo in Senior developer in a Freelance role to architect ETL

2006: solutions using SSIS in SQL Server 2005

Developed 3 SSIS packages to synchronize orders between an

"Pras did some ERP system and Hand Held DB in high volume (150,000 records

consulting work for daily) and high availability business critical

Indigo a couple applications.

years ago. He was Role involved analysis, design, development,

very professional implementation, performance testing and support of complex,

and delivered legacy data between with many business rule mappings.

excellent work on

the projects he was Technologies: SSIS, BizTalk 2006, SQL Server 2005, Web

involved with. We Services, Oracle 10g

would definitely

bring Pras back"

Cactus Commerce Integration Analyst May

Top qualities: 2006 - Mar 2007

Great Results, $300 million with 180+ employees 3 projects

Expert, High

Integrity Chapters Indigo Involved in B2B and EAI supply chain import

into Chapters Indigo's main product catalog, compiled from

. . . . . . . . . . different channels and vendors (books, music, video, SAP,

. . . . . . . . . . etc). High volume replenishment and updates handled in real

. . time with substantial preprocessing. Designed and

architected the DTS/SSIS packages, BizTalk messaging

Scott Cairney, Folica.com E-Commerce project involving a front-end MS

Vice President, Commerce Server 2007 deployment and Axapta at the back end.

Enterprise Used the new Commerce Server adapters to move products from

Collaboration and Microsoft Dynamics (Axapta) to Commerce Server and Orders

Integration, the other way. Also included extensive payment

Cactus Commerce authorization in the middle tier - Credit Cards, PayPal,

managed Pras E-Check, etc through CyberSource.

indirectly at

Cactus Commerce Created the integration architecture SRS, high-level

design, guided and mentored resources and partners.

integration architecture patterns such as asynchronous

"Great to work with messaging, correlation, long-running transactions were used

Pras, smart and for a reliable, high performing solution

customers love

him!"

Credit Valley Hospital - HL7 (Health Level 7) deployment

. . . . . . . . . . and migration for back-end hospital information system

. . . . . . . . . . (HIS) from BizTalk 2004 to 2006

. . Technologies: BizTalk Server 2006, Commerce Server 2007

Adapters, Oracle 9g, CyberSource, XSLT, XPATH, SQL Server

Pardo Mustillo 2005, SSIS, DTS, EDI, cXML

hired Pras as a IT

Consultant in 2005, DirecTV (Los Angeles) Enterprise Solution Architect

and hired Pras more Feb 13 - Sep 13

than once

At DirecTV in Los Angeles, California, I oversaw

"Pras was large-scale enterprise projects - evaluating impact on

instrumental in integration, reliability, performance, scalability,

bringing our staff flexibility and maintainability. Typical budget in

up to date on millions.

SCORM. He provided

the boost and For the B2B consumer website directv.com I advised on

encouragement that Social Media Strategy and architected a project to

we needed. I highly implement wide ranging enhancements in the site including

recommend him for mobile access:

his thoroughness

and technical Enable real-time access to programming and account from any

insights." type of mobile device, including smartphones and tablets.

Deliver common message transformation, integration, and

Top qualities: routing.

Great Results,

Expert, Good Value Involved in the architecture and implementation of

DirecTV's mobile integration with the EI layer. Researched

and designed flexible, sustainable and scalable

. . . . . . . . . . architecture for mobile apps that have significantly less

. . . . . . . . . . resources, limited bandwidth and slow connection speeds.

. . Responsibilities include ensuring the mobile solutions can

be monitored, instrumented, and supported in a scalable

environment.

Technologies Technologies: EA, UML 2, Mobile integration, BPNM, CRM

BizTalk Server TD Insurance Solution Architect Apr

200*-****-** - Jan 13

Visual Studio

2005-2008 Enterprise Business Initiatives in Direct Life and Health

C# and .NET 3.5

WCF Understand and communicate the big picture, business

SharePoint functions and the goals for new solutions in the Strategic

2007-2010 Plan

SSIS 2005 Map business problems and requirements to end-to-end

Commerce Server technology solutions in Policy Administration

2007 Participate in enterprise initiatives to align top-down

ASP.NET 3.5 / M-V-C goals (Master Data Management, Enterprise Data Dictionary

and others) with bottoms-up realities - achieve a sweet

AJAX / Rich spot

Internet Ux

Business initiatives - Business, Data, Application,

. . . . . . . . . . Technology

. . . . . . . . . .

. . Architect and oversee new business initiatives in a mesh of

packaged applications, legacy systems, and bespoke and

Certifications homegrown line-of-business (LOB) applications

MCTS Technologies: EA, SOA, TOGAF, Zachmann framework, data

MCAD architecture

MCP.NET

ING DIRECT (USA) Lead Developer/Analyst May 2005 -

MCP Transcripts May 2006

Transcript ID :

761283 Involved in architecting, designing and developing a SOA

Access Code: (Service Oriented Architecture) framework for ING's

b38I23p34z8 internal HR processes (through Toronto-based outsourcer

devtopia)

Working on TOGAF

Business processes and human workflow is decomposed into

. . . . . . . . . . sets of loosely-coupled, discrete sub-processes which are

. . . . . . . . . . then re-aggregated into composite services via an editable

. . web-based workflow configuration tool

Methodologies The result is a SaaS (Software as a Service) set which is

completely configurable while providing clean separation of

Agile programming business objects, business processes and business rules

ATAM into an efficient, scalable solution upholding SOA tenets

RUP / UML and best practices

TOGAF/ Zachman

SCRUM The SOA (Service Oriented Architecture) Implementation

. . . . . . . . . . Framework for ING Direct, USA, is based on the MVC

. . . . . . . . . . (Model-View-Controller) design pattern to present and

. . manipulate different views of the same data structures

Practice Technologies: BizTalk Server 2004 HWS, SOA, C# .NET, M-V-C

pattern, WSE 2.0, ASP.NET 2, SQL Server 2005

Architecture

Principles BELL CANADA Team Lead and Architect Jan 2004 -

Reference Mar 2005

Architecture

Target State Defined and architected a large EDW (Enterprise Data

Governance Warehouse) Call Centre Reporting and Analytics application

Best Practices

Data mining different call centre switches, call

. . . . . . . . . . distributors (ACDs), IVRs, Workforce Management Systems and

. . . . . . . . . . ERP deployed at BELL through an ETL process into a central

. . data warehouse, this application presented customizable,

drill-down contact centre reports

Education

A heavy-duty Business Intelligence application, it

1. The Institute centralizes and consolidates much of BELL's call centre

of Computer Studies reporting from a slow, manual process into an automated,

one-point dashboard for decision support

Mississauga, ON,

Canada I was involved in conceptualizing, architecting and

1100-hours, 1998 managing a team of 7 resources to develop this reporting

application in .NET and Teradata (a data warehousing DB). I

Internet set the benchmarks for development and quality control,

Applications interfaced with business and oversaw deployment.

Program

Technologies: Teradata, Business Intelligence/Data

Warehousing, ETL, NET

2. National

Institute of Design

Older Experience (1996-2003)

Ahmedabad, GU,

INDIA

5 years Post Centre for Advanced Visualization Architect

Graduate Program / Developer

Niagara Technical College, Niagara Aug- Nov 2003

1986-1992 Technologies: ASP.NET, VB.NET, C#, Visual Studio.NET,

ADO.NET, SQL Server 2000; GIS, Object Oriented Development

Percepsys Inc Technical Architect /

. . . . . . . . . . Developer

. . . . . . . . . . E-Learning Content Management System, Mississauga Jan 03 -

. . Jul 2003

Technologies: ASP.NET, VB.NET, C#, XML, XSD, Visual

References Studio.NET, SCORM, AICC

Available upon Economical Insurance Technical Architect

request: Waterloo May 2002 - Nov 2002

1. David Smart Technologies: JavaScript/DHTML; XSLT; Visual Modeling

(Manulife) tools, DreamWeaver MX

2. Mohsin Khalil TIP Interactive Technical Architect

(FCT) Detroit-Toronto Mar 01 - Apr 2002

3. Kelly Heard Technologies: ASP 3; Oracle 8i; PL-SQL; JavaScript/DHTML;

(Cactus) Visual Studio 6; CSS

4. Others Federated Insurance Team Lead

Winnipeg Jan 01 - Mar 01

Technologies: Corechange; COM+; ASP 3; JavaScript/DHTML;

Visual Studio 6; CSS

Rogers AT&T Technical Team Lead

Toronto Jul 2000 - Dec 2000

Technologies: MS Commerce Server 3; Site Server 3;

COM-DCOM; ASP; Visual Studio 6

Navantis Web Applications Developer

Toronto Mar 2000 - Jul 2000

Technologies: MS Site Server 3; ASP 2; SQL Server 7;

JavaScript/DHTML; Visual Studio 6

NexInnovations Web Applications Developer

Toronto Aug 1999 - Feb 2000

Technologies: ASP 2; Remote scripting; Visual Basic 6;

SQL Server 7; COM; JavaScript/DHTML

DSPA Software Web Applications Developer

Toronto Feb 1999 - Jul 1999

Technologies: ASP 2; Visual Basic 6; SQL Server 7; COM;

JavaScript/DHTML, CSS

GMASCO Web Content Developer

Dubai, UAE Jan 1996 - Mar 1998

Technologies: Freehand 5; PageMaker 5; HTML, Home Site,

Macintosh, Illustrator 6, etc.



Contact this candidate