Rajasekar Thiruvengadam

**** ***** ****

Carrollton, TX 75007

Phone no: 469-***-****

Email: ansqtz@r.postjobfree.com

OBJECTIVE

Oracle Developer/Oracle Tech Lead

BACKGROUND SUMMARY

More than 15 years of experience in the software industry in Oracle Design, Development and Database Administration, Data Warehouse, Oracle Retail RMS12, RPM12 Design/Development, Documentation, Implementation and Coding.

• Oracle 7.3,8,8i/9i/10g

• Oracle Forms 4.5/5/6i/9i/10g

• Oracle Reports 2.5/3/6i/9i/10g

• Crystal Reports XI

• PL/SQL, TOAD, Windows 2000,XP,Vista, Unix (AIX, Solaris, Linux)

• Sql Loader, IMP, EXP, Pro C, Perl, Cronjobs, Pl/Sql developer

• MQ Series, ETL Data stage, Informatica

• Oracle Retail Merchandising system 12.0, Retek 6.6

• Oracle Retail Price Management system 12.0

• Around 11 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, Java Application Programming, Java Applet, Java Servlet, JDBC and JSP on different platforms like SUN Solaris, Unix, Windows NT/2000/98/95.

• Extensively worked with developing reports using Oracle Report 6.0/6i/9i/10g.

• Developed Data Warehouse using Oracle Data warehouse builder.

• Worked on Oracle Financial Application 10.7 module such as AP, AR and GL.

• Extensively worked with Financial Reports

• Expertise in developing forms using Oracle Forms 6.0/6i

• Expertise in deploying reports on Reports Server and troubleshooting Reports Server.

• Experience in Report Security issues.

• Experience in Leading a Team for development of reports and Backend Development.

• 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 ware housing and data loading into oracle database tables.

• Proficient in Tuning SQL using Explain plan, SQL*Trace and Auto Trace utility.

• Experience in using Oracle Utility like Export, Import and SQL*Loader

• Experience in Migration and Upgrade Oracle Database

• Experience in all phases of Software Development Life Cycle (SDLC) like Requirement Capturing, Data Modeling and Designing, Developing, Testing, Quality Assurance, Implementing, Documenting and User Training for various business applications.

• Used Discoverer to create business areas against oracle database

EDUCATIONAL QUALIFICATIONS

Bachelor of Engineering, Madurai Kamaraj University, TamilNadu, India.

PROFESSIONAL EXPERIENCE

Sedgwick CMS, Memphis, TN June 2009 till date

Sr. Oracle Developer

Environment: PL/SQL; Pro C, Perl, SQL; SQL*Plus; Oracle 10g; AIX, Windows XP, TOAD; ETL Data stage, Informatica, Crystal Reports XI

• This is a datawarehouse project for maintaining historical data for Liability Claims, Workers compensation claims, Disability claims. Responsible for developing reports using Pipelined functions. These pipeplined functions are called from crystal reports for PDF output and scheduled to run daily, weekly, monthly.

Michaels Stores Inc., Irving, TX Oct’2007 to May 2009

Sr. Oracle Developer

Environment: PL/SQL; Pro C, Perl, SQL; SQL*Plus; Oracle 10g; Oracle Forms 10g; 10gAS; Oracle Designer 10g; AIX, Windows XP, TOAD; Oracle Reports 10g; Oracle Developer; PVCS Tracker; PVCS Version Manager, Oracle RMS12, Oracle RPM12, Retek 6.6, ETL Data stage, Informatica, Crystal Reports XI, PL/SQL Web Toolkit;

• This is an upgrade project of Retek from 6 to 12. Initial Ultralight phase includes only ITEM, PO and Pricing modules. Involved in data mapping, Data conversion from 6 to 12, Developing interfaces from 6 to 12 and 12 to 6. Developed and converted customized Retek 6 reports to RMS12.

• Involved in creating Items, Price changes and Clearances for Integration testing.

• Developed Tax codes report using UDA attached to items. Each item assigned with a UDA Value which is used for Tax purposes. Developed Cost changes, New price change, Pending price change reports and Supplier attributes report. Modified base Printfrm form to display Excel output generated from reports alongwith PDF in two separate windows. Base forms like itemattr, supattr, strattr, whattr forms are modified to support customized columns.

• Modified ordhead form to call PO report by passing userid as cookie to avoid prompting userid when running the report. Location traits matrix(lotrm) form modified to import location traits from text file containing stores using WEBUTIL. Developed back end interfaces using PL/SQL stored packages, procedures, functions, Collections, Object Types, triggers, C, Pro*C, K-Shell scripts

Developed Korn shell scripts to kick off back end PL/SQL, SQL, Pro*C programs.

Developed screens and reports using Oracle Forms 10g/Reports 10g. Also developed reports using Pro*C and PL/SQL. Strong programming and debugging skills in PL/SQL, SQL, Dynamic SQL, C, C++, Pro*C, Unix shell scripting. Developed stored packages with Oracle's Web Toolkit.

• Developed RETL (Retail Extract, Transform and Load) programs to extract data from RMS (Retail Merchandising System) to insertion to the Oracle Retail RPAS (Retail Predictive Analytics System) database for the Category Management (CatMan) product. This included the Retail Merchandising System (RMS), Retail Data Warehouse (RDW) and Retail Demand Forecasting (RDF). Most of my responsibilities concerned technical issues with the RDW implementation, including the data model, the ETL implementation, the batch schedule and the batch programs. This included the batch data extract programs for RDF and RMS, as well as the data load programs for RDW. The batch programs were all written using korn shell scripts interfacing with the Oracle Retail ETL (RETL).

CURRENT RESPONSIBILITIES (Onsite/Offshore Model)

• Lead a team of 10 to 15 developers depending upon the size of Enhancement request/change request.

• Assist Project Manager with Time estimates

• Gather Business requirements from the Business Analyst. Give feedback and clear doubts with the BA.

• Create a prototype

• Prepare Technical Specifications or give download to the Developer to prepare the Technical Doc.

• Give review comments and sign off on Technical Specs.

• Review Code for Coding standards and from Performance , reusability, modularity, etc. prospective

• Do Tuning of the code such as SQL queries and PLSQL code

• Review/Create/Modify the Reports RDF or Forms in Oracle 10g depending on the work load

• Design/Review process for data cleanup

• Migrate the code in different environments

• Responsible for meeting deadlines for the change request or enhancement

• Responsible for Sign offs from the customer

• Responsible for rollbacks incase of issues in Production

• Responsible for smooth rollout and keeping a check for the first cycle of Production runs

ETCC, Richardson, TX Nov’2006 to Oct’2007

Sr. Oracle Developer

Environment: PL/SQL; Pro C, Perl, SQL; SQL*Plus; Oracle 10g; Oracle Forms 10g; 10gAS; Oracle Designer 10g; Linux; Windows XP; TOAD; Oracle Reports 10g; Oracle Developer; PVCS Tracker; PVCS Version Manager, ETL Data stage, Informatica, Crystal Reports XI, PL/SQL Web Toolkit;

• Responsible for creating and managing Queues using Advance Queuing future. Queues created for Inbound messages(tolls) from HOST. Separate queues created to validate and process the incoming Toll transactions. If failed in Validate or process, they will be send back to HOST using another OUTBOUND queue.

• Responsible for creating and managing DBMS scheduler jobs to enqueue and dequeue messages between systems. Used JOB chains and Chain rules to make use of DBMS scheduler effectively.

• Responsible for creating and managing new reports used in CSC application.

• Involved in development and maintenance of HCTRA tagstore application developed in Oracle 10g and Reports 10g and PL/SQL.

• Extensively used HTP, HTF and OWA packages used to dynamically build webpage from PL/SQL.

• Developed stored packages with Oracle's Web Toolkit

Dallas Airmotive Inc, Grapevine, TX Feb’2006 to Oct’2006

Oracle Developer

Environment: Windows XP, ORACLE 9i,9iAS,10g Forms 6i/9i,10g Report 6i/9i,10g PL/SQL, Pro C, Perl, TOAD, Impresa Application

• Developed screens to parse and upload the EDI data file received from Pratt & Whitney.

• Developed screen and database packages to export inventory data based on the user input filters and send it as a text file to the vendor.

• Handling User requests and taking requirements from users.

• Involved in Design, Development and testing of Rotable Process project that simplifies the steps to issue rotable part to the customer order and giving core credit to the customer.

• Day to day activities include Data fixing , Bug fixing and unit testing

Tek Systems, San Antonio, Texas. Dec’2005 to Feb’ 2006

Consultant

Environment: Windows XP, ORACLE 9i,9iAS,10g Forms 6i/9i,10g Report 6i/9i,10g PL/SQL, TOAD.

• Involved in development/support of the major billing modules.

• Responsible for design and development of screens/reports using Oracle Forms/Reports

THOT CORPORATION, Double Oak, Texas. Jun 1998 to Nov’2005

Oracle Developer

Environment: Windows 2000 server (Development), Red Hat Linux Advanced Server (Production), ORACLE 8i/9i, 9iAS, Forms 5/6i/9i, 10g Report 3/6i/9i, 10g PL/SQL

• Rx Home infusion health care pharmacy software used by Pharmacists, Patients, Nurses and Physicians at Accredo Health Inc. This project was developed in Forms 5, Reports 3 with Oracle 8i in Client – Server environment and later upgraded to Oracle 9i/9iAS and Forms 6i/9i and Reports 6i/9i in Web-Server Environment. This application gathers information about Patients, Inventory, Pharmacy, Nursing and Accounting details. Apart from the main menu, it has separate menus for System Administration and Change Control System (CCS). The System Administration menu is used to set up printers, define parameters for forms and reports, add new options to the main menu, etc. The CCS menu is used to track the development schedule for forms and reports, and testing information.

Implementation of SureScripts Interface:

SureScripts Electronic Prescribing Network is the largest network to link electronic communications between pharmacies and physicians, allowing the electronic exchange of prescription information.

• Developed screens to send RefillRequest, RxChangeRequest and RxFillStatus messages

to the Prescribers through SureScripts network.

• Developed database package to import SureScripts prescriber data file to our physician’s table.

• NewRx, RefillResponse, RxChangeResponse incoming messages from Prescribers are stored in a staging table and after insert for each row

• trigger on this table will parse the messages and insert to the RefillResponse, RxChangeResponse and NewRx tables accordingly. Developed NewRx screen to display the incoming NewRx messages from prescribers.

Implementation of Virtual Private Database:

Responsible for implementing the VPD for the Rx:Home Software. VPD is the row level security provided by Oracle 9i to enforce the security between user data. Its like the online banking where one user cannot see the other user data even though its in the same database instance. This is done mainly because different Pharmacists working for different companies use the Production instance.

Used dynamic SQL extensively to build the scripts for the following steps.

• Added vpd_id column to all the 700 tables in the system and made it part of the primary key.(vpd_id is constant for all the users of one company)

• Dropped and recreated all the foreign keys to point to the new primary key containing vpd_id.

• Dropped and recreated all the indexes for the foreign keys with new column list.

• Created before update trigger for all the tables to set the update_date, update_user columns.

• Created and enabled the policy for all the tables using dbms_rls.add_policy

• Created a database procedure to set the VPD context for the user and called it in after logon database trigger.

Contact this candidate