Summary
Overview
Work History
Education
Skills
Timeline
Generic

Smita Borse

33, Littleshore Crescent, CLYDE NORTH ,VIC

Summary

  • Highly-motivated employee with desire to take on new challenges. Strong worth ethic, adaptability and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.
  • developing and maintaining Power BI dashboards for both Bendigo Bank and the Civil Aviation Safety Authority online store , leveraging ERP systems to ensure accurate database management and streamline data visualization for informed decision-making.

Overview

8
8
years of professional experience

Work History

IT Generalist (Data Analyst)

Print Media Group
Scoresby, VIC
04.2024 - Current
  • Utilized data visualization tools such as Power BI to present findings and insights to stakeholders, driving informed business decisions based on ERP data analysis.
  • Analyzed customer behavior and purchasing patterns to identify trends and opportunities for increasing sales and customer retention.
  • Developed and implemented data-driven strategies to optimize product pricing, promotions, and merchandising, resulting in a 15% increase in online sales.
  • Developed SQL queries to generate weekly and end-of-month reports in SQL Server, extracting relevant data from database tables, aggregating information, and formatting results for readability.
  • Managed daily operations of the ecommerce platform, including product uploads, order processing, and inventory management.
  • Conducted market research to identify trends and opportunities, leading to the expansion of product offerings and partnerships with new vendors.
  • Collaborated with cross-functional teams to optimize website usability and enhance the overall customer shopping experience, resulting in a 15% decrease in bounce rate.

Data Analyst

MediaBRN Benchmark pty Ltd.
Dandenong South, VIC
09.2023 - 03.2024
  • Optimized existing database structures for better performance on analytics tasks.
  • Translated raw data into meaningful information using statistical techniques.
  • Managed large datasets using Excel, SQL Server, and other data tools.
  • Developed and maintained complex SQL queries and stored procedures to extract and analyze data from ERP systems for reporting and decision-making purposes.
  • Developed SQL queries to generate weekly and end-of-month reports in SQL Server, extracting relevant data from database tables, aggregating information, and formatting results for readability.
  • Performed routine data validation to ensure accuracy of reports.
  • Maintained documentation of all the processes related to Data Analysis.
  • Developed SQL queries to generate weekly and end-of-month reports in SQL Server, extracting relevant data from database tables, aggregating information, and formatting results for readability.
  • Analyzed large datasets to identify trends and patterns, providing valuable insights for client mail campaign
  • Conducted thorough quality control checks on all mail data to ensure accuracy and compliance with postal regulations.
  • Analyzed large datasets using Power BI to create interactive visualizations and dashboards for senior management, resulting in a 20% increase in data-driven decision making.
  • Developed and maintained data models in Power BI to streamline reporting processes and improve data accuracy, leading to a 15% reduction in reporting errors.
  • Collaborated with cross-functional teams to gather requirements and design custom Power BI solutions that met business needs and improved data accessibility.
  • Conducted in-depth data analysis and identified key trends and insights using Power BI, contributing to a 10% improvement in operational efficiency.
  • Collaborated with cross-functional teams to identify data requirements, design data models, and implement data solutions within SQL Server.
  • Conducted data quality assessments and implemented data cleansing processes to ensure accuracy and consistency of ERP data.
  • Utilized data visualization tools such as Power BI to present findings and insights to stakeholders, driving informed business decisions based on ERP data analysis.
  • Analyzed customer behavior and purchasing patterns to identify trends and opportunities for increasing sales and customer retention.

Freelance Data Analyst

CrafSOL Technology Solutions
Pune, India
10.2022 - 04.2023
  • Excellent communication skills, both verbal and written.
  • Provided professional services and support in a dynamic work environment.
  • Provided reporting, analysis and insights about sales drivers and key revenue performance metrics to support corporate analytics.
  • Ambitious and analytical individual with 6 months of experience in Power BI seeking to gain additional knowledge and to utilize master’s degree in Computer Application as well as knowledge in BI tools.
  • Critically evaluates information gathered from multiple sources, reconciles conflicts, abstracts up from low-level information to a general understanding, and works with customers to uncover unmet business needs.
  • Knowledge of data cleansing and modifying data according to the Business Requirement.
  • Expert in Power BI and ability to program in DAX query language to modify data for reporting .
  • Experience in creating visualizations, interactive dashboards, reports and data stories using Power BI.
  • Proficient in using functions in Excel and perform analyzing using Pivot charts.
  • Experience in developing custom reports and creating various types of reports like on demand, drill down, Drill-through, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Cross-Tab, graphical, distributed Reports in multiple formats using SQL Server Reporting Services (SSRS).
  • Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables and DW concepts.
  • Modify datasets using DAX query, Merge statements, Refresh Schedule, Row level security and Modelling within Power BI.
  • Develop different types of Tabular Reports, Matrix Reports (Cross Tab or Pivot), Chart and Graphs reports using the SSRS reporting as per the user's requirements and deployed in report server.

Junior Business Analyst

Sandtec IT Consulting
Melbourne, VIC
01.2020 - 02.2021
  • Worked with business intelligence software and various reports to glean insights into trends and prospects.
  • Demonstrated creativity and resourcefulness through the development of innovative solutions.
  • Resolved problems, improved operations and provided exceptional service.
  • Involved in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging and Maintenance of Power BI Applications.
  • Implemented complex query techniques of passing Multi - Valued parameters and cascading parameters in MDX.
  • Skilled in creating measures, calculated columns and performing time series analysis using DAX in Power BI .
  • Created reports like parameter-based reports, graphical reports, excel reports, drill-down chart using SSRS and tabular report and generated on-demand and scheduled reports for business analysis using SSRS.
  • Transform, define, navigate the data from data source and performed merge and append queries using Power Query.
  • Performed different types of context like Row context, filter context and query context using Power BI Desktop.
  • Created different chart types and drill down reports using Power Bi Desktop (SSRS).
  • Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query.
  • Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI
  • Used different type of slicers available in Power BI for creating reports.
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • Created data models, tables within Power BI to support efficient, optimized data warehousing and reporting workflows.

Computer Lab Assistant and Web Developer

K.K.Wagh College Of ABM
, India
07.2016 - 03.2018
  • Patched software and installed new versions to eliminate security problems and protect data.
  • Configured hardware, devices, and software to set up work stations for employees.
  • Provided instruction to all lab users on proper use of all equipment.
  • Diagnosed hardware problems and fixed faults or contacted appropriate repair service.
  • Directed content of website by gathering information and integrating data from other departments.
  • Approved, reviewed and edited content flowing to website.

Education

Masters In Computer Application - Computer Application Engineering

Pune University
Nashik, India
06-2016

Bachelors of Computer Application - Computer Application

Pune University
Nashik, India
07-2012

Diploma In Information Technology - Information Technology

MSBTE
Nashik, India
02-2008

Skills

  • Data analysis and modeling
  • Database Programming and SQL
  • SQL Server
  • Power BI and Dax
  • ERP System
  • Advanced Microsoft Excel
  • Java
  • Aspnet
  • HTML and CSS
  • Data Visualization and Presentations
  • Data Validation
  • Knowledge of Python
  • Knowledge of data cleansing
  • Schedule Management

Timeline

IT Generalist (Data Analyst)

Print Media Group
04.2024 - Current

Data Analyst

MediaBRN Benchmark pty Ltd.
09.2023 - 03.2024

Freelance Data Analyst

CrafSOL Technology Solutions
10.2022 - 04.2023

Junior Business Analyst

Sandtec IT Consulting
01.2020 - 02.2021

Computer Lab Assistant and Web Developer

K.K.Wagh College Of ABM
07.2016 - 03.2018

Masters In Computer Application - Computer Application Engineering

Pune University

Bachelors of Computer Application - Computer Application

Pune University

Diploma In Information Technology - Information Technology

MSBTE

Similar Profiles

CREATE PROFILE
Smita Borse