Role : & Developer
Role Summary :
· Translating business needs to technical specifications.
· Creating database objects viz., Tables, Stored Procedures, indexes, Temp tables, Views to support the requirements using MS SQL Server.
· Developing and deploying reports using SQL Server Reporting Services (SSRS).
· Creating of Parameterized, Drill Down and matrix reports for the business users.
· Creating packages using SQL Server Integration Services (SSIS)in both project and package deployment model to pull the data extracts.
· Generation of flat files and excel files for analysis to Financial teams.
· Creating jobs using SQL Server Agent to run the SSIS packages on a scheduled basis. Monitoring the jobs, execution plan etc.
· Performing unit testing and troubleshooting.
· Developing and updating the technical document.
· Identifying areas of improvement in performance of the solution and applying corrective actions.
· Creating log files to keep track of the packages and reports execution.
· Creating pivot tables using Excel to summarize the data at
· high end for the business users.
· Skills: SQL Server, SSMS, SSIS, SSRS, Excel, SQL Server Agent, Pivot Tables
---**---
Note : If I Miss Your Call Email Is The Best Way To Reach Me
---**---
Thanks & Regards
Prashanth - US IT Recruiter
Contact : +1 (315)- 947- 0775
Email : pras...@genisists.com
LinkedIn : https://www.linkedin.com/in/prashanth-nani-804622185
|
|
Sender notified by Mailtrack 10/29/19, 10:31:56 PM |