Over 1.5 years of experience in design, development, testing and implementation of application software as Oracle PLSQL developer. Technically proficient and resourceful team member with good work ethics. Excellent Communication, Leadership and Interpersonal skills. Quick learner, self-motivated, hardworking, goal-oriented with high degree of flexibility. Good at Team Work and active interaction with team.
Languages & Databases : SQL, PLSQL, UNIX Shell Scripting, Oracle, and MS-Access
DB Dev. Tools : TOAD, SQL Developer, PLSQL Developer, SQL*Plus
Operating Systems : UNIX, LINUX, Windows XP/2000/2010
Tools :Putty, Rally, HPFortify, WinSCP, Autosys, MS Visio, Data Stage, Informatica Power Center, MS-Excel
Oracle PLSQL Developer March 2016 to May 2016Optum UHG － Eden Prairie, MN
OptumInsight is a health information, technology, services and consulting company, providing software and information products, advisory consulting services and business process outsourcing to participants in the health care industry.
Hospitals, physicians, commercial health plans, government agencies, life sciences companies and other organizations that comprise the health care system work with OptumInsight to reduce costs, meet compliance mandates, improve clinical performance and adapt to the changing health system landscape.
As an Oracle developer mainly involved in development of code for the business requirements.
Responsibilities: Involved in creating database objects like tables, views, procedures, packages as per the business requirement.
Created Partitions (List and Range) on tables to improve the performance.
Performance tuning of existing querieswith the help of TOAD utilities like optimizer and explain planto improve the response time.
Used SQL*Loaders to load data into database from CSV files for test data preparation.
Created data dictionaries of Tables in database and maintained for documentation.
Created DBMS scheduled jobs and Procedures for auto cleaning up of work process tables.
Involved in deploying objects from Dev to QA for different teams and maintaining the database security.
Providing privileges to different users on different DB objects.
Coordination between development, testing and attending daily standups as part of sprint /scrum calls.
Experience in working with clients on-site, analyzing software requirements and developing solutions and procedures.