o Extract and Import electrical rate data from SQL server by using SSIS, built data import, transform and cleansing processes in SSISo Used advanced SQLs to build key facts and dimension tables based on complex billing ruleso Provided support to generate monthly critical rate reports (FS, TS, UTD) using SSRS toolso Worked with business analysts to develop analytics and reporting queries according to business requirements

o Collected data from various sources using SAS and performed data manipulation using data steps o Developed SAS Macro to automate data quality check and data set process. o Predicted the credit risk for new customers by building a logistic regression model with key variables such as DTI ratio, credit card debt, number of inquiries and total open tradeo Compared performance metrics (KS, AUC, Somer’s D, Decile Table) to optimize the business model

Tertiary Oil Research Project (TORP)Modified Microbial Enhanced Oil Recovery Process by Eliminating the Near-Wellbore Plugging with Controlled Delivery of Nutrients by Nanoparticleso Designed a new resuspendable polyelectrolyte complex nanoparticles for entrapping nutrients with a extremely high entrapment efficiency of 98.5%o Optimized the stability of nanoparticles by dynamic light scattering, phase analysis light scattering and UV-vis spectrometero Designed a batch test and monitored the growth of the oilfield microbes in the presence of nutrints loaded nanoparticles by optical density, demonstrated the growth of microbes can be delayed up to 72 hourso Designed sand pack experiments to test the retention of nanoparticles and optimized low retention nanoparticles for different types of sand Hydraulic Fracturing Fluid Cleanup by Controlled Release of Enzymes from Polyelectrolyte Complex Nanoparticleso Optimized polyelectrolyte complex nanoparticles for entrapping enzymes by particle size, zeta potential and UV spectroscopy measurementso Measure the rheological properties of cross-linked Guar and Hydroxypropyl Guar with enzyme breaker loaded in polyelectrolyte nanoparticleso Demonstrated the polyelectrolyte nanoparticles can control the release of enzymes and protect enzymes from denaturation at elevated temperature and pH, the degradation time of Guar and its derivatives was elongated to 12 hours

Petroleum Recovery Research Center (PRRC)o Accomplished the biodegradation of oilfield produced watero Monitored the CO2 ultimate fate in the CO2 sequestrationo Designed CO2 capture process with enzyme enhanced amine solution absorption and algae biodegradationo Participated in the project “Demonstration of produced water purification using co-produced energy source at the well head”

• Inspected, cleaned, transformed, and modeled sales data• Identified, analyzed and presented customer and market information that is critical to business decision making

• Maintained custom data warehouse• Explored and analyzed of large quantities of data to enable insights into customer behavior and operational performance