SKILLS - ISSHITA KALIA ======================= TECHNICAL SKILLS ---------------- Data Engineering & ETL: - ETL Pipeline Development: Expert in designing and implementing end-to-end ETL pipelines for multi-source data integration - AWS Cloud Platforms: Proficient in AWS services including Redshift, Lambda, S3, and Step Functions for scalable data solutions - Data Quality Management: Experienced in building automated data validation frameworks and anomaly detection systems - Multi-Source Data Integration: Skilled at consolidating data from 12+ disparate sources including CRM, prescription claims, and competitive intelligence - Cloud-Based Architecture: Designed and deployed cloud-based data solutions for enterprise clients Business Intelligence & Visualization: - Power BI: Advanced user - built 150+ dashboards for KPI tracking, well metrics, and operational planning - Tableau: Expert level - designed and optimized 33+ dashboards, achieving 40% faster load times and 20% cost savings - Dashboard Development: Created 30+ real-time KPI dashboards reducing manual reporting time by 50% - Data Visualization: Skilled in translating complex data into actionable insights for C-suite leadership - Self-Service Analytics: Built self-service reporting tools enabling business users to generate reports on-demand Programming & Databases: - SQL: Advanced proficiency in writing complex queries for data analysis and transformation - Python: Experienced in Python for data analysis, ML projects, and automation - Data Modeling: Designed unified data models consolidating millions of records from multiple sources Analytics & Insights: - Salesforce Effectiveness: Deep expertise in sales analytics, territory optimization, and next-best-action frameworks - KPI Tracking: Developed comprehensive KPI frameworks across sales, operations, and quality metrics - Real-Time Reporting: Enabled real-time decision-making through live dashboard implementations - Predictive Analytics: Built forecasting models and scenario planning tools for strategic decision support - Geospatial Analytics: Experience with clustering algorithms for territory boundary identification Domain Expertise: - Pharmaceutical Operations: 3+ years working with Fortune 500 pharma clients on sales effectiveness and commercial analytics - Healthcare Analytics: Deep understanding of physician engagement, prescription trends, and HCP journey mapping - Oil & Gas Operations: Experience in well metrics, rig scheduling, and asset performance tracking from Shell role - Energy Sector: Background in petroleum engineering with practical knowledge of production operations Process & Workflow Optimization: - Workflow Analysis: Expert at identifying bottlenecks and inefficiencies in business processes - Process Automation: Reduced manual effort by 50-85% through strategic automation initiatives - Version Control: Standardized and enforced version control practices reducing production errors by 50% - Quality Assurance: Automated QA processes delivering 60% faster validation cycles - Resource Allocation: Optimized resource allocation improving efficiency by 25% SOFT SKILLS ----------- Leadership & Management: - Stakeholder Management: Coordinated with 6+ Salesforce Effectiveness Leads and C-suite executives - Cross-Functional Collaboration: Led projects involving IT, Sales Operations, Commercial Analytics, and Field Leadership - Team Mentoring: Mentored 7+ analysts on end-to-end process ownership and client alignment - Change Management: Successfully led organizational change initiatives with 92% compliance rates - Project Management: Delivered 15+ high-impact launches, surpassing goals by 15% and accelerating timelines by 20% Communication & Presentation: - Client Alignment: Strong track record of aligning technical execution with client business strategy - Executive Reporting: Presented complex analytics to global leadership and C-suite stakeholders - Training & Development: Conducted training sessions for 50+ users across multiple geographies - Public Speaking: Invited as guest speaker addressing 350+ students on industry trends - Documentation: Created comprehensive documentation and knowledge transfer materials Strategic Thinking: - Business Strategy Alignment: Synced tech execution with evolving business strategy across 15+ enhancements - Problem-Solving: Diagnosed and resolved critical delivery bottlenecks through strategic workflow optimization - Initiative & Ownership: Spearheaded new business unit launches for USD 45 Bn firm - Data-Driven Decision Making: Enabled strategic decisions through analytics and insights - Innovation: Initiated quarterly connects bridging client vision with employee impact Delivery Excellence: - Client Focus: Won 2024 Outstanding Contribution Award for consistent accuracy and client focus - Quality & Accuracy: Maintained high standards achieving 99.7% data accuracy across systems - SLA Management: Boosted SLA adherence by 35% through strategic optimizations - Timeline Management: Consistently delivered projects ahead of schedule (20-30% timeline acceleration) - Scalable Solutions: Built reusable frameworks deployed across 4-6+ business units INDUSTRY KNOWLEDGE ------------------ Pharmaceuticals & Life Sciences: - Commercial Analytics and Sales Effectiveness - Physician Engagement and HCP Journey Mapping - Regulatory Reporting and Compliance - Multi-Channel Marketing and Omnichannel Strategies - Specialty Pharma and Rare Disease Markets Energy & Oil/Gas: - Well Metrics and Production Operations - Rig Scheduling and Asset Performance - Enhanced Oil Recovery Techniques - Sustainability and ESG in Energy Sector - Process Engineering and Dehydration Systems Technology & Digital Transformation: - Cloud Migration and Platform Modernization - Data Governance and Quality Management - Sales Technology and CRM Systems - Business Intelligence and Analytics Platforms - Automation and Process Digitization