Akshay Patil
PLSQL Developer
Pune
Summary
CDAC Certified. Over 6+ years of experience, as a PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle.
Overview
7
7
years of professional experience
4
4
years of post-secondary education
Work History
Developer
Tata Consultancy Services
7 2022 - Current
- Client 2. - United Health Group (UHG) USA.
- Project domain: Insurance (Healthcare).
- Project - NEMIS is an application for medical services claim Submission from vendors system, validating of claims, generate encounter files, submitting those Encounter files (HIPPA & Proprietary file format like 837) of claims to USA sates and process State Responses.
Where Encounter file is combination of all information of member and provider to submit get paid for rendered service. - Role: It was migration project from PLSQL procedures, functions to java drools technology. Understanding developed PLSQL code and guide for making new d-rules in drools to java team.
- Client 1. - Amerisource Bergen Corporation USA
- Project domain: Healthcare
- Project- DFE (data feed engine) which is used to send order details to pharmacies and patients.
- Made changes and tested for existing informatica workflows and Mappings.
PLSQL Developer
ICICI Bank
03.2019 - 06.2022
- Created and modified complex database objects like Stored Procedures, Functions, Packages, Views, and Triggers using PL/SQL.
- Created Indexes on tables to improve performance by eliminating full table scans and views for hiding actual tables and to eliminate complexity of large queries.
- Involved in continuous enhancements and fixing of production problems.
- Developed several UNIX Shell Scripts to process files on daily basis like renaming file, extracting date from file, unzipping file and remove junk characters from file and according to changing needs of project and client requirements.
- Worked on SQL Loader to load data from flat files obtained from various facilities every day.
- Coordinated with front-end UI developer team to provide them with necessary stored procedures and packages insight into data.
- Handled errors using Exception Handling extensively for ease of debugging and displaying error messages in application.
Software Engineer
Euronet Servives India Pvt Ltd
07.2017 - 03.2019
- Involved in continuous enhancements and fixing of production problems.
- Created and modified complex database objects like Stored Procedures, Functions, Packages, Views, and Triggers using PL/SQL.
- Created Indexes on tables to improve performance by eliminating full table scans and views for hiding actual tables and to eliminate complexity of large queries.
- Worked on UNIX Shell Scripts for automation purpose while also on SQL Loader to load data from flat files obtained from various facilities every day.
Education
PG-Diploma - Advanced Computing
CDAC
Mumbai 02.2016 - 08.2016
B.E - Computer Science
North Maharashtra University
08.2011 - 06.2015
Skills
Database Language: PL/SQL, SQL
Programming Language: Knowledge of Python and JAVA (Core java)
Operating System: Windows, UNIX, Linux
ETL: Informatica
Timeline
PLSQL Developer
ICICI Bank
03.2019 - 06.2022
Software Engineer
Euronet Servives India Pvt Ltd
07.2017 - 03.2019
PG-Diploma - Advanced Computing
CDAC
02.2016 - 08.2016
B.E - Computer Science
North Maharashtra University
08.2011 - 06.2015
Developer
Tata Consultancy Services
7 2022 - Current