Tasneem Kapadia

Phone:615-***-**** Email: ad2ed3@r.postjobfree.com Charlotte NC

Objective

Highly motivated, detail oriented and aspiring data analyst seeking a challenging position to leverage my strong analytical skills, mathematical proficiency, and knowledge of data visualization techniques to contribute to an organization’s data-driven decision-making process. I am eager to contribute to a dynamic team, gain practical experience, and continue developing my expertise in data analysis and visualization.

Experience

2013 – 2015

Data Analyst, Dream Cyber Infoway Pvt. Ltd., Indore (M.P) - India

Assisted in data collection, cleaning, and preparation for analysis.

Utilized SQL and Python libraries like Pandas and Numpy to collect, clean and analyze large data sets.

Conducted Exploratory Data Analysis to uncover trends and patterns.

Supported the team in building predictive models using Python libraries like Scikit-learn, Statsmodels.

Utilized SQL and Python to collect, clean and analyze large data sets, identifying trends and patterns that drive strategic business decisions.

Supported the development of data visualization and reports.

Involved in creating stored procedures, views, and custom SQL queries to import data from SQL Server to Tableau.

Used Python to preprocess data to find trends and insights.

Utilized Python and web scraping libraries like Beautiful Soup to automate data extraction, saving approximately 10 hours of manual data collection per week.

Cleaned and transformed scraped data for analysis, ensuring data quality and consistency.

Run SQL queries in Python Jupyter notebook using Pyodbc.

Worked extensively with Advance analysis Actions, Calculations, Parameters, background.

images, and Maps.

Created dashboards by extracting data from different sources using parameters, sets,

groups and calculations.

Created Relationships, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.

Created customized reports using various chart types like text tables, bar, pie charts, tree maps, heat maps, line charts, pivot tables, combination charts in Excel and Tableau.

Designed and developed weekly, monthly reports by using MS Excel Techniques (Charts, graphs, Pivot tables) and Power point presentations.

Strong Excel skills, including pivots, Vlookup, conditional formatting including data manipulation and cleaning.

Utilized SQL, Python and Excel to extract, transform, and analyze large datasets.

Created automated dashboards and reports for stakeholders to monitor KPIs.

Collaborated with cross-functional teams, understanding their data needs and delivering tailored solutions that support their objectives.

2004 – 2005

Assistant Professor, Govt. Engineering College, Ujjain (M.P) - India

Taught Instrumentation and Measurement using classroom lectures and labs, assisted with various departmental duties and provided academic support to Professors and other staff.

Education

June 2004

B.E – Electronics and Telecommunication, RGPV University, India

Completed Bachelor of Engineering with honors in Electronics and Telecommunication - 78% aggregate.

Training

MS SQL Server, online live hands-on classroom training

Hands-on experience in writing DDL, DML SQL queries to extract, filter, and analyze data from relational databases. Proficient in joining tables, creating views, triggers, making use of window functions and performing aggregate functions for data aggregation and reporting.

Worked on assignments and projects: Extract data from flat file, used bulk insert to load data to SQL server, created databases, tables, run DDL and DML queries, used aggregate functions to analyze data and created reports using Excel, Power BI and Tableau.

Data Analytics, Udemy

Completed Data Analytics course on UDEMY and gained skills through hands-on exercise with sample datasets and data models using tools like Python, Excel, SQL. Perform data cleansing/processing/visualization and create regression models using different python libraries Pandas, Sklearn, Statsmodels and Seaborn.

Neo4J, Udemy

Completed Neo4j training and passed Neo4j Certification.

Quality Assurance (ISTQB), Udemy

Completed ISTQB foundation course on UDEMY

Projects

Microsoft SQL Server

Implement star schema database model using fact and dimension tables. Extract data from flat file, used bulk insert to load data to SQL Server, created databases, tables, developed complex DDL and DML queries to analyze data. Used different joins to combine different tables and gain insights. Conducted exploratory data analysis on datasets and load the transformed data to Tableau and created visualizations and reports to present and communicate findings using Tableau.

Also have hands-on experience in Excel: Utilized pivot tables in Microsoft Excel to summarize and analyze large datasets and created dynamic charts and graphs to visually represent key trends and insights.

Microsoft SSIS

Developed and maintained SSIS packages for data extraction, transformation and loading processes: Utilized SSIS to design and develop a data integration workflow for combining data from multiple sources into a central database.

Implemented data transformations, cleansing techniques within the SSIS package to combine, massage and format raw data from different sources.

Executed and monitored the SSIS package, ensuring successful data integration and maintaining data quality.

Skills

Strong attention to detail, ability to problem-solve and learn processes and technology quickly

Highly organized

Great interpersonal skills

Excellent math, verbal and written communication skills

Professional attitude

Ability to set and meet priorities and deadlines and handle stressful situations

Strong sense of teamwork and mutual respect

Technical Skills

Data Analysis – Proficient in analyzing complex data sets using statistical software (Python, Excel) to identify patterns, trends and insights.

Database Querying – Proficient with SQL and experience in writing queries to extract, manipulate and analyze data from relational databases.

Data Visualization – Ability to create visually appealing and informative charts, graphs, and dashboards to present data findings using tools like Tableau.

SQL, Python, Neo4j, Excel, Tableau,

Business Analysis and Quality Assurance

Certifications

Microsoft # Analysis and Visualization with Power BI- Coursera

Microsoft # Harnessing the power of data with Power BI- Coursera

IBM certified Data Analyst – Coursera

Introduction to Data Analytics IBM – Coursera

IBM Data Analysis with Python – Coursera

Databases and SQL for Data Science with Python – Coursera

Neo4j Certified Professional - Neo4j Graph Academy

Contact this candidate