SUMMARY:

• Over 7+ years of IT experience in System Analysis, Design, Testing, and Development of business applications using Oracle 12c,11g/10g/ 9i/8i.
• Experience with SQL, DML, DDL, DCL, TCL commands of SQL and have excellent debugging skills.
• Experience in logical Data modeling ER diagram, created schemas and relations accordingly.
• Good programming experience in Oracle 10g/9i/8i/8.x, Developer 2000 (Oracle Forms, Oracle Reports), PL/SQL, SQL*Plus, TOAD, SQL*Loader.
• Worked with embedded SQL (Pro C).
• Experience in development of Procedures, Functions, Packages and Database Triggers, Query Tuning using query optimizer.
• Experience in creating Extracts, Database Objects and User defined Data types (Abstract Data types), Materialized views.
• Proficient in developing Forms and Reports using Oracle Forms6i/5.0/9i/10g, Reports6i/4.5/9i/10g and also great knowledge in Tableau.
• Experience in migration of Oracle 11g database to Oracle 12c.
• Hands on experience in writing Korn Shell Scripting and job processing in UNIX.
• Knowledge of Performance Unit Testing and Quality Center Tool.
• Good Understanding of Microsoft SQL server, Java, HTML.
• Hands on experience in Data Modelling tools such as Erwin and ERStudio also great knowledge in Tableau reporting.
• Experience with both Agile and Waterfall project management methodologies.
• Experience in Documentation that involves functional specification, user Manual and technical review.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills

TECHNICAL SKILLS:

Operating System: Windows 10/8/XP/98, Linux, UNIX (Sun Solaris, HP - UX, AIX)

DBMS/Databases: Oracle 12c, 11g/10g/9i MS Access, MS-SQL Server.

Web Technologies: Perl, HTML, Java Script.

Packages: Oracle Forms and Reports (4.5, 6i, 9i, 10g).

Languages: C, C++, SQL, PL/ SQL, PRO*C

Scripting Languages: UNIX Shell Scripting

Database Tools: SQL*PLUS, TOAD, SQL*Tool, PL/SQL Developer

Office Packages: MS-Office (Access, Word, Excel, PowerPoint)

Version Control: SVN, CVS, PVCS

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr.Oracle Database PL/SQL Developer

Responsibilities:

• Database design and development activities on Premiums Payable Applications supporting STATE Medicaid Managed Care, Medicare, CHIP, CMDS programs which are large scale Database Applications.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic such as generating capitation payments, payment adjustments for eligible clients.
• Developed Unix Shell Scripts to automate backend jobs, automated system administration using Opcon tool and loading data into the Database using SQL* Loader.
• Extensively worked on Oracle Stored procedures, Dynamic SQL and Exception handling.
• Tuning the performance of SQL statements using HINTS and using TKPROF utility & Explain Plan Table.

Environment: Oracle 11g/12c, Informatica Power Center 9.1/8.6(Designer, Workflow Manager/ Monitor, Repository Manager and Informatica Server, Agile Methodology (JIRA).

Sr.Oracle Database Developer

Responsibilities:

• Worked on complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
• Created Database tables in Global Distribution Systems (GDS) architecture and performed DDL, DML and DCL commands.
• Created Packages, Procedures that performs the above logic to process claims.
• Created front end summary Oracle Report’s using Report Builder 9i.
• Worked for Production support after the project completion for 2 months where I have resolved the various call ticket’s (issues) for customers.
• Involved in creating various standard extracts and setup the SFTP and FTP connection to send the generated files by creating Filemover scripts using PERL.
• Worked with OIM, Scheduler jobs, Filemarts, Data warehouse concepts.
• Extensively worked on FACETS tables.
• Performed DBA activities includes creation of users & table spaces, indexes, Creation of database Links, performance tuning, disk space monitoring and File transfers using FTP.

Environment: : Oracle 10g, SQL, PL/SQL, SQL * Loader, TOAD 11.0, UNIX, GDS Architecture, Agile Methodology, Master Job scheduler, WinSCP, Filezippo, AIX, Production Support,SVN.

Sr.Oracle Developer

Responsibilities:

• Worked on complete SDLC (system development life cycle) including system analysis, high level design, detailed design, coding and testing.
• Developed DG’s Transportation Management System (“TMS”) which will be able to systemically schedule, reschedule, and cancel drop appointments at DG DC’s in One Network’s appointment scheduling system.
• Developed the shell scripts, cron jobs for maintain scripts for monitoring, troubleshooting and administration of the databases.
• Performed Oracle Developing, Error Handling and Unit Test Planning.
• Extensively used UTL FILE to read and write files that are located on the server.
• Used Toad, PL/SQL developer tools for faster application development.
• Apart from developing, involved taking information from the databases, turning them into files, and sending them as SFTPs to customers and later documented procedures and scripted, and drafted up their own until test plans.

Environment: : Oracle 10g, 11g, SQL, PL/SQL, SQL * Loader, TOAD, AIX,Cloud SAAS environment, OpCon scheduler, AIX/Unix environment

Research Assistant

Responsibilities:

• Ensure that storage, archival, backup and recovery procedures are executing properly.
• Conceptual Data modelling, relational data model, relational query languages, relational database management systems.
• Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms.
• Worked with Google’s Content Based Image Search system with reverse image search.

JAVA/PL/SQL, SQL Developer

Responsibilities:

• Wrote stored procedure and triggers.
• Created Java Scripts, Strings, Classes and methods
• Developed Stored Procedures for various validations while inserting data into the tables and developed PL/SQL Packages for incorporating the business rules.
• Used bitmap indexes, materialized views and partition tables to optimize the queries.
• Developed GUI forms (screens) in Visual Basic according to the user requirements.
• Application tuning for slow running queries using Explain plan (Auto trace).
• Wrote automated test scripts for GUI, Functional, Data Driven, User acceptance and Regression tests using Win Runner.
• Involved in System Interface Testing, Regression Testing, Exception Testing, and Product Testing on corporate releases.

Environment: Oracle 8i, Microsoft SQL Server 2005, SSIS (Integration Services), PL/SQL, Quick Test Professional, SQL*Plus, Reports, SQL *Loader, Visual Basic 6.0, WINDOWS.