Resume

Sign in

Business Technical Analyst

Location:
Toronto, ON, Canada
Salary:
Negotiable
Posted:
February 25, 2016

Contact this candidate

Resume:

PROFILE

Information Technology professional who is passionate in solution architecture and design and solving “difficult problems” with creative and thorough analyzed solutions;

Experience in working in variety of diverse technology platforms, such as Master Data Management, Data warehousing, and Mainframe;

Dedicated and well-organized with rich experience in banking, insurance and telecommunication industries;

Expertise in a variety of programming languages, databases and tools and in managing projects to meet business and technology objectives and timelines;

Excellent analytical and problem solving skills with the ability to resolve difficult situations under challenging conditions;

Strong verbal and written communication skills;

FUNCTIONAL SKILLS

IBM InfoSphere Master Data Management principles and processes including Reference Data Management;

Enterprise Data Integration;

Data Quality;

Enterprise Data Lineage tracing Critical Data Elements;

Data Warehousing;

Solution Architecture;

Detailed Application Design;

Data Architecture/Modelling;

Business Analysis – Specializes in specifying and facilitating client requirements;

Project Management;

TECHNICAL SKILLS

DataStage, Ab Initio, ETI;

Java, XML, C, Visual Basic, Perl, Shell Scripting;

COBOL, Basic;

Unix, Linux, MVS;

DB2, Oracle;

SAS, WebFocus, Focus, Office Tools – Excel, Word, PowerPoint, Viso;

PROFESSIONAL EXPERIENCE

Bank of Montreal 2003 – Present

Business Technical Specialist 2012-Present

Architected and designed Enterprise MDM solutions to on-board customer, and account data through batch and real-time services for a number of source systems in different lines of business (i.e. Personal & Commercial, Capital Markets, Wealth Management, Insurance) in both Canadian and US regulatory compliance projects.

Created functional design specifications, and

Created field-level mappings, and reference code mappings for the Reference Data Management solution.

Analyzed data quality issues, and worked with Data Governance to design efficient solutions to resolve them.

Architected data model changes using best design practices.

Adept in processes in: Data Cleansing, Data Integration and Data Profiling.

Provided Subject Matter Expertise to the business and technology stakeholders that included costing estimates for changes to the analytical and operational MDM applications.

Developed implementation plans with step-by-step instructions including fall-back and communication plans, and worked with project manager to implement those plans.

Managed analytical MDM platform that included leading the development team, managing releases and working with the technology and business stakeholders.

Designed solutions and managed complex and aggressively scheduled projects in terms of the time and budget constraints (i.e. Customer Risk Scoring, Credit Card Conversion)

Adept in working with different groups within the enterprise as well as with vendors to better understand the data in order to create sound technical designs.

Ensured the analytical MDM platform remained AML and CDIC compliant by creating a stable and low-risk environment.

Technical Environment: IBM WebSphere Master Data Management, Linux, AIX, DB2, SQL

Technical Specialist 2007-2012

Managed the Solution Design team of four people for the Sobeys project in the EDW Data Warehouse.

Led the Solution Design team for CI&DS team in Information Management to design efficient solutions.

Identified and resolved a major code bug in a Profitability datamart within one week that included reconciling 50MM in NIR using Ab Initio.

Architected and designed the data acquisition process to provision the data for the Scorecard applications used in forecasting and compensation.

Architected and designed major enhancements to the Air Miles Loyalty application (i.e. Debit, Gold MasterCard Programs). This included acting as the PM on the project.

Technical Environment: EDW Data Warehouse, Ab Initio, AIX, Shell Scripting, DB2, SQL

Senior ETL Developer 2003-2007

Developed and implemented ETL code for major software enhancements and fixes for Profitability, Campaign, and Marketing applications using all the lines of business in the bank.

Developed and designed common utilities and specialized code, in many instances these modules were leveraged by other teams that were used across projects.

Conducted interviews and was responsible for the on-boarding new technical resources.

Identified and resolved on-call support problems on a 24x7 basis.

Technical Environment: Ab Initio, AIX, C, Shell Scripting, DB2, SQL

Rogers AT&T Wireless 1993 – 2003

Senior Programmer/Analyst 2000-2003

Designed, developed, enhanced and supported new and existing processes in the 1.5 terabyte Data Warehouse application to enhance business functionality and to improve system performance.

Designed, and developed an automated application to load Usage data in a Data Warehouse per bill cycle which provisioned data to the Revenue application three days earlier, and published status details.

Managed the redesign of the Price Plan Analytics application that reduced cellular sales churn by 35% and completed this project within the four month required timeline. Prepared the technical requirements and specifications, developed the back-end processes.

Automated a data transmission process in the Data Warehouse application. This automation transferred data on a monthly basis to a third-party service provider that distributed magazines for Rogers Publishing. This resulted in a 50%-time improvement of the distribution of magazines and provided new convergence opportunities to sell magazines to Rogers Wireless customers.

Technical Environment: HP V Class Model V2500, HP 5000, UNIX, Windows NT, C, Shell Scripting, Visual Basic, Perl, WebFocus, Oracle, Sybase, ETI (ETL), PL/SQL

Programmer/Analyst 1993-2000

Developed, enhanced and supported new and existing critical online and batch systems to increase business functionality and improve system performance on the MVS platform

Improved customer satisfaction to a 90% rating with the implementation of the Report of Current Charges System.

Developed the Fraud Provisioning System that resulted in cellular fraud being reduced by 10% per year and in cost savings of $2 million per year.

Managed a team in the successful development and implementation of the system changes to the critical batch systems in the Montreal Area Code Split Project.

Modified and implemented the changes to the Billing, Marketing and Sales systems in the Y2K and the Multi-Level Billing projects without impacting the current daily operations.

Developed the Sales Information System that provided the business with sales activation information on a daily basis to perform their financial reporting.

Technical Environment: IBM RS6000, MVS/ESA, COBOL, JCL, CICS, SAS, FOCUS, DB2, SQL, TSO/ISPF, DB2

EDUCATION

B.A., Math For Commerce, York University

Computer Programming (Co-op Diploma), Humber College



Contact this candidate