Pranav Ranjan
@pranavranjan
Experienced data analyst focused on ETL, analytics, and interactive visualizations to drive decisions.
What I'm looking for
I am a data analyst with 7+ years of experience designing ETL processes, building data pipelines, and delivering interactive dashboards using Python, SQL, Tableau, and Power BI. I have a strong track record of diagnosing production issues, automating reporting, and improving data accuracy and operational efficiency across logistics and enterprise environments.
My background includes developing and optimizing SQL Server objects, creating analytic solutions in Tableau and Power BI, implementing Python automation, and supporting cloud-based data processing with Azure and Redshift. I prioritize clear documentation, agile delivery, and actionable insights that improve KPI visibility and support data-driven decision-making.
Experience
Work history, roles, and key accomplishments
Senior Analyst
UPS
Jan 2025 - Jul 2025 (6 months)
Designed and optimized SQL Server procedures and Power BI dashboards to improve operational visibility and data accuracy across GLS logistics, diagnosing production issues and delivering features within Agile release cycles.
Data Analyst
Vandoo LLC
Jul 2023 - Jan 2025 (1 year 6 months)
Executed ETL design and data warehouse logic using SQL Server and Hadoop, automated Python data workflows, and developed Tableau dashboards to improve data quality and operational efficiency.
Data Analyst
Volunteer, Jersey
Feb 2023 - Jul 2023 (5 months)
Collected and cleaned multi-source datasets, automated recurring SQL/Python reports reducing manual work 40%, and analyzed customer service metrics to improve response and resolution rates by 20%.
Published Power BI reports and developed DAX-driven dashboards and scorecards, automated financial reporting, and imported data from SQL/Azure DBs to support analytics and client investment research.
Education
Degrees, certifications, and relevant coursework
Pace University, Seidenberg School of Computer Science and Information Systems
Master of Science, Information Systems
Completed a Master of Science in Information Systems emphasizing data analytics, systems, and information management.
National Institute of Science and Technology
Bachelor of Technology, Electrical & Electronics Engineering
Completed a Bachelor of Technology in Electrical & Electronics Engineering with foundational training in engineering principles.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Job categories
Skills
Interested in hiring Pranav?
You can contact Pranav and 90k+ other talented remote workers on Himalayas.
Message PranavFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
