Candidate

------------------------------
First Name: Devansh
E-Mail Address: devansh6159@gmail.com
Country: United Kingdom
Phone: 7442093118
Current Job Designation: Data Business Analyst
Job Designation Applying For: Analyst
Total Years of Experience: 3
Copy your Resume / CV in this box: DEVANSH VERMA

http://linkedin.com/in/devansh1210 | London, UK | dev1210verma@gmail.com | +447442093118
Summary
Results-driven Data Analyst with 3+ years of experience translating business requirements into actionable insights using Agile and Waterfall methodologies. Proficient in R and Python (NumPy, Pandas, Matplotlib) for data analysis, forecasting, and automation. Skilled in designing interactive dashboards and reports using Tableau, Power BI, and Excel. Experienced in database management (MySQL, PostgreSQL, AWS) to optimize data processing and reporting. Strong expertise in business documentation, stakeholder communication, and problem-solving, supporting Business Intelligence, Product, Risk, and Market Analysis to drive data-driven strategies and operational efficiency.
Skills

• Programming & Query Languages: SQL, MySQL, PostgreSQL, Python (NumPy, Pandas, Matplotlib), R
• Data Analysis & Processing: Data Cleaning, Data Wrangling, Statistical Analysis, Forecasting Techniques, Predictive Modeling
• Business Intelligence & Visualization: Tableau, Power BI,
Microsoft Excel (Pivot Tables, VLOOKUP, VBA) Database Management & ETL: Snowflake, AWS RDS, Data Warehousing, Data Integration, ETL Pipelines
• Cloud & Big Data Technologies: AWS (EC2, S3, Lambda,
DynamoDB), Azure Data Factory, Hadoop, Spark
Experience
Data and Business Analyst OneCard

• Tracking & Project Management: Jira, Microsoft Visio, CRM, Figma, JAD, RTM, UAT
• Machine Learning & Advanced Analytics: Scikit-learn, Regression Analysis, Keras, Forecasting Models
• Development & Version Control: Git, GitHub, Jupyter Notebook
• Methodologies: Agile, Waterfall, Business Process Mapping, SDLC, Requirement Traceability Matrices (RTM)
• Soft Skills: Stakeholder Communication, Problem - Solving, Documentation, Time Management, Decision - Making.

10/2023 to Current Remote, India

• Conducted data collection, cleaning, wrangling, and exploratory analysis using Python, enhancing dataset usability for business insights.
• Automated manual data processing tasks by implementing Excel macros and VBA, improving productivity and reducing errors.
• Utilized SAS for statistical modelling, predictive analytics, and trend analysis to support data-driven business decisions.
• Optimized workforce planning through SQL-based data analysis, improving resource allocation and reducing recruitment costs by
$1.2M.
• Aggregated and analyzed data from multiple sources, including HR databases and internal tools, using SQL and Python to identify trends in project demand, employee skills, and utilization rates.
• Developed predictive models using linear regression to forecast workforce needs, reducing time-to-hire for key roles from 60 to 45 days.

Agile Experience Program – Internship
JP Morgan Chase & Co.

08/2023 to 09/2023
London, UK

• Partnered with cross-functional teams to streamline Agile workflows, ensuring alignment between development, business, and operational goals.
• Assisted in refining user stories, backlog prioritization, and sprint planning to enhance Agile delivery efficiency.
• Provided end-user support for CRM platforms, troubleshooting system issues, and ensuring data integrity.
• Designed and developed Power BI dashboards to visualize key performance indicators, enabling real-time, data-driven decision- making.
• Automated repetitive reporting tasks using Python, reducing manual workload, and improving data accuracy.
• Conducted root cause analysis on system inefficiencies, implementing process improvements to enhance overall productivity.
• Engaged with stakeholders to gather requirements, ensuring product enhancements met business needs and user expectations.

MSc. Business Analysis Graduate Researcher Queen Mary, University of London

09/2022 to 08/2023
London, UK

• Developed a Credit Card Default Prediction System using machine learning, enhancing risk assessment accuracy to 82% through advanced modelling techniques.
• Performed a multi-regional comparative analysis of CO₂ emissions, utilizing data visualization tools to generate actionable insights for stakeholders.

Junior Analyst Sunevan

07/2020 to 03/2021

• Developed and automated daily financial data reporting solutions, enhancing liquidity monitoring, risk management, and data-driven decision-making.
• Collected, integrated, and analyzed large-scale datasets using SQL and Python (Pandas, NumPy) to ensure data accuracy, consistency, and efficiency.
• Conducted root-cause analysis and optimized datasets for predictive modeling through advanced transformation techniques and feature engineering.
• Automated financial data analysis using Python scripts, reducing manual effort by 40% and decreasing ad hoc reporting requests by 50%.
• Designed and implemented ETL workflows using Informatica to extract, transform, and load data from multiple sources into centralized databases, improving data accessibility.
• Utilized SAP Business Warehouse (BW) for large-scale data management and efficient ETL processing.
• Performed exploratory data analysis (EDA) using SQL and Python to identify key trends and patterns, improving the accuracy of financial risk assessments
Education
Master's in Business Analysis, 2024
Queen Mary University of London, UK
Bachelor's in Electronics and Communication, 2022
LNCT Group of Colleges, Bhopal, India


------------------------------