Vijay Kumar Nayak
Data Analyst
About
Results-driven Data Analyst with 10+ years of combined experience in data analytics, sales operations, and database administration. Proven expertise in building executive dashboards, conducting statistical analysis, and translating complex datasets into actionable business insights. Skilled in Power BI, Tableau, SQL, Python, and Snowflake with a track record of supporting data-driven decisions that generated $140,000+ in investment outcomes. Strong foundation in ETL processes, data modeling, query optimization, and KPI development.
Skills & Expertise (21)
Work Experience
Freelance Data Analyst & Operations Lead
Self-Employed
Apr 2014 - Sep 2025
Performed lead and investment analysis using Microsoft Excel for sales and investor-focused businesses. Built structured Excel models to track 500+ investor leads, deal stages, and conversion metrics. Used Pivot Tables, advanced formulas, and lookup functions to analyze lead performance and funding outcomes. Created Excel-based KPI reports to support investor discussions and executive decision-making. Cleaned, standardized, and validated raw lead data to ensure reporting accuracy. Automated recurring Excel reports, reducing manual effort and improving consistency. Delivered analytical insights that supported investment decisions contributing to $140,000 raised.
System & Network Administrator
Covalense Technologies Pvt Ltd
Oct 2013 - Nov 2014
Deployed and configured enterprise IT infrastructure including Oracle 11g (Database and Web Tier), ClearOS, Cyberoam firewall systems, and VPN networks. Managed Oracle HTTP Server deployments and web tier architecture ensuring high availability for business-critical applications. Maintained network security protocols and firewall configurations protecting enterprise data infrastructure from external threats.
Oracle Database Administrator
Covalense Technologies Pvt Ltd
Mar 2013 - Feb 2014
Installed, configured, and optimized Oracle 11gR1/R2 RAC environments and Siebel CRM systems on Linux platforms, ensuring 99.8% database uptime. Performed 50+ database ETL operations (import/export) using Oracle Data Pump and SQL*Loader, migrating multi-GB datasets with zero data loss. Optimized SQL query performance, reducing report generation time by 40% through indexing strategies, query refactoring, and execution plan analysis. Resolved critical patching and configuration issues with minimal downtime (avg. 15 minutes), maintaining SLA compliance for enterprise applications. Created database monitoring dashboards and automated alert systems to proactively identify performance bottlenecks and capacity planning needs.
Education
Bachelor of Technology (B.Tech) in Engineering in Computer Science Engineer - JNTU
2007 - 2011 · Afghanistan
Certifications
AI Fluency Framework and Foundation
Anthropic · 2026
Building with the Claude API
Anthropic · 2026
Data Analytics Essentials
Cisco Networking Academy · 2025
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Need Sponsorship
Relocation
Open to Relocation
Skills (21)
Click a skill to find developers with the same skill
