Sr. Sql Dba / Ssrs / Ssis Resume
Plano, TX
SUMMARY
- Over 8 years of experience with MS SQL Server 2012/2008/2005/2000 and worked extensively on Integration services (SSIS), Reporting services (SSRS) and Analysis services (SSAS).
- Experience in installation, up gradation and configuration of MS SQL Server database.
- Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
- Extensive experience with SQL Server and T - SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries and data integrity.
- Good experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server Clustering.
- Experience in developing Custom Reports and different types of Tabular, Matrix, Ad-hoc and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) also expertise in working with Crystal Reports.
- Experience with creating Linked Servers for connecting servers at remote site locations and then querying the group of servers using T-SQL statements.
- Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor
- Logical Data Modeling using ER-Win to fit business requirements.
- Experience in solving dead Locks/Long running queries using Performance Monitorand SQL Profiler.
- Experience in creating dashboards, scorecards and building reports using performance point server 2007.
- Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
- Extensive experience in Monitoring, tuning and analyzing and allocating server resources to achieve optimum data base performance.
- Migrated Organization, Orders, Adjustments, Objectives and data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
- Experience in building Data Integration, Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting by customizing URL Access.
- Experience with Adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
- Creating the Cubes, Dimensions building, deploying, processing and maintaining Cubes using SQL Server Analysis Services (SSAS).
- Experience in integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
- Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
- Good understanding of Object Oriented Analysis and Design (OOAD), Joint Application Development (JAD) and Software Development Life Cycle (SDLC).
- Worked with preparing the documentation for GAP analysis, Technical Specification documents, Functional Specification documents, mapping documents etc, for various migrations and up gradation projects.
- Excellent Communication, leadership, team player, creative and a quick learner.
PROFESSIONAL EXPERIENCE
Confidential, Plano, TX
Sr. SQL DBA / SSRS / SSIS
Responsibilities:
- Managed databases, backup and recovery, schema maintenance, performance tuning, performance monitoring, design and implementation.
- Managed various internal applications using SQL SERVER 2012.
- Set up efficient monitoring of SQLServer jobs to ensure that failures are reported immediately.
- Implementation of SQLLogins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Optimized T-SQLstored procedures to improve performance preserve referential integrity and provide application functionality.
- Configured SQL Mirroring, Log Shipping and Replication.
- Designed and created databases, tables, views, store procedures and triggers and rebuilding the indexes at regular intervals for better performance. Developed file loading process by creating complex stored procedures, functions.
- Involved in troubleshooting the performance issues like memory pressure, High CPU utilizations and Disk IO’s at SQL Server level.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.Maintained transactional replication on production SQLServers and maintaining the database consistency with DBCC at regular intervals.
- Worked as a SQL developer/DBAfor inventory application which involved design and development of database, stored procedures and SQLqueries. Created Database Maintenance Plans for the performance of SQLServer which covers Database Integrity checks, update database Statistics and Re-indexing.
- Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
- Experienced in providing trend analysis to the service management team to enable them to make informed decisions regarding resource management.
- Created Ad Hoc reports and assisted users in building the reports using SSRS report builder.
- Query and mine large data sets to discover transaction patterns, examine data and filter for targeted information - using traditional as well as predictive/advanced analytic methodologies
- Created SSIS packages to transfer data from OLTP data base to Data warehouse.
- Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
- Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE).
Confidential, Cincinnati, OH
SQL SSRS Developer
Responsibilities:
- Design, deploy, and maintain various SSRS Reports using SQL Server Data Tools.
- Published reports into Viewpoint an application used by Construction Companies.
- Created Custom Reports for Accounts department including Job Cost and Billing using SSRS.
- Converted Crystal reports into SSRS 2012.
- Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2012.
- Designed different kinds of reports like Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through Reports.
- Designed and developed different Tabular Reports, Matrix Reports and Sub Reports.
- Analyzed code behind the existing Crystal Reports and implemented similar logic for SSRS reports and did the required enhancements as necessary.
- Created many Shared Data Sets that will be used by many different reports analyzing the existing Crystal Reports.
- Developed DDL Scripts for generating Tables, Views, and Functions in SQL Server 2012.
- Configured Internet Information Services (IIS) and Deployed Reports in to server.
- Created complex Stored Procedures some of those involving Dynamic SQL.
- Used SQL Profiler to monitor and troubleshoot performance issues in T-SQL code and stored procedures.
- Performed extensive Testing after building the reports such that they meet all the requirements and look alike Crystal Reports.
Environment: MS SQL Server 2012, SQL Server Management Studio (SSMS) 2012, SSRS-2012,SQL Server Profiler, SQL Server Data Tools, SQL Analyzer, Enterprise Manager and SQL Server Agent, Crystal Reports 2008 and Viewpoint.
Confidential, Richmond, VA
SQL SSRS Developer
Responsibilities:
- Design, deploy, and maintain various SSRS Reports in SQL Server 2008.
- Involved in the preparation of Actual FTE and Budgeted FTE Trends, Variances and Forecast Reports using SSRS.
- Converted MS Access reports into SSRS 2008.
- Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.
- Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel format using SSRS 2008.
- Designed different kinds of reports like Linked, cascaded and parameterized reports and worked on Drill Down and Drill-through Reports.
- Constantly worked with the Data Layer Team in order to design the Hierarchy appropriately to achieve the reports more efficiently.
- Designed and developed different Tabular Reports, Matrix Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reportsusing various features like Charts, graphs, filters etc.
- Integrated multiple MS Access reports in to one single SSRS report.
- Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
- Developed DDL Scripts for generating Tables, Views, and Functions in SQL Server 2008.
- Configured Internet Information Services (IIS) and Deployed Reports in to server.
- Used SQL Profiler to monitor and troubleshoot performance issues in T-SQL code and stored procedures.
- Created number of standard reports and complex reports to analyze data using Slice & Dice and Drill Down, Drill through using SSRS.
- Performed extensive Testing after building the reports such that they meet all the requirements and look alike MS Access Reports.
Environment: MS SQL Server 2008, SQL Server Management Studio (SSMS) 2008,SSIS-2008, SSRS-2008,SQL Server Profiler, Visual studio 2008, SQL Analyzer, Enterprise Manager and SQL Server Agent, MS Access, VB 6.
Confidential, Nashville, TN
SQL SSIS Developer
Responsibilities:
- Created complex SSIS Package using Script Task, For Each Loop, Derived Columns, Fuzzy Lookup, Condition Split, Sort, Union All, Execute SQL Task, Data Flow Task and File System Task etc., wrote complex stored procedures depending on the requirement.
- Created and developed database objects such as Tables, Views, Procedures, Functions, Triggers and T-SQL code with proper grants to all the users and roles using SSMS 2008.
- Resolved complex issues that affected the performance using query optimizer to improve the performance of the slow running queries and stored procedures.
- Used various data transformations like Conditional Split, Script Component, Derived Column, Sort, Merge Join and Data Conversion etc.
- Used BI documenter to prepare database documentation.
- Modified existing codes and packages depending on the requirement.
- Performed performance tuning by studying Execution Plan, Analyzing Indexes.
- Designed Dynamic Connection Managers that depend on the Expressions based on the Variables.
- Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
- Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
- Created Views, Parameterized Views, Partitioned Views and Indexed Views.
- Involved in extracting the data using SSIS from OLTP to OLAP.
- Worked on the Audit Logs that capture the audit details before and after the package execution using Variables and Parameters.
- Extensively worked with Parameters and Variables.
- Followed Agile methodology and attended Scrum meetings, discussed and analyzed the requirements and road blocks.
Environment: MS SQL Server 2008, SQL Server Management Studio (SSMS) 2008, SSIS-2008, SQL Server Profiler, Visual studio 2008, SQL Analyzer, Enterprise Manager and SQL Server Agent.
Confidential, Nashville, TN
SQL SSIS Developer III
Responsibilities:
- Created complex SSIS Package using Script Task, For Each Loop, Derived Columns, Condition Split, Sort, Union All, Execute SQL Task, Data Flow Task and File System Task etc., to load different tables based on different file extensions, to generate .CSV files based on the Views that extracted data from the above loaded tables and trigger a different package upon Validation Failure.
- Created SSIS package to extract huge data from Data Ware House into the tables on a different server depending on the requirement using Views and Temp Tables.
- Used query optimizer to improve the performance of the slow running queries and stored procedures.
- Designed and developed SSIS Packages to import and export data to and from SQL Server 2008 and Flat files.
- Experience in writing VB scripts in script component task that can discriminate the files based on the file extensions, capture the file names in a variable that is later used in Send Mail Task.
- Used SQL Profiler for monitoring and troubleshooting performance issues in slowly executing T-SQL code and stored procedures.
- Archiving the processed files by using File System Task.
- Designed Dynamic Connection Managers that are built on the fly depending on the Expressions based on the Variables.
- Created a Configuration Table where the Connection Managers depend on the Values from the Configuration Table.
- Worked on various other small projects that required modifications to the Existing Packages.
- Did extensive Testing on inbound Data and Updates and Inserts in the Database Tables.
- Created Test Files that do not validate according to the requirements to analyze the process.
- Extensively worked with Parameters, Variables and Variable Properties like using the Connection String property of a Variable to make the process Dynamic.
- Active participation in the Business Requirement Meetings with the off shore client that led to the successful completion of a complex process.
- Replicated the entire process to run parallel both in the Development and Production Environment.
Environment: MS SQL Server 2008, SQL Server Management Studio (SSMS) 2008, SSIS-2008, SQL Server Profiler, Visual studio 2008, SQL Analyzer, Enterprise Manager and SQL Server Agent.
Confidential, St. Charles, MO
SQL SSIS/SSRS Developer
Responsibilities:
- Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
- Created indexes on the columns recommended by query optimizer to improve the performance of the slow running queries and stored procedures.
- Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
- Worked on the Audit Logs using Variables and Parameters.
- Involved in installation and configuration of SQL Server 2008 with latest Service Packs.
- Extracted data from various sources like DB2, Oracle, Flat files, and XML files and Loaded in to Fact and Dimension tables of data warehouse.
- Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
- Used different Transformation in SSIS as per design specifications.
- Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
- Worked with building the hybrid data integration to SQL server 2008 where the data source were Access, Excel, Oracle from SQL server 2000.
- Migrated DTS packages to SSIS packages and modified the packages with new features of SQL 2008 SSIS.
- Designed, developed and implemented the Dimension Data Model through multiple expert interviews for multiple fact tables.
- Configured Internet Information Services (IIS) and Deployed Reports and Analysis Project in to server.
- Developed different kinds of reports and created Drill Down and Drill-through Reports for summary and detail data.
- Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
- Used SQL Profiler for monitoring performance issues in T-SQL code and stored procedures.
Environment: MS SQL Server 2008/2000, SQL Server Management Studio(SSMS) 2008,SSIS-2008,DTS-2000,SSAS, VB 6, OLAP, OLTP, Load Runner,SSRS-2008,SQL Server Profiler, Visual studio 2005, SQL Analyzer, Enterprise Manager and SQL Server Agent.
Confidential
SQL Server Database developer
Responsibilities:
- Created and maintained database objects, complex Stored Procedures, Triggers, Cursors, and Tables, Views, SQL Joins and other statements for various applications using SQL Server 2005/2000.
- Performance Tune the Stored Procedures, User Defined Functions and long running queries.
- Created ETL in DTS packages by using Data Transform Task, VBScript task, SQL task and send Email task to migrate data from different functional databases into SQL Server 2005, which hosts the ERP system by using DTS Packages.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
- Maintained records in Excel Spread Sheet and exported data into SQL Server Database using SQL Server Integration Services (SSIS).
- Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
- Used SQL Server Reporting Services (SSRS) for creating, editing and scheduling various reports.
- Designed and developed Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reportsusing various features like Charts, graphs, filters etc.
- Designed and created Report templates, bar graphs and pie charts based on the financial data.
- Formatted the reports using Global variables, Expressions and Functions using SSRS 2005.
- Involved in development and modification of existing Financial Reports and Marketing Reports which include Corporate Consolidation Reports, Financial Reports and Planning Reports for management.
- Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing.
- Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
Environment: MS SQL Server 2005/2000(64 bit edition), DTS-2000, Microsoft Visual Basics 6, OLTP, SSIS-2005, SSRS-2005, SSAS, Microsoft Business Intelligence Development Studio(BIDS), VB 6 Scripts, Office, Excel.
