Professional Summary
- Over 8 years of IT experience as an MS SQL BI Developer with specific expertise in Travel and Logistics Domain especially in the Warehouse Management System.
- Experience in Creating and Reviewing BRD, Functional and Technical specs.
- Interacted with business users for requirement gathering and end to end delivery.
- Provided business improvement plans and designs.
- Extensive experience in Application Development and support in Database Design, Development, Implementation and Support using various Microsoft technologies (SQLServer2005/2008R2/2012, T-SQL) in both OLTP and data warehousing environments.
- Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Drill through, Drill down, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studios (BIDS) and SQL Server Data Tools.
- Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact- SQL queries, stored procedures, and triggers. Experience in analyzing and debugging exiting Complex stored procedures.
- Extensively used tools like Idera, SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS-SQL Server performance.
- Experience in Installing, Upgrading and Configuring Microsoft SQL Server and Databases.
- Experience in Enterprise Reporting in generating reports...