Woodinville, Washington, United States
- SAS Certified Advanced Programmer for SAS 9 Credential - Strong skills in statistical analysis, data mining and statistical programming using R SAS and Python to solve business problems - Expert in regression modeling, probability and statistics theories, Monte Carlo simulation, mathematical optimization - Strong verbal and writing communication skills - Effective independent worker and team player
• Manipulate data tools for targeting including Aprimo Relationship Manager (ARM), Relational Database Management System and Campaign Relationship Management (CRM) system, such as Teradata Relationship Manager (TRM) (using SQL language) to produce data files. • Perform quality assurance on data files to ensure flawless execution. • Participate on multiple projects of varied complexity (simple to moderate) simultaneously. • Manipulate data to develop target lists for member communications based on targeting requirements, build queries in SQL language or CRM tools. • Document and maintain procedures and queries necessary to prepare data based on targeting requirements and variations in data sources/formatting • Apply problem-solving and analytical skill in conjunction with SQL language in order to conduct quality assurance checks on data (from initial delivery to final merged data) in order to ensure data accuracy. • Work other senior team member, business partners, including project managers, print production, client account managers and communications product managers, to assist on the flawless execution on data requests • Troubleshoot/research data-related issues and recommend corrective actions • Contribute to requirements and design phases for member communications operations projects • Team works with other Consultants and/or Manager on interactions with business partners to vet data requests and explore options and solving problems.
• Extract data from CVS Caremark data warehouse, manipulate data to generate lists for member communications, as the requirement of requestors’ claims about prescription plans, drug information and benefit management etc. (SAS SQL Macro) • Solve data quality problems and support communication campaign activity by generating mailing lists based on recent prescription claim and geo-demographic data. (Access) • Handle multiple projects of varied complexity simultaneously, interact with IT and business partners on various work streams including development, testing and implementation of new applications and improvements to our existing workflow.
- Research, manage and edit the content of MarketsWiki.com, an online open source encyclopedia focusing on the financial markets. - Project: Dark Pools Trading Construct the database of CME Group Futures and Options contracts. Daily news updating
- Maintained the macro-economic database of European and North America, and analyze with Microsoft Office tools - Apply quantitative and qualitative analysis on Copper futures and assist trading managers with decision-making - Play an active role at research team and be able to work independently
- Developed customers relationship with the manager - Guided customers to finish the process of claims settlement in the case of car accident
• Collected employees' information for evaluation • Managed and reclassified employees' information after staff transferring