Govarthanan V.

ABOUT ME

 Over 4 years of IT experience in SQL Database Development, MSBI Development, Design, Administration & Support of MS SQL Servers 2014,2012 and 2008 R2 in Production, QA, Reporting Services, Development environments & Replication.
 Experience in MS-SQL Server 2008 R2,2012,2014,2016
 Experience in Installation, Configuration, Maintenance and Administration of SQL Server.
 Extensive experience in writing stored procedures, functions and views.
 Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS Packages.
 Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
 Extensive experience in writing and tuning complex sub queries, stored procedures, functions, and triggers.
 Experience in troubleshooting SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
 Ability to create SSIS Packages using various Transformation like Lookup, Derived Columns, conditional Split, Data Conversion, Aggregate, Merge, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. To generate underlying data for the reports and to export cleaned data from Excel Spreadsheet, Flat file and CSV files to data warehouse.
 Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks, Data Acquisition and Data Modelling.
 Experience in Migration from SQL Server to MySQL Server.
 Experience in SQL Server Reporting Services (SSRS) & SQL Server Integration Services (SSIS).
 Good Experience in Creating Different Reports like Drill through Dashboard Reports, Drill down Reports, Ad hoc Reports and Chart Reports.
 Demonstrate strong ability of Extraction, Transformation and Loading ETL processes to acquire and load data from internal and external sources using SSIS, Import Export, BCP and Bulk Insert.

SKILLS