Summary
Overview
Work History
Education
Skills
Trainings Conducted
Certifications
Personal Information
Timeline
Generic

Ravikiran Patelkhana

Irving,TX

Summary

Diligent and dedicated professional with a proven track record in successfully managing diverse transitioning projects, including sensitive data and massive big data installations. Possessing experience in Teradata & ETL Development. Strong problem-solving skills and a proactive approach enable effective tackling of new tasks. Known for adaptability, creativity, and a results-oriented mindset, always striving to make meaningful contributions and advance organizational goals. Reputation for providing quick and effective tools to automate and optimize database management tasks. Background includes data integration, warehousing and analytics.

Overview

11
11
years of professional experience

Work History

Senior Developer

Cognizant
08.2018 - Current
  • Developed custom database objects, stored procedures, and delivered application support.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Created optimal technical solutions to user needs with in-depth system analysis.
  • Designed and developed customized extract, transform and load (ETL) applications per client specifications.
  • Resolved complex business issues, proposing long-term solutions to avoid repeat problems.
  • Followed standard practices for migrating changes to test and production environments.
  • Designed and implemented Teradata SQL queries, views and procedures for reporting and complex solution development.
  • Developed Control-M and Autosys jobs with scheduling details and dependencies as per the requirements.
  • Enhanced application speed and resource utilization by executing performance tuning techniques.
  • Worked on developing the new process of converting Legacy source systems to SAP which involves replacing existing ETL process to source from Sybase or Oracle and loading data in the form of files from SAP through EHANA and Middleware.
  • As a Value Add, created generic scripts for TPT Export and Import by providing the Table name as a variable which takes the Table definition and automatically creates the schema for TPT.

Module Lead

TCS
05.2017 - 08.2018
  • Monitored activities and supporting systems to meet compliance regulations.
  • Addressed technical issues in Teradata scripts and Informatica mapping and guided end users through resolution.
  • Performed development, debugging, optimization and automation to support implementation of applications.
  • Contributed to continuous improvement and quality assurance tasks.
  • Improved application performance through optimization of flow processes.
  • Participated in design and planning exercises for future application deployments.
  • Acted as a team leader in group projects, delegating tasks and providing feedback.
  • Applied effective time management techniques for SLA not to be missed for ServiceNow incidents.

Developer and Module Lead

TCS
02.2014 - 04.2017
  • Collaborated with business lines to understand business requirements and participate in development for SDLC documentation.
  • Implemented JCLs and PROCs with Bteq and TPT scripts as per the design documents using tool SAS-RAW DATA LOAD (RDL)
  • Conducted Peer reviews and Code walk throughs to ensure quality and adherence to standards
  • Designed and executed complex system test plans to support quality.
  • Developed Mainframe jobs using CA7 for workflow automation and scheduling
  • Troubleshot business logic and performance issues in existing mainframe applications.
  • Worked on implementing control checks at various stages of each application.
  • Implemented automation techniques replacing existing manual process of loading history tables and purging old data.
  • Worked on converting the Deposit Data Mining application from Teradata to Hadoop which involves FTP the Source Files from Mainframe system to Hadoop Environment and then perform all Work and Stage area loads in Hadoop using DMX-H ETL tool.

Education

B.Tech - Mechanical

GITAM University
Visakhapatnam, Andhra Pradesh
01.2013

Skills

  • Teradata
  • SQL development
  • Unix
  • Informatica Power Center
  • Data integration
  • Data Analysis
  • Data warehousing
  • Performance tuning
  • Mainframes - JCL & COBOL
  • Autosys & Control-M Scheduling
  • Agile Methodologies
  • ServiceNow

Trainings Conducted

  • JCL/NDM/File Manager/CA-7
  • Teradata SQL
  • Teradata Architecture & Utilities
  • Data warehousing concepts

Certifications

  • Introduction to Basic Programming Using Python
  • Teradata Vantage Associate

Personal Information

  • Passport Number: Z6908711
  • Date of Birth: 08/19/92
  • Nationality: Indian
  • Marital Status: Single

Timeline

Senior Developer

Cognizant
08.2018 - Current

Module Lead

TCS
05.2017 - 08.2018

Developer and Module Lead

TCS
02.2014 - 04.2017

B.Tech - Mechanical

GITAM University

Similar Profiles

CREATE PROFILE
Ravikiran Patelkhana