Data Analyst Resume Commack, NY - Hire IT People

SUMMARY

Experience wif Database Administration in SQL Server 2012 and prior
Knowledge of SSIS, SSRS and Database Concepts
Experience wif report writing tools (MS Visual Studio (SSDT), MS SQL Server, Transact - SQL, MS SQL Reporting Services(SSRS) and SQL Server Integration Services(SSIS)
Modeled Data using MS Access, Excel, and SQL as Analytical Tools
Knowledge of Server Administration - Directory Services, Data, and Network Administration

PROFESSIONAL EXPERIENCE

Confidential, Commack, NY

Data Analyst

Responsibilities:

Responsible for the development and management of several SQL databases and their file structure, associated tables, views, functions and procedures.
Created Quarterly Business Reviews (QBR) reports using SQL Server procedures, Excel developer macros, formulas, Pivot tables and charts. Optimized, increasing detail and accuracy in all aspects of the report.
Collaborated wif management, leasing and contracts personnel in designing, implementing, documenting, and maintaining a Lease Reconciliation Process.
Created numerous internal applications for the leadership and key internal departments to reduce man hours and accuracy of financial reporting tools.
Analyzed and tested systems. Provided on-site support and training for new users.
Documented all processes to establish a baseline for developmental improvements of future workflows. Analyzes, recommends and assists wif implementing new and improved processes and workflows.
Exceeded expectations in processing all requests. Reduced request time for QBR from 5 days to 1 hour. Increased number of QBR requests from 50 to 200 monthly.

Confidential, Mineola, NY

Data Analyst

Responsibilities:

Responsible for the daily management and performance of all databases (SQL and MS Access), their file structure, associated tables, views, and queries associated wif Confidential programs.
Collaborated wif management, case manager and construction personnel in designing, implementing and maintaining production caseload systems. Assists in the development of design specifications in support of new or modified caseload applications, regulatory requirements, and best practices.
Documented current processes to establish a baseline for developmental improvements of future workflows. Analyzes, recommends and assists wif implementing new and improved processes and workflows.
Participated in interdisciplinary and process improvement teams to identify potential uses of the information systems and potential optimization of current use of systems. Supported the integration and use of evidence-based methods, tools, and guidelines linked to TEMPeffective outcomes.

Confidential

System Analyst / Developer

Responsibilities:

Lead three person team from Novell to Active Directory conversion
Designed and developed SQL servers for 10 different SQL application programs
Worked wif System and Security Engineers to develop secure Active Directory OU
Implemented Security, Automation, Performance Tuning, Query Optimization on required file servers and networking of systems
Facilitated secure and confidential sharing of data between databases and university
Rebuilt 50 SSIS jobs using Visual Studio (SSDT) to support secure information transfers
Worked extensively wif vendors and to ensure applications had the latest upgrades and to test, troubleshoot and resolve all issues wif 17 departments prior to deployment while maintaining existing databases and applications
Created and maintained secure web sites, ensuring all critical data was secure
Installed and troubleshoot client based software on individual computers
Created Emergency Backup Contingency Plan to fully backup and restore databases
Documented all troubleshooting procedures, listing possible issues and expected results
Wrote and troubleshot numerous SQL codes wifin the database design and implementation
Performed daily checks and services on all servers and reported any issues

Confidential

Service Desk Manager

Responsibilities:

Supported over 3000 users at 100 sites throughout New York City and Long Island
Managed day to day operations of 6 personnel and customer service requests
Acted as senior liaison wif New York City and State agencies to establish individual accounts and provide support wif mission critical software (Connections, CCRS, Promis, CARES, LTS)

Confidential, Port Washington, NY

System Support Specialist

Responsibilities:

Responsible for Level 2 technical support for proprietary software for Point Of Sales (POS) registers

Confidential, Lake Success, NY

IT Manager / Network Administrator

Responsibilities:

Confidential

Network Administrator / Help Desk

Responsibilities:

Downsizing and elimination of the MIS department and operations were the main responsibilities