SAGAR G. GAHIWAL

• Assurant is a global provider of risk management solutions, specializing in niche markets.
  The company primarily focuses on the areas like: Homeowner's Insurance, Auto Insurance, Renter's Insurance, Extended Warranties & Protection Plans, etc.
• EPG Reporting project provides Assurant business an overview of claims processed in heavy equipment industries. EPG Insurance was acquired by Assurant in May 2018. It was Assurant's strategy to enhance its capabilities and expand its market presence in the equipment and service contract insurance sectors.
• We gather claims data from all of Assurant/EPG's heavy equipment manufacturer clients. This data from different clients is either keyed in using an online application or by doing some paper work which is then brought to our servers & databases using ETL (SSIS). Using this stored data, we generate different types of reports in SSRS and in Power BI as needed.

Responsibilities :

• Developed T-SQL scripts and ETL packages for data extraction, transformation, and loading.
• Created and published SSRS reports and Power BI dashboards, enhancing data-driven decision-making.
• Conducted unit testing and troubleshooting of ETL processes and reports, ensuring data accuracy and consistency.
• Collaborated with database administrators to optimize database performance and maintain data security.
• Documented ETL processes, data models, and reporting solutions to facilitate knowledge transfer and continuity

• Advantasure is a healthcare technology and business process services company that improves the performance of health plans and provider organizations in the delivery of government healthcare programs
• Through a comprehensive portfolio of products and services, Advantasure enables clients to lower administrative costs, increase reimbursement accuracy and improve the quality of care for their members
• OOA is one such product for Advantasure
• It handles data quality, data submissions, provider engagement, member contact and other facets of risk and quality management

Responsibilities:

• Designed and developed SSIS packages to move data from various sources into destination flat files and databases
• Troubleshoot existing SSIS packages to solve issues, Performance tuning of existing scripts and processes
• Developed Data Access Components using Stored Procedures
• Created unit Test cases and performed Unit Testing
• Worked diligently deploying and developing User help Documents for the application along with providing Production support
• Worked extensively in business analysis, interacting with business group, gathering and analyzing user requirements, functional specifications and design documents
• Environment: SQL Server Integration Services (SSIS) 2019, SQL Server 2016

• Claims Management System (CMS, Client deals in providing payment integrity solutions for different insurance sectors like –healthcare, property & casualty, etc.
• Their solutions make integrity of payments in subrogation like processes intact, helping clients to correctly deal with claims that get processed under their names
• As a data mining team gathered all the client data on one server, and by applying CMS regularized rules and business rules, provided required information on claims processing
• All this refined data is then made accessible to an application called Claims Management System (CMS)

Responsibilities:

• Involved in developing & deploying SSIS Packages
• Creating stored procedures, views, functions
• Extracting data from files like .txt, .csv and copying the data into the central repository
• Used different type of SSIS Transformations for data conversion, sorting and cleaning the data from different sources into company required format
• Using code optimizing techniques to maintain the performance and efficiency of the SSIS packages, used in the jobs
• Environment: SQL Server Integration Services (SSIS), SQL Server 2019/2014/2008R2

• Retail Sales is an overall database management system which maintains the sales records done by the client for its various products
• This provides an easy way to store the data at one place together
• Worked on Application maintenance and Support for Retail Sales across various applications
• This provides on-time support for various systems to run the business effectively without system downtimes/failures

Responsibilities:

• Interacting with business people for the requirements gathering
• Involved in designing, developing & deploying SSIS Packages
• Writing T-SQL queries to generate ad-hoc reports based on business requirements
• Creating stored procedures, views, functions
• Optimizing the stored procedures by studying the query execution plan and tools like Database performance analyzer for SQL server
• Interacting with Application Architect to have better visibility on the ongoing system changes
• Extracting data from files like .txt, .csv and copying the data into the central repository
• Used different type of SSIS Transformations for data conversion, sorting and cleaning the data from different sources into company format
• Monitoring performance of SQL server to ensure system behaves efficient and effective
• Providing weekly and monthly status reports to business, these reports include the details of overall application performance, details of any issues encountered and the fix done on these issues
• Environment: SQL Server Integration Services (SSIS), SQL Server 2008R2/2005, Excel, Database Performance Analyzer for SQL Server, Incident Management, PowerPoint, APM

• Customer Interface Enrollment & Reporting is responsible for maintaining the details of the users enrolled for the business product
• This provides visibility to track number of enrollments done which helps business to analyze and decide business strategies
• Worked on Application maintenance and Support for CI Enrollment & Reporting across various applications
• This provides on-time support for various systems to run the business effectively without system downtimes/failures

Responsibilities:

• Gathering requirement documents
• Designing ER diagrams to create the mappings between the different tables
• Creating Triggers, Stored Procedures, etc
• In T-SQL using SQL Server 2008/2005
• Providing the deliverables well within the estimated timeline
• Successfully handled the tasks distribution within the team, attended business meetings along with onsite coordinator, providing estimates on the deliverables, ensuring quality check on the deliverables, etc
• Creating & Maintaining the documentation of the applications
• Designing, Developing & Deploying SSIS packages
• Experience on tools like ORSYP to schedule the jobs running through SQL Server
• Environment: SQL Server Integration Services (SSIS), SQL Server 2008R2/2005, Excel 2007, Univiewer Console (ORSYP), Incident Management, PowerPoint

• CNC Machining is a process used in the manufacturing sector that involves the use of computers to control machine tools
• User can write programs called as CNC programs to engineer the different set of components
• This helps reducing manual work done on small lathe machines

Responsibilities:

• Creating the estimations & quotes for the “job work”
• Interacting with customers to get more business from them
• Generating invoices and purchase orders
• Storing the CNC programs in a database using SQL server 2005
• Created Excel Macro tool to fetch the CNC programs by connecting excel to database, which provided an easy interface to the CNC programmers in the company
• Environment : Excel, MS SQL Server 2005