bambi k bellowsbambibellows.com/wp-content/uploads/2018/11/bambi... · bambi k bellows –...
TRANSCRIPT
B A M B I K B E L L O W S
– Curriculum Vitae –
- Senior Management With Emphasis on Technology -
S U M M A R Y
With nearly 20 years as a C- level executive, over 30 years in technical management, and 35 years as an individual contributor in nearly every field of IT, I have a proven track record of delivering creative and strategic enterprise level solutions, on time and under budget. My projects have been global in scope, achieved billions of dollars in cost savings, modernized manufacturing operations, and brought life-saving drugs to market. A customer-facing technologist, I have worked with clients across North America and Asia, designed and delivered C-Level informational sessions, determined corporate-wide hardware and software requirements, and negotiated product acquisition contracts and VAR agreements. As a team leader, I have led large multi-disciplinary divisions, mid-size local, regional, and international departments, and small “surgical strike” tiger teams. My unique blend of experience affords me big picture vision, the ability to do low level deep dives, and virtually everything in between.
ED U C A T I O N
NORTHEASTERN ILLINOIS UNIVERSITY, Chicago, Illinois Master’s Degree of Science, Computer Science, 1995 – GPA 3.8/4.0 Bachelor’s Degree of Science, Computer Systems, 1993 – GPA 4.0/4.0
NO N -TE C H N I C A L C E R T I F I C A T I O N S
English Vocabulary – Master Level, 2006 Mathematics – Master Level, 2006
TE C H N I C A L C E R T I F I C A T I O N S
Oracle DBA v7, 2004 Oracle DBA v8, 2004 Oracle DBA v9, 2004 Oracle DBA 11g, 2012 Sybase 11.x DBA, 2004
Linux System Administrator, 2006 Solaris System Administrator, 2006 VMS Systems Manager, 2004 Unix System Administrator, 1999 Scrum Master, 2014
C-LEVEL EXECUTIVE EXPERIENCE 1999 – 2016
ECLECTICITY, CHICAGO’S SNAZZIEST STORE Chicago, Illinois
Chief Operating Officer July 1999 – May 2016
Operated world-class, award-winning independent bricks-and-mortar operation from inception to dissolution
Won Best of Chicago awards, Gift Store of the Year award, and received mentions in Chicago Magazine, Midwest Living
Magazine, Chicago Tribune, Windy City Times, Time Out Chicago, Chicago Reader, and Not For Tourists Guide to Chicago.
Highlighted in a 15 minute segment on CLTV. Selected as one of two American Express model small businesses; selected as
one of Shark Week’s target geocaching locations
Negotiated contracts, leases, and vendor agreements
Managed budgets; ensured timely payments for vendors, employees, and taxes
Developed forecasting tool to determine product acquisition requirements for current and historical spend patterns
Attracted, hired, trained, and retained employees, with turnover rates 1/5 of industry standard
Managed as many as 20 employees; created employee handbook
Created and maintained internet website and social media presence
Ensured proper City, County, and State licensing; filed trade- and service mark paperwork, obtained and maintained alarm
permits, and performed similar tasks to remain current on legal obligations
Worked with lawyers, accountants, bankers, and police as necessary
Managed all advertising campaigns
Public face for all television and radio appearances
BKB CONSULTING Chicago, Illinois
Chief Executive Officer April 1988 - June 1990 Determined corporate direction
Attracted, retained, and directed senior staff
Managed all client relationships
Executed contracts and agreements
Maintained relationships with professional service providers
INFORM ATION TE CH N OLOGY 1983 - PR E S E N T
PU B L I S H E D W O R K S A N D A S S E S S M E N T S
Contributing Author, Professional Oracle 8i Application Programming with Java, PL/SQL and XML, Wrox, 2000 Technical Reviewer, Brainbench: Oracle DBA v8 Certification Test, 2000; Oracle DBA 11g Certification Test, 2012 Technical Reviewer, Oracle SQL: 101 Frequently Asked Questions, Komenda Publishing, 1997
MA J O R JO B F U N C T I O N S P E R F O R M E D
Team Lead/Manager Technical Architect IT Strategist Project Manager Solutions Engineer
Business Analyst Systems Administrator Database Administrator Applications Administrator/DBA Product Owner/Manager
Domain/Subject Matter Expert ETL Specialist Applications Developer Scripter Trainer
C L I E N T S
ABBOTT LABS ACCO BRANDS ALLSTATE INSURANCE (x2) ALTRIA AMERITECH (x2) BOSTON CONSULTING GROUP CHRYSLER CITY OF NAPERVILLE DEPARTMENT OF PUBLIC UTILITIES CNA INSURANCE DATALOGICS DIAMOND GROUP DISCOVER CARD DOTOMI
divineInterventures FUJISAWA PHARMACEUTICAL COMPANY USA GENERAL BINDING CORPORATION GIANT STEP INFORMATION RESOURCES /IRI (x4) INSYNC SOFTWARE CORPORATION/PASSPORT INTELLIGENT MEDICAL OBJECTS/IMO LEAPNET LOREX PHARMACEUTICALS MEIYIJA MOTOROLA (x2) NAVIGATION TECHNOLOGIES/NAVTECH/NAVTEQ NCS CHINA PACIFIC BELL DIRECTORY
PEAPOD PEPSI REMARKETING SOLUTIONS SUN MICROSYSTEMS (x2) THESAUCE.COM/FLYINTHESOUP.COM UNITED STATES DEPARTMENT OF DEFENSE DEPARTMENT OF INTERIOR UNIVERSITY OF CHICAGO UNIVERSITY OF DENVER USG CORPORATION (x2) WALMART WEBSTREET.COM WMS/WILLIAMS GAMING SYSTEMS
TE C H N O L O G I E S
Platforms: Unix; MS-DOS/Windows; VAX/VMS; MacOS; DEC/TOPS-20; CDC-Cyber/NOS. Azure, AWS. Hadoop, HDFS, HFS.
Databases: Oracle, SQLServer, Postgres, hive, HBase, DB2, UDB, GreenPlum, Sybase, Ingres, Informix, Access, MySQL
Languages: C/C++, FORTRAN, COBOL, BASIC, Pascal, SAS; Bash, Korn Shell, DCL, C-Shell, Bourne Shell; SQL, QUEL, PL/SQL; TSQL; PD/PL, Pro*C, EQUEL (EQF, EQCBL), Pro*COBOL, HLI/OCI; HTML, Pager, SGML
Administration Tools: Jira, Confluence (plus Admin); Netscape Enterprise Server (Admin Only); Apache (Admin Only); Web Logic (Admin Only); Samba; HP OpenView, OperationsCenter (IT/Operations); Big Brother/Hobbit; Server Manager, Enterprise Manager; EcoTools, Patrol; OpenVision; Autosys; DBBreeze; MapQuest, WellEngaged, ProntoMail, UltraSeek
ETL/ERP/CRM/OEM/OA/Database Design Tools: Oracle Applications Financials/Manufacturing (including iProcurement, iExpense, iStore, Portal); PeopleSoft; Lawson; Tableau, Qlikview; SSIS, SSRS; Erwin, Embarcadero, DBArtisan, Deft, Visual Paradigm; i2 Rhythm, Brio; Business Objects/Crystal Reports, IQ, Cognos, Informatica; Vantive, Remedy; A1 (CM/SM)
Hardware Drivers/Interfaces: EMC Symmetrix; HDS; 3Par; StorageTek WolfCreek Drives; Barcode Printers; Autoloading Tape Drives
TECHNICAL MANAGEMENT – PRIVATE SECTOR 1988 – PRESENT
ECLECTECH, INC Chicago, Illinois
VP, Technical Services and Staffing June 1990 - Present Attract, evaluate, and retain top technical talent
Manage all client engagements
Write contracts and agreements for all aspects of client and employee relationships
Ensure legal and regulatory compliance at all levels
Maintain relationships with external resources (e.g., legal, accounting, insurance)
Respond to RFIs and RFPs
Manage all media relationships; serve as public face for television and radio appearances INFORMATION RESOURCES Chicago, Illinois
Consultant December 2014 – June 2017 Engineering Manager
Led development of a variety of applications for Big Data and Data Analytics projects
Transitioned projects from Linux to Azure; migrated Oracle databases and data warehouses to Hadoop and Hive
Traveled as necessary for client-facing meetings
Determined on- and off-shore staffing requirements
Wrote extensive high- and low-level documentation
ETL Tech Lead Managed China- and India-based teams
Led development efforts to bring IRI’s data analytics product to US- and China-based CPG and retail establishments DOTOMI Chicago, Illinois
Enterprise Database Manager July 2012 – July 2013 Managed cross-functional Data Warehouse Administration and Database Administration Department designed to put optimal
client ad(s) in front of internet users in real time environment. Database environment included Cassandra, GreenPlum, Oracle, Postgres, Hadoop, HBase, MapR, and SQLServer requiring 24/7/365 availability
Created roadmap for data increase of over 300% in database environment without degradation of performance
WMS – WILLIAMS GAMING SYSTEMS Chicago, Illinois
Senior Principal Manager – Database Administration – Applications DBAs March 2011 – December 2011 Provided hands-on leadership for international DBA and Apps DBA Teams
Performed employee management tasks, including reviews, determination of pay increases, and disciplinary actions
Managed vendor and consulting relationships, including direct negotiations with Oracle
Worked with Legal Department on verbiage for contracts and purchase orders
Ensured timely payment of invoices to third party providers
Developed processes and controls to establish and SOX-compliant Change Management System ALLSTATE INSURANCE Chicago, Illinois
Consultant November 2008 – April 2011 IT Strategist Served as Strategist for the following ventures:
o Enterprise-Wide Storage Vendor Selection, Sizing, and Implementation o Business Continuity and Emergency Management o Hardware Determination, Costing, and Amortization o Data Center Migration/Co-location o Database Consolidation and Upgrade/Patch Integration o FTE Resource Allocation o Future-Facing Technology
REMARKETING SOLUTIONS Chicago, Illinois
Consultant (Project concurrent with Allstate Contract (above)) October 2009- April 2010 Database Manager
Worked with management, end-user community, and development teams to gather requirements and determine design of all aspects of vehicle repossession and remarketing
Developed Enterprise Database architecture, and rearchitected Legacy DB2 database to ensure proper data retention and ease of migration using SSIS
Managed all personnel, tasks, and timelines, and performed Project Management tasks associated with the database and data migration from DB2 to SQLServer
Served as technical architect and database subject matter expert on multiple Agile development teams THESAUCE.COM/FLYINTHESOUP.COM Chicago, Illinois
Consultant October 1999-July 2000 Director of Technical Division
Led 30 person multi-disciplinary team comprised of database architects, Oracle and SQL Server DBAs, system administrators, network administrators, and data analysts
Managed all aspects of technical administration for B2B and B2C websites Oversaw evaluation, selection, purchase, installation, and administration of products, including Netscape, Weblogic,
Samba, Ultraseek, MapQuest and ProntoMail Spearheaded single sign on (SSO), unified registration efforts, and remote authentication efforts Product Owner Served as Agile team Product Owner for a variety of web-based applications including welcoming registrants, job match
functionality, automated newsletter generation, batch-level geocoding, and determination of dual-point proximity GIANT STEP Chicago, Illinois
Director of Database Technology May 1999-October 1999 Managed database administration supporting several B2C websites with SQLServer backends, including Pella.com,
Maytag.com and startsomething.com Performed logical and physical design of VLDBs and data warehouses Researched ancillary technology to collect demographic, technographic and psychographic metrics for correlative marketing
AMERITECH Chicago, Illinois
Consultant December 1996-February 1997 Manager of Architecture and Planning- Database
Visited prospective client sites in pre-sales capacity to determine technical requirements for new service agreements Architected custom solutions, including determination of optimal software design and database interfaces
Defined database standards and naming conventions for use across Ameritech’s technical departments
INFORMATION RESOURCES, INCORPORATED (IRI) Chicago, Illinois
Consultant August 1995-December 1996 Assistant to the Director of Database Administration
Standardized job function, wrote job descriptions and defined training requirements for all levels of DBA Department
Member of corporate disaster/recovery and co-location committee
INSYNC SOFTWARE CORPORATION (PREVIOUSLY PASSPORT) Ronkonkoma, New York
Regional Manager (Mid-Atlantic Region) August 1993-April 1994 Performed pre-sales site visits to various Army and Air Force bases nationwide
Answered Requests for Information (RFIs) and Requests for Proposals (RFPs) from federal agencies
Wrote Statements of Work (SOWs) and follow-on proposals for consulting teams at client sites
Analyzed staffing requirements and timelines
Responsible for talent acquisition, retention, and training
Participated in marketing analysis and strategy sessions
Member of executive technical staff determining requirements for the first release of PC-based product FUJISAWA USA Deerfield, Illinois
Consultant June 1991-August 1993 Assistant to Associate Director of R&D Computing
Assisted with quarterly and annual budgets and five year plans for R&D Computing Department
Determined database and software tools requirements, evaluated products, and wrote analysis and costs justification documents
Wrote job descriptions, and hiring requisitions; performed employees interviews
National and International Committee/Working Group participation: Global Safety, Global Communication, U.S. Safety, Standard Operating Procedures, Contract Research Organizations (CROs)
International Pharmaceutical Ethical Product Development Subject Matter Expert
Researched differences in regulatory reporting obligations and clinical practices between the United States, Canada, France, England, Germany, Israel, and Japan
Worked with international representatives of global Clinical and Regulatory departments to ensure sufficient and consistent handling of Adverse Drug Reactions worldwide
Assisted in creation of documents submitted to the FDA required for approval of drug, including, but not limited to, IND, NDA, and Integrated Safety Summary
Created corporate-wide break-of-blind Standard Operating Procedures guidelines
Enterprise Architect
Interviewed executive and senior staff to determine requirements for clinical trials, budgetary, regulatory and project management systems to track product development from synthesis/acquisition through post-approval reporting obligations, including all phases of preclinical and clinical trials
Created 540-page systems specification document for system called FACTS (Fujisawa Advanced Clinical Trials System), including module overviews, screen templates, database structure, lexicons, valid values, and reports
Submitted for, and received, department sign-off and approval of the Vice President of R&D for every module, screen print and report
LOREX PHARMACEUTICAL COMPANY Skokie, Illinois
Consultant April 1988-July 1990 Technical Team Manager
Performed all areas of personnel management o Interviewed Candidates o Wrote Performance Reviews o Implemented Staff Reduction
Prioritized and scheduled application developments
Defined and implemented enterprise-wide Work Assignment and Work in Progress systems
Enterprise Architect
Gathered requirements definition from each department involved in clinical development and interacted with top management to prioritize development tasks associated with clinical trials
Analyzed clinical processes and Safety Summaries to automate/expedite the Investigational New Drug application (IND)
Interviewed members of all technical and financial departments to determine functional requirements and design
Wrote Standard Operating Procedures covering Randomization, Break of Blind, and Emergency Distribution and Release
Product Owner* Developed and delivered Joint Venture C-Level presentations on advantages of automated clinical trials
management system in order to obtain buy-off on development efforts
Managed Applications Development Team for Lorex’s Integrated Clinical Trials Management System (ICTMS)o 17 sub-systems o Screen-Level Access by Drug
o 225 screens o Over 500 reports
Oversaw all phases of the Software Development Life Cycle through user-training and full documentation * This product was delivered in 1990, and survived the dissolution of Lorex, Searle’s merger with Pharmacia, and
Pharmacia’s acquisition by Pfizer. It was still unchanged, and in use, as of 2015, and, to the best of my knowledge, is still in use, bringing drugs to market, today.
Enterprise Training Manager
Managed department-specific training programs on usage of Integrated Clinical Trials Management System
Chaired the Lorex Oracle Users’ Group, a vehicle to provide informal database training for development staff
TECHNICAL EXPERIENCE – INDIVIDUAL CONTRIBUTOR – PRIVATE SECTOR 1984 – PRESENT
INFORMATION RESOURCES Chicago, Illinois
Consultant December 2014 – June 2017 ETL Architect Determined functional requirements and database design for broad-based product offerings for Fortune 500 clients
Designed and implemented new product offering allowing clients to determine share of wallet based on item hierarchies across custom geocoded areas, defined in miles, kilometers, or drive time
Isolated and rectified address, longitude, and latitude data which was not in conformance with CASS specifications ETL Team Member Received, analyzed, standardized and segmented data from heterogeneous sources into consistent database model
Determined and remediated bad data, including at the binary level, and in Chinese character sets
Performed DBA tasks in SQL Server and Oracle, including interfacing between the two
Wrote Linux and MS-DOS scripts with embedded TSQL, SQL, and PL/SQL to perform ETL operations INTELLIGENT MEDICAL OBJECTS Chicago, Illinois
Consultant Subject Matter Expert (SME): Oracle, GoldenGate, Scripting July 2013 – December 2014 Served as in-house expert to analyze, rectify, and optimize scripts, showing decreases in processing time of ~80%
Wrote mechanism to sync current product database with remote client, maintaining integrity of deprecated software
Researched, developed and delivered training programs and documentation
Provided input on products required for new Oracle Unlimited License Agreement
Company sponsored attendance at Oracle University Golden Gate Courses
Company sponsored Scrum Master Classes and Certification
DOTOMI Chicago, Illinois
Senior Database Administrator December 2011 – July 2012 Served as Lead DBA for all environments; wrote scripts to automate processes, as appropriate
Developed break-glass problem resolution strategies
ALLSTATE INSURANCE Chicago, Illinois
Consultant November 2008 – April 2011 Data Architect Determined physical and logical database architecture
Performed data modeling for business initiatives, including Entity-Relationship Diagrams and Process Flow Diagrams
Created graphical representations of topology, memory mapping, and storage
Determined project definitions, identify project resources, timelines, and milestones
Provided strategy for optimal processing, e.g., splitting applications from their dictionaries for replication purpose Data Warehouse DBA
Analytics
Customer Experience
Emerging Business
Existing Business
Recoupment
SAP Business Intelligence
UNIVERSITY OF CHICAGO Chicago, Illinois
Senior Shared Applications Coordinator May 2008-November 2008
Managed technical and user relationships for alumni/development system. Implemented Sungard Higher Education modules for client/server and web Initiated drive to integrate monitoring and metrics gathering across infrastructure team Provided DBA (Oracle, SQLServer), Unix, Windows, and Business Objects administration services as required
ACCO BRANDS, INC., GENERAL BINDING CORPORATION Northbrook, Illinois
Consultant August 2007-April 2008
Project Lead Oracle Applications Database Administrator/Oracle DBA
Developed and implemented strategies for synchronous change management, high-level provisioning, cloning, patch management, and disaster recovery
Worked closely with other members of team on scheduling and resource allocation for first corporate multi-org installation Determined corporate naming standards and programming conventions Wrote scripts to automate DBA functions
USG CORPORATION Chicago, Illinois
Consultant October 2004-August 2007
Lead Oracle Database Administrator for CORE-IT
Performed Oracle database administration on databases with combined sizes into multi-terabyte range with emphasis on monitoring, performance and space management
Managed and performed Sarbanes-Oxley auditing procedures and change management processes Wrote software to migrate applications across platforms Supported MSCA, Documentum, Sungard (Entegrate and HAS), Sabrix and Mercury ITG Automated and scheduled regular DBA functions
Lead Applications Database Administrator BII Project; Senior Applications Database Administrator LinX Project
Performed Oracle Financials and Manufacturing 11i applications administration on multi-tier, multi-language, multi-currency, multi-org environment with automatic failover
Co-located remote recovery environment, including upgrades and patching, cloning and migration, installation of printers and printer drivers, queue management and provisioning
Provided primary technical support responsibilities in War Room settings after rolling releases Reconfigured contextual indexes Configured custom Apache services Integrated standard OLTP system into Oracle Financials and Oracle Manufacturing Responsible for reporting quarterly and year-end financial information to external auditors
Senior SQLServer Database Administrator Performed SQL server database administration and wrote SQLServer DTS procedures Integrated SQLServer and Oracle into commercial website.
NAVIGATIONAL TECHNOLOGIES (NAVTECH/NAVTEQ) Chicago, Illinois
Senior Database Administrator: Oracle and Sybase September 2003-October 2004 Performed logical and physical design for databases and data warehouses Designed and implemented cross-instance data migration and delta analyses Conducted analysis to recommend hardware configuration and database licensing options Ensured data integrity to street name level with cross-check against lists of forbidden words and phrases Optimized SQL*NET for multi-platform transAtlantic database environment Wrote and maintained Standard Operating Procedures documents as required Committee and Working Group participation: Executive Level Architecture and Planning, Geospatial Product Development,
Performance and Scalability Developed scripts for standard DBA tasks
Benchmark Engineer
Served as database and systems administrator at Sun Microsystems’ benchmark facility Defined and implemented benchmark tests, success and failure criteria Analyzed results to make recommendations for configuration changes and optimal hardware and database configurations
DISCOVER FINANCIAL SERVICES/DISCOVER CARD Riverwoods, Illinois
Database Administrator, Unix Scripting Expert March 2003-August 2003 Conducted full technical assessment of corporate environment, including over 1,800 Korn shell, SQL and PL/SQL scripts;
culled, purged, integrated, and combined into menu-driven database tool selection system Integrated RMAN database backup and recovery systems with EMC Symmetrix physical and logical volume management
system, including mirror break and resilvering Wrote monitoring and alerting systems Worked with EMC engineers to ensure optimal database functionality and continuous uptime on fresh EMC installations
USG CORPORATION Chicago, Illinois
Lead Oracle DBA, Applications DBA Oracle Financials, Backup Unix System Administration Sept 2001-November 2002 Served as sole Oracle resource responsible for full lifecycle development of Oracle Financials 11i project, from initial
installation of database and apps, configuration and family pack application through go-live for complex multi-org (three operating units) and multi-currency implementation
Set up and customized iExpense and iProcurement Performed Unix, Oracle and Apache administration, including cloning, system monitoring, disaster/recovery, troubleshooting,
query optimization and user setup/provisioning (system, database and application) Wrote and administered Big Brother modules Wrote Mainframe ↔ Unix database transfer jobs Composed 140-page manual to enable novice users to perform database and applications administration tasks
divine interVentures Lisle, Illinois
Consultant System and Database Administrator April 2001-September 2001
Installed Sun Solaris; performed system administration tasks Installed Oracle; performed database administration tasks Developed backup and recovery strategy plans for both environments
Lead Commercial Application Specialist
Modified commercial Documentum product written in VB to enable product to be database independent Determined system requirements and wrote installation scripts
MOTOROLA Arlington Heights, Illinois
Consultant October 2000-April 2001 System Administrator
Oversaw Unix system administration (AIX, SUN, HP/UX) Automated systems, database, and applications administration tasks; served as mentor for all scripting projects
Oracle Database Administrator Executed Oracle database administration tasks with emphasis on failover Created auditing procedures
Applications and Tools Database Administrator, Oracle Financials and Manufacturing, i2 Rhythm and Brio
Administered all phases of application administration for Oracle Financials, i2 Rhythm and Brio Responsible for data management, cloning, history uploads, exports, C token changes and user management
LEAPNET/WEBSTREET.COM Chicago, Illinois
Consultant July 2000-October 2000 Oracle and Sybase Database Administrator
Performed basic Oracle and Sybase database administration Wrote, maintained, and optimized stored procedures in both environments
SUN MICROSYSTEMS Northeast Illinois
Consultant September 1998-May 1999 Database Expert
Served as database expert (Oracle and Ingres) for company and acted in that capacity for several clients, including Allstate, Abbott and Northwestern University
Installed and configured hardware and software Performed VMS/Ingres conversion Sun/Oracle Analyzed performance problems regarding hardware/software.
INFORMATION RESOURCES INCORPORATED (IRI) Chicago, Illinois
Consultant February 1998-September 1998 Product Owner, Imaging Database Project
Gathered requirements for application, including sizing for capacity planning and anticipated growth curves Contributed to costs/benefits analysis of development options Recommended hardware, software and storage for system Stabilized existing software environment, including application, database and hardware Developed and maintained VB and VC++ applications Performed database administration in Oracle with sizes up to 17TB Conducted database administration in Sybase, including replication server Analyzed image/data warehousing and Internet delivery
CNA INSURANCE Chicago, Illinois
Consultant February 1997-February 1998 Lead Infrastructure Engineer
Developed bridges to, from, and between third-party products; tested inter-product operability Worked closely with third-party vendors to correct commercial backup and recovery systems Determined Y2k complaince in in-house and third party tools Developed drivers for WolfCreek robotic cartridge systems
Database Administrator
Performed database administration on multiple databases with sizes up to 1.3TB. Wrote systems to gather metrics and perform database/system administration tasks, including tasks such as distributed load
exports and parallel reorgs.
Applications Database Administrator, PeopleSoft, Lawson Performed applications administration, including standardization and optimization, integrating in third-party products. Conducted product evaluations and wrote acquisitions justification documents.
AMERITECH Chicago, Illinois
Consultant December 1996-February 1997 Database Administrator
Architected custom database solutions, including determination of optimal software design and database interfaces, for potential customers.
Performed hands-on management of database administration and data analyst teams. Defined database standards and performed logical/physical database design. Wrote scripts to generate schema downloads, non-DBA truncation capabilities and event monitoring.
INFORMATION RESOURCES, INCORPORATED (IRI) Chicago, Illinois Chicago, Illinois
Consultant August 1995-December 1996 Application Architect
Designed and coded COFFEE and its subsystems including: o Fault-tolerant monitoring system with automatic failover o Interruptible heartbeat management o Remote systems monitoring for system, database, network and application activities across a heterogeneous
environment (Sun, AIX, and HP-UX) o Dynamic remote and local customization including peer-to-peer and mainframe-to-Unix communication o Configurable per-error escalation procedures o Customizable per-error notification via uucp to specifiable beepers and/or display xterms at remote sites o Configurable per-event downtime windows with definable and overriding blackout times o Configurable “flares” to send emergency communications to central error processing mechanisms
Subsequently integrated monitoring scripts into HP Openview and wrote bridges between third party products Database Administrator
Wrote integrated SQL/Korn shell scripts which automated Oracle database administration tasks, including: o Metric gathering o Hot and cold Oracle backups o Archive log file management o Logical and physical design analysis o Network-wide Oracle access management
Determined job descriptions and training requirements for all levels of DBA Department System Administrator
Wrote Korn shell scripts to perform system administration tasks on AIX, HP-UX and SunOS, including: o Unix filesystem backups o Automatic mounting of filesystems o Error checking in specified Unix directories o Filesystem usage and fill rates
Wrote drivers for autoloading tape drive devices
Integrated backup scripts into tape management system MOTOROLA Arlington Heights, Illinois
Lead Database Administrator April 1994-August 1995 Performed all aspects of database administration on large distributed Oracle installation
Worked with Oracle Corporation to modify Oracle libraries and rewrite system compiler to ensure clean link on Motorola R40 platform
Determined logical and physical database designs
Performed requirements definitions, capacity planning, disk slicing and configuration plans, and scheduling for maintenance and enhancements
Determined and implemented migration strategy from v6 to v7
Implemented production data retention strategy
Wrote live/shadow synchronization software
Member of code-review and database (Informix/Oracle) SOP committees
Trained and managed two Oracle DBAs
Company sponsored attendance at Oracle University Parallel Server Administration Courses
FUJISAWA USA Deerfield, Illinois
Consultant June 1991-August 1993 System Manager
Performed VMS System Manager function for new VAX Cluster installation in a lights out operating environment
Determined disaster/recovery plan and backup retention policies
Performed All-in-One administration including heavy customization using the CM and SM facilities
Database Administrator
Performed Ingres and Rdb Database Administration with emphasis on security and throughput Applications Developer
Prioritized module development
Wrote standard user interface and system modules
Wrote randomization algorithm for assigning patients and subjects to therapies
PACIFIC BELL DIRECTORY San Francisco, California
Consultant July 1990-June 1991 Senior DBA/Apps DBA
Performed Oracle database administration on VMS and Unix, including maintenance, tuning, load-balancing, and optimization
Installation, configuration, and administration of Oracle CASE and Financials, customized, tuned and provided support as necessary
Monitored security on database and tools
Wrote scripts, standard methods, documentation and business applications as required
Provided training and direction for four DBAs LOREX PHARMACEUTICAL COMPANY Skokie, Illinois
Consultant April 1988-July 1990 System Manager
Performed user, privilege, and process management tasks
Implemented file and directory level ACLs
Wrote VMS help system for all ICTMS sub-systems
Database Administrator
Performed logical and physical database design
Performed DBA functions, including security operations, with emphasis on performance
Applications Developer Developed Integrated Clinical Trials Management System
Defined and implemented role-based, drug-based, and study-based systems access mechanisms
Wrote systems validation standards, data integrity, and software testing protocols
DATALOGICS (LATER, PART OF ADOBE) Chicago, Illinois
Systems Engineer April 1987-May 1988 Member of Team Developing Looseleaf Publishing System for MILSPEC-A, MILSPEC-B, and Air Force Work Packages with
sole responsibility for the following components: o Offline Editing Management o Configuration of Document Type o Lists of Effected Pages
o Tables of Contents and Indexes o Lists of Illustrations and Tables o Base and Change Level Page Flow
CHRYSLER Warren, Michigan
Consultant Database Applications Developer April 1986-April 1987
Developed Automated Stamping and Assembly System
Developed Tool, Die and Part Costing Estimation System
Member of Team developing automated systems for Automating Assembly Line, including: o Project Control o Tool Control o Press Loading
Developed Interdepartmental Communication System via back-end mailboxing interchanges
UNIVERSITY OF DENVER Denver, Colorado
Programmer/Analyst October 1984-April 1986 Developed and maintained all systems which touched a student’s life, including:
o Demographics o Applications and Admissions o Student Records o Grading and Report Cards o Academic Progress Reporting
o Major Approval o Graduation Eligibility and Notification o Fraternity/Sorority Monitoring o NCAA Eligibility Tracking o Transcripts
Developed and maintained Alumni/Development systems, including: o Alumni Development o Legacies and Endowments o Alumni Directory
o Campaign Management o Quarterly Reports
o Customized Acknowledgements and Communications Generation
PUBLIC SECTOR EXPERIENCE – TECHNICAL AND MANAGERIAL - INTERMITTENT - 1983 – PRESENT
CITY OF NAPERVILLE DEPARTMENT OF PUBLIC UTILITIES Naperville, Illinois
Consultant Oracle Technical Team Manager
July 2017 - Present
Work with end client to define scopes and timelines of projects
Locate, interview, and procure resources; assign appropriate workers to projects based on their strengths
Provide technical direction and mentorship to Team Members UNITED STATES DEPARTMENT OF DEFENSE Arlington, Virginia
Security Clearance: Confidential 1993 Consultant Project Manager
Led multi-corporation development to create “Purple” (DOD-wide) Civilian Employee Management System
Worked with military and civilian members of DOD components, and other government officials and contractors, to define standard user interface for all “Purple” Systems
Answered RFPs and RFIs, developed SOPs and allocated technical resources for all phases of development
Managed timelines and budget associated with the project
Served as public face of the project with military and civilian customers
Travel to US military installations and government facilities as required Lead Security and Test Engineer
Established multi-tiered horizontal and vertical security and access control paradigms
Developed testing methodology with consistent inputs and expected outputs of all systems Lead Technical Architect
Assisted in the determination of hardware and software requirements for Unix servers and Windows clients for approximately 800 military bases worldwide
Negotiated agreements to acquire third party commercial software, including Oracle and Cognos
Worked with key military and civilian personnel to define system design and functional requirements
Wrote substantial DOD documentation consistent with HCI (Human/Computer Interface) requirements
Managed Systems, Network, and Database Administration Teams Tech Lead
Wrote standard user interface, integrated applications and enforced standard look-and-feel for client-server system
Responsible for the creation and library-level manipulation of icons used throughout the applications
Reviewed every line of code developed by all team members for internal consistency, in-line documentation, and correct usage to ensure a bug-free environment and ease of future maintenance
Provided mentorship, coaching, training and guidance to Team Members across disciplines
Performed demos for military and governmental officials
Formal user training for military and civilian users
UNITED STATES DEPARTMENT OF INTERIOR Lakewood, Colorado
Position of Public Trust – High Risk – Public Safety 1983 – 1984 Consultant Analyst/Programmer
Mathematical applications to geoscientific engineering for Earthworks projects
Vertical linkage and omissions calculations for dam building projects specific to the State of Utah
PROFESSORIAL EXPERIENCE 2016 - PRESENT
CITY COLLEGES OF CHICAGO Chicago, Illinois
Adjunct Professor, System-Wide Database Subject Matter Expert January 2016 - Present o Introduction to Microcomputers o Introduction to Database Design for OLTP and OLAP
Development of course for initial offering , including: Oracle and Erwin software installation; schema creation, privileges, data dictionary; logical and physical design; ETL; SQL and PL/SQL
PRODUCED WORK FOR APPROVED DRUGS
Prograf (Tacrolimus); Ambien (Zolpidem); Kerledex (Betaxolol); Kerlone (Betaxolol HCl); Alpidem
REFERENCES GLADLY FURNISHED UPON REQUEST