Mark H. Kayan

3 Tanager Rd ● Attleboro, MA 02703 ● 339-235-0794 ● 508-455-2864

SUMMARY

Over 24 years of experience in working with and leading development teams in programming, design, analysis, requirements building, implementation within corporate systems, specializing system redesign, integration, data analysis. Seeking a challenging position with potential for professional growth.

EXPERIENCE

Medtronic (Formerly Covidien), Mansfield, MA

Principal IT Business Systems Analyst, July 2019 - Present

Senior IT Business Systems Analyst, December 2015 – July 2019

Systems Analyst, May 2007 – December 2015

SKILLS: Team Lead, SDIM, SDLC, Design and Analysis, SQL Server, SSIS, SSRS, Oracle,

Reporting packages, FTP, PGP, SSL

Lead team of 4 contingent developers in the support of over 20 applications, including primary incident support, design, development, full SDLC cycle.

Built solid work relationships with and acted as primary technical contact and SME for applications for multiple business groups
Lead the team in the transition from Windows Server 2003-2008 and Windows Server 2008-2016 transitions, retiring or transitioning over 100 corporate applications and databases.

Lead data analyst / data designer for Federal Sunshine Act HCP project with custom developed application and data flow process
Primary IT support for global Tax and Treasury teams across 3 continents, supporting various platforms, databases, and development technologies
Main support 24/7 for global Treasury team

Worked closely with global Tax and Treasury business groups to build entire department from the ground up. This included implementation of support infrastructure of all tax and treasury systems previously used at Tyco
Implemented and managed transactional and rate files from the banks with delimited text and EDI files
Performed full software development life cycle with Salmon Treasury Management System from initial requirements gathering through system decommissioning, including development and maintenance of all reporting needs
Worked with business teams, both global and local, as well as the vendor to implement Wall Street Systems, a replacement treasury management system for Salmon TMS. Activities include: requirements development, system integration, custom development, integration of online banking systems and files, and integration with JD Edwards E-One
Supervised development contractors to assign tasks, verify scope and requirements, and ensure development and coding standards are maintained

The Allied Group, Cranston, RI

Customer Technology Specialist / Programmer Analyst, 2002 – May 2007

SKILLS: SQL Server 2005 / 2007, Visual Basic 6.0, SQL Server 7.0, Citrix

· Executed full Enterprise Resource Planning project, from initial design to complete implementation, including design and implementation of full suite of internal client/server applications

· Integrated third party shipping, mailing, and warehouse management servers and applications to communicate directly with in-house applications and databases

· Primary developer for all database, reporting, and internal application development and maintenance

· Designed, Developed, and Maintained both general-use and customer-specific applications, including customer data maintenance, customer data importation, internal processing, warehouse and inventory management, reporting, job costing/pricing, invoicing, shipment management

OneBeacon Insurance Group, Foxborough, MA

Programmer Analyst, 2000 – 2002

Primary responsibilities: design, development, and maintenance of client/server front-end insurance underwriting applications, stored procedures, and reports
Technical support for nation-wide marine insurance underwriting company
Maintained communications with both management and end users to ensure applications remained practical and efficient
Designed and implemented conversion from Windows 3.1 / 95 / SQL 6.5 to Windows 2000 / Visual Basic 6.0 / SQL Server 7.0 for client/server and 3-tiered applications

Shared Technologies Cellular, Wethersfield, CT

Programmer Analyst, 1998 – 2000

Designed and developed consolidated front-end reporting module using Visual Basic 6.0
Developed and supported consolidated reporting module back end using MS-SQL 6.5 and Crystal Reports 7.0
Worked with business users to design new reports and support existing reports
Worked with marketing department to maintain corporate web site using Microsoft FrontPage and various graphics utilities

EDUCATION

Westfield State University, Westfield, MA
B.S. in Computer Science, 1994-1998