ankit kumar

Senior Analyst

MarkScan•  November 2023 - Present•  Noida

• Spearheaded comprehensive data collection strategies, ensuring the acquisition of relevant and high-quality data from various sources. • Applied data mining techniques to extract valuable insights and patterns from extensive datasets, contributing to informed decision-making processes. • Utilize Python and Pandas for efficient data cleaning, transformation, and manipulation, ensuring data accuracy and consistency. Monitor and manage scraping performance metrics, such as response times and throughput, to ensure efficient data extraction. • Utilized Excel for efficient data manipulation, analysis, and visualization, producing insightful reports to facilitate data-driven decision-making. • Integrate Power BI with various data sources, databases, and third-party applications. Utilize SQL and other scripting languages to retrieve, manipulate, and prepare data for Power BI. • Executed ETL processes, resulting in a 40% reduction in data integration time and seamless integration of diverse datasets into Power BI. • Developed visually appealing dashboards in Power BI, utilizing Power Query for data transformation, leading to a 20% increase in user engagement. • Implemented DAX formulas to create sophisticated calculations and custom metrics, enhancing the depth of analysis within Power BI. • Technical Skills: Python, SQL, ETL, Data Mining, Power Query, Data Modelling, DAX, Power BI Services.

Data Analyst

Networks Globe Private Limited•  November 2022 - November 2023•  Noida

• Collaborating with cross-functional teams to gather requirements for data-related projects. • Design, develop, and maintain scalable data workflows for Data Analytics. • Implementing data integration solutions to enable seamless data flow across systems. • Perform data collection, cleaning, transformation, and validation using Excel, Pivot Tables, and Python. • Develop and refine SQL queries to extract specific datasets from databases. • Optimize SQL queries for performance and efficiency in handling large datasets. • Ensure data accuracy and integrity by validating SQL query results against business requirements. • Supporting data analysis and reporting activities by providing timely and accurate data sets. • Building engaging and visually appealing dashboards and reports using Power BI. • Technical Skills: Python, SQL, MS Excel, Pivot Tables, Data Cleaning, Power Query, Power BI.