Resume

Sign in

Sql Server Data

Location:
Madikonda, Telangana, India
Posted:
February 14, 2019

Contact this candidate

Resume:

SAL ISMAYILOV

ac8htc@r.postjobfree.com

973-***-****

SUMMARY

●Over 8+ years of IT experience in the Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite (Development, QA, UAT and Production Environment) with various SQL version like 2016/2014/2012/2008R2/2008.

●Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server-based applications).

●Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.

●Wrote and modified stored procedures/Triggers (DML/DDL) to implement complex business rule.

●Involved in developing stored procedures, triggers for the application.

●Expertise in Creating, Configuring and Fine-tuning ETL workflows designed using SSIS.

●Extensive Knowledge in creating complex SSIS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages.

●Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.

●Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.

●Proficient in creating sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services.

●Highly skilled in writing Parameterized Queries for generating parameterized reports and Sub reports using global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.

●Familiar working with both Waterfall and Agile Methodology.

●Expert in using tools like MS SQL Profiler, Windows Performance for monitoring and tuning SQL Server performance.

●Maintained positive communications and working relationships at all business levels.

Education

Bachelors in Finance

Masters in Information Technologies

TECHNICAL SKILLS:

Databases

MS SQL server 2016/2014/2012/2008R2/2008, MS Access, Oracle

ETL Tools

SQL Server Integration Services (SSIS), SQL Server DTS

SQL Server Tools

SQL server Management Studio, SQL server Query Analyzer, SQL Job Agent, Database Engine Tuning Advisor, SQL server profiler.

Data Modeling Tools

Erwin, Microsoft Visio

Other Tools

Team Foundation Server, Microsoft Visual Source Safe, Microsoft Office, Jira, SharePoint, Tableau

PROFESSIONAL EXPERIENCE:

Endurance Services

Mar 2018 – Present

Sr. SQL Server/SSIS/SSRS Developer

Goal of the project was to get data from heterogeneous sources and develop SSIS package and new solution for the business. Also create reports using SSRS to share data in different formats.

Responsibilities:

●Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources.

●Extracted and transformed data into Staging Servers for historical data and Staging Server and data load increments.

●Performed loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

●Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

●Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.

●Filtered data from Transient Stage to EDW by using Complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.

●Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.

●Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database

●Created and modified various Stored Procedures used in the application using T-SQL.

●Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

●Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

●Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting.

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server.

●Documented all work, so user can easily understand the flow of process.

Environment: MS SQL Server 2016, MS Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services, Team Foundation Server, Jira, MS Office (Word, Excel, PowerPoint), SharePoint, Tableau.

Citibank

Jan 2017 – Feb 2018

SQL Server/SSIS/SSRS Developer

Goal of the project is to get data to centralized Data warehouse and create report for users for reporting purposes.

Responsibilities:

●Created SSIS Packages to Extract, transform and load data from various sources in the Company into the Enterprise Data Warehouse.

●Extensively used derived column, union all, conditional split, audit, script, lookup, SCD, row count, fuzzy lookup and fuzzy grouping transformations in SSIS packages.

●Responsible for creating SSIS packages to load data to dimension and fact tables in SQL Server data warehouse.

●Created configuration files and enabling logging and error handling in SSIS, and using user defined variables to dynamically configure packages during runtime in SSIS.

●Experience working with SSIS Integration catalog in creating custom reports to check status of executed packages.

●Created and worked with different development environments such as Testing, Prod, Dev and so on.

●Worked in an agile scrum methodology.

●Created SSRS report for other departments in accordance to the business requirement

●Created SSRS report to help check for discrepancies between data sources and data warehouse.

●Participated in requirement gathering and backlog grooming for task to be assigned

●Created and monitor Sql Agent job to run and refresh data at the scheduled times.

●Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

●Used SharePoint for document repository and TFS for source control to store all the related work and report the same by creating Tasks in TFS.

●Created Data dictionary for the Integration packages.

Environment: MS SQL Server 2014, MS Visual Studio, Business Intelligence Development Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL, SharePoint, Team Foundation Server, Agile.

TD Bank

Aug 2014 – June 2016

SQL Server/SSIS/SSRS Developer

The project mainly dealt with creating SSIS packages, generate reports by extracting data from heterogeneous sources and checking the performance tuning of stored procedures, troubleshooting and maintenance.

Responsibilities:

●Created database objects such as tables, Views, Stored procedures, functions, triggers etc during the development of the database and to serve customized functionality as needed

●Developed codes with better performance by testing and ensuring code run at optimal while keeping in mind blocking and deadlocking situation and creating codes to avoid such scenario

●Designed and developed dynamic SSIS package to perform extract, transform and load (ETL) data across different platforms, validate the data and achieve the data files into the database

●Extensively worked with SSDT to create SSIS packages and created data mappings using different SSIS transformations such as Conditional Split, Lookup, Merge, Multicast, Slowly changing Dimension, OLE DB Command, Derived Column

●Experience working with different package configuration types such as Project Package configuration, XML configuration etc

●Created error handling on packages by redirecting errors, error Log shipping and saving error log in RDBMS

●Created Sql jobs to process packages and load data at specified times and specify certain action upon failure or success of the job

●Created object documentations to serve as data dictionary to enable other developers to understand project development life cycle

●Created control field to handle package metadata

●Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.

Environment: MS SQL Server 2012, SQL server reporting services (SSRS), SQL server integrating services (SSIS), T-SQL, Erwin.

Humana

Nov 2012 – July 2014

SQL Server/SSIS/SSRS Developer

The Project task was to implement and migrate existing database to SQL Server, especially by using integration services and Extract, Transform Load (ETL) tools. The Data warehouse built for the products helps to manage data, customer and information and is helpful in creating reports.

Responsibilities:

●Involved in writing stored procedures, Triggers, User-defined Functions, sub-queries, views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.

●Experience in creating joins for complex queries involving multiple tables.

●Created entity relationship (ER) diagram for proposed database to display the various relationships between entities.

●Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, triggers, views, indexes depending on the requirement.

●Involved in query optimization and tuning stored procedures for better performance.

●Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, Bulk insert etc.

●Configured and maintained Report Manager and Report Server for SSRS.

●Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services.

●Experience in creating ad-hoc reports Using Report Builder.

●Created stylish Report Layouts and Deployed the Reports using SSRS.

●Identified and worked with Parameters using complex expressions for parameterized reports in SSRS.

●Built the SSRS reports from Different Databases like Oracle and SQL Server.

●Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services 2010, SQL Server Reporting Services 2010, Erwin 7.2, SQL Server Profiler

Sun Trust Bank

Sep 2010 – Oct 2012

SQL Server Developer

Goal of the project is to get data to centralized Data warehouse and create report for users to report for users to creating reporting services.

Responsibilities:

●Responsible for creating database objects like Table, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.

●Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.

●Created Index to optimize performance of TSQL queries.

●Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.

●Reversed engineer backend database to change the T-SQL scripts, create Views, Index, Stored Procedures, Triggers, CTE, Constraints and UDF to improve performance drastically.

●Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.

●Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.

●Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database

●Created and modified various Stored Procedures used in the application using T-SQL.

●Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Environment: MS SQL Server 2008/2008R2, SQL Server Management Studio, MS Excel, T-SQL, SQL Server Profiler, Database Engine Tuning Advisor.

Royal Bank of Scotland

Jan 2009 – Aug 2010

SQL Data Analyst

Job Description:

The project was mainly on migration data by utilizing SSIS from database sources like Excel, MS Access, Flat File to MS SQL server and Generate Report using SSRS.

Responsibilities:

●Utilized SQL queries to access data stored in the database for analysis and data cleansing

●Perform Data Analysis, Data Profiling, Data Validation and Data Quality using SQL queries

●Arranged Findings reviews sessions with Business and IT team for potential issue counts, impact on Day 1 release.

●Created Data specification documents and Service level agreements(SLA) to ensure proper data is received

●Extracted data from data sources and created data mapping documents to support the development of database for risk modeling and reporting

●Wrote simple complex SQL queries to streamline the data

●Unified with Data Governance team the correct access and quality of data is met according to the requirement

●Created Data Mapping document and mapped the data between EDW to Staging database

●Perform SQL queries for Data Manipulation and Data Validation using SQL queries/Excel

Tools & Technologies: MS SQL Server 2008, MS Office(word, Excel, PowerPoint), Jira



Contact this candidate