Home » Other » Marketplace » Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bangalore ( India)
Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bangalore ( India) [message #106396] |
Sat, 07 June 2003 04:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Shikshaplanet
Messages: 4 Registered: June 2003
|
Junior Member |
|
|
Hi Guys,
We need people with 5 + years of experience in any of the following field, with at least 2 = years experience in the same field. For various client based in Bangalore , India. Please send your resume to Jobs@shikshaplanet.com . Candidate should have BE / BTech/ MCA preferably with IITs, IISC, RECs.
1 - Cognos
2 - Informatica
3 - Datawarehousing, BI, BO
4 - ETL
5 - Teradata
6 - Oracle11i
7 - OLAP
Regards
Team
Shikshaplanet.com
|
|
|
|
|
Re: Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bangalore ( India) [message #106574 is a reply to message #106482] |
Fri, 20 February 2004 07:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rajesh paliwal
Messages: 1 Registered: February 2004
|
Junior Member |
|
|
Experience Summary
Contact no¡K +44 1582 428475 Ext. 8448
Rajesh Paliwal has 5+ years of experience in Information Technology as Datawarehousing Professional
2 years in Oracle (PL/SQL, Procedures and Functions) and 7 months in Sybase.He has onsite experience working for Britannia Airways based at Luton London in United kingdom¡K¡K
3+ years in Data Warehousing and Reporting
„h 3+ years in as Informatica Developer Using Power Center 1.7.2/5.1/6.1, Power Mart 4.7.2/5.1/6.1
„h 1+ years in COGNOS (Impromptu and Powerplay).
„h Knowledge of Data Modeling Tool Erwin 3.5.2.
„h Knowledge of Business Objects.
Excellent Communication and Interpersonal Skills
Job Title History & Working Experience
Consultant & Senior Analyst April 2002- till date
Working as a Senior Analyst at Promino Infosystems Bangalore
Since April 2002
Senior Software Developer June 1999- March 2002
Working as a Senior Software Developer from June 1999 to March 2002
Technical Summary
Informatica PowerCenter 6.1/5.1, PowerMart 6.1/5 Oracle 8i, Sybase 12
COGNOS (Impromptu 6.0 and Power Play 6.5) , Win¡¦ 2000/NT/XP
PL/SQL, T - SQL
SQL PLUS , Erwin 3.5.2
Shell Scripting , Business Objects
Education
1999
Bachelor of Engineering (Electronics ) Passed in First Class with Distinction. - 68.18 %
Dr B A M University, Aurangabad, Maharashtra.
Engagement Overview
Company Promino Infosystems Pvt ltd Bangalore
Period :- Aug 2003 ¡V till date
Client :- XL Global Services (XL Capital) , Stamford, Connecticut.
Position :- Sr. Informatica Developer
Environment :- Informatica Power Center 6.1, Sybase 12, SQL Server 2000, T-SQL,
SQL - Advantage, COGNOS (Impromptu and Powerplay),
Shell Scripting Windows NT
Application :- XLRe Enterprise Data warehouse
Worked as an Informatica developer on a Reinsurance Enterprise Data warehouse, The Reinsurance Data Warehouse Project was launched with the goal of building a single, centralized reporting environment that will cleanse and consolidate data from the XL Reinsurance Business Units on a daily basis, and format this data for reporting purposes. The design is based on Ralph Kimball¡¦s data warehouse design methodology, which allows for the design of an enterprise scale data warehouse that can be implemented.
The Enterprise Data warehouse consists of 3 major data London, Bermuda and America. The XL Reinsurance Data Warehouse BUS Matrix is a theoretical set of star schemas associated with the different business processes. From this data warehouse various data marts are built.
There were 3 sources for this warehouse AS 400, SQL Server and Sybase. The Repository was created on the Sybase database.
I was involved in understanding the business process, designing the specifications and developing the Informatica maps to load the various dimensions and facts in the Star Schema. There were 4 facts (Estimated, Ultimate, Earned and Actuals) and 13 Dimensions (Date, Company, Cedant, Account Service Broker, Layer, Contract, Class of Business, Profit Center, Zone, Currency, transaction header, transaction type, Peril).
I was also involved in building the HELPER table for Class of Business, Profit Center, Peril and Zone. The helper table was used for reporting purpose.
Roles:
„h Understood the Business process.
„h Wrote technical specifications to load the various dimensions and facts for Bermuda and America data.
„h Understand the Data Model for Enterprise Data warehouse and Data marts.
„h Designed the ETL process to load the Star Schema.
„h Created complex mappings using Informatica Designer.
„h Used Type 2 dimension to keep the history changes in the dimension and the fact.
„h Created Batches and Sessions for the mappings.
„h Used various transformations Normalizer, Joiner, Lookup, Aggregator, __Expression, Router, Filter, and Update Strategies.
„h Used Informatica Debugger extensively to test the Map.
„h Followed the Standard naming conventions and the process designed for Enterprise Star.
„h Involved in Unit testing for loading start schema.
„h Created QA maps to load dimensions and facts.
„h Optimized/Tuned mappings for better performance and efficiency.
„h Created Walkthrough documents for the maps.
„h Conducted the Walkthrough Presentation for all the technical specifications and Maps.
„h Migrating the Maps and Sessions to the production Repository.
„h Production Support.
Company Promino Infosystems Pvt ltd Bangalore
Period :- Feb 2003 ¡V July 2003
Client :- ConAgra Foods, Omaha, Nebraska.
Position :- Sr. Informatica Developer
Environment :- Informatica Power Center 6.1, Oracle 8i, PL/SQL, SQL*Plus,
COGNOS (Impromptu and Powerplay), Shell Scripting,Window NT
Application :- CIL - ConAgra Integral Logistics
Worked as a key developer on a large and very important logistics applications integration project for a major food services company. Using Informatica technology (PowerCenter 5.1) and Informatica best practices, created many mappings, which pertained to specific functional specifications. The code involved reading from complex source flat files, typically hierarchical in nature and having variable length records, performing various transformations (including looping via variable logic) and writing to proprietary target systems (such as Manugistics) in a specified format. Also did extensive unit testing, documentation and participated in integration testing. In addition, performed some migration of code and repository backups. During the testing period, many change requests were handled within tight timelines to meet the specific business objectives.
Roles:
„h Imported flat files from the hub and Manugistics.
„h Translated Business processes into Informatica mappings.
„h Developed Complex mappings by extensively using Informatica
„h Transformations like Lookup, Filter, Router, __Expression, Aggregator, Joiner, and Stored Procedures etc.
„h Wrote data extracts to tables and flat files
„h Created and Running / scheduling Batches and Sessions using the Server Manager.
„h Documented the existing mappings
„h Used Oracle 8i as the target database, Source database is a combination of Flat files, Oracle tables.
„h Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
„h Formatted the data in a specific format and writing it to the target flat files.
„h Optimized/Tuned mappings for better performance and efficiency
„h Migrated mapping to production after setting the environment.
„h Production Support.
„h Documented the mappings.
Company - Hughes Softwares India Ltd Gurgoan
Period :- Aug 2002¡V Jan 2003
Client :- Williams Communications, Tulsa, Oklahoma.
Position :- Sr. Informatica Developer
Environment :- Informatica Power Center 1.7.2, Oracle 8i, PL/SQL, SQL*Plus, Sun
Solaris(2.6) COGNOS (Impromptu and Powerplay), Shell Scripting.
Application :- ASR - Data Warehouse
ASR (Active Service Request) is a data warehouse project for Williams Communication¡¦s. This maintains the operational data and the Historical data, which is used for analytical analysis. The Data is loaded in a Star Schema in form of Dimension and cubes, which is further used for reporting purposes using COGNOS.
Objective/Tasks performed:
In this project , there are 6 sources (Oracle, Flat Files, SQL Server, Sybase, People soft, Access). I was using Informatica tool (PowerCenter) to grab the data from different sources and load it in a target Schema in a target database which was Oracle. To perform this Loading I was using various Transformations like Source Qualifier, Aggregator, Filter, Lookup, Joiner, Rank, __Expression, Stored Procedure etc. to cleanse and format the input data and loading into the target by creating Sessions for this Mappings.
I was involved in Creating Mapping and then later Sessions to execute the mappings. In the later half I was also involved in tuning the Session since I was receiving a huge amount of data (approx 10 millions rows per day).
Roles:
„h Understood Business Processes
„h Coordinated with Business-users to get specific requirements.
„h Translated Business processes into Informatica mappings.
„h Developed Complex mappings by extensively using Informatica
„h Transformations like Lookup, Filter, __Expression, Aggregator, Joiner, Stored Procedures etc.
„h Wrote data extracts to Excel files so that Business-users can analyze the data extracts in spreadsheets. These data extracts are also used for high-level Business users reporting purposes.
„h Created and scheduled Batches and Sessions using the Server Manager
„h Tested the data extracts to check if they conform to the business rules.
„h Documented the existing mappings
„h Used Oracle 8i as the target database, Source database is a combination of Flat files, Oracle tables, excels files, CSV files, SQL Server, People Soft, Sybase etc.
„h Identified bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.
„h Prepared Test Plans and later scripts to load the data in the target.
„h Optimized/Tuned mappings for better performance and efficiency
Company - Hughes Softwares India Ltd Gurgoan
Period :- Jan 2002 ¡V July 2002
Client :- AXA Insurance
Position :- Informatica Developer, New York
Environment :- Informatica PowerMart 6.1, Oracle 8i, SQL*Plus, Sun Solaris 2.6, Shell
Scripting, COGNOS (Impromptu and Powerplay).
Application :- Insurance Cash Flow ¡V Policy Percent Project
The ¡¥Policy Percent¡¦ portion of the Insurance Cash Flow (ICF) project refers to the retooling of the maintenance processes for AXA¡¦s Data Warehouse Policy Agent data. The revised process is to produce the functional equivalent of all data currently maintained in the ¡¥cross product¡¦ policy agent table in the IDB (Insurance Database). However, the current phase of the project only covers implementing what is needed to support ICF processing.
Objective/Tasks performed:
The objective of the Policy Percent project is to support accurate ¡¥agent bursting¡¦ for ICF and enterprise level financial applications through the application of necessary changes and improvements to the IDB Policy Agent maintenance processing and data. This should be done consistent with the overall Data Warehouse requirements for Policy Agent data, so as to support, in the future, a single source for Data Warehouse (enterprise) Policy Agent data, and to support future Enterprise level projects.
Roles :-
„h Design and Developed mapping using Source Qualifiers, Aggregator, __Expression, Filters, Stored Procedures and functions, Update Strategies, Rank, Sequence etc.
„h Created Sessions and Batches. Setting then for weekly or monthly execution.
„h Involved in Performance tuning. Done by increasing or decreasing Buffer block size, Index cache size or Data cache size and also checking other constraints.
„h Also involved in migrating the mapping to Production Support. from Test Repository after testing all transformations
AXA¡¦s enterprise Policy Agent data has many sources. There are daily and monthly feeds. There are feeds that replace the entire policy¡¦s policy agent data, and feeds that apply to only one record per policy. They come in many formats. And there is a possibility that new feeds can be added in the future. The objective of this project is to format the input data (which comes from many sources) with data values more meaningful to the Data Warehouse. The data in these feeds that are needed for policy agent maintenance in these different feeds consist of a limited number of fields. All standard transaction record, including all possibly required fields pertaining to a single policy/agent/role combination, has been designed as a standard interface to Policy Agent maintenance core module.
The several (five) formats are mapped to the standard format. Extensive data transformations and filters are used to get the Standard Transaction Record to feed the Data Warehouse.
Personal Details: Date of Birth --- 19th Feb 1970
Passport No : A- 5193258
CTC per annum : 8 Lakhs Per Annum
Present Company - Promino Infosystems Pvt ltd Bangalore - 82
Yours faithfully
__________________
(Rajesh Paliwal)
Datawarewarehouse developer
|
|
|
|
Re: Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bangalore ( India) [message #106603 is a reply to message #106574] |
Tue, 02 March 2004 19:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
jagadeesh.k.n
Messages: 3 Registered: March 2004
|
Junior Member |
|
|
JAGADEESH.K.N
#49,1st MAIN
H.S.B.C Layout, Sreegandadakaval
Nagarabhavi II stage, Bangalore 560091, India
Contact Numbers: 9844005662
: 91-080-56954668
Email: jaga_nagaraj@yahoo.co.in
Career Objective
To excel in the field of Data Warehousing Development, Design and Working with
Data Warehouse Tools like ETL (Informatica), OLAP Tools (Cognos, Business Objects).
To contribute in this field of purist by keeping in touch with the latest technological
Developments in the field and productively Contribute towards growth of the Organization.
Academic Profile
Bachelor of Engineering in Computer Science, With Frist Class 61.5 % from
Malnad College of Engineering, Hassan.University of Mysore - 2000.
Work Summary
Total 3+ years of overall experience in Information Technology, which includes
15 months with hands-on experience in Data Warehousing development by working on ETL tool (Informatica) and OLAP tools (Cognos, Business Objects).
And 1 year 11 months of experience in Oracle 8i Data Base Administration / Solaris 8 System Administration.
Professional Summary
Organization Designation Duration
Dominus Software, Bangalore, Software Engineer OCT-2002 to till date
Xtelligence Systems ,Bangalore DBA/System Admin OCT-2000 to SEP-2002
Skill Set
Operating System Solaris 8, Windows-95/98/NT & MS-DOS
Languages Cobol, Java, T-SQL, PL/SQL, C, C++
Web Technology HTML, DHTML, FrontPage 2000
Data Base Oracle 8i /9i ,MS-Access, MS-SQL Server 7.0
GUI Microsoft Visual Basic 6.0
OLAP Tools Business Objects 5.1, Cognos
ETL Tools Informatica 5.1 (Power Center)
Domain Expertise
Order Process Management & Insurance.
Project Details
Organization: Dominus Software
Title BWom
Client Aunger Carcraft
Platform Informatica 5.1, Business Objects 5.1, Oracle 8i, Solaris
Role Team Member
Team Size 12
Duration Mar-03 to Till Date
This provides Enterprise wide DWH solutions to User on Order & Invoice Processing to Aunger Carcraft with 1 million to 25 million USD which deals in export of
Head light guards, weather shields, bonnet protectors, petrol caps etc,
Data from Operational Sources are Extracted, Related, Transformed and Loaded into the Oracle Data Warehouse using ETL tool (Informatica Power Center 5.1). Business data from source system were fed into Dimension and Fact using Relational Sources. Business Objects 5.1 (OLAP Tool) provides Decision Support to Business Community based on the Reports Developed by End-Users such as actual billings by store for the week/month/quarter/year using Aggregate tables.
Roles:
„« Developed Mappings in Informatica Power Center 5.1.1 for extracting the data from Operational Data Source, Transform the data using Filter, Expressions and Stored Procedures then load to Oracle data Warehouse.
„« Plan and Analyze the Data, Loading the data into the Database and Testing the Data.
„« Developed Connected LKP transformation to Look-Up target Dimension by using particular column.
„« Developed UPD Strategy transformation for loading data into target Dimension which match LKP Condition.
„« Documentation as per quality standards for various phases of the project.
„« Maintenance of the existing mapping/session, code and data.
„« Involved in documentation and support to End-Users.
„« Involved in maintenance and production support for the entire system.
Organization: Dominus Software
Title Insurance Agency System ( eIWIAS )
Client Thakafull Insurance, Malaysia
Platform Informatica 5.1, Business Objects 5.1, Oracle 8i,Solaris
Role Team Member
Team Size 12
Duration OCT-2002 To FEB-2003
Project Summary:
Developed Insurance Agency System (IAS), this system contains details of Agents functioning under the Organization.
The primary objective of this project is to provide enterprise wide data warehousing solutions for top-level executives and to a large extent for operational users also. Data from various online transaction processing (OLTP) applications and sources is selectively extracted, related, transformed and loaded into the Oracle data warehouse using Informatica Power Mart ETL tool. Then the transformed data from data warehouse is loaded into Data Marts to provide Business Intelligence. The end users can create reports using Business objects over intranet/internet with the help of Web Intelligence
Roles
„« Created and maintained Oracle Database warehouse and mapping those business entities to Data Mart.
„« Implemented dimensional models for the Clients Which are having many dimension tables for each star schema
„« Involved in Database programming such as writing SQL Queries and
Procedures.
„« Created set of reusable transformations.
„« Created data mappings to extract data from different source files, transform the data using filters, expressions and stored procedures then load to Oracle data warehouse
„« Validating the Mappings, Generating & Loading the Data
Organization: Xtelligence Systems
Client Indian Oil Corporation, B¡¦lore
Platform Oracle 8i, Solaris 8
Role Oracle DBA / Solaris System Admin
Team Size 10
Duration Sep-2001 to Sep-2002
Project Summary:
Database maintenance of Indian Oil Corporation¡¦s. Distribution Management. This Database contains Daily Transaction¡¦s of Dealers, Oil distributed and Sales. Primary objective of this Project is Maintenance and Monitoring database, taking backups, Recovering, Restoring Data and Achieving Maximum performance.
Roles
Database Administrator /Solaris System Admin
„« Installation of Oracle software, setting up initialization and configuration,
„« Planning, Designing and creating database layouts, Monitoring user connections
„« Creation and sizing of table spaces and setting table spaces
„« Adding control files and online redo log files, Providing help to end-users
„« Monitoring database server, taking Backup & Recovery.
„« Solaris Installation, Evaluating & Cataloging Hardware Requirements
„« Determining File System Structure & Disk partitions,
„« Patch and Package Administration.
„« Refining System Boot & Shutdown Procedures
„« Monitoring Group, User¡¦s Connections, Taking backups.
Organization:Xtelligence Systems
Client P.L.D Bank Hassan
Platform Oracle 8i, Solaris 8
Role Oracle DBA / Solaris System Admin
Team Size 10
Duration Oct-2000 to Oct-2001
Project Summary:
Database Maintenance of P,L,D Bank Hassan .This Database contains Daily Transaction¡¦s of Bank Customer¡¦s, Primary objective of this Project is Maintenance and Monitoring database, handling backups, Recovering, Restoring Data and Achieving Maximum performance.
Roles:
Database Administrator /Solaris System Admin
„« Installation of Oracle software, Setting up initialization and configuration,
„« Planning, Designing and creating database layouts, Monitoring user connections
„« Creation and sizing of table spaces and setting table spaces
„« Adding control files and online redo log files, Providing help to end-users
„« Monitoring database server, handling backup & Recovering.
„« Solaris Installation, Evaluating & Cataloging Hardware Requirements
„« Determining File System Structure & Disk partitions,
„« Patch and Package Administration.
„« Refining System Boot & Shutdown Procedures
„« Monitoring Group, User¡¦s Connections, Taking backups.
With Regards
jagadeesh.k.n
|
|
|
|
|
|
Re: Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bangalore ( India) [message #106751 is a reply to message #106574] |
Fri, 09 April 2004 00:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Pranav Bhatt
Messages: 1 Registered: April 2004
|
Junior Member |
|
|
PRANAV BHATT
PH (M) +919825511818.
Email: - pranav7417@hotmail.com
pranavabhatt@hotmail.com
OBJECTIVES
To seek a challenging position in an IT environment, where I can utilize my extensive skills & education, with further career growth opportunity.
QUALIFICATIONS
•Oracle Certified Associate Professional – Oracle 9i (Dec 2003)
•Exposure in creating database design for business applications need.
•Ability to work with minimal direction and future vision in a rapidly developing environment.
•Flexible attitude and curiosity to learn newer and advanced technologies.
•Good communication, analytical, computational and teaming skills.
•Exposure to object oriented Client/Server and Web based technologies and solutions.
•Possess good knowledge of Java & with understanding of AWT, SWING for developing component interface.
•French language ability W/R/S.
SKILL SET
ETL tool Informatica 5.0/6.1v.
Good Command over RDBMS like Oracle-9i, MS-Access.
Exposure to Reporting tools Cognos 6.0, Business Objects.
Systems MS-DOS, Windows 9x/NT/2k, UNIX (HP, Sun Solaris).
Languages C, C++, SQL, JAVA, Java scripts, COBOL, Servlets, JSP, HTML,VB6.
Exposure to web tools Macromedia Dream weaver 4, Flash 5, Fireworks.
Software exposure Visual Basic 6.0, Forte for Java, MS-office, lotus smart-suite.
Web Application Server Exposure: Tomcat 4.1.
PROFESSIONAL EXPERIENCE
Internet Arcade,Pvt. Ltd. Baroda: (August 2003 – Current)
(1)
Project: Intelnet Wireless Sales Analysis. Client: Intelnet Wireless Newark, Ohaio.
Team Size:4
Software: Power Center Client 6.2.1.
Enterprise Data warehouse is Sales project based for Intelnet Wireless, one of the leading firm in U.S. nationwide for different Telecom Services. This maintains the operational data and the Historical data, which is used for analytical analysis, various sales data from flat files were transformed with business rules to Warehouse. The Warehouse data is extracted into different regional data marts according to geographical, Time dimension for various strategic businesses Metrics. My responsibility was to prepare Star schema, Loaded Operational data from Oracle, Flat files and the data cleansing was done according to business rules. Transformations for the ETL process using Informatica Power Center Client 6.2.1
Role: ETL Developer (Informatica)
• Prepared drafted schema based on Data Warehouse business & system specifications involved in designing Star schema.
• Used Oracle 8i as the target database, Source database is a combination of Flat files, Oracle tables.
• Development of Source-target mapping Meta data, Transformations for the ETL process using Informatica Power Center 6.1
• Implemented Join, Expression, Aggregate, Sort, Lookup, Update Strategy, Filter and Router Transformations as per Business Requirements.
• Implemented Lookup Transformation to check source data with Warehouse data and if not present then created Update strategy Transformation to update new data from source to target for further analysis.
(2) March 2003 – August 2003
Project Title: CCSM (Customer Care Service-Management).
Client: - Mickros systems Pvt. Ltd.
Duration: - 6 Months.
Team Size: - 3
Project Description: -
CCSM is a web application dealing with after sales queries of clients of the company. Through CCSM the company interacts with the clients and helps the management for strategic business decisions. CCSM was developed using technologies: HTML, JSP, Servlets, and JavaScript, Apache Tomcat, Oracle9i.
Role: Software Developer-Java, Design and development.
• Interacting with Client to gather requirements (Additional to the Functional requirement). Documenting these requirements and presenting them to the team.
• Data Modeling using ERWin.
• Co-ordinate the efforts of the team.
• Preparing DESIGN DOCUMENTS for Interface, Database structure, System flow.
• Coding, Testing, presentation.
Responsibility:
• The implementation involved developing the application along with learning some newer technologies with limited time period in which we had to complete this job.
(3)Ideal Systems Pvt. Ltd., Ahemdabad January 2003-March 2003
Project Title: - Stock monitoring module.
Client: - L.A. Pharmaceuticals, Ahemdabad.
Duration: 4 Months.
Team Size: 2.
Project Description:
The stock monitoring module helped the client to monitor the inventory level right from raw stock to finished goods and maintain the inventory. It also assisted in acknowledging the vendors, inter-company transactions and calculation of excise amount on basis of the finished goods. This module was developed using Visual Basic 6, Oracle8i, Window NT.
Role: Developer Trainee: Visual Basic.
•Database design
•Working for Conceptual design thru coding, into final product.
•Coding, Testing, Presentation.
Responsibilities:
I was responsible for the complete Software Development Life Cycle right from requiring gathering, designing, Coding, Testing & implementation. I had to prove myself at par with all these activities.
EDUCATION
MCA (2000-03)
From IBMR, Pune University with First class (69.97%)
B.Com (1997-00)
From M.S. University with First Class (60%)
CERTIFICATIONS
ORACLE SQL 9i .
ORACLE Fundamental -I 9i .
|
|
|
|
|
Re: Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bangalore ( India) [message #106900 is a reply to message #106396] |
Sat, 12 June 2004 02:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shameer
Messages: 5 Registered: October 2003
|
Junior Member |
|
|
O.K. SHAMEER
Email: okshameer@rediffmail.com NO-64, 1st Floor, Room No 3
shameerok@hotmail.com Mahadeswera Layout
Phone# 9845593766 16th Main 17th Cross
BTM 2nd Stage-Bagaloore-76
OBJECTIVE:
To obtain a demanding and challenging opportunity that will allow me to leverage my technical skill set in conjunction with my proven leadership record to deliver successful Implementations of technology.
Professional Summary:
· Overall 1.5 years of IT experience in Data warehousing, having complete development Life Cycle knowledge of Data Warehousing-ETL Process; worked extensively on ETL
Tools like Informatica Power Center 5.x
· Extensive experience in PL/SQL, stored procedures, functions & packages in Oracle (9i).
· Good in back-end database Oracle 9i.
· Worked effectively independently and Part of a team.
· Logical, Analytical and Good Interpersonal skills, Commitment to perform quality
· Work and an Excellent Team Player.
· Hands on experience with Data Extraction Transformation and Data Loading, Data Migration, Data Conversions in Data Warehouse environment.
· PL/SQL, Oracle 9i, SQL Server under Windows NT/Unix
· Developed various Informatica Mappings, Mapplets and Transformations for migration of data from various existing systems to the new system using informatica Designer.
Supported or used in past projects:
Operating Systems : Windows 2000 Server, UNIX.
Client Tools : Informatica Repository Manager 5.x, Designer 5.x, Server
Manager, Informatica Server.
: Cognos Tools, Power Play 6.5/Transformer 6.5, Impromptu 5.0,
Power Play Enterprise Server.
: Business Objects 5.1
Database : Oracle 9i
Career Profile:
Software Engineer at
Atlanta IT Solutions Pvt. Ltd., Kerala
Yamazaki sales and marketing Data Warehouse.
1. Project name: Yamazaki sales and marketing Data Warehouse.
Client Yamazaki CO, Malaysia
Position/Role ETL developer.
Duration May 03-2003 To Jan 15-2004
Environment Oracle 9i, Informatica 5.1, Windows 2000 Server.
Organization Atlanta IT Solutions Pvt. Ltd., Kerala
Project Description: Yamazaki CO many departments cover groceries, household goods, bread, cakes, milk, beverages etc. Yamazaki Co have a fine selection of cheeses on our delicatessen counter, pre-packed for convenience or cut to your specifications. Yamazaki Co are also licensed to sell beers, wines and spirits and have a good range in each. Yamazaki Co can also offer a wide range of pet supplies, fuels (such as coal and gas), hosiery, wool, crafts, together.
The client wants to have some system which can give him intelligent information regarding his existing business situation and how he can analyze specifically his business. According to the client requirements, the Data warehouse System has been developed. It is meant for use by the designers and developers and will be the basis for validating the final delivered system.
Role: Informatica Developer.
Responsibilities:
· Creation of the various transformations are implemented through Informatica Designer.
· Configuring Sessions in Server Manager
· Scheduling of sessions.
· Configuring Informatica Server for loading of data.
FINANCIAL SERVICES FOR Malaysia
2. Project name: Financial Services Data Warehouse
Client OCBC Bank, Malaysia.
Position/Role ETL developer.
Duration Jan 16-2004 till date
Environment Oracle 9i, Informatica 5.1, Windows 2000 Server.
Organization Atlanta IT Solutions Pvt. Ltd., Kerala
Project Description: OCBC Bank (Malaysia) Berhad (OCBC Malaysia) is a wholly owned subsidiary of OCBC Bank Limited, one of the four largest Singapore-based financial organizations involved in retail and corporate banking, and other financial services. OCBC Malaysia has a network of 25 branches located in various locations throughout Malaysia and is among the leading foreign banks operating in Malaysia.
Banking for households is to be maintained. The OCBC Malaysia has the customers who may have accounts; loan etc.. All the financial services being provided by the bank are called products. Each products or Services will have individual axioms and constraints, which are to be maintained.
Role: Informatica Developer.
Responsibilities:
· Creation of the various transformations are implemented through Informatica Designer.
· Configuring Sessions in Server Manager
· Scheduling of sessions.
· Configuring Informatica Server for loading of data.
Academic Exposure:
Programming Languages : C++, Visual Basic 6.0, Java, PL/SQL
Operating systems : Windows 2000 server, UNIX
RDBMS : Oracle 9i, MS SQL.
Data Warehousing Tools : Informatica5x/6x, Cognos 6,
Business Objects.
Designing Tool : Erwin.3.5
Training & Certification:
Successfully completed Modern Reprographic Equipment(MRE) course of Kerala state Audio Visual and Reprographic Center, Ministry of Information Technology.
Qualification:
Master of Computer Application (MCA), from Bharathidasan University, Thiruchirapalli, Tamil Nadu.
Extra Curricular Activities:
Social : Member of National Service Scheme (NSS)
Sports : Bat Minton, Foot Ball.
Hobbies: Internet Browsing, Reading
Personal details:
Father's Name : Assain Kutty O.K.
Date of Birth : 08/02/1978
Passport No# : A1115067
Blood Group : B+
Marital Status : Single
Declaration:
I do hereby declare that the above furnished information is true to the best of my knowledge and belief.
Place : Bagalore
Date : O.K Shameer
|
|
|
|
Re: Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bang [message #107591 is a reply to message #106900] |
Fri, 05 November 2004 17:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mahesh potnuru
Messages: 1 Registered: November 2004
|
Junior Member |
|
|
Mahesh PotnuruMobile: 09849777023Home: 0891-2535674saimahesh_dwh1 @yahoo.comsai_mahi@yahoo.comSummary „ Above Two Years of Valuable Experience in Data Warehousing/ETL Programming, RDBMS and Client Server Application „ Experience in using various Informatica Transformations like Source Qualifier, Expression Filter, Rank, Router, and Aggregator.„ Extracting Data from various Resources like Oracle, SQL Server, DB2, and MSAccess„ A good exposure to OLAP tools (Business Objects 5.1/4.1 - supervisor, designer) and COGNOSSkill Set ETL Tools Informatica PowerCenter5.0/6.x OLAP Business Objects 5.1/6.0(Designer, Reporter, Supervisor) Data Modeling Erwin 3.5.2/4.0 RDBMS Oracle 7.x, IBM DB2, MS Access 7.0 Operating Systems Windows XP/ NT/2000,UNIX, DOS Languages PL-SQL. Java (Core) Front End Tools Visual Basic 6.0 Reporting Tools Crystal Reports Professional Experience:Ashok Leyland Ltd, Chennai. (DSRC International Pvt Ltd ) Sep’ 03 – Aug‘04Data Warehouse Developer About The Company:Ashok Leyland Ltd. is the second largest truck manufacturer in India having plants in five locations in India and having around 10,000 employees., which caters to the 3 divisions (Heavy Vehicles, Engines and Cargos) of the Ashok Leyland.Design, Development and Implementation of a Sales and Profitability Analysis SystemThis assignment is for the project in Ashok Leyland Ltd for creating the corporate Data Warehouse from the operational OLTP system and staging area using extraction capabilities of Informatica Power Mart. Operational sources exist in OLTP environment comprising of Oracle 8. This project is a Pilot Project towards creating the Corporate Data Warehouse in Oracle 8 for Ashok Leyland Ltd using the existing operational data for better decision-making and analysis. Extraction and Transformation tool, which has been used in project, is Informatica and the proposed front end OLAP tool would be Business Objects.Responsibilities: As a Data Warehouse developer the following were my contributions.· Interacted with the Business users to identify the process metrics and various keys dimensions and measures · Study on the existing systems used for operational data management in Oracle 8· Developed and documented data Mappings/Transformations, and Informatica sessions as per the business requirement. · Extensively used Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Server Manager.· Used most of the Transformations such as the Source qualifier, Aggregators, lookups, Filters & Sequence, Joiner, Expression as per the Business requirement· Identifying suitable Dimensions and Facts for Sales Schema· Creating the Source Definitions, Target Definition and Mapping in Informatica Designer.· Designed the mappings between sources (external files and databases) to operational staging targets· Creating reusable transformations and mappings · Creating and running sessions & Batches using Server Manager to load the data into the targetDatabase. — Organized sessions in a batch to run the sessions in a batch in sequential order or start them concurrently by the server.· Generated various reports as per the client's requirements. · Created the reports using Business Objects functionalities like Queries, Slice and Dice, Drill down,@Functions, Cross Tab, Master/Detail and Formulas etc. Environment: Oracle 8.1.6, Informatica Power Mart 6.0, MS Excel, Windows NT4.0,Millennium Software Solutions Aug’02-Jun’03Oracle DeveloperCargo Handling Processing Systems for Visakhapatnam Port trust that manages Import and Export Process, Cargo warehousing, Vessel and Agent Maintenance, Bill of lading etc. Responsibilities:· Designing User interface design of the system.· Analyzing and gathering the requirement specification.· Design and development of the application.· Used Stored Procedures, triggers and other functionalities. Environment: Visual Basic 6.0, Oracle 7.x, Crystal Reports 8.Previous EmploymentWorked as a Faculty & Lab Coordinator in DEBUG INFORMATICS., Visakhapatnam From Jan 2001-Jul 2002.Education Academic Qualification: Msc, Computer Science, 1999 - 2001 April, BharathiDasan University, Trichy. Bsc., Computer Science, 1996-1999, Andhra University, VishakapatnamTechnical Qualification: Diploma in Software Applications (Multimedia Communication Centre, MCC)Personal Details Name : POTNURU MAHESHFather’s Name : P.Krishna RaoDate of Birth : 24th April, 1979Nationality : IndianSex : MaleMarital Status : BachelorLanguages Known : English, Telugu, and Hindi & TamilPassport No : B 5525176Contact Address : MIG Plot No 202 NE Layout Seethammdhara Vishkapatnam-530013 Mahesh Potnuru
|
|
|
Re: Ppl required for Datawarehousing, Cognos, Informatica, Teradata , ETL - bang [message #107804 is a reply to message #106396] |
Wed, 01 December 2004 02:20 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Ramesh Babu.Maddasani
Messages: 1 Registered: December 2004
|
Junior Member |
|
|
Career Objective
Seeking a challenging position as a Data Warehouse Analyst, in progressive IT organization with an opportunity to contribute my skills and experience and be an active member of a team involved in opening new avenues of challenge.
Professional Education
· B.Tech in Computer Science and Information Technology from JNTU
Hyderabad.
Experience Summary
· Having 2+ years of experience in IT Industry
· More than 1.5 years of experience in analyzing, developing and testing the data warehousing projects on Informatica 5.0/6.1 Power Mart and Power Center and having about 6 months of experience in building Power Cubes and creating reports using Cognos 7.0.
· Good knowledge in ETL(Extraction, Transformation and Loading) process of Informatica 5.0/6.1
· Expertise in data scrubbing/cleaning according to the business logic using various transformations like Look up ,Aggregator, Router, Expression, Update and etc., and in developing Reusable transformations, Mapplets using Informatica designer.
· Extensively worked with the Designer tool of Informatica for building multidimensional Cubes.
· Extensively working with the tool of Cognos 7.0 for building Power Cubes and creating reports.
· Good communication, Interpersonal, Analytical skills and Result-oriented.
Experience
· Working as a Software Consultant for Iris Consulting, Bangalore since July 2002
Technical Expertise
Primary Skills
ETL Tools : Informatica PowerMart 5.0/6.1,
Informatica PowerCenter 5.0/6.1.
OLAP Tools : Cognos 7.0
RDBMS : Oracle 7.3/8.0/8I .
Methodologies : Star schema, Snowflake Schema.
Secondary Skills
Languages : SQL, PL/SQL, C, and C++
Operating Systems : Windows NT4.0/5.0, Windows 2000/98/95
WORK HISTORY
April 2004 – till date : Data Mart for Sales Module for Steven Walker & Sons ,UK
September 2003 – March 2004 :SMS for Danfoss , UK
January 2003 – August 2003 : Retail Business Intelligence System for DigiPackers , USA
July 2002 – November 2002 : Personal Management System for KEIL , New Delhi.
PROJECT PROFILE
Project #1
Project Name : Data Mart for Sales Module
Client : Steven Walker & Sons, UK
Duration : April 2004 – till date
Role : Team Member
Team Size : 6
Description : Steven Walker & Sons is one of the leading manufacturing
Company in specializing in manufacturing Bolts like U-Bolts
and Eye Bolts etc., and in roll threading and bending of fixing
and fasteners. SWS is in Business now for over 40 years
have built a reputation for standard and non-standard
products in both mild and stainless steel. We are developing
the Data Mart for Sales module for this client using ETL tool
Informatica 6.1 Power Center according to the business
requirements and creating power cube using Cognos 7.0 that
makes users to generate reports that meets their business
logic
Responsibilities : 1. Participating in analysis, development, and testing
2. Participating in preparing low-level and high-level
documents
3. Working in extracting and cleaning the data using various
transformations like Aggregator, Expression and etc,.
4. Creating reusable components like mapplets and
transformations
5. Creating power cube and reports using Cognos 7.0
Environment : Informatica 6.1, Cognos 7.0 , Oracle 8i , Windows NT 5.0
Project #2
Project Name : SMS for Danfoss
Client : Danfoss , UK
Duration : September 2003 – March 2004
Role : Team Member
Team Size : 8
Description : Danfoss is one of the largest industrial company in Denmark.
The global group is a leader within research, development,
production , sales and services of mechanical and
electronic components for several industries. It is established
in 1933 and it is a largest company in manufacturing the
components such as Refrigerators, Water valves and etc.
We developed the data mart for the sales module for this
client using Informatica 5.0 Power Center that aided the
users in generating their most coveted reports and helps
the decision makers to analyze their business.
Responsibilities : 1. Participated in analysis, development, and testing
2. Participated in preparing low-level and high-level
documents
3. Worked in extracting and cleaning the data using various
transformations like Aggregators, Expressions , lookups ,
Filters and etc,.
4. Created reusable components like mapplets and
transformations
Environment : Informatica 5.0 Power Center, Oracle 8i , Windows NT 5.0
Project #3
Project Name : Retail Business Intelligence System
Client : DigiPackers, IL, USA
Duration : January 2003 – August 2003
Role : Team Member
Team Size : 6
Description : DigiPackers is one of the oldest American retail businesses
chains , which deals with FMCG products.This Project is
for retail business covering the consumer products
especially FMCG products.The Data Mart is designed for
The purpose of sales analysis that basically helps the
decision makers to analyze the sales patters .
Responsibilities : 1. Participated in analysis, development, and testing
2. Participated in preparing low-level and high-level
documents
3. Worked in extracting and cleaning the data using various
transformations like Aggregators, Expressions, lookups,
Filters and etc,.
4. Created reusable components like mapplets and
transformations
Environment : Informatica 5.0, Oracle 8i , Windows NT 4.0
Project #4
Project Name : Personal Management System
Client : Kashish Exports International Ltd, New Delhi
Duration : July 2002 – November 2002
Role : Team Member
Team Size : 4
Description : Designed the system to manage all administrative & payroll
needs of this organization having 1650 employees. The
system calculates employee pay & maintains corresponding
records, with pay-slips generated monthly. Main reports
include pay-slip, pay register, deduction statement, and
yearly earnings/deductions for a particular employee.
Responsibilities : 1. Involved in analyzing the system requirements.
2. Developed functions, procedures and to validate data and
ensure system integrity.
3.Wrote Triggers to maintain the System integrity.
Environment : SQL,PL/SQL , Oracle 7.0 , Windows 98/2000
Personal Details
Name : M. Ramesh Babu
Father’s Name : M. Lakshmanna
Date – of – Birth : 1st July 1978
Gender : Male
Marital Status : Single
Permanent Address : M. Ramesh Babu
S/o M . Lakshamanna
H.No. 45/24/K – 26 – 2
Ashok Nagar
Kurnool – 518005
Andhra Pradesh.
Email-ID : rameshm4u@indiatimes.com
Jairamramesh1229@yahoo.co.in.
|
|
|
Goto Forum:
Current Time: Mon Sep 09 10:24:36 CDT 2024
|