CURRICULAM VITAE

SREERAM THATTARI

Mobile : +91-738*******

E-mail : e9l0m5@r.postjobfree.com

SUMMARY:

• Having 4+years of experience in the Information Technology, which includes 3+years of experience in Informatica and in development of Web-based solutions & Application development.

• Good exposure to ETL tools like Informatica 8.6.1/8.1.

• Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment.

• Extensively worked on Informatica Tools-Source analyzer, Warehouse designer,

Mapping designer, Transformation developer and Mapplet designer

• Data is extracted and transformed using Informatica predefined transformations like source Qualifier, Aggregators, lookup, Filter, Joiner, Update strategy and sequence generator etc

• Logical, Analytical and good interpersonal skills, Commitment to perform quality work, and an Excellent Team player.

TECHNICAL EXPERIENCE:

Working as an ETL Developer for CSC India Pvt Ltd, Hyderabad from 2008 to Till Date.

Worked as Software Engineer for Mist Technologies, France (2008).

Worked as Software Engineer for Ausy, France (2007).

SKILL SET:

ETL Tools : Informatica 8.6.1 & 8.1.

OLAP Tools : Cognos.

Operating Systems : Windows 2000/Windows NT, XP, Linux.

Languages : SQL and PL/SQL

Databases : Oracle9i/8i, MS-Access.

EDUCATION:

Masters of Science in Electronics and Embedded Systems from ESIGELEC with Bronze Medal- Ecole Superieure d’lngenieurs Generaliste. Paris, France.

Bachelor of Technology in Electronics & Communication Engineering from JNTU.

PROJECTS EXPERIENCE:

Project [1]

Client : Federal Bank Loan System, U.S.A.

Period : August 10 to till date

Role : ETL Developer

Team Size : 12

Environment : Oracle 10g, Informatica 8.6.1, Windows 2000.

Description:

. This banking corporation with more than 2500 branches and 4 zones located all over united states. Unlike normal banking this provides payday loans i.e. Small loans for a short period. They have two systems in place advantage and e-advantage. Advantage application captures data into flat files, where as e-advantage application pumps huge amount of data into the production database, which makes it impossible to maintain it beyond 90 days, which is stored in flat files and a database (e-advantage). Each location at the end of the day has to pump data into central zones and generate reports for different purposes .

They needed a Data Warehouse so that they could maintain historical data at central location for integration, analyze business in different locations according to profit areas, which would serve a purpose of a DSS for decision makers

Roles and Responsibilities:

• Used ETL to load data from Oracle and Flat files into the target Oracle database.

• Implemented Slowly Changing dimension type2 methodology for accessing the full history of accounts and transaction information.

• Worked on Informatica tool-Source Analyzer, Warehouse designer, Mapping designer and Transformations.

• Most of the transformations used are like the Source Qualifier, Aggregators, Connected & Unconnected Lookups, and Filters & Sequence for transforming data as per user requirement.

• Used Workflow Manager to design sessions, event wait/raise, and assignment tasks to execute mappings.

• Involved in Testing and Reviewing of the Mappings and also Tuned for better Performance.

PROJECT [2]

Client : Spartan Stores, Michigan.

Period : Nov 08 to May 10

Role : ETL Developer

Team size : 10

Environment : Oracle 9i, Informatica 8.1, Windows 2000.

Description:

Spartan Stores owns and operates 54 supermarkets and 19 deep-discount drugstores in Michigan and Ohio under the Family Fare Supermarkets, Glen's Markets and The Pharm banners. The company also supplies 40,000 private-label and national brand products to more than 330 independent grocery stores. The main aim of the project is to deliver data warehouse as a central repository to access data from segments to make data available for analysis and reporting.

Roles and Responsibilities:

• The project involved developing mappings for moving data from Flat Files to Staging (STG) and then to Data Mart.

• Developed Informatica mappings for Extraction, Validation, Transformation and Loading of Data.

• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer.

• Developed mappings using different transformations like Source Qualifier, Joiner, Rank, Lookup, Filter, Router, Sequence Generator, Aggregator and Update Strategy etc.

• Worked on Source analyzer and Warehouse designer to extract source and target into the workspace.

• Involved in Testing and Reviewing of the Mappings and also Tuned for better Performance.

• Used Informatica Workflow Manager to create, Schedule, execute and Monitor Sessions and Workflows.

Project Title [3]

Client : Mist Technologies, France.

Duration : Sep 2007 – Feb 2008.

Environment : Linux.

Tools : Symfony, Apache Tomcat, Firebug.

Language : Java Script, AJAX, HTML, PHP.

Description

Symfony is a complete framework designed to optimize the development of web applications by way of several key features. For starters, it separates a web application's business rules, server logic, and presentation views. It contains numerous tools and classes aimed at shortening the development time of a complex web application. Additionally, it automates common tasks so that the developer can focus entirely on the specifics of an application. The end result of these advantages means there is no need to reinvent the wheel every time a new web application is built

Symfony is developed in PHP and dedicated to building web applications with the same language. Therefore, a solid understanding of PHP is required to get the most out of the framework. The minimal version of PHP required to run symfony is PHP 5.1.

Roles and Responsibilities:

• Installing Symfony and configuring.

• Design of the User Interface using PHP.

• Development of PHP for the “View”.

• Development of PHP for the “Controller”.

• Development of YML,SQL and XML for the “Model”

Project Title [4]

Client : Ausy, France.

Duration : Mar 2007 – July 2007.

Environment : Windows XP.

Tools : Eclipse, Apache Tomcat, CVS, Firebug.

Language : Java Script, AJAX, HTML, JAVA, Jakarta Struts, JSP.

Description

Model-view-controller (MVC) is an architectural pattern used in software engineering. In complex computer applications that present a large amount of data to the user, one often wishes to separate data (model) and user interface (view) concerns, so that changes to the user interface do not affect the data handling, and that the data can be re-organized without changing the user interface. The model-view-controller solves this problem by decoupling data access and business logic from data presentation and user interaction, by introducing an intermediate component.

In MVC the presentation layer is further separated into view and controller. MVC encompasses more of the architecture of an application than is typical for a design pattern.

Roles and Responsibilities:

• Design of the User Interface using HTML.

• Development of AJAX and JavaScript functions for the “View”.

• Development of Java and Jakarta Struts for the “Controller”.

• Development of SQL and XML for the “Model”.

Contact this candidate