s
subrato7331

Subrato Samadda

@subrato7331

I will create dynamic Excel dashboards, formulas, and PDF to Excel conversion

India
Inglés, Hindi, Bengalí
Parte de la información aparece en idioma inglés.
Sobre mí
Hi! I’m a professional Data Analyst and Advanced Excel Expert dedicated to turning complex data into clear, actionable insights. I specialize in accurate data cleaning, PDF to Excel conversion, dynamic visualization, interactive Excel dashboards, and VBA/macro automation to streamline your workflow and save you hours of manual labor. Whether you need robust financial modeling, custom Excel formulas, or efficient data transformations, I deliver secure and user-friendly solutions tailored to your business. Let’s transform your data into a powerful asset—message me today to get started!... Lee más

Habilidades

s
subrato7331
Subrato Samadda
desconectado • 

Revisa mis servicios

Limpieza de datos
I will do excel spreadsheet formatting,excel report formatting
DeUSD 15 / proyectoMás información

Porfolio

Experiencia laboral

New_Beginnings

MIS Executive

New Beginnings • Tiempo completo

Apr 2017 - Nov 2024 • 7 yrs 7 mos

**Achievements as MIS Executive – MyTasker** * Managed and maintained large volumes of business data using Microsoft Excel, ensuring high levels of accuracy and data integrity. * Developed and automated MIS reports to support daily, weekly, and monthly business operations, reducing manual effort and improving reporting efficiency. * Created interactive dashboards using Pivot Tables, Pivot Charts, slicers, formulas, and conditional formatting to provide actionable business insights. * Cleaned, validated, and standardized raw datasets by removing duplicates, correcting inconsistencies, and resolving data quality issues before reporting. * Utilized advanced Excel functions such as XLOOKUP, VLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, TEXT, and DATE functions to streamline data analysis. * Consolidated data from multiple sources using Power Query, enabling faster report generation and improved decision-making. * Generated performance reports, KPI summaries, and management dashboards that helped stakeholders monitor business performance effectively. * Performed regular data audits and reconciliations to ensure report accuracy and compliance with organizational standards. * Collaborated with cross-functional teams to understand reporting requirements and deliver customized MIS solutions within agreed timelines. * Improved spreadsheet usability through professional formatting, structured layouts, data validation, and error-checking techniques. * Reduced report preparation time by implementing reusable Excel templates and automated workflows. * Demonstrated strong analytical, problem-solving, and time-management skills while handling multiple reporting tasks in a fast-paced virtual work environment. **Key Skills:** Advanced Excel, Pivot Tables, Pivot Charts, Power Query, Data Cleaning, Data Validation, Dashboard Creation, Report Automation, Data Analysis, MIS Reporting, Data Formatting, Business Reporting, KPI Tracking, Excel Formulas, Microsoft Office.