Data Analyst Accounting

Isaac L. Sims

IT Professional

EDUCATION

EXPERIENCE

SKILLS

CONTACT

ABOUT ME

TREASURY DATA ANALYST

BUSINESS INTELLIGENCE DEVELOPER

*/**** ** **/**** Archer Systems, LLC (Contract) – Southlake, TX

• Import and Exported claimant datasets between internal & external data sources.

• Created regular tracking reports for claimants and award distributions.

• Worked very closely with Accounting to reconcile claimant and law firm distributions.

• Developed scripts via VBA to automate and replace manual processes.

• Analyzed multiple datasets for accuracy and completeness. 3/2018 to 5/2020 Six Month Smiles, LLC – The Colony, TX

• Developed Ad-Hoc reporting and Visualizations to provide crucial real-time details for quick decision making by executives and stakeholders.

• Maintained multiple databases both in SSMS and Microsoft Access.

• Utilized SSMS (SQL) to integrate ecommerce site data with our Accounting systems.

• Developed complex SQL queries, automation routines and ETL processes.

• Managed KPIs, daily tracking reports, and Gemba reports for company transparency.

• Analyzed data to insight trends, job cost, equipment usage/location tracking.

• Managed hardware and software (Servers, 3D Printers, Workstations, Printers, and 3D Scanners),

• SQL Querying

• VBA Scripting

• Data Analysis

• Extract, Transform, Load Processing

• System Automation

• Data Visualization

• Create and Manage Databases

• System Administration

• Workflow Mapping

• Logic & Critical Thinking

• Planning & Execution

• Management & Leadership

• Microsoft Access (Superuser)

• Microsoft Excel (Superuser)

• Microsoft Power BI

• Microsoft Office 365

• Adobe Acrobat

• Business Objects (Crystal Reports)

• SQL Server Management Studio

• SQL Server 2012 & 2014

• Sage Accounting 50, 100 & 300

• QuickBooks

• Tableau

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

214-***-****

Little Elm, TX 75068

As a well-rounded IT Professional, I can

seamlessly adapt to various types of tasks

within the IT world. I equate challenges to

opportunity and growth. I have a proven record

of progress and innovation, allowing me to grow

within the industry very quickly. I take on

projects and tasks with pride and laser sharp

focus!

SOFTWARE

LinkedIn Profile

BUSINESS SYSTEMS DIRECTOR BUSINESS ANALYST

• Mapped business process to identify and resolve operational inadequacy and limits.

• Recommended operational improvements based on tracking and analysis.

• Analyzed data from multiple departments to categorize, track and retain data integrity.

• Created automated reports with Business Objects (Crystal Reports) and Excel for daily and ad- hoc distribution.

• Managed a small team to support the improvement of data gathering, processes, workflow and reporting capabilities of the company.

• Built and Implemented a fully automated inventory system from beginning to end to increase efficiency of resources and equipment tracking.

• Maintained multiple databases both in SSMS and Microsoft Access.

• Developed complex SQL queries, automation routines and ETL processes. 5/2014 to 3/2018 Precision Demolition LLC – Lewisville, TX Colony, TX

AP/AR COORDINATOR – RealManage – 5yrs

ACCOUNTANT II – Texas State Comptroller’s of Public Accounts – 5yrs References

Upon Request, Thank You

ASSISTANT ACCOUNTANT – Turbo Technicians, LLC – 9mths

• Some College – Ashworth College - Norcross, GA (2003) - Accounting

• Diploma - Lyndon B. Johnson High School – Austin, TX (1997 – 2000) CERTIFICATIONS

Contact this candidate