Aparna Mishra

Mobile: 201-***-****

Email: ac6xw0@r.postjobfree.com

Summary:

More than 10yrs years of experience in design, development and Oracle application production support. Understanding of relational database concept. Experience in physical data modeling/logical data modelling and developing functions, stored procedures and packages. Familiar with ETL(Extract, Transform and Load) process & concept.

Expertise in using Oracle Performance tuning concepts with Oracle hints and EXPLAIN PLAN tool

As a subject matter expert of Oracle, I have experience in providing corporate training required to build Oracle competency.

Languages/Tools/

Technologies/

Environment:

Database: Oracle 10g/11g/12C, SQL, PL/SQL, Triggers, Stored Procedures and Functions, Standard Packages, SQL*Plus, SQL*Loader, Import/Export, Performance tuning. Oracle Forms, Oracle Reports, Toad, SQL Developer, JavaScript, React js, Graphql, Mongodb, Visual Studio Code, Ubuntu Virtual Box, Docker.

Work Experience:

May’2011- till date

CONDUENT TECHNOLOGIES(CLCS), USA

(Application Developer)

Designing and development of software solutions and providing high value, technology- based services.

Full stack development to help implement and maintain client-facing enterprise web applications. Development and functional testing of core business critical components.

Communication across team to identifying framework related requirements and features.

Collaborate with team members to design, develop and support our new web application features.

Maintain existing application features and identify areas for improvement. Work with internal stakeholders including product owners, project managers and scrum.

Follow coding standards and best practices to deliver cohesive, readable code. Implement and carry out unit testing.

Troubleshoot and solve problems for new and legacy code bases.

Contribute to the evolution of team-level best practices and standards for software development.

Review database code changes and ensure database coding standards and naming conventions are being followed.

Work with the team to identify areas for process improvement.

Resolve any database performance related issues.

Work directly with development, operations and IT teams to ensure the applications provide outstanding experience to the clients.

Performed code review and unit testing on software for new and existing database applications.

Perform code release to production environment in scheduled outage window.

XEROX CORPORATION (XLS), USA

(Oracle Developer)

Develop the core application Software in the databases of various application. Resolve any database performance related issues.

Work directly with development, operations and IT teams to ensure the applications provide outstanding experience to the clients.

Created logical design for omnix platforms.

Develop sophisticated PL/SQL database code. Develop testing plans for QA team to execute.

Perform large scale data manipulation in response to application change. Performance enhancement or physical needs using knowledge of oracle 11g platform in an UNIX environment, oracle architecture, including physical and logical structure and memory structure, SQL and PL/SQL, including stored procedure, functions, triggers, materialized views and DBMS schedulers.

User performance tuning skills on complex queries using auto trace.

Explain plan and Tkprof and design complex shell scripts to streamline database code release to production databases.

Analyze database performance trends, modify database applications to optimize performance and collaborate with other developers to optimize applications that interact with oracle databases.

Review database code changes and ensure database coding standards and naming conventions are being followed.

Monitor database source code in GIT.

Perform database code release to production environment in scheduled outage window.

Maintain a thorough understanding of the current system. Work with the team to identify areas for process improvement.

XEROX CORPORATION (XLS), USA

(Oracle Application Support) PL/SQL Developer

Responsibilities:

As a member of the Oracle database team, I was responsible for database design, development and production support for Xerox Litigation Services.

Performed production deployment of the application by running scripts on production servers, dealt with issues faced and performed off hour maintenance window activities.

Also, interfaced with Operations and Client Services groups for deployment and post production support of the application.

Worked extensively on SQL optimization and performance tuning by using Hints, Explain Plan, Tkprof utility, SQL* Trace.

Created complex queries such as for decision making reports, oracle date, character, number functions and Analytical functions.

Developed PL/SQL packages, stored procedures, functions, Sequences, Materialized views, Table Partitions, Integrity constraints and Indexes.

Performed code review and unit testing on software for new and existing database applications.

Sep. 2006 – Oct. 2010

NIIT LTD, India

(Oracle Developer/ Oracle Trainer/Group Leader)

Responsibilities:

As an Oracle Developer, I was responsible for development, maintenance and support of Encore Vista Application.

Involved in the complete life cycle of the product from requirements gathering to end of system testing.

Worked on profiling and tracing PL/SQL program to analyze the execution of program in order to enhance performance of program.

Provided training to corporate professionals.

As a Group Leader, I supervised, manage and train 10-person office staff.

Awards

Selected as Regional Domain Expert for Oracle

Awarded Power2 NIITian

Certification:

Oracle Certified Professional OCP 9i (Intro to SQL,PL/SQL,Oracle Forms)

Microsoft Certified Professional

Education:

Master in Computer Applications (2006)

(Maharishi Dayanand University, Haryana, India)

Masters of Science in IT-M.Sc.(IT) (2004)

(Allahabad agricultural Institute Deemed University)

Contact this candidate