Over ** years of experience as an Oracle developer, Involved in complete SDLC including architecture, analysis, design, development, testing, implementation and maintenance of application software in the Client/Server and web based environments

Solid 7 years of experience with Energy trading applications and deregulated energy markets (PJM, ERCOT, NY, NE and MRTU), Analysis to track ISO/RTO wholesale energy market rules.

Good Understanding of Oracle Architecture, experience in Oracle 12c/11g/10g/9i/8i database programming using PL/SQL (Stored Procedures, Functions, Packages and Triggers) and built-in Oracle packages and UNIX environment

Experience in data Normalization and De-Normalization for database design and Data ware housing design and involved in Conceptual, Logical and efficient Physical data model design for better performance of database applications

Strongly experienced in Schema Objects (Tables, GT Tables, Views, Materialized views, Constraints, Indexes, Packages, Procedures, Functions, Triggers, Synonyms, Sequences Database Links and Types) and Bulk collects/Inserts, CURSORS/REF-CURSORS, Analytical functions, Dynamic SQL, Exception Handling and XMLTYPE concepts

Experienced in developing/supporting web applications on Tomcat Server.

Well versed with all popular IDE’s like Toad, SQL Developer, PLSQL developer, JDeveloper and Eclipse

Expert in developing scripts to create and modify Database objects like Tables, Indexes, Views, synonyms, sequences etc

Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes.

Hands-on experience with Oracle built-in packages like DBMS_SQL, UTL_FILE, DBMS_TRACE, DBMS_DDL, DBMS_DEBUG, DBMS_OUTPUT and DBMS_PROFILER

Adept knowledge in developing UNIX shell scripts, scheduling cron jobs and exposure to ETL tools like Informatica and Teradata utilities (Fast load, Multi-load, Bteq scripts & Teradata)

Used SQL*Loader, PL/SQL procedures to facilitate data import/export from staging tables to production tables and extensively used UTL_FILE

Developed XSLT stylesheets for transformation on XML objects and good knowledge and hands on experience in Object Oriented Analysis, Design and Development

Worked on Windows applications enhancements using Core Java, AWT, SWING, JDBC and deployed into t Tomcat 6.0

Experienced in providing the Impact analysis on application based enhancements proposed by Functional team

Experience in providing technical support and preparing technical documents for the end user

Experienced in User Acceptance Testing involving data validation, data integrity, functional testing, integration testing, regression testing and system testing

Highly motivated team player with good communication skills and excellent problem solving abilities. Would be willing to work independently or as part of a team

Technical Skills:

RDBMS

Oracle 12c/11g/10g/9i/8i, SQL Server 2000, MS Access.

Languages

SQL, PL/SQL, C, C++, Core Java, Adv Java, Java, XML, XSLT, HTML.

GUI/Tools

Visual SourceSafe, JDeveloper, Eclipse, TOAD, SQLDeveloper, PLSQL Developer, Sql*Plus, Control-M, Autosys and ERWIN

Web Server

Apache Tomcat

ETL Tools

Teradata, SSIS and Informatica Power Center 6.2/7.1/8.x/9.x

Operating System

Win NT/95/98/2000/XP, UNIX SUN Solaris, Unix/AIX and Linux

EDUCATION:

MSEE, Gannon University, Erie, PA.

Professional Experience

NRG, HOUSTON, TX (Sep 16 – Current

Sr. Oracle Pl/Sql Developer

Responsibilities

Written PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.

Developed PL/SQL programs and packages to carry validation based on the requirements.

Created database triggers to flip flags and perform several business validations.

Developed a package containing several procedures and function using advanced Oracle concepts such as REF

CURSORS, BULK COLLECTS are used to improve performance.

Used Hints to force rules in order to improve query performance based on Explain Plan, TKPROF.

Created Materialized Views to reduce query run time for the end user.

Worked on mappings between source and target systems.

Created Oracle Objects Types using Object oriented in Oracle plsql.

Involved in taking backups and exports, FTP in UNIX environment.

Planned version control of production source code using Control SVN.

Participated in unit testing and prepared unit test documents.

Strong experience in using Altova XML Editor for mapping between one source system to multiple target systems.

Involved in supporting/fixing post production defect fixes.

Used Stylesheets to process the XML files.

Expertise in using Altova Mapforce XML between source and target mapping systems.

Attended Design meetings, code review and test review meetings.

Interacted and communicated with team members to solve/resolve issues.

Environment: Oracle 12c, SQL, PL/SQL, PLSQL Developer, XSD,XSL, XML, SVN, JAVA

IconPlc, HOUSTON, TX (Jul 15 – Sep 16)

Sr. Oracle Pl/Sql / SSIS Developer

Responsibilities

Gather requirements from users and work with TPM’s to complete user requirements specifications(URS) and system

Requirements specifications (SRS).

Worked during the whole SDLC of the project from requirements gathering, deployment, and support.

Designed end-to-end ETL process to load the data from client extracts into oracle database.

Executing the Packages using SQL Server Agent Jobs in different environments and Supporting the daily, weekly,

Monthly, semimonthly jobs.

Analyzed data needs for customized reports and mapped data requirements.

Managed tables, indexes, constraints, views, sequences, synonyms and stored program units.

Developed Stored Procedures, Functions, Views, Materialized View and Triggers.

Defined indexes on various tables to improve the performance of the queries for reporting purpose.

Created Materialized Views to access production configurations and reduce query run time for the end user.

Designed the overall architecture for Data Migration based on functional requirement.

Wrote technical specifications for all the procedures developed in the module. Maintained log files during analysis and

reported any performance defects subsequently.

Participated in design reviews with the product teams and suggested design changes to improve database performance.

Extensive experience in creating XML files to store data and making them available when necessary.

Strong work experience in Query construction, Stored Procedures, Triggers and User Defined Functions using SQL,

PL/SQL.

Well experienced in PL/SQL programming, using features such as Collections, Bulk Binds to improve performance by

Minimizing the number of context switches between the PL/SQL and SQL engines.

Environment: Oracle 12c/11g, SQL, PL/SQL, SSIS, Sql Server, C#, XML, SAS, CVS, SVN and Liquibase.

DIRECT, HOUSTON, TX (Jan 15 – Jul 15)

Sr. Oracle Pl/Sql/ETL Developer

Responsibilities

Designed ETL Specifications as per the conversion requirement.

Designed and developed ETL DATA MART.

Developed several PL/SQL Interfaces that extracts the data from several systems into Target systems.

Understanding the existing application architecture, flow of the system, making changes for customizing business needs.

Extensively created PLSQL CUSTOM APIS, STORED PROCEDURES, FUNCTIONS and VIEWS.

Strong knowledge and hands on experience in writing Objected oriented programs using PL/SQL.

Used Hints to force rules in order to improve query performance based on Explain Plan, TKPROF.

Created Materialized Views to reduce query run time for the end user.

Using merge statement for bulk data updates has improved the performance significantly.

Worked on mappings between source and target systems.

Used SQL*Loader and External tables load legacy data, feed files data and data from various sources into database.

Modified and debugged several pl/sql programs for performance tuning using utilities explain plan, tkprof and profiler.

Created custom tools using VBA and Oracle PLSQL to load the data into nMarket.

Developed complex scripts for the data analysis to check the quality of data using regular expressions at database level

Created temporary tables and developed sql*loader control files to load the legacy data into the temporary tables

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL &

PLSQL engines

Created test scripts documentation for all the procedures that I have created.

Extensively used bulk collection in PL/SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context

switching.

Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and DynamicSQL.

Handled errors using Exception Handling thoroughly for the ease of debugging and displaying the error messages in the

application

Ability to analyze existing systems, conceptualize and design new ones, and deploying innovative solutions with high

quality standards.

Management of schemas, objects & partitioning the tables & indexes, users and privileges monitoring

Performed Logical (EXP/IMP) and Data pump for taking Backup of Database Objects.

Environment: Oracle 11gR2, ETL, VBA, SQL, PLSQL, XML, VSS, JAVA

nrg, HOUSTON, TX (Sep 14 – Jan 15)

Sr. Pl/Sql Developer

Responsibilities

Written PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.

Developed PL/SQL programs and packages to carry validation based on the requirements.

Created database triggers to flip flags and perform several business validations.

Developed a package containing several procedures and function using advanced Oracle concepts such as REF

CURSORS, BULK COLLECTS are used to improve performance.

Used Hints to force rules in order to improve query performance based on Explain Plan, TKPROF.

Created Materialized Views to reduce query run time for the end user.

Worked on mappings between source and target systems.

Created Oracle Objects Types using Object oriented in Oracle plsql.

Converted SAS code into Oracle.

Involved in taking backups and exports, FTP in UNIX environment.

Planned version control of production source code using Control SVN.

Participated in unit testing and prepared unit test documents.

Strong experience in using Altova XML Editor for mapping between one source system to Multiple target systems.

Involved in supporting/fixing post production defect fixes.

Attended Design meetings, code review and test review meetings.

Interacted and communicated with team members to solve/resolve issues.

Environment: Oracle 11g, SQL*LOADER, SQL, PL/SQL, PLSQL Developer, XSD,XSL, XML, SVN, JAVA, UNIX, Shell Scripting, SAS.

ABB, HOUSTON, TX (Nov 13 – Sep 14)

Sr. Pl/Sql Developer

Responsibilities:

Studied user requirements and functional specifications. Converted User Requirements into formal Technical specification

and Interfacing with clients.

Generated DDL statements for creation of new database objects like tables, views, sequences, functions,

synonyms, indexes, triggers.

Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages to implement business rules into the

application.

Used advanced SQL features like Inline views, advanced Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and

other analytical functions in 10g.

Involved actively in full life cycle (SDLC) of the project which includes Analysis, Design, Build, Testing phase.

Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and

Partitioning of tables.

Enhancing the existing packages for better performance and providing on-going support to existing applications and

troubleshooting serious errors when occurred.

Used Bulk processing for performance enhancement.

Extensively worked on migrations and Conversions with legacy systems data in Production Environment.

Develop API’s, ISO load processes, code to return data to screens with displaying appropriate error, warning and

information messages using logic in code and Exceptions

Developing Style Sheets using XSLT to Parse XML files that are downloaded or sent from ISO and to generate XML files

to submit client data to ISO

Created detailed technical specifications, developed application and system code, and participated in code reviews and

module testing, regression testing and supported ongoing maintenance.

Developed interfaces and final static variables for declaring constants.

Documented the application as per Javadoc.

Used JFrame, JDialog, JButton, JLabel, JTextField, JRadioButton, JComboBox, JMenuBar, JMenu, JMenuItem etc

In Swing.

Strong knowledge and experience in Altova Mapforce XML editor.

Involved in the creation of jar files during the deployment of the Application Server.

Stored Project documentation in Visual SourceSafe (VSS) environment.

Analyzed and reviewed business, functional, and high level technical requirements.

Extensively used Microsoft Visual source safe (VSS) for version controlling.

Extensively worked on building applications using Swing

Developed Stand alone application Screens using Java Swing and AWT API’s.

Prepared deployment and migration documents and scripts for deployment and backup the application

Involved in Debugging and Assembly test and user acceptance Test of the end product on the development environment.

Environments: Oracle11g, Sql, PL/SQL, SQL* Plus, PLSQL Developer, Sql*Loader, Eclipse, Java, AWT, HTML, JavaScript, JDBC, XML, XSL, Salesforce.

Constellation/MXEnergy, HOUSTON, TX (Apr 12 – Nov 13)

ETL/Oracle Pl/Sql Developer

Responsibilities

Prepared technical documentation about the implementation of business logic, Workflow diagrams and Activity diagrams

Involved in creating logical and physical data model for the application

Build a Utility Data Storage (UDS) data mart to gather all the Risk, Billing, Customer Operations and Accounting

data for generating the reports using OBIEE (11.5).

Tuned Application for peak performance using Hierarchical profiler, SQL Trace, TKPROF,

Worked with Oracle XML API’s to generate and parse XML

Coded applications using Oracle Object Oriented features to take advantage of OOPs concepts.

Develop Error handling mechanism to the process to efficiently handle production support

Unit Test and System test the application for defects and write tie out scripts for data tying.

Interfaces to load CSV files using External Tables

Develop API’s to do validations and load validated data into database after logging appropriate error, warning and

informational messages

Developed generic modules using dynamic SQL to do similar Validations in various processes.

Modify packages to debug client’s issues and analyze the cause of the issues and work on emergency release as per

client necessities

Environment: Oracle 11g, SQL*LOADER, SQL, PL/SQL, OBIEE11.5, PLSQL Developer, XSD,XSL, XML, VSS, XSD, Control-M, JAVA.

Reliant, HOUSTON, TX (Dec 11 – Mar 12)

Oracle Pl/Sql Developer

Responsibilities

Written PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.

Developed PL/SQL programs and packages to carry validation based on the requirements.

Created database triggers to flip flags and perform several business validations.

Developed a package containing several procedures and function using advanced Oracle concepts such as REF

CURSORS, BULK COLLECTS are used to improve performance.

Used Hints to force rules in order to improve query performance based on Explain Plan, TKPROF.

Created Materialized Views to reduce query run time for the end user.

Worked on mappings between source and target systems.

Created Oracle Objects Types using Object oriented in Oracle plsql.

Involved in taking backups and exports, FTP in UNIX environment.

Planned version control of production source code using Control SVN.

Participated in unit testing and prepared unit test documents.

Strong experience in using Altova XML Editor for mapping between one source system to

Multiple target systems.

Involved in supporting/fixing post production defect fixes.

Used Stylesheets to process the XML files.

Expertise in using Altova Mapforce XML between source and target mapping systems.

Attended Design meetings, code review and test review meetings.

Interacted and communicated with team members to solve/resolve issues.

Environment: Oracle 11g, SQL*LOADER, SQL, PL/SQL, PLSQL Developer, XSD,XSL, XML, SVN, JAVA

VENTYX/ABB, HOUSTON, TX (Mar 09 – Dec 11)

Oracle Pl/Sql Developer

Responsibilities:

Studied user requirements and functional specifications. Converted User Requirements into formal Technical specification

and Interfacing with clients.

Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms,

indexes, triggers.

Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages to implement business rules into

the application.

Used advanced SQL features like Inline views, advanced Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and

other analytical functions in 10g.

Involved actively in full life cycle (SDLC) of the project which includes Analysis, Design, Build, Testing phase.

Undertook Code Optimization and Performance Tuning of the application using Explain Plan, Hints, Indexing and

Partitioning of tables.

Enhancing the existing packages for better performance and providing on-going support to existing applications and

troubleshooting serious errors when occurred.

Used Bulk processing for performance enhancement.

Extensively worked on migrations and Conversions with legacy systems data in Production Environment.

Created detailed technical specifications, developed application and system code, and participated in code reviews and

module testing, regression testing and supported ongoing maintenance.

Developed interfaces and final static variables for declaring constants.

Documented the application as per Javadoc.

Used JFrame, JDialog, JButton, JLabel, JTextField, JRadioButton, JComboBox, JMenuBar, JMenu, JMenuItem

etc in Swing.

Used Input Validations in Swings.

Strong knowledge and experience in Altova Mapforce XML editor.

Involved in the creation of jar files during the deployment of the Application Server.

Stored Project documentation in Visual SourceSafe (VSS) environment.

Analyzed and reviewed business, functional, and high level technical requirements.

Extensively used Microsoft Visual source safe (VSS) for version controlling.

Extensively worked on building applications using Swing

Developed Stand alone application Screens using Java Swing and AWT API’s.

Prepared deployment and migration documents and scripts for deployment and backup the application

Involved in Debugging and Assembly test and user acceptance Test of the end product on the development environment.

Environments: Oracle10g/11g, Sql, PL/SQL, SQL* Plus, PLSQL Developer, Sql*Loader, Eclipse, Java, AWT, HTML, JavaScript, JDBC, Informatica Power Center 6.2/7.1,XML, XSL, Test Director.

The Structure Group, HOUSTON, TX (Jun 08 – Feb 09)

Oracle Developer

Responsibilities

Written PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application.

Data loading and data migration – Used SQL * Loader to load data from excel file into temporary table and developed

PL/SQL program to load data from temporary table into base tables.

Developed PL/SQL programs and packages to carry validation based on the requirements.

Associated and involved in different phases of System Development Life Cycle (SDLC).

Developed PL/SQL stored procedures, Functions, database triggers and created packages to access the database

from front end screens.

Developed views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source

staging area to target staging area.

Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data

from the database to flat files.

Created database reports by using PL/SQL to get the open enrollment and enrolled list reports.

Created database tables and wrote database triggers applicable to the business rules.

Developed triggers and packages to delete the stored session data from various tables.

Involved in writing conversion scripts package to reformat the extracted batch process file and export it to real time using

PL/SQL.

Involved in modifying various existing packages, procedures, functions and triggers according to the new business

needs.

Involved in debugging various defects relating to implementation of business logic.

Integrated menus in the forms to perform various functions like populating the database, deleting records, editing records,

etc.

Defined and documented report specification for the changes/updates to all reports or screens

Environment: Oracle 9i/10g, SQL*LOADER, SQL, PL/SQL, PLSQL Developer, XSL, XML, Test Director, VSS, Core JAVA.

SPRINT, VA. (Sep 07 – May 08)

Oracle Pl/Sql/Teradata Developer

Responsibilities

Created custom functions, stored procedures, packages, database triggers to retrieve the data from data base.

Responsibilities include design, development, testing & Implementation of EDW daily receive pre-processing (UNIX Shell

Scripts), de-normalization for reporting purpose, data security issues, development of ETL Process & currency translation

(Fast load, Multi-load, Bteq scripts & Teradata SQL), development of ETL extract process (UNIX Shell Scripts

(Korn) & Adaptive Server 11.5), testing of data for the developed modules.

Enhancing the existing packages for better performance and providing on-going support to existing applications and

troubleshooting serious errs when occurred.

Produced Scripts to cleanse source data, ETL process data with business rules, and built re-usable Mappings.

Developed SQL queries to fetch data from different tables in remote databases using database links and maintained logs

for the results.

Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and

materialized views for remote instances.

Used Hints to force rules in order to improve query performance based on Explain Plan and TKPROF.

Involved in optimization process through creation of partition tables, views, indexes etc. Also tuned and optimized SQL

statements.

Extensively created indexes to avoid the performance issues and full table scan.

Involved in taking backups and exports, FTP in UNIX environment.

Examined Source Data, Investigated Oracle Objects and Identified method for Data Migration into the target.

Used Bulk processing for performance enhancement.

Extensively worked on migrations and Conversions with legacy systems data.

Involved in creating indexes on huge tables to get the data faster.

Created UNIX Shell Scripts to process reports and update external table flags to enable reports to be viewed on web.

Extensively involved in writing scripts using UNIX shell scripts used CRON jobs for batch flows.

Prepared documentation for the user guidance.

Environments: Oracle 10g, PL/SQL, SQL Plus, Teradata V2R6.1, TOAD, UNIX, Perl Scripting, Oracle SQL Developer, Sql*Loader, Control-M.

Rapt, CA. (Jun 07 – Sep 07)

Oracle Pl/Sql/ETL Developer

Responsibilities

User Requirements gathering by interacting with the stakeholders and other management personnel to get a better

understanding of the business process.

Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.

Involved in the data analysis and data discrepancy reduction for the source and target schemas.

Created database triggers to flip flags and perform several business validations.

Involved in development of the SQL Scripts, Stored Procedures, Functions, Database Triggers and Packages using SQL

and PL/SQL as per the change documents requirements to incorporate the changes.

Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data form staging

tables into base tables.

Produced Scripts to cleanse source data, ETL process data with business rules, and built re-usable Mappings.

Performed the requirements analysis, process and data flow analysis, functional specifications, data modeling, physical

database design, forms design and development, data conversion, performance analysis and tuning.

Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.

Created various database objects like tables, views, sequences, functions, and indexes.

Written complex SQL statements using joins, sub queries, and correlated sub queries.

Made enhancements with the existing packages for better performance and providing on-going support to existing

applications and troubleshooting serious errors when occurred.

Extensively worked on SQL, created joins between huge tables and materialized views to map the columns from multiple

tables.

Performed the uploading and downloading flat files from UNIX server using FTP.

Scheduled the jobs using crontab in UNIX.

Environments: Oracle 10g/9i, SQL, PL/SQL, ETL, Informatica Power Center 6.2/7.1, SQL server, SQL Plus, SQL*Loader, TOAD, Autosys, UNIX, Shell Scripting

Contact this candidate