Summary
Overview
Work History
Education
Skills
Software
Languages
Certification
Timeline
Generic

Sanjay Kumar Rana

Bungarribee,NSW

Summary

Talented Data Analyst with advanced knowledge of Tableau and Power BI portfolio asset management system. Exceptional organizational, project management and leadership skills. Adaptable assessor of business health, sales metrics and product success with efficiency in devising plans to devise acceptable solutions.

Overview

1
1
Language
8
8
Certificates
7
7
years of post-secondary education
4
4
years of professional experience

Work History

Business Analyst

The Bathla Group
Sydney , NSW
2021.06 - Current
  • Analyzed key aspects of business to evaluate factors driving results and summarized into presentations.
  • Improved business direction by prioritizing customers and implementing changes based on collected feedback.
  • Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.
  • Assessed impact of current business processes on users and stakeholders and evaluated potential areas for improvement.
  • Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement
  • Supported team and diverse stakeholders to analyze business needs, and develop and document both functional and non-functional specifications/stories, model workflows, model data, clarify business rules and acceptance criteria to enable capability teams to successfully deliver value and mission epics.
  • Supported team and Technical Product Owner to apply analytical thinking during iterative analysis, development, and testing activities, to provide input and anticipate and resolve issues in identification, reporting, and closing of gaps in acceptance and feasibility.
  • Reviewed contracts and agreements to identify potential risks and ideal mitigation strategies

Data Analyst Intern

Careforia
Sydney , NSW
2021.03 - 2021.07
  • Formulated procedures for data extraction, transformation and integration of health care data.
  • Conducted assessment to ensure data quality and completeness with validation techniques.
  • Assisted in designing and development of health related analytical products for overall enterprise.
  • Provided assistance for quantitative data analysis with health care, biometric and survey data.
  • Designed and developed continuous outcomes reporting for multiple intervention programs.
  • Data blending implemented on databases and generated interactive dashboards.
  • Created adhoc reports to users in Tableau by connecting various data sources.
  • Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
  • Intake, load and integrate large volumes of raw, complex health care data from various health plans and disparate sources.
  • Generated tableau dashboards with combination charts for clear understanding.
  • Identified, analyzed and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.

Business Support Analyst

Uniden Pty Ltd
Sydney , NSW
2018.04 - 2019.11
  • Resolved complex technical issues that arose on client computer using troubleshooting.
  • Identifying issues, risks and benefits of existing and proposed solutions and outlined business impacts.
  • Estimating costs and identifying business savings.
  • Simplifying information and deciphering technical jargon so it is easily understood by whole team.
  • Implementing and testing of solutions.
  • Identified and managed service risks within company, recommending best practice enhancements and guidelines updates.
  • Applied honed problem-solving skills to analyze and resolve issues impacting business operations and goal achievement.
  • Reviewed files, records and other documents to obtain business information and key data informing responses to development requests.
  • Worked closely with all product development departments to create and maintain marketing materials for sales presentations and client meetings.

Web Developer

Healthier Tastier Foods Pty Ltd
Sydney , NSW
2019.04 - 2019.09
  • Providing technical support to clients.
  • Building Websites using WordPress.
  • Tasked with the responsibility to perform hardware and software checks.
  • Creation of new website features in relation to SEO rule updates.
  • Created content for blog and SEO purposes to help drive traffic to the site.
  • Configured new plug-ins and extensions.
  • Created and managed user guides for customers.
  • Ensured work is done within the ITIL framework meeting all SLAs.
  • Multi-tasked across multiple functions and roles to generate project results and meet deadlines and organizational expectations.

IT Administration

Escentials Pty Ltd
Sydney , NSW
2015.09 - 2017.01
    • Performed light Network Administration for the newly installed machines for the users: Login issues, Password re-set, e-mail login.
    • Provided Level 1 support to the existing clients.
    • Installed and configures computer equipment software with required software policies and standards.
    • Performed hardware and software installation and provides high-level customer care.
    • Troubleshoot, researched, diagnosed, documented and resolved technical issues in Windows 9x, XP, 7, Server2008, MS Office, Outlook email setup and LAN/WAN connectivity issues.
    • Maintained financial accuracy by collecting deposits, fees and payments.
    • Managed office inventory by restocking supplies and placing purchase orders to maintain adequate stock levels.
    • Developed and updated spreadsheets and databases to track, analyze and report on performance and sales data.
    • Coached new employees on administrative procedures, company policies and performance standards.
    • Created PowerPoint presentations for business development purposes.

Education

IT Professional Year – Performance education -

Performance Education
Sydney, NSW
2018.09 - 2019.08

Bachelor of Information technology -

Federation University Australia
Ballarat, VIC
2015.04 - 2018.06

Diploma - Computer Engineering

Punjab State Board Of Technical Education
Punjab
2011.01 - 2013.08

Skills

Tableau Server, Tableau Desktop, Tableau Public, Power BI

undefined

Software

Tableau Server, Tableau Desktop, Power BI, IBM Watson, Jupyter Notebook

Languages

Python, HTML, CSS, SQL, Linux Scripting in bash

Certification

IBM Data Science

Timeline

Business Analyst

The Bathla Group
2021.06 - Current

Advanced Power BI Training

2021-05

Data Analyst Intern

Careforia
2021.03 - 2021.07

Web Developer

Healthier Tastier Foods Pty Ltd
2019.04 - 2019.09

IT Professional Year – Performance education -

Performance Education
2018.09 - 2019.08

Business Support Analyst

Uniden Pty Ltd
2018.04 - 2019.11

IT Administration

Escentials Pty Ltd
2015.09 - 2017.01

Bachelor of Information technology -

Federation University Australia
2015.04 - 2018.06

Diploma - Computer Engineering

Punjab State Board Of Technical Education
2011.01 - 2013.08

IBM Data Science

2020-10

Data Analysis with Python

2020-11

Databases and SQL for Data Science

2020-12

Data Visualization with Python

2021-01

Machine Learning with Python

2021-01

Advanced Tableau Training for Data Science

2021-02

Data Analyst Capstone Project

2021-04
Sanjay Kumar Rana