Default profile banner
MA

Mohd Arqam

@mohdarqam

Data Analyst at Innovaccer Analytics Pvt Ltd

New Delhi, India

Innovaccer Analytics Pvt LtdJamia Hamdard University

Highly skilled Data Analyst with 3+ years of experience in developing, implementation and optimization of data workspace and workflow and ETL processes. Track record of improving data quality and accessibility. Developed and implemented a data cleaning and preprocessing framework that improved data quality by 30%.

Experience

Data Analyst

Innovaccer Analytics Pvt Ltd

•Dec 2021 - Present•Noida, India

Participated in daily scrum meeting with team to discuss the challenges and development of the project. Assisted in the design and development of an ELT pipeline, resulting in a 30% increase in data integration efficiency. Created SQL code to extract and transform data for business requirements, increasing accuracy by 95%. Worked on the tuning of SQL Queries to bring down run time by working on Indexes and Execution Plan. Strong client-facing written and oral communication skills; along with an aptitude for business analysis and solution design. Execute complex, ad-hoc analysis and proactively look for further insights and root cause. Utilized SQL and Python to analyze large datasets, resulting in the identification of key insights. Improved data accuracy and reduced data processing time by 40% by optimizing and automating data cleansing, extraction, and analysis processes. Worked on Power BI dashboards and ad hoc DAX queries for power bi. Worked on popular protocols and tools used for data transfer (e.g., SFTP & AWS S3). Worked on confluence and Jira.

Data Analyst

ANR Software Pvt Ltd

•Nov 2019 - Dec 2021•Noida, India

Worked as a Data Analyst with wide experience in Technical Analysis and Software Implementation Support. Developed a dashboard for health and Net Sale trends in python dash framework to Identify the performance of all clients to help the Business in taking merchandising decisions. Developed and maintained automated scripts to extract, transform, and load data from various sources, resulting in a 50% reduction in manual data entry efforts. Collected, organized, and input information into databases for storage. Presented data summaries and visualizations to stakeholders, leading to improved decision-making and better alignment of goals. Proficiency in PostgreSQL, Python and Power Bi.

Education

Jamia Hamdard University

Bachelor of Technology

Electronics and The Communication

Jan 2015 - Jan 2019

Mathematics

Licenses & Certifications

Master Power Bi

• No expiration

Hacker Rank SQL

Hacker Rank

• No expiration

Advanced Snowflake

• No expiration

Data Science with Python

• No expiration

Skills

Advanced SQL Querying
Data Visualization
Dashboarding
Data Ingestion
ELT Pipelining
Data Warehousing
Report automation
Excel
Python
R
Data Analysis
Data Modeling
Ad-hoc Analysis
Pipeline Development
Analytical thinking
Problem-solving abilities
Agile Methodology
PostgreSQL
Power BI
AWS S3
SFTP
Jira
Confluence