Data Analyst - Analytics Business Insights - NORWIN TECHNOLOGIES
(2024-12)
Data Analyst (3 years)
- Data Analysis and Visualization: Collected, analyzed, and visualized large datasets using Power BI, Python, and SQL to inform business decisions.
- Machine Learning Modeling: Developed and deployed machine learning models using Python and scikit-learn to predict customer behavior and improve business outcomes.
- Database Management: Designed, implemented, and maintained databases using SQL to store and manage large datasets.
- Statistical Modeling: Applied statistical techniques to identify trends, patterns, and correlations in data to inform business strategies.
- Insight Generation: Identified areas of improvement and provided data-driven insights to stakeholders to drive business growth.
SQL Data Analyst - TECHNOCOLABS
(2023-05 - 2024-11)
- Designed, implemented, and maintained Power BI dashboards to monitor key institutional metrics, such as enrollment rates, course completion, and faculty performance.
- Developed ETL Mappings using Postgres SQL to extract the data from unstructured data and transformed it to the Staging area, EDW and then to the Data Marts (OLAP DB) for approximately 10,000 record.
- Designed 167 SQL QA queries from source to target tables based on transformation rules and lookup tables comparing business and production data with efficiency of 99%.
- Analyzed dataset in MS Excel and collaborated with Automation, Finance, Accounting, and IT Operations to gather and prioritize their business requirements for IIT Madras Purchasing and Sales order system.
- Enhanced data visualization capabilities by designing and deploying interactive dashboards using Power BI, providing stakeholders with real-time insights into market trends, operational performance, and customer behaviour analytics.
- Proficient in applying Data Vault modeling methodology to maintain data integrity and achieve robust data modeling standards.
- Skilled in utilizing Docker for consistent deployment across various environments, enhancing
SQL Data Analyst – Client, IIT MADRAS - COGNITOVE PLATFORM SOLUTIONS
(2021-09 - 2023-04)
- Banking Data Analyst | Business Intelligence | Risk & Compliance Developed data-driven strategies that improved customer engagement by 25%, driving business growth in banking projects.
- Analyzed large financial datasets to identify trends, risks, and opportunities, providing actionable insights for enhanced decision-making.
- Designed predictive models for credit risk assessment, reducing loan default rates and improving lending efficiency.
- Optimized fraud detection using machine learning algorithms, minimizing fraudulent transactions and improving compliance measures.
- Implemented customer segmentation strategies, leading to a 15% increase in personalized marketing effectiveness and acquisition rates.
- Automated financial reporting and dashboards using SQL, Power BI, and Python, reducing manual work by 30%.
