Niharika Mandada

adzp6j@r.postjobfree.com +1-618-***-**** www.linkedin.com/in/niharika-mandada

SUMMARY

Detail-oriented Data Engineer with a proven track record in data migration, analysis, and reporting using a variety of tools including SQL, Cognos, Tableau, and Big Data technologies. Adept at gathering and analyzing business requirements, developing data solutions, and ensuring accurate data mapping. Proficient in SQL query optimization, ETL processes, and data visualization. Strong knowledge of Microsoft Excel, Power point and people soft

EDUCATION

Wilmington University, Delaware May 2023

Master of Science in Information Technology

KL University, India May 2020

Bachelor of Business Administration

SKILLS & ABILITIES

Languages: Python, Java

Database: MySQL, MongoDB

Data Modeling: Tableau, Power BI

Technologies and concepts: Azure Databricks, Agile, SSAS, SQL Server Data Tools, SDLC, Git

WORK EXPERIENCE

Data Engineer Intern (Azure Databricks, Agile, SDLC, ETL, SQL) Jan 2023 – May 2023

IT Induct, TX

•Involved in data testing by running intricate SQL queries to verify that data was accurately transformed and loaded (ETL).

•Employed SQL queries within Azure Databricks to aggregate, cleanse, and enrich data, facilitating effective data transformations.

•Worked on data mapping and profiling, using SQL to identify data relationships and discrepancies to ensure data accuracy.

•Worked in agile environments, participating in sprint planning, stand-ups, and retrospectives to deliver timely and valuable data solutions by following the SDLC practices.

•Collaborated with senior engineers to design and implement ETL pipelines, transforming raw data into actionable insights using Azure Databricks.

•Worked with business analysts and developers to translate user stories into technical specifications and providing solutions to stakeholders.

Data Analyst (Azure Databricks, Python, Kafka, Tableau, Power BI, SSAS, SQL) July 2020 - July 2021

Etico Life Sciences, India

•Utilized Python libraries and frameworks for data manipulation, transformation, and cleansing to ensure data accuracy and quality.

•Skilled in creating impactful presentations using Microsoft excel and Power point.

•Created data visualizations using Tableau/Power BI, enabling stakeholders to make informed decisions.

•Demonstrated expertise in Kafka, designing and implementing data streaming solutions to enable real-time data processing and analysis.

•Collaborated with cross-functional teams to identify data-driven opportunities for process improvement.

•Played a role in the data migration, assisting in project planning, execution, and monitoring to ensure successful outcomes.

•Facilitated communication between technical and non-technical stakeholders to improve project understanding and alignment.

•Employed SQL queries within Azure Databricks to aggregate, cleanse, and enrich data, facilitating effective data transformations.

•Created a sales analysis cube using SSAS to provide valuable insights into our company's sales data.

•Contributed actively within a multidisciplinary team environment, participating in task projects, and showcasing the ability to work collaboratively.

•Participated in code reviews, providing constructive feedback, and ensuring adherence to coding standards and quality.

•Assisted with writing effective user stories and divide the stories into SCRUM tasks.

ACADEMIC PROJECTS

E-Commerce Application ( Python, HTML, MySQL)

•Developed a web application that helps users find the businesses around them and make a bulk order.

•Developed a multi-role database model and designed a middle tier API for securing the application.

•Used sessions and cookies to create a seamless shopping experience for users.

Library Management system (Python, HTML, MySQL)

•Designed and implemented a comprehensive Online Library Management System as a team project.

•Created a relational database schema and normalized tables to store book information, user details, borrowing records, and administrative data.

Contact this candidate