Data Management

Scott M Neth

ColdFusion Developer

Portland, OR

*********@*****.*** - 206-***-****

ColdFusion and SQL developer

WORK EXPERIENCE

Data Analyst III

Northwest Permanente - Portland, OR - November 2014 to Present Responsibilities

Develop web applications for HEDIS measures.

Epic Clarity data analysis using SAS, Oracle, and Terradata. In collaboration with KPIT and business clients define, design, document and build domain level information marts for purposes of supporting end user reporting and consistent business rule definitions. Defines meta data structures for information repository and performs model management. Develops data definitions consistent with data management standards and conventions. Documents and maintains information and data needs commensurate with standard documentation protocols. Maintains content and documentation of current data marts. Maintains and monitors quality of data into and out of data marts. Populates information repository and deploys updates. Collaborates with physical database designers to develop alternative solutions for meeting complex and conflicting requirements.

Develops data definitions consistent with data management standards and conventions. Participates in model integration and convergence activities. Develop applications that combine data from existing sources, tailored to specific user groups and business needs. Work with key system users to identify user requirements and continuously improve their ability to access information easily and efficiently. Ensure consistency with established data and application standards. Design and develop automated actionable reports to inform managers in a timely fashion. Conduct analysis and make recommendations to business unit based on findings of analysis. ColdFusion Web Development Manager/Sr. ColdFusion Developer/MySQL DBA ECConnect - Seattle, WA - January 2013 to May 2014 Responsibilities

Leading a team of ColdFusion developers, Systems Administrators, and MySQL DBA's. Establishing, planning, and administering the overall policies and goals for the information technology department. Analyzing the needs of ECConnect's clients and determining ways to meet business objectives by modifying existing or developing new information processing systems. Leading and directing the staff of a small telecom startup. Report to the CEO

Sr. ColdFusion Consultant

Self Employed - November 2009 to December 2012

Clients included IBM, AT&T, Wayport, Senior Market Sales, and CenturyLink. ColdFusion development and administration. SSIS and SSRS report development from MS SQL Server 2008 and MS SQL Server 2005. Oracle data mining. ColdFusion MX7 and MX8 development. Providing middleware application support hands on technical expertise in implementing projects using various Middleware products. Specific responsibilities for administration include ColdFusion on Solaris Adobe JRUN on Solaris Adobe JRUN administration.

Develop ColdFusion web business tools for agent customers of an Insurance Management Organization and consumer facing website for Medicare Supplemental insurance, Medicare Advantage, Medicare Part D, and annuities.

Sr. Applications Analyst (Systems Analyst III - Technical Lead) UT Systems/MD Anderson Cancer Research Center - Houston, TX - June 2007 to November 2009 Took leadership of a project that was unfunded and relied on outdated and unsupported software - was able to achieve success by bringing together the skill sets of several departments Supervisor of staff of 5 overseeing ECRT Effort Certification. Manage 2 Systems Analysts, 2 Principal Applications Systems Architects, and 1 DBA for ECRT effort certification software for 8 academic institutions and 6 health science centers/medical schools/research institutes. Also technical lead (and some development work) for PCE (Patient Charge Estimate) web application and operational informatics training website. Technical Lead for ECRT - Electronic (Grant) Certification Reporting Tools. System admin of Jakarta- Tomcat server running Linux. Providing 24/7 support to mission critical application. Overseeing and managing program for entire UT Systems (15 Univ. of Texas research institutions). Providing analysis of business and management problems in terms of system and user-department requirements. Consulting with departmental personnel for problem definition and management requirements. Analyzing source documents, data base structures and management report requirements. Coordinating systems improvements between Information Systems and user departments and provides necessary documentation and consultation for implementation of systems. Provide supervision and training for Programmer Analysts. Create and implement automated tasks to reduce workload of analysts.

Maintenance and enhancement of PCE's (Patient Charge Estimates) ColdFusion business logic and Flex presentation layer which decreased patient intake time from 6 days to 6 hours. Used MVC object oriented architecture for creation of ColdFusion backend layer. Conceptualization, requirements gathering, design, development and maintenance of a ColdFusion MX training website, a website for doctor re-credentialing, and sites for various oncology researchers and doctors to pull research data related to health informatics. Also creating tables, stored procedures, views, etc. for MS SQL and Oracle 9i databases; writing webservices for database pulls, and webservices for LDAP authentication. Creation of SharePoint site portals and design/development of SharePoint tools. https://ecrt.mdanderson.org/ecrt_mdacc/

ColdFusion Consultant

Self Employed - December 2005 to June 2007

Clients included Nebraska Department of Labor, Farm Bureau Insurance, and Experian. Rewriting unemployment tax collection site (UI Connect) for the State of Nebraska to enable UIConnect to run on a ColdFusion MX platform.

Design and development of an electronic payment system in conjunction with JP Morgan Chase for Farm Bureau Insurance.

Creation and delivery of real time marketing leads and inventory data analysis for Experian ColdFusion Developer

SBC/AT&T - San Antonio, TX - April 2002 to December 2005 Conceptualization, requirements gathering, design and development of an integrated ordering tool for service reps to provision small business phone and data services which save $45,000 in overtime costs through time savings of the service reps.

Responsible for maintaining 99.5% availability on SunONE Web Server 6.1 and JRUN 4.0 running 10 instances of ColdFusion MX running on a LINUX AS 2.1. Also DBA of MS SQL 2000 Server on NT OS. Responsibilities included ColdFusion code development of website, including ordering and reporting tools. Coding of SQL required for ColdFusion pages; stored procedures, views, triggers, DTS, etc. for reports and other uses. Validation of authorized users and maintaining users records in LDAP. Manager over file clerk. Technical writing and editing of content final approval of all content placed on the site. Other duties included setting up VPN systems for Authorized Sales Representatives and maintaining and updating national "do not call" lists. https://acsw.sbc.com

Technical Writer/Project Coordinator

SBC (now AT&T) - San Antonio, TX - October 2001 to March 2002 Coordinate and analyze field data for engineering conversion of ASI's REMDY inventory coding to standardized HECI codes. Mapping of BBO/DSLAM sites and physical structures of buildings. Technical writing of document packets used by engineers for conversion of REMDY codes to HESSI codes. Designing and developing packets for engineering conversion. Developing and Writing Training Manuals for field representatives. ASI inventory assessment.

Transitioned into ColdFusion developer job from this position. Adjunct Professor

University of Nebraska, Omaha and Kearney - Kearney, NE - July 1998 to August 2001 Developed and taught writing classes. Served as advisor for class scheduling. Served on Interim Composition Committee.

EDUCATION

Master of Arts in English

University of Nebraska

Bachelor of Arts in Biopsychology

Hastings College

SKILLS

ColdFusion, t-SQL, PL/SQL, SharePoint Administration, Linux, SSIS/SSRS, MVC/FuseBox/Mach ii

Contact this candidate