Biswanath Singha Roy

PROJECT DESCRIPTION

Given On the spot and technical excellence award for implementing, Reward data calculation tool and developing Reward monthly data report

• Automation and correction of Commission, Incentive & Reward reports with prerequisite checking
• Created a master scheduler which would run stored procedure and maintain a log to help automate daily and monthly report with auto mail feature
• Have been appreciated for my pro activeness and problem-solving skills during account closure
• Received Service & Commitment Award and Learning Achievement Award two times
• Team size- 124
• Role- PL/SQL, Application layer:-ASP.NET 3, 0,IIS 7.0,MS VISUAL STUDIO 2013 (DATABASE:-ORACLE 12c Enterprise Edition Release 12.2.0.1.0)
• Project details:- GENISYS Configurator addresses the needs of United India General insurance system
• ATri-partite agreement was entered into between DXC, TCS and UIIC
• The scope of the project is development, support and maintenance
• It is an entire suite of components serving the needs of a typical general non-life insurance organization, or as individual components catering to specific organizational needs
• GENISYS Configurator has a product definition engine component that allows the users to define new insurance about 200+ products, make changes to existing products, and establish rules that govern these products
• Responsibilities:
• Developed complex SQL queries with joins, date functions, inline functions, sub-queries to generate reports,
• Create Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors
• Create PLSQL Object Types, Oracle Parallel Queries, Materialized Views using Bulk Collects, Bulk Load, Regular Expressions, Merge
• Performance Improvement
• L Experienced in OLTP, OLAP, Relational Database Management Systems RDBMS and Report Development. Also proficient in Data Transformations and loading using SQL Loader and worked on External tables and Transportable table spaces.
• Analyzed existing SQL queries to identify opportunities for improvements.

• ORACLE 12c )
• Project details:- GENISYS Configurator addresses needs of United India General insurance system
• Tri-partite agreement was entered into between DXC, TCS and UIIC
• Scope of project is development, support and maintenance
• It is an entire suite of components serving needs of typical general non-life insurance organization, or as individual components catering to specific organizational needs
• GENISYS Configurator has a product definition engine component that allows users to define new insurance about 200+ products, make changes to existing products, and establish rules that govern these products
• Responsibilities:
• Create PL/SQL Stored Procedures, Functions, Packages, and Triggers
• Debugging using PL/SQL Stored Procedures, Functions, Packages, and Triggers and standard built-in Oracle packages
• Implementation of different logic for report generation and documentation
• Development and implementation of interactive reports for respective line of business using Eclipse BI report
• Monitoring scheduled jobs.
• Analyzed existing SQL queries to identify opportunities for improvements.

• Team size- 74
• Role-, 2008) (DATABASE:-ORACLE 10G ENTERPRISE R2 in HP UX and Redhat Linux)
• Project details- GENISYS Configurator addresses the needs of United India General insurance system
• A Tri-partite agreement was entered into between DXC, TCS and UIIC
• The scope of the project is development, support and maintenance
• It is an entire suite of components serving the needs of a typical general non-life insurance organization, or as individual components catering to specific organizational needs
• GENISYS Configurator has a product definition engine component that allows the users to define new insurance products, make changes to existing products, and establish rules that govern these products
• Responsibilities:
• Develop SQL scripts, indexes, and complex queries
• Configuration and version management
• Ensure data integrity is maintained through security and change management
• Coordinate between project management and development teams
• Identify the data issues and provided solution options for resolution
• Monitor entire application development, execution, and maintenance.

• Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
• Updated old code bases to modern development standards, improving functionality.
• Discussed issues with team members to provide resolution and apply best practices.