Daniel Perreault Email & Phone Number

Sudbury, Ontario, Canada

Develop and administer strategies for the control and sharing of company database resources and services. Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures. Develop long-term goals for production databases in conjunction with data owners and department managers. Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts. Ensure the stability and reliability of data access and data quality across the organization via ongoing database support and maintenance. Analyze user requirements for reports, forms, queries, and data extraction. Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes. Provide end-user training as necessary with regards to the effective and efficient use of database tools and resources. Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements. Create and document models for new database development and/or changes to existing ones through data flowcharting. Plan and assist with the installation and configuration of relevant network components to ensure database access, consistency, and integrity. Respond to and resolve database access and performance issues. Advise on the allocation of physical data storage for database systems. Develop, implement, and maintain change control and testing processes for modifications to databases. Perform database transaction and security audits.

Sudbury, On

Monitoring and making recommendations for performance improvement in hosted databases.Experience in supporting very large and highly transactional databases and troubleshooting.Providing production support to users.Maintain the integrity, availability and recoverability of all production data systems.Conducting Database Refreshes from Production to UAT/Development environments.Extensive ETL work including SSIS to provide daily data exports.Support Production, UAT and Development environments.Monitoring all Production servers using third party tool IDERA Diagnostic Manager.Created SQL Server logins and assigning roles and authentication models as a part of Security.Creating a Datawarehouse in a STAR schema using a COLUMNSTORE index for more optimal performance.Reviewing database code to provide recommendations for Table structure, performance and code enhancements.

Sudbury, On

Create, Modify and Design Crystal and SSRS reports for internal and external use.Create SSIS packages for data transfers for warehousing.Modified COBOL code, relating to an adjudication system.Create and modify T-SQL scripts for various uses including invoicing calculations.Create and modify Oracle SQL scripts for various uses.Creating Source Control standards within the reporting team.Adhering to Source Control and Implementation standards.Train internal and external clients on enhancements to existing and new product offerings.Training new employees on our internal systems and processes.Complete Business Analysis of our internal and external processes to identify inefficiencies and provide solutions.

Sudbury, On

Deliver a quality product by ensuring that bugs have been detected prior to implementation.Participate in the development of business requirements.Ensure that final product meets business requirements.Develop test cases: outline expected and observed results.Develop time estimates.Tested newly developed products/screens.Completed Regression testing.Enhancements to existing applications.Hardware upgrades.Train internal and external clients on enhancements and new products.Provide detailed communications to internal and external clients of system implementations.

Sudbury, On

Responsible for providing efficient and consistent customer service to cardholders and/or providers.Responsible for handling all e-mail inquiries, as well as, any correspondence from clients.Responsible for processing member and provider reimbursement claims, as well as, ensuring that all policies and procedures are followed in order to meet ClaimSecure’s accuracy rate and standard turnaround times.