Harshkumar Dhanani
DATA ANALYST
NJ, USA +1-314-***-**** **************@*****.*** LinkedIn
SUMMARY
• Possessing 4+ years of practical experience as a Data Analyst across diverse industries, showcasing proficiency in data analysis, visualization, and interpretation.
• Skilled in data extraction, cleaning, transformation, and preparation from multiple sources, including insurance policy databases, claims systems, and IT infrastructure logs.
• Adept at performing advanced statistical analysis, predictive modelling, and machine learning techniques to identify patterns, trends, and anomalies in insurance and IT data.
• Experienced in developing data-driven risk assessment models, fraud detection algorithms, and pricing strategies for insurance products and services.
• Proficient in creating insightful data visualizations, interactive dashboards, and reports to communicate complex findings to stakeholders, including underwriters, actuaries, and IT managers.
• Collaborated closely with cross-functional teams, including actuarial, underwriting, claims, IT operations, and data engineering, to understand data requirements and provide relevant analysis.
• Contributed to the design, development, and maintenance of business intelligence (BI) systems and reporting tools tailored to the insurance and IT domains.
• Ensured compliance with relevant regulations, industry standards, and data privacy laws in the insurance and IT sectors.
• Continuously improved data analysis processes, explored new techniques, and implemented best practices to enhance efficiency and effectiveness.
• Proficient in a broad spectrum of technical tools and methodologies, including Python, SQL, R, Pandas, NumPy, Tableau, and Power BI.
• Skilled in the management of various databases such as MySQL, MongoDB, PostgreSQL, and SQL Server.
• Hands-on experience utilizing cloud technologies, particularly Amazon Web Services (AWS), for secure and scalable storage of both raw and processed data.
TECHNICAL SKILLS
Methodologies: SDLC, Agile, Waterfall
Language: Python, SQL, R
Packages: Pandas, NumPy, Matplotlib, SciPy, Seaborn, Scikit-Learn, ggplot2 Data Visualization Tools: Tableau, Power BI, Advanced Excel, Statistics Database: MySQL, MongoDB, PostgreSQL, SQL Server
IDEs: Visual Studio Code, PyCharm, Jupyter Notebook Cloud Technologies: Amazon Web Services (AWS), GCP Other Technical Skills: Machine Learning Algorithms, Mathematics, Probability distributions, ANOVA, Hypothesis Testing, Regression Analysis, Linear Algebra, Advance Analytics, Data Mining, Data warehousing, Data transformation, Data Storytelling, A/B Testing, Forecasting & Modelling, Data Cleaning, Data Wrangling, Requirement Gathering, Root Cause Analysis, Jira, Git, GitHub
Operating System: Windows, Linux, Mac OS
PROFESSIONAL EXPERIENCE
Data Analyst Radian Group, NJ Jan 2023 – Present
• Engaging in the complete Software Development Life Cycle (SDLC), adhering to Agile methodologies, to develop the application.
• Utilizing Power BI for crafting diverse analytical dashboards, aiding business users in swiftly grasping data insights.
• Engaging in data cleaning, mining, and wrangling processes, rectifying unorganized, inconsistent, and erroneous data using NumPy and Pandas in Python.
• Maintain and enhance data analysis tools, processes, and techniques for continuous improvement.
• Executing Data extraction, cleaning, loading, analysis, wrangling, and Predictive Modelling employing R and Python, resulting in a 30% increase in data accuracy and model performance.
• Formulating SQL queries/reports to extract metrics from SQL Server essential for the executive management team, facilitating a 10% improvement in data accessibility and reporting efficiency.
• Work closely with actuarial teams, underwriters, claims handlers, and other stakeholders to understand their data needs and provide relevant analysis.
• Contributing to developing machine learning models using Scikit-learn library in Python, including model selection, hyperparameter tuning, cross-validation, and evaluation metrics optimization.
• Optimizing Alteryx workflows for performance, efficiency, and reusability by identifying and implementing workflow optimizations, such as parallel processing, caching, and modularization.
• Developing Visualforce pages utilizing Lightning Web Components (LWC) for a proprietary CRM application to monitor business flow, leading to a 15% improvement in user interface responsiveness and user experience. Data Analyst Exert Infotech, India Jan 2019 – Dec 2021
• Developed and maintained data pipelines or ETL processes to ensure data consistency and reliability, while aiming for a 10% improvement in efficiency and reliability quarterly.
• Utilized data analysis packages such as Pandas, NumPy, SciPy, and Matplotlib for product development.
• Created and maintained a data rules spreadsheet using a spreadsheet application, such as Google Sheets or LibreOffice Calc, to update allowed values, findings, and profiling results.
• Conducted data cleaning processes to identify and rectify errors, inconsistencies, and missing values in datasets.
• Designed dashboards using visualization tools like Tableau, incorporating calculated fields, parameters, calculations, groups, sets, and hierarchies for effective data presentation, aiming for 10% improvement in dashboard usability and effectiveness annually.
• Implemented and managed the reporting infrastructure, utilizing a SQL Server database, with a target of 15% enhancement in reporting speed and accuracy annually.
• Executed tasks related to Data Profiling, Data Cleansing, Data Mapping, and Data Quality enhancement to ensure the integrity and accuracy of the data being analyzed, striving for a 10% increase in data quality and integrity quarterly.
• Conducted A/B testing to evaluate the effectiveness of different strategies or interventions. EDUCATION
Master of Science in Computer Science – NEW JERSEY INSTITUTE OF TECHNOLOGY, NJ, USA Bachelor’s in Information Technology – LDRP INSTITUTE OF TECHNOLOGY AND RESEARCH, India CERTIFICATIONS
• AWS Certified Cloud Practitioner
• Google Data Analytics