Harisha Karunakarashetty

Client: Apple Inc.

• Led the team in migrating a 200 TB data warehouse from Teradata to Snowflake, reducing query times by 40% and operational costs by 30%.
• Migrated and developed a big data solution using AWS EMR, Glue, S3, and PySpark for efficient Apple Services usage data processing from the legacy HDFS and Hive on-premises ecosystem.
• Engineered a Python-based query engine with asynchronous execution capabilities, reducing data processing time by 30%.
• Implemented data quality metrics using Streamlit, enhancing anomaly detection in Apple's media product usage data.
• Designed and deployed ETL processes using Apache Airflow, improving job reliability by 25%.
• Developed a modular ETL framework, reducing code redundancy by 35%, and enhancing maintainability.
• Spearheaded the integration of APIs and third-party services to enhance system functionality.
• Collaborated with stakeholders to understand business challenges and propose technical solutions.
• Analyzed business processes and identified opportunities for automation or optimization.
• Coordinated with teams across multiple departments to ensure successful integration between systems.

• Led database migration from SQL Server to Snowflake for Prime Therapeutics, resulting in 50% faster data processing
• Worked closely with Project Team, SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications
• Designed and implemented a supply chain data model in Vertica for AT&T's reverse logistics, improving data accuracy by 20%
• Developed ODI ELT transformation packages for USAA's EFP data warehouse, enhancing data integration efficiency by 35%
• Created an Enterprise stress testing (EST) data load process, reducing testing cycle time by 40%
• Inducted data from Oracle, SQL Server, Flat files and transformed data using Informatica power center to Teradata
• Managed and optimized Truist Forecasting System in Oracle, reducing processing time, improving data integrity, and enhancing customer satisfaction
• Automated various tasks with Shell and Python scripts, resulting in significant time savings and error reduction
• Implemented Teradata BTEQ-based reporting to analyze Anthem insurance subscriber data, improving revenue calculations and estimations
• Created documentation for data architectures, database schemas, processes, standards and good practices
• Led offshore team to translate intricate business requirements into technical specifications, ensuring seamless alignment with client objectives and boosting client satisfaction

• Optimized Oracle 11g database performance, resulting in a 25% reduction in query execution time
• Developed advanced PL/SQL programming solutions for complex MIS reports, improving report generation speed by 30%
• Implemented data validation frameworks, reducing data discrepancies by 45%
• Worked extensively on Oracle APEX report building for the Oracle University Customer support need which automated 90% of manual data handling processes