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 MoreSkills
Web Development
Development Tools
Programming Language
Data & Analytics
Database
Others
Operating System
Software Engineering
Positions
Portfolio Projects
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.
Skills
TeradataTools
hadoopCompany
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.
Tools
ETLCompany
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.
Tools
Excel MacroCompany
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
Tools
DatabaseCompany
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.
Skills
Teradata InformaticaTools
SQL AssistantCompany
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.
Tools
SQL Assistant MainFrames