Open to opportunities

vivek pola

@vivekpola

Message

Data Analyst skilled in SQL, Python, Excel, and Power BI—turning data into decisions.

Zimbabwe

Message

What I'm looking for

I’m looking to collaborate on meaningful analytics in fast-paced environments, using SQL, Python, Excel, and Power BI to clean data, derive insights, and support data-driven decisions.

I’m a Data Analyst with a strong foundation in SQL, Python, Excel, and Power BI, focused on cleaning, analyzing, and visualizing data to generate insights and support data-driven decision-making. In my SQL capstone, I analyzed Amazon branch sales across Mandalay, Yangon, and Naypyitaw—building and optimizing a relational database (1,000+ transactions, 17 attributes), feature-engineering time fields, and writing complex queries for revenue analysis, VAT optimization, product-line profitability, and customer segmentation.

I also developed a Python-based OTP Verification System using secure 6-digit OTP generation and validation, with email-based two-factor authentication via Gmail’s SMTP server and SSL encryption. I bring strong analytical and problem-solving skills, learn new technologies quickly, and enjoy collaborating on meaningful analytical work in fast-paced environments.

Experience

Work history, roles, and key accomplishments

OTP Verification System (Python)

OTP Verification System

Mar 2025 - Apr 2025 (1 month)

Developed a Python-based OTP verification system that generates secure 6-digit OTPs and validates user input for authentication using email-based two-factor authentication. Implemented random OTP generation, Gmail SMTP delivery with SSL encryption, and robust retry logic with error handling.

Python Authentication SMTP SSL Error Handling

SQL Data Analysis Capstone

Amazon Sales

Jan 2025 - Feb 2025 (1 month)

Analyzed Amazon branch sales data with SQL to uncover product performance, customer behavior, and sales trends across Mandalay, Yangon, and Naypyitaw. Built and optimized a relational dataset (1,000+ transactions, 17 attributes) with feature-engineered fields and wrote complex queries for revenue, VAT optimization, profitability, and customer segmentation.

SQL Relational Databases Data Cleaning Feature Engineering Revenue Analysis VAT Optimization Customer Segmentation

Education

Degrees, certifications, and relevant coursework

Aurora Pg College, Hyderabad

Master of Computer Applications, Computer Applications

Completed an MCA (Master of Computer Applications) degree at Aurora PG College in Hyderabad to build advanced skills in computer application development and data-oriented problem solving.

Bankatlal Badruka College Of Information Technology

Bachelor of Science in Computer Science, Computer Science

Completed a Bachelor of Science in Computer Science at Bankatlal Badruka College of Information Technology, building a foundation for programming and data analysis work.