● **+ years of experience with MS SQL Server development, stored procedures and triggers development using T-SQL

● 7+ years of experience with Crystal Reports and 5+ year of experience with SSRS

● 15+ years of experience with developing and supporting applications using various programming languages, VB.net, C#, ASP.net, Java, and HTML against SQL Server databases

● 5+ years of working experience with Agile development practices and Scrum methodology

● Strong problem solving skills with professional attitude

● Highly self-disciplined with strong ability working independently as well as in team Technical Skills ● Database:

Main: SQL Server

Other: MySQL, ArcSDE (Spatial Database Engine)

● Language:

Main: T-SQL, VB.net, C#

Other: Java, Asp.net, PL-SQL

● Software/IDE:

Main: SSMS, SSRS, SQL Profiler, SAP Crystal Reports, MS Visual Studio, MS Data Tools, BitBucket/SourceTree, MS Visual SourceSafe, Perforce, Atlassian JIRA/Confluence, TeamCity/Octopus Other: SSIS, MS Power BI, CR4E (Crystal Report for Eclipse)

Experience:

Senior Software Engineer, HQM team

NextGen Healthcare Information System, Atlanta, GA

June 2016 to December 2023

● Provide and support stored procedures and SSRS reports for a client-facing web reporting portal

● Conduct data analysis, testing, and troubleshooting across Development, QA, UAT, and Production servers

● Develop stored procedures, triggers, and SQL scripts for applications, reports, hot fixes, and data monitoring

● Develop and support an user interface tool by using VB.NET to automate the process for SQL scripts and batch updates for Stored Procedures to improve development cycle and quality

● Develop and support an internal List Management Desktop Tool by using C#.NET to improve work efficiency and data quality

SQL Developer, EPM team

NextGen Healthcare Information System, Atlanta, GA

April 2007 to June 2016

● Develop and support a variety of reports, such as financial reports, claim forms, and business performance reports for internal and external clients using Crystal Reports

● Develop EDI (Electronic Data Interchange) solutions using C#

● Provide ad-hoc reports and database analysis to ensure high data quality and performance

● Develop and support an internal web reporting application for the NextGen Claim Department using VB.net, ASP.net, and Crystal Reports Viewer

● Research on BI solutions (web reporting and dashboards) using Crystal Report viewer/MS Power BI

System Administrator II

Georgia Department of Transportation, Atlanta, GA

December 2001 to April 2007

● Provided data analysis and performance optimization on Oracle 9i, SQL Server, and Access databases for application/reports using SQLPlus, DBvisualizer, and SQL Query Analyzer

● Provided spatial data analysis and design, modeling, and administration support on Oracle 9i

● Developed and supported web and desktop reporting applications using Crystal Reports, VB, and ColdFusion

● Developed and supported a Metadata Explorer web application using JS, Java, JSP, and HTML

● Developed and supported 200+ reports for statewide offices/users using Crystal Reports

● Provided ad-hoc reporting for internal clients using Oracle Discoverer

● Developed and supported a Transportation Explorer web application (TREX - 3.5 million dollar federal and state funded project) with real time traffic camera layer, road project layer, and other demographic layers using Java, JSP, JSF, JS, XML, and HTML

● Provided support applications for Rural Management Information System (RMIS), Financial and Accounting System (FAS) using VB and Crystal Reports

● Developed a StateAid application for the DOT State Aid Office using VB and Active Report

● Provided an in-house Crystal Reports training for statewide internal users

Awards:

● Gold Star Performer Award, 1st Quarter 2013 NextGen Healthcare Information System, Atlanta, GA

● Gold Star Performer Award, August 2011

NextGen Healthcare Information System, Atlanta, GA

● Gold Star Performer Award, November 2010

Special Project: ONC/CCHIT 2011/2012 Certification NextGen Healthcare Information System, Atlanta, GA

● Gold Star Performer Award, May 2008

NextGen Healthcare Information System, Atlanta, GA

● Faithful Service Award, December 2006

State of Georgia, Atlanta, GA

Contact this candidate