knowledge_base/projects.txt

PROJECTS - ISSHITA KALIA
=========================

REAL PROJECTS (From Actual Experience)
---------------------------------------

Project 1: End-to-End ETL Pipelines on AWS for Revenue-Driving Verticals
Duration: Ongoing at ZS Associates (2022-2025)
Role: Technical Lead

Description:
Directed end-to-end ETL pipeline development on AWS managing multi-source data integration for 5+ revenue-driving business verticals serving Fortune 500 pharmaceutical clients.

Key Responsibilities:
- Designed cloud-based data architecture consolidating data from multiple source systems
- Implemented automated data validation and quality checks
- Built scalable pipelines processing millions of records daily
- Managed data integration for sales, marketing, and commercial analytics teams

Technical Stack: AWS (Redshift, S3, Lambda), SQL, Python, ETL tools

Impact & Results:
- Delivered 15% faster sales tracking capabilities
- Achieved 10% visibility gain for client decision-making
- Enabled real-time data access across multiple business functions
- Processed 4.2M+ records with 99.7% accuracy


Project 2: BI Dashboard Suite for Real-Time KPI Tracking
Duration: 2022-2025 at ZS Associates
Role: Dashboard Developer & Data Analyst

Description:
Launched comprehensive suite of 30+ KPI dashboards enabling real-time business decisions and reducing manual reporting burden for pharmaceutical sales operations.

Key Deliverables:
- Real-time sales performance tracking dashboards
- Marketing campaign effectiveness monitors
- Territory performance analytics
- Salesforce productivity metrics
- Customer engagement tracking tools

Technologies Used: Tableau, Power BI, SQL, Cloud platforms

Impact & Results:
- Reduced manual reporting time by 50%
- Enabled real-time decision-making for 6+ business stakeholders
- Improved data accessibility across 5 business units
- Supported USD 45 Bn firm's strategic initiatives


Project 3: Salesforce Next-Best-Action Framework
Duration: 2023-2024 at ZS Associates
Role: Technical Lead

Description:
Owned full-cycle launch and scaling of next-best-action recommendation framework for pharmaceutical sales representatives across multiple geographies.

Implementation:
- Analyzed physician engagement patterns and prescription behaviors
- Built recommendation algorithms suggesting optimal sales actions
- Integrated with existing CRM and analytics platforms
- Scaled solution across 6 international geographies

Technical Approach: Machine learning models, CRM integration, cloud-based analytics

Business Impact:
- Achieved 20% salesforce performance improvement
- Scaled successfully across 6 geographies
- Increased customer engagement by 25% year-over-year
- Enhanced targeting precision and sales effectiveness


Project 4: Dashboard Performance Optimization Initiative
Duration: 2023 at ZS Associates
Role: Performance Optimization Lead

Description:
Diagnosed and optimized 33+ underperforming Tableau dashboards experiencing slow load times and high operational costs.

Optimization Activities:
- Conducted performance audits identifying bottlenecks
- Redesigned data models and visualization logic
- Optimized SQL queries and data extracts
- Implemented caching and incremental refresh strategies

Results Achieved:
- Drove 40% faster dashboard load times
- Achieved 20% cost savings through resource optimization
- Improved user experience and adoption rates
- Saved USD 35K+ annually through efficiency gains


Project 5: Power BI Dashboards for Oil & Gas Operations
Duration: 2021-2022 at Shell
Role: Process Data Engineer

Description:
Built comprehensive Power BI dashboard suite for tracking KPIs, well metrics, and data quality across oil and gas production operations.

Dashboard Components:
- Well performance metrics and production tracking
- Rig sequencing and scheduling optimization
- Data quality monitoring across 4+ operational teams
- Asset-level KPI drilldowns for performance analysis
- Quarterly performance reporting for 150+ assets

Technologies: Power BI, SQL, Data integration tools

Impact:
- Enabled 25% boost in operational efficiency and resource allocation
- Achieved 20% rig performance improvement through KPI insights
- Delivered 60% faster QA through automated anomaly detection
- Provided performance visibility to global leadership


Project 6: Dehydration System Design (Academic Project)
Year: 2021
Institution: UPES

Description:
Designed and modeled gas dehydration systems for natural gas processing, analyzing multiple design parameters to optimize separation efficiency.

Technical Work:
- Modeled dehydration process using engineering software
- Analyzed 5+ design parameters (temperature, pressure, flow rates, glycol concentration)
- Optimized separation efficiency and moisture removal
- Evaluated equipment sizing and operating conditions

Learning Outcomes:
- Practical application of chemical engineering principles
- Process optimization and simulation skills
- Technical documentation and reporting


Project 7: Enhanced Oil Recovery Using Bio-Surfactants
Year: 2020
Institution: UPES

Description:
Engineered novel hibiscus-based bio-surfactant as an environmentally sustainable alternative for enhanced oil recovery operations.

Research Activities:
- Extracted and synthesized bio-surfactant from hibiscus plant material
- Conducted interfacial tension (IFT) experiments
- Compared performance against conventional chemical surfactants
- Evaluated environmental impact and sustainability benefits

Key Achievement:
- Reduced interfacial tension by 64%
- Demonstrated viability of sustainable oil recovery methods
- Contributed to green chemistry research in petroleum engineering

Recognition:
- Secured 1st place in Techuminati, SPE Fest's flagship Research Paper Competition (among 300+ students)


SYNTHETIC PROJECTS (AI-Generated Extensions)
--------------------------------------------
NOTE: The following projects are realistic but fictional scenarios generated to demonstrate potential capabilities.

Synthetic Project 1: Customer Journey Analytics Platform for Specialty Pharma
Category: Synthetic/Generated

Description:
Developed end-to-end customer journey analytics platform for specialty pharmaceutical client targeting rare disease physicians, tracking engagement across 9 touchpoints over 18-month lifecycle.

Technical Implementation:
- Built cloud-based ETL pipelines integrating web, email, events, rep calls, samples, patient services, HCP portal, medical inquiries, and peer-to-peer programs
- Designed customer journey maps tracking 150+ rare disease specialists
- Created machine learning models identifying high-propensity physicians
- Developed interactive Power BI dashboards with journey visualization and next-best-action recommendations

Data Processing:
- Processed 2.5M+ interaction records monthly
- Integrated data from 9 distinct touchpoint systems
- Built predictive models for physician engagement scoring

Business Impact:
- Enabled 40% increase in physician engagement scores
- Reduced time-to-first-prescription by 25% for newly targeted HCPs
- Optimized marketing spend allocation, reallocating USD 200K from low-impact to high-ROI channels
- Improved sales rep call quality ratings by 32%
- Created predictive alerts for physician disengagement enabling proactive retention
- Platform expanded to 3 additional rare disease brands


Synthetic Project 2: Automated Regulatory Reporting System
Category: Synthetic/Generated

Description:
Led development of automated regulatory reporting system for global pharmaceutical manufacturer managing compliance requirements across 22 international markets.

Challenge Addressed:
Replaced manual compilation process for 50+ monthly regulatory reports (adverse events, sales data, promotional spend, market access metrics) that required 15-person team and 800+ hours with 8-12% error rates.

Solution Architecture:
- Architected cloud-based reporting infrastructure on AWS using Redshift, Lambda, and Step Functions
- Built data connectors to 15+ source systems (ERP, CRM, safety databases, clinical trial systems)
- Designed validation frameworks with 60+ business rules
- Created self-service Power BI dashboards for on-demand report generation
- Implemented version control and audit trails for compliance documentation

Technical Performance:
- Processed 5M+ records across systems
- Achieved 99.7% data accuracy
- Reduced report generation time from 5 days to 2 hours (98% improvement)
- Automated 85% of previously manual data collection tasks

Business Outcomes:
- Reduced compliance team effort by 650 hours monthly (81% reduction)
- Eliminated 95% of data errors in regulatory submissions
- Saved USD 280K annually in operational costs
- Reduced regulatory risk exposure
- System passed 3 regulatory audits with zero findings


Synthetic Project 3: Sales Incentive Compensation Analytics & Forecasting
Category: Synthetic/Generated

Description:
Built comprehensive sales incentive compensation analytics platform for Fortune 100 pharmaceutical company managing USD 180M annual sales compensation budget across 4,000+ sales representatives in 6 business units.

Project Scope:
Created enterprise analytics platform providing visibility into incentive plan performance, payout projections, and plan effectiveness to replace error-prone Excel-based processes.

Solution Architecture:
- Designed cloud-based analytics platform integrating sales performance, territory targets, quota attainment, and payout rules
- Built predictive models forecasting quarterly compensation spend with 94% accuracy
- Created role-based dashboards for Sales Leadership, Compensation Team, and Sales Representatives
- Implemented scenario planning tools for plan design impact modeling

Technical Delivery:
- Processed 150K+ monthly transactions across complex compensation rules (tiered accelerators, goal-based bonuses, team multipliers)
- Automated payout calculations reducing processing from 10 days to 6 hours
- Built data quality checks preventing USD 2.3M in erroneous payments
- Created real-time performance dashboards accessed by 4,000+ field users

Business Results:
- Improved forecast accuracy from 78% to 94%
- Reduced compensation processing errors by 89%
- Saved 120 hours monthly in manual calculation effort
- Enabled data-driven plan optimization improving sales productivity by 14%
- Increased sales rep satisfaction scores by 22%
- Generated USD 450K in cost avoidance


Synthetic Project 4: Predictive Territory Optimization for Pharma Sales
Category: Synthetic/Generated (from Case Study 1)

Description:
Led predictive analytics project redesigning sales territories for Fortune 500 pharmaceutical client with 2,500+ sales representatives across North America, covering 8 therapeutic areas.

Challenge:
Existing territory alignment based on historical zip codes without accounting for physician engagement patterns, prescription trends, or competitive dynamics, resulting in inconsistent performance and suboptimal resource allocation.

Technical Approach:
- Designed multi-stage ETL pipeline on AWS consolidating 4.2M+ prescription records and 150K+ physician profiles
- Built geospatial clustering algorithms using Python and SQL
- Developed Power BI dashboard with 25+ KPIs tracking territory balance metrics
- Created scenario modeling tools for leadership decision support

Solution Delivery:
- Coordinated with 8 cross-functional stakeholders over 4-month timeline
- Enabled visualization of territory equity across 6 dimensions
- Provided data-driven alignment decision support

Impact & Results:
- Achieved 18% improvement in territory balance score
- Reduced territory variability by 22% ensuring fairer workload distribution
- Enabled 95% sales rep retention during transition (vs. 78% industry benchmark)
- Generated USD 8.2M incremental revenue in Year 1
- Created reusable framework deployed across 4 additional business units
- Reduced territory planning cycle from 6 months to 8 weeks

Recognition:
Presented as best practice case study at company's annual Analytics Summit, training 40+ analysts.


Synthetic Project 5: Real-Time Data Quality Monitoring for Marketing
Category: Synthetic/Generated (from Case Study 2)

Description:
Built automated data quality monitoring system for USD 400M omnichannel marketing campaign for new oncology drug across 5 countries, integrating email, digital ads, sales rep interactions, and medical education events.

Challenge Addressed:
30-40% data quality issue rate with incomplete physician contact information, duplicate records, and inconsistent opt-in/opt-out statuses creating compliance risks and 3-4 day manual validation delays.

Solution Design:
- Cloud-based solution using AWS Lambda, S3, and Python
- 45+ validation rules across 8 data quality dimensions
- Automated alerts for critical issues
- Interactive Tableau dashboards showing quality scores by region, channel, and data source
- Feedback loop for in-workflow issue resolution

Implementation:
- Collaborated with Marketing Operations, Compliance, IT Security, and Legal teams
- Ensured compliance with GDPR, HIPAA, and local privacy laws
- Conducted 6 training sessions for 50+ marketing users across geographies

Impact & Results:
- Reduced data quality issues by 67% within first quarter
- Cut campaign validation time from 3-4 days to 4-6 hours (85% reduction)
- Prevented 12+ potential compliance violations
- Improved email deliverability rate by 28%
- Enabled 35% faster campaign launch cycles
- Saved USD 120K annually by reducing manual QA from 3 FTEs to 0.5 FTE
- Framework scaled to 15+ additional campaigns

Recognition:
Presented to C-suite leadership as key enabler of digital transformation roadmap.