Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Generic
Meghana Kankarej

Meghana Kankarej

Sunnyvale,CA

Summary

Self-motivated Data Migration Analyst with five years of experience in ETL and data migration. Proficient in identifying key insights from complex data sets to support strategic planning and operational improvements. Passionate about leveraging data to optimize processes and achieve organizational goals.

Overview

10
10
years of professional experience

Work History

Data Conversion Analyst

Thomson Reuters
08.2017 - 09.2021
  • Developed and executed data mapping strategies for migrating legacy systems to a new data warehouse, ensuring seamless data conversion and integration.
  • Collaborated with cross-functional teams to identify and cleanse data discrepancies, ensuring data accuracy and consistency throughout the conversion process.
  • Designed and implemented data conversion scripts, leveraging SQL and ETL tools, to extract, transform, and load large volumes of data from various sources into the target system.
  • Conducted rigorous data validation and testing processes to identify and resolve data anomalies, ensuring the successful migration and integrity of critical business data.
  • Provided technical support and training to end-users and stakeholders, facilitating a smooth transition of data conversion processes and ensuring user adoption of the newly implemented system.
  • Identified process improvement opportunities to enhance operational effectiveness and improve team productivity, resulting in a 40% reduction in execution time for data-cleanup tasks.
  • Communicate with diverse clients, build rapport and long-term relationships, and achieve client satisfaction.
  • Collaborated with client teams to define business requirements and develop data discovery strategies to address specific project objectives.
  • Collaborated with client teams to gather data mapping requirements and translate them into technical specifications using T-SQL.
  • Guided and supported a junior team member through a two-month conversion process for enhanced skill development and performance.

Business Intelligence Analyst

Helm360
06.2017 - 08.2017
  • Implemented efficient error handling for existing and new T-SQL queries utilizing try catch, system variables and functions (@@error, raiserror)
  • Optimized queries/ stored procedures performance utilizing indexes, hints, query execution plans.
  • Designed SSIS packages for data profiling and data scrubbing utilizing multiple tasks and transformations.
  • Implemented event handlers, row redirects, checkpoints for efficient error handling and utilized loggings for monitoring execution in SSIS.
  • Generated various billing reports.
  • Performed various data operations such as data profiling, data cleaning and data verification utilizing customized stored procedures, fuzzy lookup, fuzzy grouping and DQS transformations in pre-staging and staging environments.

System Software Engineer

NVIDIA Corp (India)
06.2011 - 06.2013
  • Worked as a core member of the newly formed Linux for Tegra Multimedia team
  • Designed and developed a multimedia player application’s audio/video playback using GStreamer APIs.
  • Evaluated SBC codec technology and educated the team on its use for better header parsing logic of audio/video.
  • Debugged and fixed launch blockers on multiple occasions resulting in the on-time delivery of the team’s products.
  • Contributed towards analyzing and optimizing power usage on Linux for Tegra devices.
  • Collaborated with two other team members on multimedia framework migration to a new platform and kernel resulting in improved processes for the team.
  • Worked on open source technologies like Gst-OpenMAX plugin and GStreamer application for playback.
  • Contributed to analyzing and fixing memory leak issues in GStreamer, an open-source application.

Education

Master of Science - Information Systems Management

Seattle Pacific University
Seattle, WA
05-2017

Master of Science - Computer Science

Pune University
Pune, India
06-2011

Skills

  • T-SQL, Dynamic SQL
  • ETL
  • BI Tools: Tableau and PowerBI
  • Jira, Smartsheets, Confluence
  • Python
  • Data Modeling, Data Mapping, Data Discovery
  • Data Migration
  • Data Warehousing
  • Business intelligence tools
  • Backup and recovery
  • Relational databases
  • ETL development
  • Troubleshooting

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Conversion Analyst

Thomson Reuters
08.2017 - 09.2021

Business Intelligence Analyst

Helm360
06.2017 - 08.2017

System Software Engineer

NVIDIA Corp (India)
06.2011 - 06.2013

Master of Science - Information Systems Management

Seattle Pacific University

Master of Science - Computer Science

Pune University
Meghana Kankarej