Kiran Mishra

Dedicated Data & Transportation Analytics Lead with 12+ years of experience in data integration, business intelligence, and ETL engineering. Proven track record in analyzing freight spend, carrier performance, lane efficiency, and shipment metrics using Advanced SQL, Power BI, Excel, and Alteryx across logistics, banking, and healthcare operations.

Technical Lead / Data & Analytics Specialist at GE-Aerospace (2025-04 – 2026-07)

• Wrote complex SQL queries utilizing INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CTEs, and Window Functions to extract, aggregate, and validate large operational datasets.
• Designed and deployed automated ETL workflows in Alteryx and Python to streamline data ingestion, transit reporting, and multi-system data validation across AWS RDS Oracle and SQL Server.
• Developed reusable Alteryx macros and analytic apps to reduce pipeline run time and improve data reconciliation accuracy across operational dashboards.
• Scheduled daily and nightly automated extraction tasks using Python cron jobs and Alteryx Scheduler to maintain accurate staging and reporting data.
• Partnered with cross-functional business stakeholders to gather analytics requirements, define data models, and translate supply chain and operational needs into technical solutions.

Supply Chain & Logistics Data Analyst / Power BI Analyst at Tradefull (2023-05 – 2024-08)

• Analyzed transportation, carrier, and warehouse fulfillment datasets for an eCommerce fulfillment facility handling tens of thousands of daily shipments.
• Engineered SQL queries leveraging CASE statements, CTEs, Window Functions, and JOINs to combine carrier, shipment volume, freight cost, customer, and lane operational datasets.
• Developed and delivered interactive Power BI dashboards to track key performance metrics, including freight spend, carrier performance, shipment volumes, transit times, lane performance, and return analysis.
• Applied Advanced Excel techniques (PivotTables, XLOOKUP, conditional calculations) and Power Query to perform ad-hoc freight cost analysis and identify cost-saving opportunities.
• Configured Row Level Security (RLS) and managed security roles in Power BI Service to ensure appropriate access controls for partners and executive leadership.
• Set up automated data refreshes via Power BI Dataflows and Datamarts to ensure continuous visibility into daily operational and shipment KPIs.

Sr. Data & SQL Engineer / Technical Lead at Huntington National Bank (2018-05 – 2023-02)

• Served as Technical Lead for data integration and database migration projects, converting SQL Server structures into Azure Snowflake.
• Executed advanced SQL scripts and DBT transformation models to ingest data from staging layers to final production analytical views.
• Created source-to-target mapping documents and high/low-level technical design specifications for multi-source data integration pipelines.
• Performed deep data validation, root-cause analysis, and performance tuning on complex analytical queries and automated pipelines.

ETL Developer Lead at United Health Group (2014-08 – 2018-05)

• Led end-to-end data pipeline design, extraction, and transformation processes using IBM InfoSphere DataStage and relational databases (Oracle, DB2).
• Built data validation, address verification, and automated notification logic to maintain data quality standards.

Bachelor of Science in Information Technology – Sikkim Manipal University (2007)