Yamini Madan

• Design, develop, and maintain scalable ETL/ELT data pipelines using Python, SQL, PostgreSQL, and Amazon Redshift to support enterprise data integration, transformation, analytics, and reporting workflows.
• Develop robust data ingestion, transformation, validation, and integration processes, ensuring data quality, consistency, accuracy, and reliable movement across enterprise applications and databases.
• Work across AWS cloud services and data platforms to evaluate and support scalable, resilient, and cost-efficient architectures for enterprise and federal government workloads.
• Contribute to the design of a high-volume AWS-based messaging architecture supporting 1M+ SMS notifications, incorporating asynchronous processing, queueing, retry logic, delivery-status tracking, monitoring, and failure-handling mechanisms.
• Evaluate SMS delivery approaches including 10-digit long codes, short codes, and AWS messaging services, analyzing scalability, reliability, operational requirements, and cost for large-scale government notification workloads.
• Develop cloud cost models and FinOps strategies across varying message volumes, supporting cost optimization, usage attribution, chargeback models, and financial reporting for AWS-based solutions.
• Implement and troubleshoot data integrations between Salesforce and enterprise data platforms, supporting CRM data synchronization, business workflows, and downstream analytics.
• Develop Salesforce automation solutions using Salesforce Flow Builder and Lightning App Builder, translating business requirements into automated and maintainable business processes.
• Write complex SQL queries and perform data analysis across PostgreSQL and Amazon Redshift to support data validation, transformation, troubleshooting, reporting, and business requirements.
• Integrate enterprise systems and applications using REST APIs, supporting automated data exchange and reliable communication between internal platforms and external services.
• Develop reusable Python-based data processing and automation workflows to reduce manual processes, improve data handling, and support scalable engineering solutions.
• Work with Power BI and SharePoint to support enterprise reporting, data accessibility, documentation, and business intelligence workflows.
• Research, evaluate, and recommend technical solutions for federal government technology initiatives, balancing scalability, security, reliability, maintainability, operational requirements, and cost.
• Collaborate with technical and business stakeholders to translate requirements into data engineering, cloud, integration, and automation solutions, participating throughout requirements analysis, solution design, development, testing, troubleshooting, and implementation.
• Create and maintain technical documentation, architecture diagrams, data-flow documentation, implementation recommendations, and process documentation to support engineering initiatives and knowledge transfer.
• Analyze existing processes and technical workflows to identify opportunities for automation, optimization, improved reliability, and operational efficiency.
• Apply Agile development practices, collaborating with cross-functional teams through requirements gathering, technical research, development, testing, issue resolution, knowledge transfer, and continuous improvement.
• Leverage Python, SQL, AWS, PostgreSQL, Amazon Redshift, Salesforce, REST APIs, Git/GitHub, Power BI, and enterprise integration technologies to deliver modern data and cloud solutions.
• Contribute to emerging Generative AI and Agentic AI initiatives, exploring AI-powered automation, intelligent problem solving, knowledge retrieval, and workflow optimization for government and enterprise use cases.
• Participate in the development and exploration of AI-powered problem-solving solutions, combining enterprise data, automation, cloud infrastructure, and intelligent agents to streamline complex business and government workflows.

Python | SQL | PostgreSQL | Amazon Redshift | AWS | ETL/ELT | REST APIs | Salesforce | Salesforce Flow Builder | Lightning App Builder | Power BI | SharePoint | Git/GitHub | Data Integration | Cloud Architecture | FinOps | Generative AI | Agentic AI

• Developed software applications using Java and Python, enhancing functionality and user experience.
• Implemented automated testing procedures, increasing reliability of software releases and reducing bugs.
• Conducted code reviews to ensure adherence to best practices and maintain high-quality standards.
• Collaborated with cross-functional teams to gather requirements and define project scope effectively.
• Participated in Agile ceremonies, contributing to sprint planning and retrospectives for continuous improvement.
• Debugged and resolved issues in existing applications, improving overall system performance and stability.
• Assisted in refining development processes, promoting efficiency across the software development lifecycle.
• Documented technical specifications and user guides to facilitate knowledge transfer among team members.
• Improved software efficiency by troubleshooting and resolving coding issues.
• Collaborated with cross-functional teams to deliver high-quality products on tight deadlines.
• Enhanced user experience through designing and implementing user-friendly interfaces.
• Participated in software field testing to verify performance of developed projects.
• Translated customer requirements into written use cases.
• Analyzed work to generate logic for new systems, procedures and tests.

• Conducted research and analysis to support product development initiatives.
• Coordinated with cross-functional teams to streamline communication processes.
• Participated in process improvement meetings, contributing ideas for efficiency enhancements.
• Assisted engineering team with project documentation and technical reports.
• Managed inventory tracking using ERP systems for improved accuracy and reporting.
• Supported staff members in their daily tasks, reducing workload burden and allowing for increased focus on higher-priority assignments.
• Gained valuable experience working within a specific industry, applying learned concepts directly into relevant work situations.
• Sorted and organized files, spreadsheets, and reports.
• Analyzed problems and worked with teams to develop solutions.
• Participated in workshops and presentations related to projects to gain knowledge.
• Explored new technologies and approaches to streamline processes.
• Prepared comprehensive reports summarizing data analysis findings, informing key decision-makers of important trends and patterns.
• Enhanced project visibility by maintaining up-to-date project status reports.
• Facilitated knowledge sharing by creating internal wiki for project guidelines.
• Conducted comprehensive market research to inform strategic planning.