Akash N.

•3.3 years of IT Experience as Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence Development Studio (MSBI), SQL Server Data Tools (SSDT). •Expertise in writing complex and dynamic queries using joins and sub queries. •Expertise on temporary table, table variable, CTE and derived tables. •Expert in performing T-SQL DDL/DML/DCL commands using SQL Server Management Studio SSMS. •Expertise in performing backup and restore. •Expertise in scripting Views, Complex Stored Procedures, User Defined Functions (UDF) and Database Triggers. •Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2012 and 2016. •Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations. •Experience in performing error handling in stored procedure by using try catch block. •ETL implementation by using SQL Server Integration Services (SSIS), Applying some business logic and data cleaning in staging server to maintain child and parent relationship. •Experience in using merge, merge join, OLEDB command, multicast, data conversion, conditional-split, derived column, union all, aggregate transformation, sort, row count, etc. •Good understanding of Normalization / De-normalization, Normal Form and database design methodology. •Expertise in creating packages having incremental loading and maintaining historical data using look up and SCD transformation. •Experienced in Development and Staging phases of the projects with support of Dataflow, Process Models, E-R Diagrams. •Experienced in creating various Table, Matrix, Parameterized, Cascaded, Linked and Drill-through & Drill-down, Sub report, Snapshot, reports. •Good experience in deployment and scheduling reports in report server. •Created subscriptions for daily, weekly, monthly reports for Business Owner and Business analyst for various categories and regions based on business needs using SQL Server Reporting services (SSRS). •Experienced in using For Each Loop Container, Sequence Container, Script Task, Execute SQL task, Variables and Send Mail Task at the Control Flow Level and Look Up, Fuzzy lookup, Merge, Join, Union All, Derived Column, Conditional Split and various other Transformation to manipulate data in SSIS package at the Data Flow Level. •Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and teamwork skills.