Power Bi Data Analyst

EXPERIENCE

Camco Manufacturing, LLC, Winston Salem, NC

Data Analyst, Power BI Developer 2022 - 2024

Assisted consultants with querying and gathering data for company’s Microsoft Dynamics 365 conversion and UAT environment. Uploaded data for test environment via D365 Data Management Framework (DMF)

Migrated data from AX 2009 to Microsoft Dynamics 365 by working with consulting company building stored procedures and various tables within Data Validation Framework (DVF).

Built BIS messages that import data into D365 F&O from legacy system for go live date.

Converted legacy on-premise application to a cloud based environment.

Built and modified stored procedures and SSRS reports for legacy Axapta 2009 and D365 systems.

Converted, built, and deployed Power BI reports to facilitate reporting gaps between business needs and D365 out-of-box reports.

Worked with consulting company to build a new EDI system for Purchase Order, Shipping, and Invoicing Automation for customers with D365 Finance and Operations.

Assisted users with resolving various issues within Dynamics 365 post go live.

Fielded and analyzed gaps in processes that exist between a highly customized AX2009 system to a standardized D365 cloud environment.

Worked on issues received via service desk related to conversion, permissions, and report discrepancies.

Brock & Scott, Attorneys at Law, Winston Salem, NC

Report/SQL Developer, Technical & Business Analyst & HotDocs Developer 2015 - 2022

Assisted CIO with reviewing upcoming projects, primary projects, and completed analysis of requirements.

Ran reports on Service Desk tickets, reviewed, and prioritized with Director of Operations; then delegated to developers.

Maintained and updated CMS databases, stored procedures, tables, and lists. Worked with offshore development team.

Developed reports out of Case Management System (CMS) using SQL, SSRS, Power BI, and Excel Writer templates.

Developed legal documents for automated rendering using HotDocs 11, XML, XSD schema and data from CMS.

Wrote SQL stored procedures to update HotDocs XML and XSD schema to pull data from our CMS into documents.

Wrote SQL stored procedures, statements, views to create/update fields, lists, and data within Case Management System.

Created and maintained various Microsoft SharePoint websites for divisions and practice areas.

Created and maintained a library of refreshable reports, displayed on Sharepoint, using Excel Power Pivot & Power BI.

Designed, developed, automated, and maintained Firm’s service desk system using Manage Engine ServiceDesk Plus.

Designed, gathered requirements, created reports, and wrote stored procedures for internal applications.

Analyzed, designed, and created reports for automated processes and integrated projects with client systems and legal vendors (i.e., Auction.com, ProVest, NetDirector, BlackKnight, Better Choice Notice Solutions).

Interviewed subject matter experts within business for business process management implementation.

Defined and documented business and application system requirements and ‘as-is’ and ‘to be’ business processes.

Served as a liaison between attorneys, executives, staff, and technical team members.

Communicated and collaborated with internal and external customers to analyze information needs and functional requirements to deliver methodologies and project artifacts including use cases, workflow analysis, test scenarios, and proposed user interface designs.

Created technical specifications, conducted data analysis, and coordinated with offshore developers to complete changes to Case Management System.

Conducted acceptance testing on new versions of Case Management System in test environment before deploying to production environment.

TECHNICAL KNOWLEDGE & SKILLS

Axapta 2009

Systems Analysis

Dynamics 365

Systems Design

C#

Business Telecommunications

VB.Net

Networking

ASP.Net

Business Application Development

HTML5

Web Application Development

Microsoft Power BI

Accounting Information Systems

Microsoft SQL Server 2019

Management of Database Systems

Microsoft SSRS 2019

Understanding of relational databases

Microsoft Server 2012

Software Development

Microsoft SharePoint 2013

Object-oriented design

Microsoft Visio 2016

Business process modeling

Microsoft Office 2016

Use case modeling

Microsoft Visual Studio

Corporate Financial Accounting

Microsoft Team Foundation Server

Auditing

ManageEngine ServiceDesk Plus

Managerial Accounting

HotDocs 10 & 11

Accounting Ethics

Client Systems (Black Knight, Vendorscape, Clarifire)

NetDirector

EDUCATION

Bachelor of Science, Business Administration, 2014

University of North Carolina Wilmington, Cameron School of Business

Concentrations: Management Information Systems and Accounting

MIS Concentration GPA: 3.9 Cumulative GPA: 3.34

Worked 40 hours per week while maintaining full course load

Honors List

Associate in Pre-Business Administration & Associate in Arts Degree, 2002 & 2011

Cape Fear Community College, Wilmington, NC

Concentration: Accounting

Worked 30 hours per week while maintaining full course load

Dean’s List and Honors List

ACTIVITIES

Volunteered at Carolina Beach Help center, a local organization aiding homeless and domestic violence victims.

Member of Cameron Executive Network.

Contact this candidate