Result-driven senior application analyst and database architect with extensive experience in analysis, planning, designing, developing and implementing high profile, complex and business critical systems. Dynamic, resourceful and extremely driven individual with a deep passion for creating and delivering solutions that empower a team, company and customer to meet and exceed desired expectations.
Proficient in Database development, Data modeling (Conceptual, Logical and Physical), Technical architecture, Process engineering and integration.
Proven ability to translate information requirements into computer applications and meet both department needs and aggressive operational deadlines.
Dedicated worker, set effective priorities to achieve immediate and long-term goals.
Self-motivated, dedicated worker; high attention to detail and able to implement decisions to ensure smooth work-flow and meet aggressive operational deadlines.
Strong communication abilities verbal, written and electronic.
Ability to proactively analyze, troubleshoot, and resolve issues.
Ability to react to change and redirect focus.
Ability to identify and resolve complex technical concerns with high attention to detail
and meet aggressive deadlines.
Microsoft SQL Server (SQL 2008): Database
Engine - Integration Services - Data Analysis Services OLAP, Microsoft
Visual Studio 2008 Projects: SSIS, DTS, MS-DOS (.bat and .cmd), Crystal Reporting, Analysis
Services, Crystal Analysis, Tidal Enterprise Services, QlikView
11, Cognos, Microsoft
Office 2010, Excel Macros, Microsoft Access, Introspect Document
Imaging, cVision, OakDoc, Sharepoint, Watermark,
Filenet, Journyx, TeamTrack, Merant, Visio, VM &
MVS FOCUS, C++, PL/1, Basic, TSO ISPF, JCL
BTMU Capital CorporationApril 1997 to CurrentSr. Application Analyst Boston, MA
Led the re-engineering, design, development, and implementation of
an enterprise data warehouse that incorporates information from multiple data
sources including vendor and in-house applications (Leasing/Loan system,
General Ledger, Fixed Asset, Deal System, Transaction Ratings, Taxes).
Integrated and consolidated the
information for reporting and data analysis with focus on risk,
obligations, projections, and exposure. All work
was delivered successfully and on time.
Information is collected and
stored at regular intervals and was developed to be repeatable in the
event of a required re-run. Nightly batch has proven stable for 12 years.
Created innovative time-saving,
robust system that handles automated database updates of multiple
spreadsheet data by multiple business units. The process is dynamic and
variable driven enabling users to upload changes to month end data.
Includes validation and reject notifications.
Developed all translation,
validation, currency conversion, and clean-up routines that handle data movement.
Acted as the key architect.
Designed a database to handle year to date activity for deferred tax balances between the Tax Provision model, the Lease system, General Ledger, and Asset system. Beginning
balances are staged each month end and ending balances
are calculated by data-mining reports as well as extracting data from multiple systems and spreadsheets. The data gets summarized and rolled into a grid of beginning and ending balances. All processes are automated so the data is loaded into the TaxStream database as data become available.
Bridge files are created to continuously check the General Ledger against the Tax Provision model. The Tax Provision model creates a journal entry that automatically interfaces to the General Ledger. A spreadsheet
is created for the end users with multiple
tabs that summarize the source data. The entire process is repeatable.
In summary, this was an involved manual process that was entirely
Resolved the complexity of the data mappings and translations and
designed the in-take of data at different points in the time while
synchronizing and consolidating the output for the purpose of balancing to the
Ledger and ultimately feeding back to the Ledger and the Tax System.
Maximized end-user productivity by reducing users processing time from
several days to a half day.
This complex project was completed in a month and half time without any
Payroll Database (2013-Current)
Created a new process to update payroll transactions into the General
Ledger. This allowed the Tax and the
Accounting Department to easily upload a pay period of transactions into the
Ledger. The process modifies Excel files, downloads the proper account
combinations from the General Ledger, translates the headquarters accounts, and
creates CSV files that the user can load into the ledger. The process is all automated except for some
required data entry. Users receive
e-mail notifications with timing, spreadsheet updates, account translations,
and success/failures. This
project was completed
in a month and half time.
SmartStream Fixed Assets (2008 -
Re-wrote all vendor routines to import Fixed Assets data from Rental 4000 system (Progress
Database) to the Asset system (SQL Database).
Wrote batch, configured routines to move the data around the
network. Tested and debugged all the
Sharepoint Document Management (2013)
Worked on the analysis and design of a Sharepoint site to hold the IntroSpect documents. Worked with consultants
IntroSpect and Sharepoint to implement the migration of the document conversion. Ran the utilities to convert the Introspect Tiffs to pdf documents. Implemented cVsion tecnology and a process for scanning
and importing documents into Sharepoint.
Finanancil Warehouse Database
Developed a warehouse that interfaced with both a
reporting database and the Lease system.
Worked on the architecture which resulted in performance gains and made the system more maintainable. Wrote the specifications and the backend for
a Power Building application. Wrote all DTS packages and was the key contributor in the design and implementation of
audit data and a processing id concept.
In addition, created multi-dimensional database cubes.
Worked as analyst
on the analysis, design, development, testing and implantation of several
in-house applications including Deal Process, Tracking, and Financial Warehouse.
Played a key role
in the deployment of IntroSpect Document
Management system housed from 1997-2013. Responsible for rolling it out to
users, testing all modules, training, maintenance and upgrades.
Played a key role
in several SmartStream and LeasePak upgrades and implementation of a new server.
UnicareJanuary 1997 to April 1997Senior Systems Analyst - Group Systems Boston, MA
John Hancock Mututal Life Insurance CompanyJune 1995 to December 1996Senior Systems Analyst - Financial Systems Boston, MA
Education and Training
Boston University Metropolitan College1994Master: Computer ScienceBoston, MA, USBoston University Metropolitan College, Boston, MA - Master in Computer Science 1994 Software Engineering, Network Analysis and Design, Object Oriented Programming, Database Development
Suffolk University1985Business AdministrationBoston, MA, USASuffolk University 1985 Bachelor in Science in Business Administration - Computer Information Systems