OBJECTIVE:

I am a team player and look forward for opportunities which enable me to apply my skill set and knowledge to cater to the business needs of the organization and customers; thus learn and increase my understanding about the practical problems in the industry, as well give my best to take the organization to new heights.

EXPERIENCE SUMMARY:

• Over 15 years of progressive experience in Architecture, Analysis, Design, Development and support of web based and desktop software applications for Health Insurance (FACETS, HIPAA Gateway) Applications using .NET Framework and various databases.
• Strong professional experience in working with technologies like Visual Studio .NET 20XX/2017/2019, C#.NET, ASP.NET, VB.NET, .NET Framework 4.5/4.7, ADO.NET, Web services, AJAX and RESTFul API.
• Strong in design and development of highly relational and normalized database using Oracle 11g, MS SQL Server (2016/2019) and Sybase 12.5.
• Experienced in the analysis, design and implementation of applications using OOAD techniques and Design Patterns.
• Extensive knowledge of applying Object Oriented Analysis and Design (OOAD) concepts like Inheritance, Polymorphism, Encapsulation and Abstraction, Design Patterns like Singleton, Abstract Factory and Command Pattern.
• Strong experience in writing SQL queries, and T - SQL blocks like - Stored Procedures, User Defined Functions, Triggers and tuning procedures and queries.
• Experienced with Class diagrams, Use Case diagrams and Sequence diagrams using UML with MS VISIO and STAR UML.
• Experience with version Controls like Git, Team Foundation Server (TFS), Tortoise SVN and PVCS.
• An active team player with excellent communication, time management and presentation skills.
• Worked extensively with Iterative Agile Methodologies (extreme Programming, and SCRUM), Waterfall methodologies and Test-driven development (TDD).
• Ability to work in the complete software development life cycle involving in Analysis, Design, development and testing phase.
• Technology enthusiast and eager learner with the ability to successfully utilize new technologies and tools to build commercial quality products.
• Researched new technologies, evaluated their usefulness, and incorporated them into the existing architecture.
• Experience in providing architectural blueprints and end to end solution for payers to solve IT problems.
• Over 15 years of experience in various FACETS custom code development such as Extensions (XCOM/XWIN/Embedded), FXI web services, Interfaces and custom/core Batch jobs.
• Expertise in TriZetto FACETS 5.7/4. XX/3.xx and 2.96, a product used widely in the US Healthcare Payer industry with hands-on experience in Enrolment/, Billing, Commissions, Claims, Medical Plan and Provider modules.
• Deep understanding of Facets Data model and Data Dictionary.
• Expertise in trouble shooting the FACETS Core Batch, custom jobs and FACETS access setup .
• Extensive knowledge on Facets ITS Home/Host, HIPAA Gateway, MEET and CMU.
• Extensive knowledge in Facets Batch architecture and Build implementation of Facets.
• Experience in FACETS upgrades, legacy to migration to FACETS and new market implementation.
• Experience in Benefit Configuration, Medical Plan, Workflow and Provider/Network X configuration.
• Microsoft Certified Application Developer (5602490) in .NET Framework, C# and ASP.NET, SQL Server 2000 and XML Web services.
• Trizetto certified SME in .NET, SQL server and VBScript.

TECHNICAL SKILLS:

Languages:

Programming Languages: C#.Net, VB.Net, C, C++, VC++

Database Query Languages: PL/SQL, T-SQL (DDL, DML).

Scripting Languages: PowerShell, JavaScript, Perl and VB script.

Platforms/ Applications:

Microsoft Technologies: .Net X.0, .Net 4.5, ADO.Net, LINQ, WCF, Unit testing Framework, Mocking Framework.

Web Technologies: ASP.NET, Ajax, Html, Silverlight, JavaScript, AngularJS, Ado.Net, CSS and Xml.

FACETS 5.xx Online Application: XCOM, XWIN and Embedded extensions and FXI web services

DataBases: SQL Server 20xx/2016/ 2019, TSQL, PL/SQL, Oracle 8i/9i, 11g, Sybase 12.5

Software:

Design Tools: UML, Web UML Diagrams

GUI Tools: Visual Studio (20XX, 2017 and 2019) and VS Code.

Database Tools: Microsoft SQL Server 2008/2005/2000 , Toad, SQL Developer.

Deployment/Web Servers: IIS 6.0, 5.0

Version Controls: Git,VSS, Tortoise SVN, PVCS and TFS.

Testing Tools: NUnit Framework

Schedule Tools: Control-M, AutoSys

Operating Systems: Windows 2000 / XP, Windows Server 2003, Windows Server 2008

Reporting Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports, ODI.

Software Process Model: Traditional Waterfall Model, Agile Development (Scrum Process)

PROFESSIONAL EXPERIENCE:

Confidential

Facets Advisory Consultant/Architect

Responsibilities:

• Conducted Joint Application Design (JAD) meeting with vendors/external partners, client and developers to envision, model and provide initial models and designs that can be built.
• Designed the entire system based on requirements using various technologies such as Visual Studio Dot Net (C#, ASP.NET, SOAP, ADO.NET, MVC), PowerShell, SQL server.
• Working Daily with the Business users and Business Analyst to analyze the business requirements and preparation of Software Analysis Document (SAD).
• Developing Low Level Design Document and High-Level Design Document.
• Coordinating with the team for analyzing the requirement and resolving the issues.
• Helped to team in terms of technically and functionally (Facets).
• Assisted to Infrastructure team to in installation, validation and troubleshooting of Facets and other products.
• Used the Object-Oriented Programming (OOP) techniques and created classes (in C#.NET) for database access.
• Reviewed Detail design and software code in C#, PL/SQL and provided inputs to development team as needed, ensure the technical design is per company standards.
• Implementing the design documents in coding process using C# and SQL Server.
• Configuring Facets SA settings and installing Facets.
• Written SQL Stored procedures and involved in performance tuning application and stored procedures
• Responsible for code changes of shared library modules.
• Actively participated in developing Assemblies in C#.
• Developed custom Facets Custom extension (XWIN/Embedded) and web services using core FXI web services.
• Developed the Stored Procedures, Views and User-Defined Functions etc.
• Testing and validating data through the Graphical User Interface.
• Code Cleanup - including try catch blocks, closing all open database connections, logging exceptions etc.
• Involved in Code Review for business logic modules and prepared the code review documentation.
• Used Git for version control and code repository.
• Worked on effort estimation, dividing user stories, team co-ordination, client communication and Code reviews...etc.

Environment: Facets 5.7, FXI web Services, HIPAA Gateway, SMT, FEET, Extensions (XCOM/embedded) Visual Studio 2017, C#, WCF, Web Services, SSIS, Power Shell, Citrix, ADO.Net, CBI Framework, ETS Framework, GIT, SQL Server 2016, SEQ, Logstash, Commvault, Control-M.

Confidential

Sr. Consultant

Responsibilities:

• Working Daily with the Business users and Business Analyst to analyze the business requirements and preparation of Software Analysis Document (SAD).
• Developing Low Level Design Document and High-Level Design Document.
• Coordinating with the team for analyzing the requirement and resolving the issues.
• Helped to team in terms of technically and functionally.
• Written unit test cases for each module in the development using Unit testing of visual studio.
• Used the Object-Oriented Programming (OOP) techniques and created classes (in C#.NET) for database access.
• Implementing the design documents in coding process.
• Configuring Facets SA settings and installing Facets.
• Implemented user stories in coding using c# and oracle
• Written SQL packages and involved in performance tuning application and stored procedures
• Responsible for code changes of shared library modules.
• Actively participated in developing Assemblies in c#.
• Developed custom web services using core FXI web services.
• Developed the Stored Procedures, Views and User-Defined Functions etc.
• Testing and validating data through the Graphical User Interface.
• Code Cleanup - including try catch blocks, closing all open database connections, logging exceptions etc.
• Involved in Code Review for business logic modules and prepared the code review documentation.
• Used SVN for version control and code repository.
• Involved in writing test plans using Visual Studio.
• Worked on effort estimation, dividing user stories, team co-ordination, client communication and Code reviews...etc.

Environment: Facets 5.6, FXI, POS, Extensions (XCOM/embedded) Visual Studio 2015, C#, WCF, Web Services, SSIS, Citrix, ADO.Net, GIT, SQL Developer.

Confidential

Sr. Programmer Analyst

Responsibilities:

• Working Daily with the Business users and Business Analyst to analyze the business requirements and preparation of Software Analysis Document (SAD).
• Developing Low Level Design Document and High-Level Design Document.
• Coordinating with the team for analyzing the requirement and resolving the issues.
• Helped to team in terms of technically and functionally.
• Written unit test cases for each module in the development using Unit testing of visual studio.
• Used the Object-Oriented Programming (OOP) techniques and created classes (in C#.NET) for database access.
• Implementing the design documents in coding process.
• Implemented user stories in coding using c# and oracle
• Written SQL packages and involved in performance tuning application and stored procedures
• Extensively used LINQ to Entities to fetch the data from database.
• Responsible for code changes of shared library modules.
• Actively participated in developing Assemblies in c#.
• Developed the Stored Procedures, Views and User-Defined Functions etc.
• Testing and validating data through the Graphical User Interface.
• Code Cleanup - including try catch blocks, closing all open database connections, logging exceptions etc.
• Involved in Code Review for business logic modules and prepared the code review documentation.
• Used SVN for version control and code repository.
• Involved in writing test plans using Visual Studio.
• Trained new contractors on team standards, application coding guidelines, and provided an overview of the shared library modules.
• Worked on effort estimation, dividing user stories, team co-ordination, client communication and Code reviews...etc.

Environment: Facets 5.0/4.81/4.71 , Visual Studio 2008/2010, SQL Developer, Toad, C#, ASP.NET, AngularJS, Oracle 10g, LINQ, ADO.Net, Windows Communication Foundation (WCF), Enterprise Application Block, Tortoise SVN.

Confidential

Module Lead

Responsibilities:

• Responsible for writing SRS, Design and Implementation documents.
• Worked Daily with the on-site team to Analyzing Business Requirements and preparation of Software Analysis Document (SAD).
• Developed Low Level Design Document and High Level Design Document and A011
• Implemented the design documents in coding process.
• Gathering requirements and review current HealthWeb documentation.
• Study code and help update documentation as required.
• Gain a deep understanding of how HealthWeb works.
• Participate in the analysis, design and development of custom enhancements and upgrades.
• Develop a plan to help train new resources.
• Worked with team to create a HealthWeb development environment.
• Adherence to TriZetto and applicable clients coding standards
• Modify and or develop interfaces, extensions, and mini-apps associated with Facets.
• Development skills to include: Microsoft .NET, C#, ASP.NET, and RDBMS knowledge and design specification documentation as required for HealthWeb Core product.
• Worked on effort estimation, dividing user stories, team co-ordination, client communication and Code reviews...etc.
• Provided weekly status updates to Project Manager, Project lead and onsite coordinator.
• Mentor/Lead off-shore team and perform other duties assigned by TriZetto Configuration management which includes knowledge transfer.

Environment: Visual Studio 2008/2005, SQL Server, Sybase ASE12.5, SQL, C#, ADO.Net, Enterprise Application Block, PVCS, VB script, Perl Script, Citrix Network, Facets 4.41/4.71/4.8 , SQL Advantage for Sybase and Aqua Studio.

Confidential, Michigan

Module Lead

Responsibilities:

• Worked Daily with the on-site team to Analyzing Business Requirements and preparation of Software Analysis Document (SAD).
• Created high level and Low Level design of classes and data Model and completely relational and performance oriented DB.
• Designed UI layer, service interface layer, business classes and database interaction methods
• Developed a provider independent data access layer, with all the DB operations of ADO.NET implemented in it.
• Designed/developed the database, stored procedures for the application using Oracle 9i.
• Developed the Stored Procedures, Views and User-Defined Functions etc.
• Thoroughly Application tested for stability and scalable performance for more records.
• Testing and validating data through the Graphical User Interface.
• Code Cleanup - including try catch blocks, closing all open database connections, logging exceptions etc.
• Worked on effort estimation, dividing user stories, team co-ordination, client communication and Code reviews...etc.
• Mentor/Lead off-shore team and perform other duties assigned by TriZetto Configuration management which includes knowledge transfer.
• Provided weekly status updates to Project Manager and Team lead.

Environment: Facets 4.41, Visual Studio 2008, SQL Developer, Toad, C#, Oracle 9i, LINQ, ADO.Net, XML, Citrix Network, Tortoise SVN and VSS.

Confidential

Sr. Software Engineer

Responsibilities:

• Analyzed the requirements and significantly contributed in developing architecture for the application and developed UML Use Cases Diagrams.
• Responsible for creating the Class diagrams and Sequence diagrams using Star UML and documenting the project architecture.
• Worked Daily with the on-site team to Analyzing Business Requirements and preparation of Software Analysis Document (SAD).
• Created high level and Low Level design of classes and data Model and completely relational and performance oriented DB.
• Designed UI layer, service interface layer, business classes and database interaction methods
• Developed a provider independent data access layer, with all the DB operations of ADO.NET implemented in it.
• Designed/developed the database, stored procedures for the application using Oracle 9i.
• Thoroughly Application tested for stability and scalable performance for more records.
• Designed/developed the database, stored procedures for the application using Oracle 9i.
• Developed the Stored Procedures, Views and User-Defined Functions etc.
• Thoroughly Application tested for stability and scalable performance for more records.
• Testing and validating data through the Graphical User Interface.
• Code Cleanup - including try catch blocks, closing all open database connections, logging exceptions etc.

Environment: C#, XML, Oracle 9i, SQL Developer, Citrix Network, Facets 4.40 and Facets 4.41,Visual Studio 2008 and VSS.

Confidential, Michigan

Senior Software Engineer

Responsibilities:

• Created high level design of classes and data objects and completely relational and performance oriented DB.
• Designed UI layer, service interface layer, business classes and database interaction methods
• Designed/developed the database, stored procedures for the application using Sybase 12.5.
• Thoroughly all Extensions tested the application for stability and scalable performance for larger Input files.
• Created high level and Low Level design of classes and data Model and completely relational and performance oriented DB.
• Designed UI layer, service interface layer, business classes and database interaction methods

Environment: VB.NET, XML, Sybase ASE 12.5, SQL, Citrix Network, Facets 4.40 and Facets 4.41, Advantage for Sybase, Visual Studio 2005

Confidential, Denver, CO

Software Engineer

Responsibilities:

• Involved actively in writing the Business and Data Access logic using C#.
• Analysis, documentation, coding, unit testing and regression testing.
• Tuning the stored procedures.
• Team coordination.
• Involved in the documentation of the entire project and creating A011 document.
• Involved in writing complex queries, Triggers and Stored Procedures in SQL Server 2005.
• Writing business and data access components in C# utilizing ADO.NET for different databases (SQL Server 2005 and Oracle 10g).
• Responsible for maintaining versions of source code using Microsoft Visual Source Safe.
• Involved in debugging custom and core Trizetto batch jobs.

Environment: Net Framework 2.0, Visual Studio 2005, C#, ADO.Net, XML, VBScript, Sybase ASE 12.5, Citrix Network, Facets 4.21, Xml, Oracle 8i, PL/SQL, JavaScript, SQL Advantage for Sybase, Aqua Studio, MS-Access., Visual SourceSafe, PVCS.