Sql Server Technical Support

JAMES HANEY JR.

************@*****.*** Phone: 708-***-****

Summary of Skillset:

●Senior Systems Analyst for the Cook County Sheriff Department 10+ Years of IT Experience With Microsoft SQL Server and BI Suite Maintained SQL Databases Containing Over 10 Million Criminal Arrest Records

●SQL Server Integration Services (SSIS) SQL 2008 Ad-Hoc Query Writing/Manipulation

●SQL Server Reporting Services (SSRS) System Testing, Data Validation, System Security

●SQL Server 2005 to SQL 2008 R2 Report Migration Help Desk & Technical Support Troubleshooting

●Flat File/ MS Access & Excel Data Extraction Data Architecture & Documentation

Professional Work Experience:

JHaney Inc, Chicago, IL January 2016 - Present

Information Technology Freelance Contractor

Client Projects

Database Management and Troubleshooting ETL SSIS Scheduled Jobs

Assessment of raw sample data loaded in a relational database

Building table structures, field population and SQL Ad-hoc query writing

Data Extraction to identify patterns and trends to be relayed to stakeholders for critical decisions

Working with Project Managers during Backup Recovery and Data Cleansing/Integration

MBI I.T. Services, Chicago, IL

Lead I.T. Support Field Technician

●Managing a team through the Diagnosing, Repair, Configuration and Delivery of installed desktops, notebooks and workstations

●Onsite Audit Reporting and Testing of Workstation Specialized Client Applications

●Hard Drive Disk Erasure and Removal of Obsolete Hardware

●Image Programming Creation and Management Volume Image Loading

●Hardware Staging and Warehousing with Asset Tagging

Cook County Sheriff Department, Chicago, IL Oct. 2005 - Dec. 2015

Senior Systems Analyst III

●Designed, Developed and Deployed routine and ad-hoc reports from multi-million-row databases using SQL, SSIS, SSRS, MS Access, Excel, and Visual Basic scripts for the second largest Sheriff's Department in the US.

●Ensure high availability to system and minimal downtime.

●Accountable for root cause analysis pertaining to all aspects of SQL Server.

●Ascertained actionable intelligence on emerging criminal patterns, trends and activities under tight deadlines.

●Implemented and analyzed daily reports that accounted for the housing roster of 10,000+ inmates.

●Responsible for working with clients to pull ad hoc reports (clients included: Chicago Tribune, University of Chicago, and several law firms.)

●Set Up of Disaster Recovery process.

●Accountable for SQL Server performance.

●Worked on custom ASP.net dashboard interface developed directly for the Sheriff regarding internal jail population.

JAMES HANEY JR. Page 2

Professional Work Experience, Cont.

●Responsible for user support of other team members, responded to ad hoc query requests, performance issues, mentoring and overall system support.

●Awarded commendations from universities and publications for completed FOIA report requests

●Assisted investigators with suspect leads through investigative research resulting in countless arrests and case clearances.

●Compiled analysis of non-violent inmates for alternative housing thus saving millions in tax money.

●Customized applications and designed/monitored database solutions for organization.

Junior Systems Analyst II, Chicago, IL Oct. 2005 - Dec. 2010

●Wrote and automated scripts to increase departmental efficiency and automate Stored Procedures.

●Interacted and communicated with colleagues as needed as both a technical and functional expert.

●Utilized excellent written and verbal communication skills and ability to translate Technical Concepts/Requirements into Business Language.

●Maintained portions of the Cook County Sheriff's external website responsible for detailing weekly analysis of significant arrests, court appearances and serial violent offenders.

●Responded to 100+ calls daily providing customer service to inquiries regarding jail visitation policies.

●Collaborated with project managers, executive staff and outside law enforcement agencies to gather data and present strategic analysis addressing on-going crime problems.

●Tested, cleaned and standardized incoming data to meet business and management standards for data warehousing.

Education:

Oakland University, Rochester, MI - Bachelor of Science, Management Information Systems, 2004

Contact this candidate