Nagashree

DB SPECIALIST
Dubai


Profile Views 242

Recommendations (0)

Skills
MSSQL SERVER DEVELOPMENT/ADMINIST SSIS SSAS SSRS POWERBI
  • Experience
    4 Years
  • U.A.E Experience
    --
  • Industry
    Information Technology
  • Nationality
    INDIAN
  • Visa status
    Visit Visa in UAE
  • Qualification
    Bachelor - COMPUTER SCIENCE
  • Driving License: INDIA
Other Matching Titles/Position
Industry Titles
Information Technology

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


Work Experience (Employment History)
Academic Qualification

Bachelor 01 June 2014

COMPUTER SCIENCE
Certifications
Recommend Nagashree
Related UserList of Members
Mentor
Not yet Assigned
Profile Answers
Related Professionals
Profession: IT Support
Current City: Muhaisnah 4

Profession: IT Manager
Current City: abu dhabi

Profession: IT Support Engineer & Administration
Current City: Abu Dhabi

Profession: Java
Current City: Hyderabad

Profession: Information technology
Current City: Rawalpindi

Profession: ITIL Consultant
Current City: Pune