Naga S

Datawarehouse Designer


Datawarehouse Designer

Education Level:


Will Relocate:



PROFESSIONAL SUMMARY: * Over 9 Plus Years of IT industry experience with Microsoft SQL Server 2005/2008/R2/2012/2014 * Have been working as MS SQL Application/Data Warehouse developer with experience of 9 years in development, analysis, administration, database migrations, reporting analysis and data base maintenance. * Expertise in the implementation of MS SQL Server 2000/2005/2008/2012 Infrastructure. * Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service (DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication. * Expertise in using SQL Integration tools with SQL Server 2000, SQL Server 2005 and SQL Server 2008/2012/2014. * Very strong Transact-SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, CTE's, Cursors, Views, Indexes, Triggsers and Functions. Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, Bulk Insert, BCP, XML). * Worked in development environment, with knowledge of Query estimation, Index tuning wizard and database Optimization techniques. * Solid experience with creating alerts, schema management, database reorganization, data loading. * Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2, Sybase and Flat file. * Expertise in generating reports using MS Reporting Services 2008/2005. * Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services. * Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle). * Proficient with Management Studio, Enterprise Manager, SQL Query Analyzer, scheduling regular and on-demand jobs with SQL Server Agent, * Experience with high availability systems, 500+ GB databases, hundreds of databases in a highly transactional environment with proper data Archive and Purge processes. * Maintaining sound backup and restoration policies and procedures. * Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification and index updates. * Implement and maintain database security by creating the Users, Roles and assign privileges required * Generating reports from Production server whenever required * Created various types of simple, complex, parameterized reports using SSRS. * Developed various types of complex reports like Drill Down, Drill through, Cross tab reports. * Created Report Subscription and Data Driven Subscription using SSRS. * Created Report Snapshots and Report caching to show the data changes over time. * Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements. * Experience with SSRS Report Server, Report Manager and SSRS deployment Process Working Experience in preparing documentation as per organizational standards, designing, implementing, and maintaining complex database applications in financial environments. * Actively involved in monitoring system performance by using SQL Profiler, Database Engine Tuning Advisor, and Windows performance monitor, Event Viewer, DMVS, and Resource Governor to achieve better performance. * Monitoring the temp DB full and transactional log full issues. Involved in moving system databases. Reorganize and Rebuilding Indexes for better performance. Implemented Log Shipping and troubleshooting the errors. Maintaining High Availability of Databases using Mirroring concepts. * Have experience working with teams of software organizations like IBM, TCS. * Additional Domain knowledge in Health Care and Insurance. * Expertise in developing and maintaining of processes and associated SQL scripts/tools for automated build, testing and deployment of the products to various developments. * Excellent communication, presentation, interpersonal skills, strong troubleshooting and organizational skill.





CollapseJob Skills