Now you can Instantly Chat with Swathy!
About Me
SQL Developer with 6 years of experience in MS SQL Server, SSIS, SSRS for analyzing, designing, developing, installing, deploying and tuning. Exposure to database configuration, maintenance, monitoring, backup and recoveries. Experienced in providing... to database configuration, maintenance, monitoring, backup and recoveries. Experienced in providing technical support to client application issues in production environment. Exposure to debugging of issues occurring in SQL scripts, procedures, views. Experienced in working on T-SQL queries (DDL and DML) and expert in using stored procedures, triggers, user defined functions, joints, sub-queries, transactions, indexes and performance tuning. Experienced in using SSIS for extracting, transforming the data using fuzzy grouping, derived column, import column, character map, lookup, sort, merge, union all transformations. Knowledge of snaplogic tool and its functionalities to create pipeline for changing file format. Worked with Business Analyst to determine the best methods to approach in the process including layout of the plan on meeting business needs within the timeline. Experienced in using C# for developing console applications, windows forms and automating repetitive tasks. As part of work experience, has effectively lead the team at various capacities with team size ranging from 5-10. Experienced working on MS Excel and using the formulas on excel to manipulate data. Excellent written communication and good presentation skills. Highly motivated having a passion for research, learning new technologies and sharing knowledge by working constantly. Flexible, enthusiastic, team player with good communication and leadership skills.
Show MorePortfolio Projects
Description
Velux is a Danish company that offers manufacturing of skylights, roof windows and products for solar panels for installation in roofs.
Project Description:
The project involved automation of manual tasks performed on a daily basis, by creating executable files using basic C# .net and to create packages for data transfer to and from Database using SSIS.
Show More Show LessDescription
Schlumberger is the world's largest oilfield services company providing technology for drilling, production and processing to the oil and gas industry. Schlumberger supplies the industry’s most comprehensive range of products and services.
Project Description:
The project involved deploying and maintaining of two applications, one used by the client for processing of invoice payments uploaded by vendors, and the other being the vendor application for vendors to check the payment status of their invoices.
Show More Show LessDescription
Panalpina is a swiss company providing forwarding and logistics services. It majorly works in intercontinental air and ocean freight and supply chain management. It offers services to various industries like Hi Tech, automotive, telecom, healthcare, oil and gas.
Project Description:
The project involved supporting the retail application used by client, solving new requests, issues and deploying changes to be incorporated in the application.SQL Server 2008R2, SQL Profiler, Excel, Windows 7/8, MS Office 2010/2007
Show More Show Less