Sign in

Data Design

Irmo, SC
January 06, 2020

Contact this candidate



**+ years of experience in the design, development and implementation of Windows/Web Based Application using .Net (C#, VB.Net, ASP.Net, ASP.Net MVC), SQL Server, SSIS (8 years), and SSRS (5+ years), C/C++ on Windows, Linux and UNIX Environment

At HP, developed a .NET application for the State of South Carolina (Child Support Project), including extensive use of SSIS to create all ETL processes and created SSRS reports to identify data gaps and errors.

Also, with HP, he delivered new functionality and major enhancements to the State of Arkansas’s Medicaid application using .NET, C#, and SSIS to build out and improve ETL processes

Strong analytical and problem-solving skills allied with experience in business analysis, operational analysis, financial systems and inventory management; different Architectural and Design patterns, Architectural Methodology like TOGAF

Some working knowledge with Oracle, DB2, PostgreSQL etc.

Understanding of different Big Data Tools like MongoDB etc.

Technical Skills

Design Methodology/Modeling: Object Oriented Design, SDLC, UML, Spin

Languages/Scripting: C#, VB.Net, C/C++, VB6, JavaScript, JQuery, HTML, XML, XHTML, Shell

.Net Technologies: .Net Framework, ASP.Net, ASP.Net MVC, Web API

Database: SQL Server 2005/2008/2012/2014

BI Tools: MS SQL Server Integration Service (SSIS), MS SQL Server Analysis Service

(SSAS), MS SQL Server Reporting Service (SSRS)

Multi-tier Development: XML Web Service, ActiveX control, WCF

G.U.I/Graphics: MFC, OpenGL

Client/Server Development: IPC—Pipe, FIFO, Message Queue, Shared Memory

Network Programming: Windows and Unix Socket Programming



UNIX System Development: Pseudo Terminal, Device Drivers, Shell Programming

Operating Systems: Unix, Linux, Windows

Professional Experience

Intellectual Capitol, Columbia, SC April 2017- Till

Working as a senior consultant (Migration Expert) of the Child Support Project for the State of South Carolina State Government.

Provide consultancy service to the State Govt. for migrating Child Support related Legacy Data to the new system

Work as a Technical Architect for designing ETL Processes (Stored Procedures, Indexes, Triggers, Scripts, Functions, SSIS packages for Data Transfer, data integration and data maintenance)

Architect and design ETL Processes using .Net Application

Design Unit Test process for testing data integrity and quality

Design and develop Reporting System for creating various reports using SSRS

HP Enterprise Services, Columbia, SC / Remote Mar 2008 - Jan 2017

Client: Arkansas State Government - Medicaid (Remote, Aug 2014 – Jan 2017)

Solution Architect/Senior Application Developer

Created architectural design of the Solution based on client requirements

Developed Web based multi-tier multi-layer application using .Net (C#, ASP.Net, MVC, WCF, XML Web Services, JavaScript, JQuery, CSS, DotNetNuke)

Performed technical design and implemented ETL Processes (Stored Procedures, Indexes, Triggers, Scripts, Functions, SSIS packages for Data Transfer, data integration and data maintenance)

Designed and developed Unit Test Cases, performed Unit testing and Code Integration Testing

Provided Technical Support (3rd Level) for Medicaid Portal and Production Support for all applications

Internal HP Projects

App2Cloud Migration Project (Remote, Apr 2014 – July 2014)

Migrated HP IT Applications from the existing environment to the Cloud environment

Updated and changed the source code of applications to be migrated to the new environment as necessary

Recompiled the applications and deployed on the servers (IIS)

Performed regression testing

Provided training and education to the end users

Global Project for HP Data Center (Remote, Aug 2013 – Mar 2014)

Built ETL Processes (Stored Procedures, Indexes, Triggers, Scripts, Functions, SSIS packages for Data Migration, data integration and data maintenance)

Used SSAS (tabular model) for data analysis

Developed and maintained Web based and Desktop Applications using ASP.Net, C#, and SQL Server.

Developed tools for the HP Data Center

Client: South Carolina State Government, Columbia, SC (Mar 2008 – Aug 2013)

Technical Lead – Conversion Team, Child Support Project

Worked as the development lead of a team consisting of six members, prioritized the tasks, assigned tasks to other team members, coordinated the team works and provided guidance to other team members

Performed technical design and built ETL Processes (Stored Procedures, Indexes, Triggers, Scripts, Functions, and 700+ SSIS packages for Data Migration, data integration and data maintenance) to convert legacy data from 46 counties heterogeneous data sources to a single conversion database. Around 150 databases were used for the entire process.

oCreated 100+ SSIS packages and templates for all new SSIS packages used by junior developers on the team

Designed reporting system and developed SSRS reports for various purposes including the following:

oIdentified all source data issues (even a single record failure) across all 150 legacy databases -- wrote the code for and generated an error report that compiled all source data issues for the client using SSRS

oCreated an SSRS report to compare data from legacy databases to the new conversion database to ensure data quality and data integrity

oCreated an SSRS report to identify any changes made in the application database schema (by another team) and compare against the conversion database schema, then updated the schema to ensure these were identical

Designed, developed and maintained web-based business process and database applications.

Was Responsible for code quality of the application (C#.NET, web services, JavaScript), database, and 700+ SSIS packages created by the team - reviewed all code, assisted team in resolving complex technical issues, and mentored them on .NET and SQL development skills

Lead Developer-Application Team, Child Support Project

Did technical design developed Web based 3 tier multi-layer application using .Net (C#, ASP.Net, WCF, NHibernate, Web Services, JavaScript, JQuery, CSS)

Designed, developed and maintained web-based business process and database applications.

Designed test framework and developed Test Cases for Unit testing using NUnit Tool and performed Code Integration Testing

Microvellum, Inc., Medford, OR May 2006 – Feb 2008

System Analyst

Developed Windows and Web based applications for business management using .Net, XML, and Web Services

Designed and developed SMTP and POP3 Client applications using .Net Socket

Developed specifications and assisted in developing applications for the following: PocketPC, TWAIN application for printers and scanners, the installation Security Module for the products of the company, and .Net component from ActiveX DLL. Performed Unit testing

ERP Matrix, Montreal, Quebec, Canada Apr 2005 - Apr 2006

System Analyst

Surveillance System Development Project

Designed and developed Application for Surveillance System to be used for any type of Security Camera (Such as Analog Camera, Digital camera, IP Camera, or Web Cam).

Performed Unit testing

Ericsson, Montreal, Quebec, Canada Jul 2002 - Sep 2003

Research Graduate

Research Project: Networking Protocol Development Research Project

Worked on “Next Generation Internet Protocol” Project at Ericsson Research, Canada

Built IPv6 supported Linux kernel applying USAGI patch

Installed DNS server for IPv6 LAN

Developed NAT-PT to establish communication between IPv6 and IPv4 network (UNIX RAW Socket)

Using C in Linux Environment

Configured IPv6, IPv4 networks, and border gateway to make NAT-PT working

Performed Unit testing

Concordia University Montreal, Quebec, Canada Sep 2001 - Dec 2004

Teaching Assistant

Worked as a tutor for C/C++ programming Language and System Software courses in Windows/Linux environment

Worked as a lab instructor for Data Communication and Networking course

Lukkas Soft, Montreal, Quebec, Canada Apr 2000 - Aug 2001

Software Development Consultant

Analyzed requirement specifications, designed and developed Desktop Application using Visual Basic 6

Developed ActiveX controls for the middle tier


Master of Computer Science, Concordia University, Montreal, Quebec, Canada

Bachelor in Computer Science, Concordia University, Montreal, Quebec, Canada

Bachelor of Science in Mechanical Engineering, Bangladesh University of Engineering and Technology, Dhaka, Bangladesh

Contact this candidate