Syedshaffee S Meeran

Mumbai, India· syedshaffee@gmail.com

Obtain a challenging position in a company that can utilize a creative mind, an enthusiastic thirst for knowledge, and a desire to exceed the expected standard of performance. Willing to work with a team or individually with healthy team spirit.


Experience

LEAD BUSINESS INTELLIGENCE DEVEPLOER

ABC FITNESS

Managed a team of 7 report developers, including delegating tasks to specific developer, taking into consideration their personality, area of expertise, and years of experience. Assembled and led a team of Power BI developers to create reports and guide them on nay technical challenges. Design, construct, create, and maintain efficient and reliable data pipelines to move data across systems. This involves extracting data from various sources, transforming it into a usable format, and loading it into storage. Design and implement scalable, distributed, and high-performance data storage systems. Choose appropriate storage technologies and data models based on the specific requirements of the organization. Integrate different data sources to ensure consistency and accuracy in data reporting and analysis. This might involve working with structured and unstructured data from various databases, APIs, and file systems. Clean, transform, and preprocess data to prepare it for analysis. Apply data transformation techniques such as normalization, aggregation, and feature engineering to ensure data quality and relevance. Implement data quality checks and validation processes to identify and rectify data inconsistencies, errors, and missing values. Ensure data accuracy and reliability for analytical purposes. Experience administrating or connecting data sources like Azure Data Lake, Azure SQL, Azure Databricks, Azure Synapse, Snowflake, etc. for data ingestion in an analytics platform. Follow and implement industry best practices for a better time to market using the latest CI/CD technologies and automate day-to-day tasks. Develop enterprise-grade distributed products that can perform, scale, and integrate into a broad enterprise ecosystem.

July 2023 - Present

SENIOR BUSINESS INTELLIGENCE DEVELOPER

ABC FITNESS

Design, construct, create, and maintain efficient and reliable data pipelines to move data across systems. This involves extracting data from various sources, transforming it into a usable format, and loading it into storage. Integrate different data sources to ensure consistency and accuracy in data reporting and analysis. This might involve working with structured and unstructured data from various databases, APIs, and file systems. Clean, transform, and preprocess data to prepare it for analysis. Apply data transformation techniques such as normalization, aggregation, and feature engineering to ensure data quality and relevance. Connect different data sources like Databricks, Snowflake, Azure Data Lake, SQL Server Analytics Services, ODBC-based data sources, etc. for data ingestion in the Power BI platform. Set up and troubleshoot Power BI Gateway and Virtual Network Data Gateway for data source connectivity. Develop enterprise-grade distributed products that can perform, scale, and integrate into a broad enterprise ecosystem. Collaborated with business users, collect requests, and updated the set of existing BI reports accommodating business needs. Implemented 3 fully functional data schemes and 10+ data flow optimization processes for reporting performance and enhancements. Analyses current ETL process, define and design new systems. Redefine and make technical/strategic changes to enhance existing Business Intelligence systems. SQL querying for best results, use of filters and graphs for better understanding of data. Work with users and team members at all levels for performance improvement and suggestions.

November 2022 - July 2023

POWER BI REPORT DEVELOPER

ABC FITNESS

Power BI development and administration. Understand business requirements in BI context and design data models to transform raw data into meaningful insights. into meaningful insights. Create dashboards and interactive visual reports using Power BI. Identify key performance indicators (KPIs) with clear objectives and consistently monitor -those. Chart creation and data documentation explaining algorithms, parameters, models, and relations.hose. Design, develop, test, and deploy Power BI scripts and perform detailed analytics.ons. Perform DAX queries and functions in Power BI. Analyses current ETL process, define and design new systems. Redefine and make technical/strategic changes to enhance existing Business Intelligence systems. SQL querying for best results, use of filters and graphs for better understanding of data.tems SQL querying for best results, use of filters and graphs for better understanding of data. Work with users and team members at all levels for performance improvement and suggestions.

November 2021 - November 2022

POWER BI REPORT DEVELOPER BUSINESS ANALYST

FITNESS BI

Power BI development and administration. Understand business requirements in BI context and design data models to transform raw data into meaningful insights. Create dashboards and interactive visual reports using Power BI. Identify key performance indicators (KPIs) with clear objectives and consistently monitor those. Chart creation and data documentation explaining algorithms, parameters, models, and relations. Design, develop, test, and deploy Power BI scripts and perform detailed analytics. Perform DAX queries and functions in Power BI. Analyses current ETL process, define and design new systems. Redefine and make technical/strategic changes to enhance existing Business Intelligence systems SQL querying for best results, use of filters and graphs for better understanding of data Work with users and team members at all levels for performance improvement and suggestions

November 2020 - November 2021

SENIOR SOFTWARE ENGINEERING ANALYST

ACCENTURE

Power BI development and administration. Building Analysis Services reporting models. Developing visual reports, dashboards and KPI scorecards using Power BI desktop. Connecting to data sources, importing data, and transforming data for Business Intelligence. Excellent in analytical thinking for translating data into informative visuals and reports. Able to implement row-level security on data and have an understanding of application security layer models in Power BI. Proficient in making DAX queries in Power BI desktop. Expertise in using advanced-level calculations on the data set. Adept in developing, publishing, and scheduling Power BI reports as per business requirements. Able to properly understand the business requirements and develop data models accordingly by taking care of the resources. Creating Modules as per requirement. Develop GUI interfaces using Open Database. Connectivity (ODBC) to connect to Access and SQL Relational Database Management Systems (RDBMS). Building a web-based application in this role and now responsible for maintaining/managing the same. This application is a website https://cmtdex.accenture.com (accessible only to DEX leads) and contains dashboards related to governance of delivery in CMT

August 2015 - November 2020

Projects

Sending Data To HR system(Woven)
  • power-bi Interface
  • power-bi Interface
Architecture
  • power-bi Interface
Projects overview

The client's requirements were tricky as they wanted data from Power BI to be pushed to their HR systems. We were able to achieve this using PowerApps and PowerBI.

  • The data was stored in Azure SQL DB from the API
  • ADF Pipelines were used for getting data in from the API
  • Power Automate was used for sending Projections data via the API to the HR systems(Woven)
  • Git was used for version control.
  • Tabular editor was used for Model development

Daily Tracker
  • Daily Tracker report
Architecture
  • power-bi Interface
Projects overview

The user has a specific requirement where he wants to see the trends. but wanted the current trend to be controlled by the use. Came up with a solution. where the user can achieve the same

  • The data was stored in ADLS gen2 as a CSV format
  • Part of the data stored in clients Azure SQL DB managed instance
  • Transformation was done in Power BI Data Flow and used in our dataset
  • Complex expression where written in DAX
  • Git was used for version control.
  • Tabular editor was used for Model development

Health Report
  • Health report
Architecture
  • power-bi Interface
Projects overview

Health Cards where the users can identify which Business process they need to improve and focus on. The Configuration of the rag is completely Dynamic. The overall Rag is based on the weightage that is set by the user on the report

  • The data was stored Azure SQL DB managed instance
  • Part of the data stored in Blob Storage as a staging layer
  • Synapse was used for a gold layer
  • Data was model in Azure analytical services and pulled into Power-BI
  • Complex expression where written in DAX for to identify which rags it is falling under based on users Configuration
  • Git was used for version control.
  • Tabular editor was used for Model enhancements


Education

University of Mumbai

Bachelor of Commerce
2007 - 2010

St.Xavier Jr. College

Commerce
2006 - 2007

MGM High School

2004 - 2005

Skills

Programming Languages & Tools
  • Azure-Synapse
  • Data-Factories
  • Azure-Databricks
  • Data-Lake-Analytics
  • SQL-Data-Warehouses
  • power-bi
  • microsoft-power-apps
  • Daxstudio-logo-light
  • te3
  • Static-Apps
  • HTML
  • CSS
  • Azure
  • Azure DevOps
  • Gitkraken
  • Javascript
  • Java
Workflow
  • Extract, Transform, and Load use cloud technology
  • Build the data model
  • Add visuals to the report
  • Push changes to repositories


Interests

Apart from being a Lead BI developer, I enjoy most of my time being indoors where i spending my time with my family.

I have a deep passion for immersing myself in captivating stories, whether it's through the pages of a book or the screen of a movie, as I find joy in exploring different worlds and characters. During my spare time I follow a number of sci-fi and fantasy genre movies and television shows, and I spend a large amount of my free time exploring the latest technology advancements in the Data engineering world.


Certifications

  • Azure Synapse Analytics For Data Engineers
  • Power BI Administration: Administering the Power BI Service
  • Azure Databricks & Spark For Data Engineers (PySpark/SQL)
  • Data Warehouse - The Ultimate Guide
  • MSBI , SSIS , SSRS and SSAS
  • Advanced DAX for Microsoft Power BI Desktop