Rohan Bansal Email & Phone Number

Canada

• Lead the design and implementation of Azure Data Factory pipelines, automating data ingestion and processing tasks in manual data handling• Designed and implemented scalable data solutions on Microsoft Azure, leveraging services such as Azure Data Factory, Azure SQL Data Warehouse, and Azure Databricks, resulting in optimized data processing workflows• Implemented data security and access controls for Azure SQL Database and Azure Cosmos DB to ensure compliance with regulatory requirements• Managed Azure Synapse Analytics to design and maintain data warehousing solutions, optimizing data storage and query performance for analytical workloads• Monitored robust data security measures within Azure services and Snowflake, ensuring compliance with industry standards and data governance policies to safeguard sensitive information and maintain data integrity• Utilized PySpark to preprocess and analyze large-scale datasets, applying data transformations, filtering, and aggregations to prepare data for downstream analytics, resulting in enhanced data insights and model accuracy• Integrated Azure SQL Database instances, including performance tuning, query optimization, and scaling to manage increased workloads, ensuring high availability and minimal downtime for critical applications• Created pipelines in ADF using linked services to extract, transform and load data from data sources like Azure SQL, and Blob storage• Identified and implemented workflow optimizations within Azure Databricks, including cluster auto-scaling, resource tuning, and code optimization, leading to substantial cost savings and increased processing efficiency for complex data workloads• Developed the insights of data by optimizing Power BI reports and dashboards for performance, ensuring fast loading times and responsiveness

India

• Administered and maintained database management systems (DBMS) to ensure optimal functionality, including installation, configuration, and patch management• Optimized database performance through performance monitoring, tuning, and troubleshooting, including query optimization, index management, and database parameter tuning• Implemented comprehensive backup and recovery strategies to safeguard critical data, minimizing potential downtime and data loss in the event of system failures or disasters• Designed and implemented efficient and scalable database structures, including schema design, table design, and normalization, to support business requirements and optimize data retrieval performance• Created database security measures, including user access controls, role-based access control (RBAC), and encryption, to protect sensitive data from unauthorized access and ensure compliance with security policies and regulations• Introduced monitoring and alerting systems to proactively identify and address performance issues, resource constraints, and potential security threats, ensuring optimal database health and availability• Utilized SQL for developing and optimizing database queries, ensuring data accuracy and responsiveness for end-users and applications• Performed data migration tasks between different database systems and versions, ensuring data consistency and minimal downtime during transitions• Developed and tested disaster recovery plans, ensuring rapid restoration of database services in case of catastrophic events

Pbd In Financial Technology, Financial Planning And Services

Bachelor'S Degree In Business And Economics, Business And Economics