United States
Experienced SQL Developer with a demonstrated history of working in the hospital & health care industry. Skilled in Extract, Transform, Load (ETL), Databases, Data Warehousing, Software Development Life Cycle (SDLC), and Business Intelligence. Strong information technology professional with a Master of Science - MS focused in Computer Science from University of Central Missouri. coming to certifications: I’m Epic certified in Clarity, Cogito, and Caboodle I’m certified in Azure Fundamentals (AZ-900).
· Served as a Clarity (Epic Database) SME, supporting clinical data architecture, reporting, and ETL across the enterprise.
· Gathered requirements from business users and business Analysts · Developed new SQL Scripts and SQL Stored procedures as per the BRD’s · Worked on Guiding care application which is used by many Insurance companies like UHC (United Health Group), Care Source, Care First etc. · Worked on migration project of GC Product in different versions (supported in QA testing to test the existing scripts and new scripts). · Extensively worked in production support in order to handle production defects for many clients. · Analyzed the Application and participated in meetings with the business users to gather requirements and work on production defects. · Actively participated in company conducted events. · Created many Documents on different processes which helps Developers to do the testing easily and understand GC Product more easily · Exposure of Azure – Migrated packages using Azure Pipelines Environment: SQL Server 2018, GIT
Sr SQL BI DEVELOPER Client: CVS Health Sept 2016 – January 2021 · Gathered requirements from the business users. · Assessed existing DW/BI solutions and recommend approaches for modernization. · Designed, developed, and deployed SSIS packages. · Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages. · Migrated data from legacy system (Text based files, Excel spreadsheets, and Access) to SQL Server databases using SSIS to overcome the transformation constraints. · Migrated the Reports from one server to the other server and migrated the jobs from one server to the other server. · Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis. · Generated SSRS Enterprise reports: Included various reporting features such as groups, sub-groups, drilldowns, drill through, sub-reports, navigation reports (Hyperlink). · Created different Parameterized Reports (SSRS) like standard parameter reports, cascading parameter reports which consist of report Criteria in various reports to minimize the report execution time and to limit the number of records required. · Extensively used Joins, sub-queries, Stored Procedures, and Indexes for complex queries involving multiple tables from different databases. · Created views to restrict access to data in a table for security. · Migrated to the Application system (from CTD to EPIC). Environment: SQL Server 2016, 2012,2008, Business Intelligence Development Studio (SSIS, SSRS)2008,2016, MS-Visual Studio 2015, Visual Source Safe, TFS, GIT