Harshil S.
Data Scientist @CMiC
Signup · Get unlimited contacts
WORK HISTORY
Data Scientist @CMiC
North York, ON, CA
Analyzed and documented the scope of work for Data Extraction projects- Provided estimates for Data Mapping and Extraction scripts creation- Designed, developed, and maintained scripts and queries for Data Mapping and Extraction tasks from multiple legacy systems on different platforms- Examined, designed, developed, and maintained SQL scripts and queries for Data Conversion tasks- Working with external Data Extraction programmers to understand and resolve issues with incoming data- Assisting customers with Data Mapping and Extraction activities- Working with data owners to verify data accuracy and integrity- Developing and executing database queries as needed- Performing data corrections through analyzing data for errors and formulating corrective procedures- Working with other team members to efficiently troubleshoot issues related to Data Conversion- Providing ongoing status and feedback of the Data Conversion process to all parties involved
EDUCATION
George Brown Polytechnic
Postgraduate Degree, Artificial Intelligence
Algoma University
Postgraduate Degree, Information Technology
Parul University
Bachelor's degree, Computer Science
ABOUT HARSHIL S.
Accomplished Data Scientist with nearly 3+ years of experience, adept in utilizing SQL for advanced data extraction, transformation, and loading processes. Proficient in crafting optimized queries, executing complex data joins, and managing subqueries and window functions for comprehensive analysis- Highly skilled in Python programming and scripting, leveraging libraries such as Pandas, NumPy, Matplotlib, Seaborn, and R for in-depth data analysis, manipulation, and visualization. Proficient in VBA and SAS, automating data tasks and analysis to deliver actionable business insights- Expert in creating compelling Data Visualizations using Power BI, Tableau, and Looker, developing interactive dashboards and reports that translate complex data into visually appealing, easily understandable formats, empowering stakeholders to make data-driven decisions- Advanced proficiency in Excel, utilizing pivot tables, VLOOKUPs, macros, and sophisticated formulas to conduct detailed data analysis, automate repetitive tasks, and enhance reporting accuracy and efficiency- Experienced in Database Management and Optimization, with practical expertise in MS SQL Server, SSIS/SSRS, and Snowflake. Adept at query optimization and database design, significantly improving data retrieval and processing efficiency- Proficient in Data Cleaning and Wrangling, skilled in handling missing values, data transformation, and normalization to ensure data integrity and accuracy. Experienced with ETL tools and Azure, ensuring high-quality analysis- Expert in Data Analysis & Modeling, leveraging Power Query, DAX, and various machine learning models to extract insights, predict trends, and support strategic decision-making- Proficient in implementing Machine Learning techniques, including linear regression, logistic regression, and decision trees. Skilled at predicting trends and identifying patterns in data, enhancing business forecasting and strategic planning- Solid mathematical and statistical foundation, specializing in probability theory, hypothesis testing, inferential statistics, and descriptive statistics. Capable of performing rigorous analysis and validation of data findings- Experienced with Enterprise Resource Planning (ERP) systems, particularly SAP, to streamline business processes and integrate data across various functions, driving operational efficiency- Proficient in utilizing Customer Relationship Management (CRM) software to analyze customer interactions and data throughout the lifecycle, enhancing business relationships and driving sales growth
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.