Financial Systems Analyst Norcross, GA

PROFESSIONAL EXPERIENCE:

Technical Consultant, Atlanta, GA

Confidential

Responsibilities:

Provided customization (.NET) of 3rd party software implementations.
Adding additional functionality and connectivity to accounting system.
Installed network hardware and software including TCP/IP, Security, Internet, Printers and IP Telephone system, for an accounting firm.

Confidential, Norcross, GA

Financial Systems Analyst

Responsibilities:

Created automated application in .NET and MS SQL to publish multi - tiered reports for the Americas (US, Canada, South America), with distribution to the field offices. Data was pulled from multiple sources including Oracle and SQL databases.
Modified existing applications to Sun’s processes and accounting practices (.NET, Access, SQL).
Modified existing databases’ structures and data to meet Sun requirements.
DBA of an MS SQL 2000 Server and Alea (BI) Server. Write SQL procedures, functions and views. Use MS SQL DTS to import/export data from Oracle, spreadsheets and text files (ETL). Currently more than 25 SQL jobs running in schedule.

Confidential, Norcross, GA

Financial Systems Analyst

Responsibilities:

Developed VB.NET application to automatically create revenue sharing journal voucher entries. Currently being used for data warehouse management reporting (Sarbanes Oxley).
Lead ASP.NET application developer for Black Belt project resulting in $1.2mm per year in savings. Developed web application for automating exception requests between the field sales force and administration.
Developed and maintained Access application to apply business rules to Field forecast submissions. Imported and cleansed Siebel exports. Programmed application to load data into SQL Server tables for processing. Extracted and transformed (DTS) final submissions to load into Alea (BI) and submit to WWOP.
Analyze and develop finance models to automate business processes.
Create reports for Field Management and data entry templates used for Forecasts and Planning.
Support applications using VB.NET, MS Access, MS SQL, Oracle, Brio and Excel.
Created training materials. Supported and mentored users of Brio, Excel, Access and Alea.

Technical Consultant, Atlanta, GA

Confidential

Responsibilities:

Supported ultrasound application, in Access, for large medical practice specializing in maternity care. Managed connectivity to ultrasound machines from Windows computers and assumed responsibility for Windows PC and Windows network support in a UNIX environment.
Installed network hardware and software for a law firm using Windows 2000 Small Business Server, including Exchange, VPN, Terminal Server, TCP/IP, Security, Internet, Printers and Tape Backup. Set up client computers, accounts and VPN.

Confidential, New York, NY

Y2K Implementation Manager/Programmer

Responsibilities:

Programmed add-on modules to vendor products in Access, MS SQL and Visual FoxPro.
Designed and implemented MS SQL database for data exchange (ETL) between Accounting, Case Management and Records and Document Management system (iManage - now Interwoven).
Designed migration from Netware to Windows NT, PCs from DOS to Win-98. Migrated Accounting, Case Management, email, document management system and word processing from PC databases to 2- and 3- tiered systems, for Y2K compliance.
Created all project proposals for presentation to equity partners with emphasis on ROI and TCO.
Negotiated vendor pricing and implementation deadlines.