Open to opportunities

VIKRANT JOSHI

@vikrantjoshi

Message

Passionate data analyst with a finance background and coding skills.

India

Message

What I'm looking for

I am looking for a role that fosters innovation and offers opportunities for growth in data analytics.

I am a dedicated analyst with a strong finance background and a passion for data analytics. My journey began with a desire to empower decision-making through advanced data analysis, leading me to self-teach coding skills that complement my analytical abilities. I have consistently demonstrated my commitment to excellence, receiving the Excellence in Performance Award in 2023 for my innovative contributions and timely delivery of reports.

Throughout my career, I have developed analytical dashboards using Power BI, automated reporting processes, and created financial models that have significantly reduced costs. My experience spans various roles, including Senior Business Intelligence Analyst and Senior Data Analyst, where I have honed my skills in SQL, Power BI, and Excel. I thrive in environments that challenge me to learn and adapt, and I am always eager to embrace new technologies to enhance project outcomes.

Experience

Work history, roles, and key accomplishments

Current

Senior Business Intelligence Analyst

Current

Dept. of Education - Victorian School Building Authority

Jul 2024 - Present (11 months)

Developed SQL Server views and dynamic queries in Production environments, focusing on leveraging Master and transactional tables for reporting and analytics. Built SSRS and Power BI reports, translating business requirements into actionable insights and dashboards.

SQL Server Power BI ETL VBA Excel Oracle

Senior Data Analyst

Dept. of Education - Victorian School Building Authority

Jul 2019 - Present (5 years 11 months)

Automated data analysis and reporting processes to support strategic decision-making. Created analytical dashboards using Power BI for procurement, project management, finance, and month-end reporting.

Power BI Excel VBA SQL Server SSIS Data Analysis Reporting

Senior Data Analyst (Property & Land Titles)

Dept. of Health & Human Services

Mar 2019 - Present (6 years 3 months)

Extracted and formatted data up to 70,000 rows and 90 columns to simplify metrics analysis and identify anomalies using Advanced Excel, Macros (VBA), and Power BI (Power Query). Utilized Power Query in Power BI to pivot and un-pivot the data model for data cleansing and massaging.

Advanced Excel VBA Power BI Power Query SQL Queries

Finance Analyst

Carlton & United Breweries

Dec 2018 - Present (6 years 6 months)

Created Capex IT Project Cost Tracker template using Advanced Excel Functions, Macros, and VBA. Headed reconciliation of monthly Capex Actuals SAP Report versus TM1 data and consolidated Capex and Opex forecast/budget submissions.

Advanced Excel VBA SAP TM1 Budgeting

Business Development Manager

Max Exp Solutions Pty Ltd.

Feb 2017 - Present (8 years 4 months)

Responsible for driving business growth and developing new client relationships. Managed key accounts and identified opportunities for market expansion.

Business Development Client Relationship Management Market Expansion Sales Strategy Negotiation

Senior Finance Analyst

Telstra Corporation Ltd.

Jun 2016 - Present (9 years)

Ensured a high level of data cleansing, data manipulation, data extraction, and data sorting in Excel, facilitating automation. Performed revenue reconciliation exercises based on applications such as Netsuite, SAP, and Flexcab Data.

Excel Data Manipulation Financial Modeling VBA SAP NetSuite

Senior Finance Analyst

Singtel Optus Pty Ltd.

Jan 2016 - Present (9 years 5 months)

Administered Capital Funds Approvals and Capital Program Portfolio Management. Executed cost centre and general ledger analysis from SAP HANA with necessary recommendations and facilitated automation by transferring Manual Journals into General Ledger.

General Ledger Financial Statements Automation

Accounts Payable Officer

Bilfinger Water Technology

Oct 2015 - Present (9 years 8 months)

Managed accounts payable processes, including invoice processing and vendor payments. Reconciled vendor statements and resolved discrepancies.

Accounts Payable Vendor Management Financial Reporting

Marketing Manager

Indian International Film Festival of Queensland

Apr 2015 - Present (10 years 2 months)

Developed and executed marketing strategies to promote the film festival. Managed social media campaigns and coordinated promotional events.

Marketing Strategy Social Media Marketing Event Coordination Public Relations Content Creation

Accountant

SupaServices Pty. Ltd.

Jun 2014 - Present (11 years)

Prepared financial statements and managed general ledger accounts. Assisted with budgeting and forecasting activities.

Financial Statements General Ledger Budgeting Forecasting Account Reconciliation

SAP Finance Analyst

Arrow Energy Pty. Ltd. (Royal Dutch Shell)

Sep 2012 - Present (12 years 9 months)

Gained exposure in SAP and led Project Accounting & Assets Capitalization of Capital Work through CAPEX Asset Management life cycle SAP FI. Developed a new financial model using Excel functions that resulted in reducing overhead cost by $2 million.

SAP FI SAP Project Accounting Excel Financial Modeling

Project Reconciliation Officer

Dept. of Education & Training

Sep 2011 - Present (13 years 9 months)

Performed financial reconciliation of Budget vs Actuals/commitments for 200 state high school projects in Excel using pivot table/Vlookup. Verified invoices against Budget vs Act/Commit Reports and Purchase Order Commitments Line items.

Excel Pivot Tables Financial Reconciliations SAP General Ledger

Reconciliation Officer

Komatsu Australia Pty. Ltd.

Jul 2011 - Present (13 years 11 months)

Performed financial reconciliations and ensured accuracy of financial data. Assisted with month-end closing procedures.

Financial Reconciliations Month End Close Financial Reporting Data Analysis

Accounts Payable

Clough Projects Ltd.

Mar 2011 - Present (14 years 3 months)

Processed invoices and managed vendor accounts. Assisted with payment runs and resolved accounts payable inquiries.

Accounts Payable Invoice Management Vendor Management Payment Processing Financial administration

Education

Degrees, certifications, and relevant coursework

Queensland University of Technology

Master of Commerce, Applied Finance

Completed a Master of Commerce with a specialization in Applied Finance. Gained advanced knowledge in financial principles and their practical applications.