Data Engineer Sql Server

(Open to relocate anywhere in the US)

Aishwarya Belekar ********@***.*** / +1-602-***-****

https://aishwaryabelekar.github.io/

https://www.linkedin.com/in/aishwaryabelekar

Career Summary

Passionate and results-driven Data Engineer and Analytics Specialist with expertise in designing data solutions, optimizing ETL pipelines, and conducting comprehensive analysis. Skilled in advanced reporting and leveraging predictive models to drive operational excellence and informed decision-making within dynamic environments. Proven track record in automating processes, enhancing data efficiency, and translating complex business needs into technical specifications Work Experience

•

Data Engineering Co-op Aug 2023 - Present

Rocket Mortgage - Phoenix, AZ

Utilized Power BI Report Builder and SQL Server to automate file group space management and create a dashboard summarizing server status for the data warehouse platform, ensuring proactive alerts and optimal storage utilization forecasting

Leveraged Azure DevOps for team planning and project management, enhancing collaboration and workflow efficiency. Modified existing stored procedures in SQL Server to facilitate the full data warehouse platform migration from Quicken Loans to Rocket Mortgage

•

Graduate Teaching Assistant - Advanced Big Data & DBMS Jan 2023 - May 2024 Arizona State University - Tempe, AZ

Led the orchestration of a comprehensive machine learning environment utilizing Scala for Databricks, achieving course objectives, and optimizing AI model management effectively

Oversaw the implementation of MongoDB and NoSQL databases in Big Data and Hadoop ecosystems, contributing to the academic success of over 300 students in the ”Big Data Analytics” course

•

Data Science Intern - Fraud Analytics May 2023 - Aug 2023 LexisNexis Risk Solutions - Alpharetta, GA

Spearheaded the development and implementation of anAutomatedDailyRegressionMonitoringDashboardthatenabledreal-time insights into daily performance, resulting in an 80% reduction in manual data visualization efforts using Microsoft Power BI, Kibana, Python, ECL, and HPCC

Performed advanced data analysis using SQL and Python to uncover actionable insights, driving strategic decision-making for business growth.

•

Business Intelligence Developer - Data Engineering & Advanced Analytics Jun 2020 - Jul 2022 Torm Shipping - Mumbai, India

Developed high-performance multidimensional OLAP cubes for the Performance team and provided them real-time Power BI dashboard to monitor tanker performance, helping the business achieve its goal of reducing Sulphur Emission levels by 1% YTD

Executed project roadmaps leveraging C# and Python to extract and load data via REST APIs in CSV/JSON format, modifying ETL packages, and automated the process by making a time-triggered bot

Created Robotic Process Automation (RPAs) involving web scraping, OCR, and various alerts, resulting in daily time savings of 1-2 hours per vessel and cost reductions of $500 per vessel using Python, T-SQL, Tableau, and Power Automate

Tracked and reported on KPIs to monitor the success of key initiatives, providing actionable insights to leadership and payment team leaders. Worked closely with clients, Subject Matter Experts (SMEs), and leadership to intake problem statements, define solution frameworks, and deliver analytical solutions

Used SQL Server Wizard to deploy over 100 ETL pipeline solutions to production using bat files and one-click deployment, streamlining the deployment process through CI/CD best practices. Deployed over 150 SOX Compliant reports using SSRS over SharePoint to further automate the reports for visibility to upper management

•

Software Development Intern Jun 2019 - Aug 2019

Tata Consultancy Services - Mumbai, India

Developed a cutting-edge typing test program to assess candidate proficiency, capturing and analyzing responses for detailed metrics on correct/incorrect words typed. Optimized the hiring process by 40%, streamlining candidate evaluation and selection

•

Research and Development Intern Jun 2018 - Aug 2018 IIT Bombay - Mumbai, India

Executed the end-to-end design, development, and testing of an innovative Digital Learning platform, fostering significant economic growth in rural areas by successfully facilitating skill development for over 10,000+ users SKILLS

• Technical Skills: Python, C++, SQL, C#, NodeJS, HTML, CSS, DAX, Git, Kafka, Scala, Spark, Bash, VMWare

• Tools & Technologies: SSMS, SSIS, Postman, UiPath, PowerBI, SSRS, VS Code, Docker, Tableau, AWS (EC2, EBD, RDS, S3), Power Apps, SAP, Snowflake

• Databases: MS SQL Server, NoSQL (MongoDB, Cassandra, DynamoDB), Amazon RDS

• Microsoft Azure Services: Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure SQL Database, Azure Blob Storage

• Soft Skills: Problem-Solving, Collaboration, Adaptability, Attention to Detail, Time Management CERTIFICATIONS

• Microsoft Certified: Azure Data Engineer Associate:

• AWS Academy Graduate: AWS Academy Cloud Architecting :

• openSAP: Generative AI at SAP:

Projects

• Voice based E-mail for the Visually Impaired: Executed the design and deployment of an innovative solution, employing Speech-to-Text and Text-to-Speech technologies in the .NET framework, resulting in impactful outcomes.

• An IoT-based Weather Monitoring System: Implemented with 10–12 nodes, utilizing Raspberry Pi and AWS that Enabled real-time global monitoring and alerts through RESTful web services, enhancing weather data accessibility.

• Machine Learning Research Assistant - Military UAV Dynamics, ASU: Led UAV simulator research at ASU, integrating Artificial Intelligence to analyze and optimize teamwork dynamics. Designed and implemented data collection protocols to gather relevant data points, focusing on mitigating challenges related to uncertainty and teammate interdependency. Conducted time series analysis to identify trends and patterns in UAV mission geospatial data to enhance predictive accuracy and spatial understanding

Education

•

Arizona State University - Master of Science Aug 2022 - May 2024 Information Technology - Information Systems Management CGPA: 4.0/4.0

•

SNDT Women’s University - Bachelor of Science Aug 2016 - May 2020 Computer Science and Technology - Data Science CGPA: 3.4/4.0

Contact this candidate