Thornhill, ON, L3T4M6 Cell: 416-***-****
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.
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
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
Bachelor of Electronics and Telecommunication June 1996
University of Cluj Napoca, Romania
References Available on Request