Revathy Baskar
Data Analyst
Chennai
Summary
Conscientious and self-driven Azure Data Analyst with 11+ years of experience in ETL/Big Data testing with exceptional ability to validate the data loaded into Enterprise data warehouse and demonstrate data analytical skills to create business insights that benefits the organization
Overview
12
12
years of professional experience
4
4
years of post-secondary education
Work History
Azure Data Analyst
Capgemini Technology Services
1 2023 - Current
- Engaged in PI planning, Identify business requirement and phases involved for On Prem to Cloud Migration project
- Analyze the existing data sources to understand their design, batch flow, and dependencies to create business & technical requirement documents
- Create data mapping documents which has column to column mapping with transformations and aggregations rules to align data type and length between on prem and cloud environment tables
- Co-ordinate between dev and business team to refine unclear requirements
- Perform data reconciliation and report if there are any discrepancies in the data
- Perform SIT data validation to ensure there is no loss of data while migrating data from on prem to Azure cloud
- Validate the BI reports which flows from Azure Synapse DB to ensure reports published are accurate.
Big Data Analyst/QA Engineer
Tata Consultancy Services
08.2021 - Current
- Involve in PI planning, Identify and create US for the features in Scope, provide user story points based on complexity of the user story
- Elicit & understand Business and technical requirements, data Mapping including direct and complex transformation logic
- Direct interaction with Business in cases of refining the unclear requirements and document the changes in confluence Page
- Create test data by performing HCM transactions in relevant test environment, develop and execute test scenarios to ensure full test coverage
- Written complex SQL queries, SPARKSql to fetch data from Big Data/Enterprise Data Platform through utilities like Hive Terminal, putty
- Compare Data between legacy system (OAC/OBIEE) and use case layer in Hadoop data lake to ensure 100 % data reconciliation during data ware house migration projects
- Perform SIT validation including metadata, data element, duplicate/ missing data by identify the data from source data in landing zone of EDP through utilities like SFT, WinSCP and compare data against base table (SOR) with transformed data in ODL tables in Hadoop DW
- Monitor data load (delta, full refresh) and report ingestion failure issues to Ingestion team
- Key contributor in investigating pre-prod and prod issues and Collaborate with DW legacy team and reporting team, work in higher environments and contribute extensive support till Go-live
- Test Management is done via RALLY
- Communicate status in daily scrum calls, in Show and Tell meeting to walkthrough test evidences to Business and Stake holders for every sprint.
Senior ETL Test Engineer
Atos Syntel
01.2018 - 01.2021
- Involve in Sprint planning meeting, provide user story points and test estimation based on complexity of the user story
- Elicit & understand ETL testing requirements, and Mapping including direct and complex transformation logic
- Perform SIT validation including metadata, data element, duplicate/ missing data by identify the data from source data in landing zone of EDP through utilities like SFT, WinSCP and compare data against base table (SOR) with transformed data in ODL tables in Hadoop DW
- Written SQL scripts for verifying CCAR reports against Database
- Performing XML and Database validation for CCAR Reports
- Performing Edit check validation for all CCAR Reports based on the latest requirement documents
- Validate Pre and post upgrade changes in reports (PowerBI, Apptio, SWCAP reports)
- Execute test scenarios on compliance Dashboard (Tableau) changes
- Conduct DB validation tests, document test results in RALLY and communicate findings to development teams
- Report and document defects found during test cycles in JIRA (defect management)
- Communicate timely status in DSU calls, including any potential risks/issues to the appropriate teams to ensure completion of all deliverables within schedule, budget and quality constraints.
Test Lead, Test Engineer, DBA
Wipro Technologies
01.2012 - 01.2018
- Participation in analysis and identifying the Application background and process within a short span, when project had been taken over from other vendor at critical stage
- Understanding of Business requirements, preparation of TDA, RTM and acquire appropriate approval from Business
- Preparation of test scenarios, Test data, QA environment set up for test execution
- Understanding the EMV functionality for secure payment processing and business requirements
- Writing SQL queries, execute data stage jobs to test the functionality
- Delegation of every day task to team members and have always ensured good productivity have been captured
- Execution of test results and defect are managed using HP- ALM
- Project status reports, Weekly status reports provided on daily/weekly basis to ITPM, Business and other platform leads to keep them informed on the progress from QA side
- Preparation of Demo document to provide walkthrough on tested modules and complete end to end test activities to business
- As a database Admin, involved in creation of users, grant and revoke access as per the user request
- Deployment of DDLs changes in DEV and QA environment as per the change request
- Data movement between environments (PROD, DEV, QA) using multiload & fast load export utilities in Teradata.
Education
B.Tech(Information Technology) -
Anna university
01.2008 - 04.2012
Higher Secondary (12th) - undefined
High School(10th) - undefined
Skills
SQL server 2005/2008
Contact No
+91 9884012245
Disclaimer
I hereby affirm that all the information provided above is true and correct to the best of my knowledge
Timeline
Big Data Analyst/QA Engineer
Tata Consultancy Services
08.2021 - Current
Senior ETL Test Engineer
Atos Syntel
01.2018 - 01.2021
Test Lead, Test Engineer, DBA
Wipro Technologies
01.2012 - 01.2018
B.Tech(Information Technology) -
Anna university
01.2008 - 04.2012
Azure Data Analyst
Capgemini Technology Services
1 2023 - Current
Higher Secondary (12th) - undefined
High School(10th) - undefined
Similar Profiles
Jitendra UpadhyayJitendra Upadhyay
Design, Develop and Implementation at Capgemini Technology Services India LimitedDesign, Develop and Implementation at Capgemini Technology Services India Limited
PRAMOD BPRAMOD B
Team Manager - O2C Accounts Receivables, P2P & R2R at Capgemini Technology Services India LimitedTeam Manager - O2C Accounts Receivables, P2P & R2R at Capgemini Technology Services India Limited
Sourav GangulySourav Ganguly
Team Manager at Capgemini Technology Services India LimitedTeam Manager at Capgemini Technology Services India Limited
Umang GuptaUmang Gupta
Senior Analyst at Capgemini Technology Services India Ltd.Senior Analyst at Capgemini Technology Services India Ltd.
Zaheer Syed.SZaheer Syed.S
Team Manager at GSR Global ServicesTeam Manager at GSR Global Services