SUMMARY

• Around 7 years of experience in various phases of Software Development Life Cycle involving Analysis, Design, Development and Maintenance of Business Applications using Oracle Relational Database Management System.
• Solid Experience in writing SQL queries, stored procedures, stored functions, packages, database triggers, exception handlers, referenced cursors, PL/SQL records & tables and objects types
• Used the Native Dynamic SQL, Global Temporary Tables, Nested Tables, Partition Tables and REF Cursors to pass to front end for the Forms & Reports Developments.
• Involved in Query Level Performance tuning using Explain Plans and SQL utilities to pin point time consuming SQLs and tuned them by creating indexes and forcing specific execution plans.
• Expertise in Creating and maintaining Database Objects like Tables, Views, Materialized views, Indexes, Constraints, Sequence, Synonyms and Database Link.
• Extensive experience in the Data Manipulation using SQL for the retrieval of data from the Relational Database (inner joins, outer join, group by, order by, cursors etc).
• Hands on experience working wif Very Large Databases and Transactions wifin them.
• Expertise in data integration, interfaces into Oracle databases using SQL*Loader and data conversion from legacy system into Oracle Applications using PL/SQL.
• Strong exposure to all the phases of Software Development Lifecycle (SDLC) wif application development experience in Oracle, ETL, Reporting, Migration, Interfaces and Conversion projects in multiple domains
• Strong analytical skills wif ability to quickly understand clients’ business needs and identify available data sources and the relationships that exist wifin them.
• Experience in Production Support and the ability to provide time - bound and quality driven solutions has cultivated decision-making and analytical ability
• Good working Knowledge in UNIX and shell scripting (Korn, Bourne).
• Experience using version control systems like SVN, PVCS and VSS.
• Ability to learn and adapt quickly in a dynamic environment and ability to work on multiple projects against aggressive deadlines.
• Worked in both waterfall and agile environment development methodology.
• Self-starter can work independently as well as a good team player.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, Basic Java

Front End Tools: Developer 2000(forms 6i/9i, reports 6i/9i)

Relational Databases: Oracle 9i, 10g, 11g, sql server 2005

DBMS: MS Access

Web Technologies: HTML, JSP, XML

Operating Systems: Windows NT, XP, 2000, UNIX, UNIX shell scripting

Tools: and Utilities: PLSQL Developer, Toad, SQL*Plus, SQL*Loader, Winscp, Informatica, Putty

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Database Engineer/ Pl/SQL Developer

Responsibilities:

• Responsible for analysis, requirements gathering, documentation of functional/technical specifications, development and testing.
• Created new database objects like Tables, views, procedures, functions, packages, materialized views, DB links and Indexes.
• Wrote complex queries including Sub queries, Joins, Unions, Intersect and Aliases.
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS, INDEX BY TABLES and FORALL statements to improve performance in insert and update statements.
• Create a new MVIEWS on snapshot database and refresh it by modifying existing refresh mview DB procedure for regular interval.
• Performed unit and integration testing of the applications created using PL/SQL modules and used SVN for version control in team development.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Created database objects like Tables, Views, Indexes, Synonyms, grants scripts and Sequences using several DDL scripts.
• Extensively used error and exception handling techniques for validation purposes in code.
• Involved in fine tuning the existing packages for better performance by using table full, Parallel, Index Hints, Partitioning the tables.
• Create new Jobs in oracle scheduler and DBMS JOBS package to automate the processes.
• Developed an TEMPeffective Error Mechanism by creating Monitor, Error-Log Tables using Autonomous transactions
• Interaction wif business, team members and QA team for resolving application and database related problems.
• Involved in regular deployment meeting wif DBA team, UI team, QA team, network team and business user.

Environment: UNIX, Oracle 11g, SQL, PL/SQL, SQL*Loader, Toad, PLSQL developer, SVN

Confidential, CA

Database Engineer/Pl/SQL Developer

Responsibilities:

• Responsible for analysis, requirements gathering, documentation of functional/technical specifications, development and testing.
• Developed control files for SQL* Loader and PL/SQL scripts for Data Extraction/Transformation/Loading (ETL) and loading data into interface Tables (Staging area) from different source systems and validating the data .
• Created database objects like Tables, views, procedures, functions, packages, materialized views and Indexes.
• Wrote complex queries including Sub queries, Joins, Unions, Intersect and Aliases.
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS, INDEX BY TABLES and FORALL statements to improve performance in insert and update statements.
• Produced Scripts to cleanse source data, ETL process (Extract, Transform & Load) data wif business rules for new onboarding merchants.
• Performed unit and integration testing of the applications created using PL/SQL modules and used GITHUB for version control in team development.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Created database objects like Tables, Views, Indexes, Synonyms and Sequences using several DDL scripts.
• Write Unix Shell scripts to load the data file from Merchants FTP location and download the file into database directory.
• Write the KSH scripts to process the file, load into the staging table and write PLSQL procedures to load data into database.
• Extensively used error and exception handling techniques for validation purposes in code.
• Performance tuning of the PLSQL procedures using SQL TRACE & TKPROF.
• Involved in fine tuning the existing packages for better performance by using table full, Parallel, Index Hints, Partitioning the tables.
• Create new Jobs in oracle scheduler, crontab and UC4 technology to automate the processes.
• Developed an TEMPeffective Error Mechanism by creating Monitor, Error-Log Tables using Autonomous transactions
• Interacted wif business, team members and QA team for resolving application and database related problems.

Environment: UNIX, Oracle 11g, SQL, PL/SQL, SQL*Loader, Toad, PLSQL developer, Putty, GITHUB

Confidential

Sr. PLSQL Developer

Responsibilities:

• Responsible for analysis, requirements gathering, documentation of functional/technical specifications, data mapping, development and testing.
• Developing and moving the CR’s to move it to different environments such as QA, stage, UAT, Production.
• Created database objects like Tables, views, procedures, functions, packages, materialized views and Indexes to handle the CR’s and Enhancements.
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS, INDEX BY TABLES and FORALL statements to improve performance in insert and update statements.
• Performed unit and integration testing of the applications created using PL/SQL modules and used SVN for version control in team development.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Created database objects like Tables, Views, Indexes, Synonyms, Sequences using several DDL scripts.
• Performance tuning of the PLSQL procedures using SQL TRACE & TKPROF.
• Extensively used error and exception handling techniques for validation purposes in code.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Developed an Error Mechanism by creating Monitor, Error-Log Tables.
• Developed an TEMPeffective Error Mechanism by creating Monitor, Error-Log Tables using Autonomous transactions
• Basic DBA activities like granting privileges, creating views, creating partitioned tables
• Interacted wif developers and Quality Assurance team for resolving application and database related problems.

Environment: UNIX, Oracle 11g, SQL, PL/SQL, SQL*Loader, Winscp, putty, SVN

Confidential

Technical Associate

Responsibilities:

• Perform the normal health check the billing applications.
• Monitor the disk space of application files system and do the housekeeping of files systems of various applications
• Resolved the ticket raise by ticketing system in timely manner.
• Analyze and re-process the rejected billing files by modifying existing or developing new sql, plsql script.
• Develop the new shell scripts to automate the process and schedule that in cron jobs
• Participate in conference call for production outage and co-ordinate wif various teams for quick resolution of issue.
• Provide the root cause analysis to production issues and provide fix for production issues.

Environment: UNIX, Oracle 10g, SQL* Loader, Putty

Confidential

PLSQL Developer

Responsibilities:

• Created database objects like Tables, views, procedures, functions, packages, materialized views and Indexes.
• Wrote complex queries including Sub queries, Joins, Unions, Intersect and Aliases.
• Created External tables and Oracle Directories which is used to load the flat files into Oracle Database.
• Performed unit and integration testing of the applications created using PL/SQL modules and used PVCS for version control in team development.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Created database objects like Tables, Views, Indexes, Synonyms, Sequences using several DDL scripts.
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Extensively used error and exception handling techniques for validation purposes in code.
• Developed an Error Mechanism by creating Monitor, Error-Log Tables.
• Developed an TEMPeffective Error Mechanism by creating Monitor, Error-Log Tables using Autonomous transactions
• Interacted wif developers and Quality Assurance team for resolving application and database related problems.
• Review the code written by junior team members.

Environment: Oracle 9i, Oracle 10g, Forms 6i, Reports 6i, SQL, PL/SQL,PLSQL developer Tool, Toad, PVCS, UNIX, Winscp, Putty

Confidential 

PLSQL Developer

Responsibilities:

• Created database objects like Tables, views, procedures, functions, packages, materialized views and Indexes.
• Wrote complex queries including Sub queries, Joins, Unions, Intersect and Aliases.
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS, INDEX BY TABLES and FORALL statements to improve performance in insert and update statements.
• Created External tables and Oracle Directories which is used to load the flat files into Oracle Database.
• Performed unit and integration testing of the applications created using PL/SQL modules and used PVCS for version control in team development.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Created database objects like Tables, Views, Indexes, Synonyms, Sequences using several DDL scripts.
• Extracted data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Extensively used error and exception handling techniques for validation purposes in code.
• Developed an Error Mechanism by creating Monitor, Error-Log Tables.
• Developed an TEMPeffective Error Mechanism by creating Monitor, Error-Log Tables using Autonomous transactions
• Review the code written by junior team members.
• Interacted wif developers and Quality Assurance team for resolving application and database related problems.

Environment: Oracle 9i, Oracle 10g, Forms 6i, Reports 6i, SQL, PL/SQL, PLSQL developer, Toad, PVCS, UNIX, Winscp, Putty

Confidential

PLSQL developer

Responsibilities:

• Created database objects like Tables, views, procedures, functions, packages, materialized views and Indexes.
• Wrote complex queries including Sub queries, Joins, Unions, Intersect and Aliases.
• Developed several procedures and functions using advanced Oracle concepts such as REF CURSORS and BULK COLLECTS, INDEX BY TABLES and FORALL statements to improve performance in insert and update statements.
• Created External tables and Oracle Directories which is used to load the flat files (Essbase Extract) into Oracle Database.
• Performed unit and integration testing of the applications created using PL/SQL modules and used PVCS for version control in team development.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables
• Created database objects like Tables, Views, Indexes, Synonyms, and Sequences using several DDL scripts.
• Extensively used error and exception handling techniques for validation purposes in code.
• Developed an Error Mechanism by creating Monitor, Error-Log Tables.

Environment: Oracle 8i, Oracle 9i, Forms 6i, Reports 6i, SQL, PL/SQL, PLSQL developer Tool,PVCS, UNIX, Winscp