Hem Raval
Data Analyst
Talent
United Center, City of Chicago, CookMember since July 5, 2023
·
Hire this person
Send a job offer directly to this candidate
About
My name is Hem Raval and I believe that, with my skills, experience, and attitudes, I can bring a lot to the company, and I’m excited about the prospect. I feel that my skills and experience are a great fit for the position of Data Analyst. Please feel free to contact me to arrange an interview. Mentioned below are my Experiences and Expertise levels.
- 2 years of experience as a Data Analyst with Design, Modeling, Development, Implementation, and Testing of Data Warehouse applications.
- Good knowledge of the Software Development Life Cycle (SDLC), Agile, and Waterfall Methodologies.
- Working experience in using various packages in R and Python-like ggplot2, pandas, NumPy, SciPy, and Matplotlib.
- Good knowledge of various Python IDE such as Visual Studio Code and PyCharm.
- Well-Versed in designing visualizations using Tableau and Power BI software.
- Knowledge of Data Interpretation, Data Analysis, and Data Integration by using Databases like MySQL and MS SQL Server.
- Understanding of Data extraction, Data cleaning, Data Loading, Statistical or Exploratory Data Analysis, Data Involving complete Agile Requirement Analysis, Development, System, and Integration Testing.
- Responsible for multithread code and applications using Python languages.
- Creating various capacity planning reports using Python packages such as NumPy, Pandas, matplotlib, and SciPy.
- Create action filters, and parameters, and calculate sets for preparing dashboards and worksheets in Tableau.
- Develop the necessary Stored Procedures and created Complex Views using Joins for robust and fast retrieval of data in SQL Server.
- Use pivot tables and tips and tricks in MS Excel for efficient data entry and analysis.
- Performing data analysis and maintenance on information stored in MySQL database.
- Worked in Waterfall methodologies with quality deliverables delivered on time.
- Implemented Machine learning models in R and Python for business forecasting.
- Worked with Development IDE such as Visual Studio Code and PyCharm.
- Programmed a utility that used multiple packages in Python like NumPy, Pandas, Matplotlib, SciPy, and ggplot2 in R.
- Transformed and merged data as per the requirement for ease of analysis in Excel by using Power Query in Power BI.
- Created functions, triggers, views, and stored procedures using MySQL.
- Conducted Statistical Modeling of data on how providers submit outpatient authorizations using Pivot Tables in Excel.
- Participated in all phases of data mining, data collection, data cleaning, developing models, validation, and visualization.
Experience
- 2 years of experience as a Data Analyst with Design, Modeling, Development, Implementation, and Testing of Data Warehouse applications.
- Working experience in using various packages in R and Python-like ggplot2, pandas, NumPy, SciPy, and Matplotlib.
- Proficient in SDLC, Agile, and Waterfall methodologies for efficient project management and software development processes.
- Skilled in working with Visual Studio Code, PyCharm and Jupyter Notebook IDEs for efficient coding and collaboration.
- Proficient in utilizing Amazon Redshift, Snowflake, Amazon S3, and EC2 for scalable data storage, processing, and analytics in cloud-based environments.
- Well-Versed in designing visualizations using Tableau and Power BI software.
- Knowledge of Data Interpretation, Data Analysis, and Data Integration by using Databases like MySQL and MS SQL Server.
- Understanding of Data extraction, Data cleaning, Data Loading, Statistical or Exploratory Data Analysis, Data Wrangling, and Predictive Modeling using R and Python.
Education
Master of Science - Cyber Security
Bachelor of Engineering - Information Technology
