KARTIK KADAM
Kitchener,ON
Summary
- 2 years in Microsoft BI (Power BI, SSRS, Paginated Reports), creating custom dashboards and dynamic reports with advanced visualizations and filters.
- Extensive hands-on with ETL operations via Power Query, connecting diverse sources (SQL Server, Oracle, Excel) to build and cleanse complex datasets.
- Skilled in Star/Snowflake schemas and using DAX expressions to create new columns, measures, and tables for enhanced reporting.
- Collaborated with business teams to gather requirements, translating them into actionable BI solutions using conceptual and dimensional models.
- Proficient in designing and optimizing OLAP cubes with SSAS, creating efficient schemas and improving data warehouse performance.
Overview
2
2
years of professional experience
Work History
Data Engineer
Accenture
03.2021 - 05.2022
- Led the design and development of reporting data modules for a sales integration portal, gathering and documenting business requirements for analytical reports.
- Developed and optimized ETL processes with data flow transformations (Derived Column, Lookup, Conditional Split) and performed data cleansing in the staging database.
- Designed data models and implemented Star-Schema methodology for a data warehouse, ensuring efficient data flow and integration.
- Created and deployed Power BI dashboards, SSRS reports, and Excel services for cross-departmental analysis, utilizing advanced DAX calculations for performance optimization.
- Participated in JAD meetings to align development with business needs, collaborating closely with stakeholders to ensure project success.
- Managed report deployment on Power BI Service and implemented TFS for version control and bug tracking.
Data Analyst
Vermacon
09.2020 - 12.2020
- Assisted in the design and development of Power BI dashboards and SSRS reports, creating and optimizing SQL Server tables, views, and functions.
- Collaborated with business users to gather requirements and provided input on selecting appropriate visualizations for reports and dashboards.
- Supported the migration of existing self-service and ad hoc reports to Power BI for enhanced reporting.
- Generated dashboards and reports using Excel, CSV, and flat files, applying filters and calculated fields to handle large data sets.
- Assisted in managing security and setting up user roles for different modules within Power BI and SSRS reports.
Education
Cloud Data Management
Conestoga College Institute of Technology And Advanced Learning
Kitchener, ON12.2023
Bachelor of Science - Computer Applications
St. Andrews Institute of Technology And Management
Gurugram09.2021
Skills
- ALL: Power BI, Power BI Service, Power BI Pagination Reports, Power Query, Microsoft Excel, SQL Server Reporting Service (SSRS), Power BI Admin
- OLAP: SSAS Cloud: Azure, Snowflake, Power BI Service
- Database: SQL Server, Azure SQL, MS Access, DB, Snowflake Languages: SQL, PL/SQL, T-SQL, PowerShell,
- HTML Reporting Tools: Power BI, SSRS, Power Bi Report Builder, Report Studio, Report builder
- SQL Server Tools: SSDT, SQL Server Business Intelligence Development Studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS), SSAS
Languages
English
Timeline
Data Engineer
Accenture
03.2021 - 05.2022
Data Analyst
Vermacon
09.2020 - 12.2020
Cloud Data Management
Conestoga College Institute of Technology And Advanced Learning
Bachelor of Science - Computer Applications
St. Andrews Institute of Technology And Management
Similar Profiles
ANTO YOHANANTO YOHAN
Product Engineering Specialist at AccentureProduct Engineering Specialist at Accenture
Coriona WhitakerCoriona Whitaker
Unemployment Claims Specialist at AccentureUnemployment Claims Specialist at Accenture
SUMIT TIWARISUMIT TIWARI
Advanced Application Engineering Analyst at AccentureAdvanced Application Engineering Analyst at Accenture