• Experience in SQL Server Database Development, SSIS(ETL), SSRS(RDL) and MSBI Administration Skills in MS SQL Server 2005, 2008, 2008 R2, 2012• Experience in analysis, design, development, testing & implementation by gathering requirements, data analysis, validations, data flow, process models and resolving data quality issues• Excellent understanding of the Medical Insurance industry and its business processes such as Market Place, Medicare and Medicaid Enrollments.• Hands on experience in designing of conceptual, logical and physical data models for OLTP/OLAP systems using MS SQL Server and Oracle • Experience in creating tables, stored procedures, views, indexes, cursors, triggers, user profiles and user defined functions• Optimized the performance of queries in T-SQL queries by normalized tables, established joins, event handling and created indexes • Experience in creating SSIS packages for extraction, transformation and loading data from MS SQL Server, Oracle, MS Access, Excel and flat files using MS SSIS • Designed ETL strategies and preparing mapping specifications• Having good experience in report development using SSRS and Crystal reports• Created drill down reports, sub reports, drill through reports, cascading parameters, custom code, conditional formatting, subscription reports etc.• Experience in creating SQL Logins, Roles and Authentication Modes according to the Security Policies for users• Trouble shooting the technical issues and support the development teams for release Impacts• Ability to work with an aggressive and demanding project schedule and environment• Experience in handling senior level executives in multiple projects• Self-starter, with strong analytical and troubleshooting skills, ability to work independently or as part of a team
Listed skills include Microsoft Sql Server, Ssis, Ssrs, Databases, and 5 others.