Sai Charan Anumolu

• Results-driven Data Engineer with 3+ years of experience in ETL development, database optimization, and real-time data integration. Proficient in AWS Glue, Redshift, Lambda, and Airbyte, designing scalable ETL pipelines for seamless data ingestion, transformation, and validation. Optimized Redshift performance through indexing, partitioning, and query tuning, enhancing data retrieval speed.
• Developed a real-time email synchronization system for Twenty CRM, integrating webhooks, OAuth authentication, and historical email processing. Built custom ETL workflows to process diverse datasets across Snowflake, PostgreSQL, and Airtable. Strong expertise in SQL, stored procedures, and advanced data transformations to drive analytics and reporting.
• Collaborated with cross-functional teams to enhance data quality, governance, and compliance, delivering efficient, high-performance data solutions. Experienced in AWS services such as Glue, Redshift, Lambda, Step Functions, CodePipeline, and CloudWatch, ensuring scalability, security, and automation in cloud-based data architectures.

Successfully integrated email data into the Twenty CRM tool, enabling seamless ingestion and synchronization of business communications. Designed a UI-driven onboarding platform for secure Google account connections and automated sync management, improving user experience and adoption. Engineered a real-time email ingestion pipeline using webhooks, n8n, and Windmill, significantly reducing latency in syncing new emails. Additionally, implemented historical email synchronization, ensuring businesses had complete and structured access to past communications. This solution enhanced data reliability, reduced manual intervention, and streamlined CRM workflows, enabling better business insights and decision-making.

 Software Developer Intern

 SysPro IT Solutions, Duluth, USA                                                          September 2023 - November 2023

• Worked on Enhancement requests, Defects, and User stories as a developer in an agile methodology project.
• Resolved metadata issues within ETL processes, ensuring accurate and consistent data integration.
• Implemented incremental ETL, addressing, and resolving bugs related to incremental processes. Conducted thorough testing of incremental refresh loads to ensure accuracy and reliability.
• Monitored and addressed failed SQL Server jobs by analyzing logs and identifying root causes, implemented retry mechanisms within Azure DevOps pipelines to automatically rerun failed SQL Server jobs, improving overall pipeline robustness.
• Engineered ETL pipelines, including Azure DevOps pipelines, to execute and manage data transformations. Implemented Continuous Integration/Continuous Deployment (CI/CD) practices to ensure the seamless and efficient integration of information.
• Configured Azure DevOps release pipelines to deploy SQL Server database changes across different environments, maintaining consistency and reliability.
• Implemented Snowflake as a data warehousing solution, designing and implementing ETL processes to extract, transform, and load data seamlessly into Snowflake, ensuring high performance and reliability.
• Integrated Python and Scala scripts into Azure Data Factory (ADF) pipelines, enabling seamless orchestration and execution of complex data workflows across hybrid environments.

 Software Developer Intern

 Merit American Technologies Inc, Irving, USA                                              February 2024 - May 2024

• Implemented SSIS components such as Lookup, Merge Join, Conditional Split, and Derived Column to enhance data processing and quality
• Conducted database performance analysis on SQL Server, implementing effective indexing strategies to improve query execution times
• Managed ETL processes using traditional tools like SSIS alongside modern tools, ensuring effective integration, analysis, and validation of data
• Utilized Variables and Parameters within SSIS packages to enable dynamic data transformations and process customization
• Created Stored Procedures, Functions, and Packages to streamline ETL workflows and improve data processing efficiency
• Designed and generated SSRS reports for key performance indicators (KPIs), facilitating data-driven decision-making
• Integrated Power BI with existing SSIS packages to provide dynamic, interactive data visualizations that support business intelligence needs.

• AWS Certified Data Engineer – Associate - Amazon Web Services (AWS).
• Microsoft Certified: Azure Data Engineer Associate