Professional Summary
Seven years of experience in analysis, design, implementation and administration of BI using Microsoft SQL server 2012/2008/2005/2000 in development, testing & production. Expert in writing T-SQL, working on DTS, SSIS, SSRS, Data Cleansing, Data Scrubbing and Data Migration. Developed Custom Reports and different types of Tabular Reports, Matrix Reports, Adhoc Reports and distributed Reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence development studio (BIDS). Proficient building end to end data integration and workflow solutions from input source extraction, apply various transformations and data load. Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading). Database Administrative skills including, backups, recovery and database maintenance. Involved in optimization of data models using Ralph Kimball's dimensional and Bill Innmon E-R models. Experience in DTS packages migration and creating complex SSIS for ETL purposes including data migration, data extraction/ transformation/loading (ETL). Data flows using SSIS, creating mappings/workflows to extract data from Oracle, SQL Server, MS Access, Excel and Flat File sources, legacy systems and load into various Business Entities. Involved in writing complex queries, stored procedures, batch scripts, triggers, functions, joins and views using T-SQL Performance tuning of stored procedures, cascading operations, large T- SQL queries using indexes and efficient coding standards. Developed cubes, SCD and Hierarchies for analysts and executive Dashboards using Charts and Graphs. Developed business applications with VB 6 and Object-Oriented Software Languages VB.NET Creating and managing users, roles and assigning necessary permissions for SQL Server security. Handling dead locks, scheduling and maintaining the jobs and automatic e-mail notifications. Complete understanding of software development life cycle (SDLC) including requirement analysis, requirement gathering, design, development, implementation and testing and deployment experience. Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation. Operating System Windows XP/7/8/10; Windows Server 2005/2008/2012; Red Hat and CentOS - Languages T-SQL, PL/SQL, Visual Basic 6, .NET RDBMS MS SQL Server 2008/2012/2014, MS Access 2013/2016, Oracle 9i/10g/11g, MySQL - ETL Tools SSDT, BIDS, DTS, Import/Export wizard - Reporting Tools SQL Server Reporting Tools (SSRS), Crystal Reports, MS Excel