Uploaded File
Azmot
Azmot.iqbal@gmail.com
347-279-4191
110-45 Westport Station Dr,APT#G
Maryland Hts, MO 63043
Sr. ETL and SQL Developer
8 years experience W2
0
Recommendations
Average rating
120
Profile views
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.

Experience
Sr. ETL and SQL Developer
Information Technology
Mar 2016 - Dec 2016
  • Developed relational databases optimized to provide data to FSA application.
  • Worked with clients to address pressing issues by handling requests via internal ticketing system

Responsibility:

  • Collaborate with users and management on developing performance metrics
  • Establishing system performance metrics and defining mechanism for tracking performance on an ongoing basis
  • Determining database environment setting up for applications from development through Integration implementation
  • Collecting information to be recorded in database
  • Dividing information into tables, turning information into columns and creating table relationships
  • Managing the tasks of generating capacity plans for upcoming projects
  • Consistently met the project's deadlines for adding table modify column and constraints into the database and implement it integration while working with software developer and client service teams to further improve the product.
  • Demonstrated ability to adapt to company's evolving environment by learning quickly & taking on expanded roles by implementing new procedures and improving existing ones.
  • Created T-SQL objects & scripts used to maintain data integrity across all databases throughout database servers (Stored Procedures, Triggers, and Functions).
  • Capture the Business Overview, Identify the Business Problem
  • Joining Daily scrum meeting with JIRA instances for Project Tracking, Test Management, Support Tickets and Agile tracking.
  • Coordinate project initiatives with software developers, stakeholders, project managers and software testers Environment: MS SQL Server 2014/2008R2, SSRS, SSIS, SSAS, Visual Paradigm, JIRA, MS Office, Windows 7.
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
Remove Skill
Sr. BI Developer
Information Technology
Nov 2015 - Feb 2016
  • OTTO is a vertically integrated manufacturer with in-house injection molding, stamping, CNC machining, cable assembly and cable over-molding capabilities.
  • I was involved support and maintenance of the existing reports for manufacture, providing development and testing support for the new reports, creates new reporting solutions for the data warehouse as required.

Responsibilities:

  • Expertise in performance tuning of T-SQL queries and Stored Procedures.
  • Worked with Excel Power Pivot reports and Pivot charts for analyzing the data from various systems for business needs.
  • Collaborated with Integration of different systems involved in the business flow and building reports on top of it for analysis purpose and Involved in manual data validation after ETL runs.
  • Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server and Implemented error handling and rollback process in ETL load.
  • Used expressions and variables in SSIS to make load dynamic.
  • Design, deployment, and maintenance of many SSRS Reports in SQL Server 2008R2.
  • Generated various reports with drill down, dropdowns from the cubes by connecting to Analysis server from SSRS.
  • Worked with control flow and workflow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
  • Developed many OLAP cubes from scratch according to business needs in SSAS.
  • Involved in the documentation of production deployment.
  • Scheduling SQL Server Agent jobs for daily and weekly basis. Environment: MS SQL Server 2012/2008R2, SSRS, SSIS, SSAS, Visual Studio.Net 2010, VB.NET, C# 3.5, MS Office, Windows 7.
C# Data Warehousing SQL Server SSIS SSRS SSAS T-SQL Data Validation BI Developer ETL SQL Windows
Remove Skill
MS SQL Server Developer
Information Technology
Aug 2015 - Oct 2015
  • The project involved designing a new database schema and migrating databases to the Production environment, modifying database structures, providing support and guidance to operational models by checking for data quality and its consistency.

Responsibilities:

  • Planned, Defined and Designed data based on business requirement and provided documentation.
  • Gathered data and documenting it for further reference.
  • Plan, design, and implement application database code objects, such as stored procedures and views.
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis.
  • Provide database coding to support business applications using T-SQL.
  • Perform quality assurance and testing of SQL server environment.
  • Develop new processes to facilitate import and normalization, including data file for counterparties.
  • Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
  • Ensured applied, and integrity of data maintained through security, documentation, and change management. Tools & Technologies: MS SQL Server 2008, T-SQL, Win 2003 Advanced Server, Erwin v7.2.
SQL Server Win2003 T-SQL Erwin Data Modler Stored Procedure SQL Developer SQL Data Analysis Quality Assurance SQL Server Developer Database Design
Remove Skill
BI and SQL Server developer
Information Technology
Oct 2013 - Jul 2015
  • FinEngine supports the functions of business analysis, trading analytics, cost analyze and on demand analysis for client side.
  • The project involved migrate data into 2008 to 2012 SQL Server and also working with ETL process using SSIS tools transform data to the data warehouse.
  • Finally, the project gives more power to the analytical strategist, management and end users enabling them to build their analysis and equip themselves with Ad hoc and OLAP reporting tools.

Responsibilities:

  • Performed by following the normalization standards appropriate changes from SQL Server 2005 to SQL Server 2008 to maintain data consistency and data validation.
  • Actively participated in gathering Business Requirements Analyzed the Business Requirements, System Specification and implementing the logical design and physical design.
  • Creating SSIS Packages by using advanced transformations (PowerPivot Transformation, Derived Columns, Fuzzy Lookup, Term extraction, Condition Split, Aggregate) and also used Custom components such as Audit on Pre-Execute, Audit On Post-Execute, Custom Email Task and Statistics Logging Component.
  • Performed create a dynamic SSIS packages using complex expressions, variables and also control flow components such as For Each Loop, container and For Loop to loop over a Directory to load inbound files.
  • Applied the Business Rules and the requirement to filter bad data from the system by using Complex T-SQL Statements and implemented in various Constraints and Triggers for Data Consistency.
  • Prepared the Migration document showing the paths for input and output files, configuration files, table scripts, stored procedures and SSIS packages
  • Responsible for creating the reports based on the requirements using SSRS 2008.
  • Wrote a query for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
  • Created a different type of reports which include: Cross-tab, Conditional, Drill-down, Sub report, Parameterized report and deployed scheduled Reports in Report Manager using SSRS generating all daily, weekly, monthly and quarterly Reports.
  • Monitoring performance and optimizing SQL queries for maximum efficiency
  • Modified the existing SSIS packages to meet the changes specified by the users.

Tools & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, Business Object 3.1, Oracle 11g, Microsoft Excel

HTML Business Objects Business Analysis Business Requirements Stored Procedure SQL Server Oracle SSIS SSRS T-SQL Triggers BI Developer SQL Developer Data Warehousing ETL SQL XML Project Management Data Validation SQL Server Developer Database Design Auditing Microsoft Excel
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Business administration And System Management
National University

 

 

Skills
Data Validation
2016
9
Data Integrity
2016
8
ETL Developer
2016
8
SQL Server
2016
8
SSIS
2016
8
T-SQL
2016
8
Business Requirements
2015
2
Agile Methodology
2016
1
JIRA
2016
1
Scrum
2016
1
BI Developer
2016
8
SQL Developer
2016
8
Data Warehousing
2016
6
Stored Procedure
2015
3
C#
2016
2
SSRS
2016
2
Win2003
2015
2
Business Analysis
2015
1
HTML
2015
1
ETL
2016
3
SQL
2016
3
Triggers
2016
3
Auditing
2015
2
Database Design
2015
2
Microsoft Excel
2015
2
Project Management
2016
2
SQL Server Developer
2015
2
XML
2015
2
Business Objects
2015
1
Erwin Data Modler
2015
1
SSAS
2016
1
Oracle
2015
1
Windows
2016
1
Application Development
2016
1
Data Analysis
2015
1
Data Mining
0
1
Performance Tuning
0
1
Quality Assurance
2015
1