Post Job Free

Resume

Sign in

Data Analyst Microsoft Dynamics

Location:
Yakima, WA
Posted:
November 26, 2023

Contact this candidate

Resume:

Myron Hannigan

**** *. ******* ***, ******, WA 509-***-**** ad1gfp@r.postjobfree.com

Accomplished and detail-oriented IT Data Analyst bringing 30+ sole source years of expertise in designing, developing, and maintaining highly scalable, secure, and reliable data structures. Possesses strong analytical skills, exceptional problem-solving abilities, and a deep understanding of database technologies and systems. Equally confident working independently and collaboratively as needed and utilizing excellent communication skills.

Professional Experience

Yakama Nation Finance Toppenish, WA

Finance Data Manager June 2017 - June 2023

Thoroughly handled tier 2/3 support for the Finance division, auditors, and consultants related to Data Mining, Data Analysis, and specialized reports.

The implication of Microsoft Dynamics 365 and iSolved to replace the legacy system JD Edward installed in 1994.

Oversaw security settings, user roles, profiles, groups, and queues within Microsoft Dynamics Finance and Operations 365.

Served as iSoved report writer for export detail data and imported summary in Microsoft Dynamics 365 utilizing "Dynamics Connector."

Exported budget data and designed budget templates and/or analysis for the development of fiscal year budget policies, targets, and allocations.

Constructed per-capita payment file to use monthly for all 11,000 Yakama Nation Enrolled members including, RAP, Elders, Full Time Student, and Trust, averaging 27 million per year.

Trained team members from Accounting, Payroll, Insurance, and Administration on data quality processes in payroll. Resulting in a 5.0% decrease in errors.

Yakama Nation Credit Enterprise Toppenish, WA

MIS Systems Analyst August 2012 - June 2017

Successfully implemented Laserfiche and performed as Laserfiche Record Management and Administrator.

Completed Laserfiche document capture of 2.8 million records with images in QuickFeilds, Zone OCR, and SQL to populate metadata.

Consolidated and integrated financial systems, leading to 66% increase in overall efficiency.

Acted as administrator for multiple areas including Exchange Server – OWA, Microsoft Office 365 E3, Microsoft Server - DNS, AD, DHCP, Edgewave iPrism Web Filter, Sonicwall Router, Fiserv Cunify, and Mitel 5000 phone system with SIP Trunking

Skillfully furnished redundant repository backup from NAS servers and Unitrends

Carried out document capture utilizing a third party for all printed checks, capturing from PRN file sent to check printer for metadata and image of checks.

Executed Meraki Switches/Wireless AP for Cloud Management, actively monitoring WAN, VLAN, software license, and hardware management.

Milne Fruit Products Prosser, WA

Systems Administrator/Accountant September 2006 - October 2011

Installed, configured, and customized + internal and external software applications for business use. Implement Microsoft Navigation from legacy software.

Monitored server performance leveraging industry-standard tools and performance evaluation metrics to make sure all servers ran at peak production levels.

Implemented an accounting system that improved staff efficiency and reduced the overall cost of accounting by 40%

Acted as administrator for multiple areas including Exchange Server – OWA, Microsoft Office 365, Microsoft Server - DNS, AD, DHCP, Edgewave iPrism Web Filter, Sonicwall Router, and Mitel 5000 phone system with SIP Trunking

Additional Experience

Yakama Forest Products Information Systems Administrator White Swan, WA Yakama Nation Housing Authority Computer / Network Specialist Wapato WA Core Competencies

Data Analyst, Data Minning, Data Analysis, Big Data Expertise, Electronic Content Management, Information Flow Management, Administration & Management, New Market Identification, Regulatory Reporting Requirement, Database Development, Planning Processes, Business Intelligence Project Management

Technical Skills

30+ IT, Microsoft Server, AD, DHCP, DNS, Exchange Server, Data Conversion, Data Cleaning, Excel Expert, ODBC, Power Query, Power Pivot, DAX, SQL, SQL Queries, Laserfiche (Administration, QuickFeilds, Workflowk, third party, Power BI, Crystal Reports, JetReports, KeyBank (Administrator Navigator, Consolidated Payables, Key2Prepaid), Enrollment Software (Progeny, TEAMS) Laserfiche (Administration, QuickFeilds, Forms, and some workflow) Payroll (iSolved, eTime), WAN, VLAN, Microsoft (Word Expert, Power Point, Outlook, Projects, Teams, Forms, Visio), DocuSign Forms, SharePoint.

Education & Certification

As a Native American in High School, both my wife and I fit the profile of American Engineering in Science (AEIS), Targeting minorities that fit the profile to be ENGINEERS. It is my deep belief I would have a successful career in my passion for Computers and my wife in Accounting, (I have no regrets, my path is amazing of multi-grandkid with over 25+ over marriage).

60 Credits toward Laser Optics in Engineering with an emphasis in Laser Optics and Electrical Engineering, Oregon Institute of Technology

Over 100 Credits towards Engineering Transfer, Yakima Valley Community College

Microsoft Certified Professional, Microsoft

Network+ Certification, CompTIA

A+ Certification, CompTIA

Microsoft Office Specialist Master, Microsoft Microsoft Office Specialist Excel Expert, Microsoft Microsoft Office Specialist Excel Core, Microsoft Microsoft Office Specialist Word Expert, Microsoft Microsoft Office Specialist Word Core, Microsoft Microsoft Office Specialist PowerPoint, Microsoft

Certified Microsoft Office Specialist Outlook, Microsoft

IC 3 Certified (Internet and Computing Core Certification), Certiport

Volunteer Experience

United Way of Yakima County

Key Spokes Person, Loan Executive & Allocation Panel Member Johnson-O’Malley Treasure for Yakama School District



Contact this candidate