| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Oracle PL/SQL DeveloperEMAIL AVAILABLE Street Address https://LINKEDIN LINK AVAILABLEPROFILE SUMMARYWith over six years of dedicated experience as a PL/SQL Developer, I bring a wealth of expertise in Oracle PL/SQL programming, Oracle BI, and Warehouse Management System (WMS). Throughout my career, I have consistently demonstrated a strong aptitude for designing, developing, and optimizing data analytic solutions tailored to the unique needs of various industries, including Banking, Healthcare, and Insurance. My journey in software development has equipped me with the skills to design and implement robust solutions, making me well-suited for dynamic roles in PL/SQL development.Proficient in Oracle SQL, PL/SQL, PostgreSQL, MS SQL, T-SQL.Skilled in managing Oracle database systems, covering versions 10g, 11g, and 12c.Strong background in data modeling, including ER creation and maintenance, with a focus on physical modeling for scalability and performance.Developed complex queries, packages, procedures, and functions to support various business processes.Created intuitive user interfaces using Oracle Forms to streamline data entry, validation, and retrieval processes, enhancing user productivity, and improving overall system usability.Involved in different project phases, from initiation to deployment, testing, and debugging client-server applications.Developed and maintained complex BI reports and dashboards using Oracle Business Intelligence (OBIEE) to meet business requirements.Designed interactive and dynamic reports that provided actionable insights for decision-making processes.Prepared technical specification documents by thoroughly understanding the business requirements, analyzing them, and marking the areas of changes.Demonstrated proficiency in creating clear, comprehensive documentation for software projects, including Functional and Technical design documents.Active involvement in designing database schema, tables, views, and other objects in Oracle.Collaboration with DBA for CRUD operations and DDL tasks in Oracle, including schema creation, table management, index maintenance, materialized views, and table partitioning.Developed and implemented robust validation rules, data constraints, and consistency checks, reducing data errors.Skilled in optimizing database performance, implementing partitioning strategies, and providing recommendations to efficiently handle massive volumes of trading data while ensuring scalability and reliability.Optimized performance through fine-tuning SQL queries, indexing strategies, and query execution plans.Expertise in exception management, date and time functions, aggregate functions, and analytical functions.Implemented joins and hierarchical queries to fetch and manipulate data efficiently.Extensive hands-on experience in advanced performance tuning techniques for SQL Server databases, including index optimizations and query tuning, resulting in significant improvements in query execution times and overall system responsiveness.Customizes and optimizes auditing triggers specific data security needs, contributing to a more secure database environment.Optimizes database performance through fine-tuning SQL queries, indexing strategies, and query execution plans.Proficient in utilizing tools such as AWR, ADDM, ASH, and other Oracle performance tuning utilities to optimize database performance.Restructured the PL/SQL codebase, resulting in a 30% reduction in application errors and a significant improvement in performance.Developed and automated data pipelines to extract and transform data from Oracle databases to feed into Oracle BI for reporting and analytics.Familiarity with GitHub to ensure security, scalability, and continuous integration/continuous deployment (CI/CD) practices within development environments.Played a key role in guiding data migration efforts during a company acquisition, ensuring seamless integration of databases within specified project timelines.Practiced Agile principles and methodologies such as Scrum to iteratively deliver high-quality software solutions in a collaborative and adaptive environment.Participated in Agile ceremonies including sprint planning, daily stand-ups, sprint reviews, and retrospectives to prioritize tasks, track progress, and identify areas for improvement.TECHNICAL SKILLS:Operating SystemsWindows XP/2003/7/8/10, Unix, LinuxDatabasesOracle (versions 10g, 11g, and 12c), SQL Server 2008/2012, MongoDBLanguagesOracle SQL, PL/SQL, PostgreSQL, MS SQL, Transact-SQL(T-SQL), MongoDB, Core Java, Python, XML, HTML, CSS, Javascript, XML, DBMS, PostgreSQL, Shell scripting.Tools and ApplicationsSQL developer, SQL*Plus, SQL Loader, WinSCP, PuTTY, OTBI, BIRT, Oracle Business Intelligence (OBIEE), Oracle Cloud, ODI, Microsoft office 365, Visual Studio, Service-Now, SharePoint 2013, SQL Server management studio, SSIS, SSRS, SSAS, Oracle Forms and Reports, Oracle Healthcare Data Warehouse (HDW), Power BI, Dell Boomi, Azure Synapse Analytics.PROFESSIONAL EXPERIENCEClient: Maxim Healthcare Services, FL Feb 2023 PresentRole: Oracle PL/SQL DeveloperResponsibilities:Gathered requirements from data analysts and architects, and then analyzed them to find a practical solution.My responsibilities included analyzing, designing, coding, debugging, and deploying systems. Collaborated with the team to create database objects like tables and procedures using Oracle tools such as PL/SQL.In addition, prepared functional and user documents, process flow diagrams, and flow charts. Developed PL/SQL packages, procedures, and functions based on business requirements.Wrote complex Oracle SQL queries with various components like Inner/Outer joins, Indexes, Sequences, Union All, Intersect, and Minus set operators.Troubleshooted performance issues and bugs within anonymous blocks, partitioned DBMS output, and explained plans.Leveraged PL/SQL expertise to extract, transform, and analyze ERP data, contributing to the optimization of business processes and performance monitoring.Developed and maintained interactive dashboards using Power BI, empowering users with real-time data visualization and drill-down capabilities for deeper analysis.Implemented indexing strategies, partitioning techniques, and query optimizations to handle large volumes of healthcare data efficiently.Implemented SSIS packages to automate the extraction, transformation, and loading (ETL) of clinical data from disparate sources, improving data accuracy and operational efficiency.Collaborated with healthcare professionals to understand their data needs and developed custom reporting solutions using SQL Server Reporting Services (SSRS), empowering stakeholders with actionable insights for patient care and decision-making.Created and maintained BIRT reports for healthcare projects, including patient management, appointment scheduling, and resource utilization.Implemented ETL processes using ODI to ensure seamless data flow and integrity across multiple healthcare systems including EHR systems, billing systems, and laboratory systems in the Oracle Healthcare Data Warehousing (HDW) to provide a unified view of patient information and support analytics and reporting.Created logical and physical data models to support Oracle BI reporting needs, ensuring data accuracy and consistency.Played a role in deployment and post-deployment support, created indexes on tables for faster data retrieval, and loaded data using PL/SQL and SQL*Loader, calling UNIX scripts for file manipulation.Documented the design, development, implementation, daily loads, and process flow of Informatica mappings.Additionally, wrote PL/SQL database triggers to implement HIPAA rules and analyzed SQL statements, reorganized database objects, and designed indexes to improve query response.Utilized Power BI advanced formatting capabilities and data visualization techniques to create visually appealing and informative reports for executive stakeholders and regulatory bodies.Developed predictive analytics models in Power BI, using Azure Synapse as the backend, to forecast patient admissions, optimize staffing, and enhance resource planning.Automated data backup procedures using shell scripts, ensuring the regular and systematic backup of critical healthcare data, thus enhancing data security and integrity.Experienced in producing detailed Functional and Technical design documents that outline healthcare system architectures, data models, interoperability requirements, and regulatory compliance measures, facilitating effective implementation and maintenance of healthcare IT solutions.Provided on-call support, resolved user issues, and made necessary changes.Environment: Oracle Database 19c/12c, Oracle E-Business Suite, OBIEE, BIRT, SQL Developer, Putty, WinSCP, Shell Scripting, XML, SQL * PLUS, SQL Loader, Oracle Forms Builder 12c, TOAD, UNIX, SQL Server, SSIS, SSRS, Oracle Healthcare Data Warehouse (HDW), Oracle Cloud, Azure Synapse.Client: INFOSYS Nov 2020 Aug 2022Role: PL/SQL DeveloperProject Description: As a PL/SQL developer at Infosys, I contributed to the development and implementation of a comprehensive data management and automation system for CMACGM Logistics Company, a leading global logistics and shipping services provider. The project aimed to streamline data processing, enhance operational efficiency, and improve decision-making capabilities within CMACGM's logistics operations. Leveraging my expertise in PL/SQL development, I played a vital role in designing and implementing robust solutions tailored to CMACGM's unique business requirements.Responsibilities:Collected change request requirements with the business team, creating comprehensive design documents.Facilitated user access to front-end tools after obtaining necessary approvals.Developed PL/SQL packages for implementing change requests, creating diverse database objects, including tables, views, sequences, stored procedures, functions, packages, cursors, ref cursors, and triggers.Managed complex shipping development projects from inception to production within tight deadlines, receiving recognition for meticulous handling of critical tasks in cargo management.Implemented validation rules, constraints, and cargo consistency checks to uphold data accuracy and integrity, ensuring compliance with shipping regulations and standards.Crafted complex SQL statements, employed Oracle Hints for optimization, and utilized bulk collection for enhanced performance.Written SQL queries to extract data from multiple tables and databases and generating reports for business analysis.Implemented indexing strategies, database partitioning, and query optimizations to improve response times and reduce resource contention.Implemented thorough error handling procedures for debugging and maintainability.Conducted data cleansing to eliminate erroneous entries from the Data Warehouse tables.Developed and optimized ETL processes to extract, transform, and load data from various sources into the Oracle BI data warehouse.Utilized Azure Synapse to integrate and process large datasets from various logistics systems, enabling efficient data analysis and reporting in Power BI.Managed the day-to-day maintenance of Oracle databases supporting logistics applications, ensuring high availability, performance, and data integrity.Experienced in conducting performance benchmarking tests and analyzing results to identify performance bottlenecks, validate tuning efforts, and provide actionable recommendations for improving system performance and scalability.Utilized Oracle Forms and Reports to develop user-friendly interfaces and generate dynamic reports, collaborating with cross-functional teams to translate business requirements into effective PL/SQL code, ensuring optimal performance and cargo data integrity.Proactively troubleshooted and optimized Oracle Forms and Reports applications to enhance functionality and user experience, contributing to the success of complex shipping projects at CMACGM.Leveraged Oracle EBS Warehouse Management System (WMS) features such as cargo tracking, handling verification, and shipment tracking to enhance cargo accuracy, minimize handling errors, and elevate customer satisfaction.Leveraged Oracle EBS WMS features such as pick confirmation, packing verification, and shipment tracking to ensure order accuracy, minimize errors, and enhance customer satisfaction.Designed and developed complex reports using BIRT for logistics operations, including inventory management, shipment tracking, and supply chain performance.Customized BIRT reports to include interactive elements, allowing users to drill down into data for detailed analysis of logistics processes.Prepared Unit test documents like UTP and UTR as part of the development done in such a way that it captures all the scenarios that can get impacted by the changes done.Prepared migration related documents when a developed component is successfully tested and is ready to be deployed in production environment.Deployed code across environments to maintain consistency, updating version control in Clear Case.Generated test cases for the verification and validation of change requests.Implemented Agile practices within the development team, including daily stand-up meetings, sprint planning sessions, and retrospectives, to foster collaboration and transparency.Environment: Oracle Database 19c/12c, Oracle E-Business Suite, OBIEE, BIRT, SQL Developer, TOAD, Putty, WinSCP, Shell Scripting, XML, SQL * PLUS, ODI, SQL Loader, OTBI, Oracle Forms Builder 12c, Java, Data Migration, Power BI, Azure, Oracle Reports 9i/10g, Informatica, BI Publisher.Client: Oriental Insurance Oct 2017 Nov 2020Role: PL/SQL developerProject Title: Oriental Insurance Database Management and OptimizationProject Description: The Oriental Insurance Database Enhancement project was all about making the company s general Insurance database system work even better. We handled requests to change the database, created templates for those changes, and used tools like SQL Server, MS SQL, Visual Studio, and SSIS to get the job done.Responsibilities:Reviewed and analyzed database change requests for the General Insurance division.After approval, created and updated database change templates using Visual Studio.Designed and implemented a policy management system using SQL, PL/SQL, and Java, allowing insurance agents to create, modify, and retrieve policy information efficiently.Implemented authorized changes, including tasks like creating, dropping, renaming, and altering database objects such as tables, indexes, and materialized views.Developed PL/SQL-based risk assessment models to evaluate trading risks associated with investment portfolios, derivatives, and financial instruments.Contributed to the development of insurance claim processing systems by creating complex DML statements and stored procedures to handle diverse policy scenarios.Utilized PL/SQL queries to calculate Value-at-Risk (VaR), stress testing scenarios, and portfolio risk measures to monitor trading exposures.Implemented partitioning strategies based on trade date and transaction date to improve query execution speed and resource utilization.Developed monitoring tools and dashboards to provide real-time insights into trading activities and performance metrics.Handled recurring database change requests by utilizing existing templates, ensuring efficiency.Utilized ODI to automate the extraction, transformation, and loading (ETL) processes, consolidating data from multiple sources into production servers.Directed programming and documentation development team, offering insight into design process and procedures.Integrated SQL databases with market data sources, trading platforms, and financial data feeds to capture real-time market data, pricing information, and trading volumes.Developed PL/SQL scripts to normalize and clean market data for use in trading analytics and decision-making processes.Analyzed and optimized SQL queries used in Oracle BI reports for better performance and efficiency.Led the implementation and rollout of data exchange mechanisms, overseeing end-to-end deployment from system design to execution.Executed thorough testing procedures to validate the integrity and accuracy of data transfers, mitigating potential risks and ensuring compliance with regulatory standards.Proactively identified opportunities for process improvement and optimization within the data exchange framework, driving continuous enhancement initiatives to streamline workflows and enhance system performance.Employed a data-driven approach to identify bottlenecks and inefficiencies, implementing targeted solutions to optimize resource utilization and minimize downtime.Assisted with deployment of applications in various environments such as development, test, staging, and production.Collaborated with cross-functional teams to design and deploy Power BI reports and OTBI dashboards in the Insurance domain, facilitating data-driven insights into policyholder demographics, claim patterns, and underwriting risks.Documented program development and subsequent revisions with comments for easy comprehension.Gathered and analyzed functional requirements to convert them into technical requirements.Environment Oracle 10g/19c, SQL Developer, OTBI, OBIEE, Power BI, MSSQL, PL/SQL, ODI, Oracle EBS, JAVA, XML, Visio, UNIX Shell scripts, SQL Server, SQL *Loader, SSIS, SSRS, Dell Boomi, GIT.EDUCATIONMaster s in science 3.86/4.00 CgpaRowan University, Glassboro NJ.Bachelor of Technology 8.92/10.0 CgpaHindustan University, Chennai, India. |
