SUMMARY:

• Over Nine years of professional experience in Analysis, Design, Development, Testing, Implementation and Maintenance of Software tools and Application packages using AGILE Methodology.
• Experience working with various Heterogeneous Source Systems like Oracle, MS SQL Server, Sybase, and Flat files.
• Experienced in developing stored packages, procedures, functions, Partitions, triggers, and views.
• Extensive experience in developing UNIX Shell scripts, SQL and PL/SQL (Coding Procedures, Functions, Database Packages and Triggers).
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans and Table partitioning.
• Optimized the Oracle database by tuning SQL queries, creating tablespaces/partitions, and made cold and hot backups.
• Extensive experience with Oracle/SQL Server database development and experience in writing PL/SQL/ T - Sql queries, stored procedures/functions & triggers.
• Experience in database performance tuning, performance monitoring and Optimization using tools such as Oracle Hints, SQL Trace, Explain plans and table partitioning
• Implemented Packages (Stored Procedures, Functions, Cursors, and Triggers), Data Cleansing, Transformation Scripts and necessary test plans to ensure the successful execution of the data loading processes for Data Warehouse and DataMarts.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and SQL-Server databases.
• Writing scripts for collection of statistics, reorganization of tables and indexes, and creation of Indexes for enhancing performance for data access.
• Expertise in Mathematical modeling and Numerical Analysis.
• Excellent planning, analytical, written Communication and Interpersonal skills
• Excellent team player, with strong skills in trouble-shooting, Problem solving, Interpersonal, Oral & written communication

TECHNICAL SKILLS:

DBMS: Oracle 11i/10g/ 9i/8i, SQL Server 2000/2005, Sybase

Data modeling / Oracle Tools: Oracle Designer, Toad 5.2, SQL Navigator 4.5

Languages: Shell Scripting (K-Shell, C-Shell), PL/SQL, PERL, FORTRAN, Core JAVA PL/SQL, Java

Operating Systems: DOS, UNIX, Windows 95/98, 2000, NT, XP

Internet: HTML, FrontPage2000, Dream weaver, Adobe Photoshop, IIS 6.0, Apache

Version Control tools: PVCS, VSS and SVN.

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

PLSQL Developer/ Team Lead

Responsibilities:

• Involved in the Project design discussions, development, testing and production support.
• Good knowledge of performance tuning with the huge tables.
• Completely involved in Performance tuning of multiple SQL queries and PL/SQL blocks using Explain Plan, Hints and SQL Trace.
• Extensive experience in data validation and manipulation in the Oracle database using SQL queries.
• Developed back end interfaces using PL/SQL stored packages, procedures, functions, Object Types, Triggers, C, K-Shell scripts.
• Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Involved in developing UNIX shell scripts required for maintaining the data Models and processing job.
• Involved in Writing Oracle Application Program Interfaces (APIs) and Performance tuning. Wrote SQL, PL/SQL and UNIX scripts for extraction of data.
• Also involved in UNIX Administration like granting user privileges and security aspects.
• Developed stored procedures, packages, functions and triggers for workflow validation and verification.
• Involved in testing PL/ SQL programs, UNIX shell scripts required for maintaining the data Models.
• Used Oracle Developer tools to create application design specifications.
• Monitored, tuned and maintained the development database objects.
• Involved in creating Technical Specification Document (TSD) for the project.
• Coordinate with different stake holders for smooth implementation.
• Involved in all the cycles of SDLC using Agile Model.
• Participated in Daily stand-up meetings and Scrum methodology.
• Facilitated all the scrum ceremonies including sprint planning, story point estimation, sprint retrospective etc.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance. Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Writing scripts for Data Staging, Loading and cleanup process. Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Created Materialized views and partitions and used hints for query optimization.
• Created jobs using DBMS JOB package for job scheduling.
• Mentored new team members on pl/sql development.
• Using existing processes and procedures for application deployment and provided 24x7 production support as Primary

Environment: Oracle 11i, PL/SQL, TOAD, Windows XP, Putty, Linux

Confidential, St Louis, MO

PL/SQL Developer/ Team Lead

Responsibilities:

• Involved in the Project design discussions, development, testing and production support.
• Involved in direct discussion with the End-Users to study the system requirement and develop Functional and Technical specifications to meet their requirements
• Developed and modified PL/SQL code for new enhancements and resolved known issues, as per business requirements.
• Estimated Story points using poker and fibonacci series and created sub-tasks in Jira for stories that are created by product owner.
• Enhanced database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges by incorporating business standards throughout the files.
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
• Implement old processes into new modules and make sure all the business needs are addressed.
• Added new packages, with generalized procedures and functions to reduce the Trigger level load and making the code workflow better, having the business rules intact for the migration.
• Participated in the production migration. Worked on Accounts which are dropped out while sending to the spoke systems.
• Involved in all the cycles of SDLC using Agile Model.
• Participated in Daily stand-up meetings and Scrum methodology.
• Documented every story that worked in system.
• Scheduling Execution of PL/SQL Procedures using Unix Shell scripts for updating of Base tables from Transaction Tables
• Monitored business flows and status monitor in Enterprise Manager and Console.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Involved in Unit Testing of packages.
• Writing scripts for Data Staging, Loading and cleanup process. Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Writing high quality and well documented code according to standards.
• Mentored new team members on pl/sql development

Environment: Oracle 11i, PL/SQL, TOAD, Windows XP, Putty, Linux

Confidential, St Louis, MO

PL/SQL Developer, Team Lead

Responsibilities:

• Developed complex SQL queries for data retrieval from various database objects including tables and views.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes.
• Analyzed and implemented desired location for data, index, control files, redo log and archived log files.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Writing scripts for Data Staging, Loading and cleanup process. Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Created impromptu SQL queries for data verification and analysis.
• Created and manipulated Nested and Index-By tables (i.e. PL/SQL Tables).
• Manipulated PL/SQL tables and VARRAYs with BULK BINDS and BULK COLLECTS.
• Wrote Ad-Hoc SQL queries for data analysis.
• Tuning of I/O, which includes Separating of Data files and Redo log files on different locations, Striping of table data, and separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, TKPROF, SQL TRACE, ANALYZE, HINTS. Oracle query tuning and optimization
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed PL/SQL Procedures, Functions and Packages for Front End Java Application.
• Extensively used PL/SQL Procedures and Functions to transform data before the loading process.
• Created various ER diagrams and Dataflow diagrams using Oracle Designer.
• Created and tested PL/SQL blocks and UNIX shell scripts.
• Created data validation scripts in UNIX to verify the loading process.
• Designed and developed Web-enabled Oracle Forms & Reports. Including Forms based on stored procedures
• Developed PL/SQL Business Functions, procedures and packages for data models to create reports from J2ee web Application.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cronjobs for the scheduled batch processes.
• Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
• Writing high quality and well documented code according to standards.
• Mentored new team members on pl/sql development.
• Involved in all the cycles of SDLC using Agile Model.

Environment: Oracle 10g RAC, PL/SQL, TOAD, Putty, Linux, UNIX, Windows XP.

Confidential, Woonsocket, RI

PL/SQL Developer

Responsibilities:

• Involved in Developing Procedures and packages to Load Data for Pharmacy Data Warehouse.
• Analyzing the data needs for the Pharmacy Data Warehouse.
• Involved in Unit Testing of packages and shell scripts.
• Written SQL scripts for extracting data from data warehouse.
• Developed packages, procedure and functions for complex Reports
• Responsible for Study, Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Written Shell Scripts, control files to load data into staging tables and DW tables.
• Developed and Tested applications for loading rxconnect data into database tables.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Involved in Unit testing PL/ SQL Stored Procedures and Functions.
• Involved in developing UNIX shell scripts for Loading Database Tables.
• Developed shell scripts to ftp the flat files to different servers.
• Loading data from flat files into database tables using SQL* Loader
• Loading data from flat files into database tables using external tables, ctas statements and bulk load.
• Writing scripts for Data Staging, Loading and cleanup process.
• Preparing documentation for requirements, design, install and Unit testing and System Integration.
• Extensively used Serena ChangeMan for version control.
• Extensively used PVCS tracker for change requests.
• Extensively used Control M for job scheduling.
• Created Materialized Views and partitioning tables for performance reasons.
• Preparing documentation for requirements, design, install and Unit testing.
• Resolving Production severity Issues in time and meeting the SLA.
• Responsible for Analyzing and Implementing the Change Requests
• Monitoring day-to-day Process for different Data Loads and resolving Issues.
• Resolving the issues on priority basis.
• Writing high quality and well documented code according to standards.

Environment: Oracle 9i/11i, Toad, Tortoise SVN, SQL * Loader, SQL, PL/SQL, SQL*PLUS, UNIX, Control M, Unix Shell scripts, Perl Scripts, Windows 2000, XP, Microsoft Excel, Word