BACKGROUND SUMMARY

• More than 10 years of experience in the software industry in Oracle Design, Development, Data Warehouse, Oracle Retail RMS12, ReIM 12, Allocation,Documentation, Implementation and Coding.
• PL/SQL, TOAD, Windows 2000,XP, Unix (AIX, Solaris, Linux), Oracle 7.3,8,8i/9i/10g/11i
• Sql Loader, IMP, EXP, Pro C, Perl, Cron jobs, CA workload, Pl/Sql developer
• Oracle Forms 4.5/5/6i/9i/10g
• Oracle Reports 2.5/3/6i/9i/10g
• Oracle Retail Merchandising system 12.0, Retek 6.6
• Oracle Retail Invoice Matching
• Around 10 years of IT Professional experience as Tech Lead / Application Analyst / Developer in
• Internet and Client/Server applications using Oracle Database (8.8i and 9i), Oracle 9iAS, Oracle
• Developer/2000
• (Forms 6i, Reports 6i/9i), Discoverer 10g, Oracle Warehouse Builder 10g, PL/SQL, SQL.
• Extensively worked with developing reports using Oracle Report 6.0/6i/9i/10g.
• Developed Data Warehouse using Oracle Data warehouse builder.
• Proven skills in SQL tuning and enhancing application performances.
• Proficient in server side programming like Procedures, Functions, Database Triggers, Packages using
• PL/SQL and SQL.
• Worked extensively with SQL Loader using control files for data warehousing and data loading into
• Oracle database tables.
• Proficient in Tuning SQL using Explain plan, SQL*Trace and Autotrace utility.
• Experience in using Oracle Utility like Export, Import and SQL*Loader
• Experience in all phases of Software Development Life Cycle (SDLC) like Requirement Capturing, Data
• Modeling, Data cleansing and Designing, Developing, Testing, Quality Assurance, ImplementingDocumenting and User Training for various business applications.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Oracle Retail RMS/Allocation/ReIM Apps Developer

Environment: PL/SQL; Pro C, Perl, SQL; SQL*Plus; Oracle 10g; Oracle Forms 6i/10g; BI Publisher; 10gAS; Oracle Designer 10g; AIX, Windows XP, TOAD; Oracle Reports 6i/10g; Oracle Jdeveloper 10g, Oracle Developer, Oracle RMS12, Oracle ReIM 12, Oracle Retail Allocation, RDF, Data modeling, Data cleansing.,SVN

Responsibilities:

• Development, Maintenance and Production Support of Customised Costing Solution application.
• Production support and maintenance of ReIM batches.
• Managing Development/Design and Support for customised Costing Solution application with offshore team.
• Support for Custom Replenishment application(ASR) with offshore team.
• Modified custom RAC rules reports.
• Extensively used Custom PO upload module to upload PO’s using Excel files.
• Extensively used Custom Order Mass update module.
• Customized Allocation module to push orders into Custom Replenishment application(ASR).
• Customized base forms to enforce user access/roles.
• Extensively used RIB packages to create/maintain ITEMS, Supplier and cost changes from External

Confidential Richardson, TX

Oracle PL/SQL and Reports Developer

Environment: Oracle 10G, PL/SQL, SQL*PLUS, PL/SQL Developer, Oracle Reports Builder, Javascript, Shell script, Test Director, Share Point,CVS.

Responsibilities:

• Designed and developed stored procedures in pl/sql to enqueue and dequeue the transaction messages
• Implemented the rules that are to identify a transaction as a Confidential, invoice and payments
• Implemented the identification of duplicate transactions and exceptioned transactions and applying special events processing
• Maintenance of the reports in Confidential .
• Performance tuning the reports.
• Testing(Unit testing and System Testing)
• Wrote shell scripts to call pl/sql stored procedures and some file operations searching patterns

Confidential, Richardson, TX

Oracle PL/SQL and Reports Developer

Environment: Oracle 11i, PL/SQL, SQL*PLUS, PL/SQL Developer, Oracle Reports Builder, Java, Test Director, Share Point,CVS

Responsibilities:

• Developed stored procedures in pl/sql to enqueue and dequeue the transaction messages,
• Implemented the rules that include bucketing rules and other rules to parse the transaction messages.
• Implemented the identification of duplicate transactions and exceptioned transactions and applying special events processing.
• Maintenance of the reports in Confidential,
• Wrote shell scripts to call pl/sql stored procedures and some file operations searching patterns,

Confidential, Dallas, TX

Oracle PL/SQL and Reports Developer

Environment: Oracle 10G, PL/SQL, SQL*PLUS, PL/SQL Developer, shell script, dot net, Reports Builder, sql server, UNIX, putty., Test Director, Share Point, CVS

Responsibilities:

• Involved in the data analysis.
• Involved with the Analysis and Design team to arrive at proof of concepts.
• Involved in the Database Design for the new tables.
• Worked on Advanced Queing for messaging from sql server to oracle
• Involved in fixing the production issues.
• Designed and developed PL/SQL packages, procedures and functions, triggers to implement this new logic.
• Wrote shell scripts to call pl/sql stored procedures and Java modules.
• Have written SQL statements for the reports.
• Analyzed the current reports and modified the SQL statements for the changes in reports.

Confidential, Dallas, TX

Oracle PL/SQL Developer

Environment: Oracle 9I, PL/SQL, SQL*PLUS, PL/SQL Developer, TOAD,shell script, unix, Test Director,ERWIN,CVS

Responsibilities:

• Developed PL/SQL packages, procedures and functions to implement ranking.
• Involved in the Database design for the creation of new tables.
• Worked on performance tuning as the subscribers are growing.
• Production support.
• Fixing the issues then and there.
• Maintain the code for any new changes.
• Changed the SQL statements behind the crystal reports.
• Wrote shell scripts to call pl/sql stored procedures and Java modules.

Confidential, Dallas, TX

Oracle PL/SQL/ Reports Developer

Environment: Windows XP professional, UNIX, PL/SQL, Oracle 10G, SQL*PLUS, PL/SQL, PL/SQL Developer, putty, Reports Builder, Test Director,ERWIN,CVS

Responsibilities:

• Designed and developed PL/SQL packages, procedures and functions, triggers to implement business logic.
• Used External tables to read the data from flat files.
• Created many complex queries for providing the solution.
• Created a knowledge base of support cases for future references.
• Used Reports builder for verifying the already developed reports with the new data set.

Confidential

Oracle Pl/SQL ETL Developer

Environment: Windows 2000, NT 4.0, UNIX, PERL DBI, UNIX shell scripts, JAVA, SQL* PLUSPL/SQL, SQL*LOADER, Oracle Express Language, Oracle Express Administrator, OFA, TOAD.

Responsibilities:

• Responsible for ETL(Extraction, Transformation and Loading).
• Developed Confidential System (extract programs in Oracle Express language to extract data from OFA).
• Developed extract programs in PERL to get data from UNIX servers, Load it in Oracle database which is used by the JAVA front end) and implementation of the same in Production.
• Generating PL/SQL stored procedures and functions, to analyze the data, and identify format and value discrepancies, as part of a team of two.
• Wrote shell scripts to call the pl/sql stored procedures and DML statements and some file operations that include the UNIX commands to search for patterns.
• Responsible for execution and monitoring of shell scripts.

Confidential

ETL Developer

Environment: Windows 2000 professional, UNIX, PL/SQL, Oracle 9i, SQL*PLUS, PL/SQL,TOAD, SQL * Loader, PERL, Business Objects, COBOL, JCL.

Responsibilities:

• Developed Confidential Reporting System (data extract programs in PERL to get data from Oracle database).
• Generating PL/SQL stored procedures and functions, to analyze the data, and identify format and value discrepancies, as part of a team of two.
• Wrote shell scripts to call pl/sql stored procedures and DMLs and some file operations that include the UNIX commands to search for patterns.
• Running and monitoring shell scripts.
• Feature Enhancement and Production Support(24X7).
• Maintenance and performance tuning in the LOAD module.