WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6182

DataAudit_Duplicate rates

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Data Correction
    • Environment:
      Production
    • Reported by:
      Harbinger
    • Module:
      BenAdmin - Enrollment
    • Issue Importance:
      Must Have

      Description

      Please find the attached Excel for duplicate rates from production.

      Amruta Lohiya,Samir,Vijay Siddha,shyam sharma

        Attachments

          Issue Links

          relates to

          Support Activity - Support Activity WT-6178 Data Analysis

          • High - Serious problem that could block progress.
          • Resolved

            Activity

            Ascending order - Click to sort in descending order
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) created issue -
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Amruta Lohiya [ amruta.baheti ]
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
            Link This issue relates to WT-6178 [ WT-6178 ]
            Hide
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Hi Amruta Lohiya

            Any update on this

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Amruta Lohiya Any update on this
            amruta.lohiya Amruta Lohiya made changes -
            Assignee Amruta Lohiya [ amruta.baheti ] Avnish Yadav [ avnish.yadav ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Attachment DuplicateRates_11_24_2016.zip [ 33434 ]
            Hide
            Permalink
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

            Hi All,

            Please find latest data audit for duplicate rates in an attachment. DuplicateRates_11_24_2016.zip

            Password will be shared in mail.

            CC: Samir Nandkumar Prabhakar Karlekar

            Show
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Hi All, Please find latest data audit for duplicate rates in an attachment. DuplicateRates_11_24_2016.zip Password will be shared in mail. CC: Samir Nandkumar Prabhakar Karlekar
            Hide
            Permalink
            avnish.yadav Avnish Yadav (Inactive) added a comment -

            Hi All,

            We have completed data correction for TIBCO company on Production.

            Thanks,
            Avnish Y

            Show
            avnish.yadav Avnish Yadav (Inactive) added a comment - Hi All, We have completed data correction for TIBCO company on Production. Thanks, Avnish Y
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 01/Dec/16 01:42 AM
            • Time Spent:
              4h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Description
            Please find the attached Excel for duplicate rates from production.

            [~amruta.lohiya],[~samir],[~vijays],[~shyam.sharma]             		Please find the attached Excel for duplicate rates from production.

            [~amruta.lohiya],[~samir],[~vijays],[~shyam.sharma]
            Environment Production [ 10005 ]
            Issue Category EBS [ 10350 ]
            Remaining Estimate 35h [ 126000 ]
            Original Estimate 35h [ 126000 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 35h [ 126000 ] 31h [ 111600 ]
            Time Spent 4h [ 14400 ]
            Worklog Id 11015 [ 11015 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 01/Dec/16 04:33 PM
            • Time Spent:
              5h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 02/Dec/16 04:34 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 06/Dec/16 04:40 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 07/Dec/16 04:44 PM
            • Time Spent:
              2h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 12/Dec/16 06:09 PM
            • Time Spent:
              3h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 31h [ 111600 ] 26h [ 93600 ]
            Time Spent 4h [ 14400 ] 9h [ 32400 ]
            Worklog Id 14107 [ 14107 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 26h [ 93600 ] 22h [ 79200 ]
            Time Spent 9h [ 32400 ] 13h [ 46800 ]
            Worklog Id 14108 [ 14108 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 22h [ 79200 ] 18h [ 64800 ]
            Time Spent 13h [ 46800 ] 17h [ 61200 ]
            Worklog Id 14112 [ 14112 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 18h [ 64800 ] 16h [ 57600 ]
            Time Spent 17h [ 61200 ] 19h [ 68400 ]
            Worklog Id 14116 [ 14116 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 16/Dec/16 06:08 PM
            • Time Spent:
              3h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 16h [ 57600 ] 13h [ 46800 ]
            Time Spent 19h [ 68400 ] 22h [ 79200 ]
            Worklog Id 14127 [ 14127 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 13h [ 46800 ] 10h [ 36000 ]
            Time Spent 22h [ 79200 ] 25h [ 90000 ]
            Worklog Id 14128 [ 14128 ]
            satyap Satya made changes -
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
            Hide
            Permalink
            mandark Mandar Kulkarni (Inactive) added a comment -

            Hi Nandkumar Prabhakar Karlekar,
            Shall we close this ticket now?

            --------------------------------
            CC: Vijay Siddha, Satya

            Show
            mandark Mandar Kulkarni (Inactive) added a comment - Hi Nandkumar Prabhakar Karlekar , Shall we close this ticket now? -------------------------------- CC: Vijay Siddha , Satya
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 21/Mar/17 12:55 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 22/Mar/17 12:57 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 23/Mar/17 12:58 PM
            • Time Spent:
              6h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 24/Mar/17 01:00 PM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 27/Mar/17 01:01 PM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 29/Mar/17 01:01 PM
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 30/Mar/17 12:00 AM - edited
            • Time Spent:
              0.75h
               

              Austin Enrollment Audit impact on Billing Table

            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 6h [ 21600 ]
            Time Spent 25h [ 90000 ] 29h [ 104400 ]
            Worklog Id 34876 [ 34876 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 6h [ 21600 ] 2h [ 7200 ]
            Time Spent 29h [ 104400 ] 33h [ 118800 ]
            Worklog Id 34879 [ 34879 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 33h [ 118800 ] 39h [ 140400 ]
            Worklog Id 34884 [ 34884 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 39h [ 140400 ] 43h [ 154800 ]
            Worklog Id 34888 [ 34888 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 43h [ 154800 ] 51h [ 183600 ]
            Worklog Id 34889 [ 34889 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 51h [ 183600 ] 59h [ 212400 ]
            Worklog Id 34890 [ 34890 ]
            Permalink
            prasanna Prasanna Karlekar (Inactive) logged work - 31/Mar/17 12:00 AM
            • Time Spent:
              0.5h
               

              Discussion on Billing Data correction post Enrollment team

            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 59h [ 212400 ] 67h [ 241200 ]
            Worklog Id 35168 [ 35168 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Worklog Id 35168 [ 35168 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 67h [ 241200 ] 67.5h [ 243000 ]
            Worklog Id 35343 [ 35343 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Time Spent 67.5h [ 243000 ] 68.25h [ 245700 ]
            Worklog Id 35348 [ 35348 ]
            prasanna Prasanna Karlekar (Inactive) made changes -
            Worklog Id 35348 [ 35348 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 31/Mar/17 05:13 PM - edited
            • Time Spent:
              8h
               
              <No comment>
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 19/Apr/17 09:24 AM
            • Time Spent:
              0.5h
               

              Pre-Analysis

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 68.25h [ 245700 ] 68.75h [ 247500 ]
            Worklog Id 39957 [ 39957 ]
            satyap Satya made changes -
            Issue Category EBS [ 10350 ] Harbinger [ 10700 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 29/Jun/17 05:46 PM
            • Time Spent:
              8h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 68.75h [ 247500 ] 76.75h [ 276300 ]
            Worklog Id 59689 [ 59689 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 30/Jun/17 09:58 AM
            • Time Spent:
              8h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 76.75h [ 276300 ] 84.75h [ 305100 ]
            Worklog Id 59971 [ 59971 ]
            Permalink
            avnish.yadav Avnish Yadav (Inactive) logged work - 05/Jul/17 04:56 PM
            • Time Spent:
              8h
               
              <No comment>
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Time Spent 84.75h [ 305100 ] 92.75h [ 333900 ]
            Worklog Id 61009 [ 61009 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 11/Jul/17 09:54 AM
            • Time Spent:
              5h
               

              Discussion with Avnish - On Ticket and Task - Rates Data Audit. 1 hr

              WT-6182 Data Audit Work - Ticket to be asked to Avnish - 4 hr

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 11/Jul/17 05:53 PM
            • Time Spent:
              2h
               

              understanding the process from prashant
              data auditing
              verifying the same on the templates checking for the rate fields mapped
              verifying through backend

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 12/Jul/17 10:54 AM
            • Time Spent:
              8h
               

              WT-6182 Data Audit Work -

              Auditing

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 12/Jul/17 05:31 PM
            • Time Spent:
              7h
               

              Discussion with prashant about rate verification.
              Analysis of rate duplication on mentioned companies.
              Verified impact of rate duplication.

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 12/Jul/17 05:52 PM
            • Time Spent:
              7h
               

              disscussing about the duplicate rates with Prashant
              verifying the rates through the files and database
              carriyng out different scenarios to check for the duplicate rates going on the files

            Hide
            Permalink
            avnish.yadav Avnish Yadav (Inactive) added a comment -

            Hi Prashant Samal,

            We have corrected duplicate rates on "FDAC EBA for HSPL". Can you please verify the same on Export change file.

            Thanks,
            Avnish Y

            CC-- Amruta Lohiya

            Show
            avnish.yadav Avnish Yadav (Inactive) added a comment - Hi Prashant Samal , We have corrected duplicate rates on "FDAC EBA for HSPL". Can you please verify the same on Export change file. Thanks, Avnish Y CC-- Amruta Lohiya
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Assignee Avnish Yadav [ avnish.yadav ] Prashant Samal [ prashant.samal ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 92.75h [ 333900 ] 97.75h [ 351900 ]
            Worklog Id 63021 [ 63021 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 97.75h [ 351900 ] 105.75h [ 380700 ]
            Worklog Id 63023 [ 63023 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 105.75h [ 380700 ] 109.25h [ 393300 ]
            Worklog Id 63027 [ 63027 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 13/Jul/17 10:59 AM
            • Time Spent:
              3.5h
               

              WT-6182 Data Audit Work -

              Data Audit

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 13/Jul/17 12:33 PM
            • Time Spent:
              1h
               

              Verification on Production HSPL copy

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 109.25h [ 393300 ] 110.25h [ 396900 ]
            Worklog Id 63102 [ 63102 ]
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Avnish Yadav,

            I have verified random records for this data correction on UI as well as Billing details Report on HSPL copy. They seem to correct. Please do this on main company.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Avnish Yadav , I have verified random records for this data correction on UI as well as Billing details Report on HSPL copy. They seem to correct. Please do this on main company. Sachin Hingole Thanks, Venkatesh
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 13/Jul/17 05:08 PM
            • Time Spent:
              3.5h
               

              discussing with prashant about WT-6182
              verified the rates on the file as well as in the database
              mapping the rate fields on respective templates
              reporting about the issue

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 13/Jul/17 05:34 PM
            • Time Spent:
              7h
               

              Verified of rate duplication.
              Verified impact on templates after correction done on FDAC.

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 110.25h [ 396900 ] 112.25h [ 404100 ]
            Worklog Id 63232 [ 63232 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 14/Jul/17 09:00 AM
            • Time Spent:
              5h
               

              General Meeting for planning of tasks - 1 hr

              Data Audit - 4 hr

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 14/Jul/17 01:02 PM - edited
            • Time Spent:
              5h
               

              Data Audit Scenarios

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 14/Jul/17 05:35 PM
            • Time Spent:
              3.5h
               

              verifying the rates for company softchoice on HSPL
              mapping the rates fields on the templates
              exporting the templates
              verifying the rates
              reporting the employees

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 14/Jul/17 05:38 PM
            • Time Spent:
              3.5h
               

              verifying the rates for company SBM on HSPL
              mapping the rates fields on the templates
              exporting the templates
              verifying the rates
              reporting the employees

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 14/Jul/17 05:38 PM
            • Time Spent:
              3h
               

              Meeting of 'impact of 12 parameters on exported files'
              Checked impact of rate duplication.

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 112.25h [ 404100 ] 115.75h [ 416700 ]
            Worklog Id 63738 [ 63738 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 115.75h [ 416700 ] 120.75h [ 434700 ]
            Worklog Id 63741 [ 63741 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 120.75h [ 434700 ] 127.75h [ 459900 ]
            Worklog Id 63769 [ 63769 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 127.75h [ 459900 ] 134.75h [ 485100 ]
            Worklog Id 63778 [ 63778 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 134.75h [ 485100 ] 138.25h [ 497700 ]
            Worklog Id 63779 [ 63779 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 138.25h [ 497700 ] 141.75h [ 510300 ]
            Worklog Id 63781 [ 63781 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 141.75h [ 510300 ] 144.75h [ 521100 ]
            Worklog Id 63782 [ 63782 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 144.75h [ 521100 ] 151.75h [ 546300 ]
            Worklog Id 63809 [ 63809 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 151.75h [ 546300 ] 153.75h [ 553500 ]
            Worklog Id 63821 [ 63821 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 17/Jul/17 09:00 AM
            • Time Spent:
              7h
               

              Testing
              Analysis,
              Discussions with Dev,
              Meetings with Amit,
              Audit for UVU and Employebridge's remaining scenarios

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 17/Jul/17 05:21 PM
            • Time Spent:
              7h
               

              Data Audit
              Analysis
              Discussion with Prashant
              Checking the wromg member coverages scenarios
              company- Merrillville

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 17/Jul/17 05:43 PM
            • Time Spent:
              7h
               

              Discussion with amit regarding 12 parameters.
              Analysis of wrong member coverage and tested same for reported employees and company.

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 18/Jul/17 09:00 AM
            • Time Spent:
              7h
               

              Analysis,
              Discussions with Dev,
              Meetings with Amit,
              Audit for UVU's new scenarios.

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 153.75h [ 553500 ] 160.75h [ 578700 ]
            Worklog Id 64260 [ 64260 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 160.75h [ 578700 ] 167.75h [ 603900 ]
            Worklog Id 64261 [ 64261 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 18/Jul/17 05:46 PM
            • Time Spent:
              7h
               

              Discussion with prashant.
              Checked rates duplication and duplicate elections on bulk company.

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 19/Jul/17 09:00 AM
            • Time Spent:
              4h
               

              Data Audit

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 167.75h [ 603900 ] 171.75h [ 618300 ]
            Worklog Id 64669 [ 64669 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 171.75h [ 618300 ] 173.25h [ 623700 ]
            Worklog Id 64671 [ 64671 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 173.25h [ 623700 ] 175.25h [ 630900 ]
            Worklog Id 64672 [ 64672 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 19/Jul/17 01:00 PM
            • Time Spent:
              1.5h
               

              Discussion with Avnish, Amruta, Yogita and Satya for Scenarios's
              RCF Meeting

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 19/Jul/17 02:30 PM
            • Time Spent:
              2h
               

              Data Audit Continued after for new tabs as requested by Satya and Amruta for Impact Report

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 19/Jul/17 05:51 PM
            • Time Spent:
              3h
               

              Checked wrong health tier ID and plan end election active parameters on bulk companies.

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 20/Jul/17 10:08 AM
            • Time Spent:
              6h
               

              Audit and Analysis Continued..

            Hide
            Permalink
            avnish.yadav Avnish Yadav (Inactive) added a comment - - edited

            Hi Venkatesh Pujari,

            We have corrected duplicate rates on "FDAC EBA" on production. Can you please verify the same .

            Thanks,
            Avnish Y

            CC- Sachin Hingole,Rakesh Roy, Amruta Lohiya,Satya

            Show
            avnish.yadav Avnish Yadav (Inactive) added a comment - - edited Hi Venkatesh Pujari , We have corrected duplicate rates on "FDAC EBA" on production. Can you please verify the same . Thanks, Avnish Y CC- Sachin Hingole , Rakesh Roy , Amruta Lohiya , Satya
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Assignee Prashant Samal [ prashant.samal ] Venkatesh Pujari [ venkatesh.pujari ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 175.25h [ 630900 ] 181.25h [ 652500 ]
            Worklog Id 65096 [ 65096 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 21/Jul/17 12:00 PM
            • Time Spent:
              4h
               

              Meeting
              Analsysis
              Discussion with Satya for scenarios

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 21/Jul/17 05:36 PM
            • Time Spent:
              1h
               

              documenting the duplicate rates scenario
              along wit verifying the same on the database

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 181.25h [ 652500 ] 188.25h [ 677700 ]
            Worklog Id 65450 [ 65450 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 188.25h [ 677700 ] 195.25h [ 702900 ]
            Worklog Id 65458 [ 65458 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 195.25h [ 702900 ] 202.25h [ 728100 ]
            Worklog Id 65460 [ 65460 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 202.25h [ 728100 ] 205.25h [ 738900 ]
            Worklog Id 65462 [ 65462 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 24/Jul/17 08:00 AM
            • Time Spent:
              7h
               

              Data Audit Scenarios

              Discussion with Yogita and Kanchan for scenarios understanding and Explaination for preparing documents

              Analysis Continued

            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 24/Jul/17 09:02 AM - edited
            • Time Spent:
              1.5h
               
              <No comment>
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Hi Avnish Yadav,

            I have verified random records for this data correction on UI as well as Billing details Report on main copy. They seem to correct.

            Sachin Hingole

            Thanks,
            Venkatesh

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Avnish Yadav , I have verified random records for this data correction on UI as well as Billing details Report on main copy. They seem to correct. Sachin Hingole Thanks, Venkatesh
            Hide
            Permalink
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

            Testing completed

            Show
            venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Testing completed
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Assignee Venkatesh Pujari [ venkatesh.pujari ] Avnish Yadav [ avnish.yadav ]
            Resolution Done [ 10000 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 205.25h [ 738900 ] 206.25h [ 742500 ]
            Worklog Id 65581 [ 65581 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 24/Jul/17 05:09 PM
            • Time Spent:
              7h
               

              Created document for Plan End Election Active parameter
              for impact scenarios and no impact scenarios.

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 24/Jul/17 05:22 PM
            • Time Spent:
              6h
               

              discussion with prashant
              verifying wrong members coverage scenarios and documenting the same
              verifying the same through database

            venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
            Time Spent 206.25h [ 742500 ] 206.75h [ 744300 ]
            Worklog Id 65581 [ 65581 ]
            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 25/Jul/17 05:14 PM
            • Time Spent:
              3h
               

              Checked null health tier id parameter and imapct of same on export files.
              Started to create document for same.

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 25/Jul/17 05:24 PM - edited
            • Time Spent:
              7h
               

              verifying the wrong member coverage scenario on company Hallmark

              Verifying the scenario employee terminate and enrollment active
              Discussion with Prashant
              Documenting the Impact and Non Impact Scenarios

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 26/Jul/17 02:00 PM
            • Time Spent:
              1h
               

              Discussion with Kanchan for discussion of the scenarios with Satya and Avnish

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 206.75h [ 744300 ] 210.75h [ 758700 ]
            Worklog Id 66727 [ 66727 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 210.75h [ 758700 ] 217.75h [ 783900 ]
            Worklog Id 66729 [ 66729 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 217.75h [ 783900 ] 220.75h [ 794700 ]
            Worklog Id 66732 [ 66732 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 220.75h [ 794700 ] 227.75h [ 819900 ]
            Worklog Id 66745 [ 66745 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 227.75h [ 819900 ] 233.75h [ 841500 ]
            Worklog Id 66749 [ 66749 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 233.75h [ 841500 ] 240.75h [ 866700 ]
            Worklog Id 66751 [ 66751 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Worklog Id 66751 [ 66751 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 240.75h [ 866700 ] 241.75h [ 870300 ]
            Worklog Id 66766 [ 66766 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 241.75h [ 870300 ] 242.75h [ 873900 ]
            Worklog Id 66769 [ 66769 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 31/Jul/17 10:24 AM
            • Time Spent:
              5h
               

              verifying the employees for terminated emloyees active election fro company
              Hallmark Aviation Services
              discussing the scenarios with Prashant

              verfying the Rate Beyond End Date Scenario
              Documenting simultaneously

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 242.75h [ 873900 ] 247.75h [ 891900 ]
            Worklog Id 68231 [ 68231 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 02/Aug/17 09:02 AM
            • Time Spent:
              5.5h
               

              Remaining Audit Scenarios- Documents review made by Yogita and Kanchan - 2hr

              Data Analysis for meeting - and discussion with Satya and team - 3 hr

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 02/Aug/17 04:55 PM
            • Time Spent:
              2h
               

              verifying for the Plan End Election Active Scenario on company Marin General Hospital

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 03/Aug/17 09:06 AM
            • Time Spent:
              6h
               

              Data Audit Remaining Scenarios and discussion of the analysis documents which were remaining built by team

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 247.75h [ 891900 ] 249.75h [ 899100 ]
            Worklog Id 69337 [ 69337 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 04/Aug/17 10:00 AM - edited
            • Time Spent:
              6h
               

              Data Audit Finding root causes of Plan End Election active for different companies and different scenarios

              Templates Information for ONU and Marin General Hospital

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 08/Aug/17 09:35 AM
            • Time Spent:
              6h
               

              12 Points Data Audit - Bulk Companies round 1 reporting

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 249.75h [ 899100 ] 255.25h [ 918900 ]
            Worklog Id 70322 [ 70322 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 255.25h [ 918900 ] 261.25h [ 940500 ]
            Worklog Id 70325 [ 70325 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 261.25h [ 940500 ] 267.25h [ 962100 ]
            Worklog Id 70404 [ 70404 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Worklog Id 70404 [ 70404 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 09/Aug/17 09:36 AM
            • Time Spent:
              6h
               

              12 Points Data Audit - Bulk Companies round 1 reporting - 5hr

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 10/Aug/17 09:36 AM
            • Time Spent:
              5h
               

              12 Points Data Audit - Bulk Companies round 1 reporting - 5hr

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 11/Aug/17 09:37 AM - edited
            • Time Spent:
              7h
               

              Data Audit - 4 hr

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 14/Aug/17 09:00 AM
            • Time Spent:
              2.5h
               

              Data Audit

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 17/Aug/17 04:16 PM
            • Time Spent:
              1.5h
               

              Data Audit on duplicate rates for below companies
              Asml
              City of Durham
              ESBA
              GBAPS
              Liberty Hospital
              Lily
              SBM
              STEP

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 267.25h [ 962100 ] 268.75h [ 967500 ]
            Worklog Id 72333 [ 72333 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 18/Aug/17 09:44 AM
            • Time Spent:
              3.5h
               

              Data Audit Scenarios -

              Analysis and Root cause - Marking for discussions with Satya and Avnish
              Making Data and Analyzed companies as marked -

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 18/Aug/17 01:47 PM - edited
            • Time Spent:
              2.5h
               

              Discussion for the scenarios with Satya and Avnish.

              Analysis and Root cause -Company wise updates on each tabs upto plan end election update.

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 268.75h [ 967500 ] 274.75h [ 989100 ]
            Worklog Id 72940 [ 72940 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 274.75h [ 989100 ] 280.75h [ 1010700 ]
            Worklog Id 72941 [ 72941 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 280.75h [ 1010700 ] 285.75h [ 1028700 ]
            Worklog Id 72942 [ 72942 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 285.75h [ 1028700 ] 289.75h [ 1043100 ]
            Worklog Id 72943 [ 72943 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 289.75h [ 1043100 ] 292.25h [ 1052100 ]
            Worklog Id 72945 [ 72945 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 292.25h [ 1052100 ] 295.75h [ 1064700 ]
            Worklog Id 72953 [ 72953 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 295.75h [ 1064700 ] 297.75h [ 1071900 ]
            Worklog Id 72955 [ 72955 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 21/Aug/17 09:00 AM
            • Time Spent:
              6h
               

              Data Audit

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 21/Aug/17 04:17 PM
            • Time Spent:
              5.5h
               

              Data Audit for Plan End Election Active for companies
              Austin
              CityOfBaytown
              cityOfcasselberry
              cityof coalinga
              clarke
              CSS
              El Darado
              Fazoli
              discussion with Prashant for related scenarios

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 297.75h [ 1071900 ] 303.25h [ 1091700 ]
            Worklog Id 73144 [ 73144 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 22/Aug/17 09:26 AM
            • Time Spent:
              4h
               
              <No comment>
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 22/Aug/17 04:03 PM
            • Time Spent:
              7h
               

              Plan End Election Active Data Audit for Companies :
              Hallmark Aviation Services
              Jani King
              JE Dunn
              Ken Ton
              LHP
              Liberty Hospital
              MarquetteTransportation
              Chmc
              Ehmc
              GGH
              Srmc

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 303.25h [ 1091700 ] 303.75h [ 1093500 ]
            Worklog Id 72955 [ 72955 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 303.75h [ 1093500 ] 309.75h [ 1115100 ]
            Worklog Id 73704 [ 73704 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 309.75h [ 1115100 ] 313.75h [ 1129500 ]
            Worklog Id 73705 [ 73705 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 313.75h [ 1129500 ] 320.75h [ 1154700 ]
            Worklog Id 73706 [ 73706 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 23/Aug/17 09:27 AM
            • Time Spent:
              7h
               

              Data Audit continued - scenarios testing on 30 company/ 52

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 23/Aug/17 04:05 PM
            • Time Spent:
              5h
               

              Plan End Election Active Data Audit for Companies :
              ASML
              Karma
              AutoChlor
              BDG
              St Rose
              CEI
              california golf

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 320.75h [ 1154700 ] 327.75h [ 1179900 ]
            Worklog Id 73966 [ 73966 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 327.75h [ 1179900 ] 332.75h [ 1197900 ]
            Worklog Id 73968 [ 73968 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 24/Aug/17 09:02 AM - edited
            • Time Spent:
              7h
               

              Plan End Election Active Data Audit

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 24/Aug/17 09:05 AM
            • Time Spent:
              7h
               

              Data Audit on 7 companies - plan end election active

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 24/Aug/17 04:28 PM - edited
            • Time Spent:
              7h
               

              Data Audit of terminated employees active election on below companies:
              AFI
              FRMC
              St Rose
              Blue Coat
              City of Bellevue
              City of Casselberry
              City of Durham
              City of West Covina

            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 332.75h [ 1197900 ] 339.75h [ 1223100 ]
            Worklog Id 74277 [ 74277 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Worklog Id 74277 [ 74277 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 28/Aug/17 09:05 AM
            • Time Spent:
              5h
               

              Plan End Election Active Data Audit on 4 companies

            Permalink
            yogita.bhadane Yogita Bhadane (Inactive) logged work - 28/Aug/17 09:55 AM
            • Time Spent:
              7h
               

              Data Audit of terminated employees active election on below companies:

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 28/Aug/17 10:30 AM
            • Time Spent:
              6h
               

              Data audit on - 6 companies - Plan end election active

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 339.75h [ 1223100 ] 346.75h [ 1248300 ]
            Worklog Id 74495 [ 74495 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 346.75h [ 1248300 ] 352.75h [ 1269900 ]
            Worklog Id 74497 [ 74497 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 28/Aug/17 05:09 PM
            • Time Spent:
              1h
               

              Analysis for Rates Beyond End Date Data Audit

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 29/Aug/17 09:00 AM
            • Time Spent:
              4h
               

              Rates Audit - Meeting and conveying with the completed companies details list to Avnish.
              Remaining Rates Audit continued

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 352.75h [ 1269900 ] 359.75h [ 1295100 ]
            Worklog Id 74748 [ 74748 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Worklog Id 74748 [ 74748 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 359.75h [ 1295100 ] 364.75h [ 1313100 ]
            Worklog Id 74751 [ 74751 ]
            yogita.bhadane Yogita Bhadane (Inactive) made changes -
            Time Spent 364.75h [ 1313100 ] 371.75h [ 1338300 ]
            Worklog Id 74790 [ 74790 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 371.75h [ 1338300 ] 375.75h [ 1352700 ]
            Worklog Id 74816 [ 74816 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 29/Aug/17 02:17 PM
            • Time Spent:
              5.5h
               

              Data Audit for Terminated Employees Active Elections

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 375.75h [ 1352700 ] 381.25h [ 1372500 ]
            Worklog Id 74967 [ 74967 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 30/Aug/17 09:00 AM
            • Time Spent:
              7h
               

              Data Audit -

              Terminated Employees's Election Active - Remaining Companies

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 30/Aug/17 09:36 AM
            • Time Spent:
              7h
               

              Data Audit analysis for Rate Beyond End Date
              Reporting templates for 30 companies for Plan End Election Active

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 381.25h [ 1372500 ] 388.25h [ 1397700 ]
            Worklog Id 75187 [ 75187 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 388.25h [ 1397700 ] 395.25h [ 1422900 ]
            Worklog Id 75287 [ 75287 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 395.25h [ 1422900 ] 396.25h [ 1426500 ]
            Worklog Id 75480 [ 75480 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 396.25h [ 1426500 ] 401.25h [ 1444500 ]
            Worklog Id 75512 [ 75512 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Worklog Id 75512 [ 75512 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 31/Aug/17 07:43 AM
            • Time Spent:
              7h
               

              Terminated Employees Active Election reporting Templates for 10 companies
              Data Audit / Analysis For Null Health tier ID

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 401.25h [ 1444500 ] 408.25h [ 1469700 ]
            Worklog Id 75824 [ 75824 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 408.25h [ 1469700 ] 411.25h [ 1480500 ]
            Worklog Id 63821 [ 63821 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 411.25h [ 1480500 ] 414.25h [ 1491300 ]
            Worklog Id 72943 [ 72943 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 31/Aug/17 12:00 PM - edited
            • Time Spent:
              5h
               

              Terminated Employees Election active details to avnish
              and Rates Beyond end date analysis

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 01/Sep/17 09:00 AM
            • Time Spent:
              6h
               

              Data Audit - Null Health Tier ID's and Wrong Health Tier ID'S

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 01/Sep/17 04:02 PM - edited
            • Time Spent:
              5.5h
               

              Data Audit for NULL Health Tier ID and Wrong Health Tier
              Reporting the scenarios to Prashant
              Companies :
              Amherst Central School District
              City of Des Plaines
              DMA
              California Golf
              Mercy Radiology Group
              Santa Cruz Medical Group

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 04/Sep/17 09:00 AM
            • Time Spent:
              5h
               

              Wrong Members covered and Missing companies form Wrong health tier ID's data audit

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 414.25h [ 1491300 ] 420.25h [ 1512900 ]
            Worklog Id 76656 [ 76656 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 420.25h [ 1512900 ] 425.25h [ 1530900 ]
            Worklog Id 76662 [ 76662 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 04/Sep/17 04:05 PM
            • Time Spent:
              7h
               

              Data Audit For Wrong Health Tier
              Reporting the scenarios to Prashant
              Companies :
              Stimson
              Town of Cary
              UND
              Member not in coverage Table
              Companies :
              COSB
              ESBA
              GBAPS

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 05/Sep/17 08:00 AM
            • Time Spent:
              7h
               

              Wrong Members covered - Cases - Analysis of some records and impact analysis on
              Documentation of remaining scenarios.

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 06/Sep/17 04:08 PM
            • Time Spent:
              6h
               

              Data Audit for Member Not in coverage Table
              JE Dunn
              LHP
              Mendocino Coast District Hospital
              Mercy Radiology Group
              Prime Healthcare
              Stimson
              TIBCO
              UND

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 425.25h [ 1530900 ] 432.25h [ 1556100 ]
            Worklog Id 77184 [ 77184 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 432.25h [ 1556100 ] 439.25h [ 1581300 ]
            Worklog Id 77185 [ 77185 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 439.25h [ 1581300 ] 445.25h [ 1602900 ]
            Worklog Id 77186 [ 77186 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 1.5h [ 5400 ]
            Time Spent 445.25h [ 1602900 ] 443.75h [ 1597500 ]
            Worklog Id 77184 [ 77184 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
            Time Spent 443.75h [ 1597500 ] 450.75h [ 1622700 ]
            Worklog Id 77500 [ 77500 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 08/Sep/17 08:00 AM
            • Time Spent:
              4h
               

              Data Auidit Meeting and Discussion

              Remaining Documents verification and editing some scenarios

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 08/Sep/17 04:23 PM
            • Time Spent:
              7h
               

              Data Audit for the scenario Member Not in Coverage Table
              for the company UND (216 records )
              Documenting the scenarios for the Data Audit

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 11/Sep/17 08:00 AM
            • Time Spent:
              8h
               

              Data Audit Discussion with Amit and Satya for all the tabs

              • Finding out new cases to eliminate the impacted companies and proceed with data correction
              • Combining queries to share with Avnish for data analysis and clubbing the same
              • Sharing queries with Avnish for Data Analysis and Discrepancy finding of records through export files
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 450.75h [ 1622700 ] 454.75h [ 1637100 ]
            Worklog Id 77991 [ 77991 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 454.75h [ 1637100 ] 462.75h [ 1665900 ]
            Worklog Id 78003 [ 78003 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 11/Sep/17 04:14 PM
            • Time Spent:
              3.5h
               

              Data Audit Documenting the scenarios

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 12/Sep/17 08:00 AM
            • Time Spent:
              7h
               

              Data Audit

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 462.75h [ 1665900 ] 466.25h [ 1678500 ]
            Worklog Id 78348 [ 78348 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 466.25h [ 1678500 ] 473.25h [ 1703700 ]
            Worklog Id 78351 [ 78351 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 13/Sep/17 08:01 AM
            • Time Spent:
              5h
               
              <No comment>
            Permalink
            shaikh.ateeque Shaikh Ateeque (Inactive) logged work - 13/Sep/17 11:58 AM
            • Time Spent:
              8h
               

              2 hr Training session on Data Audit Overview
              Discussion with kanchan related to Data
              Meeting with Avnish and Prashant
              Go through related document

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 473.25h [ 1703700 ] 480.25h [ 1728900 ]
            Worklog Id 78501 [ 78501 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 480.25h [ 1728900 ] 485.25h [ 1746900 ]
            Worklog Id 78503 [ 78503 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 13/Sep/17 04:22 PM
            • Time Spent:
              2.5h
               

              Data Audit 2nd Round
              Duplicate Elections for companies
              Auto-Chlor
              AYDAH TRADING LLC

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 485.25h [ 1746900 ] 487.75h [ 1755900 ]
            Worklog Id 78612 [ 78612 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 14/Sep/17 11:40 AM
            • Time Spent:
              7h
               

              data audit for the duplicate rates for 13 companies

              reviewing the analysis for Arpita and ateeque

            Permalink
            Arpita.Verma Arpita Verma (Inactive) logged work - 14/Sep/17 01:50 PM - edited
            • Time Spent:
              0.5h
               

              Data Audit done on Duplcate rates.

            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 14/Sep/17 02:00 PM
            • Time Spent:
              3h
               

              Audit and Audit Scenarios discussion

            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 487.75h [ 1755900 ] 490.75h [ 1766700 ]
            Worklog Id 78828 [ 78828 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Resolution Done [ 10000 ]
            Status Resolved [ 5 ] Reopened [ 4 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Status Reopened [ 4 ] In Progress [ 3 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 15/Sep/17 11:42 AM
            • Time Spent:
              7h
               

              data audit for the duplicate rates for 13 companies

              reviewing the analysis for Arpita and ateeque

            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 490.75h [ 1766700 ] 498.75h [ 1795500 ]
            Worklog Id 78996 [ 78996 ]
            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 498.75h [ 1795500 ] 506.75h [ 1824300 ]
            Worklog Id 78997 [ 78997 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 18/Sep/17 05:16 PM
            • Time Spent:
              6h
               

              Consolidating the data for duplicate rates (Fetching the templates and verifying )

            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 506.75h [ 1824300 ] 508.75h [ 1831500 ]
            Worklog Id 79739 [ 79739 ]
            Permalink
            shaikh.ateeque Shaikh Ateeque (Inactive) logged work - 19/Sep/17 12:33 PM
            • Time Spent:
              6h
               

              Verification and Analysis of reported issue on Duplicate rate
              Company Name: CEI
              Company Name: City of Denton
              Company Name: City of Oceanside

            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 508.75h [ 1831500 ] 510.75h [ 1838700 ]
            Worklog Id 79742 [ 79742 ]
            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 510.75h [ 1838700 ] 516.75h [ 1860300 ]
            Worklog Id 79743 [ 79743 ]
            Permalink
            Arpita.Verma Arpita Verma (Inactive) logged work - 19/Sep/17 01:04 PM
            • Time Spent:
              5h
               

              1 h - KT by Kanchan about duplicate rate issue
              4 h - Analysis on provided companies for duplicate rates issue.

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 19/Sep/17 05:20 PM
            • Time Spent:
              2.5h
               

              Verifying through single record for duplicate rates
              and reviewing Ateeque , Arpita's work

            avnish.yadav Avnish Yadav (Inactive) made changes -
            Summary Data Analysis :Duplicate rates DataAudit_Duplicate rates
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 20/Sep/17 11:45 AM
            • Time Spent:
              2.5h
               

              consolidating the data and fetching the templates for duplicate rates through single record

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 20/Sep/17 12:00 PM
            • Time Spent:
              2h
               

              Consolidating data for duplicate rates Employbridge
              Verifying the analysis provided by arpita and ateeque

            Arpita.Verma Arpita Verma (Inactive) made changes -
            Time Spent 516.75h [ 1860300 ] 521.75h [ 1878300 ]
            Worklog Id 79978 [ 79978 ]
            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Remaining Estimate 0h [ 0 ] 8h [ 28800 ]
            Time Spent 521.75h [ 1878300 ] 513.75h [ 1849500 ]
            Worklog Id 78997 [ 78997 ]
            Worklog Time Spent 8h [ 28800 ]
            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 10h [ 36000 ]
            Time Spent 513.75h [ 1849500 ] 511.75h [ 1842300 ]
            Worklog Id 79739 [ 79739 ]
            Worklog Time Spent 2h [ 7200 ]
            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Remaining Estimate 10h [ 36000 ] 12h [ 43200 ]
            Time Spent 511.75h [ 1842300 ] 509.75h [ 1835100 ]
            Worklog Id 79742 [ 79742 ]
            Worklog Time Spent 2h [ 7200 ]
            Permalink
            shaikh.ateeque Shaikh Ateeque (Inactive) logged work - 21/Sep/17 02:23 PM
            • Time Spent:
              4h
               

              Data Audit for EmployeeBrige company

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 21/Sep/17 04:19 PM
            • Time Spent:
              4h
               

              Data Audit for Rates Beyond End Date
              Company GFC

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 12h [ 43200 ] 8h [ 28800 ]
            Time Spent 509.75h [ 1835100 ] 513.75h [ 1849500 ]
            Worklog Id 80349 [ 80349 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 8h [ 28800 ] 2h [ 7200 ]
            Time Spent 513.75h [ 1849500 ] 519.75h [ 1871100 ]
            Worklog Id 80380 [ 80380 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Remaining Estimate 2h [ 7200 ] 0h [ 0 ]
            Time Spent 519.75h [ 1871100 ] 522.25h [ 1880100 ]
            Worklog Id 80399 [ 80399 ]
            Permalink
            shaikh.ateeque Shaikh Ateeque (Inactive) logged work - 22/Sep/17 02:24 PM
            • Time Spent:
              5.5h
               

              Data Audit for Duplicate rates

            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 522.25h [ 1880100 ] 526.25h [ 1894500 ]
            Worklog Id 80719 [ 80719 ]
            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 526.25h [ 1894500 ] 531.75h [ 1914300 ]
            Worklog Id 80720 [ 80720 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 25/Sep/17 11:43 AM
            • Time Spent:
              7h
               

              Data audit Reverification on 13 companies for duplicate rates

            avnish.yadav Avnish Yadav (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Closed [ 6 ] Reopened [ 4 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 531.75h [ 1914300 ] 538.75h [ 1939500 ]
            Worklog Id 81488 [ 81488 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 538.75h [ 1939500 ] 545.75h [ 1964700 ]
            Worklog Id 81489 [ 81489 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 545.75h [ 1964700 ] 552.75h [ 1989900 ]
            Worklog Id 81490 [ 81490 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 552.75h [ 1989900 ] 555.25h [ 1998900 ]
            Worklog Id 81501 [ 81501 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 26/Sep/17 12:01 PM
            • Time Spent:
              3h
               

              Reverification for the duplicate rates
              verifying the templates for the 13 companies

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 555.25h [ 1998900 ] 557.25h [ 2006100 ]
            Worklog Id 81536 [ 81536 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 557.25h [ 2006100 ] 560.25h [ 2016900 ]
            Worklog Id 81537 [ 81537 ]
            Arpita.Verma Arpita Verma (Inactive) made changes -
            Time Spent 560.25h [ 2016900 ] 560.75h [ 2018700 ]
            Worklog Id 81746 [ 81746 ]
            Arpita.Verma Arpita Verma (Inactive) made changes -
            Worklog Id 81746 [ 81746 ]
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 26/Sep/17 02:05 PM - edited
            • Time Spent:
              2.5h
               

              Re verification of duplicate records

              • Issue found in previous result - records may export on file
                Duplicate rates new issue found -
                Records identified for re-verification
            Permalink
            Prashant.samal Prashant Samal (Inactive) logged work - 27/Sep/17 02:22 PM
            • Time Spent:
              1.5h
               

              Duplicate Rates -

              Files re-export and verification

              • On Liberty hospital - discussion and verification and backend check with kanchan
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 560.75h [ 2018700 ] 563.25h [ 2027700 ]
            Worklog Id 82065 [ 82065 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Worklog Id 82065 [ 82065 ]
            Prashant.samal Prashant Samal (Inactive) made changes -
            Time Spent 563.25h [ 2027700 ] 564.75h [ 2033100 ]
            Worklog Id 82078 [ 82078 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Status Reopened [ 4 ] In Progress [ 3 ]
            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 03/Oct/17 04:16 PM
            • Time Spent:
              4h
               

              Restoring the companies
              Exporting the files from HSPL to bring down the file to zero records

            Permalink
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) logged work - 05/Oct/17 05:22 PM
            • Time Spent:
              1h
               

              Consolidating and extracting the exported files and verifying the same
              Sent exported files from 7 companies to Avnish

            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 564.75h [ 2033100 ] 568.75h [ 2047500 ]
            Worklog Id 83475 [ 83475 ]
            kanchan.jalgaonkar Kanchan Jalgaonkar (Inactive) made changes -
            Time Spent 568.75h [ 2047500 ] 569.75h [ 2051100 ]
            Worklog Id 83503 [ 83503 ]
            Permalink
            shaikh.ateeque Shaikh Ateeque (Inactive) logged work - 30/Oct/17 07:02 AM
            • Time Spent:
              8h
               

              Discussion with Avnish
              Verification of Tables for Data Audit
              Analysis of created stored procedure related to the same

            shaikh.ateeque Shaikh Ateeque (Inactive) made changes -
            Time Spent 569.75h [ 2051100 ] 577.75h [ 2079900 ]
            Worklog Id 88934 [ 88934 ]
            satyap Satya made changes -
            Environment_New Production [ 18442 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Resolved [ 5 ]
            avnish.yadav Avnish Yadav (Inactive) made changes -
            Status Resolved [ 5 ] Closed [ 6 ]
            Transition Time In Source Status Execution Times
            Avnish Yadav (Inactive) made transition -
            Open In Progress
            		13d 18h 17m 1
            Avnish Yadav (Inactive) made transition -
            Resolved Reopen
            		53d 43m 1
            Kanchan Jalgaonkar (Inactive) made transition -
            Closed Reopen
            		19h 1m 1
            Avnish Yadav (Inactive) made transition -
            Reopen In Progress
            		2d 5h 13m 2
            Avnish Yadav (Inactive) made transition -
            In Progress Resolved
            		344d 2h 7m 3
            Avnish Yadav (Inactive) made transition -
            Resolved Closed
            		7s 2

              People

              Assignee:
              avnish.yadav Avnish Yadav (Inactive)
              Reporter:
              nandkumar Nandkumar Prabhakar Karlekar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 35h Original Estimate - 35h
                  35h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 577.75h
                  577.75h