Dwarakanath Julaganti
Email: acpziy@r.postjobfree.com
Phone: 732-***-****
Experience Summary
. Having 7+ years of experience in Data Warehousing projects
involving various aspects like Requirements gathering, System
Analysis, Design, Testing, Administration and Project management
of Business intelligence (BI) applications to support various
business processes.
. In-depth knowledge with hands-on experience on a variety of Data
warehouse tools and technologies like Informatica, OBIEE,Teradata,
Oracle, Business Objects, UNIX
. Working as a Informatica Administrator since 7+ years covering
various Infrastructure upgrades (5x to 7x, 7x to 8x and 8x to 9x),
Production support, application support, environment
maintenance,Migration from separate infrastructure to shared
infrastructure etc
. Worked on installing and configuring various Informatica internal
tools like IDQ, TDM, DVO, Metadata manager and Business Glossary.
. Worked as a onsite Lead for about 3 years in Informatica
Administration
. Worked in setting up end to end infrastructure for both Dual and
Non Dual Disaster recovery (DR) env.
. Ability to quickly analyze and come-up with an efficient industry
standard solution for a given problem.
. Effective communicator and energetic team player with excellent
business, and interpersonal skills.
. Problem solving skills and an attitude to learn the new cutting
edge technologies.
. Possess Domain Knowledge in Entertainment Media, Sales, and Finance
Synopsis
Me to be a sincere and hardworking person and made me a team man to the
core, adaptable to any situation. My ability to grasp things, sound
technical knowledge and good communication skills will make an ideal
combination to next level
Technical Skills
Software and Tools - Informatica Power Center 5.1.1, 6.2.1,
7.1.2, 8.6.0 hotfix 9,8.6.1 hotfix13
,9.0.1 hotfix2,Informatica 9.1.0 Hotfix3,
Informatica 9.5.0,9.5.1 hotfix3, 9.6.0 and
9.6.1 hotfix1
- Business Objects XIR2,3.1
- OBIEE 11.1.1.6.11
- DAC 11g
- Toad,PL/ SQL developer
- control m
Programming Languages - UNIX shell scripting
Databases - Oracle 9i, 10g (RDBMS), 11g
- Teradata 12.00, 13.00,13.10,14.10
- Microsoft SQL server 2005 & 2008
Operating Systems - Red Hat Linux 5.x,Oracle Linux enterprise
OEL 5.4,6.3 and AIX 6.1
- Windows 2000,XP,Windows 7
Business Areas Life sciences
Media/ Home Entertainment
Insurance
Qualifications
Degree and Date Institute Major and
Specialization
Bachelor of Golden valley Computer science
Engineering - B.E Institute of
(2001-2005) technology,
visveshwaraiah
Technological
University
Professional Memberships / Certifications
Professional Society / Certification Member Since / Date
Certified
GB Certified December 2009
Career Profile
Dates Organization Role
(April 2008 - Till Tata Consultancy Assistant Consultant
date) Services
(July 2007 - March Six sigma solutions Assistant system
2008) Pvt Ltd Engineer
Career Assignments
The details of the relevant assignments where I have been involved are
listed here, in chronological order.
Project Title 9 LM ETS Tech Build
Customer Liberty Mutual Insurance
Work Location(s) Dover,New Hampshire,USA
Period December '13 - till date
Description LM ETS Tech Build main aim is to upgrade ETL
tool to
9.5.1 and migrate few applications from
other/independent infrastructure to
Shared infrastructure and also to build a
separate 9.6.1 infrastructure for Informatica
internal tools such as Metadata manager, DVO,
Business Glossary, IDQ and TDM tools.
Position Informatica Administrator
Solution Environment AIX 6.1,Redhat Linux 6.3, Sql server 2008,
Teradata 14.10, DB2 Connect V9.7, Oracle 11g etc
Tools Informatica 9.5.0, 9.5.1 hotfix3, 9.6.0 and
9.6.1
Responsibilities Oversight of daily incident and change
management activities with a team of L2 and L3
analysts and Production Support teams.
Liaison between L2 and L3 analysts and
development leads; able to decipher, manage and
track ongoing issues that can become trends
and/or involve coordination between other
technical teams that interface with the
application.
Drives root cause analysis to completion.
Building the end to end required infrastructure
in Informatica 9.5.1 for various markets such as
CI,PI,corporate and GS
Migrating/Upgrading Applications from various
infrastructure to shared Grid infrastructure for
various markets such as CI,PI,corporate and GS
Setting up 9.6.1 infrastructure for various
Informatica internal tools such as
IDQ,TDM,Business Glossary,DVO,Metadata manager
Applying hotfixes
Applying Emergency Bug fixes (EBF)
Installing and configuring Teradata PT,PWX for
SAS,Salesforce and MQ etc
Project Title 8 Covance_GLA_OBI_Apps_Upgrade
Customer Covance Inc
Work Location(s) Bangalore, India & Princeton,New Jersey,USA
Period April '13 - November '13
Description Covance_GLA_OBI_Apps_Upgrade at Covance main aim
is to upgrade OBI Apps from 10g to 11g
Position OBI Apps Administrator (ETL, OBIEE and DAC)
Solution Environment Oracle Linux Enterprise 6.3, Oracle 11g database
Tools Informatica 9.0.1 hotfix 2, OBIEE 11.1.1.6.11,
DAC 11g
Responsibilities Gather Requirements for setting up
Infrastructure
Building a end to end POC environment similar to
10g env
Working with server build team and providing the
requirements of server, SAN storage,NAS storage
e.t.c
Installing oracle client on oracle Linux
enterprise server.
Installing i9pi tool and take corrective
actions.
Installing Informatica 9.0.1 HF2 in Oracle Linux
enterprise servers
Upgrading Informatica repository from 8.6.1
hotfix 2 to 9.0.1 hotfix2
Resolving bugs/issues
Installing RCU for OBIEE 11g in Oracle Linux
enterprise servers
OBIEE Horizontal clustering configuration.
Applying OBIEE patches to upgrade from
11.1.1.6.10 to 11.1.1.6.11
RPD,Catalog upgrade from 10g to 11g.
LDAP configuration in OBIEE 11g
Installing DAC and configuring the connection
between DAC server and client.
Upgrading DAC repository from 10g to 11g.
Project Titles 1 to NBC Tech Build - Informatica 9.5 POC (January
7 (Dates) '13 - March '13)
NBC Tech Build - (November '11 - December '12)
NBC Tech Build COE - Infrastructure upgrade
(June '10 - October '11)
NBC Tech Build COE - (Feb '10 - Jun '10)
Business Intelligence and Integration - (Aug '09
- Jan '10)
Business Intelligence & Integration build CoE
(BII) (Dec '08 - Jul '09)
Business Intelligence and Infrastructure -
(Jun'07 to Nov' 08)
Customer GE - NBC Universal
Work Location(s) Bangalore (India),Guadalajara,( Mexico),Mumbai
(India) & New Jersey (USA)
Period June 2007 - March 2013
Description NBC Tech Build at NBC Universal main aim is to
conduct Proof of concept (POC) for Informatica
9.5.0 and its relevant batch server nodes
Position Informatica Administrator
Solution Environment Red Hat Linux 5.x,Oracle Linux Enterprise 5.4,
Oracle 11g database, Teradata 14.0
Tools Informatica 5.1.1, 7.1.2, 8.6.0 hotfix 9,8.6.1
hotfix13,Informatica 9.1.0 Hotfix3
Responsibilities Build 9.5 POC Infrastructure to the client
Build Informatica 9.1.0 and its relevant batch
server nodes similar to old infrastructure
(8.6.1)
Upgrade informatica from 8.6.0 hotfix 9 to 8.6.1
hotfix13 and Teradata TTU 12 to TTU 13 on
informatica and batch server nodes
Build a Disaster recovery env both Dual and Non
dual load for critical apps like DMM,Home
entertainment etc of NBC universal
integrate all separate businesses to single
Infrastructure for International DSE and Home
entertainment (Hedway)
Build new infrastructure for NBC and upgrading
Informatica repositories from 7.1.2 to 8.6.0
Performing administration activities in various
DWH tools such as Informatica, Business objects
and Teradata and work closely with different DWH
BTG teams throughout the Software Development
Lifecycle of the projects
Personal Details
Date of Birth 11th April 1983
Sex Male
Nationality Indian
Marital Status Married
Date of Joining 02-04-2008
Designation Assistant Consultant
Location Dover,New Hampshire
Languages English, Telugu,Tamil and Kannada
Passport/Visa Details
Name as on Relations Passport Date of Expiry Place of Valid USA
passport hip Number Issue Date Issue visa's
Juliganti L1343438 30/04/2013 29/04/202 Bangalore B1 Business
dwarakanath self 3 Visa,
H1B Visa
(till Nov 20th
2016)