Network Analyst Resume
5.00/5 (Submit Your Rating)
EXPERIENCE:
Confidential
Network Analyst
Responsibilities:
- Support and maintain all of the PCs belonging to the sheriff’s office including the jail, 4 substations, and all the squad laptops.
- In charge of maintaining the cameras, laptops and printers in the squads.
- Maintain 6 servers including an exchange server.
- Created and support Access database rosters and crystal reports.
- Setting up databases, tables, views, queries and replication.
- Setting up a data card system and connecting it to a SQL database to hold card information and pictures.
- Created an access front end to a SQL database for the end users.
- Setup roaming profiles for users.
- Maintain network security
- Setup network printers as well as shared printers
- Troubleshoot any software and hardware problems that may arise
- Also find security loopholes to tighten up security.
- Remote support using Teamviewer and VNC
- Mentored fellow co - workers and interns
Independent Computer Consultant
Confidential
Responsibilities:
- Maintain and support 4 SQL 2000 servers for 2 different insurance brokerage offices
- Created a SQL database
- Created tables which held data on the clients and employees
- Created indexes on the tables in order to increase productivity
- Created views and stored procedures to report data to the employees
- Created a number of stored procedures to find problems in order to resolve them quickly.
- Analysis and created queries for the employees
- Set up scheduled tasks to run queries against the tables.
- Data movement - DTS and BCP
- Build web pages using HTML and some Java scripting
- Troubleshooting both hardware and software on personal computers
- Installing software for small companies
- Troubleshooting client’s pc or network problems over the phone when needed
Jr. SQL DBA & Global SQL Application Admin
Confidential, Chicago, IL
Responsibilities:
- Supervised 4 DBA assistants to maintain and support 5 in house SQL servers.
- Installation, Support and troubleshooting of Windows NT, 2000, SQL 6.5, 7.0, and 2000
- Creation of databases, tables, indexes, views, stored procedures, scheduled tasks and triggers
- Performance monitoring and tuning (e.g. Index creation, etc.)
- Monitoring and troubleshooting, including DBCC’s and index fragmentation
- Data movement/distribution - DTS, BCP, Custom app (AADB), and SQL Replication
- Database sizes ranged from 1 gig to 3 terabytes.
- Backup and disaster recovery
- User ID creation, access control to 134 servers around the world
- Supporting, debugging, and maintaining a global customized application written in C++ with embedded SQL to deliver data to 134 worldwide SQL servers and 2 OLAP servers
- Responsible for documentation and training in order to facilitate a smooth knowledge transfer of the application from the Sarasota development team to the Chicago support team
- The application contained multi-threads that communicated to another copies of the application on the target sites in order to deliver data
- Setting up scheduled tasks to run queries against tables that were created by the customized application to insure that the application is delivering the data accurately and efficiently
- Rewriting and maintaining a Web page written in HTML that monitored the customized application
- Created a number of stored procedures to find problems quickly in order to resolve them sometimes even before the local DBAs even realized there was a problem
- Created queries against certain tables to report financial data at the client’s request
- Setup views and stored procedures to report data to both the clients and DBAs triggered off a certain column within the table.
- VB front-end interfaces to generate SQL reports
- Solving local admin server problems that are prohibiting data delivery
- Analysis local admin. Queries to in sure accuracy in the data that is being produced
- Testing new data delivery tools that are currently on the market
Lead Data Conversions Programmer
Confidential, University Park, IL
Responsibilities:
- Mentored and Supervised 8 data conversions Programmers
- Write Programs to convert data from different systems in to a customized insurance application
- Maintain Programs and debug existing programs for merging and extracting data
- Document, debug and train new employees on a system that I am in charge of
