Sql Server Accounting
Resume:
Nelson Ricardo
******@*************.***
Professional Experience:
Skadden, Arps, Slate, Meagher & Flom LLP, New York, N.Y., May 1997 – January 2013
Client Accounting Systems Supervisor, April 2005 – January 2013
Client Accounting Project Leader, April 2003 – March 2005
Client Accounting Systems Coordinator, April 2000 – March 2003
Billing and Collections Coordinator, September 1998 – March 2000
Billing and Collections Assistant, May 1997 – August 1998
• Supervise Client Accounting Systems team (reporting and application development)
• Supervise Electronic Billing team
• Assist with oversight of other Client Accounting staff worldwide
• Guide, mentor, train, and support Client Accounting staff globally, as well as other Aderant
Expert Billing users worldwide
• Liaise and coordinate with other departments, including accounting, finance, tax, budget,
marketing, business systems & information, and I.T., as well as with partners, other
attorneys, and their assistants
• Prepare client accounting, billing, and financial reports and analyses using Microsoft SQL
Server queries and Microsoft Excel spreadsheets
• Supervise and lead technology projects related to Aderant Expert and related applications,
including ExpertImage, star*collect, and star*targetCash
• Develop and implement upgrade testing plans for existing applications
• Review, evaluate, and recommend prospective applications
• Create and update bill format templates using Aderant Expert’s DocuDraft language
• Oversee all aspects of electronic billing, including coordination of initial setup with e-
billing vendors and clients, day-to-day e-bill submission to clients, and resolution of
problems and issues
Education:
New York University, New York, N.Y.
• Bachelor of Arts in Economics, College of Arts and Science, September 1993 – May 1997
• Certificate of Advanced Studies in Information Technology, School of Continuing and
Professional Studies, 2000 – 2001 (course of study not completed)
• Certificate in Business Intelligence, School of Continuing and Professional Studies, Spring
2013
• Certificate in Advanced Web Development, School of Continuing and Professional Studies,
Summer 2013
• Certificate in User Experience (UX) Design, School of Continuing and Professional
Studies, Fall 2013
Skills and Knowledge:
General Applications and Programming Languages:
• Microsoft Excel, including advanced/expert/power-user features
• Microsoft Word
• Structured Query Language (SQL):
• Microsoft SQL Server –Transact-SQL queries
• Microsoft SQL Server Reporting Services (SSRS)
• Microsoft SQL Server Analysis Services (SSAS)
• MySQL
• Visual Basic for Applications (VBA)
• Hypertext Markup Language (HTML), including HTML5
• Cascading Style Sheets (CSS), including CSS3
• JavaScript
• jQuery
• PHP: Hypertext Preprocessor
• Extensible Markup Language (XML)
• Asynchronous JavaScript and XML (AJAX)
• C programming language
• SAP Crystal Reports
Legal and Professional Services Industry-Specific Applications:
• Aderant Expert (formerly CMS Open/CMS.Net) – time, billing, financial, accounting, and
practice management system for law firms and other professional services – extensive
experience using Billing and related modules; deep and broad knowledge of database
structure and data tables; DocuDraft
• Legal Electronic Data Exchange Standard (LEDES) – 1998B, 2000, and XML E-Billing
version 2
• Uniform Task-Based Management System (UTBMS) – phase, task, activity, and expense
codes – litigation, project, counseling, and bankruptcy
• Various electronic billing (e-billing/e-invoicing) systems, including TyMetrix 360 (T360),
Serengeti Tracker, Datacert/ShareDoc, CounselLink, LegalPrecision, Bridgeway eCounsel/
Corridor, Collaborati, Bottomline Legal Exchange, Lawtrac, DoeLegal DoeBilling, Ariba,
J.P. Morgan Business Settlement/Order-to-Pay Network (Xign), OB10, and others
Languages:
• English – native tongue
• Portuguese – near-native fluency
• Spanish – conversational
• Italian – conversational
Contact this candidate