Spaces:
Runtime error
Runtime error
| 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. | |