Tableau Server, Tableau Desktop, Power BI, IBM Watson, Jupyter Notebook
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
06.2021 - 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
03.2021 - 07.2021
- 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
04.2018 - 11.2019
- 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
04.2019 - 09.2019
- 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
09.2015 - 01.2017
- 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 09.2018 - 08.2019
Bachelor of Information technology -
Federation University Australia
Ballarat, VIC 04.2015 - 06.2018
Diploma - Computer Engineering
Punjab State Board Of Technical Education
Punjab 01.2011 - 08.2013
Skills
Tableau Server, Tableau Desktop, Tableau Public, Power BI
Computer Languages: Linux scripting in bash, Python, XML, HTML5 and CSSNetworking: WLAN, 80211ac, WPA2, Static IPDatabase: MySQL, PostgreSQL, SQL
OS Applications: Active Directory, Group Policy, VMware, Office 365, Google G-suite, Linux Send mailOperating system: Linux, Ubuntu and Debian Linux, Windows 7/10 and Mac
Google Analytics, Data Analysis,
Understanding of database procedures, Data collection processes
Software
Certification
IBM Data Science
Timeline
Business Analyst
The Bathla Group
06.2021 - Current
Advanced Power BI Training
05-2021
Data Analyst Intern
Careforia
03.2021 - 07.2021
Web Developer
Healthier Tastier Foods Pty Ltd
04.2019 - 09.2019
IT Professional Year – Performance education -
Performance Education
09.2018 - 08.2019
Business Support Analyst
Uniden Pty Ltd
04.2018 - 11.2019
IT Administration
Escentials Pty Ltd
09.2015 - 01.2017
Bachelor of Information technology -
Federation University Australia
04.2015 - 06.2018
Diploma - Computer Engineering
Punjab State Board Of Technical Education
01.2011 - 08.2013