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.• Developing data retention policy and procedures to retain data while maintaining the storage space within allocated budget.• Extraction of data using SQL for ad hoc reporting and presentations

● 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, resulting in a 5% increase in stakeholder engagement. ● Created automated reports using Python to summarize findings and recommendations in a clear and concise format, reducing report generation time.• Created pipelines in ADF using Linked Services, Datasets, and Pipelines to efficiently Extract, Transform, and Load data from various sources, including Azure SQL, Blob storage, and Azure SQL Data Warehouse.● Design workflows and dataflows for SSIS and ETL processes to accommodate various file structures and business processes.● Delivered presentations to stakeholders, investors and management teams using the Microsoft Office Suite.

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.• Designed and customized data models for Data warehouse supporting data from multiple sources.• Involved in Data modeling process, conceptual, logical and physical models, ERD and data warehouse design-Dimensional-Star, snowflake schema, Data Integrity and OLAP and facts, indexing, data dictionary.• Worked on source system analysis, data transformation, loading, validation for data marts, operational data store and data warehouse.

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%