Sql Server Data

Srikanth T

PROFESSIONAL SUMMARY

A Dynamic Professional with 7 years of experience in Development and Database maintenance using MS SQL Server 2012/2008.

Experience in working various fields like Media, Banking and Retail Business services.

Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Data Extraction, Transforming and Loading (ETL) from various data sources to destinations like Excel, flat files and OLE DB Data using Connections provided by SSIS.

Experience in using control flow tasks and data flow task in SSIS.

Experience in using transformations like Aggregate, Data conversion, Lookup, Merge, Multicast, Sort and Conditional Split in SSIS.

Hands on experience working with SSIS for ETL process ensuring proper implementation of Event Handlers, Checkpoints and package configurations.

Expert in Import-Export Data and load into various Business Entities.

Good in deploying Packages to file system and Sql server.

Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and Data Transformation Services (DTS).

Expert in developing Reports like Tabular Reports and Drill down using SQL Server Reporting Services (SSRS).

Experience in developing Cascading, Parameterized and Sub reports using variables and expressions for the business users.

Good in maintenance and Administration of SSRS by creating Job schedule, SQL Mail Agent Packages.

Experience in T-SQL queries like Views, Triggers, Stored procedures, Indexes and User Defined Functions.

Expert in creating Sub-Queries and Joins for queries involving multiple tables.

Excellent technical skills with clear understanding of ER modeling for OLTP.

Hands on experience in working with project team using Waterfall Model.

Involved in Query Optimization and Performance Query Tuning using SQL Profiler.

Great understanding of Relational Database Management Systems (RDBMS).

Expertise in Data Modeling for Moderate to Large Data Systems.

Experience in working with MS SQL Server Analysis Services(SSAS) in creating OLAP cubes.

Involved in Staging Partitions and mechanisms for databases.

Experience in Database Architecture based on functional requirements and system design of the client using RDBMS concepts.

Good work ethics with excellent communication and interpersonal skills with a strong attitude towards technologies quickly supporting the project requirements.

Strong inclination for finishing job before project deadline. Flexible to adapt to new environment.

EDUCATION

Master’s in Computer Science.

SKILLSET

MS SQL Server 2012/2008/2008 R2, SQL, T-SQL, SQL Server Integration Services (SSIS) 2012/2008, SQL Server Reporting Services (SSRS) 2012/2008, MS SQL server management studio(SSMS), SQL Server Agent, Business Intelligence Development Studio (BIDS), SQL Server Analyzer & Profiler, SQL Server Data Tool(SSDT), MS SQL Server Analysis Services (SSAS), C language and Java, Operating Systems like Windows 2007/2008/2010 and other tools like MS Office.

PROFESSIONAL EXPERIENCE

Dentsu Aegis Network, New York 05/2015 – Current

SQL Server BI Developer (SSIS/SSRS)

A global media group that specialises in Media, Digital and creative Communications services, Project is about Designing and Developing Enterprise Data Warehouse (EDW), Extracted data from the different sources and loaded that data in data warehouse and created various Reports.

Responsibilities:

Developed ETL using SSIS including data extraction and transformation between multiple data sources and destinations (MS Excel, OLE DB and Flat file).

Worked extensively on configuring the transformations like Aggregate, Data conversion, Merge, Union all and Sort in SSIS.

Performed data conversions from Flat files into a Normalized database structure.

Transformed data into SQL server database using OLE DB connection by creating various SSIS packages.

Worked on creating SSIS packages by deploying them to the Sql server and executing the Packages in Development.

Designed ETL Jobs/Packages using SQL Server Integration Services SSIS and troubleshot Packages using Event Handler and Logging.

Developed various types of Reports like Tabular Reports and Drill Down reports using SSRS.

Developed Cascading, Parameterized and Sub reports using variables and expressions for the business users.

Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2010.

Created Stored Procedures, Indexes, Constraints and User Defined Functions.

Created views to facilitate easy user interface implementation.

Involved in developing triggers to audit schema changes at the database level.

Monitored performance and optimized SQL queries for maximum efficiency.

Worked on writing the insert, update and delete queries, joining multiple tables to make changes in the tables.

Environment: MS SQL server 2012, Microsoft SQL Server Management Studio(SSMS), T-SQL, SQL

Server Data Tools (SSDT), Microsoft Visual Studio for SQL Server Integration Services (SSIS) 2012 and SQL Server Reporting Services (SSRS) 2012 and MS Excel.

People's United Financial, Bridgeport, CT 01/2014 – 04/2015

MS SQL BI/ETL Developer:

The project involved building a data repository to organize loan documents that are received from customers, the project aims at integrating data in Integrating Services and generate reports of the customers.

Responsibilities:

Worked on ETL in creating SSIS packages, building, deploying and executing the packages in the environment.

Designed and tuned ETL packages which utilized tasks such as Data Flow Task, Sequence Containers like For Each Loop Container and For Loop Container to load several folder into databases.

Worked on import & export of data from Text to SQL Server in SSIS.

Worked with various sources in the data flow tasks and used various transformations like Aggregate, merge, multicast, data conversion, sort and conditional split

Performed data conversions from flat files into a normalized database structure.

Troubleshoot ETL Packages and read Logging files to solve the issues of package failure.

Created tabular, drill down reports using SSRS 2010 for Sales department.

Involved in deploying of requested Reports.

Generated daily, weekly and monthly reports as per the customer requirements using subscriptions and maintained the snapshot history.

Developed numerous ad-hoc reports using SSRS for day to day financial reporting

Created Views to reduce database complexities for the end users.

Created Constraints, Written and executed T-SQL queries like Stored Procedures and Triggers using SQL Server Management Studio.

Worked on import & export of data from Text, Excel to SQL Server.

Environment: MS SQL server 2012, T-SQL, MS SQL Server Data Tools (SSDT), Visual Studio 2012 for SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL server management studio(SSMS), SQL Server Agent and MS Excel.

NRG Energy Inc, Houston, TX 08/2012 – 12/2013

MS SQL BI /ETL/SSRS Developer:

NRG Energy Inc., together with its subsidiaries, operates as a power company. The company provides electricity, system power and various energy services. The project was the data retrieved from the source was loaded to the data warehouse for report generation after implementing with the logic in ETL.

Responsibilities:

Created SSIS Packages to migrate slowly changing dimensions.

Extracted Data from various sources like flat files to SQL Server database Using SSIS Package.

Used various loop Containers in SSIS for Control Flow.

Designed ETL Jobs/Packages using SQL Server Integration Services SSIS and troubleshot Packages using Event Handler and Logging.

Maintained existing and created new relational and OLAP data warehouses using ETL processes.

Created tabular, drill down and parameterized reports using SSRS.

Experience in creating snapshots of static reports and configure subscription.

Created new database objects like Triggers and Views using T-SQL in SQL Server 2012/2008.

Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.

Created views to facilitate easy user interface implementation.

Created indexed views and appropriate indexes to reduce the running time for complex queries.

Tested the Installation of SQL Server.

Used Query Analyzer to optimize SQL queries.

Involved in creating ER diagrams and mapped the data into database objects.

Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.

Experienced in Developing SSAS Cubes and Deploying and Processing SSAS objects.

Environment: SQL server 2012/2008 R2, T-SQL, SQL Server Integration Services (SSIS) 2012, SQL Server Reporting Services (SSRS) 2012, SSMS and MS Excel.

Lowes, San Francisco, CA 01/2011 – 07/2012

SQL Server Developer (SSIS/SSRS)

Lowes is one of the biggest Home-improvement chains for appliances, gardening tools and much more. The project was focused mainly implementing a data warehouse, which would drive the reporting systems and carried out in business to support effective decision-making.

Responsibilities:

Involved in data warehouse and ETL development.

Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.

Worked with various containers in the control flow task such as For Loop, For Each Loop.

Extracted and reviewed data from heterogeneous sources like (Excel, flat file, Text Format Data) using SQL (SSIS).

Created SSIS packages using term extraction, execute SQL task to generate underlying data for the reports and to export cleaned data, excel spread sheets, text files to data warehouse / Oltp DB.

Created various SSIS packages by extracting data from various sources according to the requirements.

Generated various reports like Cascade type reports and Drill down reports.

Created sub-reports, tabular, parameterized and reports.

Designed and developed Cubes using SQL Server Analysis Service (SSAS) 2008R2.

Environment: SQL server 2008 R2, T-SQL, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, SSMS, SQL Server Analysis Services (SSAS) and MS Excel.

ING Group Hyderabad, India 07/2009 – 12/2010

SQL Server Developer

It is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. Maintains users checking and saving account information, allows users to make a payment and transfer funds.

Responsibilities:

Created views to facilitate easy user interface implementation.

Created Business stored procedures and functions to support efficient data storage and manipulation.

Involved in developing triggers to audit schema changes at the database level.

Worked on improving the performance of the system.

Monitored performance and optimized SQL queries for maximum efficiency.

Making a Report as per user requirement using MS Reporting Services.

Created sub-reports to present more detailed information about the summary.

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.

Environment: SQL server 2008 R2, T-SQL, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, SSMS and MS Excel.

Contact this candidate