Microsoft Office Information Systems

Carlos Ortega *******@*****.*** 612-***-****

Associate Business Analyst – Emerson Automated Solutions April 2011 - Present

Gather requirements from users, translate requirements into functional specification documents, create test scenarios, and work with developers to implement modifications into Oracle Trading Community Architecture testing and production environments.

Learned Oracle TCA record load system on my own. Now our department can load tens of thousands of records into Oracle in hours instead of logging tickets with support and having records loaded in 1 week. Found automation program that can update record attributes. Now spare computers can update thousands of records in a day instead of 3 employees updating thousands of records in a week

Improved business processes for user’s access to reports. Found free SQL programs, and created procedures for users to generate their own reports in minutes as opposed to users logging tickets and obtaining reports in a few days

Gathered requirements, created testing plan, and created web form to replace web form Latin American users were using to submit Emerson customer creation address requests. Requests are now fulfilled in 3 days instead of 8 days, and request rejection rate is down from 15% to 2%

Treasurer – PCCC

June 2015 - Present

Invested spare cash in fund supporting organizational liquidity needs and risk tolerance. In 13 months the return on the investment is 12%, as opposed to the annual 0.03% the funds were earning in the bank.

Researched and negotiated contracts with vendors for custodial services, trash removal, and Internet\phone services. Monthly savings of 20%

Pay bills and tax withholdings, submit monthly reports to board, and plan annual budget

Associate Systems Administrator – Emerson Process Management January 2008 – March 2011

Loaded images onto laptops and desktops, removed viruses and malware from computers, and provided smartphone support for 500 users at office and remote locations around United States

Deployed 30 new laptops to 30 users over 2 days without any user downtime

Information Systems Assistant – Minnesota Timberwolves & Lynx August 2001 – August 2007

Provided Microsoft Office support, virus/malware removal, and file backup and recovery for 140 user environment

Skills

Functional Specifications

Requirements Analysis

Technical Problem Resolution

User Procedures

Software

MS Excel

MS SQL Server

Toad for Oracle

Oracle O/M module

Oracle TCA

Education

BS, Management Information

Systems, Florida State

University

MS, Software Engineering,

University of St. Thomas

MBA, Finance, University of

Minnesota – Twin Cities

Contact this candidate