• Maintained, supported and managed all IT & IM systems, SQL Server database and applications for Regional and National which includes payroll(Commissionaires Enterprise Management System-CEMS), accounting(ERP – Microsoft Dynamics Great Plains), HR - CEMS, contracts(Microsoft CRM -Maximizer CRM), Quarter Master Stores- WASP Inventory Control and ID Services billing system (Regional and National) using Microsoft SQL database servers (physical and virtual) for production and testing environments. • Configured and maintained reports in all systems including Management Reporter Smartlist, Commissionaires enterprise management system (CEMS) reporting tool using SQL servers and SSRS using both Oracle and SQL database servers • Maintained and Configured Filemaker Pro financial application \ reports for a POS system • Create end user training and guides • Maintain technical documentation for all IT & Telecom systems and processes • Provide adhoc, on-the-job and classroom technical training as required to end users and clients

• Assist, Configure, Maintain securely support all IT (WAN & LAN) and Voice Infrastructures • Assist in research and implement new software and hardware solutions • Assist research and procure and /or influence the purchase of new products and solutions • Remote desk side support to HQ , Regional and National clients • Assist Account Management and 2nd line technical support to all Enterprises • Create end user training and guides • Maintain technical documentation for all IT & Telecom systems and processes • Provide adhoc, on-the-job and classroom technical training as required to end users and clients

 maintaining the CEMS reporting system for Business Operations  assisting in the administration/implementation of database maintenance and changes  liaising with IT on CEMS related problems  assisting in the development and implementation of CEMS field user requirements  providing CEMS initial, follow-up and refresher training  assisting in the development and maintenance of CEMS departmental training plan  providing advice, and support to all CEMS users  providing back-up support of database administrative duties and as a dispatcher  liaising with department representatives to ensure changes meet requirements  liaising with Business Operations Managers to ensure the CEMS field user requirements meet the contract agreements meet  maintaining unit templates/schedules  conducting ISO responsibilities  other related duties as assigned by the Supervisor Dispatch

Brigitte Leveille’s responsibility was to support and maintained the data warehouse along with some development work through Microsoft Visual Studio 2005 – Integration Services, Analysis Services and Management Studio. Her other duties included maintaining the packages and correcting some development work within the Integration Services. She also worked with OLAP reports through MS Visual Studio – Analysis Services to maintain the cubes. These reports would range from daily sales to how many customer counts per department. Mrs. Leveille muli-tasked her projects and the work given changed on a daily basis. She resolved many complex server and database issues that evolved the data warehouse and the cubes. Responsibilities: Analyzed and corrected the packages within the Integration Services  Debugged and executed packages  Reviewed and Executed Jobs as individually or as a group  Re-started Servers Analyzed Multi-Dimensional Expressions (MDX) for sales calculations within Analysis Services Reprocessed and debugged cubes for managements’ reports  Debugged Cube partitions Monitored daily servers and databases for any issues Conducted Quality Control to all their databases Created and executed complex SQL statements for verifying the data in the databases from previous incorrect entries and nightly entries Conducted research into the packages and cubes for gabs/double counted appearing in the databases and in the reports like the number of customers being doubled in a department Updated Management on a daily basis from every issues of certain risks of executing jobs to why/what caused servers/jobs not run Documented all the projects that she worked on for future “What if this happened” and “Lessons Learned” Documented all work cases that required “What to do”

Providing GHG Data Warehouse system support and advice to the GHG division Conducting Quality Control activities of the data in the data warehouse system.Assisting IT Security team as a Project Aurthority to implement a Threat and Risk Assessment for the GHG Data Warehouse.Working with IT Operations to implement the Environment Canada GHG dissemination – Facility information website for the public.Conducting Quality Control and Assurance activities for the Environment Canada GHG dissemination website for the public.Applying and verifying an End-to-End testing for the GHG Reporting System.Giving suggestions to her manager for future changes to the GHG Data Warehouse system.Reviewing and documenting the GHG reporting system changes for the next reporting year in compliance with the Canada Gazette Notice (legal documents). Assisted with the GHG Data Warehouse training for the GHG reporting division.Managing the users’ access to the GHG Data Warehouse system

 Developed database objects for clients’ data fixes.  Analyzed support tickets assigned to her in priority order within target timeframes. Delivered successful projects and tasks on-time, in-budget; Provided effective customer communications; Maintained high quality on all deliverables; Analyzed business requirements and developed technical requirement specifications; Worked independently and in a team format depending on the issue at hand. Multi-tasked to resolving the issues at hand; Created work effort estimates that will be used as the input to project schedule work breakdowns; Provided knowledge sharing with other FreeBalance personnel; Participated in bid preparation, and validate proposals; Performed timely support to client support issues; Performed other related duties as requested.

Data optimization applied to the database Worked with data warehousing concepts and techniques.Developed and implemented an Enquiry ‘s database using all phases of the System Development Life Cycle (SDLC). Created scripts using PL/SQL or SQL programming languages Supported and maintained applications that use the mobilink servers and Adaptive Server Anywhere (ASA - 7.0.0) databases Configured ASA databases.Performed PL/SQL procedure changes to one of Event Result System’s for data optimizationWrote Oracle PL/SQL scripts to generate test dataReversed Engineered Oracle data models and generated reportsCreated and maintained the data models for the Oracle applications throug Oracle Designer (CASE tool)Tested the Oracle Designer software for volume and multi-schemas.Worked with Impromptu reports for user/client’s requirements

 Performed analysis and detailed design of problems assigned by Project Leader Coded, unit tested and documented work assigned by Project Leader using the SDLC Performed system tests and reported to system test Project Leader while performing this function Passed completed work package to the Project Leader for review Prioritized work with Project Leader User/Client Liaison Assisted users with testing as required Documentation Ensured migration requests were completed Provided status report to Project leader Assisted with training of other Software Developers Applied principals of quality, Value Success to day to day work Trained software developers and Project Leaders