Pat Ellison

Document Sample
Pat Ellison Powered By Docstoc
					                                           Pat Ellison
Summary
Over 20 years experience of programming and providing full life cycle solutions as a lead in designing
and developing architectures for complex systems with Microsoft technologies.

          Developed solutions with .NET since the release of the Beta 2 version (and current) –
           extensive experience with Visual Studio.Net, ASP.NET, VB.NET, and C# with SQL Server or
           Oracle as the database.
          Architected, Designed, and Developed efficient, reliable, and reusable software modules by
           separating different Application tiers. Excellent knowledge of Object Oriented concepts and
           Enterprise Patterns and experience working with all steps of SDLC (Software Development
           Life Cycle).
          Expert in DHTML and client-side browser scripting using JavaScript, JScript & VBScript.
           Expert in XML, XSLT and Microsoft XML Document component.
          Designed and prototyped user interfaces using HTML, DHTML, Corel Draw/Paint.
           Experience working on UI design with JavaScript, AJAX and Server Controls.
          13 years of experience with SQL Server 6.5-2008.
          SQL DBA Over 7 years with MS Access. Expert in developing large scale, fully normalized,
           and highly complex relational databases for a variety of business domains.
          Converted to SQL Server databases versions 6.5/7/2k/05/08 from other versions and alien
           formats.
          Constructed and managed many data warehouses.
          Familiar with Oracle, SQL Server, Informix, Access, DB2, Alpha server, ODBC, MySQL,
           Postgre SQL, dBase, Paradox, FoxPro.
          Implemented and deployed development, staging, and production systems for a number
           of clients and instructed clients on the best practices for maintaining and upgrading these
           systems.
          A proven record of handling and managing multiple projects of different nature
           simultaneously in conflicting demands and priorities effectively under time constraints.
          Strong understanding of the dynamics of working with a large team of developers.
          Managed teams of up to 14 developers and outside consultants.
          Experienced in project management and business analysis with the ability to lead a project
           through full SDLC requirements.

Computer Skills
Programming Languages: .Net 2002, 2003, 2005, 2008, .Net User-drawn Controls, .Net Compact
Framework, Pocket PC, Web Services, WCF, WinCE, Visual Basic Enterprise 3.x/4.x,5.x/6.x Enterprise,
SQL 6.5/7/2000/2005, Stored Procedures, User Defined Functions, some Oracle, UART Programming,
QuickBasic 4.5, much x86 Assembly Language, DOS/WIN32 APIs, Rumba, XML, HTML, Heavy ActiveX,
Classes, custom OCX's, custom DLL's, ASP, C#, VB.Net, ASP.Net, ADO, ADO.Net, OLEDB, RDO,
Winsock, InterDev 1/6, COM+, some JavaScript, much more.
Operating Systems: Novell NetWare 2.x/3.x/4.x, Windows 3.x/95/98/NT4/2k/2k Adv, 2003, some
UNIX, Linux, Informix, DB2.
Protocols and Software: Internet Information server 2/3/4/5/6/7, Heavy NT Enterprising, Proxy
Severs, WWW, FTP, NNTP, POP3, SMTP, TCP/IP, WinSock, IPX/SPX, HTML, Netscape, IE3/4/5/6/7/8,
Corel 1-11, exposure to Citrix, avid user of MS Terminal Server RDP, so much more.

Compliancy Standards: HIPAA, NIST (National Institute Standards & Technology), FISMA (Federal
Information Security Management Act), and SOX (Sarbanes Oxley)

Security
Have held Top Secret security clearances and higher.

Professional Experience

UMComm.org Feb 09 – Present (90% telecommute)
Contract: Nashville, TN
Project Manager/Sr Developer/Architect/DBA
United Methodist Communications: In short they are the Electronic side of the United Methodist
Church. Tasked to create multi-staged Web apps/ console applications to support all behind the scenes
“moderation”, translations, processing, reporting, support etc.

          Responsible for collecting project requirements, architecting a viable solution, presenting
           and working out issues found during presentation and creation of use cases, Coding, unit
           testing, integrating into current build for full SDLC.
          SQL Server management, database layout, implementation, programming, performance
           tuning, documentation etc.
          C#, ASP.Net, SQL Stored Procedures, Source Control admin
          End user Training
          Technical Documentation


Hirebridge Jan 07 – Nov 08
Perm: Coral Springs, Florida (100% telecommute from Knoxville,TN)
Sr Developer/Architect/DBA
Write and maintain a 5-tier C# written Human Resources web-based resume system. Senior level
developer was given control and design responsibility for all imple mentations of new modules and
retrofits for this very large system. By placing a small HTML piece into a company’s web site they
could add job posting, candidate collection, and a full human resources package for complete auto
qualification, rejection, tracking, and history. Many B2B modules. Well over 400+ well known
companies.

          Responsible for collecting project requirements, architecting a viable solution, presenting
           and working out issues found during presentation and creation of use cases, Coding, unit
           testing, integrating into current build for full SDLC.
          Creation of user GUI
          Design of Security manager and implementation.
          Install and manage corporate email servers.
          Resume Parsing and workflow of issues.
          Building fully optimized SQL statements, stored procedures and User defined functions as
           project’s chief concern was minimizing then load on SQL server.
          B2B using XML and HRXML objects with Careerbuilder, Choice Point, Equest, Monster.
          Build Manager, Created batch push able environments which directly pulled source and
           compiled from source control. Dev-> Stage (regression testing)-> Prod.
          Creation of VMware servers for support of many systems required using min of hardware.
          Web Services
          Indexing of job seeking candidates in data warehouse
          Scoring sub system matching job seeking candidates to respective jobs.
          Batch processing of many sorts, Resumes uploaded to FTP site, Emails received, etc.
          Centralized Error collection, if web users ever see an error, it’s reported back to us via
           email.
          Data Warehousing, lowers overhead of aggregate reporting.
          CSV creation and consuming.
          Excel Exportation, Reporting was exportable to Excel
          Custom State management
          Custom template sub system, Each company could see the system as they desired
          Multi-Threaded operation for items which took mins to complete. User could submit job
           and go on and would be notified when task is completed in header of web site.
          Custom reporting, company can customize their reports.
          Logging and Sarbanes Oxley compliancy.
          Image processing
          PDF creation Processing

Tools: C#, VB.Net, ASP.Net, SQL Server, Data warehousing, SQL Replication, XML, B2B, MS
Application Blocks, CVS, CSV, Sarbanes Oxley


Nationwide Labs Sep 06 – Jan 07
Contract: Ft Lauderdale, Florida
Sr Developer/Architect
Repair and maintain a large scale medical diagnostic lab LIS system. Due to the diverse nature of their
business, and equipment on the lab floor, almost every old and new technology ever seen was located
somewhere in their systems. This was quite a way to keep all your skills sharp. This lab was unique is
that it specialized in ESRD (End Stage Renal Disease).
          Responsible for collecting project requirements, architecting a viable solution, presenting
           and working out issues found during presentation and creation of use cases, Coding, unit
           testing, integrating into current build for full SDLC.
          Creation of user GUI
          Design of Security manager and implementation.
          Insuring HIPAA compliancy and security.
          Building fully optimized SQL statements for Oracle data access in application
          B2B with web services and XML for larger clients.
          Build Manager, Created batch push able environments which directly pulled source and
           compiled from source control. Dev-> Stage (regression testing)-> Prod.
          Creation of VMware servers for support of many systems required using min of hardware.
          Web Services
          Interfacing with Many forms of Medical equipments.
          Batch processing of many sorts, Nightly updates, report compiling, update to Data
           Warehouse.
          Data Warehousing, lowers overhead of aggregate reporting.
          CSV creation and consuming.
          Logging and Sarbanes Oxley compliancy.
          Medical Image processing
          PDF creation Processing
          Evaluation of existing LIS (lab software) systems.

   C#, VB.Net, ASP.Net, ASM, Oracle Server, Data warehousing, XML, B2B, MS Application Blocks,
   SourceSafe, HIPAA


Tech Search America Jan 05 - Sep 06
Perm: West Palm Beach, Florida
Sr Developer/Architect/DBA
GlobalPex.Com. DBA, Architected, designed, wrote and maintained a state of the art one of a kind
patented document storage, certification, bar coding and retrieval system. This system supported
emails and physical paper documents. System was written using VB.Net, ASP.Net, SQL server
functions and stored procedures. Additionally portions of code were certified by FedEx, DHL, UPS.

          Responsible for collecting project requirements, architecting a viable solution, presenting
           and working out issues found during presentation and creation of use cases, Coding, unit
           testing, integrating into current build for full SDLC.
          Creation of user GUI
          Design of Security manager and implementation for HIPAA and Sarbanes Oxley.
          Install and manage corporate email servers.
          Electronic collection, bar-coding, and storage of user supplied documents.
          Management of balance on account.
          Credit Card processing
          Shopping cart style order processing.
          Manage selections of paper-stocks for exact calculation of size and weight and size for
           shippers.
          Building fully optimized SQL statements, stored procedures and User defined functions as
           project’s chief concern was minimizing then load on SQL server.
          B2B using XML objects with Fedex, DHL, UPS, and USPS, Verisign, First Data Merchants
           FDMS, and paper vendors.
          Build Manager, Created batch push able environments which directly pulled source and
           compiled from source control. Dev-> Stage (regression testing)-> Prod.
          Creation of VMware servers for support of many systems required using min of hardware.
          Server installs using EMC SAN hardware.
          Web Services
          Indexing of documents in data warehouse
          Batch processing of many sorts, Documents uploaded, Batch Emails, etc.
          Centralized Error collection, if web users ever see an error, it’s reported back to us via
           email.
          Data Warehousing, lowers overhead of aggregate reporting.
          CSV creation and consuming.
          Excel Exportation, Reporting was exportable to Excel
          Multi-Threaded operation for items like shippers estimates, weight estimates, many
           others.
          Reporting, and account management.
          Logging and Sarbanes Oxley compliancy.
          Image processing
           PDF creation, and manipulations, and Processing.

    VB.Net, ASP.Net, SQL server, Reporting, Data warehousing, B2B, SourceSafe, FedEx-DHL-UPS,
    Credit card processing, + more APIs, SANS Server, Sarbanes Oxley, NIST


Clinical Concepts Dec 2003 - Jan 05
Perm: Wellington, Florida (100% telecommute)
Sr Developer/Architect/DBA
Part of incredible Medical software team that is taking Lab Services to a new level for both doctors and
patients. Architect, and develop an Enterprise wide ASP.Net application.

           Responsible for collecting project requirements, architecting a viable solution, presenting
            and working out issues found during presentation and creation of use cases, Coding, unit
            testing, integrating into current build for full SDLC.
           Creation of user GUI
           Design of Security manager and implementation.
           Insuring HIPAA compliancy and security.
           Building fully optimized SQL statements for SQL Server data access in application
           Build Manager, Created batch push able environments which directly pulled source and
            compiled from source control. Dev-> Stage (regression testing)-> Prod.
           Creation of VMware servers for support of many systems required using min of hardware.
           Web Services
           Interfacing with Many forms of Medical equipments.
           Batch processing of many sorts, Nightly updates, report compiling, update to Data
            Warehouse.
           Data Warehousing, lowers overhead of aggregate reporting.
           CSV creation and consuming.
           Logging.
           PDF creation Processing
           HL7 processing


VB.Net, ASP.Net, SQL server, Reporting, B2B, SourceSafe, HIPAA


DataMed/DrNotes
May 2003 - Dec 2003
Perm: Boca Raton, Florida
Sr Developer/Architect/DBA
Lead, Architect, and Develop a Compact Framework .NET 2003 application to provide satellite
operations for a large medical host program. Provided HIPAA and HL7 Compliancy in a legally
changing Medical world. Designed and implemented custom user drawn controls, Bi-directional SQL
Server Replication, look and feel mimicking of the larger desktop application, and shared crypto base
for secure data transfer. Wrote the "Who's Who" ASP system that allowed employees to see
information and a picture of the others and doubled as the Human Resource's termination database.
Wrote a ASP.Net MIS Ticket request system in off time to assist the department I was connected to.
Also wrote a Real time Call Detail logging system to capture and report calls made on the Nortel
switch phone system. ASP.Net, VB.Net, SQL server DBA..etc

VB.Net, ASP.Net, SQL server, Reporting, Data warehousing, B2B, SourceSafe, HIPAA, HL7, IVR
programming, Call logging, reporting, Tech Training, Nortel Switch.


First Data Inc
Jul 2002 - Apr 2003
Contract: Coral Springs, Florida
Manager, Sr. Programmer, Liaison, for Design of credit card Service Fee processing for acquisition GCS
into the ValueLink Family. About 75% of all Visa/MasterCard/American Express transactions in the
world go through First Data Inc.

SQL server, Data warehousing, Reporting, B2B, Oracle / SQL DTS packages/ Stored procedures.


HIPa (Administrators)
Sep 2001 - Jul 2002
Perm: Hollywood, Florida
Full life cycle project, integrated scanned documents and Rumba connectivity to improve workflow to
Health Insurance Plan (HIP) of Florida's HCFA 1500 Claim processing..

VB.Net, SQL server, Oracle, Reporting, B2B, SourceSafe, HIPAA, HL7, IVR, OCR


Office Depot World Head Quarters
Sept 2000 - Aug 2001
Contract: Delray Beach, Florida
Managed the CTI (Computer-Telephony Integration) Team and Project. This brought efficiency to the
every center around the world by allowing the customer service representatives to answer both
telephone calls and emails as they come in. This allowed Office depot to become one of the first
companies to treat emails with as much importance as a phone call, thereby treating the customer
with the attention they deserve. Customer service representatives were shown client history based on
inbound Caller-ID (ANI) or email routing then this info preloaded our home brewed Millennia System.

Large Project management, Rockwell Inc, Microsoft, Inna-tec.


Praxair Distribution
Aug 1999 - Sep 2000
Contract: Jupiter, Florida
Built grass roots Intranet on a Data warehousing platform. Consulted and implemented SQL 7 to
support data warehouse project. Thereby relieving primary shared Alpha Host server of the burden
users placed on it while reporting with Access, Excel, and other reporting schemes Extensive use of
SQL 7 Stored procedures and ASP to integrate dynamic on-line reporting and analysis, Took Data
Transformation Packages (SQL 7 DTS) to new heights, DCOM Objects, Interdev ActiveX objects.
Secondary mission was to mentor the Director of IS dept to stream line operation plans to allow future
growth for both administration and Infrastructure.

ASP, SQL Server, DCOM Objects, Interdev, ActiveX, Data warehousing


Target Capital Companies
June 1998 - Jul 1999
Perm: Boca Raton, Florida
MIS Manager/Director, MIS Department
Headed, maintained, and managed the resources of the entire IS department for a multi division
holding company. Position was one level under CIO. Primary accomplishments, Designed and headed
Internet/intranet. Many Winsock and internet/intranet custom DLL's and OCX's, ASP driven MIS
Intranet Ticketing system involving email notifications, Standardization of workstations, ISO-reporting,
Data warehousing project. Tasked with complex task of providing mission critical reporting using
Crystal reports from an environment consisting of many unique and different database sources.


BellSouth Mobility
Nov 1996 - June 1998
Perm: Boca Raton, Florida
Senior Programmer/Analyst and Projects Manager, IT Department, Region One Headquarters (Florida).
Visual Basic 3/4/5, ActiveX programming, software integration, technical assistance, and 4th level
support for the Help desk (before requiring vendor intervention). South Florida Database Admin.
Complexity and use of over 50+ NT Servers keep us on the bleeding edge of Microsoft's Beta program.
Designed, Implemented, and documented region wide Intranet, includes active content with both
server and client side programming.

VB 3/4/5, ActiveX, ASP pages, software integration, technical assistance, and 4th level support South
Florida Database Admin


SZL SportSight, Inc.
Jan 1992 - Oct 1996
Perm: West Palm Beach, Florida
Software Manager, Supervised and trained 14 programmers in Visual Basic 3.x/4.x, C, SQL Server,
and Access all under Windows 95. ODBC/SQL, developing custom controls, Sheridan Data Widgets,
Apex True Grid Pro 2.x, Crystal Reports, VSVBX 5.x, and VSView. Managed and planned all software
activities and Network deployments/changes. Helped move this company towards multiple products
that allowed this company to become noticed by big namers such as Silicon Graphics (Partnership),
Teledyne, ESPN, Motorola, The Sunshine Network, and Madison Square Garden Network. Lead team to
developed many 3D real world tracking systems that still are know publicly as "Supervision(tm)", "Golf
PROView(tm)".

Military Service

Military Intelligence, Panama City, Panama Central America
Sep 1989 - Sep 1991
Served as Systems Automation and Network Manager. Special DA assignments in Panama City,
Central America; setup and maintain multi-point computer communications system utilizing my
programming design skills. Connected sites such as Orlando, Florida and Soto Cano Airbase,
Honduras.


Soto Cano Airbase, Honduras Central America
Jul 1989 - Sep 1989
Served in Honduras, Central America providing operation support and maintenance for prototype
programmable electronic warfare equipment in an aviation environment.


White House Communication Agency, Washington D.C.
Jul 1987 - Jul 1989
Hand-picked for assignment to provide support to The President of the United States, his Vice
President and the Secret Service. All communications supported via KU satellite systems and IDNX
smart multiplexers. Active service in research and development for Satellite Transmission Systems
(STS) of Haugpauge, New York.


The Pentagon, Washington D.C.
Aug 1986 - Jul 1987
Shift Supervisor and Maintenance NCO Support of Joint Chiefs of Staff. Maintain all network equipment
and fiber optic links. Due to qualifications served as site programmer.


SatCom Equipment Repair
Active Duty, US Army
Jun 1985 - Sep 1991
Trained and served in Satellite Communication Network Repair, MOS 29Y level II and Computer
Programming.

Education
Delta, University Center, Michigan
Business Management
Western High School
Bay City, Michigan
Bay Arenac Skill Center
Bay City, Michigan
Micro Electronics, Communications and Computers.
US Army, Signal Corp
Ft Gordon, Georgia
Areas of Study
 Digital Electronics and Data Formats
 Digital Communications, Maintenance of Modems and Multiplexers, Networking
 Satellite Communications to support Networking
 USC-49 Satellite Station Theory, Operation, Cabling and Maintenance
 Electronic Jamming Theory and link Integrity Procedures
 JRSC Spread Spectrum AN/GSC-28 Theory, Operation, Programming
 JRSC Spread Spectrum AN/GSC-28 Maintenance and Signal Distribution
 KU Satellite Systems, special use with IDNX Smart Modem
References
Excellent character and technical references available upon request.

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:236
posted:2/26/2010
language:English
pages:6