SAI AKSHITHA BOKKA
NC
Summary
Adept Data Engineer with proven expertise in developing robust data pipelines and enhancing data processing efficiency at renowned companies like Fannie Mae. Leveraged skills in Python, SQL, Tableau and Power BI to automate and optimize data workflows, demonstrating strong analytical capabilities and a commitment to driving business insights through data. Highly organized and detail-oriented worker, with a drive to exceed expectations. Ability to analyze data, develop strategies, and provide solutions to complex problems. Seeking to leverage skills and knowledge to contribute to team success.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Engineer Intern
Fannie Mae
07.2023 - 12.2023
- Collaborated with Data Scientists and Business Analysts at Fannie Mae to gather requirements and understand data needs, ensuring alignment with the organization's data quality standards and regulatory requirements
- Developed and optimized ETL pipelines to extract, transform, and load data from various financial sources into Fannie Mae's data warehouses, enhancing data processing efficiency and integrity
- Assisted in designing and implementing data models that supported both real-time financial analytics and batch processing, utilizing tools like SQL, Python, and Apache Spark
- Conducted data cleansing and validation activities to maintain the accuracy and consistency of financial data across multiple databases and data lakes
- Monitored data pipeline performance and implemented error-handling mechanisms, ensuring seamless data flow and minimizing downtime in Fannie Mae's critical data processes
- Utilized cloud-based data services such as AWS S3, Redshift, and Glue to manage and scale data storage and processing tasks in Fannie Mae's cloud environment
- Automated data processing tasks using Python scripts and Apache Airflow, reducing manual effort and increasing efficiency in data operations
- Documented data flows and pipeline architecture to facilitate knowledge sharing within Fannie Mae's data engineering team, ensuring smooth handover of tasks and continuity
- Participated in code reviews and debugging sessions to enhance the quality of Fannie Mae's data engineering codebase, addressing issues promptly and improving overall system robustness
- Supported the implementation of data security measures, including encryption and access control, to protect sensitive financial information in compliance with Fannie Mae's security policies
- Created multiple workbooks, dashboards, and charts using calculated fields, quick table calculations, Custom hierarchies, sets & parameters to meet business needs using Tableau
- Integrated Tableau with various data sources, including SQL databases, cloud storage (AWS S3), and Excel, to provide comprehensive data insights and reporting capabilities
- Developed and managed Tableau data extracts to optimize dashboard performance and reduce load times for end-users.
Data Engineer
Accenture
08.2021 - 07.2022
- Architected and built multiple data pipelines, managing end-to-end ETL and ELT processes for data ingestion and transformation within Google Cloud Platform (GCP)
- Possess a solid understanding of AWS components, including EC2 and S3, for efficient cloud computing and storage solutions
- Created and optimized both simple and complex SQL scripts to validate data flow across various applications
- Conducted data analysis, migration, cleansing, transformation, integration, and managed data import/export processes using Python
- Developed and deployed data pipelines in cloud environments such as AWS and GCP, ensuring seamless data flow and integration
- Executed data engineering tasks, including data extraction, transformation, loading, and integration, to support enterprise data infrastructures such as data warehouses, operational data stores, and master data management systems
- Oversaw data services and data movement infrastructures, leveraging extensive experience in ETL concepts, solution development, and data modeling
- Established and managed dedicated workspaces for each project on Power BI Service, ensuring seamless publication of reports from Power BI Desktop to their respective service workspaces
- Leveraged Power BI to design and develop diverse analytical dashboards, enabling business users to swiftly gain insights from the data
- Installed and configured Data Gateway to automate the data refresh schedules for Power BI reports, ensuring up-to-date information for users.
Education
Master of Science in Management and Information Systems -
Southern Illinois University Edwardsville
Edwardsville, Illinois05.2024
Bachelor of Technology, Information Technology -
Bhoj Reddy Engineering College
Hyderabad, Ts05.2021
Skills
- Power BI
- Tableau
- Microsoft Excel
- Python
- Java
- C
- HTML/CSS
- JavaScript
- SQL
Certification
- AWS Cloud Practitioner Certified
- Microsoft Power BI Certified
- Microsoft Azure Fundamentals
- Azure SQL Fundamentals
Coursework
- Data Structures
- Software Methodology
- Algorithms Analysis
- Database Management
- Artificial Intelligence
- Information Technology
- Cloud Management
- Software System Design
Projects
- Healthcare Analytics Dashboard Project (Power BI, SQL): Developed a comprehensive Power BI dashboard to monitor patient outcomes, hospital performance, and resource utilization using Power BI, Created visualizations including patient flow charts, treatment efficacy graphs, and resource allocation tables., Integrated data from multiple sources, enhancing data reliability and depth of analysis using Power Query and SQL., Designed dynamic, interactive reports using Power BI, providing actionable insights for healthcare administrators.
- Email Client Software Project (Java): Developed an email client software using Java for secure email transactions., Implemented SMTP and POP3 protocols for secure email communication., Configured ISP's mail servers for reliable email sending and receiving.
- Personal Budget Tracker (HTML, CSS, JavaScript, SQL, Microsoft Excel, Power BI): Created a responsive web application using HTML, CSS, and JavaScript for the frontend to provide a user-friendly interface for budget tracking., Created data visualizations using Microsoft Excel and Power BI to provide users with clear insights into their spending patterns and financial summaries., Developed features for users to input, categorize, and track their expenses and income, along with the ability to set budget limits and goals.
- Cloud-Based E-commerce Platform (AWS, Java, Spring Boot, SQL):Designed and implemented the architecture of a scalable e-commerce platform using AWS services to ensure high availability and performance., Developed backend features including user authentication, product catalog management, and order processing using AWS EC2 instances.
Timeline
Data Engineer Intern
Fannie Mae
07.2023 - 12.2023
Data Engineer
Accenture
08.2021 - 07.2022
Master of Science in Management and Information Systems -
Southern Illinois University Edwardsville
Bachelor of Technology, Information Technology -
Bhoj Reddy Engineering College
Similar Profiles
VENKAT CHITTEPUVENKAT CHITTEPU
Sr. Product Manager - Finance Technology at Fannie MaeSr. Product Manager - Finance Technology at Fannie Mae
Moses Judson Edward Sundaram Ananthajothi BalanMoses Judson Edward Sundaram Ananthajothi Balan
Senior Technical Architect at Fannie MaeSenior Technical Architect at Fannie Mae
MARCUS COLEMARCUS COLE
Director, Program Management, Strategic Partnerships & Workforce Strategy at Fannie MaeDirector, Program Management, Strategic Partnerships & Workforce Strategy at Fannie Mae