AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF14261
profile image
Manatkar V AXF14261 Active
Plsql/sql developer in Pune
PL/SQL Developer with 4 years of experience,I have honed my skills in designing, implementing, and maintaining business-critical applications using Oracle databases. My expertise spans the entire software development life cycle, from requirements analysis to deployment and maintenance. I am proficient in Oracle PL/SQL, SQL, and database performance optimization techniques. My strong analytical and problem-solving skills, coupled with excellent communication abilities, allow me to collaborate effectively with cross-functional teams to deliver high- quality solutions.
Industries : Finance, Healthcare
Share
Hire Manatkar V
Download PDF
Availability
Full-time
Total experience
4 years
Technical skills
PLSQL
3 Years & 11 Months
Trigger
3 Years & 11 Months
Stored procedure
3 Years & 11 Months
Indexing
3 Years & 11 Months
Performance tunning
3 Years & 11 Months
Query Analyzer
3 Years & 11 Months
ORACLE Database
2 Years
Sql server, Oracle 11g
Projects
Microsoft remediation project
September-2022 to April-2023
Description
During the Microsoft remediation project, I meticulously addressed JIRA ticket requirements by remediating stored procedures and optimizing queries, achieving significant performance improvements. I collaborated with cross-functional teams to design and implement Oracle PL/SQL solutions, enhancing operational efficiency by streamlining processes and ensuring data accuracy. Additionally, I played a key role in code check-ins, unit testing, and resolving production issues, consistently delivering high-quality solutions on time. • Collaborated cross-functionally to analyze, design, and implement Oracle PL/SQL solutions, enhancing operational efficiency and data accuracy.
Roles and Responsibilities
Developed and optimized Oracle SQL solutions, reducing data processing time by 40% and enhancing system performance. • Successfully remediated stored procedures based on Microsoft's requirements, significantly improving their performance. • Proficiently utilized Dynamic SQL to address code issues and enhance performance, delivering solutions that met project requirements. • Played a key role in the development process, including check-ins, unit testing, and resolving production issues, ensuring timely delivery of high-quality code. • Acted as a liaison between the development team and clients, ensuring effective communication and addressing client feedback promptly.
Technologies: Sql server
Industry: Finance
Navinet adjusting tool
August-2019 to December-2021
Description
Blue Shield uses an OCR (Optical Character Recognition) scanner for direct entry of claims and encounters into its claims processing system, OSCAR (Optimum System for Claims Adjudication and Reporting). OCR technology is an automated alternative to manually entering claims data. The OCR equipment scans the claim form, recognizes and “reads” the printed data then translates it into a format for direct entry into OSCAR. The scanner can “read” both computer-prepared and typewritten claim forms. Direct entry of claims by the OCR scanner is an advantage to you because it requires less human intervention in preparing and entering your claims. The scanner reads, numbers and images your claims in one step. OCR scanning reduces claim entry time. However, OCR claims do not receive the same priority processing as do electronically submitted claims
Roles and Responsibilities
Coordinated with front-end design team and provided stored procedures and packages for data insight. • Utilized SQL*Loader for daily data loading from flat files. • Developed PL/SQL scripts for data manipulation, validation, and materialized views. • Created triggers and master tables for automated primary key creation. • Utilized TOAD for database object creation and enhancement scripts. • Implemented indexes and partitioning for database performance enhancement.
Technologies: Oracle 11g
Industry: Healthcare
Navinet adjusting tool
January-2022 to August-2022
Description
Highmark’s Real-Time tools are available to all NaviNet®-enabled contracted providers and to providers who submit electronic claims through a practice management system. These primary Real-Time capabilities include Real-Time Provider Estimation and Real-Time Claims Adjudication. These real-time capabilities give providers the ability to discuss member financial liability with patients when services are scheduled or provided. Providers could also collect applicable payment or make payment arrangements at the time of services, if they wish to do so. The Real-Time Claims Adjudication tool gives providers the added ability to submit claims for specific health care services and receive a fully adjudicated response within seconds. This allows providers to determine, at the time of service, the correct amount the member owes. This, in turn, enables the provider to collect payment or make payment arrangements for the member’s share of the cost at the time of service.
Roles and Responsibilities
Developed ETL packages using PL/SQL and SQL*Loader for flat file loading and error logging. • Participated in testing the application for Oracle 11g to latest upgrade. • Tuned SQL queries for improved performance using Explain Plan and Hints. • Involved in all stages of database development, including needs assessment, QA/QC, design, and support. • Conducted training for new team members.
Technologies: Oracle 11g
Industry: Healthcare
Work history
Associate software engineer • August-2022 to May-2023
Software Developer • July-2019 to August-2022
Tata technologies
Soft skills
Communication
Teamwork
Critical thinking
Problem-solving
Time management
Education
Bachelors degree in Mba( Buisness analyst)
Savitribai phule university
2021 to 2023
Masters degree in Electrical engineering
Savitribai phule university
2015 to 2019
Language
English - Advanced