Summary
Overview
Work History
Education
Skills
Personal Information
Timeline
Generic

Prem Ashish

Ahmedabad

Summary

. Detail-focused Data Analyst with knowledge in data warehousing, process validation ,Business Intelligence and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.

Overview

7
7
years of professional experience

Work History

Lead Business Data Analyst

Kraft Heinz
08.2022 - Current
  • Determine operational objectives by studying business functions, gathering information, and evaluating output requirements and formats
  • Interpret, evaluate, and interrelate research data to develop integrated business analyses and projections for incorporation into strategic decision-making
  • Collaborated with cross-functional teams to develop and maintain data pipelines and integration processes Through Tool like Alteryx and Matillion, resulting in a 25% increase in data processing efficiency
  • Designed and developed a data warehouse automation process that reduced manual effort by 80% and improved data processing speed by 50%
  • Developed and maintained ETL processes through Alteryx and Matillion that moved over 1TB of data per day from source systems to Snowflake, ensuring data accuracy and completeness
  • Designed and developed data models and data warehouses that supported business intelligence and analytics solutions, resulting in a 20% increase in data-driven decision-making
  • Troubleshot and debugged data issues, reducing data-related incidents by 40% and improving overall data quality by 25%
  • Developed and implemented a new Tableau dashboard for a retail client, resulting in a 25% increase in sales and a 15% reduction in inventory costs
  • Trained and educated end-users on how to use Tableau and Power Bi dashboards effectively, resulting in a 20% improvement in data literacy across the organization
  • Conducted ad-hoc analysis and reporting as needed to support business decisions, providing key insights that led to a 5% increase in revenue for the client
  • Created complex SQL queries to extract meaningful insights from large datasets, which improved operational decision-making times by 12%
  • Used Numpy and Pandas to Manuplated and clean data that reduced the time by 1hrs
  • Design, Develop, and maintain data base objects like tables, views, functions, stored procedures, and scripts in snowflake
  • Standardize and automate company processes using Alteryx, including: SQL table updates, generating new SQL queries, ease of use macros, and more
  • Minimize Stock outs, Work order to cash team to get the money on time, effective Vendor Management, and collaboration, Enable control and Visibility on Trade Investment Team
  • Followed UI /UX design while developing dashboard
  • Actively Involved in all phase Of Report Building
  • Our Team Followed Agile methodology
  • Responsible for creating report for Order to cash, worked on report such as WOPA and NABS which save around 4 hr per week
  • Pioneered the adoption of Agile methodologies in the BI department, boosting productivity by 18% and accelerating report delivery by 40%
  • Minimize Stock outs, Work order to cash team to get the money on time, effective Vendor Management, and collaboration, Enable control and Visibility on Trade Investment Team.

Business Data Analyst

Anneal Pvt.Ltd
03.2022 - 07.2022
  • Implemented data governance processes to ensure data accuracy and compliance, resulting in a 95% reduction in data errors and improved data quality
  • Able to design, develop, and maintain ELT/ETL pipelines in and out of data warehouse using a combination of Python and Matillion Snowflakes SNOWSQL that help the business to refresh the data 2 times faster than BI tool
  • Developed and maintained data governance and data quality standards, resulting in a 50% reduction in data errors and a 25% increase in data reliability
  • Done Analysis On call Centre where we have used Pandas and Numpy to clean data, And Build Dashboard in Power Bi to Show KPI like Avg time spend by Agent, No Of Calls, how many successful call he has achieved etc
  • By doing so we have increased by 10% Accuracy in its work recruitment by tracking his efficiency
  • Helped in implementing end to end multiple data migration solutions and improvements in the current design process involving Matillion as an ETL tool
  • That helped 5% in process improvement
  • Developed Dashboards that display KPIS related to infection control and medication processes, improving the staff ability to monitor patients' progress by 90%
  • Done Analysis On call Centre where we have used Pandas and Numpy to clean data, And Build Dashboard in Power Bi to Show KPI like Avg time spend by Agent, No Of Calls, how many successful call he has achieved etc
  • By doing so we have increased by 10% Accuracy in its work recruitment by tracking his efficiency
  • Managed a Tableau project for a healthcare client, analyzing patient data to identify areas for improvement and reduce hospital readmission rates by 10%.

Analyst – Data & Quality

Radiant and Radical Air System Pvt Ltd
07.2017 - 08.2021
  • Design, Develop, and maintain database objects like tables, views, functions, stored procedures, and scripts in SQL
  • Troubleshoot and resolve issues related to Alteryx jobs and workflows
  • Automated key Sales reports using Power BI, saving 10 hours of manual work per week for the finance team
  • Enhanced executive decision-making by designing interactive Power BI dashboards that highlighted actionable insights, leading to a 12% increase in operational efficiency
  • Conducted in-depth data analysis using DAX to identify a 15% cost-saving opportunity in the sales department
  • Implemented data governance processes to ensure data accuracy and compliance, resulting in a 15% reduction in data errors and improved data quality
  • Created and maintained Tableau data sources and data extracts, improving data accuracy by 15% and reducing data processing time by 20%
  • Developed and maintained ETL processes, ensuring timely and accurate data extraction, transformation, and loading into the database
  • Designed and developed a complex CTE, stored procedure, improving system performance by 20% and reducing query execution time by 10%
  • Developed and maintained data integration processes for a large-scale project, successfully integrating data from multiple sources into a centralized database, resulting in a 25% improvement in data accuracy and a 30% reduction in data duplication
  • Implemented data quality processes, including data profiling and cleansing, resulting in a 40% improvement in data accuracy and a 20% reduction in data inconsistencies.

Education

B.Tech - Mechanical Engineering

Siddhartha Institute of Engineering And Technology
05.2017

Skills

  • Tableau
  • Power BI
  • Snowflake
  • Alteryx
  • Data Visualization
  • MSSQL
  • Statistical Analysis
  • Matillion
  • Python: Pandas, Numpy, Scikt-Learn, Matplotlib,Seaborn
  • Agile
  • Exploratory Data Analysis
  • Project Management

Personal Information

Title: Senior Business Analyst

Timeline

Lead Business Data Analyst

Kraft Heinz
08.2022 - Current

Business Data Analyst

Anneal Pvt.Ltd
03.2022 - 07.2022

Analyst – Data & Quality

Radiant and Radical Air System Pvt Ltd
07.2017 - 08.2021

B.Tech - Mechanical Engineering

Siddhartha Institute of Engineering And Technology

Similar Profiles

CREATE PROFILE
Prem Ashish