Software Engineer Sql Server

SHAIK AZMEER

Email: *************@*****.*** Phone: +91-970*******

Summary:

Having 2.5 years of experience in Software Development of analysing problems, developing and simplifying procedures and finding innovative solutions.

Extensive experience with SQL Server and T-SQL in constructing Procedures, triggers, Tables, Table variables, user defined functions, views, indexes, CTE, temp tables, relational database models.

Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2005/2008/2012.

Good Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views

Strong knowledge in Dynamic SQL (sp_executesql, exec).

Good Knowledge on Executing Batch Files and Bulk Insert.

Strong Knowledge in SQL Commands like (DDL, DML, DCL, TCL), Operators.

Attaching and detaching databases for memory usage.

Having experience in using the SQL Server 2005 & 2008 and 2012 Business Intelligence Development Studio (BIDS).

Generating reports like Drill down reports, Drill through reports, Sub reports using SSRS

Experienced in RDBMS concepts like Stored Procedures, Functions, Triggers and Views.

Performance tuning.

Configured jobs to make periodical backups.

Knowledge in BCP commands & Bulk Insert commands.

Experts in generating drill down reports, drill through reports, sub reports, matrix reports, and chart reports by using SSRS.

Backup and Restore the database file.

Having Experience to implement the business logic using Triggers, Indexes, Views and Stored procedures.

Skill Set:

Languages

SQL, T-SQL

Technologies

Microsoft Business Intelligence (MSBI)

Operating Systems

Windows 8.1,Windows 7, Windows XP, Windows 2003

DBMS

SQL Server 2005, 2008 R2, 2012

ETL Tools

SQL Server Integration Services

Reporting Tools

SQL Server Reporting Services, Report Builder

Education Qualification:

B.Tech from Jawaharlal Nehru Technological University, Ananthapur.

Professional experience:

Working as a Software Engineer for Stack edge IT Services Pvt Ltd. Hyderabad from March 2016 to Aug 2017.

Working as a Software Engineer for Clover Infotech Pvt Ltd. Bangalore from Aug 2017 to till date.

Project Details:

Project Name : Merc (Micro finance )

Platform : SQL 2012,SSRS,SSIS

Technologies used : SQL Server 2012,200R2.

Team Size : 12

Project Period : Aug 2017 To Till Date

Description for Merc (Microfinance EMI Receipting console):-

Microfinance is to allot very small loans to poor people with the aim of aiding them to start their own enterprises so as they can come out of poverty. That is microfinance is not a hand out, instead it is a hand up that permit the poor, mostly women, to attain continuous financial triumph.

Small amounts of loans and savings.

Short- terms loan (usually up to the term of one year).

Payment schedules attribute frequent installments (or frequent deposits).

Installments made up of both principal and interest, which is amortized over the course of time.

Short processing periods (between the completion of the application and the disbursements of the loan).

Manage our database system and client Requirement as well.

Fixe the issue in the database and Resolve the problem.

Database migration for LMS as well as DMS system.

Create the Newly Financial Report as per Requirement for business purpose, procedures, functions, tables and SSIS Packages as well.

Having working experience in migration.

Good knowledge in Loan management systems.

Configured jobs to make periodical backups.

Reviewing and Execution of Test Cases.

Generating reports like Drill down reports, Drill through reports, Sub reports using SSRS.

Designed and Implemented Backup strategy.

Creating different steps in scheduling of the various jobs like Database backups.

Setting up Production, Testing and UAT Environments.

Bug fixing.

Responsibilities:

Writing complex stored procedures, triggers, functions and views.

Involved in Index operations (Rebuild & Reorganize) and database maintenance.

Performance tuning.

Developed Dynamic SQL queries and results with manipulated data.

Coordinating the Developing activities with the development team and QA team

Enhancements of the existing code according to client requirements.

Configured jobs to make periodical backups.

Writing Adhoc queries for migration and Report Purpose.

Responsible for development of Procedures, Functions and database Triggers.

Created indexes and analyzed its role for optimizations.

Creating various types of reports like drill down, drill through, sub reports.

Reviewing and Execution of Test Cases.

As per requirements developed the reports in the form of Matrix and Table.

Generating reports like Drill down reports, Drill through reports, Sub reports using SSRS.

Designed and Implemented Backup strategy.

Creating different steps in scheduling of the various jobs like Database backups.

Implemented the business logic using Triggers, Indexes, Views and Stored procedures.

Changed the Procedures and Created indexes on tables to increase the application's performance (Manual performance Tuning).

(SHAIK AZMEER)

Contact this candidate