Senior Systems Analyst/Team Leader
Jason Wickline
Responsibilities
Education and Training
Millikin University; Decatur, Illinois May
1994
Bachelor of Science: Management Information Systems
Technical Training
Oracle 9i Database: Administration Fundamentals I
Oracle 9i Database: SQL Tuning Workshop R2
Oracle Reports Developer 10g: Building Reports
Visual Basic
JAVA Script
XML
HTML
Lotus Notes Development
Managerial Training
•
Creating Highly Effective Project Teams
•
Making Projects Work
•
Managing Multiple Projects & Objectives
•
Project Management Techniques
•
Advanced Project Management Techniques
Professional Experience
Programming/Operating System Experience
SQL/PLSQL Windows 2000 UNIX (AIX, HPUX)
COBOL Windows XP DOS
CICS MVS ISPF
Database Experience
Oracle (9i) DB2 Informix
Access Progress Ingress
Previous Professional Experience
Millikin University, Decatur, Illinois
Senior Systems Analyst/Team Leader January 2007 - Present
·See responsibilities above.
Database Analyst May 2003 - December 2006
· Provide customer support for modules of Administrative system
· Develop
and implement database queries, procedures, packages, and reports
· Perform
design and development in response to requests for information
· Identify
and resolve data related problems
· Ensure integrity of data
· Provide information requested from internal/external
customers
· Ensure
that reports are accurate and produced in a timely manner
· Prepare
project, plans, and schedules for significant database-related implementation
and support efforts
· Communicate regularly with internal technical,
applications and operational staff, as appropriate, in order to ensure
the database integrity, security
and availability
· Evaluate database management systems and related tool sets
· Monitor assigned
organization operational and development projects to ensure consistency
and satisfaction of database infrastructure
· Interact with
and assist system administrators to provide a compatible and usable database
environment
· Assist in development and implementation
of data and database related standards, procedures and guidelines
· Coordinate testing activities within
and outside the department, as required
· Maintain
development, test and production regions of programs
· Assist in
monitoring the direction and growth of business to ensure the application
of appropriate technologies and support systems
· Assist in the
preparation of application systems project plans and schedules, relative
to database-related design, development, implementation, and support
· Coordinate
testing activities for appropriate application systems development with
Database Administrator(s), as required
· Consult with the end users regarding
database issues
· Monitor and track
application system development progress in order to provide and/or recommend
the appropriate application of database resources
and/or technology in order to meet development and support requirement
Nims Associates Inc.; Decatur, Illinois
Consultant: Senior Systems Analyst August 1997 – May 2003
· Provide daily production support for customer’s online system
· Analyze, design, and develop COBOL online and batch programs for
customer service system.
· Resident expert on Design 1 and Install 1 application development
tools.
· Develop and deliver training program for development tools to staff
of over 40 people.
· Maintain documentation on customer information system.
· Develop programs related to customer orders and tracking customer
specific information.
· Work with DBA to improve performance and improve response time of
applications.
· Provide estimates on work requests.
· Develop and implement testing plans for releases of application code.
· Research discrepancies in production data due to programming errors.
· Assist programmers with high level logic in SQL statement writing.
Richland Community College; Decatur, Illinois
Adjunct Faculty January 1996 – January 2000
· Teach principles and applications of information systems
· Plan projects, activities, and lecture to meet required curriculum
· Test and evaluate students understanding of course material
· Aid students with understanding of computer components and jargon
· Advise of educational and work opportunities to help students reach
desired objectives
Courses Taught
· Introduction to Business Computer Systems
· COBOL Programming 1
· COBOL Programming 2
· Business Applications on Microcomputer
· Microcomputer Data Base Systems
· Systems Analysis Methods
· Data Base with SQL
· Office Technology
Administrative Information Systems Specialist November 1995
– August 1997
· Provide daily computer support for staff of over 400
· Assist in user training sessions on Data Base system
· Provide reporting capabilities that will enhance workflow within
college
· Design and develop modules not contained within standard software
product
· Train and assist student intern with identified goals
Decatur Custom Tool; Decatur, Illinois
Systems Administrator February 1995 - October 1995
· Provided daily computer support for office staff of thirteen
· Monitored and adjusted AIX operating system for maximum performance
· Coordinated and implemented EDI communications with Caterpillar
· Diagnosed and resolved hardware problems
· Assisted in the training of staff in usage of newly purchased customer
system
Systems Analyst January 1994 - February 1995
· Served as resident expert on computer systems
· Studied and recommended alternative system to replace outdated system
· Oversaw data conversion during implementation of computer system
· Designed and developed custom reports for business analysis
· Presented organizational restructuring of staff to increase profitability
|