Sql, Etl And Data Warehouse Developer Resume
Marlton, NJ
SUMMARY:
EHR, SQL and ETL developer who has managed, lead and mentored teams through product life - cycles while maintaining strict deadlines. Well versed in data design and warehousing, development, ETL,, documentation and reporting. Motivated and self-directed with a broad background enabling a quick grasp of requirements and impact assessment for efficient solution design.
PROFESSIONAL EXPERIENCE:
SQL, ETL and Data Warehouse Developer
Confidential, Marlton, NJ
Responsibilities:
- Design and develop data warehouses and data marts via T-SQL in MS SQL .
- Develop health record ETL processes for large data system retirement in MS SQL .
- Extensively utilized dynamic SQL techniques for flexibility and compatibility.
- Successfully deployed over 20 Meaningful Use, ACO and practice management reports
- Archival and Mapping of legacy data from Confidential , centricity, PCare & MDR in Informatica
- Developed error Tracking and logging processes for ETL projects
- Performance tuning of T-SQL and Jreports source scripts.
EHR & SQL Developer
Confidential, Knoxville, TN
Responsibilities:
- UI development for Confidential EHR via templates, documents and T-SQL.
- Maintain version tracking library in Tortoise .
- Write technical documentation for use with upgrade gap analysis.
- Perform releases into Production environments. developed and released over 50 Confidential customizations
- Performance tuned multiple T-SQL processes for better efficiency and speed
- Full SDLC on multiple large-scale projects for use by specialty medical practices
Project Manager
Confidential, Savannah, GA
Responsibilities:
- Simultaneous project management, development, upgrades and for multiple client implementations.
- Development in Confidential EHR, Crystal Reports, and SQL 2008. Gap analysis and lifespan review of legacy customizations.
- Successfully guided practices through Meaningful Use reporting and attestation developed and released analysis processes for medical specialties via Crystal Reports
Ambulatory Systems Manager
Confidential, Prince Frederick, MD
Responsibilities:
- Lead and mentored my ambulatory team in development, implementation and management of Confidential EHR.
- Data design and EHR customization of templates, documents and reports.
- Custom development via VB.
- Chair presentations to directors, administrators and stakeholders using Robert's Rules.
- Plan and perform gap analyses to meet upgrade regulations.
- Negotiate participation agreements with medical administrators.
- Doubled the size of my team in two years to provide specialization and efficient support directed implementation of five specialties; served as implementation director at two others
- Participated in Data Governance Team, specializing in Confidential regulation and HIPAA auditing
- Guided organization through extensive documentation for EHNAC accreditation
- Managed and assisted development of Confidential EHR upgrade to ICD10 via scrum principles
Trainer / IT Specialist
Confidential, Marlton, NJ
Responsibilities:
- Developed automated T- SQL processes for fast new user setup
- Individualized EHR sessions for high-risk users and doctors
EHR Specialist & Founder
Confidential, Fredericksburg, VA
Responsibilities:
- Full SDLC of UI for pain management and in-patient medical groups
- Successfully increased workflow efficiency for an OB/GYN clinic
- Designed and developed custom database and community web site for locating local doctors developed custom application to allow doctors quick access to patient progress notes
EHR Specialist & Developer
Confidential, Fredericksburg, VA
Responsibilities:
- Project Manager and Trainer for initial implementation of Confidential EHR system
- Designed and implemented custom templates and reports resulting in highly efficient EHR
- Developed custom data structures , ETL and mapping techniques for management reporting
- Wrote technical and user documentation for all customizations
- Maintained corporate internet and Intranet sites via Dreamweaver and PHP