SUMMARY:

• Oracle developer with 7+ years of total IT experience in the areas of analysis, design, development, implementation and management of full life cycle commercial applications.
• Proven technical skills with 7 years of experience in Oracle SQL, PL/SQL and oracle 9i/10g/11g.
• Experienced in developing Stored Procedures, Functions and Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Synonyms, Database Links, User Defined Data Types, Nested Tables and Collections.
• Have extensive experience in developing, implementing and maintaining application systems under Windows/Unix operating systems using SQL, PL/SQL, Oracle Database and many other facilities, such as Import/Export, SQL*Loader and SQL*Plus.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
• Excellent experience of managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, Informatica Power Center 9.x/8.x,Target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of indexes for enhancing performance for data access.
• Expert in UNIX Shell scripting (Bourne, Korn).
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Carry out pruning activity of converting Pro *C code in to Oracle PLSQL.
• Highly skilled in business/function analysis, data modeling and relational database design extensive experience in developing/supporting company-wide systems. Proven ability to work with a wide range of departments and levels of management.
• Excellent team member with problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic team player.
• Gone through each and every phase of software development life cycle for a significant period of time.
• Ability to learn new tools, concepts and environments.
• Ability to explain technical concepts and communicate with users and system administrators Confidential all levels.

TECHNICAL SKILLS:

Languages and Technologies: PL SQL, SQL, SQL plus, C, C++, JAVA, HTML, Java Scripts, UNIX scriptsOperating SystemsMS Windows 7/ NT/ 2000/ XP & VISTA, and UNIX.

Databases: Oracle 8i, 9i, 10g, 11g, Access, DB2, MS SQL Server GUI(S)Visual basic 6.0, ASP, HTML, Cold Fusion

Tools: Oracle SQL Developer, SQL*Plus, TOAD, SQL *Loader, ANSI SQL, Oracle procedure Builder, Bugzilla, ETL tool (Informatica), ProC*, HP Quality Centre, MS Excel, Power point.

Reports: Crystal Reports, Oracle Reports, MS visual studio 2005, SSRS, OBIEE, and COGNOS.

Version Control: Visual SourceSafe

PROFESSIONAL EXPERIENCE:

Confidential, OH

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developing Stored Procedures, Functions and Triggers.
• Development was done extensively on collections (Associative Arrays, Nested Tables)
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.

Environment: Oracle 11g, 12c, Toad, UNIX, MS visual studio 2005, Bugzilla, SVN Tortoise

Confidential, VA

Oracle PL/SQL Developer

Responsibilities:

• Altered the database structures according to the new system
• Altered the triggers to match up with the new structures and new business logic
• Maintaining the existing procedures and other SQL scripts
• Altered the procedures and functions according new business requirement.
• Developed Unit test harness to test the loaded data.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Preparation of the Test Cases and involvement in Unit Testing and Integration Testing.
• Used HPIMS, HPMKT as version controlling Confidential UNIX box level.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed performance tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries manually by Explain plan.
• Involved in handling the changes in compiling scripts according to the database changes.
• Used Java as middle tier to the front end.
• Used spring JDBC templates to get the data from back end.
• Used VBA to troubleshoot the flat files and parsing.
• Extensive use of JavaScript Confidential front end to validate store manager’s web browser.

Environment: Oracle 11gR1, UNIX, PL/SQL Developer, spring, JDBC, java, PET, Clear case

Confidential, CT

Oracle PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Loading of customer data from flat files using SQL loader.
• Created tables, Functions, Triggers, procedures and packages for implementing complex database intensive business rules.
• Encrypted the PL/SQL code using wrappers.
• Created Indexes and sequences for faster retrieval of the customer information and enhance the database performance.
• Involved in writing test cases to ensure that requirements are met in the developed application.
• Created Korn Shell scripts, Bourne Shell Scripts and Bash Shell for automating tasks as well as for creating extracts.
• Performance tuning of the application programs using EXPLAIN PLAN and SQL TRACE.
• Used the rollup and cube operators to generate summaries.
• Developed of Oracle Reports of purchasing module.
• Developed forms screens like my policy, insurance claim.

Environment: Oracle 10g, UNIX, Windows XP, PL/SQL, SQL*PLUS, Oracle Reports, SQL Developer.

Confidential, GA

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Developing Stored Procedures, Functions and Triggers.
• Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.
• Maintaining daily batch cycle and providing 24 hour production support.
• Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Developed automated scripts to schedule the load of flat files on daily, weekly and monthly basis.
• Interaction and coordination with various application teams for resolving issues, patch movements.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.
• Partitioned tables and indexes for better performance of application.
• Involved in importing the production data to lower environments for testing purpose.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support.

Environment: Coldfusion 8/9, Oracle 9i, 10g, UNIX, ant scripts, web server, MS visual studio 2005

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Responsible for system study & information gathering.
• Development was done using front end as Oracle Pl/Sql Developer/2000.
• Involved in creation of Tables using storage parameters and clusters.
• Involved in writing Database procedures, Functions, Packages and Database Triggers.
• Coded many generic routines (as functions), which could be called from other procedures.
• Developed user interface screens, Master detail relations and Report screens.
• Developed various Reports for the end users as per their requirements and created many reports to suit preprinted format of the company.
• Developed complex Forms and Reports using Oracle tools.
• Conducted sessions to end-users.
• Involved in integration testing.

Environment: Oracle 8i, PL/SQL, Windows 2000 server, Visual Source Safe, SQL Loader, Shell Scripting, Developer 2000