Database Administrator/SSRS Report Writer Resume

PROFESSIONAL EXPERIENCE

Confidential

Database Administrator/SSRS Report Writer

Maintain all database servers
Assist upper management in queries and BI functions
Write SSRS reports to facilitate needs of company
Write database logic for Bid Tool application
Write database logic for Supply Chain tool
Designed and wrote C# code for ETL of TMS Cloud application data so that the data can be in - house and available for queries.
Designed SSIS package and Small Parcel Re-Billing application
Involved in Customer facing strategic data projects
Currently building C-Level reporting with MS PowerBI

Confidential, Rocky Mount, NC

Database Administrator/Senior System Administrator

Installed Microsoft Dynamics AX (Axapta), ver. 3.0 and 2009
Database maintenance for 24 instances, backups, jobs, performance, capacity planning
SQL DBA and BI Reporting (SSRS, SSAS, SSIS, T-SQL, normalization)
Designed Reporting solution on SSRS in SQL 2005 and later migrated to SQL 2008R2
SQL performance tuning, missing indexes and index defragmentation
Data integration of Payroll, Time and Attendance, Shipping and ERP into Reporting system.
SQL 2008 SSRS, Cube Design and Sharepoint 2010 with Excel Services, Workflows and Infopath Forms, data replication and integration
Lite work with VB.net and ASP in Visual Studio
SQL Data Mart and Data Warehouse design and implementation
Juniper Network replacement, MDF and 9 IDFs, fiber connected
Shoretel VoIP phone system implementation, 320+ handsets, two locations

Independent Contractor

Installed SCO Office Mail Server on SCO Linux Server 4.0 at Walker Paint Company, engineered LAN, connected via DSL to Internet, building Company website.
Installed Exchange 2000 and all Outlook clients at Euromatics Plastics. Installed terminal services.
Installed Exchange 2000 and all Outlook Clients at Region L Council of Governments.
Installed ISA server and Exchange 2000 at DSM Software.
Installed Exchange 2000, Enterprise Instant Messaging, Netscape Fast Track, Apache and IIS5 HTTP Servers behind the firewall, and SQL 2000 and MQ Series at Interflex Technologies.
Installed various Zyxel firewalls and VPN concentrators

Confidential, Durham, NC

Unix//WinNT Administrator /AVVID/Unity/ICD

Implementation and administration of a centralized Cisco AVVID system containing one CallManager cluster, unified Unity voicemail system, Cisco ICD contact center for 25 agents, Cisco Productivity Services server, 4 remote locations utilizing SRST and 350 IP phones.
Day to day maintenance of all IPT related products and users.
Monitoring and maintenance of all network hardware using Cisco Works, MRTG, ART, CallManager Serviceability Tool, sniffers and analyzers
Maintain dual Cisco Pix, VPN Gateway and 7 separate switch clusters,
Top level of support for all network related issues
Migrated SCO OSR5 to UnixWare 7 on 5 production servers
Shell Scripting and programming, Perl scripting, CGI programming
Web design, http server administration; developed company Intranet site
Auto scripted data transfer of second reporting intranet using FTP and rcp for automation and convenience in lieu of using MQ Series or other ETL application
Wrote over 220 Unix scripts for daily automation and threshold notification
Support production application (PDI/RMS) for 600+ convenience stores
Developed IT Policy/Procedure manual and enterprise documentation set
Co-developed Disaster Recovery plan
DHCP, WINS, DNS, SMB, and Proxy implementation and maintenance
Network troubleshooting, maintenance, capacity planning and documentation
Assisted all departments in acquisitions regarding capacity planning, connectivity, uptime, feasibility and new service at acquired remote sites
Trained/Mentored Help Desk Personnel