SUMMARY

-*+ years of experience as a Data Science Specialist/Analyst

-Expertise in Data mining using SQL from a large database.

-Proficient in overall Data retrieving, cleaning data and report writing.

-Exposure to python libraries NumPy, Matplotlib, Seaborn, Spark, and ML.

-Exposure to Hadoop, Spark, PySpark, Data Pipelines, DataBrick – Big Data Technology.

-Hand on experience in writing and editing queries using tools like Heidi and MySQL Workbench.

-Strong ability to translate statistical data into meaningful facts, by representing it in Microsoft Excel for business to help management, to make better business decisions.

-Strong troubleshooting, analytical and problem-solving skills.

-Excellent team player with active participation in meetings with the management, testing, development teams and clients.

-Strong abilities to work in pressurized environments, effective problem solving and trouble-shooting skills, quick learner and adapt new tools and technology.

-Intensive experience as QA with Defect Logging, Tracking and Reporting using test management/defect tracking tools like JIRA and Asana.

-Experienced with all the phases of software testing life cycles and have an excellent understanding of Software Development Life Cycle (SDLC).

-Excellent knowledge of Programming languages and Web Design - C, C++, Core JAVA, HTML, JavaScript, CSS, Image Processing and Python.

-Knowledge of Multithreading Concept, Object Oriented Programming (OOP), MVC, Data Structure, Data Warehouse and Analytics.

-Experienced using development tools like X-Code, Eclipse, Dreamweaver, and MATLAB.

-Hand on experience with Ticket System – Smarter Track and Microsoft Office suite - Word, Excel, Power point, Outlook, and Access.

-Ability to meet, prioritize and manage multiple simultaneous tasks and deadlines.

-Familiarity with GIT, Data Visualization Tool Tableau.

PROFESSIONAL SKILLS

Languages : Python, C, C++, Core Java, Objective – C

Web : HTML, Java Scripts, CSS.

Database : MySQL and MS Office Access

Tools : Jupyter notebook, MySQL Workbench, MATLAB 2012a, XCode, Eclipse, Dream weaver, Heidi, Asana, Komodo edit 11

Reporting Tool : Microsoft Excel, JIRA

ACADEMIC QUALIFICATIONS

Data Science Certification, University of Toronto/University of Waterloo, Canada. 2022

-Final Group project in Machine Learning

Master of Technology in Information Technology, Charusat University, India 2014

-Final Dissertation in Image Processing

Bachelor of Engineering in Information Technology, Dharmsinh Desai University, India 2007

-Final semester project in GIS.

WORK EXPERIENCE

DATA SCIENCE SPECIALIST Nov 2022 - Present

DATA ANALYST May 2019 – Nov 2022

Enerlife Consulting Inc., Toronto, Canada

Enerlife’s Performance-Based Conservation approach is transforming the knowledge and practice of energy conservation in buildings. This has led to unprecedented energy savings in a growing number of buildings and portfolios which are now among the most energy efficient in North America.

-Organize, analyze, and disseminate significant amounts of information with attention to detail.

-Filtered, cleaned, classified, and represented data in meaningful way for further business decisions.

-Report writing and present findings to management in graphical form using statistical tool, Microsoft Excel.

-Supported and attended regular management meetings and follow ups.

-Analyze energy consumption data for electricity, gas, water, steam, and chilled water usage and represent them in graphical format.

-Setting the baseline based on the findings and degree days.

-Analyzing building performance and applying for EnergyStar rating.

-Working with one of the largest online building performance databases in North America for clients like commercial landlords to leading hospitals, school boards and municipalities.

-Utilized tool - MySQL Workbench to Develop and re-write SQL Queries to mine Data from large sets of data.

-Optimized data collection procedures and generated reports on a weekly, monthly, quarterly, and yearly basis.

-Actual utility bill reading and updating to database manually and by Power queries.

-Automating reports by connecting it to SQL databases and developing dashboards.

-Developing Python scripts using Jupyter notebook for automating reports.

-Developed and maintaining Python scripts to download, read and write csv file of weather data and convert it to required format.

-Utilized panda’s library, NumPy array, seaborn library.

-Developed and maintaining selenium script with Python to upload report to Enerlife Energy Management System.

-Editing and maintaining the content of WordPress websites – https://greeninghc.com/, https://sustainableschools.ca/, https://climatechallengenetwork.org/ and https://mayorsmegawattchallenge.com/

Project: Ice Rink Python Tool Development

Description: Python tool development to automate calculations for different Utilities using python libraries like NumPy, Pandas and Matplotlib. Tool reads all the required inputs from excel file and processes it and generate output in excel file.

Project: Python Weekly reporting tool

Description: Python tool development to automate calculations for different Utilities using python libraries like NumPy, Pandas and Matplotlib. Tool reads all the required inputs from MySQL Database and processes it and generate output in word file, showing the weekly and yearly savings. The tool is flexible to generate 1-week, 2-weeks, 4-weeks, or previous month savings reports.

DATA ANALYST/QA Mar. 2018 – Dec. 2018

First Global Data Corp., Toronto, Canada

First global money is money transfer App for Web, iOS and Android where customer can transfer money from USA and Canada to various countries using different payment methods.

As Data Analyst,

-Developed and re-write SQL Queries to mine Data from large sets of data.

-Utilized tools like Heidi and MySQL Workbench to write queries and retrieve information.

-Data mining, organize, analyze, and disseminate significant amounts of information with attention to detail.

-Optimized data collection procedures and generated reports on a weekly, monthly, quarterly, and yearly basis.

-Filtered, cleaned, classified, and represented data in meaningful way for further business decisions.

-Report writing and present findings to management in graphical form using statistical tool, Microsoft Excel.

-Supported and attended regular management meetings and follow ups.

-Generated reports for finances, compliance and accounts department for Canada, Los Angeles, and Guyana office.

-Successfully interpreted data to draw conclusions for managerial action, strategy and operations.

-Proposed solutions to improve system efficiency.

-Created visually impactful dashboards in Excel for data reporting by using pivot tables and VLOOKUP.

As QA,

-Conducted Functional, System, Regression, End to End testing and UAT by executing all the test cases

-Executed test cases according to the test cycle and logged all the defects with their priorities in JIRA

-Prepared summary report of overall testing status & defect status

-Performed full Functional, User Acceptance, Regression, and end-to-end testing including identifying testing scenarios, building the test scripts, modifying test scripts, executing scripts and reporting test results.

-Created Test Plans, Test Scenarios and Test Cases for assigned modules as well as verified the actual result based on the expected results. Troubleshot issues related to test cases, test data & required test environment.

-Provided daily status reports to the management during Test planning and Test execution.

-Generated reports like test case result report, test case creation report, daily report, weekly report, issue log report, defect report, test summary report.

GEEKSQUAD SERVICE AGENT Jan. 2018 – Mar. 2018

BestBuy, Scarborough, Canada

Responsibilities includes:

-Installed operating system and software to newly purchased or under maintenance computers.

-Installed and configured computers with software like adobe reader, media players, Microsoft office, open office, antivirus installation and activation.

-Received and delivered shipment.

-Contacted customers via phone calls and email system.

-Attended to customers and solved their queries regarding computer or software issues.

-Provided maintenance to customer's computer, both hardware and software.

-Generated paperwork for customers.

QUALITY ASSURANCE DEVELOPER Sept. 2014 –March 2017

Device Developer, Ahmedabad Gujarat India

Device Developer is a product based and service-oriented company, I worked as a Quality Assurance Developer - developed and tested the iOS application.

As QA,

-Defined and performed various test functions – Black Box, User Acceptance Testing, Functional and End to End testing for mobile devices / websites and mobile apps.

-Directly Interact with Project Teams, Developers and Clients for test requirements, clarifications, and testing.

-Manually executed the test cases to validate functionality.

-Ensured testing activities allow applications to meet business requirements and systems goals, fulfill end-user requirements, and identify existing or potential issues.

-Clearly and concisely record, track and report the status of issues, enhancements and other software changes to lead Project Manager/Client.

-Make recommendations for improvement of applications to developers and project management teams.

-Participated in regular project meetings with an overview of the status of bugs and enhancements.

-Created additional documentation to assist and record the testing effort.

-Ensured that bugs and requirement variances are being appropriately communicated to development for correction.

- Fully documented any unexpected bugs or issues identified in testing with instructions of how to recreate them.

-Used JIRA reporting tool to report bugs or any issues found while testing.

As Developer,

-Designed, developed, analyzed, tested, and maintained, iOS Application using XCode with Objective-C along with MVC architectural pattern.

-Developed Mobile Application “App Development Portal”, where one can design own app according to their needs.

-Worked on the different modules of the App like Simple text, Gallery, Slideshow, and Image+Text.

-Worked with UI Controls and UICollectionViews.

-Worked with Auto Layout.

-Tested and bug fixed in existing iOS Application.

-Meet Clients for Requirement gathering.

LECTURER

Akshar Institute of Information Technology, Nadiad Gujarat India June 2008 - July 2011

G.H. Patel College of Engineering and Technology, Vallabh Vidhyanagar Gujarat India

July 2011 – Aug 2012

-Conducted Lectures and Laboratories for programming Language like C, C++, Core Java, Algorithms, Data Mining, Data Structure and Business Information System.

-Covered the programming concepts like inheritance, polymorphism, multithreading, class and objects, functions, pointers, arrays, looping techniques and decision-making techniques.

-Conducted Theory and Practical Examinations.

-Supervised and Trained new Lecturers.

Contact this candidate