Arnav Shankar
Wellington,WGN
Summary
Results-oriented data professional with 4+ years of experience in data analytics, data warehousing, and data engineering. Demonstrated expertise in building efficient data warehouses, creating comprehensive Power BI reports, and optimizing SQL procedures for valuable business insights. Ability to translate complex business needs into actionable strategies, empowering decision-making processes and fostering organizational growth. Skilled in data modeling, ETL processes, and visualization techniques, consistently delivering innovative solutions that exceed expectations.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Reporting Engineer
Student Job Search
06.2024 - Current
- Spearheaded the design and implementation of a data warehouse, integrating data from multiple sources, resulting in improved data accessibility and reporting efficiency.
- Developed and optimized SQL stored procedures, boosting data processing efficiency by 30% and reducing query execution time by 40%.
Built comprehensive dashboards, enabling stakeholders to visualize key performance indicators and make data-driven decisions. - Integrated third-party cloud databases such as Zoho Analytics, streamlining data workflows and reducing manual reporting efforts by 25%.
- Acted as a subject matter expert in reporting data, providing critical support and insights to business and reporting teams, leading to improved decision-making.
- Automated routine data extraction and transformation tasks using SQL, reducing manual intervention and increasing overall process efficiency. Mentored junior analysts, enhancing their SQL and reporting skills, and ensuring high standards of code quality and report accuracy.
Associate Consultant- Data & Analytics
Cognizant New Zealand
04.2022 - 05.2024
- Led the development of a robust data warehouse for a key client, integrating disparate data sources and optimizing data retrieval processes, which improved report generation speed by 50%.
- Created advanced Power BI reports, incorporating complex DAX functions to deliver actionable insights on sales growth, customer retention, and profitability.
Collaborated with stakeholders to design data models and define ETL processes, ensuring data accuracy and consistency across the organization. - Developed and documented SQL scripts and stored procedures for data extraction, transformation, and loading, reducing processing time by 30%.
Produced comprehensive reports using data mining and predictive analytics techniques, enabling stakeholders to make informed decisions. - Worked closely with the BI team to ensure seamless integration of new data sources into the data warehouse, improving data availability for reporting.
- Worked on data migration project from WhereScape Red to Coalesce, overseeing all stages of process to ensure smooth transition. This included conducting comprehensive assessment of existing data structures and workflows, developing a detailed migration plan, and executing data transfer with minimal disruption to ongoing operations.
- Implemented robust data validation techniques to ensure data integrity and consistency throughout migration process.
- Coordinated with cross-functional teams to address any issues promptly, and provided post-migration support to resolve any unforeseen challenges, resulting in improved data management capabilities and enhanced reporting efficiency.
Developer
Tata Consulting Services NZ
12.2021 - 04.2022
- Managed a data migration project from Pacsoft to SAP using MySQL for extraction and transformation, ensuring data accuracy and consistency.
- Designed and implemented a data warehouse schema with dimensional modelling, significantly improving query performance.
- Automated ETL processes with Python and AWS Lambda, including JSON transformation and regular expression checks, streamlining operations.
- Developed Power BI reports for real-time operational insights, enhancing decision-making.
- Created complex SQL queries and stored procedures to optimize data processing.
- Collaborated with cross-functional teams to improve ETL processing efficiency.
Data Analyst Intern
Parkable
03.2021 - 07.2021
- ·Cleaned up and backed up data to maintain data integrity during extraction, manipulation and processing
- Developed machine learning model to predict parking space sharing, reducing Marketing costs by 20%.
- Assisted in gathering requirements and analyzing data to support business intelligence initiative
- Developed protypes of data visualization and storytelling techniques using Power BI and other tools Identified, analyzed and interpreted trends or patterns in complex data sets by finding correlations and visualizing with charts.
- Successfully built machine learning model to predict parking space sharing using Python and Power BI, which helped Parkable reduce cost of Marketing and share of parking space was never analyzed before.
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
Reporting Analyst
Cerner Healthcare Solutions Private Limited
05.2018 - 06.2019
- Played a key role in designing and deploying a reporting data warehouse, enabling the consolidation of healthcare data for multidimensional analysis.
- Prepared business metric reports using Power BI, including daily productivity dashboards and quality assessments, resulting in a 20% increase in stakeholder engagement.
- Developed SSAS cubes for multidimensional analysis, providing deeper insights into patient demographics, treatment outcomes, and resource utilization.
- Created SQL-based SSRS reports to meet regulatory compliance requirements, ensuring accurate and timely dissemination of critical information.
- Worked on optimizing SQL queries to reduce report generation times, improving the overall efficiency of reporting processes.
Education
Master of Analytics - Data Science
Auckland University of Technology
Auckland, AUK07.2021
Bachelor of Science - Computer Science And Engineering
SRM Institute of Science And Technology
Chennai11.2018
Skills
- Data Analytics
- Data Migration
- Teamwork and Collaboration
- Data Modelling
- Power BI
- Data Warehouse
- Problem-Solving
- Analytical and Critical Thinking
- SQL
Certification
Microsoft Azure AZ 900
Additional Information
- Reference Available on request
Timeline
Reporting Engineer
Student Job Search
06.2024 - Current
Associate Consultant- Data & Analytics
Cognizant New Zealand
04.2022 - 05.2024
Developer
Tata Consulting Services NZ
12.2021 - 04.2022
Data Analyst Intern
Parkable
03.2021 - 07.2021
Reporting Analyst
Cerner Healthcare Solutions Private Limited
05.2018 - 06.2019
Master of Analytics - Data Science
Auckland University of Technology
Bachelor of Science - Computer Science And Engineering
SRM Institute of Science And Technology
Similar Profiles
Archi SaharanArchi Saharan
Recruitment and Candidate Resourcer at Student Job SearchRecruitment and Candidate Resourcer at Student Job Search
Archi SaharanArchi Saharan
Recruitment Consultant at Student Job SearchRecruitment Consultant at Student Job Search
Daniel FranklinDaniel Franklin
General Laborer at Student Job SearchGeneral Laborer at Student Job Search