SUMMARY

• Around 8+ years of experience in various phases of Software Development life cycle, including Designing, Development, Testing and Production Support using Oracle SQL, PL/SQL, and UNIX.
• Expertise Oracle, SQL, PL/SQL, Oracle Forms, Oracle Reports
• Experienced in working wif utilities like SQL*Loader, External Tables, Import, Export to extract and load large volume of data.
• Experienced in performance tuning using SQL Trace - TKPROF and Explain Plan.
• Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
• Extensive work experience on Oracle 11g/10g/9i/8i, SQL server databases on UNIX, Linux and Windows enterprise platforms.
• Proficient in translating business requirements into logical data models, creating modularized enterprise applications
• Experience in interacting wif users, analyzing client business processes, documenting business requirements, performing design analysis and developing technical design specifications.
• Experienced in using pl/sql,sql developer tools like TOAD, PL/SQL developer
• Extensive experience in Application development using Oracle Forms and Reports.
• Strong experience wif Unix Shell Scripting (KORN, Bash).
• Providing assistance in logical/physical data modeling using ERWIN.
• Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and users documentation
• Worked on Production Support, receiving production calls, troubleshooting the application and resolving bugs.
• Oracle PL/SQL Oracle Forms XML Appworx Word Excel SQL developer
• Oracle SQL Oracle Reports SVN Java TOAD PVCS Access Visio
• Excellent analytical, problem solving, communication and interpersonal skills, wif ability to interact wif individuals at all levels.
• Strong understanding of object-oriented JavaScript
• Ability to work in teams and independently wif minimal supervision to meet deadlines.
• Experience in Data warehousing Management

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i/8.x, MS SQL Server, MS-Access

Languages: SQL, PL/SQL, T-SQL, Shell Script, Batch script, XML

Database Utilities: TOAD 8.5/8.0/7.1, SQL-Developer, PL-SQL Developer, SQL*Plus, SQL*Loader, Import and Export, Explain Plan TKPROF.

Operating System: Windows XP/NT/2000/98/95, Unix

Scripting Languages: Unix Shell Script, Batch File

Front End: Oracle Forms, Reports 6i, VB 6.0

Others: ERWIN, Crystal Report, Oracle Migration Workbench (OMWB), SQL Server migration assistance

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior Oracle Developer

Responsibilities:

• Interact wif the Business Teams in the requirements gathering.
• Associate wif the system analyst in developing the use cases and class diagrams.
• Working wif Database Architects in designing and maintaining the database structure.
• Designing database structure using ERWin.
• Creating DDL scripts from ERWin.
• Developed PL/SQL procedures, functions, triggers.
• Created materialized views.
• Used Java to create interactive pages.
• Unix Shell Scripting.
• Used clustered indexes to enhance performance of the application.
• Handled DBA activities like Grant/Revoke privileges to database objects
• Imported data into database from other files like xls, xml using PL/SQL procedures and External Table.
• Wrote UNIX script for batch process.
• Production support which includes PL/SQL package and UNIX Scripts bug fixing, manual Updates/Inserts and monitoring of processes.
• Used autonomous transactions in PL/SQL for various business rules.
• Prepared schema statistics, data preparation by import/export from external databases in Dev and Quality control databases.
• Oracle Forms 10g, Oracle Reports 10g, Oracle SQL and Oracle PL/SQL.
• Used extensively system tables like ALL OBJECTS, ALL TYPES, ALL SOURCE, DBA OBJECTS, DBA ROLES.
• Used and handled various named system exceptions in PL/SQL code like INVALID CURSOR, NO DATA FOUND, TOO MANY ROWS, VALUE ERROR
• Used and handled user defined exceptions in PL/SQL code.
• Created and managed sequences, used nextval and curval attributes of sequences in PL/SQL.
• Used different types of queries like subquery, union all query, intersect query, minus query.
• Created public synonyms.
• Made modifications to existing Oracle Forms and Oracle Reports used for software used by Worked closely wif administrators to understand and resolve performance issues by constantly troubleshooting and optimizing the code.
• Monitored database performance, backups, alerts and logs.
• Involved in performance tuning and testing the performance of the application.
• Provide timely updates to management on coding, status and scheduling issues.
• Review and provide input of the business and design requirements to ensure quality products.

Environment: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, Mainframe and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.HP-Unix, Oracle 9i/10g, Business Objects 6.5/XI R2, Toad, Informatica, Power Center 7.0, Autosys

Confidential, NJ

Database designer and Programmer

Responsibilities:

• Resolving user inquiry on daily issues in production system;
• Did user requirement analysis wif end users and business heads.
• Created the logical and physical interface model mapping EIM tables.
• Created database objects and PL/SQL Interface scripts.
• Created PL/SQL ETL scripts to read flat file data into staging table.
• Created Reports using SQL* Plus.
• Used Sybase extensively.
• Created Ad hoc SQL queries to use in various reporting.
• Extensively used TOAD tools for creating tables, procedures, SQL scripts, SQL tuning, explain plan.
• Oracle Reports mailed in tax collection. Three tier environment for Oracle Forms and Oracle Reports.
• Designed and developed the Audit Trail module wif UNIX shell and PL/SQL scripts.
• Created UNIX shell scripts to run the interface scripts
• Created UNIX shell scripts to ftp data from Main Frame host as a flat file.
• Created UNIX shell scripts to mail the users using 'elm' mailing.
• SQL used for various Oracle Reports.
• Oracle Forms and Reports deployed using the application server in three tier environment.
• Production support of existing Oracle PL/SQL and Oracle Reports.
• Maintain and created new Oracle reports used for collection of current and delinquent local taxes, real estate tax, business privilege and mercantile tax.
• Created the interface batch script (IFB) files on Confidential server.
• Co-ordinate wif Confidential front-end developers to complete user interface screens as per design.
• Co-ordinate wif the end user team to do the testing on QA database.
• Done the system testing and unit testing on QA database.
• Completed the implementation of the system on Production database. Monitored the daily batch process scheduled on Production system. Monitor Confidential Server components like Triggers, Workflow Monitor Agent, and Workflow Action Agent.
• Responsible for requirements gathering from Clients, Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Developed entity diagrams and data dictionaries to accomplish tasks. Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Created Platform independent schema structure so that the product data can be implemented in any database.
• New Oracle reports for summarizing default status by states. Oracle Report for dynamic generation of first notice of default letter sent to borrower.
• Oracle Forms and Reports deployed using the application server in three tier environment.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions wifout engineering changes.
• Performed Development at the crucial piece of work on Oracle PL/SQL Packages, SQL scripts to facilitate the functionality for the module.
• Maintain existing invoice marketing application that was in Oracle PL/SQL packages, Oracle Forms and Oracle Reports
• Involved in Technical feasibility discussions, Peer reviews and in unit testing.
• Developed Reports like Individual price list, Product Financial Analysis and Market compare list in Reports 6i.

Environment: VB 6, JAVA, Oracle 10g/11g, PL/SQL, SQL*LOADER, Oracle Streams 10g (Replication), SQL PLUS, HTML, SQL Server SSIS, TOAD, XML, HP-UNIX shell scripting.

Confidential, N.Y

Senior PL/SQL Consultant

Responsibilities:

• Worked as Team lead, and led a team of four developers, Responsible for requirement gathering, status reporting, creating various metrics, project deliverables.
• Conduct Technical Reviews and Audits of existing systems and Developed strategy document for new implementation.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER, Damp pump, Regular Expressions, Automatic Statistics collections in existing Oracle 9i applications.
• Developed PL/SQL procedures, Functions and Packages and used PL/SQL ETL Table functions to load data into the database.
• Tuned Report performance by exploiting the Oracle's ne built-in functions and rewriting SQL statements.
• Used Crystal Report to generate reports.
• Created custom Excel report for dynamically grouping and analyzing financial account details. dis was an Oracle financials R12 instance. Created MD70 for work.
• Used EXPLAIN PLAN,TKPROF to tune SQL queries, Crystal Report.
• Create conversion routines and add custom reports for converting legacy chemical analysis quality system into Oracle
• Quality module release 11 and RDBMS 8i. Create custom data import application using Excel macros over ODBC connection. Conversion routines utilize PL/SQL. Custom reports used Oracle Reports 2.5.
• Highly experienced in Oracle Business Intelligence Enterprise Edition( OBIEE )/Siebel Analytics, Oracle Discoverer (Desktop Edition, Plus Edition, Viewer Edition and Admin Edition of Versions 4i, 9i and 10g), BI Publisher ( Formerly Known As XML Publisher)
• Extensively used Erwin for data modeling and Dimensional Data Modeling by ERWIN.
• Worked on Informatica Power Center tool-Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• By using Autosys, created the job which runs a UNIX script. The script in turn runs the "pmcmd" command to run a workflow.
• Design and implement an Oracle E-Business Suite (EBS) solution to extract/ import routines to utilize EDI transfers to and from a warehouse vendor for a major medical product manufacturer.ocuments were 888 (item extract),816 (customer extract), 940 (SO extract), 944 (PO/RMA import), 945 (shipment import), 947 (inventory adjustment import). The solution utilized concurrent programs, PL/SQL routines, external tables and PL/SQL generated email notifications.
• Maintained CMS wif various repositories for security, Managing Objects, Server and Audits.
• Implemented new concept of manage access restriction in universe on the existing application by which 1550 reports are reduced to less than 200 reports.
• Excellent experience in designing OBIEE Dashboards, BI Answers, and Analytics using Administration Tool of Oracle Business Intelligence Enterprise Edition on Top of Data Marts and Data

Confidential, CT

Senior PL/SQL Consultant

Responsibilities:

• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Developed various Business Object 6.5 Reports and Universes. Used Context and loops in many complex Universes.
• Used partitioning and sub partitioning of tables to improve performance.
• Developed Shell scripts and SQL control files to load data through SQL Loader.
• Developed Complex SQL queries using various joins and developed various dynamic SQL’s thorough out the projects.
• Used Crystal Report to generate reports.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Used Bulk Collect feature to improve performance.
• Analyzed and computed statistics to improve response time for queries.
• Involved in Performance tuning of complex queries.
• Test case/data preparation, execution and verification of the test results.

Environment: HP-Unix, Oracle 10g, Business Objects 6.5, PRO*C, K Shell Scripting.