Uploaded File
Azmot
Sr. ETL and SQL Developer
3 years experience W2 Maryland Hts, MO
Available immediately
Actively seeking
Azmot
94
views
Sr. ETL and SQL Developer
0
Recommendations
Average rating
94
Profile views
Data Validation Data Integrity ETL Developer SQL Server SSIS T-SQL Business Requirements Agile Methodology JIRA Scrum
Remove Note
View Note
Recent Experience
Sr. ETL and SQL Developer 03/16 - 12/16
SQL Server SSIS SSRS SSAS Scrum T-SQL Agile Methodology Triggers JIRA SQL Developer Data Integrity ETL Developer ETL SQL Project Management Application Development Windows
Sr. BI Developer 11/15 - 02/16
C# Data Warehousing SQL Server SSIS SSRS SSAS T-SQL Data Validation BI Developer ETL SQL Windows
MS SQL Server Developer 08/15 - 10/15
SQL Server Win2003 T-SQL Erwin Data Modler Stored Procedure SQL Developer SQL Data Analysis Quality Assurance SQL Server Developer Database Design
Summary

  • Over eight years of IT experience as BI and MS SQL Server Developer 2014/2012/2008 R2/2008/2005/2000 in various Industry verticals like USDA, Manufacture, Insurance, Airlines, Telecommunication, Pharmaceutical, Retail, and Bank.
  • Strong experience big JIRA instances for Project Tracking, Test Management, Support Tickets and Agile tracking.
  • Specialize in the full and partial migration of JIRA/Confluence projects/spaces respectively.
  • Strong experience in TSQL coding, User Defined Function, Stored Procedure, Query Optimization, and Performance Tuning.
  • Highly proficient in the use of T-SQL for developing multiple SQL joins, User Defined Functions, indexes, user profiles, complex Stored Procedures, Triggers, Tables, views, Data integrity, Relational Database Models and query writing
  • Understanding complex business rule wrote and modified stored procedures/Triggers (DML/DDL).
  • Expertise in ETL workflows Creating, Configuring, and Fine-tuning, designed between Heterogeneous and Homogenous Systems using BIDS and MS SQL Server 2008 respectively.
  • Expertise in creating complex SSIS and DTS packages for ETL purposes. Implemented complex transformations to use in SSIS package.
  • Experience in developing ETL Packages using SSIS and data transformations and deploy on production servers.
  • Highly Proficient On-demand handling sub reports and creating Scheduled reports. Query for generating drill down reports using MS SQL Server Reporting Services 2008/2005 (SSRS).
  • Expertise writing Parameterized Queries for creating Tabular reports and Sub reports using Global Variables, Expressions, Defining Data Sources, Functions, Sorting the data and Subtotals for the reports using SSRS 2008/2005.
  • Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects.

Top 5 Skills
SkillsProficiencyLast Used
Data Validation
2016
Data Integrity
2016
ETL Developer
2016
SQL Server
2016
SSIS
2016
Education and Certifications
Bachelor's in Business administration And System Management
National University
Preferences
Availability:Immediately
Willing to relocate?:Yes
Relocation preference
Any location
Prepared to Travel:100%
Employment Type:Permanent
Security Clearance:No clearance
Citizenship:U.S. Citizen