Resume of Senior Business Analyst

Title
Senior Business Analyst

Primary Skills
Business Analysis, Project

Location
Canada-ON-Toronto

Posted
Sep-16-07


PROFILE

• 18 years of business/systems solutions experience in the financial industry.
• Broad range of experience covering business and functional requirements gathering/analysis, project management, business/process/data/system modeling, testing, business / data architecture, data-warehousing, system development life cycle and training.
• Excellent organizing, planning, presentation, consensus building & interpersonal skills

PROFESSIONAL EXPERIENCE

NP Consulting, Toronto
Senior BA /PM
January 2006 to Present

• Elicited, analyzed and documented business & technical requirements for the financial software company clients. (Projects >1Million USD for: S1/FRS).
• Managed internal/external business/technical personnel, project activities, issues and timelines (Europe/North America).
• Developed project study report and project plan for the financial software company's clients in the financial industry.
• Developed functional documentation for the reporting application.
• Created and reviewed RFP's.
• Explored to develop business/systems with small/medium equity trading companies.
• Researched, developed strategies for equities/option trading.
• Provided training: Business /Systems Analysis, Project Management and Equities/ Options Trading.

Bank of Montreal, Toronto
Senior Business Analyst/ Consultant (Contract)
November 2004 to November 2005

• Basel Central Solution Data Mart: Gathered, analyzed and documented Basel II requirements for Credit Risk, Equity Risk and Marketing Risk by eliciting information from the Business Team and Information Management personnel.
• Coached new Business Analysts and other Basel project team members on business process, standards and practices.
• Reviewed RFP, evaluated vendor software solution and suggested changes.
• Leading Basel II capital calculations technical implementation with the Business Team.
• Bank-wide Reconciliation: Estimated Information Management work due to Bank-wide reconciliation project.
• Harris Bank Marketing Data Mart: Documented technical functional requirements for the Sales & Marketing Contact Management Data Mart.

Royal Bank, Toronto
Senior Business Analyst (Contract)
September 2004 - October 2004

Basel II Project (High level solution assessment):

• Management Reporting & Governance: Conducted workshops, interviews with Business Managers at various platform/portfolio levels and documented high level business solution meeting Basle II requirements.
• Securitization (Conduit & Banks own assets): Conducted interviews with Business Managers and documented high level business solution meeting Basle II requirements.

CIBC, Toronto
Senior Business Analyst (Contract)
February 2003 - August 2004

Basel II Project:
• Retail Reporting: Interviewed Business Managers, Business Users, Coordinated with systems personnel and coached Business Analysts in producing reporting requirements, Basel II requirements, data mapping and data model documentation for Retail Banking, Wealth Management and Wholesale Automotive group.
• Special Debts Application: Developed the Data Model by coordinating with Business Analysts, Business Users, ETL programmers, Developers, Database Administrators and reported to the Project Manager.
• Credit Exposure: Developed the security, reference data- Data Model by interviewing developers and Business Analysts.
• General Application Security: Identified high level requirements, developed the data model by interviewing developers, systems personnel and reported to the Project Manager.
• Wholesale Banking Datawarehousing: Developed test-plan, test cases for the adjustment application; identified BASEL data requirements and produced data mapping.
• Documented Project improvements.
• Environment: Oracle 9, UNIX, CA Erwin, SQL (TOAD), Windows NT, VSS, Visio and MS Office Pro.

Royal Bank, Toronto
Senior Business Analyst (Contract)
January 2002 - October 2002

• Credit Application Database (Data Warehousing Development) Project: Gathered/Analyzed business requirements; participated in data modeling; planning, designing, implementation of the datawarehouse and conducted testing. Produced data mapping and data definition documentation. Interacted with ETL programmers, database administrators, project managers and business managers (credit risk).
• Environment: IBM MVS, TSO/ISPF, JCL, DB2, NCR Teradata, COBOL, SQL, FOCUS, Windows NT Niku Project Manager and MS Office Pro. This significantly improved development of strategies, credit scoring and analysis.

TD CANADA TRUST, Toronto
April 1999-August 2001
Project Lead/ Business Analyst

• Managed I.T. infrastructure projects for the Credit Risk Management & Modeling department.
• Modeling Data mart Project (customized database for modelers): Gathered/analyzed business requirements, conducted planning, designing, testing and implementation with statistical modeler/programmers, contract programmers, corporate IT department and the Data Warehouse team. Environment: IBM DB2, AIX (UNIX)/Oracle 7 Datamart, SAS, Windows NT, Lotus Notes, and 4 MS Project. This reduced the learning curve, data extraction time and created more time for valued analysis.
• Business Objects Project for the Lending Group (Client-Server database that insulates end users from the complexity of the database and enables intuitive data extraction, reporting & analysis): Gathered/analyzed business requirements, conducted planning, participated in designing the data model, testing, implementation with programmers, end users, corporate IT department and the Data Warehouse team. Environment: IBM DB2, AIX (UNIX)/Oracle 7, Business Objects, MS Windows NT 4 and MS Project. This enabled easier understanding of data, reduced data extraction time. Thereby creating more time for analysis and reporting for the Lending Group.
• Model Tracking & Scoring Project (Automated program for data extraction, statistical modeling and scoring of the credit/loan applicants): Gathered/analyzed business requirements, conducted planning, designing, testing and implementation with in-house modeler/programmers, contract programmers, corporate IT department and the Data Warehouse team. Environment: IBM DB2, AIX (UNIX)/Oracle 7 Data Warehouse, SAS, MS Windows NT 4 and MS Project. This reduced data extraction time and enabled more time for valued analysis by modelers.
• Reporting Data mart Project (Customized database for reporting and automating the publishing of reports to the intranet/internet) - Developed a business case, and feasibility report. Developed a project plan, gathered/analyzed business requirements, developed a data model, developed a testing plan for the implementation, and conducted meetings, presentations. Environment: MS Windows NT 4, SQL Server 7, MDDB/OLAP and MS IIS 4 Server. This was to reduce data extraction time and thereby generate reports quickly.
• Data File Layout Project (Organized information of data fields used by the Risk Management & Modeling Department from diverse data sources of the two merged companies): Gathered/analyzed requirements through meeting with end-users, analysts, product managers; researched and organized a data file layout for the department. This enabled a better understanding of existing data for data extraction/ analysis and data warehouse enhancements.
• Generated risk /financial performance reports (Mortgages, Personal Loans, Business Loans, Credit Cards) in a IBM DB2, TSO/ISPF, SAS, QMF, COBOL, Focus, MS Access, Excel and Windows NT environment. This information helped in fine tuning the strategies, policies - which in turn affect profitability of the financial portfolios.
• Advised the VP and the team on the Risk Management systems process (transactional systems, data warehousing, data marts, and end user applications) as the two financial companies were integrating. This enabled streamlining the data extraction and analysis process.
• Participated in development of new reporting formats, which focused on relevant information and avoided excessive information in the context of the merger of two companies.
• Developed departmental web-site using Dream Weaver and Java Navigational tool.

EDUCATION

• Project Management Professional (PMP).2006
• Canadian Securities Course. Canadian Securities Institute, Toronto.2005
• Options Trading. Optionetics, USA.2005.
• Data Warehousing Boot camp: Pieter Mimno, Informatica & Business Objects.
• SAS Programming & Enterprise Miner.
• Ontario Mortgage Brokers certification.
• Courses:
- Oracle Developer/Administrator.
- SQL, PL/SQL. Developer 2000 Forms 4.5/5. SQL Plus. SQL Loader. CASE Tool: ERWin.
- Object Oriented Design & Development, Use Cases, RUP, Unified Modeling Language, and Quality Assurance.
- HTML, CGI/PERL, Java, JavaScript, FrontPage 98, IIS4, UNIX and Visual Basic 5.
• Certified NetWare Engineer.
• Systems Analysis & Programming Diploma. Control Data Institute, Toronto.
• Post-Graduate Diploma in Business Management. India.
• Bachelor of Science. University of Mysore, India.

Certifications
PMP


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in Canada-ON-Toronto »
View all resumes in Canada-ON »

View other Senior Business Analyst resumes