CHARAN PAIPOTI
Summary
Business Analyst and Project Manager with 3 years of experience in data analytics and process optimization. Developed SQL and Python-driven dashboards that enhanced operational efficiency and informed strategic decisions. Managed cross-functional projects and streamlined processes, ensuring reliable data for network operations.
Overview
3
3
years of professional experience
Work History
ANALYST & PROJECT MANAGER
State of Connecticut
10.2023 - 05.2025
- Managed day-to-day operations of facility serving over 1,500 individuals, overseeing vendors and handling invoices.
- Streamlined operations by tracking service KPIs in Excel, reducing student wait times by 20%.
- Developed staffing and scheduling models in Excel, optimizing labor allocation and increasing productivity by 15%.
- Implemented inventory tracking and cost analysis techniques, reducing food waste by 10% through real-time Tableau dashboards.
- Conducted performance reviews and audits, utilizing Excel and Tableau to drive data-informed improvements.
BUSINESS ANALYST
TATA CONSULTANCY SERVICES
03.2022 - 08.2023
- Boosted strategic planning and operational efficiency by 20% via data analysis in Excel, SQL, Power BI.
- Streamlined workflows by analyzing over 1,000 records monthly using SQL, Python, saving over 800 hours monthly.
- Elevated decision-making with Power BI dashboards, Excel reports achieving 94.7% data accuracy.
- Forecasted project performance trends using Tableau, preventing a 7% utilization drop, gaining 15% efficiency.
- Enhanced project visibility and invoicing by coordinating cross-functional data initiatives across 150+ accounts.
- Managed automation initiatives' lifecycle for SBI's TDFP & FDP units to meet regulatory requirements.
- Produced accurate key indicator reports and variance analysis by applying financial concepts to forecast performance.
Education
Master of Science - Business Analytics and Project Management
UNIVERSITY OF CONNECTICUT
Storrs, CT05.2025
Skills
- Python and R
- Agile and Scrum methodologies
- Data visualization tools
- Microsoft Office Suite
- SQL and database management
- Predictive modeling techniques
- Business intelligence solutions
- Cross-functional collaboration
- Critical thinking and problem solving
- Data analysis with Pandas and NumPy
- Project management tools (Jira, Visio)
- Forecasting and data modeling strategies
- ERP-CRM systems (Salesforce, HANA)
- ETL pipelines and data warehousing
Projects
InsightRx:
- Forecasting Drug Overdose Deaths, Used 10 years of Connecticut overdose data (2012-2022) to identify trends in fatalities caused by heroin, fentanyl, methadone, and cocaine.
- Analyzed overdose death data to build predictive models for various substances.
- Used SAS and JMP to model deaths related to heroin, fentanyl, methadone, and cocaine.
- Achieved 80% model accuracy, aiding early intervention strategies and public health.
ResumeAI -
- AI-Powered Resume and Job Matcher, Developed a smart web app that extracted resume skills and compared them with real-time job descriptions using ATS logic.
- Integrated Dify and GPT-4 for resume parsing and scoring, along with LinkedIn and Indeed APIs for job data.
- Helped users identify job opportunities with over 85% match accuracy, improving application targeting and job search success.
Ananda AI -
- AI-Powered Cryptocurrency Chatbot, Led the development of Ananda AI, LLM-powered chatbot delivering real-time cryptocurrency market insights and trading signals.
- Managed project planning and execution, overseeing both technical development and cross-functional collaboration.
- Built a Retrieval-Augmented Generation (RAG) architecture integrating live crypto data and curated knowledge for responses.
- Designed conversational flows to enable natural interactions, providing users with trading signals, market trends, and educational content.
Timeline
ANALYST & PROJECT MANAGER
State of Connecticut
10.2023 - 05.2025
BUSINESS ANALYST
TATA CONSULTANCY SERVICES
03.2022 - 08.2023
Master of Science - Business Analytics and Project Management
UNIVERSITY OF CONNECTICUT
Similar Profiles
Carla KielbasinskiCarla Kielbasinski
Human Resources Generalist 3 at State of ConnecticutHuman Resources Generalist 3 at State of Connecticut
John SpeasJohn Speas
Juvenile Detention Officer at State Of ConnecticutJuvenile Detention Officer at State Of Connecticut
Bronwyn SchnitzlerBronwyn Schnitzler
Chief Probation Officer at State of ConnecticutChief Probation Officer at State of Connecticut
Dawn ThomasDawn Thomas
Developmental Support Worker 2 at State Of ConnecticutDevelopmental Support Worker 2 at State Of Connecticut
Manisha YarapothinaManisha Yarapothina
Project Manager / Business Analyst / Product Manager at MedCost, Winston SalemProject Manager / Business Analyst / Product Manager at MedCost, Winston Salem