SUMMARY

• Around 8 years of experience in Analysis, Design, Requirements Gathering, Production Support, Performance Tuning, Trouble - shooting and Maintenance of databases.
• Excellent skills in Design and Development of applications using Oracle Database 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms & Reports 10g/9i/6i.
• 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.
• Experience in ETL Architect/Designer, Relational Database applications design, development and Support on UNIX.
• Experience in developing the webpage using JSP, extensive experience on Java, Java script, Hibernate.
• Extensively developed PL/SQL code using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data and enforcing referential integrity.
• Experience in using tools like TOAD, PLSQL Developer, and SQL Developer.
• Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.
• Experience in designing data models using Erwin and Visio.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques
• Experience in architecture design of Extract, Transform, Load environment using Informatica Power Mart and Power Center.
• Experience with data warehouse design using Star Schema and Snowflake schema.
• Experience in loading data from flat files to database tables using SQL*Loader.
• Experience in working with UNIX and expertise in UNIX Shell Scripting.
• Strong experience in SQL Tuning using Explain Plan, SQL*Trace and TKPROF.
• Skilled in developing UI using HTML, DHTML, JavaScript, AJAX, JSP, JQuery,Servlets, JSF.
• Well versed with XML, XSL, XSLT, XPATH, SAX, and DOM.
• Knowledge in implementing Service Oriented Architectures (SOA) using XML based Web Services (SOAP/WSDL) and publishing web services using code based and schema based approaches.
• Working Knowledge on testing tools like Win Runner, QTP, Quality center, Test Case manager
• 24/7 on-call support for production
• Ability to work closely with clients to analyze data, determines project requirements, review functional requirements and develop detailed designs to meet requirements.
• Excellent analytical and problem solving skills with strong communication and interpersonal skills.

TECHNICAL SKILLS

Operating Systems: Windows98/XP/2000/2003/NT, DOS,UNIX (Sun Solaris, HP-UX), LinuxDatabase Oracle 11g/10G/9i/8i, MySQL, MS SQL Server,DB2, MS Access 2000

Programming languages: ANSI C, C++, VC++,C#, VB, Java, PL/SQL programming, Pro*C, Unix scripting

Web Technologies: HTML, DHTML, Cold Fusion, AJAX, XML, JSP

Script Languages: JavaScript, Shell, Perl scripting

Tools: Toad, PLSQL Developer, OEM, SQL Navigator, SQL Tools, Erwin

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

ETL: Informatica Power Center 8.1.1

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Oracle Developer

Responsibilities:

• Analyzed System Requirements to create high level and detail design documents with the assistance of requirements team and Architects.
• Worked closely and supported members of teams such as Architecture, Change management, Database Management, Technical operations, System Test, UAT, Requirements and Business teams during entire life cycle of the project.
• Significant use of database technology data warehousing STAR schema, SQL-Loader, Oracle Stored Procedures.
• Involved in intense design and coding in Java and Oracle for web-enabled applications, developing JAVA solutions for client/server applications.
• Custom front-end forms using XML, XSLT, Javascript, VB and proprietary tools, back-end development of enhancements and customizations to the database scripts, triggers, stored procedures and import/export packages.
• Developed a web-based reporting application with some design input and requirements capture using VBScript, Javascript, AJAX, ASP, ADO, HTML, XML.
• Coded in Javascript, Jquery, CSS and DHTML for front-end code.
• Responsible for developing validations scripts (Regular Expression validations, Authentication Validations, Custom Validations using JQuery.
• Developed highly complex applications using Oracle 11g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Used concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.
• Developed Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
• As a key PL/SQL developer, defined the required analytics to design, develop financial routines, and assisted various work streams in identifying, and resolving data irregularities, and establish management reporting processes and requisite supporting technology.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD). Created SQL scripts to perform unit and component testing financial calculations such as, Interest receivables.
• DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.
• Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.
• Developed a Java program for automatic batch loading.
• Handled code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest.
• Performed performance tuning for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.
• Used existing processes and procedures for application deployment and provided 24x7 production support as Primary.

Environment: Oracle 11g/10g, Clear case, Clear quest, Toad 9.5, PLSQL Developer 7, Sun OS 5.8, Windows XP 5.1.2, AB Initio, Java, Javascript, JQuery, HTML, Business Objects, Sql*Loader, DOORS.

Confidential, Arlington, VA

Oracle Developer

Responsibilities:

• Interacted with Business Analysts and Users in requirement gathering.
• Translated user requirements into data flows, detail technical specifications and database requirements.
• Created a custom extraction system that populated a data warehouse star schema.
• Worked as developer for both a web- based application and reporting system built using Javascript, AJAX, HTML, XML, Access.
• Managed implementation and delivery of software project deliverables for documentation, user interface, front-end processing and validation (ASP, JavaScript, HTML, and CSS), back-end DTS packages, database tables, functions and stored procedures.
• Involved in designing and developing Presentation layer (User Interface) using HTML, DHTML, JQuery plugins, Java script.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.
• Developed, modified, and optimized complex queries for data retrieval and modification. Optimized and Tuned SQL Queries by running Explain plans.
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.
• Created tables with complex constraints applicable to the business rules.
• Developed Unix Kshell scripts to extract data from the Production database & refresh the data warehousing application on a daily basis.
• Created tables, Tablespaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes
• Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.
• Data migration and conversion done utilizing Oracle utilities: Export/Import
• Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used
• Involved in writing Perl Scripts for populating data on to WebPages.
• Involved in data load using PL/SQL and SQL*Loader; and cron jobs calling UNIX scripts to download and manipulate files.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
• Involved in Production Support and troubleshooting data quality and integrity issues.

Environment: Oracle 11g, Sun Solaris 10, SQL, Erwin, SQL*Plus, TOAD, SQL*Loader, Java, Javascript, JQuery, Quality Center, Relational Clear Case, Informatica Power Center 8.1.1, SQL Developer.

Confidential, Philadelphia, PA

PL/SQL Developer

Responsibilities:

• Involved in Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.
• Involved in Designing data models using Erwin.
• Developed a web-based reporting application with some design input and requirements capture using Javascript, AJAX, ASP, ADO, HTML, XML, and Access.
• Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements
• Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for better performance
• Developed, modified and optimized complex queries for data retrieval and modification.
• Wrote UNIX shell scripts for automating regular data loading jobs.
• Tuned SQL queries and complex procedures to improve performance
• Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges
• Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica power center 8.5.
• Used SQL* Loader for Data Conversions and to load the flat files from other different sources, from flat files into Oracle database.
• Tuned SQL* LOADER and SQL Scripts to load data faster.
• Used Workflow manager to create Workflows, Worklets and tasks.
• Extensively used Quality center to Run test cases and to report and track defects.
• Used Relational Clear Case for source and version control.
• Involved in Unit Testing for the application.
• Involved in solving day-to-day problems, giving support to the users.
• Provided 24/7 on call production support.

Environment: Oracle 10g, SQL, Erwin, SQL*Plus, TOAD, Quality Center, Sql*Loader, Java, JavaScript, Relational Clear Case, Informatica Power Center 8.1.1, Sql Developer.

Confidential, Irving, TX

PL/SQL Developer

Responsibilities:

• Responsible for Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.
• Involved in designing of Star Schema for Data Mart in Erwin
• Designed Entity-Relationship models using ERWIN and other design features.
• Wrote control files for data loading using SQL*Loader.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privilege
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Implemented exception handling using autonomous transactions, Pragma Init, Locks, used save points, commits & rollbacks to maintain transactional consistency & database integrity.
• Used Oracle Supplied Packages such as UTL FILE, DBMS JOB, DBMS SL and DBMS ALERT.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Developed and maintained UNIX shell scripts (Korn Shell) to process extracts and loads.
• Developed & maintained UNIX shell scripts to automate file transfers.
• Usage of Dynamic Execute Immediate statements to fetch data as needed for Dynamic SQL.
• Created database Triggers for data security and used SQL* Loader for bulk data load
• Involved in detail design and development of mappings using Informatica power center
• Designing and developing complex mappings using Map lets and reusable transformations.
• PL/SQL Collections were extensively used for high performance of stored procedures.
• Created the materialized views - Partitioned very large database tables using list partitioning to improve performance.
• Achieved optimum Performance Tuning using EXPLAIN PLAN and TKPROF functional utilities and also by creating Indexes.
• Monitored user interaction with the system and made improvements to tune applications to shifting business and user needs.
• Developed software test plans, test design specifications, and test scripts for various test scenarios.
• Performed Unit Testing for the project.
• Involved in Production Support and troubleshooting data quality and integrity issues

Environment: Oracle 10g, AIX-UNIX, SQL*Plus, SQL*Loader, TOAD, PL/SQL, Perl, Pro*C, Quality center, Toad, SQL, Informatica Power center 8.1.1, Erwin.

Confidential, Franklin, TN

Oracle Developer

Responsibilities:

• Involved in various stages of the project life cycle mainly analysis, design, Coding, testing and implementation of the application.
• Created new Tables, Indexes, and Sequences where needed.
• Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.
• Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.
• Involved in Designing data models using Erwin
• Design of Star Schema for Data Mart in Erwin.
• Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements
• Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
• Created UNIX Shell scripts for automating the execution process.
• Designed and Created several Customized Reports using Oracle Reports.
• Designed and developed front-end applications using Oracle Forms.
• Unit testing various PL/SQL blocks and GUI testing the user interface screens.
• Developed Procedures and Triggers for Oracle Forms and Reports
• Used Autosys for scheduling jobs.
• Involved in writing Perl Scripts for populating data on to WebPages.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Involved in writing complex queries to generate reports as per client requests as part of production support
• Wrote SQL statements in Pro*C and replaced them with appropriate calls to functions in the SQL runtime library.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Coordinated with DBA in improving Database Performance.
• Involved in developing test plans and test cases based on high-level and detailed designs.
• Worked 24/7 Production support on rotation.

Environment: Oracle 10g, HP-UX UNIX, SQL*Plus, SQL, Pro*c, Perl, PL/SQL, SQL*Loader, Forms10g, Reports10g, Erwin, TOAD, Java, Perl, XML, Autosys, Designer 6.i.

Confidential, Philadelphia, PA

PL/SQL Developer

Responsibilities:

• Involved in Requirement gathering and writing Functional and Technical documents
• Worked in Data modeling, Data mapping and Data flow using Erwin
• Created materialized views, Inline Views & normal views where business requirements needed
• Tune the SQL queries and complex procedures to improve performance
• Created database triggers for data security & Consistency
• Experience in writing procedures, functions and packages for new requirements
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications
• Participated in Performance Tuning using Explain Plan and TkProf.
• Analyzing user requirements and writing optimized queries to retrieve data from Oracle database
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database
• Created Materialized views & normal views where business requirements needed
• Developed packages for processing data in the staging tables according to the Clients requirements
• Maintained and Updated existing applications of Oracle Forms and Oracle reports according to requirement.
• Writing UNIX Shell Scripts to automate load process, scheduling batch jobs in Crontab.
• Worked in unit, integration and performance testing.
• Documented changes and enhancements in code
• Involved in Code review before dropping into QA/UAT
• Coordinated with the team of java developers to accomplish complex financial calculations.
• Involved in the deployment of code into QA and Production environment
• Used CVS for version control of applications

Environment: Oracle 10g, UNIX, SQL*Plus, SQL*Loader, Toad, JAVA, CVS, PL/SQL Developer, Oracle Reports 6i, Oracle Forms 6i, Perl, Erwin, Pro*c, XML, Windows XP.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing
• Used SQL* Loader to load data into different tables
• Extensively used PL/SQL for designing packages, stored procedures, functions and database triggers
• Extensively used PL/SQL to extract data from different tables with millions of records in some of the tables
• Created Materialized views & normal views according to the requirement.
• Developed, modified and optimized complex queries for data retrieval and modification.
• Incorporated validation rules for promotion history table and updating tables
• Participated in status meeting and walkthroughs
• Generated PL/SQL reporting and Unix Scripts to notify process failure/success.

Environment: Oracle 9i, SQL*Plus, PL/SQL, Toad, MS Windows 2000, C, C++