Ashish Pareek
Open to work2 years experienceData Analyst
Data Analyst & Power BI Developer
Standing Rank
Rank Not Available
Developer Badges
Skills & Technologies
16 skillsGitHub Activity Evidence
GitHub Footprint Not Connected
Recruiters value verified code contributions. Linking a GitHub account displays live heatmaps, active contribution metrics, repository languages, and push activity tags.
Work Experience
Data Analyst · BI & Dashboard Engineering
Cotmac Electronics Pvt. Ltd.
- Rebuilt end-to-end reporting pipeline (SQL, Python, AWS S3/Athena), collapsing report generation from 2 days to 15 minutes — recovering 10+ engineering hours/week with zero manual steps.
- Engineered executive Power BI dashboards (DAX, Power Query, RLS) tracking downtime, throughput, and efficiency KPIs — directly drove a 30– 40% reduction in operational downtime within 3 months of deployment.
- Deployed a real-time 24h rolling KPI alert system with threshold-based anomaly detection, replacing manual shift reviews with proactive intervention before issues escalate.
- Automated weekly MIS reporting via Power Query and Advanced Excel — 90% cut in manual effort across 100K+ records; enforced full data governance: schema contracts, RLS, UAT validation before every release.
Quality Analyst (Contract)
DesignBoxed
- Validated 350+ operational records weekly at 98% accuracy; built exception-flagging pipelines in Advanced Excel that eliminated compliance errors and enforced data integrity before management-level reporting.
Projects
InsightGen AI — Autonomous Business Analyst Agent
- Built an AI agent that ingests CSV/S3 data → computes KPIs (MoM growth, churn, NPA%) in DuckDB → retrieves context via RAG → generates a full strategic memo with prescriptive actions and ROI estimates.
- Achieved 90% faster data-to-decision vs manual analyst workflow; 'Show Your Work' button exposes every SQL query for full auditability — zero black-box outputs.
Loan Risk Intelligence — Credit Risk Dashboard
- Cleaned 50K+ loan records using SQL window functions; embedded a Random Forest risk scorer into a Power BI star schema with NPA%, recovery rates, drill-through profiles, and a live what-if credit-threshold parameter.
- Finding: bottom 20% credit tier drives 62% of NPAs — enables live underwriting policy simulation for risk and credit teams.
FinSight 360 — Cloud-Native Loan Portfolio Analytics
- Built a serverless AWS pipeline (S3 → Glue → dbt → Athena → QuickSight) with modular, version-controlled dbt models; found top 20% risk borrowers drove 62% of NPAs — projected 15–18% credit loss reduction.
E-ComPulse Pro — Predictive Funnel Analyser & Budget Optimiser
- 3-layer engine on 100K+ Olist orders: SQL cohort analysis (15% payment drop-off) → Prophet conversion forecasting → PuLP linear programming for optimal $10K channel budget allocation.
Leaderboard Standings
Leaderboard Position Pending
Global test scores, peer standing percentiles, and algorithm leaderboard ranks are updated dynamically.
Assessment Highlights
Assessments Not Completed
Coding evaluations, system assessment results, and conceptual score badges will appear here after taking a test.
AI Collaboration Score
AI Collaboration Score Pending
Developer coding behavior, assistant cooperation, and AI pair-programming indicators are evaluated during live coding sessions.
Role Compatibility Profile
Role Compatibility Analysis Pending
Custom matching reports, candidate role compatibility percentiles, and core engineer strength profiles are processed once conceptual code screenings are complete.
Achievements
Achievements Not Earned
Special rewards, developer badges, system recognition certificates, and conceptual milestones will display here.
About Details
Professional Bio
Data Analyst with 1.5+ years delivering measurable BI and pipeline impact. Rebuilt reporting stacks, automated business reporting, and engineered executive Power BI dashboards that reduced production downtime and manual effort.
Master of Computer Applications (MCA)
Bharati Vidyapeeth Deemed University, Pune (2022 - 2024)
Bachelor of Computer Science (B.Sc. CS)
Smt. Kasturbai Walchand College, Sangli (2019 - 2022)