Jack Staples Email & Phone Number

Calgary, Ab, Ca

Victoria, Canada

• Developed python ETL script to extract data from flat CSV files, load into a SQL Server database, and perform validation and transformation procedures to stage the data for loading to the target system• Created scripts through loading tool to map and insert the data to its expected fields in the target system.• Coordinated with subject matter experts to create data extraction specification for exporting data from legacy database systems to match target database• Worked directly with clients to assist in the correction of data validation errors to correctly match the specification requirements• Lead developer on student portfolio system for the student information system used province wide throughout the British Columbia school system• Conducted interviews to determine the suitability of potential developers for the team, as well as helped with the onboarding of several new team members• Participated in an agile environment as a technical lead for a sprint team, taking part in stand-ups, planning sessions, backlog grooming sessions, reviews, and retrospectives.

Victoria, British Columbia, Canada

• Full-stack (web/business/data tier) legacy application development,debugging and enhancement for school administration, studenttranscript delivery and course management throughout British Colombia• Received commendation due to my success in integrating with theMinistry of Education development team• Created and deployed student grade reporting across multiple platformsused by thousands of students across British Columbia• Created and modified JMeter scripts to perform production scaleperformance testing of specific features in development and testenvironments• Extended Listener pattern implementation on JSF Lifecycle to allow forpage filtering, blocking users from pages they cannot access• Implemented the Rule Design pattern on a large scale for validating userinput and database transfer object fields• Responsible for translation of business requirements into technicalspecifications for several enhancement projects• Followed Test Driven Development using Junit tests to achieve highlevels of code coverage• Worked with and maintained Oracle SQL databases, managing dataacross multiple systems and environmentsTechnologies used: Java, JSF Primefaces / Icefaces / Richfaces, EJB 3.0, JPA /Hibernate, JBOSS 6.2 and 6.4, JMeter, Junit, Jenkins, JSP, Oracle SQLDeveloper, Ant, Maven, Apache Camel, SVN, JIRA

Edmonton, Alberta, Canada

• Performed the migration of non-production reports from a DB2 databaseto an MS SQL database• Worked with Lead BA to located reports which required repointing• Worked with DW/BI Team to identify new folder structures• Repointed ~3500 reports using Metamanager software• Rewrote DB2 queries to SQL• Updated owners about changes• Prepared status reports for PMTechnologies used: IBM Cognos, Metamanager, SQL, SQL Server, DB2, VisualStudio, C#, Excel, Crystal Reports

Edmonton, Alberta, Canada

• Assisted guests at Rogers Place during concerts and sporting events• Promoted safety while enforcing the policies and procedures of RogersPlace• Responded to and dealt with emergency situations