CAREER SUMMARY:

• Experienced Technical Leader and Subject Matter Expert (SME)—with a programming and analysis, business intelligence, and software engineering background—seeks to analyze, design, develop, document, deploy, and support various types of data - centric/-driven applications and systems; with emphases upon analytics and master data management.
• Leadership (e.g., director, manager, lead, architect), with emphasis upon technology
• Data reporting and analytics, informatics, master data management (e.g., tools from Microsoft, Oracle, SAP, Tableau)
• Data warehousing, using extract, transform, load (ETL) (e.g., tools from Informatica, Oracle, Microsoft, SAP)
• SQL queries for ad hoc and scheduled reports, views, performance tuning, and stored procedures
• Object-oriented programming (OOP) and structured programming
• Project management, emphasizing software development lifecycle (SDL/SDLC), including Agile and Waterfall
• Systems integration, emphasizing network solutions (e.g., cloud computing, remote access)
• Strategic technology planning (e.g., disaster recovery DR, security requirements)n-tier analysis, design, development, testing, deployment, and support of applications, databases, and systems
• Diagramming, including flowchart and unified modeling language (UML) (e.g., using Microsoft Visio)
• Extensive knowledge of banking/lending, healthcare, manufacturing, taxation and other regulatory environments
• Oral presentations (e.g., Presentations, PowerPoint) for diverse audiences, including business, clinical/medical, legal, and technical
• Various forms of writing, including legal (e.g., contracts, proposals, policies, motions, pleadings, judgment forms) and technical (e.g., manuals, procedures, specifications)

TECHNOLOGY SUMMARY:

Analytics: SAP BO Dashboards f/k/a Xcelsius, WebI (i.e., Explorer/InfoView/Rich Client), DeskI; Tableau Desktop, Public, Server

Cloud Storage: Amazon Cloud Drive; Apple iCloud; Dropbox Desktop; Google Drive; Microsoft OneDrive f/k/a SkyDrive, SkyboxCloud Cloud (e.g., Hybrid, Private, Public)

Collaboration: IBM OneSource; I.R.I.S. IRISCloud Community; Microsoft SharePoint

Compilers: Apple Xcode; Borland C++Builder, Delphi, JBuilder, Kylix; IBM VisualAge, WebSphere; Microsoft Office VBA, Visual Studio/.NET; NetBeans IDE; Oracle JDeveloper; Progress Software ClientBuilder, Eclipse IDE; SAP PowerBuilder

DBMS: dBASE; IBM DB2 (e.g., mainframe; Windows), Informix; Microsoft Access, FoxPro, SQL Server; Oracle Database; MySQL; PostgreSQL; SAP Sybase SQL Anywhere, Sybase SQL Server

DB Tools: Oracle SQL Developer; IBM Data Studio, DB2 Connect; Pegacat Software JXPlorer; SQLTools.net SQL Tools; Synametrics Technologies WinSQL

Document Management: ABBYY Business Card Reader, FineReader, FineScanner, FlexiCapture, PDF Transformer+, Recognition Server; Adobe Acrobat; I.R.I.S. IRISCard, IRISCloud (i.e., ECM, Invoice, OCR), IRISCompressor, IRISNotes, IRISPen, IRIScan, Readiris; NewSoft Presto PageManager; Nuance OmniPage, PaperPort, PDF Converter

EHR/EMR: Cerner Millennium, PowerInsight Explorer (PIE), PowerInsight Warehouse (PIEDW), HealtheIntent (HI); athenahealth athenaOne, athenaClinical; GE Healthcare Centricity eReaders Amazon Kindle; Barnes & Noble Nook; Microsoft Reader

FTP/SFTP: GlobalSCAPE Enhanced File Transfer (EFT) Server; IPSwitch WS FTP; Mozilla FileZilla

Languages: Basic (e.g., VB5/VB6/VB.NET), C/C++/C#/Objective-C, FoxPro, F#, HTML, Java, JavaScript/JScript, Pascal (e.g., Delphi), Perl (i.e., PerlScript), PowerBuilder, Ruby, Ruby on Rails, SQL/T-SQL/Transact-SQL

Mainframe (Legacy): Attachmate Extra ; BMC Control-D; CA Technologies Integrated Database Management System (IDMS), Top Secret, Terminal Productivity Executive (TPX); IBM Customer Information Control System (CICS), CICS Transaction Gateway, COmmon Business-Oriented Language (COBOL) Compiler, DB2, Direct Access Storage Device (DASD), Indexed Sequential Access Method (ISAM), Interactive System Productivity Facility / Production Development Facility (ISPF/PDF), Job Control Language (JCL), Multiple Virtual Storage (MVS), Time Sharing Option/Extensions (TSO/E), Virtual Storage Access Method (VSAM), WebSphere Application Server; Software AG Adaptable DAta BAse System (ADABAS)

Middleware: Compuware Gomez; Enteros Load2Test; IBM WebSphere Application Server, Portal Server; Infor Fourth Shift ERP/MRP; Informatica Dynamic Data Masking, PowerCenter; Microsoft Active Directory; Nagios IT Infrastructure Monitoring; Oracle Applications (e.g., JD Edwards EnterpriseOne), Directory Server f/k/a Sun Java System Directory Server, Sun ONE Directory Server, iPlanet Directory Server, Netscape Directory Server), WebLogic Portal; SAP ERP; Tecnomatix Unicam eM-Quality System

Office Suites: Apache OpenOffice (i.e., Base, Calc, Draw, Impress, Math, Writer); Corel WordPerfect Office (e.g., eBook Publisher, Lightning, Paradox, Presentations, Quattro Pro, WordPerfect); Google Docs; Microsoft Office (e.g., Access, Excel, Outlook, PowerPoint, Project, Visio, Word), Office 365

OS: Apple iOS, MacOS; Google Android OS, Chrome OS; IBM AIX, OS/2, OS/390, OS/400 (e.g., i5/OS, i), z/OS; Microsoft Windows (e.g., NT 3.51, NT 4, 95, 98/98SE, 2000, XP, Vista, 7, 8/8.1, 10), Windows Phone, Windows Server (e.g., NT 3.51, NT 4, 2000, 2003, 2008, 2013); Oracle Linux, (Sun Microsystems) Solaris/SunOS; Research in Motion (RIM) Blackberry OS

Project Management: Microsoft Project, Project Online; OpenProject Foundation OpenProject; SAP Business ByDesign, Portfolio and Project Management (e.g., cFolders, cProjects, RPM); Workspace.com Workspace

CORE SKILLS:

• Project management
• Workflow and work queue management
• Mentoring and training
• IT Architecture:
• Process engineering/workflow
• Resource planning/scheduling
• Change management
• Data science
• Descriptive and predictive analytics
• Dashboards, reports, and extracts
• Database administration
• Data warehousing
• Master data governance/management
• Methodology:
• Object-oriented (OOP; e.g., Booch)
• Structured (e.g., Yourdon)
• Compiled:
• Java
• Delphi
• F#
• Visual Basic (VB), Visual Basic.NET (VB.NET)
• C, C++, C#, Objective-C
• Scripting:
• HyperText Markup Language (HTML)
• JavaScript/Jscript
• Perl
• PowerShell
• Python
• Structured Query Language (SQL), Transact-SQL (T-SQL), Oracle PL/SQL
• All things Tableau, including administration, architecture, and development:
• Tableau Server
• Tableau Desktop (preferred)
• Tableau Online f/k/a Tableau Public
• Tableau Prep
• All things SAP, including administration, architecture, and development:
• BusinessObjects (BO)
• BO Dashboards f/k/a Xcelsius
• Crystal Reports (CR)
• All things Microsoft, including administration, architecture, and development:
• Excel, e.g., Power Query; PowerPivot
• PowerBI
• Microsoft Visual Studio
• NetBeans IDE
• Eclipse
• ActiveState
• Oracle JDeveloper
• R Studio
• Microsoft SharePoint
• IBM OneSource
• Microsoft Office, through Professional Plus 2016 and 365
• Corel WordPerfect Office
• Google G Suite
• Apache OpenOffice

PROFESSIONAL EXPERIENCE:

Senior applications programmer analyst

Confidential, Houston, TX

Responsibilities:

• Evaluate requests to determine proper placement
• Conduct meetings to gather/clarify specifications with Customers
• Prioritize requests according to an enterprise value matrix
• Meet monthly with Senior Leadership to finally prioritize requests
• Efficiently resolve conflicts to meet Customer expectations
• Weekly Team Meeting:
• Communicate/explain priorities of Senior Leadership
• Review and discuss current analytics and statistics (e.g., aging of assigned versus unassigned; average time to close/resolve)
• Assign requests that have been finally prioritized, or which have been determined not to require such prioritization
• Facilitate peer knowledge sharing, especially regarding issues, obstacles, and resolutions (if any) from previous week; industry standards and best practices
• Training:
• Conduct advanced individual and small group training sessions to teach Customers how to use BO and Tableau
• Mentor other Team Members in various aspects of analytics and reporting, with emphases upon our tools
• Dashboards using Tableau, BO Dashboards f/k/a Xcelsius, and Microsoft Excel
• Reports using BO, Microsoft Excel
• Extracts in custom/direct SQL (i.e., Oracle; Microsoft SQL Server; HP Vertica), Microsoft Access, and BO. Some custom/direct SQL queries were standalone, while others were operationalized within Access, BO, and even on the hosts, themselves. E.g., standard views; materialized views; executable reports
• Custom coding for, e.g., formulae; calculated fields and variables; filtering; alerters and conditional formatting
• ETL packages in Informatica PowerCenter and Microsoft SSIS
• Maintain and troubleshoot various other dashboards, reports, and extracts
• Ensure that Team maintains service level agreement (SLA) for elevated/expedited requests, especially for minimizing time from opening to Customer contact
• On Call:
• Manage on-call assignments
• Participate in on-call rotation
• Request/Service Management:
• ServiceNow
• BMC Remedy
• HP Quality Center
• Electronic Medical Record (EMR) / Electronic Health Record (EHR) / Health Level SEVEN (HL7) / Population Health:
• Cerner Millennium, HealtheIntent athenahealth athenaOne/athenaClinical
• GE Healthcare Centricity
• Medical Billing/Practice Management
• Cerner Revenue Cycle Management (RCM) athenahealth athenaOne/athenaCollector
• Allscripts EPSi

Systems analyst

Confidential, Round rock, TX

Responsibilities:

• Drafted business requirements for large-scale enterprise records management project (ERMP), affecting in excess of TEN MILLION (10,000,000) records, pursuant to the Federal Information Security Management Act (FISMA).
• Developed last desktop version of Report Request Distribution (RRD) using Delphi. Provided template for AdvanTG Web version using Java, J2EE, and JSP
• Customers to gather/clarify requirements and specifications
• Cross-functional Teams to control/coordinate changes to production systems
• Applications, using Delphi, Java, Java 2 Platform Enterprise Edition (J2EE), and .NET (e.g., VB.NET, C#):
• End-to-end solutions
• Bug fixes and enhancements, such as a utility for converting rich text format (RTF) to hypertext markup language (HTML) for mass collection letter generator application
• Components:
• User interface (UI)
• Middle tier
• Backend components for web applications using a variety of technologies, including Active/Java Server Pages (ASP/JSP), HTML, cascading style sheets (CSS), extensible markup language (XML), JavaScript Object Notation (JSON), JQuery, and Struts
• SQL queries and stored procedures using for use in enterprise applications, some of which utilized Java Object Oriented Querying (JOOQ)
• Reports using ad hoc SQL and PL/SQL (e.g., IBM Data Studio, WinSQL), SAP Crystal Reports (CR) and BO, Microsoft Excel, and SQL Server Reporting Services (SSRS)
• Extensions and plug-ins using Asynchronous JavaScript and XML (AJAX), JavaScript, Ruby, and Ruby on Rails:
• Network monitoring
• Software/website testing automation
• Web applications for Android OS and iOS devices, using Eclipse and Xcode
• ETL packages using Informatica PowerCenter, IBM DB2 Warehouse Manager, Oracle Warehouse Builder (OWB), and Microsoft DTS n/k/a SQL Server Integration Services (SSIS)
• Maintained and troubleshot various applications, reports, and extracts
• Regular on-call rotation
• Annual disaster recovery (DR) exercises

Programmer analyst

Confidential, Austin, TX

Responsibilities:

• Quickly promoted within a short time after hiring
• Provided project management leadership to transition from proprietary electronic data interchange (EDI) to XML and other more widely-held standards
• Created a credit management report, pursuant to requirement/specifications provided by the chief financial officer (CFO). This solution leveraged Microsoft Excel, Visual Basic for Applications (VBA, i.e., within Excel), and SQL Server
• Analyzed, designed, and tuned SQL queries and stored procedures for use in enterprise applications
• Designed ETL packages in OWB and DTS
• Developed and supported serial communication applications with Delphi and Visual Basic (VB), capturing real-time data from various machines, such as IET Labs (GenRad) in-circuit testers (ICT)
• Developed custom integration modules for enterprise/manufacturing resource planning applications (i.e., Proprietary, Fourth Shift MRP, SAP ERP), which used dBASE, SQL Server, and Oracle back-ends

Programmer analyst

Confidential, Austin, TX

Responsibilities:

• Quickly promoted within a short time after hiring
• Performed both leadership and development functions, including architecture and server administration
• Electronic Tax Filing System, which automatically receives and processes sales tax returns via electronic data interchange (EDI):
• As project manager, drafted requisitions for system components, all of which were approved
• As developer, built custom C/C++ modules to extend NetVillage f/k/a Galacticomm WorldGroup BBS/web server, so that the latter could automatically assign unique numbers to each incoming tax return
• As systems integrator, used the extended version of BBS/web server on then-latest version of Windows NT Server 4.0, in order to achieve Year 2000 compliance

Developer consultant

Confidential, Austin, TX

Responsibilities:

• Developed comprehensive inventory control application for a leading pipe manufacturer, using a combination of Acrobat, VB, and SQL Server
• Developed executive reporting solution for a leading online gaming company.
• Provided on-demand snapshot analysis using an Excel front-end to query a SQL Server back-ends from around the United States

Principal member

Confidential, TX

Responsibilities:

• Develop mobile applications for Android OS, iOS, Java ME, Symbian OS, and Windows Phone devices
• Provide systems integration services with build-to-order hardware, software, and web solutions (e.g., e-Business/Commerce; informational; mobile device), as well as technical support services for each
• Provide audio/video/multimedia consulting, engineering, and production services