Power Bi Data Engineer

Education

University of North Carolina Charlotte, USA

Master of Science in Computer Science

Vellore Institute of Technology Chennai, India

Bachelor in software engineering

Career Objective

I’m a data analyst with a strong foundation in data analysis and seeking a role that will allow me to gain valuable experience on my journey to becoming a data engineer. My goal is to work in a position where I can build upon my existing skills and knowledge while contributing to the development and management of data systems and to make a meaningful contribution to the world of data technology by becoming a proficient data engineer.

Experience

Infoville Solutions Pvt Ltd Jan 2019 – Dec 2021

Roles and Responsibilities:

• Designed, built, and maintained Power BI data visualization dashboards that helped business users make decisions based on key metrics and performance measures.

• Developed code and scripts in PySpark for acquisition and transformation from different sources.

• Implemented Spark using Python in Databricks utilizing Data Frames and Spark-SQL API for faster Processing of data.

• Monitoring the Spark Jobs in the cluster environment debugging for the failed jobs.

• Managed worksheets using the manual and automated processes on the Power BI development server.

• Preparing dashboards using calculated fields, parameters, groups, sets, and hierarchies in Power BI.

• Worked with key business data to understand and analyze the customer data, Created Visualizations in Power BI using Excel, and SharePoint data.

• Utilized Power BI and custom SQL features to create dashboards and identify correlations. Extensively used SQL for accessing and manipulating database systems.

• Facilitated the overall management of the project including mitigation, status reports, client presentations, defining milestones, and deliverables, and establishing critical success factors.

Academic Projects

Automated Data Backup:

• Designed and implemented a Python-based automated data backup solution using AWS Lambda, AWS S3, and CloudWatch Events.

• The project involved creating a scheduled backup system that securely backed up files or databases to AWS S3, ensuring data reliability and availability.

• Demonstrated strong automation skills, proficiency in AWS services, and the ability to streamline critical data management processes.

• Implemented data encryption and access control mechanisms to enhance the security of the backed-up data, ensuring compliance with data protection standards. Sales and Revenue Dashboard:

• Developed an advanced Power BI dashboard for real-time tracking of sales performance and revenue trends. Imported and integrated sales and revenue data from various sources into Power BI for analysis.

• Created visualizations, including line charts, and KPI cards to represent essential metrics such as total revenue, sales by product, and monthly sales trends.

• Utilized power BI’s AI capabilities to generate insights and recommendations from the data, providing actionable information.

• Published the dashboard in the Power BI service, considering data security measures to control access to sensitive information.

Python

SQL

MySQL

MongoDB

AWS

VISUALIZATION

Power BI

FRAMEWORK AND

LIBRARIES

NumPy

Pandas

Matplotlib

OPERATING SYSTEMS

Windows

Linux

GIT

Excel

Visual Studio Code

OTHER SKILLS

Hadoop and spark

Contact this candidate