Steven Thelen Email & Phone Number

Nashville, Tn, Us

Temple Terrace, Fl, Us

Manage team of developers to handle all application development for web & desktop, reporting, database support/backup strategies and data interfaces• Hands on manager of 7 developers • Production DBA supporting all SQL databases: Over 50 DB servers, 200 DBs, 7 Terabytes DB Primary, 20 Terabytes Backup, etc• Ensures that database systems are operating at acceptable performance and availability levels• Responsible for backups, recovery, and disaster recovery processes • Manage DB growth and forecast space needs to ensure business continuity• Create, support, consolidate maintenance plans as needed to support business• Perform all logic and physical designs for Database servers.• Upgraded main 8 Terabyte data warehouse server to SQL 2012 with log shipping and replication. Also built 18 Terabyte backup server.• DBA for all SQL databases (2000, 2005, 2008 R2 and 2012), resolved database corruptions, fixed poor performing DBs and stabilized ETLs issues from average of 500 to less than 10 daily• Leveraged ERWIN to create data models• Used Solar Winds and SQL Monitor to ensure SQL was performing as desired.• Handle all data feeds to & from internal and external systems using various ETLs such as BizTalk (X12) , CorePoint (HL7), SSIS (XML, delimited file), .NET, etc• Responsible for Data Warehouse integrity, building new data feeds, support and performance• Assisted with UltiPro to Kronos (Self Service, Time Keeper and Payroll) implementation building ETLs, reporting and HR & Finance data warehouse reporting abilities with Crystal.• Accountable for new development and maintenance on all internal and external web sites.• Implemented BI360 for Budget (vs TM1) by architecting Snowflake schema & building ETLs • Project management: requirements gathering, design, analysis, detailed specifications, project estimates, automated TFS deployments to QA, detailed customer testing, change control, production deployments with rollback, monitoring, maintenance, etc

Tampa, Fl, Us

Built many enterprise web applications to sell to clients (Banks, Government, Attorney Firms, etc) along with iPhone and Droid products• Working manager of 6 developers focused on web site development and reporting analytics.• DBA for all SQL 2008 R2 environments, backups, stored procedures, indexes (clustered & non-clustered) and views• Architected all databases, tables and views for products developed• SQL regions: DEV (Developer), UAT (User Testing), DEMO (Sales), PROD (production)• Administered all database and domain control user access, setup web site DNS and SSL • Utilized SQL Profiler to analyze poor performing queries and created indexes where appropriate• Created many Access & SQL databases for applications and reporting• Hands-on manager that builds reports and web sites • Developed and modified web pages with ASP.NET, C#, XML, JavaScript, jQuery, VBScript• Created Web Bots to automatically pull foreclosure information from all the clerk sites (getting around captcha) and then digesting data based on attorney rules to triage case files to appropriate parties… Bank of America paid $6 Million for first year of this product.• Won a contract with Fidelity to build their REO eBay style bidding web site • Used Photoshop & Illustrator to design most images, templates and buttons used on web sites.• Built robust applications to reduce maintenance and emergencies as well as incorporated CMS for business admins to enhance web sites and update site access/roles/permissions as needed.• Developed SSIS processes to import & export files (XML, delimited files, etc) • Built VB.NET automators (such as email campaigns, daily to snap shot portfolio reporting, etc)

Phoenix, Arizona, Us

Coordinated management and maintenance of core Oracle, SQL Databases and Domains for all areas of hospital operation. Created data metrics utilizing trending for forecasting purposesBuilt VB scripts for automation of interfaces, file maintenance and ETL processesDBA for Oracle 10g & SQL (2000 & 2005) and database backups to SAN System maintenance, security, space allocation, data warehouse audits and performance tuningHandle Lawson financial system security access which houses employee salariesLeveraged CCL Scripting, Crystal, Access and Excel for advanced reporting

Responsible for LAN, network performance, user security, resolving computer Issues, management of data analytics, reporting and automationManaged Microsoft Exchange Server, network administration, network security accessDBA SQL 2000 & 2005 and created stored procedures and triggersBuilt SSRS reports for investor reporting and portfolio performance utilizing OLAPCreated advanced Excel reporting and graphsCreated ETL processes to support purchasing portfolios, servicing efforts & portfolio salesDeveloped tools to automate daily processesManaged project to convert from a legacy A/R system to a Web based platform

London, Gb

Managed development, design and implementation of data processes. Principle accountabilities include: data maintenance, process automation, forecasting and trending analytics on mortgage loans.GUI ApplicationsCreated many web sites to increase business efficiency and effectiveness (Reporting Web Site, Web automation via HTA do reduce manually processes, faxing application, etc)Built VBA program to assist business forecasting needs based on future pipeline volume Used Mainframe and PC SAS heavily for analyzing data (main reporting tool).Developed various programs for advanced reporting and graphical representations of data with Visual Basic, Crystal, HTML and CrystalDeveloped Employee Tracker used for reporting and securityImplemented documentation site containing business project specifications and their statusesProduced bar code scanning process to track certified mail sent to the customer AutomationStreamlined application process of Sub Prime portfolio data files to support purchasing portfolios of approximately $3 Billion per month.Presented upper management with weekly forecasting models to show data trends and future expected issues.Built JCL code to automate mainframe jobs versus a manual daily load Created bat and cmd files with PC SAS jobs to automate user reportingImplemented processes to send emails with attachments via SAS or VB applicationsDeveloped interface for scripting automation of pages utilizing JavaScript, VB Script and ASPCreated VB sweeper to pull in files FTP’d from the Mainframe and load them into SQL tablesDevelopment of tools to automate daily processesAccomplishmentsProfitable Growth Star, Key Performer, Exceeded Expectations on all Performance reviews