SUMMARY:

• Over 7 years of IT experience in various application phases of Software Development Life Cycle including Designing, Development, Testing and Production Support using SQL, PL/SQL and UNIX.
• Experience with multiple RDBMS including Oracle 11g/10g/9i/8i, Microsoft SQL Server 2000/2005/2008 and associated SQL Dialects such as Transact SQL (T - SQL), PL/SQL
• Expert level experience on PL/SQL that includes Cursors, Ref-cursors, Procedures, Functionsand Packages, Oracle Supplied Packages, Object, Materialized views, Partitioned Tables, Triggers, Synonyms, Sequences and Table Indexing.
• Experience in creating cursors, composite data types, collections and exception handling.
• Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Using Appropriate Interface tables.
• Created XML file for the include instead of the direct include in to the batch processing
• Extraction of XML files to load it into database through SQL *loader.
• Extensive experience in improving the performance of Query by minimizing the number of context switches between the PL/SQL and SQL engines Using Collections, Bulk Binds.
• Efficient in developing Logical and Physical Data model and organizing data as per the business requirements using Sybase Power Designer, Erwin, Embarcedaro in both OLTP and OLAP applications.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and Hints.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Experience in using tools like SQL * Plus, SQL Assistant, PL/SQL developer, TOAD.
• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.
• Experienced in writing UNIX shell scripts for automating the process of data loading & Batch Processing.
• Developed and maintained system documents, including technical specifications, data mapping, program logic and flowcharts.
• Expert knowledge with Microsoft Excel, Power Point, Word.
• Strong communication, interpersonal, analytical skills with proficiency at grasping new concepts quickly and utilizing the same in a productive manner.
• Analyzed and Implemented the ETL architecture using ETL Informatica, SQL * Loader, PL/SQL.
• Worked on DML, DDL, and TCL operations. Extensive experience in Database query tuning, Performance tuning of Reports and troubleshooting Oracle Application issues on OLTP and DSS systems.

TECHNICAL SKILLS:

Databases: Oracle 12c/11g/ 10g/ 9i/ 8i,SQL Server 2005, MS ACCESS

Languages: SQL, PL/SQL, PRO* C, C++,Java, Visual Basic

Tools: TOAD, SQL Developer, Oracle Enterprise Manager, SQL*Plus, SQL*Loader, Discoverer, MS Office, JIRA,Erwin, Embarcedaro, MS Visual Studio 2007

Internet Technologies: HTML

Scripting: Unix shell scripting, AIX, Java Script, Perl

Operating Systems: UNIX, LINIX, Windows VISTA/XP/2000/98, MS DOS, MAC

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Sr. Oracle PL/SQL Developer

Responsibilities:

• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Optimized SQL used in reports to improve performance dramatically.
• Tuned and optimized the complex SQL queries.
• Had to design database model risk management application.
• Statement Processing - Redesigned existing patient statements functionality so that the process is automated to the full extent possible. Centralized data collection to make conversion to different formats efficient. Built using OracleXMLDBand XSLT.
• Developed the functions, packages, procedures and triggers for various modules of the system using the latest XML DB architecture.
• • Developed DBMS JOB functions to process incoming Files to load into the XML Repository
• Working on documenting Market Risk, Credit Risk, Operational Risk critical data elements, data lineage, dashboard procedures, visio flowcharts, and control points for BCBS 239 Compliance needs. Interacting with Market Risk, Credit Risk Heads and support team to provide clear definitions for all data/business terms and report procedures.
• Experienced in installation, configuration, tuning, security, backup, recovery and upgrades of IBMAIX.
• Worked with Business users to gather requirements for developing new Reports or changes in the existing Reports.
• Extensively used SQL*Loader scripts to load legacy data into Staging tables and relevant Packages to validate and cleanse data.
• Created Cursors, Collections and DB Triggers.
• Created INDEX BY Table Method to Fetch Records in Random Selection.
• Fine-Tuned and optimized number of SQL queries and performed code debugging using TOAD.
• Set up batch and production jobs through Tidal.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Worked with HTML, JavaScript pages in order to create web pages and fix bugs for the Rhapsody web site.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Tuned SQL queries, performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables.
• Developed and maintained all HIPAA security policies and procedures including the organizational Information Security policy and roles & responsibilities; Developed policies, standards and baselines related to asset and procurement management, IT vendor management, IT workforce planning, and IT compliance with county, state, and federal regulations. Acted as the Information Security point of contact for federal, state, and private auditors

Environment: Oracle 11g, SQL, PL/SQL, SQL*LOADER, Oracle Database 11.2.0.2.0, XMLDB,HTML/JavaScript, TOAD, UNIX, Oracle 10g RAC.

Confidential, New York, NY

PL/SQL Programmer

Responsibilities:

• Proposed Changes to the existing Database Architecture as per the requirement.
• Drafted a Solution Design Documentation for the proposed changes to the database.
• Unlocking Root user and Padmin user, using AIXand VIO's Bootable CD's respectively.
• Changed the Architecture of the Current data flow along with their Exception Handling methodology to handlethe unprocessed Transactions.
• Produced physical data models and suggested proper indexing that promotes fast dataretrieval based on BI usage.
• Developing Unix Shell Scripts to Execute the Database Packages and Procedures on daily basis.
• Involved in analysis of market risk and claims data.
• Designing, Developing, Enhancing and Maintaining Data warehouse ETL Processes, PL/SQL scripts, DB Procedures, DB functions, creating tables and indexes.
• Involved in Analysis, Design and Development of ETL Mappings for raw data loading and for building star schema using Informatica Power Center 9.5, Oracle 11g.
• Re Engineered the ER diagrams to populate the data from other source systems, ETL, process the dataaccording to DW methodologies, apply star schema and store them in Data mart tables.
• De-normalizing the base data and building the Data warehouse in Star Schema.
• Interaction with the End users for the Functional requirements and Design specifications.
• Tuned the SQL Queries by Statically Analyzing the Database Tables.
• Created Stored Procedures, functions and packages as per ETL Framework.
• Modified Existing Packages, Procedures, Functions and transformations as per the New Architecture.
• Extensively performed Unit Testing with different test cases.
• Provided Test Data to QA team for validation.
• Created and altered database Objects as per business requirements.
• Developed number of reports to provide the Error logs Information for the failed transactions and procedures to handle them.
• Responsible for data analysis, engineering, programming, implementation and Support for the product.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.

Environment: Oracle 9i/10g, SQL, PL/SQL, JAVA, UNIX, SQL*Plus, Toad, UNIX.

Confidential, MN

Oracle PL/SQL Developer

Responsibilities:

• Created and modified complex functions, stored procedures, packages and Triggers by using Oracle PL/SQL based on the business rules.
• Extensively worked on Schema Migration, Database Program Migration, and Data Migration from Sybase to Oracle by using Oracle SQL Developer.
• Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS PROFILER, and Hints etc.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
• Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading in the PL/SQL Packages.
• Used UTL FILE PACKAGES for writing DBMS OUTPUT into the files.
• Extensively used Oracle 11g features like RESULT CACHE, Compound Triggers etc.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day
• Worked on Table partitioning and Index creation to improve the performance of the query.
• Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.
• Automated connection to and data retrieval from team site, exported risk report data in spreadsheet format, and automated data retrieval for continuing operations.
• A proven developer with excellent track record widely recognized for excellent technical knowledge, quick learning capabilities, high quality work products, on-time delivery, risk analyzing and providing solutions.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.
• Facilitate timely approval of major milestones, approvals and signoff.
• Report the project status and generate milestone reports.
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project’s success.
• Create a risk plan and list all the mitigations.
• Present the change requests for approvals.
• Facilitate and document the post implementation results in the form of closure reports.
• Conduct weekly status meetings.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Participate in requirements review, application design review and test plan reviews
• Coordinate activities with infrastructure, business and QA teams.

Environment: Oracle 11g/10g, WINDOWS 7, SQL, PL/SQL, SQL * Plus, TOAD, SQL*Loader, Shell Scripts, SQL *Loader, SQL Plus, SQL Developer, UNIX, Windows XP

Confidential

Oracle Developer

Responsibilities:

• Writing PL/SQL code for deleting data for employee records for previous data.
• Involved in software requirement specification and technical design.
• Performed Normalization and Logical Database Design.
• Created of database links and accessing the data through SQL statements.
• Created database, table spaces, user schemas, and assisted in database administration and maintenance.
• Created Stored Procedures, Database Triggers, Functions and Packages to manipulate the database and to apply the business logic according to the user’s specifications.
• Involved in developing various Procedures, Functions and the PL/SQL Libraries to support the GUI application.

Environment: Oracle 8i, SQL, PL/SQL developer, SQL server 2005, Microsoft BIDS 2005

Confidential

Oracle Developer

Responsibilities:

• Have done research on Service providers in different fields like, medical, healthcare, business etc.
• Analysis of the specifications provided by the clients
• Design and Development.
• Created the Table structures.
• Database management
• Coding database manipulations, Stored Procedure changes and creating new stored procedures in Oracle.
• Unit testing.
• Involved in Logging and Tracking the defects

Environment: PLSQL, Oracle9i, Toad, Windows 95, UNIX.