Analytics Engineer with less than a year in data pipelines, SQL, Python, and Power BI
AI is analyzing your overall score…
Identifying your key strengths…
Evaluating your skill match against the job requirements…
Assessing your cultural and operational fit
A Data Analyst / Analytics Engineer seeking a position to leverage a solid engineering background. Possesses expertise in creating robust data pipelines, consolidating data from various sources, and designing impactful executive Power BI dashboards. Proficient in a wide array of tools and technologies for data analysis, programming, databases, and visualization.
Dr. B. C. Roy Engineering College
B.Tech · Applied Electronics and Instrumentation Engineering
August 1, 2019 – June 30, 2023
Pailan Technical Campus
Diploma · Electronics and Instrumentation Engineering
August 1, 2015 – June 30, 2018
Silver Jubilee High School
Secondary Education
June 1, 2013 – May 31, 2014
SBI Loan Risk Prediction
January 1, 2023 – June 1, 2026
Processed 7,000+ loan records using SQL and Excel; identified key risk drivers (credit score, income, DTI ratio) through aggregations and conditional analysis. Built Tableau KPI reports visualizing loan approval rates, default trends, and risk band distributions for banking stakeholders.
View ProjectFull-Stack Financial Intelligence & Analytics Platform
January 1, 2023 – June 1, 2026
Architected and deployed a decoupled, end-to-end analytical pipeline tracking 12 years of historical financial data for Nifty 100 enterprises across relational cloud storage, secure APIs, and interactive dashboards. Engineered an asynchronous computational pipeline using Celery and serverless Upstash Redis to isolate resource-heavy data-scoring tasks from the main thread, maintaining continuous web server availability. Developed a high-performance REST API using Django REST Framework (DRF) with unified database schemas, full OpenAPI/Swagger documentation, and clean endpoints hosted live in production on Render. Designed a 5-page enterprise dashboard suite in Power BI using advanced DAX logic, delivering comprehensive multi-dimensional snapshots of corporate health, profitability curves, leverage risk quadrants, and real-time operational cash engine trends. Implemented custom single-company drill-down logic ("Tear Sheet") providing instant, one-click evaluation of a company's full 12-year historical capital structure and financial margins.
View ProjectCyber Attack Analysis System
January 1, 2023 – June 1, 2026
Built Python (Pandas, Matplotlib) tool to process large-scale cybersecurity logs; automated severity distribution calculations across DDoS, Malware, and Intrusion events. Developed an interactive menu-driven terminal interface for dynamic dataset exploration; exported processed insights to CSV for reporting.
View ProjectGeographical Data-as-a-Service (GDAAS) Platform
January 1, 2023 – June 1, 2026
Developed a cloud-native SaaS REST API serving 457,000+ normalized village records across a 4-tier Indian administrative hierarchy (State > District > Block > Village). Engineered an end-to-end ETL pipeline in Python (Pandas) to merge 29+ state-level datasets into a single optimized PostgreSQL database. Implemented secure B2B infrastructure with API Key authentication, CORS middleware, and real-time usage analytics to monitor search trends and system load. Deployed an Admin Dashboard (Chart.js) and B2B Portal on Render, achieving sub-100ms response times for high-volume requests.
View ProjectGlobal Cybersecurity Threat Analysis (2015-2024)
January 1, 2023 – June 1, 2026
Cleaned multi-year breach data in Excel and built an interactive Tableau dashboard tracking threat trends, attack types, and severity levels across regions. Enabled stakeholders to identify peak breach periods and prioritize cybersecurity resource allocation through data-driven visual insights.
View ProjectJob Salary Prediction & Analysis
January 1, 2023 – June 1, 2026
Analyzed job salary data using Python (Pandas) and Google BigQuery SQL; identified key patterns - salary growth with experience and highest pay in Data and AI roles. Generated automated Excel reports with salary trend visualizations to support career planning and talent acquisition decisions.
View ProjectGoogle Data Analytics Professional Certificate
Coursera
January 1, 2025 – Present
Cultural Fit Analysis
The candidate's projects demonstrate a strong alignment with the 'Analytics Engineer' target role, showcasing diverse applications of data engineering and analytics skills across finance, cybersecurity, and geographical data. The breadth of technologies used (Python, SQL, Power BI, Tableau, Django, FastAPI, PostgreSQL, BigQuery, Celery, Redis) indicates adaptability and a willingness to learn new tools. However, the lack of explicit team collaboration or leadership experience in the project descriptions makes it difficult to assess cultural fit beyond technical contributions.
Soft Skills & Operational Fit
The candidate's project descriptions indicate a strong problem-solving aptitude and a structured approach to system design and data analysis. The focus on end-to-end solutions, from data ingestion to dashboarding, suggests good operational fit for roles requiring full lifecycle data engineering and analytics. The detailed project descriptions also imply good written communication skills for technical documentation.