PROFILE:

• 9 years and 6 months of total IT experience including three years at onsite in Development, maintenance and implementation of custom applications using oracle9i/10g/11g plsql in UNIX environment.
• 9 years of extensive experience in Unix shell scripting
• Good experience in data migration
• Strong experience in writing complex sql queries
• Strong experience in data analysis
• Strong experience in writing Oracle plsql programs such as packages, procedures, functions and cursors
• Strong understanding of key concepts, such as triggers, packages, procedures, functions, and cursors
• Expert in optimizing the applications using advanced oracle techniques
• Good experience in handling the problem, problem - solving and troubleshooting
• Good analytical & problem-solving skill.
• Good verbal, written, and presentation skill.
• Excellent team player, Self-motivated and quick learner and adaptable to a fast growing and changing environment

KEY SKILLS:

Operating systems: Windows NT/95/XP/2000, Rhel Linux, IBM-AIX 5, Sun Solaris

Databases: Oracle 9i/10g/11g, Sql Server, MS-Access

Languages: sql, plsql, Cobol, C, XML parser for plsql, Unix Shell Scripts, CA - Unicenter

Front-end: Visual Basic 6.0, Crystal Report 8, and Oracle Forms and Reports 6i

Tools: Erwin data modeler, Toad, Putty, WinSCP, sql*plus, Rational Clear Case, Rational Clear Quest, Remedy, and Rational Portfolio Manager

PROFESSIONAL EXPERIENCE:

Confidential, Mounds View, Minnesota

Oracle PLSQL developer / IT Specialist

Environment: Oracle 11g, Toad, IBM Tivoli Work Scheduler, C#.net, iOS, Tortoise SVN

Responsibilities:

• Response Sales Reps issues and Communicate with them for the solution
• Perform Data analysis to resolve the production support issues
• Deployment new releases in production environment
• Writing complex sql queries to facilitate business needs
• Work with development team to address complex production issues
• Tuning sql queries using explain plan

Confidential, Warren, Michigan

Oracle PLSQL developer

Environment: Oracle 11g, Toad, Sun Solaris 9, Unix shell scripting, Erwin data modelRational Clear Case, Rational Clear Quest

Responsibilities:

• Facilitate User Acceptance Testing Phase requirements
• Data Migration from a classic system to dynamics system
• Gather and understand the requirements and write the design (layout) specification in order to get the input files containing business data from customer eventually to load into dynamics data base
• Writing complex sql queries to facilitate business needs
• Writing procedures, functions and cursors using advanced plsql techniques such as bulk binding
• Debugging and Testing
• Tuning sql queries using explain plan, tkprof, Oracle hints, indexing technique
• Optimization of code to handle huge volume of data using bulk binding

Confidential, Bentonville, Arkansas

Oracle PLSQL Developer

Environment: Oracle 11g, Toad, Sun Solaris 9, Unix shell scripting, Erwin data model, Rational Clear Case, Rational Clear Quest

Responsibilities:

• Interact with the client to understand the requirements and write the technical design specification based on TDD
• Get the input containing business data from client, eventually to load / update into data base
• Writing complex sql queries to facilitate business needs
• Writing procedures, functions and cursors using advanced plsql technique
• Debugging and Testing
• Optimization of code to handle huge volume of data
• Tuning sql queries and plsql code using explain plan, tkprof, bulk binding

Confidential

Oracle PLSQL Developer

Environment: Oracle 9i/10g, Toad, Sun Solaris 8, Unix shell scripting, CA Unicenter, PVCS, Remedy

Responsibilities:

• Interact with the clients to facilitate business discussions to gain consensus and support for service requests.
• Investigate the incidents and communicate with clients to provide the final solution.
• Facilitate business discussions to gain consensus and support for requirements with team leader.
• SQL Query Optimization using explain-plan, Oracle hints, and tkprof.
• Create sql statements, tables, synonyms, sequences, views, and cursors to facilitate business needs.
• Create plsql stored packages, procedures, functions, and triggers.
• Debug and test database packages, procedures, functions, and triggers.
• Create reports using sql*plus to fulfill user requests
• Provide workaround sql statements to avoid severity incidents.
• Created scripts to load data from flat file to database tables using sql*loader.
• Configured tnsnames and sqlnet files.
• Developed utilities using Unix shell script to automate repeated task.
• Responsible for the deployment in the production satisfying change processes.
• Responsible for managing problem management and configuration repository tool.

Confidential

Oracle PLSQL Developer / IT Specialist

Environment: Oracle 9i/10g, Toad, AIX Unix, Unix shell scriptingRational Clear Case, Rational Clear Quest

Responsibilities:

• Interact with the customers to provide support for the production issues.
• Problem Investigation to provide the final solution and apply fix in production.
• Facilitate business discussions to gain consensus, and support for requirements with team members
• SQL Query Optimization using explain-plan, Oracle hints, and tkprof.
• Create sql statements, tables, synonyms, sequences, views, and cursors to facilitate business needs.
• Create plsql-stored packages, procedures, functions, and triggers.
• Import/Export database dump for problem investigation.
• Create reports using sql*plus to fulfill user requests
• Provide workaround sql statements to avoid severity incidents.
• Developed utilities using Unix shell script.
• Responsible for the deployment in the production satisfying change processes.
• Responsible for managing problem management (Clear Quest) and configuration repository tool (Clear Case).
• Developed and executed implementation instructions, Unit and System test cases.

Confidential

Oracle PLSQL Developer

Environment: Oracle 9i, Toad, AIX Unix, Unix shell scriptingProject Description: Confidential Nextel is all about network transactions for GMG (wireline), CDMA (wireless), and IDEN will originate in ATLAS.

Responsibilities:

• Involved in gathering requirements from customers
• Responsible for creating project plan
• Developed advanced plsql programs to upload data from XML file to oracle tables using XML parser
• Debug and test database packages, procedures, functions, and triggers
• Edited existing database programs to facilitate business functions
• Developed Unix shell programs to execute reuse application programs created to upload data received in XML file from People soft interface application.