PROFESSIONAL SUMMARY * Highly motivated SQL server Developer with Ten Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005, SSIS and SSRS. * Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/2008/2005/2000. * Experienced in client requirement Analysis, design, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/2008/2005/2000, SSIS, SSAS and SSRS 2005/2008/2012. * Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches. * Experience in writing complex SQL queries involving multiple tables inner and outer joins. * Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views. * Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications. * Worked Extensively on ETL process using SSIS package. * Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation. * Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all. * Extensive professional experience in design, development, implementation and support of mission- critical Business Intelligence (BI) applications. * Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and Power BI SDLC from prototyping to deployment. * Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy * Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. * Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement. * Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts and Data Visualization with Tableau software. * Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. * Good understanding of Health care, and Retail domains.

Highlights:

• Applications
• Business Intelligence
• Coding
• Configure
• Data Conversion
• Data Definition Language
• Data Modeling
• Data Warehouse
• Database
• Database Design