Puja Kumari — Consultant

I’m a results-oriented Senior Data Analyst with over 8 years of experience delivering actionable insights across the pharmaceutical, consulting, banking, media, and ed-tech industries. I specialize in translating customer, product, marketing, and financial data into strategic outcomes that drive growth and efficiency. 💡 Core Competencies Cloud Data Engineering: Building scalable ETL pipelines with AWS (S3, Athena, Redshift, Lambda, Glue) and Google BigQuery Business Intelligence & Reporting: Creating insightful dashboards using Tableau, Power BI, Looker, and QuickSight Customer & Marketing Analytics: Analyzing user behavior, funnel performance, and campaign ROI to improve engagement and retention Banking & Financial Data: Developing SLA-based dashboards for operational reporting and compliance tracking AI/ML Integration: Enhancing decision-making through predictive modeling and intelligent automation Stakeholder Collaboration: Aligning data strategies with cross-functional goals in Agile environments 🏆 Selected Achievements Automated invoice processing via AWS, saving 1,440+ hours quarterly and driving $1.3M+ in cost savings Built pharmacy support dashboards that reduced customer wait times by 30% and improved issue resolution by 15% Improved team capacity planning with dashboards that enhanced resource efficiency by 40% Boosted trial-to-subscription conversion by 12% with predictive analytics models Increased data-driven decision-making across business teams, improving campaign targeting and engagement by 30% 🧰 Tools & Technologies: SQL, Python, Tableau, Power BI, Looker, Google Analytics, AWS, BigQuery, Excel, JIRA 📍 Based in Berlin, eligible to work across the EU, and open to relocation or remote opportunities. Always eager to connect and explore data-driven innovation!

Stackforce AI infers this person is a Data Analytics and Business Intelligence expert in the Healthcare and EdTech sectors.

Experience: 7 yrs 11 mos

Skills

Cloud Data Engineering
Data Analytics
Business Intelligence & Reporting
Customer & Marketing Analytics
Stakeholder Collaboration
Data Visualization

Career Highlights

Achieved $1.3M annual cost reduction through automation.
Improved customer satisfaction with real-time stock visibility.
Enhanced decision-making with predictive analytics models.

Work Experience

Eli Lilly and Company

Consultant -1 (2 mos)

Senior Data Analyst (2 yrs 5 mos)

Accenture

Marketing Data Analyst (1 yr 2 mos)

Shaw Academy

Product Data Analyst (1 yr 1 mo)

Clover Infotech

Data Analyst (1 yr 6 mos)

AcadGild

Data Analyst (1 yr 1 mo)

flipClass

Data Analyst (8 mos)

Education

Bachelor of Technology - BTech at University Institute of Technology, RGPV

Intermediate at RVS College of Education

Higher secondary at Holy cross

Bachelor of Technology - BTech at University Institute of Technology, RGPV

Puja Kumari

Consultant

India7 yrs 11 mos experience

Key Highlights

Achieved $1.3M annual cost reduction through automation.
Improved customer satisfaction with real-time stock visibility.
Enhanced decision-making with predictive analytics models.

Stackforce AI infers this person is a Data Analytics and Business Intelligence expert in the Healthcare and EdTech sectors.

Contact

Skills

Core Skills

Cloud Data EngineeringData AnalyticsBusiness Intelligence & ReportingCustomer & Marketing AnalyticsStakeholder CollaborationData Visualization

Other Skills

AWS TextractRedshiftData ExtractionAutomationCommunicationProblem SolvingTableauPower BIPythonMySQLAWSStakeholder ManagementData AnalysisStrategic ReportingSystem Integration

About

Experience

7 yrs 11 mos

Total Experience

1 yr 3 mos

Average Tenure

Current Experience

Eli lilly and company

2 roles

Consultant -1

Mar 2025 – May 2025 · 2 mos · On-site

Copay Invoice Automation – AWS Textract & Redshift Integration
· Designed and implemented an end-to-end automation solution for processing copay invoices using AWS
cloud services.
· The solution leveraged AWS Textract to accurately parse invoice data from PDF documents, automating
the data extraction process. Reduced manual effort and minimized human error, resulting in more accurate
and reliable financial data.
· Business Impact: Achieved a time savings of 1,440 hours per quarter, contributing to an estimated
$1.3M annual cost reduction.
Tech Stack: Tableau, Power BI, Python, MySQL, AWS (S3, Athena, Textract, Redshift, EventBridge, Lambda, Glue,
Secret Manager, State Machine), HTML, CSS, Advanced Excel, JIRA, Prefect

AWS TextractRedshiftData ExtractionAutomationData AnalyticsCommunication+2

Senior Data Analyst

Oct 2022 – Mar 2025 · 2 yrs 5 mos · On-site

Developed Pharmacy Stock Locator Tableau Dashboard, enabling real-time stock visibility for customer care agents, resulting in:
25% reduction in operational inefficiencies
15% improvement in helpline resolution rate
30% decrease in customer wait time, enhancing satisfaction
Built Capacity Tracker Dashboard for Tech@Lilly leadership to support strategic planning by:
Enhancing forecast accuracy for team capacity vs. project workload
Delivering 40% improvement in resource alignment and utilization
Enabling data-driven decisions across short- and long-term initiatives
Collaborated with cross-functional teams to gather requirements, define KPIs, and deliver stakeholder-aligned dashboards
Utilized advanced tools including Tableau, Power BI, Python, MySQL, and AWS (Textract, Redshift, Lambda, Glue, S3, Athena)
Automated and optimized data pipelines to improve data accessibility, accuracy, and reporting speed

TableauPower BIPythonMySQLAWSData Visualization+4

Accenture

Marketing Data Analyst

Jul 2021 – Sep 2022 · 1 yr 2 mos · India

Client Engagement & Stakeholder Management: Acted as the primary liaison with SKY, ensuring projects aligned with their strategic goals and enhancing relations through regular updates and meetings
Data Analysis & Strategic Reporting: Led the creation of data analysis frameworks and reporting systems, providing key insights for marketing strategies, product development, and customer retention
Technical Solutions & System Integration: Worked alongside technical teams to design and implement solutions that supported SKY’s digital transformation, managing system upgrades to improve operations
Cross-Functional Teamwork: Directed multidisciplinary teams across diverse locations, ensuring effective collaboration and smooth project delivery in a multinational setting
Client Relationship & Business Development: Built and maintained strong relationships with SKY’s executive team, delivering solutions that fostered ongoing business and exceeded expectations
Impactful Decision-Making Tools: Developed and deployed dashboards for TV and broadband services, enhancing decision-making and operational efficiency, resulting in a 10% increase in customer retention and a 30% boost in stakeholder engagement
Tech-Stack: Tableau, Power BI, MySQL, GCP (BigQuery)

Data AnalysisStrategic ReportingSystem IntegrationStakeholder ManagementTableauPower BI+3

Shaw academy

Product Data Analyst

Apr 2020 – May 2021 · 1 yr 1 mo · Bengaluru, Karnataka, India

Data Reporting and Visualization: Engineered and sustained comprehensive dashboards and reports for the Product, Education, and Tech teams, enhancing visibility into critical business metrics and fostering an environment of data-centric decision-making
Ad Spend Efficiency: Spearheaded the monitoring and analysis of Return on Ad Spend (ROAS), implementing optimizations that amplified campaign efficiency by 15%, significantly cutting costs while maintaining output
Customer Journey Optimization: Developed and refined reports on customer journeys and conversion funnels, leading to strategic feature enhancements that boosted customer engagement by 15% and increased conversion rates by 10%
Revenue Forecasting: Conducted detailed analyses of buyer behavior and revenue forecasts, delivering insights that heightened forecast precision by 20%
Cross-Functional Collaboration: Collaborated effectively with multinational teams, adapting to diverse cultural and working styles to ensure cohesive project delivery and alignment with international business goals
Tech-Stack: Tableau, MySQL, MS Excel, MS Office

Data ReportingDashboard ManagementCustomer Journey OptimizationTableauMySQLBusiness Intelligence & Reporting+1

Clover infotech

Data Analyst

Sep 2018 – Mar 2020 · 1 yr 6 mos

Data Processing and Analysis: Efficiently processed and analyzed large datasets from various sources, utilizing SQL and MySQL to provide actionable insights for banking clients
Visualization and Reporting: Developed interactive visualizations and reports in Tableau, improving stakeholders’ accessibility to data and supporting enhanced decision-making processes
Data Quality Management: Conducted comprehensive data quality analyses to identify and rectify discrepancies, ensuring the integrity of data in ongoing projects
SLA Management and Support: Oversaw and resolved support requests within strict SLA parameters using effective ticketing tools to maintain high levels of customer satisfaction
Tech-Stack: Tableau, Power BI, MySQL, GCP (BigQuery)

Data ProcessingData VisualizationSQLMySQLTableauData Analytics

Acadgild

Data Analyst

Jul 2017 – Aug 2018 · 1 yr 1 mo · Bengaluru, Karnataka, India

Performance Tracking and Reporting: Built and maintained detailed reports and dashboards to monitor product performance and identify areas for improvement.
Strategic Data Analysis: Extracted and leveraged actionable insights from extensive datasets to guide strategic decision-making and support product development.
Data Resource Management: Managed the development of data resources, aligning data collection and analysis with product launch strategies and business needs
Tech-Stack: Tableau, Advanced Excel, MySQL

Performance TrackingData AnalysisTableauMySQLData AnalyticsData Visualization

Flipclass

Data Analyst

Oct 2016 – Jun 2017 · 8 mos · Bengaluru, Karnataka, India

Dashboard Management: Created and managed key business metric dashboards, enhancing data-driven performance tracking
Data Handling and Insight Generation: Handled large datasets, transforming raw data into valuable insights that informed business strategies
Process Automation: Developed Macros in Excel to automate repetitive tasks, significantly increasing reporting efficiency and accuracy
Tech-Stack: Tableau, Advanced Excel, SQL

Dashboard ManagementData HandlingExcel MacrosData AnalyticsData Visualization