Hình đại diện của alambd
@alambd
Thành viên từ April, 2007
0 Đề xuất

alambd

Trực tuyến Ngoại tuyến
Oracle9i/10g/11g, PL/SQL, Teradata13, Informatica8.5/8.6/9.1, SAP BO, OWB, ODI, OBIEE, Linux, Shell script
$7 USD/giờ
2 đánh giá
3.1
  • 33%Các công việc hoàn thành
  • 100%Đúng ngân sách
  • 100%Đúng giờ
  • N/ATỉ lệ thuê lại

Portfolio

Các đánh giá gần đây

Chưa có đánh giá nào.

Kinh nghiệm

Technical Consultant

Jan 2011 - Aug 2013 (2 years)

Banglalink(Orascom) EDW Teradata Telcom Project Technology:Teradata,Informatica9.1,SAP BO XI,ERwin. * Teradata SQL * Teradata ETL tools & Utilities such as * BTEQ,MultiLoad,FastLoad,FastExport,TPT * Teradata Physical Implementation * Teradata Administration * Data Modeling to build LDM and PDM * Developed standard SQL, PL/SQL code * Query optimization technique * Developed Data summarization & aggregation concepts and scripts * Developed shell scripts (Korn shell) for ELT and BI purpose * 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 * Documents all ELT code for the business * Designed and installed test scripts for ELT code * Created Informatica9.1 ELT code from functional and technical specs * Converting Oracle Procedures, Functions into Teradata stored Procedure (SP) and Syntax. * 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 Management System) * Creating WorkFlow and WorkLet and also Managing sessions through WorkFlow. * BI Report (Daily, Weekly & Monthly) CHAIN Development for Banglalink BI Department. . Business Report creating through Teradata, SAP BO. * Developed SHELL SCRIPTS to transfer CSV & SEND EMAIL and for Mappings. * Banglalinks' (Orascom) existing Data Migration from Oracle to Teradata. * More than 1 Terabyte data migrated through Informatica9.1. * Design and develop test plans.

ETL Consultant at Bangladesh Bank @ Enterprise Data Warehouse Project

Jan 2009 - Dec 2010 (1 year)

Bangladesh Bank EDW Project (IT-7) with Basel-II implementation. Technology: Oracle EXADATA, OracleDI, OWB, OBIEE, Oracle10g Developer Suite. .Basel II Business requirements – Source system (GL) To Basel Data Warehouse .Business Analysis . Credit Risk, Market Risk & Operational Risk calculation & reporting .Basel II Business requirements - Data warehouse to Risk Engine .Settings for the Risk Calculation engine .Risk Engine Results layer to Basel II reporting layer .Solution for National Discretion (Central bank Reporting) .ALCO reporting through IFRS9 .Data Modeling (LDM & PDM) .Developed standard SQL, PL/SQL code for ELT purpose. * Design and created ETL standards and procedures * Architecture design of new data warehouse and ETL process * Designed and installed test scripts for ETL code * Created OWB (Oracle Warehouse Builder) and ODI (Oracle Data Integrator) ETL code from functional and technical specs * Developed Oracle Procedures, Functions and Packages and Syntax. * Design and created FTP scripts for moving source and target files * Tuned SQL and PL/SQL statements for end users creating custom reports * Worked on all phases of data warehouse development life-cycle, from gathering requirements to testing, implementation, and support. * Demonstrated expertise utilizing ETL tools, including Oracle Warehouse Builder, OracleDI ETL package design, and RDBM systems like SQL Servers, Oracle. * Architecting/designing the application accessing multiple type of data stores (Data warehouses, Datamarts, ODS, OLTP) and design of logical/physical data model. Also responsible for defining standards for database design and data modeling. * Created a number of cubes, dimensions and business critical KPIs using Oracle Analytical Workspace Manager and BI Server in several different ways - hierarchically and using custom groupings that the company will use to analyze performance. * Dash-board design. * Design and develop test plans.

Giáo dục

MBA

2006 - 2007 (1 year)

Bsc in Computer Science & Engineering

2000 - 2004 (4 years)

Chứng chỉ

Informatica (2012)

Informatica

Training on Informatica & Certification

Teradata (2012)

Teradata

Teradata Training & Certification

Oracle (2002)

Oracle

Oracle Certification on Developer6i and Oracle9i DBA

Data Warehouse (2010)

Indra Systemas

Data Warehouse: * ETL Design * Data Modeling * Analysis through Excel * Source System Analysis * BI

Oracle BIEE (2010)

Oracle

Oracle BI: * Oracle BI Analytics * Repository * Bi Publisher * Server administration * BI Dashboard * Data Model Design

ODI & OWB (2010)

Oracle

Oracle Data Integrator Oracle Warehouse Builder

Các xuất bản

An Adaptive Web Browser

This paper deals with a browser with data analysis that will assist a person of finding information for satisfying long-term recurring goals rather than short term goals. This browser predicts the interestingness of unseen sites based on previously visited sites through data analysis. Using naïve Bayesian classifier for this task, and demonstrate that it can incrementally learn profiles form user feedback on the interestingness of websites. Algorithm: AI, Machine Learning

Các Chứng Nhận

  • Đã kết nối với Facebook
  • Freelancer Ưa Thích
  • Đã Xác Thực Thanh Toán
  • Đã Xác Thực Điện Thoại
  • Đã Xác Thực Danh Tính
  • Đã Xác Thực Email

Các kỹ năng hàng đầu của tôi

Xem các Freelancer tương tự