• As Project Manager:Agile (Scrum) i had the opprtunity to work in large production environments with database implementation on Unix, Window, Oracle and Java.
• Implemented Agile Scrum Methodology throughoutthe organization to improve communications between Engineering, Product Management, and business, to provide more transparency across the 3 departments, and to obtain great business value with short turnarounds.
• Coached/Mentored a cross functional team of 18 resources to deliver quality products which led to over $3.5Min revenue for the year of 2017/2018.Utilized Agile Scrum practices to help the team increase their velocity by 63% within the first year of agile adoption.
• Experience as Enterprise Agile coach, coaching product owners, teams and leadership using Scrum framework.
• Improved team velocityby incorporating capacity planning into sprint planning sessions.
• Facilitated Release Planning, Sprint Planning, Backlog Grooming, and Retrospective meetings.
• Removed team impediments on a daily basis to allow the team to deliver the sprint goals and deliverables.
• Facilitated Spring Retrospectives to build good working relationships among the agile teams.
• Collaborated with members of the Product, Business & Engineering Teams to develop & maintain Backlogs.

• WellCare Health Plans, Inc. provides managed care services exclusively for government-sponsored health care programs, focusing on Medicaid and Medicare. Headquartered in Tampa, Florida, WellCare offers a variety of health plans for families, children, and the aged, blind and disabled, as well as prescription drug plans. The Company served approximately 2.2 million members as of March 31, 2010.
• As per the Medicare Prescription Drug, Improvement, and Modernization Act of 2003 (MMA) established a new program for private plans called Medicare Advantage (MA), WellCare offers both a Medicare Advantage plan as well as a Prescription Drug Plan.  Development and maintenance of Wellcare-Encounters project.

Encounter

• The term “Encounter” refers to the superset of all professional and institutional, fee-for-service claims;capitated and delegated encounters; and “carve-out” encounter data across all health services (medical, dental, behavioral, pharmacy, and laboratory), including laboratory results.
• Claim – The term Claim refers only to those records submitted by recognized providers to WellCare with the expectation of a fee-for-service payment. Essentially, a claim is an encounter submitted by a recognized provider organization for a WellCare member that is adjudicated and, unless denied, reimbursed and paid through the Peradigm claim system.

• Non-Claim Encounter –The term Non-Claim encounter refers to those records of clinical services submitted by Providers, Vendors and Customers (For Example: States) for purposes other than fee-for-service reimbursement. These include:
  • Medical, as submitted by capitated or delegated provider entities.
  • Behavioral, as submitted by vendors (eg: Magellan) or submitted by carve out vendors.
  • Dental, as submitted by Doral or submitted by carve out vendors.
  • Pharmacy, as submitted by WHI or by carve out vendors.
  • Laboratory, as submitted by Quest or LabCorp, including laboratory test results.
  • History, as submitted by States or other customers which could include any subset of non-claim encounters.
• Used parametric cursors and ref cursors for performing DML operations involving multiple records. 
• Created database objects like table, views and sequences.
• Involved in developing, testing and deploying backend procedures, function &   packages in    PL/SQL.
• Involved in loading data from legacy system via SQL* loader.
• Worked on optimizing existing procedures and functions. 
• Knowledge of Claims adjudication process.
• Used Oracle JDeveloper as IDE for developing Java Application and creation web pages for users to view and change the data.

• LexisCheck a.k.a UK CiteCheck is a tool designed to automatically check legal references as you draft documents. LexisCheck is developed for lawyers using technology that fits within existing document workflows.
• Lexis®Check Draft is meant for finding legal citations in a word document and its corresponding signals of a law firm. This is a Microsoft Word plug-in, targeted for MS Word versions from 2002 (Office XP). This plug-in will be available for any instance of word application as a toolbar after the user has installed in the PC. This product is used to find the legal/legislation citations available in a word document. Once the product is launched by clicking Details view button from the toolbar, it finds the citations in the current document and lists in a separate window.
• The user can navigate through citations list and each item will be highlighted in the word document while navigating. The user has the ability to insert a chosen citation from the list back into the document to make the legal document content consistent.
• Lexis®Check  Provides,
  • Signals.
  • Parallels.
  • Court details.
  • Practice Areas.
  • Validation of parallels.
  • Decision date.
• JCite takes care of few things about UK CiteCheck are:
  • It uses a different CFE tree for recognition.
  • It is calling US through WSK/WSAPI
• Involved in developing, testing and deploying backend procedures, function & packages in PL/SQL.
• Used PL/SQL tables and records in transaction processing.
• Used DBMS_Schedulerfor automatic execution of package.
• Worked on optimizing existing procedures and functions. 
• Involved in schema design, query construction, performance tuning.
• Used Oracle materialized views / snapshots, clusters and partitions for faster query performance.
• Improved query performance through bit map & function based indexes, explain plan, analyze, hints & joins.
• Involved in Prod Support * Implementation of DB, contributed towards database infrastructure enhancements. 
• Used parametric cursors and ref cursors for performing DML operations involving multiple records. 
• Created database objects like table, views and sequences.
• Used Oracle JDeveloper as IDE for developing Java Application and creation web pages for users to view and change the data

• VNSNY Home care involves in getting in authorizations from various health insurance carries, providing the home health care services. This project is to analyze, develop, design and test pl/sql coding and reports. Track and troubleshoot the transmissions from Nurses data and provide the report to the business users and management.
• Requirement gathering from business users and designed the functional and technical requirement document phase wise. Participated in understanding the business and documenting business rules, functional        Specifications use cases.
• Identifying business, mapping criteria from web browser to the database tables and fields entities and relationships design and making modifications to the existing the data model.
• Analyzed the architecture and made design changes to the application/data model by performing the reverse engineering.
• Performed the tuning creating the indexes and using the hints and checking with explain plan.
• Inserted the data into Managed Care database tables using SQL loaderby writing the control files.
• Developed PL/SQLStored Procedures/Packagesand Reports with extensive use of SQL Query, Joining tables, SQL functions in Queries.
• Wrote the Procedures, packages and wrote the shell scripting for automation of execution of the procedures.
• Doing the analysis of the data and comparing created the reports and graphical reports for the management. 
• Used TOADfor creating PL/SQL and SQL Scripts to debug and test the code.
• Created the reports/workbooks according the needs of business users and shared the workbooks to the users by creating the user parameters, joins out of tables and views.
• Troubleshoot and resolves software and configuration problems, trained to use the DiscovererReports.
• Wrote shell scripts to automate execution of procedures, packages.
• Created the reports to get the Patients authorizations information on timely basis weekly, monthly.
• Wrote SQL,PL/SQL proceduresto extract the data from MCS tables for creating the MCS reports, Externally and Internally for Managed Care on daily, weekly and monthly basis.
• Wrote Shell scripts to incorporate the PL/SQL coding.
• Coding & Debugging, Sorting out their time-to-time technical problems.
• Tested the code and checked the results. Performed the Unit testing.
• Supported and troubleshoot the issues handled the production level 2 support on 24X7 basis.
• Created the new and ad-hoc reports using Discoverer with parameters, Calculations and conditions.
• Created the MS Access reports for the Adult Home matching Project evaluation report and wrote macros.

Project Details:       Design and Development ofBanking System. Worked as system analyst, designer, programmer and module leader. The banking system consisted of modules such as bank master, bank transaction, view/deletion ofbank master, view/deletion of bank transaction, loans and reports. I was the module leaderfor the above underlined modules.

Key Responsibilities:

• Requirement analysis & specification, system study and preparation of design documents.
• Dataflow diagrams for transaction and information flow.
• Database modeling & design, Normalizations including scheme objects.
• Design and development of forms and reports.
• DBA roles like creating user, granting roles, table spaces.
• Coding, testing, implementation of forms and reports.
• Optimization of reports. Created thedatabase triggers, stored procedures and functionsfor the validation of input data and implementing business rules.
• Worked on optimizing existing PL/SQLpackages, procedures, functions, views to suit business needs.
• Used different exception handlers and created some user defined exception handlers. 
• Extensively involved in developing transaction forms and customization of support screens, involving a lot of validations at all the levels like field, block and form level.
• Oracle Reports was used as the reporting tool incorporating and invoking the reports from the forms itself.
• Experience in data warehousing (star schema), DataMart and Cube Development.