Transcript business systems analyst

CAREER ISSUES
IS 342
Chandra S. Amaravadi
1
PRE-REQUISITES
2
KNOW YOURSELF
DO YOU LIKE:
troubleshooting problems?
communications? coding?
working with people?
working individually?
working with numbers?
none of these?
3
GETTING THE JOB
CHOOSE A CAREER PATH
Technical sales & support
Help desk; PC specialist; tech support
Systems analyst
Business analyst
Database analyst
Data mining/warehouse analyst
Business-systems analyst
IT analyst
IT systems analyst
Security analyst
Network analyst
IS major/
business minor
CS major/
IS minor
4
EXAMPLE JOB DESCRIPTIONS
5
HELP DESK
Provides technical, operations, and support to users of company's personal
computers either by telephone or through e-mail, relative to desktop
hardware and software issues as well as an understanding of an enterprise
user account process. Performs hardware and software diagnostics and
coordinates repairs. Develop and provide metric based reports. Ability to
demonstrate excellent written and oral communication skills and strong
customer service experience. Responsibilities include such tasks as password
resets, e-mail requests, web requests and direct requests for Help Desk
support. Candidate will document, research, identify and attempt to solve
technical problems on initial call and/or triage where appropriate for
resolution. Document and track support activity and clearly communicate
technical solutions in a user friendly professional manner. Uses expertise in
customer service and technical knowledge gained from prior experience to
resolve issues as it relates to customer's environment. Work with Call Center
representatives regarding local support at various locations.
6
PC SPECIALIST
U.S. Bank
Provides installation and day-to-day support for
hardware, software, and network components for
desktop personal computers. Offers advanced technical
support to local network or system users, troubleshoots
difficult user software or hardware problems, and
repairs equipment. Performs first level support for
questions and problems relating to microcomputer
hardware, software, and networks.
Associate's degree or equivalent work experience
-At least 1 year experience with the support of hardware, software,
and network components for desktop personal computers.
7
PC SPECIALIST..
U.S. Bank
Practices preventive maintenance, logs and tracks
problems, reviews problem tracking databases.
Investigates hardware problems and performs minor
system hardware and communication connection
repairs. Works with callers or specialists to resolve
routine and/or unusual system problems. Provides
technical support for workstations and office
applications. Participates in analysis of client identified
issues or problems, which may require changes to
procedures, standards, or systems. Performs moves,
changes, enhancements, and corrections to office
layout for PC's, printers, and other hardware.
8
TECHNICAL SUPPORT
PRIMARY
FUNCTIONS:
The services you will provide include, but are not limited to:
Technical Consulting by advising clients’ technology strategy.​
Installing and configuring Servers, Desktops Switches and Firewalls.​
Troubleshooting problems (hardware, software, network, etc.​).​
Provide Tech Support at a level that also enhances the client experience.
9
BUSINESS ANALYST
UNITED HEALTH GROUP, WEST VALLEY
Description:
Document process flows, user requirements and test scenarios
Communicate and clarify requirements with IT, project team and end users
Orchestra and executing testing & acceptance/validation of test scenarios
and deliverables
Responsible for creation and execution of training, training materials and end
user documentation
Responsible for action item follow up with action holders ensuring timely
completion and participating in status meetings
Serve as a resource to other team members as designated by Operations –
assume full accountability for assignments
10
BUSINESS ANALYST..
UNITED HEALTH CARE, MINNEAPOLIS
Core Competencies:
• Highly motivated and innovative, with the ability to work as part of a high
performance team as well as independently – being a team player is a MUST
• Ability to take direction and immediate action as priorities change quickly
• Ability to manage multiple priorities and execute deliverables on time
• Extremely organized with superior attention to detail
• Exceptional interpersonal, verbal and written communication skills
• Professional skills – Initiative, Collaboration/Teaming, Organization/Planning,
Accountability/Autonomy
11
BUSINESS SYSTEMS ANALYST
JOB DESCRIPTION:
This candidate will maintain a thorough understanding of the
business and appropriate IS strategies. The focus will be
support of manufacturing related applications including
FACTORYworks, EnterpriseOne Manufacturing and other
custom applications.
12
DATABASE ANALYST
JOB DESCRIPTION:
Responsible for designing, planning, implementing and administering databases,
including security, access, and documentation.
1. Participates in the design, maintenance, enhancement, coding, and
administration of relational databases.
2. Analyzes and determines information needs and elements, data relationships
and attributes, data flow and storage requirements, and data output and reporting
capabilities.
3. Coordinates new data development ensuring consistency and integration with
existing data warehouse structure.
4. Reviews business requests for data and data usage, researches data sources for
new and better data feeds….
13
DATABASE ANALYST..
JOB DESCRIPTION..
Responsible for designing, planning, implementing and administering databases,
including security, access, and documentation.
5. Participates in continuous improvement efforts in enhancing performance and
providing increased functionality, including performing proactive maintenance
such as ensuring continued space availability, monitoring activity, and
documenting problems, changes, and solutions.
6. Tests designed applications.
7. Assignments may include design of data dictionaries, database structure and
layout, installing, upgrading, and managing database applications.
8. Stay current on vendors\' best security practices in relation to organizational
requirements…
14
DATABASE ANALYST..
QUALIFICATIONS..
Bachelors Degree in Computer Science or related technical discipline, or
the equivalent combination of education, technical certifications or
training, or work experience.
2-5 years of related database analysis and/or administration experience.
15
DATA WAREHOUSE ANALYST
C&S Wholesale Grocers
•User level and/or implementation experience in WMS & TMS systems is
desirable.
•Experience and exposure to transportation operations & concepts is desirable.
•Experience with data mining, business intelligence tools, financial planning and
analysis would be a plus.
•Strong analytical, logic, math, and problem solving skills.
•Need the ability to work effectively and productively without direct on-site
supervision.
•Strong self-starter, persuasive and able to affect change when required with
upper level management team.
•Strong communication and presentation skills.
•Technical skills required: MS Office (especially MS Excel), SQL.
16
DATA WAREHOUSE ANALYST
MC LEAN, VA
QUALIFICATIONS:
B.S. in Computer Science or related discipline or an
equivalent combination of education and experience from
which comparable knowledge and skills may be acquired; and
one year of experience in data warehousing.
Analyze, develop and evaluate data mining methodologies
using data mining and data analysis tools.
Design, develop, test and maintain databases and
application projects.
Create data repositories.
17
DATA WAREHOUSE ANALYST..
SOFT SKILLS
Soft skills include:
Solid Analytical skills
Quick Learner
Communication (written & verbal)
Comfortable operating in an environment with ambiguity and
frequent changes of direction and/or priorities.
 Basic Facilitation
 Attention to Detail
 Data Analysis
 Multi-tasking ability
18
DATA WAREHOUSE ANALYST..
SOFT SKILLS..
Other competencies:
 Excel, Word
 Knowledge Sharing with other teams members.
Relational Data Base Concepts.
Queries against complex relational databases
Data Quality Standards & Policies
Advanced Data Warehousing Concepts
An Understanding of SDLC - Waterfall, UML, Rational.
19
IT ANALYST XEROX
JOB REQUIREMENTS
The IT Analyst is responsible for the support of our IT Operations and data
analysis to ensure that the systems and operations supporting our customers
are well defined and monitored. The IT Analyst will have a strong
analytical background and have experience in multiple hardware and
software platforms. This person must be a self motivated individual willing
to accept the challenge of learning their environment through systematic
investigation and analysis. The following are the desired skills for this
position.
20
IT ANALYST XEROX..
1-2 years exp. in IT Service Desk and Operations support
1-2 Years exp. using SQL Server and Oracle
Past development experience using .Net
Experience in Windows and Linux environments
Familiar with software development in .Net (c# and
jsp.net)
Strong Process and Data Analytical skills
Strong documentation and writing skills
21
NETWORK ANALYST -- BROOKSHIRE
Job Requirements/​Qualifications:
4-6 years Network Administration experience.​
Proficiency in CISCO IOS.
Experience configuring Firewalls and or Cisco ACE equipment
Strong and comprehensive troubleshooting skills.​
Perform with limited support and direction and act as a technical
resource/​mentor for other Network Administrators.​
Proficiency in verbal and written communications and is expected to create
and maintain documentation.​
Participate in an off-hours on-call rotation is required.​
Occasional travel for training classes, conferences and various disaster
recovery tests.​
Wireless equipment configuration in a corporate environment is a plus.​
SAN administration experience is a plus.​
Education: Degree or certification in Network related field is a plus
22
NETWORK ANALYST -- BROOKSHIRE
Job Responsibilities:
Maintains and administers LAN, WAN, and wireless networks and
related computer environments.​ Equipment may include but not limited to
routers, firewalls, wireless controllers, computer hardware, systems
software, and associated configurations.​
Monitors LAN, WAN, and wireless networks to ensure network
availability and performs necessary maintenance to support network
availability.​
Designs, implements, and maintains network services such as DNS,
DHCP, and VPNs.​ Assists with design and planning of large scale network
projects.​
Develops documentation of network components, configurations, and
guidelines for use.​
Ensure network security and integrity through implementation of system
backups, recovery procedures, and contingency planning.​
23
GETTING THERE
24
GETTING THE JOB
STRENGTHEN YOUR RESUME
Apply for scholarships/awards
Be active in student organizations
Do summer/part-time jobs
Certifications
Perform well in course projects (work in a company if possible)
Take additional course work
Volunteer
on-campus (University)
off-campus (elementary schools are receptive)
http://www.wiu.edu/student_services/student_activities/volunteer/community.php
25
CERTIFICATIONS
Software technologies
ASP.NET, JSP etc.
W3 Schools, Taming the beast
MCDST (Microsoft Certified Desktop Support Technician)
pass two exams on operating systems
MCSE (Microsoft Certified Systems Engineer)
pass four Operating System, 1 design, 2 electives
MCDBA (Microsoft Certified Database Administrator)
design implement, administer Microsoft SQL server
26
GETTING THE JOB
SHARPEN YOUR SKILLS/IMAGE
Make resume stand out
Prepare portfolio if possible
Prepare answers to interview questions
Practice communications
Review essential ideas in courses
Go to career fairs and talk to recruiters
27
IF STILL ON JOB MARKET
Consider Master’s degree
M.S.
MBA
Work on strengthening qualifications
e.g. take DS305
try to get a certification (e.g. MCDBA)
Be on the look out for opportunities
Try to maintain positive outlook
28
ON THE JOB TIPS
Work output & quality important
always be professional
arrive early and leave on time rather than other way
Fitting-in
adapt to culture
maintain good relationships
do not be an individualist
do not criticize
29
TIPS FOR A SUCCESSFUL CAREER
AND HAPPY LIFE
Most important factors:
career growth
job satisfaction
finances
work-life balance
???
30
BOOK RECOMMENDATIONS
1)
2)
3)
4)
5)
Eric Tolle “The power of now”
Spencer Johnson, “Who moved my cheese?”
Robin Sharma “The monk who sold his Ferrari”
Robin Sharma “Who will cry for you when you die?”
Deepak Chopra “The seven spiritual laws.”
31
32