Dallas-Fort Worth Metroplex
3 years of analytical working experience with solid background in data mining with Python, SAS, and SQL; provided actionable insights to the business and being able to work cross-functionally across the company. Major Job functions included Operational Reporting, Strategic Analysis, Strategic Planning, and Data Maintenance /Management. Interested in Business Analyst, Data Analyst or Data Scientist that can gain exposure and credibility in the industry.
• Provided actionable insights through BI reports on key products for operational team to identify enhancement and enable the team to act quickly on new business opportunities (using SQL, Tableau, MS Power Point and MS Excel) • Led a project to identify the key activities that have relative strong sales’ impacts through statistical analysis; improved the activity efficiency with limited budget by providing suggestions on directions and guidance for the product launch training plans; presented the results to internal users in a visual format that is easily understood and actionable • Created new methodologies for strategy planning: predict high sales days based on past sales history to support quarterly working calendar planning and improved the operation productivity • Collaborated with internal partners and HQ to collect internal business needs, develop technical solutions, testing and improve the MCS automatic solutions continuously to better support the field team activities and improved the operation efficiency • Identifies opportunities in database management and worked with multiple departments to standardize the process with technology solutions and streamline operations; collected business needs across the department and oversaw the deployment of data to the data warehouse; educated and trained internal users to use the data for business purpose
• Data Reporting - developed and performed business intelligence analysis on customer services’ data weekly, monthly and annually as well as created ad hoc reports use for trend analysis for department use • Data Analytics and Visualization – created and presented standard reports, using multiple tools including Access, Advanced Excel (VLOOKUP, Pivot Table and Pivot Charts), clearly recognized and summarized trends in a visual format that is easily understood and actionable • Data Gathering and interpretation – collected, analyzed and interpreted historical unstructured and structured data to determine the patterns and causes of commodity/asset replacement and repairing by qualitative and quantitative analyses, aimed at reducing of assets replacement • Data Maintenance/Management - worked with IT and customer service representatives in resolving data issues such as missing or inaccurate client data with focus on continued improvement of the data environment
• Collected comprehensive data on textile manufacturing corporations to construct detailed industry research reports with the team • Collaborated with Senior Analyst to investigate newly IPO firms and conduct analytical reports of 5 IPO firms including predicting recommended stock prices
• Communicated with 20 clientele to collect individual financial requirements to facilitate financial plan experts designing personalized wealth-management strategies • Handled 6 customer-appreciation events for high-net-worth investors with net assets over $750,000
• Educated 10 clients daily in prospective financial-management strategies and effectively promoted & sold bank products and services • Directed 100+ visitors daily to appropriate staff members and provided key contributions to consultancy efforts