MD SAQUIB ZEYA

No Project was Assigned.

• A) Primarily worked on development of legacy DMS based on the provided requirements from scratch to start of production
• b) Worked on different DMS of automotive industries and extract the data from their DMS into AWS s3 bucket
• c) Worked with Data Engineering team to migrate the data from Stage, Process and Models and analyzed the data into AWS s3 bucket.
• d) As a part of accounting team, working on large datasets of data coming from dealership point and do the validation in AWS ATHENA using SQL .
• e) Analyzed the validation then by the QA team and provide the conversion sign off when validation is passed.
• f) Created interactive dashboards using Tableau to visualize trends and patterns, facilitating data-driven decision-making across the organization.
• g) Used Data Blending, groups, combine fields, calculated fields and aggregated fields to compare and analyze data in different perspectives.

• A) Developed and implemented advanced analytics solutions to optimize marketing campaigns, resulting in a 20% increase in customer acquisition.
• b) Managing advertising campaigns on digital marketing, social media advertising and on different DSP like Trader Desk and Google DBM
• c) Experience in Designing and Visualizing the datasets of Visio content and Visio commercial using the Tableau.
• d) Work closely with traders, sales and Client in US on various campaigns from scoping things to deliver the desired output e) Using tools like Python, SQL, MS EXCEL, and Azure Data brick for various Analysis.

• Consulting project- I'm working as an individual contributor (IC)with KPMG Netherlands consulting team to generate & modify business data & business data reports & dashboards for various Europe Clients by using SQL, Excel, Alteryx.
• Also, in Consulting Project I write custom SQL queries on SSMS in order to serve ad hoc data request from various clients
• I built Power-BI dashboards & business reports for various clients to give them data visualization & data analytics solutions in order to improve their business strategy & performance.
• Audit Data Analytics Project- I'm working as an individual contributor (IC) with KPMG Netherlands Audit Data Analytics team to generate reconciliation audit data reports with the help of Alteryx, Excel & Client data
• Then I perform different audit data analytics operations with the help of KPMG data analytics proprietary tools to provide Audit Data Analytics solutions to various Europe Clients.
• In this project before generate the reconciliation audit data reports, I built Alteryx ETL Data Workflow on client data in order to achieve Data Cleaning & Data Validation operations, resulting the accurate data analysis in audit.

• A) Hands on experience of Extraction, Transformation and Loading in SQL server database.
• b) Hands on experience in Designing and Visualizing the datasets using the BI tool like Tableau.
• c) Hands on experience in creating and reporting datasets using Excel.

• Handling the customer through emails, chats and make the weekly, Monthly report in excel of the products sold across the cities in Excel