Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Dil S. | Elance
 
176985602337900
Last Sign-in: Jul 1, 2014

Dil S.

ETL Analyst,Data Analyst,Data Processing
   Australia
  |   melbourne, victoria

Overview

Minimum Hourly Rate $22

7+ years of experience as BI/ETL Analyst, data analysis,database,Excel Spreadsheet,Data processing.

Statistical Analysis using MS Excel

I complete all my task with hard-work and diligence

Thanks,
dilsey

Read More »

Skills (10)

Tested
Data Warehousing Test
My Score
avg
Sql server 2008
Microstrategy

Service Description

•Well versed in Datawarehouse architecture,dimensional modelling ,slowly changing dimensions,snowflake/star schema
•Well versed with DWH tools Wherescape RED(ELT), Informatica 8.6 (ETL), Abinitio (ETL tool)
•Source data analysis using complex queries and using predictive analysis on excel sheet
•Statistical Analysis R square ,Trend , Median , standard deviation ,Moving Average using Excel Sheet
•ETL (Extract, transform and Load) Architecture designing and configuring
•Data profiling and analysis of the source data, metadata and reference data using Oracle PL/Sql , UDQ
•Data assessment, Data cleansing , test extract and Load, final extract and load , validation of data
•Writing shell scripts in Unix and Automating the Jobs
Data warehousing Skills:::
Datawarehousing Architechture, ETL ,Wherescape Red, Informatica 8.6.1 (Source Analyzer, DataWarehousing Designer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Worklets),Informatica PowerAnalyzer ,Metadata, Data Mining, Datamart, OLAP, OLTP, SQL* Plus, SQL*Loader, Abinitio
Dimensional Modeling:::::
Dimensional Data Modeling, Data Modeling, Star Schema Modeling,Snow-Flake schema, FACT and Dimensions Tables, Physical and Logical Data Modeling
BI Skills:::::::
Reporting tool(Business Objects 6.5),Microstrategy
Languages SQL/PL-SQL, Unix shell script, T-Sql, HTML


Read More »
Overview  |  Job History  |  Resume/C.V.

Keywords

BI/ETL Analyst
Dimensional Modelling
Informatica
Abinitio
Wherescape RED expertise.Expert in Business Objects and Microstrategy. Can extend my BI/ETL knowledge to any other BI/ETL Tool. Proficient in Data Analysis and Data Profiling.
My Snapshot
All Categories
Elance Level
Level represents activity and experience on Elance. Freelancers start at Level 1 and achieve higher levels through their work. A higher "Level" indicates greater earnings, ratings and other achievements on Elance. Learn More »
  • 12 months
  • Lifetime
Jobs
0
0
0
Total
Milestones
Hours
Reviews
Recommend
Clients
Total
Repeat
Earnings
Total
Per Client
Identity
Username
dilsey
Type
Individual
Member Since
February 2011
Elance URL
Verifications
0
Dil S. | Elance

Dil S.