Senior SQL database administer and developer - Eye-Q Eye hospital - Gurgaon, India
(2024-11)
Senior SQL developer - Simple Solve Inc. - Pennington, USA
(2023-08 - 2024-08)
Simple INSPIRE, a fully integrated Platform, is designed to meet the challenges of unprecedented transformation in the Insurance industry and take advantage of disruptive technologies, and digital abundance.
Policy
Management system is a platform with a visionary architecture and a foundation built on disruptive technologies for digital-first enablement. It empowers you to drive change rather than be driven by change. Introduce new norm policy products with confidence. The platform has an integrated insurance claims system to create and manage claims. A claim can have multiple claims features to manage multiple claims arising out of a single incident. Managing and reporting claims can be done at the Claim level or the Feature level. The Simple INSPIRE – Insurance Claims system can create letter templates to generate claims-related correspondence providing operational efficiency.
- Working on SQL server development, SQL database administrator, Snowflake SQL, and Snowflake pipeline
- Proficient in Extract, Transform, Load (ETL) processes, with expertise in designing, developing, and optimizing data workflows
- Designed and developed SSIS packages to extract, transform, and load data from various source systems into SQL Server databases
- Created complex SSRS reports with parameters, drilldowns, and interactive sorting to meet diverse reporting requirements
- Implemented data cleansing and transformation logic within SSIS packages to ensure data quality and integrity
- Designed and developed SSAS cubes to support business intelligence initiatives
- Collaborated with business users to gather and analyze requirements for data models
- Optimized cube performance by fine-tuning aggregations, partitions, and indexes
- Created SSIS Log Tracking database in SQL Server Management Studio (SSMS) containing multiple tables including Execution Status, Business Scope, Processing Log, Error Log, etc.
- Integrated SSAS solutions with other BI tools like Tableau and Excel for comprehensive reporting
- Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors, and procures/views in Snowflake
- Transformed data from one server to other servers using tools like Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
- Integrated and extracted source data using SSIS ETL tool and stored procedures created in SQL Server Management Studio (SSMS), and developed transformation logic and designed ETL packages
- Data Visualization: Expert in creating interactive dashboards, reports, and visualizations using Tableau
- Used T-SQL in SQL Server Management Studio (SSMS) to develop Stored Procedures, User-Defined Functions (UDFs) and Views
- Data Analysis: Strong analytical skills with experience in statistical analysis, data mining, and trend identification
- Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS)
- Database Management: Proficient in SQL and data integration from various sources, including relational databases, cloud services, and flat files
- Developed and maintained interactive dashboards and reports in Tableau, providing real-time insights to stakeholders
- Gathered requirements and Created data models for the databases
- Defining and Setting backup and recovery procedures
Senior SQL developer - Tata Consultancy Service Ltd - Chennai, India
(2010-07 - 2023-08)
Hospital Management System (HMS) and Electronic Medical Records (EMR) Sankara Nethralaya Eye Hospital is one of the world's best ophthalmic care and research centers, which serves around 2000 patients a day. The center houses around thirty various departments, which efficiently manage patient care and medical services. The major functionality of HMS is a fully integrated Hospital Management suit that is powered with various applications like Appointment Scheduling, Patient Registration, Billing, Clinical laboratories, Wards, Surgery Scheduling, Purchase, Pharmacy, and Stores.
- Proficient in Extract, Transform, Load (ETL) processes, with expertise in designing, developing, and optimizing data workflows
- Designed and developed SSIS packages to extract, transform, and load data from various source systems into SQL Server databases
- Created complex SSRS reports with parameters, drilldowns, and interactive sorting to meet diverse reporting requirements
- Implemented data cleansing and transformation logic within SSIS packages to ensure data quality and integrity
- Designed and developed SSAS cubes to support business intelligence initiatives
- Collaborated with business users to gather and analyze requirements for data models
- Optimized cube performance by fine-tuning aggregations, partitions, and indexes
- Created SSIS Log Tracking database in SQL Server Management Studio (SSMS) containing multiple tables including Execution Status, Business Scope, Processing Log, Error Log, etc.
- Integrated SSAS solutions with other BI tools like Tableau and Excel for comprehensive reporting
- Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors, and procures/views in Snowflake
- Transformed data from one server to other servers using tools like Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
- Integrated and extracted source data using SSIS ETL tool and stored procedures created in SQL Server Management Studio (SSMS), and developed transformation logic and designed ETL packages
- Data Visualization: Expert in creating interactive dashboards, reports, and visualizations using Tableau
- Used T-SQL in SQL Server Management Studio (SSMS) to develop Stored Procedures, User-Defined Functions (UDFs) and Views
- Data Analysis: Strong analytical skills with experience in statistical analysis, data mining, and trend identification
- Involved in improving the performance of Stored Procedures and queries in SQL Server Management Studio (SSMS)
- Database Management: Proficient in SQL and data integration from various sources, including relational databases, cloud services, and flat files
- Developed and maintained interactive dashboards and reports in Tableau, providing real-time insights to stakeholders
- Trained team members on Tableau best practices and data visualization techniques
- Created and managed business intelligence solutions, including dashboards, reports, and data models in Tableau
- Improved data quality and consistency by implementing data governance and validation processes
- Developed and maintained SSAS cubes to facilitate data analysis and reporting
- Conducted data analysis to support decision-making processes across various departments
- Created reports utilizing SSRS 2012, Power BI and deployed them on SSMS as per business requirements
- Generated reports and dashboards using SSRS, Tableau and Power BI
- Assisted in the development and maintenance of SSIS packages for data extraction, transformation, and loading
- Designed and developed interactive and dynamic reports using SQL Server Reporting Services (SSRS) based on business requirements
- Created complex SSRS reports with parameters, drill-downs, and custom expressions to provide detailed insights to stakeholders
- Implemented SSRS subscriptions for automated report generation and distribution, improving report accessibility and timeliness
SQL Developer - Sankara Nethralaya Medical Research Foundation - Chennai, India
(2007-07 - 2010-07)
Medical Records Management System: Major functionalities of the MRD project involve the maintenance of Surgery details, Doctor Details, and Operation Theatre details.
- Working along with programmers and contributing to the development team process
- Managing, troubleshooting and resolving database and application related issues
- Production Database Administrations
- Developing SQL scripts, Stored Procedures, Views, Triggers, Indexes, Joins, User Defined Functions and Cursors
- Assisted in the development and maintenance of SSRS reports, including report design, layout, and data visualization
- Supported report testing and validation activities to ensure accuracy and reliability of SSRS reports
- Documented SSRS report specifications, configurations, and deployment procedures for knowledge sharing and team collaboration
- Checking of Cluster availability for Data Base servers
- Creating user ids and defining roles, allocating quotas with necessary privileges for all databases
- Gathered requirement and Created data model for the databases
- Normalized data model for optimum performance
- Designed and Implemented of Backup and Recovery Strategies and taken backup using scripts
- Defining and Setting backup and recovery procedures
- Developing backup scripts to automate the backup procedures
- Tuning and balancing I/O by monitoring file system and table space I/O statistics
