Manahil Sajjad
Data Analyst
Lahore
Summary
I am a dedicated and passionate database developer with a strong commitment to delivering high quality, designing and optimizing the queries to meet client objectives. I am proficient to write complex SQL queries and optimizing database performance, utilizing indexing strategies, and implementing normalization techniques and also visualize the data in Excel, Power Bi and Tableau. Managing large datasets, creating detailed reports, and delivering insights that drive strategic business decisions.
Overview
4
4
years of professional experience
7
7
years of post-secondary education
Work History
Data Analyst
Ecomspot
04.2023 - Current
- Gathering data from various sources and ensuring it is accurate and usable.
- Using statistical tools and software to interpret complex data sets and identify trends or patterns.
- Creating charts, graphs, and dashboards to present findings clearly and effectively to stakeholders.
- Compiling reports that summarize data analysis and provide actionable insights for decision-making.
- Working with databases and data management systems to organize and maintain data integrity.
- Proficiency in tools and languages such as SQL, Python, R, Excel, and data visualization platforms like Tableau or Power BI.
- Applying analytical skills to address business challenges and optimize processes.
- Presenting findings and recommendations to both technical and non-technical audiences, often including executives.
Software Engineer
Joblogic (UK)
02.2021 - 04.2023
- Design and optimize databases using SQL, MySQL and also retrieve the data using Microsoft SQL Server Management Studio.
- Implement version control using Git, facilitating collaboration and efficient code management.
- Stay up-to-date with emerging web development trends, technologies and best practices and share knowledge within the team.
- Provide ongoing website maintenance and support, addressing any technical issues or updates as needed.
- Gathering all the requirements and analysis sessions, providing technical insights and offering suggestions for optimal solutions.
- Review the code and provide the feedback on software requirements and design updates, provide the better optimal solution.
- Compile the test cases with a highly creative approach considering multiple and unique test scenarios of the wider QA team.
- Conducted detailed review sessions with Business Analyst, Designer and Developers.
- Gained strong Knowledge and understanding of requirements for the project.
- Key contributor to daily standup, project team meetings and sprint planning meetings.
Web Developer
House Of professionals
10.2020 - 1 2021
- Analyze the requirements and design the websites according to the requirements of the client.
- Develop and maintain responsive and user-friendly websites using HTML, CSS, Bootstrap and javaScript / JQuery.
- Collaborate with cross-functional teams, including designers and project managers to gather requirements and translate them into functional web interfaces.
- Designing and optimizing the queries using SQL Server Management Studio.
- Review the code to maintain the code quality and ensure adherence to coding standards, best practices and project requirements.
Education
Bachelors in Electrical Engineering -
National University of Computer and Emerging Sciences (FAST - NUCES - Lahore Campus)
01.2016 - 04.2020
Intermediate in Computer Science - undefined
Kips College, Johar Town Lahore
01.2014 - 04.2016
Skills
Data Analysis & Visualization: Excel: Advanced formulas, pivot tables, macros, and data visualization Power BI: Data modeling, DAX, report creation, and interactive dashboards Tableau: Data visualization, dashboard design, and calculated fields
Writing and optimizing queries, database design, and data manipulation
Data manipulation, numerical analysis, visualization, and machine learning
Descriptive statistics, inferential statistics, hypothesis testing, regression analysis
Data preprocessing, transformation, and integration
Ability to interpret complex data and identify trends and patterns
Clearly presenting data findings and insights to non-technical stakeholders
Familiarity with version control systems like Git
Skills and Testing Tools
- Microsoft Excel
- Power BI
- Tableau
- Python
- SQL / MySQL
- HTML 5
- CSS 3
- Bootstrap 4
- SCSS
- Git
- Jira
- Java Script/J Query
Languages
English
Urdu
Punjabi
Timeline
Data Analyst
Ecomspot
04.2023 - Current
Software Engineer
Joblogic (UK)
02.2021 - 04.2023
Web Developer
House Of professionals
10.2020 - 1 2021
Bachelors in Electrical Engineering -
National University of Computer and Emerging Sciences (FAST - NUCES - Lahore Campus)
01.2016 - 04.2020
Intermediate in Computer Science - undefined
Kips College, Johar Town Lahore
01.2014 - 04.2016