Summary
Overview
Work History
Education
Skills
Certification
Additional Information
Timeline
Generic

Nahom Balcha

Dallas,TX

Summary

9+ years of experience in Software System Development and Expertise in areas of .NET Framework and .NET Core Technologies, C# , VB.NET , MS SQL Server, Java script , Json , XML , including MVC and Business Intelligence , Cross Platform Mobile Development and Others.

Overview

11
11
years of professional experience
1
1
Certification

Work History

.NET , .NET CORE , C#, SQL DEVELOPER

Bit
04.2019 - Current
  • Worked as a Developer in team for designing developing the application using Microsoft advanced technologies, Visual Studio, C#, .Net, ASP.NET, SQL Server and Version Control
  • Develop Class Using C# Development to Develop Class and Database Connectivity
  • Implementation of APIs
  • Developed a communication layer that is used for consuming web services and API's
  • Analyzed existing SQL queries to identify opportunities for improvements
  • Developed custom database objects, stored procedures and delivered application support
  • Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
  • Designed and developed forward-thinking systems that meet user needs and improve productivity
  • Tested functional compliance of company products
  • Authored code fixes and enhancements for inclusion in future code releases and patches
  • Employed coding practices based on commonly accepted standards to establish site layout and user interface
  • Experience with AZURE Cloud Services like Azure Storage, Azure functions, Logic Apps, App services, Web Jobs, Key Vault, Active Directory, Azure Search, Azure Runbook Account, AAD B2C, Cosmos DB, SQL DB, Application Insights, Monitor, Log Analytics, Azure CLI, CI-CD with Azure DevOps
  • Reviewed code to validate structures, assess security and verify browser, device and operating system compatibility
  • Collected, defined and translated user requirements into project designs and implementation plans
  • Collaborated with in-house web designers to create sleek and innovative UI design

C#, .NET , NET CORE , MVC, BI,SQL DEVELOPER

Bank of America /Infosys Tech
, United States
01.2017 - 01.2019
  • Company Overview: NC, United States
  • Designed and developed APIs using Microservices architecture with Azure Functions and ASP.NET Core, enhancing scalability and modularity
  • The project involved tuning and streamlining, enhancing and supporting an Extraction, Transformation and Loading (ETL) process
  • Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard
  • Involved in SSIS Package creation from package design documents to package build
  • Designing and developed various Classes in C#.NET to implement the business logic and event handling
  • Leveraged Azure DevOps to establish robust Build and Release pipelines, ensuring seamless deployment of microservices
  • Utilized Azure Functions for serverless computing, optimizing resource utilization and scalability
  • Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated
  • Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse
  • Created Test packages to validate the SSIS packages build
  • Created and modified Stored Procedures, Functions, and Indexes
  • Expertise in generating reports using MS Reporting Services 2012
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
  • Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse
  • Optimized web applications for speed, scalability and security
  • Boosted web traffic by improving navigation and rectifying bottlenecks
  • Planned and engineered RESTful web services to manipulate dynamic datasets
  • Conceived and built optimized landing pages in HTML and CSS for integration and cross-browser compatibility
  • Took concepts and produced design mockups and prototypes to strengthen designs, enhance user experiences and improve site interactions
  • Implemented encryption, authentication and additional security measures, safeguarding systems
  • Created web-based dashboards and reporting tools for data visualization
  • Collaborated with other developers to refine software design and implementation
  • NC, United States

SQL DBA/DATABASE ADMINISTRATOR/DEVELOPER

Anritsu Corporation
Morgan Hill, United States
02.2016 - 01.2017
  • Company Overview: Morgan Hill, CA
  • Installed, Configured, and Managed SQL Server 2012, 2008, 2005 & 2000 in development, test, and production environment
  • Installed and Configured SQL Server 2008 for testing different features and stability
  • Backup/Recovery: Strong knowledge and working experience in Database Backup and Disaster Recovery
  • Experienced with Point-in-Time Recovery
  • Restored Database from backup
  • Database High Availability: Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008
  • Configured Log Shipping as Standby database from Production database for Reporting purposes
  • Clustering using SQL Server 2008/2005
  • Configured and Maintained Replications
  • DBCC: Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well
  • Report Development: Installed, Configured, and administered SQL Server Reporting Services (SSRS)
  • Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0
  • Deployed Reports and managed security of report server including folder level
  • SSIS: SSIS Package create, deploy and manage
  • Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server
  • Morgan Hill, CA

SSIS/SSRS/SQL DEVELOPER /DBA

Centene Corporation
St. Louis, United States
01.2014 - 01.2016
  • Company Overview: St
  • Louis, MO
  • Involved in SSIS Package creation from package design documents to package build
  • Involved in Unit testing of the SSIS extract packages and also building validation packages to check the accuracy of the data migrated
  • Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse
  • Created Test packages to validate the SSIS packages build
  • Created and modified Stored Procedures, Functions, and Indexes
  • Expertise in generating reports using MS Reporting Services 2012
  • Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
  • Designed SSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS
  • Database Migration: Between databases in MS SQL Server 2000, 2005, 2008,2008 R2/2012
  • Oracle 10gR2/11gR2 databases to SQL Server 2008 R2
  • My-SQL 4.1.0/5.0.15 databases to SQL Server 2005 and 2008 R2
  • Database Programming: T-SQL, Trigger, and Stored-Procedures
  • Optimize SQL queries and Stored Procedures
  • DTS/SSIS: Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
  • Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
  • St
  • Louis, MO

Education

Bachelor of Science - Information Systems And Computer Science

09.2009

Skills

  • ASPNET
  • C#
  • NET
  • ADONET
  • XML
  • Web Services
  • APIs
  • Windows Services
  • LINQ
  • VBNet
  • TSQL
  • HTML
  • CSS
  • JavaScript
  • Xamarin
  • Microsoft SQL Server
  • MS Access
  • Oracle
  • Data Flow Diagram
  • Flow Chart
  • Entity Relationship Diagram
  • Visual Studio
  • Git
  • Team Foundation Server
  • Cross Platform Mobile App Development
  • MVVM
  • Web API Development
  • SQL Server Database High Availability
  • Standby
  • Replication
  • Database Mirroring
  • Clustering
  • Log Shipping
  • Installation
  • Configuration
  • Administration
  • Database Monitoring
  • Performance Tuning
  • Query Optimization
  • Database Upgrading
  • Database Deployment
  • Design Methodologies
  • IDE
  • Version Control
  • Windows App Development
  • Web Development
  • Backup/Recovery
  • Security Management
  • Data Modeling
  • Scripting
  • Job Automation
  • Toad Data Modeler
  • Erwin
  • MVC
  • Azure

Certification

  • Microsoft Certified IT Professional: SQL Server – 2008, Database
  • MCITE - (Microsoft Certified IT expert)
  • Google Analytics

Additional Information

SSIS Package create, manage, and deploy Windows Operating Systems (2008, 2008R2, 2012, 2016, 2019, 2022): Installation, Configuration, User and Security Management., Write Different type of stored procedure, Function and triggers., Write and deployed different TSQL statements., Operating Systems: Working experience on Operating Systems (O/S) include Windows Server 2019, 2008, 2008 R2., Working experience also includes installing, configuring, and administering the above operating systems., VMware: Installed, configured, and administered SQL Server 2019, 2017, 2008 R2, 2008, 2005, 2000.

Timeline

.NET , .NET CORE , C#, SQL DEVELOPER

Bit
04.2019 - Current

C#, .NET , NET CORE , MVC, BI,SQL DEVELOPER

Bank of America /Infosys Tech
01.2017 - 01.2019

SQL DBA/DATABASE ADMINISTRATOR/DEVELOPER

Anritsu Corporation
02.2016 - 01.2017

SSIS/SSRS/SQL DEVELOPER /DBA

Centene Corporation
01.2014 - 01.2016

Bachelor of Science - Information Systems And Computer Science

Similar Profiles

CREATE PROFILE
Nahom Balcha