Sql Developer - Healthcare Data Analyst - System Analyst Resume
Miami, FL
PROFESSIONAL SUMMARY:
- SQL Server Developer with 5 plus years of experience in professional application and database development with thorough knowledge of different phases of software development lifecycle including analysis, design, development, documentation, deployment and system support.
- Experience in designing of the database in SQL Server 2012, 2008, and 2005.
- Hands on experience in writing T - SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Derived Tables, Views, and Triggers.
- Currently looking for an SQL Developer, System Analyst, Data Analyst, or Healthcare System Engineer position in a fast-paced and teamwork-oriented environment.
- Working with client/business analysts to define data requirements for enterprise analytical reporting needs.
- Maintaining the product application data which is critical in product lifecycle and efficiently implementing the data migration in each release.
- Data Mining, Data Warehouse, Business Intelligence
- Data Integration interfaces (SSIS, HL7, EDI X12, and others).
- Strong Knowledge in Laboratory Information Systems (Clinical and Anatomical)
- Strong Knowledge in Revenue Cycle Management systems (Healthcare domain)
- Developing project schedules and meeting delivery schedules
- Experience working with users to clarify requirements
- Writing and reviewing software requirements specifications and software design specifications
- Writing, reviewing, testing and debugging code
- Performing integration testing
- Writing documentation
TECHNICAL SKILLS:
SQL Server: Database administration, Transact-SQL, SQL Reporting Services SSRS, SQL Integration Services SSIS.
Other DB: MySQL, Oracle.
Visual Studio: C-Sharp, ASP.Net, Business Intelligence, Reports, Integration, and others.
Other tools: PowerBI, Mirth Connect, Assembla, Jira, Subversion, Microsoft Office.
Connectivity: API, Web Services, HL7, X12 4010 and 5010 versions (837, 835, 270, 271, etc.), EDI Framework, Network configurations, VPN Connections.
PROFESSIONAL HISTORY:
Confidential, Miami, FL
SQL Developer - Healthcare Data Analyst - System Analyst
Responsibilities:
- Report Center (SSRS) connected to their Laboratory Information System (MySQL).
- SQL Server Reporting Services (SSRS)
- SQL Server / MySQL Interface
- T-SQL, Store Procedures, Triggers, functions, etc.
- Leading the Interface Implementations on Confidential from the following 3rd party solutions:
- PierianDx solution for analysis and diagnosis of Sequencer results.
- Illumina solution for the Next Generation Sequencer workflow.
- Anatomic Pathology Application Interfaces
Confidential, San Mateo, CA
Software Development Manager
Responsibilities:
- Database design, modeling, Development (MSSQL, T-SQL, ASP.NET, C#) on the first phase of the design/development process, leading a team from Mumbai, India.
Confidential, Palo Alto, CA
Product Manager
Responsibilities:
- Supervise IT Department for Software implementations to the customers.
- Provide customer needs to the IT Department.
- Provide customized reporting for internal and external customers.
- Perform necessary investigation, analysis and evaluation to manage special Ad Hoc projects.
- Coordinating between IT personnel, project managers, and end-users, translating business needs into concrete goals & requirements to provide custom solutions and mentoring of new team members
Confidential, Miami, FL
Lead Architect
Responsibilities:
- Developer and responsible for the Anatomic Pathology application. This web-based solution was made in ASP Classic, ASP.NET, DLLs in C-Sharp and Visual Basic 6 and SQL Server as a Database. Following are some of their most remarkable features:
- Histopathologic and Cytopathologic Evaluation.
- Requisition, Accession, Technical Component process, Professional Component process and reporting (Prostate, Dermatology, Gastroenterology (GI), etc.).
- GYN Cytology (OB-GYN). - QA/QI/QC processes and reporting (Bethesda Standards) according to CLIA and Joint Commission.
- Molecular Studies Module. - Interface with Digene Hybrid Capture and Roche. The information with the final result is processed and delivered to the customer with no human intervention.
- Fluorescence In-Situ Hybridization (Fish). - Process, interpretation and reporting.
- s:
- Highly recognized as a resourceful contributor and acknowledged with increased developing responsibilities. Proven record. Documentation available.
- Publicly recognized for initiation, development and implementation of the Anatomic Pathology application in 2008. Proven record. Documentation available.
- Responsible for the Revenue Cycle Management (RCM) module. This web-based solution interface with the Anatomic Pathology application and other clinical systems of the company to process and bill our customers like healthcare insurance companies.
- X12 files generation and translation in 4010 and 5010 versions using EDI Framework.
- HL7 generation and translation for Electronic Requisitions and Reporting using Mirth Connect.
- Develop SQL server store procedures and DTS/SSIS packages to generate reports via Microsoft Reporting Services.
- Design, develop SSIS packages.
- Provide customized reporting for internal and external customers.
- Perform necessary investigation, analysis and evaluation to manage special Ad Hoc projects.
- Coordinating between IT personnel, project managers, and end-users, translating business needs into concrete goals & requirements to provide custom solutions and mentoring of new team members.