Sarah Hernandez Email and Phone Number

Volunteer Position. Developed strategies to attract, interview and retain student candidates from Kansas State University and other colleges for our Diversity and Inclusion as well as IT recruiting capabilities.

(2 of 2 roles for 2nd new hire rotation)PEARL PROJECT - REPORT DEVELOPER:-Evaluated project reporting requirements, available reporting technologies, and determined appropriate reporting technologies to implement. -Designed SSAS reporting data model, utilized MDX query language and SSRS to create reports and dashboardsSHAREPOINT UPGRADE:-Managed the migration of my organization’s 2003 SharePoint sites to SharePoint 2013 and SharePoint Online.3RD PARTY WEB APP SECURITY EVALUATION:-Gathered detailed information about 3rd party web apps that the Finance organization uses and evaluated the security processes for apps that were determined to have the most business impact.

(1 of 2 roles for 2nd new hire rotation)-Developed, enhanced and configured Production and Revenue Accounting as well as Land systems applications (Enterprise Upstream, Tobin Land Suite, PRISM)-Developed process to record metrics for Unix jobs-Wrote, debug, and optimized PL/SQL code and Unix scripts-Executed user data mining and data maintenance requests

•Identify and recruit students, who are motivated and passionate about technology, for full-time and internship positions in the Information Technology organization at ConocoPhillips. •Organize and conduct recruiting events such as classroom, club and college presentations as well as interviews and career fairs.•Selected by IT lead university recruiter to evaluate, organize and host ConcoPhillips 2015 IT Student Leader Forum.

(1st of 3 new hire rotations)• Resolved over 2,300 tickets as 3rd level support for Exchange 2007/2013/Online, Lync 2010/2013, Intercall (web conferencing), RightFax, Scanmail (email security system) and Sendmail (gateway) issues• Assisted in server builds, migrations and issue resolutions for the Exchange 2013 upgrade project• Organized and implemented new room resource settings that improved room scheduling• Worked with the SCOM team to prioritize and build new Exchange 2013 alerts• Executed PowerShell commands to complete tasks and gather Exchange/Lync information• Created knowledge center articles to assist the service desk in resolving common messaging issues• Documented and implemented new Scanmail installation process• Created a VBA script to automate the Intercall/Lync integration process• Participated in bimonthly on-call rotation

-Assisted advisers and their students-System Administrator of the appointment system-Created and managed the company contact database-Created and managed the graduation applications database and approval process-Managed confidential documents and administrated various forms and documents within the office

-Developed a new web page that would help end-users capture, edit, and create shipping rates for ocean going vessels. The page’s functionalities consisted of querying by criteria, inserting new ocean rates, updating and deleting multiple rates at one time. Specific toolsets used include PL/SQL stored procedures and packages, web services, data access objects, collections, HTML, and ASP .NET

-Managed and tested support requests from the crude, renewables, and RIN channels-Managed, created and documented the Crude by Rail Boarding Pass priming project-Tested the new Crude by Rail Boarding Pass application-Worked with the end-users directly to quickly troubleshoot system errors-Tested and provided feedback for the thin client pilot program

-Forecasted, applied and managed incoming and outgoing international cash-Reconciled international bank accounts -Assisted in preparing weekly estimates and monthly closings-Created a new inventory valuation process

-Assisted cost management analysts, planners, and project leaders-Reconciled Pipeline Integrity Engineering Facilities projects-Audited invoices against the Global Procurement Department’s rate sheets-Initiated and documented a new job order review process-Helped implement software update within the department-Executed job orders and ran job order execution reports-Updated designer forecast schedules-Provided Excel Spreadsheet support