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 *** .
- 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...
