Overview
Summary
Work History
Education
Skills
Timeline
Certification
Generic

Riyaz Ahmed Khan

Fitchburg,United States

Overview

14
14
years of professional experience
1
1
Certification

Summary

Adept at driving significant improvements in database performance, I leveraged my expertise in T-SQL and problem-solving skills at Mint Middle East LLC to enhance query efficiency by 90%. My proficiency in SSIS and a keen eye for detail ensured robust data integrity and streamlined ETL processes, showcasing a blend of technical prowess and analytical acuity. Talented Software Developer equipped with great coding, debugging and project management abilities. Accomplishes project goals consistently with elegant, scalable code. Works great with team members under Agile and Scrum frameworks.

Work History

Software Developer

Mint Middel East LLC
Dubai, UAE
04.2010 - 03.2021
  • Installation, Configuration, Maintenance and Administration of MS SQL Server 2008 R2
  • Responsible for creating T SQL scripts to create report models
  • MS SQL performance tuning
  • Trouble shooting problems by using SQL server profiler
  • Developed and document disaster recovery plan
  • Involved in Setting up Log shipping, database mirroring and Involved in Creating Back up Strategy
  • Involved in Designing (Logical and Physical) of Customer Database
  • Created & managed the Database Users, Login, Roles, Profiles and Security
  • Automated Backup/Restore Jobs as well as reduce the Backup/Restore time up to significant amount
  • Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using MS SQL
  • Creation of Jobs, Schedules, Alerts using MS SQL Server Agent and Notifications using SQL Mail
  • Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to MS SQL server
  • Worked as MS SQL Server administrator
  • Worked on performance tuning of Database and Query tuning
  • Involved in resolving blocking and dead lock Issues by using MS SQL commands Using T-SQL
  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other TSQL code to implement business rules
  • Designed Handshaking architecture for overall data transfer from the OLTP to Staging area and finally into OLAP with SSIS and T-SQL stored procedures
  • Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation of the OLAP databases
  • Developed, deployed, and monitored SSIS Packages including upgrading SSIS using upgrade advisor
  • Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages
  • Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports
  • Contributed to the definition of database requirements; analyzed existing models and reports for opportunities to improve efficiency and troubleshoot various performance issues
  • Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes
  • Involved in performance monitoring, tuning, and capacity planning
  • Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database
  • Translated business requirements into BI application designs and solutions
  • Created SSIS package to load data from Flat Files, Excel, and XML Files to Data warehouse and Report Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension
  • Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse
  • Responsible for the implementation of data viewers, Logging, and error configurations for error handling the packages
  • Involved in the complete life cycle of creating SSIS packages, building, deploying, and executing the packages in both environments (Development and Production)
  • Created and maintained data flow diagrams for existing and future ETL processes
  • Designed, deployed, and maintained complex canned reports using SQL Server 2008 Reporting Services (SSRS)
  • Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions
  • Created reports to retrieve data using Stored Procedures that accept parameters
  • Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, and Drill-down reports using Expressions, Functions, Charts, and Maps, Sorted the data, Defining Data sources and Subtotals for the reports
  • Publishing PDF Reports obtained from the Report Server on to SharePoint Portal
  • Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, a conditional split, and backup and was involved in the scheduling of SSIS packages
  • Involved in Data Extraction, Transformation, and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert)
  • Involved in the error handling of SSIS packages by evaluating error logs
  • Successfully extracted transformed and loaded data into the data warehouse
  • Created reports using SSRS from OLTP and OLAP data sources and deployed them on the report server
  • Created tabular, matrix, chart, drill-down reports, parametric, cascaded reports, dashboards, and score cards reports (SSRS) according to business requirements
  • Created reports by dragging data from the cube and wrote MDX scripts
  • Used SSIS 2008 to create ETL packages(dtsx files) to validate, extract, transform and load data to a data warehouse, and data mart databases, and process SSAS cubes to store data in OLAP databases
  • Improved the performance of long-running views and stored procedures
  • Improved performance by adding indexes, removing unnecessary columns in the inner views, and adding conditions to get only the required data
  • Identified slow-performing views, stored procedures, and queries using SQL Profiler, by running simultaneously while browsing the application
  • Tuned the queries using the Execution plan, to get an index to seek from table scan and index scan
  • Improved the performance of many queries by 90%
  • Worked with Erwin data modeling tool
  • Created Database objects including Tables, Views, Stored Procedures, and UDF
  • Developed User-defined functions, stored procedures, indexes, and Triggers
  • Extensively involved in writing database scripts

SQL Developer

Workers Equity Holding LLC
Dubai, UAE
06.2007 - 12.2009
  • Writing triggers, stored procedures, and functions defining user-defined data types, TSQL, and creating and maintaining physical structures for collateral management and hedging
  • Working with Dynamic Management Views, System Views for Indexing, and other Performance Problems
  • Create / Manage Table Indexes, Query Tuning, Performance Tuning, and Deadlock Management
  • Defect tracking and closing by using HP Quality Center
  • Design and Deploy SSIS Packages
  • Creating SSIS Packages, Configure SSIS packages for different environments using DTSConfig
  • Produce CSV, and utilize CSV files as part of the ETL Process, Used .Net Scripts
  • Produce XML Event Handling, Logging, and Batch Checks for data accuracy
  • Code deployments/configurations/config management in various environments
  • Implement Security, Roles, Logins, and Permissions
  • Extract-Transform-Load data into SQL Server 2008 Normalized database from various sources
  • Maintain Users / Roles / Permissions, Security
  • Scheduling SSIS packages using Autosys, writing JIL Scripts
  • Enhance existing applications to meet new business requirements
  • L3 Production Support on a Rotation Basis
  • Enhance existing stored procedures, views, functions, and database objects to meet additional requirements of the latest releases
  • Capacity Planning DBs, Disk Requirements
  • Deploy the code in various environments
  • Create and maintain DB Change Log to track the state of the DB in each environment (Dev, Test, UAT, Pre-Prod)
  • Application Testing, Debugging SIT, UAT, Test Clusters, and Test Load Balancers
  • App Testing in Development, Production, DR
  • UML Use Case diagrams, Conceptual Flow Diagrams, and ER Diagrams by reverse engineering the databases using Visio 2003
  • Deploy various reports on SQL Server 2005 Reporting Server
  • Tuning the Databases, Auditing, and Dynamic Management Views
  • Database Capacity Planning, Maintenance Plans, Backup, and Restore
  • Data Modeling, Conceptual/Logical/Physical Modeling
  • Create and maintain a database for Incident, Problem Tracking, Metrics
  • Working with SQL, and T-SQL queries, worked on developing Stored Procedures, functions, triggers, and Views
  • Design Reports as on Internal User needs
  • Access SharePoint Server using Web Services to deploy reports on Reporting Server
  • Involved in creating tables, stored procedures, indexes
  • Creating and Maintaining users, logins, jobs, job Notifications with packages
  • Design, Creating, and Deploying various SSIS Packages (for ETL - Extraction, Transformation, Loading)
  • Configuring the Database Mail, Mail Operators using SQL Server 2005
  • Importing Data from various sources like DB2, Oracle, Excel, XML
  • Ensuring Data Consistency, Analyzing the Data
  • Detailed documentation of all the existing and new processes, Create and Update Data Dictionaries
  • Business Analysis, Understanding Requirements, Converting Business Requirements into Technical Solutions

Education

Masters Degree - Computer Science

Fitchburg State University
Fitchburg, MA
12.2022

Masters Degree - Computer Applications

Osmania University
Hyderabad
05.2004

Skills

  • Programming Languages:C#,ASPNET,ADONET
  • Application Servers:IIS
  • Operating Systems:Windows 95/98/2000/NT/XP/2008 ,UNIX,LINUX
  • Data Base:MS SQL Server2008
  • Web Technologies:HMTL,CSS,JavaScript
  • Reporting & Data Warehouse Tools:SSRS,SSIS
  • Cloud Technologies;AWS,Azure
  • Microsoft Suit:MS Office,Word/Excel/Powerpoint,Outlook

Timeline

Software Developer

Mint Middel East LLC
04.2010 - 03.2021

SQL Developer

Workers Equity Holding LLC
06.2007 - 12.2009

Masters Degree - Computer Science

Fitchburg State University

Masters Degree - Computer Applications

Osmania University

Certification

Microsoft Certified Azure Fundamentals, 05/2024

Similar Profiles

CREATE PROFILE
Riyaz Ahmed Khan