CARMEN DINE

** ******** **** ****: 905-***-****

Thornhill, ON, L3T4M6 Cell: 416-***-****

ac87g5@r.postjobfree.com

Highlights of Qualifications

Over 15 years’ expertise in defining business solutions in an IT environment in a business analyst role - working with business owners and IT development staff

15 years’ experience working within a software development environment

Create exceptional business/functional requirements documents using cases and test plans from product definitions

Excel in project leadership roles – managing/coordinating complex projects involving enhancements to existing product platforms

Strong listening and interpretative skills for facilitating understanding of issues and solution designs

Maturity and dispute resolution skills, able to address conflicting requirements required

In depth knowledge of Microsoft Office (Microsoft Access, Excel, Visio, Power Point) SQL, Visual Basic, ServiceNow, Crystal Reports, Visual Studio, Reporting Services, Tableau, SAP.

Professional Background

Analyst 2017 - present

TD BANK –Toronto

Provide specialized end-to-end reporting support and business insights for one or more business areas

Produce specialized reporting packages, dashboards, scorecards, data extracts, analysis for assigned business area(s) while demonstrating solid understanding of business objectives

Create complex and comprehensive BI reporting packages utilizing enterprise data infrastructure as well as localized data marts and other data sources

Deliver insights and commentary that can inform and shape business decisions as pertains to Wealth business and sales performance management

Develop, adopt and evolve best-in-class reporting capabilities including moving to common "look and feel" for reporting packages produced within the team and evolving report automation standards

Review, analyze and understand the data and data sources to ensure that all business requirements are met and that the reporting is comprehensive, efficient and accurate

Validate the quality and integrity of the reporting processes and the data included in the reporting packages

Continue to improve reporting processes with respect to efficiency, accuracy and timeliness

Support changes to Scorecards, Dashboards to allow the business to track additional metrics as required

Maintain documentation for processes and participate in cross-training to support the team’s succession planning

Business Analyst 2012 - 2016

TD BANK -Toronto

Define, plan, coordinate and obtain information requirements to support and launch new products and software releases.

Prepare insightful analysis on monthly performance, using both quantitative and qualitative methodologies to deliver key insights to senior manager/ executives in an easily digestible manner.

Collaborate with key stakeholders to provide financial and service level analytic and insights for new initiatives to understand staffing.

Work directly with Team Manager and Senior Manager across Canada to review trends, research data and prepare analysis, tracking actuals vs target/budget and providing variance reporting for the business.

Develop business architecture using requirements such as scope, processes, alternatives and risks.

Perform daily, monthly financial and regulatory reports for the business, and ad-hoc reports.

Develop daily and monthly financial and regulatory reports for the business within the established timelines.

Experience with SQL Reporting, Tableau, Crystal Reports, SAP Business Objects and other report writing tools utilizing SQL, Access, Excel.

Analyzed purchase patterns and attitudinal data to reveal new CRM growth opportunities to enhance consumer spending.

Lead in implementation of new or changed reporting requirements in operation routine, by providing analysis, programming and testing for new report requests from broad user requirements provided by the Manager or Business user.

Undertake process improvement initiatives which involve development and enhancement of new and existing models in MS Access, Excel applications, and ad-hoc SQL querying to mine data from the various Lending source systems.

Develop problem solving and analytical skills, and implement plans to suite business plans objectives.

Programmer –Reporting Analyst 2009 - 2011

Leland Industries Inc. Toronto

Designed and developed a sales analysis and reporting application. This program was designed to be used by the company's managers in order to assist them during the marketing and business decision making.

Environment: SQL, Visual Basic, Crystal Reports, Visual Studio, SAS Business Intelligence, Fourth Shift, MS Access, Visual Basic.

Provide enterprise server solutions to corporate clients according to the business process and requirements of the organization

Perform analysis for business application

Designed and developed an inventory application. The system included the following modules:

oInventory database update

oMonthly commission code, gross profit and valuation reports

oCalculate product shortages and generate daily reports

oCustomer orders and backlog reports

oPricing quotations

Experienced with SQL Reporting, Crystal Reports, SAP Business Objects and other report writing tools utilizing SQL Server, Access, Excel

Design and develop SSIS packages, SAS, SSRS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance

Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

Provided end user support.

Programmer/Reporting Analyst 2008 – 2009

CrossCap Media Services- Toronto

Code, debug, document and install new programs and make changes to existing programs/technologies

Perform maintenance and develop documentation for all developed programs

Write structured application/interface code from specifications conforming to established methodology and standards

Provide first-line problem resolution or escalation, as well as technical assistance

Analyze end user needs and developing customer oriented solutions which interface with existing applications

Develop, implement and maintain application software to established standards and specifications

Work in cooperation with technical support to prepare application software procedures and documentation for usage, operation, back-up and recovery, problem resolution, shut-down and initialization and process automation

Liaise with end users to test application software, ensuring accuracy, integrity, interoperability, and completeness to achieve desired results

Education

Bachelor of Electronics and Telecommunication June 1996

University of Cluj Napoca, Romania

References Available on Request

Contact this candidate