PROFESSIONAL SUMMARY:

• 7 years of application development experience. Strong in Oracle database: architecting database solution and design, data modeling, data analysis and developing tables, packages, stored procedures, functions, views, trigger, performance and tuning.
• Strong experience in systems Analysis, design and development of complex software systems in Finance, Health, Manufacturing and al sectors. Expertise in Oracle 10g/11g, 9i, 8i databases, cluster databases, SQL - Server, PL/SQL, UNIX Shell Scripting, OEM Oracle Enterprise Manager/10g/11gGrid Controller.
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 8i/9i/10g/11g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. Detailed depth Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle. Excellent team player and proven track record working in various team sizes performing cross-functional roles.
• Good Knowledge of Data integration and migration using SQL* Loader.
• Developed Client-Server applications using front-end tools like Oracle Developer 2000 - Forms 5.0/6i, Oracle Reports 2.5/6i, SQL*Loader, Data Pump and SQL*Navigator. Involved in designing numerous Oracle Forms and Reports by interacting directly wif End Users and Business Analyst.
• Extensive experience in Database query tuning, Performance tuning (Explain Plan and TKPROF utility) of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• 2 + Year of Data Modeling & Data Analysis experience using Dimensional Data Modeling and Relational Data Modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
• Strong knowledge in Oracle cursor management and exception handling.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions. Extensively worked on Data Extraction, Transformation, and Loading wif RDBMS, Flat files.
• Superior communication, presentation, analytical and problem solving skill. Work well wif all levels of business.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g (RAC/OPS),SQL, DB2

Development Tools: TOAD, DB2, SQL Developer 3.0, OEM/EM 10g/11g, SQL*Plus, SQL* Loader, Oracle Forms and Reports 10g/11g/9i/6i, OLAP, OLTP, EXPORT/IMPORT, MS office 2007, 2010

Data Modeling: Dimensional Data Modeling, Star Join SchemaModeling, Snow Flake

Operating Systems: Windows NT/2000/XP, Sun Solaris, Linux, UNIX, HPUX

Database concepts: SQL, PL/SQL

System Management Tools: RMAN, ASM

Protocols: TCP/IP, HTTP

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Oracle PL/SQL Developer

Responsibilities:

• Developed various PL/SQL stored procedures and functions
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, DBMS MVIEW and UTL FILE.
• Develop logical and physical data models dat capture current state/future state data elements and data flows using Erwin.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Utilized SQL*Loader to load flat files database tables.
• Involved in Writing, debugging and optimizing PL/SQL code.
• Involved in migrating database from Oracle 9i to 10g/11gdatabase.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database
• Involved in the ETL process of developing new tables from the existing views and materialized views.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Developed and implemented various migration scripts for various schema objects migration.
• Worked on complex queries PL/SQL packages, functions, stored procedures, triggers, views
• Performing Unit, Integration and System testing, and setting up UAT for the project modules.
• Used EXPLAIN PLAN, TKPROF to tune SQL queries.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Worked closely wif end-users and team members to understand business requirements dat drive the analysis.
• Participated in Peercode reviews and verifying coding standards.
• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.

Environment: Oracle 10g/11g, SQL, PLSQL, SQL*Loader, UNIX, TOAD.

Confidential, Milwaukee, WI

Oracle PL/SQL Developer

Responsibilities:

• Involved in the maintenance and enhancement of the application
• Maintained good rapport wif Business Analyst & Business Users to identify information needs as per business requirements
• Document the business process flows
• Schedule meetings and present technical issues to business users and developers.
• Performed discussions wif data modeler to update the data model for new requirements
• Extensively developed complex PL/SQL packages for Invoice Processing.
• Designed/developed tables, views, various SQL queries, stored procedures, functions.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Extensively worked wif Dynamic SQL, Composite data types & Global Temporary Tables
• Used PL/SQL tables, array structures as a part of oracle collections.
• Involved in partitioning of very large tables. Used list and range partitioning.
• Associated wif DBA in monitoring the performance related issues using Explain plan, SQL Trace and TKPROF utility
• Create & maintained box jobs using Shell Scripts.
• Developed scenarios for Unit, Integration testing to ensure dat all the components work correctly when integrated.
• Communicate issues and progress to project manager.
• Solving day-to-day problems, giving support to the users.
• Involved in Production Support and troubleshooting data quality and integrity issues

Environment: Oracle 10g, PL/SQL, HP UNIX, UNIX shell scripting, COBOL, Maestro, VB

Confidential, Waukegan, IL

Oracle PL/SQL Developer

Responsibilities:

• Developing highly complex applications using Oracle 10g/11gdatabase as backend wif expertise in design and development of Oracle PL/SQL packages and procedures.
• Responsible for analyzing, Design and developing the code logic in Oracle Forms and also worked on Oracle databases which is to develop and maintain for the real production environments.
• Developed Packages and customized functions and Triggers based upon the business logics.
• Participated in system analysis and data modeling, which included creating Tables, Views, Indexes, Synonyms, Triggers, Functions, Procedures, Cursors and Packages.
• Utilized SQL*Loader to load flat files into database tables.
• Used PL/SQL developing to load data from the source table to the target table based on the business logic.
• Developed conversion programs to bring Legacy details into Oracle table using SQL*Loader, PL/SQL Package and populated data into base tables.
• Created PL/SQL blocks using Cursors, REF Cursors, Collections - Nested Table, various Complex Triggers.
• Designed and developed Web-enabled Oracle Forms & Reports.
• Worked on Forms Triggers, Alerts, Data Blocks, LOVs, Parameters and Program Units by using PL/SQL procedures and functions.
• Analyzed data, designed and developed Oracle forms, layout, report triggers, parameter form, data models
• Developed complex triggers in reports before/after for validation of user input on the application system.
• Developed UNIX shell scripts to provide a user interface to Oracle Forms and Reports.
• Worked on Oracle Web Apache Server for configure of upload and download wif the required Oracle forms refers to a class of systems dat facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
• Tested the Forms, debugged and fixed it after the testing
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Responsible for performance tuning activities in oracle.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Used Materialized Views in order to improve the performance.
• Proposed and coded enhancements on Oracle PL/SQL.
• Involved in designing numerous Oracle Forms and Reports by interacting directly wif End Users and Business Analyst.
• Worked and developed different forms and reports.

Environment: UNIX(RHEL, Solaris), Oracle Database 10g/11g, TOAD,PL/SQL, Oracle Developer Suite 10g/11g, PUTTY, HP Quality Center

Confidential

Junior SQL Developer

Responsibilities:

• Writing complex SQL for the Back End Development requirements.
• Complex SQL scripting using advanced functions.
• Core knowledge and experience on SQL for SQL* Reports.
• Top development skills include using Oracle PL/SQL to write Stored Procedures, Packages, andTriggers.
• Usage of various Built-In PL/SQL packages based on requirements.
• Good knowledge on Wrappers, Composite Data Types, Cursors and REF-Cursors.
• Writing complicated Oracle Forms and creation of customized Oracle Reports.
• Prepared Test Cases based on Test Plan for Unit Testing, System Testing, End-to-End Testing and UAT support Testing.
• Used Quality Center to report bugs.

Environment: UNIX, Shell Scripting, Oracle 8i, PL/SQL, Oracle Reports, Windows XP.