Post Job Free

Resume

Sign in

Sql Server Developer

Location:
San Francisco, CA
Posted:
January 26, 2015

Contact this candidate

Resume:

Norman Cano

* * * * *

Profile

Individual Summary Over fifteen years of experience designing and implementing multi-tier applications and

system integration solutions as application architect, system integrator, technical lead

and business manager. Excellent application analysis and design concepts. Strong

ability applying optimal design patterns to the system design and employ extreme

programming techniques for robust implementations. Strong management skills in

order to work with multi-cultural, backgrounds and global teams.

Key Skills

.NET Framework ASP.Net, AJAX Windows, Linux C, C++, C#, Java

BizTalk Server 2004-2013 MS-SQL, Sybase, Oracle MS Dynamics XML, XSL, XSLT

TIBCO EMS, BE, BC SharePoint 2003-2013 HL7, IHE, Rosetta Net Exchange

Web Services DTS, VSS, TFS EDI, SWIFT, ISO8583 MSMQ, MQ Series

WSE, SOA, WCF, REST Rational, Clear Quest TCP/IP, EIGRP, X25 MSF, Agile

Education

MSCE – Data Platform Solution Expert (ongoing)

Administering Microsoft SQL Server 2012 Databases

MCSD - Microsoft Certified Solutions Developer

Developing Windows Azure and Web Services

Developing ASP.NET MVC 4 Web Applications

Programming in HTML5 with JavaScript and CSS3

MCSE – Microsoft Certified Solutions Expert

Core Solutions for MS SharePoint Server 2013

Advanced Solutions of Microsoft SharePoint Server 2013

MCSA – Microsoft Certified Solutions Associate

Configured Advanced Windows Server 2012 Services

Installing and Configuring Windows Server 2012

Administering Windows Server 2012

MCITP – Microsoft Certified IT Professional

SharePoint 2010 - Administrator

MCPD – Microsoft Certified Professional Developer

SharePoint Developer 2010

Windows Azure Development

Web Developer 4

MCTS – Microsoft Certified Technology Specialist

SharePoint 2010, Configuration

SharePoint 2010, Application Development

Microsoft BizTalk Server 2010

.NET Framework 4 – Data Access

.NET Framework 4 – Web Applications

2 P a g e

.NET Framework 4 – Service Communication Applications

.NET Framework 4 – Windows Communication Foundation (WCF) Development

SharePoint Services 3.0 – Application Development

SharePoint Services 3.0 – Configuration

BizTalk Server 2009 – Developing Business Processes

BizTalk Server 2009 – Integration Solutions

BizTalk Server 2006 – Custom Applications

BizTalk Server 2006 – Applied Techniques

BizTalk Server 2004 – Designing e-Business Solutions

BizTalk Server 2004 – Developing e-Business Solutions

BizTalk Server 2004 – Deploying and Managing e-Business Solutions

Developing Bus. Process and Integration Solutions using BizTalk® Server 2009

Cisco Routing & Firewall

Advanced Cisco Routing & Firewall Configuration ACRC

Bachelor of Science Degree in Information Systems Engineering

Mariano Gálvez University, Guatemala, Central América

Microsoft Exam Verification Tool:

https://mcp.microsoft.com/Anonymous/Transcript/Validate

Transcript ID: 884609

Verification

Access Code: 00884609

Languages

English (advanced) Spanish (fluent)

3 P a g e

Work Experience

Microchip Technology, Phoenix, AZ Consultant

Integration Architect, Business Analyst, BizTalk Senior Developer, Rosetta Net 2013-2015

(Windows Server 2008, C#, SQL Server 2008, XML, WS-RPC, BizTalk Server 2010,

Rosetta Net Accelerator, ModelN, Axis)

Reviewed customer needs, helped client make technical and strategic

decisions to enhance services and processes

Architected and implemented a solution to Integrate a Rosetta Net Global

Supply-Chain (5C1 Distribute Product List, 5C2 Request Design

Registration and 5C4 Distribute Registration Status) based on BizTalk

Server 2010 and legacy platforms.

Lead and conduct Integration and Development

Developed several pipeline components, orchestrations and helpers

Performed code reviews

Prepared release packages for seamless deployment to production.

Trained and mentored developers

SIT, UAT and BAU Support

Inter-American Development Bank, Washington, DC Consultant

Solution Architect, Business Analyst, BizTalk Senior Developer, Swift 2013-2014

(Windows Server 2012, C#, SQL Server 2012, XML, Swift, Oracle, MQ Series,

BizTalk Server 2013, Swift Accelerator)

Architected and implemented several solutions to integrate MQSeries,

Oracle, Swift Network, Active Directory and SharePoint.

Established development framework by identifying right BizTalk components

to use, project dependency structure for solution, defining the coding

standards, process for build automation.

Lead and conduct Integration and Development

Developed several Swift Maps, WFC Extenders and Pipeline Components

Developed there extensive and high-availability orchestrations

Provide Advanced Development (BizTalk & Swift) Training

Performed code reviews

Prepared release packages for seamless deployment to production.

KapStone Paper, United States Consultant

Solution Architect, BizTalk Senior Developer, Project Manager, EDI (Windows 2013-2015

Server 2008, C#, SQL Server 2008, XML, BizTalk Server 2010, EDI)

Architected and implemented a solution to Integrate an EDI Network

(Trading Partners, Suppliers and Internal Plants) based on BizTalk Server

2010 (EDI 810, 830, 850, 855, 860, 997)

Established development framework by identifying right BizTalk components

to use, project dependency structure for solution, defining the coding

standards, process for build automation.

Provide guidance, standards, roles and responsibilities plans

Lead and conduct development

Managed 2 teams to build new BizTalk EDI Solutions and Deployment

Packages

Performed code reviews

ICLOPS, Chicago, IL Consultant

Solution Architect, BizTalk Senior Developer, HL7, IHE, EDI 837 (Windows 2013

Server 2008, IIS 7, ASP.NET 4.0, C#, SQL Server 2008, XML, WCF, HL7, IHE, EDI,

BizTalk Server 2010)

Architected and developed solution to Integrate Healthcare Enterprise (HL7

& IHE), Healthcare Claims (EDI 837)

Implement Cross-Enterprise Document Sharing (XDS.b)

Lead and conduct development

Prepared release packages for seamless deployment to production

4 P a g e

Vertellus, Indianapolis, IN Consultant

Solution Architect, BizTalk and SharePoint Developer, SAP, MS Dynamics 2012-2013

(Windows Server 2008, SharePoint Server 2007-2010, IIS 7, ASP.NET 3.5, 4.0, C#,

SQL Server 2008, XML, BizTalk Server 2006, SAP, Microsoft Dynamics)

Reviewed existing SharePoint implementation and design.

Reviewed existing BizTalk implementation and design.

Review existing SharePoint 2007 Workflows. Redesigned workflows and

migrate data to SharePoint 2010.

Review existing SAP BizTalk Integration implementation and code.

Redesigned code so that it is reusable, extensible and uncoupled.

Lead and conduct development

Prepared release packages for seamless deployment to production.

HCR ManorCare, Toledo, OH Consultant

Solution Architect, BizTalk Server Developer, Healthcare (Windows Server 2008, 2012-2013

IIS 7, ASP.NET 3.5, 4.0, C#, SQL Server 2008, XML, BizTalk Server 2010, HL7)

Architected and developed solution to integrate HL7 Healthcare Platforms

Lead and conduct development

Performed code reviews

Trained and mentored developers.

Prepared release packages for seamless deployment to production.

Petroleum Geo-Services, Houston, TX Consultant

Integration Architect, BizTalk and SharePoint Developer, PeopleSoft (Windows 2012

Server 2008, SharePoint Server 2010, IIS 7, ASP.NET 3.5, 4.0, C#, SQL Server

2008, XML, BizTalk Server 2010, PeopleSoft)

Architected and developed BizTalk-SharePoint solution to replicate and

integrate PeopleSoft Security to SharePoint 2010, including: Oracle lists,

procedures and security layers design, business and system processes,

SharePoint Layouts, Templates, Libraries, Web Services and PowerShell

scripts, BizTalk processes and monitoring.

Estimated development, test and production times

Lead and conduct development

Performed code reviews

Trained and mentored developers

Prepared release packages for seamless deployment to production.

Practice Velocity, Belvidere, IL Consultant

BizTalk Senior Developer, Healthcare (Windows Server 2008, IIS 7, ASP.NET 3.5, 2012

4.0, C#, SQL Server 2008, XML, BizTalk Server 2010, HL7)

Implemented and developed a solution to integrate HL7 Healthcare

Platforms

Lead and conduct development

Performed code reviews

Trained and mentored developers

Prepared release packages for seamless deployment to production.

MFlex, Irvine, CA Consultant

BizTalk Developer (Windows Server 2008, IIS 7, ASP.NET 3.5, 4.0, C#, SQL 2012

Server 2008, XML, BizTalk Server 2010, Oracle)

Implemented a BizTalk Solution to integrate overseas platforms

Lead and conduct development

Prepared release packages for seamless deployment to production.

Citibank, Latam (Central, South America & Caribbean) Full Time

e-Business Manager / Software Architect 1997 – 2011

5 P a g e

Lead e-business strategy (websites, online banking portals, mobile banking,

etc.) for several countries

Lead e-business teams for six countries

Lead e-channels and integration development teams for three countries

Lead the new online banking redesign and revamp project based on

business strategy using BizTalk 2009 as core engine

Point of contact for Technical and Business relationship management,

(global and local teams)

Barca Solutions, Central America Full Time /

Consultant

Software Integration Architect

2008 – 2010

Lead e-channels development team (portal & online transactions, ATM’s,

Point of Sales, IVR)

Designed, architecture and lead implementation of the online banking

platform.

Front-End: C#, ASP.Net, HTML, JavaScript & XSLT

Back-End: Fincentric’s Ovation Core Banking Systems (3 countries) - C++, Probe

NT, SQL / Macosa’s COBIS Core Banking System (3 countries) - VB.Net, Sybase /

In-House Credit Cards holders Core System (5 countries) - VB.Net, Sybase / In-

House Credit Cards holders Core System (1 country) - RPG, AS400, DB2

/ Fraud & Monitor Solutions – Falcon, Monitor, etc. - Java, C++, Oracle, MS SQL

Middleware: MS BizTalk 2006, IBM WebSphere, TIBCO

Interfaces: XML Web Services, WSE, Store Procedures, MQ Series

Designed, architecture and lead implementation of the ATM’s & POS switch

for six countries in Central America - C++, ISO8583, X25, XML, TCP/IP,

Sockets, etc.

Providing training and mentoring to developers

Designed and lead implementation of the first initiative in order to integrate

the Central American Financial System (most all the banks around central

America) with different platforms (AS400, NT, UNIX) and DBMS (Sybase,

DB2, MS SQL Server).

Integrate a financial network around Central America and Panama to the

SWIFT platform; host the access on a single point.

Development web based CRM solutions

Enterprise technology consulting with 9 banks and financial institutions in

Central America, México & Peru

Technical facilitator between cross-functional group on topics such as

automating build processes, scalability testing, enterprise-wide architecture

and migration to .Net

Parliament Central America (Government), Central America Consultant

SharePoint Architect, Technical Lead (Windows 2003 Server, IIS 6, .NET 2.0, 2008 - 2009

ASP.NET, ADO.NET, C#, Web Services, SQL Server 2005, BizTalk 2006, XML XSL,

Workflows, Solution packager)

Reviewed existing architecture, suggested new topology to improve

performance, reliability, availability and manageability.

Reviewed existing projects, made suggestions to improve code, best

practices and appropriate design patterns.

Documented existing issues and concerns, designed new procedures to

solve existing problems.

Fixed many issues from their environments (SharePoint 2003 and 2007).

Mentored and assisted developers for creating custom workflows, web parts,

solution packages and other.

Deloitte and Touche, Nashville, TN Consultant

SharePoint Architect, Technical Lead (Windows 2003 Server, IIS 6, .NET 2.0, 2007 – 2008

ASP.NET, ADO.NET, C#, Web Services, SQL Server 2005, XML XSL, Workflows,

Solution packager)

6 P a g e

Reviewed existing architecture, suggested new topology to improve

performance, reliability, availability and manageability.

Reviewed existing projects, made suggestions to improve code, best

practices and appropriate design patterns.

Fixed many issues from their environments (SharePoint 2003 and 2007).

Mentored and assisted developers for creating custom workflows, web parts,

solution packages and other.

Consultant

Fers Corp, Bear, DE

Solution Architect, Technical Lead (Windows 2003 Server, IIS 6, Java, MySQL, 2007 – 2008

XML XSL)

Architected, documented and implemented Customer Web Base CRM

Reviewed existing architecture, suggested new topology to improve

performance, reliability, availability and manageability.

Providing training and support to users in CRM solutions

Consultant

Thin-Air, London, UK

Solution Architect, Technical Lead (Linux, Java, PHP, MySQL) 2007 – 2008

Architected, documented and implemented Customer Web Base CRM

Reviewed existing architecture, suggested new topology to improve

performance, reliability, availability and manageability.

Providing training and support to users in CRM solutions

Consultant

Administradora Fondos de Pensiones, Guatemala

Solution Architect, Technical Lead (Windows 2003 Server, IIS 6, .NET 2.0, 2007 – 2009

ASP.NET, ADO.NET, C#, AJAX, Web Services, SQL Server 2005, XML XSL)

Architected, documented and implemented Online Banking System

Reviewed existing architecture, suggested new topology to improve

performance, reliability, availability and manageability

Reviewed existing projects, made suggestions to improve code, best

practices and appropriate design patterns

Fixed many issues from their environments

Mentored and assisted developers in order to implement best practices

Full Time

Grupo Uno Bank, Central América

Solutions Integration Architect (Windows 2003 Server, IIS 6, .NET 2.0, ASP.NET, 1997-2007

ADO.NET, C#, BizTalk 2004, 2006, Web Services, SQL Server 2000, 2005, XML

XSL, SharePoint 2003, 2007, COM+)

Lead a team of ten engineers in the design and development of the financial

e-solutions

Managed several development teams to build appropriate software solutions

to meet specifications.

Designed and lead implementation of a financial integration e-solution. The

BizTalk driven system connects multiple country banks and deliver single

point of administration, data retrieval, notifications and data exchange.

System implemented in C# and Java. The presentation layer is ASP.NET,

JavaScript/XSL. The business layer is abstracted by the secure web service.

Data layer consists of COM+ serviced components. The system integrates

multiple data sources driven by Sybase, SQL Server and DB2.

Designed and developed EDI transaction processing engine using BizTalk

Server and custom C# components

Managed product development for various PROBE projects including

Gateways and Ovation Systems.

Developed Internet gateway (XML, Web Services, NP), SAT gateway

(Guatemala government) for Ovation.

7 P a g e

Programmed numerous libraries for XML, Named Pipes and Web Services.

Directly responsible for analysis, design, development and implement

Electronic Transactions and Internet Projects.

Providing training and support to end users and service personnel in charge

of installation and operations of a large-scale for online-banking.

Mentored developers to build high performance modules for BizTalk.

Part Time

Mariano Gálvez University, Guatemala, CA

Networking & Programming Instructor (TCP/IP, IPX/SPX, X25, EIGRP, Routers, 1999 – 2000

Firewalls, C++, VB.Net, Java.)

Taught Computer and Information Science course to 60 students per semester

Full Time

Seguros Universales, Guatemala, Central América

1994-1999

Technical Lead, Senior Developer (Unix-SCO, Informix, DB2)

Lead a team of four programmers for in-house development solutions

Managed the reengineering and development of a new global solution for

the assurance market (life, health, vehicles, etc.)

Providing training (in-house solution) and technical support to end users

Mentored developers to use best practices with Informix Development

Full time

Abinitio, Guatemala, Central America

Support Specialist (Unix SCO, HP-UX, Windows, MS Office, hardware) 1993 – 1994

Supported customers for technical difficulties

Fixed software and hardware related problems

Unix SCO Installation & Support

Skills

Product Level Activity Experience

ASP 3.0 Expert Currently used Long

ASP.NET Expert Currently used 7 Years

JavaScript/VB Script Expert Currently used Long

HTML, CSS Expert Currently used Long

HTML5, CSS3 Specialist Currently used 1 Year

XML, XSL, XSLT Expert Currently used 6 Years

.Net Framework 1.0, 1.1, 2.0, 3.0, 3.5, 4.0, 4.5 Expert Currently used 6 Years

AJAX Expert Currently used 3 Years

LINQ Expert Currently used 4 Years

Design Patterns Expert Currently used 6 Years

.NET Remoting Expert Currently used 6 Years

WCF, WWF Expert Currently used 4 Years

Enterprise Single Sign-On Expert Currently used 8 Years

Cloud Services

AppFabric Specialist Currently used 2 Years

Windows Azure Specialist Currently used 2 Years

Salesforce.com Specialist Currently used 1 Year

SQL Server 2000, 2005, 2008, 2008 R2, 2012

SQL Server Clustering Expert Currently used 5 Years

Stores Procedures/Views Expert Currently used 10+

SQL Security Expert Currently used 10+

DTS/SSIS Development Expert Currently used 7 Years

OLAP/Analysis Services Expert Currently used 5 Years

Database Design Expert Currently used 10+

Reporting Services Expert Currently used 7 Years

8 P a g e

Oracle Intermediate Currently used 3 Years

MySQL Expert Currently used 7 Years

SQL Server 2000, 2005, 2008, 2008 R2, 2012, 2012 R2

Windows NLB Expert Currently used 8 Years

Windows Clustering Expert Currently used 6 Years

NT Domain/Active Directory/DNS Expert Currently used 10+

Hyper-V Expert Currently used 2 Years

IIS 5, 6, 7, 7.5, 8.0 Expert Currently used 8 Years

BizTalk 2002, 2004, 2006, 2009, 2010, 2013

BizTalk Server Clustering Expert Currently used 8 Years

BizTalk Orchestrations Expert Currently used 10+

Orchestrations Helpers Expert Currently used 8 Years

Custom Pipeline Components Expert Currently used 10+

BizTalk BAM Expert Currently used 6 Years

BizTalk BRE Expert Currently used 8 Years

HL7 for BizTalk Expert Currently used 4 Years

ESB Toolkit Expert Currently used 5 Years

SWIFT Accelerator for BizTalk Expert Currently used 6 Years

HIPAA Accelerator for BizTalk Expert Currently used 4 Years

EDI for BizTalk Expert Currently used 4 Years

RosettaNet Accelerator for BizTalk Expert Currently used 4 Years

LOB Adapter Pack for BizTalk Expert Currently used 4 Years

WCF Adapter Pack for BizTalk Expert Currently used 5 Years

WCF Custom Service Behaviors Expert Currently used 4 Years

SAP Adapter for BizTalk Expert Currently used 4 Years

Oracle Adapter for BizTalk Expert Currently used 4 Years

SharePoint/MOSS 2003, 2007, 2010, 2013

Custom Workflows Expert Currently used 8 Years

Deployment Packages Expert Currently used 8 Years

Event Receivers Expert Currently used 8 Years

Event Handlers Expert Currently used 8 Years

Web Parts Expert Currently used 8 Years

Web Content Management Expert Currently used 5 Years

Setup, Deployment, Configuration and Architecture Expert Currently used 8 Years

Business Connectivity Services (BCS) Expert Currently used 4 Years

Visual Basic Expert Until 2007 7 Years

C# Expert Currently used 10+

VB.NET Expert Until 2008 6 Years

Java Expert Currently used 9 Years

C/C++ Expert Until 2007 10+

Visual Source Safe Expert Currently used 7 Years

Team Foundation Server Expert Currently used 4 Years

Team Foundation Server – Visual Studio Online Expert Currently used 1 Year

Microsoft Project Expert Currently used 8 Years

TIBCO Business Events/Connect, Adapters, Message Service Intermediate Eventually 1 Year

IBM WebSphere Intermediate Currently used 1 Year

Cisco Firewall & Routers Expert Until 2007 7 Years

ISO8583 Expert Until 2006 9 Years

TCP/IP, X25, SPX, EIGRP, Protocols Expert Current Used 9 Years

Clark Connect / Clear OS Intermediate Current Used 2 Years

9 P a g e



Contact this candidate