SUMMARY

• Around 8 years of experience as OraclePL/SQL developer in Analysis, Design and Implementation of Oracle E - Business Suite Applications
• Involved in all phases of the SDLC (Software Development Life Cycle) from Analysis, Design, Development, Testing, Implementation and Maintenance with timely delivery.
• Expertise in Tableau, Oracle, MySQL
• Expertise in writing Packages, Stored Procedures, Functions, Views, Database Triggers using SQL and PL/SQL in Oracle.
• Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Proficient knowledge in HTML and JavaScript.
• Manipulated Stored Procedures, Triggers, Views, Functions and Packages using TOAD.
• Experience in Performance Tuning & Optimization of SQL statements.
• Experienced in identifying Business requirements, Technical requirements, Database Design, Troubleshooting and writing interfaces between various applications.
• Created materialized views like primary key, rowid, and sub query materialized views.
• Strong in writing Stored Procedures and SQL queries
• Proficient in data loading/extraction using SQL*Loader and Oracle utilities.
• Good understanding of the Oracle database, related utilities and tools.
• Have extensive experience in Performance tuning by analyzing the execution plans of the query
• Hands on experience in tracking down the bottlenecks in query using trace files.
• In-depth knowledge on Tableau Desktop, Tableau Server and Tableau Viewer.
• Ability to design and display Graphic rich visualizations with Filters, Drill Downs and Parameters.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to requirements specifications
• Extensive experience in utilizing Collections to boost performance in PL SQL block.
• Strong Background in implementation of RDBMS and OOPS concepts.
• Excellent technical and analytical skills with clear understanding of OLTP and OLAP models.
• Creating different kinds of partitions on tables and indexes.
• Creating roles and granting to users based on their group requirements.
• Creating profiles and attaching them with users, performing.

TECHNICAL SKILLS

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

Languages: JAVA,C,C++,VB6.0,SQL,PL/SQL

Oracle Tools: ANSI SQL, Oracle PL/SQL, SQL*Plus, TOAD, SQL*Plus, SQL*Loader, Oracle procedure Builder

Development Tools: Developer 11g/10g/9i/6i/2000 Release 1 & 2, Reports 10g/9i/6i, Forms 6i/9i/10g

Reporting Tools: Tableau 7/8, Oracle Reports

Scripting Languages: Java Script, UNIX Scripting, shell Scripting

Web Technologies: HTML

PROFESSIONAL EXPERIENCE

Confidential, MA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures, functions, packages to view appropriate data at GUI.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day.
• Generated server side PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Created new mappings, modified existing mappings using Informatica Powercentre 8.6
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created scripts to createnew tables, views, queriesfor new enhancements in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Extensively involved in usinghints to direct the optimizerto choose an optimumquery execution plan.
• UsedBulk CollectionsFOR ALL forbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines, extensively used PLSQL Collections.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Generated custom reports on Oracle Reports using Oracle Reports builder and published the reports using report server.
• Created test packages to validate all new and existing procedures and functions in Unit Testing Phase.
• Involved all SIT, QA, UAT and Production deployment.
• Created batch jobs to load data into our database using UNIX Shell Script and Control - M scheduling.
• Created adhoc reports to users in Tableau by connecting to various data sources.
• Used several objects - Vertical, Horizontal, Blank, Tiled, Floating, Text, Web-page, Image in order to create efficient dashboard using tableau desktop.
• In order to improve the performance of the tableau desktop EXTRACT connection is used to get the data into Tableau data engine for faster retrieval of data. If the database is fast enough to retrieve the data then we usually go for LIVE connection.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Environment: Oracle 10g/11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP, Tableau, Informatica 8.6

Confidential, NJ

Sr. Oracle PL/SQL Developer

Responsibilities:

• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Performed Database Administration of all database objects includingtables, clusters, indexes, views, sequences packagesandprocedures.
• Upgraded the existing database from Oracle 9i to Oracle 11g.
• Involved inLogical & Physical Database Layout Design.
• Created queries to minimize transactions table data size and copy into historical tables.
• Modified exiting UNIX Shell Scripts to schedule daily jobs.
• Improved the performance of the application by rewriting theSQL queries.
• Involved application deployment process and co-ordinate with DBA Team.

Environment: Oracle 9i/11g, PL/SQL, TOAD, Sun Solaris, HP- Quality Center

Confidential, NY

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs and production support.
• Managing FDR applications and handling day to day support of the batches using job scheduler Tidal.
• Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
• Create new Tables, Indexes, Views, Materialized Views, Table Partitions as per the requirement.
• Create SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE
• Wrote complex stored procedures and packages
• Used FDR Scenario Manger to create new AML scenarios, writing complex queries Oracle.
• Developed daily, weekly, monthly Reports for alerts generated and scheduled Jobs.
• Worked on UNIX scripting for scheduling the jobs.
• Created and monitored the OracleDBMS JOBS as a part of weekly tasks.
• Involved in fixing bugs within Packages and Stored Procedures.
• Involved in all production support tasks and have working knowledge of Reporting Tool like Tableau.
• Involved in Tuning Database & Application performance using Explain Plan.
• Involved in the Daily maintenance of the database that involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process.
• Performed Unit Testing and Integration Testing of the Application. Involved in preparing documentation and user support documents.
• Wrote ad-hoc queries to generate reports for business users.
• Extensive analysis and reasoning of alerts generated by the system.

Environment: Oracle 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty and Crystal Reports.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system.
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.
• Used advanced features of SQL in order to design and tune SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning.
• Designed, developed and tested stored procedures, views and complex queries for Reports distribution.
• Developed database triggers and stored procedures using SQL cursors and tables.
• Effectively used views to prevent unauthorized access.
• Created packages for transforming data from various data sources.
• Tuned SQL queries using execution plans for better performance.

Environment: Oracle 10g, Windows 2000/NT/XP, TOAD.