Diligent professional looking for reputed firm to work with, currently working as MIS assistant, having vast experience in different pr ominent sectors, with advanced Excel skills, consistently delivering impactful results. Motivated by a strong commitment to excellence, I bring a proven track record of success across various roles. Skilled in leveraging data-driven insights to drive efficiency and achieve business objectives. Adept at adapting to diverse environments, I am poised to contribute valuable expertise to any team or project.
Collection and analysis of data for SFERP and SPHF projects.
With the help of Xlookup, Hlookup and Pivot table, Develop regular reports for senior management.
Cleaning GRM data for the accuracy of data, with the help of Textjoin combines text for multiple ranges, Remove Duplicates, Filter.
Develop dashboards for timely data access using advanced Excel features such as Index-Match, Sorting, Offset with Counta, advanced formulas and Pivot tables.
Generation of daily reports, and extraction of data from the MIS portal using MS Word.
Use Power Query to automate data cleaning, transform data, and ensure accurate reporting.
Design, implement, and maintain comprehensive MIS systems to support project objectives.
Preparing PPRP project daily basis entries and CIF reports
Develop procedures and protocols for data collection and analysis and ensure proper security measures for handling sensitive information of BNF.
I had an opportunity to work on real-world project called Food-Hunter App and apply my analytical skills to solve problems and make data driven decisions.
Utilized SQL, advanced Excel for data processing and analysis, successfully deploying a quality project for clients, focusing on efficiency and accuracy in data handling.
Leveraged advanced SQL features such as window functions, Common Table Expressions (CTEs), data grouping, and string functions, trim, replace to clean, process, and analyze dataset.
Conducted detailed analysis to uncover customer behavior patterns and trends, providing actionable insights to address performance issues.
Employed Advanced Excel functions XLOOKUP, Pivot Tables for in-depth data analysis and report creation, reducing manual work by 2 hours and increasing workflow efficiency.
Developed visually compelling reports and dashboards using Power BI, effectively communicating findings.
Customer dealing, Understood problems to provide the best solution, Achieved sales target.
Interacted with concerened and other departments to facilitate problem resolution. Analyzed client data & sales trends.
Identified opportunities for the room of improvement. Supervised outbound team to ensure they followed computer-generated lead order.
Also exhibited courtesy at all times. Completed all the paperwork & documentation before deadlines.