Sr. Data Architect Resume , Purchase, N.Y - Hire IT People

SUMMARY:

Senior Database Architect who leads all SQL related projects while maintaining a highly visible and accessible presence. Extensive background in building and managing Production, Development, and testing databases. A strong focus on project development and execution by collaborating with multiple departments to develop projects that meet business needs. Strong ability to target risk before and during project implementation while providing risk management solutions. Skilled in managing these aspects in a timely manner and ensuring successful project execution in accordance with specified deadlines. Articulate and innovative, with a demonstrated capability to solve complex business problems and create new opportunities.

PROFESSIONAL EXPERIENCE:

Confidential, Purchase, N.Y

Sr. Data Architect

Responsibilities:

Assisted in the relocation of our datacenter from Purchase, NY to a hardened site in Virginia.
Designed, Created and implemented reporting repositories of production systems for reports not suited for data warehouse.
Responsible for all Microsoft SQL server databases in versions 2000, 2005, 2008, and 2012
Assisted in designing, creating, and implementing a Data warehouse in SQL 2005 with Microstrategy as the BI tool for reporting.
Designed, Created, and implemented all SSIS and ETL load jobs for the Data Warehouse which brings together four major systems, insurance billing and scheduling, proprietary EMR system (Artworks), the general ledger system, and the Human Resource system.
Project Manager Human Resource system implementation
Project Manager/Designer/Programmer for proprietary Risk Management system
Project Manager for Beryl FTP data transfer
Project Manager for ADP automatic report generation and FTP transfers of same reports Responsible for upgrading all existing hardware to meet future demands of the company's data Member of IT team to migrate existing in house datacenter to a hardened site Member of IT team to determine which.
Create and maintain all ERD diagrams for all database production systems using Erwin Data Modeler
Create and maintain all database maintenance backup, optimize, and cleanup jobs for all database systems
Responsible for all Domain user certifications for all active employees for yearly audits.
Migrated Data Warehouse databases and all SSIS ETL jobs from SQL 2008 to SQL 2012
Installed SQL Report Builder and migrated all reports, datasources, datasets, and subscriptions from SQL 2008 to SQL 2012.

Confidential, Wappingers Falls, N.Y

Sr. Database Administrator

Responsibilities:

Managed all Microsoft SQL Databases
Developed SQL stored procedures when needed
Evaluated and debugged SQL code Managed and designed a Credentialing database
Project manager for Horizon Cap project.

Confidential, Newburgh, N.Y

Computer Consultant

Responsibilities:

Installed and managed all aspects of ACT database
Set up client groups and input client information Design company brochure for prospective clients
Upgrade and install computer software Install wireless network for companies New York office
Upgrade computer hardware for New York and Florida office.

Confidential, Tarrytown, N.Y

Database Administrator/Project Manager

Responsibilities:

Contribution was the design of the nightly Oracle data load from over 10 hours to under 5 hours by optimizing the Oracle configuration files.
Completed Oracle Masters in Database Administration Responsible for Oracle production systems versions 7.x - 9.1 running on NT 4.0 and Windows 2000 Maintained PeopleSoft test, development, and production databases Assisted in PeopleSoft upgrades Proposed and managed Oracle consolidation project.
Moving systems from Alpha NT and VMS onto Windows NT 4.0 Developed monitoring scripts to check Oracle performance Perform all tuning of Oracle databases Responsible for hardware configurations, installation and setup of Oracle systems Used Enterprise Manager along with scripts to check Oracle systems Proposed and implemented Raid5 onto existing systems Responsible for Oracle to SQL migrations Implemented SQL 7 database for Ciba's legal department Implemented SQL 2000 databases for migration of AS400 and Oracle data Setup ODBC con.

Confidential, New York, N.Y

DBA/Computer Programmer

Responsibilities:

Manager of agency's twelve person computer helpdesk Hired and Managed programming consultants for FileMaker Pro and Macro programming in Excel Managed all databases projects for Filemaker Pro and Oracle Designed and created data files, tables, and indexes for Oracle systems on Sun Sparc systems Used Unix commands to diagnose systems Transferred data from different systems to Oracle Designed and developed databases in Oracle and FileMaker Developed formatting macros in Excel for Brio Query Reports Designed billing package in Rapport for agency's Yellow pages department Re-designed BBS forms for Gillette's TV and print billings form.

We provide IT Staff Augmentation Services!

Sr. Data Architect Resume

Purchase N, Y

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship