Technical Lead - BI

• Oct 2021 - Present

Senior Software Engineer

• Dec 2019 - Oct 2021

• Responsible for Application, Database, Data Warehouse and ETL Architecture and implementation. • Implemented database objects and performed query performance analysis of Productions application database. • Expertise in analyzing the query plan and optimize the Store procedure. • Work on various proof of concept for azure data factory, Reporting solutions. • Power BI dashboards for financial workflow and government processes • Working with various reporting solutions like… Show more • Responsible for Application, Database, Data Warehouse and ETL Architecture and implementation. • Implemented database objects and performed query performance analysis of Productions application database. • Expertise in analyzing the query plan and optimize the Store procedure. • Work on various proof of concept for azure data factory, Reporting solutions. • Power BI dashboards for financial workflow and government processes • Working with various reporting solutions like Telerik reports and crystal reports. • Working with modern day version control apps like Git and Azure DevOps for Agile implementation. • Working on various POCs for OnPrem to cloud and Cloud to OnPrem data load. • Working on various backup and restore process of database for azure cloud sql server and OnPrem.

MS Sr Systems Analyst

• Apr 2014 - Dec 2019

• Developed various reports using SSIS and SSRS. • Write complex SQL query to extract the data from various Clinical and financial application and export into CSV, EXCEL based on client requirement. • Create SSIS packages for HEDIS Measure and Schedule to Transfer to FTP using SSIS script and email task. • Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query. • Develop complex reports using cognos report studio, query studio and… Show more • Developed various reports using SSIS and SSRS. • Write complex SQL query to extract the data from various Clinical and financial application and export into CSV, EXCEL based on client requirement. • Create SSIS packages for HEDIS Measure and Schedule to Transfer to FTP using SSIS script and email task. • Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query. • Develop complex reports using cognos report studio, query studio and analysis studio. • Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS. • find the root cause of slowness in application • Expertise in troubleshooting of Crystal reports errors and configuration with various applications. • Create complex T-SQL and Normalized up to 3NF • Power BI report dashboard and reporting solutions. • Developed SQL scripts and SSIS packages for 340B and Wellgreens data extraction project. • Expertise in reading the Application and database logs to find the root cause of the slowness and provide appropriate solution for the same • Expertise in reading the SQL execution plan and run the traces and analyze in SQL query tuning adviser. • Developed various Provider Summary Reports using SSRS and did high level of testing with database Show less • Developed various reports using SSIS and SSRS. • Write complex SQL query to extract the data from various Clinical and financial application and export into CSV, EXCEL based on client requirement. • Create SSIS packages for HEDIS Measure and Schedule to Transfer to FTP using SSIS script and email task. • Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query. • Develop complex reports using cognos report studio, query studio and… Show more • Developed various reports using SSIS and SSRS. • Write complex SQL query to extract the data from various Clinical and financial application and export into CSV, EXCEL based on client requirement. • Create SSIS packages for HEDIS Measure and Schedule to Transfer to FTP using SSIS script and email task. • Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query. • Develop complex reports using cognos report studio, query studio and analysis studio. • Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS. • find the root cause of slowness in application • Expertise in troubleshooting of Crystal reports errors and configuration with various applications. • Create complex T-SQL and Normalized up to 3NF • Power BI report dashboard and reporting solutions. • Developed SQL scripts and SSIS packages for 340B and Wellgreens data extraction project. • Expertise in reading the Application and database logs to find the root cause of the slowness and provide appropriate solution for the same • Expertise in reading the SQL execution plan and run the traces and analyze in SQL query tuning adviser. • Developed various Provider Summary Reports using SSRS and did high level of testing with database Show less

SQL Developer

• Jun 2013 - Apr 2014

• Optimized the performance of various SQL scripts. Developed custom T-SQL stored procedures to perform ETL operations. • Development of complex TSQL code applications. • Worked on Various reporting solutions like SSRS, Quick view. • Maintaining various security model for client reports. • Understanding real estate workflow and help user for various reporting solution. • Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance… Show more • Optimized the performance of various SQL scripts. Developed custom T-SQL stored procedures to perform ETL operations. • Development of complex TSQL code applications. • Worked on Various reporting solutions like SSRS, Quick view. • Maintaining various security model for client reports. • Understanding real estate workflow and help user for various reporting solution. • Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.7 • Developed SSRS subscriptions to schedule report. • Involved in database Backups, Restore and scheduling them accordingly. • Involved in query optimization, index tuning of database. • Developing the Drill Down, Drill Through, sub reports for various business requirements using SSRS. • Created the charts and Dashboards in SSRS • Created various reports through Microsoft power pivot tool. Show less • Optimized the performance of various SQL scripts. Developed custom T-SQL stored procedures to perform ETL operations. • Development of complex TSQL code applications. • Worked on Various reporting solutions like SSRS, Quick view. • Maintaining various security model for client reports. • Understanding real estate workflow and help user for various reporting solution. • Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance… Show more • Optimized the performance of various SQL scripts. Developed custom T-SQL stored procedures to perform ETL operations. • Development of complex TSQL code applications. • Worked on Various reporting solutions like SSRS, Quick view. • Maintaining various security model for client reports. • Understanding real estate workflow and help user for various reporting solution. • Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.7 • Developed SSRS subscriptions to schedule report. • Involved in database Backups, Restore and scheduling them accordingly. • Involved in query optimization, index tuning of database. • Developing the Drill Down, Drill Through, sub reports for various business requirements using SSRS. • Created the charts and Dashboards in SSRS • Created various reports through Microsoft power pivot tool. Show less

Oracle Software Developer

• Dec 2011 - Jun 2013

• Development for transcription workflow in ORACLE Apex. • Developed various functionality in ORACLE Apex tool • Created SQL and Plsql module • Handle live system of DIC2DOC Portal • Development for transcription workflow in ORACLE Apex. • Developed various functionality in ORACLE Apex tool • Created SQL and Plsql module • Handle live system of DIC2DOC Portal