Kolla reddy T.

Kolla reddy T.

9 Years of Experience as Data Engineer

, Singapore

Experience: 10 Years

Kolla reddy

9 Years of Experience as Data Engineer

10 Years

Now you can Instantly Chat with Kolla reddy!

About Me

  • Experience in managing large databases and in large data warehousing projects.

  • Proficiency in writing Complex SQL queries, including the use of derived tables, Unions, multi-table joins.

  • Have e...

  • Have extensive work experience in Teradata (12,13.1,15.0).

Build, customize interactive reports and dashboards in Tableau.

Show More

Portfolio Projects

Corporate treasury Reporting

Company

Corporate treasury Reporting

Description

Role  Senior Systems Analyst

Organization   VUI Systems Pte Ltd

Tool/Languages  Teradata

Project Details:

CT reporting is data mart application that extracts the data from different source systems and load the data into Hadoop data lake. The transformed data is used for analysis and predictions by Corporate Repository.

Responsibilities:

  • Analyze the existing system and respective sources. Do the data profiling and provide the mapping for loading the data coming from different source systems like Teradata, Oracle, DB2 into Hadoop data lake.
  • Understand the business requirements and create the Functional specification document.

Show More Show Less

Skills

Teradata

Tools

hadoop

Integrated Sales and Service Technology (ISST)

Company

Integrated Sales and Service Technology (ISST)

Description

Role   Data Analyst

Organization  Wipro Technologies Limited and Capgemini India

Tool/Languages   SAS, Oracle, R

Project Details:

ISST is sales and service application to interact the customer with different offers or information related to his account using different campaigns.

Responsibilities:

  • Develop programs that convert raw SAS datasets to standard format. Create standard programs and macros.
  • Provides all levels of technical and application support, incident management (Level 2 & 3 support). Addressing users, data issues and application related issues.
  • Developing ISST reports for the user to analyze the customer.
  • Develop in Linux/SAS GRID environment, within an Agile framework.
  • Develop ETL solution for front end application.
  •  Fine-tune the existing scripts and process to achieve increased performance and reduced load times for faster user query performance
  • Create SAS views and SAS indexes to reduce I/O bottlenecks and processing time for large volumes of data.

Show More Show Less

Tools

ETL

Credit Risk

Company

Credit Risk

Description

Role   SAS Analyst

Organization   BA Continuum India Pvt Ltd

Tool/Languages    SAS

Project Details:

Credit Risk is application to analyze the risk associated with customer to the bank. It runs on UNIX-Sun OS. Developed in SAS grid.

Responsibilities:

  • Imports data from different sources in different formats such as Excel, csv and flat file
  • Generate tables, listing and graphs using PROC REPORT and PROC GPLOT
  • Create macros and used in existing macros to develop SAS programs for data analysis.
  • Produce SAS reports in SAS in RTF, PDF, CSV and HTML formats.
  • Analyze, design and test fix requests and enhancements to SAS solutions.

Show More Show Less

Tools

Excel Macro

IDN Basel

Company

IDN Basel

Description

Role   Senior Programmer

Organization   BA Continuum India Pvt Ltd

Tool/Languages    SAS,Teradata

Project Details:

IDN Basel is a migration project from SAS to Teradata equivalent stored procedures and from Sybase data base to Teradata. The main challenge is to provide real time data to users with the quality and accuracy. Focused on design improvement, developing tools and database features that facilitate query-plan analysis and performance tuning.

Responsibilities:

  • Converting SAS to Teradata stored procedures.
  • Data Analysis and issue identification.
  • Fine-tune the existing scripts and process to achieve increased performance and reduced load times for faster user query performance

Show More Show Less

Tools

Database

Data Quality and Data Governance

Company

Data Quality and Data Governance

Description

Client  AMEX

Role  Senior Programmer

Organization  Cognizant technology solutions

Tool/Languages  Teradata, SQL Assistant, Informatica 8.x, Event Engine

Project Details:

DQ and DG is Metadata driven data management (data Movement, data Validation, data standardization, data loading) project.

Responsibilities:

  • Developing SQL Queries to fetch the appropriate results requested by User. Developing PL-SQL code and Unit testing.
  • Preparing design documents and testing strategy for the application.
  • Responsible for testing support from UAT phase and scheduling the jobs in Event Engine.

Show More Show Less

Customer Risk Solutions – Customer Data Mart

Company

Customer Risk Solutions – Customer Data Mart

Description

Client  Bank of America

Role  Teradata Developer

Organization  Infosys Limited

Tool/Languages  SQL Assistant, Mainframes, Autosys, Unix Shell Scripting, Informatica 8.x

Project Details:

CRS is one of the key application systems ofBanking domain uses FSLDM model where it gives all the information about risks involved in a customer

Responsibilities:

  • Developing code based on the requirements from the client.
  • Debugging of the Scripts and executing them through Putty.
  • Track defects in the code and retest them when fix has been applied.

Show More Show Less