Data Analyst Business Intelligence

Samat Zholdassov

650-***-****, **********@*****.***

Summary:

* ***** ** ********** ** a Data Analyst and 3 years as a Data engineer: Expertise in ETL processes, Business Analytics, Data Processing, Data Extraction, Data Manipulation, and database management. Proficient in transforming raw data into actionable insights to support strategic business decisions.

5 years of Data Visualization and Business Intelligence Reporting: Implemented Business Intelligence solutions using Tableau and Power BI, delivering comprehensive visual analytics and reports. Extensive experience in analysis, design, development, testing, and programming under SAS using SQL.

7 years of SQL Expertise: Proven ability to write and optimize complex SQL queries, with working knowledge of RDBMS including SQL Server, MS Access, and MySQL. Skilled in managing and reviewing Hadoop log files to support big data analytics.

5 years of Python Experience: Utilized Python libraries such as Pandas, NumPy, Matplotlib, and Seaborn for data analytics, data wrangling, and visualization. Experienced in extracting and analyzing data using Excel. Familiar with developing solutions on Cloud platforms (Google Cloud, AWS) and performing statistical analyses using Google Analytics and Adobe Analytics.

Big Data Analysis and Data Modeling: Developed data models and performed big data analysis using Hive, MapReduce, and SQL. Strong skills in data architecture, including the design and optimization of data structures to support large-scale data processing.

Risk Management and Mitigation: Leveraged data analysis to develop rules and models for recognizing, mitigating, and preventing risky behaviors such as abusive accounts, fake engagements, and fraud. Collaborated cross-functionally to enhance risk perception and develop effective risk control measures.

Cross-functional collaboration: Worked with engineering, modeling, operational, and product teams to ensure comprehensive risk management coverage. Contributed to the development and refinement of risk measurement frameworks and dashboards using data visualization tools.

Communication and Data Storytelling: Developed and presented reports and visualizations to communicate complex data insights to stakeholders. Fostered a data-driven culture by providing regular updates and workshops on risk trends and mitigation strategies.

Technical Skills:

Proficiency in SQL for querying and analyzing large datasets.

Expertise in data visualization tools like Tableau, Power BI, and Looker.

Advanced knowledge of data mining techniques and statistical analysis.

Strong problem-solving abilities with a proactive approach to identifying and resolving issues.

Excellent communication skills, capable of translating complex data into clear and actionable insights.

Familiarity with streaming technologies and video content delivery networks (CDNs).

Experience with global data initiatives and understanding of regional differences in user behavior and preferences.

Professional Experience:

Lincoln University, Oakland, CA Sep 2023 – Present, Senior Data Analyst

●Extracted and analyzed financial data from various sources, including databases, spreadsheets, and financial statements, to identify trends, patterns, and anomalies.

●Developed and maintained data pipelines and ETL processes to ensure the timely and accurate collection, transformation, and loading of financial data into the university's data warehouse.

●Designed and implemented data models and schemas to support reporting and analytics requirements, ensuring data integrity, consistency, and accuracy.

●Prepared comprehensive reports and presentations in Excel, summarizing key findings and recommendations for senior management and stakeholders.

●Assessed data quality, integration, and reporting to identify gaps and inconsistencies.

●Generated comprehensive reports highlighting findings and recommendations for process enhancements.

●Managed multiple life safety data projects, coordinating with various departments to ensure timely and accurate completion.

●Prioritized tasks and allocated resources effectively to meet project deadlines and ensure high-quality outcomes.

●Created interactive dashboards and reports using Tableau to visualize financial metrics, KPIs, and performance indicators for stakeholders and decision-makers.

●Automated routine reporting tasks using Excel macros and SQL scripts, reducing manual effort and increasing efficiency.

●Developed automated data pipelines to integrate data from various sources into Tableau, ensuring timely and accurate reporting.

Ipsy via Intellisoft Systems LLC, San Mateo, CA Jan 2023 - Sep 2023, Data Engineer

●Conducted regular quality checks and validations to ensure that all catalog entries met Ipsy's high standards of accuracy and completeness.

●Analyzed inventory data using SQL to identify slow-moving and fast-moving products, optimizing stock levels and reducing excess inventory.

●Worked with stakeholders to define key performance indicators (KPIs) and create interactive dashboards that provide real-time visibility into resource usage, costs, and performance.

●Enhanced the accuracy and completeness of the item catalog by sourcing and updating item photos, names, taxonomy, and brands, ensuring a seamless and accurate customer experience.

●Conducted comprehensive performance analysis of marketing campaigns and promotional activities, enabling data-driven decision-making for the enhancement of marketing strategies and customer engagement initiatives.

●Analyzed the effectiveness of promotional campaigns using SQL to compare pre-and post-promotion sales data.

●Created Tableau visualizations to illustrate the impact of promotions on sales and inventory levels, helping to optimize future promotional strategies.

●Translated complex data findings into comprehensible and actionable insights, tailored to different audience levels including technical teams, product managers, and executive leadership.

●Worked closely with cross-functional teams, including engineering, product, and marketing, to ensure data integrity and support catalog-related initiatives.

●Performed data querying using SQL across large datasets, optimizing queries and processes for efficiency.

●Leveraged multiple customers listening posts (surveys, customer verbatim, focus groups, social media) to create a reliable and sensitive customer feedback signal.

●Unified feedback sources to enhance the accuracy and responsiveness of customer insights.

●Utilized data analysis tools and techniques to identify patterns and insights, informing catalog management decisions and strategy.

Google via Artech, Sunnyvale, CA Jul 2022 - Nov 2022 Data Analyst

●Developed and implemented databases, data collection systems, data analytics, and other strategies that optimized the Distribution Center’s operational effectiveness.

●Developed a data quality portal using Python and SQL querying and Google Analytics tools and worked with BigQuery, Google's fully managed, serverless data warehouse.

●Created and supported reports and dashboards using Google PLX, Tableau, and Looker.

●Leveraged GCP services for data storage, and processing and utilizing tools such as Google Cloud Storage, BigQuery, and Dataflow to build end-to-end data pipelines that support business intelligence and reporting requirements.

●Developed customized reports and dashboards in Google Analytics to visualize key performance indicators (KPIs) and provide actionable insights to stakeholders, such as marketing teams, product managers, and executives.

●Developed interactive and visually appealing dashboards and reports using Tableau to communicate insights derived from Google's data to stakeholders across different departments.

●Leveraged Looker as a centralized platform for data exploration, visualization, and collaboration, enabling teams to access and analyze data in real time.

●Utilized SQL for data extraction, transformation, and analysis from Google's vast datasets stored in various databases such as BigQuery, Cloud SQL, and Spanner.

Comcast via Mold-cable, San Jose, CA Jan 2021 - Dec 2021 Business Analyst

●Developed and presented analytical project ideas, progressed initiatives, and reported results with business implications to internal business partners.

●Leveraged Salesforce for data analysis and reporting, driving business insights and actions.

●Conducted detailed examinations of user engagement, content performance, and streaming quality to enhance the overall user experience.

●Analyzed data as input for auditors to determine whether businesses are conducting and monitoring operations by established Comcast policies/procedures, best practices, and legal requirements.

●Experienced in creating and customizing Salesforce reports and dashboards, providing key performance indicators (KPIs) and visualizations for sales, marketing, and customer service teams.

● Develop comprehensive reports, dashboards, and presentations to communicate findings, recommendations, and risk points to leadership and other stakeholders.

●Utilized advanced data mining techniques to independently analyze vast datasets, uncovering critical issues affecting video streaming performance.

●Collaborated with cross-functional teams to allocate necessary resources and implement effective solutions to identified problems.

●Designed and maintained a comprehensive suite of reporting tools and intelligence assets, ensuring they are user-friendly, well-documented, and easily accessible to stakeholders.

●Created dashboards and visualizations that provide clear and actionable insights into video platform performance metrics.

●Developed detailed project plans and clear communication strategies to drive effective change.

●Managed projects from inception to implementation, ensuring alignment with business goals and stakeholder expectations.

●Efficient data mining and data extraction from various databases to meet reporting and business intelligence needs.

Home Credit Bank, Almaty, Remote Jan 2017 - Nov 2020 Business Analyst

●Utilized sales data analysis to identify market trends and customer behavior, providing valuable insights for the development of targeted sales strategies and the optimization of product offerings.

●Implemented operational data analysis to streamline internal processes and improve overall efficiency, resulting in cost reduction and enhanced resource allocation within the organization.

●Worked closely with cross-functional teams including marketing, finance, and product development to ensure alignment on business objectives.

●Presented complex analytical findings clearly and concisely to non-technical stakeholders, facilitating data-driven decision-making.

●Analyzed complex business problems and issues using data from internal and external sources to provide insight to decision-makers.

●Collaborated with the Growth Strategy team to identify business trends and develop business opportunities for major national retail brands in the protection plan space, contributing to a 30% increase in revenue and a 20% increase in protection plan sales.

●Collaborated with cross-functional teams, including sales, marketing, and finance, to understand their data needs and deliver custom reports and insights aligned with business goals.

●Leveraged data analytics to gain insights into customer behavior and preferences.

●Used these insights to inform the development of personalized marketing campaigns, resulting in improved customer engagement and satisfaction.

Areva vs KazAtomProm, Almaty, Full-time Aug 2013 - May 2016 Business Analyst

●Analyzed the SQL scripts and designed the solution for a custom ETL pipeline by using Python.

●Served as the point of contact for all aspects of information security, including access management, endpoint protection, cloud security, and PCI compliance

●Perform analysis of security data and conduct data visualization to create comprehensive technology risk reports for the IT department and senior leadership.

●Managed student workflow, and automated student development process for complex projects to reduce department cost.

●Developed a tool to read and load a large amount of departmental student data for various analysis purposes into the MySQL database tables.

●Designed MySQL queries to perform multiple joins to give correct and unique data as per the requirement.

●Implemented and configured SAP MDG to establish a centralized and standardized master data management framework.

●Collaborated with business units to define data quality standards and ensure compliance with MDG processes

●Developed data quality rules and workflows within MDG to enforce data governance policies and maintain data accuracy.

Projects and Achievements:

Dashboard Development: Designed and developed a comprehensive dashboard for Comcast, providing real-time insights into customer behavior and operational metrics, leading to a 15% increase in customer satisfaction.

ETL Automation: Implemented automated ETL processes at Google, reducing data processing time by 30% and improving data accuracy.

Data Quality Initiative: Led a data quality improvement initiative at Ipsy Inc., resulting in a 20% reduction in data errors and improved decision-making accuracy.

Education:

● Master of Science, Finance Management, Lincoln University, Oakland, CA, USA, Sep 2023 - Present.

● Master of Business Administration, MIS, Lincoln University, Oakland, CA, USA, Sep 2018 - Dec 2021. ● Bachelor of Computer Science, Eurasian National University, Kazakhstan, Sep 2009 - Jun 2013.

Contact this candidate