Highlights:

Skills:

Data Engineer Intern 05/2024 - 12/2024
Bloom Insurance, Bloomington, Indiana United States
Industry: Insurance
Data engineer skilled in optimizing data pipelines, automating ETL workflows, and enhancing data processing efficiency. Reduced report generation time by 30% with dynamic stored procedures and improved data ingestion efficiency by 40% using SSIS. Designed robust database schemas and created Power BI/SSRS reports, driving a 20% improvement in decision-making. Experienced in automating workflows with Apache Airflow and ensuring seamless deployments with Redgate tools, delivering efficient data solutions and actionable business insights.
Engineered and optimized dynamic stored procedures to streamline complex data queries, reducing report generation time by 30% and enhancing data availability for analysis. Designed and implemented a new database schema with history tables to store daily incoming data, facilitating improved data availability for reporting and business insights. Developed and automated multiple ETL jobs using SSIS, creating robust workflows for daily data ingestion from shared folder files into the database, improving data processing efficiency by 40%. Created Power BI and SSRS reports to visualize historical and daily data, enabling the business team to extract actionable insights and monitor key performance metrics, leading to a 20% improvement in decision-making efficiency. Utilized Redgate tools to migrate SQL queries, stored procedures, and data across multiple environments, ensuring 100% version control accuracy and seamless deployments. Leveraged Apache Airflow to automate and schedule ETL workflows, increasing operational efficiency by 20% and reducing manual intervention in data processing.--
Software Engineer 06/2021 - 07/2023
Accenture, Mumbai, Maharashtra India
Accomplished professional with expertise in leading cross-functional teams, automation, and data processing optimization. Spearheaded a multi-vendor project, accelerating delivery by 20% within a Scrum framework. Reduced manual testing time by 67% with an advanced automation framework using Selenium, RestUtil, and Jenkins. Designed RESTful APIs with AWS Lambda, improving data accessibility by 15%, and optimized data pipelines with Apache Spark for 15% faster batch processing. Enhanced ETL QA accuracy and legacy system reliability, earning the Accenture Celebrates Excellence Award in 2022.
Spearheaded a cross-functional team within a Scrum framework, accelerating delivery of a multi-vendor project by 20%, consistently exceeding client expectations. Developed an advanced automation framework leveraging Selenium, RestUtil, Java, TestNG, and Jenkins, reducing manual testing time by 67% and improving deployment reliability by 45%. Designed and integrated RESTful APIs using AWS Lambda for serverless execution, improving data processing efficiency by 15% and enhancing data accessibility for client platforms. Built and optimized data pipelines using Apache Spark, increasing the speed and reliability of batch processing jobs by 15%. Enhanced ETL QA processes through sophisticated SQL queries for accurate Informatica workflow validations, reducing data discrepancies by 15% and improving workflow accuracy. Optimized legacy systems by refactoring code and developing comprehensive unit tests using JUnit, enhancing code quality and reliability. Recognized with the Accenture Celebrates Excellence Award (January 2022) for consistent high-performance delivery and exceeding client expectations.--

Mumbai University 08/2017 - 05/2021
Mumbai, Maharashtra, India
Degree: Bachelor's Degree
Major:Electronics and Telecommunication Engineering
.

Login to view resume: Nishan_Poojary_Resume -