Joe Dale Email & Phone Number

Eden Prairie , Mn, Us

Franklin, Tn, Us

Nashville, Tn, Us

Phoenix, Arizona, Us

Automation of incoming medical transactions.Developed new architecture and pipelines for such (SSIS and MSSQL - with views and synonym usage)Led off-shore development for reporting and QAReview of incoming database code into the production/UAT environment.QA of client facing transaction results working with Client Services

While furthering education started Decision Support Services as a side business. Technical consulting to Hollywall – digital rights with artist focus – DDEX standards in application, MusicBrainz, datacenter integration, application design. Internet Resale.---------------------------------------General notes concerning entire career: Have always believed in transparency and open lines in the way I operate, being a team player and a solution seeker.

Nashville, Tennessee, Us

Led development and analytics for worldwide P&C management serving near ¼ billion subscribers. Multiple tools for data pulls and presentation• SSIS and C# core• IIS for presentation w advanced graphics• PowerShell with modules--> PowerCLI for VmWare - cluster and node level data with over/under utilization levels--> UCS PowerTool - core platform (Unified Computing Systems) - compute, memory, IO, DR status--> EMC Cmdlets - exmaination of storage performance and growth incl. common blocks• Rest interfaces for --> OpNet - app performance incl. TIBCO--> SolarWinds - dataCenter monitoring - power, racks, servers, network--> Splunk - analysis and sumation of Web Log data• PL/SQL- data pull of Orion network SAN/WAN P&C usage from back-end oracle• MySQL - pull linux performance and error data from Nagios• Groovy (loosely typed Java) - pull Database (Oracle and MSSQL) P&C info from Foglight• t-sql - for MSSQL stored data--> most Business data - call volume, call wait, CSR counts, phones shipped ...--> server Inventory from CA eHealth and Spectrum--> telecom P&C data--> core P&C storagePerformed multiple analysis w results on portal• Project resoures and response for surges and new projects• Cross check network and server circuit - deltas both sides• Overall datacenter resources - virualized main and satelitte--> right sizing--> use of existing resources vs new--> proto resource reservation system• Project requirements for new Soluto product line--> utilze Azure and AWSInterface for multiple concerns• Led 4 member off-shore team• Tech interface with other IT teams • Work with solution architects• Daily readiness meeting w management & other IT teams• Requirements gathering from Stakeholders• Special project collaborations• Critical IncidentsPCM Portal• In-house IIS application (offShore dev)• cross reference P&C w business data• Geo and business sections with transparent security~ 40% dev, 30% specs/presentation, 30% interaction

Nashville, Tennessee, Us

Oversaw development of ETL solutions enterprise wide• Extensively utilized SSIS, C#, MSSQL• National and International clients including Verizon, AT&T, T-Mobile, Korea Telecom and Sprint--> Interface with technical client teams--> Interface with internal Asurion Stakeholders - Marketing, Fraud, Call Center, Dev, Legal • Implemented new clients and multiple client mergers affecting data feeds and operation--> Enrollment and Eligibility Processing--> Claim processing support--> Carrier to Asurion links providing phone activation, white, gray and blacklisting--> Client Correspondence - automated letters and telephone message updatesData Warehouse - Install and Implement - Schema Design and Aggregation Population• utilized Greenplum (Terradata competitor) with PostgreSQL primarily some MSSQL OLAP• Enrollments, Claims, Call Center, CIRTS, Fraud• OLAP and standard OLTP type design with historical savesOff-shore team(5) integration with core Asurion staff(6) Development of ACH system to providers of roadside services for quick payment turnaroundImplement new technologies - Inter-company internet APIs, IBM Data Stage, Greenplum, PostgreSQLContinuing internal merger (Lockline) consolidation

Nashville, Tennessee, Us

Became MCPIT certificed for MSSQL.Transition was to fill immediate need of not allowing inefficient/poor SQL code to enter into our production systems which had become a priority problem - setup standards to follow, worked with code development teams on front-end regarding design (particularly under load) and implementation.• This resulted in reduction of CIRTs (Critical Incidents) and subsequent rollbacks. Analyst on multiple solutions including database design and logic implementation. Reviewed/optimized incoming stored procures/code to be placed into production. Developed guidelines for corporate wide database development. Additionally turned servers - particularly MSSQL Enterprise 64 CPU server finding best parallelism (with modification) for heavily used procedures.

Nashville, Tennessee, Us

MSSQL, DAX, Sagent, VB, C#, FileNetStarted off in 2003 working Contract for Hire at Asurion and quickly went full time. Involved in the rewrite of their existing enrollment system with Verizon being the primary client at the time. Some pieces where still in place up to the time I left. Also transtitioned thier RoadSide Assistance package to MSSQL working closely with Asurion's Houston devlopment team.After initial work on enrollments system started working with DAX team (CRM package) in major modification (pushing up to 30K phones a day through an assembly process line). There implemented, for our financial department, what was referenced as 3 dimensional accounting - basically added an additional cost break level (across company unit) and generated a new shipping system unlinking the hard ties with UPS. Also solved days old problem that had line running at 1/5 capacity. Was at times responsible for operational overview/support (read on-call) of these systems.Came back to ETL/enrollment as senior developer. Assisted in adding several additional telecoms in addition to managing the feed changes caused by multiple mergers and some splits that were happening in telecom at the time. Most ETL work performed in Sagent with MSSQL back-end (SPs) in addition to secure front-ends (FileNet ...) . Solely wrote first international enrollment system for Korea's KTF - vastly different from existing systems. Many projects in this realm due to constant enhancement request from clients and addition of remainder of the big 4 wireless telecoms, international telecoms and many regionals (each a somewhat different implementation). During this phase of my time with Asurion our department's systems expanded from just being enrollment processing to additionally handing most technical transfers between Asurion and our customers (the major telecoms). With all these systems dealt directly with customer technical teams for smooth implementation.

Oracle 7 DBA/developer (PLSQL), PowerBuilder, MSSQL, Bourne Shell, VB, MS BatchAt Wright started off writing Shell scripts for Sun OS4.1 (Solaris) combined with linux DBA and developer responsibilities with Oracle 7. Later utilized PowerBuilder, DataArchitect and MSSQL to develop PR2PO. A system starting in AutoCad and moving through to PO requisition. Basically allowed Mechanical and Electrical Engineers to created a Bill of Material (for generation of customer one off assembly lines - HP ink jet, Gillette Mach III, golf clubs, diapers, Li Ion batteries, defense ...) and from CAD BOM order parts required - properly approved, timed, ordered and marked for placement in production while covering exceptions. Also developed several general/OS automatons to assist production.

Harvard Extension Graduate Certification, Datascience

Postgrad Certificate, Data Science

Bs, Electrical Engineering