|
|
|
Professional Profiles |
|
IT-CAREERNET
.
|
From: Kousikan Veeramuthu, Informatica Developer
Date: Tuesday, June 28, 2005
Time: 09:41 AM
KOUSIKAN VEERAMUTHU 12,Unity Apartments, Varadarajpet main rd, Choolaimedu, Chennai-94 Ph- 09444305349 E-Mail- kousikan@gmail.com EXPERIENCE SUMMARY: Around two years of software development experience in Informatica Experience and knowledge in data extraction data transformation and data loading Good knowledge on data warehouse concepts like star schema, snow flake schema, dimension and fact tables Developed mappings using various transformationsProficient in using Informatica Workflow Manager to create and schedule workflows, sessions and batchesWorked on SQL and PL/SQL Done performance tuning to improve the session performance Trained and used CMM process methodologies Preparing for Informatica certification. TECHNICAL EXPERTISE: Elements Particulars Primary Skills Informatica 5.1, 6.2 Operating Systems WINDOWS, HP-UNIX Languages SQL, PL-SQL Development Tools TOAD, AQT Databases ORACLE 9i,DB2 UDB v7, MS Access Domain Knowledge Retail Configuration Tools VSS EXPERIENCE DETAILS: (starting from the current employer) SL. NO. NAME OF THE ORGANIZATION DESIGNATION FROM TO 1 Caritor India Pvt Ltd SE March 2004 Till date 2. Livewire Solutions SE Trainee July 2003 February 2004 PROJECT DETAILS: 1. NAME OF THE COMPANY Caritor India Private Limited PROJECT NAME BPM-Weekly Labor Data CLIENT Staples PROJECTDESCRIPTION Staples Europe, which primarily deals with Office supplies, Furniture and Technology products require Extract, Transform and Load (ETL) processes to be created for loading into the Enterprise Data Warehouse (EDW) tables. Current BRIO KPM Report process needs Weekly Labor Data, which comes from LDMS on Weekly basis. The data is used within BRIO to generate KPM primary and secondary reports. The Labor data from LDMS would be now fed on weekly basis to EDW. A CSV file will be generated on weekly basis from LDMS database after the WAR report is completed and data in Weekly Labor table is updated. ENVIRONMENT Informatica 6.2, DB2 v7, MS Access 97 DURATION From 05/05 To Till Date ROLE / RESPONSIBILITY Team Member CONTRIBUTIONS Design in association with onsite PM, development and testing of Mappings, Workflows.Testing the correctness of the mapping by simulating the transformations in Access.Optimized the module for better performance using various tuning techniques TEAM SIZE 3 2. NAME OF THE COMPANY Caritor India Private Limited PROJECT NAME Europe Facts CLIENT Staples PROJECTDESCRIPTION Staples Europe, which primarily deals with Office supplies, Furniture and Technology products require Extract, Transform and Load (ETL) processes to be created for loading into the Enterprise Data Warehouse (EDW) tables. It contains the modules of Shipment, Shipment Line, Tender Sales, and Coupon Usage Sales. The requirement is to load the sales that are done by Coupon Usage, Tender, Shipment processes into separate DB2 tables. ENVIRONMENT Informatica 6.2, DB2 v7, MS Access 97 DURATION From 02/05 To 05/05 ROLE / RESPONSIBILITY Team Member CONTRIBUTIONS Design, development and testing of Mappings, Workflows, Optiload scripts.Optimized the module for better performance using various tuning techniques TEAM SIZE 3 3. NAME OF THE COMPANY Caritor India Private Limited PROJECT NAME Weekend Inventory CLIENT Staples PROJECTDESCRIPTION Staples Europe, which primarily deals with Office supplies, Furniture and Technology products require Extract, Transform and Load (ETL) processes to be created for loading into the Enterprise Data Warehouse (EDW) tables The data for inventory will be staged from formatted fixed length flat files and sent to the EDW from the AS/400 system by FTP. The requirement is to load the inventory details into DB2 table and to find the available inventory at the end of the week. ENVIRONMENT Informatica 6.2, DB2 v7 DURATION From 12/04 To 01/05 ROLE / RESPONSIBILITY Team Member CONTRIBUTIONS Design, development and testing of Mappings, Workflows, Optiload scripts and Balancing code for Weekend Inventory data load. TEAM SIZE 3 4. NAME OF THE COMPANY Caritor India Private Limited PROJECT NAME Sales Inventory Operations and Planning (SIOP) CLIENT Honeywell-Aerospace PROJECTDESCRIPTION SIOP data mart fetches data from Heterogeneous sources such as GMS, CSDM, Havrell etc. The reports include Sales Revenue Analysis and Fleet Information Analysis. The objective of this project is to track the exact revenue obtained from both GMS and CSDM & to have an insight into the fleet information of the Parts Supplied by the Honeywell. ENVIRONMENT Informatica 6.2, Oracle 9i DURATION From 08/04 To 11/04 ROLE / RESPONSIBILITY Team Member CONTRIBUTIONS Creating Repository for Informatica Power Center 6.2Involved in creating & validating the Mappings. Creating and running workflowsCreating SQL scripts TEAM SIZE 4 5. NAME OF THE COMPANY Caritor India Private Limited PROJECT NAME Contract Manager CLIENT Honeywell Aerospace PROJECTDESCRIPTION Contract Manager is a browser-based application used to create, evaluate, and manage contracts. Contract Manager consists of a repository where all contracts can be stored, providing the ability to create contracts from existing templates and clauses, and to edit and modify contracts as necessary. ENVIRONMENT Informatica 5.1.2, Oracle8i DURATION From (04/04) To (07/04) CONTRIBUTIONS Creating Repository Involved in creating & validating the Mappings. Creating and running workflowsCreating SQL scripts ROLE / RESPONSIBILITY Team Member 6. NAME OF THE COMPANY Caritor India Private Limited PROJECT NAME CHAMPS CLIENT Honeywell Aerospace PROJECTDESCRIPTION CHAMPS (Customer Homebase for Aftermarket Maintenance Programs System) are a Siebel Systems enterprise application for handling Aftermarket programs. It is a CRM application used by Honeywell claims and contracts administrators. ENVIRONMENT SIEBEL DURATION From (03/04) To (04/04) ROLE / RESPONSIBILITY Team Member CONTRIBUTIONS CHAMPS has got 18 interface loads which runs at schedule time and load data from other system into CHAMPS and also feeds other systems I handle failures in the interfaces, if any and do the necessary actions to correct them. I was also instrumental in delivering the maintenance requests, which would be assigned to the support team. TEAM SIZE 4 7. NAME OF THE COMPANY Livewire Solutions PROJECT NAME RHC - Performance Analyzer CLIENT Red Hill Credits PROJECTDESCRIPTION Red Hill Credits is a commercial finance company that finances businesses in the US. The company has a sales force, which adds clients (accounts) and identify prospective businesses with the client. The goal of the Red Hill commercial finance is to analyze the performance of various divisions and the sales persons in those divisions. It also evaluates the performance of various products over different regions, industry and customers. The analysis involves studying the historical business trends using historical data.The various stages the sales process undergo and the success/failure rate in those stages are also analyzed. This helps the manager to make stage level analysis for business failure and successes. ENVIRONMENT Informatica 5.1.2, Oracle 8i DURATION From (07/03) To (02/04) ROLE / RESPONSIBILITY Team Member CONTRIBUTIONS Developed mappings using expression, aggregator, filter, normalizer, joiner, lookup, router, update strategy and procedures to develop and feed Data MartsDeployed and tested sessions in Informatica Server TEAM SIZE 4 QUALIFICATION DETAILS: (Highest degree on top) SL. NO. DEGREE BRANCH YEAR OF PASSING NAME OF THE COLLEGE / INSTITUTE NAME OF THE UNIVERSITY Percentage / CGPA / Grade 1 B.E. Information Technology 2003 Kongu Engineering College Bharathiyar University, Coimbatore 72 2 XII NA 1999 Viswadeepthi Mat. Hr. Sec School Tamilnadu 90 3 X NA 1997 Viswadeepthi Mat. Hr. Sec School Tamilnadu 82
|
|
|
|
|
|
|
|
© 2002-11 IT-Careernet.com
Reproduction, retrieval, copying or
transmission of the content of this site is not permitted without the
publisher's prior consent. Last changed:
January 27, 2012
|
|
-start of code- -end of code- &n bsp; Sponsor: ITC Software
