Data Analyst

Medusa Distribution LLC

1. Spearheaded the development of ETL Pipelines utilizing Python and SQL to amalgamate and extract data from diverse sources, catering to the Business Intelligence needs of the organization.
2. Orchestrated the seamless migration of the Datawarehouse from Microsoft SQL Server Databases to AWS Redshift on the Cloud.
3. Conceptualized and executed Key Performance Indicators (KPIs) and Metrics, crafting Tableau Dashboards to address the requirements of Stakeholders and Executive teams in Sales and Operations.
4. Collaborated with Operations Teams to create Inventory management reports, facilitating real-time stock tracking and informed inventory ordering decisions, resulting in a noteworthy 56% increase in inventory turnover.
5. Formulated ad hoc reports and dashboards for sales executives, enabling the monitoring of sales reps’ performance, tracking conversion rates, and allocating commissions judiciously.
6. Developed a Customer Segmentation Model through RFM Analysis, incorporating metrics like CLTV to pinpoint and retain the Most Valuable Customers, effectively mitigating churn risks.
7. Pioneered the creation of Dashboards including Customer Churn Analysis, Product Analytics, Warehouse Management, and Supplier Analytics, utilizing Tableau and Metabase.
8. Ensured data accuracy, consistency, and completeness by implementing regular data quality checks and cleansing processes within Amazon Redshift Databases.

Power BI Developer

Data Crypt

1. Developed and maintained interactive dashboards and reports using Power BI for various multinational clients, including Azadeau, a famous retail chain.
2. Extracted data from Type forms, transformed it, and performed exploratory data analysis in Excel before loading it into Power BI.
3. Created parametrized daily automated reports using R programming to ensure timely delivery of insights to clients.
4. Collaborated with cross-functional teams to understand business requirements and develop solutions to solve business problems.
5. Conducted data analysis and provided insights to the management team to inform decision-making processes.
6. Worked with SQL databases to retrieve and manipulate data for reporting purposes.
7. Maintained data integrity and ensured the accuracy of reports and dashboards.

University of the Punjab

Spatial Data Analytics, Image Processing , Geospatial Statistics