Sr. SQL BI Developer Available resume

Professional Summary:

  • Over 7+ years of Information Technology development experience in Database Design and Development in SQL server *** R *** system in OLTP and OLAP environment.
  • Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server *** R *** .
· Used TFS (Team Foundation Server) for project management and source control.
  • Maintaining Version control for T-SQL, SSRS, and SSAS using TFS.
  • Experienced with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • Extensive experience in TSQL Development which includes creating Complex Business Stored Procedures, Tables, Cursors, Views, Indexes, Triggers and User Defined Functions.
  • Hands on experience with T-SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function.
  • Hands on experience in Writing & Debugging Stored Procedures and Triggers, Troubleshooting Database issues.
  • Experience in Code Optimization and Improving Efficiency in Databases including Re-Indexing, Updating Statistics, Recompiling Stored Procedures and performing other Maintenance Tasks.
  • Experience in working with SSIS Packages for Extraction, Transformation and Loading (ETL) operations.
  • Experience in Import & Export of various data formats using DTS (Data Transformation Services), BCP, Bulk Insert and SQL 2012 Integration Services.
  • Transformed data from one server to ot...

See full