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.