Associate Analyst with 2+ years in Data Analysis and Business Intelligence.
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
Results-driven Data Analyst with 2+ years of experience in analyzing complex datasets to deliver actionable business insights. Proficient in SQL (MySQL, PostgreSQL, Microsoft SQL Server) and Python (Pandas, NumPy, Matplotlib, Seaborn) for data extraction and analysis. Skilled in building interactive dashboards using Power BI and Tableau, along with advanced Excel (VBA, Power Query) for reporting and automation. Experienced in data cleaning, validation, data modeling, and ETL pipeline development to support efficient, data-driven decision-making. Strong understanding of business KPIs, data visualization best practices, and stakeholder communication to translate data into meaningful insights.
NK Orchid College of Engineering
Bachelor of Technology · Electrical Engineering
N/A – June 30, 2021
Zensar Technologies
Associate Analyst (Data Analysis & Reporting)
December 1, 2023 – Present
India
Financial Data Analysis
June 24, 2026 – Present
Designed and executed complex SQL queries across 8 interrelated tables (Client, Account, Transaction, Loan, Card, etc.) to extract actionable insights on banking operations, customer behaviour, and regional trends. Cleaned and transformed large volumes of raw banking data using SQL (e.g., date standardization, null handling, relationship mapping) to prepare datasets for analysis. Built Power BI dashboards and reports to visualize KPIs including customer demographics, loan distribution, account usage, card profitability, and district-wise performance. Developed year-over-year and month-over-month trend analyses for banking performance using DAX and Power BI Time Intelligence functions. Created SQL views and calculated columns to support dynamic Power BI reports for stakeholders. Segmented customer profiles using SQL-based filters and visualized them in Power BI to suggest tailored financial products and improve client targeting. Evaluated and visualized loan portfolio risk and repayment behaviour to assist in credit risk management decisions. Delivered strategic recommendations on reducing major operational expenses and improving profitability based on combined SQL analysis and dashboard findings.
Cultural Fit Analysis
The candidate's project diversity, particularly in financial data analysis, and their role as an Associate Analyst align well with the target role of Associate Technical Analyst. The breadth of skills across SQL, Power BI, Excel, and ETL demonstrates adaptability and a willingness to learn and apply various tools. Their experience in delivering strategic recommendations based on data insights suggests a proactive and results-oriented approach, which is a good cultural fit for a data-driven organization.
Soft Skills & Operational Fit
The candidate demonstrates strong analytical thinking, attention to detail, and problem-solving skills through their work in data discrepancy root cause analysis and data validation. Their experience in collaborating with cross-functional teams and coordinating with IT for data feeds indicates good communication and teamwork abilities, which are crucial for an Associate Technical Analyst role. The focus on improving data accuracy and efficiency aligns well with operational excellence.