Rohan Singh Dhek

Experienced Data Analyst with payments + SQL + Python expertise

Pilibhit $5/hr Hybrid Full-time 9+ yrs exp 100 · Outstanding

About

I am a Data Analyst with 8 years of professional experience in reporting, business operations, and data analysis. Throughout my career, I have worked extensively with Excel, dashboards, and business reporting, helping stakeholders make informed decisions through data-driven insights. Over the past year, I have expanded my technical expertise by learning SQL, Power BI, Python, and Google Analytics. I have built interactive dashboards, completed hands-on analytics projects, and earned the Google Analytics Professional Certificate to strengthen my analytical capabilities. I enjoy solving business problems using data, identifying trends, automating reports, and creating dashboards that simplify complex information. I am a quick learner, adaptable to new technologies, and enjoy collaborating with cross-functional teams. At this stage of my career, I am looking for an opportunity where I can leverage my experience while continuing to grow as a Data Analyst by working on challenging analytics projects and contributing to data-driven business decisions.

Skills & Expertise (29)

Data Analysis Advanced

8.5/10

Years Exp

SQL Advanced

8.4/10

Years Exp

Excel Advanced

8.2/10

Years Exp

Python Advanced

8.1/10

Years Exp

Pandas Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Tableau Advanced

8.0/10

Years Exp

NumPy Advanced

7.8/10

Years Exp

Power BI Advanced

7.5/10

Years Exp

Client Communication Advanced

7.0/10

Years Exp

Stakeholder Management Advanced

7.0/10

Years Exp

MS Access Jupyter Notebook Joins MIS Reporting Reporting Automation Data Validation Subqueries GET Google Sheets Window Functions MySql Macros XLOOKUP VLOOKUP Power Query Pivot Tables CTEs Dashboard Development

Work Experience

Senior Data Analyst – Payments & CRM Analytics

Virtual Employee Pvt. Ltd.

May 2017 - Present

Managed end-to-end CRM data accuracy and reporting operations for banking and payment clients, consistently maintaining 99.9% data accuracy across high-volume transactional datasets. Designed and automated compliance, residual, reconciliation, and MIS reports using Excel, SQL, and reporting tools, improving reporting efficiency and operational visibility. Developed SQL queries (joins, filters, validations, subqueries) to extract, validate, and analyze transactional and CRM data for reporting and audit support. Built Tableau dashboards and reporting views for senior management, enabling faster business decision-making and improved operational monitoring. Automated recurring reporting workflows and Excel-based processes, reducing manual effort by 30% and improving turnaround time by up to 30%. Integrated and onboarded new applications and external data sources into CRM systems, improving workflow efficiency and reporting reliability. Managed payment gateway reconciliation and transaction monitoring across multiple platforms including NMA, GET, Humboldt, Signature, Global One Pay, and PayFac. Collaborated directly with banking partners and internal stakeholders as SPOC for issue resolution, reporting support, and compliance coordination.

Jr. Executive – Chat Support

Agusag Technologies Pvt. Ltd.

Sep 2016 - May 2017

Monitored website activity and optimized chat scripts, increasing customer engagement by 10%. Maintained 100% product data accuracy, ensuring reliable information delivery. Provided real-time customer support to 50+ customers daily, achieving high customer satisfaction.