SUMMARY:

• A quick learner possesses a strong background in math, finance, statistics and actuarial analysis, and aspires for position and advancement in the actuary field.
• A detail - oriented and results-driven business analyst with a demonstrated track record.
• Collaborates with senior management and cross-functional staff to present key findings, provide recommendations, and improve decisions.
• Excel in evaluating information and delivering solutions to drive performance and profitability.

AREAS OF EXPERTISE:

• Actuarial Analysis
• Financial Mathematics
• Probability and Statistics Application
• Macro and Micro Economics
• Financial Product Analysis
• Statistical Data Analysis
• Corporate Finance
• Data Mining and Data Management
• Query Writing
• Statistical Model Design
• Budgeting
• Cost Minimization Simulation

TECHNICAL SKILLS:

SAP (ECC 6.4, SCM 7.0), SQL, SAS, Tableau, Toad, Microsoft Excel, VBA, Python, R, Microsoft Access, Microsoft Project, Visio, Oracle, PeopleSoft, E-Views

EXPERIENCE:

Confidential, Plano, Texas

Statistical Data Analyst

Responsibilities:

• Wrote SQL queries in TOAD to retrieve related data to support statistical analysis.
• Used SAS distribution to conduct cluster analysis and group stores by performance.
• Built statistical model to determine eligibility of 2,400 stores to carry products in 36 classes.
• Analyzed store and distribution center inventory positions, forecast future delivery, net gain, and replenishment application parameters to determine necessary adjustments to optimize budgetary decisions and store needs.
• Recommended enhancements and changes in replenishment parameters to drive replenishment orders and maximize store sales and profitability, variance pattern and other factors to determine optimized order point for each store/each class.
• Tracked performance of test stores receiving new test items; analyzed how test project affected substitution class performance, store long-term UOR, and store total inventory position; and made decision on whether to proceed with tests.
• Reviewed store health situation weekly to identify over-stock and under-stock stores to treat differently in GEAR system run, in order to adjust store’s inventory position balance.
• Compared actual replenishment results to forecasts, determined drivers for differences, and decided multiplier in GEAR to differentiate importance of factors.
• Conducted cyclical and ad hoc analysis and presented key findings by Tableau to improve decisions.
• Assisted manager and director in developing updated replenishment models to enhance replenishment decisions.

Confidential, Richardson, Texas

Order Management Analyst

Responsibilities:

• Identified data exchanged in SAP between purchase orders, inventory documents, shipping status documents, atlas documents, and invoice documents via EDI, and conversion and direct flow to partners’ order management systems.
• Researched RMA material, delivery order, 1st GI, 2nd GI, Atlas, invoice, and revenue database.
• Monitored inventory and material movements and used SharePoint to realize information sharing.
• Applied Excel to maintain statistical analysis updated and assisted with target-oriented decision.
• Analyzed and identified supply chain problem and offered solutions.
• Utilized Macro function to identify problem data; standardized all worksheets for categorization purpose.
• Used SQL to perform data retrieving, table join, and database updating in Access.

Confidential, Garland, Texas

Statistical Analyst

Responsibilities:

• Performed field visits of factory and researched on value-added and non-value-added process.
• Developed more efficient sourcing processes of different raw materials and realized quality assurance.
• Studied business process flow, conducted data mining from corporate database, and joined data tables to achieve one-to-one, one-to-many, or many-to-many relationship based on primary and foreign key in SQL.
• Used V-lookup to select and analyze data of materials that had obvious losses during delivery; categorized possible reason for material losses (shrinkage).
• Utilized pivot table to complete statistics on different potential reasons of material shrinkage.
• Analyzed factors influencing shrinkage of inventory via Significant F and P-value in Excel regression.
• Used cause-effect analysis, statistical tools, and six sigma methods to analyze quantitative data of final product.
• Applied what-if analysis on raw material Slurry and identified source of $100,000 discrepancy.

Confidential

Financial Product Analyst

Responsibilities:

• Conducted market research on new financial products and performed price analysis to estimate price elasticity.
• Performed sampling survey of 1,500 observations, allocated customers’ master data and risk-return preference, and used statistics skills to categorize data into database.
• Built models in Excel based on hypothesis, applied multivariate regression in Excel, analyzed Confidential report, and concluded on how much each potential factor would influence on customers’ consumption preference.
• Used estimated index from regression to apply Solver in Excel to complete transition modeling for case, and identified set of optimized rates and payment values for new financial product.
• Performed what-if analysis and set most profitable rate and payment method for new financial product.
• Provided final reports to management to support decision of new finance product improvement.