• Reverse-engineered and migrated complex Microsoft SQL Server stored procedures to PostgreSQLcompliant SQL for cloud data warehouse platforms such as AWS Redshift and Snowflake, refactoring procedural logic into scalable, set-based queries optimized for distributed processing • Designed, implemented, and maintained SQL driven data transformation and validation layers including staging, fact, and dimension tables while enforcing data quality through reconciliation queries, constraints, and automated integrity checks • Developed and optimized analytical data models and materialized views to support downstream consumption by BI tools such as Power BI and Tableau, ensuring high query performance, consistency, and reliability across heterogeneous data sources, including Microsoft SQL Server, PostgreSQL, AWS Redshift, and Snowflake • Utilized Power BI for data preparation and modeling by leveraging Power Query to transform data and design robust data models; developed calculated columns and measures using DAX to deliver accurate metrics, and implemented Row-Level Security (RLS) to restrict user access to specific data content based on roles • Migrated interactive dashboards from Tableau to Power BI, leveraging Microsoft Fabric capacity to support large-scale enterprise data operations and using the Performance Analyzer to evaluate usage patterns and optimize performance across different scenarios • Optimized query performance for the Cardiac, Cardiopulmonary, and ECOA projects in PostgreSQL and Snowflake, reducing execution time for the same dataset from 5 minutes to 2 minutes

• Validated data from SAP systems, identifying inconsistencies and ensuring data accuracy; Implemented quality assurance measures to maintain high data integrity standards • Designed and implemented a comprehensive sales dashboard using Power BI, integrating data from Microsoft SQL Server; Provided insightful visualizations to monitor sales performance and trends, enhancing the sales team's strategic decisions • Developed and maintained Microsoft SQL Server databases, focusing on high performance and data integrity; Optimized database performance through indexing and query optimization, reducing query execution times by 5 % • Created dynamic, interactive dashboards in Tableau and Power BI to monitor key performance indicators (KPIs) for various marketing campaigns; These dashboards led to a 20% increase in campaign effectiveness by providing actionable insights and supporting data-driven decisions • Managed critical database functions including backups, recovery, and user access controls in Microsoft SQL Server; Ensured data security and availability through effective administration process • Engaged with stakeholders to gather and understand data requirements; Delivered tailored reports and visualizations to meet business needs, ensuring alignment with strategic goals and enhancing data driven decision-making; Collaborated with stakeholders to understand data requirements and deliver custom reports and visualizations

• Using Plx script to integrate relevant department’s data from database and build interactive Plx dashboard for SLO/KPI such as device distribution, inventory count, and compliance accuracy to provide the future trend for the data insight • Implemented complex stored procedures, and parameters to migrate raw data into the Hart database; Automated extraction of the SimPPA, Zuma project increased the team performance efficiency by 15% accuracy • Developed the automation Linux shell script with a different use case to capture the power performance such as CPU, GPU, and SOC based on different scenarios; Designed the automation Python script to control different devices’ default setting and preserve data integrity ensures the data quality 5% • Identified different test cases such as Geekbensh, GFXbench, audio, multimedia, camera, and gaming with diverse brands such as Samsung, Mediatek, pixel, iPhone, and Xiaomi series as well; Manipulated these power performance data and presented insight in the monthly reports to predict the best decision for the department • Developed and maintained highly scalable Testflow using TypeScript with Angular, HTML structure • Designed the new structure and created the efficient function, optimized the tester with the stable test while they easily compared the historical data by using Typescript

• Migrated Microsoft SQL Server stored procedures to AWS Redshift environment to reduce the executed time and created interactive dashboards in Tableau and Power BI to help clients drive the new business • Analyzed the raw data from the clients to identify key metrics of performance (KPI), provided deeper insights to optimize marketing effectiveness and enhanced customer’s engagement by 14% • Implemented complex stored procedure and ETL concepts in Snowflake; Collaborated with the engineering team for improve the better performance • Designed ER diagrams and mapped the data into database objects, involved in normalization of the database in OLTP, and built the SSRS reports to predict the best decision

• Built dimensional custom datasets by extracting, manipulating, and cleaning data from big data warehouses (Greenplum and Hadoop) using advanced PostgreSQL, and Python • Designed interactive interface in Tableau and Power BI to visualize the tech product in each different retail stores and presented the insight of weekly reports in order to translate the data into the real stories • Used regression analysis in Python to determine how marketing strategy affected top sellers in weekly U.S. report and that contributed the profit and loss to a 10% decrease in annual expenses • Managed the search products engine to generate syndicated reports, resolve data anomalies, preserve data integrity and maintain processes to ensure the data quality

• Automated extraction of food bank information in the United State using the Google Application Programming Interface (API) and Python • Manipulated 1 million different data points and created an iterative dashboard in Tableau to analyze if the advertisement of the Cooking Matters recipe had any effect on the sales of ingredients • Responsible for loading, extracting and 10-fold cross validation of client data • Conducted quantitative (SQL) and qualitative analysis, diagnosed areas for improvements; increased multiple work streams’ efficiency by 26.7% on average • Performed analysis for a wide range of requests using data in different formats and from various platforms • Collaborated with marketing team for improve sales solution of food bank information and integrated multiple data sources to predict the best decision for Cooking Matters recipe

Extracted data from SQL databases (using BigQuery and MySQL), analyzed performance of algorithm against benchmarks and visualized the results in tables and charts in Excel (data size per project: 100,000+) • Developed Machine Learning Model (K nearest neighbors) using Python or R to predict proper business enhancement solutions based on client information (industry, certification audit result, region, business size, etc.) • Built dashboards in R or Python to assess optimization performance across multiple data science products • Designed dashboards using Tableau with graphs and charts to translate data into visualized stories • Extracted actionable insights from large datasets to make recommendations for brands in various industries, increasing social media followers by 5% - 10% • Identified KPIs, built models and analyzed campaign and business performance