PROFESSIONAL SUMMARY:

• A result oriented systems Analyst with 13+ Years of experience in IT covering Analysis, Design, Execution, Support and Maintenance of projects across Retail/Banking/Telecom/Healthcare domains with various reputed organizations.
• Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Dbase Management System (RDBMS).
• In depth knowledge and Experience on Health care data, claims and Confidential .
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Expertise in Client - Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Created Tables, Views, Constraints, Index and Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Partitioned large Tables using range partition technique.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experiences in creating Shell Scripts for invoking SQL scripts and proficient with Unix commands.
• Experience in Data Analysis and Reporting including hands on experience with the Reporting tools such as IBM Varicent-Cognos.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

TECHNICAL SKILLS:

Databases: Oracle 8i/9i/10g/11G (SQL, PL/SQL ), MS SQL SERVER 2000/2005/2008.

Operating Systems: UNIX(LINUX, HP UNIX ), Windows NT/98/95/2000 & Windows XP.

Languages/Utilities: SQL, PL/SQL , Shell Scripting, Pro*C, HTML, ASP, VB/JavaScript.

Other Tools: Maestro Job scheduler, PVCSand IBM-Varicent/Cognos

PROFESSIONAL EXPERIENCE:

Confidential

Oracle and SQL Server Senior Database Developer

Responsibilities:

• Develop Confidential Measures (certified by NCQA), P4P(certified by NCQA), State measures(State specific submissions) and CMS ACO measures, Custom measure requirements from different sets of clients.
• Support and maintenance of database coding for Oracle 10g/11g and SQL Server R2 Databases.
• Work with Product management team, Business analysts, client services and DBA’s to ensure that development efforts are elegant, user friendly and cohesive.
• Analyze, design, develop and test ad hoc reports on request basis.
• Propose new architectural changes, enhancements, tips, and best practices.
• Follow Scaled agile framework methodology to plan work.
• Manage multiple projects simultaneously.
• Documenting and implementing changes with new enhancements.
• Responsible for production support/ automation, development activities, test results and implement resolution for any integration issues and providing bug fixes.
• Helped training the team on different areas of software.

Confidential, MN

Oracle PL/SQL Developer& Production Support

Responsibilities:

• Coordinated with the upstream systems and front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various channels.
• Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Developed PL/SQL triggers and master tables for Auditing purposes.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning with the help of DBA team using like EXPLAIN PLAN, SQL*TRACE.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Partitioned the staging tables to enhance the performance and also introduced purging logic.
• Performed modifications on existing form as per change request and maintained it.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g, SQL* Plus, TOAD, SQL*Loader, Retek 9i (RESA), Shell Scripts, UNIX & Pro*C.

Confidential, MN

Production Support/Maintenance and Enhancements, SQL Developer

Responsibilities:

• Coordinated with the upstream systems and made continuous improvements around job runtime and their dependencies.
• Created SQL Scripts to Archive and Purge the transactional data for the fiscal period closed by business team.
• Identified Index required on Transactional tables and created the same to gain optimal performance on the outbound jobs.
• Automated SQL reports called through Unix Shell script delivered to support team and business on daily reconciliation of data across careers viz AT&T, Sprint and Verizon.
• Created VBScripts to report out the daily transactions count and $ Commission amount to the business team via automated email.
• Quickly learned the nuances of third party application and was able to customize the application as per the client requirement with very minimal support from vendor.

Environment: MS SQL Server 2008, SQL Server Management Console, IBM Varicent-Cognos, VBScript, Windows, WeDO-RAID Application, Shell Scripts, SQL Loader and UNIX.

Confidential

Oracle PL/SQL Developer& Production Support

Responsibilities:

• Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Developer.
• Created management analysis reporting using ParallelQueries and also participated in change and code reviews to understand the testing needs of the change components. Worked on troubleshooting defects in timely manner.
• Involved in creating UNIX ShellScripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Performed modifications on existing form as per change request and maintained it.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target datastructures.
• Involved in the continuous enhancements and fixing of production problems.
• Proactive maintenance and support of Retek system and deliver quality solutions in response to varying business enhancements.
• Responsible for managing scope, planning, tracking of project enhancements delivered.
• Ensure ticket backlog is Zero and awarded by client for zero Job abend for a month.

Environment: Oracle 10g, SQL* Plus, TOAD, SQL*Loader, Retek 9i (RMS), Shell Scripts, UNIX & Pro*C, Forms and Reports.

Confidential

Oracle PL/SQL Developer& Production Support

Responsibilities:

• Understand the business requirements and translate into Functional and Technical Design document.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart after applying business rules and required calculations.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 10g, SQL* Plus, TOAD, SQL*Loader, Shell Scripts and UNIX.

Confidential

Oracle Database programmer/Analyst

Responsibilities:

• Worked in Production Support Environment as well as DEV/QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data from SQL server database to Oracle database.
• Wrote sequences for automatic generation of unique keys to support primary and foreign keyconstraints in data conversions.
• Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures.
• Implemented 9i and upgraded the existing database from Oracle 8i to Oracle 9i.
• Involved in Logical & Physical Database Layout Design.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Provided user training and production support.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links

Environment: Oracle 8i/9i, SQL* Plus, TOAD, SQL*Loader, Java and JavaScript.

Confidential

Oracle Database programmer/Analyst

Responsibilities:

• Worked in Production Support Environment as well as DEV/QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements and data fixes.
• Study on existing system and involved in preparation of system requirement specification.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Created numerous complex reports to serve the business day-to-day needs.

Environment: Oracle 9i, SQL* Plus, TOAD, SQL*Loader, Java and JavaScript.

Confidential

Oracle Database programmer/Analyst

Responsibilities:

• Study on existing system and involved in preparation of system requirement specification.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Created numerous complex reports to serve the business day-to-day needs.

Environment: Oracle 9i, SQL* Plus, TOAD, SQL*Loader, Java and JavaScript.

Confidential

Database programmer and Front End Developer

Responsibilities:

• Study on existing system and involved in preparation of functional design and technical design documents phase by phase.
• Created various front end screens using .NET 1.1 Framework.
• Created scripts to create new tables, views, queries for new and enhancements in the application using TOAD.
• Various regulatory forms were stored in Database and pulled to the front end screens via packages.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Created numerous complex reports to serve the business day-to-day needs.

Environment: Oracle 9i, SQL* Plus, TOAD, SQL*Loader, ASP.net, JavaScript and CSS.