Ravi Kiran Kandra
Data Engineer at NexZenTek- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
SnowPro Core Certification
SnowflakeFeb, 2021- Oct, 2024 -
AWS Certified Developer - Associate
Amazon Web ServicesSep, 2018- Oct, 2024 -
CCA Spark and Hadoop Developer
ClouderaJul, 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 -
VR Siddhartha Engineering College (Autonomous), Vijayawada
Bachelor's degree, Information Technology