Ajay

Ajay

Data Analyst
Canada

About Me

Highly skilled and analytical Data Analyst with extensive experience in data analysis, data validation, and database management seeking to leverage expertise to improve business decision-making and operational efficiency…

Experience

Data Analyst

DnT Infotech
Aug 2019 - Present · 6 years 11 months

Analyzed thousands of data points for the portfolio data of India's leading banks.
•Created PL/SQL Blocks, Procedures, Functions, and Packages, using database-supplied packages of application data.
•Handled complex SQL statements for data validation, troubleshooting, and implementation of custom business processes.
•Perform root-cause analysis on data issues and drive implementation for remediation.
•Used strong analytical skills for writing relational database solutions for fintech business requirements. •Mapping and Loading source data into the database using ETL
•Design and develop automated frameworks in SQL for testing the integrity of application data, data flow and ETL.
•Identify tasks that can be automated and improve the system's performance which results in minimum level of manual interference from the team for its working.

Data Analyst

DnT Infotech LLP, Ahmedabad, India
Aug 2019 - Jan 2022 · 2 years 5 months

Analyzed thousands of data points for the portfolio data of India's leading banks.
Created PL/SQL Blocks, Procedures, Functions, and Packages, using database-supplied packages of application data.
Handled complex SQL statements for data validation, troubleshooting, and implementation of custom business processes.
Performed root-cause analysis on data issues and drove implementation for remediation.
Used strong analytical skills for writing relational database solutions for fintech business requirements.
Mapped and loaded source data into the database using ETL.
Designed and developed automated frameworks in SQL for testing the integrity of application data, data flow, and ETL.
Identified tasks that could be automated and improved the system's performance, resulting in minimum manual interference from the team.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Database Management Statistical Data Analysis Pattern Identification Trend Identification ETL Python ASP.NET/C# JavaScript HTML CSS SQL Server PL/SQL Oracle Relational Database Hadoop HDFS Hive Spark Advanced MS Excel SSIS SSAS SSRS Jupyter Notebook MS Visual Studio Data Migration Azure Data Platform Architecture Data Engineering Data Factory SQL Server Optimization MySQL Database API Machine Learning Predictive Analytics Regression Techniques Data Validation Troubleshooting Root-Cause Analysis Normalization Data Integrity Teamwork Communication Organizational Skills Attention to Detail Adaptability Work Ethic Presentation Skills Analytical Skills
Report this Profile?