Technical/BI Specialist

Veteran IT professional with comprehensive knowledge of the software, relational database management systems, data modeling, data analysis and system development life cycle, from concept and definition to creation, launch and evaluation.

Performed all aspects of software integration, data management, change and release management, quality assurance, incident management, disaster recovery planning, training/mentoring and project leadership.

Adept in forming strong working relationships with managers, teams, clients and vendors, leveraging communication skills and ability to translate complex information into audience-appropriate language.

Skilled in leading teams in performance aligned with business objectives and aggressive schedules.

Well-versed in call center operations, support management and end-user interaction; practiced in discerning user error from system failure, as well as recommending training solutions.

Excel in process improvement, from analyzing workflow to coordinating steps; accomplished in automating manual processes.

Talented in process analysis, with the ability to author business cases, gather requirements, design projects, identify solutions and lead multiple projects simultaneously.

Strong organizational skills with a demonstrated ability to identify and set priorities to meet the strong demands of a dynamic work environment. Proven ability to maintain a sense of humor in a high-stress environment.

TECHNICAL PROFICIENCIES

Languages: VB, C/ C++, SQL, PL/SQL, HTML5, JavaScript, CSS, VBScript, Java, VB.NET, ASP.NET, ASP, XML

Databases: DB2, Oracle, MS Access, Microsoft SQL Server

Tools: Sterling GENTRAN, Microsoft Visual Studio, BTRADE TD Manager, Microsoft Project, Microsoft Office Suite, Rational Clear Case, IIS, Microsoft Visual Source Safe, Rational Visual Test, HP Quick Test, VMWare, Visio, SVN, IBM InfoShpere Information Server, CITRIX, Power Point

Platforms: Windows 2003/2008/2012, AIX, LINEX, UNIX

Networking: VPN, LAN, WAN, IBM WebSphere MQ, Expedite, FTP, SFTP, Telnet, SSL, DNS

PROFESSIONAL EXPERIENCE

CGI, Toronto, ON

LEAD DEVELOPER (contract) 2014-2015

Provided services for the SEDAR/EDI/SEDI application suite for Canadian Securities Administrators.

Provided advice on the operations and functionality of various applications, databases and systems.

Assisted the team in the build of optimal solutions as changes were prioritized.. Hands-on (i.e coding, unit testing) as required.

Contributed to key technology design decisions.

Guided technical teams through the various phases of the software development process and reported progress to management and project stakeholders.

Ensured delivered software programs met the standards for security, correctness, platform readiness and performance.

Provided coordination, oversight and technology leadership to the software development process.

Translated development requirements into technology architecture and infrastructure design specifications.

Championed the software development standards conduct system analyses and guided senior management and project teams during the technology decision-making process.

Explained technical capabilities and features in business terms and provided the management support required to deliver an organization's technology strategy.

Managed production cutover processes, including but not limited to Change Control and Release Management.

Analyzed and resolved complex performance user/system problems and outages.

TMX The Canadian Depository for Securities, Inc., Toronto, ON

Technical specialist II 2001-2014

Promoted to serve as an end-to-end specialist and provided leadership to cross-functional teams, including project management, IT development, help-desk support and web-development teams.

Data Management

Created and maintained maps and programs that extracted data from the SEDAR database and loaded it into GENTRAN software for analysis, validation and translation into EDI standard format.

Developed an automated process to allow SEDAR EDI users to receive weekly and monthly reports via email.

Performed EDI software (GENTRAN client/server and BTRADE TD Manager client/server) upgrades.

Extracted data from the SEDAR database based on business requirements and prepared reports.

Updated SEDAR logical data models.

Oversaw daily payment transactions and operations of SEDAR EDI business. Adjusted the status of incorrect payments in the production Database according to Change Requests.

Participated in Key Manager Changes for trading partners as part of EDI support. Helped develop test scenarios for our trading partners to reflect new changes in the EDI process. Created an EDI support Guide that described the SEDAR EDI process in detail.

Used TD Manager to create security keys for trading partners and EDI payments.

Helped set up an EDI process for CGI during the transition period.

Made changes to the data replication design on SEDAR.COM.

Installed and configured Sterling GENTRAN software.

Familiar with the IBM InfoSphere family of products including Data Stage, Quality Stage, Information Analyzer and Data Governance Catalog.

Served as a subject-matter expert to SEDAR Database Administrators (DBAs) for the modification of existing tables/queries/schemas.

Project Management – Oversaw team deployment, motivation and performance in formal and informal settings.

Spearheaded projects from concept to deployment, coordinating launch plans, meetings with management, team leads, and development teams, to ensure alignment with vision.

Scheduled test environment access and coordinated software testing with test scripts, procedures and bug identification with clients and other departments.

Triaged issues with cross-functional teams to resolve environment issues and scheduled the appropriate maintenance of environments without impacting other environment activities.

Attended change management meetings to ensure smooth releases across platforms and communicated information to relevant stakeholders upon change request approval.

Ensured environments met environment stakeholder requirements, scheduling testing activities using one data set for testing and another data set for production support.

Vital in conducting business-process modeling and re-engineering of a web-based dissemination site displaying public documents in 15-minute intervals instead of a former 24-hour wait period.

Participated in post-mortem meetings at the end of implementations to analyze strengths, weaknesses and improvements for future projects.

Assisted project managers and managers in project planning, providing development and configuration estimates to guide realistic schedules and budgets.

Conducted information-gathering sessions with internal and vendor resources to assess hardware and software requirements.

Development and Collaboration – Partnered with cross-functional teams as a technical advisor.

Maintained best practices in release management, ensuring all releases were in accordance with change management procedures and passed internal and external audits.

Collaborated with IT Security for performance-tuning and server-hardening in adherence to audit and security standards; developed a risk mitigation strategy for code deployment.

Engaged various teams on a software currency project upgrading IBM servers and databases with up-to-date versions of AIX, DB2 and WebSphere.

Served on infrastructure teams to automate deployment procedures, speeding implementation and synchronizing production with the DRP environment, eliminating human error.

Coordinated data refresh of servers after updates to production, ensuring platform alignment.

Worked with system administrators and database administrators to confirm fresh file system and database data and system configuration.

Instrumental in the development of an application facilitating electronic filing of securities as required by the Canadian Securities Administrators.

Designed and implemented a code enhancement enabling clients to access 70,000 previously unreadable documents on a public dissemination website.

Monitored, reviewed and analyzed the effectiveness and efficiency of existing systems, recommending changes, upgrades and alternatives.

Designed and implemented application solutions for Finance and Business departments, as well as for external clients.

Technical Specialist - Blended technical acumen and strong communication skills to provide superior IT, system and hardware support to end-users in a rapid and demanding environment.

Maintenance and support of SEDAR (the System for Electronic Document Analysis and Retrieval), a client server software application designed for the Canadian Securities Administrators ("CSA") to facilitate and enhance the securities filing process in Canada.

Leveraged expertise to quickly resolve escalation issues beyond first-level support.

Diagnosed and resolved production issues, drawing end-users through a chain of inquiry to differentiate user error from system failure.

Provided guidance to SEDAR Help Desk in resolving and troubleshooting production problems and acted as Backup to the Help Desk supervisor, and in that role performed some of her duties (Severity 1 notifications, Severity procedures, and troubleshooting).

Performed SEDAR Code Updates. Prepared all required documentation, ensuring all changes were documented properly. Implemented modifications according to assigned Change Requests, SEDAR Problem Logs and PTRs, including database, server and/or VB changes. Reviewed interfaces and the impact of modifications, prepared test cases and test plans and implemented changes.

Designed, tested and executed programs/scripts to provide different reports based on Business requirements.

Participated in preparation of all required documentation to reflect the process of NRD EFT File Transfer. Participate in testing and implementing changes.

Co-ordinated SEDAR DRP Tests. Tested, and oversaw the general success in the SEDAR functionality, and audited timed progress.

Participated in the development of a new strategy to enhance our disaster recovery procedure. The new strategy enabled SEDAR and SEDAR.com to be restored in 1-2 hours, much improved from the mandated 12 hour window.

Collaborated with end-users at the Ontario Securities Commission to develop a plan to allow end-user documents [XBRL] to work with their existing application.

Worked as part of a team to improve our internal controls to make our systems compliant with external audit from KPMG.

Partnered with Technology Services in development of a procedure to deploy and maintain code on DEV/SIT/UAT/PROD and DRP systems.

Analyzed, investigated and resolved issues from SIT/UAT testing.

Trained, supported and provided direction to junior staff.

Used methodology that includes: proper design, proper code commenting, proper coding standards, proper use of version control, proper PTR identification and resolution, proper code and code fix documentation, proper re-design/re-code.

TMX The Canadian Depository for Securities, Inc., Toronto, ON

Internet specialist 1999 - 2001

Provided technical support related to the wide area network and SEDAR.com.

Developed, maintained and supported SEDAR Website.

Performed SEDAR Web Operational Activities as assigned.

Implemented and tested new versions or updates of the SEDAR Web Site.

Manipulated Web data extracts to produce Web Reports Using WEBTRENDS software.

Provided On-Call support, as required.

Analyzed network traffic and monitored solutions for managing bandwidth usage for SCRIBE application.

Trans-World Distributor Inc., Toronto, ON

Database Developer 1995 - 1998

Designed and debugged applications to control project development.

Oversaw the general Database system design.

Provided regular backup of computerized operations.

Created financial and inventory reports.

PROFFESSIONAL DEVELOPMENT

Training:

Developing Java Web Applications: Hands-On

Java and XML Application Development: Hands-On

Developing a Website: Hands-On

MS Project

Visual Basic Programming for .NET: Hands-On

Programming with .NET Introduction: Hands-On

EDUCATION

Oracle Developer, University of Toronto, DEEDS Project, Toronto, Canada

Software Programming Engineer, PrimeTech Institute, Toronto, Canada

Teacher of Mathematics and Computer Science, University of Lvov, Ukraine

Languages: Fluent in English, Ukrainian and Russian.

Contact this candidate