Robin Ying
Manhattan, NY*****
Email: ad3u4p@r.postjobfree.com, Phone: 212-***-**** (c)
Summary
Master’s degree on MIS (Management of Information System) from City College, CUNY
Legal firm working experience, Elite 3E system training, Client\Matter data reports, financial systems data analysis, AP, AR, billing report creation using Power BI Report Builder
18 years data analysis, report, data modeling and MS SQL Server database administration (DBA) experience
10 years Business Intelligence (BI) experience (data ETL, mapping, package configuration and migration, analysis service and reporting) using MS SQL server SSIS, SSAS, SSRS, Power BI
Solid SQL DBA skills: Server upgrading, data migration, data modeling and database design, create tables, database query, using operators, data sorting, data restructuring, alias, various table joins (inner, outer, cross, self), using subqueries and multiple queries, using index, performance tuning, using view, T-SQL, cursor, stored procedure, trigger, dynamic SQL, XML
Trained at project management using SDLC, Agile/Scrum, O-O and UML etc.
Professional experience of most advanced MS SQL Database server installation and configuration. Installation and configuration of virtual machine VMware and Window Servers
Knowledge of Oracle DBA experience: user account setup, system privileges, database security
Full knowledge on finance: read financial report, understand key statistic data
Highly collaborative team player with great verbal, written communication, and interpersonal skills
Proven ability to prioritize and complete multiple tasks, capacity to approach problems effectively and creatively
Self-motivated quick learner and hard worker. Willing to take responsibilities
Superior analytical skills to think through complex, multidimensional problem and propose solutions
Computer skill:
Database: MS SQL server, DBA, SSIS, SSAS, ERwin, Oracle, MySQL, DB2, DPA
Reporting: SSRS, Power BI Report Builder
Languages: SQL/T-SQL, MDX, XML, Python
Operation system: Windows, VMware, Window servers
Professional Training:
Computer: MIS, MS SQL server, Business Intelligence (BI), Power BI, Bioinformatics, data mining and machine learning
Legal Financial systems: 3E database, Client\Matter, Power BI Report Builder
Management: Ethical working environment building, task planning and goal setting, change management and innovation, team motivation, personal communication, performance monitoring
Personal: Quick learner, attention to detail, smart- and hard-working, focusing and commitment, personal skills
Selected Achievements:
Master’s degree of MIS (Management of Information System) from CCNY, CUNY
Legal firm working experience, 3E financial management system, Legal management and financial report creation
Extensive training on data science, Business Intelligence, business statistics, data mining and machine learning
Successfully downloaded and installed VMware, Window Servers, MS SQL servers (2008r2, 2012, 2016, 2019) on PC
MS SQL server single row and group functions, multi table joins, subqueries, stored procedure, and advanced SQL queries
Extracted data from MS SQL server database tables into flat files and Excel spreadsheets
ETL data from flat files and Excel spreadsheets in remote servers, including Oracle, into SQL server database using SSIS function
Constructed Data warehouse, cube and performed data mining, KPI using SSAS
Generated different kinds of multidimensional business reports using Excel, SSRS, Power BI, Tableau
Work History
Technology Support Group, Kramer Levin Naftalis & Frankel LLP, NY Dec. 2021 – Present
Financial Systems Analyst
Responsibilities:
Responsible for 3E financial systems data analysis, loading, troubleshooting using Integration Builder (Intapp) and 3E Wilson Data Loading Portal, including legal data on CourtAlert, Chrome River Invoice, Westlaw, Lexis Advance Search, and LoopUp etc.
Creation of user accounts at 3E USERS system for new legal hires. Set up timekeeper’s access to 3E Workspace for time entry.
Designing, creation and modification of SSRS reports using Report Builder for firm various client\matter administration, Accounts Payable, Billing and Collections, financial and management etc. reports and deployed to development report server and production report server.
Conducted routine financial systems ticket response, solving 3E Workspace time-entry issues, follow-up of user’s feedback.
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 dept, accounting dept and billing dept, etc.
Created daily working report and had regular MS team meetings with manager to present work and study progress.
District Council 37, Manhattan, NY Feb. 2016 – Nov. 2021
Data Analyst/BI Developer
Responsibilities:
Database management. Data Modeling, Data backup, restoration, data loading, mirroring setup.
Routine database monitor, maintenance, permission control, troubleshooting to ensure integrity and consistency of data.
Various environment (i.e., Development, Test and Production) data migration, store procedure deployment.
Business modeling, database design, table/view creation, PK/FK, index, and default constrain setup.
Create DBCC plus cursor batch file to re-size database files to optimize available disk space.
Establish database security and permission procedures. Maintain records/documentation of programs as needed.
Participate in multidisciplinary projects and collaborate with different project leaders and programmers to fulfil business missions.
Use Power BI to create regular business reports, perform data analysis and publish to intranet.
Compassionate Care Hospice, Parsippany, NJ May. 2015 – Jan. 2016
Sr. SQL/Business Intelligence Developer
Responsibilities:
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.
PharmLogic Analytics LLC, Hoboken, NJ July. 2014 – April 2015
SQL/Business Intelligence Developer
Responsibilities:
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 different 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 good quality.
IT Department, Victorinox Swiss Army Inc, Monroe, CT Nov. 2013 – Jun. 2014
SQL/Business Intelligence Developer
Responsibilities:
Responsible for the company’s new SellThru Data Warehouse construction. Worked with sales department to establish data warehouse dimension tables and fact-tables e.g., DimMaterial, DimCustomers, DimStores, DimTime, DimRep, Productsales, etc.
Set-up multiple primary keys and foreign keys to establish relational databases.
Designed SSIS packages and scheduled jobs to update dimension tables and daily load sales data regularly and automatically from EDI-852, SAP and SKU, etc. data sources.
Performed routine maintenance for company main data warehouse. Used SSRS to generate reports for sales department and deployed to company Sharepoint server.
Had regular conference meetings with senior directors and presented progress reports weekly.
Research Foundation, City University of New York, NY July 2010 – Oct. 2013
SQL/BI Developer and Data Analyst
Responsibilities:
Managed one project about new generation sequencing by supervising, coordinating and trouble–shooting project operation.
Performed data ETL from various data sources with different file types. Designed and optimized SSIS packages.
Designed and constructed data warehouse, star-schema, cubes, and dimension hierarchy. Analyzed data using data modeling (Erwin) and data mining (data tree, cluster) tools.
Generated reports using report service tools.
Developed and successfully coordinated project plans incorporating all lifecycle phases inclusive of all efforts in matrix environment with teams from various institutions meeting senior management objectives.
Provided weekly progress reporting to senior director via Power Point presentations. Tracked issues, resolutions, and results feedback.
Collaborated with DBA to ensure system performance and project running.
Yale University School of Medicine, New Haven, CT Nov. 2004 – June 2010
Project Manager/Data Analyst
Responsibilities:
Led and conducted an NIH project for pharmacometric research and analysis system. Won 1 million funding from federal government.
Developed project plans, outstanding issues lists for resolution, and managed change control for timelines.
Collecting raw data from front-end research settings transformed and loaded data into database.
Statistic and modeling analysis of dataset using analysis tools to discover new working strategies and improve business process.
Monitoring and preparing reports on practice growth and productivity. Presented results on international conference.
Education:
M.S., Management of Information System (MIS), City College of New York, CUNY, New York, NY
B.S, M.S., Bioinformatics and Engineering, Fudan University, P.R. China
Certified Specialist in SQL Server DBA, Learning Tree International, Herndon, VA, USA
Certificate, Microsoft SQL Server Business Intelligence (MSBI). USA Database Training, LLC. Silicon Valley, CA, USA