SUMMARY

• A seasoned PL/SQL Developer with 7yrs plus work experience in Data ware house, Application Development and Production Support in Client/Server Environment using Oracle 11g/10g/9i/8.x, SQL, PL/SQL, Oracle Data Integration.
• Experience in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Excellent proficiency in Data Extraction, Transformation and Loading techniques.
• Profound Knowledge in Star Schema Modeling and Snowflake Dimensional Modeling (Data Marts, Facts and Dimensions.
• Strong technical expertise in creating and maintaining database objects - Tables, Views, Materialized Views, Indexes, Sequences, Synonyms, Database Links and Database Directories.
• Extensive experience in developing PL/SQL Stored Procedures, Functions, Packages, Cursors, Collections (Nested tables and Arrays),Records, Object types and Database Triggers.
• Proficient in Oracle utilities and tools - SQL*loader, Export/Import, TOAD 8.0/8.5/9.0, SQL*plus, ISQL*plus, SQL Developer and SQL Navigator.
• Expertise in generating customized Forms and Reports using Oracle Forms and Reports 6i/9i.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques and Indexes.
• Profound experience in Tuning SQL queries using utilities like EXPLAIN PLAN, SQL Trace and TKPROF to improve the performance.
• Strong experience in Oracle ETL data loading techniques like UTL FILE, SQL loader, Copy Command and External tables from various business source environments.
• Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team.

TECHNICAL SKILLS

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

Scripting: SQL, PL/SQL, UNIX Shell Scripting

Languages: C, C++, JAVA, HTML/DHTML, XML.

Reporting Tools: Business Objects, Crystal Reports

ETL Tools: UTL, TKPROF and SQL* Loader

Query Tools: TOAD, SQL Developer, SQL* Plus, iSQL* Plus.

Operating Systems: Windows 2000/NT/XP/7/98, MVS and UNIX.

GUI: Developer 2000-Forms 6i/9i, Reports 6i/9i.

Packages: Microsoft Office Suite-MS-Word, MS-Excel, MS-Power Point.

Other Tools: PVCS, Beyond Compare, VB Scripts, SQL* Loader, MS-Visio, MS Project Professional 2003, VSS.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr PL/SQL Developer

Responsibilities:

• Development of database objects (Tables, Procedures, functions, packages, triggers, views, materialized views and cursors) using Oracle SQL/ PLSQL.
• Work closely with CVS BA team to understand the business requirement and create Functional document
• Involved in the Analysis of the Work order and create a detailed design document and writing pseudo Code for it
• Involved in creating unit test cases and write VB scripts to create the batch scripts and upload the code using PVCS in the different environment.
• Creating Nimsoft tickets after the code check-in and support UAT and SIT testing team.
• Involved in maintaining and supporting the production issues.
• Worked on many mini projects like MAM Extract modification, MAM File Payment structure updating, RXClaim feed structuring, Automating the batch process to handle Configuration Load, enhancing HBA framework to handle error routines
• Working with CVS to remove all the previous references and conditions to exclude legacy Best data.
• Extensively used SQL Loader, TKPROF and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
• Involved in debugging and tuning the PL/SQL code, tuning queries, optimization for the Oracle database using Explain Plan, hints and also worked on Partition tables using Range method.

Confidential, Chicago, IL

PL/SQL Developer

Responsibilities:

• Developed ETL for Data Extraction, Data Mapping and Data Conversion for various application and processes
• Participated in client requirement sessions to analyze and gather business requirements.
• Involved in the Analysis, Design, Coding and Testing of the application and participated in discussion meetings about requirements
• Involved in logical and physical database design.
• Involved in migration to FACETS and Implementation, involved in end to end testing of FACETS Billing, Enrolment, Claim Processing and Subscriber/Member module.
• Used FACETS Analytics for fast and easy retrieval, display and grouping of information by writing proficient queries and creating reports.
• Responsible for validating the CR and PR and impact assessment and providing development estimations
• Configured member and group level benefits and contract configuration in FACETS.
• Worked on Member Management, Eligibility, Claims and Billing modules within FACETS.
• Modified and updated existing Forms to adapt to new database schema and to interact with the data tables. Developed Triggers to implement the data constraints
• Customized existing Reports and developed new Reports to suit client requirements. Also created the test scripts for the generated final Reports
• Performed optimal query mechanism to avoid deadlocks and blocking and also troubleshooting them if they do occur and continuous enhancement, optimization and fixing of problems
• Discussions with the business user and getting Change Requests (CR) and Problem Reports (PR).

Confidential, Chicago, IL

PL/SQL Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data Loading Process and Reporting systems.
• Designed and developed a huge database of 120 tables and its data load process from flat files and also designed complex functional views for Payroll application.
• Extensively used SQL Loader, UTL FILE and External Table mechanisms to load legacy data, feed files data and data from various sources into the Oracle database tables
• Designed and developed the Packages, procedures, functions efficiently in loading, validating and cleansing the data. Also worked on creating users and roles as needed for the applications.
• Extensively used UTL SMTP and windows blat techniques to develop the monitoring processes to automatically notify the source systems, administrators and users through email alerts on missing feed files, unsuccessful job runs and load status of scheduled lo
• Created Cursors, Collections and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Worked on Performance tuning using the Partitioning and indexing concepts (Local and Global indexes on partition tables).
• Involved in Performance testing, User Acceptance testing of the application and participated in Code and Design Reviews, Status meetings and Walkthroughs.
• Involved in continuous enhancement, optimization and fixing of problems.
• Provided technical support to the user with regard to operational aspects.