Data Analyst

SIVASANKAR THIRUGNANA SAMBANDAM

Email ID: **********.*****@*****.***

Mobile: +1-952-***-****

SUMMARY:

ETL QA engineer / Data Analyst with over 13+ years of experience in various domains including Healthcare and Banking.

Expertise in ETL, Enterprise Data Warehouse Testing-Evaluating Cloud Data Integration from multiple source systems to target system Amazon Redshift.

Experienced in AWS services like AWS Glue, AWS Athena for file validations.

Experienced in SQL queries to validate data, format and performance of the Revenue Recognition historical trend analysis report using Tableau Business Intelligence tool.

Designed and developed test scripts for ETL Automation Regression testing using VBA.

Experienced in different modules of TriZetto’s FACETS claim processing (837) and adjudication, Member and provider load, D-SNP claims COB automation.

Experienced in HEDIS (Healthcare Effectiveness Data and Information Set) Admin measures, Hybrid Measures and P4P measures in United Health Group (UHG).

Extensive experience in Backend Testing on distributed databases using SQL queries.

Experienced in UNIX commands for source file data validation, job execution and analysis.

Experienced in Waterfall and Agile Projects, worked very closely with Product owners (PWC) and participated Sprint Planning, Scrum meeting, Backlog grooming and Retrospective.

Expertise in using various defect-reporting and defect-tracking tools like JIRA and HP ALM.

Experienced in Functional testing, User Acceptance Testing, System Integration testing of client/server and Web base Applications.

Ability to learn and adapt to the rapid changing technologies and implementing the same at work.

Strong knowledge of data management and data warehouse concepts, including database structure, and SQL.

Experienced in preparing test strategy & test scenarios to meet business requirements.

TECHNICAL SKILLS:

Programming Languages : VBA and HTML and C

Operating System : Unix, Windows XP, Windows 10

Databases : Oracle 11G, SQL Server 2008 and MS SQL Server 2017,

: Amazon Redshift 1.2.16, Salesforce

ETL Tool : IBM Information Server (Data Stage 11.3), Talend 7.2

BI Reporting Tool : Tableau 10.5, TIBCO Spotfire 7.8

Other Tools : IBM Scheduler 3.1, HP ALM 12.2, Rally, Jira

PROFESSIONAL EXPERIENCES:

Project 1: Revenue Recognition Nov 2018 – Present

Role: Senior QA Analyst

Client: CHANGE HEALTHCARE (CHC) Employer (Cognizant Technology Solutions)

Description: Revenue recognition project goal is to build the Revenue data mart with a Revenue calculation engine to recognize the actual revenue. Revenue recognized is entity satisfying its promise to transfer services in a contract with a customer following the ASC 605 & 606 accounting standards. Revenue Recognition consist of different modules like Standalone Selling Price derivations, Contract Modification, Contract Treatments, Revenue Waterfall (contract asset/liability derivations), Total contract Value (opening balance calculation and adjustments), customer stratification and journal entries.

Responsibilities:

Involved in Requirement analysis with PWC business team.

Analyzed source to target mapping sheet for RMS and Reports.

Test data files are received from multiple databases and processed it through ETL and loaded to target database Redshift.

Experienced in AWS services like AWS Glue and AWS Athena to verify output files in S3 bucket.

Testing each point between extract and load, including data load from the source extract to staging, staging to transformation and the data reaches to data warehouse.

Used UNIX commands to validate output files and file management.

Verified the Revenue Recognition Calculation results by using SQL queries.

Writing SQL queries against BI Tableau Reports and performed the reports testing.

Defects tracking and reporting in Jira.

Developed Automation test scripts for ETL Regression testing using VBA.

Performed Preparation of Test Plans, Test Cases and Test Scenarios to meet business requirements.

Project 2: Facets 5.6 R4 upgrade Nov 2017 – Oct 2018

Role: Senior QA Analyst

Client: Horizon BCBSNJ Employer (Cognizant Technology Solutions)

Description: The Facets 5.6 R4 upgrade project is to upgrade the current Facets 5.2 R8 claims processing system, utilizing multiple application groups for business processes and information management for Horizon BCBSNJ. As part of Testing, Core Facets features has been identified for Horizon BCBSNJ and Facets Upgrade has been tested & validated.

BCBSNJ is expanding its Medicare Advantage D-SNP product line and so increasing the number of D-SNP (Dual Eligible Special Needs Plans) members. These members are eligible to both Medicare and Medicaid plans. BCBSNJ currently has 50,000 D-SNP members and it is hoping to increase to 8, 00,000. The current process for full dual members, to adjudicate the D-SNP claim requires adjudicating the claim for the Medicare payment, and then again for the Medicaid payment. There are multiple areas has identified as bottlenecks where automation could provide time, effort, and accuracy benefits. The purpose is to automate the process to load D-SNP claims and apply the COBA calculation on them to get adjudicated.

Responsibilities:

Performed Preparation of Test Plans and Test Scenarios to meet business requirements.

Regression testing of existing functionalities are performed and validated to make sure no functionalities are negatively affected due to upgrade code movement.

Parallel Testing are performed to compare HOC2 Outcome with HOC3 Outcome.

Validated member load (834) and Provider load and confirm both are available in Facets.

Validation of 837 Institutional (Hospital) and Professional (Medical) claims and claim details are loaded into Facets and validated Claim payment and status.

Validation of D-SNP claim processing and COB Automation calculation applied to get adjudicated into FACETS.

Validation of ITS claims are loaded into facets.

3rd party/Vendor (Evicore, NIA,Cotiviti) integration testing has been done during Parallel testing.

Validated the claim details by using SQL queries.

Project 3: HEDIS Integration and Cornerstone May 2014 – Oct 2017

Role: Senior QA Analyst

Client: UNITED HEALTH CARE (OPTUM) Employer (Cognizant Technology Solutions)

Description: The Healthcare Effectiveness Data and Information Set (HEDIS) is a set of standardized performance measures designed to ensure that purchasers and consumers have the information they need to reliably compare the performance of managed health care. HEDIS rates are designed to evaluate the effectiveness of a health plan’s ability to demonstrate an improvement in its preventive care and quality measures to plan’s members.

All HEDIS data collected by NCQA are maintained in a central database with controls to protect confidentiality. NCQA has a Measure Certification program for organizations that develop, license and sell HEDIS measures (Admin and Hybrid), P4P and other quality-measure reporting software that calculate numerators and denominators using administrative data sources.

Cornerstone was built with a vision to make a central repository and to provide a common platform for data intake and analysis for CPC Products. It serves line of business – Medicare, Medicaid and Commercial. To support the services of business, various data sets are loaded in Cornerstone.

Responsibilities:

Involved in Requirement analysis with business team.

Analyzed source to target mapping sheet for Admin measures, Hybrid measures and Reports.

ETL-Prepared Test data files for each measure aggregations and processed it from landing zone and Used UNIX commands for file management.

Ran the Job steams in IBM workload Scheduler and Monitor the job status.

Verified the job logs in Data Stage Director and Reported job failures to Development team if job aborted. Also, Verified the Aggregation results by using SQL queries.

Used HP ALM for Test case execution and Rally for Defects tracking and reporting.

Provided support for UAT testing and Production issues.

Provided support for downstream applications as Optum HEDIS Manager.

Project 4: SPIDER Benefit Testing Apr2013 – Apr 2014

Role: QA Analyst

Client: WellPoint Employer (Cognizant Technology Solutions)

Description: TriZetto delivers world-class, healthcare IT solutions that enable healthcare organizations to work more efficiently and collaboratively to deliver better health. TriZetto solutions help health plans and TPAs increase administrative efficiency, improve the cost and quality of care, and succeed in the retail healthcare market. TriZetto solutions help physicians and health systems simplify business processes and execute strategies for population health management, accountable care and value-based initiatives. TriZetto’s healthcare expertise, innovative solutions and comprehensive services help simplify healthcare for everyone.

Project 5: Power Builder Remediation Aug2010 – Apr2013

Role: Test Analyst

Client: MetLife Employer (Cognizant Technology Solutions)

Description: This project is related to upgrading of Operating System across applications from Windows XP to Windows 7. Some of the PowerBuilder (PB) applications which are still in lower version of Power Builder are not compatible with Windows 7 OS. There is a need to ensure around 16 PB applications upgrade to Version 12 or higher to be operational after OS upgrade.

Project 6: NBAD Dec2006 – Jul2010

Role: Senior Test Engineer

Client: National Bank of Abu Dhabi Employer (Polaris Software Lab)

Description: Our Retail Banking platform is a feature-rich solution that addresses the critical need for a scalable, flexible, and secure and customer centric core-banking platform. It is a multi-currency solution conceived and built with the anytime-anywhere customer in mind.

Modules Involved: Fixed Deposit, Central Liability System, Fund Transfer Out, Fund Transfer In, Standing Instruction, Reports and Queries etc.

TIDE

Time Deposit (Tide) is one of the basic and essential products of a bank. Banks hold the Customers’ deposits for a fixed period of time and provide interest for the deposit amount. Banks offer a number of facilities such as linking deposits with Current Account or Savings Account, Automatic Rollover of deposits on maturity. The Tide module supports the following types of transactions:

Payments (SWIFT MESSAGE) - Standing Order

Standing Order is one of the commonly used utilities of any banking system. Customers to give instructions to the bank, which could be executed at periodical intervals specified by the customer. It supports Booking, Modification and Cancellation.

FTOUT

Cross Border funds transfer of funds to persons in different countries / regions across the world. The module covers fund transfer in both local and foreign currency through automatic routing mechanism and the transfer currency supported by SWIFT.

FTIN - Incoming funds transfer deals with the credits received by the Bank from remitters in different countries / regions across the world. The incoming funds transfer may be for its customers termed as Incoming Funds transfer – Customer.

EDUCATION CREDENTIALS:

Master’s in Computer Applications (Bharathidasan University) - (2000 – 2003)

Certifications: ISTQB Foundation

Contact this candidate