We provide IT Staff Augmentation Services!

System Database Analysts Resume Profile

3.00/5 (Submit Your Rating)

SUMMARY OF QUALIFICATIONS

  • 20 Years IT Experience working the last 12 years with ASP.Net C and SQL Database Development and Administration.
  • Extensive hands - on experience in system and network management installation maintenance administration security troubleshooting training and technical support.
  • In-depth knowledge of network technologies architectures and platforms with the ability to apply them to the strategic benefit of organizations.
  • Proven ability to successfully streamline optimize and maintain system/network functionality performance and recoverability in mission-critical environments.
  • Adept at working with management to prioritize activities and achieve defined project objectives able to effectively translate operational/network requirements into technical solutions.

Technical Skills

Desktop Operating Systems Microsoft Windows XP Pro/Home 32/64bit Windows 7 32/64 Home Home Premium Business Windows 2000 Windows NT Windows 9x 95/98/ME CICS DOS/VSE VTAM

Software Word Excel Outlook PowerPoint Access/Project Visio Adobe Acrobat / Photoshop / Illustrator GoToMyPC VNC VPN Client Symantec Antivirus Ghost MacAfee Antivirus Anti Spyware SQL Server Management Studio SQL Configuration Management MVS/TSO/ISPF CA-Scheduler Zeke Knowledge of Oracle Database and DB2

Server Operating Systems Microsoft Windows R2 2012 Server NT 4.0

Server Applications Active Directory SQL DB DB2 File and Print Services Terminal Services

Wired Networking LAN/WAN Switches Routers Bridges Firewalls Modems Network Printers and Scanners

Network Protocols TCP/IP DNS FTP TFTP Telnet Ping HTTP HTTPS RDP SOAP

Professional Experience

System database Analysts

Confidential

  • Developed email notification web service using BIDS 2008 SSIS
  • Automated Inventory Forms Order Process with SQL stored procedure and SSIS 2008 package.
  • Processed daily weekly and monthly Mass Merge Mailing SSIS 2008 Production Packages.
  • Created SQL SSIS and SSRS reporting database and automated the reporting process using SSIS 2008.
  • Converted SSIS 2000 packages to SSIS 2008 packages and updated all outdated stored procedures.
  • Assist Account manages with daily excel spreadsheet extractions for download and uploads.
  • Preformed weekly database backups.

Database administrator

Confidential

  • Installation and Implementation of SQL Server 2008R2 2012 and both Server updates.
  • Use ASP.Net C and BIDS to create dash board for Automated Reports Generation.
  • Designed Analyze and test new versions of the Client/Passenger Relational DBMS.
  • Program script and API for Database Tables and Table Nominalization for Client Databases.
  • Created and Design SQL SSRS SSIS and SSAS Crystal Financial Reporting System.
  • Assign access permissions roles and privileges to client SQL Database.
  • Import/Convert Access database and excel spread sheet to SQL Database Tables.
  • Ensured that storage archiving back-up and recovery procedures are functioning correctly
  • Monitored performance and managed parameters to provide fast query responses

web/database developer

Confidential

Guided Lead Developer with Single Sign-On development for Zachys website.

  • Developed C .Net Active Directory Application to create New User Profile.
  • Developed several SAP Crystal Cube SSRS Reports for Inventory and Invoicing.
  • SQL 2008R2 Database backup recovery and data analyst using OLAP SQL profiler.
  • Trouble shoot bottle neck issues on Zachys web site for retail auction and storage.
  • Maintain internal IT helpdesk for several companies.
  • Responsible for importing of access and excel flat file to SQL DB for weekly cost report distribution.
  • Program and Process DB2 Production jobs for billing department.
  • Programmed stored procedures triggers to create customers statements.
  • All Development done within the Microsoft Visual Studio ASP.Net 2010 SQL 2008

ASSISTANT DEVELOPER

Confidential

  • Developed Client Statement SSRS RTE web reporting service using SQL 2008R2.
  • Developed SharePoint Reporting Service with 50 trea byte of data source.
  • Development of SharePoint 2010 Imaging Dental Application
  • Developed QB SQL applications for system interrogations using Visual Studio C
  • Process and Monitor DB2 Production Jobs for report distribution.
  • Trouble shooting Client database for bottle neck processing via OLAP.
  • Developed .Net Web form Invoicing Application using C
  • Automated Billing system with .Net win web form Application using C .
  • Developed and Design SQL database C Stored Procedures and triggers.
  • All Development done within Microsoft Visual Studio ASP.NET 2010 C T- SQL environment.

DATABASE ADMINISTRATOR/DEVELOPER

Confidential

  • Database error handling and performance tuning process DB2 production Jobs.
  • Create Update Dept. database via SQL Query Analyzer Enterprise Manager.
  • Designed logical physical databases for RDMS SSRS Crystal reporting.
  • Developed ETL SSRS and SQL Cube reports for product inventory.
  • Created Index tuning using clustered and covered indexing preformed all DB backups.
  • Programmed stored procedures scripts and triggers for reporting services using C and C .
  • Documentation for installation of all new SQL Server 2005/2008 DB apps.
  • All work done within a SQL 2005/2008 Database environment.

ASP.NET C PROGRAMMER

Confidential

  • Perform testing of New Apps created with SQL server2000
  • OOP coding and Implementation of new programs in C C .
  • Maintain dept. data warehouse via SQL 2005 Server Manager.
  • Developed New Web form Win form applications for P.O.S. posting using C .
  • HTML XML code modifications.
  • Created Crystal and cube Reports for Dep. Head using ASP.Net and BI in C
  • Created weekly and Monthly SSRS report based on Child Support System.
  • All programming work done in Visual Studio ASP.Net 3.0/3.5 environment in C .

DATACENTER SUPERVISOR

Confidential

  • Troubleshooting and resolving JCL abends.
  • Responsible for daily FTP downloads and uploads.
  • Constant communications with Tech managers and programmers.
  • Approve Assign Process all Productions Change Management forms.
  • Responsible for production ETL Repots.
  • Using TSO/ISPF SDSF sub modifying rerunning batch production jobs
  • Maintain Monitor DNS connection log error in shift turnover.
  • Document follow up all shift incidents via Remedy worked IT Helpdesk.
  • Primary Tester for all production report/data services for clients.
  • Supervise a total of 3 production analyst 8 computer operators.
  • All performed within an MVS/ESA/CICS OS390 environment.

PROJECT MANAGER

Confidential

  • Responsible for scheduling clients files for weekly and monthly updates
  • Troubleshooting and resolving JCL abends on VSE MVS.
  • Responsible for daily FTP from St. Paul to New York with MVS remote system.
  • Actively participated in production job stream set-up on MVS VSE
  • Supervise conversion dept. on execution and controlling batch jobs on MVS VSE
  • Responsible for allocating copying moving and renaming production data sets
  • Using TSO/ISPF sub modifying rerunning and deleting batch production jobs
  • Coordinated all remote production projects from St. Paul New York in LAN WAN
  • Network environment.
  • All task perform within an MVS DOS/VSE/CICS OS390 environment

We'd love your feedback!