AKASH. M

Sr. ORACLE PL/SQL/ EBS DEVELOPER

PROFESSIONAL SUMMARY:

Dedicated and highly skilled Oracle PL/SQL developer with around 8 years of hands-on experience in troubleshooting and enhancing Oracle Cloud, Forms & Reports, Snowflake environments and good knowledge also with hands on experience in python scripting.

Offering extensive experience in designing, developing, and troubleshooting RPDs, dashboards, and reports. Adept at leading cross-functional discussions, estimating project effort, and providing effective solutions for reporting challenges.

Worked as Oracle PL/SQL Developer in Oracle 18c, 12c, 11g, 10g, 9i & 8i versions and IT experience in Software Development/Maintenance & Production Support Projects.

Created and integrated PL/SQL packages which load the daily batch data into the storage warehouse. Authored PL/SQL stored procedures and functions before creating Oracle packages to augment business functionality.

Resolved issues with Oracle 11g Forms/Reports application, such as workstation using side printers for slip printing and other reported problems.

Technical areas of experience related to PL/SQL, Informatica, UNIX & Shell Scripting.

Experienced in complete life cycle Implementation of PL/SQL Development.

Experienced in working in OLAP and OLTP Database environments.

Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Collections, Performance Tuning and Query Optimization.

Resolved issues with Oracle 6i Forms/Reports application running on windows 7 or Windows Server 2008R2, if upgrade option is not feasible.

Resolved issues with Oracle Forms/reports 10g or higher applications to run on or already deployed on Oracle Exalogic.

Managed all servers as well as windows 7/8 and windows server 20082/2012 use cases, like Development, Virtual machines, and Citrix platform.

Hands-on experience in Extract, Transform, and Load (ETL) processes, ensuring efficient and accurate data movement.

Proficient in creating visually appealing and insightful reports and dashboards using Power BI.

Writing complex DAX formulas for calculated columns, measures, and calculated tables to derive meaningful insights.

Crafted PL/SL packages to build payment reports for reconciliations between different systems.

Executed three full life cycle Oracle Fusion implementations, ensuring a seamless transition to the cloud suite of products.

Managed Electronic Data Interchange (EDI) integration, improving data exchange with external partners and suppliers.

Utilized Oracle Integration Cloud (OIC) to integrate Oracle Fusion Procurement with third-party applications, facilitating data flow and enhancing system functionality.

Functional and technical support of the Order Management, including Advanced Pricing, modules of Oracle E-Business Suite.

Configured Oracle Enterprise Manager (OEM) to automate and monitor numerous databases.

Led multiple full-cycle Oracle EBS implementations, focusing on AR, AP, GL, and FA modules.

Successfully configured Oracle Fusion Procurement modules, specializing in end-to-end implementation and optimization of cloud applications.

In-depth knowledge of service provider setup and rates setup within OTM.

Experienced in Python Packages like Pandas, JSON, Done data processing automation using Python.

Collaborated with the Automation team and created automation jobs processed with each billing cycle. Entrusted as a member of on-call rotation to resolve emergency tickets and ensured all files were properly loaded.

Generated Pearl Scripts, and UNIX shell scripts for automation jobs focused on processing files.

Proficiency in Java JDK Ver 11+ and Microservices development.

TECHNICAL SKILLS:

Build Tools

Maven, Gradle.

Web Services

RESTful APIs.

Testing Frameworks

JUnit, Jest.

Middleware Technologies

Kafka

Containerization & Deployment

Docker, Kubernetes.

Microservices

Spring Boot, Camel

DevOps Tools

Github

Scripting

Unix Shell Scripting.

Database

SQL on Oracle 12c/19c

Cloud Computing

Oracle Cloud, Snowflake

Big Data tools

Hadoop, Hive, HQL, NiFi, HDFS, AbInitio

PL/SQL Development

Stored Procedures, Functions, Triggers, Packages

Performance Tuning

Query optimization, Indexing, Partitioning.

Oracle Tools

SQL*Loader, TOAD, SQL Developer, SQL Tool, SQL Navigator, Developer SQL*Plus, Discoverer, Oracle BU Publisher 11g

Database Design

ER Modeling, Normalization, Data Warehousing.

Tools

SQL Developer, TOAD, Oracle APEX, SQL*Plus.

Version Control

Git, SVN

Reporting

Oracle Reports, BI Publisher.

Modules

Oracle Payables, Oracle Receivables, Oracle General Ledger,

Oracle Inventory, Oracle Order Management, AOL,

Oracle Purchasing, Sys Admin, SABRIX.

Data Modeling Tools

Erwin 4.5/4.0, Microsoft Visio 2012.

Programming Languages:

Python

Project Management Tools

JIRA, HP ALM, qTest.

EDUCATION:

Masters in computer science (MSCS) from Monroe College, New York. (2021- 2023).

PROFESSIONAL EXPERIENCE:

Client: State Farm, Bloomington, Illinois Jun 2022- Till Date

Role: Sr. Oracle PL/SQL/ EBS Developer

Description: Proactively manage the Reseller Billing System which generates monthly invoices as part of the Reseller Solution Suite (RSS). Subsequently, the system shares customer account information with respective databases. Entrusted to guide the platform which executes millions of real time client usage records composed of Voice, Data, SMS, and MSM records daily.

Responsibilities:

Proficient in both functional and technical aspects of Oracle Transportation Management (OTM).

Worked on Upgrade, maintenance and troubleshooting of Oracle Forms and Reports

Develop a best practice or standards document for Oracle 6i/10g/11g Forms/Reports application development.

Assisted in the migration and resolution of issues of the following Oracle 11g Forms and Reports applications to the Oracle Exalogic Servers.

Customize standard Unmapped Subsidiary Accounts report using Oracle Reports as per the user requirements for General ledger Consolidation purposes.

Extensively involved in configuring and setting up modules including Order Management, Packaging, Shipment Planning, Tendering, Execution, Rates, Freight Settlement, Trade Management, and customs.

Hands-on experience with SQL/PLSQL for data manipulation and retrieval within the OTM environment.

Developed complex SQL queries to extract and analyze data for reporting purposes.

Configuration and setup expertise in OTM functionalities such as Order Management, Shipment Management, Financials, Rates, Master Data, Bulk Planning Parameters, VPDs, User Configuration, and Screen Set Development.

Proficient in working with CSV and XML for data exchange.

Proficient in using Informatica PowerCenter for designing, developing, and deploying data integration solutions.

Engaged with the Revenue Assurance team and resolved client issues for each billing cycle.

Developed a variety of monitoring scripts to alert failures, low disk space, or exceptionally long jobs.

Configured Jenkins to architect and deployed code for enterprise release; credited for product enhancement.

Enhanced system performance by optimizing queries and fine-tuning indexes, leading to an 80% improvement in overall response time.

Developed and maintained a library of reusable PL/SQL code snippets, accelerating development cycles and ensuring consistent coding standards.

Designed and implemented data migration strategies, successfully transitioning shell Scripts, legacy systems to the new Oracle platform without data loss or downtime.

Successfully configured Oracle Fusion Procurement modules, specializing in end-to-end implementation and optimization of cloud applications.

Supported the EDI system, including troubleshooting issues and setting up new trading partners.

Supported the interface from Oracle EBS to our ecommerce web, working with the digital marketing team to implement new functionality.

Collaborated with cross-functional teams to deliver procurement solutions aligned with client’s business goals.

Administering, troubleshooting, and debugging Oracle databases.

Developed UNIX scripts to process feed from upstream systems that need to be loaded in a database.

To convert / transform the feeds to the required format, dynamic ETL UNIX shell scripts were developed.

Collaborated with cross-functional teams to gather business requirements and translate them into technical solutions.

Developed and implemented customizations, extensions, and interfaces to meet specific business needs.

Conducted thorough analysis of existing financial processes, identified areas for improvement, and implemented enhancements for increased efficiency.

Environment: SQL, PL/SQL, UNIX Shell Scripting, Oracle 10g/11g, Toad, SQL*Plus, SQL*Loader, PUTTY, MS Office, Windows XP.

Employer: ELLE LOGITECH, India Jul 2019- Aug 2021

Client: Citi Bank

Role: Oracle PL/SQL Developer

Project: Real Time Data Visualization (RTDV)

Project Description: The Real Time Demand Visualization project has been delivered to focus on unlocking the benefits of using real-time data & insights primarily to transform the short-term forecasting and real-time resource management functions.

Responsibilities:

Developed Python Application for google analytics aggregation and reporting.

Experienced in web Application Development using Python.

Support the interface from Oracle EBS to our ecommerce web, working with the digital marketing team to implement new functionality.

Strong experience in transforming 11i accounting to R12 accounting related to GL, AP, AR and Fed Admin.

Strong experience with federal accounting required for R12 upgrades including GTAS.

Assisted clients in the implementation of Cloud Applications and associated conversions, integrations, and reports using Oracle Cloud technologies.

Extracting and transforming data using Power Query to prepare it for visualization.

Strong troubleshooting and debugging skills for resolving OTM-related issues.

Worked extensively on agents and planning aspects in OTM, contributing to enhanced system efficiency.

Proficient in configuring and managing rates for effective transportation cost management.

Record software architecture in a software architecture document using use cases and Unified Modeling Language (UML).

Worked with UX/UI to improve and refine product visual design and consistency create, maintain, and present technical documentation to different audiences and levels.

Prepare required documentation, including project plans, software program, and user documentation.

Technical experience with Oracle Applications 11i and Release 12 implementations in SCM, Order-to-Cash Flow, Finance Areas.

Excellent working experience in designing, building, customizing, and supporting RICEWF objects for Oracle EBS R12.

Also experienced in publishing reports to Power BI Service and sharing them with stakeholders.

Optimizing Informatica workflows for better performance and resource utilization.

Integrating Informatica with various databases such as Oracle, SQL Server, and others for seamless data transfer.

Utilized APEX, PL/SQL, SQL, HTML and XML to develop robust and scalable solutions.

Demonstrated proficiency in using APEX, TOAD, and Oracle for application development and database management.

Brought extensive knowledge of Oracle On-Prem Procurement to supplement Oracle Fusion solutions.

Assisted in the integration of Oracle On-Prem Procurement and Oracle Fusion solutions, ensuring a cohesive and efficient procurement ecosystem.

Collaborated with the team to provide insights into the functional aspects of Oracle On-Prem Procurement, contributing to a more comprehensive understanding of procurement processes.

Participated in Material Availability Planning to maintain optimal inventory levels while meeting customer demand.

Designed and implemented data migration strategies, successfully transitioning shell Scripts, legacy systems to the new Oracle platform without data loss or downtime.

Collaborated with clients to identify business requirements and translate them into effective Oracle Fusion solutions.

Executed three full life cycle Oracle Fusion implementations, ensuring a seamless transition to the cloud suite of products.

Supported supply analytics initiatives by extracting and analyzing data to drive supply chain optimization.

Monitored and administered numerous databases in UNIX/Linux environments on Oracle 11gR2 databases.

Troubleshooted and resolved user connectivity and account lockout issues.

Created and integrated PL/SQL packages which load the daily batch data into the storage warehouse.

Authored PL/SQL stored procedures and functions before creating Oracle packages to augment business functionality.

Crafted PL/SQL packages to build payment reports for reconciliations between different systems.

Responsible for creating and managing tablespaces and datafiles.

Entrusted as a member of on-call rotation to resolve emergency tickets and ensured all files were properly loaded.

Generated Pearl Scripts, and UNIX shell scripts for automation jobs focused on processing files.

Configured Jenkins to architect and deployed code for enterprise release; credited for product enhancement.

Worked on various EBS development projects, including custom reports, forms, and workflows.

Environment: Oracle 10g / 11g/12c/18c, SQL, PL/SQL, SQL*PLUS, Informatica, SQL*Loader, CVS, TOAD, UNIX, Shell scripting. Python, Scala, Hive, Apache NiFi, Power BI, Spark, JIRA, My SQL, Putty, Hadoop, Python.

Employer: CENT Solution Technical Services, INDIA Jun 2016- Jul 2019 Client: Prime Healthcare

Role: Software Engineer

Responsibilities:

Performed code reviews and implemented best python programming practices.

Experienced in python test driven development techniques.

Generated Python Django Forms to record data of online users.

Collaborated with cross-functional teams to analyze business requirements and design efficient database solutions.

Developed, tested, and maintained complex PL/SQL code for various applications, ensuring optimal performance and data integrity.

Assisted in the transition from Oracle DBA to Oracle Development, contributing to the successful upgrade of legacy applications to the Cloud.

Worked closely with the Sr. Oracle DBA in a team-oriented environment, providing support and expertise in Oracle development and SQL queries.

Participated in the GDS Program, collaborating with clients on Mortgage Security projects, specifically with Ginnie Mae.

Upgraded legacy applications to new technologies, ensuring alignment with industry best practices and standards.

Involved in the end-to-end phase of the project including Requirements gathering, Blueprint discussion Realization, Testing and Go Live phase.

Performed the impact analysis assessment on the requirements and provided a Test Estimation followed by Test Strategy.

Developed and deployed a RESTful web service using Python and Flask, resulting in a 25% reduction in server response time and a 15% increase in user satisfaction.

Collaborated with front-end developers to integrate user-facing elements with server-side logic, resulting in a seamless user experience and a 10% increase in user engagement.

Created Test Plan, Test scenarios and detailed Test design which covered all the requirements (Functional & Non-Functional).

System design development, testing, implementation, troubleshooting and support of the merchandise distribution centers, the transportation logistics, the sales analysis, the demand forecast and the supply chain planning systems.

Understanding of source file’s structure and data format which are coming from 3rd party systems.

Environment: Oracle 10g, PL/SQL, Oracle FMW, Xml, Visio, UNIX Shell scripts, SVN, Toad, SQL Developer, HP Quality Center, SQL *Loader, Import Export, Autosys.

Contact this candidate