SUMMARY

• Over 9 years of programming experience as an Oracle SQL/PLSQL/ETL Developer in Analysis, Design, and Implementation of Business Applications in OLTP, Client/Server architecture and data warehouse applications.
• Strong Knowledge on oracle architecture and database design.
• Excellent working and conceptual knowledge of Oracle, PL/SQL, Developing Forms and Reports, C/C++, UNIX Shell Scripting and HTML.
• Experience in development of applications using Oracle 10g/9i/8i, SQL, PLSQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i.
• Good Experience in developing PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors Ref Cursors, Analytical Functions, Collections, Exception Handling.
• Extensive experience in analysis and design of database, database modeling, ER Diagrams,normalization and de - normalization.
• Strong experience using Oracle Data Integrator (ODI) and Oracle Warehouse Builder (OWB).
• Extensively worked on Oracle Data Integrator (ODI) Topology manager, Designer, Operator.
• Tuned SQL queries using Explain Plan and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Expertise in loading data from legacy systems using SQL*Loader.
• Have in-depth knowledge in Data analysis, Data warehousing and ETL techniques, Business Objects, UNIX Shell Scripting, SQL, PL/SQL scripts.
• Experience with Star Schema Modeling and knowledge of Snowflake Dimensional modeling.
• Worked with various performance tuning techniques using tools provided by Oracle like SQL*TRACE, TKPROF, HINTS, DBMS PROFILER, DBMS STATS etc.
• Used DBMS SCHEDULER to run jobs in parallel to improve time-constrained performance.
• Used DBMS PROFILER package which enables the collection of profiler (performance) data for performance improvement.
• Good understanding of Relational database design and developed various data models using ERWIN and Oracle Designer.
• Created various reports using oracle reports developer like matrix reports, matrix with group reports, and group above reports using Reports 9i/6i/3.0/2.5 and designed user interfaces with Forms 6i/5.0/4.5.
• Extensively worked with third party database tools like TOAD & PL/SQL Developer.
• Experience in using oracle long data types like BLOB, CLOB
• Experienced in Error Handling By Using Exceptions.
• Experience with software Development life cycle (SDLC) process performing detailed analysis, collecting requirements, documents requirements, coding and unit testing, integration and system testing
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Excellent Logical and Analytical Skills, Enthusiastic, and good Interpersonal Skills.

TECHNICAL SKILLS

Databases: Oracle 9i, 10g, 11g

Languages: SQL, PL/SQL, VB, C#

Tools: TOAD, SQL Developer

Oracle Utilities: SQL Loader, EXP/IMP, EXPDP/IMPDP, RMAN

Operating systems: Windows Server 2000/2003, Oracle Enterprise Linux, Red hat Linux

PROFESSIONAL EXPERIENCE

Confidential, Louisville, KY

Oracle Developer

Responsibilities:

• Involved in design of database and created database objects.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed and modified procedures, Function, triggers, forms, reports and deployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Performed load and integration tests on all programs created and applied version control procedures to ensure that programs are properly implemented in production.
• Responsible for creation of new users and setting up privileges and policies for protection of data.

ENVIRONMENT: Oracle 9i, SQL, PL/SQL, SQL*Loader, KORN Shell script, Oracle Forms 9i, Reports9i.

Confidential

DBA / Developer

Responsibilities:

• Migrated SQL server database to Oracle using SQL Developer’s migration tool.
• Completely owned commission module, which is crucial in VUE Product. This module includes commission cycle, payment cycle and out bound GL extracts.
• Converted Stored Procedures, Functions, Packages, views to implement the same logic as it is in SQL server.
• Regularly taking backups of development and test database and restoring whenever required.
• Managing user permissions for all the users.
• Involved in client calls for requirements gathering.
• Responsible for release management.

Environment: Oracle 10g/11g, Oracle Data Integrator (ODI 10g/11g), PL/SQL, PL/SQL Developer 8.0.4, Shell scripting, SQL*loader, UNIX/LINUX, Windows NT.

Confidential

DBA / Developer

Responsibilities:

• Development (using Stored Procedures, Functions, Packages …), Unit testing and bug fixing.
• Downloading and maintaining the database dumps from client, restoring in internal database and regularly backup the development database.
• Implementing the enhancements.
• Fixing the issues posted by team and posted by client.
• Involved Production Support and client interaction.
• Responsible for Release Management.

Confidential

DBA / Developer

Responsibilities:

• Backup Database from UAT and restore.
• Regularly backup the development and test database.
• Responsible for generating Extracts.
• Involved in doing major changes in Bonus Schedule. This also involves report design changes.
• Support the compensation team and understand the processes.
• Interacting with client and gathering Requirements.
• Responsible for Release Management.

Confidential

DBA / Developer

Responsibilities:

• Regularly refresh the development and test database with UAT backup.
• Implementing the enhancements like A646 Health Reform changes.
• Development (using Stored Procedures, Functions, Packages …), Unit testing and bug fixing.
• Taking backup form production server and importing to internal database when required.
• Involved in Production Support.
• Responsible for Release Management.

Confidential

DBA & PL/SQL Developer

Responsibilities:

• Regularly perform Backup and Restore activities on development and test databases.
• Implemented Data guard at client environment for minimizing data loss.
• Collected User Requirements by participating in meetings and studying existing System.
• Created database objects like Tables, Views, Sequences, Directories, Synonyms, Stored Procedures, Function and Packages, Cursor, Ref Cursor and Triggers.
• Involved in analysis, design, coding and testing.
• Involved in modifying various existing Packages, Procedures, Functions and Triggers according to new business needs.
• Developed complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Used SQL LOADER to upload the information into the database.
• Used Explain plan for query optimization.
• Wrote test cases and performed unit testing.
• Involved in writing Technical Specification Documentation.

Confidential

DBA & PL/SQL Developer

Responsibilities:

• Created the database structure in MS access and Oracle.
• Developed procedures, triggers and functions in Oracle database.
• Prepared the cables for Serial communication and TCP\IP communication.
• Communicating with the COM class objects and reading the data from serial port.
• Understanding the Communication method by reading the Interface manual.
• Updating the Patient Test results to HIS database based on appropriate Barcode.
• Saving the Quality Control data in Access database and Exporting the Quality Control data to Excel sheet.
• Implemented at the client place.

Confidential

Application Developer

Responsibilities:

• Research on Confidential environment, DICOM standards and Network port communication protocols.
• Created architecture for Confidential environment. Also prepared SRS for this Project.
• Created the database structure.
• Developed a windows service as a SERVER side application.
• Understating and Using a Third party OCX control for developing the client side application.
• Developed procedures, triggers and functions in Oracle database.

Confidential

System/Network administrator

Responsibilities:

• User administration (creating and managing ADSI accounts).
• Maintaining systems (changing Hardware components).
• Verifying that peripherals are working properly.
• Quickly arrange repair for hardware in occasion of hardware failure.
• Monitor system performance.
• Software Installations including Operating Systems (Windows and Linux), Oracle Server/client, Dot Net, VB6.0, Proxy software and etc based on the requirement.
• Monitor network communication, Crimping network chords.
• Update system as soon as new version application software release.
• Implement the policies for the use of the system.
• Maintaining Internet policies using CC Proxy and Wingate.
• Scheduling Server maintenance activity.
• Configured RAID for Database server using RAID1 (Mirroring).