• Administered Elite 3E application - Foundation for Marketing Dept. Updated SQL scripts to import data from 3E Master Datamart to application server. Troubleshooting issues, proposing solution and testing the results. • Administered BizTalk service for BillBack, Invoice and Voucher as well as Concur/Pivot applications etc. 3E data importing and exporting. Troubleshooting and fixed the issues on BillBack cost, invoice management etc.• Responded 3E financial systems tickets, solving user requests on 3E Vision – CompuLaw application, Client\Matter and user account related 3E issues. • Helped the time entry system migration from Elite 3E to Intapp - Time, trained to practice admin role when the application goes live.• Monitored the viDesktop application for HR and troubleshot the errors when some issues emerged. • Reviewed and updated the tech documentations at firm’s OneNote system.

• Administered Elite 3E financial systems, managed user accounts at 3E USERS system for onboarding and offboarding legal staffs. Controlled timekeeper’s access to 3E Workspace for time entry.• Oversaw, monitored, tracked, and reported the performance and capacity of 3E system to ensure the health and stability of the solutions owned. Provided recommendations to tech lead for enhancements and new capabilities. • Conducted routine financial systems ticket response, solving 3E Workspace time-entry issues, follow-up of users’ feedbacks. • Performed data extraction, transformation, loading (ETL), analysis, and troubleshooting using Intapp Integration Builder and 3E Wilson Integration Portal, including legal data on CourtAlert, Chrome River Invoice, Westlaw, Lexis Advance Search, and LoopUp etc. • Developed and delivered enhanced SSRS reports using Power BI Report Builder for firm’s various client\matter administration, Accounts Payable, Billing and Collections, Marketing etc., financial and management departments and deployed to Power BI development and production report servers. • Wrote SQL scripts to read data from 3E production database to create 3E Cosine Broadcast notifications for firm’s various departments, e.g., legal conflict, client\matter administration, accounting, and billing, etc. • Responsible for some 3E templates (‘Design Gallery’) upgrade, related XML files and 3E tables updates.• 3E production web server load-balancing certificate creation and renewal. Created system architecture and process documentations for use by team and users.• Built, maintained, and advanced a strong relationship with Elite 3E, Intapp, and other vendors. Understood the roadmap for specific offerings and possessed strong knowledge of the Finance space.• Created daily working report and had regular MS team meetings with management to present work progress and provide planning, roadmap, patching, testing, QA, and remediation etc. suggestions.

• Database management. Data Modeling, Database backup, restoration, data loading, mirroring setup. • Administrated Microsoft Dynamics GP application for user permission, access privilege, and security settings.• Routine database monitor, maintenance, permission control, troubleshooting to ensure integrity and consistency of data.• Various environment (i.e., Development, Test and Production) data migration, testing, and store procedure deployment. • Business modeling, database design, table/view creation, PK/FK, index, and default constrain setup.• Created DBCC plus cursor batch file to re-size database files to optimize available disk space. • Established database security and permission procedures. Maintained records/documentation of programs as needed.• Participated in multidisciplinary projects and collaborate with different project leaders and programmers to fulfil different business missions.

• Designed, built and data ETL of a company major Data Warehouse. • 2006 version SAP B1 ERP system financial module Meta data research, documentation, and data analysis.• Wrote complex SQL queries, stored procedures to extract data from SAP server and create comprehensive business reports using Power BI. • Performed routine maintenance and update of company master data stores as well as data QA.

• Fully responsible for company’s data migration from various sources (Sftp, e-mail in .txt or .xls) into database using ETL tools (BCP, Bulk insert and data import/export Wizard) and SSIS packages. Dealt with rich data. Troubleshot technical issues, optimized package process, and improved ETL efficiency.• Designed SSIS packages and setup scheduled jobs to automatically update database tables on daily basis.• Wrote complex SQL queries and stored procedures to extract and edit data from database according to business logic to make comprehensive and precise reports daily and monthly. Distributed the reports to senior managers and other collaborative teams. • Performed verification and QC of reports from various sources. Designed QC reports using screenshots or Excel spreadsheet. Deployed the QC reports to SharePoint server. • Completed all the projects assigned within deadline and with decent quality.