Khalid Ansari

Background

About Khalid Ansari

Data Analysis Expertise: With 3+ years in Data Analysis, I excel in Data Extraction, Modelling, Wrangling, Statistical Modelling, Mining, and Visualization. My strength lies in spotting inconsistencies during ETL, ensuring impeccable datasets. I'm process-driven, using SQL, Tableau, Power BI, Advanced Excel, Python, and R for intricate problem-solving. I've harnessed machine learning libraries like SciKit-Learn, TensorFlow, and PyTorch for highly accurate predictions. ‍ Technical Skills: My mastery extends to SQL, Python, and R, backed by Pandas, NumPy, dplyr, and tidyr for data manipulation. I'm adept at scripting complex SQL solutions in SQL Server and MySQL, including Procedures, Functions, and Triggers. My visualization toolkit includes Matplotlib, Seaborn, and Plotly, while Python and SQL drive my model development and validation. Visualization Tools: Proficient in Tableau for reports and data alignment, and Power BI for diverse data fusion, report generation, and dashboard creation. My Excel expertise spans pivot tables, VLOOKUP, and HLOOKUP. 🤝 Collaboration & Cloud Integration: I've collaborated with cross-functional teams, optimizing data pipelines for integrity and availability. My proficiency spans AWS services like Amazon S3 for robust storage, Lambda for serverless computing, EC2 for scalability, and RDS for relational databases. In GCP, I've excelled in Big Query for insightful analysis. Modeling & Decision Making: I transform business needs into structured models—be it Dimensional, Physical, or Logical Modelling. I rely on A/B testing to make informed decisions. Data Mining & BI: I'm an expert in data mining, predictive modelling, and web scraping, utilizing tools like Scrapy, BeautifulSoup, and Selenium. My BI proficiency spans Data Warehousing, advanced querying, and spreadsheet analysis. With tools like Hadoop, PySpark, and Dask, I handle big data and parallel computing efficiently.