Banner Image

All Services

Programming & Development

Python_Developer_Oracle_PLSQL_Developer

$9/hr Starting at $30

ACCOMPLISHMENTS: ? Business user reported that having challenge in comparing two reports in different formats being generated with same source with more than 65k records. Automated Report validation process consumed manual effort of 120 Hours and reduced to 40 Mins and generate user defined reports in Excel sheet using PANDAS in PYTHON. ? Single handedly analyzed and migrated 2.7 lakh lines of legacy Pro*C code to PYTHON in just 15K lines in crucial timeline (90 days) which reduced the CYCLE RUN TIME from 2hrs to 30 mins. ? Migrated the core processing of INTERCHAGE FEE application in Pro*C to PERL due to production issue caused since User fed wrong info in Application pricing tables. Recovered the data by modifying correct info and posted the data for ACH settlement in 2 days within defined SLA to avoid penalties for the Organization. ? Captured the long running jobs in legacy system and migrated to Python which reduced the runtime to 60%. ? Monitored the long running complex queries and optimized the performance by tuning using Indexes. ? Improved the performance of Application programming and reduced the Database CPU utilization by using Data science packages like PANDAS DataFrame and NumPy.

About

$9/hr Ongoing

Download Resume

ACCOMPLISHMENTS: ? Business user reported that having challenge in comparing two reports in different formats being generated with same source with more than 65k records. Automated Report validation process consumed manual effort of 120 Hours and reduced to 40 Mins and generate user defined reports in Excel sheet using PANDAS in PYTHON. ? Single handedly analyzed and migrated 2.7 lakh lines of legacy Pro*C code to PYTHON in just 15K lines in crucial timeline (90 days) which reduced the CYCLE RUN TIME from 2hrs to 30 mins. ? Migrated the core processing of INTERCHAGE FEE application in Pro*C to PERL due to production issue caused since User fed wrong info in Application pricing tables. Recovered the data by modifying correct info and posted the data for ACH settlement in 2 days within defined SLA to avoid penalties for the Organization. ? Captured the long running jobs in legacy system and migrated to Python which reduced the runtime to 60%. ? Monitored the long running complex queries and optimized the performance by tuning using Indexes. ? Improved the performance of Application programming and reduced the Database CPU utilization by using Data science packages like PANDAS DataFrame and NumPy.

Skills & Expertise

OraclePerlPL/SQLPythonSoftware DevelopmentUnix Shell Scripting

0 Reviews

This Freelancer has not received any feedback.