Jeanus

Over 5+ years of Experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence solutions using Data Warehouse/Data Mart Design and MS SQL Server 2019/2017/2016/2014 and various BI tools. Expertise in scripting T-SQL queries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA). Used Sub-Queries and Joins to simplify complex queries involving multiple tables.

Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes. Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints. Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into target tables. Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, MS SQL Server by using BCP utility, DTS and SSIS services. Proficient in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, SQL Server and MS Access.

Created

Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service. Extensive experience in various Tableau Desktop objects like Measures, Dimensions, Folder, Hierarchies, Extract, Filters, Table Calculation, Calculated fields, Groups, Parameters, Forecasting, Blending and Trend lines. Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).

Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and controlling and granting database access and Migrating On premise databases to Azure Data Lake store using Azure Data factory.

Data Analyst - Well Health Technologies - Toronto, Canada

(2025-10 - 2026-06)

• Creating and managing schema objects such as Tables, Views & Indexes depending on user requirements.
• Extensive experience of writing complex T-SQL queries, Triggers, Functions and Stored Procedure.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables
• Responsible for writing T-SQL code for creating Cursor and handling Data Validations.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Use SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script.
• Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.
• Develop and deploy SSIS packages, configuration files, and scheduled jobs to run the packages to generate data in CSV files.
• Designed and built-up high performance ETL Packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Created different KPI using calculated key figures and parameters.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Creating many calculated columns and measures using DAX in Power BI based on report requirements.
• Designing and Developing the Dashboard Reports in Tableau.
• Involve in troubleshooting of performance issues which were associated with Tableau reports.
• Created different visualizations in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Cards, Slicers, etc. Also, using different transformation inside edit query into clean-up the data.
• Create Drill through reports, drill down reports, Sub reports, Cascading Parameters, linked reports, Matrix etc. using BIDS.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Moving CSV files from Azure blob to Azure SQL Server.
• Scheduled Jobs in Flows and ADF Pipelines.
• Worked on projects using Agile and Waterfall model methodologies.
• Gather requirements for business processes and determine ways to optimize/improve JIRA/Confluence build and configure complex workflows and screen, field, security, and notification schemes.

Data Analyst - Euna Solutions - Toronto, Canada

(2024-04 - 2025-09)

• Involved in planning, defining, and designing data base using Erwin on business requirement and provided documentation.
• Worked on tuning the queries and fixing the stored procedures to get the data consistency.
• Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Worked extensively on complete data mapping of all source systems as part of data analysis.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.
• Performed daily tasks including backup and restore by using SQL Server 2017 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Assisted with Database design, extensive data analysis of all 3 source systems & implemented the ETL architecture to support the migration.
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Actively participated in migration of on-premises SQL Server schemas to cloud on Azure SQL Server DB and Azure VM and developed and maintained databases.
• Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server 2017.
• Created ETL Extraction Strategy architecture as part of Development plan to extract & load data from source systems to staging and to ECB Destination servers.
• Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in data warehouse.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into target tables.
• Designed dashboard and passionate practitioner of effective data visualization.
• Create Drill Down and Drill Through report to go to details and child report within Power BI based on hierarchy.
• Created reports on Power BI Desktop and published on Power BI Report Server.
• Developed, published customized interactive reports and dashboards, scheduled data refreshes on reports using Tableau Desktop and Serve.
• Created user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.).
• Created and scheduled tasks for reloading and distribution of Data in Tableau.
• Developed ad-hoc reports using Power Pivot.
• Designed, developed, and deployed reports in MS SQL Server environment using SSRS-2017.
• Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters.
• Created reports to retrieve data using Stored Procedures and parameterization.
• Experience in configuring Azure web apps, Azure App services, Azure Application insights, Azure Application gateway, Azure DNS, Azure Traffic manager, App services, Analyzing Azure Networks with Azure Network Watcher, Implementing Azure Site Recovery, Azure stack, Azure Backup and Azure Automation.
• Created Azure SQL database, performed monitoring and restoring of Azure SQL database
• Experience in database design and development using SQL Azure, Microsoft SQL Server, Microsoft Access.

SQL BI Developer - Capgemini - Mumbai, India

(2019-08 - 2022-05)

• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Analyzed the Data quality

Master of Computer Engineering - University of Windsor (2022 - 2023)

Bachelor of Computer Engineering - Guru Nanak Dev University (2015 - 2019)