Larry W Hicks Email & Phone Number

Greater Philadelphia Area

Assignment at American Board of Internal Medicine (ABIM)Analyze data and production problems involving Oracle databases or code.Develop PL/SQL code for projects as needed.Maintain existing PL/SQL code, as neededReview performance of applications and code that utilizes the Oracle databases.

Greater Philadelphia Area

On contract through Insight GlobalETL development primarily using Oracle tools (SQL, PL/SQL) in an Agile Kanban team.. Tuned poor performing SQL queries.Developed plan and code to move unpartitioned terabyte tables into comparable tables with monthly partition to allow better data management and improve performance for daily data loads and extracts.

Greater Philadelphia Area

Data architect and analystData requirements gathering; source data analysis and documentation, designing data solutions and Erwin data models.Database implementation support and qualtiy assurance.Oracle PL/SQL and SQL code reviews, performance recommendations.

Greater Philadelphia Area

As a contractor through Rose International,Led business unit IT team in investigating and restoring multiple years of historical credit card history (both MBNA and BAC) for use in risk management models. We successfully restored or recovered over 6 years of data from several data sources from VSAM to COBOL extracts to DB2.

Greater Philadelphia Area

Provided consulting support to YellowBook for the automated QA testing environment -- architecting the QA test environment to support overnight data refreshes, including subsetting a 5Tb database to under .5 Tb in the QA environment.

Greater Philadelphia Area

As contractor through Judge GroupDeveloped data mart for a new external data feed to meet client needs. Delivered the required data in under 2 months, which earned SDI a $100+K bonus from the client.Standardized over 20+ procedures and functions commonly used within SDI and developed a package of these procedures and functions to improve efficiency and maintanence of the package and the many programs that used this code.

Greater Philadelphia Area

On assignment through Tek Systems.Investigated current product tables throughout Health Care Systems (HCS). Developed process and data flows for product data through the 3 main Health Care Systems. Identified data inconsistencies and process changes needed. Developed project plan and timeline for the effort. Designed new product master tables and processes for feed from SAP. Developed SQL and PL/SQL scripts/packages to populate and maintain the new HCS Product Master. Developed SQL… Show more On assignment through Tek Systems.Investigated current product tables throughout Health Care Systems (HCS). Developed process and data flows for product data through the 3 main Health Care Systems. Identified data inconsistencies and process changes needed. Developed project plan and timeline for the effort. Designed new product master tables and processes for feed from SAP. Developed SQL and PL/SQL scripts/packages to populate and maintain the new HCS Product Master. Developed SQL and modified PL/SQL package to move the 1st system to using the new master. Developed unit test plans for new and modified code and performed unit tests. Provided Oracle tuning and consulting, as needed. Show less

Greater Philadelphia Area

Managed team of 12-16 Oracle and SQL Servers DBAs and SAP BASIS support staff that supported several group in AIG's Personal Lines Division.Made my group one of the strongest Oracle organizations within AIG.Created and staffed the SQL Server team in response to new need to support over 100 SQL Server databases.Implemented a number of policies, processes and standards to improve current database and SAP environments and support and to provide guidelines for on-going… Show more Managed team of 12-16 Oracle and SQL Servers DBAs and SAP BASIS support staff that supported several group in AIG's Personal Lines Division.Made my group one of the strongest Oracle organizations within AIG.Created and staffed the SQL Server team in response to new need to support over 100 SQL Server databases.Implemented a number of policies, processes and standards to improve current database and SAP environments and support and to provide guidelines for on-going improvements.Set direction for database environments including: Architecture: software versions and tools, backup strategies, etc. Security: access, data protection, auditing Support: SLAs, service profiles, customer communications Planning: Strategic and tactical Standards: Processes, policies, proceduresAlong with senior members of my staff, served as focal point for coordinating application/databases changes and implementations. Show less

Greater Philadelphia Area

As contractor through Idea IntegrationLed group of data analyst and PL/SQL programmers. Were responsible for analyzing data issues with the Centers for Medicare and Medicaid (CMS) Part D prescription plans. After determing the problems, we communicated issues to CMS, and where possible developed work arounds to get the Medicare members covered in prescription plans.Developed and documented processes and procedures to standardize and streamline the analysis and reconciliation… Show more As contractor through Idea IntegrationLed group of data analyst and PL/SQL programmers. Were responsible for analyzing data issues with the Centers for Medicare and Medicaid (CMS) Part D prescription plans. After determing the problems, we communicated issues to CMS, and where possible developed work arounds to get the Medicare members covered in prescription plans.Developed and documented processes and procedures to standardize and streamline the analysis and reconciliation activities. Identified and coordinated the automation of as many processes as possible. Show less

Raleigh-Durham, North Carolina Area

- Wrote and published computer management books. - Maintained one,two and three day seminars on the Concepts of Site and Systems Management.- Presented seminars on the Concepts of Site and Systems Management for L.W. Hicks Associates, Digital Equipment Corporation (DEC) and Digital Equipment Computer Users Society (DECUS). (Over 1400 computer managers attended these seminars.)- Provided management and computer consulting for small to medium business clients.

Greater Philadelphia Area

As a contractor through Prestige StaffingManaged the IBM Oracle/DB2 DBAs at the Campbell client site.Established policies and procedures for the DBA functions, so that IBM standards and client requirements were met.Ensured that DBA efforts were within the current Services Responsibility Matrix, i.e. statement of work.Coordinated with the customer Database Architect.

Greater Philadelphia Area

As contractor through Hudson Global Resource-Was technical PM(TPM)/architect for 2 reporting projects and several smaller projects for Consumer Finance (CF) and Business Lending (BL). Projects were HP-UX/Oracle based.-Coordinated efforts of 5-9 DBAs/data modelers.-Was TPM for new Business Lending System.-Installed first Oracle 8i and 9i instances.-Developed/maintained project plans/budgets for projects.-Was TPM for migration of 4 CF databases from NT/Oracle 8.0 to… Show more As contractor through Hudson Global Resource-Was technical PM(TPM)/architect for 2 reporting projects and several smaller projects for Consumer Finance (CF) and Business Lending (BL). Projects were HP-UX/Oracle based.-Coordinated efforts of 5-9 DBAs/data modelers.-Was TPM for new Business Lending System.-Installed first Oracle 8i and 9i instances.-Developed/maintained project plans/budgets for projects.-Was TPM for migration of 4 CF databases from NT/Oracle 8.0 to HP-UX/Oracle 8i. -Trained several new DBAs on DBA tasks.-Assisted in creating Erwin data models of existing CF systems.-Led upgrade from Financials 10.7/Oracle 8.0/HP UX 10.20 to Apps 11.5.3/Oracle 8i/HP UX 11.0.-Trained new DBAs on the 11i upgrade process.-Investigated technology stack changes for V11.5.1, 11.5.2, and 11.5.3.-With Oracle consultant, developed 11i cloning procedures. Show less

Greater Philadelphia Area

As contractor through Technical Directions, Inc.-Provided systems analysis, testing, project management, ORACLE database expertise, and VMS expertise on Zeneca AG's Electronic Commerce (EC)/data warehouse (DW) systems. -Project lead for ORACLE based EDI applications and Oracle to SAP interfaces.-Supported the EC and Customer Service users for the EDI and Bulk Billing subsystems.-Represented the EC group on Y2K Integration Test Team.-Redesigned the Bulk Billing system to… Show more As contractor through Technical Directions, Inc.-Provided systems analysis, testing, project management, ORACLE database expertise, and VMS expertise on Zeneca AG's Electronic Commerce (EC)/data warehouse (DW) systems. -Project lead for ORACLE based EDI applications and Oracle to SAP interfaces.-Supported the EC and Customer Service users for the EDI and Bulk Billing subsystems.-Represented the EC group on Y2K Integration Test Team.-Redesigned the Bulk Billing system to incorporate new business needs - increased automatic billing 200% and improved cash flow.-Provided programming support for PL/SQL and PRO/C programs.-Maintained several Data Warehouse applications.-Evaluated/tuned several long-running DW applications. Show less

Raleigh-Durham, North Carolina Area

-Provided system analysis and testing, system architect, project management and database expertise on GTE's Integrated Network Management System (INMS) project. (A SEI level II compliant project.)-Was project lead/SW architect for one of the development teams. -Developed DB procedures/triggers for one of the modules..-Provided architectural support to team members.-Trained/supported 2 new ORACLE DBAs.-Developed project plans for design and coding phases. -Performed… Show more -Provided system analysis and testing, system architect, project management and database expertise on GTE's Integrated Network Management System (INMS) project. (A SEI level II compliant project.)-Was project lead/SW architect for one of the development teams. -Developed DB procedures/triggers for one of the modules..-Provided architectural support to team members.-Trained/supported 2 new ORACLE DBAs.-Developed project plans for design and coding phases. -Performed design and code reviews for over 100 units of code.-Led team that developed PL/SQL coding/documentation standards.-Developed justification, proposal, and plan for upgrade of ORACLE V6 to ORACLE V7.1.-Prepared and presented to upper management and the customer on the ORACLE upgrade and INMS V 2.5 features. Show less

Raleigh-Durham, North Carolina Area

As contractor for TECH-AID:-Provided system analysis and testing, project management and ORACLE database expertise on GTE's Integrated Network Management System (INMS) project. -Developed detailed design for several forms and three sets of network routing routines. -Participated in the Joint Analysis and Design (JAD) process for Version 2.4.-Coordinated testing activities in the System integration Test Facility (SITF).-Coordinated government witnessed tests of the Version… Show more As contractor for TECH-AID:-Provided system analysis and testing, project management and ORACLE database expertise on GTE's Integrated Network Management System (INMS) project. -Developed detailed design for several forms and three sets of network routing routines. -Participated in the Joint Analysis and Design (JAD) process for Version 2.4.-Coordinated testing activities in the System integration Test Facility (SITF).-Coordinated government witnessed tests of the Version 2.3 INMS System Management subsystem. -Trained new Oracle DBA on ORACLE database size and performance analysis.-Performed CSCI, integration and government witnessed tests of the Version 2.3.-Evaluated ORACLE sizing problems discovered during testing. Recommended changes to fix issues. Show less

Developed and taught Computer Management courses for Digital Ed. Services.Consulted with Digital's Conversion services group in Colorado Springs. Converted DEC-10/20 applications to VAX.

Raleigh-Durham, North Carolina Area

As a contractor for DataMasters:-Coordinated software testing activities for GOLD software system. Glaxo's Clinical Trials system. -Coordinated implementation of software and database upgrades and installs to the many testing, training and production environments.-Coordinated implementation and testing of the upgrades and installs to these environments.-Performed Oracle DBA and Change Control roles for the test environment.-Trained/supervised other testers. (Test team… Show more As a contractor for DataMasters:-Coordinated software testing activities for GOLD software system. Glaxo's Clinical Trials system. -Coordinated implementation of software and database upgrades and installs to the many testing, training and production environments.-Coordinated implementation and testing of the upgrades and installs to these environments.-Performed Oracle DBA and Change Control roles for the test environment.-Trained/supervised other testers. (Test team varied from 1 to 7 people.)-Developed standard unit/integration test procedure for GOLD projects.-In conjunction with Digital consultant, executed over 70 performance test runs between April and July 1991.-Developed software/system test procedures. Show less

Raleigh-Durham, North Carolina Area

- Was a consultant assigned to GTE Government Systems. (See that position description for details.) - After that assignment, set up and was Marketing Director for Turn-Key's Raleigh office. - Consulted part-time for a couple of clients in the area, including Oxford University Press.

Raleigh-Durham, North Carolina Area

As a contractor for Turn-Key Solutions:- Provided ORACLE database, VMS, FORTRAN and project management expertise to GTE Government Systems.- Managed an eight-month phase of the software development cycle of the Phase I Command and Control system, Integrated Network Management System (INMS). (Project team included three to five consultants and two employees.)

Greensboro/Winston-Salem, North Carolina Area

- Provided management consulting to clients, including site design, relocation planning, hardware/software evaluation, and system tuning (DECsystem-20 and VAX).- Designed, developed and implemented database applications. Performed software evaluations, security audits, TOPS-20 system tuning and capacity planning for clients.- Taught seminars on system management, database techniques, and system security for several Fortune 100 companies.- Reviewed the design and implementation of… Show more - Provided management consulting to clients, including site design, relocation planning, hardware/software evaluation, and system tuning (DECsystem-20 and VAX).- Designed, developed and implemented database applications. Performed software evaluations, security audits, TOPS-20 system tuning and capacity planning for clients.- Taught seminars on system management, database techniques, and system security for several Fortune 100 companies.- Reviewed the design and implementation of System 1022 and 1032 database systems to improve efficiency and performance (DECsystems and VAX) for clients- Clients included Citibank, Miller, Mason and Dickenson. Chase Manhattan Bank, Fordham University, Digital Equipment Corporation, Software House (Cambridge, MA), Grinnell Reinsurance, Sweet Briar College, 3-M, Price Waterhouse, National Information Systems, Inc. and others. Show less

Greensboro/Winston-Salem, North Carolina Area

M.B.A., Marketing And Economics

Activities and Societies: With work, family and school, there was no time for other school activities. Was part of the first off-site.

Biochemistry

B.B.A., Management And Economics

Activities and Societies: Alpha Phi Omega (member of Kappa Theta Chapter) As student assistant, helped set up the Babcock School.

A.S., Mathematics

Activities and Societies: Founder of the Tau Phi Chapter of Alpha Phi Omega