| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Manhattan, NYStreet Address
Email: EMAIL AVAILABLE, Phone: PHONE NUMBER AVAILABLE (c)SummaryMasters degree on MIS (Management of Information System)Legal industry working experience, Elite 3E financial system, Client\Matter data reports, financial data analysis, AP, AR, billing report creation using Power BI Report Builder, BizTalk, CompuLaw (Adrant), Foundation, Concur, Pivot, Iridium, IManage, Design Gallery, BillBack, Paperless Proforma, Wapi, 3E FUNC, Intapp Time, Boomi18 years data analysis, report, data modeling and MS SQL Server database administration (DBA) experience10 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, Visual BasicPower BI Proficiency: Administration, Report server installation and configuration, Report Service, Report Builder, Power Query, DAX, API, Visualization, PublicationSolid SQL Developer and DBA skills: Server upgrading, data migration, data modeling and database design, create tables and views, write complex query, using operators, data sorting, data restructuring, alias, various table joins (inner, outer, cross, self), using subqueries and multiple queries, using index, performance tuning, stored procedure, using CTE, variables, user-defined functions, dynamic SQL, cursor, trigger, dynamic SQL, XMLPowerShell: cmdlets, functions, variables, parameters, exception handling and automated scriptingTrained on 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 ServersKnowledge of PL/SQL Oracle Database and DBA: user account setup, system privileges, database securityFull knowledge on finance: read financial report, understand key statistic dataHighly collaborative team player with great verbal, written communication, and interpersonal skillsProven ability to prioritize and complete multiple tasks, capacity to approach problems effectively and creativelySelf-motivated quick learner and hard worker. Willing to take responsibilitiesSuperior analytical skills to think through complex, multidimensional problem and propose solutionsComputer skill:Database: MS SQL server, DBA, SSIS, SSAS, ERwin, Oracle, MySQL, DB2, DPAReporting: SSRS, Power BI Report BuilderLanguages: SQL/T-SQL, MDX, DAX, XML, Python, PowerShellOperation system: Windows, VMware, Window serversProfessional Training:Computer: MIS, MS SQL server, Business Intelligence (BI), Power BI, Bioinformatics, data mining and machine learningLegal Financial systems: Elite 3E database, 3E Workspace time entry, Client\Matter, Power BI Report BuilderManagement: Ethical working environment building, task planning and goal setting, change management and innovation, team motivation, personal communication, performance monitoringPersonal: Quick learner, attention to detail, smart- and hard-working, focusing and commitment, personal skillsSelected Achievements:Masters degree of MIS (Management of Information System)Legal firm working experience, Elite 3E financial management system, Legal administration, and financial report creation, various legal application administrationExtensive training on data science, Business Intelligence, business statistics, data mining and machine learningSuccessfully downloaded and installed VMware, Window Servers, MS SQL servers (2008r2, 2012, 2016, 2019) on PCMS SQL server single row and group functions, multi table joins, subqueries, stored procedure, and advanced SQL queriesExtracted data from MS SQL server database tables into flat files and Excel spreadsheetsETL data from flat files, Excel spreadsheets and remote servers, including Oracle, into SQL server database using SSIS functionConstructed Data warehouse, Data Mart, cube and performed data mining, KPI using SSASGenerated various kinds of multidimensional business reports using Excel, SSRS, Power BI,Work HistoryIT Department, Cole Schotz P.C., Hackensack, NJ May. 2024 PresentEnterprise Applications EngineerResponsibilities:Administered Elite 3E application - Foundation for Marketing Dept. Updated SQL scripts to import data from 3E Master Datamart to application server. Troubleshooting issues, proposing solutions 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 firms OneNote system.Technology Support Group, Kramer Levin Naftalis & Frankel LLP, NY, NY Jan. 2023 Apr. 2024Financial Systems AnalystResponsibilities:Administered Elite 3E financial systems, managed user accounts at 3E USERS system for onboarding and offboarding legal staffs. Controlled timekeepers 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 firms 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 firms 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.District Council 37, Manhattan, NY Feb. 2016 Dec. 2022Database Analyst/DBAResponsibilities:Database management. Data Modeling, Data 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.Used Power BI to create regular business reports, perform data analysis and publish to intranet.Compassionate Care Hospice, Parsippany, NJ May. 2015 Jan. 2016Sr. SQL/Business Intelligence DeveloperResponsibilities: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 2015SQL/Business Intelligence DeveloperResponsibilities:Fully responsible for companys 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.IT Department, Victorinox Swiss Army Inc, Monroe, CT Nov. 2013 Jun. 2014SQL/Business Intelligence DeveloperResponsibilities:Responsible for the companys 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. 2013SQL/BI Developer and Data AnalystResponsibilities:Managed one project about new generation sequencing by supervising, coordinating and troubleshooting 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 2010Project Manager/Data AnalystResponsibilities:Led and conducted an NIH project for pharmacometric research and analysis system. Won one 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, NYB.S, M.S., Bioinformatics and Engineering, Fudan University, P.R. ChinaCertified Specialist in SQL Server DBA, Learning Tree International, Herndon, VA, USACertificate, Microsoft SQL Server Business Intelligence (MSBI). USA Database Training, LLC. Silicon Valley, CA, USA |
