Power Bi Guest Service

Ramprasan Dasari

Hartford, Connecticut +1-857-***-**** ********@**.**********.*** linkedin.com/in/ramprasan-dasari

PERSONAL SUMMARY

Energetic Business enthusiast with hands-on experience in translating complex data into smart solutions using SQL, Excel & Power BI. Skilled in bridging gaps between business needs and technical teams for Medicare, Medicaid, and insurance-driven projects.

SKILLS

SQL, SAP, SAS, Microsoft Excel, PowerPoint, Canva, Power BI, POS, Agile Methodologies.

Research analysis, Team leadership, Operations, Project management, Client communication, and User engagement.

EDUCATION

THE UNIVERSITY OF BRIDGEPORT Bridgeport, CT Master’s in Business Analytics GPA: 4 May 2023 – Aug 2024

Supply Chain Analytics Data Analytics Project Management

HNB GHARWAL (CENTRAL) UNIVERSITY Dehradun, India Bachelor's in Agriculture GPA: 3. Aug 2015 – Jun 2019

Agribusiness Commodity Marketing Agri-statistics

EXPERIENCE

The Fresh Market Avon, CT Guest Service Analyst Aug 2024 – Till Date

Led guest service analysis initiatives by evaluating OSAT scores, service recovery data, and customer feedback to improve satisfaction and retention KPIs across the department.

Automated weekly reporting on POS inefficiencies, gift card issue resolution, and service time benchmarks using SQL and Power BI, reducing escalation response time by 30%.

Used Periscope and store portals to manage production planning, delivery tracking, and inventory analysis for the front-end and floral departments, ensuring data accuracy and order fulfillment.

Oversaw scheduling and payroll accuracy using UKG UltiPro, aligning staffing with peak footfall hours to improve service readiness and reduce labor waste.

Maintained and analyzed digital guest service logs to identify patterns in complaints, recurring issues, and training needs, resulting in improved guest resolution workflows.

Facilitated training for new associates on guest interaction KPIs, register process analytics, and Power BI-based performance dashboards to elevate team awareness and ownership.

The Fresh Market Guilford, CT Retail Analyst- Internship May 2024 – Aug 2024

Collaborated with cross-functional department leads (produce, grocery, bakery, guest service) to analyze store-level operational data, identify bottlenecks, and recommend improvements in workflow efficiency.

Used Periscope and Excel to track inventory movement, forecast ordering needs, and reduce unnoticed stock transfers, improving product availability and shelf accuracy.

Supported end-to-end guest service analysis by monitoring service logs, feedback trends, and OSAT metrics to enhance the guest shopping experience and reduce unresolved issues.

Developed dashboards in Power BI to track footfall patterns, register wait times, and peak service windows, assisting managers with real-time decision-making.

Executed store-wide performance reporting on promotions, inventory levels, and shrink data, collaborating with leadership to implement data-driven replenishment and merchandising strategies.

Participated in daily team huddles, aligned operational focus with business priorities, and supported scheduling coordination using UltiPro to meet guest traffic demand.

UNIVERSITY OF BRIDGEPORT Bridgeport, CT Customer service trainee Feb 2023 – May 2024

Boosted UB's mailing department services through optimized inventory flows and improved space utilization.

Enhanced operational efficiency by scheduling and managing timely deliveries.

Utilized Quadient WTS software to perfection in managing mail and deliveries. Improved inventory tracking and management have also contributed to higher satisfaction rates.

KALGUDI DIGITAL PVT LTD Hyderabad, Telangana, India Business Analyst- Health Insurance Platform Jun 2022 – Apr 2023

Collaborated with cross-functional teams to support the launch of a digital health insurance enrollment and claims assistance platform for farmers, serving over 50+ rural communities across Telangana.

Gathered and documented business, user, and functional requirements for modules related to policy eligibility, claims processing, and benefit communication, aligning with local regulatory standards and rural health needs.

Developed Requirement Traceability Matrices (RTMs) and user stories to ensure consistent alignment between stakeholder expectations and development outputs.

Created SQL-based reports to analyze farmer health claim trends, identify high-risk groups, and support timely policy updates based on utilization data.

Used Power BI to develop real-time dashboards on claim approvals, denial rates, and geographic penetration of healthcare coverage, improving transparency for regional leadership.

Led UAT and quality audits for health benefit modules, verifying end-to-end flow from registration to claim settlement; issues identified were documented and triaged.

Delivered training sessions to field agents and NGO partners, ensuring smooth onboarding of new health service features and clear understanding of coverage processes.

Worked closely with internal stakeholders and IT to design data integration flows with third-party government health portals, ensuring compliance and interoperability.

IFFCO e BAZAR LIMITED Khammam, Telangana, India Data analyst, Healthcare Retail Project (IFFCO Tokio Collaboration) Oct 2019 – May 2022

Spearheaded data analysis for a rural health insurance integration project in partnership with IFFCO Tokio, aimed at offering subsidized coverage to agri-retail customers across 12 districts.

Collaborated with business units to document and translate business requirements for policy enrollment, premium calculation, and coverage eligibility workflows aligned with insurance regulations.

Conducted gap analysis on customer onboarding data, identifying discrepancies in age, income, and crop risk profiles that could affect insurance approval and claim accuracy.

Used SQL and Excel to build risk segmentation models based on farmer purchase behavior, claim history, and seasonal health patterns, contributing to tailored coverage plans.

Designed Power BI dashboards to track policy uptake, premium collections, and claim resolution timeframes, enabling transparency for both store managers and insurance partners

Collaborated with store staff and regional managers to train over 150 frontline associates on how to assist farmers with digital insurance enrollment and policy queries.

Created and reviewed BRDs and SOPs for the integrated insurance service desk at eBazar locations, ensuring consistency with local language and literacy support.

Aligned the reporting formats and compliance documentation to IFFCO Tokio’s audit requirements, helping reduce claim rejections due to data mismatches and incomplete submissions.

CERTIFICATIONS

BUSINESS ANALYTICS WITH EXCEL, SIMPLILEARN

Gained proficiency in data manipulation, visualization, and statistical analysis, and enhanced abilities in data-driven decisions.

RAINWATER HARVESTING, NIRDPR, HYDERABAD, TELANGANA.

Participated in a program organized by the Sehgal Foundation at NIRD Hyderabad, gaining insights into traditional rainwater harvesting techniques. And acquired comprehensive training in sustainable water management practices.

EXTRACURRICULAR

CRICKET:

Team captain for inter-university competition (HNB) – Champions/winners (2018-19)

Team captain for Peddapalli Territory, at SCVPL – Champions/winners (2021-22)

Contact this candidate