SUMMARY:

• Over 16 years of analysis, design, and development experience on Oracle Client Server and Web Applications using Oracle.
• Expert level experience in Oracle 7.x, 8.x, 9.x, 10g, 11g and 12c databases and Oracle Forms 10g, Oracle Reports 10g, Oracle Application Express 4 (APEX) Designer 9i and Oracle Business Intelligence (OBIEE) Reports 11g.
• Proficient in writing stored Procedures, Functions, Packages and Database Triggers using SQL, PL/SQL and Oracle Web Tool kit and strong understanding of Unix Shell scripting.
• Expert knowledge on Oracle database query tuning skills to improve the performance of large volume of data.
• Very good understanding and knowledge on Data modelling concepts and expertise in data modelling using Erwin Data Model tool.
• Strong perseverance and diligence towards attaining challenging goals and effective time management. Applied Agile and Waterfall methodologies in the projects to ensure delivery of the project on time with minimal defects.
• Very strong in software design, analysis and development of business and financial applications using Oracle database 12C and Forms, Reports. Involved in all phases of software development cycle.
• Expert knowledge on Informatica Power Centre 9.6 and Oracle Application Express (APEX).
• Expertise in Source Code Management using Visual Source Safe, PVCS, SVN, GIT Lab and Serena Dimensions.
• Good communication skills with strong work ethic and Possess high programming skills, good analytical ability to study the project, reengineering existing systems, ability to adapt to any programming environment and capable of developing any client server application using state of the art programming methods and tools.
• Worked as Project Lead in Confidential Technologies and managed a team of 15 developers.
• Worked as Onsite coordinator at Confidential UK on Onsite - Offshore model.
• Experience in managing the project with minimal supervision.

PRINCIPAL EXPERTISE:

• Development of Oracle applications using Oracle Database 10g/11g/12c (SQL/PL SQL), Developer 2000 suit (Forms 10g and Reports 10g), Oracle Application Express 3 (APEX) and Oracle Designer 9i.
• Expertise knowledge of Data modelling using Erwin tool.
• Development of Java based applications.

TECHNICAL SKILLS:

Platform: Unix - Sun solaris, Windows 98/NT/2000/XP

Languages: SQL,PL/SQL, Oracle Web Tool Kit, Core Java, JDBC,JSP

Databases: Oracle Database versions 7x,8x,9x,10g,11g and 12c

Tools: Oracle Developer Suit (Forms 10g, Reports 10g),Oracle Designer 9i, Oracle Application Express (APEX) 4. Hibernation. Oracle Business Intelligence 11g. (OBIEE ) Reports.

Data Transformation: Informatica Power Center 9.6

Web Development: Java Script, HTML

Version Control: PVCS, Clear Quest, Serena Dimensions, GIT Lab

Applications: Outlook, Word, Excel and PowerPoint

Other Tools: Erwin Data Modeler 9.5,Toad, Sql Navigator 5.5,PL/SQL Developer and SQL Loader.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. Oracle Database Developer

Responsibilities:

• Attending daily Scrum meetings and provide status updates.
• Participate on database design meetings with Data architecture and Data modellers.
• Working with DBA group to analyse performance related issues and fix them using suggestions provided by the DBA group.
• Create new database objects like tables, indexes and modify existing objects using Oracle database 12c according to the customer standards.
• Creating and modifying stored procedures and database triggers per the requirements.
• Creating sql queries according to the front-end requirements and provide support to front-end development team on release basis.
• Providing support to QA users and resolve database job related issues for QA testing.
• Comparing and maintaining the database objects and reference data on various development and QA environments.
• Working with Front-end Java development team to trouble shoot with performance related issues and optimize sql statements to improve performance.
• Maintaining all code objects using GIT Lab code repository.
• Provide support during QA and Production build deployments.

Confidential

Sr. Oracle Database Developer and Lead Technical Analyst

Technical Environment: Oracle 11g/12c, Toad, PL/SQL Developer, Erwin Data Modeller 9.5, Serena Dimensions Version manager and PL/SQL(Procedures, Functions and Database Triggers). OBIEE Reports 11g and Oracle Application Express 4.

Responsibilities:

• Coding, testing, debugging, implementing, and documenting highly complex programs using Oracle PL/SQL. Developed complex test plans to verify logic of new or modified programs.
• Designing systems and programs to meet highly complex business needs. Participated and prepared detailed specifications discussions from which programs are developed and coded.
• Creating appropriate documentation in work assignments such as program code, and technical documentation.
• Gathers information from existing OLTP/OLAP systems, analyses program and time requirements. Prepares time estimates and justifications for assigned tasks and provides recommendations to project managers.
• Supports project personnel in resolving fairly complex program problems like environmental issues, database tuning issues and application access issues. Works with client and management to resolve issues and validate programming requirements within their areas of responsibility. Provides technical advice on complex programming.
• Served as technical project lead and provided leadership and work guidance to less experienced personnel. Conducts and participated quality assurance activities such as peer reviews.
• Provided consulting services in a technical and/or managerial capacity to management and technical staff. Representing company in presentations or conferences involving customers, co-contractors and suppliers.
• Working closely with DBA group to resolve issues related to database privileges, grants and creating new database users.
• Creating and modifying database objects like tables, indexes, views, materialized views etc., using Oracle database 11g and 12c.
• Created various PL/SQL objects like Type bodies, Packages and procedures for Measures Engine module to calculate and process eligibility of Electronic Health Records Category 1 and Category 3 data.
• Developed Reports proto types using Oracle Apex 4 tool.
• Designing new tables/modify existing tables according to the requirements using Erwin Data Modeller tool to support OLTP and OLAP (Aggregation) transactions.
• Generating DDL scripts using Erwin and deploy them in Development environment for developers.
• Analysis, Design, Development and unit test new requirements on OLTP and OLAP Development Environment.
• Worked with DBA group, Configuration Management group and System Administration group to true up Development, Integration and Test environments.
• Worked on Informatica Power center 9.6.1 to develop work flows to transform data from one source to another. Resolved issues related to performance during the workflow executions on higher environments.
• Providing support to QA users and resolve issues related to QA testing.
• Participated on SQL tuning to improve performance of processes and PL/SQL objects like procedures and packages.
• Provided best practices to improve the performance of PL/SQL code to Informatica team.
• Coordinating with Middle wear team to configure OBIEE tool on Dev and Integration environments for development activities.
• Coordinating with DBA and Middleware teams to implement changes in Test and Production environments.
• Participated on Project initiation meetings and provided inputs related to environments and development effort for project schedule.
• Participating code reviews and provides inputs/suggestions to improve the coding
• Maintaining all code objects using Dimensions code repository.
• Submitting code deployment builds (Database, Informatica and OBIEE) on higher environments and coordinating with Middle were team to deploy components on higher environments.
• Led a team of 3 developers and track the work assigned to them and also coordinated with other teams to ensure that development and code checkins are done on timely manner.

Confidential, Baltimore, MD

Oracle Database Developer

Responsibilities:

• Analysis and resolve issues related to MATO (OLTP) Database.
• Gather, analyse and interpret function specifications and business user requirements.
• Develop and optimize automation scripting using PL/SQL.
• Modifying existing or creating new PL/SQL code in Packages, Database triggers, Procedure and Functions to add new functionality according to the requirements.
• Performing the impact analysis and provide inputs on day to day issues identified by the user group.
• Maintaining the code objects using CVS tool.
• Creating and modifying database objects like tables, indexes, views etc., using Oracle database 10g and 11g databases.

Confidential, Suitland, MD

Sr. Oracle Forms Developer

Technical Environment: Oracle 10g, Oracle Developer Suit (Forms and Reports Version 10g), Toad, PVCS Version manager and PL/SQL(Procedures, Functions and Database Triggers).

Responsibilities:

• Design and development of application using Oracle Forms (10g), Reports (10g) .
• Modifying existing Oracle forms screens and reports according to the Business/Users Requirement to support OLTP transactions.
• Maintaining and updating the requirement documents.
• Attending Client/Business users meetings and provide updates on the project progress and issues.
• Analysis and resolve the issues raised by the end users.
• Maintaining the code objects using PVCS version control tool.
• Preparing the test data for Unit and Beta testing.
• Participating in the Unit and Beta testing and provide support to the business users during the beta testing.

Confidential, Richmond, VA

Oracle Developer

Environment: Oracle 11g, Developer 2000(Forms and Reports Version 10g), Oracle Web Tool Kit, Oracle Designer 9i, Oracle portal 10g, SQL Navigator, PVCS Version manager and PL/SQL(Procedures, Functions and Database Triggers) HTML and JavaScript.

Responsibilities:

• Design and development of online application (OLTP) using Oracle Forms (10g), Reports (10g), Oracle Web tool kit and PL/SQL(Procedures, Functions, Packages and Database Triggers) for Client enrolment and nutrition health care application (Wic), web based Retail store management system (RSMS) (OLTP) and Web Vision Applications using HTML and Javascript.
• Participating in the database design and analysis phases.
• Performing the impact analysis and provide inputs to Business manager.
• Attending meetings with client/Business users to understand and collect the requirements to convert into business logic to develop the application.
• Participating in unit testing and documentation of requirements.
• Generating web based user interfaces (Screens) and reports using Oracle Forms, Reports, Oracle Deisgner 9i, Oracle Web Tool kit, HTML, JavaScript
• Attending the weekly meetings and provide updates on the development to Project Manager and team.
• Writing and tuning of PL/SQL code like Procedures, Functions, Database Triggers, Packages and SQL queries to improve the application and reports performance.
• Modifying existing PL/SQL code in Packages, database triggers, procedures and functions to add new functionality according to the requirements.
• Modified existing web reports and front end applications developed in Oracle Application Express on basis of user’s request.
• Modifying and writing new Unix shell scripts to schedule batch jobs to run on everyday midnight to process large number of records on the database to change the client status based on certification dates.
• Working with DBA to identify and resolve the performance and user privilege related issues.
• Participation on rollout of the new application versions (Both Client server and Web portals) to all Business users throughout the Virginia state.
• Providing application support to end users.
• Maintaining the code objects using PVCS tool.
• Providing support to Business users and QA team for User Acceptance and Beta testing.
• Participating in all phases of development life cycle.

Confidential

Project Lead/Onsite Coordinator.

Technical Environment: Oracle 8i (SQL and PL/SQL). And Advantex Applications on Unix and Windows NT.

Responsibilities:

• Participated in meeting with Business users and stake holders to collect the business requirements and clarifications.
• Understand the business requirements and provide inputs to offshore team to develop the interfaces.
• Attending the client meetings with business and Third party Mobile Data Solution Inc., Vancouver (Ventex) supplier.
• Provided detailed data modeling analysis and business impact documentation to Client to understand the impact of the new changes in the current system.
• Participated in Factory Acceptance test at Ventex’s office Vancouver, Canada.
• Participated in all phases of testing at Onsite and coordinated with Offshore to deliver in house development on time to Confidential .
• As a Project Lead review and deliver the Analysis Design Report (ADR), Technical Design Report(TDR) and other related documents to business for their approval.
• Created and modified stored procedures, functions and packages according to the new requirements.
• Provided technical support to junior developers on Oracle database, data modeling and PL/SQL.
• Coordinated with various teams like Infrastructure (CSC), Environment and Database Administration groups to resolve day to day issues on test environments to ensure the test environments are up and running through out the testing phases.
• Provide assistance to Project manager to prepare project plans and dead lines for all the phases of project.
• Supervise and provide technical assistance to rollout the Mobile Application to all the field user’s mobile devises with the help of CSC infrastructure team as part of project rollout to Confidential, UK.
• Provided timely inputs on project execution and highlighted the risks to project manager and clients on periodical basis. Attending client meetings with project manager and provide updates on project execution.
• Planning and coordinating with the other stake holders to implement the project on production and ensure that the application is up and running.

Confidential

Onsite Coordinator

Technical Environment: Oracle 8i (SQL and PL/SQL). And Advantex Applications on Unix and Windows NT.

Responsibilities:

• Responsibilities including attending the business meetings, interacting with business users and resolving their application related issues and technical problems.
• Attending the client review meetings and also performing investigations and analysis of third party requests.
• Provided impact analysis and data modeling analysis on existing system for all new requirements.
• Coordinating with Offshore team to perform certain tasks from Offshore and complete the work in time.
• Review of coding, test cases and documentation prepared by Offshore. Analysis on new requirements and provide technical solutions on Oracle Database objects, procedures, functions, packages and triggers to offshore team.
• Provided solutions on critical database related issues, and data modeling issues to ensure the testing phase completes on time.
• Ensure the daily batches executed successfully and inform the status to business manages.
• Developing and maintaining the code of Web Pages using Oracle Portal and HTML.
• Resolving the business critical tickets (Issues) and Portal authorization issues.
• Raising the change requests to Ventex on new requirements.
• Conducted walkthrough meeting on Analysis design with business stake holders to ensure all requirements were covered before raising a change request to third party product development company Ventex for Advantex application.
• Conducted walkthrough meeting with Ventex team on all open issues related to Advantex application.
• Participating in all review meetings with clients and third parties. Identifying the proactive proposals to business in order to identify the potential areas in the system. Coordinating with other support groups to resolve the day to day issues.