Database Developer Resume

SUMMARY:

Experienced in all phases of the Software Development Lifecycle (SDLC) (Requirements Analysis, Design, Development, and Testing)
3+ years of working T - SQL knowledge including Temporary Tables, SPROC’s, CTE’s, and Aggregation
Extensive background in Extract, Transforms, and Loads (ETL) of heterogeneous data sources into data extracts, Operational Data Stores (ODS), Data Marts (DM), and Dimensional Models
Major contributor during design sessions from both a technical and business perspective
Intimate knowledge of Agile methodology having played Scrum Master, Product Owner, and Developer
Designed processes to balance error handling and alerts, maintainability, and speed-to-value
Expertise in interacting with Business Analysts and customers to gather requirements and translate business intentions into functional specifications and technical specifications
Customized workflows in MS Team Foundation Server to match work environment
Able to present multiple solutions to compensate for scope creep
Responsible for providing project status and timelines to management
Experienced report writer for varied audiences including analysts, executives, and providers ranging from excel reports, graphs and charts, and PowerPoint presentation
Familiar with creating SSIS packages and SSRS Reports
Solid understanding in the realms of realms of Professional Billing and Managed Care with respect to Health Care
Familiar submitting Encounter Data to CMS
Experience in working with Patient Eligibility, Coordination of Benefits (COB) and Division of Financial Responsibility (DOFR)
Experience with Quality Reporting like CA IHA P4P Measures and MSSP
Extracted data to third-party Quality Programs like Ascender and Verisk DxCG
Able to accomplish business objectives with minimal supervision
Strong organizational and documentation skills
Charismatic presentation skills to both technical and business audiences

TECHNICAL SKILLS:

Technical Knowledge: MS SQL Server (2008/2012), SSIS (2012), VBA (Excel), MS Team Foundation Server (TFS 2010, 2013), Visio, MS Office, MS Project

Exposedto: SSRS (2008)

SDLC Methodologies: Waterfall, Agile

PROFESSIONAL EXPERIENCE:

Confidential

Database Developer

Responsibilities:

Designed data mart to combine 6 disparate data sources into a single data feed for both internal and external reporting of clinical measures
Coded extracts for Dartmouth’s High Valued HealthCare program
Created process to supplement Managed Care data with outside sources to comply with CMS 837p 5010 specification
Ingested outside files with SSIS automation, a data store for traceability, and mapping documentation in SharePoint
Validated quality of data extracts with business knowledge as a Revenue Analyst
Developed maintainable database solution to calculate Risk Adjustment Factor (RAF) scores by year
Used SSIS packages and SSRS reports to automate distribution of a Billing Activity Summary that reported on the revenue for UCLA’s School of Medicine
Presented proposed technical solutions during design sessions and code reviews
Acted as liason between customers and the rest of the development team to gather requirements
Recorded developer tasks via TFS to report project status and timelines to management
Documented requirements with process flow and server diagrams in Visio
Worked with Project Management Office to determine team wide priorities
Communicated time-line affecting issues to both customers and management
Managed customer expectations via weekly status meetings
Participated in Lessons Learned meetings to highlight areas for improvement
Lead process improvement efforts to increase the visibility of the development team’s effort
Trained team members in Health Care concepts related to ETL projects

Confidential

Analyst

Responsibilities:

Joined Professional Billing and Managed Care sources together for holistic reporting of a patient’s clinical history
Presented financial and clinical findings via graph and chart presentations in both Excel and PowerPoint
Worked with Chief Medical Officer on customer Quality metrics
Researched Coordination of Benefits questions from Managed Care Operations including Eligibility, Middle of Care, and Contracted Rates
Developed data feeds to power Verisk DxCG and Allscripts e-Prescribe third-party tools
Designed data marts to store and report on results generated from third-party tools
Developed T-SQL Queries to answer Ad Hoc questions on Confidential Reports
Used MS Word tapping MS SQL backend to automate Denial Letters for unclean claims
Utilized RAF scores to identify possible Diagnosis Code (ICD-9 Dx) under-coding
Ran QA and troubleshot automated report errors
Analyzed monthly Confidential reports to explain outlier data points
Mapped flat files from health plans to ODS target tables
Identified high risk patients for Care Coordinators and Population Managers

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship