SUMMARY

• Senior Oracle PL/SQL Developer with 7 years of software development experience in IT industry involved in analysis, design, development, testing, implementation and maintenance of applications/databases in web and client/server technologies.”
• Expertise in Oracle 8i/9i/10g/11i, SQL, SQL/PLSQL, Forms 6i/10g, Reports 6i/10g.
• Over 7 years of experience with Oracle SQL, PL/SQL, Tables, Indexes, Views, Sequences, Stored Procedures, Functions, Packages and Database Triggers and Cursors.
• Worked on advanced concepts like collections, Object Types, and Dynamic SQL, Ref Cursors and Materialized Views.
• 6+ experience in TOAD, SQL Developer.
• 5+ years of developing and customizing reports using Oracle reports and Crystal Reports.
• Extensive Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing
• Experience in schema structure design and involved in estimation and optimization of data storage Experience in utilizing newer Oracle tools and methods like teh use of External Tables, merge statement, Pipelined functions and 10G features.
• Performance Tuning & Query Optimization of SQL statements.
• Experience in different phases of Software Development Life Cycle which include Analysis, Design, Development and Testing
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Experience in performance Tuning using SQL Trace, Explain Plan, Indexing, Partitioning and Hints.
• Functional knowledge in various modules like Manufacturing, Inventory.
• Successfully utilized performance enhancements features of Oracle to optimize teh batch processes.
• Experienced in environments requiring direct customer interaction during design specification, development, and product implementation phases.
• Great learning skills to adapt teh rapid changing technologies and implementing teh same at work.
• Strong Analytical, Inter - personnel, Problem-solving and Proven ability to work under pressure.
• Self-Motivated and able to work as individual and as a team.
• Experience in working under high stress environment to meet teh project deadlines.

TECHNICAL SKILLS

Oracle Products: SQL* Loader, PL/SQL, SQL* Plus, Oracle Forms 10g/9i, Reports 10g/9i, Enterprise Manager, Oracle 10g Application Server.

Databases: Oracle 11i/10g/9i/8i, MS Access, SQL Server

Languages: SQL, PL/SQL, JAVA, C, C++

Environment: UNIX, Windows XP/2000/NT, DOS

Reporting Tools: Crystal Reports, Report Designer.

Dimensional Data Modeling: Rational Rose, ERWIN

Servers: Weblogic, Tomcat, WebSphere.

Web: HTML, DHTML, FrontPage.

Tools: Enterprise Manager, TOAD, PL/SQL Developer, PL/SQL Loader, Business Objects XIR 3.1/XIR 2, Visual Source Safe, Clear Case.

Front-End Tools: MS office suite, Adobe PageMaker, Centura

PROFESSIONAL EXPERIENCE:

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Gathered user requirements to create technical specifications and designs.
• Loaded flat files data into staging tables and tan loaded to teh database tables.
• Used ETL loading techniques to load data from data warehouse to teh oracle database. Techniques. Also, validated and tested data after teh data loads.
• Analyzed existing logical data model (LDM) and made appropriate changes to make it compatible with business requirements.
• Expanded Physical Data Model (PDM) for teh OLTP application using ERwin.
• Wrote stored procedures to do data and also to validate as per teh business logic.
• Wrote PL/SQL blocks to generate dynamic SQL which can be used on production environment.
• Used Oracle advanced concepts like collections, Varrays, types with in types and pipe lined functions.
• Moved objects from one schema to another based on teh requirements.
• Extensively worked on teh high level production support issues (BTGs) and utilized PTM (Production turn over management).
• Also was responsible for initiating CAB (Change Advisory Board) meetings to acquiring higher management approvals.
• Strong understanding of teh principals of Data warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Worked with DBA to create teh physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for teh facts and dimensions.
• Extensively used HP-ALM tool for centralized change management and also to automate teh day to day development/testing process.
• Created UNIX shell scripts to automate batch data loads with Informatica team.
• Created spool files for higher management to assess teh script execution and validation in various environments.
• Utilized performance tuning techniques (Explain plan, TKProf, Hints, DBMS Profiler).
• Interacting with teh DBAs on a daily basis to deploy data clean up scripts and created DDLs, DMLs, triggers on teh database tables.
• Responsible for code enhancements, unit testing and deploying teh changes across various environments (Dev, test, UAT).

Confidential, OH

Oracle PL/SQL Developer

Responsibilities:

• Worked on implementing various PL/SQL procedures to track teh CCW Routes (Customer Care Workbench) information for SCRA loans. And also implemented procedures to calculate teh Subsidy/Prefund amounts for active SCRA loans.
• Created complex PL/SQL scripts using Bulk Collect operations for loading teh data from legacy systems into staging tables. Used Implicit/ Explicit Cursors and Collection Types in dis process.
• Worked on creating Validation scripts using PLSQL Procedures and Functions which validated Customer, Loan, and Property information in MSP (Mortgage Service Provider) and VLS (Vendor Lending System).
• Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.
• Worked on Normalization and De normalization techniques.
• Worked on scheduling Jobs using DBMS JOBS package for manually loading teh data required for reporting teh SCRA application.
• Created various procedures to track teh Subsidy/ Prefund calculations for SCRA Active Loan populations.
• Used Database Triggers for making history of insertion, updating, deletion and all kinds of Audit routines.
• Created SQL objects (PL/SQL Procedures, Functions) for measuring teh employee work performance on a daily basis.
• Modified teh existing PL/SQL Procedures to meet teh changes of EPIC 2.0. dis procedure calculated Incentive for teh Indexing group in Manila.
• Developed SQL*Loader control file according to teh mapping tables to populate teh custom load tables using teh extract file.
• Worked on implementing Collection Types in teh PL/SQL blocks.
• Used of EXPLAIN PLAN and HINTS to tune queries for better performance and also Extensive Usage of Indexes.
• Worked on Report builder 10g for creating new reports and also on report fixes and enhancements.
• Worked on Data Extract Process which is done on demand as per teh user requirements. Upon their specific request, data is retrieved from various systems using SQL/PLSQL coding and delivered in their requested format.

Confidential, NYFC

Oracle PL/SQL Developer

Responsibilities:

• Wrote PL/SQL procedures, packages, triggers in Oracle 9i/10g and Oracle Forms (Developer 10g / 9i) as required. Involved in creation of databases, moved databases by recreating control files, export/import, and complete backups. Created and maintained Oracle schema objects like Table spaces, Tables, Rollback segments, Indexes, Sequences and Synonyms.
• Design Logical and Physical data, define relationships, and implement business rules as constraints for normalization / demoralization of entities.
• Wrote SQL*Loader scripts to migrate teh data from teh text files, Spreadsheet etc. and populated teh intermediate tables.
• Developed and implemented concurrent process to load item details from external sources into inventory item tables and also created forms to view interface errors with details and correct teh data in teh interface table.
• Worked extensively on customizing existing forms appearance, validation logic, behavior and incorporating new functionalities to teh existing forms.
• Developed new forms by using Template.fmb.
• Customized and created various reports using Reports 6i and registered them under teh concurrent manager.
• Performance tuned teh PL/SQL stored procedures in Oracle 9i/10g.
• Design/Develop various technical components such as Discoverer EUL, Workbooks, Oracle reports, PLSQL and SQL Reports, workflows, etc. as well as participate in teh maintenance of existing reports.
• Used Qwest tools (Toad 8.0, SQL Navigator) for database monitoring and tuning.
• Designed and developed forms and reports for easy data updating dat increased data entry efficiency over teh existing system.
• Generated XML files for data transfer. Used XML parser to parse teh data.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon teh requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply teh data model changes.
• Interacted with users regarding teh proposed solution and design for customization and teh migration strategy.
• Customized and created various forms using Forms 6i in some Oracle Apps modules and registered and run under custom responsibilities.
• Registered teh automation scripts as concurrent programs and created a scheduling process dat invokes teh script periodically.
• Created business areas, custom views, and summary folders according to teh user’s requirements and modified existing reports by creating additional joins using Discoverer Admin 9i.
• Maintained user security and privileges at business area level. Periodic backups of EUL and Export, Import of Business Areas from one instance to another.
• Designed and developed reports by using lexical parameters in before, after parameters and before report triggers.

Confidential, FL

Oracle PL/SQL Developer

Responsibilities:

• Extensively worked on Performance tuning by using Explain plans and various hints.
• Worked on table partitioning (Range and List) and deploying local indexing on portioned tables.
• Used Oracle 9i features such as merge for various transformations.
• Used stored procedures in Oracle for retrieving teh data from teh database for solving complex queries.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of teh application.
• Created Stored Procedures, functions and Packages in Oracle 9i using SQL and PL/SQL for teh Audit Trail using Oracle 9i as backend.
• Performed teh uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning teh PL/SQL code, tuning queries, optimization for teh Oracle database.
• Created new reports and also customized using Reports .
• Ensured dat weekend data loads, end-of-month & end-of-quarter processing ran successfully and completely, transparent to user community.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Developed custom forms using standard AOL components like template forms and libraries. Used descriptive flex fields extensively to capture additional information in standard as well as customized forms.
• Creating Test scripts for teh generated final Reports.
• Involved in data migration from SQL Server to Oracle 9i.
• Good working knowledge of PL/SQL.
• Attended meetings and review to discuss current issues and processes to tackle issues.

Confidential, Houston, TX

PL/SQL Developer

Responsibilities:

• Wrote PL/SQL procedures, packages, triggers and functions to enable plug and play of multiple data sources.
• Developed PL/SQL scripts to migrate data into repository database.
• Wrote complex queries to retrieve data from teh database based on User requirements.
• Created and worked on nested tables and customized data by adding calculations, summaries and functions.
• Data Modeler with strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Used Explain Plan, TKPROF to gather statistics along with teh analyzing command for performance tuning.
• Transferred Data from teh ORACLE database to teh target tables in data warehouse environment by creating mappings with teh help of Informatica.
• Managed and resolved design issues during development stage.
• Performed UNIT Test and Integration Test.
• Directly interacted with teh end user and responsible for User Acceptance Test.

Confidential

PL/SQL Developer

Responsibilities:

• Understanding teh functional process and technical feasibility.
• Data modeling using Rational Rose.
• Making teh front- end screens using Centura.
• Writing teh backend procedure using PL/SQL for teh complete transaction.
• Validating teh data.
• Testing all possible cases.
• Documentation of teh complete process.