• Using Excel to clean the data, remove duplicate, subtract the information from different spreadsheet and combine. • Using MDS ERP system to manage the resource of company like customer, purchase order, inventory, vendor, price etc.• Cooperating with the final team to calculate the account receivable, invoices, inventory value and made report by Excel. • Use Shopify to check the order, customer, product and run and analyze reports. • Selected sales data from different pharmacies on the HubSpot to visualize the trends and styles.

• Used classification techniques including Random Forest and Logistic Regression to quantify the likelihood of car’ churn• Data wrangling to clean transform and reshape the data utilizing NumPy and Pandas library.• Built interactive overview Tableau dashboard with drill-down ability across various KPIs to visualize freight process; helped them to identify spending trends over time (by Car’s Type, Brand, Shipping Type, etc.)• Used Python(NumPy, SciPy, Pandas, Scikit-learn, seaborn) and machine learning algorithms to predict the lag in delivery and provided actionable recommendations by identifying potential risks and cost reduction opportunities.• Used SQL to join and merge monthly parcel data with location data stored in different excel files, and then transformed the aggregated data into an analytics-ready consolidated dataset. • Developed dual-axis chart in Tableau to analyze freight spend and number of shipments by month. • Created geographic hierarchy with origin and destination country, state, and city-level to visualize and organize freight data at a different level of details. • Developed dual-axis chart in tableau to analyze freight spend and number of shipments by month. • Performed data blending and created complex calculation fields using Table Calculation and Aggregate functions in Tableau.• Executed and tested queries and reports using Explain data before publishing dashboards.• Restricted data for users using row-level security and user filters using Excel.• Generated context filters and used performance actions while handling a huge volume of data. • Analyzed client’s business requirements and processes through interviews, document analysis, surveys business process descriptions, use cases, user stories, scenarios, and workflow analysis.

Data Mining Model to Analyze the players in ‘Football Manager 2020’ • Creating System Design, Module Design, Data Flow Diagrams, DB Schema etc. • Prepared Test Plans, Test Suits, and Test Cases by analyzing the Requirements, Technical Specifications, and Non-Functional Requirements• Constructed 5 different kinds of prediction models by Python, including KNN, Linear regression, Decision tree, Naïve Bayes Classifier, and Logistic regression to predict the new players' market value and rank.• Visualized the relationship using Tableau by hat maps, boxplot, scatterplot, histograms, and line charts.Design of an application for Employee Management • Worked on complete Software Development Life Cycle, and major aspects of technological projects including Requirement Analysis, Design, Development, Database Design, Deployment, Testing, Debugging, and Application Maintenance. • Implemented code in Python to review and manipulate the data.• Development multi-page application from beginning to end.• Designed and developed the UI of the website sing HTML, CSS.• Profiled code for optimization and memory management.Economic Analysis for Surface Mount Technology at Chromalox Instruments and Control Corporation • Use the cost of materials, labor, and overhead from the history. Find the PW at a MARR of 20% and IRR for the in-house production alternative and the subcontract alternative. • Created tables by Excel, including revenues, expenses, taxes, depreciation, and investment. • Decided which alternative is better and other three additional factors rather than economic factors. • Calculated the breakeven value for the in-house production alternative and the subcontract alternative. • Find the PWs under new scenarios and the expected PW (E(PW)) for each alternative. (Sensitivity Analysis) • Write a report in Word to show the result and thinking.

•Inspur is a leading global data center and cloud computing solutions provider. Among the world’s top 3 server providers, they deliver and deploy robust, performance-optimized, purpose-built platforms to major data centers around the globe to address important emerging fields and applications.• Applied Statistical Analysis and developed an optimized model using regression.• Predicted differences between supply and demand by pipeline in next 3 months and pictured differences by line graph, mapping, bar chart etc. via Tableau, Excel pivot table. • Developed scripts using Python like Pandas, NumPy for data manipulations. • Created Python DB Modules libraries such as MySQL-Connector and pyodbc to load the data. • Developed SQL queries that handled data form multiple tables using Python library psycopg2.• Conducted reporting analytics and presented results in Excel-based Reports using Pivot Tables, V-Lookup, and Line and Pie Charts. • Conducted reporting analytics and presented results in Excel-based Reports using Pivot Tables, V-Lookup, and Line and Pie Charts. • Used MAE/RMSE/MSE to evaluate different models' performance.• Constructed the dashboards in Tableau and PowerPoint and made a presentation with stakeholders to communicate the strategic findings and recommendations.

• Maintained clients’ MySQL database by collecting raw data and conducted feature engineering over 100k order histories including catalog such as furniture, electronics, and office supplies. • Involved in writing SQL queries implementing functions, triggers, cursors, object types, sequences, indexes etc.• Rewrite existing Python/Django modules to deliver certain format of data.• Migrate the Data form local to cloud environments like AWS S3 bucket using Python.• Collected data and applied data-visualization with Tableau for clients based on the information of over 1k spices suppliers to analysis and find out suppliers with best price and cost performance. • Addressed sensitivity analysis report and spreadsheet for clients based on the cost of materials, labors, revenues, expenses, taxes, depreciation, and discount rate to help clients make marketing decisions.