Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Anisha Joseph

Melbourne,VIC

Summary

  • Experienced Senior Data & Reporting Analyst with over 6 years of proven expertise in interpreting and analyzing complex data sets to drive business decisions and optimize processes.
  • Adept at leveraging technology and tools such as Power BI, SQL, Python pandas, sci-kit-learn and Azure Serverless apps to perform statistical analysis and develop visualization to extract insights and develop scalable solutions.
  • Skilled communicator with a track record of effectively translating data findings into actionable reports for stakeholders at all levels.
  • Demonstrated leadership in cross-functional teams, guiding junior analysts, and driving projects from conception to completion.
  • Organized and dependable team player successful at managing multiple priorities with a positive attitude and willingness to take on added responsibilities to meet team goals.

Overview

1
1
year of professional experience
1
1
Certification

Work History

Reporting Specialist

Australia Post
Burnley, VIC
05.2024 - Current
  • Designed and developed dynamic Power BI dashboards and reports to provide actionable insights from ServiceNow data, enhancing decision-making processes.
  • Automated data extraction, transformation, and loading (ETL) from ServiceNow into Power BI, ensuring accuracy and efficiency in reporting.
  • Created and maintained data models in Power BI, optimizing performance, and enabling intuitive data visualization for end-users.
  • Collaborated with cross-functional teams to gather requirements, define KPIs, and translate business needs into scalable reporting solutions.
  • Implemented role-based access and security settings in Power BI to ensure compliance with organizational data governance policies.
  • Conducted regular performance analysis of reports and dashboards, refining visualizations and measures to improve user engagement and satisfaction.
  • Leveraged DAX (Data Analysis Expressions) to create complex calculations and measures for advanced analytics in Power BI reports.
  • Provided training and support to stakeholders on using Power BI dashboards, fostering self-service reporting capabilities across departments.

Senior Consultant Data Analyst

Ernst & Young
  • Played a technical lead role in the Analytics and Engineering team for a prestigious mining client to enhance the in-house AI tool to improve track maintenance and geometry deterioration forecasting.
  • Implemented the upgrade of the existing re-rail and rail wear forecasting application using Python libraries such as pandas, scikit-learn, Azure serverless apps and Azure SQL DB.
  • Collaborated with stakeholders for requirements gathering and solution design, implemented machine learning modelling using multiple linear regression techniques, model evaluation in mean squared error and variance measurement using r-squared.
  • Performed a key role in the Platform Engineering taking ownership of implementing the monitoring and alerts of the SQL DB usage, data replication latency and integration runtime status.
  • Implemented monitoring using the OpenTelemetry Python API and Azure function apps to send custom metric data to Application Insights and set up monitoring through SQL Workbook and KQL scripts.
  • As part of the internal EY Sales Analytics team, conducted data analysis and designed data models in Power BI Desktop.
  • Developed complex dashboards using DAX measures and advanced visuals to showcase trends and gaps in individual KPIs, sales and revenue.
  • Extensively used SSMS to design and develop tables and stored procedures using Advanced SQL for ETL and connect the same to the Power BI desktop for visualization.
  • Generated ad-hoc reports in Excel to evaluate specific business requirements.
  • Performed validation testing and assisted stakeholders for UAT testing and post-deployment testing.

Senior Data Analyst

Commonwealth Bank
  • Dedicated team player in the Home Buying space in Data and Decision Science portfolio at Commonwealth Bank, which deals with Home Loans and related credit products.
  • Collaborated with stakeholders from Product and Business teams to understand requirements and provide reliable solutions.
  • Conducted technical analysis and performed data discovery using data files from multiple sources.
  • Designed and developed schema data models as per project requirements.
  • Extensively worked on Spark SQL and Hive on Hadoop cluster for computational analytics using complex queries to fetch data from Hive tables and process the same to create batch reports which provide useful business insights.
  • Developed scripts for creating tables and views in Hive using Hive QL.
  • Prepared documentation and analytical reports delivering summarized results and conclusions to stakeholders.
  • Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.

Data Analyst

Tata Consultancy Services
  • Performed the role of a squad lead in the Platform portfolio for a banking client, which caters to BDR remediation of repositories for all portfolios.
  • Designed and developed Hive tables and .hql scripts to process various complex datasets.
  • Utilised Spark ETL framework that aims at the transformation of data in data integration, enrichment and access layers using SQL as per business requirements.
  • Developed Scala codes to facilitate migration of jobs to Houston, a Disaster Recovery solution, which records run-time data and processing details necessary to revive the system in case of disaster.

Application Development Analyst

Accenture
  • Dedicated team player in the policy and claims administration portfolio for a UK government-based Insurance client.
  • Utilised Apache Sqoop to unload data from MySQL to HDFS using Sqoop scripts and Sqoop jobs.
  • Created Managed tables and External tables in Hive and loaded data from HDFS using Apache Hue.
  • Developed HQL scripts to schedule in Crontab to run on time for various client requirements.
  • Worked on different file formats like text files, CVS, XML, JSON and AVRO files.
  • Collaborated with On-site Business Analysts for requirements gathering and clarification, system testing, comparing counts etc.

Senior Software Engineer

Infosys Technologies
  • Worked as a team player in Online Fulfillment mainframe team for an American publishing and financial information client.
  • Responsible for handling the database of subscribers and maintaining their contact histories, billing profiles and delivery-related information.
  • Worked as a technical programmer writing COBOL codes to implement various major and minor project work requests.
  • Involved in production support activities like ABEND resolution, adhering to SLA and providing permanent fixes for redundant ABENDS.

Education

Bachelor of Technology - Computer Science

Cochin University of Science And Technology
India
04.2012

Skills

  • Microsoft Power BI
  • Analytical and critical thinking
  • Data warehousing and analysis
  • Advanced SQL, Spark SQL
  • Python programming
  • Data analysis libraries: Pandas, scikit-learn, SciPy
  • Azure Cloud - Logic Apps, Function Apps, Azure Synapse Analytics, Azure Application Insights
  • Tools: MS Excel, VS Code, Jupyter Notebook, JIRA, Azure Data Studio, Azure Boards, and Server Management Studio (SSMS)
  • Business intelligence
  • Microsoft Excel
  • ETL processes
  • Snowflake concepts

Certification

  • PCAP-31-03 - Certified Associate in Python Programming
  • AZ-900 Microsoft Azure Fundamentals
  • Snowflake Snow Pro Core Certification
  • ITILV4 Foundational Certification

Timeline

Reporting Specialist

Australia Post
05.2024 - Current

Senior Consultant Data Analyst

Ernst & Young

Senior Data Analyst

Commonwealth Bank

Data Analyst

Tata Consultancy Services

Application Development Analyst

Accenture

Senior Software Engineer

Infosys Technologies

Bachelor of Technology - Computer Science

Cochin University of Science And Technology

Similar Profiles

CREATE PROFILE
Anisha Joseph