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.