Srujan Kumar Email & Phone Number

Pickering, On, Ca

Brossard, Quebec, Canada

I currently serve as an SSIS/Power BI Developer. In this role, I facilitate seamless data extraction, transformation, and loading processes, collaborating closely with stakeholders to meet reporting needs. My responsibilities include designing SSIS packages, optimizing T-SQL queries, and implementing automation solutions for maintenance tasks and backups. Additionally, I develop SQL Server reports with drill-down capabilities and leverage Hive queries for data lake integration. With expertise in ETL processes and a strong command of SQL Server technologies, I contribute to the successful implementation of enterprise data warehouse solutions, ensuring data integrity and reliability.

Mumbai, Maharashtra, India

I played a pivotal role in data management and visualization. I developed robust ETL packages using SSIS to seamlessly integrate various data sources into SQL Server databases, ensuring data integrity and efficiency. Leveraging Power BI, I crafted insightful dashboards with dynamic filters and interactive features, enabling stakeholders to gain actionable insights quickly. Additionally, I led the creation of ad-hoc reports and drill-through functionalities, enhancing data exploration capabilities. With expertise in both Power BI and SQL Server Reporting Services (SSRS), I designed and deployed parameterized reports catering to diverse business needs. Furthermore, I contributed to database optimization efforts, including migration tasks and performance tuning, to ensure optimal system functionality. My experience with Azure Data Factory and Azure Cloud further enriched my skill set, enabling me to design and deploy ELT pipelines seamlessly. In summary, my role encompassed end-to-end data management and visualization, contributing to enhanced decision-making processes within the organization.

Mumbai, Maharashtra, India

I played a multifaceted role in data management and visualization. Collaborating closely with stakeholders, I developed intuitive user interfaces and visually appealing dashboards, ensuring alignment with organizational requirements and usability standards. Leveraging Power BI and Tableau, I transformed raw data into actionable insights, utilizing various visualization techniques and advanced features. I also contributed to the design and implementation of technology roadmaps for Power BI, facilitating the installation and development of insightful dashboards. Additionally, my responsibilities included conducting user testing, gathering feedback, and preparing detailed specifications to streamline data processes and operations. Working in a dynamic environment, I integrated custom visuals, conducted user testing, and optimized data connections for seamless user experiences. In summary, my role encompassed end-to-end data management, visualization, and user experience optimization, contributing to enhanced decision-making processes within the organization.

Bengaluru, Karnataka, India

I played a pivotal role in designing and implementing data solutions to support business intelligence initiatives. Collaborating closely with technical architects and database analysts, I contributed to the design of summary tables and developed functional and technical documents for efficient report development. Leveraging SQL Server Integration Services (SSIS), I transformed data from legacy systems to modern platforms and created interface stored procedures to streamline data loading processes. Additionally, I worked extensively with T-SQL programming, stored procedures, and user-defined functions to manage data and enhance system performance. My responsibilities also included designing and developing data pipelines and workflows in Data Bricks, analyzing large datasets, and collaborating with cross-functional teams to define data requirements. Furthermore, I played a key role in automating data processing tasks and ensuring data accuracy and security. With proficiency in logical and physical data modeling, database design, and data analysis, I contributed to the successful delivery of reports and insights to stakeholders. Working in a dynamic environment, I scheduled reports for regular distribution and prepared reports in various formats to meet business needs. In summary, my role encompassed end-to-end data management, analysis, and reporting, contributing to informed decision-making within the organization.