Bhargavi Mardala

worked on designing and delivering cloud-native data and AI solutions to enhance student services and analytics capabilities. I led the development of an AI-powered chatbot using AWS Bedrock, Amazon Lex, Kendra, Lambda, and S3, improving student support efficiency by 40%. My role included building serverless ETL pipelines with AWS Glue and Lambda, designing and optimizing Amazon Redshift schemas and SQL for analytics and cost management, and automating infrastructure using AWS CloudFormation. I also implemented secure cloud architectures using IAM, VPC, and KMS, applied prompt engineering with Claude 3.5 Sonnet to improve response accuracy, and integrated enterprise search with Amazon Kendra. In addition, I served as Scrum Master, leading Agile ceremonies, coordinating cross-functional teams, and ensuring timely delivery of project milestones

At The Hartford, I worked as a Data Warehouse Developer supporting Automobile and Homeowner Insurance domains, delivering enterprise-scale data pipelines for policy, claims, and underwriting analytics. I led end-to-end ETL development using Informatica PowerCenter, IICS, SQL, and PL/SQL, translating business requirements into scalable data models and analytics-ready datasets across Oracle, Snowflake, and Hive. My role included implementing data quality controls, optimizing batch and incremental loads, and collaborating with DBAs to improve database performance and production stability. I partnered closely with analysts, QA teams, and business stakeholders to deliver reusable data assets, supported production workflows using AutoSys, and managed releases using Azure DevOps and GitHub. I also contributed in an Agile environment, mentored junior developers, maintained documentation in SharePoint, and provided on-call production support to ensure reliable data delivery.

At BNY Mellon, I worked as an ETL Developer/Analyst supporting financial reconciliation and compliance processes. I designed and maintained daily reconciliation workflows using Informatica PowerCenter and Smartstream TLM, ensuring accurate and timely processing of high-volume financial transactions. My role involved building complex ETL mappings and parameterized workflows, developing and tuning advanced SQL and PL/SQL queries, and delivering audit-ready reporting using Crystal Reports. I automated ETL orchestration and monitoring with UNIX shell scripting, provided Level-2 production support for critical applications, and helped maintain high system availability. I also supported CI/CD deployments using Jenkins, GitHub, and SVN, collaborated closely with business analysts and stakeholders to translate business rules into scalable ETL solutions, and contributed to documentation, audits, and mentoring junior developers.