We provide IT Staff Augmentation Services!

Sql Developer Resume Profile

4.00/5 (Submit Your Rating)

SUMMARY

  • An innovative results-oriented IT professional with 8 years of experience as a Business Systems Analyst providing leading edge technological solutions.
  • Experience with configure and implement application systems to deliver system functionalities required by business unit stakeholders.
  • Experience collecting, analyzing, and reporting data for Business Intelligence and related quality studies from a data warehouse environment
  • Understand workflows, creating requirements, implementing/testing, providing post-implementation support and training client staff.
  • Experience with Vendor Management, Business Intelligence tools, ERP and Healthcare systems implementation and enhancements, systems analysis, trouble-shooting and end user training.
  • Excellent client-facing skills, superb communication, problem-solving, and critical thinking skills.

SKILLS

Crystal Reports, MS Office, DataFlux, SQL Scripting, SQL Query Analyzer, DB2, HTTP, Visual Basic, Java, MS Project, MS Visio, Active Directory, CICS, CLP, Cognos, OpenLink, Mirth Connect, Interfaceware, AHC HCM, Open EMR, eClinical Works EMR, GeCentricity, Point Click Care, MS Dynamics, Siemens Soarian, NEXTgen/EHR, Covisint DocSite

EXPERIENCE

Confidential

Systems Analyst

  • Data Acquisition Consultant.
  • Responsibility include uploading new client data files to SQL or Oracle Databases for BI reports.

Environment: SQL Scripting, Oracle Scripting

Confidential

Systems Analyst

  • Responsibility includes assisting in defining the project scope, and managing the defined scope.
  • Primary duties defining the functional, usability, reliability, performance and support requirements of an EMR system.
  • Primary tasks include collecting, compiling, organizing and analyzing data for Business Intelligence and related quality studies and projects, including HEDIS, PIPs and QOCs that will help impact health care strategies and health outcomes.
  • Serve as a business subject matter expert.
  • Work as liaison between the business and IT. Provide the link between the technical and the business views of the system by ensuring that the technical solutions being developed will satisfy the needs of the business.
  • Lead system requirements definition, design, testing, training and implementation support.
  • Provide analysis of efficiencies related to system enhancements/automation.
  • Works with IT learning organization to assist in the development of system training documentation and provide training to end users.
  • Assist with developing use cases.
  • Hands-on experience with EMR Electronic Medical Records Technology and workflow processes. MS Access, SQL Scripting, FTP sites.
  • Create AdHoc Reports.
  • Work with Providers and EMR vendors to import data to our FTP sites.

Environment: SQL Scripting, SQL Query Analyzer, Facets

Confidential

Business Systems Analyst

  • MIS Consultant interacting extensively with stake holders and vendors to implement HIE and EMR
  • Performed HIE and EMR system implementation and associated activities including training, mock go-live and pilot testing to meet Meaningful Use certification criteria and standards
  • Collected, analyzed, and reported data in a data warehouse environment for Business Intelligence studies
  • Primary tasks include collecting, compiling, organizing and analyzing data for related quality studies and projects help impact health care strategies and health outcomes.
  • Duties included data analysis of facility compliance, create documentation of compliance issues.
  • Create AdHoc Reports.
  • Performed Requirements gathering, solution design, testing, and project coordination.
  • Facilitated JAD sessions with developers and business resources
  • Translated requirements into technical specifications for development teams
  • Worked with Interface Development team, IS Support group, hospital personnel and HIE application vendor to analyze, design, document, test, troubleshoot and coordinate implementation HIE and EMR.
  • Constructed UI workflow charts and diagrams, documentation and specifications
  • Performed HL7 interface integration testing of business scenarios to ensure that information is able to flow correctly between applications
  • Performed HL7 interface UAT specification to confirm HL7 messages sent and/or received from each application conform to the HL7 interface specification
  • Monitored project progress tracking activity resolving problems published progress reports.
  • Created retrospective data analysis reports using PIVOT tables
  • Experienced with SQL Scripting, SQL Query Analyzer, crystal reports
  • Knowledge of Meaningful Use, EHR Medicare/Medicaid Incentive Criteria and Requirements
  • Knowledge of TANF, SNAP
  • Knowledge of SOA
  • Knowledge of HL7 standards

Environment: SQL Server, SQL Query Analyzer, SQL Scripting, Mirth, Excel Pivot Tables, Cognos

Confidential

Systems Analyst II - Implementation Consultant

  • Experienced in documenting requirements, process flows, functional requirements, User Interface diagrams
  • Knowledge of Healthcare domain, workflow operations and regulatory affairs
  • Knowledge of SOA
  • Experienced with patient registration systems
  • Excellent knowledge of SharePoint Content Management System
  • Experienced with Agile development methodology
  • Soarian Clinicals:
  • Knowledge of System/User security access configuration Knowledge of CPOE configuration, testing and maintenance Knowledge of workflows and rules engine User Requirements gathering Knowledge of Build process staging Knowledge of Job Scheduler Knowledge of OpenLink interface engine
  • Knowledge of CMS Meaningful Use EHR Medicare/Medicaid Incentive Criteria Requirements
  • Knowledge of ICD9, ICD10 procedure codes
  • Soarian Financials:
  • Experienced with SQL Scripting, crystal reports Gap analysis, design and verification for DSS.
  • Create AdHoc Reports.
  • Go-Live Support.
  • Compiled comprehensive trouble-shooting documentation for IT support staff Developed end-user training material and conduct training sessions for various clinical user groups Worked with Siemens Support to isolate and resolve system issues

Environment: SQL Scripting, SharePoint, Agile, OpenLink, ICD9, ICD10

Confidential

LIS Business Systems Analyst

  • Served as key resource to lab users and management for lab system operations.
  • Knowledge of SOA
  • Responsible for requirements gathering, analysis, solution design, testing, and building HL7 interfaces
  • Used Microsoft Visio to created interface programming flowcharts, data stream flowcharts and workflow flowcharts for Business Intelligence
  • Knowledge of QCPR
  • Monitored Lab system and ensured accurate interfaced data transmission between systems
  • Troubleshoot HL7 interface transmission problems
  • Addressed new issues by formulating recommendations, reviewing with team, and implementing correction/s with management oversight.
  • Addressed recurring problems and pro-actively recognizes potential problems and appropriate action with LIS team management.
  • Maintained and update LOINC files and documentation of changes.
  • Participated in the development of user training programs. Conducted end user training.
  • Developed and maintains documentation of LIS operations and procedures to support Lab system management.
  • Prepared monthly financial reports for DSS, billing and commissions

Environment: SQL Server, Mirth Connect, Flow Charting Tools, MS Project, Visio, eClinical Works, GeCentricity

Confidential

Sr. Business Systems Analyst

  • Responsible for providing leadership and technical support of Long Term Care information technology infrastructure
  • Knowledge of SOA
  • Knowledge of Healthcare domain, workflow operations and regulatory affairs
  • Act as a subject matter expert on applicable regulations e.g. National Health Care Reform, HIPAA, Medicare, etc. training and awareness programs, and for responding to compliance related inquiries.
  • Knowledge of CMS Meaningful Use, EHR Medicare/Medicaid Incentive Criteria and Requirements
  • Knowledge of HL7 interface segments
  • Experienced with SQL Scripting, SQL Query Analyzer
  • Created IT SOP methods using ITIL specifications to meet internal workflow requirements
  • Collected, analyzed, and reported data for Business Intelligence purposes
  • Create AdHoc Reports
  • Managed all information technology assets, organizational HIPAA compliance and application security
  • Recommended hardware and software purchases, budget, and staffing
  • Developed key collaborative relationships with vendor s leadership and account team to promote effective vendor performance, service delivery and ongoing relationships.
  • Performed system operations and administration for multiple AS400 I-Series systems
  • Managed integration and implementation of Pharmacy/MAK system
  • Managed integration and implementation of MS Dynamics Financials ERP software package
  • Managed integration and implementation of Point Click Care EHR software package
  • Managed Time and attendance application

Environment: Unix, DB2, SQL Server, SQL Scripting, ITIL, MAK system, MS Dynamics Financials ERP, Point Click Care EHR

We'd love your feedback!