| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateCandidate's Name JulagantiEmail: EMAIL AVAILABLE Phone: PHONE NUMBER AVAILABLEExperience 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 FinanceSynopsisMe to be a sincere and hardworking person and made me a team man to thecore, adaptable to any situation. My ability to grasp things, soundtechnical knowledge and good communication skills will make an idealcombination to next levelTechnical 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 AssignmentsThe details of the relevant assignments where I have been involved arelisted 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 ||Candidate's Name |self | | |3 | |Visa, || | | | | | |H1B Visa || | | | | | |(till Nov 20th|| | | | | | |2016) | |