SUMMARY

• Over 6 years of programming experience as Oracle PL/SQL Developer, wif an in - depth noledge and exposure to different types of applications and architectures which includes web-based and client based application development projects in different domains
• Excellent noledge of software development life cycle(SDLC)
• Proficient working in Oracle 11g/10g/9i/8i databases using SQL and PL/SQL(Stored Procedures, Functions, Packages and Triggers)
• Load data into Oracle tables using SQL*Loader
• Extensively used navigational tools like TOAD, SQL Developer, and Rapid SQL
• Experience in creating cursors, composite data types, collections, and exception handling
• Expertise in tuning of Procedures, Packages, and SQL
• Experience in dimensional modeling to design star schema databases
• Developed complex database objects like Stored Procedures, Packages, Triggers, Functions, Ref cursors using SQL and PL/SQL
• Extensive noledge and work experience in System Analysis, Design, and Development of database applications in Client/Server applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, SQL*Loader
• Strong noledge of Extraction Transformation and Loading(ETL)
• Solid experience in writing and debugging and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, and UNIX shell scripts
• Expertise in developing SQL,PL/SQL scripts in Oracle distribution environment
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules
• Created Cursors, Collections, and database triggers for maintaining complex integrity constraints and implementing teh complex business rules
• Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, and file archiving
• Used bulk binding techniques like BULK COLLECTION and FOR ALL to improve performance
• Excellent in analytical, Problem solving, and communicating TEMPeffectively wif other members or teh end-user to meet their needs at all levels. Ability to adopt to any situation and interact TEMPeffectively wif other members of business engineering, quality assurance and other teams involved wif teh System Development Life Cycle.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8i, MY SQL, DB2, MS ACCESS

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

Tools: TOAD, SQL Developer, Rapid SQL, Oracle Enterprise Manager, SQL*Plus, VISIO 2010, SQL*Loader, Open Office, MS Office, OBIEE, OWB

Internet Technologies: HTML, Vb.Net, Java Script, XML, Oracle Application Server, CSS, DHTML

Scripting: Unix Shell Scripting, Java Scripting

Operating Systems: UNIX, Windows 7/VISTA/XP/2000/98, MS DOC, MAC

PROFESSIONAL EXPERIENCE

Confidential, Buffalo Grove, IL

PL/SQL Developer

Responsibilities:

• Involved analysis, design, coding, and implementation
• Involved in creation of Conceptual Modeling covering all teh business requirements
• Created complex queries using SQL and PL/SQL to summarize data which are used as views on which reports are based
• Designed and developed scripts to create table, views, indexes, and sequence
• Created or Modified Sequel Script(.sql file) to point teh current source
• Worked on SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects, and hierarchies
• Used advanced features of PL/SQL like collections, nested table, array, and Dynamic SQL
• Involved in uploading of data from flat files into databases and validated teh data wif PL/SQL procedures
• Created various SQL and PL/SQL scripts for verification of teh required functionalities
• Used SQL hints and Indexes as needed to improve SQL performance and used advanced BULK techniques (FOR ALL, BULK COLLECT) to retrieve and insert teh data into destination tables
• Worked wif BULK Collections for BULK Load processing
• Extensively used teh advanced features for PL/SQL like Records, Tables, Object types and Dynamic SQL
• Wrote many simple and complex ad-hoc reports using SQL*Plus and TOAD for teh business users
• Transformed complex business rules to Oracle PL/SQL
• Developed data conversion procedures in PL/SQL. Involved in maintain batch processing PL/SQL procedures for data extraction for feed creation
• Created Indexes for faster retrieval of teh customer information and enhance teh database performance
• Performed SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE
• Developed ETL procedures and data conversion scripts using Pre-Stage, Stage, Pre-Target and Target tables
• Automated data loading, extraction, report generation using UNIX Shell scripting
• Created programming code using advanced concepts of Records, and Collections
• Created Error Handling to handle run-time errors in teh PL/SQL code
• Created test scripts documentation for all teh procedures me created
• Involved in teh Error Diagnosis, developing test plans to conduct teh Unit and Integration testing

Environment: Windows 7/XP, Oracle 11g,10g, PL/SQL, UNIX shell scripting, SQL*Plus, TOAD, SQL Navigator

Confidential, New York, NY

Pl/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements, creating detailed documentation HLD and TDD which includes all business requirements and technical specifications
• Developed complex Oracle SQL queries wif complexity using Inner/Outer joins, Union All, Intersect, and Minus set operators
• Involved in teh creation of Oracle Tables, Table Partitions, and Indexes
• Developed Stored Procedures, Functions, Packages for Financial system
• Setup, tested and implemented new descriptive flex fields in Oracle Financials
• Used databases triggers and PL/SQL for development of system
• Extensively used PL/SQL to write Cursors for acquiring information to be used in calculation written inStored Procedures
• Handled PL/SQL compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to system events through triggers
• Created Shell scripts which act as wrapper for various tasks like for executing SQL*Loader command lines, for refreshing teh materialized views and for updating teh face and teh Dimension tables
• Worked on projects involving gap and map analysis, design and customization as per teh business rules and worked on custom applications development
• Involved in Tuning Database and Application performance using EXPLAIN PLAN, TKPROF resolving lock contentions, indentifying and killing sessions
• Wrote shell scripts for calling functions to automate teh loading and extractions process from legacy system
• Created records, tables, collections(nested tables and arrays) for improving query performance by reducing context switching
• Performed data loading using Data Loader to teh data into staging tables
• Created PL/SQL procedures in order to dump teh data from staging tables to base tables
• Experience in using Dynamic SQL, BULK COLLECT, REF Cursors and VARRAYS
• Used Oracle supplied packages such as UTL FILE, DBMS JOB, DBMS SQL and DBMS ALERT
• Used various SQL profiler templates for tracking execution time of TSQL statements
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints
• TOAD, SQL Developer tools were used to develop programs and executing teh queries

Environment: Windows 7/XP, Oracle database 11g/10g, UNIX, SQL*Loader, SQL Navigator, Shell Scripting and TOAD

Confidential, Chicago, Illinois

PL/SQL Developer

Responsibilities:

• Created custom Triggers, Stored Procedures, Packages, and SQL scripts
• Involved in uploading of teh data from flat files into databases and validated teh data wif PL/SQL Procedures
• Developed control files for SQL*LOADER and PL/SQL programs for loading and validation of teh data into teh database
• Developed complex SQL queries for data retrieval from various database objects including tables and views
• Developed various complex Stored Procedures, Packages, Interfaces and Triggers in PL/SQL
• Tuned complex Stored Procedures for faster execution and development of database structures, according to teh requirements
• Developed SQL and PL/SQL scripts to transfer across teh schemas and databases tables
• Used principals of Normalization to improve teh performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, Transform, Cleansing, and Loading of data from source to target data structures
• Written SQL queries for data validation, extraction, and loading
• Worked on Inner/Outer joins, Loops, Indexes, Materialized views and Normal views.
• Development for enhancements using technologies like PL/SQL, UNIX. Configuration Management of all teh files and process documentation
• Involved in Shell scripts to automate teh loading, balancing, and extraction process
• Check teh functionality of data in teh front-end whether it is displaying properly
• Documented teh whole process flow, PL/SQL packages, Log files, locations and descriptions, log tables and possible error messages, process codes, and descriptions

Environment: Windows XP, PL/SQL, Oracle 10g, SQL*LOADER, ETL tools, and UNIX

Confidential 

PL/SQL Developer

Responsibilities:

• Primary responsibilities include gathering business requirements, designing teh functional and technical specifications
• Developed different reports(pivots, charts, tabular) using global and local filters. Created SQL scripts for conversation of legacy data(including validations) and tan load it into tables
• Involved in Logical and Physical database design and Star Schema design
• Developed SQL*Loader programs for various modules to validate while importing into Oracle system
• Participated in database development like creating PL/SQL Triggers, Packages, Procedures and Functions
• Developed reports using Reports 6i
• Involved in Performance Tuning of teh application using EXPLAIN PLAN, Hints and TKPROF
• Tuned SQL queries to enhance performance, using teh method Explain Plan at backend and in TOAD
• Developed functions and procedures for different data load modules
• Generated PL/SQL scripts to notify process failure/success
• Developed SQL*Loader programs and PL/SQL scripts to load legacy data into Oracle Apps
• Created stored procedures, packages, functions and triggers using SQL and PL/SQL
• Involved in developing packages for implementing business logic through procedures and functions
• Creating and populating table fields by migrating data from different databases
• Did Relational Data modeling, and created Data Dictionary
• Created external tables to handle huge volumes of data which is not used frequently
• Produced scripts to cleanse source data, ETL process data wif business rules, and built re-usable mappings
• Involved in PL/SQL code review and modification for teh development of new requirements
• Check teh functionalities of data in teh front-end whether it is displaying properly or not
• Knowledge in Normalization, data transfer, documentation, preventive maintenance, code review, automation, stored procedures, and triggers etc.

Environment: Oracle 9i,10g, PL/SQL, TOAD, Windows 2000 server, UNIX, SQL LOADER, TOAD, Reports 6i, and Windows XP