Management Assistant
Resume:
Pediredla
Jaganmohan
C/o
Magnus
Månsson
Landbrogatan
31A
LGH
1201
37134
Karlskrona
0046
723
219
471
*********@*****.***
CAREER
OBJECTIVE:
Looking
for
an
Innovative
and
challenging
software
development
and
testing
environment,
which
can
fully
utilize
my
capabilities
and
to
be
dynamic
software
professional
working
systematically.
With
my
education
as
a
strong
foundation,
I
want
to
be
a
part
of
progressive
organization
where
I
can
expose
my
knowledge.
Having
an
ability
to
learn
the
hard
way
and
take
deliberate
steps
to
overcome
the
problems
by
tapping
into
the
best
source.
Technically
sound
in
the
area
of
expertise.
PROFESSIONAL
SUMMARY:
Ø Over
2
years
of
diversified
experience
in
IT
in
enterprise
application
implementation/Database
administration
Ø Having
2
years
of
experience
in
TERADATA
ADMINISTRATION
worked
on
EDW
Utilities
(BTEQ,
SQL
assistant,
Multiload,
Fastload)
Ø Good
at
working
with
high
volumes
databases
of
multi
terabytes
Ø Expert
in
writing
Macros
and
Views.
Ø Proficient
in
Teradata
DBA
activities
like
creating
databases,
security-
managing
tables/indexes,
performance
tuning
and
managed
perm
spool
and
temp
spaces
DBS
control.
Ø Experience
knowledge
on
Teradata
tools
like
Teradata
administrator,
SQL
Assistant,
TSET
Ø Good
at
Teradata
Database
Object
Management,
Space
Management,
User
Management,
Viewpoint
monitoring,
Alert
Management,
Data
move
on
different
environments.
Ø Having
good
knowledge
about
database
internals,
how
data
flow
happens
in
Teradata.
WORK
EXPERIENCE:
Ø Worked
as
a
Teradata
DBA
for
Emphasis
Hyderabad
(July
2006-
December
2008).
ACADEMIC
EDUCATION:
Ø Masters
in
Electrical
Engineering
with
an
emphasis
on
Telecommunications
2009
(Blekinge
Tekniska
Högskolan,
Karlskrona,
Sweden)
Ø Bachelor
of
Technology
in
Electronics
and
Communication
Engineering
2001-
2005
(Biju
Patnaik
University,
Rourkela,
India)
PERSONAL
SKILLS
AND
COMPETENCES:
Technical
Skills
Ø Languages:
C,
Teradata
SQL
Ø Operating
System:
Linux,
Windows
95/98/NT/2000/XP/7,
Mac
OS.
Ø Applications:
Good
Command
on
Microsoft
Office
Tools
(Word,
Excel
and
Power
point).
Ø Database:
Teradata
TD12.
Familiar
with
TD
13.10.
Ø Tools
and
Utilities:
Teradata
Administrator,
SQL
Assistant,
Viewpoint,
FLOAD,
MLOAD,
TPUMP,
Fast
Export,
BTEQ,
Arc
Main,
Net
Backup
Utility
Languages:
Ø Swedish:
Basic
Level,
completed
ground
level
course
Ø English:
Advanced
Level
Ø Hindi:
Advanced
Level
Ø Telugu:
Advanced
Level.
PROJECTS
HANDLED:
P roject :
1
TITLE:
CUSTOMER
DATA
ANALYSIS
SYSTEM
Client/Company:
BAYER
Environment:
Teradata
12
Operating
Systems:
Windows
and
Linux
Duration:
February
2008 -
November
2008
PROJECT
DESCRIPTION:
Bayer
is
one
of
the
world’s
largest
pharmaceutical
companies,
which
has
implemented
a
large-
scale
Enterprise
Data
Warehouse
system
using
Teradata
database.
It
has
fields
of
activity
of
Healthcare,
Crop
science
and
Material
science
services
all
over
the
world.
Bayer
Healthcare
holds
a
global
leadership
positions
in
crop
protection
and
non-
agricultural
pest
control
and
also
has
major
activities
in
seeds
and
crop
plans
with
genetically
optimized
properties.
RESPONSIBILITY:
Ø Experience
using
Teradata
Administrator
and
Viewpoint
to
monitor
and
manage
Teradata
Database.
Ø Monitoring
blocked/idle
sessions
and
bad
performing
queries
through
viewpoint,
Session
monitoring
to
ensure
throughput
and
session
efficiency
Ø Creating
physical
database
objects
(tables,
views,
indexes,
macros,
procedures).
Ø Creating
users
and
User
rights
management.
Ø Creation
of
Roles
and
Profiles
Ø Execution
of
Adhoc
queries.
Ø Performed
BAR
activities
using
TARA.
Ø Maintain
Teradata
Database
Objects
and
Indices,
Space,
Users
and
alerts
associated
with
the
Teradata
Environment.
Ø Complete
Teradata
access
requests
(new
users,
password
resets,
password
unlocks
and
user
deletion)
as
required,
following
agreed
processes.
Ø Security
Administration
and
maintaining
Teradata
Roles.
Ø Configuring
and
monitoring
of
alerts,
queries,
locking
logger,
access
locks
and
database
performance.
P roj ect:
2
TITLE:
ISD
Data
Warehouse -
Teradata
Support
Client/ Company :
Wall -
Mart
Environment:
Teradata
Operating
Systems:
Windows
and
Linux
Duration:
March
2007 -
December
2007
PROJECT
DESCRIPTION:
Wal-
Mart
is
an
American
multinational
retailer
corporation
that
runs
chains
of
large
discount
department
stores
and
warehouse
stores.
The
company
is
the
world's
third
largest
public
corporation,
and
has
world’s
second
largest
database
in
terms
Size.
Wal-
Mart
data
warehouse
is
built
heavily
on
Teradata
Database
RESPONSIBILITY:
Ø Creating
objects
on
need
basis.
Ø Determining
the
Primary
Index,
which
is
very
vital
in
table
creation.
Ø User/Database
setup.
Implementing
Teradata
roles
and
profiles.
Ø Involving
in
Space
allocation.
Ø Tune
the
long
running
queries
raised
by
application
teams.
Ø Analyse
data
in
DBQA
table.
Ø Generate
weekly
report,
which
contains
expensive
queries
(which
are
taking
more
system
resources)
and
work
on
fixing
those
queries
using
query-
tuning
techniques.
Ø Preparing
reports
with
tuning
gains.
Ø Define
concurrency
thresholds
to
load
utilities.
Ø Define
rules
and
filters
to
stop
run-
away
and
bad
queries.
Ø Compressions:
Single
and
Multi
value
compressions.
Ø Optimised
collect
stats
process,
implementing
sample
stats
wherever
feasible.
Ø Implementation
of
Partitioned
Primary
Indexes
on
tables
having
size
more
than
30GB
Ø Co-
ordinating
with
application
team
for
production
role
outs.
REFERENCES:
1) Mikael
Åsman
Program
Manager,
E&E
Dept.,
Telecommunications,
BTH.
Email:
******.*****@***.**
Mobile:
+46
708
47
87
13
Contact this candidate