Amanul Huda
Senior Analyst BI
Lucknow
Summary
Professional Summary:
A Senior Data analyst with problem solving skills and developed complex projects & Infrastructure. Have proficiency in Power BI report making with different data sources such as files SQL Servers, Semantic Models. Knowledge of One data lake, lakehouse, Azure synapse analytics, azure blobs, Data warehousing and data reporting.
Transformation tools such as Microsoft fabric with Apache spark notebook, Dataflow gen 2, Power Query editor in power bi.
ETL through SQL, pyspark using T-SQL in CDM. Was part of building end to end enterprise BI reporting with power bi front end and Azure SQL as backend.
Overview
5
5
years of professional experience
2
2
Certifications
Work History
Senior Analyst - BI
Teleperformance
2 2020 - Current
- Responsible for project planning & designing of architecture of data model at an enterprise level using technologies like MS Power BI suite & MS Azure (ADF) Microsoft Fabric
- Strong understanding of DAX language, including concepts like row context, filter context, query context & common DAX functions like Time Intelligence, filters, iterator functions
- Developing visual reports, dashboards and KPI scorecards using Power BI desktop
- Creating dashboard with custom themes & tiles with hyperlink to respective reports
- Creating email subscriptions to share report data as attachment to management as per desired schedule
- Power BI reports distribution via apps and/or SharePoint communication site/ groups
- Power BI Premium, BI modelling & Enterprise Level BI project management with RLS implementation for data security, even with Many to Many Cardinalities
- Adding guest user via Azure Directory mapping, adding Free license users to Premium capacity & monitoring Premium Capacity consumption
- Knowledge and understanding of other Power BI suite features and capabilities including (but not limited to) Power BI Gateway, Power BI Premium Capacity and Power BI Mobile.
- Knowledge of Data warehouse & its processing. Flows such as ODS STAG PROD, Delta Schemas in Lake house
- Experienced with Data flow gen-2 & PySpark notebooks
- Worked on Azure Databricks for transformation.
- Enhanced team productivity by streamlining workflow processes and implementing time-saving strategies.
Process Associate
Genpact
09.2019 - 02.2020
- Worked as Account Repayable & Record to report for McKesson process.
- Payments for international customers
- Handled cases on Salesforce
- Managed 50 customers calls per day and made payments which increased backlogs by 10%
Consultant
Fortredge Constructions Pvt Ltd
8 2018 - 09.2019
Created structured tables for customers and inventories at construction office.
- Managed over 10 customers calls per day.
- Successfully managed to showcase reports in Power BI to stake holders.
- Managed database in Excel with Customer & Transaction tables.
- Managed client relationships through regular check-ins and updates on project progress.
Education
Bachelor of Computer Applications - Computer Applications
Integral University
Lucknow 04.2001 -
Skills
Problem-Solving
Client Relationships
MS Office
Power BI
DataWarehousing
MicrosoftFabric
Data Analysis
Data Modeling
DAX
Business Intelligence
Analytical Thinking
SQL and Databases
SQL Programming
Statistic analysis
Technical understanding
Certification
Microsoft Certified: Power BI Data Analyst Associate,
Languages:
English
Upper intermediate (B2)
Hobbies:
I like to consume technical content such as new technologies on YouTube.
I like to sing .
Not a gaming freak but 2-3 games i play eg:, GTA, subway surfer.
Timeline
Process Associate
Genpact
09.2019 - 02.2020
Bachelor of Computer Applications - Computer Applications
Integral University
04.2001 -
Senior Analyst - BI
Teleperformance
2 2020 - Current
Consultant
Fortredge Constructions Pvt Ltd
8 2018 - 09.2019