Aryan Singh – Data Analyst | Public Profile on Dr.Job

About Me

My career goal is to apply my software engineering expertise, analytical abilities, and advanced technologies to drive meaningful decision-making for an improved digital future.

Experience

Data Analyst

BELL, Mississauga, ON

Sep 2023 - Present · 2 years 10 months

Demonstrated exceptional expertise in SQL/PLSQL and Python to extract, analyze and transform data into useful insights from large data stores (SAP & Oracle)
Wrote several complex PLSQL routines on Oracle and Python code to reduce overall manual efforts in ETL
Actively involved in database maintenance to improve data read-write performance and debugging bottlenecks
Implemented PowerBI to create interactive dashboards and revenue reports essential for business operations
Developed Python tools to read and import Excel files into databases

Software Developer Intern

CAP SPECIALTY INSURANCE, Vaughan, ON

May 2022 - Aug 2022 · 3 months

Collaborated with a team of experienced full-stack web developers to develop the company's web applications in an agile environment, utilizing Java, PHP, SQL, HTML/CSS, JavaScript, jQuery, AWS
Developed automation tools to reduced manual data entry
Leveraged parallel process within the tool to increase the upload speed of large files
Worked extensively with MySQL database, focusing on SQL, writing complex queries and procedures

Skills

Python SQL Database Data Science JavaScript Machine Learning Algorithms React.js PL/SQL Linux OS Java C# PHP C/C++ JavaScript HTML/CSS SQL T-SQL PLSQL AWS Lambda CloudFront S3 API Gateway Route 53 DynamoDB JWT Auth Tokens Azure Docker Kubernetes Databricks PySpark Glue Data Factory Pandas Matplotlib Spring Hibernate React Node.js Django Power BI Excel Power Query Power Pivot MySQL PostgreSQL Oracle SQL Server MongoDB Cosmos DB TensorFlow Keras Machine Learning LSTM Dropout Early Stopping jQuery Agile