Summary
Oversees the daily transactional cycle of 302 business locations to assist with systematic challenges and legal documents ranging from implementation of business strategies to accelerate critical decision- making stages of acquisition, Inventory management, supply chain and financial reporting.
Supports big data handling efforts with the aid of data support tools and software to execute group strategies.
Lead project-based assignments with emphasis on data analytics, data manipulation and data visualization for effective departmental performance and scheduling on various accounts.
Skills
Tableau
Microsoft Office Suite (Excel, Word, MS Project, PowerPoint)
Python
SQL Queries
Data Science
Salesforce
Education
Bachelor of Science in Accounting and Business Administration, SUNY Polytechnic Institute
Associate Degree in Business Administration, Tompkins Cortland
Certification
SQL for Data Science, IBM
Data Analytics, IBM
PROFESSIONAL EXPERIENCE
Lithia Motors Inc. Calabasas CA May 2021 - present
Business Analyst
Lead weekly/Monthly meetings on policy and Team performances update for both remote and onsite teams.
Utilize data visualization tools such as Tableau and Alteryx to create and display dashboards, charts, graphs and maps for presentation and data analytics purposes.
Utilize SQL server to run basic queries and obtain necessary data in Python and IBM DB2
Responsible for governance of the Alteryx server, developing and maintaining data workflow using the Alteryx tool, developing integration from Alteryx into reporting platforms such as Power BI, and supporting regional operations work through the development of metrics and dashboards
Transforming raw data into actionable insight based on custom reports, dashboards, and data visualization
Ability to utilize SQL and NoSQL to manage data repositories in IBM DB2
Experienced on Python, workflow process mapping, sharing, updating and dashboard in pandas
Oversee and ensure the accurate entry of all departmental financial transactions are executed in accordance with the data ecosystem teams
Serve as a consultant for educating /training multi departmental groups concerning discrepancies in general ledger accounts and evaluating the best preventative measures to adhere to.