(Cover Letter - MS Word Version / PDF Version)
(Résumé - Condensed Version - MS Word Version /  PDF Version)
(Résumé - Technical Profile Version - MS Word Version /  PDF Version)
(Résumé - Detailed Version - MS Word Version /  PDF Version)



Dean K. Anderson

31 Sunnyvale Court, Lower Sackville, NS B4E 2T2
902-865-4130 (home)902-877-1077(cell)
deananderson@eastlink.cahttp://deansconsulting.ca

 

INFORMATION TECHNOLOGY PROFESSIONAL

Dynamic, creative and results-driven Information Technology Professional successful in design, development and delivery of cost-effective, high-performance technology solutions to meet challenging business demands. Experience in all facets of project lifecycle development - initial feasibility analysis and conceptual design, development, testing, documentation, implementation, user training and enhancement.

QUALIFICATIONS

 Graduated from a recognized university with a Bachelor of Science degree in Mathematics and Computer Science; twenty (20) plus years related experience.

Solid experience working in software development methodologies and exposed to complex projects.   Experience with project management and systems development life cycle methodologies; change management; risk management; system and role-based information access security.

Proven track record gaining in depth knowledge of internal systems, analyzing data, gathering and documenting true business requirements, developing Oracle database solutions, creating and executing test scripts using PL/SQL and/or UNIX scripts, production implementation.

History demonstrating leadership experience, highly developed business analytical skills and abilities with a record of achievement in positions of increasing responsibility.

Broad experience demonstrating strategic and innovative thinking, developing technical solutions to meet business objectives for clients, locally, nationally and internationally.

Experience leading business growth; redesigned a web site for an Ontario client which resulted in the client being rated #1 in their industry; an increase in client profile nationally and internationally; and within the first six months, the client's sales increased from $400 thousand to $2.0 million and by the end of one year increased to $1.0 billion.

Reliable, trustworthy, energetic and driven regardless of obstacles.

EXPERIENCE

 

NOVA SCOTIA DEPARTMENT OF JUSTICE 2011 - PRESENT
Programmer Analyst / Oracle Developer

Recruited to provide professional programming and analytical services to clients of the Department of Justice.
Work with Department of Justice clients; a key member within the Justice Application Support team tasked to identify, develop, implement and maintain information technology systems for the department.
Responsible for the design, development, implementation, and on-going monitoring of multiple web-based Oracle systems - sharing Help Desk duties on a rotational basis with other staff.
Environment: Windows XP Pro, ORACLE, TOAD, SQL, PL/SQL, SQL*Plus, IP, Internet, PFE, Ultra Edit-32, SRTS Ticket System, Justice Enterprise Network System (JEN), Groupwise

KEANE, INC. 2006 - 2011
LARGE US HMO
HEALTH INSURANCE		 2008 - 2011
QA Test Analyst / Oracle Developer

Recruited to accelerate ORACLE development and testing of complex, high profile oracle project initiatives supporting business requirements for a large Health Management Organization ranked #2 among US health plan providers.
Collaborated with the business areas to understand specific needs, finalize project scope, and ensure conformance to quality, development and testing requirements.
Reviewed technical requirements, provided estimates, recommended technical solutions.
Developed integrated test plans, test strategies, test conditions, use cases, and test scripts.
Analyzed existing processes, transactions, and data models to troubleshoot and resolve identified issues.
Established an in-house Oracle education program, and developed testing methodologies offering notable cost-saving results, operational improvements and productivity increases.
Environment: Windows XP Pro, UNIX (HP9000), ORACLE, TOAD, SQL, PL/SQL, SQL*Plus, IP, Internet, Ultra Edit-32, Reflections, Lotus Notes, PuTTY, FTP, WinSCP, KADET Ticket System, TAHPMaster, Document Management System (DMS), Development Issues Management System (DIMS), TIDAL Enterprise Scheduler, JAM (Job Activation Module), PeopleSoft, CISCO VPN, CSV
Special Recognition: Click here to view ...    2010 Keane PIN Award (Performance_Recognition)
Click here to view ...    2008 Certificate of Excellence

 

GLOBAL FINANCIAL SERVICES PROVIDER
AUTOMOTIVE		 2006 - 2008
Oracle Production Support Analyst

Provided client-focused, high quality analysis and support of the client's ORACLE Data Information Warehouse environment supporting business requirements networked among distributed database applications in a multi-country environment between Canada, United States, and India. Activities included performing modifications to resolve unplanned production abends, providing research and analysis for user requests, and implementing functional enhancements to the supported systems.
Primary contact for System Change Requests and resolution of issues.
Identified, documented, and reviewed requirements, estimated effort and recommended technical solutions.
Designed, developed, and tested PL/SQL code to resolve reported data issues and to provide data warehousing solutions.
Mentored and provided training to team resources.
Monitored Batch Cycle runs to ensure Information Warehouse data maintained high availability and accuracy for all users worldwide (some applications have 24x7 support needs).
Environment: Windows XP Pro, UNIX (HP), Oracle, ODBC, Toad, SQL, PL/SQL, SQL*Plus, Visio, IP, Internet, Ulra Edit-32, Putty, SFTP, WinSCP, CiscoVPN, GMACFS Secure Access SSL VPN, Jabber, MS Communicator, Kadet Ticket System, EDS Service Center Ticket System

 

CAPITAL DISTRICT HEALTH AUTHORITY 1998 - 2006
INFORMATION TECHNOLOGY SERVICES
ONCOLOGY SOFTWARE DEVELOPMENT		  
Senior Systems Analyst, Team Lead

Recruited to provide technical leadership and assistance in reengineering a complex, mission-critical health care software system (Oncology Patient Information System - OPIS) within the largest integrated academic health district in Atlantic Canada. Outcome enabled less cost, more efficient application maintenance, downsizing of staff, and greater scalability benefits to support direct patient care and disease registry perspectives.
Worked with business clients, external clients and IT to understand specific business needs, gather requirements, design, develop and implement solutions.
Facilitated business requirements-gathering activities with department groups.
Provided client-focused, high quality analysis, bug fixes, data extracts, data imports, application development, testing and implementation of application changes.
Developed, created, executed and coordinated signed off on user acceptance test cases.
Created development, testing, implementation, and user documentation.
Lead design, development, testing and implementation of the International Classification of Diseases, 9th and 10th Revision (ICD-9-CM and ICD-10-CM ) within OPIS.
Environment: Windows 98, Windows XP Pro, Oracle Developer 2000 Motif, AIX Unix, Exceed, FTP, PuTTY, TOAD, SQL, SQL*Plus, Novell, TinyTerm, GroupWise, HTML, Source Code Control Systems, MAGIC Self Service Help Desk

 

IT Consultant, Dean's Consulting Services 2004-PRESENT
Lower Sackville, Nova Scotia
Website design, hosting and maintenance for clients locally, nationally, and internationally;
Enabled companies to market products and services, to gain a competitive edge, to increase business profit margins and to acquire new clients;
Provided customized computer based training and mathematics tutoring services on Campus at DAL, NSCC and private sessions; computer repairs and upgrades.
Delivered concept training courses on site at ctc Train Canada to students from provincial and federal government departments:
      Oracle Developer 10g: PL/SQL Functions, Procedures and Packages
      Oracle 10g Fundamentals
      Oracle Developer: Introduction to Oracle Forms 10g
      Introduction to Oracle 9i PL/SQL

 

Oracle Software Specialist 1992-1998
Software Kinetics, Halifax, NS

Proven track record with Oracle development and conversions involving Oracle Forms ranging from version 3.0 to 10g.   Installing/using Oracle Database v7-10g and the Developer Suite 2000/10g. Selected projects:
Oracle Applications Promotion Allocation System (PAS) Human
Resource Information System (HRIS) Time Capture System
Time Sheet Audit Trail System DBA Manager Application
PowerBuilder Applications
Rate Plan Optimizer System Artifacts Conservatory Directory System
Software Application Testing
TuneUP.Com Learn Series of applications, Mentor Networks Inc.

 

Programmer/Analyst 1992
Environment Canada, Canadian Parks Service, Halifax, NS

 

EDUCATION

Leadership Development Certification 2003
Business Communications Certification 2000
Executive & Professional Development, Saint Mary's University, Halifax, Nova Scotia
Courses completed:
     Managing Workplace Conflict - November 2003
     Leadership Development Workshop - October 2003
     Interpersonal Communication Skills - November 2002
     Business Writing Skills - October 2002
     Writing and Editing Professional Materials - October 2002

B.Ed., Mathematics (Teacher Certificate Level 5 Certified), Dalhousie University
1992
B.Sc., Mathematics & Computer Science, Saint Mary's University 1986

 

PROFESSIONAL DEVELOPMENT

Project Management Essential Tools & Techniques Workshop, Unisys Canada Inc., 2005
Introduction to Oracle: SQL and PL/SQL, Prometric Certification Services 2001
Coaching Workshop: Bringing Out the Best in Others, Bayer Institute 2000
Clinician-Patient Communication Workshop, Bayer Institute 2000
Oracle8 Database Administration, General Physics Canada Ltd 2000
Fast Track to PowerBuilder, PowerSoft Education Services 1996
Introduction to Oracle SQL, SQL*Plus and PL/SQL, Software Kinetics Ltd 1996

 

References Available - Upon Request