Doug Stephens Email & Phone Number

• Consultant on coding, database design, backup and recovery, screen flow / design, software testing and application security for financial companies and the technology side of startups in the healthcare sector..
• Contractor with ADP as a systems analyst / programmer from Mar 2009 – Dec 2011ADP is the leading vendor of payroll systems in North AmericaCreated an in-house automated testing procedure using JCL/ COBOL/DB2, for QA/QC.

Toronto, Ontario, Canada

• Hands-on manager. Wrote, debugged, analysed, designed, deployed mainframe code
• Managed the Mutual Funds (MF) statements team (3 team members) & the Global resourcing (GR) technical team onshore and off shore in India (Bangalore & Hyderabad (10 team members)
• Technical consultant to GR onshore / offshore team
• Develop test scenarios for unit tests for GR. Co-ordinate testing between offshore GR and onshore test/QA/QC groups
• Manage incidents, fixes, problems, changes, small and large projects
• Analysis and design of application code for GR

Toronto, Ontario, Canada

• DB2 / IMS database creation, maintenance and optimization – DB2: Query system catalog to determine metadata, administer security, LDS, ER design, Domains, lock granularity, clustering, serialization, deadlocks / lost.

Toronto, Ontario, Canada

• Loyalty One is the leading marketing / Loyalty creation company In North America.
• Started as a programmer and grew to become the manager
• Redesigned and rewrote the main client facing Airmiles monthly statements (JCL/COBOL / DB2/ VSAM). CPU time for the process was reduced from approximately 20 hours to under 1 hour
• Maintenance of the 24*7 AirMiles application written in JCL/COBOL/CICS/DB2
• Wrote numerous dynamic (file /database driven) adhoc programs designed for reuse. Pioneered estimation at AirMiles, using confidence intervals / probabilities for better budgeting / forecasts
• All phases of SDLC including estimation, analysis, design, transforming requirements to code, unit and integration testing, code-walkthrus and deployment

Toronto, Ontario, Canada

• Banking companies: TD and Royal BankProgrammer / analyst &DBA. Application development environment included JCL/CICS / COBOL / DB2 / IMS for mortgages. DB2 DBA work included tuning for locks, indexes, joins, RI.
• Insurance: Keane Consulting for Dominion of Canada General InsuranceSoftware consultant. Highlights - Wrote a customized Y2K solution resulting in extensive structural changes. Wrote a parser in REXX, COBOL, JCL to (a).
• Government: Ministry of community and social services, Analyst / programmer. Integration of Walker financial systems into existing COBOL / JCL/ DB2/ VSAM application

Perth, Western Australia

• As a result of my academic achievements, I was recruited directly from university before the completion of my degree, by BHP; sponsor of the prize that I received.
• Production support, enhancements and new projects SDLC – mining inventory (24*7 application), Accounts payable / receivable – COBOL/IMS(DB) – DL1/VSAM/DB2JCL/CICS/SQL
• Customized proprietary software (CHRIS, Walker) written in COBOL/VSAM/ DB2/ JCL/ CICS/SQL