Programmer Analyst Resume
SUMMARY:
Detail - oriented professional with SQL scripting experience using SQL Developer, Microsoft SQL Server and PL/SQL in Oracle. Expertise in reporting using Crystal Reports and Argos Reporting.
TECHNICAL SKILLS:
Oracle SQL Developer
SQL and PL/SQL
Linux
Microsoft SQL Management Studio
Microsoft Office
IPEDS Reporting
Project management
Lime Survey
Scantron Class Climate Survey Software
Software Testing
PSPP Statistical Software
Ad Hoc Reporting in Argos and Crystal
Payroll Processing
Technical help desk experience
Strong analytical skills
Confidential Banner
WORK EXPERIENCE:
Programmer Analyst
Confidential
Responsibilities:
- SQL reporting in Oracle SQL Developer
- Creating and maintaining scheduled cron jobs
- Creating and maintaining Argos Reports
- Assisting users when issues arise using Banner software, portals and other third party software the client uses on a daily basis
- Creating custom PL/SQL scripts, inserting and removing data from tables in database, and updating data as necessary
- Attending and participating in project meetings for developing new reports or dashboards for client
Coordinator of Research/Data Analyst
Confidential, Gulfport, MS
Responsibilities:
- Assist in research projects
- Use of SQL, PL/SQL and Oracle database tables to extract data for ad hoc reporting request, state and federal reporting as well as internal research projects
- IPEDS Reporting
- State Funding Reporting
- Maintain an online fact book
- Develop SQL to design new reports
- Update older SQL code to conform with our new database servers
- Banner SIS proficiency
- Member of SACCR
- Utilize Excel and PSPP to analyze data and create charts, graphs and reports
- Utilize survey systems to administer surveys to students and faculty
Program Support Specialist
Confidential, Hattiesburg, MS
Responsibilities:
- Provide administrative support and support for software programmers
- Create SQL queries and stored procedures
- Create Crystal Reports with and without logos, including cross-tab reports
- Use Visual Basic to add code to call reports, create web pages (aspx), create HR Forms, debug programming code, and test software additions and modules
- Process bi-weekly payroll
- Utilize Microsoft Office for many projects
- Provide software support to end users by adding and removing user permissions, providing support over the phone, and working Help Desk Tickets in a timely manner.
- Technical Audits
- Project management
Caregiver
Confidential, Wiggins, MS
Responsibilities:
- Schedule doctor appointments
- Transportation to and from doctor appointments
- Ensuring patient had all medicines and took them on time
- Paying bills
- Completion of any paperwork concerning legal matters or medical care of an elderly person
Student Assistant
Confidential, Hattiesburg, MS
Responsibilities:
- Assist math department faculty
- Grade papers and recording grades in gradebook
- Assist students with math courses by tutoring and answering general questions
- Assist with registration and advisement
- Technical assistance with computers, projectors, and graphing calculators for math department staff
Programs Specialist, Financial Aid Office
Confidential, Perkinston, MS
Responsibilities:
- Process federal and state student financial aid
- Import and export data between the college and the Department of Education and the state reporting entities
- Process federal student loans
- Assist students during registration, to fill out their FAFSA, and answering general questions
- Maintain Federal and State software for financial aid programs
- Balance state financial aid reports
- Implement new process to adequately process a new grant program
Graphic Designer
Confidential, Wiggins, MS
Responsibilities:
- Utilize Adobe Photoshop to produce graphic images
- Tutorials were utilized as a source for creative inspirations
- Create alphabet images as well as clip art type images using layers, textures, actions, styles, graphics pen tables and brushes
- Use of GIMP and a vector drawing program to assist in the design process
Student Assistant
Confidential, Perkinston, MS
Responsibilities:
- Assist in the daily operation of the Human Resources Department
- Scanning of employee documents
- Filing records
- Creating mail merges
Imaging Technician
Confidential, Gulfport, MS
Responsibilities:
- Scanning student financial aid documents into a database
- Indexing files to make for easier searching
- Distribute files to the distribution center for storage
- Data entry
Data Entry Clerk/Loan Processor
Confidential, Gulfport, MS
Responsibilities:
- Process student application for internal and external student loans
- Print and distribute approved loan documents
- Processed incoming loan documents into computer system and ensure documents were completed
- Pulling credit reports
- Tracking students status in class
- Balanced outstanding funds reports with the database for accurac
