MUEEN FAZLUL
Mississauga,ON
Summary
Analytical and results-driven Data Engineer with over 12 years of expertise in data analysis, proficient SQL query writing, and a focus on leveraging Microsoft Azure for comprehensive data solutions. Proven track record in extracting, cleansing, transforming, and automating reports to deliver valuable insights to management and stakeholders. Well-versed in Microsoft Azure Data Factory, Databricks, and Power BI, complemented by a solid background in working with databases, including Oracle, SQL Server, DB2, and Netezza. Adept at merging and transforming data from diverse sources, with specialized knowledge in Microsoft Azure to enhance data processing capabilities and drive informed decision-making.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Project Lead Consultant
Datamatics Global Services LLC
07.2022 - 01.2023
- Led the end-to-end implementation of SAP BO 4.1 to Power BI and SSRS Migration Project for Dubai Islamic Bank
- Executed end-to-end ETL (Extract, Transform, Load) processes within Azure Data Factory to facilitate the seamless flow of data from diverse sources to destination systems
- Collaborated with cross-functional teams during project planning sessions, analyzing business requirements and proposing optimal solutions
- Developed and implemented data pipelines using Azure Data Factory, employing data transformation activities to clean, enrich, and structure data for analytical purposes
- Worked with various data sources, including Azure SQL Database, on-premises SQL Server, Azure Blob Storage, and other cloud-based and on-premises repositories, ensuring seamless data connectivity
- Created and maintained SSRS reports focusing on key performance indicators (KPIs) and essential business metrics
- Played a pivotal role in converting SAP BO 4.1 reports and queries to Power BI, utilizing SQL, Azure SQL, and T-SQL
- Ensured seamless data validation with end-users
- Utilized Apache Spark within Databricks to process and transform large datasets, ensuring efficient and scalable data processing
- Collaborated with Azure architects to integrate cloud-based data storage and processing into Power BI solutions, leveraging Azure PaaS Data Services such as Azure SQL Database, Data Lake Store (Gen 2), and Data Factory
- Developed Power BI Visualization Dashboards and Scorecards, incorporating Power BI best practices and UI Design Principles for different departments within the bank
- Implemented incremental loading strategies to optimize data extraction and loading processes, reducing processing times and resource utilization
- Leveraged various data sources, including SQL Server, IIAS Server, Oracle, and Excel, to pull data into Power BI for comprehensive analysis
- Demonstrated expertise in writing calculated columns, Measures queries, and complex DAX Functions in Power BI desktop, showcasing advanced data analysis techniques
- Designing and developing automated workflows using Microsoft Power Automate to streamline business processes and increase operational efficiency
- Collaborating with stakeholders to gather requirements and identify opportunities for automation within various departments or functions
- Creating automated flows to automate repetitive tasks, such as data entry, file management, notifications, and approvals.
Data Analyst
Dubai Islamic Bank
04.2018 - 06.2022
- Documented effective and replicable methods for extracting data from different sources and organizing data sources for the Collection Department in the Bank
- Collaborated with stakeholders to identify business needs and data sources
- Provided data to users by extracting it from different databases like Oracle, DB2, Netezza, and Intellect System by writing SQL queries as and when required
- Utilized data visualization tools like Webi rich client, Power BI, SAS, SSRS, and Intellect System to effectively communicate business insights
- Worked with business intelligence software and various reports to glean insights into trends and prospects
- Automated Reports Like Provision Calculations, Incentives for Collectors, and End of end-of-service reports within the Department using SAP Business Intelligence, Power BI, and Excel using Macros and made readily available to the users as and when required
- Created universe using Information Design tool in SAP BI 4.1 and created web reports and scheduled the same to Top Management
- Actively involved in Noor Bank Migration with Dubai Islamic Bank to test, convert, and develop the reports of Noor Bank in Dubai Islamic Bank Environment
- Conducted exploratory data analysis using Databricks notebooks to uncover patterns, trends, and insights within the data
- Leveraged Spark SQL for querying structured data, facilitating in-depth analysis
- Worked in upgradation of different Systems like DB2, and Intellect System to validate the data and communicated the same to stakeholders and Business Analysts in case of discrepancies
- Integrating Power Automate with other Microsoft 365 applications, such as SharePoint, Outlook, Teams, and Dynamics 365, to create end-to-end automation solutions
- Proficient in Jira administration, including user management, project setup, workflow customization, and issue tracking, ensuring optimal utilization of the platform for project management and collaboration
- Experience in ALM (Application Lifecycle Management) processes, including requirements management, test case management, and defect tracking, utilizing tools such as Jira and ALM to streamline software development workflows and ensure project success
- Providing training and support to end-users on how to use and manage automated flows effectively.
Business Intelligence Consultant
Dicetek LLC
12.2016 - 03.2018
- Implemented Power BI datasets and reports for the Treasury team, emphasizing user requirements and a comprehensive understanding of Treasury Concepts
- Collaborated closely with end-users, prioritizing the documentation of requirements for a Power BI reporting solution, aligning with the Treasury team's needs
- Employed Power BI Promotion Manager with CTS for seamless migration of datasets, reports, and Dashboards across Dev, Test, UAT, and Production environments
- Focused on leveraging Azure Data Factory for ETL processes, extracting data from diverse Relational Databases (Azure SQL Database, Microsoft SQL servers) and loading it into environments such as BW, Azure SQL Database, Data Lake Store (Gen 2), and .txt & .CSV files
- Conducted thorough data modeling, prioritizing performance testing, and integration testing using Azure ETL capabilities and Power Query to ensure the efficiency and reliability of the reporting solution
- Managed the migration of all team projects from DEV to TEST to PS to PROD, placing a priority on ETL transformation jobs as part of administrative responsibilities, utilizing On-Premise Data Gateway
- Emphasized the design and development of interactive Dashboards on top of Power BI reports, with a focus on Azure-related technologies, BEx Queries, and OLAP Universe
- Created complex Power BI reports, giving priority to ETL transformation features such as Variables, Drill Downs, Sections, breaks, Merged Dimensions, etc., using Power Query and Power Pivot in accordance with Azure Data Factory-compatible design principles
- Configure new projects in Jira, defining project scopes, workflows, issue types, custom fields, and customizing workflows to align with project requirements and team methodologies, while overseeing accurate tracking and resolution of issues.
Business Intelligence Consultant
HTP Global Technologies
05.2015 - 12.2016
- Extracted data from diverse sources, including relational databases (e.g., Oracle, SQL Server), flat files, and web services
- Developed and deployed robust reporting, analytics, and Data visualization solutions utilizing the full suite of Power BI tools
- Expertise in Power BI components such as Power Pivot, Power View, Power BI Online, Power BI Desktop, and Power BI Publisher, coupled with advanced proficiency in DAX for effective data modeling and analysis
- Responsible for designing and implementing reporting solutions utilizing Reporting Services, Power BI, or other data visualization tools to meet business requirements
- Designed and developed reporting data modules specifically tailored for Marketing Analysis, ensuring relevant and actionable insights for stakeholders
- Applied various transformations using BODS functions and scripts for standardization, cleaning, and enrichment of extracted data
- Loaded transformed data into the target data warehouse or database, ensuring referential integrity and data consistency
- Implemented robust error-handling mechanisms and detailed logging for auditing, troubleshooting, and performance monitoring
- Designed and implemented incremental loading strategies for processing only changed or new data, minimizing processing time
- Integrated data quality checks and validation processes to ensure the accuracy and reliability of transformed data
- Integrated BODS with SAP systems to facilitate seamless data flow between BODS and other SAP BusinessObjects applications
- Configured job schedules for optimal execution times, considering system resource availability and business requirements
- Automated the entire ETL workflow for regular and consistent execution
- Fine-tuned job performance through optimizations such as pushdown optimization, parallel processing, and cache utilization
- Documented ETL job design, including source-to-target mappings, transformation logic, and any custom scripts or business rules
- Implemented monitoring mechanisms for tracking job execution, performance metrics, and data quality metrics
- Conducted regular maintenance tasks, including updating metadata, reviewing and optimizing transformations, and ensuring compatibility with evolving data landscapes.
SAP Business Objects Developer
Trowano Avenues
05.2014 - 05.2015
- Extensive experience in understanding and developing business requirements
- Direct interaction with client for requirement gathering and development of reports BO Administration by assigning security for users and groups, universes, reports, dashboards, folders, and classes at objects and row level
- Resolving different errors that occur when viewing reports/dashboards
- Scheduling of reports with the latest instance to the users
- Assigning object level and row level security at the universe level
- Worked on the development of the universe by resolving to join path problems like Loops, Chasm, and Fan traps and creating classes and objects
- Developed complex Webi reports from Multiple Data Providers
- Linking universes to share the common components/creating hierarchies at the universe level
- Development of web reports using reporting functionalities like sections/crosstab/alerts, breaks, ranking/drill, and prompts to retrieve relevant data
- Development and modification of database views Worked on implementing aggregate awareness in the universe to optimize reports
- Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from sources like Oracle and Delimited Flat files.
Software Engineer
Ninemind Software Services Pvt Ltd
10.2009 - 10.2014
- Inventory, Accounts Payable, and Purchase Orders were the different subject areas within the data warehouse
- Used advanced universe functionalities like Derived tables, Index Awareness, and custom LOVs
- Created custom hierarchies to aid in Drill-Through analysis of Webi documents and built cascading prompts
- Participated in the complete development lifecycle: analysis, design, build, and test reports
- Created several complex Web Intelligence and Desktop Intelligence reports to help management to track and monitor contract, commodity and price compliance
- Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting
- Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report
- Extensively used Calculations, Variables, User Objects in the creation of reports
- Created User Prompts, Conditions and Filters to improve the quality of report generation
- Scheduled Reports using scheduler Infoview as well as CMC
- Consolidation of reports by groups/regions and designing templates catering to the needs of sourcing/financial analysts & material and cost specialists.
SAP Business Objects Developer
Vinculum Solutions Pvt Ltd
10.2013 - 03.2014
Education
Bachelor of Technology - Electronics And Communication
Jawaharlal Nehru Technological University
Hyderabad, India05.2008
Skills
- Primary Job: Data Analyst
- ETL Tools: BODS, Azure Data Factory, Azure Databricks
- Reporting Tools: Power BI, SAP Business Objects
- Management Tools: Jira, Power Automate
- Azure PaaS Data Services: Azure SQL Database, Data Lake Store (Gen 2), Data Factory
- Azure PaaS Data Streaming Services: Azure Event Hub, Streaming Analytics
- Database Technologies: SQL, Azure SQL, T-SQL
Languages
English
Professional Working
Certification
PL-300: Microsoft Power BI Data Analyst
Timeline
Project Lead Consultant
Datamatics Global Services LLC
07.2022 - 01.2023
Data Analyst
Dubai Islamic Bank
04.2018 - 06.2022
Business Intelligence Consultant
Dicetek LLC
12.2016 - 03.2018
Business Intelligence Consultant
HTP Global Technologies
05.2015 - 12.2016
SAP Business Objects Developer
Trowano Avenues
05.2014 - 05.2015
SAP Business Objects Developer
Vinculum Solutions Pvt Ltd
10.2013 - 03.2014
Software Engineer
Ninemind Software Services Pvt Ltd
10.2009 - 10.2014
Bachelor of Technology - Electronics And Communication
Jawaharlal Nehru Technological University
Similar Profiles
VARSHA RAMWANIVARSHA RAMWANI
Team Leader at DATAMATICS GLOBAL SERVICES PRIVATE LTDTeam Leader at DATAMATICS GLOBAL SERVICES PRIVATE LTD
Siva Kumar PallapuSiva Kumar Pallapu
SQL Developer at Datamatics Global services limitedSQL Developer at Datamatics Global services limited
Shiril TripathiShiril Tripathi
Senior Software Consultant / Backend Lead Developer at Datamatics Global Services Pvt. Ltd.Senior Software Consultant / Backend Lead Developer at Datamatics Global Services Pvt. Ltd.
Cassandra MandapCassandra Mandap
Nursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery UnitNursing Clinical Student Practical Nurse at Humber River Hospital- Inpatient Surgery Unit
Dominik SzwecDominik Szwec
Union Clerk/Supervisor at Daniel's No FrillsUnion Clerk/Supervisor at Daniel's No Frills