Post Job Free

Resume

Sign in

Informatica Administrator

Location:
Portsmouth, NH
Posted:
June 01, 2015

Contact this candidate

Original resume on Jobvertise

Resume:

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)



Contact this candidate