
pranay dubey
DATA ANALYST ADVANCE EXCEL AND DATA ENTRY PROFESSIONAL
Competenze

Consulta i miei servizi


Portfolio
Esperienza lavorativa
Soft engg(data analyst)
Self Employed • Full time
Dec 2021 - Apr 2022 • 4 mos
management and analysis experience, I successfully handled diverse projects focusing on High-Speed Data Entry, Advanced Excel, and Google Sheets workflows.My primary responsibilities included managing accurate data entry operations, web research, copy-paste tasks, and converting messy PDF/Image files into clean Excel spreadsheets with 100% precision. I specialized in Data Formatting and Data Cleaning, ensuring thousands of rows of raw corporate data were properly organized, error-free, and professional.On the analytical side, I utilized Advanced Excel features to build interactive dashboards, apply logical formulas (like XLOOKUP, INDEX-MATCH), and summarize large datasets using Pivot Tables and Charts to present key metrics clearly. I also integrated baseline SQL database queries and Python (Pandas/NumPy) to streamline data manipulation and automate repetitive spreadsheet tasks.Through this hands-on experience, I mastered the art of maintaining absolute data accuracy under tight deadlines, optimizing spreadsheet efficiency, and helping clients turn raw information into well-structured, actionable business insights."