Business Systems Sql Server

Sherry Tremblay

Business Systems Consultant

.

***- ***-****

.

******************@*****.***

.

Goffstown, NH 03045

.

PROFESSIONAL SUMMARY

IT professional with over 15 years' experience in agile and waterfall methodologies in technical and cross-functional leadership in information systems development and implementation, as well as business processes and applications. Strong business system analysis/design, documentation, business process optimization, change request management and prioritization, data analysis/reporting, system implementation and product support spanning various industries such public and private sectors: banking, biotechnology, education, advanced energy, finance, healthcare, insurance, investment trade banking, retail, and software technology. A proven track record of increasing productivity, quality, and customer satisfaction. Strong analytical and problem-solving skills, excellent planning, and multi-tasking abilities, with proven experience in utilizing people and process knowledge to help enterprises make critical decisions.

SKILLS

Microsoft Tools – SharePoint, Office 365, Access, (Excel V-Lookup / Pivot Table), PowerPoint, Project, Visio, Word, PlanView Enterprise Requirements / Issue Management - Confluence, Cherwell Service Management, HP Quality Center, JIRA, Remedy, TFS Microsoft Team Foundation, MIRO Server SQL Server Management Studio, SQL Studio Reporting, SQL Server Analysis, and SQL Server Integration Process Flow Tools: Bizagi, Lucidchart, Visio Data Analysis / Reporting: Tableau, Microsoft Power BI Marketing Systems: Salesforce Pardot B2B Marketing Automation CRM / ERP Systems: Salesforce, Salesforce Community Cloud, Salesforce Lightning Microsoft Dynamics 365 and CRM, Proprietary CRM Systems ERP Systems: Microsoft Dynamics GP, Infor Lawson Zoho One Cloud: Accounting and Finance, CRM, Expense Reporting, HR, Ecommerce, Campaign Management, Social Media Management, etc.

.

Banking and Financial Data Analysis

.

EXPERIENCE

DYNAMICS 365 BUSINESS SYSTEMS ANALYST, Windsor, CT

TRC Energy Companies, Inc., October 2022-November 2023

Worked with large energy companies and retail big box stores with a focus on clean energy transition – from conception and research, to program planning and design, to implementation, customer engagement, engineering support, evaluation, and continuous improvement.

Collaborated with internal colleagues and external clients to identify and understand all business processes, ensuring alignment with departmental and company needs

Worked closely with the executive team to appoint process owners for all business processes, enhancing accountability and efficiency

Demonstrated strong leadership and teamwork in gathering and documenting requirements, workflows, and other critical components of the business processes

Effectively managed multiple projects concurrently, focusing on Dynamics 365 and Client Portals

Meticulously documented process flows and data flows for each business process, enabling clear visualization and comprehension

Crafted comprehensive process instructions and established training plans, ensuring seamless implementation and knowledge transfer

Identified business requirements for each process, guaranteeing alignment with organizational goals

Effectively prioritized and led process improvement projects, delivering impactful enhancements to meet business objectives.

.

INFOR BUSINESS SYSTEMS ANALYST/INFOR ERP ADMINISTRATOR, Concord, NH

State of New Hampshire, September 2019-October 2022

Led as the advisor of Infor IPA's for Finance, Purchasing, Talent Management and Human Resources on the functionality of the State of New Hampshire Enterprise Resource Planning (ERP) system

Provided operational support and led the design and building of automated business processes using Infor Process Automation (IPA) framework

Reviewed system configuration and design options, making appropriate recommendations for system changes, enhancements, and maintenance requests

Led optimization efforts for the State's Infor ERP system, focusing on efficient configuration and alignment with business strategies

Collaborated with business users to identify and implement best practices, ensuring effective and efficient use of Infor ERP functionality

Designed and built automated business processes using the Infor Process Automation (IPA) framework

Configured ERP System security processes and rolled out changes to impacted business teams

Successfully streamlined and automated processes, reducing exposures by 80% and enhancing overall system efficiency

Created test plans and coordinated and participated in testing across the business units impacted

Production support for security issues, software issues and training issues.

.

BUSINESS SYSTEMS CONSULTANT, Boston, MA

RXPhoto Medical, March 2019-September 2019

RxPhoto supports both a web based and mobile application HIPAA compliant photography management tool (cloud based/SAAS) used by medical practices worldwide.

Led the transition to a new Zoho Financial system

Reduced operational processes related to financial service applications by 70%

Redesigned the business pricing engine increasing company revenue by 40%

Created user stories, wireframes of new screens, product features, groomed backlog

Worked with offshore and onshore teams in the development, maintenance, and support of CRM application customizations

Perform audit on AWS framework and RXPhoto contract to ensure that they were HIPAA Compliant.

.

SR. BUSINESS SYSTEMS ANALYST/PRODUCT OWNER, Windham, NH

Medicus Healthcare Solutions, June 2017-December 2018

Project entailed building a custom CRM / ERP system with API's to Salesforce, Microsoft Dynamics Great Plains and Salesforce Pardot; replacing legacy homegrown ERP software, replacing the old .NET code with a modular, PHP-based micro-service architecture in the backend to a new proprietary ATS/ERP System Implementation. Software used: SQL Server Management Studio MYSQL Navicat Erwin Data Modeller Bizagi Workflow Salesforce Microsoft Dynamics GP Ceridian Payroll Concur - Travel Salesforce Pardot - Marketing Campaign Management.

Led a cross-functional business team across the United States to develop a customized CRM and Applicant Tracking System, integrating API's with Salesforce, Microsoft Dynamics Great Plains, and Salesforce Pardot

Successfully implemented Medicus' first CRM system after three previous unsuccessful attempts with other CRM vendors

Designed and crafted engaging dashboards and reports, resulting in a 20% boost in sales performance

Conducted a comprehensive analysis of microservices to determine readiness for AWS adoption

Expertly integrated Salesforce with the new CRM, maintaining, creating, and updating user roles, security measures, profiles, and workflow rules

Seamlessly integrated Dynamics Great Plains with the new CRM, meticulously documenting user requirements and crafting detailed specifications for the customization of the GP ERP system

Produced technical specifications for API integration from the CRM to GP, ensuring seamless data exchange.

.

BUSINESS SYSTEMS CONSULTANT-PROJECT MANAGER, White River Junction, VT

LAB PARTNERS, February 2016-May 2017

Lab Partners is a testing laboratory following strict FDA rules and regulations.

Successfully completed the full implementation of Microsoft Dynamics CRM and Integration with Dynamics GP system

Streamlined and automated processes by 80%, reducing exposures by building solutions to remedy the issues

Identified operational deficiencies, re-engineered business processes, and implemented new CRM systems with workflows

Led the Microsoft Dynamics CRM and Dynamics GP system implementation, ensuring seamless integration and efficiency

Played a pivotal role in streamlining and automating processes, reducing exposures by 80% and enhancing overall system efficiency

Identified operational deficiencies and re-engineered business processes, ensuring alignment with ERP best practices.

.

SR. BUSINESS SYSTEMS ANALYST-PRODUCT OWNER, Medford, MA

SiriusXM / AGERO Roadside Assistance, August 2006-January 2016

Simultaneously worked on five interdependent products, including mobile and web applications, external and internal APIs, and a homegrown CRM platform that powered 90% of a $1 billion business and was utilized by 3,500+ contact center agents, mastering end-to-end workflows of insurance and automotive industries in the process.

Lead BA for the Automotive and Insurance Client Implementation Team, managing 8-10 client implementations at any given time

Implemented Salesforce CRM and Dynamics CRM systems, reducing implementation time and improving claims processing efficiency

Successfully integrated Salesforce with the new CRM, maintaining, creating, and updating user roles, security measures, profiles, and workflow rules

Reduced implementation time for an average-sized client from 6 weeks to 2 weeks

Managed and mentored 4 junior business systems analysts and 1 junior project manager

Lead BA for replacing existing claims processing systems and financial accounting system

Reduced claims processing time by 70% by implementing Dynamics CRM system

Lead BA for implementing a solution to support a new product line for field dispatches

Implemented Salesforce CRM.

.

EDUCATION

BACHELOR OF SCIENCE (B.S.) IN CIS CANDIDATE, Manchester, NH, US

Southern New Hampshire University, Expected graduation 2027

CERTIFICATIONS

Agile - Disciple Agile Delivery

ITIL Foundations

Six Sigma Green Belt

SQL Certifications in SSMS, SSRS, SSAS, and SSIS

PMP Currently Pursuing

WEBSITE, PORTFOLIO AND PROFILES

www.linkedin.com/in/sherrylynntremblay

REFERENCES

References available upon request

Contact this candidate