Vlad Kagramanov

**** ********** ****.

Mississauga, Ontario, L5N 1X6

(416) - 786 - 0743

abqadg@r.postjobfree.com

Objective: Sr. Business Analyst

w 19 years experience in the field of computer systems and applications,

implementation, development and testing

w Business and system analysis/design in web-based and Data Warehouse environments

w Advanced knowledge of Banking, Credit/Market Risk, Basel II&III, Accounting, Insurance, Oracle, SQL, MS Project, MS Office, JAD, SDLC/Agile, IBM

Experience Summary

Designed credit risk reporting solution at BMO. Implemented Credit Adjudication and Credit Risk Management application at TD Bank. Implemented a business solution for back-office application at Yellow Pages. Designed Credit and Marker Risk Data Warehouse for the Federal Finance Department. Designed business solution for Credit Risk & Commercial Lending Data Warehouse at CIBC (Capital Markets - Basel II Project). Designed and implemented ERP Financial application at SunLife Canada. Designed and supported Financial Application at Ontario Provincial Government. Implemented and supported Brokerage application at Fidelity Investments. Implemented Wealth/Credit Risk applications at Citibank Canada.

Business Experience

Bank of Montreal June 2012 to November 2012

Sr. Business Analyst

Basel Credit Risk Management application implementation

Defined reporting requirements with key business stakeholders. Identified additional business and IT contacts required to complete the requirements phase of the project. Facilitated group sessions with business SME(s). Created Business requirements documents. Mapped the requirements to the Data Warehouse and the initial source systems, performed gap analysis,. Maintained the project issue log. Designed the repository to manage new data requirements. Supported business and IT enquires. Acted as liaison across development, QA and business teams. Participated in defining QA project plan, ETL procedures and test cases.

Environment: Credit Risk Management, Accounting, SDLC, SQL, .NET, MS Project, PowerPoint, Visio, MS Office, Access

TD Bank April 2010 to May 2012

Sr. Business Analyst

Credit Adjudication and Credit Risk Management Application implementation

Assisted project manager in defining the project scope. Categorized and prioritized customer requirements. Created and maintained project issue log. Performed feasibility study, presented results to business stakeholders. Created process workflows and Business Requirements document for Data Warehouse and BI reports. Created change requests as needed. Maintained day-to-day relationship with the key project stakeholders. Assigned tasks and provided guidance to team members. Participated in defining UAT project plan, data transformation scenarios and test cases. Assisted technology and business teams during UAT. Analyzed and categorized defects and issues, presented solutions to the working group. Obtained sign-offs from business stakeholder groups. Conducted post implementation review and project closure tasks.

Environment: Credit Risk Management, Accounting, SDLC, HP Quality Center, SQL Server, .NET, MS Project, PowerPoint, Visio, MS Office, Access

Yellow Pages (Trader Corp.) Jan 2008 to March 2010

Sr. Business Analyst

Accounting and Credit Risk Back-Office Application Implementation and Support

Captured and analyzed high-level business requirements. Created AS IS and TO BE process workflows, mappings and documented financial business processes and procedures. Analyzed processes and developed gap analysis document. Formally documented findings and presented proposed solutions to clients. Facilitated group sessions with business to determine requirements. Acted as liaison across development, QA and key business contacts. Designed, evaluated and documented web front-end, reporting and data mapping solutions. Supported application in production environment.

Environment: Win XP, Accounting, Media, RUP, MS Project, MS Office, UML, Visio, Oracle, SQL, PL/SQL

Federal Government – Ministry of Finance Jul 2007 to Dec 2007

Sr. BI Business Analyst

Basel II – Credit & Market Risk Reports and Data Warehouse Application Design

Collected and analyzed business requirements, prepared feasibility study and performed gap analysis for Basel II reporting requirements. Estimated required tasks and timeframe for the project lifecycle. Prepared Business Use Cases, Business Requirements documents, Design documents and UAT Test Cases for data mapping procedures and data mart reporting requirements. Prepared status reports for the project manager and the steering committee. Evaluated RFP presented by external vendor. Obtained sign-off from the business. Defined training requirements, participated in UAT procedures, assisted UAT testers. Developed user manuals and documentation.

Environment: UNIX/Win XP, Credit/Market Risk, Basel II, Agile, UML, Cognos, MS Project, PowerPoint, Visio

CNA Canada March 2006 to July 2007

Sr. Business Systems Analyst

Cargo Insurance & Records Management Web Application Implementation

Documented AS IS Business Processes for all Business Units. Designed TO BE workflow diagrams. Created Use Cases, translated high level business requirements into detailed functional specifications. Assisted business users in classifying requirements into categories. Determined which of the requirements could be automated and how to integrate automation into business and technical processes. Assisted project team in research and evaluation of alternative technical solutions. Designed UI prototype, recommended the most efficient and cost effective BI reporting solutions. Developed UAT manuals and walkthroughs, assisted business users during UAT testing.

Environment: UNIX/Win XP, Insurance, Credit Risk, Visio/ErWin, MS Project, PowerPoint, SQL Server 2000, .NET

CIBC - Capital Markets August 2004 to March 2006

Sr. Business Analyst/QA Analyst

Commercial Lending– BASEL II Capital Accord Reports Implementation

Prepared functional requirements and specifications documents for reporting requirements. Led a team of external consultants to develop a high-level business solution. Designed Use Cases, translated high level business requirements into detailed functional specifications. Provided technical guidance and advice to project teams on conceptual business and technical issues. Collected and analyzed requirements related to Credit Risk & Commercial Lending. Designed Metadata Repository and Data Dictionary to link together business requirements across disparate mainframe systems. Designed report prototypes and ETL procedures to load the data to the data Warehouse. Created UAT test cases, assisted business community during UAT testing.

Environment: IBM/UNIX/Win2000, Market/Credit Risk, Impaired Loans, RUP, Rational Rose, ErWin/Visio, Macromedia, MS Project, Oracle 9i, PL/SQL

Oracle Canada (SunLife Financial) March 2004 to August 2004

Sr. Oracle Business Consultant

Web-based Financial Application Enhancements

Analyzed business requirements, Business Requirements documents for database conversion procedures, control and reconciliation reports. Led a team of consultants in implementation of financial web modules including GL and Cash Management. Designed solutions for business users to analyze financial data using BI reporting capabilities. Designed database conversion processes to perform data loading into Data Warehouse from Oracle GL database. Created high-level QA test plans and scenarios, assisted project team during integration and QA testing phases.

Environment: Win XP, UNIX/HP, Oracle 9i/11i, Agile, PL/SQL, OWB, UML

Ontario Provincial Government September 2002 to March 2004

Business Systems Analyst

Highway Costing Application Implementation

Participated in meetings with business users to define process requirements and scope. Performed feasibility study, presented results to business stakeholders. Created business requirements, functional specifications and design documents. Created prototype for legacy system conversion operations including web front-end, reports, data mapping and loading processes. Created test cases for unit, integration and QA testing. Defined and documented training requirements. Assisted business users during UAT procedures. Provided 24/7 production support.

Environment: IBM/Win NT, Oracle 8i/9i/DB2, PL/SQL, ErWin, UML, MS Project

Fidelity Investments February 2001 to July 2002

Sr. Oracle Consultant

Brokerage Application Implementation and Support

Designed, developed, and implemented a web-based Brokerage Application for Fidelity Investments. Participated in meetings with business group to define deliverables for database layer functionalities and timeframe for deliverables. Designed Use Cases, translated high level business requirements into detailed functional specifications. Designed and created a model to access database layer based on Business Requirements. Designed back-end procedures and functions. Investigated and re-assigned critical level issues related to front-end and back-end procedures and functionalities. Participated in QA and UAT testing procedures. Provided 24 hours on-call production support.

Environment: Win NT, SUN/UNIX, Mutual Funds/Brokerage, RUP, UML, Oracle 8i, PL/SQL, Rational Rose, Access 97

CTC Software Solutions (Citibank / PWGSC) Feb 1998 to Jan 2001

Business Systems Analyst/Business Analyst

Wealth Management and Financial Application Development

Created Business Requirements, Functional Specifications and Software Design Documents. Led a team of developers and data modelers to implement new version of batch processing and design logical and physical data models. Designed, developed and tested complex reports to provide quarterly financial results to business users. Converted data from a legacy system to Oracle database. Evaluated and tested client/server applications and software for Year 2000 compliance.

Environment: Win 95/98/NT, MS Project, MS Office, Visio, SAP ABAP, SQL

Bell Canada September 1995 to February 1998

Sr. Programmer Analyst

Data Warehouse Design and Development

Created application front-end prototype and enhanced a module of Bell Canada Retirement Forecast System. Developed screens to perform load and manipulation of data, generate and export data in various formats. Customized a package to manage network objects. Created a batch module using PL/SQL and OCI to build a script file.

Environment: IBM/Win NT, HP-UX, SQL Server 6.0, JAVA, ProC, Visual Basic 4.0, PowerBuilder 5.0, Access 2.0

M&S Computer Ltd. June 1990 to March 1995

Programmer Analyst/Database Developer

ERP Financial System Development

Developed and implemented a financial system, tested an existing billing system and redesigned, implemented and supported a new billing system. Customized computer - aided design for an Automobile Plant.

Environment: Windows 3.1, HP-UX, Oracle 6.0, SAP, PowerBuilder 4.0

BUSINESS: BASEL II, Banking, Capital Markets, Credit Risk, Market Risk, Impaired Loans, Cargo Insurance, Small Business Loans, Mutual Funds, Accounting, Government

SOFTWARE: ORACLE, J2EE, OWB, .NET/ASP, ER-Win, Informatica, Rational Rose, UML, Cognos, RUP/Agile/Waterfall, PowerPoint, Mercury Suite, MS Project, MS Office, Visio

Education

Master Degree of Computer Science

Moscow State Technical University( 1987 - 1993, Moscow/Russia)

Special University Courses

Oracle, Protocols (TCP/IP), C/C++, Application Architecture

Security Clearance

Enhanced Level

Courses

Informatica, BSA, Management, Visual Basic, SQL Server, Java

Languages

English, Russian

References

Available upon request

Contact this candidate