SUMMARY

• 12 years of IT experience as an Oracle PL/SQL Developer.
• Expertise in Software Development Life Cycle (SDLC) of Projects - System study, Analysis, Physical and Logical design, Coding, Testing and implementing business applications.
• Apply database best practices in software development and maintenance.
• Efficient at handling multiple projects at a time and handle deadlines for deployments effectively.
• Expertise in using Oracle 8i/9i/10g /11g and 12c databases.
• Excellent analytical and organizational skills and provide attention to detail.
• Hands on experience in preparing User Specification Requirement, Software Requirement and Technical documentation.
• Experience in interacting with Business Users, Application Users and working in coordination with Infrastructure DBA’s.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language and maintaining the DDL scripts
• Oracle Applications E-Business Suite (Supply Chain Management Modules). XML Publisher reports on Oracle Applications 11i/R12.
• Experience in Oracle Apps 11i GL, AP, AR, OM modules.
• SQL*Loader, SQL*PLUS, TOAD, SQL Developer and WINSCP3 applications are extensively used to manage the database.
• Experience on Oracle BI Publisher Reports.
• Working experience in data extraction, transformation and loading operations into oracle using SQL Loader, External tables, DB links, Export/import to read and write the files.
• Strong experience in developing SQL/PLSQL Scripts/Programs for Data Analysis, Extraction, Transformation and Loading (ETL) mechanism.
• Extensive Experience on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL, SQL* Loader.
• Extensively worked on BULK COLLECTS, BULK INSERTS, and BULK UPDATES & BULK DELETES for loading, updating and deleting huge data
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan and TKPROF.
• Expertise working with Oracle Database Migration from 10g to 11g conversion.
• Effectively used SQL* Loader to migrate data from Sprint DW to Nextel DW.
• Involved in creating scripts for Creates, Alters and Data Modifications and worked with DBA for implementation.
• Expertise in Optimization Techniques.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Worked with Large Databases like JP MORGAN /US Bank and Sprint.
• Experience in Unix Shell scripting.
• Expertise in preparing technical documentations/presentations.
• Experience in Autosys and d-Series to schedule jobs and for batch monitoring.
• Extensive working Experience with CVS, SVN and SYNERGY change management tools.
• Experience working in On-Shore/Off-shore Development Models
• Experience with JIRA used for Agile methodology.
• Highly adaptable to a fast paced environment with minimal supervision.
• Experience with ticketing systems(HPMS).
• Knowledge of Microsoft Database SQL SERVER.
• An excellent technical ability possesses strong oral and written communications skills, analytical and interpersonal skills.

TECHNICAL SKILLS

ETL Tools: Informatica 8.1, DataStage 7.5.x (Enterprise Edition)

Databases: Oracle 12c/11g/10g/9i/6i, SQL Server 2005/2000.

Reports: Oracle Forms 11g/10g/9i/6i, Cognos8.4, Discoverer 11g.

Programming Languages: C, SQL, PL/SQL, Shell Scripting.

Scheduling tools: Control-M, Autosys, d-Series.

Operating System: Windows 9x/NT/2000/XP, UNIX/LINUX.

ERP: Oracle Apps 11i/R12.

Oracle BI: BI Publisher Reports.

Source Control: SVN, CVS.

Others: Toad, SQL Developer, MS Word, MS Excel, MS PowerPoint,HPMS,HP PPM

PROFESSIONAL EXPERIENCE

Confidential, Orrville, OH

Sr. Oracle Database developer

Responsibilities:

• Work closely with the User/BA’s to get requirements.
• Prepaid Technical Design Documentation.
• Extensively work on developing and modifying complex PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers to implement business rules into the application.
• Involved in UAT testing for the application
• Working with multiple application.
• Modifying and developing database triggers, cursors, procedures, functions and packages to meet business requirements
• Extensively involved in performance tuning using Explain Plan, Optimized SQL queries and created Materialized views for better performance.
• Working in Agile Methodology.
• Participated in daily standup/scrum meeting.
• Analyzing the programming requirements, organizing and prioritizing those developments.
• Tuning the SQL Queries for the existing applications.
• Used the WinSCP3 tool and PUTTY to work in the UNIX environment
• Used Embedded SQL’s in UNIX shell scripts.
• Used d-Series for the job scheduling.
• Create complex reports by using RTF Templates
• Expertise in BI(XML) Publisher Reports Creating Data Templates and complex XML Publisher Templates
• Development and Customizations of Reports using BI Publisher.
• Worked on new/enhancements Discoverer reports.
• Performance Tuning of complex SQL queries using Explain Plan to improve the performance of the reports.
• Used Discoverer Administrator to create and refresh Business Areas.
• Worked on Oracle Apps 11i, AP, OM modules.
• Expertise in RTF Template(layout).
• Used HPSM portfolio to deploy the code into QA and Production
• Involve in Code Reviews and walk through meetings.

Environment: Oracle 12c, Toad, Windows 7, HPUX, Pl/SQL, SQL, SVN, HP Service Manager, d-Series. Discoverer Desktop, Discoverer Administrator, XML/BI Publisher, Oracle Applications E-Business Suite - R12, HP PPM.

Confidential, Akron, OH

Sr. Oracle Database Developer

Responsibilities:

• Extensively work on Production issues reported in UAS.
• Prepaid Business requirement/Technical Design Documentation.
• Analysis of data to resolve various production and QAT bug fixes
• Extensively work on developing and modifying complex PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers to implement business rules into the application.
• Work extensively on Complex SQL scripts which are using for reporting purpose.
• Bug fixing and enhancements if needed in production.
• Develop database utilities used by the application development teams.
• Worked closely with the infrastructure DBA team for successfully implementing the oracle migration from 10g to 11g.
• Prepare and maintain documentation for conversion.
• Perform development DBA related tasks involved with conversion project such as performing import / exports, verifying database objects after migration, comparison of database objects etc.
• Export and import of database objects using Data pump utilities EXPDP and IMPDP.
• Working extensively with application teams in testing in all three tiers for upgrades.
• Migrated data from Flat Files to Oracle database using SQL*Loader and External tables.
• Used Oracle APEX utility to load one-time historical data.
• Modified existing Oracle APEX reports.
• Maintain and troubleshoot Oracle Forms application.
• Database monitoring for queries using Oracle enterprise manager.
• Involve in code reviews with the team lead.
• Experience in working with Data Modeler.
• Created and managed primary data base objects such as Tables, Indexes, Sequences, and Synonyms, materialized views.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Force run the job, if a job fails to complete.
• Developed user documentation for all the application modules. Also, responsible for writing test plan documents and unit testing for the application modules.
• Generated DDL scripts and Created and modified database objects such as tables, views, sequences, functions, synonyms, indexes, packages, stored procedures using SQL Developer tool.
• Provides skills and performs tasks related to technical developments.
• Used Bulk collect and Forall in stored procedures to improve the performance and make the application to run faster.
• Developed List of values to populate data in certain conditions based on Record Groups.
• Worked on Oracle forms bug fixes.
• Developed UNIX Shell scripts to automate table creation, execute procedures
• Work closely with the User to get requirements.
• Analyzing the programming requirements, organizing and prioritizing those developments.
• Troubleshoot and resolve technical issue during development.
• Manage change via an established change management process.
• Coordinating with the Offshore Resources on an everyday basis.
• Involve in Code Reviews and walk through meetings.
• Prepared UNIX shell script for the transfer of files from FTP to SFTP.

Environment: Oracle 10g,11g, Oracle Forms 6i,11g, SQL Developer, Windows XP, Pl/SQL, SQL, SVN, HP Service Manager, JIRA.

Confidential, Durham, NC

Oracle Database Developer

Responsibilities:

• Involved in the reporting for all the eligible states for C2C which contains the performance information.
• Generated the reports for C2C in .txt, .html, .csv formats.
• Extensively Involved in Performance Tuning the PL/SQL code written for C2C reporting project.
• Involved in the reporting for state west reports which contains both performance and penalty information of customers.
• Generated state west reports for IL, NV and OH States in excel format.
• Extensively usedDynamic SQL.
• Implemented new functionalities for existing applications.
• Written PL/SQL scripts to create new tables and their corresponding database sequences, synonyms, indexes, and constraints and PL/SQL packages.
• Work with the QA teams in resolving the Quality center defects and support them in QA testing activities for QA code drops.

Environment: Oracle 11g, TOAD, Windows XP, Pl/SQL, SQL.

Confidential, Jersey City, NJ

Oracle Database Developer

Responsibilities:

• Involved in the integration of existing V-DMA application, A-DMA application, V-Dashboard and Arachni applications in single web based new DMA system.
• Extensively Involved in Performance Tuning the PL/SQL code written for both the V-DMA and A-DMA applications.
• Implemented new functionalities for existing applications.
• Partitioned large tables to maintain data of few tables.
• Created local indexes on partitioned tables to improve the performance.
• Involved in resolving most performance issues and bottleneck issues.
• Worked on Oracle 11g Database using Sql and Pl/Sql.
• Created GTT for the performance.
• Worked on Table Partitioning and deploying various methods of indexing like local Indexes and Global Indexes on partitioned tables.
• Performed PERFORMANCE TUNING of the tables and queries by using HINTS, defining
• INDEXES, PURGING TABLES, set up periodic scheduled maintenance tasks like EXPLAIN PLAN
• Written PL/SQL scripts to create new tables and their corresponding database sequences, synonyms, indexes, and constraints.
• Performance tuned the whole code to meet the deadline of deployment.
• Involved in UAT testing of the application.
• Work closely with the testing team to provide them with necessary testing information.

Environment: Oracle 10g, TOAD, Windows XP, Pl/SQL, SQL, SVN.

Confidential, Atlanta, GA

Oracle PL/SQL Developer/ Cognos Developer

Responsibilities:

• Worked extensively with Business User to gather requirements and implemented those using Stored Procedures.
• Extensively worked in developing Cognos reports for the Merchant processing system.
• Developed Cognos Framework Models in Oracle.
• Worked with High Transaction volume data to increase the Performance of stored procedures Using Explain plan and Hints.
• Extensively worked in developing Complex PL/SQL Stored Procedures, Functions, Packages, Cursors and Triggers to implement business rules into the application.
• Worked extensively on Complex SQL scripts which were used for reporting purpose.
• Extensively involved in performance tuning using Explain Plan, Optimized SQL queries and created Materialized views for better performance.
• Worked Extensively In setting up Batch Process Using Autosys Scheduler.
• Worked on deploying the code using the version controls tool.
• Created reports using Cognos and automated scripts to validate the integrity of the data based on end user needs.
• Created standard filters, calculation prompts, and conditions.
• Analyze, designed, developed, implemented complex models and reports.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Written PL/SQL scripts to create new tables and their corresponding database triggers, sequences, synonyms, indexes, and constraints.
• Designed Oracle tables, views, synonyms for the application.
• Developed various jobs using stages Oracle enterprise, Lookup, Dataset, Join, Sort, Aggregator, Filter, Modify, Funnel, Peek (debugging stage), Funnel, and RDBMS stages extensively.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Developed Views which were used for reporting purpose.

Environment: Oracle 10g, TOAD, Windows XP, Pl/SQL, SQL, Cognos8.4, UNIX. DataStage 8.1, DataStage 7.5.2 (Enterprise Edition), Autosys.

Confidential, Reston, VA

Oracle Pl/SQL Developer

Responsibilities:

• Responsible for application development using Oracle, SQL, PL/SQL, packages, stored procedures, SQL*Loader and UNIX Shell scripting
• Performed PERFORMANCE TUNING of the tables and queries by using HINTS, defining INDEXES Etc...
• Partitioned large tables to maintain data of few tables.
• Created local indexes on partitioned tables to improve the performance.
• Developed UNIX Shell scripts to automate repetitive database processes
• Loaded the files for the UBP conversion from P2K (Sprint) to Ensemble (Nextel) using SQL Loader.
• Used Embedded SQL’s in UNIX shell scripts.

Environment: Oracle 9i (Version 9.2.0.6.0), SQL, PL/SQL, SQL*Loader, HP-UNIX (9.2.0.7.0), Shell Scripting, TOAD (Version 8.6.1.0), PUTTY (0.55 Release), WinSCP3.

Confidential, Ohio

Oracle PL/SQL Developer

Responsibilities:

• Interact with business analysts to develop modeling techniques and re-structuring strategies
• Modifying existing SQL code and performance tuning if necessary.
• Wrote Stored Procedure, Package for back end validations
• Wrote Procedures using Oracle supplied Packages
• Read data from flat files and uploading that data into oracle tables using SQL*loader.
• Created test Cases as per the business requirements and executed them.
• Provided Test Data to QA team to validate front end application. Also performed unit testing.

Environment: Oracle 9i, 10g, PL/SQL, PL/SQL Developer, Windows XP Pro.

Confidential

Jr.PL/SQL Developer

Responsibilities:

• Wrote Stored Procedure, Package and Triggers for back end validations.
• Involved in team meetings, preparing Meeting minutes.
• Code base consists of complex package logic that uses DML and writes all SQL executed to log tables for troubleshooting, and logic that processes logistical data for optimizing selecting a product and its features available across different companies. Measuring and reporting product list using Excel, PL/SQL scripts.
• Wrote complex SQL queries using joins and correlated sub queries

Environment: Oracle 9i, (SQL*Plus, PL/SQL Developer), Windows, MS Office 2003 (Excel, Word).