Bin Gu Email & Phone Number

South Jordan, Utah, Us

• Support the internal Business Intelligence product with regards to new data and new reporting;• Ad-hoc analysis to address urgent high-impact analysis for business stakeholders;• Support active management of credit, operational, and compliance risk exposures across product and client portfolios;• Use SAS, Viya, SQL, and Tableau to generate reports to show the potential clients for the credit card application, to bring more revenue to the company;• Use SAS 9.4/SAS Enterprise Guide, SAS Linux, to work on data from SnowFlake, applying models to figure out the best group of potential applicants;• Partner with internal and external partners to incorporate learnings from across the bank and the industry to calibrate our payments risk strategies and capabilities;• Evaluate and improve on the current state of our credit card product terms;• Track market conditions and propose changes to our offerings to keep our product offerings in line with the market;• Develop, update, and maintain business intelligence applications such as shiny. Work with management to improve the value and quality of business intelligence;• Utilize various statistical techniques to analyze the credit card customer performance and create strategies to optimize risk/reward relationship;• Provide analytic support for all new account acquisition campaigns and channels;• Coordinate the development, maintenance and ongoing management of daily, weekly and monthly marketing reports;• Develop and maintain comprehensive performance reports for all campaigns and strategies implemented to acquire new credit card accounts;• Manage strategy and implementation/audit documentation with other departments and with outside vendors;• Support modeling group in periodic modeling efforts.

Redwood City, Ca, Us

• Worked primarily on the Payment Reconciliation, Prescription Drug Event contracts and used SAS, SQL and SPSS to create reports for Centers for Medicare & Medicaid Services (CMS), generated ad-hoc, monthly, quarterly reports and shortened the regular reports from days to minutes. • Applied project management skills, statistical and data management techniques to lead projects, to improve business operations. Designed analysis plan then develop SAS coding and use SPSS to do the statistical analysis, leverage analysis, updated seasonal and ad-hoc reports, used Tableau to visualize the reports to meet clients’ needs at the highest professional level, used SAS, Excel to provide advanced analysis for strategic vision;• Conceived, designed, programmed, developed and managed new data & information resources and business support tools, based on an in-depth understanding of internal customer requests. Worked with customer to understand the underlying issue/need or business problem. Developed comprehensive reports that provide information to assist management in key decisions and performance metric tracking. Reports are based only on internal data, the external market, and lender-provided information, or a combination thereof, requiring more comprehensive analysis and far-reaching implications.

Greensboro, Nc, Us

• Produced data, information, systems, tools, and training that contributed to increased business volumes, reduced operational costs, operational efficiencies;• Managed 3 teammates in person and 12 virtually, including signing assignment for each teammate based on their skills, writing sample code for junior analysts, collecting all pieces and combining into one summary report, with tables created from SAS, Tableau and then represent to supervisor;• Determined user support and training needs. Developed and implemented documentation and training materials to enhance self-sufficiency for users of the department's tools, analytics, and reports. Fully understood the business and the problems/issues of internal customers (line management of varying levels). Utilized an understanding of the "how" as well as the "why" to interpret and analyze available and developed data and information;• Drew conclusions regarding the business impact of the information and prepares reports, presentations, and executive summaries while offering suggestions to management regarding what other types of data may be needed/tracked to address business needs;• Regularly seek and identified ways to enhance the end product and provide value-added consultation to management. Helped identify new areas of the business that may need tracking and analysis;• Addressed and developed work of considerable complexity, utilizing multiple technologies, data sources (both internal & external), departmental records/personnel, and intellectual creativity, to achieve objectives.

Phoenix, Arizona, Us

• Worked on the Partnership for Patients (PfP) Evaluation Contract and directly reports to CMS;• Establishing methodologies, using SAS SQL, analyzing data to obtain meaningful results, reviewing reports for accuracy and generating production codes for customized reports;• Responsible for conducting a thorough assessment of the measures maintained by data providers and other contractors to ascertain data integrity, which includes performing business and information system process modelling to identify opportunities for improvement.• Audited data and measurement submitted by hospitals and compare with external data, generate the report by using T-Test and correlation in SAS. Created graphs for labour measures regarding individual hospitals against Nationwide.• Generated different types of graphs, including histogram, vertical bar, horizontal bar, pie chart, and tables by using SAS Proc template and Proc Sgrender, based on data of labour information for mothers and infants for over 100 U.S hospitals.

New York, Ny, Us

• Developed key relationships with commercial clients for the extensive business;• Used MetLife software to do the premium design for all levels of clients, used SAS and Excel to handle big data, got familiar with database structure.• Systematically explained the details of products to the clients logically, to make them better understanding the premium design and products details;• Collected and sorted sales data and prepared weekly metrics and sales reports to management using company information system and Microsoft Office tools;• Calculated and compiled financial data using Excel in research assignments;• Maintained current benchmark tools, developed Excel and VB Macros combination solutions, and coded new solutions for product projections;• Analyzed existing specifications and algorithms, used product knowledge to create quality assurance solutions, cross-tested projection platforms and generated quality control reports;• Update dividend scale to Individual Life products (Traditional, both Pension and Non-pension) and block Whole Life products with different dividend scale;• Review prospectus, coordinate and support the compliance process before illustration release.

Boston, Ma, Us

• Assisted Prof teaching graduate students Base SAS for 4 semesters;• Graded all homework, quiz and exams and explained all in details;• Created models to calculate huge amount of clinic data, comparing with Excel.

Master, Actuarial Science

Bsc, Mathematics