SUMMARY

• About 8 years of programming experience as an Oracle and PL/SQL developer in Analysis, Design, Data Modeling (Logical and Physical) and Implementation of Business Applications using Oracle products.
• Strong experience in interacting with business analysts and developers to analyze and write the user requirements, functional specifications and system specifications.
• Strong Knowledge on oracle architecture and database design.
• Very good understanding of data warehouse principles like fact tables, dimension tables, star and snowflake schema modeling.
• Experience in data modeling using ERWIN.
• Extensively worked in Client - Server application environment using Oracle 12c/11g/10g/9i on Windows, UNIX/LINUX platforms, SQL*Plus, Developer and data migration using SQL*Loader.
• Implemented PL/SQL advanced topics like Bulk Collect, Ref Cursors, Dynamic SQL, Collections, UTL FILE to read and write the files.
• Design and Generation of different Database Objects like Tables, Views, Synonyms and Sequences, PL/SQL packages and Database Triggers.
• Strong knowledge in Exception Handling and also experience in performance tuning (PL/SQL) using Explain Plan, TkProf, Indexing and Hints.
• Well-acquainted in working with complex SQL queries with joins, date functions, inline functions, sub-queries to generate adhoc reports, Functions and Procedures.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL Developer, PLSQL Developer and SQL*Navigator.
• Very good experience in UC4 Scheduler. Created many jobs, process flows, events and scripts in Uc4.
• Good experience in transferring files from one location to other location by using mailbox/target ID.
• Working experience with Arrays, Lists using java.
• Working Knowledge on UNIX, Windows and Shell Scripting.
• Good experience in version control of documents and database objects using tools like CVS and SVN.
• Experience in developing reports and forms using Oracle forms and reports 6i.
• Immediate & long-term goals are met within operational deadlines.
• Ability to work both as an individual as well as a team.
• Self-motivated and organizational ability to effectively set priorities to achieve.
• Quality minded analyst, possess good interpersonal, analytical presentation skills.

TECHNICAL SKILLS

Languages/Scripting: SQL, PL/SQL, Unix Shell Scripts, Java

Databases: Oracle 12c/11g/10g/9i, MS-SQL Server 2008, MS Access.

Tools: SQL*Plus, SQL*Loader, Erwin, TOAD, PL/SQL Developer, SQL Navigator, Eclipse,UC4 Scheduler

GUI: Oracle Forms 6i and Reports 6i.

OS: UNIX, Windows XP, Windows 2000/2003, Windows 7.

PROFESSIONAL EXPERIENCE

Confidential

Lead Oracle PL/SQL Developer

Responsibilities:

• Interacted with BA team to understand requirement in specification.
• Created csv files for commodities and ice like as requested in specifications.
• Worked on DB link to get data from different databases.
• Added many columns to the upstream tables, which are needed for extracts.
• Written many procedures, functions, packages and views as required.
• Created many tables, views and materialized views.
• Used dbms mview. refresh to refresh materialized views.
• Wrote many complex queries by using joins and with clause.
• Worked on Partition and sub partition on the table.
• Gave grants to many tables, views, packages, procedures and functions.
• I worked on historization of tables. Some of the tables have only one day data, so worked on those tables to historize one week and month end data in tables.
• Created lot of scgibml files and sent to SG through file transfer process.
• I transferred files from new edge location to SG location by mailbox using target id.
• Done unit testing for all the tasks.
• Used parallel hint to improve the performance by running in parallel sessions.
• Used dynamic sampling hint in the view to get the correct plan.
• Created indexes on some tables to improve the performance of query.
• Created many sql jobs, Unix jobs and FTB jobs in UC4 process.
• Created many events in UC4 which will trigger after the upstream data is loaded.
• Created many workflows in UC4 and scheduled them to run on Monthly and Daily basis.
• Created many alerts and notifications in UC4 process. For example, if job is running more than expected then support team and developers will get an alert email mentioning that job is running long.
• Created all documents for the project by using word and Visio.
• Worked on many jira issues, jira is the tool used to track issues in Newedge.
• After merging into SG, worked on impulse, Impulse is the tool which is used for tracking issues and creating change management tickets.
• Used to attend the Change management meeting to review my tickets and get approvals for production deployment.
• Used SVN for version control of database objects.

Environment: s: Toad, Oracle 12C, Oracle 11g, Microsoft Word, Microsoft Excel, Microsoft Visio, Lotus Notes, Microsoft Outlook, Notepad++, putty, Winscp, UC4, Lync, Jira, Impulse, SVN, UNIX

Confidential, Littlerock, AR

Sr. Oracle PL/SQL Developer

Responsibilities:

• Interacted with Structured team people to understand the requirement of Detail Designed Document.
• Created tables and modified table structures by adding a new column to existing table and populated data into that column.
• Wrote many update statements to update data present in tables.
• Wrote a View, which contains all the generators that are in active state.
• Analyzed many packages and modified to meet the business requirement.
• Analyzed many functions and procedures and modified according to the business requirement.
• For testing I used to schedule a package to run for every 30 seconds.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote many views for GIA Application.
• Analyzed one of the existing packages and wrote functional document as per our business requirement.
• Given grants to tables, views, procedures, functions and packages from other schema.
• Worked with testing people to write the test cases for both the applications.
• Wrote some test cases to test the application in HPQC.
• Wrote java code for loadforecast and unitcommitment files using arrays and lists.
• Created many table, trigger, and sequence for TRA Application.
• Wrote many inserts scripts to insert Generator Company for every generator in table.
• Created a view, which contains flow gate statistics.
• Created a view, which contains all the open actions.
• Modified many views according to the business requirement for TRA Application.
• Wrote a function in TRA Application, which gives the total amount of load shed.
• Added many columns to the existing tables in TRA Application.
• Given grant by using ‘DBMS JAVA.GRANT PERMISSSION’.
• Modified many existing packages to meet business requirement.
• Pulled data by using views, procedures and functions.
• Done unit testing for both applications.
• Analyzed and fixed production bugs.
• Used Concurrent Versions System for version control to keep track of all work and all changes made to all files.

Environment: Oracle 10g, Toad, Windows 7, Microsoft Word 2010, Microsoft Excel, Microsoft Outlook, Concurrent Versions System (CVS), Notepad++, HP Quality Center, Eclipse, java SE6.

Confidential, Houston, TX

Sr Oracle PL/SQL Developer

Responsibilities:

• Interacted with the business users to get the requirements for calculating cost of goods for ERCOT market.
• I used many analytical and aggregate functions for mathematical calculations.
• Created Records, Objects, Collections to store ordered group of elements for faster assessment of tables.
• Used Bulk collections for bulk load processing.
• Analyzed some of existing Scripts and created technical specifications for the scripts.
• Altered many existing scripts as per the requirement.
• Improved the performance of the application by rewriting the SQL queries.
• Created views for UI team, If any user changes data in the frontend we used to do calculations and update data into backend tables.
• Created a monthly and hourly product data materialized views for daily reports.
• Used dbms mview.refresh to refresh materialized views.
• Analyzed existing package and made changes as per the business requirement.
• For Daylight-saving issue I used rank function to split hours based on duplicate hour column.
• Used dbms xml to generate a sql queries as xml format.
• Solved many bugs which are reported by business users.
• Used views, procedures and functions to pull data.
• Wrote complex sql queries by using joins.
• Created many Tables, Views, Synonyms and Sequences for the application.
• Created indexes for fast retrieval of data.
• Given grates to tables from other schemas.
• Given grants to packages from other schemas.
• Used User-defined and System defined exceptions to handle different types of Errors.
• Done unit testing for many packages, procedures and functions.
• Wrote a package, which is used to pull data from views and insert them into different tables based on meter type
• Wrote a package, which is used to pull data from curves and load them into table
• Wrote a package, when we pass an opportunity it will give total number of customers, sites, meters (Idr and scalar), products and deals closed.
• Wrote many other packages and scheduled some packages to run on daily basis by using DBMS JOB Scheduler.
• Wrote scripts for data conversions, Data are present in two tables my task is to write a script which populate data from two tables into one new table.
• Written documentation for existing scripts.
• Used SVN to version control all the database script.

Environment: Oracle 10g, PLSQL Developer, Microsoft Excel 2007, Microsoft Word 2007, windows XP, Microsoft Visio, Sub Version, Notepad++,Microsoft Outlook.

Confidential, Portland Oregon

Sr. Oracle PL/SQL Developer

Responsibilities:

• Inserted data into many tables according to the business requirement. For example when a new style is produced by a plant then we used to add that new style to style list, prod plnt Attr and prod plnt fcty attr tables.
• I worked in a production support team, so I used to make a back of data whenever we change data for tables by creating a new temporary table.
• Created ON DEMAND REQUESTS(ODRs) for some jobs to keep on-hold or on-ice .Again whenever we want that jobs to be run, I create a ODR for that jobs to keep them OFF ICE or Off HOLD.
• I used to check the LER checks every day before batch runs. There are some steps to follow that LER checks
• I used to verify by writing query, whether batch run date is correct.
• I used to check the disk space availability by using command df - v.
• I used to check whether demand pull is in enable state.
• I used to verify flags in profile file by using command vi.profile. After that I used to check two conditions in profile file.
• We used to have WCC editor there I used to check whether the batch run is enrolled for that particular day in calendar.
• I used to take a backup a database after taking backup I used to compress that file by using gzipbackupfile.
• Solved many bugs reported by business users.

Environment: s: Oracle 10g, Toad, Microsoft Word 2007, Microsoft vision 2007, UNIX, Microsoft Outlook

Confidential, Houston Texas

Sr PL/SQL Developer

Responsibilities:

• Interacted with Business team to understand project specifications.
• Analyzed script to make sure the mapping was done as per data dictionary.
• Created many tables, views, procedures, functions and packages as per requirements.
• Created technical specifications for the scripts.
• Altered many existing scripts as per specifications.
• Improved performance of the application by rewriting SQL queries.
• Used advanced SQL like Aggregate functions and analytical functions for mathematical and statistical calculations.
• Created documents by using Microsoft word and visio.
• Created many csv files as per the requirements.

Environment: s: Oracle 10g, Toad 10.1, Microsoft Word 2007, Microsoft vision 2007, Microsoft Outlook