SUMMARY

• Over 8 years of experience in the areas of analyzing, application programming, system design, development and testing of business applications
• Strong experience in design and development of applications involving Perl, Oracle and Unix Shell Scripting
• Good experience in creating web applications using HTML and JavaScript
• Expert in creating various PL/SQL stored procedures, views, functions and temporary tables
• Strong RDBMS concepts including expertise in pl/SQL queries like DML, DDL, Stored Procedures, Views, User Defined Functions (UDF), Triggers, and Cursors etc.
• Strong experience in designing and developing many Perl modules
• Extensive experience in Oracle backend in PL/SQL development
• Extensive Experience in design and development of multi - tier applications using Java, J2EE, Spring, Struts, Hibernate and JDBC.
• Experience in developing Web Services using REST and SOAP
• Strong hands on experience in Unix Shell Scripts for automation testing
• Good experience in Data warehouse concepts, ETL tools like Informatica
• Experience in Oracle relational database modeling, SQL and PL/SQL
• Experience in analysis, design, development, documentation & production support applications using web and client/server technologies
• Good experience in Data Modeling tools like Erwin, Toad
• Ability to develop/maintain applications and write complex Oracle PL/SQL queries
• Strong commitment towards quality, experience in ensuring compliance to coding standards and review processes
• Excellent analytical, communication skills and good team spirit

TECHNICAL SKILLS

Languages: Perl 5.2, Javascript, HTML 5, CSS 3, SQL, PL/SQL

Operating System: UNIX, Windows, Solaris, Linux

Databases: Oracle 10/11g, MS SQL Server, MySQL

Web Servers: WebLogic, Apache Web server, WebSphere

Tools: Cron Tab, DBI/DBD, Erwin, SQL*Plus, SQL*Loader, HP Quality

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Performed requirement analysis by gathering functional and non-functional requirements
• Worked on creating test cases aligned with the requirements using UNIX shell scripts
• Maintained the system, wrote scripts in Oracle SQL to monitor batch processing to get early warnings in case of wrong data processing.
• Gathered data from Oracle database using a function in the form of XML and processed by an XML parser
• Designed logical and physical data models for star schemas usingErwin
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Used DML on the dynamically built object, must employ special dynamic syntax, because latter SQL code in the PL/SQL
• Automated and optimized information lifecycle using Oracle 12C database.
• Developed UNIX Korn shell scripts to automate various release engineer processes such as password validations, HP PPM package deployment statistics etc.
• Used Autosys to schedule many jobs extensively
• Automated the Informatica jobs using UNIX shell scripting.
• Used DML on the dynamically built object, must employ special dynamic syntax, because latter SQL code in the PL/SQL
• Worked on development and maintenance of SQL code embedded in Oracle PL/SQL
• Created a suite of Perl scripts to provide application level control and monitoring of databases, application servers and process schedulers
• Created and enhanced entity relationship diagram, Data Structure Diagram, Data Definition Language (DDL) Scripts
• Worked on Performance tuning of SQL, Oracle PL/SQL and analyzed tables
• Improved database security with 12c database.
• Created several UNIX scripts to implement new features in the modules and updating the existing code based on the requirement
• Stored reformatted data from relational, flat file, XML files using Informatica (ETL).
• Created complex functions, stored procedures, packages and triggers using Oracle PL/SQL
• Created a Perl-based tool to assist in website integrity checking
• Used DML syntax to extracts data from a database
• Developed various code deployment scripts for the HP PPM tool which involves Web catalog deployment, weblogic server deployment, RPD deployment, ODI deployment etc.
• Wrote UNIX shell scripts to login to Oracle databases and execute multiple queries, views and concurrent programs.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Worked with HP PPM tool for creating and deploying PL/SQL packages.
• Wrote UNIX scripts for file handling and manipulation.
• Scheduled many batch processes and FTP scripts using Autosys
• Conducted Unit testing. UAT on the application using functional and automated testing methods.
• Wrote different PL/SQL statement to generate different portal pages
• Created and implemented database objects and business intelligence tools, using SQL and Oracle 12c
• Worked on Performance tuning of Oracle packages, procedures, functions and triggers. Replaced existing subroutines with faster parsed code in trade request handling. Improved access speed into Oracle database for individual trade requests and bulk calls.
• Enhanced DML query syntax elements for more powerful data accessing and processing
• Used SQL*Loader techniques to copy a mass storage of data
• Automated production jobs using UNIX shell scripts
• Designed and developed UNIX shell scripts and Oracle scripts to fetch the data to generate and display reports.
• Involved in Data Definition Language (DDL), for retrieval and update operations
• Used principles of Normalization to improve the performance. 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.
• Created database triggers to control DML operations at improper timings in transactional tables to effect security
• Investigated and efficiently resolved challenging technical support issues received from clients
• Developed reusable components and rule based engines for improving productivity using Oracle PL/SQL
• Wrote UNIX scripts to automate verification of information inserted into the database.
• Used SQL, SQL*Plus and PL/SQL to check for data truncation problem
• Wrote feed handlers using Perl and DBI to update an Oracle database
• Performed SQL*Loader for data load into Oracle database
• Involved in interactions with the end-users and provided production support and debugged production issues.

Environment: Oracle 12c/11g/10g, PL/SQL, SQL, SQL*Loader, Crontab, MS Office, HTML 5, CSS 3, Perl, UNIXSingle Security Analysis

Confidential, New York, NY

PL/SQL Developer

Responsibilities:

• Involved in gathering software requirements and specifications from clients
• Designed, implemented, and maintained Perl application with Oracle database
• Developed Java using Eclipse as IDE
• Designed and developed XML Convert, which was a successful software product that converted data into XML and vice versa using flat file schemas
• Performed requirements analysis by gathering functional and non-functional requirements for the project
• Developed Shell scripts and SQL control files to load data through SQL*Loader
• Handled on resolving complex issues and Error Handling in SQL Server Integration Services (SSIS)
• Used JavaScript and Perl for dynamic data filtering, uploading and downloading
• Wrote several Oracle PL/SQL stored procedures to access the database
• Developed application using Java, J2EE, Struts, spring, Hibernate
• Used PERL and UNIX shell scripts to setup web pages dynamically
• Designed and developed functionality according to requirements utilizing Java/J2EE technologies
• Created and modified SQL*Plus scripts to capture data
• Supported customers for applications using Autosys, and the Operations group monitoring Autosys on a 24/7 basis
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Create reusable DDL, DML SQL queries that can be used for different input data to validate against the User Interface.
• Created and enhanced internet sites by developing Java Servlets that accessed an Oracle database via JDBC
• Used SOAP and REST web services along with XML to transfer data between the switches and server.
• Created Logical/physical Data Model in Erwin and have worked on loading the tables in the Data Warehouse
• Created many Core Java classes for data file extraction and loading
• Involved in writing shell scripts on Unix for Informatica ETL tool to run the sessions
• Used PL/SQL tables to process huge volumes of data and used Oracle bulk collect to improve the database performance Tuning
• Configured and used Spring, Hibernate, Oracle database, PL/SQL technologies in developing back-end services.
• Single point of contact for all database changes and handled all DML and DDL scripts in code repository.
• Updated ETL tasks in SQL Server Integrated Services (SSIS) for data warehouse development
• Developed drag and drop slide show editing and viewing application with JavaScript and HTML
• Optimized the Oracle query using SQL to improve the query performance
• Maintained web pages using HTML with JavaScript validation
• Implemented struts frame work for implementing the MVC pattern
• Designed Restful XML web services
• Enhanced Core Java codes with JDBC routines for Oracle connection
• Coded and tuned Oracle PL/SQL and SQL throughout the development
• Involved in writing shell scripts on Unix for Informatica ETL tool to run the sessions
• Conducted unit testing, UAT on the applications using functional and automated testing methods
• Wrote packages using Oracle PL/SQL to access data from the database and write into and extract from flat files using SQL* Loader utility
• Responsible performance tuned Oracle SQL queries using the parallel query feature, indexes, and processor hints
• Worked extensively on data extraction, cleansing and data integration, and loading from different data sources using SSIS
• Developed a J2EE based web application using Spring and the Hibernate object/relational mapping framework as well as the Java Message Service
• Extensively developed complex SQL packages for ETL
• Designed, developed and tested several Autosys scheduled job scripts and UNIX shell scripts
• Developed Unix shell programs and scripts to maximize productivity and resolve issues
• Implemented complex SQL queries on the database along with Stored Procedures, triggers and PL/SQL code blocks
• Responsible for creating Oracle DDL, DML SQL Scripts to configure application development environment
• Involved in the development of model, library, struts and form classes (MVC)
• Wrote UNIX Shell Scripting for Informatica Pre-Session, Post-Session Scripts and also to run the workflows.
• Maintained multiple levels of support for batch processing for reporting module
• Wrote SQL and shell scripts for performance tuning and monitoring, database backup and recovery on Oracle
• Developed Perl Scripts to transform data and to drive execution of PL/SQL Packages and procedures
• Created several UNIX scripts to implement new features in the modules and update the existing ones
• Provided 24x7 support during application deployment and debugged production issues

Environment: Oracle10g/11g, PL/SQL, SQL, SQL*Loader, HTML, CSS, JavaScript, Perl, UNIX, Crontab, MS Office, SSIS

Confidential, New York, NY

Oracle Developer

Responsibilities:

• Involved in gathering software requirements and specifications from clients
• Created various stored procedures to validate data in Oracle
• Used Perl and UNIX to set up web pages dynamically in the application
• Developed application using Eclipse IDE
• Worked with SQL *loader to load data from flat files into databases
• Used Autosys, Perl and Shell Scripts to schedule automated file and data processing jobs
• Wrote and enhanced Oracle PL/SQL stored procedures and triggers for better performance of queries
• Performed requirements analysis by gathering functional and non-functional requirements for the project
• Defined both logical views and physical data structure using Erwin.
• Created SSIS packages to load staging tables
• Used JDBC to establish connection to Oracle and populate the tables with the necessary fields
• Gathered data from database using a function in the form of XML and processed by an XML parser
• Responsible for coding of DAO Classes using Struts with hibernate
• Designed, developed, debugged and tested the web based J2EE application
• Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL, Informatica).
• Worked on performance tuning of Oracle SQL, PL/SQL and analyzed Tables
• Created tables and performed data driven test to retrieve items from the database using SQL for loading data from news feeds
• Developed Web services (REST and SOAP) to make services thread safe and flexible and reliable.
• Created a SQL Reporting Services and SSIS Infrastructure that pulls data from multiple data sources and provides a simple to use reporting environment
• Created Spring batch jobs for automation of products and validation of operation
• Wrote source code in SQL*Plus and Oracle PL/SQL to handle multiple tables
• Developed and tested Oracle PL/SQL procedures, functions and triggers for loading and updating the data feeds into tables
• Development of the server side application that includes Servlets to handle the database interaction with the back-end Oracle database using JDBC
• Performed ETL code reviews and Migration of ETL Objects across repositories.
• Developed Perl scripts to support development, testing and production support activities for the project
• Designed and developed UNIX shell scripts and Oracle scripts to fetch data for reports and to display reports
• Achieved automated workflows using Autosys
• Developed client/server applications to support real-time collaboration using Core Java
• Maintained stored definitions, transformation rules and targets definitions using Informatica
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Used SSIS built in functions such as multi cast, condition split, sort, aggregation, lookup & fuzzy lookup
• Created multiple Unix shell scripts to import data into Oracle using SQL*Loader
• Used JavaScript for data validation while extracting and loading information into tables
• Created user interfaces using HTML and JavaScript for web page presentation of data
• Developed the middle tier using J2EE technologies under Struts framework
• Provided Oracle PL/SQL script support for production database upgrade and change
• Provided support, training and troubleshooting services in customer support team
• Modified Perl scripts due to database changes using Perl DBI
• Developed Java Hibernate, Spring Frameworks and JavaScript for database access from CGI Web Pages
• Worked as a Component Developer to code in Java and J2EE technologies
• Developed and performance tuning Oracle PL/SQL, packages, procedures, functions and triggers
• Provided support to develop the entire warehouse and plan the ETL process.
• Created several UNIX scripts to implement new features in the modules and update the existing ones
• Involved in PL/SQL code review and modification for the development of new requirements
• Worked intensively on Oracle side creating many Tables, Stored Procedures and Triggers
• Developed stored procedures and complex packages using PL/SQL
• Conducted unit testing, UAT on the application using functional and automated testing methods

Environment: Oracle10g/11g, PL/SQL, SQL*LOADER, SQLPLUS, Crontab, HTML, CSS, JavaScript, Back-end - Perl, UNIX, SSIS

Confidential

Database Developer

Responsibilities:

• Involved in Knowledge transition activities in the requirement analysis phase
• Developed many tables, stored procedures and triggers on Oracle database for implementing complex business logic
• Participated in the design reviews with the business and development teams
• Created SQL*Loader scripts to load data from external system to Oracle
• Prepared Test Strategy and Test plan using HP Quality Center
• Designed and developed XML schemas for the Web services, which are core components of this application
• Performed ETL code reviews and Migration of ETL Objects across repositories
• Involved in performance tuning of various queries and stored procedures
• Also worked with many PL/SQL procedures to create calculated values and store them in database
• Worked in creating batch module using Core Java
• Prepared Test Design and performed Test execution using HP Quality center
• Developed Perl scripts to support development, testing and production support activities
• Designed and developed UNIX shell scripts and Oracle scripts to fetch data for reports and to display reports
• Developed an XML based engine to construct web pages at request time from XML based components
• Created Controller classes using Spring MVC to capture the user's response and to implement the business logic
• Worked on Shell Scripts in order to convert incoming Excel Flat files from .xls to .csv which helps importing into Informatica.
• Developing applications in MVC architecture using Struts framework
• Developed Oracle tables and PL/SQL packages, procedures and functions
• Extensively developed complex SQL packages for ETL
• Created VB scripts for automation testing of all the functional features of the applications
• Used SOAP and REST web services along with XML to transfer data between the switches and server.
• Developed user interface and standardized the Core Java code for objects
• Created and modified SQL*Plus scripts to capture data
• Wrote and executed test cases for various functional scenarios of the applications
• Wrote Unix shell scripts to automate verification of information inserted into database
• Prepared reports using Stored Procedures with DBI/DBD connection to Oracle and created many reports using HTML
• Involved in performance testing activities for Scopus and science direct
• Designed and documented the changes necessary to the Oracle PL/SQL, Perl, Perl DBI, and Korn Shell code to meet the requirements
• Used Spring MVC Framework Dependency Injection for integrating various Java Components
• Reviewed test artifacts before publishing it for SME's review
• Used HP Quality center for logging defects during usage reporting and tracked the defects till the closure
• Developed the middle tier using J2EE technologies under Struts framework
• Implemented the list interface like ArrayList and LinkedList using core Java class
• Developed Oracle PL/SQL packages and procedures for extracting or loading of files for internal and external sources
• Performed date warehouse testing using ETL processes and XML databases
• Assisted and worked in creating test cases aligned with requirements using UNIX shell scripts
• Monitored the performance tuning in Oracle PL/SQL application
• Provided Perl programming solutions for all the requested tasks
• Worked on bug fixing and supported the production applications and data handling

Environment: HP Quality Center, HP Quick Test Professional, Java, HTML, CSS, XML, Oracle, SQL, SOA, Advanced REST client

Confidential

Database Developer

Responsibilities:

• Involved in requirement gathering and analysis phase and participated in design documentation
• Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
• Wrote synchronization code using PERL and UNIX Shell Scripts
• Involved in joining the two tables in Oracle
• Developed and wrote shell scripts for data transfer
• Developed different types of reports using Oracle reports
• Involved in back-end process using SQL, PL/SQL
• Scheduled the jobs using the CronTab
• Used SQL*Loader loads data from external files into tables of an Oracle database
• Worked on performance tuning and monitoring of Oracle database
• Created PL/SQL Tables, Stored procedures, Triggers and Views
• Developed scripting tools using PERL and UNIX shell programming to fulfill various requirements of the project
• Created flat files with SQL*Plus from Oracle tables in Unix environment
• Involved in Oracle PL/SQL code review and modification for the development of new requirements
• Responsible for performance tuning activities in Oracle
• Developed Perl scripts to support development, testing and production support activities in the project
• Designed and developed UNIX shell scripts and Oracle scripts to fetch data for reports and to display reports
• Worked in scheduling the PERL scripts for end of the day run
• Worked extensively in the back-end Oracle database using PL/SQL
• Active participation in testing and quality assurance activities

Environment: Oracle, KSH, SQL, PL/SQL, SQL*PLUS, HTML, CGI, UNIX, Perl