Nithya Palanisamy

Ph: +1-512-***-****

Email: advini@r.postjobfree.com

Over all 8 + years of experience as SQL Server/Business Intelligence developer in database designing, modeling, and reporting using SQL Server 2017/2012/2008/2005/2000, SSIS, SSRS.

Designing databases and ensuring their stability, reliability, and performance.

Deigned, created, and implemented database systems based on the end user's requirements. Improve application's performances.

Prepared documentations for database applications, developed database schemas, tables and dictionaries.

Ensure the data quality and integrity in databases, fixed any issues related to database performance and provided corrective measures.

Create complex functions, scripts, stored procedures and triggers to support application development, Take regular database backup.

Tested databases and perform bug fixes, Provide authentication and authorizations for Database

Developed best practices for database design and development activities.

Experience in requirement analysis, designing, coding, testing and evolution phases in a software development life cycle.

Experience in writing technical design documents and developing testing documents.

Held meetings with stakeholders to understand both technical business needs and requirements as required.

Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.

Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio SSMS.

Rich development experience in creating tables, views, triggers, stored procedures, user defined functions and other T- SQL statements.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.

Experience in extracting and transforming data using DTS, Import and Export Data wizard.

Experience in dimensional data modeling using star and snowflake schemas for fact and dimension tables using SSAS.

Experience in optimizing the database by creating various Clustered, Non-clustered Indexes.

Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.

Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision. Good understanding of Insurance, Financial and Retail domains. Expert in working with trace files and execution logs.

Highly self-motivated and excellent time management skills. Strong interpersonal and communication skills.

TECHNICAL SKILLS

Languages: VB6, SQL, Web Services - C#, C, C++

Databases: MS SQL Server (SQL Server 2017/2012/2008) MS Access.

Reporting: SQL Server 2005 Reporting Services (SSRS), salesforce

Education Details:

MCA(Master of Computer Applications)

B.SC(Bachelor of science)

PROFESSIONAL SUMMARY

Centers for disease control and prevention, Atlanta, GA July 2020-Current

Role: MS SQL Server/ Business Intelligence SSIS Developer

Responsibilities:

Working on full life cycle development (SDLC) involving in all stages of development.

Strong knowledge of relational databases, as well as skills in SQL query design and development.

Analyzes day-to-day functions and processes to ensure they are performing within predetermined guidelines, limits, and specifications.

Creating the database objects - schemas, tables, indexes, views, user-defined functions, cursors, triggers, stored procedure, constraints, and roles.

Writing the stored procedures and user-defined scalar functions (UDFS) to be used in the SSIS packages and SQL scripts.

Extensively utilizing the joins and sub-queries to streamline complex questions including different table

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.

Using DDL and DML for writing triggers, stored procedures, and data manipulation.

Designed SSIS packages to extract, transfer, load (ETL) existing data into SQL server from different environments.

Genworth Mortgage insurance Raleigh,NC (WFH) 2018 Feb -June 2020

Role: MS SQL Server/ Business Intelligence SSIS, SSRS Developer

Responsibilities:

Actively involved in interacting with front end users, business analyst to gather user requirements and online system specifications.

Documented the user requirements based on functional specifications.

Created database schema and number of database objects like tables, views, stored procedures, user defined functions using SQL Server management studio.

Involved in writing complex SQL scripts which includes transact statements, database object validation, and exception handling to facilitate functionality in different modules.

Handled errors using exception handling extensively for the ease of debugging and displaying the error messages in the application.

Created audit tables and implemented complex business logic using triggers.

Used cursors and cursors with dynamic SQL for fetching data and processing it.

Maintained the table performance by following the tuning tips like normalization, creating clustered and non-clustered indexes and collect statistics.

Created ETL packages using heterogeneous data sources SQL Server, Flat Files, Excel source files, XML files etc, and then loaded the data into destination tables by performing different kinds of transformations using SSIS.

Used different transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component and etc.

Created DTS package to schedule the jobs for batch processing.

Generated various reports with drilldowns, drill through, calculated members and dropdowns from the cubes by connecting to analysis server and SQL Server from SSRS.

Rebuilding the indexes at regular intervals for better performance, involved in trouble shooting and fine-tuning of databases for its performance and concurrency

Created subscription of reports in different formats like PDF, excel, word etc to be generated automatically on weekly or monthly basis using SSRS.

Worked on requirement analysis, coding and testing various modules in a software development life cycle

Advanced Energy Industries, Fort Collins, CO. 2016 April to 2018 Dec

Role: SQL DEVELOPER

Responsibilities:

Developed SSIS packages for different tasks like data cleansing and standardizing, sorting, conditional split, back up and involved in scheduling of SSIS packages.

Involved in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous systems using SQL tools (SSIS, Bulk Insert).

Involved in error handling of SSIS packages by evaluating error logs.

Successfully extracted transformed and load data into data warehouse.

Created reports using SSRS from OLTP and OLAP data sources and deployed on report server

Created tabular, matrix, chart, drill down reports, parametric, cascaded reports, dashboards and score cards report (SSRS) according to business requirement.

Created reports by dragging data from cube and wrote MDX scripts.

Used SSIS 2008 to create ETL packages to validate, extract, transform and load data to data warehouse, data mart databases, and process SSAS cubes to store data to OLAP databases

Improved the performance of long running views and stored procedures.

Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.

Identified slow performing views, stored procedures and queries using SQL Profiler, by running simultaneously while browsing the application.

Tuned the queries using Execution plan, to get index seek from table scan and index scan. Improved the performance of many queries by 90%.

Created Database objects including Tables, Views, Stored Procedures and UDF.

Developed User defined functions, stored procedures, indexes, Triggers.

Extensively involved in writing database scripts.

E-travel-India 2011 Oct-2015 March

Role: SQL Production Support

Responsibilities:

The tool is integrated with multiple and different categories of vendors like car vendors, flight vendors, hotel vendors so on where the user information is sent to vendors for booking then billing process is done.

Assisted in the weekly performance review and documentation.

Designed and developed UI front-end applications JavaScript, HTML5.

Used C#.NET to develop code behind logic.

Create and maintain database for Server Inventory, Performance Inventory

Working with SQL, and T-SQL, VBA

Involved in creating tables, stored procedures, indexes

Creating and Maintain users

Creating / Running jobs with packages

Design, Develop, Deploy Packages with WMI Queries

Importing Data from various sources like Excel, SQL Server,

Collecting Server Inventory data from users using InfoPath 2003/2007 into SQL Server 2005

Ensuring Data Consistency, Analyzing the Data

Generate Dash Board Reports for Internal Users using SQL Server 2005 Reporting Services

Backing up the Database

Deploy various reports on SQL Server 2005 Reporting Server

Design Reports as of User Requirements

Contact this candidate