Ravi Kiran Kandra

Data Engineer at NexZenTek
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
US
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • SnowPro Core Certification
    Snowflake
    Feb, 2021
    - Oct, 2024
  • AWS Certified Developer - Associate
    Amazon Web Services
    Sep, 2018
    - Oct, 2024
  • CCA Spark and Hadoop Developer
    Cloudera
    Jul, 2018
    - Oct, 2024

Experience

  • NexZenTek
    • United States
    • Information Technology & Services
    • 1 - 100 Employee
    • Data Engineer
      • Dec 2018 - Present

      • Developed and automated the ETL processes using python, SQL, pyspark and shell scripts. • Automated data validation processes using python. • Worked on analyzing data using Hive. • Analyzed and developed backend processes for the applications using python. • Worked on monitoring the production jobs and fixing the issues in the production. • Created Data Mapping for migrating Survey from one vendor to other, • Migrated the data from Hadoop to Snowflake. • Converted pyspark and hive scripts to python and snowsql scripts to migrate the jobs from Hadoop/Spark to Snowflake. • Created ETL processes in snowflake using Python and Sql

  • MindIQ Solutioins
    • Bloomington, Illinois, United States
    • Data Engineer
      • Nov 2017 - Nov 2018

      • Worked on developing the data warehouse for the project. • Developed logical and physical data models, design data access strategies and wrote SQL code to access and update data stored in relational databases. • Created database objects namely tables, procedures, triggers, constraints, indexes and views. • Developed SSIS packages to extract data from multiple sources. • Worked on Performance tuning by optimizing the existing SQL Queries using SQL Profiler. • Developed reports using multiple data sources in SQL Server Reporting Services (SSRS). • Created Multidimensional cubes using SSAS and designed Data Warehouse schemas. • Provided Full Reporting Life Cycle support using SSRS. • Built statistical reports in Power Pivot, DAX to create various calculations, including ratios to total/parents, financial comparisons between dates and previous runs.

  • Pearlsoft Solutions
    • Little Rock, Arkansas, United States
    • Software Engineer
      • Jul 2016 - Oct 2017

      • Worked on analyzing the Business Requirements and Identifying mapping documents required for system and functional testing the application. • Worked on preparing the requirement specification document by gathering requirements and analyzing them. • Worked on developing the application using Spring MVC framework. • Developed java scripts for all client-side validation and developed User Interface (GUI) using JSP, CSS. • Worked on developing Use Case diagrams, Activity diagrams and business flow diagrams, • Developed application using J2EE design patterns like Service Locator, Singleton and Session Façade. • Worked on Configuring the application using Hibernate, spring, DAO's, JSP’s and Actions Classes. • Developed presentation layer using JSP, JavaScript, HTML and CSS. • Used JDBC for database connectivity and to invoke Stored Procedures. • Worked on deployment of the applications to the Web Sphere Application Server. • Wrote complex SQL queries, stored procedures and triggers. • Worked on unit and system testing the application.

  • HCLTech
    • India
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Software Engineer
      • May 2011 - Jul 2014

      • Developed a web application for Resource Management in ASP.Net and SQL server. • Involved in the requirements gathering, analysis, design, code review and development stages. • Worked on developing the database of the application. • Worked on developing web pages with required functionalities using MVC architecture. • Designed and developed GUI with web forms using ASP.NET Controls, HTML, CSS, JavaScript, AJAX and Jquery. • Developed UI prototypes using pencil and sketch. • Worked on unit and system testing the application. • Developed Automation test scripts using selenium. • Used ADO.Net extensively for retrieving, querying and manipulating data in the database. • Wrote Stored Procedures, Transactions, Triggers and Statements to access data from SQL Server Database. • Worked on debugging, deploying and diagnosing web applications. • Worked on developing and consuming web services. • Worked on Web services Integration using SOAP and REST Protocols. • Worked on database administration. • Gained domain knowledge on Banking and Insurance.

Education

  • University of Nebraska at Omaha
    Master's degree, Management Information Systems
    2014 - 2016
  • VR Siddhartha Engineering College (Autonomous), Vijayawada
    Bachelor's degree, Information Technology
    2007 - 2011

Community

You need to have a working account to view this content. Click here to join now