Keerthana Devarajan
Analyst
Bengaluru,KA
Summary
ETL Tester with extensive experience in data warehousing and business intelligence. Skilled in developing test plans, executing test cases, and validating data integrity. Strong problem-solving abilities with a track record of identifying discrepancies in complex data sets. Contributed to enhanced software quality through effective testing methodologies and optimization strategies.
Overview
4
4
years of professional experience
Work History
Analyst
Deloitte Consulting LLP
Bengaluru
08.2022 - Current
- BIP Reports
- Invoice processing
- Accounts payables-FCF, Invoice Audit check, Right Angle(Jet Fuels)
- Analyzed large datasets to identify trends and inform business decisions.
- Utilized SQL and Excel to extract, manipulate, and analyze data efficiently.
- Leveraged SQL queries to extract, transform and load data into databases.
- Prepared detailed reports by collecting, analyzing, and summarizing information and trends.
- Developed and maintained databases, data systems, reorganizing data in a readable format.
- Collaborated with developers to troubleshoot data discrepancies and issues.
- Performed data analysis and validation on source and target data sets for accuracy of transformation rules in ETL processes.
- Documented test results and maintained clear records for audit purposes.
- Developed test plans and scripts to validate ETL jobs.
Education
Bachelor of Science - Mathematics
Sri Krishna arts and science college
Coimbatore05-2022
Associate of Science - Biological And Physical Sciences
Sri Narayana Matriculation Higher Secondary School
Coimbatore05-2019
Skills
- Data analysis and modeling
- SQL database management
- Project management and problem solving
- Report generation
- Microsoft Excel
- Software development life cycle (SDLC)
- Data integrity validation
Company
Deloitte Consulting LLP
Awards & Recognition
Spot awards - Deloitte, 05/01/23, 03/01/24, 10/01/24, received 3 spot awards in recognition of consistent commitment for maintaining high-quality work.
System Experience
Training Experience - Oracle BIP reports, Java, Power BI
Project Experience - MS Excel, Cloud Financials, Oracle SQL Developer, Databricks
Timeline
Analyst
Deloitte Consulting LLP
08.2022 - Current
Bachelor of Science - Mathematics
Sri Krishna arts and science college
Associate of Science - Biological And Physical Sciences
Sri Narayana Matriculation Higher Secondary School