Summary
Overview
Work History
Education
Skills
Certification
Timeline
SoftwareEngineer

Nithya Rajeev Kumar

Data Analyst
Plain City,OH

Summary

Experienced Finance and Data Analytics Professional with over 8 years of experience in financial services, specializing in data analysis, project management, and technology integration. Proficient in Python, SQL Server, and Tableau, with hands-on expertise in data warehouse systems, data mining, and reporting tools. Skilled in working with large datasets and cloud technologies (AWS, Databricks) to drive data-driven decision-making and streamline business processes. Adept at learning new tools and coding languages to stay at the forefront of emerging technologies.

Detail-oriented Data Engineer designs, develops and maintains highly scalable, secure and reliable data structures. Accustomed to working closely with system architects, software architects and design analysts to understand business or industry requirements to develop comprehensive data models.

Overview

8
8
years of professional experience
1
1

CCA

Work History

Data Engineer

Apollo
08.2021 - 01.2024
  • Company Overview: Apollo Insurance via UST Global, CA
  • Developed highly maintainable Python / SQL code and followed all best practices regarding coding
  • Met with key stakeholders to discuss and understand project scope, tasks required and deadlines
  • Investment, claim and trade data from different sources in different formats such as comma separated, text, etc.
  • Are received, transformed, processed and analyzed
  • Tidal is used as workflow orchestrator for moving files through different stages and processes
  • Successfully export large data sets from RDBMS and MySQL to HIVE data warehouse using Sqoop techniques for make use of HQL
  • Involved in converting SQL queries into HQLS
  • Cleanser and Validator is Python program
  • Component validates format and schema of data in files and removes all invalid data
  • Transforms data and stores in SQL Server database (Databricks)
  • Apollo Insurance via UST Global, CA

Data Engineer

Wells Fargo
04.1999 - 07.2021
  • Company Overview: Minneapolis
  • Designed and developed dynamic Tableau dashboards to visualize KPIs, increasing data visibility by 40%
  • Conducted in-depth analysis of large datasets, identifying trends and optimizing operations by 20%
  • Collaborated with stakeholders to gather requirements and deliver actionable insights through visualizations
  • Automated reporting processes using Python, reducing manual effort by 30%
  • Created user-friendly Tableau dashboards for tracking sales performance, increasing team efficiency
  • Utilized SQL to query and manage data from relational databases, improving reporting accuracy
  • Minneapolis
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Developed and delivered business information solutions.
  • Gathered, defined and refined requirements, led project design and oversaw implementation.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.
  • Developed strong communication and organizational skills through working on group projects.

.Net Developer

Dimensions Solutions
09.2008 - 05.2011
  • Company Overview: India
  • The system supports multiple warehouses
  • The system has the provision to switch from one warehouse to another without a re-login
  • Location can be created in the hierarchy level Zone, Aisle, Bay and Tier
  • Stock Keeping Unit (SKU) supports multiple units of measurement
  • A Rule based engines will automatically drives the system to the entire operation in a warehouse from receive to dispatch
  • The solution is developed as a web application using ASP.Net 2.0 technology
  • Features such as Master page, site map for navigation and in built controls such as Data Grid is used
  • Form based authentication is used and the user information is stored in the Database
  • Data Grids are used to display the location details of the product searched for
  • ADO.Net technology is used for connecting to SQL Server Database
  • Crystal Report is used to display various online reports
  • India

Education

Master of Science - Computer Programming

University of Kerala
08.2006

Bachelor of Science - Computer And Information Sciences

University of Kerala
05.2003

Skills

  • SQL
  • Python
  • Tableau
  • Power BI
  • MySQL
  • PostgreSQL
  • SQL Server
  • Sqoop
  • Dashboard Design & Development
  • Data Engineering
  • Data Modeling
  • C#
  • Databricks
  • Hadoop
  • HDFS
  • Spark
  • PySpark
  • Hive
  • Flume
  • Kafka
  • PowerBI
  • Pycharm
  • Visual Studio
  • Cloudera
  • Jira
  • Git
  • AWS
  • MS SQL Server
  • Windows
  • Linux
  • Data manipulation

Certification

CCA Cloudera Spark and Hadoop Developer, 01/01/21

Timeline

Data Engineer

Apollo
08.2021 - 01.2024

.Net Developer

Dimensions Solutions
09.2008 - 05.2011

Data Engineer

Wells Fargo
04.1999 - 07.2021

Bachelor of Science - Computer And Information Sciences

University of Kerala

Master of Science - Computer Programming

University of Kerala

Similar Profiles

CREATE PROFILE
Nithya Rajeev KumarData Analyst