Supporting AWS MigrationCloud System Testing

• Served as a key member of Scrum team for AMTM- Fannie Mae’s internal capital market pricing application, performed daily analysis on large housing finance dataset with SQL server to ensure compliance with QA standards and customer specifications• Worked in conjunction with product owner and developers to meet business requirements, delivered numerous products that improve user experience, and enhanced performance of the application• Performed quantitative financial data analysis using SQL and Python, developed testing strategies and executed test plans to continuously refine valuation models for mortgage-backed securities (MBS), single-family and multi-family loans, debt, and derivatives• Automated processes with Alteryx and Python to increase testing efficiency for user activities UI data mapping validation, multi-family loan pricing validation• Participated in weekly business meetings to demonstrate new feature change, and present test evidence to provide developer teams and business user teams with detailed reports on quality metrics, identified bugs/flaws, and recommended fixes• Identified data discrepancies and their root causes regarding recent pricing method adjustment, preventing millions of dollar wrongful reporting

• Executed daily email marketing communications and generated customer awareness of key sales promotions and new product launches• Created online marketing strategies to strengthen the online presence and launched digital advertising campaigns using Google AdWords and auction-based, pay-per-click platforms• Optimized performance of an advertising campaign by selecting appropriate words or phrases, determined appropriate bids for keywords to appear on Google's Search, fueled additional revenue stream by increasing the conversion rate by 132% for Q1 and 300% for Q2• Provided monthly performance reports for the manager for SEM programs, tracked, analyzed KPIs utilizing Google Analytics. Optimization of Social media campaigns saw an increase in user engagement and website page views by 300% in Q1 and Q2 2018• Assisted in providing ROI analysis on digital marketing campaigns, created presentations with Tableau to illustrate the effectiveness of campaigns and provided strategic insights to drive performance within the Marketing Department

• Worked cross-functionally with Sales, Marketing, and Finance teams to measure ROI and KPI’s to support budgeting and forecasting, managed and execute ad-hoc reporting, dashboarding and business analysis• Facilitated managing SEO and SMO projects implementation, collected requirements and oversaw the optimization timeline, generated weekly report with business insights for the CEO• Created and incorporated new inbound marketing strategy to generate > 300% organic traffic and leads• Performed Keyword search volume analysis, A/B and Multivariate testing, On & Off-site optimization • Developed ETL processes to consolidate data from diverse data sources into a uniformed SQL Server 2005 database, reviewed and improved existing SQL code such as developing new ad-hoc queries, to meet marketing campaign objectives • Collaborated with a group of graphic designers, video producers to create highly-engaging content, managed updating the company’s social media including Facebook, Instagram and YouTube using automation software such as SproutSocial

• Conduct research of market areas related to listed companies, conduct SWOT analysis, predict market prospects, highlight profitable sections.• Create a daily report for potentially profitable stocks, efficiently arrange useful information and present it clearly with persuasive evidence.• Monitor listed companies’ financial activities, including capital budgeting, banking, hedging, risk analysis, and cash flow forecasting.