SUMMARY

• 8 plus years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System(RDBMS).
• Extensive experience in Data Transformations, Data Loading, Database Modeling and Performance Tuning.
• Strong knowledge in front end development using oracle forms/reports6i/9i/10g.
• Experience in different phases of Oracle Application implementation life cycle including Technical Design, Data Conversion, OracleForms development, Oraclereport development, Unit Testing,, Integration Testing, End User Training, Production Support.
• Designed and developed over a hundred OracleReports and Forms for both Oracle Applications and Custom Development.
• Strong Knowledge on oracle architecture and database design.
• Developed mapping to load data from source to target using owb.
• Have a strong knowledge on data ware housing concepts and implementation using oracle ware housing.
• Strong knowledge on Star schema, snowflake schema
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Excellent conceptual knowledge of Oracle 9i/10g, PL/SQL.
• Hands on experience in design, development of end user screens and reports using Oracle Developer/2000 (Forms, Reports), Forms and Reports 9i, Oracle Developer Suite10g.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in database programming using SQL and PL/SQL.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Scheduled complex cron jobs on UNIX platform using crontab format
• Experience in Dynamic SQL, PL/SQL Collections and Exception handling.
• Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
• 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 stored at the OS level.
• Experience in retrieving data from Personal Data Files, and Stored Procedures.
• Experience in troubleshooting various aspects of the client/server architecture in both UNIX and Oracle setting.
• Identified several SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), explain plan, auto trace.
• Identified if any programs or any updates in the table or any deletion by setting up the DBMS JOB package.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, TKPROF and SQL*Navigator v.4.5.
• Participated in collecting the requirements, analyzing the System Requirements.
• Experience with Star SchemaModeling and knowledge of Snowflake Dimensional modeling.
• Experience with Data Modeling using ERWIN 4.0/3.5.2.
• Experience in SQLServer, MSAccess, SQL, PL/SQL, SQL Plus, Toad, and MSSQLServer, Query Analyzer. Able to write SQL and PL/SQL queries in order to optimize report development.
• Proficient in Microsoft Office Suite (to include PowerPoint, Visio, Project, SharePoint and Access).
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Excellent planning, analytical, written Communication, ability to work under pressure and Interpersonal skills.
• Ability to explain technical concepts and communicate with users and system administrators at all levels. Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Extensive experience on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/ 8i/8.x/7.3,DB2,teradata v2r5

GUI’S: Developer/2000(Forms 10g/9i/6i/5.0/4.5& Reports 10g/9i/6i/3.0/2.5),owb

LANGUAGES: SQL, PL/SQL, C, HTML, XML, java script

ADMINISTRATION: SQL*Loader, Export, Import.

Tools: TOAD,SQL*PLUS, SQL*NAVIGATOR, SQL DEVELOPER, Putty, VI Editor, forms Builder, Reports Builder, Procedure Builder, Graphics Builder, Import & Export utility, Erwin

OPERATING SYSTEM: Windows7/ NT/2000/98/95, DOS 6.0/3.0, UNIX,SUN SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, Beaverton, Oregon

Oracle Pl/Sql Developer/Support/Production Engineer

Responsibilities:

• Develop Packages, Stored Procedures/Functions to develop Atlas Database mirroring the existing ATG System
• Write Procedures to classify the incoming orders based on their regions and place them in different SAP system
• Perform root cause analysis for and test failure and co - ordinate with different teams to resolve the issue
• Create and Maintain Autosys jobs in both production and development Environments
• Create Views based on multiple tables and perform data changes on tables for cancelled and modified orders
• Create multiple jobs in Autosys Environment co-coordinating with offshore team and other technical teams to create a QA Environment to perform testing
• Working on issues like Defective Images, discrepancy between product, price, Style-colors with most of source systems like Flex, CDB and CDM, Goal, Scean7 etc for Confidential .net.
• Create UNIX Shell scripts and SQL queries to get order report data from Atlas and process them into reports that is used by other systems like SAP and JCAPS for maintenance
• Wrote Test scripts to execute Performance testing to check the low of order between the system and the databases and performance of Confidential .net.
• Customized forms by writing block level triggers and item level triggers using OracleForms.
• Designed and developed over a hundred OracleReports and Forms for both Oracle Applications and Custom Development.
• Developed screens and reports using OracleForms/Reports 10g. Also developed reports using Pro*C and PL/SQL.
• Conversion OracleForms and Reports 10g to OracleForms and Reports 11g.
• Involved in creatingLogical Model and Physical Models using ERWIN.
• PreparedDefectmetricsfor the project by Querying Atlas database usingSQL and Unix shell scripting
• Took initiative in designing Coupon code addition to their existing system and to add unique coupons codes to their XML and send it to the Database
• Develop Unix Shell scripts to monitor jobs and run the stored procedures/functions
• Help the various testing teams by tracking the order details through databases, SAP and Idocs that are created.
• Created MSAccess programs with login security functionality to allow user to interact with all databases.
• Structured and optimized code in stored procedures, triggers andMicrosoftAccess for processing data.
• Involved in preparation ofTest planandTest scriptswith the help of requirement and design document.
• Co-ordinate between different teams to highlight the defects and defect resolution
• Provided Support coverage for the release and performed root cause analysis during the warranty phase
• Worked with different teams to set up the development and test Autosys environments
• Created Work Instruction Manual listing the possible failures and Recovery steps for each and every new job added as part of the project
• Involved in the preparation ofTest planandTest scriptswith the help of requirement and design document
• Builtcustomer driven test scenariosbased on customer issues raised throughQuality Center
• Provided Testing and Support for their Fall Release by providing support to resolve the severity 1 incidents
• Created and Monitored the new jobs in Production that were added part of the Release
• Resolved all the high TPRs that were raised for the projects that I was involved in
• Assisted in building UAT Test Scripts and provided support to the end-users when they performed UAT
• Provided guidance to the external team in performing testing on the components that I own
• Helped design and test Wrapper Scripts to send mails to users the reports generated through the Databases
• Created Template to test the generic steps involved in addition of new jobs to the existing system.

Environment: Oracle 10g/9i, SQL, PL/SQL, SQL*Loader, UNIX Shell script, MS Access, TOAD, Oracle Forms 10g, Reports10g, Oracle Designer,UNIX, JAVA, Windows XP/2000.

Confidential, Richmond, VA

Oracle Pl/Sql Developer /Data Analyst

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing and project coordination
• Created process force and deployed into run time depository using ware house builder
• Involved in logical modeling and physical modeling of application.
• Used multiple operators (union, routor) for loading data using owb.
• Having strong knowledge in creating and maintaining the owb
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in developing CRONTAB to schedule the information of cron entries.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas. worked with bulk collect to Implement the performance of multi row queries
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems using PL/SQL and SQL*Loader.
• Remediate Oracle application Custom object components like Forms, report and Concurrent Program (PLSQL code).
• Involved in development of OracleForms/Reports, New Screen designs, Modifications.
• Upgraded to Forms 10g, Reports 10g, maintained and troubleshoot OracleForms and Reports.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Worked on admin and user editions of discoverer 10g and used AIM (application implementation methodology) in documenting the development tasks.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Generated various analytical reports using MicrosoftAccess.
• 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.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.

Confidential, Flint, MI

Oracle Pl/Sql Developer/ Data Analyst

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created SQL*Loader control files for loading the data from flat files to staging area tables.
• Developed SQL scripts to create database objects liketables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER, etc.
• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.

Confidential, Chicago, IL

Oracle Pl/Sql Developer/ Data Analyst

Responsibilities:

• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed and modified procedures,functions, triggers, forms, and reportsanddeployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i.

Confidential

Oracle Pl/Sql Developer

Responsibilities:

• Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader - for different cases)
• Explain Plan, TKPROF was used for checking the performance of queries
• Modified and updated existing custom forms to adapt to new database schema
• Involved in creation and updates of several SQL packages and Procedures
• Created SQL scripts for conversion of legacy data (including validations) and then load it into the tables
• Developed SQL*Loader programs &PL/SQL scripts to load legacy data into Oracle Apps.
• Developed reports using Reports 6i.
• Developed PL/SQL programs for various modules to validate data while importing into oracle system.
• Participated in database development like creating PL/SQL triggers, packages, procedures function.
• Handling errors using Exceptions.

Environment: ORACLE 7.x, Reports 6i, PL/SQL, SQL Loader, SQL.