Senior Database Architect Resume
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.
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
- 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
