PROFESSIONAL SUMMARY:

• Lead Database Developer with 10+ years of extensive development experience in MS SQL Server, FACETS and PL/SQL in Healthcare domain with demonstrated skills in working with Business, Clients, Enterprise Architect and Project teams to develop and support applications that meet business requirements and operational excellence.
• Lead, collaborate, and mentor in the analysis, design, development and issue fixing.
• Experience in MS SQL SEVER as Database Backend developer for Healthcare Applications.
• Experience in Developing and Maintaining applications with ORACLE PL/SQL.
• Experience in and Troubleshooting and Maintaining Database & C# .Net Applications.
• Experience in writing SQL queries in UQT tool to generate reports based on end user’s requirement.
• Experience in developing new integrations and enhance existing integrations using MS SQL server.
• Experience in Resolving Production Issues to support Integrations.
• Experience in Performance Tuning, Query Optimization, Complex Stored Procedures, Triggers, User Defined Functions, and SQL joins.
• Experience working with source controls like TFS.
• Ability to meet deadlines delivering results, Quick to adapt and learn business rules, business process, new business tools and business best practices.
• Quick learner and flexible to adapt new technologies.

PERSONAL SKILLS:

• BCP Coordinator for projects.
• Anchor and managing Team events.
• Got spot s, Associate of month and associate of the Quarter.
• Passionate in learning new technology.

FUNCTIONAL SKILL:

• Experience in Resource Planning and Project Estimation.
• Good Understanding of Process Measures and Metrics followed in the Software Project Life Cycle.
• Handled Requirements Collection, Preparation of the Requirements Specification, High level and Low - level Design of various projects by interacting with Clinicians, Technical experts and UI Specialists.
• Good Knowledge in the Preparation of Unit Test Plan, Unit Testing and Integration Testing.
• Mentored/Lead fresh graduates and enabled them to become productive resources in a short span of time.

SKILLS SUMMARY:

Working Platforms: Windows

Programming Languages: SQL, PL/SQL, C # .Net, C.

Healthcare Product: Facets 5.7R3, HBS Modules -, Claims, Billing, Utilization Management, Customer Service.

Tools: Visual Studio 2015, TFS, UQT, Beyond compare

Domain: Healthcare

PROJECT EXPERIENCE:

Confidential, West desmoines

Product Specialist - Technical

Responsibilities:

• Mentoring and Facets and migration.
• Onsite collaboration and defining business requirements.
• Provide Scope and Estimations for Change Requests and Enhancements.
• Educate the team to understand the requirement better and finding the impacts .Always created the POC and provided to the team to complete their analysis.
• Provide multiple solutions to a problem and choose the best of the lot to meet client requirements.
• Creating new interfaces for extracting data from Facets to External systems using daily batch jobs. using SDLC and Agile Development Methods as part of the migration.
• Peer Review of Process checklist, Unit Test Plans and Test Data and validation scripts and Ensuring Quality of Production Deployment.
• UAT and support during deployment in PROD.
• Creating Weekly status report and utilization report.

Confidential

Product Specialist - Technical

Technologies Used: Facets, SQL server.

Responsibilities:

• Created an automation process for newborn member loading and claim processing.
• Created an automation process to improve the member matching logic in claim processing.
• Created interfaces for extracting data from Facets to External systems using daily batch jobs.
• Ensure quality work products are delivered to suit the business requirements.
• Created facets designs and documents by translation of functional designs.
• Prepared and maintained technical designs and unit test code.
• UAT and support during deployment in PROD.
• Creating Weekly status report and utilization report.

Confidential

Responsibilities:

• Understanding the business requirement(s) and attending client calls during the requirement phase of the project to make things clear.
• Provided knowledge transfers to the team about the requirement and make the team to understand the requirement better to deliver best quality components.
• Responsible for Creating estimates for the project and sharing it to the leads.
• Responsible to arrange/plan for the resources during emergency releases.
• Technical Design of the Applications & the key Interfaces.
• Designing User Interface (Screens) using DML and DDL statements.
• Development of Oracle PL\SQL objects.
• UTC Preparation, Unit Testing, Design, System Testing, System testing Support and documentation, UAT and support during deployment.
• Responsible to keep in touch with SIT/UAT teams during testing phase and fix the issues in quick time.
• System Testing, System testing Support and documentation, UAT and support during deployment.