SHAIK SHARPUDDIN

• Project Name : Shareholder reporting .
• Client : Landmark group.
• Role : Team Member/Oracle SQL and PLSQL Developer
• Environment : Oracle 11g, SQL, PLSQL, SQL Developer, Git, OBIEE.
• DESCRIPTION :
• Shareholder Report is a customization reporting application .It provides a standard -sized workflow to increase transparency and collaboration between clients ,auditors and internal teams which helps shareholders to become updated and aware about the status and progress of their shares in a particular company .
• Roles & Responsibilities:
• * Involved in all day to day activities related to databases like data consolidation, data migration.
• * Worked on PL/SQL queries for creating data validation rules
• *
• Created complex views, materialized views on multiple tables as per customer requirement.
• * Involved in creating Indexes for faster retrieval of data.\n Created PL/SQL stored ,
• *
• Writing Queries, Sub-queries, Joins.procedures, functions and packages for calculation and database tables joins.
• * Monitoring the jobs in UC4 Tool.
• *
• Checking log files in the WINSCP Tool.
• * Creating HPSM Tickets for failed jobs.
• * Modified existing procedures, functions as per the Project requirements.
• * Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• * Created Cursors for dynamic operations at various levels as per the requirement
• * Used bulk collect for mass update as performance improvement process.
• * Used Pragma Autonomous Transaction to avoid mutating problems in database trigger.
• * Using the SQL Developer tool we debugging the code and unit test.
• * Monitoring the jobs in UC4 Tool.\n. Creating HPSM Tickets for failed jobs.

Client : Mapfre

Project Title : Mapfre Insurance project.

Environment : SQL, PLSQL Developer.

Role : Support role- Incident Analysis.

Team Size : 15.

Tools : SQL Developer, Service Now,Splunk,Robot Scheduler

Duration : OCT 2022 to Till now .

• Developed scalable and maintainable code, ensuring long-term stability of the software.

Description:

Mapfre Insurance is a leading global insurance provider, known for offering a comprehensive range of insurance solutions across auto, home, health, life, and commercial sectors. With a strong presence in over 40 countries, Mapfre emphasizes innovation, customer-centric services, and sustainability. The company leverages advanced digital platforms to enhance the customer experience, providing seamless policy management and claims support. Recognized for its commitment to social responsibility, Mapfre is actively involved in community and environmental initiatives, making it a prominent player in the international insurance landscape.

• Integrated new technologies into existing systems, increasing capabilities and improving overall performance.
• Developed reusable components that significantly reduced development effort on multiple projects.
• Implemented effective debugging strategies, resulting in fewer software defects and increased reliability.
• Consistently met project deadlines by effectively managing time and prioritizing tasks according to importance.
• Analyzed proposed technical solutions based on customer requirements.
• Established efficient communication channels within the team, leading to better collaboration among members during project development phases.
• Developed robust, scalable, modular and API-centric infrastructures.
• Increased code quality and reduced bug rates by establishing comprehensive unit and integration testing protocols.
• Reduced system downtime and improved reliability by proactively identifying and addressing potential system vulnerabilities.
• Involved in all day to day activities related to database like data consolidation, data migration scripting.
• Designed data models and database schemas to support complex data storage and retrieval requirements, ensuring data integrity and accessibility.
• Participated in agile development processes, including daily stand-ups, sprint planning, and retrospectives.
• Developed next generation integration platform for internal applications.
• Improved software performance by identifying and resolving bottlenecks in the code.
• Conducted thorough code reviews to identify potential areas for improvement, ultimately enhancing code quality across all projects handled by the team.
• Refactored legacy codebases for improved maintainability, paving the way for easier future updates.