SUMMARY

• Over 8+ years of programming experience as an OraclePL/SQL developer, System Analysis, Design, Development & Support of Oracle Database 8i, 9i, 10g and 11g in Production, Staging, Development environments.
• Proficient working experience with SQL, PL/SQL,StoredProcedures, Functions, Triggers, Packagesand using the latest features to optimize performance.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Experience withData Modeling, Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modelinganddesign techniques.
• Experience in working AGILE projects.
• Experience in working with TFS and Sprint Iterations.
• Expertise in Client - Server application development using Oracle11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOADandSQL*LOADER.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable table spaces
• Extensive Experience with Oracle tools like SQL, PL/SQL, SQL*PLUS, SQL Developer, PL/SQL Developer, TOAD.
• Experience in Designing the Database using tools Erwin, MS Visio and good knowledge of Relational Database Management System (RDBMS).
• Excellent experience with performance tuning, Normalization and De-Normalization, Partitioning of Tables.
• Expertise in developing Oracle Forms/Reports using complex queries.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using INFORMATICA.
• Good Knowledge of data warehouse Concepts and ETL tools like INFORMATICA.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Good hands on experience with programming languages like C, C++, and Java.
• Experience in software testing, unit testing, regression testing, and defect tracking.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• In depth knowledge and experience with Oracle products on Windows Server 2008/2012.
• Strong experience with Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Proficient in advance features of Oracle 11g /10g for PL/SQL programming like Using cursor variables, Ref. Cursors, VARRAYS, Nested tables, Dynamic SQL, Bulk Binds, Inline views, Global Temporary Tables.
• Experience in application and database Fine-tuning using explain Plan, SQL Trace and TKPROF.
• Extensive knowledge of using DBMS Oracle supplied package like UTL FILE, DBMS JOBS, DBMS SCHEDULER, DBMS ALERT, etc.
• Hands on experience working with DB Links and also creating materialized views like Read Only, Updatable, Writeable.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTPand dimension modeling forOLAP.
• Expert in UNIXShellScripting (Bourne, KORN), Perl scripting.
• Hands on experience with CRONTAB in UNIX environment for scheduling routine tasks.
• Good experience working with various FTP protocols like FTP using SSH protocol.
• Clear communication and documentation of technical specifications.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers and expert Skills in time management, prioritizing tasks.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, C, C#, Shell Programming (Bourne, KORN), Java, Perl Scripting.

Databases: Oracle 8i/9i/10g/11g/12c,RE MS SQL Server 2005/2008, MYSQL, MS Access,DB2/UDB

Reporting Tools: Oracle Forms & Reports 6i/9i/10g, Crystal Reports, Business, ObjectsDeveloper Suite 5.1/BO XIR2, COGNOS Suite, COGNOS.

ETL Tools and Others: INFORMATICA (Power-Center 5.1/6.2/7.1/8.6.1/9.1.0 ), Power-Mart 5.1, Power Connect/Power Exchange for SAP R/3, Main-Frame and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader. TOAD 12.x, SQL Developer, PL/SQL Developer, Pro*C, Rational Rose, Microsoft Visio, ER-Studio, Erwin 3.5.2/4.0, MS Visio, BI.

DB Utilities: SQL Loader, Export / Import, Data pump, Explain Plan, TKPROF.

Operating Systems: UNIX (LINUX, Sun Solaris, Linux, HP Unix, AIX), Windows NT/XP/Vista/7, Windows 95/98/2000/NT, Windows Server 2003/2008.

Web Technologies: HTML, DHTML, XML, JavaScript.

PROFESSIONAL EXPERIENCE

Confidential, Austin, TEXAS

Sr. Oracle PL/SQL Developer

Responsibilities:

• Responsible for requirements analysis, database design, development and unit testing of the application.
• Creating design and implantation/deployment instructions document.
• Ability to write optimized code and work independently.
• Experience in working AGILE projects. Understanding the current application, applying enhancements to the application.
• Good understanding of user requirements and coming out with corresponding functional and non-functional system requirements.
• Extensively involved in writing SQL queries and PL/SQL programming.
• Involved in Creation of DB objects like Tables, partitioning tables, Indexes, sequences, views.
• Worked with offshore teams located in India and Brazil, and daily we interact by conducting LYNC/SCRUM meetings.
• Coordinated with offshore teams located in India and Brazil and manage in deliver of plan/assign work for members. Support team if required w.r.t. troubleshooting.
• Involved in discussions with business on new functionalities to be built in.
• Had been an Interface between the client and developers, Keep on posted updates to the client regarding project status.
• Hands on experience inTFS, &we used to have Sprint Iterations for two weeks.
• Updates the tasks in TFS sprints and Defects are raised in TFS queries log.
• Updated Status of the tasks daily with estimated hours, remaining hours and completed hours.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Involved in migrating the Oracle database from 10g to 11g.
• Worked on SQL Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Extensively used the advanced features of PL/SQL like collections, ref cursors, and dynamic SQL, nested table, arrays, ref cursors, materialized views and dynamic SQL.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used the Control-M job scheduling tool tomake the jobs automated.

Environment: Oracle 10g /11g, PL/SQL, SQL, TOAD, SQL Developer, PL/SQL Developer, SQL*PLUS, Windows 7/8,Control-M.

Confidential, Kansas City, MO

Sr. Oracle PL/SQL Developer.

Responsibilities:

• Responsible for requirements analysis, database design, development and unit testing of the application.
• Extensively involved in writing SQL queries and PL/SQL programming.
• Performing hands-on analysis, manipulation and loading of customer-provided data and providing reporting on loading using SQL*Loader.
• Involved in Creation of DB objects like Tables, partitioning tables, Indexes, sequences, views.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexes for faster retrieval of the customer information and enhance the database performance.
• Worked on SQL Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Created the DB design using Erwin, MS Visio tools or modifying the existing design according to the new requirements.
• Extensively used the advanced features of PL/SQL like collections, SQL, Nested table, VARRAYS, Ref Cursors, Materialized views and Dynamic SQL.
• Used data pump utilities (EXPDP/IMPDP) for Copying of data from development server to test and production server using.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROF utility to get the report for the trace file.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Developed flat files using UTL FILE Oracle supplied package.
• Wrote Perl Scripts according to the requirement.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.

Environment: Oracle 10g /11g, PL/SQL, SQL, TOAD, SQL Developer, PL/SQL Developer, SQL*PLUS, Pro*C,Solaris 5.10, UNIX, Perl, Windows XP/7, MS Visio, Erwin, ER-Studio.

Confidential, Columbus, Indiana

Sr. Oracle PL/SQL Developer

Responsibilities:

• Involved in Creation of tables, partitioning tables, Join conditions, correlated sub queries, nested queries, views, sequences, synonyms for the business application development.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Created Indexesfor faster retrieval of the customer information and enhance the database performance.
• Extensively used the advanced features of PL/SQL like collections, nested table, varrays, ref cursors, materialized views and dynamic SQL.
• UsedSQL*Loaderas an ETL tool to load data into the staging tables. UsedDTS Packagesas ETL tool for migrating Data from SQL Server 2000 to Oracle.
• Worked on Application level Performance tuning.
• Used Explain plan and auto-trace for tuning the SQL and Generated session level trace and used the TKPROFutility to get the report for the trace file.
• Used Oracle 10g new feature data pump utilities (EXPDP/IMPDP) for Copying of data from development server to test and production server using.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Utilized SQL*Loader to perform bulk data loads into database tables from external data files.
• Used DBMS FGA to provide fine grained security.
• Worked on WCAG and involved in Client-Side Programming, Data Communications, Database & Data Modeling, Human Factors, Interactive Digital Media, Interface Design, Internetworking Lab, Needs Assessment and Web Design, XML
• Developed flat files using UTL FILE Oracle supplied package.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Used Validation Controls and Custom validation control to validate Web forms

Environment: Oracle 10g /11g, PL/SQL, SQL, TOAD 9/10, SQL*PLUS, Solaris 5.10, UNIX, Perl, Windows XP,Pro*C, C#.Net, IIS 6.0,WCAG 2.0, INFORMATICA.

Confidential, Virginia

Sr. Oracle PL/SQL Developer

Responsibilities:

• Analysis of business requirements and converting business rules into design software to meet the requirements.
• Participated as a team member and involved development of application.
• Developed tables, indexes, constraints, views and sequences.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Used PL-SQL features like cursors, ref cursors, Exception handling.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Involve in Tuning, Performance and Optimization of queries and standardization of the code.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Planned the index rebuilding, index analyze and table analyze on periodical basis.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.
• Oversee all stages of design, development, and deployment of new Java-based vendor application system for financial-services industry.
• Used SQL Server SSIS tool to build high performance data integration solutions including extraction, transformation and load packages for data warehousing. Extracted data from the XML file and loaded it into the database.
• Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications etc).
• Developed LOV’s and Triggers for different data blocks.
• Developed forms Using Tab-canvas, Stacked, Content and Horizontal toolbar canvas.
• Developed Oracle Reports/Forms using complex queries as per client request as a part of production support.
• Generated Reports on the daily basis according to client requirements using Crystal Reports.

Environment: Oracle 10g/11g, SQL, PL/SQL,, SQL*PLUS, TOAD 8.x/9.x, Java, Oracle Forms and Reports 10g/9i, Crystal Reports, UNIX, Perl,SQL Server SSIS, Windows XP, INFORMATICA.

Confidential, Chandler, Arizona

Oracle PL/SQL Developer

Responsibilities:

• Performed database and query tuning and performance monitoring.
• Enforced database integrity using primary keys and foreign keys.
• Monitored growth of data and managed space allocation accordingly.
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers & maintaining Referential Integrity.
• Extensively written PL/SQL code for stored Procedures, Functions, Packages, Libraries and other database triggers etc. Written interfaces to transfer/interact data with various external systems.
• Used %TYPE and %ROWTYPE for anchoring the variables to the database data types.
• Used package like DBMS JOB to determine if there are any jobs that are to be performed, or any changes are made to the program or procedure.
• Backup strategies, scheduling the backups. Backing up and restoring the databases whenever necessary.
• Actively involved in coding SQL statements in PL/SQL.
• Helped my team in installing the Operating System Windows Server 2008, Oracle Virtual Box, VMWare and Server manager.
• Developed various Complex Queries, Views for Generating Reports.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Used Quest TOAD to tune query performance.
• Performed off site on call 24x7 production support for Oracle 8i database administration activities.
• Trouble shooting performance issues using Explain Plan and TKPROF.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block, and applied business rules on them.
• Created public synonyms on the database links for easy reuse.
• Created database links to retrieve data from multiple servers.
• Used EXPORT/IMPORT to do table level and full database de-fragmentation.
• Managing Tablespaces, Rollback segment, Indexes for various applications like Financials Accounts, Inventory Control System and Payroll & Personnel Administration System.
• Made Forms customization on various existing forms.
• Use built-in functions in oracle forms.
• Created layout wizard and data block wizard in oracle forms.
• Created LOVs, record group in oracle forms.
• Created and customized UNIX shell scripts for automating regular maintenance and batch jobs.

Environment: Oracle 9i/10g/11g, PL/SQL, Windows 2000, SunOS 5.8, Crystal reports 9, SQL*Loader, TOAD 8.5, SQL Navigator, Oracle Forms 9i/Oracle Report 9i.

Confidential, San Antonio, TX

Oracle PL/SQL Developer

Responsibilities:

• Wrote packages, stored procedures for storing the client information in providing the services of cloud computing and email applications using PL/SQL.
• Developed batch files to manage batch order processing and scheduled them using Windows scheduler.
• Created views pointing to different databases to get the data from interface modules.
• Created indexes for avoiding full table scans and disks sorts, and improved the performance and tuned the oracle queries.
• Creation of many Database Packages, Functions, and Procedures.
• Developed database triggers and stored procedures using PL/SQL cursors and tables.
• Used PL/SQL Dynamic procedures during Package creation.
• Created triggers to apply complex business logic and for auditing.
• Trapping the error codes and error messages and inserted them into a lookup table for further use.
• Optimized critical queries to eliminate full table scans using EXPLAIN plan, TKPROF.
• For Optimization Process actively involved in creating views, materialized views, partitioning tables and creating indexes etc.
• Migrated/Upgraded Oracle Database from 9i to 10g.
• Hands on programming languages, including C#, C, C++, JavaScript, HTML, and XML.
• Responsible for making enhancements to the existing database.
• Created SQL Loader scripts and External tables to load the data from flat files and validated the data with PL/SQL procedures.
• Sorted issues of long time taking queries by using dynamic SQL statements like Execute Immediate and DBMS SQL.
• Reviewed the code and debugged the errors.
• Involved in different phase of testing like User Acceptance Testing, Unit testing.
• Involved in writing Test cases and performing data validation and process testing for application moving into production.

Environment: VB 6, Oracle 9i/10g, SQL, PL/SQL, SQL Developer, Java, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.

Confidential

Oracle Forms & PL/SQL Developer

Responsibilities:

• Study the scope of the systems.
• Analyzed and designed the various PL/SQL scripts in accordance with the necessary Business rules and procedures.
• Participated as a team member in the analysis of the system.
• Creation of many Database Packages, Functions, and Procedures.
• Developed database triggers and stored procedures using PL/SQL cursors and tables.
• Used PL/SQL Dynamic procedures during Package creation.
• Extensively used the advanced features of PL/SQL like collections, nested table, VARRAY&Dynamic SQL.
• Created the indexes and analyzed the table for better performance.
• Used case statements and expressions while writing PL/SQL block.
• Used DBMS REDEFINATION package to rename columns and constraints.
• Extensively used Explain Plan, TKPROF for SQL query optimization.
• Used PL/SQL tables, PRAGMA AUTONOMUOS TRANSACTION to avoid mutating problem in database trigger.
• Worked extensively on exception handling, to trouble-shoot PL/SQL code.
• Customized data by adding calculations, summaries and functions.
• Developed Front end with Forms 6i.
• Wrote DDL statements and triggers in oracle forms.
• Wrote PL/SQL Library and triggers in oracle forms.
• Developed LOV’s and Triggers for different data blocks.
• Developed complex Oracle forms providing extensive GUI features (multi-selects drag and drop, graphical charts, automated system alerts and notifications.
• Designed and developed Oracle forms & reports generating up to 60 reports.
• Involved in coding and implementation of PO’s, other bills, LC’s, Service tax and other advances, LC Payments.
• Managed and resolved design issues during development stage. Worked closely with other developers.
• Bridged the connection between Oracle Database and Java Application using JDBC Driver and data transfer.
• Develop application code for java programs. Develop and execute unit test plans. Support formal testing and resolve test defects.
• Used the methods provided in the JDBC API to create, read, update and delete the data from the database.
• Prototype demo to the management and users.

Environment: Oracle 9i, PL/SQL, SQL Developer, Java, Forms 6i, Reports 6i, Windows XP, UNIX.