Ishan Sheladiya
Data Analyst Scientist @Digicel Group
Signup · Get unlimited contacts
WORK HISTORY
Data Analyst Scientist @Digicel Group
GB
Support production issues for legacy ETL processes, ensuring data accuracy and availability while handling on-call responsibilities.• Optimize Stored Procedures and Functions by designing indexes to enhance database performance.• Build and maintain CI/CD pipelines in Azure DevOps for automated testing, building, and deployment of Python applications.• Debug and monitor SSIS packages in production, ensuring seamless execution and troubleshooting issues.• Manage snapshot data workflows, loading data from transactional systems into data warehouses.• Develop and enhance Power BI dashboards, collaborating with users to refine requirements and deliver accurate solutions.• Translate business needs into SAS code for new program development.• Leverage Teradata utilities and tune queries for improved performance.• Create data models and Power BI reports from scratch, using DAX for measures/columns and M language for data transformations.• Implement incremental processing in Power BI for efficient snapshot data handling.• Design reusable Power BI datasets to empower cross-team reporting.• Deploy SSIS packages and SSAS cubes to production as part of the deployment team.• Utilize Azure Cloud services, creating pipelines with U-SQL to process data from raw to curated zones, scheduled via Azure DevOps.• Tune multi-dimensional SSAS cubes with partitions and aggregations to reduce processing times.• Enhance query performance for SSAS cubes using MDX, aggregations, and partitioning strategies.• Develop SQL objects (Stored Procedures, functions, indexes, views) with modern DML/DDL practices.• Debug and enhance SSRS reports while scheduling SSIS packages via JAMS.• Proficient in source control (TFS, GitHub) and experienced with Databricks, Spark SQL, and Microsoft training.
EDUCATION
President Science College
Bachelor of Applied Science - BASc, Chemistry
ABOUT ISHAN SHELADIYA
Data Analyst | SQL Developer | BI & Analytics | Azure Data EngineeringWith over 5 years of experience in data analysis, SQL development, and business intelligence, I specialize in designing, developing, and optimizing data-driven solutions using SQL Server, Azure Data Bricks, Power BI, and ETL pipelines to drive business insights. Data Engineering & WarehousingExpertise in database development, data modeling, and ETL processes for structured and unstructured data.Proficient in SQL, T-SQL, and OData, with experience in star and snowflake schema designs.Developed and optimized SSIS packages for incremental data loads from various sources like SQL Server, Excel, and flat files.Hands-on experience in Azure Synapse, Databricks, and Power BI data models. ETL & Big Data ExpertiseAutomated ETL workflows using SSIS, Python, and U-SQL, enhancing data efficiency.Designed and maintained data pipelines on Azure Data Factory for seamless data integration and migration.Implemented performance tuning strategies for large-scale multi-dimensional cubes in SSAS. Business Intelligence & Data VisualizationDeveloped interactive dashboards in Power BI and SSRS reports for actionable insights.Created complex DAX measures and calculated columns for business intelligence applications.Experience in data cleansing, staging, and transformation to optimize data pipelines.Designed multi-dimensional cubes and optimized MDX queries for efficient data retrieval. Cloud Technologies & SecurityMigrated on-premise data warehouses to Azure Cloud with minimal downtime.Built secure and scalable cloud-based solutions with Azure ADLS, DevOps, and Key Vault.Automated CI/CD pipelines using Azure DevOps, ensuring efficient deployment and monitoring. Technical Leadership & Performance OptimizationDebugged and optimized Power BI reports, SSIS packages, and SSRS reports for peak performance.Conducted performance tuning of SQL queries and stored procedures to improve system efficiency.Monitored and maintained database performance using tools like SQL Profiler, TFS, and GitHub. Technical SkillsSQL | T-SQL | Python | Power BI | Azure Synapse | SSIS | SSAS | SSRS | Tableau | MDX | DAX | Azure Data Factory | Databricks | ETL | DevOps | OData Passionate about data-driven decision-making, optimizing data workflows, and leveraging cloud technologies to deliver high-impact business intelligence solutions. Let’s connect to explore opportunities in data analytics, cloud solutions, and business intelligence!
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.