Database Architect Resume Profile New York, NY - Hire IT People

SUMMARY:

Diversified experience in team leadership as well as in design, development, coding, testing, and supporting computer software on PC's and IBM Mainframe. Solid mathematical background Statistics, Quantitative Analysis . Databases modeling and designing, Application development.

SOFTWARE

OS: MS Windows NT, MS Windows '9x/2000/XP/Win7, MS Windows 3.X, and MS/PC-DOS, UNIX

Languages: VB.NET, Visual Basic 3-6 , Transact-SQL, PL/SQL, VBA, FORTRAN, PL/1, and Clipper.

Databases, ETL and SYBASE 11, MS SQL Server 6.5/7.0/2000/2005/2008-R2 SSIS-ETL ORACLE 8, FoxPro,

Data modeling tools MS Access 97/2000/2003/2007/2010 including Access VBA , INFORMATICA, ERWin 7.0

Spreadsheets and MS Excel Excel VBA , Lotus 123, Seagate Crystal Reports 4.6-9 ,

Reporting tools: MS SQL Server 2005-2008 R2 Reporting Services, SharePoint

PROFESSIONAL EXPERIENCE

Confidential

Database Architect

Personal responsibilities and achievements included:

Phase 1. Based on business model and user requests designed relational database concept. Parsed system information rules and criteria and completed data modeling and relational databases design
Created MS Access database and all components of the processes. Raw data have been loaded from flat files using Import specifications. Encryption/decryption concept was implemented for input/output files.
Created and implemented Application Reporting Engine using both MS Excel OLE Automation and templates.. Output workbooks have been formatted using VBA.
Created security system with different types of permissions for multi-user environment.
On Phase 2 converted back-end from Access to MS SQL Server 2008. Linked tables approach was implemented for Access GUI using ODBC. The Bulk Copy utility has been ran from VBA for daily-based import process.
Moved business logic calculations from VBA to SQL Server views, user-defined functions and procedures.
Created views and stored procedures instead of queries and VBA code to enhance performance. Extensively used indexes and index views to increase efficiency of the back-end operations.
On Phase 3 added new functionality for Global Job Grading process based on specific corporate criteria.
Elaborated the Row Level Security RLS concept and implemented RLS to application business model.
Provided regression tests for all stages of the application.

Confidential

Database Architect / Application Developer Consultant

Full development cycle includes

Creation of the business requirements document BRD .
Database modeling and design tables, relationship, indexes .
Design and creation GUI. Coding, testing and debugging file importing process, calculation and reporting modules. MS Excel workbooks with tables and graphs have been chosen as output.
Creation the reporting system, which contains over 20 Excel workbooks generated from MS Access VBA procedures.

Confidential

Personal duties included:

Parsed system information rules and criteria provided data modeling and relational databases designing.
Created MS Excel 2010 template, which using ADO retrieves data from password-protected MS Access database and allocated data on several raw data worksheets.
Using MS Excel 2010 VBA coded, tested and debugged procedures created pivot tables and charts.
Various MS Excel reports generated from VBA code allows validate loaded data as well as compare risks of the previous and current report cycles.

Confidential

Database / Application Developer Consultant

Using ODBC connection retrieves information from SYBASE databases to populate/refresh mapping tables.
Designed and developed number of the Excel reports extensively using templates containing MS Excel Macros. Raw data have been retrieved to Excel workbook from SYBASE using ODBC or connection string. Then VBA code created and formatted different types of reports including Pivot tables and Charts.
Using powerful features of the MS Access 2007 linked SharePoint tables to Access. Created tool to modify information in SharePoint files. Improve VBA code to automatically re-link SharePoint tables to Access application.

Confidential

Report Conversion included:

Replacement of the specific ML credit risk indicators with BAC indicators in over then 900 Excel reports, using either metadata engine or modifying the SQL statements or SYBASE stored procedures, which retrieve data from databases.
Report criteria correction. Provide mapping of the BAC indicators to Merrill Lynch indicators. Development includes both MS Excel macros and SQL queries upgrading.
Coding, testing and debugging changes in Excel templates with VBA Macros as well as underlying SQL statements and SYBASE stored procedures.

We provide IT Staff Augmentation Services!

Database Architect Resume Profile

New York, NY

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship