SUMMARY:

• Over 7+years of IT experience as an Oracle PL/SQL developer and Oracle Forms and Reports Developer on variety of Window and UNIX platforms with Oracle 11g/10g/9i/8i.
• Oracle certified Associate (OCA) in IZ - 007.
• Worked with clients in different domains like Insurance, Banking-Finance, FMCG and Mortgage.
• Experienced on complete Software Development Life Cycle (SDLC) using various methodologies like Rational Unified Process (RUP), Waterfall Model, Agile, V-Model and SCRUM.
• Involved in Analysis, Design, Development, Migration, Testing and Implementation ofERPin multi-tier architecture.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 8i/ 9i/10g/11g, T-SQL, SQL Server 7.x/2000/2005 and 2008, Oracle Forms 6i/9i/10g, Oracle Reports 6i/9i/10g.
• Expertise in Oracle Database Architecture and making structural changes to the database.
• Ample of experience working in various stages of a database design, includingData Modeling, Schema Design, User creation, Designing Physical and Logical structure.
• Hands on experience in preparing UserSpecification Requirement, SoftwareRequirement, Technical Documentation, and Test Plan.
• Proficient with Database Cloning, Migration, Standby Database, Data Guard of Oracle Databases and Oracle Applications.
• Worked in Client/Server Architecture, design and development of User Interfaces and Customization of Forms and Reports based on the user requirement using Oracle Forms and Reports.
• Experienced in file loading using SQL Loader, file manipulation and emailing capabilities of Oracle using in-built packages.
• Excellent experience in Oracle 11g/10g/9.x development using PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views, Oracle Objects.
• Expertise in using EXPDP/IMPDP (Data pump) to take the hot backup using DUPLICATE or full export and also to accomplish table level and full database de-fragmentation.
• Experienced in ETL techniques and Analysis and Reporting including hand on experience with Extracted data from Oracle using SQL Developer through facility and generated ad-hoc reports.
• Used PROC SQL for ad-hoc report programming, to perform the tasks like data manipulation of multiple views in Oracle, creation of the ad hoc reports for marketing research data, preplanning and doing ad hoc joining of multiple Oracle views.
• Documented all the processes involved in designing, development of projects and database for future reference.
• Provided 24 x 7 dedicated supports to production, development & test application environment.
• Goal Oriented individual with ability to direct complex projects from concept to fully operational status.
• Organized, good interpersonal, communication and documentation skills.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, Microsoft SQL Server 2000/2005/2008 , MS Access 97&2000, My SQL, Sybase server, Teradata.

DB Utilities: SQL Loader, OWB, Export/Import, Data Pump, Explain Plan, TKPROF,AutoTraceSQL Navigator

Reporting Tools: Forms builder 9i/6i, Reports builder 9i/6i, ERWIN, Oracle Discoverer 6i,Crystal ReportsInformatica, Oracle Forms 10g/6i, Oracle Reports 10g/6i, SQL Server (SSRS), Report Studio, Dashboard.

Operating systems: Windows NT, Windows XP/95/98/2000, Windows Server 2003/2008, Linux, UNIX.

Languages: C, C++, T-SQL, PL SQL, Java, Shell Programming (Korn).

Web Technologies: XML, HTML, CSS, ASP.Net, VB script, MS front page 2000.

Tools: TOAD 9.0/9.1/9.5/9.6/10.1.18 , 10.6, Oracle SQL Developer, PL/SQL Developer7,MS Project 2000ERWIN 4.14/ 4.0 MS Office 97/2000/2003 , Power Builder,MS Outlook 97/2000/2003 , ER, Studio, Mind map, Dream weaver, MS Communicator, MS Visual Studio.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Oracle PL/SQL Developer

Environment: Oracle 9i/11g, Surround SCM,Toad10.6,Textpad,MicrosoftOutlook 2007,Trillian,Informatica,SQL Developer,SQL*Loader,SnagIT 8,ColdFusion,Windows XP,SQL Navigator, Excel 2007,HP Quality center.

Responsibilities:

• Participated in different phases of a project analysis phase, preparing the techicnical specification, development and testing.
• Involved in multiple projects had a chance to explore different applications, understand the applications and prepared the documents accordingly.
• Project involved the enhancement of existing application in order to provide a user - friendly & reliable for users
• Propose possible solutions to business and obtained approval and sign off from business.
• Gather data from production; load it into development database for data analysis.
• Generate reports and statistics to figure out the cause of the problem; setup test cases to confirm the data analysis and present the results to all business parties.
• Perform feasibility analysis on the approved solutions and change oracle code to present proof of concept.
• Extensively used CURSORS, Ref cursors for returning query results from an Oracle Database to a client application.
• Concepts used to achieve hierarchical queries LAG OVER PARTITION, SYS CONNECT BY PATH which played a major role in displaying the required output.
• In corporate oracle best practices for current version, while keeping it generic for the expected migration to 11g.
• Ran scripts in 11g as a part of migration from 9i to 11g & edited few scripts to support 11g environment.
• REGEXP INSTR, REGEXP SUBSTR, SEQUENCES CONTINUE are some of the features used in 11g as part of migration.
• Achieved faster query execution time by performing the tuning using concepts like auto trace, explain plan, query viewer which helped in providing the best solution.
• Applied XML concepts including elements, forest, and aggregate to extract a large amount of data from the database.
• To handle exceptions wrote various exception handlers to improve reliability.
• Team will first, implemented all the changes in the development environment. This will ensure minimal disturbance to the existing services.
• Following successful unit testing, changes will be moved to SQA. All changes have to pass integration testing and regression testing by SQA team. Any issues raised by SQA team have to be addressed before moving to UAT.
• Concerns by UAT users will be addressed prior to production release.
• All changes have to pass unit testing, integration testing and regression testing before being approved for production.
• Provided 24/7 support in time of deployment and also production issues.
• Document and evaluate changes required to complete and map business requirements to technical requirements, test case documents which can be used for user training.

Confidential, New Britain, CT

PL/SQL Developer

Environment: Oracle 11g/10g, Windows 2008/XP, PL/SQL, SQL*PLUS, TOAD 9.6, SQL Developer, SQL*Loader,UNIX,MS SQL SERVER2005/2008,Erwin, Crystal Reports,MS Outlook 2000/2003, MS Communicator, Oracle Forms10g, Oracle Reports 10g,Report Studio,SQL Navigator.

Responsibilities:

• Participated in phases of development like System Analysis, Design, Coding, Development and Implementation and provide support to existing client databases.
• Extensively used feature of oracle 10g in data pump utilities (EXPDP/IMPDP) for copying of data from development server to test and production server.
• Developed backend processes using SQL, PL/SQL and dynamic SQL to create oracle objects, stored procedures, packages, and triggers.
• Profoundly worked with high - performance PL/SQL features such as REF Cursor, Composite Data Types such as Records, Collections, Bulk Collect and Autonomous Transactions.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V arrays, Records, Materialized views, Dynamic SQL.
• Developed scripts to migrate data from flat files to target tables performing required validations on the data using ETL.
• Developed interfaces/screens using Forms10g for the users and used Triggers to validate the data.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Performed SQL tuning to prevent performance issues from impacting production and end users.
• Developed Reports using Reports10g (Creating EUL, Business Areas, Privileges, Administration functionalities, Reports through User Edition).
• Generated Dashboard report, List Reports, Cross Tab Reports and Drill through reports using Report Studio
• Personalized standard reports and forms according to business requirements, using Oracle Forms and Reports.
• Documented all the processes involved in project for future reference.

Confidential, San Jose, CA

Oracle PL/SQL Developer

Environment: Oracle10g/9iAS, Oracle OEM, Perl 5.1,Oracle Developer 9i, SQL * PLUS, MS-SQL SERVER 2005, Toad 9.6, JAVA,PL/SQL, MS-Visio,HTML, Power Builder 8.03,XML, Developer, ERWIN Unix Shell Scripts, SQL Loader and Crystal reporting, Oracle Forms 10g,6i,Oracle reports 10g,6i.

Responsibilities:

• Gathered requirement from the business users, prepared functional specification and design documents.
• Involved in the design of logical and physical data model of the components.
• Wrote complex SQL queries and PL/SQL procedures to extract data from various source tables of data warehouse.
• Developed a PowerBuilder application framework and several applications to manage the security and code tables for Oracle database.
• Wrote a PowerBuilder application to track the investments of their executives in a SQL Server database.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Created custom triggers for the validation of input data and to implement business rules.
• Created Ms Access ODBC connection Strings, functions to connect to the oracle database and execute the procedure from the access front end.
• Created Packages, Procedures and Functions that extensively used PL/SQL cursors, user defined object types and exception handling.
• Migration of the existing SQL Server procedures, function and Views into Oracles PL/SQL Packages, Procedures, Functions and views to calculate the manufacturing cost.
• Used SQL trace facility and TK PROF along with Explain Plan and Partitioning to accurately assess the efficiency of the SQL statements when the application runs.
• Generated various timely based Reports and also modified the discrete job data Reports to add custom fields, and altered layouts as per client requirements using Oracle Reports
• Developed necessary Forms based on the business requirements and customized the existing forms using Oracle Forms.
• Used UML and MS - Visio to create data model diagrams.
• Prepared the technical documentation and user support documents.
• Analyzed and designed UML model using ERWIM to reflect existing business models.

Confidential, Bloomington, IL

Oracle PL/SQL Developer

Environment: Oracle9i,SQL,PL/SQL,OracleDesigner2000,Toad5.0,UNIX,MSOutlook98/2000,MSWord,Micrsoft SQL Server 2005, Windows XP, Erwin, Mind Map, Oracle Forms 9i, Reports 9i, Teradata, Java

Responsibilities:

• Interacting with the clients to understand the requirements and Designing module wise Oracle 9i database structure and its implementation on the client server.
• Developed Function Definitions, Entity Access Matrix and Entity Life History Diagrams using SSADM, Mind Map and Excel 2000.
• Wrote new pl/sql packages, procedures of the application in accordance with the prevailing standards of the application using Oracle Designer.
• Enhanced the existing packages of the application by adding new procedures and new business logic accordance with the prevailing standards of the application.
• Performed Data Analyst role, to analyze the data and to clean the DB schema.
• Developed Database objects like Views, Materialized Views, Indexes, Sequences, and Synonyms.
• Wrote shell scripts to process PL/SQL procedures and wrote PL/SQL program units for data extracting, transforming and loading
• Fine - tuned, the SQL queries in order to improve the overall system performance
• Taking logical backups using export at object and schema level to save space and reduce fragmentation in your database.
• Wrote UNIX shell scripts to encrypt flat files that are created by Oracle Job s and to upload FTP the flat files to the designated server.
• Wrote new procedures, which are triggered by UNIX shell script to process the staging data and do the required process.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Assisted in setting up the Forms and Reports Services on standard 6i server.
• Support for the development, pre-production and the production databases.

Confidential, Richmond, VA

Oracle PL/SQL Developer

Environment: Oracle 9i, PL/SQL, PERL, HTML, Discoverer, SQL*PlusReports, Sql*Loader, Windows xp, UNIX, TKPROF, MS Outlook 2000, TOAD, Mind Map, MS Office, Oracle Reports9i/6i, Oracle Forms9i/6i.

Responsibilities:

• Participated meetings to gather functional and non - functional requirements with tax experts, tax officers and end-users.
• Involved in system analysis and developed requirement catalog.
• Participated in developing Entity-Entity Matrix, Logical Data Model and Data Flow Diagrams.
• Created Tables & Views and referential integrity constraints using SQL and wrote Database Triggers, Procedure & Functions using PL/SQL.
• Created index on all key fields and analyzing tables is done to reduce query return times. Materialized views are created in many cases for frequent refreshes of data and also to improve performance.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Developed Menu Model Diagrams and Input/output structures for the data entry screens.
• Involved in developing the Process Model Diagrams to represent the Income Tax business processes
• Used DBMS PROFILER package to understand where the code is spending the most time, detect it and then optimize it.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, used these tools with EXPLAIN PLAN.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Orecle8i as back-end.
• Intensively involved providing end-user trainings to tax officers and data-entry operators.
• Designed and developed Web-enabled Oracle Forms & Reports including Forms based on stored procedures.
• Used the Crontab in UNIX for Automatic Tasks like loading data into Tables, Importing and Exporting data.
• Assisted in setting up the Forms and Reports Services on 9i and 6i AS.

Confidential, Miami, FL

Oracle PL/SQL Developer

Environment: Oracle 9i,HTML,PL/SQL,Informatica Power Center 8.6, SQL Loader,Toad, Windows 98/2000/2003 , MS Outlook, Microsoft SQL Server 2000/2003, Unix.

Responsibilities:

• Understanding the existing application and its related back end business logic and wrote technical documentation for the proposed changes in the application.
• Involved in the development of the Function Hierarchical Diagrams, Entity Relationship Diagrams for batch as well as core modules.
• Extraction of data from source systems through Excel and Flat files, loading in to the data mart tables for report needs.
• Designed the database from scratch using Oracle SQL*Plus and additional Oracle Objects including Tables, Views, Sequences, Triggers, etc. were also developed during this process.
• Use ofEXPLAIN PLAN, ANALYZE, HINTSto tune queries for better performance and also Extensive Usageof Indexes
• Monitoring existingSQL codeandperformance tuningif necessary.
• Loaded data from flat files and load data to warehouse using External Tables and PL/SQL Scripts using SQL*Loader and ETL with PL/SQL.
• Developed interfaces using PL/SQL procedures and created packages to load data into targeted Oracle database.
• Verified the loads and involved in debugging process team.
• Provided database support to testing team in writing complex SQL queries.
• Prepared the detailed design document, test cases and use cases for business requirements
• Measuring and reporting response rates using Excel,PL/SQL script.