Senior Data Analyst
ABIC Partners
Total years of experience :17 years, 8 Months
Utilized advanced data modeling techniques to transform datasets into interactive reports and dynamic dashboards.
Designed and implemented dynamic dashboards to effectively visualize patterns and trends within datasets.
Presented findings and insights to key stakeholders, including the CEO, COO, and CFO, to support informed decision-making.
Streamlined operations and reduced manual tasks by implementing automation processes using VBA, PQ, and Power Automate.
Managed commission payout calculations for a salesforce of 1500+ individuals by reconciling complex transactional data.
Conducted training sessions to educate associates on the effective use of Microsoft Excel and other Microsoft Office Suites.
In February 2023, I embarked on my freelance career, specializing in providing comprehensive solutions centered
around Microsoft Excel and Power BI. These solutions encompassed a wide array of tasks, including data collection,
cleansing, and transformation, as well as the execution of in-depth analysis and the creation of insightful reports and
dashboards. Through my services, I played a vital role in empowering stakeholders to make informed and strategic
decisions. As of now, I am proud to have successfully completed a total of 26 projects, consistently earning the trust
and satisfaction of my clients with a perfect 100% client satisfaction rate. Furthermore, my unwavering commitment to
excellence and swift project delivery led to the prestigious recognition of obtaining the "Top Rated" badge on Upwork,
setting me apart as one of the most efficient freelancers in this field.
30+ clients served | 100% Job Success Score | TOP RATED | ★★★★★
Excel Dashboard Designer| US | ★★★★★ | Apr 3, 2023 - Jul 17, 2023
"Excellent results! He was definitely informative and met all of our goals that we want to achieve. Will be using him again in
the future."
Excel template for trucking company | US | ★★★★★ | Jun 4, 2023 - Jun 7, 2023
"Ash did a great job. Very punctual and trustworthy. Took the time to explain everything needed to complete project. Will
definitely use him again for future projects."
Excel Pro for Google Adwords | US | ★★★★★ | May 8, 2023 - May 9, 2023
"Great provider. Fast and communicative!"
Excel Pro needed | US | ★★★★★ | May 4, 2023 - May 5, 2023
Excel organize | US | ★★★★★ | Apr 26, 2023 - May 2, 2023
"Always goes above and beyond will hire again soon"
Online assignment | Algeria | ★★★★★ | Apr 6, 2023 - May 1, 2023
"Ash provides promote responses and he always met the deadlines. Very helpful and collaborative at delivering the task."
Excel VBA Repair | US | ★★★★★ | Apr 29, 2023
"I will definitely hire Ash again. He's the best"
Spreadsheet Data Expert Needed | US | ★★★★★ | Apr 13, 2023 - Apr 27, 2023
Excel Macro Writer Needed For A Small Excel Job | US | ★★★★★ | Mar 15, 2023 - Apr 24, 2023
EDUCATION AND TRAINING
LANGUAGE SKILLS
ADDITIONAL INFORMATION
FREELANCING EXPERIENCE
"He did a very good job"
Power BI Developer | US | ★★★★★ | Apr 20, 2023 - Apr 24, 2023
VBA Macro for Data Clean Up | US | ★★★★★ | Apr 17, 2023 - Apr 23, 2023
Link https://www.upwork.com/freelancers/syedashrafc
Spearheaded the development and maintenance of precise Management Information System (MIS) reports for the service line.
Collaborated closely with both management and clients to identify and prioritize critical business and information needs.
Customized and tailored dashboards to align with specific client requirements.
Transformed extensive data sets into actionable insights, facilitating effective decision-making processes.
Addressed and prioritized ad-hoc report requests, ensuring timely delivery of accurate and relevant information.
Implemented automation techniques, such as VBA and functions, to streamline processes and minimize manual workload.
Conducted basic statistical analysis on survey data, created visually appealing dashboards and infographics, and delivered professional presentations to diverse audiences, utilizing data-driven insights for decision-making support.
Managed the end-to-end process of data coding, including overseeing staff recruitment, conducting comprehensive training sessions, and maintaining accuracy and consistency in data interpretation.
Developed and designed professional presentations for directors, streamlining processes and improving productivity.
Actively engaged with clients, working closely on project management and maintaining a hands-on approach to ensure client satisfaction.
Maintained accurate records by inputting information into computer databases and implemented automation processes using VBA to enhance efficiency and reduce manual intervention.
Implemented standardized coding processes, conducted staff recruitment, and provided comprehensive training to enhance coding skills, ensuring consistency, accuracy, and proficiency.
Arranged monthly training sessions, maintained communication with senior managers, and updated them on progress, issues, and quality control measures for delivering 100% clean data.
Managed records, prepared bills, and maintained ledgers in the Coding Department, conducted briefing sessions for coding projects.
Translated verbatim responses, promptly delivering them to relevant departments and clients, while generating comprehensive reports on various time intervals.
Assisted managers in departmental activities, designed and developed Microsoft Excel templates to streamline processes and enhance efficiency, automating tasks with VBA for reduced manual intervention and increased productivity.
Conducted coding of market research questionnaires, ensuring accurate and consistent data entry.
Performed translation of verbatim responses from the native language (Urdu) to English.
AWARDS & ACHIEVEMENTS Oct, 2022 Summa cum Laude Dec. 2018 Dean’s Honour Certificate for outstanding academic achievement. Nov 2011 Entry scholarship for undergraduate degree based on academic excellence.
Three years Diploma of Associate Engineer in Electronic Technology.