Subramanian Guruswami

Email: ac9tgs@r.postjobfree.com: SkypeID: ac9tgs@r.postjobfree.com

Ph#: 678-***-****

LinkedIn:https://www.linkedin.com/in/subramanian-guruswami-1642438b/ Status: A citizen of USA and living in Bordentown, NJ, 08505 Professional Summary:

● Having extensive more than 9 years plus of experience Information Technology and having good experience in Database design, development, SSIS, SSRS, Administration, for very large and complex databases in SQL Server 2012, UNIX administration and knowledge in Hadoop administration.

● Extensive background in Database design and creating SQL objects - tables, Store procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.

● Very good T-SQL Programming skills.

● Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands

● Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.

● Experience in deployment procedure to create SQL scripts to make the stress-free process to DBA.

● Created complex SSIS Packages for Data Migration and Transformation.

● Experience in data migration from various sources like UNIX (CISAM files)/Access/Flat files/Excel sheets/DB2/Oracle to SQL Server 2012.

● Have Knowledge of SSIS, SSAS and SSRS with error handling.

● Experience in SQL Server Clustering and Log Shipping.

● Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem-solving skills.

● Has the ability to work in a fast-paced environment, good team player and can work independently. Helped the database developers on technical issues.

● Expertise in enhancing and deploying the SSIS Packages from development server to production server.

● Experience in deployment process using T-SQL scripts, crating step by step document and check list to simplify the DBA task.

● Experience in administrating the created reports and assigning permission to the valid users for executing the reports.

● Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.

● Experience in using DMV for performance tuning.

● Experience in Disaster Recovery Planning and Security Management operations.

● Strong experience in mentoring team members and writing documentation. Technical Skills:

Databases MS SQL Server 2008/2012, and CISAM

Programming C#, ASP .NET, CSS, HTML, C, and T-SQL

Administration SQL server 2012

Data Tools SSIS, SSRS, SSAS, DTS, Import & Export data, bulk insert Operating Systems Windows, UNIX and Hadoop

Tools Backup Utility, SQL Sentry, Visio, Connx, SQL Profiler, IDERA Network Topologies TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP Professional Experience:

Cenlar FSB, Yardley, PA Since – Feb 2019

Role: SSIS Lead / SQL Developer

Responsibilities:

● Developed SSIS Packages

● Redesign Excel Spread Sheet output to SSRS report

● Read multiple source and move the data to Data Warehouse

● Redesign complicated SSIS packages to simple store procedure

● Redesign hard coded SSIS packages to parameter-based packages.

● Fine tune slow running store procedures

● Implement large volume of tables into partition tables

● Maintaining daily DBA tasks (Indexing, statistics, storage, backup & restore, SQL agent job failures, MS SQL system errors so on)

Tmobile, Alpharetta, GA – thru RandStad Technologies Oct 2018 – Jan 2019

Role: SSIS Lead / SQL Developer

Responsibilities:

● Developed SSIS packages

● Developed deployment packages – using T-SQL scripts install ispac, create SQL agent job, execute SQL Agent job, validate the destination result set and email the result to the end user group.

● Read multiple sources and migrate into different destinations.

● Developed multiple store procedures

● Coordinate with customer and prime responsible to manage end to end data migration. Tsys, Columbus, GA - thru RandStad Technologies Sep - 2018 Role: Sr. SQL DBA / Developer

Responsibilities :

● Agile methodology.

● Prime responsible to coordinate with the off-shore team India

● Convert reports from SQL command bcp queries to SSRS reports.

● Convert traditional SQL queries using different format to SSIS packages

● Generated multi parameterized reports to allow the user to make selection before executing reports.

● Migrate SQL server database to Oracle database.

● Deployed SSIS package using package configuration to export various package properties to package environment independent.

● Managing the daily status from the team and monitor the status of the project and report to the client. Value Momentam Feb 2018 – Aug 2018

Role: SSIS Sr. Developer / Lead

Responsibilities – client Hiscox Insurance:

● Responsible to migrate legacy system called Magic using SQL server as back end and C and C++ as front end to Oracle based OneShield package.

● Prime responsible to manage the entire team off-shore and on site.

● End to end data migration responsible.

● Created and managed multiple SQL server databases.

● Managing different heterogeneous sources such as Excel, DB2, SQL server using SSIS and SSRS for reporting.

● Generated multi parameterized reports to allow the user to ability to make selection before executing reports.

● Created SSIS packages to pull data from SQL server and exported to Oracle.

● Deployed SSIS package using package configuration to export various package properties to package environment independent.

● Managing the daily status from the team and monitor the status of the project and report to the client. Automobile Protection Corporation (APCO). Jun 2012 – Oct 2017 Role: Enterprise SQL DBA

Responsibilities

● Installed and administered Microsoft SQL Server 2012 Enterprise Edition on SAN environment.

● Created and managed multiple SQL server databases.

● Created SQL objects like tables, store procedures, functions, triggers, rules, and functions.

● Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.

● Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.

● Designed and created views for security purposes, implemented rules, defaults, and user defined data types.

● Created, implemented and maintained a reporting suite of over 72 standard reports. Customized many reports to meet individual client needs.

● Created drill down, drill through, sub and linked reports as well as managed the subscription of the reports.

● Generated multi parameterized reports to allow the user to ability to make selections before executing reports; thus making them user friendly.

● Provided 24 x 7 production support for the database and application issues.

● Loading data from various sources like OLEDB, flat files to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.

● Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.

● Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

● Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

● Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

● Rebuilding the indexes at regular intervals for better performance

● Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.

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

● Coordinated with developers and testers to plan well ahead of time for production deployment.

● Monitored and modified performance using execution plans and Index tuning.

● Deploying new code base release to UAT and Production Environments.

● Perform SQL Server service pack and Windows Service pack upgrades.

● Extensively worked on Enterprise Manager for managing the database.

● Troubleshoot performance problems and fine-tuning of databases.

● Involved in Index Analysis and Performance Tuning.

● Worked with different upstream team for downloading ETL data.

● Recovering the databases from backup in disasters.

● To analyze long running slow queries and tune the same to optimize application and system performance.

● Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

● Expert in Using DMVs, Performance dash board, database snapshots and tracking Performance Counters.

● Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.

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

● Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

● Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

● Expert in implementing the snapshot isolation and DDL triggers.

● Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

● Restructuring the stored procedure, designing, coding and developing the same using the T_SQL Programming.

● Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression

(CTE).

● Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).

● Monitoring the performance issues by using IDERA third party tools.

● Monitored store procedures using SQL Sentry tools to improve the performance. Find tuned nested joins, created necessary indexes to avoid overhead.

● Fine-Tuned where clause in the store procedures to improve the performance.

● Migrated AIX UNIX to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition. Automobile Protection Corporation (APCO). July 2008 to June 2012 Role: SQL DBA

Responsibilities

● Perform business analysis, technical analysis, systems design, and application software programming.

● Prepared Entity Relationship(ER) diagrams.

● Transferring the data (ETL) from UNIX to SQL and Data warehouse using SSIS tool.

● Installed, authored, and managed reports using SQL Server 2012 Reporting Services.

● Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

● Developed, deployed and monitored SSIS Packages.

● Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

● Re-engineering Customer request in UNIX system and redesigned in SQL.

● Prepared the project management and technical documentation.

● Unit Testing the SSIS packages with respect to its flow and performance issues.

● Solving the Bugs Reflected by the Testing team.

● Rebuilding the indexes at regular intervals for better performance.

● Monitored and modified Performance using execution plans and Index tuning.

● Rebuilding the indexes at regular intervals for better performance.

● Extensively worked on DBCC commands and Dynamic Management Objects.

● Expertise in SQL Server Reporting Services.

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

● Complete documentation about the database. Recovering the databases from backup in disasters.

● Export or Import data from other data sources like flat files using Import/Export through SSIS.

● To analyze long running slow queries and tune the same to optimize application and system performance.

● To set up SQL Server configuration settings for better server management.

● Monitoring the servers using IDERA third party software.

● Worked in SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

● Managed disk space requirements and regular backup in UNIX environment.

● Involved in disaster and recovery process in UNIX environment.

● Monitored the UNIX performance and multi-platform network traffic, CPU usage in UNIX environment.

● Managed system performance maintenance process on monthly intervals in UNIX and SQL systems.

● Developed shell scripts and managed crontab in UNIX environment. Education: Bachelor’s in Business Administration,University of Madras, India. References: Will be provide upon request.

Contact this candidate