Prem Ashish
Ahmedabad
Summary
Experienced programmer with 6.5+ years of relevant experience in the field relevant dashboarding story using Tableau & Power BI along with 5+ years’ experience in SQL the main concentration on data analysis, data migration & visualization techniques using data driven tools & techniques by working on various optimization techniques and help delivering project requirements through excellent problem-solving capabilities. Strong knowledge of Data warehousing & data integration using SQL, ETL(Alteryx) along with Python. Solid Extensive experience on Business Intelligence ,Worked extensively in data consolidation. Excellent Team Player with ability to work Independently along with Strong analytical Skills.
Overview
7
7
years of professional experience
Work History
Lead Data Analyst and BA
Kraft Heinz
Ahmedabad
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 Analyst – Data Analytics | Data Engineer
Onesky Offshore Pvt.Ltd
Ahmedabad
10.2021 - 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 combination of Python and Matillion Snowflakes SNOWSQL that help the business to refresh the data 2 time faster then 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 help 5% in process improvement
- Developed Dashboards that displays 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
Ahmedabad
07.2017 - 08.2021
- Design, Develop, and maintain data base 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
BTech - Mechanical Engineering
Siddhartha Institute of Engineering and Technology
05.2017
Skills
- Tableau
- Power BI
- Snowflake
- Alteryx
- Data Visualization
- Machine Learning
- Matillion
- Python: Pandas, Numpy, Scikt-Leran, Matplotlib
- Agile
- Scrum
- Exploratory Data Analysis
Personal Information
Title: Senior Business Analyst
Timeline
Lead Data Analyst and BA
Kraft Heinz
08.2022 - Current
Business Analyst – Data Analytics | Data Engineer
Onesky Offshore Pvt.Ltd
10.2021 - 07.2022
Analyst – Data & Quality
Radiant and Radical Air System Pvt Ltd
07.2017 - 08.2021
BTech - Mechanical Engineering
Siddhartha Institute of Engineering and Technology