EXPLORE

Data Entry Data Processing Oracle SQL XML
Profile cover photo
User Avatar

Md H.

@hasnat02

0.0
0

0.0

0.0

0%

Oracle,SQL

$20 USD / Hour

・

Flag of

United States (10:23 PM)

・

Joined on April 24, 2009

$20 USD / Hour

・

o Data Analyst with over 5+ years of industry experience in Database Design, Data Analysis, Data Modelling, Data Migration, Data Mining, Data Mapping, Process flow and Quality Assurance skills. o Strong working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading (ETL). o Strong in SQL queries for data verification/validation and Backend processes o Experienced in different RDBMS like Oracle, DB2 and SQL Server 2003/2005 o Good understanding of OLTP, OLAP for data processing o Experienced with utilities like SQL*Loader, Datapump, Export/Import, Telnet, and FTP o Solid working knowledge of PL/SQL Procedures, Functions, Triggers, Packages o Extensive experience in testing and implanting Extraction, Transformation and Loading of data from multiple sources into Data Warehouse, Data Mart using ETL tools o Good command over Logical and Physical entity relationship data modelling using tools like Oracle o Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse o Good hands on knowledge in MS Excel, MS Access, MS Word, MS PowerPoint. o Strong knowledge of all phases in Software development life cycle (SDLC) and the iterative Rational Unified Process (RUP) o Extensive experience working in backend tester by writing SQL Queries and PL/SQL scripts on large data warehouse systems involving Terabytes worth of data. o Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data. o Design and review of various documents including the Software Requirement specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents o Very good understanding of Business Intelligence(BI) and Data Warehousing(DW) concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation. o Extensively worked on Dimensional modelling, Data cleansing and Data Staging of operational sources using ETL processes. o Knowledge of programming languages like Java, C#, PHP, VB Script, .Net etc. o Strong in designing database, domain modelling and ER diagrams o Knowledge of EDI, HIPAA, NACHA, PCI, LOS transactions o Experience in conducting Backend, User Acceptance Testing (UAT) o Highly motivated and a self-starter with excellent communication and interpersonal skills o Strong analytical and problem solving skills, capable of addressing relevant facts and recommending solutions. o Used Team Site Content Management (SCM) Tool to deploy and manage the content managed files.

Verifications

Portfolio

Portfolio

126254
126254
0.0 · 0 Reviews
Reviews

No reviews to see here!

Experience

Data Analyst

Jul, 2011 - Present

•

14 years, 5 months

Computer Express Int.

Jul, 2011 - Present

•

14 years, 5 months

o Involved in data modelling, analysis, reporting of Data Warehouse o Responsible for data gathering, mapping and documenting these o Involved in the business requirements gathering and analysis, understanding client's Data Warehousing requirements and system analysis. o Involved in designing Logical data model and Physical conceptual data model using Erwin,TOAD o Extracted data from different sources like SQL Server, DB2, XML files, flat files and loaded into Oracle data warehouse/data mart acco

Jul, 2011 - Present

•

14 years, 5 months

Education

University of Dhaka

2001 - 2006

•

5 years

Bachelor of Computer Science

Flag of

Bangladesh

2001 - 2006

•

5 years

Qualifications

SQL Expert

2011

Oracle

Oracle database certified SQL Expert.

2011

Registered Users

Total Jobs Posted

Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)

Copyright © 2025 Freelancer Technology Pty Limited (ACN 142 189 759)