Senior Sql Developer
Current Designed, developed and implemented an in-house EDI Billing system to support Accounting’s need for Health Care claims and/or encounters. Integrated ASP .NET, SQL Server & EDI HQ into one consolidated Web Application, so Billers could view & submit claims/encounters to various clients based on each client’s specific EDI format. Built SQL Sever solutions for various data migration/replication process. Created database maintenance plans for monitoring database integrity and performance. Migrated data from various data sources to centralized SQL server databases using SSIS or customized SQL job. Optimized Indexes for better performance by analyzing their Query Plans. Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler. Created Entity Relationship Diagrams (ERD), data dictionaries, and physical data structures such as tables, primary/foreign keys and indexes. Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine. Maintained Batch logging, Error logging tables and handled errors using Event handlers. Developed, monitored, and deployed SSIS packages and/or customized SQL job for Dynamic ETL flow to validate, extract, transform and load data into database. Created Customized reports (Parameterized, Drill-through, and Drill-down Reports) using SSRS. Involved in deploying, configuring and managing reports using Report Manager and Report Builder. Developed ETL audit process and controls to ensure data quality is compliant with defined standards and thresholds. Developed customized eligibility process for each client based on different eligibility file format. And integrated all eligibility data into one consolidated Web application for internal call centers.
