Integration Architect Resume
5.00/5 (Submit Your Rating)
SUMMARY:
Results - oriented database developer and business systems analyst with over 16 years of experience designing and optimizing SQL Server data warehouses, reporting systems, and ETL processes. Familiar with medical claims, enrollment, and provider data from Medicare, Medicaid, and major health insurers as well as major practice management and EMR systems.
TECHNICAL SKILLS:
- SQL Server 2016, 2014, 2012
- SQL Server DBA, SSAS, SSIS
- T-SQL querying and reporting
- SQL Server query optimization and performance tuning
- Relational and OLAP (Star-Schema) database design and modeling
- VB.NET
- Excel and Access VBA
- Confidential data including claims, billing, coding (DRG, ICD, CPT), and practice management
- Technical writing
EXPERIENCE:
Integration Architect
Confidential
Responsibilities:
- Integrated client data warehouses, practice management, and electronic medical record systems with Confidential 's population health management data warehouse.
- Gathered technical requirements, prepared documentation, and designed HIPAA and HITECH compliant ETL processes.
- Developed and implemented ETL tools, scripts, and queries in T-SQL, SSIS, and VB.Net.
- Wrote complex T-SQL queries for quality control and testing to measure data quality, integrity, accuracy, and completeness.
SQL Server Developer/Senior Business Systems Analyst
Confidential
Responsibilities:
- Served as SQL Server 2012 and 2014 development DBA.
- Updated and maintained servers, performance tuned query and ETL processes, and developed and implemented security policy.
- Designed and programmed OLTP and OLAP data warehouse databases including tables, stored procedures, views, triggers, and security.
- Designed data model and ETL processes to use SSIS to load data from a wide range of client systems into a single, unified reporting and administration system.
- Saved auditor hours and greatly improved reporting accuracy by converting ad-hoc Excel business administration and reporting “systems” into a rich SQL Server 2014 and MS Access based application.
- The application, which was used internally and licensed to clients, combined claim research, management, reporting, and administrative tools. Reports that took days to compile are now available in real-time.
- Improved developer productivity by designing and creating an MS Access application development framework.
- It included VBA function libraries, templates, add-ins, and builders which standardized the company’s codebase across all applications. Both developers and power users were able to create standard forms, objects, and user interfaces with the push of a button.
Data Analyst/Business Systems Analyst
Confidential
Responsibilities:
- Performed development DBA tasks, including administering, optimizing, and performance tuning SQL Server 2012 databases over a terabyte in size, containing billions of rows. Optimizing one build process cut run times from 5 days to three hours.
- Wrote advanced T-SQL queries to analyze Medicare and private insurer claims data uncovering recovery audit opportunities worth millions of dollars to Confidential ’s clients.
- Developed ETL procedures to load and process Medicare claims and enrollment data compliant with HIPAA standards. The processes were so efficient that Confidential consistently achieved client data processing milestones ahead of schedule and with greater accuracy than its competitors.
- Participated in design and requirements gathering meetings with Medicare payors to create specifications for data exchange with government data warehouses. Designed and created Confidential ’s internal ETL processes to meet these requirements.
- Prepared data and worked with data mining team to create predictive scoring models for medical chart reviews. Designed Star-Schema data model and implemented SSAS cubes for analyzing review results.
- Gathered requirements and documentation for developing new applications and business processes. Communicated effectively at all levels of the organization.
- Designed workflows and created MS Access and SQL Server-based tools for contact management, correspondence, and claims administration.
- Conducted employee training seminars on Confidential data processing, medical claim pricing, and advanced SQL Server and VBA programming techniques.
Auditor/Data Analyst
Confidential
Responsibilities:
- Worked directly with audit management and senior auditors to gather audit requirements and develop SQL Server and MS Access VBA based tools.
- Assisted DBA with SQL Server administration and development, including performance tuning, complex T-SQL reporting, and optimizing ETL processes in DTS and VBA.