Sundar Palivela

Responsibilities:Data validation in different layers (raw, curated, resiliency & Provisioning)Validated Map Reduce, Hive Scripts by pulling the data from Hadoop.Data transformations/processing checks as per source to target mapping.Utilized PYTHON Libraries spark analyze large data sets, to increase data accuracy.Developed complex SQL queries for querying against the database to validate data.Validating the tables with partitions, Sqoop & Spark Import/Export data into Hadoop clusterWorked on Hadoop components like Edge node and HDFS Directories, Hive Tables, Autosys instancesPerformed various Hadoop controls like data checks, record checks and threshold limits.Developed Python(spark) scripts to automate data processing tasks, reducing data processingValidated the data sources used in tableau reports and calculations, aggregations, transformation.

Project Details: The Unified Customer Profile is being developed to retrieve customer information from multiple applications using one process where identifiers are linked consistently across VRD and Legacy Systems. The testing scope is to ensure that the new orders and changes processed from each application flow into Cassandra, the new database, successfully and the portal can successfully query and retrieve all the customer information from Cassandra. Responsibilities:Data validation in Staging & Cassandra (K2view Fabric, Talend ETL Tool) work on AWSAutomate API’s using Selenium Rest Assured framework and testing framework using TestNG, MavenUtilized PYTHON Libraries spark analyze large data sets, to increase data accuracy Within AWSDeveloped complex SQL queries for querying against the database to validate data.Validated the test data with API validation, built With PEGA PRPC Application. (Verizon Portals)Execute TALEND jobs to extract, transform, and load & Test error handling mechanisms in Talend jobs.Verifying the correctness of data transformations and business rules during the ETL Process in AWSValidated the data sources used in tableau reports and calculations, aggregations, transformation. Developed Test Frameworks in Selenium for UI Regression Test Automation with Cucumber (BDD framework and when necessary and potentially execute Unit Test Automation (Java /Junit). Responsible for verifying Web services API calls - data validations in REST (Rest Assured automation framework), SOAP protocols.Utilize Groovy Scripting in JMETER Capabilities to customize request payloads, handle dynamic data

Project Details: The Thales Global Connectivity Management System (GCMS) is a proprietary system that provides connectivity services to the guests/passengers. The major functionality of GCMS is the customer payment process, user access management and database logging services. Responsibilities:Deploy the various builds on Hadoop clusters using JS Node and AnsibleCreated Hive Complex Queries using Lateral view for xml nested data for validation on business rules.Developed SQL Scripts for Verification of data at extraction phase to ensure, transformation phase and loading phase of data to ensure correctness of the data.Validation of Dataflow from landing area to HIVE tables using flume interceptor.Develop Test strategy, test plan/design, execute test cases and defect mgmt. for the ETL. Check if the constituent Hadoop scripts like HiveQL and Pig Latin are robust.Worked - Map Reduce, Pig, Hive Scripts pulling data from Hadoop, Validate data in files with Autosys.Responsible for verifying Web services API req / res data validations in REST, SOAP protocols.Validating APIs using Restlet Client, Postman toolValidation of flight data, pulling by flume interceptor to phoenix tables using Kafka queueCreating test cases for ETL mappings and design documents for production supportDebugging and scheduling ETL jobs/mapping and monitoring error logsHands on Experience on JIRA, JAMA, Confluence tools

Project Details:AT&T remains responsible for End-To-End delivery of all Development, Test, and Tier 3 Production Support functions as the Canter of Excellence (COE).Migration of GCP reporting functionality (ARS, iDAT, DSS, EIAN, and LOAM) to target architecture ARS migrates to ESAR IDAT, DSS, EIAN, and LOAM migrate to AERSResponsibilities:Participated in Due diligence for AT & T account and helped to set up common test office.Ensure that MapReduce jobs are running at peak performance.Develop SQL Queries / scripts and similar artifacts to validate completeness, integrity, and accuracyWorked with ETL group to understand the mapping for dimensions and facts.Create Hive Queries which help analysts spot emerging trends by comparing historical figures.Reviewed database business and functional requirements reviewed mapping transformations.Extensively worked with flat files and diff data sources.Involved in writing complex SQL procedures to implement business logic.Data validation on SAP HANA for data loads from Legacy system to HANA System.ETL testing (SAP BODS) and BO reporting info view Test Execution Reviews I tested several complex ETL mappings, reusable transformations for daily data loads.Experience in Business Objects and MicroStrategy report Testing

Marsh & Mechlennan Project Details:UK SMART is web-based application that enables the capture of the relevant product exposure / benchmarking information that will be presented via Market Connect to UK insurers; this is one element of the Strategic Carrier Services Strategy. Responsibilities:Involved in production support activities like defect fixing and testing.Involved in unit test scripts review and in the performance tuning of the application.Involved in defect management activities using CA tool and report generation activities.Coordinating with onsite team in fixing defects and getting clarification from the clients.Knowledge Transfer to the New team members.

Project Details:Claims Workflow Management (WFM) is a complete lifecycle claims solution which increases the efficiency and speed of handling claims. It guides claims handlers through the complex process of dealing with the progress of a transaction through the entire claims process.Workflow Management (WFM) system is being built on a standard PEGA platform and the architecture is based on Service Oriented Architecture (SOA) and integrates with the modernized ‘Claim Services’.Responsibilities:Identifying Priorities to Implement specific tests.Understanding User Stories and preparing Scenario’sInteracting with other Work streams (Leopards, Panthers, EZAccess, EFile & Web Services teams) of WFM on daily basis so the complete project integration is in sync.Hands on Experience on TMF (Test Management Framework)Prepare Automation Test Scripts, Business functions and Test Data.Reviewing, Executing the test cases & chasing the defects to closure

Project Details:Project is related to Claim handling. In Xchanging, Claim is created in the external system called CASA CLASS (Mainframe). Claim moves from CASA to IMR (Intermediate Repository) for further processing. After completing the task in IMR, claims come into the XCS workflow. Responsibilities:Primary investigation on Pega Rules Logs, Pega Rules Alerts logs.Identifying the issues by using the Pega tools (PAL readings, DB Trace)Prepare the Workflows for the Business Use CasesDesigned complex user interfaces using Harness, Flow Actions, Sections and HTML stream rules.Performed unit testing on business rules (decision rules, validation rules) to meet quality compliance.

Description:A 25-Year-old company based in Cambridge, MA, USA, PEGA Systems is committed to a new way of development business solutions, one that gives business users direct input and relieves IT of manual coding and assembly. Creating the applications dynamically with the PEGA Business process management systems. Responsibilities: Performing Endurance test on Applications built on PEGA (PRPC on WEB, Switch Application, Integration Services SOAP, MQ and SI Framework). Analyzing and Reporting Endurance test Results to the Client Involved the JUNIT testing - Build Deployment using web sphere and web logic, import the source code (.jar files), Execute the test cases using Eclipse, and defect reporting.