Over 11+ years of IT experience in Database Design, Development, ERP Planning, Implementation, Data ware house Production Support in Client-Server environment for various Industry verticals like Manufacturing, Retail and Healthcare Insurance. 8+ Years’ Experience in Microsoft SQL Server Database Design, Development, Programming, Maintenance with Performance tuning, 5+ Years of Experience in Business Intelligence (SSRS/SSIS). Microsoft Certified Professional (MCP) in Microsoft SQL Server Business Intelligence Development & Maintenance (MSBI) Experienced in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs. Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Keys & Constraints, and Normalization techniques on database Tables. Expert in creating and using Stored Procedures, Views, User Defined Functions. Experience in Installing, Configuring, Handling Multiple Instances & Databases of Microsoft SQL Server. Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency. Developed, deployed and monitored SSIS 2008R2 Packages. Used Control Flow Tasks like For Each Loop Container, Sequence container, Execute SQL Task and Data Flow Task in Designing packages. Experience in Data Flow Transformations like Derived Column, Conditional Split, Data Conversion, Union All, Merge Join, and Lookup and so on. Expertise in SSRS 2008 R2 and Crystal Reports (MIS) 8.5/9.0/11. Exercising of creating database and mapping schema of HIPPA EDI 837 (ASC X12 005010/004010) Claims (Professional, Institutional and Dental), CMS 1500/1450 Reporting Expert understanding of HIPPA PACDR 298-Professional, 299-Institutional and 300-Dental Experience
©