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.