PREM ASHISH
Hyderabad
Summary
- Experienced programmer with 7+ years of relevant experience in the field of IT with 4+ years' experience in Snowflake & Matillion along with 4+ years relevant experience in the dashboarding story using Power BI & Tableau with the main concentration on data analysis, data migration & visualization techniques using data-driven tools & techniques by working on various optimization techniques and help to deliver project requirements through excellent problem-solving capabilities.
- Strong knowledge of Data Warehousing & Data Integration using SQL, ETL(Matillion,Alteryx) along with Python
- Solid understanding of Data modelling and architecting skills including solid foundation in data warehousing concepts, data normalization, and dimensional data modelling using data vault design
Overview
8
8
years of professional experience
Work History
Lead Data Engineer
Kraft Heinz and Million Minds
Hyderabad
08.2022 - Current
- Determine operational objectives by studying business functions, gathering information, and evaluating output requirements and formats
- Designed and implemented ETL workflows using Matillion ETL for Amazon Redshift (or other cloud platforms like Snowflake, Google BigQuery) to efficiently extract, transform, and load data from various sources
- Designed and developed a data warehouse automation process that reduced manual effort by 80% and improved data processing speed by 50%
- Created and maintained ETL procedures using Matillion and Alteryx to transfer more than 1TB of data per day from source systems to Snowflake while guaranteeing data completeness and accuracy
- Created and implemented data models and data warehouses to facilitate analytics and business intelligence solutions, increasing data-driven decision-making by 20%
- Troubleshot and debugged data issues, reducing data-related incidents by 40% and improving overall data quality by 25%
- Migrated AWS Data(EC2) to Snowflake
- 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
- Collaborated with cross-functional teams (data analysts, business intelligence developers, system architects) to define and implement data requirements and ETL solutions
- Integrated APIs and third-party services to automate data flows from external systems such as CRM, ERP, and other cloud-based data sources
- 12% faster operational decision-making times were achieved by developing intricate SQL queries to draw insightful conclusions from huge datasets
- Configure, manage, and maintain the Matillion ETL platform
- Pioneered the adoption of Agile methodologies in the BI department, boosting productivity by 18% and accelerating report delivery by 40%
- Construct, create, and manage database objects in Snowflake, such as tables, views, functions, stored procedures, and scripts
- Leveraged Snowflake's data warehousing capabilities and Matillion's ETL processes to identify patterns, trends, and anomalies in network data, enabling accurate diagnosis and resolution of performance issues
Data Engineer
Anneal Pvt.Ltd
Ahmedabad
03.2022 - 07.2022
- Data mistakes were reduced by 95% and data quality was enhanced as a consequence of the implementation of data governance procedures to guarantee data accuracy and compliance
- Leveraged Matillion and Airflow to implement robust data transformation processes, supporting dimensional modelling for analytical use
- This framework improved data reliability and supported self-service analytics for business users
- Done Analysis On call Centre where Pandas and Numpy used to clean data, And Build Dashboard in Power Bi to Show KPI As a result, Our work recruiting accuracy has improved by 10% and have tracked efficiency
- Created Dashboards that display KPIS related to infection control and medication processes, improving the staff ability to monitor patients' progress by 90%
- Managed a Tableau project for a healthcare client, analyzing patient data to identify areas for improvement and reduce hospital readmission rates by 10%
- Designed and implemented ETL mappings, transformations, and workflows utilizing Matillion, Snowflake, and AWS
Analyst - Data & Quality
Radiant and Radical Air System Pvt Ltd
Hyderabad
07.2017 - 08.2021
- Created, develop, and manage SQL scripts, tables, views, functions, and stored procedures, among other database objects
- 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
- Improved data quality and reduced data mistakes by 15% as a result of implementing data governance procedures to guarantee data compliance and accuracy
- Created and maintained Tableau data sources and data extracts, improving data accuracy by 15% and reducing data processing time by 20%
- Created a sophisticated CTE stored procedure that reduced query execution time by 10% and increased system performance by 20%
- Monitor ETL jobs and troubleshoot issues related to data integration, data transformation, and data quality
Education
B.Tech - Mechanical Engineering
Siddhartha Institute of Engineering And Technology
05.2017
Skills
- Tableau
- Power BI
- Snowflake
- Alteryx
- Data Visualization
- MSSQL
- Azure Blob
- Statistical Analysis
- Matillion
- Python: Pandas
- Python: Numpy
- Python: Matplotlib
- Python: Seaborn
- Agile
- Exploratory Data Analysis
- AWS
Timeline
Lead Data Engineer
Kraft Heinz and Million Minds
08.2022 - Current
Data Engineer
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
Monica PrasannanMonica Prasannan
R&D Technologist at HEINZ WATTIE'S (KRAFT HEINZ)R&D Technologist at HEINZ WATTIE'S (KRAFT HEINZ)
Nurul Lutfia CandraNurul Lutfia Candra
System Implementation Specialist at The Kraft Heinz Company - PT. Heinz ABC IndonesiaSystem Implementation Specialist at The Kraft Heinz Company - PT. Heinz ABC Indonesia
Franklin BerryFranklin Berry
Machine Operator at Kraft HeinzMachine Operator at Kraft Heinz