Debadyuti Sardar

Working for UK's Leading Specialist Insurer of Commercial and Personal risks, Hiscox Plc.

• Migrated codebase and application build and deployment process from Bitbucket and Bamboo to Azure DevOps single handedly.
• Used Blob Storage to download ARM Template and overridden environment specific parameters.
• Developed high performant Azure Data Factory Pipelines.
• Worked flexible hours across night, weekend, and holiday shifts.
• Demonstrated respect, friendliness and willingness to help wherever needed.
• Learned and adapted quickly to new technology and software applications.
• Demonstrated leadership skills in managing projects from concept to completion.
• Resolved problems, improved operations and provided exceptional service.
• Used GitHub for Code management and support various application prodtion release

• Worked for UK's Largest Mutual Insurer, Royal London Pension & Insurance
• Understand existing client’s application process, related to Schemes, Schemes related investments and personal pension investments from SMEs
• Interaction with Development Lead, SMEs and Business Analysts on daily basis
• Gathering Business requirement for validating policy and build transformation logic
• Gathering Business requirement for extract master investment/Individual funds data, Policy level investment extract data and build transformation logic
• Analyze Schemes and investment data as well as policy level data and decide how legacy data can fit into new investment control system as per the new data model
• Perform data volume analysis which will help business to make delivery decisions
• Preparing High Level & Low Level Technical Design Document, ETL process document, Data Reconciliation process document
• Writing PL/SQL Package & Procedure to implement policy validation process, data extract process and the data reconciliations process
• Page 2 of 5
• Writing Oracle SQL queries to extract master Schemes, investments and individual funds data as well as policy level investment data using business transformation rules
• Making validation, extract and reconciliation process configurable and dynamic using metadata
• Developing reconciliations dashboard and Migration stages dashboard using
• SQL and Excel to present the ETL situation for taking business decisions
• Preparing unit test case document and unit testing
• Perform performance testing and performance tuning for long running queries using explain plan, AWR reports (supplied by DBA), creating necessary index or dropping unnecessary index or force index whenever required if not using by optimizer
• Deliver the data extract as per the investment control system data model
• Sharing knowledge to the juniors/testers if they have any gap in application/ process understanding
• Check-in codes into server using version control tool.

• Worked for UK's Largest Airline, British Airways
• Responsible for Cost Estimation & resource loading for the implementation based on initial project scope and assumption
• Interacted with IT stakeholders as well as Business stakeholders on daily basis
• Gathered required Business Logic for new allowance from the Business
• Responsible for impact analysis of the existing application to integrate new allowance
• Prepared High Level & Low Level Technical Design Document
• Presented Technical Design Overview to the stakeholders
• Mentoring and providing technical guidance along with business understanding of the project to the new on boarders to facilitate the smooth absorption of the application process and in development of the new allowance
• Writing PL/SQL Package & Procedure to implement the new allowance and make necessary changes to the impacted areas
• Conducting UAT and provide UAT support
• Responsible for preparing Live Implementation Plan.

• Responsible for creating complex conversion scripts for Extraction
• Transformation and Loading data using PL/SQL for various clients as well as tuning complex PLSQL programs for multiple reputed clients
• Created and developed complex SQL queries and PL/SQL procedures, functions, packages and database triggers
• Performed extensive performance tuning of SQL and PL/SQL scripts
• Created Explain Plan and used Index Hints to tune SQL and PL/SQL Scripts to improve performance
• Designed, Analyzed, Extracted, Transformed and loaded data into Oracle
• Tables using PL/SQL Conversion Scripts for implementing Oracle Data
• Warehouse from different sources to Oracle tables
• Writing PLSQL codes to facilitate business functions and calculations
• Designed and developed complex Forms and Reports
• Created various control scripts and loaded data into Oracle database from excel using SQL
• Loader
• Extensively involved in diagnostics, troubleshooting, analysis and resolution of support issues and defects as well as full system development life cycle (SDLC) of multiple Oracle Projects
• Providing Production onsite support / customization, coordinating with client
• Mentoring and providing technical guidance along with business understanding of the project to the new on boarders to facilitate the smooth absorption of the same
• Monitoring every day batch runs and fixing issues if any during the batch run
• Interacted with the UAT teams to address problems and concerns in the areas related to database
• Extensively involved in Unit testing, Integration testing and UAT testing
• Created Technical Documentation and mentored other members in the team
• Prepared and tested Unit Test Cases and documented results.

• India Limited & Eveready Industries India :
• Provided support & developed PL/SQL programs to enhance Payroll application process
• Meeting clients, understanding their problems and solving them
• Designed and developed complex Forms and Reports
• Extensively involved in Unit testing, Integration testing and UAT testing
• Page 4 of 5
• Created Technical Documentation and completing the assignments well within the time frame.

• Started working for Bharat Coaking Coal Limited as PL/SQL Developer and responsible for daily Client Interaction and Understanding the Client’s Needs and Solving them immediately after a Detailed Analysis of the same by either developing or making necessary modifications in our existing codes, making necessary modifications in Procedures, Functions, Triggers (SQL, PL/SQL) to customize the Software, Developing reports on Oracle 6i Report Builder.