Charmi Sangani

Charmi Sangani

Data Analyst
Canada

نبذة عني

Detailed-oriented and results-driven Information Science professional who excels at maintaining large databases, performing data collection and analysis, and conducting detailed reports. Experience in product analytics, …

الخبرة

Business Data Analyst

Adastra
Jul 2022 - حتى الآن · 4 سنوات

Responsible for providing data analysis that focused on improving the user experience and optimizing user retention
Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions, and common table
expressions to track user activity metrics such as retention rate and daily active users. Optimized existing queries to
run faster on large datasets.
•Created and analyzed business requirements to compose functional and implementable technical data solutions.
•Designed and maintained MySQL databases and created pipelines using user-defined functions and stored procedures
for daily reporting tasks.
•Spot and analyze trends in user activity data, identify underperforming user segmentation, and report insight to
stakeholders.
•Built ETL pipelines to retrieve data from NoSQL databases and load aggregated data into the analytical platform.
•Generated, wrote, and ran SQL scripts to implement the DB changes, including table updates, addition or update of
indexes, creation of views, and store procedures.

Data Analyst - part time

Adastra
Jul 2022 - Jun 2023 · 11 أشهر

Responsible for providing data analysis that focused on improving the user experience and optimizing user retention.
Wrote complex ad-hoc MySQL queries involving correlated subqueries, window functions, and common table expressions to track user activity metrics such as retention rate and daily active users.
Optimized existing queries to run faster on large datasets.
Created and analyzed business requirements to compose functional and implementable technical data solutions.
Designed and maintained MySQL databases and created pipelines using user-defined functions and stored procedures for daily reporting tasks.
Spot and analyze trends in user activity data, identify underperforming user segmentation, and report insight to stakeholders.
Built ETL pipelines to retrieve data from NoSQL databases and load aggregated data into the analytical platform.
Generated, wrote, and ran SQL scripts to implement the DB changes, including table updates, addition or update of indexes, creation of views, and store procedures.

Data Analyst

Mechatron System
Apr 2020 - Feb 2022 · 1 سنة 10 أشهر

Assist in data preparation activities including exploration, cleansing, validation, integration, transformation, and aggregation of data.
Support the design and implementation of technical enhancements to the company’s data warehouse, including database design, ETL processes, access, and security.
Develop ETL processes and reusable packages according to standards reflecting industry-specific best practices.
Participate in and influence the design, planning, and implementation of the organization’s projects and initiatives regarding database system performance and administration.
Design, develop, and support databases, data marts, data dictionaries, and metadata repositories.
Participate in the analysis and resolution of issues related to information content, data integrity, integration, and performance.
Support the implementation of Business Intelligence solutions for company-wide performance reporting needs.
Analyze the data and identify gaps, data quality issues, and integrity issues.
Create and maintain system documentation, including a data dictionary.
Assist IT team in supporting database administrator functions, including managing servers and users.
access, database security, optimization and performance tuning, capacity planning, and disaster recovery.
Develop and maintain data standards for consistency and quality.
Collaborate with Subject Matter Experts and Product Owners to define the data requirements and source-to-target mapping necessary to support advanced analytics initiatives.
Provide recommendations for technical solutions based on best practices

Data Analyst

Arunamurti Media PVT LTD
Apr 2019 - Mar 2020 · 11 أشهر

Extracted databases from the server using SQL queries and stored procedures, and built an ETL pipeline using Python.
Performed complex analyses of the developmental, financial, and organizational databases Using Excel.
Participated in identifying, analyzing, and interpreting trends, patterns, correlations, and anomalies in complex datasets to find insights and draw conclusions.
Lead in the development of data analytics visualizations and statistical reports to assist News Safety Sol and its clients in their decision-making processes
Design, build, and deploy business intelligence reports and create plots and dashboards using PowerBI.
Responding to customer queries, problem identification, and solution, and maintaining SLAs, analysis, and visualization of insights from customer data (using Python, Tableau, and SQL) for decision-making to improve the customer’s involvement by 10%
Integrate and Forecast revenue and reservations using Excel statistical tools based on market trends and profit margins.
Analyzed the service reports to identify the weaker areas for support and helped optimize the support processes, thereby reducing SLA breaches by 25%.
Build several machine learning and statistical models for solving stakeholders’ problems.
Understand data mapping and data flow within the supported systems.

Production Designer

Vista print
Feb 2018 - Mar 2019 · 1 سنة 1 شهر

Illustrate design ideas using storyboards, process flows, and sitemaps.
Proficient in using design software such as Adobe Creative Suite, Sketch, or similar programs.
Experience creating detailed and professional concept renderings for a range of projects.
Collaborate with the client to successfully create prolific social media graphics suitable for target marketing.

المهارات

توجيه الأعمال تقييم البيانات بوربوينت سكرم عملية التشغيل نماذج البيانات جودة البيانات مستودع البيانات حالات الاختبار ليكون تطوير واجهة المستخدم تابلو Python NumPy Pandas Matplotlib Seaborn scikit-learn SQL tidyverse dplyr ggplot SAP MS Project MS Office MS SharePoint MS Visio MS Word Maven Power BI Cost/benefit analysis GAP analysis Risk Analysis Impact Analysis SWOT analysis HTML JavaScript CSS Bootstrap CSS Django MS SQL Oracle MySQL IBM DB2 PostgreSQL NoSQL Google Cloud Platform Microsoft Azure AWS EC2 S3 RDS Google Analytics UML SDLC Agile/Scrum Waterfall Jira Rational Rose HP Quality Center JAD
الإبلاغ عن هذا الملف الشخصي؟