EXPERIENCE SUMMARY:

• Has 16+ years of experience in Architecting, Analysis, design, development, implementation, maintenance and support for Client - server, Web, Enterprise and Integration applications in Healthcare, Logistics and Banking domains.
• About 12+ years of experience in Facets Product architecture, Database Architect, Development and maintenance of Oracle database & application
• Extensive Healthcare business domain knowledge in Commercial, Medicare and Medicaid Line of business.
• Extensive experience in Oracle 9i/10g/11g/12c - SQL & PL/SQL
• Extensive in-depth knowledge in Healthcare Facets product in / Enrollment and Claims module.
• Experienced on Oracle Performance tuning, Database Design and Data modeling wif expertise on Explain Plan, TKPROF and SQL Loader
• Vast experience on Extraction, Transformation and Load (ETL) strategy, design and implementation. Includes ETL across different platforms
• Excellent programming skills in PL/SQL, VB 6, VBA and Object Oriented Methodologies.
• 5+ US Onsite experience entails working wif clients/domain experts to analyze and define business requirements, Shaping functional, technical specifications and design, giving presentations, liaising between business groups and technical team.
• More than 2 years of experience in Agile - Scrum development, Involved in Product Backlog, Sprint backlog, Burn down chart, Sprint planning and retrospective meetings.
• More than 8 years of experience in Water fall development life cycle and involved Analysis, Design, Coding, Implementation and Maintenance phases.
• Experience coordinating, validating and undertaking unit and integration testing, overlooking the version control system and bug-tracking system.
• Excellent communication skills & very good team building and leading abilities and ability to articulate technical problems & solutions in a mixed team environment
• Diverse roles include Project Lead, Database Architect, Solutions Architect, System Analyst and Lead consultant. This involved close interactions wif client executives, Program Management Office, Project Managers and Oracle Support.
• Excellent Adherence of Project management process documents, me.e. Configuration Management Plan, Staffing Plan, Tracker, Change management, Metrics tracker, Milestones, Backup Plan, HR Plan…etc.
• Ability to communicate effectively and clearly between teams and resolve issues quickly.

TECHNICAL SKILLS:

Primary Skills: Analysis, Designing, Leading a Team and Implementation, Project Management

Operating System: Win9x/2000/Xp, Linux, Unix, Windows 7

Programming Languages: Oracle (PL/SQL), Unix Shell Script, VB 6, VBA

Databases & Tools: Oracle - 9i, 10g, 11g, 12c, SQL Server 2012, MS Access 2003/ 2007 and Oracle Sql Developer

Third Party Tools: Toad, PL/SQL Developer, SQL Query Analyzer

Product: Informatica 9.6, Healthcare product - Facets

SCM Tools: VSS, CVS, PVCS, TFS, JIRA

PROFESSIONAL EXPERIENCE:

Confidential

Facets solution Architect

Responsibilities:

• Involved in architecting multiple Confidential sequence and the respective inbound file processing steps and sequencing to the right order.
• Mentored team members in arriving at the technical solution for SI Custom components.
• Provided technical assistance to the team and calls wif Onsite on the Architecture discussions regarding any open issues.
• Gatheird business requirements, working closely wif business users, project leaders and developers. Analyzed the business requirements and designed conceptual and logical data models.

Environment: Oracle 12c, Facets R5.3

Confidential

Database Architect

Responsibilities:

• Involved in analyzing the TPL claim processing logic involving Medicare and Commercial carriers.
• Helped team members in writing the Pre-adjudication functionalities to handle the TPL requirements.
• Involved in resolving complex queries and optimized long running SQL and PL/SQL scripts for better performance.
• Provided technical assistance to the team and represented daily calls wif Onsite on the discussions regarding any open issues.

Environment: SQL Server 2012, Facets R5.3

Confidential

Database Architect

Responsibilities:

• Responsible for the whole project life cycle of Development which includes interacting wif Analyst and business users wif brain storming session theirby to understand the requirements.
• Integrated wif the clients and developed the Business Requirement.
• Presented Monthly Status Report and Monthly Dashboard Reports to Clients.
• Participated in all review meetings and in receiving sign off from the users.
• Helped team members in writing complex queries and optimized long running SQL and PL/SQL scripts for better performance.
• Prepared Weekly Status Report, Weekly Dashboard and presented to onshore.
• Involved in day-to-day meetings wif offshore team.
• Conducted Peer reviews on Pl/SQL code developed by the team members.
• Review the ETL mapping.
• Provided technical assistance to the team and represented daily calls wif Onsite on the discussions regarding any open issues.

Environment: Oracle SQL, PL/SQL, Facets, Oracle 11g, SQL Developer, Informatica 9.6

Confidential

Database Designer & Team Lead

Responsibilities:

• Involved in requirement analysis and provided the estimates for requirements
• Effectively coordinated wif the Offshore Team to ensure Quality deliverables
• Involved in Deployment of the changes in Citrix environment, local shared drive
• Worked closely wif offshore development team.
• Ensures the review and delivery of on-time and high quality project deliverables
• Communicates all project issues related to system design, development, testing, and deployment
• Identified and evaluated technology risks.
• Participated in business meetings and developed work estimates.
• Reported and co-coordinated wif all stakeholders.
• Tracking the efforts of all the team members and ensure effective resource utilization
• Handled a team of 4 developers
• Involved in Review of all the deliverables and ensured on time delivery

Environment: Oracle SQL, PL/SQL, VBA, Oracle 11g, SQL Developer

Confidential

Database Sr. Developer

Responsibilities:

• Created deployment scripts.
• Involved in requirement analysis.
• Managed all database artifacts in UBH.
• Developed PL/SQL, SQL programs.
• XML file template creation
• Optimized performance by analyzing query patterns.
• Review of Technical design Documents, Code framework Documents, Unit test plan Documents and Unit Test Logs

Environment: Oracle SQL, PL/SQL, Facets, Oracle 9g, SQL Developer

Confidential

Database Sr. Developer

Responsibilities:

• Base packages developed which is common irrespective of TP specification.
• Involved in development phase of the project
• New plug-in Procedures, Triggers need to be developed as per the business requirements, which are called for the particular message from the Processing steps.
• Support to the new message during the stabilization period.

Environment: Axway XIB, Oracle SQL, PL/SQL, Oracle 9i, TOAD

Confidential

Database Sr. Developer

Responsibilities:

• Involved in making enhancements in Design and Coding of the corresponding Interfaces based on the BRD (Business Requirement Document).
• Involved in Writing Oracle functions, Procedures and Packages
• Performing Testing on the Changed Functionalities.

Environment: Axway XIB, Oracle SQL, PL/SQL, Oracle 9i, TOAD

Confidential

Database Developer

Responsibilities:

• Maintenance of this application and log the difference in the format between the versions.
• Enhancement changes are done in Oracle PL/SQL codes
• Involved in performing unit testing on developed code.

Environment: Oracle SQL, PL/SQL, Oracle 9i, TOAD

Confidential

Database Developer

Responsibilities:

• Prepare the Data Dictionary Document and Technical Manual wif the identified Procedures, Functions and Views and update for the HLD Delivery.
• Entity Relationship (ER) Diagram using Oracle Designer.
• Creation and Maintenance of the NAOS and NBSM Database as separate Instance.
• Developing Procedures and Functions using PL/SQL for performing validations
• Assign the Tasks to the Oracle team Members
• Preparing the Program Specification, Coding and Test cases for the PL/SQL Programs.

Environment: Lotus Domino R6, Java, Forms 6i, COM, SQL and PL/SQL and Toad

Confidential

Application Developer

Responsibilities:

• Understanding the requirements.
• Done Screen Design, Programming Documents.
• Done Coding and Created the Components.
• Performing Unit testing on the Developed code.

Environment: VB 6.0, COM, ASP 3.0, SQL Server 2000

Confidential

Application Developer & DB Designer

Responsibilities:

• Done Database Design, Analysis and Procedures documents.
• Done Unit Testing.

Environment: VB 6.0, COM, Oracle 8i & 9i

Confidential

Application Developer & DB Designer

Responsibilities:

• Done Database Design, Analysis and Procedures documents.
• Done Manual Test and written Stored Procedure in Oracle.

Environment: VB 6.0, COM, Oracle 8i & 9i