Description
PROFESSIONAL SUMMARY: * Over 10 years of IT experience in the Analysis, Design, Development, Implementation and testing of Client applications using Microsoft SQL Server 2000/2005/2008R2/2012/2014/2016 and its BI. * Extensive work experience on all phases of Software Development Life Cycle (SDLC) in various domains like Banking, Finance, HealthCare, Retail, Transport & Insurances. * Experience with Installation and Configuration of MS SQL Server 2016/2012/2008R2/2005/2000. * Excellent work experience in MS SQL Server development including designing logical/physical databases using T-SQL, and with Business Intelligence suite consists of Microsoft Integration services (SSIS), Reporting Services (SSRS), and Analysis services (SSAS), performance tuning. * Hands on experience of T-SQL, OLTP, OLAP in design & development database and data warehousing. * Experience in logical, physical and dimensional data modeling, data mapping and data normalization, well verse in ERWIN and Microsoft VISIO 2007/2010. * Experience in creating complex stored procedures, Views, effective Triggers, and useful Functions to facilitate efficient data manipulation, mapping and consistent data storage to staging then to databases. * Experience in various Extracting, Transforming and Loading (ETL) tasks using SSIS including tools like BCP utility, DTS and SSIS 2005/2008R2/2012/2016 Packages with suitable control & data flow tasks. * Hands on experience in using of Control Flow tasks like Execute SQL Task, Data Flow Task, Script Task, SMTP Task, Containers (For Each, Sequence), precedence Constraints, Look up task using SSIS. * Experience in using SSIS (SQL Server Integration Services) transformations like Aggregate, Multicast, Data conversion, Merge Join etc in Data flow task based on multiple sources like flat files (.txt, .csv), excel files, SQL Server databases (OLEDB), ODBC, ADO.Net source, XML Source etc. * To deploy same SSIS packages on various domains used package configurations, Logging for status check, Event Handlers, Error handling, check points & Break point for SSIS Package Debugging. * Experience with ad-hoc reporting, regular reporting, parameterized, Custom Reporting, power view reports, power pivots, and graphical reporting using SSRS for daily/weekly/bi-weekly/monthly reports. * Experience in creating Power Pivot data models to provide the data to Power View dashboards. * Created and implemented cubes, transaction to reporting solutions with SQL Server Analysis services. * MS SQL Server 2005/2008 R2 OLAP developments including KPIs, Data mining, working with slowly changing dimensions (Fixed, Changing and Historical) and MDX (Multidimensional), DAX queries. * Experience on Master Data Services (MDS), Data Quality Services (DQS) of Advanced SQL Server. * Experience in Microsoft.net technologies using C#, ASP.NET1.1/2.0/3.0/3.5, ADO.NET, Language integrated Query (LINQ), WCF, WPF, Windows Forms, Windows Controls, XML, JavaScript, Web Services, Web controls, Web Forms, and Visual Studio.NET2005/2008. * Experience in planning and implementation of Role based Security & Database permissions on SSMS. * Strong experience in SQL Server Database Administration, Management, Upgrading, Migration and Development in Production\Nonproduction environments. * Experience in implementing different types of Replication Models such as Transactional, Snapshot and Merge in SQL Server 2012/2008R2/2005/2000 in OLTP environments. * Extensive work experience with Database Backup, Restore, Capacity planning, database security. * Involved in DBA activities such as backups, restores, deploying in DEV/QA/UAT/PROD environments.
Accomplishments
Highlights:
Keywords
