Business Intelligence Analyst

Puneet Ramini Business Intelligence Analyst

*************@*****.*** 857-***-**** USA LinkedIn Summary

Analytical and results-driven Data Analyst with 3+ years of strong expertise in data extraction, cleaning, and visualization. Skilled in using SQL, Python, R, Excel, and Tableau to deliver actionable insights and support data-driven decision-making. Adept at building dashboards, performing statistical analysis, and collaborating with cross-functional teams. Experienced in Agile environments with a focus on improving business efficiency, reporting accuracy, and stakeholder communication through data-centric solutions. Technical Skills

● Data Analysis & Programming: SQL, Python, R, VBA, Advanced Excel (VLOOKUP, PivotTables, Power Query, Macros)

● Business Intelligence & Visualization: Tableau, Excel Dashboards, KPI Reporting, Real-time Data Validation, A/B Testing, UAT

● Modeling & Forecasting: Financial Modeling, ROI Tools, Forecasting Models, Predictive Analytics, Risk Assessment

● Tools & Methodologies: Agile (Scrum, Bi-weekly Sprints), ETL Auditing, User Acceptance Testing (UAT), Data Cleaning & Merging

● Soft Skills: Cross-functional Collaboration, Stakeholder Communication, Strategic Decision Support, Documentation & Reporting Professional Experience

Business Intelligence Analyst, Citibank 01/2025 – Present Remote, USA

● Worked with marketing, data science, and front-end teams in an Agile environment, applying bi-weekly sprints to refine segmentation models, integrate new data sources, and ensure alignment with business goals through stakeholder meetings.

● Used SQL to analyze large-scale customer transaction and demographic data, segmenting customers based on purchasing behaviors and engagement metrics. Increased segmentation accuracy by 25%, providing insights for marketing tactics.

● Improved UI with the front-end team and conducted A/B testing, leading to a 25% improvement in user experience. Performed User Acceptance Testing (UAT) with the testing team to ensure product quality and meet user satisfaction requirements.

● Applied Advanced Excel (VLOOKUP, Power Query, PivotTables) to merge and clean large datasets, ensuring seamless integration for segmentation analysis. Optimized reporting templates, reducing manual effort by 40% and improving reporting consistency.

● Designed Tableau dashboards with real-time data validation techniques, ensuring high data quality and integrity across customer segments. Validated customer data sources, resulting in a 30% drop in data discrepancies for reporting purposes.

● Delivered detailed reporting and performance analysis of customer engagement via Tableau and Excel, providing stakeholders with actionable insights that resulted in a 15% gain in campaign engagement and a 10% boost in resource allocation. Business Analyst Co-Op, The Roux Institute 07/2024 - 12/2024 Portland, Maine, USA

● Built financial models and ROI tools in Excel and Python, helping startup founders forecast revenues more accurately and evaluate investment opportunities with clearer strategic direction.

● Advised over 30 early-stage founders on data-driven decisions, providing analytical insights that influenced resource prioritization and accelerated startup project outcomes.

● Partnered with innovation teams to translate business goals into financial projections, enabling improved alignment between product strategy and long-term growth objectives across multiple ventures. Business Analyst, Deloitte 09/2021 - 08/2023 Hyderabad, India

● Automated repetitive reporting tasks using VBA, significantly reducing report preparation time by 40% and improving data accuracy for financial risk assessments and monthly performance summaries.

● Designed complex Excel models with advanced formulas and macros, streamlining the financial risk exposure assessment process and cutting turnaround time by 20% for internal stakeholders.

● Used R to conduct predictive analysis on client transaction data, detecting fraud-prone patterns that helped reduce financial irregularities by 15% for a major financial services client.

● Partnered with consultants and clients to translate business problems into data solutions, enabling proactive decision-making through clear, quantifiable insights and efficient data visualization techniques. Jr Data Analyst, Mercury Associates 10/2020 - 09/2021 Hyderabad, India

● Analyzed customer sales data to uncover purchasing behavior trends, helping marketing teams implement targeted promotions that contributed to a measurable 15% increase in product-specific sales performance.

● Extracted, cleaned, and analyzed large datasets using SQL, identifying patterns and actionable insights that enabled strategic decisions, resulting in a 12% increase in overall sales for the business unit.

● Developed interactive dashboards in Tableau to present campaign KPIs including click-through rates, conversion rates, and revenue impact, enhancing decision-making and improving stakeholder engagement.

● Collaborated with cross-functional teams to align data reporting with campaign goals, ensuring that real-time performance metrics were available to drive agile marketing strategies and boost ROI.

● Maintained data integrity by performing regular audits and documentation of ETL processes, which reduced inconsistencies and enhanced the accuracy of business reporting for ongoing performance reviews. Education

Master of Science in Project Management Analytics 09/2023 – Present Northeastern University - Boston, USA

Executive MBA in General Management 02/2022 – 02/2023 Indian Institute of Management - Calcutta, India

Bachelor of Business Administration – Finance 06/2018 – 06/2021 Osmania University - Hyderabad, India

Contact this candidate