SUMMARY

• Over 7 years of extensive IT experience emphasizing planning, analysis, design, documentation and testing of software applications.
• Worked as a Senior Developer in Oracle11i and SQLServer2005 technologies.
• Worked in different domains like Logistics, Telecom and Insurance.
• In - depth knowledge and strong programming skills in PL/SQL and SQL.
• Experience in developing batch jobs in Oracle.
• Excellent experience in Oracle 10g/9.x/8.x/7.x development using PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views, Oracle Objects.
• Good knowledge of enterprise data warehouses.
• Knowledge of ETL tools like Informatica.
• Excellent experience in all phases of SDLC in Agile, SCRUM, traditional and Waterfall methodology.
• Performed business analysis as part of core team responsible for conceptualization and development of systems.
• Hands on experience in designing and implementing solutions for business functionalities.
• Experience in cause and effect analysis of bugs in PL/SQL code.
• Experience in designing applications from scratch and reengineering using UML
• Very good knowledge of data modeling, data analysis, data standardization, data clean up, data consolidation and designing database schema.
• Exceptional ability in gathering user requirements and documenting them as functional specifications and Use Case documents.
• Excellent skills in documenting metadata required for the application.
• Involved in designing, developing and configuring processes, technologies and performance measures.
• Extensive experience in Client/Server Architecture, design and development of User Interfaces and Customization of Forms and Reports based on the user requirement using Oracle Forms and Reports.
• Experienced in file loading using SQL Loader, file manipulation and emailing capabilities of Oracle using in-built packages.
• Expert in optimizing database performance, resource use, and physical implementations of databases, addressed variety of database integration issues including migration between disparate databases, integration, maintenance / conversion, capacity planning issues, and new applications.
• Involved in documenting designing and development phases of the project and database for future references.
• Result-driven, self-motivated Business Analyst with proven ability to work in a team-based and challenging environment.
• Experienced in communicating and working with diversified groups.
• Quick learner and excellent team player, ability to meet tight deadlines and work under pressure.
• Excellent written, verbal communication and analytical skills.

TECHNICAL SKILLS:

Databases: Oracle11i, SQLServer2005,DB2, MS-Access

SQL Tools: Toad, PL/SQL Developer

Reporting Tools: Forms builder 9i/6i, Reports builder 9i/6i, ERWIN, Oracle Discoverer 6i,Crystal Reports, Informatica, Oracle Forms 10g/6i, Oracle Reports 10g/6i

Languages: SQL, PL/SQL, C, C++, Java

Operating Systems: Windows 7 and LINUX

Other Tools: VISIO, Eclipse.

Scripting Languages: HTML, DHTML, JavaScript, XML

Technologies: OODBMS, OOAD, OOPS, RDBMS

PROFESSIONAL EXPERIENCE

Confidential, Austin, TX

Senior Developer

Responsibilities:

• Analyzing and developing of system requirements based on information obtained from operations and management.
• Creating technical detail design document based on system requirements.
• Performing Impact analysis for both different kind of SR’s that are being implemented (Maintenance and Modifications).
• Designing, Coding enhancements and customizations to the application in accordance with the System requirements.
• Wrote technical documentation for the proposed changes in the application.
• Developing Eligibility Module using PL/SQL packages, procedures and functions.
• Performed new systems development and maintenance using Oracle forms 10G.
• Designing and developing of forms using Oracle forms 10G and Forms Builder.
• Designing of prototypes for the new income module, Prototype demonstration to the user and obtaining the approvals for the newly designed prototypes.
• Responsible for developing stored procedures, functions, custom packages and new reports using Oracle Discoverer 10g.
• Enhanced the existing packages of the application by adding new procedures and new business logic accordance with the prevailing standards of the application using Oracle Designer.
• Wrote new pl/sql packages, procedures and corrected the existing packages of the application in accordance with the prevailing standards of the application using Oracle Designer.
• Development of the new forms using the prototypes and synching the existing back end code to the new Forms.
• Created Indexes and partitioned the tables to improve the performance of the query.
• Evaluating and tuning the performance of the new code which gets implemented
• Performance tuning of the pl/sql Programs that are identified as the bottle neck for the application performance.
• Work with peer engineers and programmers to design system and to obtain information on project limitations, capabilities, and performance requirements and perform data modeling.
• Performed technical documentation, unit testing, integration testing and writing test plans.
• Testing the application at the development (Unit Testing) and System Level (Application System Testing)
• Responsible for reviewing code, test scenarios and design documents created by team members.
• Created the Process flow diagrams for each function on the schema using the MS Visio.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Used UML to create data model diagrams.
• Prepared the technical documentation and user support documents.
• Analyzed and designed UML model to reflect existing business models.

Confidential, Atlanta, GA

Developer

Responsibilities

• Participated in all phases of development like System Analysis, Design, Coding, Development and Implementation and provide support to existing client databases.
• Developed backend processes using SQL, PL/SQL and dynamic SQL to create Oracle Objects, Stored procedures, packages, and triggers.
• Profoundly worked with high-performance PL/SQL features such as REF Cursor, Composite Data Types such as Records, Collections, Bulk Collect and Autonomous Transactions.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, V arrays, Records, Materialized views, Dynamic SQL.
• Extensively wrote SQL Queries (Sub queries and Join conditions, correlated sub queries).
• Developed scripts to migrate data from flat files to target tables performing required validations on the data using ETL.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Well-versed in writing Ad-hoc Queries using bind variables and error handling to improve query performance.
• Provided Performance tuning and performance analysis for large oracle data warehouse for partitioning, scalability and monitoring.
• Extensively used QUEST Tools TOAD, SQL*PLUS, SQL * Loader & utilities such as UTL FILE and UTL MAIL in packages to interact with system files, generate HTML, and send mail.
• Involved in creating documentation for the project for future reference as well as for client references and training.

Confidential

Developer

Responsibilities:

• Consolidating functional requirements, creating LLD documents of the module based on interactions with client.
• Creation of stored procedures to implement core business logics in account receivables and payables sub modules.
• Creation of stored procedures to generate reports.
• Done Interfacing of external system with Oracle Financials module.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links.
• Actively involved in performance tuning task force team, fine-tuning all the affected processes, which would have High I/O Cluster, waits, Poor Explain Plan, High CPU Cost. Reviewed (by generating trace files, explain plans etc) and modified (or redesigned) the existing programs to drastically increase the performance.
• Created Shell Scripts for Host Concurrent programs and migration scripts for code deployment.
• Customized the existing LOV's (Created/Modified several value sets).
• Create and modified existing forms for new Business rules.
• Internal code reviews.
• Taking module functionality introductory sessions.
• Taking project internal PL/SQL training sessions for trainees.
• Created several reports using Oracle Reports 6i.

Confidential

Programmer

Responsibilities:

• Wrote new pl/sql packages, procedures of the application in accordance with the prevailing standards of the application using Oracle Designer.
• Enhanced the existing packages of the application by adding new procedures and new business logic accordance with the prevailing standards of the application.
• Performed Data Analyst role, to analyze the data and to clean the DB schema.
• Developed Database objects like Views, Materialized Views, Indexes, Sequences, and Synonyms.
• Wrote shell scripts to process PL/SQL procedures and wrote PL/SQL program units for data extracting, transforming and loading
• Fine-tuned, the SQL queries in order to improve the overall system performance
• Taking logical backups using export at object and schema level to save space and reduce fragmentation in your database.
• Wrote UNIX shell scripts to encrypt flat files that are created by Oracle Job’s and to upload FTP the flat files to the designated server.
• Tuning application using tools like Explain plan, SQL*Trace and TKPROF for high efficiency.
• Wrote new procedures, which are triggered by UNIX shell script to process the staging data and do the required process.
• Performed exception handling for data that did not conform to the required format.
• Aided developers in writing efficient code and making efficient use of the resources leading to better performance and optimization.
• Testing and Implementing enhancements and solutions.
• Support for the development, pre-production and the production databases.

Confidential

Programmer

Responsibilities:

• Written PL/SQL Stored Procedures, Functions and Packages and Triggers to implement business rules into the application.
• Developed SQL queries and PL/SQL stored procedures to systemize the warehouse operations.
• Used Toad to Extract and test the data in the database.
• Create and modified existing forms for new Business rules.
• Developed new reports to generate reports based on the new business logics.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links.
• Performed Fine Tuning of SQL, PL/SQL Procedures.
• Performed Unit testing for the Developed component.
• Wrote Ad-hoc Queries using bind variables and error handling to improve query performance.
• Used DBMS PROFILER package to understand where the code is spending the most time, detect it and then optimize it.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, used these tools with EXPLAIN PLAN.
• Created the Process flow diagrams for each function on the schema.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Prepared the technical documentation and user support document.

Confidential

Programmer

Responsibilities:

• Participated in meetings to gather functional and non-functional requirements from the clients.
• Involved in system analysis and developed requirement catalog.
• Participated in developing Entity-Entity Matrix, Logical Data Model and Data Flow Diagrams.
• Extraction of data from source systems through Excel and Flat files, loading in to the data mart tables for report needs.
• Created Tables & Views and referential integrity constraints using SQL and wrote Database Triggers, Procedure & Functions using PL/SQL.
• Created index on all key fields and analyzing tables is done to reduce query return times. Materialized views are created in many cases for frequent refreshes of data and also to improve performance.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS (Native Dynamic SQL).
• Developed Menu Model Diagrams and Input/output structures for the data entry screens.Involved in developing the Process Model Diagrams to represent the Issue Tracking System in an Organization.
• Developed program specifications and test plans based on the logical program specifications.
• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle9i as back-end.
• Designed and developed Web-enabled Oracle Forms & Reports including Forms based on stored procedures.
• Developing program specification documents for the module and maintaining versions of the documentation.
• Reviewing the test cases developed based on the program specification and documenting the errors in the test cases.
• Thorough testing and debugging of the forms and reports developed.
• Integrity testing - testing the forms by integrating them with the module as well as other modules of the project.
• Assisted in setting up the Forms and Reports Services on 9i and 6i AS.