Mahabubur Rahaman
Cell #: (+88 01715616344)
E-Mail: [Send email using form at bottom]
Address: Block L, House 37(3rd floor south), Road S 1, Eastern Housing,
Pollabi Second Phase, Mirpur, Dhaka - 1216, Bangladesh.
As a Database/Data warehouse/BI developer more than 8 years experience on all
aspects of database , data warehouse and ETL development in Microsoft SQL Server
environment.
This has provided me with an excellent grounding in backend.
SQL Server - SSIS, SQL queries and stored procedures to develop and maintain ETL
processes to extract, transform and load data into data warehouse.
Extensive experience with data warehouse concepts and methodologies.
Experience with business intelligence or reporting tools (preferably SQL Server
BI tools: SSIS, SSRS, SSAS).
Experience with database design & modeling using SQL Server 2002/2005/2008
I have also sound knowledge about IBM ETL Tools like Datastage.
Working familiarity with XML & Service Oriented Architecture, Software
Architecture
Technical Summary
Back-ends Development
Extensive expertise in
SQL Server Database Engine
1. Database Design with proper Normalization.
2. DBA Work likes Backup, Recovery, Indexing, DBCC, Performance tuning and so
on
3. Data Warehousing with ETL Process using T-SQL and SQL Server Integration
Service
4. Writing stored Procedures, Trigger, Function using T-SQL, CLR procedures.
5. Extended Stored Procedures with VC++.
6. Calling VB/VC++ component using T-SQL.
7. Creating job schedule.
8. Backup, Restoring databases (Full/Incremental)
9. SQL tuning, indexing and effective query writing.
1***- Database tuning using DBCC.
11. Writing Ad hock Query using OpenXML, OpenDatasource, OpenQuery to Export
/Import text, CSV, xls file data.
Recently I have worked with Changed Data Capture service of SQL Server 2008.
SQL Server Analysis Service
1. Creating Cube with Dimension and fact table.
2. Extract Transformation and Loading data from various data source.
3. Writing MDX Query to point cell value.
SQL Server Integration Service
1. Export/Import data from source to destination previously named DTS..
2. Lookup/Transformation data.
I have sound knowledge about SQL Server Service Broker
Business Intelligence
SQL Server Reporting Service.
1. Creating RDLs with SQL Server 2005 BI Intelligence including Sub Reports,
KPI,
2. Deploy to Report Server and manage Security.
3. Creating Report Model.
4. Work with Reporting Service Sharepoint Integration.
5. Dashboard Design with Reporting service using BO Crystal XCelcius.
Crystal Report.
Active Data report
Crystal XCelsious (Dashboard Design).
ORACLE 8 and 10g Server / Express Edition
1. Design Schemas with normalized database object (tables, views, Functions,
Stored Procedures).
2. Creating package definition and body.
3. Named block likes Stored Procedures, Functions, User define data types with
PL/SQL
4. Exception handling.
5. Indexing table data for quick search.
6. Export/Import.
7. Performance tuning by effective PL/SQL programming, Database shrinking, Auto
Statistics and so on.
Front-ends Development
Designing Web/Desktop application using ASP.Net using C #.Net v1.1, 2.0, 3.0
and 3.5, VB6, VFP7, Classic ASP
Completed project development from analysis, design and building through to
implementation and live production running.
Analyzing functional Specs and Designing Technical doc.
Extensive expertise in
UI Tools
ASP.NET, ASP.NET MVC Framework, Silverlight.Sharepoint
Scripting Language
JQuery, JavaScript, VBScript, HTML, XML
Data Access Components
ADO.NET, ADO.NET Entity Framework, ADO.Net Data Service, LINQ TO SQL
CMS
Sharepoint Technology, Web part design
Programming Language
C#.Net 2.0/3.5 with WPF, WCF, WF, XAML technology. XML Web Service
Design Pattern
Command Pattern, Factory Method, Abstract Factory, Repository, Template design,
Singleton, MVC, MVVM and so on.
I have sound knowledge about Restful service, Iqueryable , IEnumerable, URI
resource.
OS
Windows 7 Ultimate, Windows Server 2008, Windows Vista , Win server 2003,
Windows XP
Acted as Consultant on Banking solution projects and strategies.
7 years experience with VB6, COM+, MSMQ, User Control, DLL
3 years experience with Oracle, PL-SQL, Package, Trigger, Creating,
Backing up and Recovery database
Worked closely and effectively with all levels of management
Direct involvement in all system development lifecycles
Work Experience
Orion Informatics Ltd
Senior Software Engineer
APRIL 2006 to PRESENT
Project: CRA Wiz
Description: CRA Wiz is used to import, geocoder, scrub, analyze, and submit
mortgage applications and CRA loan records to the USA government.
CRA Wiz applies a wide range of automation technologies to the CRA reporting
process, from guaranteed accurate geocoding to flexible reporting to intelligent
analysis. It speeds preparation of data for CRA reviews, scrubs and corrects data
and reports the results.
CRA Wiz Components:
Data Prep Module provides functionality that allows Importing, editing and
preparing data for submission
Analysis Module provides access to various analysis reports using out of the box
templates
Geocoder standardizes and geocodes address data
Responsibilities:
Error Tracking and Bug fixing.
Development based on new requirements.
Performance Tuning of the software.
Design T-SQL queries, stored procedures and functions.
Tuning Stored Procedures.
Use Crystal Reports and SQL Server Reporting Service for report generation.
Create technical documentation for the new functionality of the system.
Assist in creating users manual
Train end-users on how to use new system and how to fully utilize the new
system to improve productivity.
Create database structure and scripts.
Coordinate with the team on the overall project backend issue which improves
productivity of the company.
Analyze the requirements and prepared the specifications including test plan
formulation from requirements and test scenario development from use cases.
Identify the expected behavior, as specified in requirements
Convert application developed using Visual Basic for Applications to web-based
applications
Develop various Transact-SQL code to implement business rules through
Triggers, Stored Procedures, Functions, and Views.
Generate management reports as needed
Environment:
VB6, Web Service using C#.Net v1 language, XML, HTML, JavaScript, SQL server
2000/2005 (Database Engine Backup Recovery, Performance tuning, Indexing,
Transaction, Replication)
Project: Wiz Basic(K2)
Description:
Quickly perform all essential HMDA compliance functions on data including:
geocoding, rate spread calculations, HsMDA FFIEC edit checks, and preparation of
the hmda.dat submission file. Effortlessly generate the LAR and public LAR
report. And monitor key performance indicators with dashboards to stay on top of
compliance status.
Wiz Basic is a fully-hosted solution, which requires no special IT expertise
because there is nothing to install. And because it is web-based, any regulatory
updates require no action on the part of the user
Responsibilities:
Analyze and resolve business, system and development issues
Analyze current business processes for improvements
Research on technologies to determine its applicability to current and future
projects
Implement new technology to current systems
Design Dashboard using Crystal XCelsius, Excel and SQL Server Reporting
Service KPI
Design Custom Report using SQL Server Reporting Service and Integrated with
Share Point Site.
Technology:
C# .NET, ASP.Net,SharePoint Technology
Project: Fair Lending Wiz
Description: Fair Lending Wiz: Web lets you monitor indirect lenders without
overburdening internal resources. It identifies third parties that may be
charging higher rates to protected classes or denying loans on an unfair basis.
It gives you the information you need to effectively monitor, analyze and manage
third party lending.
We interview the underwriters, build the models and identify the risks. You
focus on closing loans with complete confidence that your third party originators
are treating customers equally and fairly
Responsibilities:
Analyze current FLWizWeb system for ways to improve productivity
Coordinate with all levels of management to ensure all issues are taken into
consideration
Bug Fixing, Changing, Adding new requirements to the software,.
Data processing for Various bank line (FNB,CITY BANK etc USA),
Dashboard design using Crystal Xcelsius. ETL design and so on.
Assist in designing a new database structure
Design T-SQL queries, stored procedures, Trigger and functions
Tuning Database query performance by optimizing Indexing, Statistics.
Use Crystal Reports for report generation
Create technical documentation for the new system
Technology:
C# .NET, SQL Server 2000,SQL Server Analysis Service
EDUCATION
Bachelor's Degree
Field of Study : Computer Science/Information Technology
Major : Oracle,D2K
Institute/University : Newport University, United States
CGPA : 3/4
Graduation Date : Jan 2001
Certification
H.S.C (1995, 1st division)
S.S.C (1993, 1st division)
References
Available upon request
|
