Data Project Manager
Resume:
Jeffrey Li
ac0t3q@r.postjobfree.com
Work Experience:
Covington Burling LLP 12/2014 - Present
Sr. Tech Project Manager/Enterprise Business Application System Engineer
• Project manager of data integration project for 3E financial system implementation.
• Manage and led efforts in development over 40 3E inbound integration interface programs that include ChromeRiver and foreign exchange currency rates.
• Manage, design, and develop over 70 3E outbound integration programs that include 13 ChromeRiver data feeds and all other enterprise operational data feeds.
• Provided 24/7 Elite financial system support, Webview, ChromeRiver, Elite/3E related databases and servers’ maintenance, and over 30 third party interface applications.
• Manage annual 1099 electronic files generation and filing.
• Obligate for all facets of Probono Net system related data integration, presentation, and reporting.
• Establish and maintain processes of accounting related meta data and data warehouse.
• Obligate to draft tech documents and training protocols to help IT trainers in Elite webview, Chromeriver, 3E time capture, and other systems.
• Hand on development tens of custom financial reports.
• Managed projects relating to Elite, Chromeriver, Ultipro, IntApp Open, and other financial related applications.
• Obligated to setup business user access to Elite, webview, 3E, Image connect, and Chromeriver.
• Manage vendor issues, create support tickets, resolve incidents for all financial system related applications.
• Manage and hand on develop Oanda multi-currency exchange daily data intake application.
• Led efforts to design, develop, and deploy over 15 business processes between 3E and ChromeRiver: task, activity, good payor, travel advance, invoice vendor, invoice G/L, entity, entity type, matter, person, paid invoice, paid expense, matterOnselect, and client refund.
Department of Treasury 10/2012 – 11/2014
IT Specialist (Data Management)
• Team leader of implementation project to design and deploy hundreds of canned workforce reports to a shared web portal that captures broad spectrum of federal human capital practices such as workforce planning, succession, separation, budgeting and forecasting.
• Provide technical guidance to data management team on data extract, transformation, and load from distributed data sources to data warehouse system. Direct a team of consultants on data sourcing, data migration, data modeling, data collection, data marts, and data storage. Develop project plans, create work breakdown structure, lead project team, manage project to on-time and on-budget, receive sign-offs from internal and external federal clients.
• Hand on SSRS, SSIS, SSAS, VBScript, C#, XSLT, XML.
Patton Boggs LLP 05/2003 - 10/201
Sr Financial System Engineer
• Obligate for 24/7 technical support of Enterprise Elite financial system, Webview, Chromeriver, Ultipro, Krono Workforce.
• Led a project team of consultants to design, develop, and implement an enterprise data warehouse solution that integrates distributed data sources from Ultipro HR/Payroll system, Elite financial system, Adaytum/Sotori budget system, and Kronos workforce timekeeper system.
• Obligate to design and develop firm-wide custom reports using SSRS, SSIS, and Crystal Reports for all functional business users. Design, develop, test, and deploy canned HR workforce and finance reports to intranet and SharePoint sites.
• Led numerous application project requirement intake processes. Translate business rules and processes into requirements. Evaluate the feasibility of proposed new systems development projects. Consult with customers to refine functional requirements. Convert functional requirements into design specifications. Determine best approaches for implementation within the technical environment. Work closely with application developers to conduct data mapping. Led efforts to design and develop adequate data architecture to fit special business needs.
• Led a development team to develop a SharePoint 2007 BI reporting portal that includes canned reports using SSRS, graphic chart dashboard using PerformancePoint, and data analytic site using Excel Services.
• Drafted training documents and hand-on training protocols in Elite webview and Chromeriver.
• Manage and maintain data warehouse and canned reporting dashboard. Provided 24/7 customer support on inquiries of custom reports, user access, report subscriptions, canned report usage and interpretations, problems and issues with SQL reporting systems.
• Lead development efforts of extensive cost analysis project to define firm wide cost trend, collection, write-off, and drill downs from General ledger to each cost codes and individual response parties.
Howrey, Simon, Arnold & White, LLP 07/2001 - 04/2003
Tech Project Led
• Project lead of converting legacy financial system WSI in HP/Unix 9.i/Informix system to Elite 3.0 enterprise in HP/Windows 2000/SQL Server 2000 system.
• Oversaw technical conversion team and coordinated daily conversion activities between technical conversion team and financial teams.
• Managed all phases of client-server application developments: HW cost recovery data intake system, Elite data upload system, client invoice management system, and data conversion reconciliation system.
• Project lead in evaluation and selection of third party hardware and software. Led efforts in hardware and accessories specifications for the financial system. Managed change control and problem escalation. Conducted application update and upgrade.
• Developed technical procedures for routine data quality assurance, database system disaster recovery plan, system analysis, database performance tuning, system troubleshooting, and test procedures. Conducted routine database backup, system maintenance, performance tuning and optimization, data modeling, query analysis, application architecture, and documentation.
Patton Boggs LLP 09/2000 - 06/2001
Sr. Consultant
• Team lead in managing enterprise database systems that include Elite financial system, FRX, DOCS OPEN, ULTIPRO, and INTERACTION. Led effort in database migration from SQL Server 6.5 to 7.0 in Windows NT and Windows 2000.
• Obligated for firm wide custom reports. Conducted database design, performance tuning, system analysis, monitoring, backup, and restore. Replicated database files among five remote servers located different offices across United Sates.
• Documented database test procedures, and disaster recovery plan. Designed query definition and created query reports.
• Designed and implemented Congressional, Billing, Questionnaire, and Expense databases.
• Designed, developed, and implemented client-server applications: Expense Report, Congressional Search, Questionnaire, and Overtime applications using VB 6.0, SQL, Crystal report, VBScript, and HTML.
Education:
University of Illinois Urbana, IL United States
Doctorate
University of Nevada-Reno Reno, NV United States
Master's Degree
Chendu Meteorology Institute Chendu China
Bachelor's Degree
Massachusetts Institute of Technology Cambridge, MA United States
Postdoc
Job Related Training:
CERTIFICATES: Oracle 9i PL/SQL; PMP, ITIL V3
Affiliations:
Project Management Institute - PMP
Contact this candidate