Manager Sales
Resume:
RAJU VENKATARAMAN
Naperville, IL 60565
Phone: 630-***-****
E-Mail:***********@*****.***
Professional Summary
> 4+ years of experience in DATA WAREHOUSING (INFORMATICA).
> Strong knowledge in Extraction, Transformation, Loading from various
sources into data warehouse using Informatica power center.
> Extensively worked on Informatica components - Designer, Workflow
Manager & Workflow Monitor.
> Experience in OLAP tool Cognos.
> Experience in preparing the test case based on the functional
specification and logging defects.
> Experience in troubleshooting and performance tuning.
> Proficiency in Oracle Sql & Pl/SQL queries.
> Professional strengths include good communication and interpersonal
skills. Excellent team player and dedicated team member.
> Result-oriented approach, Fast learner, Consistent performer.
Technical Skills
ETL Tool : Informatica 6.1/7.1 / 8.1
BI Tool : Cognos 8.0
Databases : Oracle 9i, MS SQL Server-2000/2005
Operating System : WINDOWS XP/NT
Professional And Project Experience
COMPANY : Compsearch Software Services Mar
2010 -May 2010
CLIENT : Omega Cube Technologies
Role : ETL Developer
____________________________________________________________________________
__
Overview:
> This project is for one of the largest retail store chains super
markets, having thousands of stores.
> The main motive of this project to capture the Sales and marketing
processes and data warehouse to maintain Client's history and Current
data.
> Data from Operational source system was Extracted, Transformed and
loaded into data warehouse using Informatica.
Environment:
Informatica Power Center 7.1, Oracle 9i, Flat Files, Windows XP
Roles & Responsibilities:
> Analyzed the data in the source systems.
> Involved in mapping with the source and warehouse components.
> Extensively used Informatica client tools-designer, workflow manager
and workflow monitor.
> Created various Transformations like Joiner, Aggregate, Expression,
Filter, Update Strategy, and Lookup.
> Designed the ETL process using Informatica tool to load data from
source to target.
> Developed mapping to load the data in slowly changing dimension.
Company : Satvat Infosol, Chennai
Nov 2008 - Dec 2009
Client : Flextronics, Singapore.
Role : ETL Developer
____________________________________________________________________________
__
Overview:
> The client is leading electronics manufacturing company
based at Singapore.
> The company is looking for business enhancements and
competitive Edge using information
technology to make better business decisions.
> According to client's requirement this data warehouse is
being developed.
> Using this data warehouse, analysis of the Sales and
Profits is done and the Reports are
generated month-wise and year-wise. Thus the Data
Warehouse helps in making strategic
decisions for improving the business.
Environment:
Informatica 8.1, Oracle9i, Cognos 8, Windows NT
Roles & Responsibilities:
> Developed Complex mappings by extensively using Informatica.
> Analyzed the sources, targets, transformed the data, mapped the data
and loaded
the data into targets Using Informatica.
> Used most of the Transformations such as Source Qualifier,
Aggregators, Lookups, Filters, Joiners, Sequence Generator, Update
Strategy and Expression.
> Created Mappings between Source and Target using Power Center
Designer.
> Checking the Mappings and responsible for Performance tuning and Error
handling of Informatica mappings.
> Created Session and Workflows.
> Created reusable transformations and mapplets to prevent the
redundancy of
transformation usage and maintainability.
> Involved in performance tuning to improve efficiency.
> Design and development of the reports using Report Studio/Query Studio
as per the requirements.
> Developed standard reports, charts, drill -through reports and master
detail reports
using Report Studio.
> Created Lists, Groups and Cross-tab reports with drag and drop
functionality.
> Created test cases for mappings.
Company : Preludesys, Chennai
Oct 2007 - Oct 2008
Client : Emicos, UAE
Role : ETL Developer
____________________________________________________________________________
__
Overview:
> Emicos is the leading manufacturer of perfume products in UAE and the
sales occurs through booking those products in online, direct sales.
> The system gives special emphasis on customers by extending them
various other services apart from order placement and amending orders
like special discounts to frequent customers, get quote from the
distributor towards bulk purchase.
> ETL tool Informatica is used for Extraction, Transformation and
Loading of Data. Using this existing database the system should
analyze the sales information of their products and to generate the
reports in monthly, quarterly and yearly wise.
Environment:
Informatica 7.1, Oracle9i, Cognos 8, Reportnet1.1, Windows NT
Roles & Responsibilities:
> Extensively involved in Data Extraction, Transformation and Loading
from Source to target systems using Informatica 7.1.
> Created data mappings to extract data from different source files,
transform the data using Filter, Lookup, Update Strategy, Aggregator,
Expression, Joiner Transformations and then load into the Data
Warehouse.
> Developed the mappings and tuning them for better performance.
> Created and Monitored Sessions using Informatica Workflow Manager and
Workflow Monitor.
> Implemented Slowly Changing Dimension-2 by using wizard.
> Created List reports, Cross-tab reports.
> Designed Drill-through reports and Dash board reports.
> Migrated Reports from Reportnet1.1 to Cognos 8.
> Created different type of charts like Column charts and Bar charts.
> Created reports with data formats.
> Involved in debugging of mappings.
> Done unit testing for Mappings.
Company : Synaptree, Chennai
July 2005 - Sep 2007
Client : ITC Limited, India
Role : ETL Developer
____________________________________________________________________________
__
Overview:
> ITC is the largest publicly listed food, beverage and
packaging company in India.
> The scope of this Project is to capture the Sales and
Marketing processes and
data warehouse to maintain client's history and current
data.
> Data from Operational Source System was extracted,
transformed and loaded into data
warehouse using Informatica.
> According to client's requirements this Data warehouse is
being developed. This
Data warehouse supports BO applications used to generate
Business reports.
Environment:
Informatica 6.1, Oracle 8i, Windows XP, Reportnet 1.1
Roles & Responsibilities:
> Responsible for extracting, transforming and loading the data from
various source systems to target systems.
> Performed data manipulation using various transformations like Source
Qualifier, Lookup, filter, Aggregator, Update Strategy.
> Worked on Informatica Mapping Designer and Workflow manager.
> Scheduled workflow on Workflow manager.
> Developed reports in ReportNet 1.1
> Created List Reports and Crosstab Reports.
> Created different type of charts.
> Involved in Performance Tuning.
Professional Training
> Diploma Certification course in Oracle From SqlStar,Chennai
> Diploma Certification course in .net from NIIT,Chennai
> Diploma Certification course in Software Testing from
Softsmith,Chennai
> Diploma Certification Course in Computer Hardware and Networking from
CIIT InfoTech,Chennai
Educational Qualification
> M.C.A (Master Of Computer Application) from Thangavelu College Of
Science and Management (Madras University)
> B.S.C (Bachelor Of Computer Science) from Mohamed Sathak College Of
Arts And Science (Madras University)
Contact this candidate