SUMMARY

• Around 5 years of IT experience in Design, Development, Implementation and support of RDBMS in Production and Development Environments using Oracle Tools.
• Involved in complete Project Life Cycle including requirements gathering and Analysis, Database design, Database development, Application development, Testing, Implementation and Support of the application software and extensively on Production support.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views, using Oracle PL/SQL database programming language.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Excellent in Query Optimization Techniques, Creating, Replacing & modifying database entity models and maintenance.
• Good understanding of Data mining concepts, ETL Processes and Data modeling concepts such as Design of the Dataflow, ER Diagrams, UML, Use Cases, Normalization and De - normalization of Tables.
• Experience in using Oracle Forms 9i, Reports 6i&2.5 for developing end user screens and reports and also adept in using Oracle Tools like SQL* Plus, SQL Developer.
• Used SQL analytical functions for data analysis and developed aggregated drill down reports.
• Used SQL loader and UTL FILE to load the data into oracle tables from FLAT, CSV and Text files
• Worked on SQL Loader scripts to load the data in to temporary staging tables
• Good team player, quick learner and detail oriented, strong technical, organizational and report writing skills combined with self-motivation.

TECHNICAL SKILLS

RDBMS: Oracle 12c,11g, SQL Server 2008/2012, MS Access and MS-Access, Forms 9i/10g,Reports 9i/10g.

Modeling: WINSCP, Putty.

Operating Systems: Windows Vista/ XP/2000/2003.

Oracle Utilities: SQL*LOADER

Languages: SQL, PL/SQL,UNIX Shell Scripting

ETL tool: Informatica

Developer Tools: SQL Developer, Oracle Developer Suite (Forms and Reports).

3rd Party tools: MS Visio, JIRA, Service Now, TFS Repository.

PROFESSIONAL EXPERIENCE

Confidential, Pasadena, CA

Application Support Analyst

Responsibilities:

• Provided tier 3 support by working with software development and QA teams.
• Provided Tier 3 support and root-cause analysis for incidents and/or service requests
• Providing tier 3 application support by monitoring internal software applications in the application (client).
• Submitting bugs and tasks in Service now issue tracking software development and coordinating with offshore digital teams.
• Experience in working with the Service now ticketing tool.
• Identified, documented, and troubleshooted application computing issues as they arise.
• Experience in working with UNIX and PUTTY Environments.
• Experience working as L2 production support.
• Proficient in developing and maintaining of packages, functions, triggers, tables, views.
• Resolving customer reported tickets in Service now. Related tasks and completing application support requests.
• Worked with SQL Joints on tables for performance reasons.
• Experience in developing the existing SQL queries due to performance issues.

Environment: SQL Developer, UNIX, WINSCP, Microsoft Office, Putty.

Confidential, Monroeville, PA

Oracle PL/SQL Developer

Responsibilities:

• Responsible for conducting user requirement meetings and gathering information from the end users for reporting system and analyzed all the existing system
• Experience in working with the SPARCS application.
• Developed and worked on a new screen named as EXTERNALVENDOR screen.
• Involved in SPP transition project.
• Created new constraints to identify patients who are eligible for transition based on their drug.
• Responsible for creating the tables, enforcing the Constraints & Indexes.
• Created PL/SQL Procedures, Functions and Packages in PL/SQL
• Responsible for Developing the NewReportsusingReports10g.
• Responsible for creating the Database Triggers coded to meet the global operation.
• Tested required stored Procedures, Functions, Packages and Database Triggers.
• Involved in solving the bugs reported by the end user in implementation phase in bothFormsandReports.
• Involved in performance tuning for slow runningReportsusing various optimizer hint techniques.

Environment: Oracle 11g/12c, SQL Developer, Oracle Forms and reports.

Confidential, Ashburn, VA

Oracle PL/SQL Developer

Responsibilities:

• Involved in Design, Development and Testing of Conversions, Interfaces, Workflow and Reports.
• Experience in writing post validation SQL scripts to verify data is loaded properly oncedata stagejob is completed.
• Resolving the issues on priority basis.
• Responsible for Analyzing and Implementing the Change Requests.
• Designed and developed Database Tables, Triggers, Cursors, and Ref Cursors created Stored Procedures, Functions and Packages for implementing business logic and to meet Business requirements.
• Worked on scripts to refresh data for the various data sources and developed Backup scripts to restore data.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Collaborate with various departments and perform research on all data processing functions.
• Involved in day to day meeting with development team in agile environment updating with further steps and providing feedback on current issues.

Environment: Oracle 11g/12c, SQL Developer, SQL*Loader, TOAD, UNIX, Shell Scripting, Microsoft Office, Putty, Datastage.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created Data Flow Diagram, Entity Relationship Diagram from Designer.
• Involved in Development, Testing, Implementation and Training.
• Extensively involved in writing SQL queries (Sub queries and Join conditions).
• Created Database Triggers in PL/SQL.
• Involved in developing UNIX shell scripts required for maintaining and processing job.
• Involved in Package modifications to reflect the changes.
• Involved in export and import at schema level.
• Created Object Types in PL/SQL.
• Performed customization on existing Forms appearance, validation logic, and behavior and incorporating new functionalities for control purpose.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.

Environment: Oracle 9i, SQL Developer.