WORK EXPERIENCE - ISSHITA KALIA ================================ Total Professional Experience: 44 months (3 years 8 months) CURRENT EXPERIENCE ------------------ Position: PGDM Student Organization: SP Jain Institute of Management and Research (SPJIMR), Mumbai Duration: 2025 - 2027 (Expected) Status: Currently pursuing Post Graduate Diploma in Management FULL-TIME POSITIONS ------------------- Position 1: Business Technology Solutions Associate Organization: ZS Associates Duration: July 2022 - May 2025 (2 years 11 months) Location: India Overview: Worked with Fortune 500 pharmaceutical clients delivering data engineering, business intelligence, and sales effectiveness solutions. Led multiple high-impact projects involving ETL pipeline development, dashboard creation, and business analytics. Key Responsibilities: Data Engineering & Infrastructure: • Directed end-to-end ETL pipelines on AWS managing multi-source data for 5+ revenue-driving verticals • Managed consolidation of data from 12+ disparate sources including CRM, prescription claims (IQVIA), physician affiliations, and competitive intelligence • Built cloud-based data architecture processing 4.2M+ records with 99.7% accuracy • Designed unified data models integrating sales, marketing, and commercial analytics data Business Intelligence & Analytics: • Launched 30+ KPI dashboards reducing manual reporting time by 50% and enabling real-time decisions • Delivered 15% faster sales tracking and 10% visibility gain through BI tools • Diagnosed and optimized 33+ underperforming dashboards achieving 40% faster load times and 20% cost savings • Created self-service analytics enabling ad-hoc analysis for 6+ business stakeholders Sales Effectiveness & Strategy: • Owned full-cycle launch of new business unit for USD 45 Bn firm, leading delivery and stakeholder alignment • Achieved 20% salesforce performance gain by scaling next-best-action framework across 6 geographies • Unlocked 25% YoY growth in customer engagement by tracking suggestions and drug promotion activity • Improved resource allocation and engagement strategy by 25% across 5 business units through visibility tools Process Optimization & Delivery: • Spearheaded 15+ cross-functional enhancements syncing tech execution with evolving business strategy • Boosted SLA adherence by 35% by resolving critical delivery bottlenecks via strategic workflow optimization • Enabled 30% faster reporting by streamlining pharma operations and scaling delivery via cloud platforms • Reduced production errors and delays by 50% through standardized version control practices • Slashed activation time by 30% via standardized knowledge transfer accelerating delivery across teams Leadership & Mentoring: • Coordinated with 6+ key Salesforce Effectiveness Leads enabling ad-hoc analytics, strategy, and execution • Mentored 7+ analysts for end-to-end process ownership, client alignment, and scalable delivery • Initiated quarterly connects bridging client vision and employee impact, spotlighting team-led upgrades Cost Optimization: • Saved USD 35K+ annually by optimizing Tableau dashboards and redesigning workflows • Achieved 20% cost savings through dashboard performance improvements • Reduced manual effort by 50% through strategic automation initiatives Key Projects at ZS Associates: - ETL Pipeline Development on AWS for multi-vertical data integration - 30+ Real-time KPI Dashboard Suite for pharmaceutical sales operations - Next-Best-Action Framework scaled across 6 geographies - Dashboard Performance Optimization Initiative (33+ dashboards improved) - Territory Optimization Analytics (generated USD 8.2M incremental revenue) - Real-Time Data Quality Monitoring (reduced issues by 67%) Awards & Recognition: • Won 2024 Outstanding Contribution Award for consistent accuracy, client focus, and delivery excellence • Honored for steering 4+ high-impact launches, surpassing goals by 15% and accelerating timelines by 20% Position 2: Process Data Engineer Organization: Shell Duration: September 2021 - June 2022 (10 months) Location: India Overview: Built business intelligence solutions for oil and gas production operations, focusing on KPI tracking, operational efficiency, and data quality management across global assets. Key Responsibilities: Dashboard Development: • Built Power BI dashboards for tracking KPIs, well metrics, and data quality across 4+ teams for operations planning • Delivered quarterly dashboards across 150+ assets unlocking performance visibility for global leadership • Designed KPI drilldowns enabling proactive asset-level interventions Operational Optimization: • Enabled 25% boost in efficiency and resource allocation through automated rig sequencing and optimized scheduling • Achieved 20% rig performance gain by designing performance monitoring and analysis tools • Led 60% faster QA delivery via automating anomaly checks in Power BI for cross-team data validation Data Quality & Validation: • Implemented automated data quality monitoring across production operations • Created anomaly detection systems for cross-team data validation • Built audit trails and quality scorecards for operational data Key Projects at Shell: - Power BI Dashboard Suite for Well Metrics and KPI Tracking - Automated Rig Sequencing and Scheduling Optimization - Data Quality Monitoring System (60% faster QA delivery) - Asset Performance Analytics across 150+ global assets Technical Environment: Power BI, SQL, Data Integration Tools, Oil & Gas Production Systems INTERNSHIP EXPERIENCE --------------------- Internship 1: National Fertilisers Limited Duration: 2020 Type: Industrial Internship Description: Analyzed operational workflows in fertilizer manufacturing operations to identify bottlenecks and efficiency improvement opportunities. Key Activities: • Analyzed 8+ operational workflows across production and logistics • Identified and flagged 4+ critical bottlenecks impacting production efficiency • Recommended process improvements and workflow optimizations • Conducted time-motion studies and efficiency assessments Impact: • Enabled key process changes that saved 25 hours per month • Provided actionable insights for operational improvement • Gained practical experience in industrial process analysis Learning Outcomes: - Manufacturing operations and process optimization - Workflow analysis and bottleneck identification - Data-driven problem solving in industrial settings Internship 2: Essar Oil and Gas Duration: 2019 Type: Technical Internship Description: Gained hands-on experience in oil and gas field operations with focus on hydraulic fracturing, coalbed methane (CBM) development, and health, safety, security, and environment (HSSE) protocols. Key Activities: • Benchmarked 25+ hydraulic fracturing designs across different well conditions • Mapped 30+ coalbed methane (CBM) wells analyzing production potential • Conducted 12+ site visits to active production and drilling locations • Completed 5 comprehensive HSSE training modules Technical Exposure: - Hydraulic fracturing design parameters and optimization - Coalbed methane reservoir characterization - Well mapping and production planning - Field operations and drilling activities - Safety protocols and environmental compliance Learning Outcomes: - Practical oil and gas field operations knowledge - Understanding of unconventional resource development - HSSE best practices and regulatory compliance - Field data collection and analysis techniques SYNTHETIC EXPERIENCE (AI-Generated Extension) ---------------------------------------------- NOTE: The following is a realistic but fictional leadership scenario. Leadership Role: Cross-Regional Data Governance Initiative Lead Organization: ZS Associates (Hypothetical Extension) Duration: Mid-2024 (4-month initiative) Scope: 3 regions (North America, Europe, Asia-Pacific), 12 client engagements, 45+ team members Context: Led critical data governance initiative following client-reported data discrepancy that required 3 weeks to resolve and put USD 15M contract renewal at risk due to inconsistent data standards across regions. Challenge: • Each region using different naming conventions, data models, and quality checks • No centralized documentation of data lineage or transformation logic • Version control gaps creating production issues during handoffs • Knowledge silos limiting cross-team collaboration • Client trust erosion due to data inconsistencies Leadership Approach: Stakeholder Engagement: • Conducted 20+ interviews with analysts, project leads, and client stakeholders across regions • Assembled cross-functional working group of 12 senior analysts representing all regions • Developed coalition and buy-in across diverse stakeholder groups Implementation Strategy: • Pilot-driven approach with 3 high-impact projects before enterprise rollout • Developed training materials and documentation templates • Hosted 8 regional workshops training 65+ team members • Established monthly governance council for continuous improvement Change Management: • Quantified business case: 200+ hours monthly in rework due to poor governance • Delivered quick wins within 2 weeks (standardized file naming, centralized documentation) • Identified and empowered 8 regional champions as advocates • Created flexible framework balancing standardization with project-specific needs Results Achieved: • Reduced data-related production issues by 72% within 6 months • Cut average issue resolution time from 3 weeks to 2 days • Improved cross-regional collaboration with 15+ successful team transitions • Enabled 30% faster onboarding for new analysts • Achieved 92% compliance with governance standards across all active projects • Secured USD 15M contract renewal and expanded scope by USD 4M Recognition: • Presented approach at company's Global Analytics Forum • Framework adopted as enterprise standard • Three working group members promoted citing leadership development • Data Governance Manager role created based on initiative success Leadership Lessons: - Building coalition before driving organizational change - Balancing standardization with flexibility for diverse needs - Using data to make the case for investments - Empowering others rather than centralizing decision-making - Celebrating small wins to maintain momentum PROFESSIONAL SKILLS DEVELOPED THROUGH EXPERIENCE ------------------------------------------------- Technical Skills: - ETL Pipeline Development and Data Engineering - Business Intelligence (Power BI, Tableau) - Cloud Platforms (AWS - Redshift, S3, Lambda) - SQL and Data Modeling - Data Quality Management and Validation - Sales Analytics and Salesforce Effectiveness - Process Automation and Optimization Business Skills: - Stakeholder Management and Client Alignment - Cross-Functional Project Leadership - Strategic Planning and Execution - Change Management and Organizational Development - Team Mentoring and Knowledge Transfer - Executive Communication and Presentation Domain Expertise: - Pharmaceutical Sales and Commercial Analytics - Oil and Gas Production Operations - Data Governance and Quality Management - Sales Effectiveness and Territory Optimization - Regulatory Reporting and Compliance CAREER PROGRESSION SUMMARY -------------------------- 2019: Started with technical internship at Essar Oil and Gas 2020: Industrial internship at National Fertilisers Limited 2021: Graduated B.Tech and joined Shell as Process Data Engineer 2022: Promoted to ZS Associates as Business Technology Solutions Associate 2024: Won Outstanding Contribution Award at ZS Associates 2025: Completed 44 months of professional experience, joined SPJIMR for PGDM 2027: Expected PGDM graduation Total Growth: From technical intern to award-winning business technology professional managing multi-million dollar client engagements in under 6 years.