Steven Ashley Email & Phone Number

Lee'S Summit, Mo, Us

Andover, Ma, Us

Tools: CCL, DA2, FTP, Shell, Discern Visual Explorer, OpsView SchedulerSecurity: Public Trust Government Security Clearance (2019), Security + Cert.Developed Extract/Reports for multiple client hospitals in the Community Works environment.Mentored VA Reporting groups on creation of efficient CCL Extracts and Reports by creating template views of the following aspects of the Cerner Millennium/Revenue Cycle data model.• Patient Accounting• Charge Services• Orders/Event Management• Scheduling• Emergency• Laboratory• Pharmacy• Radiology• Registration• SurgeryCreated custom CCL/DA2 reports as needed for clients.

Tasked with converting ASP Classic websites to ASP.NET, as well as the day to day maintenance/changes of the production (ASP Classic/ ASP.Net) versions. • Communicated directly with marketing department to design, build and test requested changes to existing processes using approved SDLC/ITIL methods• Designed and Implemented Marketing Analytics processes needed to improve corporate marketing performance.• Oversaw multiple releases of requested changes to existing website functionality• Redesigned existing ASP classic processes for ASP.NET, JavaScript, VB.NET, C#.NET• Installed and Implemented IIS 6.0• Implemented interfaces to/from external 3rd party partners using SFTP.

Plano, Texas, Us

Tools: CCL, DA2, FTP, Shell, Discern Visual Explorer, OpsView SchedulerTaught/Mentored Hospital Programming staff on creation of efficient CCL Extracts and Reports Architected:• Interface from Cerner Millennium to Crowe• Interface from Cerner Millennium to Press Ganey• Interface from Cerner Millennium to Pathology Associates• Interface from Cerner Millennium to Strata Decision• Report (Code) Masters for Cerner Millennium• Patient Clinical Summary ReportingProjects touched the following aspects of the Cerner Millennium/Revenue Cycle data model.• Emergency• Charge Services• Laboratory• Orders/Event Management• Patient Accounting• Pharmacy• Radiology• Registration• Scheduling• Surgery

Architected:• Interface from Cerner Millennium to Kaufman Hall Axiom• Custom Changes (tokens) to Rev Cycle coding queues to allow coder specialization by physician• Interface from Cerner Millennium to Press Ganey• Interface from Cerner Millennium to Wealth Engine• Interface from Cerner Millennium to Season Hospice• Interface from Cerner Millennium to Relay Health• Interface from Cerner Millennium to Macro Helix• Government (State) Mandated Reports (Patient Accounting, Medicare/Medicaid)Projects touched the following aspects of the Cerner Millennium/Revenue Cycle data model.• Emergency• Charge Services• Laboratory• Orders/Event Management• Patient Accounting• Pharmacy• Radiology• Registration• Scheduling• Surgery

Kansas City, Missouri, Us

Software Architect specializing in creation of custom reports and extracts using Bedrock, CCL, SQL and JavaScript in Cerner’s Revenue Cycle and custom CCL groups. • Fluent in Revenue Cycle process from Patient Access & Registration to A/R Follow-up and Collections• Redesign of Patient Accounting to MedAssets Interface resulting in a drop of data issues from 60 per month to 2 per month while increasing installed sites from 20 to 35. • Architected CCL extracts of Patient Accounting (GL) information to PeopleSoft. • Architected CCL extracts of Charge Services (CDM) information to MedAssets.• Designed and coded custom reports to satisfy gaps in Patient accounting standard reporting. • Designed and coded multiple data base audits to identify process and data issues using Bedrock. • Managed Cerner to MedAssets Interface Implementations.• Monitored Ops Jobs and financial system interfaces. • Wrote Unix/CCL based scripts to automate file transfers via SFTP. • Experience setting up automated jobs via opsviewscheduler in Cerner. • Lean Software Development implemented with JIRA and KANBAN. • Strong written and verbal communication skills (internal & external) • Used Subversion and TortoiseSVN for version control and package development• Deployed compiled source packages from Windows to Unix/Linux Backends• Mentor junior associates • Collaborate with other internal and external teams as needed • Perform additional duties as requiredCerner Data Model Experience• Patient Accounting• Charge Services• Interfaces• Laboratory• Orders Management• Pharmacy• Radiology• Registration• Scheduling

Washington, Dc, Us

As a senior level consultant for JMA, provided tier-2 support (Systems Administrator / DBA), for the SNCC (System Network Control Center). Troubleshooting problems for 3 ITIL compliant enterprise data centers (KC, STL and DC) on a variety of applications and platforms and databases. • Role resulted in significant reduction (~75%) in off hours call outs/overtime of System Administration and Database Administration staff. • Developed Access based doc tracking system to manage (email) contracts and documentation required to implement NITC data (private) cloud, resulting in increased accuracy and efficiency by support staff by eliminating need to scan in documents.• Analyze events and issues, determine accuracy, importance and relevance in a 24x7 enterprise data center. • Managed UNIX and Windows systems both real and virtual (VMWare/VSphere).• Relates system status information to clients while taking into account both political sensitivity and audience of that information. • Certified both mainframe and midrange systems after releases. • Participated in periodic disaster recovery/failover exercises.• Developed Remedy certification package (test cases).

Detroit, Mi, Us

• Dealt directly with c-level managers on project scope and status.• Met with client teams to design reporting solution, gathered goals, targets and metrics.• Creating Statement of Work documenting project plan, targets, metrics and key players,• Installed and configured Windows 2003/2008 and Linux (LAMP) servers, CITRIX probes. • Installed, configured (security, backup/recovery), monitored, tuned SQL Server 2005/2008 • Used Compuware scheduling and deployment tools (System Manager/Testpartner) to deploy and schedule applications and custom automation scripts at remote locations. • Analyzed network configuration and performance, problems, and SLAs, then using web based reporting tools (SRSS like), and SNMP alerting designed and implemented advanced multi-tiered Service Management solutions, in line with ITIL best practices.• Developed dashboard solutions pinpointing causes of poor end-user experience (asp.net).• Developed application automation scripts (extended vb.net).• Puppet was used as needed to keep multiple LAMP servers in sync.• Mentored staff on the administration of the new reporting solution and tools. • Performed classroom corporate training on Vantage as well as the customized solutions. • Updated existing class materials for new releases. • Prepared statement of work documents and project updates.• Travel extensively • Perform additional duties as required

Detroit, Mi, Us

Kansas City, Mo, Us

Environment: Windows XP, Websphere, Siebel CRM, BT ACH, CMSDatabases: Oracle 10i, SQL ServerTools: PL/SQL, TSQL, XML, MS Enterprise Manager, MS Excel, VBA QACenter Testing Suite (Testing Suite Manager, Requirements, Error Management, Automated Test Engine.), Remedy.Directly involved with DBAs on identifying problems and tuning of Seibel stored procedures and database comparisons. Tested multiple phases of a multi-server, web-based custom Siebel implementation. Also tested custom 3rd party implantation of an Online Banking website including multi-layer single Sign-On security application. Role included:● Worked directly with client(s) to identify existing testing projects.● Listened to customer concerns, researched responses and resolved them to the satisfaction of the customer.● Performed Assessment of needs by analysis of applications or application requirements to be tested in line with confidentiality, integrity and availability (CIA) of information systems● Gathered customer requirements by listening to clients, identifying problems and making recommendations.● Prepared detailed statement of work, project planning prior to project aligned with customer strategic goals.● Prepared daily project management updates to both client and supervisory personnel in line with principles, methods and techniques of IT project management.● Prepared project resolution documents upon project closure ● Resolved performance and security issues in Siebel PL/SQL stored procedures and identified XML and database discrepancies.● Insured that designed solution met customer targets for availability, reliability and maintainability.● Insured that designed solution met customer expectations, assisting them in meeting their SLAs for availability, reliability and performance.● Automated test case creation was accomplished via MS Excel and VBA using the Excel\Word to QA Director interface.● Testing required high levels of attention to detail.

Environment: MS Windows Server 2003, Active Directory, Cisco, Barracuda, NovellDatabases: SQL Server 2005Tools: C#, VBA, DTS/SSIS, SSRS, T-SQL, QuantumResponsible for analyzing current Application/Network status then design and implement an refresh/update of systems and hardware for a 100+ user environment. Moved from Novell (1995) based network to Server 2003/Active Directory based network. Role included:● Worked directly with client(s) to identify refresh objectives and performance goals, lead efforts to improve service availability.● Listened to customer concerns, researched responses and resolved them to the satisfaction of the customer.● Assessed new system design methodologies and technologies to improve software quality in the face of increasing threats.● Prepared detailed statement of work, project planning prior to project aligned with customer strategic goals.● Prepared daily project management updates to both client and supervisory personnel in line with principles, methods and techniques of IT project management.● Prepared project resolution documents upon project closure ● Planned, developed, implemented Disaster Recovery plan for the new system to ensure the confidentiality, integrity, and availability of systems, networks, and data. ● Evaluated and Implemented enhanced security programs across disciplines. ● Implemented NAS for online backup of servers and client workstations.● Implemented Barracuda firewall for protection from Internet intrusions and respond against known vulnerabilities, attacks, and exploitations.● Migrated FoxPro based application to SQL Server 2005/DTS/SSIS/SSRS application, applied 5+ years of accounting system upgrades. ● Developed long-range plans for IT systems and security.● Resolved integration issues related to the implementation of new systems with the existing infrastructure. ● Selected and trained additional IT staff for additional system/security modernization projects.

Bismarck, Nd, Us

Environment: Windows 2000, Websphere, Java/PowerBuilderDatabases: Oracle 10i, SQL ServerTools: Optimal J, Java, Catalyze, Segue Test, MS Word, MS Excel, VBA, Test PartnerResponsible for analyzing current development / testing environment, designing new testing methodology customized to fit current development environment with given tools, then implementing new test methodology. Trained the state workers on the new methodology. Role included:● Worked directly with client(s) to identify existing security and performance issues.● Listened to customer concerns, researched responses and resolved them to the satisfaction of the customer.● Performed Assessment of needs by analysis of applications or application requirements to be tested in line with confidentiality, integrity and availability (CIA) of information systems● Gathered customer requirements by listening to clients, identifying problems and making recommendations.● Prepared detailed statement of work, project planning prior to project aligned with customer strategic goals.● Prepared daily project management updates to both client and supervisory personnel in line with principles, methods and techniques of IT project management.● Prepared project resolution documents upon project closure ● Designed and delivered custom testing solutions, in-line with SLAs, and best practices in a complex IT environment.● Insured that designed solution met customer targets for availability, reliability and maintainability through strict attention to detail.● Insured that designed solution met customer expectations, assisting them in meeting their SLAs for availability, reliability and performance.● Assisted client personnel in identifying existing security/performance problems and solving them.● Gave clear and convincing oral presentation of the new solution to executive level management.● Provided leadership to systems staff on administration and use of the solution and tools.

Us

Environment: Windows XP, Windows 2000Databases: Oracle, SQL ServerTools: XML, TSQL, MS Query Analyzer, Mercury Test Director, MS Enterprise Manager, MS Excel, VBA, HL7Tested a multi-server, multi-tier Medical Credentialing application that implemented various 3rd party tools in a .Net framework. Primarily responsible for the planning, development and execution of test cases, testing application interfaces (TSQL) and functionality between the 3rd party tools, the credentialing application and various SQL Server databases on different WAN based Servers. Test development required an in-depth knowledge of .Net framework, SQL Server, and the ability to interpret the XML messaging implemented between the application components. Tests Cases, Results tracking and trouble resolution were preformed via Mercury Test Director. Automated test case creation was accomplished via MS Excel and VBA using the Excel to Test Director interface.Role included:● Worked directly with client(s) to identify existing testing projects.● Listened to customer concerns, researched responses and resolved them to the satisfaction of the customer.● Prepared detailed statement of work, project planning prior to project aligned with customer strategic goals.● Prepared daily project management updates to both client and supervisory personnel in line with principles, methods and techniques of IT project management.● Resolved performance and security issues in TSQL stored procedures and identified XML and database discrepancies.● Automated test case creation was accomplished via MS Excel and VBA using the Excel\Word to QA Director interface.● Testing required high levels of attention to detail.

Overland Park, Kansas, Us

Environment: Solaris, Windows 2000Databases: Informix, OracleTools: Dbaccess, SQL Plus, SCCS, SQL, FTP, DIRECT CONNECT, KSH, Perl, C, MS C++, QoS, Winsock, VoIPDeveloped a 600+ table multi-tier ODS/Data Warehouse detailing telecommunications network information. Required a strong knowledge of telecommunication terminology, architecture and provisioning as well as an in-depth knowledge of design theory and optimization of data warehouses and operational data stores. Multiple interface feeds were developed between the ODS/Data Warehouse and many other telecommunications network related applications.Role included:● Prepared daily project management updates to both client and supervisory personnel in line with principles, methods and techniques of IT project management.● Worked directly with clients by attending user specification meetings.● Developed ETL load KSH scripts, C++ programs and stored procedures in compliance with project requirements.● Lead alpha and beta regression testing in compliance with project test plans.● Attended application design meetings.● Participated in system test design meetings.● Participated in user acceptance test planning. ● Performed system and user acceptance testing.● Participated in post project reviews.● Introduced concept of providing usable feedback to source systems on deficient data for correction.● Selected for proof of concept exercise for outsourcing activities.● Participated in project planning and management meetings, user acceptance test planning, user acceptance testing and post project reviews.● Developed written requirements for off shore development team, whose activities were guided via a daily conference call.● Developed test cases for Beta, System, and Acceptance testing for project.● Selected for proof of concept exercise for the creation of a VOIP solution for a hearing impaired Call Center.● Verified operation and effectiveness of Microsoft’s QoS, VoIP API services.

Us

Compuware Corporation - Harte HanksPosition: System Analyst / Database AdministratorEnvironment: Windows 2000, NovellDatabases: Informix, OracleTools: Dbaccess, SQL Plus, SCCS, SQL, FTP, DIRECT CONNECT, KSH, Perl, C, MS C++, QoS, Winsock, VoIPCreated applications for gathering CRM data for the Pharmaceutical Industry and then loading the data into a data warehouse for marketing research. Timelines were extremely tight and had to be completed within aggressive timeframes to meet client requirements and expectations. Performed as DBA for 12 instances of Oracle Server requiring high levels of availability.Role included:● Worked directly with client(s) to identify objectives and performance issues in client meetings and application design meetings..● Listened to customer concerns, researched responses and resolved them to the satisfaction of the customer.● Performed Assessment of needs by analysis of existing configuration, security and performance.● Gathered customer requirements by listening to clients, identifying problems and making recommendations.● Prepared detailed statement of work, project planning prior to project aligned with customer strategic goals.● Prepared daily project management updates to both client and supervisory personnel in line with principles, methods and techniques of IT project management.● Insured that designed solution met customer expectations, assisting them in meeting their SLAs for availability, reliability and performance.● Developed ETL C++ programs, FoxPro and PL/SQL stored procedures in compliance with project requirements.● Introduced concept of providing usable feedback to source systems on deficient data for correction.● Created capacity plans and reports for databases.● Monitored database health and condition for improved confidentiality, integrity and availability (CIA) of the information system.● Administrated network (file systems, users, roles and permissions) on Microsoft network.

Overland Park, Kansas, Us

Environment: Windows 2000, HP UnixDatabases: OracleTools: PL/SQL, PROC, SQL Plus, SCCS, SQL, FTP, DIRECT CONNECT, KSH, Perl, CImplemented interfaces from various feeding systems (including PRECEDENT 2000 (P2K) Billing System) to Corporate Billing IDS / Data Warehouse. Implemented an interface from Customer Care Organization to the Corporate Data Warehouse. Implemented an interface sending a feed of all new customers from P2K to a fulfillment vendor. Implemented interfaces from a third party Prepaid Cellular System to the Corporate Data Warehouse, Commissions Management, and General Ledger Systems.Role included:● Participated in the implementation of the Capability Maturity Model (CMM)● Prepared daily project management updates to both client and supervisory personnel in line with principles, methods and techniques of IT project management.● Worked directly with clients by attending user specification meetings.● Attended application design meetings.● Required an in-depth understanding of the P2K system.● Required an understanding of design and optimization of data warehouses.● Required an understanding of computer communication and file transfer (FTP, DIRECT CONNECT).● Developed ETL load KSH/Perl scripts, C/PROC programs and stored procedures in compliance with project requirements.● Lead alpha and beta regression testing in compliance with project test plans.● Introduced concept of providing usable feedback to source systems on deficient data for correction.● Participated in project planning and management meetings, user acceptance test planning, user acceptance testing and post project reviews.● Developed test cases for Beta, System, and Acceptance testing for project.

Overland Park, Ks, Us

Environment: Windows 2000, HP UnixDatabases: OracleTools: PL/SQL, BANNER, SQL Plus, SCCS, SQL, KSH,Oracle DBA during critical Fall Enrollment Period after the community college’s primary DBA resigned 2 weeks prior to fall enrollment period. Application was very high visibility and demanded high reliability. Role included :● Training of Assistant DBA for replacement of primary DBA position. ● Review of backup and recovery procedures, isolating multiple backup problems before damage was done. ● Implemented needed changes in the backup shell scripts.● Installed Oracle Web Server for the colleges enrollment system ● Updated Oracle Forms based enrollment management software (BANNER).Created capacity plans and reports for database instances.● Monitored database health and condition for improved confidentiality, integrity and availability (CIA) of the information system.● Tuned Database for better performance of the BANNER system● Tuned SQL Queries and stored procedures for better performance.

Dallas, Tx, Us

an NT based requirements gathering application by Platinum Technology with an ORACLE 7.1 UNIX back end. Performed beta site application/database upgrade to ORACLE 7.2 NT. Provided ORACLE, NT and UNIX Administration expertise to the development team at Platinum in order to complete the conversion.

Dallas, Tx, Us

Environment Windows 2000, UNIX System VDatabases: Oracle, Sharebase (Britton Lee), FoxPro, RecitalTools: PL/SQL, PROC, SQL Plus, SQL, FTP, DIRECT CONNECT, KSH, Perl, C, , Platinum Technology, MS Project, Cisco, TCP/IPWorked as System Admin and DBA in support of Card Operations in Kansas City. Supported IT efforts culminating in the Malcolm Baldrige Quality Award (1994) for AT&T Consumer Communications. Served on team that was tasked with selecting company accepted and approved applications for all of AT&T. Served on team that designed call detail data warehouse then thought to be that largest in the country. Served on team that cut calling card provisioning process from 25 days to 4 days in preparation for the first gulf war. Role included:• Participated in the implementation of the Capability Maturity Model (CMM)• Lead organization in quality efforts introducing multi level testing (alpha, beta, regression, system, and acceptance) in development projects.• Worked directly with client groups reviewing existing security objectives and performance issues and in setting additional security guidelines and performance SLAs.• Determined customer requirements by listening to clients, identifying problems and making recommendations.• Prepared daily project management updates in MS Project for both client and supervisory personnel in line with principles, methods and techniques of IT project management.• Insured that designed solutions met customer targets for availability, reliability and maintainability.• Insured that designed solutions met customer expectations, assisting them in meeting their SLAs for availability, reliability and performance.• Performed installation, updates, maintenance and performance tuning on Oracle, and Share Base databases.• Administrated network (file systems, users, roles and permissions) on Microsoft network.• Administrated network and communication links and feeds via UUCP and CONNECT DIRECT

Dallas, Tx, Us

Environment MSDOS, NOVELL, Windows, UNIX System V, DEC VAX/VMSDatabases: RDB, Informix 2.x, 3.x, 4.x, Sharebase (Britton Lee), FoxPro, RecitalTools: DBAccess, SQL, FTP, KSH, Perl, C, 4GL, MS Project, TCP/IPWorked as System Admin and Oracle, Informix, Sharebase DBA in support of the National Telemarketing Center both in Kansas City and Atlanta. Served on team that made possible secondary calling centers after AT&T’s national telemarketing center was overwhelmed by call volume during Television Advertising campaigns. Role included:• Worked directly with client groups reviewing existing security objectives and performance issues and in setting additional security guidelines and performance SLAs.• Listened to customer concerns, researched responses and resolved them to the satisfaction of the customer.• Determined customer requirements by listening to clients, identifying problems and making recommendations.• Insured that designed solutions met customer targets for availability, reliability and maintainability.• Performed installation, updates and performance tuning on Informix and Share Base databases.• Administrated network (file systems, users, roles and permissions) on Novell and Microsoft networks.• Administrated network and communication links and feeds via UUCP and CONNECT DIRECT• Designed, Developed and Implemented Marketing Reports based on VAX RDB data gathered from data gathered from National Telemarketing Center representatives.• Designed and Developed WAN based application/database failover process for business calling card, providing near real time cut over in the event of disaster.• Developed availability plan and procedures that made allowed balancing 800# call volume and data handling in multiple locations revolutionizing telemarketing industry. • Designed, Developed and Implemented custom call center application in Recital (Multiuser-Dbase3) for gathering information not included in main systems.

Dallas, Tx, Us

Environment MVSDatabases: DB2, VSAMTools: TSO, JCL, ISPF, CLIST, UCC7 (CA7), UCC11 (CA11)Worked as Computer Tech in the 24x7 AT&T Billing and Control (BAC) department in Kansas City. Responsible for analysis of Batch System Output, finding, troubleshooting, and resolving failed billing jobs on large mainframe system. Role included:• Monitored Billing Batch Job flow for amended job, identified error condition, diagnosed root cause, and resolved them if possible, if impossible refereed problem to qualified personnel.• Prepared daily updates for supervisory personnel in line with principles, methods and techniques of IT project management.• Developed CLIST to scan Batch System Outputs for error codes and cross check datasets for issues, saving at least 50% of effort, led to promotion to management at the National Telemarketing Center.

Ba, Psychology, Sociology

Bachelor'S Degree, Psychology