SUMMARY

• 7 years Experience in System analysis, Design, Programming, Testing Support of applications using Oracle 11g/10g/9i/8i database.
• Solid knowledge of SQL and PL/SQL programming and the ability to write and execute complex queries with large, complex data sets.
• Working experience in MS SQL Server and T-SQL programming with knowledge of designing SSIS packages using SSIS.
• Involved in all phases of the Software Development Life Cycle from Technical Research, Requirements analysis, Design, Development, Testing, and Support with focus on Performance Tuning and Quality Assurance.
• Strong knowledge and Experience developing PL/SQL Stored procedures, Functions, Packages, Database Triggers, Cursors, Exception Handlers, Materialized views, Views.
• Experience using Oracle database utilities like SQL plus, SQL Loader.
• Extensive experience using tools like TOAD and SQL Developer.
• Extensive experience developing custom forms and reports using Oracle Forms and Reports Tools.
• Experience using EXPLAIN PLAN, SQL Trace and TKPROF for SQL tuning and diagnostics.
• Good knowledge on relational database management RDBMS concepts and experience using ERWIN and Microsoft VISIO to model data using ER Diagrams, UML, Use Cases to better visualize and design the project requirements.
• Experience handling on call Production Support, receiving critical calls, troubleshooting the applications and resolving bugs in short time frames.
• Hands on experience and knowledge writing UNIXshellscripts.
• Experience interacting with business analysts and customers for requirement gathering, analysis and development of technical design specifications.
• Created and maintained system documentation, including technical specifications, operation manuals, unit and integration test cases/results and data mappings.
• Ability to work independently or in a team focusing on prioritizing various tasks and planning ahead to buffer unforeseen circumstances.
• Flexible, motivated, and a committed individual with good communication skills and strong aptitude to learn new technologies.

TECHNICAL SKILLS

EDUCATION

Bachelors in Computer Science and Information Technology. JNTU, Hyderabad.

INDUSTRY EXPERIENCE

Confidential

Oracle PL/SQL Developer

Project Description: The project deals with the process of revenue generation of the healthcare provider. It includes supporting the services like patient access, billing, and charge description and denial management. The required data is stored to database while updating balances and claim status accordingly. UNIX shell scripting is used for the automation of the processes used to update database.

Responsibilities:

• Participated in Design, Coding, Development and Implementation
• Involved in the creation of tables necessary for application
• Developed SQL Queries Sub queries, correlated sub queries and Join conditions .
• Worked on Stored Procedures, Functions and Packages.
• Use TOAD developer tool for faster application design and developments.
• Translating business rules into procedures, packages, database triggers and functions using PL/SQL.
• Worked in Unit testing PL/ SQL Stored Procedures and Functions.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Prepared Test Plans and participate in unit testing, system testing, thru production implementation.
• Worked on business requirements and functional specifications.
• Developed and tested reports using Crystal Reports

Environment: Oracle 10g/9i, Pl/SQL, SQL Loader, Java, Toad, SQL Developer, UNIX shell scripting, crystal reports.

Confidential

Oracle PL/SQL Developer

Project Description: The Confidential assets based on location are designed, managed, utilized, planned and disposed by the Enterprise portal called Integrated Workplace Management Systems IWMS . The system helps in the optimization of resources like real estate portfolio, infrastructure and facilities.

Responsibilities:

• Developed automated data extraction scripts from database to flat files and transfer to specific file systems over ftp.
• Used MS Visio to create/document data flow charts of the entire application portal.
• Developed adhoc queries to handle the system's exception workflows.
• Developed stored procedures thereby ensuring parameterized adhoc queries and better performance.
• Used a variety of built-In PL/SQL packages to efficiently code/enhance the user defined packages for exception handling, file handling.
• Provided production support/System testing support by writing complex SQL queries for data validation, data loads to downstream systems.
• Created packages to handle custom exception scenarios due to bad data and write the trace to error log files to be reviewed later.
• Used Oracle Reports to generate optimization reports that were sent out to planning committee.

Environment: Oracle 10g, SQL Plus, SQL Navigator, SQL Loader, MS Visio, Oracle Utilities

Confidential

Oracle developer

Project Description: Confidential environments providing utilities to collect drug and vaccine data are maintained by Clinical Information Services. Data warehouse contains the data loaded from these collection systems. For analysis of the Business Intelligence reports, the access is given to the statisticians.

Responsibilities:

• Participated in design, documentation, development, implementation and testing.
• Involved inPL/SQL package coding, requirement documentation, testing analysis, and project timeline creation.
• Work with the backend part migrating various database applications to incorporate the changes in the newrelease of applications and hardware changes.
• Prepare guidelines for tuning of application code and assist the team, Workedwith the Manager of Unix and Database Systems, performance tuning of heavy transaction oriented SQL statement.
• Used Qwest tools Toad 8.0, SQL Navigator for database monitoring and tuning.
• Developed batch programs for data load using SQL Loader, DTS and shell scripts.
• Gathered customer interactions and designed functional model of schema
• Wrote database triggers and procedures.
• Used PL/SQL procedures and functions in packages to organize application.
• Used PL/Sql Exception Blocks forTrapping Exceptions, Trapping Predefined Oracle Server errors.
• Involved invalidation, Unit Testing, UAT, System Testing

Environment: Oracle 10g/9i, PL/SQL, SQL Plus, SQL Loader, Unix shell scripting, Erwin 4.0/3.5.2, DB2, MS-Excel, MS-Access, XML, Flat files, Windows NT.

Confidential

MS SQL Developer

Project Description: Confidential is a leading full-service outsourcing provider to the global financial industry, capable of meeting the most demanding requirements for efficient, secure and scalable operational support.A suit of workflow products for brokerage operations is designed by Confidential product assists customers to transfer their assets from one brokerage firm to another.The firm becomes ACAT eligible firm when it is a member of NSCC.

Responsibilities:

• Used SQL Server 2005 for DB design.
• Created SSIS Packages to parse flat files with variable length coming from NSCC.
• writtenComplex Stored Procedures and Queries.
• Optimized stored procedures for better performance.
• Created SQL Jobs and Scheduled as per the requirements.
• Backup/Restore between different environments
• Written documentation like guides and Implementation plans.
• worked in analyzing and fix the issues on time.
• DevelopedStored Procedures, explaining the Data Model and Maintained Data Dictionary.

Environment: Visual Studio 2005, HTML, XML, SQL Server 2005/2008, SSIS, SSRS, Power Point, Excel

Confidential

Software Engineer

Project Description: The purpose of Audit Inspection and Management System is to support the development and management of audit programs in GSK. The WWRC AIMS project adds to this existing implementation by providing functionality needed by WWRC. It implements customized on-line and off-line forms , Data Mart constructed and maintained to provide a source a data for management reports and metrics, a series for forms built to provide a user-oriented front-end to the AIMS Data Mart, WWRC end-users have ability to generate Audit Plans and Audit Reports in PDF format.

Responsibilities:

• Assisted in analysis, design, development, and testing of the application.
• Documentation of the product features.
• Use TOAD developer tool for faster application design and developments.
• Understood the Workflow of WWRC Audit Inspection Management System
• Front end validations usingJava Scripting.
• Developed Management Reports using PL/SQL which deals with extracting the data from the WWRC Datamart.
• Implemented Role based Authentication.
• Involved in Unit Testing and Integration Testing.

Environment: Oracle 9i, PL/SQL,Net Beans 5.0, Toad, CS-RCS, Eclipse, Dream Weaver, JavaScript,Windows XP, Net Beans 5.0.