Junhao Fu

Web Crawling and Data Extraction:

• Engineered and deployed sophisticated web crawlers using Python, effectively aggregating essential data from various online sources.
• Utilized Pandas library extensively for cleaning and structuring text data, ensuring high-quality inputs for company projects.
• Significantly enhanced data collection processes, resulting in 20% increase in data volume available for analysis, thereby improving the accuracy of subsequent analytical processes.
  

Application Development and Data Analysis:

• Spearheaded the development of a robust analysis application using Python and Django, integrating seamless database interactions.
• Designed and implemented advanced features for quantitative analysis of extensive project data, including key financial metrics such as revenue, sales volume, profit, profit margin, revenue growth rate, profit growth rate, as well as critical corporate parameters like assets, liabilities, stock prices, market valuation, and dividends.
• Ensured the application's scalability and efficiency in handling large data sets, providing valuable insights for strategic decision-making.
  

Translation Plugin Development:

• Innovatively created a Python-based translation plugin, enabling swift and accurate translations between Chinese and English within the database.
• Enhanced data accessibility and usability for multinational teams, facilitating smoother cross-cultural collaborations and data-driven strategies.
  

Bond Issuance Project Involvement:

• Actively participated in bond issuance projects for Yongqiaochengtou Holdings, focusing on government bond issues.
• Collaborated closely with financial engineers in the issue team, playing a critical role in selecting and implementing appropriate pricing models.

Data Collection and Analysis:

• Tasked with gathering essential market and bond-specific data crucial for bond pricing. This included collecting information on interest rate levels, payment flows of the bond, maturity times, and credit ratings.
• Employed advanced data cleaning and standardization techniques to ensure the accuracy and usability of collected data.

Model Development and Calibration:

• Contributed significantly to the development of computer programs for selected bond pricing models, particularly the pure discount model suitable for government bonds.
• Responsible for calibrating model parameters using real-time market data to ensure precise and reliable bond pricing.

Performance Validation:

• Conducted extensive backtesting and sensitivity analyses on the pricing models to assess and validate their performance under various market conditions.
• Ensured that the models remained robust and adaptable, providing accurate predictions and insights for effective bond pricing strategies.

Data Collection and Cleaning:

• Utilized Python to develop efficient web crawlers for extracting comprehensive drug sales data.
• Employed the Pandas library to meticulously clean and organize a large-scale drug sales database, encompassing over 100,000 data rows and spanning from 2009 to 2016.
• Ensured data accuracy and usability by including diverse data types such as drug names, ingredients, descriptions, manufacturing companies, and annual sales figures.

Data Analysis and Decision-Making:

• Conducted in-depth analyses of pharmaceutical companies, focusing on aspects like production capacity, innovation, and profitability.
• Analyzed prominent pharmaceutical companies including Pfizer, Merck, Novartis, and AstraZeneca, leveraging data to evaluate their market positions and financial health.
• Employed various decision-making methodologies, such as earnings per share analysis, net present value (NPV), internal rate of return (IRR), and the capital asset pricing model (CAPM), to derive insightful conclusions from the collected data.

Strategic Insights and Reporting:

• Synthesized complex data into actionable insights, aiding in strategic decision-making processes.
• Prepared comprehensive reports and presentations, effectively communicating findings to stakeholders and guiding investment and operational strategies.