Systems Analyst Data

GH

GERALD HAMILTON

*******************@*****.*** 901-***-**** Olive Branch, MS 38654

Able to coordinate and direct all phases of project-based efforts while managing, motivating, and guiding teams. Reputed for exercising initiative, accepting, challenges and analyzing alternatives. Experienced in learning and excelling at new technologies as needed. Strong analytical and critical reasoning ability - Using logic and analysis to identify the strengths and weaknesses of different approaches.

RELEVANT

Coldfusion

Html

Toad 9.0

MS Office

Originality and Creativity

Java Script

Korn Shell Scripting

SQL

PLUS

MS Project

Team Leadership

Hiring and Onboarding

T-SQL

XML

UNIX

MS Visio

ASP

DOS

LINUX

Windows XP/NT

PL/SQL

Oracle 8/8i/9i/10g/11g

Active Directory

Visual Basic

SQL Developer

Dreamweaver 9.0

Tortoise SVN 1.5.3

Hyperion

MS SQL Server

Argos

Hamcow Logistics, LLC Olive, MS

Business Manager (Contractor)

12/2017 - Current

Maintain client compliance with company (Client) policies and procedures Provide assistance with payroll for all drivers

Maintain any vehicle maintenance to trucking equipment Provide support for emergency vehicle breakdowns

Make sure all trucking equipment meets DOT Federal regulations Interview and do background check for drivers

Abide by all the client's safety requirements

Monitor fuel purchase system with assistance of Fuel Cards for drivers Collect and send invoices from drivers to company (Client) for payroll Assist with maintaining financial and expense reports Interacted with customers and vendors with utmost professionalism to solve various problems.

Collaborated and built trust within organization and with customers, meeting or exceeding expectations.

Drove high performance by developing team members. Determined customer needs and calculated payment options based on Summary

Skills

Experience

consultative sales process.

Communicated client priorities, delivering presence and business objectives.

Worked closely with internal teams to deliver on high-profile, complex projects.

Hamcow Consulting Olive Branch, MS

Business Manager

04/2016 - 04/2016

Work closely with the financial management team to ensure that all bills are paid in a timely manner

Maintain and communicate with client on all deadlines and upcoming events

Confer with client to develop strategies for their personal branding and brand management

Schedule promotional or performance engagements for clients Arrange meetings concerning issues involving their clients Manage business and financial affairs for client

Prepare monthly accounting statements for client

Plan, organize, schedule, and manage events and calendar Supervise the work of the accountant and ensure accurate maintenance of the accounts of the incomes receive, and expenditures made by the client Assist the client in managing the work, meeting job commitments and ensure responsibilities are discharged on time

Effectively and efficiently perform duties when requested by the client ECS Federal, Electronic Consulting Services

Memphis, Tennessee

Computer Systems Analyst IV

05/2014 - 04/2016

Approve and designate workload request to other DBAs and Analyst in the group

Receive background check to get Federal Security Clearance to work for USPS postal service

Effectively made use of table functions, indexes, table partitioning, analytical functions, materialized views, and query re-write Public Trust Clearance from Federal Government

Responsible for creating PL/SQL scripts to migrate and archive data to data warehouse

Analyze business requirements and data to derive technical designs, development plans and test plans to achieve development goals Create Shell Scripts for invoking SQL scripts for batch scheduling Create and modified UNIX shell Scripts according to the changing needs of the project and developer requirements

Create Shell Scripts that would dynamically archive data to data warehouse

Involve in data loading using PL/SQL and SQL

Loader calling UNIX scripts to download and manipulate files Migrate and deploy database backend objects and data from development to staging and/or production

Debug and re-write any database PL/SQL code for Senior developers, Junior developers and

DBAs that are running slow

Help create any Help Desk or Change Request tickets for deployment or changes to production database objects or data

Research and resolve any issues or errors for Data loads on production Provide support in design meetings with programming staff and advise clients in all phases of system design and implementation Develop technical design documents, flow charts, interface documentation, and technical architecture diagrams

Experienced in Client-Server application development using Oracle 11g/10g/9i/8i,

PL/SQL, SQL

PLUS, TOAD and SQL

LOADER

Work effectively with multiple team members in diverse roles to deliver computing applications.

University of Memphis Memphis,

Tennessee

Database Systems Programmer II

11/2011 - 05/2014

Researches, collects and analyzes information and data to identify problems and recommends alternative solutions

Code, debug, and test Oracle objects and Banner API's to support application (projects such as Computing Lambuth Footprint, Updating Alumni Address, Updating Alumni Information,

Intent to Graduate)

Create Supplemental Development Engine (SDE) fields for Banner Oracle forms in Finance and Payroll

Develop Oracle procedure in PL/SQL to migrate date into SDE fields Document test cases, expected test results, test data requirements, and collaborate with testing teams and project team to resolve testing problems Serve as backup Argos Administrator

Assisted with setting up users accounts in Argos

Maintaining security for LDAP group and individual Argos users Provided support as primary administrator for Umdrive application Monitors, upgrades, maintains, secures and optimizes UMdrive (Xythos) applications

Provides technical expertise and client support for daily administration and maintenance

Establishes and maintain security for UMdrive application Coordinate system resources and user accounts

Submit and report tickets to vendor for any application bugs or latest Service Packs

Resolve any tickets that were submitted by faculty, students, and staff for UMdrive, Argos,

Hyperion reports, and past projects

ECS Federal, Electronic Consulting Services

Memphis, Tennessee

Systems Analyst III

06/2011 - 10/2011

Analyze business requirements and data to derive technical designs, development plans and test plans to achieve development goals Assist DBA's with migrating and deploying database backend objects and data from development to staging and/or production Debug and re-write any database PL/SQL code for Senior developers, Junior developers and

DBAs that are running slow

Help create any Help Desk or Change Request tickets for deployment or changes to production database objects or data

Research and resolve any issues or errors for Data loads on production Provide support in design meetings with programming staff and advise clients in all phases of system design and implementation Develop technical design documents, flow charts, interface documentation, and technical architecture diagrams

Work effectively with multiple team members in diverse roles to deliver computing applications

Advise other developers with proper PL/SQL tuning and other Oracle functionality

Northrop Grumman Corp Memphis,

Tennessee

Systems Analyst III

03/2010 - 06/2011

Analyze business requirements and data to derive technical designs, development plans and test plans to achieve development goals Lead design meetings with programming staff and advise clients in all phases of system design and implementation

Develop technical design documents, flow charts, interface documentation, and technical architecture diagrams

Advise other developers with proper PL/SQL tuning and other Oracle functionality

Work effectively with multiple team members in diverse roles to deliver computing applications

Advise other developers with proper PL/SQL tuning and other Oracle functionality

Northrop Grumman Corp Memphis,

Tennessee

Programmer Analyst III

02/2008 - 03/2010

Conduct meetings with other developers and analyst on ongoing projects Pull USPS code updates through Amazon Web Service (AWS) Work efficiently as a team with other developers on projects Create and maintain repositories in Tortoise SVN for Coldfusion code Advise other developers with proper PL/SQL tuning and other Oracle functionality

Meet all requirements of the project plan for programming projects Create dynamic web interface using Coldfusion, PL/SQL, and DOS batch scripting

Re-write existing applications in PL/SQL based on requirements from Business Analyst

Debug and troubleshoot applications on the development and staging environment

Provide workflow diagram for new applications

Resolve any issues or problems that may arise in projects Debug, configure, and act as the Coldfusion Administrator for the the department

Create and maintain multiple Coldfusion internal web applications Responsible for creating a process plan for the new Oracle 10g database migration

Configure and set up Oracle 10g client environment for the BMA Certification department and Postal One department

Backup Oracle objects using exports and maintain backup for Coldfusion web pages on repository box

Support in upgrading from Coldfusion 7.0 web server to Coldfusion 8.0 web server

Northrop Grumman Corp Memphis,

Tennessee

Database Programmer/Analyst

03/2004 - 02/2008

Assist with setting up, testing, and troubleshooting applications on the production environment

Identify and resolve problems with scheduled cronjob scripts on Unix and Linux production servers

Migrate application from development and staging to production Implement change requests for development, staging, and production applications

Program and develop DOS, PL/SQL scripts, procedures, and UNIX shell scripts

Develop scripts and reports to maintain production databases for day-to-day backups, alerts, etc

Tune pl/sql scripts, procedures, functions, and packages for production applications

Ensure integrity of production data for USPS Data Mart Resolve Oracle software issues that are reported through Remedy software in a timely matter

Install and provide tech support for Oracle based product such as Developer Suite, Toad,

Oracle client, etc

Load flat file data from various platforms such as mainframe, Solaris Unix, Red Hat Linux, and Windows using SQL

Loader

Maintain documentation of the production database operations Create and run backup scripts for development databases Monitor tablespaces for production and development databases Responsible for all daily loads on the databases

Implement and follow up security procedures.

Cummins Inc Memphis, Tennessee

Operation and Data Analyst Graduate

Intern

02/2003 - 03/2004

Analyzed and fixed parts that were out of synchronization in the Oracle databases

Developed SQL scripts for Operation Department's monthly reports Maintained a weekly report for Information Systems on parts that are out of synchronization

Consulted and worked with application developers on design and constraints of Oracle tables

Assisted in maintaining daily inventory accuracy using the SQL/PLSQL scripts

Constructed daily financial and backorder reports for Operation's director and corporate managers

Supported several,

Resolve any issues in outbound warehouse logistics' Contact domestic and international Cummins warehouse suppliers about incomplete orders

Performed product cycle count audit throughout the warehouse Memphis Grizzlies, NBA Memphis,

Tennessee

Basketball Information Intern

01/2002 - 05/2002

Created and organized players' profile in a database Coordinated scouting reports for the scouting department Analyzed scouting report for any type of statistical errors Assisted the director of Basketball Operations in coordinating regular season games.

City and County of San Francisco-

DPW-BOE San Francisco, California

Management Information Systems Intern

05/2001 - 01/2002

Developed a Visual Basic application that updates employees' contact information in

Active Directory

Maintained ASP applications for Bureau of Engineers [BOE] Personnel Department's intranet site

Provided technical support for the Bureau of Engineers' training room Created and maintained email accounts using Active Directory Provide technical support for the BOE department

Solved problems dealing with hardware, software, and networking for all workstations

Assisted in all facets of Network Administration for a 5 server/175 workstation network environment.

Christian Brothers University Memphis, Tennessee Bachelor of Science in Computer Science

05/2002

Olive Branch High School Olive Branch, Mississippi High School Diploma

AWARDS, Christian Brothers University, Computer Science Scholarship (CSEMS) Award (2000-2002). Education and Training

Additional Information

Contact this candidate