Integrated DermatologyDatabase Specialist
Jan. 2011 - Aug. 2013Boca Raton, Florida, United StatesMultiple roles including SQL Server Specialist, Business Analyst, Data Analyst, Database Architect, Database Modeler, Database Developer, and Manager of the Web Application Development Team. Responsible for stored procedures, views, triggers, and indexes. Implemented transactional replication to synchronize data feeds between web applications and IPAD applications and between production and UAT environments. Identified performance problems using SQL Server Profiler. Created ETL processes for importing data for new customers. Created SSRS reports designed for use as programmer tools and systems analysis. Supported programmers by writing stored procedures needed for web application and IPAD application. Created SSIS automation for various database updates. Created Data Models in Visio of all aspects of complex database system. Created automated data dictionary for SQL Server database system. Implemented transactional replication. Queries using Change Data Capture (CDC).
• Practice Management System (PMS), Electronic Health/Medical Records (EMR/EHR), Revenue Cycle management (RCM), and Prescribers’ Digital Reference (PDR). • Architect. Analyst. Developer. Medical records. Medical billing. Statistical reports
• ICD-9, ICD-10, CPT, NPI, HL7, HIPAA, Rx, • On Premise, Colocation, OLTP, OLAP, Medical