Banner Image

All Services

Programming & Development Database Design & Administration

DB Admin and development

$5/hr Starting at $25

  • Over 17+ years of IT industry experience with Power BI, .NET, Microsoft SQL Server, SSIS/SSRS/SSAS,  Power BI, PostgreSQL in OLTP and OLAP (Data warehousing) environments. 
  • Extensive knowledge on Application virtualization and Load Balancing.
  • Worked in an Agile team of .NET developers for a fast-paced software development firm.
  • Developed and provided maintenance for 20+ .NET websites, using ASP.NET MVC, jQuery, HTML, and CSS
  • Advanced expertise in developing web and Client Server Applications and Hosting.
  • Good work experience with ADO.NET and Entity Framework.
  • Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications. 
  • Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions & features. 
  • Experience in Error handling and debugging coding issues and troubleshooting production problems. 
  • Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Functions, CTE’s, Table Variables and Stored Procedures. 
  • Experience in SQL Optimization by using SQL server extended events, Index Tuning, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans. 
  • Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities. 
  • Expert in automating process by creating jobs and error reporting using Alerts, FTP and SMTP. 
  • Designed and develop packages to and data from various data sources into SQL server.
  • Excellent analytical/Communication Skills, Team Play and very much result Oriented. 
  •  Design and implement new ETL processes and adapt current ETL processes to accommodate.
  • Advanced skills in creating Reports, Dashboard and perform Data Visualization using Tableau 8.2
  • Proficient emotional intelligence employability skills including Integrity, Adaptability, Strong Work
  • Ethic, and the ability to work well in teams.
  • Experience in creating complex SSIS packages using appropriate control flow, data flow elements. 

With SSIS Standards like error handling, logging and working with package config files.

  • Hands on experience in using different transformations like data conversions, look ups, derived column transformations etc. for data cleansing.

About

$5/hr Ongoing

Download Resume

  • Over 17+ years of IT industry experience with Power BI, .NET, Microsoft SQL Server, SSIS/SSRS/SSAS,  Power BI, PostgreSQL in OLTP and OLAP (Data warehousing) environments. 
  • Extensive knowledge on Application virtualization and Load Balancing.
  • Worked in an Agile team of .NET developers for a fast-paced software development firm.
  • Developed and provided maintenance for 20+ .NET websites, using ASP.NET MVC, jQuery, HTML, and CSS
  • Advanced expertise in developing web and Client Server Applications and Hosting.
  • Good work experience with ADO.NET and Entity Framework.
  • Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, DCL commands for various business applications. 
  • Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions & features. 
  • Experience in Error handling and debugging coding issues and troubleshooting production problems. 
  • Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Functions, CTE’s, Table Variables and Stored Procedures. 
  • Experience in SQL Optimization by using SQL server extended events, Index Tuning, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans. 
  • Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP utilities. 
  • Expert in automating process by creating jobs and error reporting using Alerts, FTP and SMTP. 
  • Designed and develop packages to and data from various data sources into SQL server.
  • Excellent analytical/Communication Skills, Team Play and very much result Oriented. 
  •  Design and implement new ETL processes and adapt current ETL processes to accommodate.
  • Advanced skills in creating Reports, Dashboard and perform Data Visualization using Tableau 8.2
  • Proficient emotional intelligence employability skills including Integrity, Adaptability, Strong Work
  • Ethic, and the ability to work well in teams.
  • Experience in creating complex SSIS packages using appropriate control flow, data flow elements. 

With SSIS Standards like error handling, logging and working with package config files.

  • Hands on experience in using different transformations like data conversions, look ups, derived column transformations etc. for data cleansing.

Skills & Expertise

Administrative AssistantCrystal ReportsData WarehouseDatabase AdministrationDatabase DesignDatabase DevelopmentMicrosoft SQL ServerMySQLPL/SQLPostgreSQLQuery OptimizationSQLStored Procedures

0 Reviews

This Freelancer has not received any feedback.