Kumar N Email & Phone Number

Toronto, Ontario, Canada

• Development and maintenance of data pipeline on Azure Analytics platform using Azure Databricks, Python, Pandas and NumPy libraries.
• Developing reports and visualizations using Power BI for the agency.
• Maintaining data storage in Azure Data Lake.
• Cleansing of source data in text files, and destination data to maintain data integrity and accuracy.
• Working with data ingestions from multiple sources into the Azure SQL data warehouse
• Created processes to load data from Azure Storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.

• Worked with large datasets consisting of millions of records, developing efficient data processing workflows and optimizing database performance to ensure timely and accurate delivery of insights.
• Successfully executed data migration projects from On-prem SQL server to Cloud databases such as Azure Synapse Analytics (DW) and Azure SQL DB.
• Led the development and implementation of complex SQL databases to store and analyze data, resulting in reduction in data processing time.
• Leveraged SQL and Python to efficiently collect and transform data from Company’s prospectus.exe, improving data analysis accuracy and efficiency by 15%.
• Strong familiarity with Azure BLOB and Data Lake storage, proficient in loading data into Azure SQL Synapse Analytics.
• Designed and developed interactive and informative visualizations, including charts, graphs, and dashboards, using Tableau and excel to effectively communicate complex data analysis findings to diverse stakeholders.

Hyderabad, Telangana, India

• Worked on various reports using reporting tools like Tableau and MS excel to forecast the growth of various KPI.
• Analyse and creating reports to evaluate inventory data and makes recommendations to enhance processes in pharmacy operations.
• Extract data on request from customers and business partners using SQL and translate results into various formats, including Excel, Crystal Reports and SSRS.
• Generated Data Models using Erwin and developed relational database system and involved in Logical modelling using the Dimensional Modeling techniques such as Star Schema and Snowflake Schema.
• Involved in creating Ad-hoc reports by data analysis using MS-Access via ODBC or TOAD for data import and SQL analysis of reconciling data from the call centre.
• Worked with BA for analyzing requirements to developing SIS and SSRS packages, testing, implementation, and support.

Hyderabad, Telangana, India

• Worked on data extraction using various queries/formulas, manipulate using various analytical tools to create reports.
• Worked on various reports using reporting tools like Tableau and MS excel to forecast the growth of various KPI.
• Involve in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center and SSIS.
• Worked in creating different Visualizations in Tableau using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports.

Graduate Certificate, Information Technology, 87%

Bachelor Of Commerce (Computers), Business/Commerce, Information Technology, 80%