Senior Software Developer

• Apr 2021 - Present

Software Developer

• May 2018 - Present

NIH OAMP HBCU PEI Database: HHS. Web application development using Java and MySQL. The portal will support the utilization of HBCUs and Business Partners for NIH contract and grant awards.• Uses Java, Javascript and HTML to develop HBCU pre-solicitation portal in Spring MVC framework and Hibernate.• Implements smart matching logic using Elasticsearch to help users quickly identify most relevant contract and grant opportunities.• Implements scheduled tasks through Spring Scheduler to update backend Oracle database.• Manages MySQL database.• Develops proof of concept on Salesforce platform to evaluate the potential migration to a local platform.CMS Clarity: HHS. Provide report creation and support. • Designs and modifies reports using Crystal and Jasper Reporting Tools.• Writes SQL queries to generate data for the reports.• Deploys reports to Business Objects Central Management Console (BO CMC) and Clarity Project Portfolio Management (PPM).

Data Analyst

• Jan 2015 - Present

SDER Library: HHS. Data analysis, web design and development for data elements and data definitions used by the Federal government in agency interactions with the public.• Analyzed Federal repositories of data elements to develop a set of data attributes that are commonly used across the Federal grants sector.• Identified potentially duplicate forms among SF424 family by using data elements with associated attributes developed in the previous data analysis effort.• Performed similarity analysis on data within and across pre-award and post-award grant forms respectively.• Compared, contrasted and mapped data elements used on the grant forms to approved data elements from multiple authoritative sources, such as Uniform Grant Guidance and DATA ACT.• Creates test plan and test scripts of application.• Creates SQL scripts to update Oracle SQL database.• Uses Java, Javascript and HTML to develop CDER Library in Spring MVC framework and Hibernate.• Implemented scheduled tasks through Spring Scheduler to update backend Oracle database.CPSC Open Data I & Recalls Internet Surveillance Widget: CPSC. Development of a RESTful API to expose the Consumer Incident database to the public. Development of a widget for third party websites to incorporate in their existing web sites to extend the reach of the existing recalls database and recalls API.• Led requirement analysis; captured, analyzed, interpret, and document system requirement.• Performed QA techniques on project deliverables to ensure requirements are met and customer satisfaction with both the process and the end products.• Created test plan, test scripts, and executed testing of application.TSRS: DOT. Data analysis, web design and development for data from NTS and STS statistic reports.• Created data dictionary based on the analysis of transportation data from national and state statistic reports.• Created business rules to support creating customized report function in the web application.

Business Development Intern

• Apr 2014 - Dec 2014

Business Development Intern• Researched and identified potential partnerships or clients• Reached out to current partners and assisted management with developing new opportunities• Assisted in creating new business development strategies• Assisted in writing proposals, including modifying resumes and drafting past performance profilesTraining School Program Manager• Worked with clients to come up with detailed project plans using Microsoft Project• Coordinated formal meetings with clients including preparation of all materials and logistical arrangements• Performed financial analysis on the last 3 years of financial information to predict costs and profit over the next 18 months, including cost/profit and return of investment. This information was presented to clients using MS PowerPoint and Excel• Drafted business plans for presentations to clients for possible future partnerships CMS ASPN Training Project Technical Editor• Designed survey questions and focus group questions to discover training needs of regional offices• Analyzed help desk tickets data, using Access Database to analyze training needs based on Regions and applications• Coordinated focus groups and individual interviews among the regional offices to better understand training needs• Reported on meeting minutes, interview results, and Training Needs Assessment (TNA)

Teaching Assistant

• Aug 2014 - Dec 2014

Teaching Assistant for BUSI758-B: Data Models and Decisions taught by Professor Sean Barnes. Teaching Assistant for BUSI758-B: Data Models and Decisions taught by Professor Sean Barnes.

Data Analyst

• Dec 2013 - Dec 2014

• Used EventFlow as a data mining tool to visualize the sequences of drugs usage, significantly simplifying the medical records • Generated medical data sets using MySQL in remote research server SSH Secure Shell and used R as a data mining tool to deal with patient clustering to greatly improve the efficiency • Used excel to clean the dataset and transformed the data to the format of EventFlow• Analyzed and interpreted the data together with professors from the School of Pharmacy• Collaborated with EventFlow development team to debug the software and improve its functions• Presented in the symposium hosted by Human-Computer Interaction Lab in the University of Maryland

Social Media & Registration Department

• Jun 2013 - Aug 2013

• The Eran Group was founded as a manufacturing, turnkey product development, and logistics solutions business. The Headquarter is located in the US with branches in Israel and China.• Co-worked with the design department for the propaganda posters and logos• Daily edited and updated all the information in the official SNS, such as weibo, QQ zone and well-known forums.• Came up with marketing strategies together with marketing team• Offered valuable suggestions for the perfection of the database system

Primary Research

• May 2012 - Aug 2012

 Delivered a thorough presentation of market potential analysis for Turkish Pharmaceuticals market Primarily researched on online database about 40 Chinese Pharmaceuticals companies and translated dozens of documents Assisted the Drug Licensing team to search in the NRDL (national reimbursement drug lists) and Price Lists in China as well as contracted Doctors specialized in oncology in China Planned for a marketing research project in China authorized by one company from Mexico, including the budget and possibility of this project

Consultant

• Mar 2012 - May 2012

Car Parking Assistance Project (Founded by a Fortune 500 firm )  Taking leadership skills courses by associate professor Anders Örtenblad Searching for the background information about the existing industry in China and the potential competitors After analyzing the initial reports, taking the orientation to the business with car parking lots as the marketing strategy Searching for the information about the car parking lots in Ningbo, especially owned by Wal-Mart, Tesco or other shopping centers Designing two kinds of questionnaires for car parking managers and car owners (under way) Analyzing the data using MCA and SWOT (planned) Writing the final report using the information and data analysis with suggestions about the market in Ningbo and the promotion methods (planned) Making a presentation to investors (planned)

Consultant

• Feb 2011 - May 2011

Western Theatre School Project  Searching for the background information about the existing Western Theatre School market in China Designing two kinds of questionnaires for parents and other adults (divided into two groups of male and female) Interviewing more than 200 people around the large shopping malls and the universities Analyzing the data collected using Microsoft Excel with figures and graphs to show the attitudes and motivations of the interviewees towards Western Theater School, their normal ways to get information (for advertising aprts), the time and the size of class they prefer, the accepted price and so on Writing the final report based on the literature review and data analysis Making a presentation of 10 minutes to more than 20 investors

Public Relationship and Project Team

• 2009 - 2011

 Kept in touch with more than 7 social medias and more than 20 famous media in China reported the news about the team Organized the promotion for mass events (more than 500 people attended) including post design and more than 10 media guests invitation In the Greenbag Project, helped 13 disabled persons employed after skills classes Negotiated as well as communicated with the companies to market those green bags(including the Ningbo International Bank and Guangdong Development Bank) Led the team to win the Top 10 social entrepreneurship competition in Zhejiang Province of China Prepared for the SIFE World Cup. Collected and analyzed the information of 50 domestic and 15 oversea competitors, designed strategies for presentation, annual report and Q&A, finally attended the World Cup in Los Angeles (the team won the second place in the World Cup finally against more than 40 teams around the world)

Project Member

• Sep 2009 - Jun 2010

 Organized the activities on Aged People’s Day with around more than 50 people attended and led 7 volunteers Organized the activities of English Salon for more than 20 children and led 5 volunteers Organized the activities of Thanksgiving handwork in a class of a community’s kindergarten with more than 20 children and led 8 volunteers  Organized the activities on Aged People’s Day with around more than 50 people attended and led 7 volunteers Organized the activities of English Salon for more than 20 children and led 5 volunteers Organized the activities of Thanksgiving handwork in a class of a community’s kindergarten with more than 20 children and led 8 volunteers