Imagen de perfil de alambd
@alambd
Miembro desde 22 de abril de 2007
0 Recomendaciones

alambd

En línea Desconectado
Oracle9i/10g/11g, PL/SQL, Teradata13, Informatica8.5/8.6/9.1, SAP BO, OWB, ODI, OBIEE, Linux, Shell script
$7 USD/hr
2 comentarios
3.1
  • 33%Trabajos finalizados
  • 100%Dentro del Presupuesto
  • 100%A tiempo
  • N/ATasa de recontratación

Portafolio

Comentarios recientes

Experiencia

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.

Educación

MBA

2006 - 2007 (1 year)

Bsc in Computer Science & Engineering

2000 - 2004 (4 years)

Calificaciones

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

Publicaciones

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

Verificaciones

  • Conectado a Facebook
  • Freelancer Preferido
  • Pago verificado
  • Teléfono verificado
  • Identidad verificada
  • Correo Electrónico Verificado

Mis habilidades principales

Buscar freelancers similares