Oracle Pl/sql Developer (oracle 11g) Resume
VA
PROFESSIONAL SUMMARY:
- Senior IT Professional with more than 27 years of experience in the Information Technology industry.
- Areas of specialization include Performance Tuning techniques at schema and Server level, Data Modeling, and ORACLE PL/SQL and Oracle 8i/9i/10g/11g.
- Application tuning: Tuned both front - end and back-end which involves SQL and PL/SQL using the Oracle tuning methodology like Partition, Index, clustering and Parallel query techniques for CPUs; have also used SQL tuning tools like stat pack, auto trace and explain table.
- Database administration: Experience with data modeling, PL/SQL and SQL tuning, tuning the SGA and ETL type of works except the backup and restore techniques of RMAN. Have also done Unix automation process Scripts using KSH scripting and also Windows scripting.
- Data modeling: Have done schema re-engineering as well as new schema modeling using Erwin. Possesses strong data modeling knowledge in star and snow-flex schema. Have also re-engineered existing schema and plugged in many new process model using Erwin tool and also have strong normalization techniques which can be used for old or new process models.
- Experience with Oracle OEM/Grid Control and DBA Tools using sqldeveloper
- Have experts experience in REMOTE database extract using Oracle BULK processing techniques and performance tuning techniques, which involves TWO PETABYTES of data storage in process.
AREAS OF SPECIALIZATION ON ORACLE PLATFORM:
- ETL tool in ORACLE Platform
- Other ETL tool and supporting tools
- Oracle 8i/9i/10g/11g
- Sql server 2000
- Abinitio
- Oracle PL/SQL
- T-SQL
- Unix shell scripting
- Oracle performance Tuning Techniques
- ETL Tool
- Autosys
- Oracle Bulk processing Methodology
- Transformation of data from ORACLE data to SQLSERVER Methodology
- Oracle ETL Tool (Sqlloader/Export/Import )
- Access DB for transformation
PROFESSIONAL EXPERIENCE:
Confidential, VA
Oracle PL/SQL Developer (Oracle 11g)
Responsibilities:
- Analysis and design back-end for data processing.
- Schema patches maintenance using Tortoise SVN.
- Oracle PL/SQL development using PL/SQL Release 11.2.0.1.0 capabilities viz,Triggers, Stored procedures, Functions, Packages, Dynamic SQL and Bulk collect statement.
- Oracle Optimized SQL statements for the application.
- Enhancement or existing application using Oracle PL/SQL code.
- Refactoring PL/SQL packages.
- Support production database.
- Test data preparation.
- Attend URS Data Model, PL/SQL ETL, Data Sync, application and support sessions for modification and enhancement of the system.
- Analysis of application log file from Unix environment for SQL.
- Tools: Oracle Database11g Enterprise Edition Release 11.2.0.1.0 , PL/SQL Release 11.2.0.1.0 ER Studio modeler, Tortoise SVN, Sqldeveloper and PL/SQL Developer 11.0.6, Unix.
Confidential, VA
Sr. Oracle Database Developer (Oracle 11g)
Responsibilities:
- Analysis and design back-end for BULK data processing.
- Oracle SQL Tuning using
- SQL statement tuning (Hints, Rewrite SQL, SQL Profile)
- Instance object tuning (PL/SQL packages, procedures etc)
- Instance Workload tuning (Optimizer setting, Optimizer statistics tuningCursor sharing)
- Schema patches maintenance using Tortoise SVN.
- Oracle PL/SQL development using PL/SQL Release 10g/ 11.2.0.1.0 capabilities viz,Triggers, Stored procedures, Functions, Packages, Dynamic SQL and Bulk collect statement.
- Oracle Optimized SQL statements for the application.
- Enhancement or existing application using Oracle PL/SQL code.
- Refactoring PL/SQL packages.
- Support production database.
- Test data preparation
- Analysis of Unix process monitoring for SQL, TKPROF for oracle performance tuning.
Tools: Oracle Database11g Enterprise Edition Release 11.2.0.1.0 , PL/SQL Release 11.2.0.1.0 , ER/Studio model, Tortoise SVN, TOAD, Unix.
Confidential, VA
Application DBA
Responsibilities:
- Analysis and design using ER/studio
- Schema patch maintenance using Tortoise SVN
- Oracle PL/SQL development using PL/SQL Release 11.2.0.1.0 capabilities viz, Triggers, Stored procedures, Functions, Packages, Dynamic SQL and Bulk collect statement.
- Oracle Optimized SQL statements for the application and report
- Oracle SQL Tuning using
- Enhancement or existing application using Oracle PL/SQL code.
- Test data preparation
- Data Fixes
- Support App development
- Production support
- Analysis of Unix process monitoring for SQL, TKPROF for oracle performance tuning
Tools: Oracle Database11g Enterprise Edition Release 11.2.0.1.0 , PL/SQL Release 11.2.0.1.0 , ER/Studio model, Tortoise SVN, TOAD, Unix
Confidential, VA
Sr. Programmer
Responsibilities:
- Analysis and design of VB6.0 application enhancement for Crux application
- Enhancement or existing application using VB6.0 code and Oracle PL/SQL.
- Performance tuning of existing SQL and PL/SQL modules.
Tools: Oracle (9.X/10G) PL/SQL, SQL, TOAD, Crystal Reports, VB6.0.
Confidential, VA
On-site Coordinator
Responsibilities:
- Supported and monitored payment processing system using ad hoc PL/SQL and SQL queries.
- Designed User Manual Documentation for the Apps.
- Modified existing Crystal Reports and Oracle procedures for Bug Fixing and added new functionalities.
- Performance tuned existing SQL and PL/SQL modules.
- Automation Tools for Unix and Oracle processes using Ksh script and Windows scripting.
Tools: Oracle PL/SQL, SQL, Erwin, UNIX, KSH scripting, Crystal Reports, TOAD, Visio, VBA/WSC script.
Confidential, VA
Sr. Developer
Responsibilities:
- Maintenance, development, and bug fixing of Confidential Web based Application using ASP, ASP.NET,C# Oracle (PL/SQL)
- Modified existing Oracle procedures for Bug Fixing and added new functionalities.
Tools: Windows XP, Oracle PL/SQL and ASP.NET, C#, COM+, ASP, IIS, TOAD. Erwin
Confidential, VA
Oracle/Access/AB Initio Developer
Responsibilities:
- Set up and designed EUC Access database for the different Loan Categories viz. TDR, REO, Securities and other.
- Designed and developed Ab Initio graphs using ORACLE and Unix
- Extracted and Transformed Oracle Legacy systems Data Into Oracle server using PL/SQL and Ab Initio.
- Analyzed and wrote SQL queries based on the Requirement EUC computing.
- Created and generated the ADHOC queries using ORACLE and Access databases.
- Scheduled Jobs in Unix using JIL Scripts
Tools: Windows 2000, Unix, Oracle PL/SQL, Access 2000, SQL*Loader, VBS Scripts, Abinitio Graphs (ETL tool 2.x)), Unix Shell scripts, Access Reports, Erwin, Scheduler Autosys.
Confidential, VA
Sr. Developer
Responsibilities:
- Maintenance, development and Bug Fixing of (BOB) Building and tenant Application using ASP2.0/SQL Server 2000/T-SQL.
- Developed dynamic and static Web Reports using ASP2.0/T-SQL.
- Maintained and developed Billing System using ASP.NET (C#)/SQL Server 2000.
- Developed new ASP.NET C# front-ends.
- Maintained VB.NET application for Monthly usage billing data (Meter maid).
- Extracted and transformed Oracle Legacy systems ORACLE data into SQL Server using PL/SQL/T-SQL.
- Created and modified web based Crystal Report application using IIS and Crystal Report 8.5 and 10.0.
- Created Advanced Procedures and Functions using SQL Server T-SQL for ASP, ASP.NET & Crystal Reports.
- Troubleshot SQL Server procedures, Functions for the above Applications using T-SQL.
- Performance and Optimization Techniques in ASP.NET and SQL Server 2000.
- Database Re-Engineering for the existing modules using Erwin.
- Wrote WSC scripts for Extracting Legacy and External Data for Reporting.
- SOX compliance - CMR procedures.
Tools: Windows 2000, T-SQL, Unix, Oracle PL/SQL, Erwin SQL Server, ASP.NET, ASP 2.0, IIS and Crystal Reports 8.5/10 in WEB.WSC scripts, VB scripts, Java Scripts, JAVA & Apache Tomcat server.
Confidential, VA
Data Analyst
Responsibilities:
- Downloading of PMW data spreadsheet from Common Folder using using Documentum script from Access database.
- Extracting the Data from the downloaded worksheet to staging Table.
- Testing the existing module for the correctness of the system Data.
- Preparation of GUI using VB6.x for a Macros in Excel and Access/2002 for an additional functionality to the system.
- Testing and Remediation of the existing application
- Troubleshooting Database and Application.
Tools: Windows/2000Professional, VisualBasic 6.x, Excel Macros, Erwin, Access/2002, Oracle9i Enterprise Edition Release 9.2.0.4.0, Documentum.
Confidential, VA
Analyst
Responsibilities:
- Analysis and Design: Preparation of detailed design to explain the Functional, structural and GUI Requirement for each transaction in the original Excel file and how this is to be handled in the current system.
- ETL: Migrate Excel spreadsheet data into the Access Database staging Table.
- Development: Preparation of GUI using VB6.0 based on the requirement.
- Testing: Creating a test plan and data for the unit and integration Testing for the Back-end and GUI modules.
- Troubleshooting Database and Applications.
Tools: Windows NT, Visual Basic 6.0 (MSDAC 2.x ADO, ActiveX Control, Dll's etc.), Erwin, Access, Crystal Reports 9.0.
Confidential, MD
Analyst
Responsibilities:
- Design: Preparation of .NET Crystal Reports based on the user requirement.
- Development: Writing Web-Form to Generate the Reports. Writing Oracle Stored Procedures and SQL query for the Crystal Reports.
Tools: Windows XP, Microsoft Visual studio .NET 2003 (.NET Technology C#, VB, ADO.NET, Crystal Report), IIS Version: 5.1, Oracle PL/SQL (Stored Procedures & Dynamic), Erwin.
Confidential
Data Modeler
Responsibilities:
- Analysis and Design: Preparation of Data Model based on the User Requirement using ER/Studio
- Preparation of high Level and Low Level Document using Rational Tool.
- Preparation of Database Scripts using TOAD.
Tools: Rational, ER/Studio, Oracle 9i and Toad.
Confidential, PA
Analyst
Environment: .
Responsibilities:
- Design: Analysis of Existing system, Preparation of Design specification for the Reports Based on the user requirements and Translation of Design Specification to the Oracle Reports Data Model with the help of Erwin.
- Writing a Requirement Document for the New Reports Modules based on the user specifications.
- Creation of ASP Pages (PROVIDER INVOICE) using MS.ADO v.25 control and oracle8.0 as a backend. My role is to Design and develop an ASP/Oracle back-end package.
- Preparation of Oracle Stored procedures, Functions in PL/SQL based on the Reports Requirement.
- Development: The Performance tuning of all the Queries used in the Crystal Reports and Stored Procedures using proper Oracle Indexing and Performance Tuning techniques.
- Preparation of VB 6.0 forms, Segate Crystal Reports, Dll's etc.
- Creation of Complex Crystal Reports using Segate Crystal Reports 7.0 of various types viz. Standard Reports, Label Reports, SubReports, CrossTab Reports which uses a temporary table data populated from the stored procedures during execution.
- Integration of Report into the main module.
- Testing: Creating a test plan and data for the unit and integration Testing of Reports and stored procedures.
- Troubleshooting Database and Applications using iTAR and Metalink.
- Troubleshooting of Crystal report using Crystaldecision support link.
Tools: Windows NT, Oracle 8.x, PL/SQL 8.0.5 (Stored Procedures & Dynamic), Visual Basic 6.0, and Segate Crystal Report Professional Edition 7.0.Erwin3.5 and Active Server page (Classic ASP2.0), Erwin.
Confidential, LA
Analyst
Responsibilities:
- ETL: Setting up Staging Tables for data conversion Process system.
- Converting the Customer Data into Excel CSV File
- Analyzing the User Specification and Creating Control file for the data Upload through SQL*Loader.
- Preparation of Stored procedures in PL/SQL based on the Confidential Application to upload data from a staging Table.
- Development: Writing PL/SQL Stored procedures in Oracle 7.3.x for the PowerBuilder Reports.
- Creating a Power builder GUI for the Reports using Data window and writing scripts.
- Testing of converted data in Confidential Application.
Tools: Windows NT, Power builder, Oracle 7.3.x, PL/SQL (Stored Procedures & Dynamic), Erwin.
Confidential, VA
Analyst
Responsibilities:
- Analysis and Testing: Analysis of Front-end (Forms 4.5/Reports 2.5) & Back-end Code (PL/SQL) for impact assessment.
- Preparation of code change based on the module
- Testing of remedied code by changing the Clock to critical Y2K dates.
Tools: Sun Solaris, Oracle/Developer 2000 (Forms 4.5, Reports 2.5), PL/SQL (Stored Procedures & Dynamic), Pro*C, Windows-NT/95, Business Object, Erwin.