SUMMARY

• Around seven years of extensive experience in Oracle development, Support and Migrations projects on different domains
• Expert in SQL queries, PL/SQL Procedures, Packages, Functions, Stored Procedures, Cursors, Triggers, Interfaces and Data Conversion using PL/SQL, SQL*plus, TOAD, SQL Navigator and SQL*Loader.
• Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
• Strong experience in providing technical documentation and status reports of the applications as per the requirement.
• Extensively Used Cursors, REF Cursors, Bulk technics for Data extraction and Data Loading.
• Involved in Forms Migration from 6i to 9i using Migration Assistant Tool.
• Knowledge of database architecture for OLTP and OLAP applications, Data Analysis and ETL processes.
• Involved in Unit Testing, Integration testing & GUI testing, and providing Production Support.
• Experience in developing UNIX shell scripts. Working knowledge with various UI like Secure Shell, Telnet and Putty.
• Extensively involved in performance tuning for various oracle based applications for enhancing the load performance in various schemas across databases using methods like EXPLAIN PLAN, TKPROF and SQL TRACE
• Strong knowledge in Data Warehousing concept using PL/SQL, Manual ETL, UNIX Shell Scripting, Crystal Reports
• Knowledge transition to the team members and training to the End users.
• Proficient in analyzing and translating business requirements to technical requirements and architecture
• Experience in all phases of the development life cycle coherent with data cleansing, data conversion, data profiling, performance tuning and system testing
• Well versed in data analysis, developing data warehouse designs, working with staging, star schema and snowflake schemas, and dimensional reporting.
• Strong database skills and development knowledge
• Experience in leading and managing teams. Was a member of the board which determines the scope of a project, priority of a defect, and finalizes hot fix releases
• Extensive experience in handling CRs, onsite - offshore interaction and co-ordination
• Worked as a Team Lead for offshore team members and have experience of handling multiple projects at a time
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2007, MS Access, DB2

Languages: SQL, PL/SQL, Pro*C, C/C++, JAVA, XML, UNIX Shell Scripting, Perl Scripting

Oracle Tools/ GUI: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 4i/9i/10g

Tools: TOAD, SQL DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator, UNIX/LINUX Utilities, ERWIN

Web Technologies: HTML, VBScript, Java Script, CSS, DHTML, XML.

Operating Systems: Oracle Enterprise Linux, Redhat Linux, Sun Solaris for SPARC 8.0/2.6, HP UNIX 10.2, IBM AIX 4.1, Windows-2000/NT/98/95, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Morton Grove, IL

Sr. Oracle Developer

Responsibilities:

• DevelopedForms Screensused by Oracle Developer Suite forforms procedures, functions and packagesgenerate to end product of forms.
• Analyzed data, designed and developedOracle forms 10g queries, layout, report triggers, parameter form, data modelsetc.
• Programed inUnixshell scripts to provide a user interface toOracle formsandreports.
• Created Cron jobs inUnixfor scheduling file preprocessing.
• Oracle Forms developed and deployed in allUNIX environmentthrough Dev, Test, and Prod in an Oracle Applications environment.
• Portal included strong Java coding experience.PL/SQL scriptsin an Oracle RDBMS environment
• Initialized utilization ofData WarehouseETL software during conversion of Legacy data in Confidential to Oracle.
• Worked on FormsTriggers, Alerts, Data Blocks, LOVs, Parameters, and Program unitsby using PL/SQL procedures and functions of OOPS methodology
• Tested the Forms,debugged and fixed the Formsafter the testing
• Worked on OracleWeb Apache Serverfor configure of upload and download with the required Oracle forms refers to a class of systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.
• Extensively worked in creatingdynamic tables, loops, cursors and conditional operatorson the Oracle Form 10g, Hora 9, and using SQL *Plus
• Analyzed and developed E-Business Suite programs for databases supporting supply chain management,order management, inventory,warehouse management system, purchasing, and procurement.

Environment: HP-UNIX, Windows XP, Oracle Database 11g, PL/SQL, Oracle Developer Suite 10g,, Tortoise SVN, PUTTY

Confidential, Rockville, MD

Sr. Oracle Developer

Responsibilities:

• Developed Packages to validate raw data from Flat Files and insert into tables.
• Involved in the data transfer creating tables from various tables, coding using PL/SQL, Stored Procedures and Packages.
• Customized the Reports in Cross Tab Layout and Tabular Layout Formats.
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Designed and developed conversions to sustain Business Rules and Flow.
• Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers.
• Created the integrity constraints and Database Triggers for the data validations.
• Used PL/SQL Tables and Records in payroll generation process.
• Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.
• Customized Customer Transaction Analysis Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Report. Writing after Parameters Triggers for the Validation of the data.
• Created various custom reports like Transaction Aging Report, Credit Card Transaction Report, Active Invoice Register Report, Account Balance Consolidation reports and others using Reports Builder 6i.
• Coordinated with DBA in improving database performance.
• Written Test Plans and Involved in Unit testing.
• Designed and developed user test scripts for the UAT and migration of the developed codes. Scheduled the jobs with heavy dependencies.

Environment: Oracle Database 10g, Oracle Forms 10g, Oracle Reports 10g, Windows XP, UNIX, SQL Developer, XML, SQL, PLSQL, Oracle Forms and Reports 10g, Unix Scripting, Clear Case, Clear Quest, WINSCP, Putty.

Confidential, Winston-Selam, NC

Oracle Developer

Responsibilities:

• Created Indexes, Materialized Views needed for the project implementation.
• Created global temporary tables for the ARS Reports needed.
• Created Ad-hoc and On-Demand Reports for the end users.
• Regularized the reports for daily/weekly/monthly basis.
• Used lots and lots of Analytical function needed for the reports to built.
• Customized existing application in Forms 6i
• Implemented critical Surveillance Reports using Oracle Reports Builder Report 6i
• Involved on weekly status meetings and presented the projects to the Leads.

Environment: Oracle 10g, PL/SQL Developer, Report 6i

Confidential

Report Developer

Responsibilities:

• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.
• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.
• Received data from source (Soft Dollar, Market data & Communications) and imported the data to the interface table using SQL * Loader.
• Developed validation programs to validate the data before importing into oracle tables.
• Worked on UNIX Shell Scriptingfor Scheduling Batch Jobs.
• Developed PL/SQL Packages and Database Triggers.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loaderand PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.
• Developed user interfaces using Oracle Forms.
• Customized Reports using Reports according to client requirements.
• Developed Revenue reports like Monthly and weekly Revenue, Total Revenue and Monthly Transaction and Revenue Comparison Reports.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, TOAD, UNIX, Forms 6i, Reports 6i.

Confidential

Software Engineer

Responsibilities:

• Developed Stored Procedures and complex Packages using PL/SQL.
• Developed Triggers, Functions, Cursors, Materialized Views and Procedures.
• Created and used DB- links to connect to other local and QA databases.
• Developed new functionality in the existing application as part of change requests.
• Performance tuned DB queries.
• Defect Analysis and bug fixes.
• Strong RDBMS concepts and experience in creating, maintaining andtuning Views, Stored Procedures User Defined Functions and System Functions using SQL Server, T-SQL.
• Having good knowledge on creation and scheduling of T-SQL jobs to run daily.
• Complex enhancement requests.
• Provided hands on support to the users.
• Developed and customized several forms including Tabular, Mailing Label, Matrix, and Matrix with groups.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loader and PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.

Environment: Oracle 9i, Oracle Forms 6i, Oracle Reports 6i, Perl Scripting, PL/SQL TOAD, UNIX.