SUMMARY

• Over 11 years of experience in IT industry mainly in design, development, implementation, testing, production support and documentation of business applications using Oracle/Unix.
• Strong technical expertise in ORACLE SQL and PL/SQL.
• Having experience as Application DBA.
• Good knowledge in Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• Strong Coding, debugging skills, troubleshooting & problem analysis skills proven under high - pressure environments.
• Rich Experience in developing PLSQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Objects, Materialized views, Exception Handling, Advanced PL/SQL and good in Performance/Tuning.
• Strong in using tools such as TOAD, SQL*Plus, SQL developer, PL/SQL developer.
• Tuned SQL queries using EXPLAIN PLAN, optimizer Hints and TKPROF utility, Indexes and performed refinement of the database design leading to significant improvement in system response time and efficiency.
• Experience in ETL, data extraction, data migration and data loading using Export, Import, SQL*Loader and Toad Data Point Utilities.
• Experience in Shell scripting, OOPs concepts, Core Java, JSP, JavaScript, XML and Web services.
• Well experienced in developing the efficient Data Models, ER Diagrams, Data integrity and organizing the data as per the Business requirements.
• Good knowledge in Relational Databases (RDBMS).
• Self motivated team player with excellent communication and interpersonal skills with the ability to manage responsibilities individually or as part of a team environment.
• Ability to quickly master new software and adapt to changing needs.
• Provided support all through the System Integration Testing and User Acceptance Testing phases.
• Worked as production support independently and resolved many production tickets on time without any escalations
• Experience working on Onsite/Offshore Model.
• Experience working in Telecom, Insurance and Banking Domains.
• Experience in Agile and Waterfall Development approach.

TECHNICAL SKILLS

Operating Systems: O/S Concepts, Windows 98/2000/XP/NT, MS-DOS, Unix

Programming Languages: SQL,PL/SQL,Oracle 11g/10g,C, JAVA, JSP,Java Script,Webservices,XML, Unix Shell Scripting,UML

Design tools/ CRM Tools: Chordiant, E-CAD (PSpice), MATLAB

Telecom Products: Kenan Arbor, Metasolv

Configuration Management Tools: ClearCase,VSS, WinCVS, Serene Dimensions, CVS

Object Modeling Tools: ERwin, Rational Rose

SDLC: Extreme Programming (XP), Waterfall

Application Servers: BEA Weblogic 10.1

IDE: Eclipse

Special Software/Tools: Caliber, HP Quality Center, Remedy

Data Warehouse Tools: Informatica

PROFESSIONAL EXPERIENCE

Confidential, Dublin, OH

Analyst

Responsibilities:

• Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Understanding the systems involved in data conversion to do backfill.
• Discuss with business users in mapping the data from source to destination systems.
• Involved in Designing schema and schema objects.
• Involved in Extraction, Loading and Transformation process of data.
• Have written PL/SQL scripts required for migration
• Worked effectively in hectic schedules with extended hours and weekend support as and when required
• Onsite -Offshore coordination
• Provided process improvements, proactive solutions, value additions to the customers.
• Have been proactive in taking the initiatives and have been primary POC for data design of conversion project.
• Worked extended hours and provided weekend support whenever required.

Environment: Oracle SQL/PL SQL, PL/SQL Developer, TOAD, UNIX shell scripting, HP Quality Center, Caliber

Confidential, Dublin, OH

Technical Lead/Senior Developer

Responsibilities:

• Discuss with business users in creating and refining business requirements.
• Analyze IT requirements, prepare high level and low level technical design documents.
• Involved in estimation, high-level design, detailed design, and coding and testing phase of the project.
• Developed UI pages using JSPs, UI validations using JavaScript
• Developed Webservices using Weblogic web services frame work.
• Developed PL/SQL code to implement business rules using cursors, ref cursors, procedures, functions, Triggers, object types, collections, Dynamic PL/SQL and packages.
• Performance tuning-Using optimization techniques to minimize the execution of the SQL queries.
• Used Explain Plan in tuning queries.
• System Test and UAT Defect resolutions
• Handled Production issues with high pace and efficiency.
• Wrote Queries to retrieve data in XML format from the tables.
• Worked effectively in hectic schedules with extended hours and weekend support as and when required
• Onsite -Offshore coordination
• Provided process improvements, proactive solutions, value additions to the customers which generated revenue growth
• Have been proactive in taking the initiatives and have been primary POC for support of production deployments
• Worked extended hours and provided weekend support for UAT whenever required.
• Worked as production support independently and resolved many production tickets on time without any escalations.

Environment: Struts framework 1.2, JSP, Java Script, XML, XSD, Weblogic Server 10.1, Webservices, Oracle SQL/PL SQL,PL/SQL Developer, TOAD, Eclipse IDE, Ant, Serene Dimensions, Unix shell scripting, HP Quality Center, Caliber.

Confidential, Dublin, OH

Technical Lead/Senior Developer

Responsibilities:

• Involved in defining system requirements, designing & prototyping, developing, testing, training and implementation of the applications
• Analyze IT requirements, prepare high level and low level technical design documents.
• PLSQL Code development and Unit Testing of ITRs
• Developed PL/SQL code to implement business rules using cursors, ref cursors, procedures, functions, Triggers, object types, collections, Dynamic PL/SQL and packages.
• Involved in data mapping and populating database tables using SQL * Loader
• System Test and UAT Defect resolutions
• Performance tuning-Using optimization techniques to minimize the execution of the complex SQL queries.
• Created database tables, database objects, Indexes, Synonyms, grants.
• Onsite -offshore coordination
• Handled Production issues with high pace and efficiency.
• Optimized existing queries for better performance and less impact on database and used Materialized views in places where the data does not change very frequently
• Generated many reports using SQL queries and materialized views.
• Provided process improvements, proactive solutions, Value additions to the Customers which generated revenue growth
• Have been proactive in taking the initiatives and have been primary POC for support of production deployments
• Worked extended hours and provided weekend support for UAT whenever required.

Environment: Oracle 11g,Unix,PL/SQL Developer, TOAD, Serene Dimensions, ER Win Data Modeling tool, Unix shell scripting, HP Quality Center

Confidential

Oracle PL/SQL Developer/ Application DBA

Responsibilities:

• Involved in defining system requirements, designing & prototyping, developing, testing, training and implementation of the applications
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Extensively worked on oracle objects such as Tables, views, synonyms, Object Types, Collections and involved in developing the Database objects.
• Wrote Packages, Stored procedures and functions for accessing, inserting, modifying and deleting data in the database from GUI.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Developed PL/SQL code to implement business rules using cursors, ref cursors, procedures, functions, Triggers, object types, collections, Dynamic PL/SQL and packages.
• Used Global temporary tables for processing DML operations on huge data from GUI at one time.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Handled Production issues with high pace and efficiency.
• Developed Queries to retrieve data in XML format from the tables.
• Worked on shell scripts in Unix environment
• Provided process improvements, proactive solutions, Value additions to the Customers which generated revenue growth
• Have been proactive in taking the initiatives and have been primary POC for support of production deployments
• Onsite -offshore coordination
• Worked extended hours and provided weekend support for UAT whenever required.

Environment: Oracle 10g, PL/SQL, TOAD,PL/ SQL Developer, UNIX, CVS, Serene Dimensions, Unix shell scripting, ER Win modeling tool,HP Quality Center

Confidential

Developer

Responsibilities:

• Created the Entity Relationship(ER) diagram by using Rational Rose and UML.
• The ER represents the data required to support particular Use Cases.
• Once the ER is viewed as complete for the use case it will be assessed against the existing Out Of the Box (OOTB) Chordiant object model to determine what changes and extensions need to be made to create the Sawgrass Business Object Model (SBOM).
• During the entire process will be in close contact with both the business and development areas to ensure proper understanding of the steps taken and resulting SBOM
• Conversion module deals with converting the data from the backend systems (IBS, FDR) to the Oracle database, which needs to be created
• Analyze/Map the data elements between IBS/FDR and Chordiant based on Use case requirements.
• Make appropriate changes to Oracle data structures based on detail design.
• Mainframe data needs to be extracted, transformed and loaded to Oracle database.
• Data in the Oracle database should be in sync with the IBS database as UCSS desktop. Users can change the information on IBS database.
• Data to be synched up on a regular basis.

Environment: UNIX, Oracle 9i, TOAD, PL/SQL, JAVA, Chordiant, Rational Rose, Clear Case

Confidential

Oracle Developer

Responsibilities:

• Developed the current version of the tool using the technology - Visual Basic for Applications (VBA) with Oracle 9i, where in Inputs captured from users (through Excel sheets) are posted to Arbor, Metasolv, TIBCO and CRM systems using Macros and various PL/SQL procedures.
• Developed automation tools for configuration that reduced delivery time by 60%.
• Performance improvisation in this tool is achieved using effective PL/SQL procedures that dump data into the respective systems automatically as soon as the user gives inputs (which are also minimized).
• Designed Script Generation Tool, which reduced production movement time by 75%. Program is written using VB 6.0.
• Tested functionalities, configurations and provided fixes, solutions. Products used are Kenan Arbor (Billing) & Metasolv solutions (provisioning).
• Provided Technical support for Package Configuration Tool (PCT 3.4) in billing team.
• Assisted in coding of Report generation Tool.
• Supported production and UAT activities ensuring better customer satisfaction.

Environment: VB, UNIX, SQL, PL/SQL, TOAD, MS-VSS, PL/SQL Developer, Kenan Arbor Billing

Confidential

Oracle Developer

Responsibilities:

• Understanding user requirements and Impact analysis
• Prepared requirement specifications, Use Cases and Test plans.
• Design and construction of different front-end forms using XSL, XML.
• Have done many enhancements to the existing front-end forms.
• Code development, Walkthroughs and Testing.
• Technical documentation /User Manual preparation.
• Involved in the design, development and testing of the data migration scripts.

Environment: UNIX, XML, XSL, Java, JDBC, Oracle 9i, MS-VSS, PL/SQL Developer, TOAD