About Me

Ø  Experience on SSIS 2012/2014, SSRS 2012/2014, MS SQL Server, Power BI

Ø  Worked with various transformations (Lookup, Multicast, Conditional splits, Derived column, Aggregate, Merge, Balanced Data Distributer, Row Count, Sort, Union...ditional splits, Derived column, Aggregate, Merge, Balanced Data Distributer, Row Count, Sort, Union All etc.), control flow tasks (Execute SQL, File System Task) and containers (For loop, For each loop, Sequence Container, Script Task, Execute Package Task, FTP Task).

Ø  Experience in writing, optimizing T-SQL Objects like stored procedures, Indexes, Views, CTE, Set Operators, Constraints, Functions, Joins.

Ø  Experience on handling with different source like SQL Source, Excel, and Flat File.

Ø  Hands on experience in creating, deploying, trouble shooting, scheduling and monitoring SSIS Packages.

Ø  Creating the reports as per client’s requirements in the form of table, matrix, Chart and list.

Ø  Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.

Ø  Expertise in designing, deploying scheduling and maintaining SSRS reports

Ø  Interacting with clients and clarifying their issues.

Ø  Excellent communication skills bridging Client Interaction and Team Management.

Ø  Strong analytical, problem troubleshooting/solving skills, self-starter.

Ø  Creation of SSIS packages with Analysis process tasks to process cubes.

Ø  Creation of report subscriptions to send the reports by mails by scheduling the reports.

Ø  Experienced in configuring with Error logging and Error handling to redirect error rows and fix the errors in SSIS.

Ø  Expert in deploying both SSIS Packages and SSRS Reports.

Ø  Good interpersonal communication and an excellent team player.

Ø  Good Knowledge on Power BI.

Ø  Expert in creating and developing Power BI Dashboards in to rich look

Ø  Experience in developing Dashboard Report, Parameterized Reports, Linked reports, Sub reports by Region, Year, Quarter, Month and Week.