SUMMARY:

• Oracle Database Architect/Developer with over Eighteen (18) years of Experience in IT - Software Design, Development, Testing, Database Application and Database Administration.
• Excellent experience in Healthcare Systems.
• Extensive experience in Oracle Database development/Database administration ( Development)
• Good experience in Explain Plans AWR, ASH and TKPROF.
• Good experience in troubleshooting and tuning various query performance issues and bottlenecks using Explain plan and AWR.
• 3 years experience in Agile programming paradigm.
• Excellent experience in Oracle 11g Release 2, PL/SQL, Pro*C
• Strong skills in UNIX Shell Scripting.
• Good experience in Oracle Application Express (APEX)
• Very good knowledge in working with HP QC center for opening service request and defect analysis and closure of defects.
• Good Team player.

TECHNICAL SKILLS:

ETL TOOLS: Informatica Power Center 9.x, Power Mart 9.x SQL*Loader

B.I. TOOLS: Business ObjectsBusiness Intelligence 4.0, Oracle OBIEE 11.1.1.6.0 .

Operating Systems: UNIX, Windows 7/XP/NT/95

RDBMS: Oracle 11g Release 2.0, MS Access

Data Modeling Tools: ERWIN

Microsoft Products: MS Visio, Microsoft Project, MS Excel, MS Outlook, MS Word

CASE Tools: Oracle Designer 9i/10g/11g

Others: TOAD 9.x, Oracle designer

Change Control Tools: Harvest, CVS, Tortoise Subversion, Serena Dimensions

RAD Tools: Oracle Application Express 4.0.2

PROFESSIONAL EXPERIENCE:

Confidential, Columbia, MD

Data Management Specialist

Responsibilities:

• Involved in day to day activities for various file validations.
• Validated 2016 Recon Issuers data in multiple runs.
• Developed and tested procedures part of standardization that happened team wide.
• Developed and designed synonym master table to reduce hard coding of synonym name in all validation procedures.
• Helped the Development team to finalize ETL Mappings
• Created and Finalized JSON file layouts for the interfaces to populate incoming input data
• Designed and Developed Data models for M834 Changes
• Modified existing Data models using ERWIN for new data loads from Cognosante data source

Environment: Oracle Database 11.2.0.2.0, SQL Developer 4.0.3, Linux 2.6.32-573.22.1. el6.x86 64Oracle Application Express 5.0, AJAX, JavaScript 1.8, Jquery 2.2,JSON 3.0, ERWIN

Confidential

Technical Architect / Development Database Admin

Responsibilities:

• Developed new shell scripts and scheduled cron jobs for running PL/SQL procedure and Packages
• Analyzed AWR Reports for the stress/performance testing of call center application
• Created outlines to maintain the same execution plan in different environments.
• Worked on improving the performance of different application queries.
• Certified queries for optimum performance.
• Created indexes in different environments
• Created users and reset password of existing users on a need basis.
• Helped the Architecture team to finalize ETL Mappings
• Created and Finalized JSON file layouts.
• Developed Oracle APEX repots and UI screens
• Used jquery to build accordion style content, drag and drop functionality, calendar, popup and modal windows
• Created outlines for optimizing query performance in different environments.

Environment: Oracle Database 11.2.0.2.0, XMLDB, PL/SQL, Windows XP Professional EditionMS Visio, ERWIN, Microsoft Project, MS Excel, MS Outlook,Siebel CRM 7.0, HP-UX UNIX, SQL Developer 4.0.3, Linux 2.6.32-573.22.1. el6.x86 64, Oracle Application Express 5.0, AJAX, JavaScript 1.8,Jquery 2.2,JSON 3.0

Confidential

Senior Database PL/SQL Developer /Technical Lead

Responsibilities:

• Created frameworks and test strategies.
• Created and supported new database users and assisted in their database access and daily issues,
• Developed a new data model for CSP system to migrate from the old system.
• Involved in JAD sessions and code walk through meetings for the CSP system.
• Suggested changes in the code for CSP system.
• Proposed changes in the existing code structure of EHR module of Measures Engine.
• Developed the functions, packages, procedures and triggers for CSP/EHR system using the latest XML DB architecture.
• Designing logical and Physical data models for upcoming systems.
• Take part in technical design specification walk through meetings and gave valuable suggestion and guidance.
• Worked on enterprise database model enhancements
• Analyzes existing schemas and worked on performance tuning certain applications.
• Created various front-end reports using OBIEE for Physician Quality Reporting System.
• Created mappings and workflows using OWB for PQRI data warehouse.

Environment: Oracle Database 11.2.0.2.0, XMLDB, PL/SQL, Windows XP Professional EditionOracle APEX 4.0.2,MS Visio,ERWIN,Microsoft Project, MS Excel, MS Outlook, Lotus Notes, Informatica Powercenter 9.x/Power Mart 9.x,Serena Dimensions, Serena business Manager, Tortoise Subversion, Unix, BEA Web logic 2.0,Oracle OBIEE 11.1.1.6.0, Oracle Warehouse Builder 11.2.0.4.0

Confidential, Rockville, Maryland, MD

Senior Database PL/SQL Developer

Responsibilities:

• Created new database instances for development and QA environments.
• Tuned different queries to enhance performance and get rid of bottlenecks.
• Prepared test cases and worked on Defect analysis.
• Developed DBMS JOB functions to process incoming SPL Files to load into the XML Repository
• Developed (Apex reports) Standard reports and Ad hoc reports for the system with the ability to render the SPL XML data through internet explorer.
• Created Dashboard reports using OBIEE for EDRLS
• Created Application express authentication schemes and Authorization schemes for the Interface.

Environment: Oracle Database 11.2.0.2.0, XMLDB, PL/SQL, Windows XP Professional EditionOracle APEX 4.0.2,MS Visio, Microsoft Project, MS Excel, MS Outlook, Lotus Notes, Informatica Powercenter 8.x/Power Mart 8.x, ERWIN, Serena Dimensions, Serena business Manager

Confidential, Pittsburgh, PA

Senior Oracle Developer

Responsibilities:

• Developed Packages, Procedures, Functions, Triggers and Shell scripts for loading the Texas energy data.
• Involved in the Production support for various errors encountered in the integration of the Texas energy market data into existing RSSC system.
• Involved in the User interaction meeting for the Design of the Enhanced system.
• Worked independently in the design of various OBIEE reports.
• Developed shell scripts for the Data load.

Environment: Oracle 11g, PL/SQL, Windows XP Professional EditionOracle APEX 3.2,MS Visio, Microsoft Project, MS Excel, MS Outlook,Lotus Notes,Harvest,Unix,Oracle OBIEE 11.1.1.6.0, Oracle Warehouse Builder 11.2.0.4.0

Confidential, Milwaukee, WI

Senior Oracle Developer

Responsibilities:

• Developed End-User Input screen using Oracle APEX.
• Modified the Authentication to use LDAP instead of APEX Authentication Scheme.
• Developed the Reports for various Input Criteria.
• Tested the system for variety of Inputs and verified the Reports for validity.
• Developed Flowcharts / Execution diagrams using Microsoft Visio
• Developed work schedule / work plan using Microsoft Project.
• Developed user-end forms using Forms Developer 6i.

Environment: Oracle 11g, PL/SQL, Windows XP Professional Edition, Oracle Reports Developer 6iOracle Forms Developer 6i, Oracle Designer 6i, Informatica Powercenter 8.x/Power Mart 8.xOracle APEX 3.2,MS Visio, Microsoft Project, MS Excel, MS Outlook, CONTROL-M,Oracle OBIEEOracle Warehouse Builder

Confidential, Richmond, VA

Senior Oracle Developer

Responsibilities:

• Developed Packages, Procedures, Functions and triggers for this Migration.
• Automation of Procedures using CONTROL-M Tool.
• SQL*Loader and SQL*Plus are extensively used for Data migration activities.
• Complex queries are written to pull the data from Heterogeneous systems and load them into a single repository.
• Created and implemented different Database environments for Development and Migration testing
• Tested the Packages, Procedures, Functions and Triggers for migrating data into different Modules.
• Developed Shell scripts for the execution of the Packages/Procedures.
• Modification of existing Shell scripts.

Environment: Oracle 11g, PL/SQL, Developer 6i/9i/2000 (Forms 6i/9i, Reports 6i/9i) TOAD, Informatica Powercenter 7.x/Power Mart 7.x, Control-M, Reflections, Harvest, OBIEE Reports 8.0HP-UX UNIX 11.0, SQL*Loader, Perl, SQL*Plus, Oracle Application Express (APEX 3.2), JavaScript, Oracle Reports Developer 6i, Oracle Forms Developer 6i, Oracle Designer 6i, Oracle APEX 3.2MS Visio, Microsoft Project, MS Excel, MS Outlook, TKPROF, Oracle Discoverer, Oracle Application Web server, Oracle Designer 10g,CONTROL-M, Oracle OBIEE, Oracle Warehouse Builder

Confidential, Welesley, MA

Senior Oracle Developer

Responsibilities:

• Created Packages to implement the loading of data into persistent area for the Prime project.
• Modified the existing packages to load the data from multiple vendors into the persistent area.
• Worked on the creation of schema for the outbound staging area in development and test environments and setting up the UNIX environment and creation of ops$ id for these environments.
• Tuned SQL queries for optimum performance.
• Developed client facing reports using OBIEE.
• Involved in the enhancement of existing Pro*C programs for user requirements.

Environment: Oracle 10g/11g, Pro*C 2.0, PL/SQL, Developer 6i (Forms, Reports), Reflections, Harvest, HP-UX UNIX 11.0, Informatica Power Center 6.0, OBIEE Reports 8.0, Informatica Designer 6.0, Oracle Application Express, IBM Rational tools, Oracle Application web server, Oracle Discoverer, Oracle Designer 10g, Windows XP Professional Edition, Oracle Reports Developer 6i, Oracle Forms

Confidential, Richmond. VA

Capstone Developer

Responsibilities:

• Created a Recon/Reject process for handling the reject/recon from PNC Bank
• Creating Reconciliation Process for Confirmed and Rejected accounts by PNC (a bank used for Account servicing), First Payment (3rd Party tool for check fulfillment) and CAPSTONE using UNIX Shell scripting.
• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements.
• Developing procedures, functions, packages and Database Triggers. Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor or TOAD.
• Created PL/SQL Packages for easier application design and improved Performance.

Environment: Oracle 10g/11g, PL/SQL Developer, DDL, DML, SQL*Navigator, TOAD, PUTTY, Windows 2003, CAPSTONE, Informatica Powercenter 7.x/Power Mart 7.x, Analytical / Config Work Station (CWS/AWS) tool, Rational - Clear Case, F-secure, OBIEE Reports 8.0, Telnet,TKPROF, Windows XP Professional Edition, Oracle Reports Developer 6i, Oracle Forms Developer 6i, Oracle Designer 6i, Oracle APEX 3.2,MS Visio, Microsoft Project, MS Excel, MS Outlook, Performance TuningHP-UX UNIX 11.0, Oracle Application Express, Oracle Application web server, Oracle discoverer, Oracle Designer 9i, Oracle OBIEE, Oracle Warehouse Builder 11.2.0.4.0

Senior Oracle Developer

Confidential

Responsibilities:

• Gathered business and technical requirements for project scoping.
• Created the source and the target systems to aid the design of the Enterprise Data Warehouse using the case tool Erwin.
• Analyzed business reporting requirements and Involved in Star Schema designing and developing reports.
• Created various Category Business Planner reports using Oracle APEX.
• Developed and Modified UNIX shell scripts.

Environment: Informatica Power Center 7.1, PL/SQL, Oracle 9i/10g/11g, Actuate 7.0, MS Access, Windows NT, UNIX, Oracle APEX, Oracle Designer 9i, Windows XP Professional EditionOracle Reports Developer 6i, Oracle Forms Developer 6i, Oracle Designer 6i, Oracle APEX 3.2,MS Visio, Microsoft Project, MS Excel, MS Outlook, OBIEE Reports 8.0, Oracle Discoverer, Oracle Application Web Server, Oracle OBIEE, Oracle Warehouse Builder 11.2.0.4.0

Senior Oracle / Informatica Developer

Confidential

Responsibilities:

• Created Repositories and Folders for the users based on the requirement.
• Extensively used Oracle Discoverer for ad-hoc querying, reporting, data analysis
• Worked with Power Center Designer tool in developing Mappings to extract and loading the data into different Targets.
• Created stored procedures for loading the data into the target tables.
• Involved extensively in the creation of User run reports using OBIEE Reports 8.0

Environment: Informatica Power Center 6.2, PL/SQL, Oracle 9i/10g/11g,IBM Rational Tools, Erwin, TOAD, Business Objects 5.1.2, UNIX, Windows NT, Oracle APEX, OBIEE Reports 8.0,Oracle Discoverer, Oracle Designer 9i,Oracle Application Web server, Oracle OBIEE, Oracle Warehouse Builder 11.2.0.4.0

Senior Developer

Confidential

Responsibilities:

• Carry out the Enhancement work for all the modules
• Developed new Shell scripts for execution of Packages and Procedures
• Modified the existing stored procedures for the Enhancement.
• Testing the Enhancement work done in the modules
• Prepare Test cases and test specifications

Environment: PL/SQL, Oracle 9i/10g, TOAD, UNIX, Oracle Discoverer, Windows NT

Senior Developer

Confidential, Concord, CA

Responsibilities:

• Upgrading Custom Forms Developed in Forms 4.5 and Forms 2.4 for Oracle Application Server Version 10.5.7 to Version 11.5.8
• Conversion of V2-Style triggers to V3-Style trigger for running in Oracle Application Server Version 11.5.8
• Preparation of Unit test cases for Forms 4.5 and Forms 2.4

Environment: Oracle 9i/10g, Oracle Application Server 11.5.8, PL/SQL, Pro*C 2.0, SQL*Plus 8.1.5, Oracle Discoverer, Developer 2000

Senior Developer

Confidential

Responsibilities:

• Involved in the debugging the errors encountered in the Employment action form (EAF).
• Involved in debugging the functions and procedures of Accounting Module, Job Labor Redistribution Form (JLRF).
• Extensively used Oracle Discoverer for ad-hoc querying, reporting, data analysis
• Developed Unix shell scripts for the execution of Packages and Procedures

Environnent: Oracle 9i, PL/SQL, SQL*Plus 8.1.5, Oracle Discoverer, Developer 2000

Senior Developer

Confidential

Responsibilities:

• Responsible for Data Modeling and table Design
• Developed an e-commerce solution involving Perl, Java, HTML, DHTML, JavaScript, Pro*C, ERWIN, SCCS, IIS on NT servers, with Oracle back-end to integrate their stores spread across the US,
• Designed and developed user interactive Web Pages using JavaScript, Perl, HTML, Frames, Interactive Forms and Image mapping.

Environment: Oracle 9i, SQL*Plus 8.1.7, PL/SQL, Pro*C 2.0, Oracle Discoverer, PerlWindows NT 4.0, HP-UX, Sun Solaris UNIX 5.8

Developer

Confidential

Responsibilities:

• Involved in the system study phase, impact analysis, design phases of the module
• Modified the front-end programs
• Lead a team and also developed the EOD program (Developed some pro*c programs to generate reports of excess refund made to customers (EOD)
• Involved in the System Integration Test part of the system (SIT)

Environment: Oracle 9i, SQL*Plus 8.1.7, PL/SQL, Pro*C 2.0, Oracle Discoverer, PerlWindows NT 4.0, HP-UX, Sun Solaris UNIX 5.8

Developer

Confidential

Responsibilities:

• Involved in the system study, impact analysis, design, and development and testing stages.
• Involved in the design, development and testing of screens
• Developed and tested functions for foreign currency conversions
• Extensively used Oracle Discoverer for ad-hoc querying, reporting, data analysis

Environment: Oracle 8.1.7, Forms 3.0, SQL Reports 1.1, PL/SQL 2.1, PRO*C 1.6, Oracle Discoverer, SQL*Plus 3.1, SUN Solaris