SUMMARY

• Around Five years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Development of client/server and multi - tiered applications using the Oracle Relational Database Management System(RDBMS), SQL, and PL/SQL on different platforms like Windows NT/2000/XP, UNIX and Linux. Good experience of Performance AnalysisandSQL query tuning,while designing scalable applications from scratch and maintaining existing ones, using Query Optimizer, Indexes, Execution Plans, Hints, Explain Plan, And Tk-prof
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation, and Post Implementation surveys. Highly skilled in Design, Development, Implementation, and Testing of business applications, Unit and System testing on thedatabase.
• Proficient in PL/SQL programming - Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects - Tables, Views, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges on OLTP server.
• Provide Application System Support and Analysis for Deltek CloudERPSolutions performance testing and final end-to-end testing carried out by various AOL QA groups
• Experienced in Dynamic SQL, PL/SQL Collections,and Exception handling.
• Support applications for executing the Developer Suite work flows and analyzing/debugging the session's logs
• Experienced in loading data into Oracle Database using Data Loader and SQL*Loader.
• Extensive experience in data migration techniques using SQL* Loader, Import/Export.
• Experience in advanced PL/SQL concepts like Bulk collect, Multi Table insert, PL/SQL table, Cursors, Nested tables, V arrays, Records, Types and Dynamic SQL for DML operations for better performance.
• Proficient in Oracle 12c/11g/10g/9i/8i/7.3 PL/SQL backend applications development Toad, SQL Plus, and PL/SQL Developer.
• Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning.
• Configured RMAN backups with the usage of newly introducedoracle12c container databases.
• Experience in creating SQL loader scripts to load data from flat files into the database and also creating External Tables to manage data which is store at the OS level.
• Develop many front-end applications using APEX 4.2.
• Assist in design and development of large-scalePerlapplications and Created Perl scripts usingDBI/DBDfor data extraction
• Developed and designed dynamic configuration wrapper in Perl to generate flat fund reports
• Worked on Oracle Forms 12c/11g/10g/9i/6iReports 11g/10g/9i/6i.
• Well-versed with different stages of Software Development Life Cycle (SDLC).
• Extensively used PL/SQL to build Oracle Reports 12c/11g/10g and views for processing data, enforcing referential integrity and needed business rules.
• Experienced in Tuning Queries for better performance with alarge volume of data. Extensive experience in developing applications using Oracle Forms / Reports. Experience in almost all the versions of Forms/Reports.
• Excellent analytical, problem-solving, communication and interpersonal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved in the System Development Lifecycle.
• Expertise in implementing ETL (extract, transform and load) by using Oracle WarehouseBuilder (OWB).
• Experience in migration of source code using version control system ( Confidential, Arch, Visual source safe, svn, TFS).

TECHNICAL SKILLS

Operating systems: UNIX, LINUX, Windows Vista/XP/2000/98, MS-DOS, MAC

Languages: SQL, PL/SQL, Unix Shell Scripts, JSP, C, C++, java, CSS, HTML, XML.

RDBMS: Oracle 12c/11g/10g/9i/8i, MS-SQL Server 2000/2005, Sybase, DB2, MS Access.

Oracle Utilities: SQL*Plus, SQL*Loader, SQL developer, TOAD.

GUI Tools: APEX 4.2,3.2,Oracle Forms 11g,10g,9i,6i and Reports 11g,10g,9i,6i, ERWIN,VISIO, Golden gate, Autosys, Control-M, JIRA and HP quality center, PAC 2000.

PROFESSIONAL EXPERIENCE

Confidential, CO

ORACLE PL/SQL DEVELOPER

Responsibilities:

• Worked as an OracleDeveloperto provide basic support to the client for Database and Insurance Application. Also provided support for primaryleveldebugging (applicationproblems)
• Working currently withOracleE-Business Suite (EBS)R12apps, and was involved in the upgrade process
• Configuration and Administration ofOracle12c/11g/10g databases on various Operating Systems.
• User interaction, requirement analysis, functionalspecification, design, development,andimplementation.
• Involved in developing DB objects like tables, triggers,and Views.
• Using Swing Concepts in Java Front End Forms are designed.
• Developed and customized number of reports using Oracle Reports and Forms.
• Using Oracle JDeveloper Database tools to write triggers and procedures, Function.
• Worked with Java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Involved in the development of Functions, Procedures, and Packages to transfer data into the database tables.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Worked as a member of the writing staff providing documentation for AOL's eCommerce subsystem which is part of the new AOL Digital Media Platform (DMP) offering.
• Created database diagrams and flow charts using Visio Professional. Worked with Subject Matter Experts (SMEs) using Microsoft Word and Visio to create documentation and to demonstrate object relationships.
• Wrote SQL, PL/SQL, programs to retrieve data from the flat files
• Transferred data from flat files into the database tables using SQL* Loader.
• Extensively used IMPORT utility to load the exportedfiles.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Expertise inworkingon Cloud basedERPapplications
• Used ExplainPlan, HINTS, DBMSProfiler for performance tuning of SQL, Pl/SQL queries.
• Supported code push preparing change for new version release of application support to end jobs, also involve in Troubleshooting, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Extensively used Cursors, User-definedObjecttypes, Records, and Tables in PL/SQL Programming for generating worksheets.
• Create/maintain and modify complex database triggers and datamigrationscripts.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used SQL*LOADER to upload data into the tables.

Environment: Oracle 12c/11g, SQL, PL/SQL, Oracle SQL developer, SQL navigator 7.2, Autosys, Oracle RDBMS, UNIX, Informatica Power Center, PAC2000.

Confidential, Monroeville, PA

Oracle Developer

Responsibilities:

• Studied user requirements and functional specifications.
• Developed EntityRelationship diagrams/Dimensional Diagrams for business requirements
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in designing ERdiagram using VISIO, to set the logical and physical relationships of thedatabase.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Experience with Oracle partitioned tables and queries.
• High-Transaction environment experience.
• Loaded the data into database tables using SQL*loader from thetext and excel files.
• Developed data model, SQL Coding, SQL Query tuning process,andSchemas.
• Developed SQL Scripts, Packages,and Procedures for Business rules check to implement business rules.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of alarge number of tables in PL/SQL blocks and even have experience with exception handling.
• Created scheduled and schedule now reports.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.
• Good experience in GG mapping.
• Created materialized views to assist GGdevelopment.
• Good in understanding the GG deployment and tune the performance.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, UNIX, Formsand Reports 11g, MS Windows 7,VISIO, GOLDEN GATE,Informatica Power Center

Confidential, Dallas, TX

SQL Developer

Responsibilities:

• Worked on the project that involved development and implementation of a data warehouse.
• Created Stored Procedures, Functions, Triggers, Indexes,and Views using T-SQL in all the environments for SQL Server 2000.
• Developed DTSPackages to transfer the data between SQLServer and otherdatabase and files.
• Scheduled jobs & Re-Scheduled on Production Databases.
• Created report form with Stored Procedure using T-SQL
• Wrote and optimized Triggers, Stored Procedures,and Queries in T-SQL.
• Created database objects like tables, views,and indexes.
• Created SSISPackages to perform filtering operations and to import the data on daily basis from the OLTP system toSQLserver.
• Created Perl scripts usingDBI/DBDfor data extraction.
• Used variousCPANPerl modulesto enhance the functionality
• Created and modified stored procedures, triggers,and cursors.
• Designed, developed and modified various Reports.
• Handled and managed customer relationship management system.
• Designing and modeling database according to Requirement. And made changes according to it.
• Designed, developed, and tested complex queries for Reports distribution.
• Built and performed user acceptance testing on modified reports.
• Skilled in running jobs in Enterprise Manager using thejob-scheduling tool.
• Using Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIXCrontab for the scheduled batch processes.
• Expertise in creating shell scripts and used Crontab in UNIX environment for scheduling routine tasks.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using the golden gate.

Environment: MS SQL Server 2000/2005, My SQL, Lotus Notes, MS Access, MS Office Suite (Word, PowerPoint, Excel).

Confidential

Jr. Oracle Developer

Responsibilities:

• Responsible for analyzing business functionality for the back-end processes.
• Created PL/SQLstored procedures, functions, and packages for moving the data from staging.
• Involved in using dimensional modeling, created fact tables, dimensional tables and other database objects in the Star schema model.
• Developed ETL processes for Data Extraction, Data Mapping and Data Conversion usingPL/SQL scriptsand load data into warehouse Schemas.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Responsible to load various table data, flat file data to populated and processed on daily basis from legacy to the online production environment using SQL*LOADER.
• Involved in creating user interface Forms and reports using Oracle Forms/Reports 6i.
• Participated in performance tuning, unit test case preparation and execution.

Environment: Oracle 8i, SQL, PL/SQL, TOAD, SQL*Loader, SQL*Plus, Forms 6i, Reports 6i, Windows 2000.

Web Design/UI Developer

Confidential, Housto,TX

Responsibilities:

• Design and Development of components for this Web page using ASP.NET, C#.NET, JavaScript, XML, XSLT.
• Designed User Interface using Web Forms, Win forms, DHTML, XSLT, XML, JavaScript, AJAX, CSS, ASP.NET, Server Controls and Visual Studio.Net.
• Designed and developing web controls, master pages, validation controls, CSS files using C#.NET, VB.NET, jQuery, XML, HTML and ASP.NET 2.0/3.5/4.0.
• Used Themes, Skins and CSS to give look and feel to Web pages using ASP.Net
• Implemented UI using JQUERY, AJAX andExtJS, JavaScript, XML, JSON forinteractive cross browser functionality and complex user interface.
• Designed rich User Interface screens using MVC and Silverlight with C#.
• Created various UI components for different web pages using HTML, JavaScript, andExtJS.
• Created user interfaces by using ASP.NET Web forms and Webservercontrols.
• Participated in requirement gathering sessions with the client and server
• Involved in designing, analysis and development of application using ASP.Net, C#, HTML, CSS and SQL Server 2008.
• Involved in coding the Business Layer and Data Access Layer using C# .NET. Designed the web forms, user controls, master pages using the technologies HTML and Asp.net
• Created the style sheets required for the application and used them for achieving uniformity through all the aspx pages.
• Created the client-side functionalities/data validations using JavaScript. preparation/modifying of the requirements in Requirement Specification document using UML.

Environment: .Net Framework 2.0, C#.NET, ASP.Net 2.0, ADO.Net, SQL Server 2005Visual Studio.Net 2005, TSQL, XML, XSLT, WCF, UML, WPF, Ajax, JavaScriptSSRS, DHTML, CSS, HTML, N-Unit, IIS, Windows XP.