Robin Ying Email & Phone Number

New York, NY

Hackensack, NJ

• 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.

New York, United States

• 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.
• 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.
• 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.

United States

• 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.

Parsippany, NJ

• 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.

Hoboken, NJ

• 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..
• 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.
• 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.

Postgraduate Degree

Master Of Science - Ms, Management Of Information System (Mis)