add photo
Basanta
basantat863@gmail.com
817-778-9592
Ft Worth, TX 76244
SQL/SSIS Developer
10 years experience W2
0
Recommendations
Average rating
163
Profile views
Summary

  • Around 5+ years IT Experience in Database Development, Administration, Data Analysis, Design, Development, and support of MS SQL Server in various environment.
  • Experience with software development life cycle (SDLC). Extensively involved in SDLC from initial planning through implementation of the projects.
  • Expert in designing ETL data flows creating mappings/workflows to extract data from SQL Server Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
  • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De-normalization Techniques on database Tables.
  • Excellent knowledge in developing SQL objects like Table, stored procedure, triggers, views etc. using MS SQL server 2008/2014/2017
  • Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
  • Experience with Software Development Life Cycle (SDLC), Business Requirement Document (BRD), Designing, Programming, Database Design, Data Warehousing, and Business Intelligence Concepts.
  • Expert in developing SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management.
  • Developed various reports like Sub Reports, Matrix Reports, Drill Down Reports, Drill Through Reports and Charts using SQL Server Reporting Services (SSRS).
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks
  • Good understanding on how to use SQL Profiler for debugging and Execution plan to understand complex queries in depth.
  • Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.
  • Written complex SQL queries having to deal with multiple tables using various statements like joins, CTE, temp tables, reading from views etc.
  • Worked on SQL Task Scheduler to be executed automatically at regularly timed intervals by creating a scheduled task.
  • Experience in Error handling, Debugging, error logging in non-production and production environment.
  • Worked with Microsoft Power BI to extract data from external sources modifying data to expected format in Excel and created SSIS packages to load into database.
  • Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills possessing strong analytical skills.

Experience
Education
Business Studies
Tribhuvan University
Skills
Microsoft Excel
2023
13
SQL
2023
13
SQL Server
2023
13
SSIS
2023
13
OLTP
2023
9
Oracle
2023
9
Stored Procedure
2023
9
Data Conversion
2026
8
ETL
2020
8
Performance Tuning
2020
8
Snowflake
2020
8
SSRS
2020
8
T-SQL
2020
8
Triggers
2020
8
Windows
2020
8
MS Power BI
2026
6
SQL Loader
2026
6
API Development
2023
5
Data Migration
2023
5
Teradata
2023
5
ASP.NET
2018
4
Business Intelligence
2018
4
Data Dictionary
2020
4
Data Modeling
2020
4
Data Warehousing
2020
4
Information Architecture
2018
4
MS SharePoint
2018
4
MySQL
2018
4
PostgreSQL
2018
4
SSAS
2018
4
Visual Basic
2018
4
Data Marts
2018
2
Metadata
2018
2
Data Analysis
0
1
Database Design
0
1
Storage Management
0
1