| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
NAME
Candidate's Name Thombath
Mobile: PHONE NUMBER AVAILABLE
Email :EMAIL AVAILABLE
SUMMARY
4.8 years of Information Technology experience in understanding and analyzing the
software and hardware engineering requirements
Expert knowledge of Netezza, Teradata, Oracle 10 g,11g,SQL,PL/SQL,Unix .
Good experience on working on applications like Aginity Workbench for Puredata
System for Analytics,Teradata SQL assistant, Informatica PowerCenter 9.1 tool
,Erwin Data Modeler tool,Toad,Wherescape tools(RED,3D). Utilized these applicants
to query and build on databases.
Expert in fastload, multiload, fastexport and creating unix scripts .
Work Experience
Worked with Infosys as a Senior System Engineer from September 2012 to May 2016.
Currently working with Visual IQ as Senior Software Engineer from June 2016.
Academics
B.E (Mechanical Engineering) from MSRIT (M.S Ramaiah Institute Of Technology)
2012.
SKILLS
Aginity Workbench for Puredata Analytics,Teradata SQL
Tools & Technology Assistant,Informatica Powercentre 9.1,Toad,Wherescape RED,
Wherescape 3D,ERWIN data modeler
Java ,c++,HTML
Language known
Database Known Netezza,Teradata,Oracle, MySQL
Operating System Windows, Unix
PROJECT DETAILS
Project: Marketing Attribution using the cookie data provided from multiple Ad servers
Client: DFS,John Lewis,Orange
France,Softlayer,Volaris
Duration: June 2016Till Date
Environment: Netezza, S3 Cloud
Tools Used: Aginity Workbench for Puredata System for Analytics
Project Overview: This project is to provide complete analytical level data for the client to reduce their
market spend based on the multiple graphs, dashboards and reports provided for the client through an
User Interface exclusively developed for each client to analyzing on the marketing attribution based on
the cookie data and other offline data.
Roles and Responsibilities:
Load the cookie level data i.e click, activity and impression data to the database through a company
developed platform from the AD servers or other vendors.
Report on the issues found in data and get it resolved from vendors and make the data available for true
metric calculation
Cookie level data along with other lookup data is used and run through a workflow which uses Cloud
and Netezza for processing these data for calculationg the true metric.
We procees the data by giving credit to all touch points thorugh which a click or impression got
converted for the calucation whereas many other marketing attriution companies works on the last click
attribution concept.
Provide technical solutions to address design issues.
Design approval and documentation.
Project: NMG(Next Gen Merch Analytics) II
Client: Nordstrom
Duration: Jan 2015May 2016
Environment: Teradata,Unix,Oracle
Tools Used: Informatica PowerCenter 9.1,Wherescape RED, Wherescape 3D,ERWIN Data Modeler,SQL
assistant
Project Overview: This project was taken up to migrate the existing US rack stores merchandising data
from one database to another(oracle to Teradata).In the new database the complete information will be
supported by a new system RMS14(Retail Merchandising System).This is an upgraded version of the
existing system RMS9.All the existing reports and extracts accessed by the users will be updated
accordingly to fetch information from the new database.
Roles and Responsibilities:
Design the approach of stored procedures and shell scripts for storing and maintaining merchandising
data.
Making data models using reverse engineering and forward engineering approaches in wherescape 3D
and ERWIN data modeler. The diagrams made in the tools is saved as pdf format and present to client
architects to finalize on the design.
Used Teradata SQL assistant and toad to analyze the data in multiple databases and design based on
the analysis results.
Used Informatica PowerCenter and wherescape RED ETL tools for building data warehouses. The data
is fetched from the source files or databases and transformed to the required format and loaded into
different tables and made available to the business users with the required analytical data.
Provide technical solutions to address design issues.
Design approval and documentation.
Coding of stored procedures and shell scripts.
Unit testing for the code components.
Deployment of code components to production environment.
Production support for deployed code components.
Project: NMG(Next Gen Merch Analytics)
Client: Nordstrom
Duration: Jun 2014Dec 2014
Environment: Teradata,Unix,Oracle
Tools Used: Informatica PowerCenter 9.1,Wherescape RED, Wherescape 3D,ERWIN Data Modeler,SQL
assistant
Project Overview: Nordstrom Inc. was only having stores in the US. Currently Nordstrom is planning to
open full line stores in the Canada to improve their business. This project is taken up to support all the
merchandising data(sales,receipts,transfer,on order etc) related to the newly planned Canada stores.
Roles and Responsibilities:
Requirement gathering and analysis,Interacting with client architects to create technical
architecture,Providing estimates.
Creation of functional and detailed design, technical design documents, unit test cases.
Coordinating with other development teams, allocation of work among the team members, mentoring
the team.
Used ERWIN data modeler and wherescape 3D for designing the table structures based on the
requirements.
Used Wherescape RED and Informatica PowerCenter to create objects and use them to build
procedures which loads extracted and transformed data from multiple sources like flat files,oracle
database, Teradata.
Technical reviews of the work done by the team.
Providing production support and performing/supporting system and user acceptance testing.
Design the approach of stored procedures and shell scripts for storing and maintaining merchandising
data.
Project: Code Migration from Oracle to Teradata
Client: Nordstrom
Duration: Mar 2014May 2014
Environment: Teradata,Unix,Oracle
Project Overview: This project was taken up to enhance the performance of the procedures and PL/SQL
Packages currently present in oracle to Teradata database. Both Oracle and Teradata are RDBMS
databases. However, Teradata is specially designed for Data warehouse. The data retrieval is much faster
in Teradata which is the major advantage. The main difference is Teradata supports parallelism and it
allows more data 10 to power 12 Gb where it increases stability when compared to Oracle.
Roles and Responsibilities:
Preparation of detail design, high level design, approach documents for the process.
Performed modifications on existing procedures as per change request and maintained it.
Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in
order to meet requirements for Extract, transformation, cleansing and loading of data from source to
target data structures.
Improved the performance of the application by rewriting the SQL queries.
Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries
and database links.
Set-up and Design of Backup and Recovery Strategy for various databases.
Provided user training and production support.
Project: International Clickstream
Client: Nordstrom
Duration: Sep 2013Feb 2014
Environment: Teradata,Unix,Oracle
Tools Used: Informatica PowerCenter 9.1,Wherescape RED, Wherescape 3D,ERWIN Data Modeler,SQL
assistant
Project Overview: This project involves capturing click details which involves the details of how many
times a product was clicked and viewed, opening a mail, closing a mail, opening links in the mail, filling
of feedback forms in the mail, registration details, order details etc kind of information involved while
shopping online through Nordstrom.com (Nordstrom, USA) into database tables.
Roles and Responsibilities:
Coordinated with the front end design team to provide them with the necessary stored procedures and
the necessary insight into the data.
Created and modified several UNIX shell Scripts according to the changing needs of the project and
client requirements.
Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from
the file, unzipping the file and remove the junk characters from the file before loading them into the base
tables.
Making data models using reverse engineering and forward engineering approaches in wherescape 3D
and ERWIN data modeler.
Used Wherescape RED and Informatica PowerCenter to create objects and use them to build
procedures which loads extracted and transformed data from multiple sources like flat files,oracle
database, Teradata.
Involved in the continuous enhancements and fixing of production problems.
Creation of database objects like tables, views, materialized views, procedures and packages using
oracle tools like Toad, PL/SQL Developer and SQL* plus.
Training new recruits.
Project: CNP(Customer Notification Platform)
Client: Nordstrom
Duration: March 2013August 2013.
Environment: Teradata,Unix
Tools Used: Informatica PowerCenter 9.1,Wherescape RED, Wherescape 3D,ERWIN Data Modeler,SQL
assistant
Project Overview: Rack App is a customer notification application which was developed for Nordstrom,
USA. This application will notify the customers whenever a new product of their interest gets launched in
the store. These notifications will be coming as a pop up in the customers phone on a daily/weekly basis.
The customer can navigate through the application to get more details on the products and the nearest
store in which the same product is available.
Roles and Responsibilities:
Install Extensive use of Unix Shell Scripts to automate process.
Used PL/SQL to create Packages, Functions, and Procedure.
Used wherescape red for making auto generated procedures.
Used Wherescape 3D to make database tables(a table is a set of data elements (values) using a model
of vertical columns(which are identified by their name) and horizontal rows, the cell being the unit where
a row and column intersect).
Used Teradata SQL asssistant(Teradata is a massively system used to move data to a warehouse where
it can be recalled and analyzed) to run sql queries.
Used Informatica PowerCenter to create objects and use them to build procedures on top of the tables
which loads extracted and transformed data from multiple sources like flat files,oracle database, Teradata.
Making data models using reverse engineering and forward engineering approaches in wherescape 3D
and ERWIN data modeler.
Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to
reduce the response time.
Involved in all phases of database development, from needs assessment to QA/QC, design, and
support.
PERSONAL DETAILS:
Father Name Ahamed Abdul Jaleel
DOB 25Jun1990
Gender Male
Marital Status Single
Pan Card No AQZPT2308M
|
