Sql Server Project

P J - CSM

AUL ANDRON

** * * * * S T N U T S T R E E T, F O X B O R O, M A S S A C H U S E T T S 0 2 0 3 5

( 6 1 7 ) 8 9 9 - 6 11 3 p a u l j a n d r o n @ h o t m a i l . c o m

SUMMARY

Innovative Information Technology Leader with more than 20 years of experience designing, developing, and

implementing IT methodologies and applications to build strong enterprise architecture and drive effective business

IT strategies that deliver business growth, improved efficiency, and increased profitability. Adept at partnering

with business leaders and using critical analysis to identify business needs and gaps, recommending or developing

appropriate technology solutions and integrating seamless technology solutions. Demonstrated ability to manage

complex projects, organize functional and cross-functional IT and business teams, and deliver multi-stage

development projects on time and within budget.

KEY CAPABILITIES

IT Project Lifecycle: Value-Added Leadership:

Project Management:

Requirements Analysis Cross-Functional Supervision

Custom Software Development

ROI Analysis Team Building & Mentoring

Database Design (RDBMS)

Costing & Budgeting Client Relations & Presentations

Systems Engineering

Project Scheduling Business & IT Planning

System Migrations/Integrations

Testing/QA/Rollout/Support Vendor Management

Enterprise wide Implementations

Process Improvements IT Governance

EXPERIENCE

Claris Vision, Dartmouth, MA June 2013-June 2014

Leader in Cataract, Lasik and Glaucoma Surgery in Southeast Mass and Rhode Island

Director of IT

Directed Information Technology operations within a $47 million eye company providing leadership and vision for

the IT department including strategic planning of information systems.

• Project-managed software initiatives involving the transition of programs to new platforms and the merger

of disparate systems from acquired client companies; Koch Eyes of Warwick RI, Seacoast Eye Associates of

Wakefield RI, South Coast Eye Care of Dartmouth MA and Eye Health Vision Centers of Dartmouth.

• Direct all information technology and network system deployment and maintenance including all IT

infrastructure, wireless communications, PC systems, local networks at 13 practice locations throughout MA &

RI consisting of 45 Ophthalmologists, Optometrists and Opticians servicing over 150,000 patients annually.

• Provided SaaS support for over 350 users using Allscripts Healthcare Solutions, Medflow EHR Eye Care

solutions hosted at EarthLink communications facilities.

• Managed internal resources and external vendors to implement VMware Horizon View™ desktop services

to deliver high-performance Windows 7 virtual desktops to remote medical offices.

• Upgraded Active Directory 2003 to Active Directory (AD DS) in Windows Server 2012 to manage a single

identity for each user, across both on-premises and cloud-based (SaaS) applications.

• Initiated and led project to convert over 350 users from Microsoft Exchange to Google Apps and Gmail.

• Security/Privacy Officer in charge of all Policies to allow company to qualify for meaningful use

CMS/EHR Incentive Program.

• Implemented SysAid an IT service management and help desk software package that integrates all the

essential IT tools into one Service Desk reducing the IT response time by 40%.

LoJack, Canton, MA February 2012-June 2013

Premier worldwide provider of tracking and recovery system.

IT Application Development Manager

Managed a team of 7 direct reports supporting the ongoing development and strategic planning process (SDLC) for

all application systems including ERP, CRM, Web and Mobile devices using SharePoint, BizTalk, Sql Server, .Net,

JavaScript, Appcelerator Titanium and ActionScript.

PAUL JANDRON Page 2

.

• Led project to migrate website from SharePoint 2007 to Kentico 6.0 CMS. Current website is written in

.Net with Sql Server 2008 R2 for the back-end.

• Partnered with company Getfused to develop and lead a team of developers (QA, UI/UX, DBA and

Programmers) to design a Consumer App for all mobile devices using Adobe Air with ActionScript for use in

the United States and Canada. http://mobileapp.lojack.com/.

• Partnered with company DiaSpark to develop a Dealer IPad application and a mobile device Technician

Installation application. Products are developed in Titanium using JavaScript, SQLite, SQL Server 2008 R2.

• Managed Crystal Reports conversion of reports to Sql Server SSRS.

• Worked with Marketing in designing Sql 2012 BI database with Pragmatic Works helping to create a robust

and auditing framework along with executive dashboards for sales reporting.

INVACARE, Milford, MA 2004-September 2011

Global leader in the manufacture and distribution of innovative home and long-term care medical products.

Director of IT (2006-2011)

Promoted to this IT leadership role, managing a team of 21 direct and indirect reports responsible for hardware and

systems support, internal systems programming, and internet and mobile technologies. Implemented ITIL best

practices to improve service which provided the cost benefits from improved productivity as a result of

streamlining work processes. Interacted with clients and C-Level personnel, managing B2C and B2B websites

during all phases of SDLC.

Architecture:

• Project leader for the infrastructure planning, designing, scheduling, and cost estimating in the relocation of

six distribution centers in Massachusetts, Florida, Texas, California, New Jersey, and Indiana.

• Collaborated with business units to implement improvements to distribution centers operations, utilizing

Citrix Desktop and Avaya Phone services, adding significant savings per year in phone and desktop support.

• Ensured availability of systems to ship between 8,000 and 14,000 orders per day using VMware Servers

and HP Eva San for redundancy and failover.

• Created the EDI architecture and directed the implementation of EDI for multiple applications utilizing

middleware such as Microsoft BizTalk and SQL Server allowing the automation of orders to grow from 35% to

65% per year. (EDI sets used: 810,820, 824,832,850,852,856,864 to and from vendors).

• Managed and provided leadership to the systems admin group for the maintenance of 1 UNIX (HPux)

server, 6 Linux (Redhat variants), and 60 windows 2003/Windows 2008 servers.

• Led the enterprise team on the design and development of highly complex, large-scale internet and backend

applications on Unix/Linux/Windows platforms, crossing multiple business lines allowing the flexibility of

integrating existing software with newer technologies.

• Designed Data Warehouse to integrate and centralize data from ERP, Sage CRM and Commerce Server

Web systems using SQL Server 2005 and BizTalk for reporting and data analysis of customer and vendor

buying trends.

IT Governance:

• Legal Compliance – Governance / Risk / Compliance (GRC): Maintained policies and procedures for PCI,

MA 201 CRM 17, Sarbanes Oxley, HIPAA.

• Partnered with Cap Gemini to host an independently audited SAS70 Type II Datacenter for B2B and B2C

websites, reducing the cost of IT operations by up to 20%.

• Developed a comprehensive IT Disaster Recovery plan utilizing SunGard and Cap Gemini services.

• Participated in annual PwC and E&Y audits for Sarbanes Oxley Compliance, consistently receiving audit results

with no deficiencies.

Web Development:

• Managed global B2B (Microsoft Commerce Server) and B2C (Magento) websites, utilizing offshore (Cofa

Media) and onshore team of engineers, QAs and UX designers to develop features and functionality for

websites, across the United States, Australia, Canada, Europe, New Zealand, and Asia.

PAUL JANDRON Page 3

• Utilized Agile project management methods for site enhancement, maintenance, content, and design

changes offering cross-platform interoperability, ensuring Web Development teams were fully trained.

• Led design and project management for a $20M per year website for the Australian VA to order their

medical devices via a B2B web portal along with adding more service offerings for the VA vendors.

• Website technologies used included Microsoft Commerce Server, C#, ASP.Net, BizTalk, Sql Server,

SharePoint, for B2B websites and PHP, MySql, and Java for B2C websites.

• Collaborated with vendors and programmers using Jira and activeCollab for Project Management tools.

IT Leadership:

Senior Programmer Analyst / Project Leader (2004-2006)

Initially recruited to oversee, develop, and coach a team of programmers responsible for applications development.

Established technical specifications and prioritized functions, tasks, and projects. Defined requirements for

applications development, implementation, and support. Introduced new initiatives and sold senior management on

the integration of streamlined technology and business processes.

• Led a major technology initiative, BizTalk / EDI project that enabled the company to ship directly to

retailers. Project contributed to incremental sales of $5M in year one and opened up a new distribution

channel.

SQUID TECHNOLOGIES, Foxboro, MA 1995-2004

Privately held Information Technology consulting firm with expertise in designing Vendor Managed Inventory

(VMI), VICS Bill of Lading, and EDI Integration software using Visual Basic (VB), Access, and SQL Server for

Discreet Manufacturers and Distribution companies. Sold firm in 2004.

President/CTO/Owner

Founded and developed this IT consulting firm providing a wide range of services, including business systems

planning, organization development, technology blueprints, system audits, staff recruitment, and projects to

integrate acquired business into client’s infrastructure and business operations.

• Managed client acquisition and new business development, established business processes, developed

operating procedures, and managed all business, operational, and financial planning.

• Recruited, trained, led, and mentored teams of highly skilled staff and contractors, including defining

contract requirements for software support, purchasing, licensing, and contractor employment.

• Consulted with clients on mergers and acquisitions impact, assessed hardware and software resources, and

developed consolidation plans to unite disparate processes behind a single client company standard.

• Negotiated and fulfilled contracts for major client projects, including the development and implementation

of ERP applications for QAD, JD Edwards and Oracle. Successfully sold the company in 2004.

• Secured major contracts to manage EDI services / divisions for leading enterprise technology and Services

Company, along with supporting EDI & Bar-coding for many manufacturing and distribution companies.

• Drove the high-quality completion of systems engineering, software/database development and enterprise

wide implementation projects for clients including:

Mayer Electric

Alltel Town and Country Linen

Celestial Seasonings

Xerox PFI Pharmaceuticals

Rio Products ON Semiconductor

Additional roles include Senior Programmer Analyst for ROMAN RESEARCH, CROSS COUNTRY GROUP,

SEXTANT and Senior Programmer for MULTI TASKING. Further early career details are available on request.

EDUCATION TRAINING COURSES

AND

Bachelor of Science, Information Technology, COLORADO STATE UNIVERSITY GLOBAL CAMPUS (Expected 2016)

Associate of Science, Information Technology and Computer Programming, NEW ENGLAND INSTITUTE OF TECHNOLOGY,

Warwick, RI

Progress Database Administration, Progress Programming I and II UNIX Administration I and II

CSM – Certified Scrum Master

PAUL JANDRON Page 4

PMP Bootcamp from PMTI

ITIL Foundation Certificate - IT Training Zone Limited (Expected July 2014)

Medsafe Certificate: Corporate Compliance, MA/Part D, Fraud Waste and Abuse

Medsafe Certificate: HIPAA Privacy & Security Including Omnibus Rule

Veteran, UNITED STATES NAVY

Contact this candidate