sameer pathan

sameer pathan

Data Engineer(BI)/Software Developer
India

About Me

Results-driven Power BI Developer having 4+ years of experience in the field of data engineering specialized in Power BI and SQL and T-SQL, Data analysis. Proficient in crafting and delivering data-driven solutions utili…

Experience

Data Engineer

Adastra Corporation
Aug 2023 - Present · 2 years 10 months

Orchestrated a comprehensive data migration initiative, leading the transition of reports and
dashboards from Qlik to Power BI.
● Oversaw the seamless migration of data sources to Snowflake and Amazon Redshift cloud platforms,
ensuring uninterrupted access to critical data.
● Executed the migration and refinement of existing interactive Power BI dashboards and reports,
enhancing data visualization and analytical capabilities.
● Implemented robust data warehousing strategies and advanced data quality techniques to ensure the
integrity and reliability of organizational data assets.
● Leveraged SQL Server proficiency to craft optimized SQL queries for generating insightful and
actionable reports.
● Applied expertise in DAX queries to create dynamic calculations, empowering users to derive
meaningful insights from complex datasets.
● Employed stored procedures within Power BI to execute sophisticated calculations and streamline
data processing workflows.
● Implemented and managed dynamic row-level security protocols, safeguarding sensitive data and
ensuring compliance with privacy regulations.

Data Engineer

Adastra Corporation, Thailand
Aug 2023 - Present · 2 years 11 months

Orchestrated a comprehensive data migration initiative, leading the transition of reports and dashboards from Qlik to Power BI.
Oversaw the seamless migration of data sources to Snowflake and Amazon Redshift cloud platforms, ensuring uninterrupted access to critical data.
Executed the migration and refinement of existing interactive Power BI dashboards and reports, enhancing data visualization and analytical capabilities.
Implemented robust data warehousing strategies and advanced data quality techniques to ensure the integrity and reliability of organizational data assets.
Leveraged SQL Server proficiency to craft optimized SQL queries for generating insightful and actionable reports.
Applied expertise in DAX queries to create dynamic calculations, empowering users to derive meaningful insights from complex datasets.
Employed stored procedures within Power BI to execute sophisticated calculations and streamline data processing workflows.
Implemented and managed dynamic row-level security protocols, safeguarding sensitive data and ensuring compliance with privacy regulations.

Software Engineer

T Software IT Services, Nagpur
Apr 2020 - Aug 2023 · 3 years 4 months

Developed interactive dashboards and reports using Power BI Desktop and published them to Power BI Service for end-user consumption.
Written SQL QUERIES in SQL Server in order to generate reports.
Expert experience in Data Warehouse designing with different schemas – Star and SnowFlake schemas.
Optimized performance of Power BI reports by optimizing data models, measures, and visuals.
Hands on experience in writing and implementation of the Stored Procedures, Functions, Views, Joins, Sub - Queries, CTE’S, indexes, Triggers using SQL & T-SQL
Good understanding of Data Modelling - Dimensions and Fact Tables

Skills

Excel SharePoint Administration SQL Database Data Repository Microsoft SQL Server MSSQL Power BI Redshift S3 Power BI Service Snowflake Data Modelling Dax Amazon Redshift Azure SQL Cloud MySql M Query Javascript CSS3 Material UI Axios Quicksight Azure Cloud Azure Data Studio Azure Analytics Services Qlik Sense SSMS VS Code REST API Jest JWT Azure data Explorer SQL DAX SharePoint OData Azure SQL MySQL MS SQL JavaScript TypeScript HTML5 React Redux Bootstrap Qlik Tableau Jira Agile MS Office Node.js Azure Data Explorer T-SQL Data Warehousing Stored Procedures Data Quality Data Visualization Data Analysis Data Pipelines Data Lake
Report this Profile?