SQL developer Resume Houston, Tx - Hire IT People

SUMMARY

Server Developer with 4 plus years of experience in professional application and database development with thorough knowledge of different phases of software development lifecycle including analysis, design, development, documentation, deployment and system support
Experience in designing of the database in SQL Server.
Hands on experience in writing T - SQL queries, Stored Procedures, User Defined Functions (UDF), Cursors, Derived Tables, Views, and Triggers.
Working on full life cycle development (SDLC) involving in all stages of development.
Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure.
Worked on creating complex database queries using SQL queries, Stored Procedures, Functions, Views, Indexes and Triggers in SQL Server
Extensively utilizing the joins and sub-queries to streamline complex questions including different table.
Worked on creating custom reports with integration and reporting services as SSIS, SSRS and worked on executing report programmatically from FOM Windows service and reports are places at FTP location and an email confirmation with report is sent to customer.
Developing the tabular queries for efficient analysis of report using pivot/unpivot in T-SQL.
Creating and managing the clustered indexes and non-clustered indexes and optimized queries using execution plan.
Creating action filters, parameters and calculating the sets for preparing dashboards and worksheets in Tableau .
Creating dimension model for reporting system by identifying required dimensions and facts using Erwin.

TECHNICAL SKILLS

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Microsoft Visual Studio

Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Databases: SQL Server 2019/2014/2008 R2

Programming Languages: T-SQL, C# .Net, Java, HTML5.

Development skills: T-SQL, SSIS/SSRS/SSAS.

Operating Systems: Windows, UNIX.

Technologies: MSSQL

PROFESSIONAL EXPERIENCE

SQL developer

Confidential, Houston, Tx

Responsibilities:

maintaining customer information and ensuring efficient data retrieval as required for care decision making.
Writing stored procedures, triggers and monitoring performance to ensure efficient data retrieval. understanding of client functional requirements and participating in writing functional specs.
Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data working on SQL Loader to load data from flat files from various facilities every day
Creating and modifying server Unix Shell scripts according to the changing needs of the project and client requirements.
Writing Unix shell scripts to process the files on a daily basis like renaming the file, extracting the data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.

Environment: SQL Server 2018, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS, VB.Net, Erwin, MS Excel, XML, SQL Profiler.

SQL developer

Confidential, Westchester, IL

Responsibilities:

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Developed PL/SQL triggers and master tables for automation creation of primary keys.
Created Pl/SQL stored procedures, functions, and packages for moving the data from the staging area to the data mart.
Created scripts to create new tables, for fast retrieval of data to enhance database performance.
Supported, maintained and enhanced existing financial software, and patriate in user training
Monitored performance and managing parameters to provide fast responses to front-end users considering back-end organization of data
Worked with DevOps team to set up and maintain database servers

Environment: SQL Server 2014, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), IIS, VB.Net, XML, Team Foundation Server, Unit Testing, Visual Studio 2015 MS Excel, SQL Profiler

We provide IT Staff Augmentation Services!

Sql Developer Resume

Houston, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship