SUMMARY

• 8+ Years of IT experience in Design, Development and Maintenance of various software applications in client - server environment using Oracle Technologies on UNIX & Windows Platforms.
• Experienced as Oracle Database Administration/Oracle Applications DBA in Exporting/Importing/Maintaining Database Models.
• Experienced in maintaining multiple databases, handling the performance issue for Oracle Upgrades.
• Experience with front end applications like Java, JDBC and interface applications like Weblogic.
• Experience working with XML Javascript.
• Experience in CEMR Data Conversion Application to Epic for Clinical Data and Dental conversion to Metavance internal Database.
• Experienced working with Data Issues and handling the flaw by implementing new design modules.
• Experience in Data Extraction, Migration, Transformation and Error handling.
• Adept in Oracle, Oracle Tools and Utilities like SQL and PL/SQL.
• Experienced working with Toad 11.5, SQL*Plus, SQL *Loader, SQL Developer.
• Experienced in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages to implement business logic.
• Experience in Data Migration processing including data loading from flat files to the database tables using SQL*Loader and Bulk Collect.
• Extensively worked on Performance Tuning and Query Optimization using Explain Plan and re-designing of poorly designed process flow of data.
• Experienced in creating Oracle Outlines and migrating them into SQL Plan Baseline Functions
• Highly involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Production Support.
• Well versed in MS Office Suite such as Visio, Word, Excel, Access and PowerPoint.
• Experienced in creating in Logical and Physical Model Diagrams using Power Designer which are useful in Database Architecture.
• Involved in programming, debugging, Unit and System Integration testing of modules.
• Involved in jobs scheduling, monitoring and Production Support in a 24/7 environment.
• Excellent Analytical and Problem Solving skills with strong communication and interpersonal skills.
• Experienced as Onsite Coordinator with a team of 4 in India.
• Experienced in prioritizing action items and delivering to customers on time.
• Flexible, highly adaptable, team player, pro-active and eager to learn and perform new tasks.

TECHNICAL SKILLS

Languages: C, C#, Java, XML

Databases: Oracle 11g/10gR2/9i/, MS Access

Tools: Toad 11.5, Power Designer, SQL* Plus, Teradata, SQL* Loader, SQL Developer, Oracle Developer, MS Visio, Text Pad, Erwin, Informatica 8.5, VI Editor, Tidal, Business Objects Data Services 11.5 and Data Integrator.

Knowledge: SSH, KSH Scripting

Version Control: PVCS, Open Source CVS

Web Technologies: HTML, CSS, XML, JavaScript

Operating Systems: UNIX, Solaris, Windows 95/2000/NT/XP, Linux

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr.Oracle PLSQL Developer

Responsibilities:

• Involved in the IT projects in Operations Marketing Sales as a PL/SQL developer.
• Keeps abreast of IP and CIRS standards with a focus on reliability.
• Working with Data Modeling, database creation and configuration, creation of indexes.
• Responsible to monitor database performance, and manage database and query tuning.
• Involved in developing and maintaining application stored procedures and Unix shell scripts.
• Writing SQL coding, including use of sub-queries, inner and outer joins, and Oracle built-in functions.
• Many of our production support tickets involve reading the SQL queries built into the Java script. These queries are lengthy with lots of joined tables.
• PL/SQL coding. In particular, must understand the language well enough to read code written by other people and trace it through to resolve problems.
• Work with Java front end application team on daily basis and coordinate to improve and reach the requirement of customer.
• Work with interface team and testing team with performance testing and when the Java code is being deployed to desired environment.
• Turn off Oracle scheduled job when restarted the WebLogic servers.
• Working with SQL performance tuning, creating outlines and migrating to SQL Plan Baseline Functions.
• Involved Data Modeler to help with tuning, but the developer should have a basic understanding of tuning concepts, including effective use of indexes, reading an Oracle optimization plan, and structuring a query for better performance
• Prepared Production Support Documentation for future purpose.
• Involved in preparing Technical Specifications and Developer Package.
• Working with Enhancement Projects and participating in 2 month releases.
• Involved in handling integration and interfaces with other systems like SAP, Sales Force.
• Involved in glancing Performance Testing and Regression testing.
• Involved in Exporting and Importing Metadata across the databases.
• Participated in mentoring junior and offshore developers - sharing ideas, skill and knowledge with others.
• Involved in Business acumen. Remedy tickets often come in with vague requests.

Confidential, San Francisco, CA

PL/SQL Developer and Data Migrations

Responsibilities:

• Created Jobs in Business Object data Services Application and Data Integrator Application.
• Worked on Oracle SQL Developer Data modeler
• Expertise in monitoring Automation jobs and executing Data Quality Initiative.
• Exclusively worked in creating Unix shell scripting to load the data using Flat Files / Excel Files.
• Worked on Unix Server for file transfers and created Shell Scripts to hand the multiple jobs and kick off the jobs.
• Created the PL/SQL packages, procedures, functions applying the business logic to load the package data in required environment.
• Worked with XL file format and created the workflow in Microsoft Visio and send the release installation plan to Release team to insure all the jobs are in Production database.
• Updated the code in Clear case and did a code check out when ever new code is written
• Prepared the proper documentation for all the jobs and provided the user guide to the Users.
• Design and developed the scripts to create table, views, indexes and sequence.
• Created the custom tables to import the Patient’s data and insert into the database tables.
• Extensively used INDEXES AND HINTS for better performance of queries.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Prepared the proper documentation for all the jobs and provided the user guide to the Users.
• Customized different modules of reports after upgrade process using MS Access.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Actively involved in preparing Technical and Business documentation for the application in design, which could serve as future to the programmers and system developers.
• Developed customer strategies and improve business performance.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, Business Objects Data Services, Data Integrator, UNIX Perl Scripts.

Confidential, Tampa

PL/SQL Developer and Data Migrations

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specification and design document for the development of the CEMR Application.
• Completely involved in migrating data to Epic applications in a text file format and transferring the data onto the FTP Server, which is accessible to the interface team.
• Involved in analyzing the root cause for the missing data and providing the missing data from the Extracts for Testing.
• Extensively worked in providing updated records of the patients on weekly basis by comparing the previously Exported patients records.
• Involved in keeping track of previously Exported patients and archived them for future purpose.
• Created the PL/SQL packages, procedures, and functions applying the business logic to update the patients’ database.
• Design and developed the scripts to create table, views, indexes and sequence.
• Created the custom tables to import the Patient’s data and insert into the database tables.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Used Perl Scripting in moving the files faster to the Archive folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing BRD, functional document, user document, process flow diagram and flow charts.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS package, UNIX (Putty) Perl Scripts, MS Office, MS Visio.

Confidential, New York, NY

Oracle Pl/SQL Developer

Responsibilities:

• As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
• Involved in the Database Design Relational models using ERwin.
• Created different schemas and maintained schema objects.
• Created Data Mart with complete Start Schema for OLAP Reporting.
• Wrote PL/SQL Overloading Stored Procedures, Functions, Packages and Package Constructors to enforce Business rules.
• Involved in upgrading Database using Oracle 11g and made ease-of-use features that make Grid computing more accessible.
• Maintained streamlined data management processes that ensures integrity of data between business systems as well as Improving data quality, integrity and reliability that is managed through business change.
• Involved in developing processes using ETL tools (Data Integrator), PL/SQL and SQL to support business reporting requirements.
• Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
• Configured packages to transfer data from development to testing server regularly using Autosys 4.5.
• Scheduled the Jobs using the Autosys 4.5 and 4.5.1 to automate the daily jobs.
• Created control file scripts and used SQLLDR to load data into the staging table.
• Implemented complex Interface business rules using Oracle Database Triggers constructs.
• Utilized Partitions to fine-tune SQL data load.
• Extensively used INDEXES AND HINTS for better performance of queries.
• Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof
• Extensively wrote UNIX Shell scripts to automate the data load from sqlldr to staging table.
• Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions. Creating and editing database tables, views, indexes, constraints, and users. Used for quick access to the Schema Browser.
• Involved in generating WebiIntelligence Reports to satisfy Ad-Hoc request.
• Participating in code walk through and review sessions with the Development team and QA team.

Environment: Oracle 9i/10g/11g, Oracle 10gR2, SQL, PLSQL, CVS, TOAD, Microsoft Visual Studio, Business Objects XI3.1, ERwin, Windows XP, UNIX.

Confidential

Oracle Technical Consultant

Responsibilities:

• Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures.
• Developed custom database objects like tables, materialized views, triggers, indexes, cursors to implement efficient data management techniques.
• Designed and created ER and Data Modeling diagrams using VISIO 2000 software.
• Converted work schedules for employees from legacy system into Oracle HRMS and Payroll using assignment API.
• Developed an Interface Program to transfer legacy data to the HR/payroll tables using SQL*Loader
• Worked on extracting life events and benefits of employee information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
• Developed custom packages, procedures and functions for the HR schema.
• Checked the functionality of screen GUI’s.
• Worked with the team to isolate production issues with accuracy and quick precision.
• Reviewed the Business Requirement Documents and the Technical Specification.
• Designed Test scripts and test cases in Test Director and MS-word.
• Generated automated test cases on first build of the module using QTP, Rational Tools.
• Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using QTP.
• Analyzed Software Requirement Specification
• Involved in writing the Test cases and Test plans based on Source to Target Mapping documents and Data Model diagrams.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the data between Enterprise Data Warehousing and Data Mart Staging Tables.
• Used various checkpoints in the Informatics designer to check the data being transformed.
• Wrote and ran Unix Scripts for batch jobs.
• Performed backend database testing by writing SQL and PL/SQL scripts to verify data integrity.

Environment: Oracle9i, PL/SQL, SQL*Loader, UNIX, TOAD, MS-Excel, MS-Visio