Prashanth Patil
Guelph,ON
Summary
Experienced IT professional with 7+ years in the analysis, design, development, testing, and implementation of ETL and Business Intelligence solutions. Proficient in Microsoft BI tools including SSIS, SSRS, SSAS, and Power BI, as well as SQL Server and Azure SQL Cloud. Skilled in designing, developing, and deploying BI solutions, optimizing database performance, and working with both on-premises and cloud environments. Experienced in Azure Data Factory for building pipelines, creating dependencies, and automating tasks with PowerShell scripts. Strong communication, critical thinking, and problem-solving skills, with a pragmatic approach to balancing user requirements with technical solutions. Adept at staying current with emerging technologies and integrating them into existing frameworks.
Overview
8
8
years of professional experience
1
1
Certification
Work History
MSBI/Power BI Developer
Intact Public Entities
10.2023 - Current
- Worked on DAX query to create calculated columns and calculated measures based on Requirements
- Developed Power BI dashboards, visualizations, and interfaces with SharePoint and SSRS to deliver meaningful and actionable insight
- Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway
- Published Power BI Reports in required originations and made Power BI Dashboards available in web clients
- Created SSIS packages to extract, transfer and load data into data warehouse on daily basis
- Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent
- Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions
- Worked with various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, ftp task, send mail task
- Migrated SSIS Packages from old to new versions during data migration
- Involved in modifying existing Data Stage and Informatics Jobs for better performance
- Building pipelines to copy data from source to destination in Azure data factory (ADF V1)
- Worked on creating dependencies of activities in Azure Data factory
- Creating stored procedure and scheduled them in Azure Data factory
- Creating Data factory in Azure Data factory
- Worked on POC to migrate existing on-premises BI platform to Azure Cloud
- Moving CSV files from Azure blob to Azure SQL Server
- Configured Integration Runtime (IR) to move data from on premise to cloud
- Worked on PowerShell scripts to automate creation of resources and resource group.
Power BI Developer /Sr. Data Analyst
Future Generali
07.2020 - 08.2022
- Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc
- In Power BI
- Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
- Created drill down and drill through report to go to details and child report within power bi based on hierarchy
- Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging
- Secured Power BI reports using Row Level Security (RLS) and DAX filters
- Created new calculations and KPI such as average life of products, profit margins utilizing DAX in SSAS
- Created views, triggers, user defined functions to incorporate flow of business and automated stored procedures
- Coded and tested SQL queries based off persistent table using Inline Views, Dynamic SQL, Merge statements
- Built and monitored indexes to bring down processing times from minutes to seconds
- Improved SQL Queries to optimize e performance of procedure from 5 minutes to 60 seconds
- Querying and manipulating multidimensional cube data through MDX Scripting in SSAS
- Wrote complex DAX functions in Power BI and Power Pivot
- Used various sources to pull data into Power BI such as SQL Server, SAP BW, Oracle, SQL Azure, Amazon Athena, SSAS Cube
- Continuously analyze existing KPIs, reports, and dashboards to understand gaps with stakeholder needs and act to close these gaps
- Worked with business to develop formal business glossary, defining metrics and KPI's, Customer reporting feedback, Functional KPI performance, Exec KPI performance and SDM performance KPI
- Designed and implemented prototype SQL Server DB, SSIS, and Power BI solution to report descriptive statistics of telemetry usage data for client's SaaS cloud platform
- Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS)
- Wrote extensive T SQL / P SQL query for Join conditions, Unions, Aggregations and Expressions for SSRS Report
- Extracted data from internal data warehouse system to SSRS
- Designed and developed stored procedures, queries and views necessary to support SSRS reports
- Extensively involved in Unit and UAT during deployment of SSRS report
- Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS
- Built Tabular Model cube from scratch data
- Created relationships between tables in Power BI using Star and Snowflake schemas
- Fetched data from Snowflake data warehouse and performed ETL on platform
- Built Measures in tabular model using DAX queries and created partitions in tabular model
- Designed and developed SSIS Packages, to process the collection of data from sources like SQL Server 2014, Salesforce
- Teradata, MS Excel, Flat files
- And configured and scheduled to run packages to generate data in CSV files
- Troubleshooting reports issues, ETL job failures, optimizing query performances
- Configured Integration Runtime (IR) in order to move data from on premise to cloud
- Worked on power shell scripts to automate creation of resources and resource group
- Performed database backup and deployment to production server
- Involved in modifying existing Data Stage Jobs for better performance
- Created detailed technical documentation of various staging area operations for future reference and guidance
- Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation
- Worked on Azure Data factory to load data from on premise to Azure Data Lake
- Building pipelines to copy data from source to destination in Azure data factory (ADF V1)
- Worked on creating dependencies of activities in Azure Data factory.
SQL/MSBI Developer
Datamatics
06.2018 - 07.2020
- Involved in planning, defining and designing data base using Erwin on business requirement and provided documentation
- Translating business requirements into technical design specifications
- Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2012
- Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based design data models
- Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements
- Responsible for optimizing all indexes, SQL queries, stored procedures to improve quality of software
- Created traces using SQL Server profiler to find long running queries and modify those queries as part of Performance Tuning operations
- Performed daily tasks including backup and restore by using SQL Server 2012 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
SQL/ MSBI Developer
Country Financial
10.2016 - 11.2017
- Gathered user requirements to develop business logic and analyzed and designed packages and database solutions
- Worked on project using specifically Agile and Scrum methodology with short-term releases
- Worked closely with database to design and implement database components in timely manner
- Set up ETL Jobs to run on nightly basis into Data marts using SQL Server Agent
- Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned existing packages
- Developed highly complex SSIS packages using various Tasks, Containers and Data transformations
- Used configuration files, to migrate SSIS packages from development stage to quality analysis (testing) without having to reconfigure packages
- Created SSIS packages to extract data from multiple flat files, CSV, Excel and XML files and scheduled jobs to call packages
- Built Complex Stored Procedures for writing SSIS Package Logs into Physical Database
- Scheduled jobs for executing stored SSIS packages, which were developed to update database on daily/weekly/monthly basis
- Worked with SSIS packages involved FTP tasks, Merge, and Merge joining, Sort, Pivot and Un pivot Control Flow Transformations
- Created and maintained Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques
- Analyzes data by defining quality requirements, making recommendations for changes on source system, working with users to correct historical data and by applying standard data cleansing in integration services flows using SQL Server Data Tools
- Experience working with Team Foundation Server (TFS) and Visual SourceSafe
- Responsible for regression testing ETL jobs before test to production migration
- Created User Defined Functions to encapsulate frequently and commonly used business logic making system more modular, secured and extensible
- Executed Transact-SQL batches, system procedures, and script files at command prompt using SQL CMD Utility
- Developed database application using agile methodology along with Java development
- Used Team Foundation Server for storing and moving developed scripts to other environments
- Resolved and closed Production tickets generated due to failure of production jobs.
Education
Post Graduation Degree in Business Analytics - IT Computing
Conestoga College
Guelph, ON12.2023
Bachelor's degree in computer science - Information Technology
JNTUH
Hyderabad, India05.2014
Skills
- T-SQL
- Python
- PL/SQL
- HTML
- C#
- Net
- VBNet
- C
- Java
- Java script
- CSS
- Windows Scripts
- Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7
- Power BI
- SQL Server Reporting Services
- Power Apps
- Power Query
- Crystal Reports
- Power Automate
- Tableau
- Excel
- Erwin
- Rational Rose
- MS Visio
- MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000
- MySQL
- Oracle 11g/10g/9i/8i
- MS Access 2003/2000/97
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS), Power Automate (Flow), Visual Studio 2013/2010/2008
- SSAS
- Business Intelligence Development Studio (BIDS) 2008
- MS Data Tools 2012 / Visual Studio Shell
Certification
- Power BI Data Analyst Associate
- IBM Data Analyst Certification, January 2021
Languages
English
Full Professional
Timeline
MSBI/Power BI Developer
Intact Public Entities
10.2023 - Current
Power BI Developer /Sr. Data Analyst
Future Generali
07.2020 - 08.2022
SQL/MSBI Developer
Datamatics
06.2018 - 07.2020
SQL/ MSBI Developer
Country Financial
10.2016 - 11.2017
Post Graduation Degree in Business Analytics - IT Computing
Conestoga College
Bachelor's degree in computer science - Information Technology
JNTUH
Similar Profiles
MEGHA PATELMEGHA PATEL
Underwriting Support Clerk at Intact Public EntitiesUnderwriting Support Clerk at Intact Public Entities
Carlier BrysonCarlier Bryson
CMT at Roberson EntitiesCMT at Roberson Entities
Reventh Raj YataReventh Raj Yata
SENIOR PRINCIPAL BUSINESS INTELLIGENCE MANAGER at DELL Technologies (DELL EMC + Dell Entities)SENIOR PRINCIPAL BUSINESS INTELLIGENCE MANAGER at DELL Technologies (DELL EMC + Dell Entities)
Hamda JamaHamda Jama
Clinical Nursing Student at St. Joseph's Healthcare Hamilton- Mental HealthClinical Nursing Student at St. Joseph's Healthcare Hamilton- Mental Health
Bradley FodorBradley Fodor
Collegiate Gamer (Scholarship) at Ottawa UniversityCollegiate Gamer (Scholarship) at Ottawa University