Somasundaram Kumarappan Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

Industry / Domain: PharmaceuticalProject: Data aggregation of specialty drugsRole Description:● Lead a high-performing Quality Assurance team, fostering a collaborative and results-driven work environment for multiple data aggregation projects in the US pharmaceutical domain.● Developed comprehensive test strategies and plans tailored to the unique requirements of new clients, ensuring a thorough understanding of their specific testing needs.● Managed creation and review of SQL test scripts, ensuring alignment with project requirements and testing objectives.● Implemented test automation with robot framework using an in-built database library to run data quality SQL scripts automatically. Achieved 25% reduction in workload required for daily validations. ● Developing custom python scripts using pyspark and pandas to enhance the automation framework to achieve 80% automation in the next year.● In process of designing a custom automation framework to run SQL queries via AWS glue using boto3, pyspark and pandas libraries for QC team to control data quality in daily deliverables.

Bengaluru, Karnataka, India

Industry / Domain: PharmaceuticalProject: Data aggregation of specialty drugsRole Description:● Developed and implemented specialised test data sets for the pharmacy domain, including transactions, inventory, and sales data, ensuring comprehensive coverage of business scenarios.● Conducted rigorous validation of AWS Glue jobs and workflows to ensure accurate and effective application of business transformation logics.● Created and executed comprehensive data validation checks on AWS Relational Database Service (RDS), including Aurora PostgreSQL and SQL Server instances.● Developed and executed complex SQL queries to assess and ensure the quality of data in various databases.

Bengaluru, Karnataka, India

Industry / Domain: Casino GamingProject: Casino Management SystemRole Description:● Conducted thorough validation of extract and transformation logic within the data warehouse of the Casino Gaming industry.● Executed comprehensive validation checks on data stored in the data warehouse through SQL Server Reporting Services (SSRS) reports.● Verified the integrity and correctness of data stored in SQL Server Analysis Services (SSAS) cubes and associated dimensions within the data warehouse.● Collaborated with Tableau developers to validate the consistency and accuracy of data visualisations, ensuring that business insights derived from the dashboards were reliable.● Applied SQL querying techniques to identify and resolve any discrepancies or data quality issues, ensuring synchronisation between the warehouse and source data.

Chennai Area, India

Industry / Domain: HealthcareProject: Encounters processingRole Description:● Developed and executed SQL queries to meticulously validate data integrity between reconciliation files and diverse databases including Sybase, Oracle, and MS SQL Server within the healthcare domain.● Created, modified, and maintained detailed test cases and scenarios in accordance with project requirements and specifications.● Developed an Excel-based reporting tool using macros to efficiently present testing statistics to clients, enhancing communication and transparency.● Leveraged Excel macros to design and develop various tools aimed at improving testing processes and efficiency.● Utilised HP-ALM as a test management tool to report, track, and manage issues identified during testing.

Chennai Area, India

Industry / Domain: HealthcareProject: Enrolment, Eligibility and Claims processing of Medicaid policy for different US statesRole Description:● Validate the loading of healthcare EDI files, including 834 (Enrolment), 835 (Payment/Remittance), and 837 (Claims) files, into the system through respective jobs in the TIDAL workload automation tool.● Ensure the seamless execution of the Extract, Transform, Load (ETL) process using IBM InfoSphere DataStage for converting healthcare EDI files to flat files.● Verify and validate that members are appropriately assigned to health plans and Primary Care Physicians (PCPs), ensuring accurate and up-to-date healthcare information for effective member management.● Develop and execute SQL queries to retrieve diverse sets of data from the database, and subsequently validate and verify the retrieved data within the FACETS UI (User Interface). Ensure that the data conforms to business requirements and complies with established standards for healthcare data management.

Bachelor Of Engineering - Be, Electrical, Electronics And Communications Engineering

Hsc, Biology Group

Complete higher secondary education with 94%.