ANIL KASHYAP
Email Id Contact Address
*************@*****.***
F11,C 3, Sector 58, Vishan Pura Noida,
Contact No +91-954*******, 740-***-****
Noida 201301
Date of Birth 2 july 1990
Years ofExp:1 Years 07 Months
Professional Experience
Supasclus Pvt. Ltd., Noida – Since May 2012 to till date
Current
Organization:
Noida
Current Location:
Assistant software engineer
Current
Designation:
Summary
Having 1.7 years of experience in software industry with database designing, database development, Administration &
testing on production environment.
Having strong knowledge in database monitoring, Teradata tools & utilities like Multiload, Fastload, Parallel Data
Pump (Tpump), Arcmain& BTEQ, Teradata Parallel transporter (TPT), Viewpoint server, Netvault, TD SQLA,
TD-Administrator
Having strong knowledgeable in TD configuration, tuning and diagnosing performance issues.
Excellent knowledge on DBMS concepts.
• Knowledgeable in Teradata server and client based administration utilities like Filer, CheckTable, Config,
Reconfig etc.
Strong expertise in troubleshooting, monitoring and problem analysis.
Self-motivated, hardworking, possess strong analytical and problem solving skills and also result oriented with the
spirit of teamwork, effective communication and interpersonal skills. Eager to learn, able to adapt quickly, well-
organized and very reliable.
Technical Qualifications
B.Tech from K.I.E.T, Ghaziabad (Affiliated toU.P.T.U., Lucknow) in 2012.
Completed latest Teradata 12.0 Basics Certification in 2013.
Academic Qualifications
B.Sc from G.P.G.G.College affiliated to Agra University in 2009.
Intermediate from G.I.C farrukhabad,affiliated to UP Board Allahabad in 2006.
HighSchool from S.V.M. farrukhabad,affiliated to UP Board Allahabad in 2004
Technical Skills
Area Skills
Windows server 2003, Windows XP, suse9-10
Operating Systems/ Platform:
Databases / RDBMS: Teradata TD12, TD13, TD13.10
Teradata Tools & Utilities: Multiload, Fastload, Parallel Data Pump (Tpump), Arcmain & BTEQ, Teradata SQL
Assistant, PDCR, Archive/restore, TPT, TD Viewpoint server, TASM, TD-Administrator.
Others: Tivoli work scheduler(Maestro), ITSM, Netvault.
Industry Project(s) Details
Project #1: NIKKEI - Database Services
NIKKEI Digital Media, Japan
Client/Company:
Period: May 2012 to till date
SLES9 & 10
Environment:
Tools: BTEQ, Teradata Administrator, SQL assistant, Viewpoint, Netvault
Teradata 13.10
Database:
Role: Application DBA/Developer
Description:
Nikkei is one of the largest media corporations in Japan. Nikkei specializes in publishing financial, business and industry news.
Nikkei Digital Media provides a comprehensive information service well known as “Nikkei POS Information Services.” They
use a Teradata system to house core business data supporting their “Nikkei POS Information Services.”
Responsibilities: Designing, Development, Administration, support, Testing.
Teradata Database Development
Contribution:
Schema Designing.
Development of SQL (BTEQ) scripts.
SLA/SLE/Critical Batch monitoring and users’ tickets resolution.
Bug fix and permanent resolution.
Performance tuning.
Leading & mentoring new joiners in the team.
Teradata Database Administration
Schema Designing.
Preparing SQL Unit
Test Scripts and execution.
Creating Users and granting access/privileges based on requirement without impacting the
Security policies.
Managing the TD up gradation process by taking the CAB (i.e. Change advisory Board) approvals
and helping further to TD system database administrator during outage.
Ensuring perfect benchmark testing after the successful upgrade of latest TD version.
Suggesting the developers about the possible advantages/disadvantages of implementing a new
feature in database according to the new releases.
Ensuring 24*7 availability of TD Prod database to the client.
Continuous monitoring of the batch jobs/SQL’s triggered by Business End Users and Power Users.
Roles and Profiles Creation, space allocation, BAR process.
Development of SQL scripts.
Defect Reporting.
SLA/SLE/Critical Batch monitoring and users’ tickets resolution.
Creating databases and setting up Environment for Development, Testing and UAT and moving
the code and History data to production by following the implementation process.
Maintaining the Teradata Space efficiently for Business and batch jobs by ensuring the Data
currency is up to date.
Helping business in suggesting the new ideas to implement the on-demand requests successfully
with less load on TD servers.
Writing COLLECT STATS scripts based on the existing as well as adhoc queries and ETL loading
scripts.
Mentoring new joiners in the team.
Academic Project(s) Details
Project #1: R.G.B. Color detection
Krishna institute of Engineering & Technology
Client/Company:
Period: January 2010 to May 2012
Matlab 6.0, Windows 2007
Environment:
Tools: Matlab Kit,
Group Leader
Role:
Description:
In the project, we aim to develope a color spot as it is color of object or marketing in the image. It is used in armies, hospital and
photography etc.
Responsibilities: Testing Designing, Development, support.
R.G.B. color detection Development
Contribution:
Designing of Detection technique
Development Text scripts.
Monitoring and users resolution.
Bug fix and permanent resolution.
Performance tuning.
Leading & mentoring in the team.
Academic Project(s) Details
Project #2: Line follower Robot
Krishna institute of Engineering & Technology
Client/Company:
Period: October 2009 to December 2010
Embedded System, Windows 2007
Environment:
Tools: Keil 8051, Atmel Programming Tool.
Group Leader
Role:
Description:
Project “Line Following Autonomous Robot” is based on 8 bit Microcontroller. This Robot follows the black line which is drawn
over the white surface or it follows the white line which is drawn over the black surface. The infrared sensors are used to sense
the line. When the infrared signal falls on the white surface, it gets reflected and if it falls on the black surface, it is not reflected
this principle is used to scan the Lines for the Robot. All the above systems are controlled by the Microcontroller. Microcontroller
gets the signals from the infrared sensors and it drives the motors according to the sensor inputs. Two DC motors are used to
drive the robot.
Responsibilities: Implementer, Testing Designing, Development, support.
Line Follower Robotic Development
Contribution:
Designing of Detection technique
Development Text scripts.
Performance tuning.
Leading & mentoring in the team.
Personal Information
Gender: Male.
Mr. Surendra Kashyap
Father’s Name:
Strengths : Open to learn new technologies.
Work-aholic, Energetic and Good Team Player.
Hobbies: Reading books, Watching movie, Listening music, Cooking.
Permanent Surendra Kashyap, Ganga Nagar Colony, Lal Gate, Farrukhabad
Residential Pin Code- 209625 U.P.
Address:
I hereby declare that the information furnished above is true to the best of my knowledge and I bear the responsibility
for the correctness of the above-mentioned particulars.
Date:
Place: (Anil Kumar Kashyap)