Ahmed Saad
Meerut
Summary
Around 4.5 years of strong experience in Business and Data Modelling/ Data Analysis, Data Quality, Data Governance, Data Integration.
Knowledge of Enterprise Data Warehousing including Data Modelling ,Data Integration (ETL/ELT) and Business Intelligence.
Skilled in implementing SQL techniques such as JOINS, Updating &Creating tables and basic queries.
Knowledge in Dimensional Data Modelling, Star Join Schema/Snowflake modelling, FACT & Dimensions tables, Conceptual, Entity-Relationship Diagram.
Responsible for data modelling.
Experienced in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
Thorough Knowledge in creating DSC (Data Schema), DPD (Data Point Dictionary) .
Experienced in Creating and Maintaining documentation such as Data Schema/Data Point Dictionary/ETL Specifications.
Hands on experience using Excel (Data formatting , Data Validation , Pivot Tables ) .
Exposure in writing simple SQL, PL/SQL queries.
Overview
4
4
years of professional experience
Work History
Data Analyst
Webhelp India Private Limited
01.2023 - 09.2023
- Experience in using excel function and formulas.
- Developed ERD using Star & Snowflake Schemas.
- Designed Data Schema ( DSC ) , Data Point Dictionary ( DPD ).
- Created documents like Data schema for correct update of database & Data Point Dictionary using excel to ensure the correct calculation for analytics .
- Knowledge in Data Modelling, Star Join Schema/Snowflake modelling, FACT & Dimensions tables, Entity-Relationship Diagram.
- Experienced in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
- Optimized ETL processes for faster and more accurate data integration.
- Empowered students to solve complex problems using advanced Excel functions such as PivotTables, VLOOKUP, and conditional formatting tools.
- Worked with above practices to ensure accurate and required analysis for clients like : The Very Group , Avantia , BMW , Sainsbury's etc.
Data Analyst
SofttechEra
02.2022 - 12.2022
- Maintained up-to-date knowledge of industry trends and advancements in data analytics, enhancing adaptability of solutions provided.
- Designed data schemas to ensure correct update of data.
- Implemented robust quality control measures to minimize errors and improve reliability of analytical outputs.
- Resolved complex business challenges by using Excel and PostgresSQL to ensure correct calculation of analytics.
- Streamlined data processing for faster results by implementing analytics.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Produced monthly reports using Excel spreadsheet functions.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Increased data accuracy by implementing thorough validation checks and error-handling mechanisms.
- Created and updated tracking spreadsheets using MS Excel.
Business Development Executive
Extramarks Education Pvt Ltd
04.2019 - 12.2021
- Gathered business requirements, working closely with business users, project leaders, and developers.
- Analysed business requirements and designed Conceptual and Logical Data models.
- Involved in Data analysis.
- Involved in extracting data from SQL.
- Knowledge in SQL queries using joins and basic function.
- Work with Data Architect on Dimensional Model with both Star and Snowflake Schemas utilized.
- Documented Source to Target mappings as per business rules.
- Performed Preparation and processing required to start service.
- Quickly analyse data and bring meaningful insight using Spreadsheet , excel , SQL.
- Having hands on experience with Freshdesk & Salesforce (CRM).
- Hands on experience in Spreadsheets.
Education
Bachelor of Technology - Mechanical Engineering
Raj Kumar Goel Engineering College
Ghaziabad , India07.2018
Skills
- Excel, SQL
- Data Modeling
- MS-Office Package
- Microsoft Office (Windows, Word, Excel)
- MS Excel
- Using advanced Excel features like Pivot tables and Charts for generating Graphs
- Designed and developed weekly, monthly reports using MS Excel Techniques (Charts, Graphs, Pivot tables)
- Strong Excel skills, including pivots, VLOOKUP, conditional formatting, large record sets Including data manipulation and cleaning
- ETL, DSC (Data Schema), DPD(Data Point Dictionary), Snow-flak schema, SQL
- Business intelligence, Data Designing
- SpreadSheet, ETL, MS Excel
- Data Analysis
- Data Modeling
- Spreadsheets
- Time Management Abilities
- Clear Communication Skills
- Attention to Detail
- Analytical and Critical Thinking
- Active Listening
- Multitasking Abilities
Timeline
Data Analyst
Webhelp India Private Limited
01.2023 - 09.2023
Data Analyst
SofttechEra
02.2022 - 12.2022
Business Development Executive
Extramarks Education Pvt Ltd
04.2019 - 12.2021
Bachelor of Technology - Mechanical Engineering
Raj Kumar Goel Engineering College
Similar Profiles
Shalu SharawatShalu Sharawat
Business development assistant at Webhelp India Private LimitedBusiness development assistant at Webhelp India Private Limited
Krinjal GuptaKrinjal Gupta
Process Associate at Webhelp India private limitedProcess Associate at Webhelp India private limited
KAMAL TEJA NARMETAKAMAL TEJA NARMETA
Contact Center Associate at Webhelp India Private LimitedContact Center Associate at Webhelp India Private Limited