John "Harrison" Hodge

- Efficiently managed 12 Power BI Workspaces, overseeing the production and distribution of over 100 reports tailored to the distinct needs of World Finance's Operations Team, Accounting, Marketing, Auditing, and Executive teams.

- Provided comprehensive reports to empower each department with actionable insights. These reports covered a wide range of areas including Bonus Structure Management, Tax Insights, Audit Compliance, Executive KPI Monitoring, and Credit Portfolio Analysis.

- Utilizing Python and R, I conducted thorough summary analyses of datasets procured from our business analysts. This approach enabled us to extract valuable patterns and trends, facilitating informed decision-making across all departments.

- Successfully translated existing Microsoft SQL code to Microsoft Snowflake, ensuring seamless migration and optimization of our data infrastructure to support the diverse analytical needs of each department.

- Designed and managed over 50 PowerBi reports pertaining to TTIs distribution insights.

- Used Snowflake, Python (Pandas, Numpy, ChromeDriver) and Microsoft SQL Server to procure datasets for reporting needs.

- Provided visualization to Financial Reporting and Supply Chain KPIs for distribution management.

- Translated over 25 reports from Microsoft SQL Syntax to Snowflake SQL.

- Managed large-scale databases to ensure timely access to critical information for key stakeholders.

- Reduced operating costs by automating manual data processes using scripting languages such as Python.