I'm a Data Analyst with a passion for turning raw data into meaningful insights and business solutions. I have hands-on experience with SQL, Python, ETL processes, and data visualization tools like Power BI and Tableau. I enjoy solving complex business problems, especially in domains such as retail, banking, and human resources.
I have worked on various projects, including:
- Property Data Extraction: Extracted, transformed, and loaded US property data (owner info, property value, taxes, etc.) from over 100 CSV and text files into SQL Server using an inhouse ETL tool. The data was used by mortgage companies to assess loan eligibility. Automated processes led to a 30% overall TAT reduction.
- Sales Performance Assessment: Analyzed a retail chain's sales performance to identify key improvement areas.
- Bank Loan Analysis: Developed SQL queries to evaluate loan default rates, improving risk management strategies for the bank.
- HR Analytics Project: Provided insights into employee turnover and retention, enabling better workforce planning.
Additionally, I have led a team of 25 employees, automated data processes, and streamlined workflows, saving time and improving accuracy across departments.
- Programming Languages: SQL, Python, R
- Data Visualization: Power BI, Tableau, Excel
- ETL Tools: SQL Server, Salesforce, Hive
- Data Analytics: Pandas, NumPy, Matplotlib, Seaborn
- Team Leadership: Led a cross-functional team to streamline processes, reducing turnaround time by 10%.
- Automation: Part of automation team that helped automated data extraction and transformation processes using ETL tools, reducing processing time by 30%.
- Training Programs: Designed and delivered training on ETL processes, SQL, and data visualization, improving team efficiency by 10%.
- Power BI Projects: Exploring advanced Power BI features to build interactive dashboards that help stakeholders make data-driven decisions.
- Python & R: Deepening my knowledge of Python for data manipulation and R for statistical analysis to enhance my data analytics capabilities.
- Advanced NumPy for efficient data manipulation
- R Programming for deeper statistical analysis
- Enhancing my skills in Power BI to create advanced visualizations
Feel free to explore my repositories and reach out if you'd like to collaborate on data-driven projects!