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.

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.

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.

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

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.

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.