Mizail Sharon Paul.P

Client : Prudential Limited
• Enhanced client satisfaction by providing tailored solutions and
recommendations for their business needs
• Analyze the Source Data and design high-level mapping document
considering BaNCS structure.
• Writing the Mapping Document with Transformation Logic.
• Discuss with Client related to Data Quality Issues and finalize the best
possible solution.
• Discuss with Process Team and finalize the migration strategy and
preparing Migration Strategy Document and share with Client.
• Design and Modified the Load plan In ODI as per requirement.
• Establishing plans for deliverable and always maintain the
timeline.
• Tuning the SQL code for better performance.
• Ensuring Quality Testing,Reconcile and validate the data before delivery.
• Maintaining Change log & version log for Defect Management.
• Writing SQL code based on testing scenario and provide the same to
testing team.
• Developer with comprehensive understanding of all aspects of data and
reporting from analytic perspective for insurance domain
• Engaged in the development and execution of migration reconciliation
reports, ensuring accurate and comprehensive tracking of data transfer
during the migration process.

• Streamlined processes by automating repetitive tasks, saving time and resources.

• Improved software quality by conducting thorough code reviews and implementing best practices.

• Performed data manipulation using ODI first as team member

• Managed database tables,procedures and indexes.

• Led the successful migration initiative from Oracle to Azure Synapse, involving thorough assessment, data extraction, transformation, and loading processes. Collaborated with cross-functional teams to ensure seamless application migration, conducted comprehensive testing to validate data integrity and system performance, and implemented optimizations for enhanced functionality in the Azure Synapse environment.

• Analyze and develop existing codes in order to incorporate user requirement.

• Make amends in existing coding in order to keep this synchronized with Front end, data ware house system .

• Tested SQL and SQL Loader programs for database application.

• Implemented enhancements to existing software products.

• Performed data manipulation using ODI first as team member.

• Worked in domains like MEDIA and POSTAL

• Developed strong relationships with clients, leading to high customer satisfaction rates and repeat business.
• Assisted in the design and development of innovative technical solutions, resulting in increased profitability for the company.
• Effectively executed ERP (Enterprise Resource Planning) processes within the KIMS Group of Hospitals,
  streamlining and optimizing organizational workflows for enhanced efficiency and performance.

• Implemented Database security modules for leading Insurance company in Switzerland

• Implemented Database security modules for leading Human resource consulting firm in USA

• Based on customer requirement, developed multiple data masking functionalities.

• In multiple POC’s, worked as a Product specialist deployed MENTIS products and demonstrated customer use cases.

• As a Senior Product Specialist while installing or upgrading our application in client side I need to take care of end-to-end process until the implementation project will get completed and signed off by clients.

• Need to clear client’s queries regarding uses of application and need to give the knowledge of added advantages

of the particular product and how they can use the product in best way.

• Need to give best solutions if client faces any issues while using the product and if they need any customization

on the existing product.

• Participated in Preparing Technical demo environment with all MENTIS Modules.

• Design and Developed new requirement using sql,pl/sql

and T-SQL

• Worked in development and maintenance of system integrity for Accounts

related processes and report

• Responsible for preparing test cases,root cause analysis and maintain change control log.

• Implemented robust error handling and logging mechanisms to improve system reliability and simplify troubleshooting efforts.