Senior Data Analyst – Resume Sample in PDF

-Responsible for the automation of Finance processes using various technologies such as VBA, SQL, Power Pivot, Redshift, Power BI, Python Pandas, Snowflake, Tableau that allow to save big amount of time and increase efficiency in reporting.
-Build and update complex dashboards through Tableau.
-Act as a link between BI team and Finance team.
-Supervision of Finance Automation processes.

-Design, improve, deliver reporting and analytics solutions using Tableau and Amazon Redshift SQL.
-Maintain existing business reporting and analytical solutions by providing production support for troubleshooting and regular processing needs.
-Develop and document standards/best practices for development and administration of the Tableau platform providing expertise in data visualization and optimization.

-Design, maintenance of ETL processes through Microsoft SSIS and complex SQL nested Stored Procedures and automation of long excel routines through SQL queries.
-Develop data analytics and reporting through MS SQL and Tableau for IT Portfolio Management team.
-Responsible for database management and support (grant permission levels, database backups, schedule, check and build SQL Agent Jobs).

-Prepare,upload intercompany transactions into the consolidation system (Hyperion Financial Management ) and perform Month End closing activities.
-Alter existing VBA codes and write new scripts for the purposes of automating report generation.
-Reconcile intercompany accounts to ensure accuracy and compliance with internal financial policies, contributing to the overall integrity of financial statements.

-Assess customer credit worthiness by analyzing financial data, market/country conditions and customer reputation of assigned portfolio.
-Financial analysis and reviews include interpreting financial statements, ratio analysis and cash flow statements.
-Monitor and manage credit limits for customers, adjusting them based on updated financial data and market conditions to mitigate credit risk.

-Process and verify supplier invoices, ensuring accuracy and compliance with company policies before approval for payment.
-Assist in resolving discrepancies between purchase orders, invoices, and delivery receipts, working closely with vendors and internal departments.
-Support the preparation and submission of payment runs, ensuring timely and accurate processing of vendor payments.