Phani Raj Swarna
Toronto
Summary
Creative Azure and Business Intelligence Developer with more around 6 years of practical experience converting raw data into valuable insights. Proficient in utilizing Azure services to create scalable solutions, combined with a robust skill set in designing vibrant and visually engaging BI dashboards.
Overview
6
6
years of professional experience
1
1
Certification
Work History
BI and Azure Consultant
Investment Industry Regulatory Organization of Canada
12.2022 - Current
- Configuring Azure DevOps pipeline triggers for automated builds and deployments, streamlining the software delivery process
- Designing and implementing security filters and row-level security in SSAS tabular models to restrict data access based on user permissions
- Implementing Python scripts for web scraping and data extraction from websites
- Utilizing Git's log with the grep and all-match options to search for commits with multiple patterns in commit messages within the database code
- Expertly managing package events and notifications in SSIS, utilizing event handlers to respond to specific events and execute actions accordingly
- Utilizing Azure Key Vault's integration with Azure Management Groups for centralized management
- Creating and maintaining data integration schedules and monitoring SSAS jobs for timely and reliable data updates
- Ensuring successful execution of scheduled jobs for up-to-date and accurate reporting
- Creating and managing SQL server maintenance plans for regular index rebuilding and statistics updating to optimize query performance
- Developing and maintaining data enrichment and transformation routines for data analysis
- Configuring Azure Purview to support multi-lingual metadata annotations for diverse user communities
- Ensuring secure access to reports and report folders by configuring report security and access controls in SSRS, managing user roles, permissions, and data confidentiality
- Implementing robust OLAP and OLTP security measures to protect sensitive data and enforce access controls, ensuring data confidentiality and compliance with industry regulations
- Designing and implementing custom conflict resolution policies in multi-master configurations in Azure Cosmos DB
- Demonstrating creative proficiency in implementing report drill-through actions in SSRS, providing users seamless access to granular data insights
- Designing and implementing custom data wrangling and transformation logic in Azure Databricks to prepare data for analytics
- Expertly crafting and implementing data integration pipelines within Azure Synapse, ensuring seamless and efficient data flow across diverse sources and destinations
- Utilizing Blob Storage versioning to recover previous versions of blobs
- Devising seamless database migration and upgrade plans for smooth transitions with minimal disruptions
- Integrating Power BI with other business intelligence tools, data visualization tools, or third-party platforms to enhance capabilities and extend functionality
- Optimizing SSIS packages for enhanced performance, employing parallelism and source/destination-specific optimizations
- Designing and implementing data visualization best practices, including appropriate color schemes, data labeling, and interactivity to enhance user experience and understanding of the data
- Designing and deploying Azure Data Factory pipelines with data partitioning and parallel processing for optimal performance
- Creating and managing Power BI content packs for sharing standardized reports and dashboards with external clients or partners.
Azure and BI Developer
Apple Express
09.2021 - 12.2022
- Collaborated for optimized data retrieval in Power BI, Integrated Power BI with Microsoft tools and platforms, Instituted data lake monitoring and alerting, Managed precise report delivery with SSRS subscriptions, Configured Azure Purview for data extraction and classification, Skillfully designed SSRS drillthrough and bookmarking, Implemented database version control and change management, Developed custom Power BI templates and themes, Utilized Blob Storage event notifications for Azure Data Factory, Maintained data enrichment and transformation routines, Crafted seamless SSIS data flows for heterogeneous systems, Developed SQL scripts for data replication and synchronization.
BI Programmer
Accenture
02.2020 - 09.2021
- Maintained Power BI reports with custom subscriptions, Integrated Azure Databricks with data warehousing solutions, Oversaw data lake storage and file system management, Developed SQL scripts for data anonymization, Leveraged Azure Cosmos DB's Request Units monitoring, Created calculated columns and tables in SSAS tabular models, Optimized SSAS cube performance with fine-tuning, Optimized data loading for improved performance, Managed key vault synchronization with on-premises systems, Configured deployment notifications in Azure DevOps, Implemented Power BI's composite models for data combination, Employed data masking and anonymization in SSIS packages.
Jr ETL Developer
CSB Bank
03.2018 - 02.2019
- Collaborated on designing and developing data cubes, Developed SQL scripts for data enrichment, Maintained detailed SSIS package documentation, Optimized SSRS reports with pagination and interactive features, Implemented Power BI's data export to Azure Data Lake, Integrated Power BI with Azure Machine Learning for predictive analytics, Created advanced calculations using MDX or DAX in SSAS, Conducted data analysis for actionable insights.
Education
B.tech in Computer Science and Engineering -
Jawaharlal Nehru Technological University
Hyderabad, IndiaSkills
- Cloud Computing: Skilled in harnessing Azure services such as Azure Blob Storage, Azure Data Factory, Azure Databricks, Azure DevOps, Azure Purview, Azure Synapse, and more
- Databases: Proficient in utilizing Access, Azure Data Lake, Azure Data Warehouse, MySQL, SQL Azure, and SQL Server
- Data Analysis: Capable of performing in-depth data analysis using various tools and languages, including Python, SQL, and other relevant technologies
- Development Tools: Skilled in using Visual Studio 2013, Visual Studio 2015, and Visual Studio 2017 for effective development tasks
- ETL (Extract Transform Load) Tools: Demonstrating expertise in ETL development, ensuring the efficiency of data extraction, transformation, and loading processes Extensive experience with Azure Data Factory, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Data Tools 2012, and SSIS
- Reporting Tools: Competent in utilizing Excel, Power BI Desktop, Power BI Service, and SSRS to generate insightful reports
- Scripting: Proficient in Elementary Python, PL/SQL, SQL, T-SQL, Unix Shell Scripting, VB, and MySQL
- Version Control Tools: Experienced in using Bitbucket, Git, Team Foundation Server (TFS), and VSTS for version control and collaborative development
Certification
Microsoft Power BI Data Analyst
Timeline
BI and Azure Consultant
Investment Industry Regulatory Organization of Canada
12.2022 - Current
Azure and BI Developer
Apple Express
09.2021 - 12.2022
BI Programmer
Accenture
02.2020 - 09.2021
Jr ETL Developer
CSB Bank
03.2018 - 02.2019
B.tech in Computer Science and Engineering -
Jawaharlal Nehru Technological University
Similar Profiles
Daniela CapozzoloDaniela Capozzolo
Senior Investigator, Enforcement Department at Canadian Investment Regulatory OrganizationSenior Investigator, Enforcement Department at Canadian Investment Regulatory Organization
Jerome WhalenJerome Whalen
Principal Investigator at Financial Industry Regulatory Authority, FINRAPrincipal Investigator at Financial Industry Regulatory Authority, FINRA
Kerry DunnKerry Dunn
Senior Office Manager, Department of Enforcement at Financial Industry Regulatory Authority, FINRASenior Office Manager, Department of Enforcement at Financial Industry Regulatory Authority, FINRA