نبذة عني
Logical [Data analyst] collects, processes, and executes statistical analysis of data. Key team member who is responsible for possessing exceptional problem-solving skills combined with strong cross-functional understand…
Logical [Data analyst] collects, processes, and executes statistical analysis of data. Key team member who is responsible for possessing exceptional problem-solving skills combined with strong cross-functional understanding of business processes and information technology. Determined individual with drive to expand career.
الخبرة
Data Analyst
• Responsible for designing the SQL queries, procedures, functions, and triggers.
• Automated over 10 manual tasks with Python scripts, cutting down data analysis time by 75%. In addition, Utilized Python and SQL for data extraction, transformation, and loading (ETL) processes, ensuring data accuracy and reliability.
• Developed dynamic Power BI dashboards that allowed stakeholders to clearly visualize key performance indicators, aiding in data-driven decision-making and for real-time profitability tracking.
• Used SQL for data extraction from 12 interconnected tables within Mega Mart's customer sales databases, employing JOIN and VIEW operations.
• Leveraged aggregation and filtering functions to refine and streamline the data, enhancing the reporting process.
• Utilized SQL and power BI for data loading and visualization, uncovering crucial business insights to boost the sales performance of our client, HERITAGE FOODS LIMITED.
• Collaborated as a team member to remove duplicate records from the business database, achieving a 92% accuracy rate. Furthermore, assisted front-line teams in making 25% more data-driven decisions by providing up-to-date, pertinent insights across various projects.
• Built a data warehouse employing SQL Server and Excel to manage, structure, and scrutinize extensive data sets, achieving this milestone within three weeks of commencing the client's project (GT Holidays Private Limited).
• Boosted the value of analytical reports by improving data mining and segmentation methods for a client across various social media platforms.
• Followed agile methodologies and participated in weekly sprint progress and sprint delivery.
• Delivered consistent maintenance and bi-monthly development of bug fixes for both existing and new Power BI reports for clients over a period of two years.
• Analyzed 50GB of data to devise an optimal pricing strategy for 15 new products for our client, Prithvi Enterprises, uncovering opportunities that boosted annual revenue by $1.5 million.
Garden Center Associate (Part-time)
Engaged in customer interaction, plant maintenance, inventory organization, and product display.
Followed checklists and handled materials effectively.
Completed the assigned daily tasks and reported promptly to the supervisor.
Data analyst Intern
Responsible for designing the SQL queries, procedures, functions, and triggers.
Conducted research and tested relevant data to support project decision-making for locations and Vendors.
Delivered immediate insights across seven critical performance metrics, resulting in a 33% increase in revenue during the first month on the job.
Employed SQL, Power BI, and Excel for the analysis and processing of 20 terabytes of data, aiding in more than 100 plus business decisions.
Employed data mining, OLAP, and statistical analysis tools to identify 35 market trends.
Conducted statistical modeling, hypothesis testing, and A/B testing, providing robust data-driven recommendations that improved project outcomes.
Learned in utilizing, testing, supporting, and migrating databases across Microsoft SQL Server, Oracle, and MS Access platforms.
Data analyst
Automated over 10 manual tasks with Python scripts, cutting down data analysis time by 75%.
Utilized Python and SQL for data extraction, transformation, and loading (ETL) processes, ensuring data accuracy and reliability.
Developed dynamic Power BI dashboards that allowed stakeholders to clearly visualize key performance indicators, aiding in data-driven decision-making and for real-time profitability tracking.
Used SQL for data extraction from 12 interconnected tables within Mega Mart's customer sales databases, employing JOIN and VIEW operations.
Leveraged aggregation and filtering functions to refine and streamline the data, enhancing the reporting process.
Utilized SQL and power BI for data loading and visualization, uncovering crucial business insights to boost the sales performance of our client, HERITAGE FOODS LIMITED.
Collaborated as a team member to remove duplicate records from the business database, achieving a 92% accuracy rate.
Assisted front-line teams in making 25% more data-driven decisions by providing up-to-date, pertinent insights across various projects.
Built a data warehouse employing SQL Server and Excel to manage, structure, and scrutinize extensive data sets, achieving this milestone within three weeks of commencing the client's project (GT Holidays Private Limited).
Boosted the value of analytical reports by improving data mining and segmentation methods for a client across various social media platforms.
Followed agile methodologies and participated in weekly sprint progress and sprint delivery.
Delivered consistent maintenance and bi-monthly development of bug fixes for both existing and new Power BI reports for clients over a period of two years.
Analyzed 50GB of data to devise an optimal pricing strategy for 15 new products for our client, Prithvi Enterprises, uncovering opportunities that boosted annual revenue by $1.5 million.