Jessica Claire
, , 100 Montgomery St. 10th Floor (555) 432-1000,
Professional Summary
  • Working experience in Banking Domain, Biopharmaceutical Domain.
  • Strong Practical Knowledge of Waterfall, Agile, Scrum, RUP.
  • Strong Business analysis skills including in depth knowledge of Software Development Life Cycle (SDLC).
  • Extensive experience in developing Use Cases and Test Cases.
  • Creating the UML Diagrams including Use Case Diagram and Activity Diagram.
  • Strong Practical Knowledge of Data Governance, Data Warehouse process, Master Data Management.
  • Hands-on experience of generating data visualization reports and dashboards using Tableau/Power BI based on the data retrieved by SQL queries.
  • Proficient execution of SQL query to retrieve, manipulate and validate data for data analysis and data visualization purpose.
  • Strong experience in ERP Systems (IFS) Implementation, Support and Project Management
  • Outstanding communication ability including presentation, organizing the meeting and coordinate with different stakeholders.
  • Project methodology: SDLS, Agile, Rational Unified Process (RUP)
  • Business Modeling Tools: MS Visio
  • Database: SQL
  • Defect Tracking Tools: HP ALM
  • Business Applications: Microsoft office Suite, MS VISIO
  • Data Analysis Tools: R, Python, Microsoft Excel
  • Document Tools: Microsoft Word, Microsoft PowerPoint.
Professional Experience
11/2021 to Current Data Analyst Clough, Harbour & Associates, Llp | Brooklyn, NY,


  • Participated in the Sprint Planning meeting and Scrum daily meetings with different Stakeholders and Product Managers to discuss the scope and get sign offs on Business requirements.
  • Conducted data analysis using logistics model, tree classification and random forest method.
  • Employed SQL Queries and integrate with Tableau to develop complete and visualized reports and dashboards from various databases.
  • Built automated dashboards using Tableau and SQL Server to share relevant insights that would outline the critical information for the business.
  • Executed SQL queries to test the database for records that detect and submit functional acknowledgment.
  • Gather, document, and analyze data/information from various platforms including IFS ERP and MS Suite programs.
  • Data transaction and Data cleaning by using the IFS System and SQL.
  • Worked on the financial area of IFS ERP system, concentration with Supply Chain Management, Purchase and Material Management.
  • Performed data entry tasks through various databases to display an organized inventory.
  • Assists the Materials Management Team in all aspects of Material Distribution and inventory control.
  • Helping the Financial Team to do the adjustment of cost variance for the inventory.
  • Utilized the VLOOKUP to gather data scattered throughout another MS Excel spreadsheet.
  • Summarize large quantities of data by using the Pivot Tables in Excel.
  • Helping QA team to release the QCPASS inventory in the IFS system.
  • Creating the Test strategy, Test plans, Test scenario and Test cases for helping the QA team.
  • Worked with the QA team to conduct a User Acceptance Testing (UAT) of the final product.
09/2021 to 11/2021 Business Data Analyst Intern Internet Brands, Inc. | New York, NY,


  • Utilized Software Development Lifecycle (SDLC) overflow to configure and develop process.
  • Gathered, aggregated, and modeled critical business requirements to forecast changing market variables.
  • Created Workflow diagrams and Activity Flow diagrams to clearly demonstrate processes and timelines.
  • Migrated current analysis report from Excel files to Power BI dashboards, migrate the Business/Operation logic and rules to new BI software which could improve work efficiency and reduce human errors.
  • Categorize different number sets and list them accordingly to make it easier to sort by using the Pivot Tables.
  • Performed real-time dashboards and reports using Power BI for executives to track the Key metrics and provide valuable insights.
  • Wrote and optimized diverse SQL queries while working on RDBMS Oracle SQL Developer.
  • Test the QA team's final scripts and assist QA to create Test cases.
05/2021 to 08/2021 Delivery and Inventory Data Analyst Intern Comptree Inc. | City, STATE,


  • Perform data analysis (SQL and Excel) on delivery results and prepare results to supervisor.
  • Coordinate with manager to provide support to staffs with delivery data analysis, to improve delivery results.
  • Monitor delivery result data issues and coordinate with manager.
07/2017 to 08/2017 Risk Control Team Intern China International Capital Corporation Limited | City, STATE,


  • Researched on the regulatory stipulations regarding annuity, outsourced business and clearing accounts with the regulatory requirements sources from the company’s internal regulations, the restrictions set forth in agreements and governmental policies.
  • Conducted monitoring before, in, and after the investment process.
  • Inspected on product agreement, conducted risk estimation, revised the investment scope, and disclosed investment risks.
  • Approved all asset management products: sent out transaction requests in the Homs System
  • Given the authority to manually approve investment actions according to the pre-set risk control criteria.
Expected in 08/2021 to to Master of Science | Statistics Rutgers University-New Brunswick, New Brunswick, NJ, GPA:
Expected in 08/2020 to to Master of Science | Economics University of Illinois At Urbana-Champaign, Champaign, IL GPA:
Expected in 06/2018 to to Bachelor of Science | Mathematics China University of Geosciences (Beijing), Beijing, China, GPA:
Expected in 06/2018 to to Bachelor of Arts | Law China University of Geosciences (Beijing), Beijing, China, GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Rutgers University-New Brunswick
  • University of Illinois At Urbana-Champaign
  • China University of Geosciences (Beijing)
  • China University of Geosciences (Beijing)

Job Titles Held:

  • Data Analyst
  • Business Data Analyst Intern
  • Delivery and Inventory Data Analyst Intern
  • Risk Control Team Intern


  • Master of Science
  • Master of Science
  • Bachelor of Science
  • Bachelor of Arts

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: