Support Analyst Sql Server

Irina Kaminsky

Phone: 416-***-****

E-mail **********@*****.***

TITLE Senior Finance Applications Support Analyst

QUALIFICATIONS

TOOLS: MS-DYNAMICS 2010/GREAT PLAINS, DYNAMICS GP 2015/2018, DYNAMICS 365 BUSINESS CENTRAL, E–ONE SMARTCONNECT, SQL Server Reporting Services, FRx REPORTS, MANAGEMENT REPORTER, FYI SOFT REPORTS, OFFICE, JIRA

RDBMS: SQL SERVER, ACCESS

EXPERIENCE SUMMARY

25 years’ experience in ERP systems support including troubleshooting at SQL/database level

Proven ability to bridge the gap between business needs and technical solutions, with deep knowledge of full-cycle

accounting processes

25 years’ experience in corporate reporting / accounting

25 years’ experience in support as required throughout various aspects of the full accounting cycle

25 years’ experience in customer support and training

Adept at gathering and analyzing business requirements, developing actionable insights, and supporting data-driven

decision-making

Strong ability to handle incidents, problems and change at a global enterprise level

Skilled in cross-functional collaboration, incident management, and delivering high-quality support in fast-paced,

enterprise-level environments

Proficient in Jira for project tracking, workflow customization

Recognized for strong analytical thinking, attention to detail, and a commitment to continuous improvement

A reliable team player with exceptional communication skills and a proactive approach to learning and

problem-solving.

PROFESSIONAL EMPLOYMENT

06/2020-06/2025 Richards Packaging Inc, US/Canada

Position Senior Finance Systems Support Analyst / AR Analyst

Monitor customer accounts to identify overdue payments and follow up on delinquencies

Participated in the end-to-end migration from Microsoft Dynamics GP to Dynamics 365 Business Central, ensuring business continuity through detailed data validation and testing

Reconcile customer accounts and investigate discrepancies to ensure accurate reporting

Designed and developed custom financial and operational reports using FYI Soft, SmartList Builder, and SQL Views based on stakeholder requirements

Supported month-end close activities and prepared AR reports for finance leadership

Conducted in-depth data analysis using Excel and SQL to support business decision-making, including reconciliation, trend analysis, and variance reporting

Supported the development and enhancement of reporting solutions to meet evolving business and regulatory requirements

Led data cleansing and transformation initiatives, standardizing large datasets and improving data quality and usability for reporting and analytics

Created documentation and training materials, and provided end-user training to ensure adoption and proper use of new tools and processes

Provided subject matter expertise on Dynamics GP and Business Central, offering ongoing support and troubleshooting for over 200 users across North America

Supported Inventory and Field Service operations, including quarterly inventory counts and post-implementation system stabilization and improvement

Automated key financial procedures using Integration Manager, including exporting to Excel Pivot Tables for real-time analysis

Developed and maintained EFT (Electronic Funds Transfer) processes, ensuring timely and accurate vendor payments

Acted as liaison between business users and IT to ensure alignment of system capabilities with business objectives

Performed detailed testing, reconciliation, and validation to ensure data integrity and system accuracy post-migration

Created and modified Management Reporter and FYI Soft reports for financial and business performance monitoring

Researched and resolved data integrity issues in financial reports and reconciliations by communicating with business users and external partners

02/2009-04/2020 Heart and Stroke Foundation, Toronto, Canada

Position Senior Finance Systems Support Analyst

Initiated and executed process efficiency by creating and updating reports, to support the analysis of key revenue and expense areas, as well as maintained and updated existing reports on as needed basis

Worked closely with IT for all updates

Developed multiple integrations in Integration Manager to automate daily procedures

Combined data from multiple sources (SQL databases, Excel files, flat files, etc.) into integrated views that can be used to drive analysis and summarized crisply for executive decision making

Coordinated with various stakeholders and offshore team with weekly status call. Analyzed the specifications provided by Business Analysts

Developed and maintained integrations from CRM Dynamics to Dynamics GP using E-One SmartConnect

Developed, implemented, and maintained EFT (Electronic Transfer) payments

Administered Dynamics GP 2010/Dynamics GP 2015. Ensured high availability of Dynamics GP as well as other tightly coupled business application

Customized and maintained required reports from Dynamics GP including expert level use of SmartList

Developed custom reports from Dynamics GP using SmartList Builder and SQL View

Provided on-going MS-Dynamics/Great Plains support for 200 users including remote troubleshooting

Provided training and maintained training materials and procedures documentation

Provided all level of support – basic support and troubleshooting, configuration, database administration, and repair for server

Provided support for the development of reporting solutions to meet business objectives

Customized GP Report and Form Dictionaries

Created GP Bank Formats for Electronic Reconcile

Created and modified advanced reports in FRx Reports 6.7, Management Reporter, Excel 2007

Administered BI 360 - configured and managed the data warehouse, added modules and dimensions, managed attributes to empower better reporting, and running processes to manipulate data

Utilized Excel tools (Power Query, pivot tables, filters) to identify and correct data discrepancies, improving data quality and integrity

Conducted detailed Excel-based data audits, applying formulas and logic checks to enhance reliability of business-critical information

06/2006-02/2009 724 Solutions, Santa Barbara, US

Position Senior Financial System Analyst

Prepared reports for CEO and executive management to support financial analysis

Applied financial reporting changes mandated by management

Provided monthly/quarterly analysis of fixed assets, deferred revenue, and inter-company accounts

Assisted, the VP/Controller with client relations and technical questions

Fulfilled the Systems Administrator role for MS-Dynamics\Great Plains, established and maintained security for 12 users

Provided budget analysis for assigned departments

Performed MS-Dynamics\Great Plains installations and upgrades

Modified MS-Dynamics\Great Plains applications to facilitate accounts payable

Provided training and maintained training materials on application functionality across all MS-Dynamics\Great Plains modules and FRx Reports 6.7 writing

02/2002-06/2006 724 Solutions, Toronto, Canada

Position Financial System Analyst

Designed and implemented a new chart of accounts and an organizational structure for financial reporting

Prepared monthly reporting packages for assigned departments highlighting the key drivers in the operating expenses

Provided monthly/quarterly analysis of fixed assets, deferred revenue, and inter-company accounts

Prepared annual budget and quarterly forecast reports

Provided support of Project Accounting Model’s user

Performed MS-Dynamics\Great Plains installations and upgrades

Created and modified reports in FRx Reports 5.5, Excel 2000 and Access 2000

02/2002-08/1998 Futureway Communications, Toronto, Canada

Position Financial System Analyst/Developer

Created and modified reports to meet user requirements using MS-Dynamics\Great Plains report writer

Provided training on application functionality across all MS-Dynamics\Great Plains modules and FRx report writing

Fulfilled the Systems Administrator role for MS-Dynamics\Great Plains, established and maintained security for 18 users

Modified MS-Dynamics\Great Plains applications to facilitate accounts payable and accounts receivable

Created an Oracle-related Revenue Analysis Report using Cognos Power Play 6.6

Created workflow applications of business activities using Ultimus Workflow Suite

Performed financial system upgrades and user installations

Identified peripheral applications requirements, coded, tested and implemented applications with guidance

Maintained user documentation

EDUCATION

1981-1987 M Sc. in Economics Institute of Technology St Petersburg, Russia

2009 SharePoint 2007 Toronto, Canada

2008 Advanced Excel Toronto, Canada

2001 Advanced Developing SQL Queries for Oracle8i Toronto, Canada

1999 Visual Basic 6 and ActiveX for Enterprise Applications Toronto, Canada

1991-1993 Business Administration and Accounting Management College, Israel Tel-Aviv

REFERENCES Available upon request

Contact this candidate