Kaaviya Krishnamurthy Email & Phone Number

Horsham, Gb

United Kingdom

Client : NHS BSASpearheaded large-scale data migration for NHS BSA project from Oracle to Cloud in recreating the NHS BSA application to recover treatment cost from member states by analyzing data volume of around 180 million.Demonstrated attention to detail, with ability to “dive deep” into data issues to find root causes that lead to quality improvement and delivered the project with 96% data quality. Developed and executed PL/SQL scripts to extract, transform, and load data into new systems. Collaborated with multiple stakeholders to report insights to both technical and non-technical audience.

Chennai, Tamil Nadu, India

Enhanced data models for CITI’s Finance reports and RISK reports which includes Credit Risk, Market Risk, and Operational Risk which helped senior management teams to mitigate risks and exploit opportunities for growth. Data Modeler for integrating two applications into one working alongside Data architects and ETL engineers consolidating business elements and reporting needs.Involved in a migration project to move data and reports from Sybase DB to Big data platform using Hive, Sqoop, Python programming and Spark.Automated and prepared shell script to load data from Sybase to Hive using SQOOP and shell scripting minimizing the developer effort to 45%. Created Data Models and built ETL data pipeline using PySpark, Spark SQL and Shell scripting for SNC project which reports Syndicated loan information to Fed Government.

As part of MIDE team, I took part in understanding business requirements from various source systems and translating it into FSD and designed database models and prepared ETL flow sheet to satisfy the reporting needs. Successfully implemented and Awarded for an IDEA (Innovation) project to automate the data model creation in SAP Power designer using vba which in turn minimized the manual effort of 2 hours/day for each employee. Created dashboards in PowerBI reporting tool.

Bangalore

Bangalore

Collaborated with business analysts and subject matter experts to understand business requirements and translate them into data models for specific data marts and warehouse.Created logical and physical dimensional models with various layers for Greece Insurance project.Designed the database to ensure data model scalability and maintenance by following version control, using proper indices and partitions.Developed and maintained data dictionaries and metadata repositories to enhance data governance and ensure data model integrity.

Bachelor'S Degree, Information Technology, 8.23 Gpa/10 Gpa

Education record