SUMMARY:

Experienced IT Professional with solid Health Information Systems Administration, Software Development, Database Administration, and Clinical experience.

TECHNICAL SKILLS:

IT Software Tools: SSMS, SSRS, SSIS, TSQL, Access, Office, Visio, Project, Oracle Oracle Forms/Reports, PL*SQL, DESIGNER 2000

Other: ANSI C, SCCS (Source Control), DBX (Debugger), Navigator, TOAD, ERWIN, NET8, OEM, OID/ONAMES, UNIX Scripts (KSH), FTP

DATABASE: Oracle, SQL Server, MS Access

SKILLS INVENTORY:

• Agile methodologies
• Visual Studio TFS, Report Viewer and Report Builder 3.0
• SQL Developer and TOAD
• SSRS
• MS SQL Server Database
• Oracle Database
• Healthcare Coding /CDI application software
• Systems Analysis and Design
• Data analysis, report development & automation
• Develop (BI) Subsets, Highlights, and Scorecards
• 24x7 Monitoring & Support of Hospital Systems
• Software Implementation and Upgrades
• Functional Configuration of Vendor Software Applications
• HPF Workflow Administration
• Monitor & support Transaction Data Interfaces (HL7)
• User Access Management
• Determine proper medical coding assignment/charges and apply E&M codes/charges to the Confidential database
• Software Development, and Support
• Systems Analysis & Design
• Systems Integration across multiple complex platforms
• Implementation and support of Multi - Database Environment
• Database Backup and Recovery

CHRONOLOGICAL SUMMARY OF EXPERIENCE:

Confidential, Cumming, GA

SQL Server SSRS/BI Report Developer

Responsibilities:

• Participate in full life cycle of reports development (requirements definition thru deployment)
• Create, update and maintain Reports using SSMS, Visual Studio, SSRS and T-SQL
• Perform research and analysis for issue resolution related to reports, stored procedure and databases.
• Build and maintain ETL/SSIS packages to populate data from various sources (flat files, excel, DBF files, other databases).
• Optimize and Performance-tune queries and stored procedures for data extraction and reports.
• Use Visual Studio/TFS to maintain reporting objects (.rds, .rsd and .rdl)
• Deploy and maintain reports on the report server
• Create time and data-driven Subscriptions
• Use Redgate for database object source control
• Designed and re-organized Visual Studios report solutions and projects (production) to simplify the report objects source control process
• Design and develop complex queries (T-SQL) for reporting purposes
• Use TFS and Agile methodologies

Confidential, Alpharetta, GA

Software QA Analyst/SSRS Developer

Responsibilities:

• Perform Data Analysis and Regression testing of Healthcare Coding Software
• Develop Customer Reports generated with SQL Server 2012 (SSRS)
• Perform Analysis and Triage of Customer Support Issues
• Create Test Data, utilizing Oracle SQL and Store Procedures
• Document software defects using bug tracking system (TFS) reported defects involving program functionality, output, online screen and content to software developers.
• Delivered thorough QA testing reports that determined product quality and release readiness.
• Perform Hotfix and Production release testing
• Participate in Daily Scrum (2 week sprint schedule), Sprint Planning, Sprint Retrospective User Story points estimation, Backlog grooming, and User Story Elaborations
• Workstation configuration including VPN, NetApps, Confidential Applications and Visual Studio
• Perform team collaboration, utilizing Enterprise Skype for Business
• Test TruCode Encoder software quarterly upgrades

Confidential, Lawrenceville, GA

Sr. Systems Analyst

Responsibilities:

• Perform administration and 24x7 on-call support for hospital systems, including: Horizon Business Intelligence (HBI), Horizon Performance Manager (HPM), Horizon Patient Folder (HPF), Metriq, Webstrat, Actus, KBT, HIC, Veracity, and ChartWise systems
• Perform Data Analysis utilizing ETL, SSIS, Visual Studio, SSMS, and SSRS
• Develop custom reports utilizing SQL Server 2008 Report Builder 2.0 (SSRS)
• Responsible for the monitoring and support of the interfaces for electronic transaction feeds, Data formats include: XML, HL7 (ADT), ANSI 836/837, Imbedded PDF through the BDI process, ASCII, Postscript, TIF, IERL, PDF, and JPG
• Perform HPF Workflow administration, develop and support workflow threads
• Installation, configuration, and support of peripheral devices, such as: printers, scanners, and webcams
• Training courses completed: Business Intelligence (HBI) - ETL Tools, System Administration; Horizon Patient Folder (HPF) - System Administration, Imaging Link Engine, Workstation Admin, Image Engine, System Admin - Technical & Application, Principles of Operation, ROI Admin, and Workflow Engine and Manager; STAR - Administration, Menu, Forms and GUI; and Crystal Reports I & II

Coder/Abstractor

Confidential

Responsibilities:

• Recommended improvements to the Confidential Charging application user interface and database utilizing MS Access, Visual Basic, and SQL Server Relational Database Technologies. Results: Improved the efficiency and accuracy of the Health Information Management Department data entry process flow
• Apply ICD-9-CM, CPT coding guidelines for Confidential and Inpatient Acute care services utilizing Webstat and Actus medical billing software
• Analyze Confidential stats to determine appropriate evaluation and management code assignment/charges, apply E&M codes/charges to the Confidential database and ensure nightly process via the HIS system

Confidential, Lawrenceville, GA

Student

Responsibilities:

• Researched, developed and implemented a Document Master database (utilizing MS Access) to identify, organize, document and maintain all internal forms (approximately 2500) that are contained in the Confidential
• Developed two new policies and procedures.
• Presented them with a Power Point Presentation to the Document Capture team.
• Trained and supervised two new PRN employees utilizing these procedures

Confidential, Gainesville, GA

Student (Managerial Practicum)

Responsibilities:

• Added new Policy/Procedure, provided RAC analysis and workflow diagram

Confidential, Augusta, GA

Student

Responsibilities:

• Comprehensive overview of the Confidential processing, workflow, coding/billing and document management systems

Confidential, Alpharetta, GA

Medical Billing Specialist

Responsibilities:

• Manual and electronic processing of sensitive medical information such as patient demographics and medical histories
• Converted medical billing records from healthcare provider formats to Confidential -1500 Insurance formats for Insurance reimbursement
• Submitted claims to insurance company through insurance website portal. Monitored and worked delinquent claims to resolution

Confidential, Alpharetta, GA

Database Administrator I & Senior Programmer Analyst

Responsibilities:

• Development and support of Oracle 8.x databases, including: version installation, upgrades, patch implementation, DB instance creation, cloning, and copying, MTS, OID 2.1.1 implementation, Net8, imp/exp sqlload, replication, hot/cold backups.
• Provide 24 hour on-call support for database and all performance issues.
• Analyze, code, test, and document applications that process Public Record Information utilizing PL*SQL, Developer 2000, Forms 4.5, Reports 2.5, Designer, Workflow, Windows NT, Solaris.

Confidential, Atlanta, GA

Senior Systems Programmer & Senior Programmer Analyst

Responsibilities:

• UNIX (AIX) system administration and technical support
• Worked with Security Administration to configure UNIX to mainframe communication access.
• Develop UNIX scripts to automate UNIX to mainframe data transfer.
• Analyze, code, test, and document applications that process credit information, utilizing ANSI “C”, ORACLE Pro “C”, ORACLE SQL, UNIX Shell Script, and VRU technologies.
• Train new programming staff as needed.
• Primary applications include: Credit scoring, Voice Recognition System (application & interface), Remote Direct Access Terminal Communications, System to System, Inquiry Posting, and UNIX to mainframe communications.