Henry Cerro Email & Phone Number

Anne Arundel County, Maryland, United States

Supporting data science efforts with a variety of tools and languages, such as Apache NiFi, Jupyter, Python and Regex

The SI is the subject matter expert in applications and systems which have been deployedto the production environment, and is responsible for tasks related to hardware andsoftware infrastructure in the client's Development, Test, and Integration Facility(DTIF). Available to the Configuration Control Board for questions related to systemmodifications. Point of contact for various system components including, but not limited to LDAP,Siteminder, Bluecoat, Veritas or… Show more The SI is the subject matter expert in applications and systems which have been deployedto the production environment, and is responsible for tasks related to hardware andsoftware infrastructure in the client's Development, Test, and Integration Facility(DTIF). Available to the Configuration Control Board for questions related to systemmodifications. Point of contact for various system components including, but not limited to LDAP,Siteminder, Bluecoat, Veritas or Solaris/Unix. The SI works with the development team to manage all scheduled and unscheduledinfrastructure changes, code modifications, LDAP schema additions, and Blue Coat changes.Coordinates and monitors changes to system configurations, software installs, and data. Primary point of contact for issues that have been escalated from the systems operationscenter (SOC). Works with the SOC to address, manage, and resolve operational incidents. Oncall 24/7.Primary deployment engineer; in concert with the Development team, deploys new buildsfrom the development system to integration. Writes install documents for the SOC engineersto follow for deployment to the test and production environments.Attends the daily Operations Center status meetings, and manages issues that involve theoperational system. Primary point of contact to the client's Project Manager and her team,the Customer Support Center, and the content managers. Responsible for coordinating thecommunication of these issues and managing their resolution.Principle engineer for loading large content databases into the online operationalsystem. Receives updates from the various bureaus and engineers their preparation andupload to the production system. Show less

Primary point of contact between the client***s Project Manager and her staff. Attendsvarious weekly meetings: * Daily Operations Center status meeting * Weekly Engineering Review Board (ERB) meeting. * Weekly External Content Provider (ECP) Workgroup meeting. Coordinates the communication of any issues raised at these meetings to all relevantparties (management and staff). Manages the escalation and resolution of problems andconcerns… Show more Primary point of contact between the client***s Project Manager and her staff. Attendsvarious weekly meetings: * Daily Operations Center status meeting * Weekly Engineering Review Board (ERB) meeting. * Weekly External Content Provider (ECP) Workgroup meeting. Coordinates the communication of any issues raised at these meetings to all relevantparties (management and staff). Manages the escalation and resolution of problems andconcerns. Troubleshoots any issues related to system operations and provides timely status updates.Acts as the client's liaison to the Customer Center, the operations center (OC), and thecontent managers for any technical issues regarding system operations. Visits each officedaily to address any outstanding issues or concerns.Responds to ad hoc tasking from Project Manager, Deputy, and Co-Project Manager. Atvarious receives tasking from the Project Manager or her immediate team members.Principle engineer responsible for loading large databases into client applicationManages requests from customers for data. Works with the Customer Center and SOC toassemble, process and transmit the data to the requestor.Produces regional blog quarterly report. Works with the OC and the developers to producethe report.Collects and distributes monthly geography metrics.Assists with system verification and sends out status to the Project Manager and herteam. Show less

Role Description: STP Portfolio Modernization Lead Reporting to the System Architect, is responsible for managing the transformation ofentities into the next generation data center architecture.Selects and maintains technical solutions/tools as necessary for delivering Data Centercapabilities. Creates and manages the improvement of standard procedures utilized by the team todeliver Data Center Service capabilities. Manages relationships with each… Show more Role Description: STP Portfolio Modernization Lead Reporting to the System Architect, is responsible for managing the transformation ofentities into the next generation data center architecture.Selects and maintains technical solutions/tools as necessary for delivering Data Centercapabilities. Creates and manages the improvement of standard procedures utilized by the team todeliver Data Center Service capabilities. Manages relationships with each project team to enable successful issue escalation andresolution. Ensures that excellent customer service is being provided to project teams on aconsistent basis. Working closely with the Infrastructure and Shared Services Lead, manages Data Centerbudget management and maintenance, identifies and delivers new Data Center capabilities.Issues escalation/resolution as necessary. Assists with all initiatives related to delivering Data Center Services. Developsdocumentation and presentations on Data Center capabilities. Plans and manages the work ofinformation systems project teams familiar with intelligence agencies' operations. Leads clients through streamlining, reengineering and transforming business processes.Ensures testing and piloting results meet application performance goals. Aligns theapplication with changing business needs. Show less

Contracted to the client***s public-facing Portal development project; Oracle, Vignette (VCM & Portal), WebLogic, iPlanet, Apache and Solaris systemsadministrator for both the production and development environments. Divided time betweenthe Reston development facility and the Bethesda server facilities. Responsibilities included maintenance, analysis and resolution of issues related to theAccenture-managed systems, applications and hardware. Implemented a security design… Show more Contracted to the client***s public-facing Portal development project; Oracle, Vignette (VCM & Portal), WebLogic, iPlanet, Apache and Solaris systemsadministrator for both the production and development environments. Divided time betweenthe Reston development facility and the Bethesda server facilities. Responsibilities included maintenance, analysis and resolution of issues related to theAccenture-managed systems, applications and hardware. Implemented a security design forthe development servers that met DOD standards. Provided guidance on configurationmanagement, including the installation, conversion, and management of an updatedversioning system (Subversion) to replace the Reston team's CVS system. Worked side-by-side with the prime contractors in the WebOps server room in Bethesda.Installed and configured a ticketing system and a Wiki site for the Reston team.Primary technical point of contact to the Accenture Reston and client***s Bethesdafacility. Show less

Role Description Contracted to the client***s classified portal development project; Worked within a diverse team of systems and development professionals to provide serveradministration, configuration management, and software development expertise.Primary responsibilities involved administering, monitoring, and troubleshooting thedevelopment team's SIPRNet and JWICS Solaris servers. Backed up the Oracle databases andmonitored the Oracle and server logs. Monitored and… Show more Role Description Contracted to the client***s classified portal development project; Worked within a diverse team of systems and development professionals to provide serveradministration, configuration management, and software development expertise.Primary responsibilities involved administering, monitoring, and troubleshooting thedevelopment team's SIPRNet and JWICS Solaris servers. Backed up the Oracle databases andmonitored the Oracle and server logs. Monitored and archived the Subversion (versioncontrol system) repository. Developed, tested, and implemented shell scripts/cron jobs tomonitor, backup and archive server audit, apache, WebLogic, and Oracle log files.Worked with systems team on site's Information Assurance re-Certification.Assisted in the testing and delivery of updates to the SIPRNet and JWICS productionPortal systems.Downloaded, scanned, installed and monitored patches and upgrades to the developmentsystem applications. Worked with the systems team to upgrade Sun servers to Solaris 9. Show less

Role Description Worked in Concerto project database administrator team through the end of this Accentureproject. Duties included; Responsible for the installation, maintenance, troubleshooting,upgrading, migration and problem resolution of PeopleSoft Portal, HR, EPM, Security,eRecruit, and ELM applications for Concerto's development, testing, and production systems(PeopleTools versions 8.19, 8.43, 8.44, and 8.46). Systems run on AIX and Windows 2000servers, with… Show more Role Description Worked in Concerto project database administrator team through the end of this Accentureproject. Duties included; Responsible for the installation, maintenance, troubleshooting,upgrading, migration and problem resolution of PeopleSoft Portal, HR, EPM, Security,eRecruit, and ELM applications for Concerto's development, testing, and production systems(PeopleTools versions 8.19, 8.43, 8.44, and 8.46). Systems run on AIX and Windows 2000servers, with databases on Oracle and DB2. Managed all areas of PeopleSoft configurationmanagement.Stat! Administrator: Responsible for the development, configuration, and staff trainingof the Stat! applications management system (Quest Software, www.quest.com). Developedthree Service Domains to manage Concerto's Tier-3 applications management system, whichreplaced their manual systems. Provided Stat! technical support to NSA FinancialManagement team. Show less

Responsible for the maintenance, migration, and problem resolutionof Concerto's AIX, Windows 2000, and UNIX systems. Worked with NSA systems engineeringarea, and with rest of the Concerto DBA team, was primary contact between systemsengineering and development/test teams. Managed server configuration management andsecurity for Concerto.; Role Description Reengineering project for the US Department of State. The Integrated Logistics ManagementSystem (ILMS) consolidates… Show more Responsible for the maintenance, migration, and problem resolutionof Concerto's AIX, Windows 2000, and UNIX systems. Worked with NSA systems engineeringarea, and with rest of the Concerto DBA team, was primary contact between systemsengineering and development/test teams. Managed server configuration management andsecurity for Concerto.; Role Description Reengineering project for the US Department of State. The Integrated Logistics ManagementSystem (ILMS) consolidates over 20 legacy systems into a single Portal-based application. Primary responsibilities: Manage version control system and processes for 100+ sizeproject team. Install, configure, train and maintain "Stat!" version control tool (QuestSoftware, Inc.). Configure "Stat!" tool for all PeopleSoft and generic applications usedin project. Install, configure, upgrade and provide technical support for PeopleSoft Portal, EPM,CRM, and Financials systems. Install, configure, troubleshoot, upgrade and provide technical support for MicrosoftWindows 2000 Server. Upgraded State Department servers from Windows NT to Windows 2000.Act as project team liaison to Accenture's CMMI management group. Show less

Project to assist the Kansas Department of Human Resources (KDHR) with the pilotimplementation, operations management and support of an n-tier, internet-based WorkforceDevelopment System ("Kansas Job Link"; using aderivative of an existing application implemented for the State of Ohio. Acted as primary KDHR point of contact for legacy data conversion, data integrity andcross-system synchronization. Managed the design, development and execution of a data… Show more Project to assist the Kansas Department of Human Resources (KDHR) with the pilotimplementation, operations management and support of an n-tier, internet-based WorkforceDevelopment System ("Kansas Job Link"; using aderivative of an existing application implemented for the State of Ohio. Acted as primary KDHR point of contact for legacy data conversion, data integrity andcross-system synchronization. Managed the design, development and execution of a data conversion system to populate theKJL SQL Server 7.0 database with KDHR's legacy mainframe dataCreated data integrity protections (database CHECK CONSTRAINTS) that guard against theload of invalid legacy dataMaintained a series of legacy-to-KJL interfaces designed and custom built to Kansas-specific Workforce Development System (WDS) specificationsProduced weekly database conversion and interface status reportsProject team technical support for database administration, systems analysis, SQLefficiencies, and ad-hoc Show less

Worked with the Information Systems Branch Chief and one Federal Programmer/Analyst todesign, develop and implement functional and data communication links between the legacyand re-engineered PMS. Project involved:- Functional analysis of the legacy system processes to determine their ability tosupport the re-engineered system (this was needed because IV&V revealed that only aportion of the new system was capable of supporting full functionality in time for phaseone… Show more Worked with the Information Systems Branch Chief and one Federal Programmer/Analyst todesign, develop and implement functional and data communication links between the legacyand re-engineered PMS. Project involved:- Functional analysis of the legacy system processes to determine their ability tosupport the re-engineered system (this was needed because IV&V revealed that only aportion of the new system was capable of supporting full functionality in time for phaseone of system implementation);- Development of a complete data map between the legacy COBOL/IMS database system and there-engineered Oracle-based PL/SQL UNIX system;- Research into the capabilities of the commercial file transfer product (CONNECT:Direct)offered by the DHHS Data Center as the data exchange medium;- Design and development of CONNECT:Direct modules, UNIX Shell Scripts, MVS JCL, andCOBOL modules to manage the bridge processes between the UNIX and the MVS systems;- Modification of the legacy modules to support the new Oracle-based data sources;- Test and improvement of the design of 40 UNIX Shell Scripts and CONNECT:Direct modules;- Execution of a Government Acceptance Test (GAT) and the implementation of the bridgecomponents into production Show less

Analyzed, developed and/or customized several Microsoft Access 97/VBA databases systems.Designed and implemented a database to manage the development and implementation of theUNIX-to-mainframe bridge components described above.Developed an Access/VBA application to manage the coordination of testers,specifications, inputs, activities, and expected results in support of the above-mentionedGAT. Merged two separate Access applications into a single system in… Show more Analyzed, developed and/or customized several Microsoft Access 97/VBA databases systems.Designed and implemented a database to manage the development and implementation of theUNIX-to-mainframe bridge components described above.Developed an Access/VBA application to manage the coordination of testers,specifications, inputs, activities, and expected results in support of the above-mentionedGAT. Merged two separate Access applications into a single system in support of Year 2000, End-to-end, and GAT activities. Original database was designed solely for risk analysis; re-designed to add issue-tracking capabilities. Task involved:- Reverse-engineering of the original database to determine the optimal locations for thenew tables, queries, forms, definitions, and code- Creation of the new database objects to enable issue tracking- Synchronization, testing and customization of the database Show less

Multi-faceted project for the U.S. Department of Health and Human Services (HHS) ProgramSupport Center (PSC), Division of Payment Management (DPM). Determine the readiness of the Re-engineered Payment Management System (PMS), provideguidance to the development contractor, and assist with the analysis and development ofinterfaces between the UNIX re-engineered system and the legacy mainframe/MVS system.Duties to include: - Analyzing, designing, and developing bridge… Show more Multi-faceted project for the U.S. Department of Health and Human Services (HHS) ProgramSupport Center (PSC), Division of Payment Management (DPM). Determine the readiness of the Re-engineered Payment Management System (PMS), provideguidance to the development contractor, and assist with the analysis and development ofinterfaces between the UNIX re-engineered system and the legacy mainframe/MVS system.Duties to include: - Analyzing, designing, and developing bridge software processes between UNIX-basedreengineered Payment Management System and mainframe-based Legacy system- Analyzing and/or synthesizing re-engineered and legacy system, code, and programspecifications- Reviewing the development contractor's plans for completeness- Reviewing the functional risk level assessment- Reviewing the development contractor's test scenarios, test cases, and test data forreasonability and completeness- Performing the tests & analyzing the test results- Preparing the test analysis report, to include an assessment of the success of thetest. Show less

Responsible for the design, development, execution and documentation of a Y2K testagainst the legacy system. Task involved:- Analysis of the legacy PMS' screens, reports, file interfaces, and documentation todetermine its Y2K exposure- Development of a methodology to simulate the execution of the batch system for each ofthe critical Y2K test simulation dates- Creation and management of a plan to execute, monitor, and capture statistics from thebatch processes in… Show more Responsible for the design, development, execution and documentation of a Y2K testagainst the legacy system. Task involved:- Analysis of the legacy PMS' screens, reports, file interfaces, and documentation todetermine its Y2K exposure- Development of a methodology to simulate the execution of the batch system for each ofthe critical Y2K test simulation dates- Creation and management of a plan to execute, monitor, and capture statistics from thebatch processes in synchronization with the overall test project plan- Development and execution of on-line tests of the legacy PMS Disbursement processingscreens. Show less

Project: Administration for Children and Families (ACF) Project; Project to design and create Y2K risk analysis and contingency plans for mission-criticalsystems used by The Administration for Children and Families (ACF) and the Federal Officeof Child Support Enforcement (OCSE), within HHS. Systems analyzed included: Grants Administration Tracking and Evaluation System (GATES),Adoption and Foster Care Analysis and Reporting System (AFCARS), Runaway and HomelessYouth… Show more Project: Administration for Children and Families (ACF) Project; Project to design and create Y2K risk analysis and contingency plans for mission-criticalsystems used by The Administration for Children and Families (ACF) and the Federal Officeof Child Support Enforcement (OCSE), within HHS. Systems analyzed included: Grants Administration Tracking and Evaluation System (GATES),Adoption and Foster Care Analysis and Reporting System (AFCARS), Runaway and HomelessYouth Program Information System (RHYMIS), Child Support Enforcement Network (CSENet),Federal Parent Locator Service (FPLS), Tax Refund Offset System (TROS), and EnumerationVerification System (EVS). Show less

Responsible for synthesizing information from ACF's and OCSE's various mission-criticalsystems, and developing specifications for the development of Risk Analysis documents andContingency Planning specifications. Task involved:- Conducting interviews with management and technical personnel to determine the system'scritical processes- Proposing candidate areas of risk and potential contingencies to the client andcoordinating the evolution of the documents with feedback… Show more Responsible for synthesizing information from ACF's and OCSE's various mission-criticalsystems, and developing specifications for the development of Risk Analysis documents andContingency Planning specifications. Task involved:- Conducting interviews with management and technical personnel to determine the system'scritical processes- Proposing candidate areas of risk and potential contingencies to the client andcoordinating the evolution of the documents with feedback from management and subjectmatter experts- Finalizing the agreed-upon specifications for the various systems- Development of cross-referenced and fully annotated Risk Analysis and ContingencyPlanning documents for each of the systems; Role Description Independent verification and validation (IV&V) project to perform and/or assist U.S.Department of Education personnel to evaluate Year 2000 (Y2K) compliance tests. IV&Vduties involved:- Reviewing the contractor's plans for completeness- Reviewing the functional risk level assessment- Reviewing the contractor's test scenarios, test cases, and test data for reasonabilityand completeness- Performing the test- Analyzing the test results- Preparing the test analysis report, to include an assessment of the success of thetest.Independent Verification & Validation (IV&V) AnalystResponsible for the IV&V analysis of the Y2K test planning, testing and documentation ofthree of the Department's contracted systems: Multiple Data Entry, Central ProcessingSystem, and Title IV Wide-Area Network. Show less

Role Description Development of a LAN-based workload analysis system for the National Cancer Institute,Division of Extracurricular Activities, Special Review, Referral, and Resources Branch(SRRRB).; Work consisted of two components. The first, to be completed by a subcontractor, was areview and analysis of SRRRB's current processes and their managerial and technologicalcontexts, with process improvement recommendations. The second component, to be completedby primary… Show more Role Description Development of a LAN-based workload analysis system for the National Cancer Institute,Division of Extracurricular Activities, Special Review, Referral, and Resources Branch(SRRRB).; Work consisted of two components. The first, to be completed by a subcontractor, was areview and analysis of SRRRB's current processes and their managerial and technologicalcontexts, with process improvement recommendations. The second component, to be completedby primary contractor, consisted of the development and implementation of a manipulablesoftware model of SRRRB's processes to aid in planning and scheduling its work. The particular process modeling application software used was "Process 98" by ScitorCorporation.Led project team in the analysis, development, installation, and training of the systemand a report of its findings. Primary point of contact for the client. Led analysis sessions with the COTR andprofessional staff in the development and refinement of process models for SRRRB'sContracts and Grants systems. Entered, tested, and manipulated application software based on knowledge gained fromanalysis sessions. Conducted overview sessions for SRRRB technical support personnel.Project team consisted of the project leader, a network analyst, and a technicalintegration / business process reengineering specialist. Show less

Role Description Assist in the development, testing, and implementation of a client server (LAN tomainframe) system for a utility services company.

Project Leader for Individual Case Management on-line system reengineering effort.Managed team consisting of a Data Administrator, DBA, Quality Assurance Analyst, and fourProgrammers. Directed analysis and testing of IBM mainframe DB2 and VSAM databases, andprepared projection and recommendation reports for users, DBAs and management. Workedclosely with end-users on the design of the GUI and the database. Rewrote user manual forreengineered system. Project was completed on… Show more Project Leader for Individual Case Management on-line system reengineering effort.Managed team consisting of a Data Administrator, DBA, Quality Assurance Analyst, and fourProgrammers. Directed analysis and testing of IBM mainframe DB2 and VSAM databases, andprepared projection and recommendation reports for users, DBAs and management. Workedclosely with end-users on the design of the GUI and the database. Rewrote user manual forreengineered system. Project was completed on time and under budget, despite an extremelytight schedule and the loss of the DBA toward the end of the project. Project Leader for change to the on-line Inventory Reporting system. This change allowedthe processing of Point of Service claims data. Team consisted of two Programmers and a Show less

Led a team of company and client employees. The work was distributed among threelocations; The Seattle team wason-site at the client's office, and consisted of a Joint Application Design (JAD) group ofIntermetrics analysts and client staff. They were responsible for data gathering andproduction of the requirement document, as well as on-line (screen) design work. The Bellevue Intermetrics team was formed to develop the on-line processing programs thatsupported the… Show more Led a team of company and client employees. The work was distributed among threelocations; The Seattle team wason-site at the client's office, and consisted of a Joint Application Design (JAD) group ofIntermetrics analysts and client staff. They were responsible for data gathering andproduction of the requirement document, as well as on-line (screen) design work. The Bellevue Intermetrics team was formed to develop the on-line processing programs thatsupported the user screens. The McLean team designed and developed the batch processing systems. Interviewed andhired several key staff, supervised the work at all three sites, advised personnel onclient policy requirements, and monitored the progress of all teams. Developed an MS Excel spreadsheet to track the metrics for the work being done, andtracked all tasks on an MS Project file.Number of Employees Supervised:Professional: 16Non-Professional: 0 Company: Blue Cross and Blue Shield of the National Capital Area (Now CareFirst BCBS) Project: Federal Employee Program Project; Role Description Claims processing system for Federal Employee Program. Mainframe-based system handlesclaims transmissions from 72 Blue Cross and Blue Shield Plans across the United States andEurope. Show less

Assisted managers in departmental reorganization. Scheduled and conducted interviews withover twenty-five programmer applicants, and made hiring recommendations to managers.Established working and administrative procedures and policies. Directed, planned andcoordinated data processing activities with a team of five programmers. Managed researchand development activities that allowed Anti-Fraud team to evaluate a new product. Established a process to improve the… Show more Assisted managers in departmental reorganization. Scheduled and conducted interviews withover twenty-five programmer applicants, and made hiring recommendations to managers.Established working and administrative procedures and policies. Directed, planned andcoordinated data processing activities with a team of five programmers. Managed researchand development activities that allowed Anti-Fraud team to evaluate a new product. Established a process to improve the management of incoming ad-hoc user requests, and thetraining of new programmers. Reported weekly status of ad-hoc requests to management andstaff. Solicited recommendations from programmers and testers on ways to improve thedepartmental systems, and prepared weekly status reports for management, other teamleaders, and DBAs.Number of Employees Supervised:Professional: 5Non-Professional: 0 Show less

Organized and maintained security system for test DB2 databases. Calculated storage usageand assessed annual DASD requirements for applications programming section. Reported onannual DASD usage statistics to management and programming staff. Supervised thereservation and usage of test DASD for programming area.Managed project, which assessed tape storage utilization. This project evaluated the end-users' allocation of tape files in light of tape retention policies and… Show more Organized and maintained security system for test DB2 databases. Calculated storage usageand assessed annual DASD requirements for applications programming section. Reported onannual DASD usage statistics to management and programming staff. Supervised thereservation and usage of test DASD for programming area.Managed project, which assessed tape storage utilization. This project evaluated the end-users' allocation of tape files in light of tape retention policies and procedures, andpublished findings to management and end users. Those tapes that should have been expiredwere scratched, and those that needed longer retention were extended. Project resulted ina 40% reduction in tapes.Coordinated the resolution of complex technical issues arising in operational statisticalsystems. Represented programming area in bi-annual Disaster Recovery tests, and reportedon results to management. Implemented various ad-hoc statistical requests from users.Taught programming efficiencies to co-workers. Represented applications programmingsection at technical Policies and Procedures meetings. Directed OJT efforts forprogramming area; coordinated training efforts with shop's technical trainers; manageddepartmental onsite training sessions with vendors. Prepared quarterly report detailingimpact of growth on scheduled systems, and compared prior efficiencies to currentperformance. Report delivered to management, computer operations, and programming staff. Show less

Conducted Joint Application Development (JAD) sessions for various on-line CICSapplication development projects. Designed database requirements for new Managed Care, On-Line Reporting, and Individual Case Management systems. Wrote TELON modules for variousCICS applications.

Worked on project teams that analyzed and implemented statistical reporting systemsregarding cost & utilization, mail order drug processing, and claims processing in and outof subscribers' service area.

Analyzed changes to Mail Order Drug processing system, and coded programs for year-endchange implementation.Designed enhancements to Fraud system, and assisted Programmer Trainee in coding andimplementing changes.Identified programming inefficiencies in a mission-critical system and implemented thechanges: program execution reduced from over eight hours to less than one hour. Assistedin the coding and implementation of several large batch-processing systems.

Education record

Mba

Ba, Musicology

Aa, Music, Philosophy

Activities and Societies: Honor Society