Summary of Career

1. ? Create Tables, Views, Triggers, Functions and Procedures using T-SQL. ? Performance tuning and optimisation of SQL Procedures. ? Analyse the data and the preexisting MS Access reports/queries to implement those using SSRS and T-SQL. ? Perform data migration using SSIS and create mapping rules for data migration. ? Create backups and restoration. ? Requirement Analysis and design database. ? Perform software implementation tasks, including source control and deployment activities ? In depth

---

2. ? Create T-SQL Procedures, functions, views, indexes and triggers. ? Review the existing Procedures and optimize them. ? Work on CRs and enhancements. ? Create SSIS packages. ? Create reports using SSRS.

---

3. ? Gather the requirements from the Solutions Architect, create the data mappings and design them using SQL Server. ? Load the data using SSIS packages. ? Work on QA and peer review. ? Schedule the data load process using Visual Cron. ? Design the database, involve in reporting and data analysis. ? Perform database tests, indexing and create documentations. ? Create triggers, objects, workflows and SSRS reports. ? Work on spreadsheets and excels to evaluate data accuracy. ? Risk management

---

4. ? Create database backups, restoration, server configuration and administration. ? Write T-SQL queries, SP’s, views and functions. ? Email configuration and routing ? FTP server support. ? Document the issues and provide the solutions for the same. ? Write basic Unix commands. ? Troubleshoot the issues with customer website. ? Log shipping and Mirroring . ? Upgrade the database and restore the websites.

---

5. SSIS PACKAGE CREATION

---

6. TABULAR SSAS

---

7. MULTIDIMENSIONAL SSAS

---

8. SSRS

---

9. DAX

---

10. POWERBI

---