Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Nour Alam | Elance
 
176985602337900
Last Sign-in: Jan 14, 2013

Nour Alam

DW (ETL, BI), Data Modeling,Data-mart, SQL, PL/SQL
   Bangladesh
  |   Dhaka, Dhaka
  |  10:05 am Local Time

Overview

Minimum Hourly Rate $8

* Expert on Informatica 9.1
*Business Report creating through Teradata, SAP BO.
* Linux/Unix Shell Scripting
* Enterprise - Oracle Applications, Oracle Forms, Oracle PL/SQL, Business Analytics
* Databases - Teradata, Oracle 11g/10g, 9i/8i, SQL Server 2008/2005/2003.
* Sector Expertise - Project & Programme Management, Business Analysts (Telecoms, Financial Services & Banking, Utilties, Pharmaceutical, Retail, Hospital)
* Business Intelligence & Systemology - SAP BO XI R3, Oracle Business Intelligence (OBIEE), Microstrategy, Pentaho.
* ETL -...

Read More »
Jan 5, 2013|Other IT & Programming|$0|Working

View All »

Skills (10)

Tested
SQL Programming
Data Warehousing
Data Warehousing with Oracle Exadata & Teradata
Data Architect
Data Modeling
Logical & Physical Data Modeling
Oracle PL/SQL
Oracle Warehouse Builder (OWB- With Mapping Skill)
SAP BO XI R3
Oracle BIEE

Service Description

Technical Consultant
Banglalink Data Warehouse -Teradata Project
September 2011 – Present (1 year 4 months)GULSHAN-1, TIGER BUILDING

* Data Modeling to build LDM and PDM
* Developed standard SQL, PL/SQL code for ELT purpose.
* Query optimization technique
* Developed Data summarization & aggregation concepts and scripts
* Developed shell scripts (Korn shell) for ELT and BI purpose
* Design and Develop ELT process using Informatica9.1
* Developed ELT process for various Operational Data Source (TABS, IVR, LMS, CMS, POS, SALESCOM and forth) of Banglalinks’ Telecom (Orascom) and BI reporting with BI Chain Development.
* Design and created ELT standards and procedures
* Assisted in architecture design of new data warehouse and ETL/ELT process
* Assisted in setting up ETL/ELT standards and process
* Documents all ELT code for the business
* Documents all ELT code with proper changes
* Designed and installed test scripts for ELT code
* Created Informatica9.1 ETL/ELT code from functional and technical specs
* Creating and Converting Oracle Procedures, Functions into Teradata stored Procedure (SP) and Syntax.
* Design and created FTP scripts for moving source and target files
* Tuned SQL statements for end users creating custom reports
* Data Migration From Oracle to Teradata.
*** Mappings the following Subject Areas:
a) CALL USAGE,
B) ROAMING
C) RECHARGE
D) CUSTOMER PRODUCTION
E) TABS
F) INTERACTION (CALL CENTER)
G) IMEI
H) LMS (Loyalty Management System) & CMS (Campaign...

Read More »

Keywords

ETL
BI
SAP BO
Informatica
OBIEE
OWB
ODI
Oracle
Teradata
SQL
Company Snapshot
IT & Programming
1
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
dwh_a1
Type
Company
Member Since
December 2012
Elance URL
Verifications
0
Nour Alam | Elance

Nour Alam