SSIS/SSRS/T-SQL Developer Resume Nashville, TN - Hire IT People (2025)

Ssis/ssrs/t-sql Developer Resume

0/5 (Submit Your Rating)

Nashville, TN

Hire Now

SUMMARY

  • Over 7 years of professional IT experience in System Design, Development and Support of Microsoft SQL server in Development.
  • Professional programming experience in SQL, Oracle, Oracle Forums and Reports, Oracle Transportation Management (OTM).
  • Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC) and capable of handling responsibilities independently as well as a proactive team member.
  • Strong experience in MS SQL Server with SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
  • Developed interactive reports using SQL Server Reporting Services.
  • Excellent command over managing Alerts, Operators and Jobs through SQL Server Agent.
  • Strong knowledge of creating Tables, Views, Indexes, Replication, and other SQL joins and query writing.
  • Experienced in strategically implementing the indexes such as Clustered index, Non - clustered index, covering index appropriately on data structure to achieve faster data retrieval.
  • Expert at creating reports using SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) 2008/2005.
  • Excellent experienced in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility, SQL Replication and Log Shipping.
  • Experienced in Designing, Developing and Maintaining Web Applications using Visual.
  • Experienced in creating many complex SSIS packages using SQL Server Integration Services (SSIS)
  • Ability to work on ETL, data modeling and data warehousing using Business Intelligence Development Studio (BIDS).
  • Worked extensively in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and database Engine Tuning Advisor.
  • Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

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

BI Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS).

Databases: SQL SERVER 2008 R 2/2008/2005/2000 , MY SQL, Oracle 10g and DB2,MS-Access

Languages: C, C++,T-SQL, PL SQL, Java

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

Operating Systems: Windows 95/98/2000/2003/ XP-Pro, Windows NT, Windows XP, UNIX, Windows 7

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

SSIS/SSRS/T-SQL Developer

Responsibilities:

  • Created logical and physical database design, data structures and maintained it by using SQL tools like Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic, Microsoft TFS and CRM/XRm.
  • Designed and implemented complex database architecture.
  • Designed SSIS strategies to pull data from different sources, like SQL server, flat files and load it to the destination database.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Optimize existing T-SQL code.
  • Optimized the database by creating various clustered, non-clustered indexes and indexed views.
  • Converting VSAM(Legacy System) Flat Files to SQLSERVER Destination using SSIS Package.
  • Utilize Dynamic T-SQL within functions, stored procedures, views, and tables.
  • Configured Dynamic SQL at different levels of replication server component like server level, connection level and table level.
  • Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system.
  • Implemented backup strategy for critical database backups to Implemented Sql database maintenance plans for production servers.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
  • Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
  • Developed many asp.net web applications using SQL Server and C#, to provide solutions for companywide needs.
  • Developed Master/Detail Reports and Tabular reports based on the user requirements using Crystal Reports.
  • Developed reports using SSRS 2005 and Crystal reports. Used table control, matrix control for cross tab reports.
  • Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
  • Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
  • Return the custom code in Reports to avoid the case statement in the SQL stored procedure.
  • SSIS Packages are created to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Diagnosing and tuning the server optimal performance using SQL Server 2005’s Dynamic Management Views (DMV), Profiler and Index Tuning Wizards

Environment: SSRS, SSIS, MS SQL Server 2008,T-SQL, Windows 2003,C#,VSS 2005,XML,MS Access, MS Sharepoint,ASP.NET, MS Office Access 2003, VBScript, ER-Win,VB6,Crystal reports 7.5 .

Confidential, Louisville, KY

SQL Server Developer

Responsibilities:

  • Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
  • Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
  • Wrote DDL, DML statements for processing of daily activities.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Responsible for upgrading and migrating of various applications in Access to SQL Server 7.0.
  • SQL Server Administration involving planning and implementing Backup and Recovery Strategies
  • Configuring the standby servers and setting guidelines to automate recovery scenarios
  • Implementation of data transfer through DTS
  • Monitoring and fine tuning of SQL Server performance and ensuring integrity
  • Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures
  • Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs
  • Created Stored Procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data
  • Involved performance tuning using indexing (Cluster Index, Non Cluster) tables.

Environment: T-SQL, SQL Server 2000, Windows 2000 Server, SSIS, SSRS, SSAS, Query Analyzer, DTS,MS Access 2000.

Confidential, San Antonio, TX

MS SQL Server/ SSIS/SSRS/SSAS Developer

Responsibilities:

  • Developed technical specifications and analyzed business needs with managers and development Teams.
  • Build procedures to extract, transformation and Load data in SQL Server 2000/2005/2008 using DTS packages to import/export data feeds to/from data warehouse.
  • Worked withT-SQLtocreateTables, Views, Triggers and Stored Procedures.
  • Participated in migration from SQL Server 2005 to SQL Server 2008.
  • Used SQL Server Reporting Services to migrate and convert crystal Reports into SSRS.
  • Used data mapping for all the migrated jobs using SSIS.
  • Involved in tuning of Stored Procedures and query optimization for the improvement of deadlock situations and hang-ups on server.
  • Imported XML data files and put into the desired database.
  • Used Data Manipulations to optimize the performance, which includes modification of T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing table, establishing Joins and creating clustered/non-clustered indexes where necessary.
  • Worked on formatting the SSRS report using Global variables and expressions.
  • Developed query for generating drill down reports using Reporting Services.

Environment: MS SQL Server 2008, Windows Server 2003, SSIS, SSRS, SSAS, T-SQL.

Confidential

MS SQL Server Developer

Responsibilities:

  • Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
  • Developed various T-SQL stored procedures, triggers based on the requirement.
  • Defined Check constraints, Business Rules, Indexes and Views.
  • Imposed Referential Integrity of data by creating different constraints.
  • Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS various features like multi-tasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.
  • Created derived columns from the present columns for the given requirements.
  • Performed development support, document reviews, test plan, integration of the system.
  • Creation/ Maintenance of Indexes for various fast and efficient reporting processes.
  • Managing historical data from various heterogeneous data sources (i.e. Excel, Access).

Environment: T-SQL, SSMS, SSIS, SQL Server and Microsoft Visual Studio, XML, MS Access

Hire Now

Report an issue

Privacy Policy
Resume Categories
  • .NET Developers/Architects Resumes
  • Java Developers/Architects Resumes
  • Informatica Developers/Architects Resumes
  • Business Analyst (BA) Resumes
  • Quality Assurance (QA) Resumes
  • Network and Systems Administrators Resumes
  • Help Desk and Support specialists Resumes
  • Oracle Developers Resumes
  • SAP Resumes
  • Web Developer Resumes
  • Datawarehousing, ETL, Informatica Resumes
  • Business Intelligence, Business Object Resumes
  • MainFrame Resumes
  • Network Admin Resumes
  • Oracle Resumes
  • ORACLE DBA Resumes
  • Other Resumes
  • Peoplesoft Resumes
  • Project Manager Resumes
  • Quality Assurance Resumes
  • Recruiter Resumes
  • SAS Resumes
  • Sharepoint Resumes
  • SQL Developers Resumes
  • Technical Writers Resumes
  • WebSphere Resumes
  • Hot Resumes

SSIS/SSRS/T-SQL Developer Resume Nashville, TN - Hire IT People (3)

  • Contact
  • Schedule A Meeting
  • Franchise Opportunity
  • Suppliers
  • LCA Posting Notices
  • Hire IT Global, Inc - LCA Posting Notices
  • Electronic PERM posting Notice
Client Services
  • IT Staff Augmentation
  • Hire Programmers
  • Government Services
  • IT Project Management
  • Industry Expertise
  • Resume Database
Job Seekers
  • Browse Jobs
  • Upload Resume
  • Employee Benefits
  • Resume Marketing
  • Us Citizens/Green Cards
  • Visa Sponsorship
  • Employer on Record Services (EOR)
  • Forms Checklists
Visa Sponsorship
  • H1B Visa Transfer
  • E3 Visa Sponsorship
  • TN Visa Sponsorship
  • EB3 to EB2 Porting
  • Green Card Sponsorship

Loading, Please wait...

SSIS/SSRS/T-SQL Developer Resume Nashville, TN -  Hire IT People (2025)
Top Articles
Latest Posts
Recommended Articles
Article information

Author: Ouida Strosin DO

Last Updated:

Views: 5937

Rating: 4.6 / 5 (76 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Ouida Strosin DO

Birthday: 1995-04-27

Address: Suite 927 930 Kilback Radial, Candidaville, TN 87795

Phone: +8561498978366

Job: Legacy Manufacturing Specialist

Hobby: Singing, Mountain biking, Water sports, Water sports, Taxidermy, Polo, Pet

Introduction: My name is Ouida Strosin DO, I am a precious, combative, spotless, modern, spotless, beautiful, precious person who loves writing and wants to share my knowledge and understanding with you.