Ashwini Lode

3M HealthCare

• Developed and maintained SSIS data flows for healthcare data integration and transformation across enterprise systems.
• Architected and integrated application frameworks, driving enterprise-wide security alignment and improved operational efficiency.
• Automated document routing, approvals, and notifications using AWS file shares integrated with Power Automate workflows, accelerating business processes and enhancing collaboration.
• Orchestrated automation pipelines using Informatica to manage threshold changes and synchronize SharePoint updates, enabling seamless integration between on-premise ETL processes and cloud-based workflows.
• Implemented RSA key pair authentication to encrypt data flows, ensuring secure and trusted system communication.
• Modernized reporting pipelines by optimizing SQL queries and stored procedures, and designed cloud-ready database schemas to support migration and hybrid data environments, improving analytics performance.

TechnipFMC

• Architected enterprise-scale Power BI ecosystems featuring dynamic KPI dashboards, drill-through reporting, and predictive analytics using DAX, enabling Finance and Operations teams with real-time, actionable insights.
• Engineered high-complexity SSIS pipelines for multi-source integration (ERP, CRM, APIs, flat files), incorporating robust error handling, logging, and metadata-driven orchestration for resilient ETL automation.
• Optimized ETL performance using incremental load strategies (CDC, partitioning, parallel processing), reducing data refresh cycles by 70% while maintaining near real-time data availability.
• Designed high-performance semantic data models using hybrid star–snowflake schemas, implementing surrogate keys, hierarchies, and aggregation tables to enhance scalability and query performance.
• Executed advanced SQL performance tuning, including query plan analysis, index optimization, and materialized views, achieving sub-second query response times for mission-critical BI workloads.
• Collaborated with business stakeholders to translate complex requirements into scalable BI solutions, embedding governance, lineage tracking, and compliance with enterprise data standards.
• Automated data quality assurance by integrating validation, reconciliation, and anomaly detection mechanisms within ETL pipelines, ensuring high data accuracy and reliability.