Rene Merrifield alexandria, va 571-***-**** ********@*****.***
Systems Engineer
High-impact systems engineering professional with a record of elevating service delivery and achieving high technical performance. Strengths include creating and managing Oracle database system applications. Possesses expert diagnostic and analytical skills. Experienced problem solver able to urgently resolve performance issues, ensuring service sustainability and business continuity.
Signature competencies
Systems Analyst Installing, Configuring & Troubleshooting Structured & Conceptual Analytics Virtualization Automation & Software Scripting Operational Support Systems Monitor & Testing Application Software System Management Relativity eDiscovery Platform Oracle11g RDBMS SQL & PL/SQL SQL Loader
Career History and Key Accomplishments
CACI, Inc. Commercial Alexandria, VA 02/2008 - 04/2019
Systems Analyst / Systems Engineer Investigation and Litigation Support
Execute and deliver compliance analysis details on incoming discovery production files to establish validity for the Consumer Financial Protection Bureau. Monitor installed systems and infrastructure that provides the Litigation team notifications. Enable non-compliant production assessments and ensure high-level systems infrastructure readiness. Generate process models, examine quantitative and qualitative financial data and develop solutions. Through systems management maintain operating systems and application software.
Provide both end user and administrator services and support for Relativity and Clearwell for the Consumer Financial Protection Bureau legal staff.
Responsible for database administrator tasks, including creating complex searches, tags, and coding layouts.
Perform intake on incoming productions to prepare them for loading into Relativity or Clearwell. Maintain proper chain of custody and tracking through SharePoint and Salesforce. Manipulate load files using Textpad.
Process all smaller non-load ready data using ReadySuite, as needed.
Collaborate with CFPB staff to determine best practices and methods on a per workspace basis.
Utilize Excel to create overlays for use in Relativity, as well as reporting. Create file lists from data sets for triage.
Import and export files to forensics through prepared Relativity and Clearwell production sets.
Analyze data files for insertion to Oracle11g database for Deepwater Horizon discovery processes.
Collaborate with Project Managers on Oracle11g database scripts design, stored PL/SQL procedures and SQL statements; resolve issues on source data fields for privileged documents.
Establish workflows that support an efficient document review, search, and retrieval through importing data sets across OMEGA eDiscovery web applications.
Key Accomplishments:
Ensured quality of files loaded into and exported from e-discovery and case management applications as well as conducting quality checks of productions prepared by vendors.
Executed code on Oracle 11g PL/SQL, stored procedures and produced data input that revised existing system logic efforts; achieved rapport through relationships developed with end-user communities, stakeholders, and service providers for Deepwater Horizon project.
Improved coding by 20% by providing critical support through FEMA Claims Concordance database framework and configuration; adjusted database data-entry fields for requirement fits.
Reduced downtime and improved database security by overseeing concordance databases document distributions; improved process effectiveness, accomplished ways to increase efficiency.
Performed the maintenance routines, updated the database index to improve text searching..
Delivered suggested changes for FEMA Claims Denial letters and workflow analysis through the collaboration with team members on efforts completed and timelines.
Navstar Alexandria, VA 08/2007 - 02/2008
Programmer Analyst
Collaborated with team members on creating Oracle enterprise web-based chain-of-custody tracking systems for Katrina Acquisition, Exhibit and FEMA tracking that improved data entry by 25%.
Assembled the ER diagram, created database objects and coded client-side validation for the tracking systems.
On-the-job training in Oracle Jdeveloper for developing J2EE tracking applications and other technologies such as JSF, JSP document, XML, HTML.
Indus Corporation Washington, DC 12/2004 - 05/2007
Programmer Analyst
Managed database functional requirements process, conducted validation reviews, enhanced data-entry forms to execute reports for Department of Transportation.
Designed, implemented, tested, and maintained forms, reports, packages in an Oracle 10g web-based application system.
Supervised/trained 6 to modify Oracle forms and to develop logic for the seeing-impaired community while maintaining the same level of usability, functionality and efficiency.
Information Controls, Inc. Gaithersburg, MD 11/2003 - 11/2004
Oracle Developer
Streamlined Oracle 9i web-based data-entry form that improved the pharmaceutical inventory collection process by 30%.
Modified table structures; added columns, table constraints and event triggers.
QSS Group Washington, DC 02/1999 - 04/2003
Oracle Developer
Worked with Oracle Designer to capture requirements, model, and generate designs to convert into software programs. Produced and maintained Oracle6i form and report applications for AmeriCorps.
Consistently met strict client deadlines on diverse projects.
Increased productivity 50% by automating system to view and modify data, designed user-friendly forms.
Education and Professional Development
Relativity Certified User Certificate v9.6
Associates of Arts Degree in Computer Programming