Summary
Overview
Work History
Education
Skills
Certification
Accomplishments
Languages
References
Timeline
Generic

Nikhila Kalva

Harleysville,PA

Summary

Results-driven Senior Data Architect with expertise in solution and data architecture for OLTP, ODS, and Cloud Databases. Proven ability to enhance data pipeline efficiency by 80% at Slalom Consulting and achieve $400k annual savings for Quest Diagnostics. Recognized for exceptional data integration and modeling skills, fostering cross-functional collaboration while successfully managing multiple large-scale projects. Acknowledged for innovative contributions with a Best Design and Best Overall awards at Hackathon, demonstrating strong technical and organizational capabilities.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Consultant

Slalom Consulting
Philadelphia, PA
07.2022 - Current
  • Directed the data migration team during the transition from on-premises Oracle/SQL Server to Snowflake.
  • Led data migration project from legacy platform to Databricks while complying with Unity Data Catalog.
  • Built and configured the client’s Snowflake and Matillion environments, and refactored existing data services into a new environment by building data pipelines, which improved query performance by an average of 80% faster.
  • Deployed scripts for creating, modifying database objects like tables, views, stored procedures, functions.
  • Developed and maintained data architecture standards, models, diagrams and documentation.
  • Ensured that all applications adhere to established data governance policies and practices.
  • Collaborated with stakeholders and cross-functional teams on gathering requirements for dashboard reporting needs to achieve goals.
  • Developed data pipelines to ingest and process large datasets.
  • Monitored operations and reviewed records and metrics to understand company performance.

Senior Developer

Quest Diagnostics
West Norriton, PA
04.2014 - 08.2021
  • Extensive experience providing vision and leadership for designing and delivering business solutions, enabled through technology.
  • Lead the development team of the Quest Reagent Tracker, which has provided $400k per year in reagent use savings on platforms.
  • I was a key player and led the team on several technology upgrades and POCs.
  • Produced architectural designs for the Lab Ops Cumulative Flow Dashboard, which allowed the business to identify areas for timing improvement that, in turn, will improve TAT and efficiencies.
  • Demonstrated collaboration and interpersonal skills, establishing effective working relationships across the IT departments.
  • Re-designed the data model for the operational analytics reporting platform, which improved the report response time by 30%.
  • Lead the team on the critical data center migration and consolidation initiative, from WDC to TDC, with zero outages.
  • Automated manual processes by creating custom scripts and programs using scripting languages like Bash, PowerShell.
  • Performed advanced analytics on structured and unstructured data using SQL and Python.
  • Won Best Design and Best Overall Team in the Quest Hackathon competition.

Senior ETL Consultant

LiquidHub
Wayne, PA
01.2012 - 02.2014
  • Worked on Control-M Enterprise Manager 7.0.00 to load, run, and monitor the jobs, and worked on Control-M Desktop 7.0.00 to create new tables and jobs in Control-M.
  • Extensively worked on UNIX shell scripting, and wrote new UNIX scripts to FTP, updating the existing scripts according to the requirements.
  • Used FTP scripts to move the files between the mainframe, UNIX server, and Windows.
  • Used Hummingbird connectivity in 2008 to connect to servers, and used Hummingbird FTP and Exceed to FTP the files between different servers, along with PuTTY.

Education

Bachelor of Science - Computer Science

JNTU
Telangana, India
05-2005

Skills

  • Business presentation
  • Technical review
  • Real-time analytics
  • Git version control
  • Organizational development
  • Cross-functional collaboration
  • Data analytics
  • Performance metrics
  • Decision-making
  • Advanced SQL
  • Data integration
  • Data modeling
  • Performance tuning
  • ETL development
  • Data pipeline design
  • Data science

Certification

  • AWS Certified Data Engineer
  • AWS Cloud Practitioner
  • SnowPro Advanced: Data Engineer
  • SnowPro Core
  • Databricks Certified Data Engineer
  • Matillion Associate
  • Certified Scrum Master
  • Certified Datastage Developer 8.0

Accomplishments

  • Won Best Design and Best Overall application in Quest Diagnostics - Hackathon
  • Won GRIT-ty award - recognized for moving outside of comfort zone to grow the expertise in various technologies with dedication, determination and drive and show true GRIT.

Languages

English
Full Professional

References

References available upon request.

Timeline

Consultant

Slalom Consulting
07.2022 - Current

Senior Developer

Quest Diagnostics
04.2014 - 08.2021

Senior ETL Consultant

LiquidHub
01.2012 - 02.2014

Bachelor of Science - Computer Science

JNTU

Similar Profiles

CREATE PROFILE
Nikhila Kalva