AMAN AHMED-| LinkedIn : Aman Ahmed | -
EDUCATION
EXPERIENCE
LOVELY PROFESSIONAL UNI.
DATACULT | Jr. BI and Associate Product Engineer
B.tech (CSE) (Hons.)
June 2023 - August 2024 | Bangalore , Karnatka
• Analyzed a client project brief to understand the core business problem,
identified the requirements to be delivered, and prioritized tasks as a data
analyst and work on Excel for report Generation.
• Identified the necessary datasets to address the client’s business questions,
then performed data cleaning and merging using Redshift SQL to ensure
accurate analysis.
• Provide support for data-related issues, troubleshoot problems, and ensure
data availability and reliability.
2018 – 2022 | Punjab, India
HIGHER SECONDARY(12TH)
Yaadav Bharti School
2018 | Bikaner, India
SECONDARY SCHOOL(10TH)
Bikaner Boys school
2016 | Bikaner, India
INCUBYTE | Jr. Analyst
Nov 2022 – June 2023 | Ahemdabad , Gujarat
SKILLS
• POWERBI
• SQL
• Created SSIS packages and executed them and configured them for daily.
• Collaborated with cross-functional teams to develop and optimize Azure
Functions and improving process accuracy for client deliverables
• Optimized the sql query based on query plans.
• EXCEL
PROJECTS
• HIVE
CHOCOLATE SALES ANALYSIS (Link)
• AWS QUICKSIGHT
• JIRA
• VISIO
LANGUAGES
• English
• Hindi
• French
CERTIFICATION
• PowerBI (Link)
• ToolsUsed: SQL, PowerBI,Excel
• Created analysis reports such as SalesAnalysis,ProfitAnalysis,
GrowthAnalysis,and TimeSeriesAnalysis using PowerBI
• Created a welcome page in which one can redirect to the
whatever analysis reports are required using the buttons cenario.
SALES INSIGHTS (Link)
• Tools Used : Sql , Powerbi
• Designed a Power BI dashboard to understand AtliQ hardware
goods sales trend.
• Final Dashboard was effective at displaying the sales trend of
AltiQ hardware,allowing users to understand the data and make
informed decision.
• This dashboard help in increasing the sales at least by 7 percent
SCD IMPLEMENTATION IN DATA WAREHOUSING (Link)
INTERESTS
• Badminton
• Cooking
• Cardistory
• Documentry
• Tools Used : MySQL,Hadoop,hive,Unix
• Created a Sqoop Job to send data from mysql HDFS (Hadoop File
system)
• Created External Table in Hive and then transferred data from
HDFS to hive table.
• Implemented SCD-01 logic to get the updated data
• Exported SCD-01 data to MySQL Master Table.
