SQL Server DBA Resume Overland Park, KS - Hire IT People

SUMMARY:

TECHNICAL SKILLS:

C#, Java/JSP/Java Script, MS Access

WORK EXPERIENCE:

SQL Server DBA

Confidential, Overland Park, KS

Responsibilities:

Project lead in creation of stand - alone SQL Server environment for Fraud and Payment Operations departments
Responsible for design and development of Fraud and Payment Operations data warehouse including data mapping, table/index design and creation ETL processes via SSIS
Automated replication of Oracle tables from various Confidential systems including Nextel Data
Warehouse (billing system), Point of Sale, Confidential .com and Prepaid (Virgin and BOOST mobile)
Automated load of Confidential 's web log files that either required XML or regular expression parsing
Improved speed and efficiency of data loads and data purges by creating table partitions and implementing sliding window scenario
Created a managed picklist process for users to be able to send data from SQL Server to a dedicated Oracle table in the billing system
Integrated WinSCP SFTP tool into SQL Server environment by implementing WinSCP's C# libraries through CLR giving users ability to SFTP via a stored procedure call
Created customer impacting automated processes in SQL Server that helped reduce head count
(Equipment Refunds, High Risk Payment Management, Financial Information Removal)
Gathered reporting requirements and created SSRS reports

Application Developer

Confidential, Overland Park, KS

Responsibilities:

Created an automated confirmation text message notification process for Confidential Payments using
Created an automated process to keep credit card auto-pay information up to date improving auto-pay payment decline rate, saving Confidential annually.
Developed department wide employee productivity tracking process helping management set performance benchmarks, better understand process workloads and identify opportunities for productivity improvement
Created JSP application in support of productivity tracking process to collect employee productivity data through web entry for those processes that could not be systematically tracked
Created JSP payment search improving efficiency of payment investigation process
Was responsible for transferring credit card and bank account information during billing system migration

Reporting Analyst

Confidential, Overland, KS

Responsibilities:

Gathered report requirements from various groups in Payment Operations and used extensive knowledge of Confidential Oracle systems to provide additional input to get the most value from available data
Worked with accounting department to create automated reporting to be used on Confidential 's general ledger
Worked with reconciliations team to create automated reporting to identify payments made through lockbox and retail stores that did not end up in the billing system
Eliminated manually generated reports by migrating SQL to Crystal server environment improving efficiency and report availability
Supported 70 automated daily, monthly weekly reports and was the point of contact for adhoc report requests
Compiled presentation decks on Payment Operations metrics for executives using Excel and Power Point
Created reports pertaining to payments, refunds, credit card chargebacks, check returns and SLA metrics