ABHISHEK SARAF
Arlington,TX
Summary
Highly skilled data analyst with expertise in SQL, SSIS, and ETL processes using Informatica PowerCenter. Proficient in writing and executing complex SQL queries and stored procedures. Equipped with comprehensive programming knowledge in Python, R, and SQL, along with proficiency in data analysis & visualization, machine learning algorithms, and mathematical modeling. Proven experience of 2 years as a data analyst, utilizing advanced analytics and data-driven insights to drive business growth and optimize operational efficiency. Adaptable and driven with a strong work ethic and ability to thrive in team-based or individually. Articulate communicator and proactive team player with demonstrated ability to collaborate with peers, senior management, and stakeholders in comprehending key requirements and executing procedures accordingly. A quick and persistent learner with a positive attitude and passion for keeping abreast of the latest tools and technologies.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analyst
Hopkins Software Pvt Ltd
04.2021 - 11.2022
- Developed and implemented SQL and Python code for data preprocessing, and deployed predictive models using machine learning techniques to generate data-driven insights, enabling accurate forecasting of local real estate market prices
- Worked closely with cross-functional teams to incorporate market trends into models, and designed Tableau dashboards to simplify complex outputs, enhancing stakeholder visibility and decision-making
- Utilized advanced analytics to quantify project potential, significantly increasing the likelihood of investment by 100%.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Utilized data visualization techniques to present and explain complex data sets.
Data Analyst Intern
Hopkins Software Pvt Ltd
11.2020 - 04.2021
- Conducted thorough data validation and cleanup, ensuring the accuracy and reliability of datasets used for analysis.
- Optimized SQL queries for faster processing times, increasing overall productivity within the team.
- Enhanced data visualization capabilities for better decision-making with the use of advanced BI tools.
- Completed data cleaning and validation of existing spreadsheets to promote a robust data management platform, resulting in accurate data analysis and entry.
- Converted raw datasets into meaningful formats by performing extensive pre-processing activities such as normalization and transformation.
- Identified bugs in data collection or reporting and investigated root causes.
- Applied machine learning algorithms to enhance analytical capabilities and uncover hidden patterns within the data.
- Created data models to support decision-making processes.
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
Education
Master of Science - Data Science
The University of Texas At Arlington
Arlington, TX05.2024
Bachelor of Technology - Civil Engineering
Anurag University
Telangana, India07.2021
Skills
- Technical Stack
- Programming Languages:
- Python (Pandas, scikit-learn), R, SQL, C
- ETL Tools: SSIS, Informatica PowerCenter
- Frameworks & Libraries: Cassandra, MongoDB, scikit-learn, PySpark, TensorFlow, PyTorch, and Apache Spark
- Web Technologies: HTML, CSS
- Databases: MySQL, PostgreSQL, NoSQL databases (MongoDB, Cassandra)
- Data Visualization Tools: Tableau, PowerBI, Matplotlib, Seaborn
- Microsoft suite: Visio, Word, Excel, Powerpoint
- Machine Learning: Supervised and unsupervised learning techniques, regression, classification, clustering, ensemble methods
- Statistical Analysis: Hypothesis testing, probability distributions, statistical modeling
- Data Analysis
- Project Management
- Data and Analytics
- Report Writing
Certification
- Udemy - Complete python bootcamp from zero to hero in python
- Udemy - Learning python for data analysis and data visualization
- Udemy - Data visualization in Excel: All Excel Charts and Graphs
- Udemy - python 101- for data analysis
- Coursera - Foundations on data science: K-means clustering in python
Timeline
Data Analyst
Hopkins Software Pvt Ltd
04.2021 - 11.2022
Data Analyst Intern
Hopkins Software Pvt Ltd
11.2020 - 04.2021
Master of Science - Data Science
The University of Texas At Arlington
Bachelor of Technology - Civil Engineering
Anurag University