SUMMARY

• About 9+ years of experience in Information Technology providing professional service as Oracle developer in planning, analysis, design, development, enhancement, testing and maintenance using Oracle database.
• Involved in system study, design, development, and implementation stages of SDLC in various projects until the maintenance level.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design. Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Strong work experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL).
• Extensive knowledge on PL/SQL components like Procedures, Functions, Cursors, Packages, Triggers, Shell Scripts and SQL Loader scripts and other features such as VARRAYS, Nested Tables, Index by tables, Bulk Collections, Collections, Analytical functions, Database Triggers using features like Exception Handling, REF Cursors and Bulk binding.
• Experience in application development using various advanced features of Oracle like Autonomous Transactions, Dynamic SQL, Object types and Records.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles, Materialized Views and privileges.
• Extensively worked in Client - Server application development using Oracle 11g/10g/9i SQL, PL/SQL, Oracle Import and Export Utilities.
• Good knowledge about the principles of DW like ER modeling, Data marts, OLTP, OLAP, Dimensional Modeling, Fact Tables, Dimension tables and star/snowflake schema modeling.
• Hands on experience working on UNIX shell scripts.
• Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/ Export, bulk and batch processing.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL Plus, create indexes and import data from different schemas and also in SQL performance tuning using Cost BasedOptimization(CBO)
• Technically proficient in RICEW (Reports, Interfaces, Conversions, Extensions, Workflow) Concepts.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development.
• ExperiencewithOracleSuppliedPackagessuchasDBMS SQL, DBMS JOBandUTL FILE.
• Develop reports against Star Schema and Snow-Flake Schema.
• Experience in working with Informatica Power Center for Extract Transformation and Loading of the data from different sources to targets which includes relational source, flat files, XML's etc.
• Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters, context filters, user filters according to the end user requirement.
• Expertise in Scrum - Iterative and incrementalAgile software developmentmethodology
• Well-Organized, quick learner, self-motivated great Team player with Strong interpersonal skills, communication skills and documentation skills

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i, MS SQL Server 7.0/2008/2005 , Teradata

Programming Languages: SQL, PL/SQL, JAVA, XML, Shell Scripting, Visual basics 6.0, C, XSL (XSLT, XPATH), HTML

Tools: Informatica Power Center 9.x/8.x/7.x, TOAD, SQL Developer, PL/SQL Developer, SQL * Plus, SQL* Loader, Erwin, Cloud Controller, Autosys, Version control tools (SVN, Clear case, Clear quest, CVS), Tableau

Operating Systems: UNIX (Sun Solaris, HP UNIX, AIX, LINUX), Windows

Office Tools: MS Word, Excel, Power Point, Visio, UML, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr Oracle PL/SQL developer

Responsibilities:

• Worked with business analyst to identify, develop business requirements, transform it into technical requirements and responsible for deliverables.
• Application development using Scrum - Iterative and incrementalAgile software developmentmethodology
• Extensively developed various PL/SQL Stored packages, Procedures, Functions, Collections, Cursors, Ref Cursor, Object Types, Triggers, analytical functions.
• Development of the Mappings, Lookups, reusable components, Sessions, Workflows.
• CreatedRecords, Tables, Objects, Views,Materialized views, Exceptions, Indexes, Triggers, Compound Triggers, DB Links, Privileges and Global temporary tables(Nested Tables and Varrays), and performed Error Handling.
• Wrote PL SQL scripts and used couple of metadata tables to do Data Profiling, Referential Integrity and Data Quality before loading data into staging area.
• Used PL/SQL programming to develop standard packages like DBMS SQL, DBMS JOB, and UTL FILE.
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information.
• Developed reports, dashboards, and SQL queries using Tableau. Developed & Implemented Reports using Tableau Server.
• Leveraged Tableau built in graphical capabilities to create bar charts, tree maps, area charts and also created custom visualization like donut charts, trellis plots etc.
• Leveraged EXPLAIN PLAN, TKPROF, AWR, SQL Tuning Advisor and SQL TRACE utilities to fine tune PL/SQL subprograms and batch jobs.
• Utilized SQL*Loader to load flat files database tables.
• Code optimization using Bulk SQL and Bulk Binding.
• Used Cloud Controller and CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Handled various exceptions to troubleshoot PL/SQL code.
• Knowledge in Data ware housing for creating of fact tables.
• Tuned Report performance by exploiting the Oracle's built-in functions and rewriting SQL statements.
• Test case/data preparation, execution and verification of the test results.
• Responsible for documentation of all the project developments and modulations as per the standards defined and the system requirements.
• Participating in user acceptance testing (UATs), making necessary adjustments to coding structures based on user recommendations
• Creating the design document for the entire process identifying issues, providing solutions, logical & physical table structures

Environment: Oracle 11g, Toad, PL/SQL Developer, SQL Developer, SQL * Loader, Java1.7, Erwin, UNIX, XSLT, WinSCP, Clear Case, Clear Quest, IBM ISM, HP QC, Cloud Controller, Autosys, Tableau Desktop 8, 9.1, Windows XP.

Confidential, Detroit, MI

Sr. Oracle Developer

Responsibilities:

• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• Participating in client meetings or conference calls for technical & business requirements reviews.
• Developed PL/SQL procedures, functions, Sequences and packages for processing business logic in the database.
• Extensively developed procedures and packages being called by using the Shell Scripts, Perl scripting, which was written in Unix.
• Developed new modules, which enhanced and improved the functionality of the Application.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• CreatedPL/SQLobjects such as tables, views, synonyms, sequences, triggers, Ref cursors, Dynamic SQL and database links as well as custom packages tailored to business requirements.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions
• Troubleshooting and resolving issues in various aspects of the post production support.
• Wrote complex ad-hoc reports using SQL Plus and TOAD for the business users.
• Scheduled the batch jobs to execute the DB jobs using the DB schedulers.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN.
• Partitioned the fact tables and materialized views to enhance the performance.
• Extensively used bulk collection in PL/SQL objects for improving the performing.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application
• Created scripts to load data from flat files into Oracle database tables using shell scripts and Oracle packages
• Written complex SQL queries with complexity using Inner/Outer joins, Union All, Intersect & Minus set operators.
• Data export and import using Oracle data pump utilities
• Created events and tasks in the work flows using workflow manager.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Writing unit/integration test cases and done the unit testing/ Integration testing to achieve the functionality.
• Used Rational Clear case to manage various versionsof the code.
• Leading the DB team, coordinating with front end team and delivered the good quality of code.
• Provided the post production support and prepared the knowledge base document for support people to cross verify the files.
• Monitored the Prod Tickets, Change Control tickets throughJIRAsystem

Environment: Oracle 11g/10g/9i, SQL*LOADER, SQL PLUS, HTML, Rational Clear case 7.0, Informatica Power Center 9.1, JAVA, TOAD, XML, HP-UNIX shell scripting.

Confidential -Irving, TX

PL/SQL Developer

Responsibilities:

• InvolvedinfulldevelopmentcycleofPlanning,Analysis,Design,Development,TestingandImplementation.
• Involved in gathering business requirements, and designed the process flow for the tool.
• Prepared the Technical Design Document based on the Business Requirement for various modules.
• Developedpackages,procedures,triggers,functions,Indexes, analytical functions andCollectionstoimplementbusinesslogicusingSQLNavigator.CreatedPL/SQLscriptsfordatamanipulationandvalidation.
• Developed Various Shell Scripts for automation & validation.
• Worked on Dynamic SQL by using Execute Immediate and DBMS SQL along with Bulk Collect.
• DesignedlogicalandphysicaldatamodelsforstarandsnowflakeschemasusingErwin.
• Wrotesequencesforautomaticgenerationofuniquekeystosupportprimary keyandforeignkeyconstraintsindata conversions.
• CreatedandmodifiedSQL,PL/SQLandSQL*Loaderscriptsfordataconversions.
• WorkedonXMLalongwithPL/SQL and version control tool software CVS.
• Used Ref cursors, Records and Tables in PL/SQL programming.
• DesignedDataModeling,DesignSpecificationsandtoanalyzeDependencies.
• Tested the application to ensure proper functionality, data accuracy, and modifications had no adverse impact on integrated system environment.
• Creatingindexesontablestoimprovetheperformancebyeliminatingthefulltablescansandviewsforhidingtheactual tablesandtoeliminatethecomplexityofthelargequeries.
• Finetunedprocedures/SQLqueriesformaximumefficiencyinvariousdatabasesusingOracleHints.

Environment: Oracle 10g,Toad, SQL*Plus,PL/SQL,CVS, Windows2000

Confidential

Oracle Developer

Responsibilities:

• Developed PL/SQL stored procedures, Materialised views, Functions, Analytical functions, Triggers, packages and views.
• Fixing bugs according to the software change requirement.
• Responsible for unit testing, and documentation of the interfaces.
• Loaded the data into database using the SQL*Loader from various sources.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Involved in Data warehouse design with star schema.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Worked on troubleshooting defects in timely manner.
• Automating processes triggering events on scheduled days & times as defined by management using DBMS JOB
• Written shell scripts and are scheduled using cron jobs.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plan, Hints to reduce the response time.

Environment: Oracle database 9i, PL/SQL, SQL Plus, SQL*LOADER, SVN, Windows 2000 Professional and UNIX.

Confidential

Software Engineer

Responsibilities:

• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Used PL/SQL programming to develop Stored Procedures, Sequences, Functions, Materialized views and Database Triggers including standard packages like DBMS SQL, DBMS OUTPUT.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.
• Loaded data from Existing database schema to new schema using Oracle Packages.
• Utilized SQL*Loader to load flat files database tables.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
• Highly experienced on developing Oracle SQL scripts to facilitate the functionality for various modules.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Developed and implemented various migration scripts for various schema objects migration.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.

Environment: Oracle 9, Oracle PL/SQL developer, Unix, TOAD, SQL*Plus, SQL*Loader, Shell Scripting.