E-mail:ma087b@r.postjobfree.com
Goutham V Mobile no: +91-819*******
Experience
Around 2 years of IT experience in which 2 yrs of experience on Data Warehousing.
Experience with Informatica 8.6 in developing complex mappings/sessions and workflows.
Excellent Communication skills,Core team player.
Extensively Worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
Having good exposure in Data warehousing Architecture and Technologies.
Having creative and independent problem solving skills, quick learning abilities.
Have Excellent PL/SQL programming skills.
Technical Skills
ETL TOOLS : Informatica 8.6
OLAP TOOLS : Business Objects XIR2
RDBMS : Oracle 10g.
Languages : C++, PL/SQL.
Operating System : Windows98/2000/NT/XP,HP UNIX.
Career
Working as a Software Engineer with Ciber India Pvt Ltd, Bangalore from May 2010 to till Date
Worked as a Software Engineer with Keane International India Private Limited, Bangalore from June 2009 to till April 2010
Project # 1
Title : Sales Datawarehouse
Company : Ciber India Pvt Ltd.
Client : Wolverine World Wide Inc.,USA
Role : ETL Developer
Team size : 6
Duration : May 10 to Till date
Environment : Informatica 8.6,Oracle 10g,Windows NT.
Description
Wolverine World Wide, Inc. engages in manufacturing, sourcing, marketing, licensing, and distributing footwear, apparel, and accessories to the retail sector primarily in the United States, Europe, and Canada. Its footwear product lines include casual shoes, dress shoes, boots, uniform shoes, and rugged outdoor and work footwear. It also offers casual, outdoor, and work apparel products. The markets its products under the brand names of, Bates, Cat Footwear, Chaco, Cushe, Harley-Davidson Footwear, Hush Puppies, HyTest, Merrell, Patagonia Footwear, Sebago, Soft Style, and Wolverine. The company wholesales its products to a range of retail customers, including department stores, national chains, catalogs, specialty retailers, mass merchants, and Internet retailers, as well as to governments and municipalities in the United States
Roles & Responsibilities
Extensively working on Informatica Designer, Workflow Manager, Work flow Monitor Working on Source Analyzer, Warehouse designer, Mapping Designer & Mapplet Designer.
Created mappings, reusable transformations in Mapping Designer.
Working on different Sources such as Oracle
Used Informatica to extract data into Data Warehouse, built Oracle.
Developed complex Mappings, Mapplets and Reusable Transformations to facilitate daily loading of Data into Oracle
Performed Unit testing of the mappings developed.
Created Low Level Designs for the mappings.
Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to model various standardized business processes.
Did performance tuning of Informatica mappings.
Project # 2
Title : RIDW (Retail Inventory data warehouse)
Company : Keane International India Private Limited
Client : Johnson & Johnson
Role : ETL Developer
Team size : 4
Duration : June 09 to April 10
Environment : Informatica 8.1,Oracle 9i,Windows NT.
Description:
This project has been developed for Johnson & Johnson. It has many consumer products like soaps, shampoos, detergents etc. This project is about designing a data mart for the details of the products manufactured and distributed. It gives a clear idea about the quantity of products manufactured and the quantity distributed according to the area and product. It helps the officials in development of better Organization intelligence, Reduce Costs and in making quick and effective decision-making and forecasting.
Roles& responsibilities:
Extensively working on Informatica Designer, Workflow Manager, Work flow Monitor Working on Source Analyzer, Warehouse designer, Mapping Designer & Mapplet Designer.
Created mappings, reusable transformations in Mapping Designer.
Working on different Sources such as Oracle
Used Informatica to extract data into Data Warehouse, built Oracle.
Created transformations and used Aggregator, Expression, Sequence Generator, Joiner, Filter, Router, Look up and Update Strategy transformations to model various standardized business processes.
Did performance tuning of mappings and SQL statements.
Education Qualification:
Bachelor of Technology in ECE from JNTU,Hyderabad.
Personal Information:
Personal : Male / Single / Indian.
Languages known : English, Hindi & Telugu