PL/SQL Developer – Resume Sample in PDF

• Performed regular maintenance and updates on existing insurance systems, ensuring data integrity and system reliability through meticulous troubleshooting and bug fixing using Oracle SQL Developer and PL/SQL.
• Developed and executed complex queries and stored procedures to support business operations, leveraging tools such as PowerBuilder and scripting languages like Perl and Unix shell scripts for efficient data manipulation and reporting.
• Collaborated with cross-functional teams to design and implement enhancements to insurance systems, utilizing Automic AWA for automation and Visual Studio/.Net for integrating new functionalities, thus improving overall system performance and user experience.

• Designed and developed database components to support the INSIS insurance system, creating efficient PL/SQL code, stored procedures, triggers, and functions to handle complex business logic and data processing.
• Collaborated with business analysts and stakeholders to gather and understand requirements, translating them into technical specifications and ensuring the new system met business needs and regulatory requirements.
• Conducted comprehensive testing and debugging of the database components, performing unit tests and collaborating with QA teams to ensure the reliability, performance, and accuracy of the new insurance system before deployment.

• Designed and developed ETL processes using Informatica PowerCenter to extract, transform, and load accounting data from various source systems into the data warehouse, ensuring accurate and timely financial reporting.
• Optimized and maintained ETL workflows and mappings, implementing performance tuning techniques to improve data processing efficiency and reduce load times, thus enhancing the overall reporting process.
• Collaborated with finance and accounting teams to understand reporting requirements, developing and customizing reports and dashboards to provide actionable insights and support decision-making processes.

• Implemented data integration solutions using PL/SQL and Informatica PowerCenter, ensuring seamless data flow between various systems and the data warehouse, thereby supporting comprehensive data analysis and reporting needs.
• Managed version control and release processes for the data warehouse, coordinating with development and operations teams to deploy new versions, patches, and updates, ensuring minimal disruption to business operations.
• Conducted data quality checks and validation procedures, utilizing Informatica Data Quality tools and custom PL/SQL scripts to ensure the accuracy, consistency, and integrity of data loaded into the data warehouse, thereby maintaining high standards for data governance.

• Developed and maintained PL/SQL scripts and stored procedures to support portfolio management operations, ensuring efficient data processing and accurate financial calculations within the system.
• Collaborated with portfolio managers and analysts to gather requirements and provide technical solutions for portfolio tracking, risk assessment, and performance reporting, ensuring the system met the dynamic needs of the investment team.
• Optimized database performance and resource utilization, implementing indexing, partitioning, and query optimization techniques to handle large volumes of financial data, thus enhancing system responsiveness and reliability.

• Executed data migration strategies, utilizing PL/SQL and Informatica PowerCenter to transfer and transform data from legacy life insurance systems to the new Graphtalk AIA system, ensuring data accuracy and integrity throughout the process.
• Developed and maintained database schemas and structures using PowerDesigner, creating and updating tables, indexes, and relationships to support the new system’s requirements and enhance performance.
• Provided ongoing support and maintenance for the Graphtalk AIA system, troubleshooting issues, performing regular updates, and optimizing the system to ensure smooth operations and minimize downtime for end-users.

• Coordinated with cross-functional teams to manage the integration of software modules, ensuring that all components worked seamlessly together and met the stringent quality and performance standards required for automotive applications.
• Developed and maintained build scripts and automation tools using Linux scripting and make files, streamlining the build and deployment processes for embedded software across multiple vehicle models, thereby reducing development time and minimizing errors.
• Performed rigorous testing and validation of embedded software modules, including Board Computer and External Temperature modules, using a combination of automated testing frameworks and manual testing techniques to ensure compliance with automotive industry standards and client specifications.

• Designed and implemented core business applications, leveraging PowerBuilder and Informix to create robust, scalable software solutions that supported the company’s strategic objectives and operational needs.
• Led software architecture and design efforts, defining system structures, components, and interfaces to ensure that the software met performance, scalability, and maintainability requirements.
• Mentored and guided junior developers, providing technical leadership, conducting code reviews, and sharing best practices to foster a culture of continuous improvement and high-quality software development within the team.

• Managed the company’s IT infrastructure, ensuring the optimal performance and security of all hardware and software systems, including servers, networks, and workstations, to support business operations effectively.
• Developed and implemented IT policies and procedures, establishing guidelines for data management, system security, and user access to maintain a secure and efficient IT environment.
• Provided technical support and training to staff, equipping users with the knowledge and skills needed to effectively utilize the company’s software for group life insurance and other IT resources, thus enhancing overall productivity and reducing downtime.

• Developed and optimized embedded software algorithms, utilizing C/C++ to ensure the accurate and efficient functioning of the automatic MCM board tester, meeting the stringent performance criteria set by Hitachi Ltd.
• Collaborated with international teams, coordinating with engineers and developers from IBM Deutschland and other global locations to integrate various software components, troubleshoot issues, and ensure seamless interoperability of the system.
• Conducted rigorous testing and validation of embedded software, designing and executing test plans to verify the functionality, reliability, and robustness of the MCM board tester under various operating conditions and scenarios.