Summary: * Around 7 years of professional experience in SQL Server database development, extensively worked in Production, Test, Development and Replication &Cluster Server Environments & development databases as a Developer. * Excellent experience in designing and developing Reporting System using Business Objects. * Experience with Finance, Sales, Health Care Doman like Insurance, Claims, Enrollment, and Credit Card tracker. * Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments. * Hands on experience in creating indexed Views, Complex Stored Procedures, Functions, Triggers, CTE's to assist efficient data manipulation and data consistency and used DDL, DML commands for various business applications. * Efficient in upgrades and migration from MS SQL Server 2000/2005 to MS SQL Server 2012/2008R2. * Hands on experience working with SSIS, for ETL Process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations. * Created SSIS packages with complicated transformations like Lookup, Derived Column, Condition Split, Multicast, Sort, Union All, Cache Transform, and Conditional Split, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc. * Great Expertise in event handlers, Package Configurations, Logging, and Check points, Package Securities and User Defined Variables for SSIS Packages. * Experience in enhancing and deploying the SSIS Packages from development server to production server. * Experience in Reporting Services, Power BI (Dash Board Reports), Crystal Reports, Tableau using MS SQL Server and in supporting services MDX technology of the analysis services. * Expertise in designing, supporting complex reports like Drill-Down, Drill-Through, Parameterized, Matrix, and formatting Reports using SQL Server Reporting Services SSRS) based on client requirement. * Created stored procedure for generating reports using SQL Server Reporting Services (SSRS). * BI Integration with SharePoint like Power View, Power Pivot and Power Query, Excel Service, and Reporting service. * Excellent hands on experience in creating groups, hierarchies and measures, KPIs. * Good knowledge on creating the MDX cubes and Designing and Building the Dimensions and cubes with star schema and pre-calculating the same in SSAS2005/2008/2008R2. * Good knowledge in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects. * Having good experienced on BI Share Point like SharePoint 2013, SharePoint 2010 and Good Exposure with Microsoft Office System like MS Word, MS EXCEL, MS PowerPoint, MS Access, MS office Tools * Strong knowledge on .Net Web Services, Windows Communication Foundation (WCF), .Net Windows Services. * Have knowledge of VMware and MS Azure. * Writes independent code in VB.NET, VBA MS Access, MySQL, SQL, store procedures, develops, tests, debugs, implements, and documents programs. Assists in the modification of existing code. * Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP. * Experience working with code repositories such as GitHub, SVN and Team Foundation Server (TFS) * Experience in working with both Agile and Waterfall methodologies * Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills. * Quick learner and proactive team member with good Communication skills and Leadership capabilities.

Highlights:

• Microsoft SQL Server
• Structured Query Language
• Stored Procedures
• Management
• Services
• T-SQL
• Business Requirements
• Data Warehouse
• ETL
• Integrate