LAKSHMI MULLAPUDI
Data Engineer
Naperville,IL
Summary
Detail-oriented Data Engineer designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models. Proficient at developing database architectural strategies at the modeling, design and implementation stages.
Overview
5
5
years of professional experience
Work History
Data Engineer
BNY MELLON
02.2023 - 03.2024
- Leveraged Python scripting for data extraction, transformation, and loading (ETL), streamlining migration workflows and optimizing data compatibility between SQL Server and AWS.
- Developed data-driven reports and dashboards using Tableau, presenting insights to the leadership team.
- Implemented robust data quality checks and orchestrated data workflows using AWS Glue, Lambda, and Data Pipeline to ensure accuracy, real-time processing, and timely delivery.
- Utilized Redshift for Extract, Load, and Transform (ELT) processes, handling big data from heterogeneous sources like AWS S3, APIs, and Teradata.
- Contributed to developing data lake architectures in S3 and Power BI dashboards, aligning with organizational goals and standards.
- Utilized Agile and SDLC methodologies to deliver continuous integration/continuous delivery (CI/CD) pipelines, integrating tools like Jenkins and AWS for VM provisioning.
- Developed automated processes for code builds and deployments using Python scripting.
- Designed event-driven architectures to automate data processing tasks based on incoming data streams.
SQL Server DBA
Metamor Software Solutions
04.2019 - 06.2021
- Coordinated cross-functional database projects with agile methodologies and tools like Jira, ensuring timely delivery and budget compliance.
- Facilitated effective communication among internal and external stakeholders to align project goals and manage expectations.
- Identified and implemented database optimization best practices to enhance efficiency and performance using SQL Server optimization techniques.
- Extracted data from various operational systems including flat files, spreadsheets, and RDBMSs such as SQL Server.
- Conducted and automated ETL operations to extract data from multiple sources, transform inconsistent and missing data into consistent and reliable formats, and load it into the multi-dimensional data warehouse.
- Assisted in deploying SSRS reports on the SharePoint Portal
- Proactively managed database-related risks, developing mitigation strategies to minimize impact on project timelines and deliverables.
- Fostered collaboration within the team, participating in initiatives and training programs to enhance SQL Server, Power BI, and database administration skills.
- Implemented BI solution framework for business intelligence projects.
Education
Bachelor of Science - Computer Science
Shri Vishnu Engineer College For Women's
Bhimavaram, India05.2020
Skills
- Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS), SQL Server Data Tools
- ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)
- Reporting Tools: SQL Server Reporting Services, MS Access, MS Excel
- Database: MS SQL Server, MS Access, Oracle, DB2 iSeries, MariaDB
- Programming: T-SQL, PL-SQL, C, C#
- Web Technologies: HTML, DHTML, Java Script (Validation), CSS, ASPNET
- Operating Systems: Windows, Windows Server, Windows XP, Windows Vista, Windows 7
Self Motivation
NoSQL Databases
Written Communication
Relationship Building
Adaptability
SQL Programming
Data Migration
Timeline
Data Engineer
BNY MELLON
02.2023 - 03.2024
SQL Server DBA
Metamor Software Solutions
04.2019 - 06.2021
Bachelor of Science - Computer Science
Shri Vishnu Engineer College For Women's