We provide IT Staff Augmentation Services!

Senior Database Architect Resume

5.00/5 (Submit Your Rating)

An astute seniortechnology manager with more than sixteen years experience in systems analysis, design, documentation, software development, and project management. Track record of developing revenue enhancing, cost-saving systems for such Fortune 500 companies as Schering Plough and Johnson & Johnson.

Championed design, development and implementation of cost efficient technology processes

  • Part of analytical team on enterprise systems transformation/migration to cloud services cutting costs by 1/3rd
  • Managed data center hardware consolidation enabling client to accept new clients for hosting services.
  • Saving Vitech Systems $1 million annually.
  • Process enabling prompt and efficient testing rather than weeks of development and fixes at the client site.

Decisive Leader adept at identifying roadblocks, defining requirements and executing technology solutions.

  • Custom development project at I.U.O.E. had stalled after 2 1/2 years of work. Integrated business rules and re-structured legacy data.
  • Turned around stalled project; saving company $550K annually; Moved project into production within 10 months,
  • Saving $250K in development costs and $300K in software company\'s newly available resources.
  • Developed and implemented stalled Hyperion Essbase finance reporting application in under 6 months; Moved project ahead to support financial data reporting.

Excellent communicator adept at conveying complex ideas to coworkers, as well as clients.

  • Designed a communication database to track lessons for new hires and store all related information saving Johnson & Johnson $200K annually.
  • Part of data warehouse team that shaved 26% off warehouse load cycle.
MBA, Management Information Systems
BA, Chemistry / Physics / Computer Science

Professional Experience

Confidential, Alexandria, VA - Consultant w/ Security Clearance Nov 2010 - Present
Lead Associate - Working on government EA contracts

  • Worked on government IPv6 initiative for the DOT
  • Lead Records Management PM managing budget, financials, monthly forecasts, tracking and risk assessment
  • Principal Consultant on database conversion project
  • Designed ETL process and converted data for National Bridge data

Confidential, New York, NY - Consultant Aug 2010 - Oct 2010
Senior Database Architect

  • Worked on a private client Data project as an independent consultant.
  • Data Modeling using Erwin.
  • Utilize Talend/Pentaho DI open source data integration tool for ETL.
  • Design ETL strategy and solution for government data application on Solaris 9 platform for Bloomberg NYC project.
  • Database platform: MySQL 5.1/Oracle 11g.
  • Designed and implemented data standardization process.
  • Process and work flow documentation.

Confidential, Dallas, TX Oct 2008 - Aug 2010
Senior Database Architect

  • Data Modeling using Quest Data Modeler.
  • Develop strategy for data warehouse implementation on Postgresql/Mac OS X platform.
  • Part of a team to develop OLAP cubes, MDX queries for reporting.
  • 2 direct reports; a Database Administrator, a Java Analyst/Programmer.
  • Utilize Talend/Pentaho DI open source data integration tool for ETL.
  • Project planning with custom project planning tool.
  • Design and document process flow diagrams
  • Designed and Implemented online portal for ETL data life cycle tracking.
  • Supporting Marketing Services with Decision Support reports to clients.
  • BI tools SAS, Pentaho Designer, BIRT (Eclipse based)

Confidential, Brooklyn, NY - Consultant Apr 2008 - Oct 2008
Senior Data Architect

  • Design hardware/software infrastructure for legacy data.
  • Develop strategy for data warehouse implementation on Oracle 11g/Linux platform.
  • Develop strategy for Business Intelligence reporting.
  • 3 direct reports; an Oracle DBA, a Java Architect and a Business Analyst.
  • Utilize Talend Open source data integration studio for ETL.
  • Support marketing reports on Postgresql database on Linux platform.
  • Project planning with Microsoft Project.
  • Installed and administered Oracle 11g RAC on Linux (centOS)
  • Oracle metalink administrator for patches and general support.
  • Evaluate Hyperion Financial Management for the Finance department.
  • Evaluated WebLogic and Jboss application servers for SOA/Web Services project

Confidential, Trenton, NJ - Consultant Feb 2008 - Apr 2008
Senior Technology Project Manager

  • Email infrastructure assessment and implementation of Exchange 2003.
  • Network analysis, recommendations and implementation.
  • Software compliance assessment.
  • Network/security vulnerability assessment and corrective implementation.
  • Process analysis and process flow modeling using MS Visio.
  • PowerPoint presentations to senior management on network assessment and project updates.
  • Implemented NAS for weekly backups.
  • Implemented hosted Exchange server over http

Confidential, Lyndhurst, NJ - Consultant Nov 2007 - Jan 2008
Database Director

  • Manage standardization, migration, transformation, validation and quality assurance of data within a PostgreSQL database.
  • Worked on Data/Database architecture improvement process using TOAD data modeler.
  • Assisted in SQL scripting for database updates and reporting.
  • Used MS Access for data manipulation and First Logic as ETL tool for disparate data loads.
  • Process analysis and process flow modeling using MS Visio.
  • Responsibilities included supervision of PHP/ASP/C++ developers.
  • Software requirements gathering from business data analysis.

Confidential, Princeton, NJ - Consultant August 2007 - Nov 2007
Senior Project Manager/IT Director

  • Manage IT budget and 9 staff including Oracle/SQL Server DBAs across 5 locations.
  • Managing hardware/software infrastructure for the data center and responsible for Strategic IT operations.
  • Network monitoring and equipment status with Nagios network tool.
  • Cognos 7 Business Intelligence reporting administration and support.
  • Support of UNIX shell scripts for data load process.
  • Upgraded SQL Server 2000 to SQL Server 2005 for VB/.Net application.
  • Designed process and managed outside developer on VB/.Net/ASP project interfacing with clients.
  • Lotus Notes email, development and application support.
  • Project management using MS Project, MS Visio and Quest Data Modeler/Erwin for database logical redesign.
  • IT Security officer for 5 locations.
  • Disaster Recovery planning and implementation for the Data Center

Confidential, New York, NY Feb 2000 - July 2007
Director of Information Technology

Manage the benefit software system, directing the technological infrastructure and strategic vision for this $110M Taft/Hartley union; Manage $600K budget and 5 staff/2 outside consultants and various vendor contracts. Established company wide IT policies and procedures.
  • Designed, developed, and implemented a Point of Sale System with Visual Basic front end using a combination of RUP and Agile methodologies.
  • Streamlined issues resolution, data flow and basic communication processes between departments.
  • Upgraded and implemented disaster recovery and backup software/hardware for the entire organization.
  • Developed in house Help Desk support software to manage end-user, application and desktop support.
  • Implemented HIPAA-compliant security measures, dramatically reducing organization vulnerability.
  • Successfully migrated AS400 legacy system to Oracle 9i/10g on Sun Solaris overseeing the entire database development project.
  • Installed and implemented SQL Server 2000 for Business Intelligence reporting.
  • Database environment security assessment for organization.
  • Project management using MS Project, MS Visio and PowerPoint presentations to the executive team.
  • Led team though the entire SDLC process in development of various Web-enabled applications using ASP, flash, Dreamweaver and MySQL database.
  • Implemented NAS for backup

Confidential, New York, NY 1998 - 2000
Project Manager/Data Manager

  • Managed 5 staff, data conversion ETL efforts and project updates for up to 10 simultaneous clients.
  • Developed client data sourcing and data mapping document; Supervised the Oracle DBA group.
  • Directed all client data conversion efforts, educating clients on Oracle procedures implementation.
  • Handled client visits, requirements planning for database development, data modeling and design.
  • Implemented iterative simultaneous data and software code testing process.
  • Client PowerPoint presentations and project documentation using Visio and MS Project.
  • Database security assessment for all client implementation projects.
  • Support and maintenance of PL/SQL programs for various clients.
  • Oracle metalink administrator.

Confidential, Union, NJ 1998
Information Systems Programmer/Analyst

  • System Project manager, architect and Developer of Hyperion Essbase 5.0.1 OLAP Server for financial reports.
  • Implemented ETL process from AS400 to multidimensional database.
  • General systems support of in-house and field Regional Managers.
  • System Project manager on Demand Solutions software for requirements planning and warehouse replenishment using RAD methodology.
  • Project lead on implementing Business Objects 4.1 (BI) connected to the AS400 server in Memphis.
  • Project management and reporting using MS Project and Visio.
  • Designed, developed and implemented MS Access 97 application for the Finance department.

Confidential, Piscataway, NJ 1996 - 1998
Senior Information Management Analyst

  • Analytical support to Finance regarding data warehouse information using MS Access, Business Objects and SQL/SQL*PLUS; Also supported PL/SQL and Pro*C programs.
  • Project lead on purchase and implementation of 2nd party data cleansing/integrity tool.
  • Project lead on Lotus Notes database application development in a matrix environment using RAD methodology.
  • UNIX shell scripting/Business Objects reports to support finance department.
  • Technical lead on sourcing data warehouse with pharmacy information.
  • Project management using MS Project 4.0, Visio and MS PowerPoint presentations.
  • Maintained daily updates to Oracle V.7.3 database and UNIX component of data warehouse ETL.

Confidential, South Orange, NJ 1994 - 1996
Adjunct Math Professor/Chemistry Tutor

  • Taught developmental algebra course, Intro to the Internet, and HTML Basics.
  • Project lead on FoxPro database application design, development and implementation; Excel Macro and HTML programming for the Educational Opportunity Program department.
  • Chemistry tutor with a Graduate assistantship.

Early Career:

Confidential, Edison, NJ 1991 - 1994

Sr. Analyst/Team Leader, Inorganics

  • Managed 5 Chemists.
  • Team lead on Lab Networking project as well as requirements gathering on Oracle software development.
  • Certified Laboratory to receive US Army work increasing revenue by $5M.
  • Drove Lab qualification stage through instrument maintenance, providing stellar chemical results and reduced re-tests.
  • Part of reengineering team to upgrade Lab server and networking protocols.

Confidential, Whippany, NJ 1989 - 1991
Group Leader, Metals Department

  • Managed 7 Chemists.
  • Designed and implemented Oracle database programs for Laboratory Information Systems (LIMS).
  • Certified Laboratory to receive US Army work increasing revenue by $1.5M.

Confidential, Newark, NJ 1985 - 1989
Environmental and Chemist Group Leader

  • Managed 6 Chemists across 2 shifts.
  • Managed technology and software projects for the lab.
  • Data migration to new database from mainframe.
  • Developed Lotus 1-2-3 macros for monthly government reports allowing reports to go out 5 days before due dates.

Technical Training: Extensive experience in
OS: Linux, Win NT, Win 2000, XP, Vista, Sun Solaris, HP-UX, AS/400, UNIX
Software: Business Objects, Crystal Reports, Certification in PowerPoint, Excel and Word, WordPerfect, OpenOffice, Citrix metaframe, Cognos Impromptu
Databases: Oracle 6.5/7.3/8i/9i/10g, Sybase, MS SQL Server 2000/2005, Teradata, Interbase, DB2, PostgreSQL, MySQL, MS Access, Paradox, Lotus Notes 4.5
RDBMS: Quest T.O.A.D., DBArtisan, ErWin, Toad Data Modeler, E/R Studio, SQL Navigator, Sql Developer
Languages: Visual Basic, .NET, ASP, C++, HTML, Java, JavaScript, Dreamweaver, PHP4, Unix Korn shell scripts, DOS, PL/SQL, Pro*C, SQL, JCL, TSO/SPDF, Python, J2EE
Email Server: Exchange, Lotus Notes, Novell
Methodologies: Total Quality Management (TQM), ETC Corp., 1992., SDLC, Rapid Application Development, Iterative Data warehouse, OOP, PGP, SAN, NAS, VPN
Switches/Routers: Cisco 1600, 1750, Cisco Catalyst, IP Phone 7940G, SonicWall Firewall, iPrism, IDS
Infrastructure: Nagios, OCS Inventory, MS Active Directory, Novell eDirectory, LDAP, SDLC

We'd love your feedback!