SUMMARY:

• Over 8+ years of programming experience as an Oracle PL/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, Stored Procedures, Functions, Triggers, Packages and 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.
• Extensive database development experience, including oracle using SQL and PL/SQL, and MySQL development using SQL and PHP.
• 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.
• 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
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Deep knowledge of Oracle Retail merchandising systems and processes for global retail companies.
• Strong experience with Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Designed, prototyped and wrote coding standards for WCAG 2.0 AA compliant websites and application.
• Analyzed traffic patterns and abandonment rates of ecommerce solutions
• 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 UNIX Shell Scripting (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, Visual Studio.NET.

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 8.0, 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, F-Secure 5.3, SFTP, Pro*C, Rational Rose, Microsoft Visio, ER-Studio, Erwin 3.5.2/4.0, MS Visio, BI, DWB, Oracle Retail merchandising systems (RMS).

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, IIS, AJAX, SOAP and Active X, WCAG 2.0.

EDUCATION: Bachelor of Technology in Computer Science from JNTU Hyderabad.

PROFISSIONAL EXPERIENCE:

Confidential, Austin, TE

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.
• Converted legacy PL/SQL code to PHP to read from MySQL databases.
• 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.
• Developed ETL scripts using PHP to convert data from oracle to MySQL databases.
• 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 in TFS, & 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.
• 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 to make the jobs automated.

Environment: Oracle 10g /11g, PL/SQL, SQL, TOAD, SQL Developer, Pro*C, Data Modeling, Oracle Forms & Reports, 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, Columbu

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 Indexes for 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 TKPROF utility 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.
• 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 reports 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, Windows XP, INFORMATICA.

Confidential, 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.
• 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.
• 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.
• 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.