Garrett Pickus Email & Phone Number

Remote

Gilbert, Arizona, United States

- Worked on tickets to resolve Relativity issues for Deloitte’s Federal Discovery team. - Did Relativity preinstall and install steps on new servers and documented repeatable steps for team. - Maintained and answered questions about Powershell and Relativity scripts and occasionally wrote new ones when time permitted. Worked with Federal Discovery development team to get new scripts and applications approved for instance as needed. - Worked with Database Administration team… Show more - Worked on tickets to resolve Relativity issues for Deloitte’s Federal Discovery team. - Did Relativity preinstall and install steps on new servers and documented repeatable steps for team. - Maintained and answered questions about Powershell and Relativity scripts and occasionally wrote new ones when time permitted. Worked with Federal Discovery development team to get new scripts and applications approved for instance as needed. - Worked with Database Administration team to identify issues with SQL Server setup, maintenance, slowness, and blocking queries. Suggested SQL indexes to make queries run efficiently as needed. Show less

Phoenix, Az

Fix and report issues with Relativity, EDA/LAW, and eCapture/ADD applications. Handle custom requests not achievable in the front end of application with SQL scripts. Write custom Relativity Event Handlers in C#/VB not possible in Event Handler Express. Write scripts to capture metrics numbers for eCapture/ADD processing. Create remediation workflows to workaround bugs/issues. Submit bugs/issues as needed to Software Creators. Look into latency/slowness issues and escalate to… Show more Fix and report issues with Relativity, EDA/LAW, and eCapture/ADD applications. Handle custom requests not achievable in the front end of application with SQL scripts. Write custom Relativity Event Handlers in C#/VB not possible in Event Handler Express. Write scripts to capture metrics numbers for eCapture/ADD processing. Create remediation workflows to workaround bugs/issues. Submit bugs/issues as needed to Software Creators. Look into latency/slowness issues and escalate to appropriate groups as needed. Show less

Remote

Answer client questions about eDiscovery software via phone, chat and email. Report bugs and client issues to Software Engineering team as needed. Use NoSQL database to research issues and solve client problems. Update technical team documentation about software as needed. Research issues with problematic file types and software warning errors. Advise clients on best methods to migrate data into DISCO software. Prepare incoming data to properly ingest into DISCO system as needed.… Show more Answer client questions about eDiscovery software via phone, chat and email. Report bugs and client issues to Software Engineering team as needed. Use NoSQL database to research issues and solve client problems. Update technical team documentation about software as needed. Research issues with problematic file types and software warning errors. Advise clients on best methods to migrate data into DISCO software. Prepare incoming data to properly ingest into DISCO system as needed. Advise clients on how to use the software and come up with plans to help ensure gets the best experience from the DISCO software. Show less

Phoenix, Arizona Area

Write SQL scripts to create custom eCapture metadata fields. Write custom reports from the eCapture database as requested from Project Managers. Write custom reports from eCapture database for management to determine total amount of data processed for a time period. QC eCapture exports and load into Relativity. QC Relativity Productions and Subsets. Troubleshoot eCapture issues and report to IPRO if necessary. Process data in eCapture and catalog electronic media as needed. Troubleshoot… Show more Write SQL scripts to create custom eCapture metadata fields. Write custom reports from the eCapture database as requested from Project Managers. Write custom reports from eCapture database for management to determine total amount of data processed for a time period. QC eCapture exports and load into Relativity. QC Relativity Productions and Subsets. Troubleshoot eCapture issues and report to IPRO if necessary. Process data in eCapture and catalog electronic media as needed. Troubleshoot issues with standard SQL scripts as needed. Show less

Phoenix, Arizona Area

Wrote SQL scripts to integrate Clearwell metadata into eCapture database. Create custom metadata fields in eCapture database per client specifications. Create action plans in eCapture for complex EDD requests from clients. Fix issues within the eCapture environment. Report bugs to IPRO as needed. Created a small website in ASP/C# with a SQL backend to log billable time for work completed until the company decided to migrate all tracking into Doculogix PTS.

Oversee a shift of eight technicians, responsible for continued training and supervision of technicians for a legal discovery company ranked in the top 10 of an industry survey.Solve shortcomings and make custom reports for the Electronic Discovery application using SQL queries on the backend database, set company records for data processed in a month.Troubleshoot errors and suggest improvements for the application, report them to the development department. Run quality tests on beta… Show more Oversee a shift of eight technicians, responsible for continued training and supervision of technicians for a legal discovery company ranked in the top 10 of an industry survey.Solve shortcomings and make custom reports for the Electronic Discovery application using SQL queries on the backend database, set company records for data processed in a month.Troubleshoot errors and suggest improvements for the application, report them to the development department. Run quality tests on beta versions of code and see if output gives expected results. Show less

Created and processed .TIF images and metadata from client's raw computer files for legal discovery company.Implemented improvements for existing processes that streamline operations, and enabled team to consistently meet client deadlines and set records for data processed in a month.Solved shortcomings and diagnosed issues with the Electronic Discovery application code using SQL queries on the backend database.