• Collaborated with various Mortgage Network departments (including Executive, Finance, Legal, Operations, Sales, etc.) and IT to transfer business requirements into technical solutions. • Developed and maintained complex SQL queries, stored procedures, views, functions for data analyzing, data visualization, ETL projects, reporting and ASP.NET applications.• Researched and analyzed reporting requirements. Developed and generated ad-hoc reports for internal and external reporting. •… Show more • Collaborated with various Mortgage Network departments (including Executive, Finance, Legal, Operations, Sales, etc.) and IT to transfer business requirements into technical solutions. • Developed and maintained complex SQL queries, stored procedures, views, functions for data analyzing, data visualization, ETL projects, reporting and ASP.NET applications.• Researched and analyzed reporting requirements. Developed and generated ad-hoc reports for internal and external reporting. • Designed and developed informative and interactive SSRS reports, and published SSRS reports in SQL Server Reporting Service. Managed reports distributions and set up subscriptions.• Analyzed and optimized SQL queries, SSRS reports and ASP.NET applications to improve data accuracy and system performance.• Managed Mortgage Network Accounting (Great Plain) databases, pushed monthly batches to map accounting transactions to each account and processed monthly finance routines. • Identified and resolved Mortgage Network Accounting issues about warehouse data uploading, data discrepancies, accounts setting and accounts transactions.• Troubleshoot and explained system and data issues to Mortgage Network users and improved system and reporting.• Created temples of electronic documents and mapped data to documents.• Integrated inside data and outside data and processed data ETL.• Documented business requirements and solution changes. Show less

• Search and analyze electronic circuit board materials (cores and prepregs) data from various vendors• Clean up and prepare formated data for importing to data library

• Manage sales database, collect and compile customer, product and contract data to provide information to Sales Department.• Generate Sales Department reports and Sales budget audit.• Analyze sales and finance data, create reports to support Vice President’s decision and present to customers and stakeholders • Predict sales trends and forecast sales volumes by analyzing historical data and current contracts. • Analyze orders, shipments and warehouses inventory data to guide… Show more • Manage sales database, collect and compile customer, product and contract data to provide information to Sales Department.• Generate Sales Department reports and Sales budget audit.• Analyze sales and finance data, create reports to support Vice President’s decision and present to customers and stakeholders • Predict sales trends and forecast sales volumes by analyzing historical data and current contracts. • Analyze orders, shipments and warehouses inventory data to guide production arrangements and inventory control.• Solve special customer issues, such as supply chains, customer service, inventories, special orders, returns and rebates. Show less

• Computationally studied the physical and chemical properties of noble metal nanoclusters and simulating the interactions of clusters with small molecules.• Wrote computer programs to build models and sent them to supercomputers for calculations • Wrote programs to extract the data we were interested in from big data produced by supercomputers and analyze them. • Built mathematic models to predict the best catalytic structures for industrial manufacturing.• Wrote peer reviewed… Show more • Computationally studied the physical and chemical properties of noble metal nanoclusters and simulating the interactions of clusters with small molecules.• Wrote computer programs to build models and sent them to supercomputers for calculations • Wrote programs to extract the data we were interested in from big data produced by supercomputers and analyze them. • Built mathematic models to predict the best catalytic structures for industrial manufacturing.• Wrote peer reviewed technical reports and publications. Show less