Mandates

TELUS

Applications, Scripts, and Databases — TELUS

December 2006 – September 2007

Functional analysissoftware architecturedevelopmentdefect correction

I built VBScript jobs to automate work in Telnet consoles (Reflection X), then a Java application on the Nortel PSP Guide API: pull switch tables, load them in memory, search from a plan, and produce the requested report. That application cut the monthly NPA-NXX load from one to two weeks down to three to five days.

I also took over support of a departed analyst's C# applications: Access plus ASP.NET to pull data from several websites into a knowledge base for recurring translation work.

Impact

  • Telnet (Reflection X) automation in VBScript
  • Java PSP Guide application: NPA-NXX cut to 3–5 days a month
  • Took over C# / Access / ASP.NET translation tooling

Technologies

C#JavaASP.NETVBScriptXMLOracleAccessUMLNortel DMSReflection XPSP GuideExcel
Download this mandate