Akshay Shankar is a seasoned Data Engineering professional with 9 years of experience in Data Analysis and Data Engineering. Currently, he leverages his expertise in PySpark and Azure Databricks to deliver innovative data solutions for top-tier clients, including major multinational investment banks.Professional Experience:Investment Banking Client: Specialized in reconciling data extracts from IBM Db2 to Salesforce using PySpark and Azure Databricks, ensuring data integrity during migrations.Investment Banking Client: Led a team in generating data pipelines for Financial Regulatory reports (BE 12, BE 15), gathering requirements, implementing business logic in Azure Databricks, automating processes with PySpark, and creating incremental data load pipelines using Azure Data Factory.American Asset Management Company: Decommissioned mainframe applications, rebuilding systems on distributed platforms to reduce maintenance and hardware costs.Major US Bank: Developed logic to identify populations impacted by system issues, such as incorrect loan rates or refunds, conducting time variance analysis for calculating remediation amounts.Financial Services Client: Analyzed fraud and settlement data using Hive and PySpark, creating Tableau dashboards to provide insights into fraud performance, identifying segments with fraud savings opportunities.Core Competencies:Data Ingestion: Creating robust ETL pipelines for diverse data sources.Data Storage and Processing: Designing scalable data storage solutions using technologies like Apache Spark and Databricks.Data Modeling and Governance: Defining data structures, ensuring accurate data integration and governance, with knowledge in SCD Type 2.Data Security and Compliance: Managing data securely in compliance with industry standards and regulations.Technical Skills: Azure Databricks, Apache Spark, Python, SQL, Azure Data Factory, Azure Data Lake, Azure Key Vault, GIT/GITHUB, Tableau, Agile, Hive, MySQL DBAchievements:-Led a team to generate end-to-end data pipelines for financial regulatory reports.-Spearheaded mainframe application decommissioning, reducing costs.-Developed robust data reconciliation logic for a major migration project.Future Goals:Akshay aims to build efficient, scalable data systems that drive informed decision-making and strategic growth. His problem-solving skills, perseverance, and continuous learning mindset make him a valuable asset to any data engineering team.