OBJECTIVE:

• Looking forward to associate with an organization, that allows me to utilize my competencies to the best use that helps grow myself and organization.

SUMMARY

• Over 7.5 years of IT experience in application development / production support in Oracle PL/SQL (9i, 10g, and 11g), Forms & Reports 6i, and 10g with experience in onsite / offshore development.
• Experience in all phases of SDLC; Analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Innovative professional with proven ability to develop business solutions, and identify, analyze, and solve problems to increase customer satisfaction through expertise knowledge in database programming using PL/SQL and designing forms & reports.
• Strong experience in Oracle 9i/10g/11g complex queries, packages, functions, stored procedures, triggers, views, data dictionary objects and built - in packages.
• Experienced in developing APIs using Collections, Cursors, Bulk Processes, Merge, and Dynamic SQL.
• Expertise in complex joins, exception handling, autonomous transactions, Materialized views, aggregate & analytical functions and data processing using sqlloader and external tables.
• Experienced in performance Tuning using explain plan, indexes, hints and various table partitioning techniques.
• Working experience in designing complex user interfaces using Forms 6i/10g, master-child relationship for data integrity, dynamic record groups, list values, editors, changing visual attributes/properties, dynamic display of fields on canvas at run time with varying view port size.
• Experience in working on different canvases, view ports, modal, modal less windows, displaying alerts, capturing messages in forms.
• Strong experience in forms built-ins, system variables, form triggers, global variables, object libraries, smart classes, visual attributes, attached libraries and parameters.
• Good knowledge in migrating forms/reports from 6i to 10g and to 11g.
• Experience in developing complex reports for data output, invoices, graphs.
• Strong knowledge in report parameters, place holders, formula columns, summary columns and report triggers.
• Good understanding of creating responsibilities, concurrent programs, registering forms and reports in oracle applications 11i.
• Hands-on experience with Shell script and HP Service Center and Quality center tools.
• Consistently recognized for technical troubleshooting skills; Able to quickly learn and master new technologies; equally successful in both team and self-directed settings.

TECHNICAL SKILLS

RDBMS: Oracle 9i/10g/11g

Developer Suite: Oracle Forms & Reports 10g, 6i

Programming: SQL, PL/SQL, Shell Script

Utilities: PLSQL Developer, Toad, SQLdeveloper, Putty, WinSCP

Schedulers: Autosys, Appworx

Platform: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential - Dublin, OH

Delivery Module Leader

Responsibilities:

• Working in development of surveillance application that acts as a security measure to keep track of employees/declared relatives trading and generating alerts if unusual pattern observed as per pre defined rules.
• Developed APIs (procedures) as per the business requirement to define rules to generate short term trade/non-approved trade alerts and send the data to Java system.
• Developed procedures for data validation, loading data from staging tables to actual tables as per load strategy.
• Creating loader scripts to load multiple feed files from source system to actimize database.
• Using explain plan, hints, materialized views, optimized the programs for faster result population to front-end for user display.
• Using table partitioning techniques, bulk processing and indexes for tuning the procedures for better performance.
• Working with Data Management team for Autosys jobs scheduling and shell script development.
• Designed database architecture for staging area.
• Monitoring and reviewing team members programs, testing and maintaining in subversion.
• Creating Design documents, flow charts, and test scripts.

Environment: Oracle 11g, QL, PL/SQL, Unix, Shell Script, PUTTY, HPSD, Autosys

Confidential - Cincinnati, OH

Onsite Leader

Responsibilities:

• Worked in development, testing and production support using Oracle Forms, reports 10g, Oracle database 11g.
• Collecting requirements from customer and creating high level design documents.
• Developed database packages for recording/scanning check-in, put-away of the parts received at the warehouse.
• Developed loader scripts to load the transactions from third party system IBM-MQ to oracle database and scheduling jobs in appworx.
• Created database objects tables, views, materialized views, packages and procedures as per the business needs.
• Tuned the programs for faster job completion within SLA.
• Developed pl/sql programs with complex dynamic queries to reduce the future enhancements for each site addition, thereby reducing the cost to company.
• Created user friendly forms to store/query data, import to delimited/fixed width files on local system.
• Developed complex forms having master-child relations to maintain data integrity.
• Developed forms with different canvases to populate data using dynamic lists, record groups.
• Developing complex reports for generating invoices, graphical representation of data, using formula columns, summary columns, place holders.
• Reviewing and maintained source code and tested to fulfill the business requirements.
• Interacting with client and offshore team for smooth execution of the project.

Environment: Oracle 11g, Forms & Reports 10g, SQL, PL/SQL, Unix, Shell Script, PUTTY, HPSD.

Confidential - Cincinnati, OH

Technical Leader

Responsibilities:

• Worked in data analysis project.
• Interact with client on daily basis, to collect errored data, analyze the root cause which was usually the change in business requirement.
• Modified the existing packages, procedures to process the information as per new requirements.
• Worked on optimizing existing procedures and functions using PL/SQL.
• Developed forms with dynamic record groups, combo boxes, forms with canvas lengths adjusting dynamically.
• Developed forms with editors to pass data, dynamic lists to list items.
• Dynamically changed the visual attributes/properties of items in forms.
• Developed reports with multiple layouts.
• Used report triggers effectively.
• Created mappings in ETL to load data from source database to target database

Environment: SQL, PL/SQL, Forms and Reports 6i, Oracle 10g, PLSQL Developer, PUTTY, Unix Shell Scripting (ksh), ETL

Confidential - Cincinnati, OH

Oracle Developer

Responsibilities:

• Collected the requirements from customer, weekly reported the status to customer.
• Extensively developed user interfaces using oracle forms 6i which includes dynamic display of fields on screen, master-child relations, publishing the forms on oracle applications 11i.
• Developed forms to facilitate the user to input the output file details that have to be generated by back end packages.
• Developed forms to correct the errored records, including functionality to autocorrect the similar errors in future, there by reducing the end-user efforts.
• Created back end package, that will generate any format of file csv,xml,txt, dat etc based on the data setup in the user interfaces. Once user sets up the output file definitions like fixed width or delimited, csv, txt, xml depending on requirement, this package creates the interface file.
• Created forms to load data for table to table transfer and wrote dynamic programs in back end to facilitate the same.
• Created packages with dynamic sqls that are capable of creating any format of file like fixed width/delimited, dat, csv, txt, xls, xmls files based on one time data setup in user interfaces.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Exception Handling.
• Worked on optimizing procedures and functions using PL/SQL.
• Worked on Dynamic SQL and PL/SQL block in PL/SQL.

Environment: Oracle Application 11i GL, Forms & Reports 6i, SQL, PL/SQL, Unix Shell Scripting (ksh), Oracle 10g, PUTTY.

Confidential

Oracle Developer

Responsibilities:

• Worked with various functional experts to implement their functional knowledge into working procedures.
• Modified existing forms, reports to suit the business requirements of Confidential Motors India Ltd.
• Modified existing store procedures, functions, packages to fix the gaps to meet the requirements of Confidential Motors India.
• Developed database triggers, functions, procedures, and packages in PL/SQL, Oracle10g as back-end.
• Developed user interfaces to store the repair history of the vehicles, sales history of the dealers.
• Developed reports to generate the invoices.
• Creation of database objects like tables, views, procedures, packages using Erwin data model.
• Worked on Dynamic SQL and anonymous PL/SQL block.
• Wrote various kinds of SQL queries involving Correlated Sub queries, UNION, Inner and Outer Joins
• Developed UNIX Shell Scripts and PLSQL procedures to import and export data.

Environment: Oracle Forms & Reports 6i, PL/SQL, Unix Shell Scripting, Oracle 10g, PUTTY.