Ram M Email & Phone Number

Toronto, Ontario, Canada

As a Data Engineer at BMO, I’ve been integral in enhancing data operations, focusing on cloud technologies and data engineering. My role encompasses:• Data Migration and Cloud Integration: Led the migration of data pipelines to Azure Synapse and ADLS from Hadoop systems, ensuring seamless integration and data transfer.• Real-Time Data Processing: Implemented Kafka and Spark Structured Streaming, significantly boosting real-time data analytics and responsiveness.• Cloud Data Management: Managed Azure Data Lake and Blob Storage, optimizing these platforms for scalability and data accessibility.• Data Analysis and BI Tools: Proficient in tools like Tableau and Splunk, conducting regression analyses and developing insightful visual representations for business intelligence.• Databricks and Azure Management: Automated Databricks notebooks with SQL and Python, and managed high concurrency clusters in Azure Databricks, enhancing data preparation and quality.• Data Pipeline Architecture: Developed and maintained data pipeline architecture in Azure, using Data Factory and Databricks, and implemented solutions in Azure SQL Data Warehouse.• Team Collaboration and Project Management: Collaborated with SMEs, data scientists, and developers through all stages of data product development, aligning projects with business objectives.• Data Design and Systems Development: Led data design and managed large datasets, actively engaged in developing OLTP and OLAP systems from the ground up.• Agile Practices: Embraced Agile methodology for project execution, ensuring effective team communication and alignment with project goals.• Data Security and Compliance: Maintained stringent data security and compliance standards.This role has been a significant platform for growth in data engineering, cloud technologies, and business intelligence, enabling me to contribute effectively to BMO’s data strategy.

Vancouver, British Columbia, Canada

In my dynamic role as an Azure BI Data Engineer at CENTRAL1, I specialized in optimizing data processes and business intelligence solutions using Azure technologies. My key responsibilities and achievements included:• Data Extraction and Transformation: Orchestrated the extraction of data from various sources including flat files and Oracle, transferring it into Azure Data Lake. I streamlined the data transformation process using Azure Databricks to structure and organize the data effectively.• Azure Databricks and HDInsight Management: Expertly managed Azure Databricks for data organization and visualization through dashboards. Also, performed data aggregation and validation using Azure HDInsight, ensuring data accuracy and reliability.• Business Intelligence and Reporting: Developed Azure Analysis Services (AAS) models and created comprehensive measures to support Power BI report generation. This enabled detailed business insights and data-driven decisions for both business and IT users.• Database Performance Monitoring: Actively involved in database monitoring, collaborating with database administrators to optimize performance and enhance reporting capabilities.• ETL Processes and Data Integration: Utilized Azure Data Factory for daily data loading from identified sources. I was responsible for creating and managing transformation processes in Azure Databricks, supporting Spark SQL and Python.• Agile Methodology and Project Management: Maintained an agile approach, effectively managing project timelines and deliverables. Regularly collaborated with cross-functional teams to ensure alignment with project goals and business requirements.• Performance Enhancement and CI/CD: Increased statistical reporting performance by 25% through diligent monitoring, tuning, and optimizing. I was also involved in the CI/CD process for migrating objects to QA and Production environments.

Toronto

In my tenure as a Data Warehouse Developer at COGNIZANT, I played a pivotal role in advancing data warehouse solutions, focusing on SQL Server management, data migration, and ETL processes. Key contributions and responsibilities included:• Data Migration & Integration: Led significant data migration from various sources to the data warehouse, involving complex SQL procedures to ensure seamless data flow and integrity.• SQL Server Proficiency: Developed dynamic SQL queries, views, triggers, and stored procedures, enhancing database interaction with front-end applications and overall functionality.• Data Modeling & Design: Conducted physical and logical data modeling, aligning the database design with business objectives and analytics requirements.• ETL Lifecycle Management: Managed ETL processes using SSIS, creating data load jobs and deploying packages across development, testing, and production environments.• Reporting & Analytics: Generated comprehensive reports with SSRS, enabling detailed analytics and data-driven decision-making.• Performance Tuning: Optimized TSQL queries for improved database performance and efficient data retrieval.• Agile Methodology: Embraced Agile practices in a collaborative setting, interfacing regularly with business users to translate their needs into effective database solutions.• SSAS for Data Analysis: Utilized SQL Server Analysis Services to create data cubes, enhancing analytical capabilities and data reporting.This role allowed me to effectively apply my technical expertise in SQL Server, data warehousing, and ETL, while also developing my project management and teamwork skills. My efforts significantly enhanced data management and reporting efficiency within the organization.

India

In my role at INFOSYS, I was integral to database development, focusing on enhancing data processes and system optimization. Key responsibilities and achievements:• Requirement Analysis & System Design: Played a key role in the initial project stages, gathering user requirements and system specifications, ensuring the creation of effective database solutions.• ETL & Data Integration: Managed data flow using SQL Server Agent Jobs, ensuring data integrity and efficiency within the ETL framework.• OLAP Cube Development: Developed OLAP cubes using SQL Server Analysis Services (SSAS), enhancing data analysis capabilities and supporting complex queries.• Advanced Reporting: Designed, developed, and deployed a range of SSRS reports, enabling dynamic and responsive data reporting.• Performance Optimization: Regularly worked with large datasets, optimizing database performance and query efficiency.• Data Warehouse Support: Assisted in developing and maintaining the data warehouse, aligning it with business needs and data standards.• Collaboration & Agile Methodology: Collaborated with cross-functional teams and embraced Agile methodologies, contributing to effective project management and team communication.• Database Design & Development: Engaged in comprehensive database design and development, creating stored procedures, triggers, functions, views, and indexes, ensuring robust database architectures.• Data Security & Compliance: Maintained focus on data security and adherence to industry regulations.My experience at INFOSYS significantly enhanced my skills in SQL development, data analysis, and reporting, laying a solid foundation for my career in data engineering and database management.