SUMMARY:

• More than 14+ years of extensive experience in design and development using Oracle database and data warehousing applications, PL/SQL, SQL, SQL*Loader, SQL*PLUS, External Tables Unix Shell Scripting, Perl and Autosys.
• Extensive experience in data modeling, design and development of logical and physical models and normalization. Implemented, tested and supported databases and data models.
• Designed and developed OLTP applications using Oracle SQL and PL/SQL. Developed very efficient, concurrent and reliable system.
• Did dimensional modeling. Designed and implemented dimension and fact tables. Partitioned the tables. Created appropriated portioned and global indexes.
• Extensive experience of development in complex data warehousing environment Expertise in ETL development involving very large warehouses (VLDB) having billions of rows per table. Designed, developed, tested and deployed complex ETL processes. Used aggregate functions, analytical functions, Dynamic SQL, materialized views (snapshots), bulk collection, partitioning tables and indexes in very large data warehouses. Used parallelism. Developed procedures to processed large amount of data by joining dimension and fact tables in large data warehouse.
• Expertise in design, development, testing and support of functions, procedures, packages, variables, records, collections etc. Developed packages for complex applications.
• Used SQL*Loader extensively to load the data. Loaded data in multiple tables. Design and developed control file. Wrote functions that were invoked when loading the data.
• Designed, developed and implemented external tables. Used external tables to process and load data. Developed processes. Used external tables as part of ETL.
• Expertise in development of packages, procedures, triggers and functions.
• Used advanced features of Oracle including portioned tables, portioned indexes, global indexes and local indexes. Created partitioned tables and loaded data into partitions to enhance the performance. Loaded data into a table and using partition exchange to make it part of the table. Used split partitioning.
• Very creative, innovative and analytical. Always think of new solutions for improving quality, end user satisfaction and cost savings in terms of performance and maintenance. Enjoy solving challenging technical problems.
• Expertise in optimizing and tuning of applications and complex SQL Queries. Strong experience of Oracle SQL performance and tuning especially in very large data warehouse environments.
• Strong experience of complete software development life cycle. Started project from collecting requirements and delivered completed product and maintained it. Designed from requirements, did coding, performed unit testing, integration testing and system testing. Worked with users to perform UAT. Coordinated production releases and supported the applications after release. Wrote high level design documents, detailed design documents, test plan and test cases. Wrote release notes and rollback plans.
• Always followed Software Quality Procedures and Software Engineering practices. Used Agile methodology as well as Waterfall Models.
• Expert in development of UNIX shell scripts for applications including Oracle PL/SQL and SQL scripts.
• Expertise in Shell Programs and writing Scripts (Korn Shell and Bourne Shell). Expert in developing, debugging and optimizing the complex shell scripts, and integrating other executable with the scripts.
• Migrated packages, procedures, functions and other database objects scripts from one database (Solaris based) to another database (Linux based).
• Extensive experience in application development and system programming using C in UNIX environment. Experience in advanced UNIX Network programming using of Sockets, IPC and UNIX System Calls. Worked in all flavors of UNIX.
• Developed and implemented configuration management procedures for the organization using PVCS. Used configuration management tool including Serena Dimension CM, Clear Case, SCCS, SVN and CMVC.
• Experience in using Perl. Used Perl for scripting, SQL and HTML and web applications.
• Provided round the clock (24/7) production support and achieved almost zero down time. Carried mobile and pager. Did root cause analysis. Interacted with users, business analysts, agents and others. Resolved the problems, closed tickets. Did root cause analysis.
• Provided training to engineers. Made presentations, held discussions and addressed meetings
• Worked with very reputed financial companies including Confidential, Confidential, Barclays, Bear Stearns (JPMC), Brown Brothers, Capital One, American Express and Wells Fargo. Developed software for many leading non - financial companies including Cadence, R. L. Polk and NEC Japan.

TECHNICAL SKILLS:

RDBMS: Oracle 12c, Oracle 11.2g, Oracle 11g RAC, Oracle 10g RAC, 9i/8i (SQLPL/SQL: SQL* Plus), SQL*LOADER, Data Modeling, Logical and Physical Design, Data Warehouse, OLTP

Tools/ Languages: PL/SQL, SQL, SQL*PLUS, SQL*LODER, Perl, Korn Shell Scripting, Java, TAOD, PL/SQL Developer, SQL Navigator, Teradata SQL assistance, WinSQL, Awk, CGI, HTML, C, C++, Clear Case, PVCS, CMVC (AIX), MS OFFICE, MS VISIO

Data Modeling: ERwin, MS Visio

ETL Too: l Ab Initio

Scheduling Tool Autosys: OS AIX 5.1, 4.3/4.1, HP-UX 11.0/10.01, Solaris/SunOS, Linux, UNIX

Windows NT/XP/98/95: Utilities SQL*LOADER, UNIX Utilities including FTP, LEX, YACC, C-ISAM

Writing Software Requirement: Specifications, System Test Plan, High Level Design, Low Level Design, Unit Test Plan, Integration Plan

Others: Inter Process Communication (IPC), Sockets (TCP/IP and UNIX Domain), Shared Memory, Semaphore, Message Queue, Pipes, FIFO, Signals, and UNIX System Calls with C/C++, Eagle Star and panels

Configuration Management: Clear Case, Clear Quest, PVCS, CMVC, SCCS, Developed process for the organization and implemented the process

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Senior PL/SQL Developer

• Worked with Business Analysts, performed the study of the business process and analyze the requirements. Developed the application for ETL process.
• Design, developed, tested and deployed complex SQL queries and PL/SQL procedures for ETL process. Wrote DDL for creating tables indexes etc. Partitioned the tables.
• Developed SQL queries for large tables. Used different features of PL/SQL and SQL.
• Tuned the queries for better performance. Analyzed tables, used indexes, partitione tables, wrote efficiet better queries and PL/SQL procedures.
• Used JIRA for tracking. Did QA and production releases. Wrote documents for release and rollback. Developed scripts for production release and rollback.

Environment : PL/SQ, Oracle 12c, Teradata, Teradata SQL assistant, Windows 1

Confidential, Jersey City/ Fort Mill, SC

Sr. Oracle PL/SQL Developer and Data Modeler

• Worked with closely Business Analysts to study and analyze requirements to build new application and analyzed requirements. Constantly interacted with various teams including DBAs, QA teams, team leads and managers.
• Did data modeling and designed logical model and physical models of the tables. Implemented the model. Created ER diagrams.
• Designed partitioned tables, indexes, constraints etc. Investigated data and decided appropriate partitioning keys. Developed scripts to implement physical model including creating tables, indexes, constraints, partitions, local indexes, granting privileges etc.
• Developed ETL processes for extraction transformation and loading of the data. Used PL/SQL, SQL and Shell scripting.
• Developed SQL*LOADER process for loading the data into tables. Wrote control file and Korn shell script.
• Designed, developed, tested, and deployed PL/SQL packages, procedures, and functions, complex views using PL/SQL and SQL. Used different features of PL/SQL including cursors, bulk collections, dynamic SQL, partitioning of the tables etc. Used Explain plan and SQL Tuning Advisor to improve complex queries. Analyzed tables.
• Wrote complex SQL queries. Used variety of features including analytical functions, dynamic SQL, WITH clause, joining tables on partitions. Wrote very high quality of code. Introduced parallelism with partitioning.
• Led the efforts to tuning of root queries. Improved performance.
• Performed tuning and improved the performance of SQL queries. Used explain plan, SQL tuning advisor for analyzing big and complex queries. Wrote efficient applications. Minimized table joins, used partitioning with proper partitioned indexes. Developed SQL queries for better performance minimizing data reads and processing using analytical function, hints, appropriate indexes, parallelism etc.
• Developed UNIX shell script using SQL*PLUS, SQL etc., tested and deployed.
• Supported the applications in production and fixed production issues.
• Performed integration testing of the packages written by team for quality, reliability and performance. Improved performance of the applications.
• Involved in problem resolution and root cause analysis. Improved quality and performance.
• Used JIRA for development, tacking and issues.
• Used GitHub for version control.

Environment : PL/SQL, SQL, Oracle 11g, Oracle12c, GitHub, Linux, Korn Shell, SQL Developer, Autosys, Windows 10

Confidential, Owings Mills, MD

Sr. Oracle PL/SQL Developer

• Worked with Business Analysts, DBAs, QA teams and managers. Collected and analyzed the requirements.
• Did data modeling and designed logical model and physical models of the tables.
• Designed partitioned tables, indexes, constraints etc. Investigated data and decided appropriate partitioning keys.
• Implemented the model. Wrote scripts for creating partitioned tables, local indexes, granting privileges etc.
• Tested the model. Tasted partitioned table for quality and performance.
• Developed PL/SQL procedures using various PL/SQL features. Wrote complex SQL queries. Used different features including with clause, analytical functions, joining tables on partitions. Wrote very high quality of code. Introduced parallelism with partitioning.
• Did performance and tuning of the applications. Used AWR reports to find slow running queries in a huge application. Tuned the queries. Used different methods. This includes breaking down application in steps, partitioning tables with indexes, using of hints, avoiding use of functions etc.
• Supported the applications. Involved in problem resolution and root cause analysis. Improved processes and minimized issues. Improved quality and performance.

Environment : PL/SQL, SQL, DB Visualizer, Oracle 12c on Exadata, Linux, Korn Shell, ServiceNow, Symphony, Windows 10

Confidential, Columbia, MD

Lead PL/SQL Developer and Data Modeler

• Worked in large team environment. Worked with independent teams of Architect, Business analysts, DBA, developers, testers, QA staff and production support staff. Collected and analyzed the requirements.
• Did data modeling, created logical and physical models. Did normalization of the tables to 3NF. Worked closely with Business Analysts for improving quality. Created tables, indexes, constraints, privileges, rolls etc.
• Did dimensional modeling. Identified grain for fact table. Identifeid dimesions. Created dimension and fact table structures. Identified partitionon key to partition tables. Partitioned tables. Created scripts for creating database objects.
• Designed, developed, tested and supported complex ETL applications in large data warehousing environment.
• Designed using requirement documents, did coding, performed unit testing, integration testing, system testing and supported the applications. Promoted code from sand box environment to controlled development environment, QA, UAT (V & V) and Production. Used Dimension-CM for configuration management.
• Wrote high level design and detailed design documents. Developed test plan and wrote test cases. Wrote test plan and test cases for non-technical users for better understanding.
• Developed packages, procedures and functions. Wrote advanced SQL queries using advanced PL/SQL features. Developed applications as packages.
• Used advanced features of SQL and PL/SQL including aggregate function (grouping, rollup with inner join and left outer join), analytical functions, table partitioning, index partitioning, parallelism, bulk collections with FORALL. Used different kind of partitioning including list and range partitioning for tables and indexes. Created local and global indexes.
• Used dynamic SQL for DDL operations in PL/SQL procedures. Developed SQL scripts for various applications.
• Used SQL*Loader and external tables for loading the data into complex environment. Wrote control files and Korn shell scripts to run the job. Wrote procedure for loading the data into various tables in the database based on the business rules.
• Designed and created external tables. Developed process to read external tables, process and load into the tables. Data files were received periodically.
• Developed application for Teradata. Designed and developed SQL queries and stored procedures. Tested, released and supported the application.
• Used Korn Shell scripting. Used Korn Shell scripting with SQL and PL/SQL for complex application development to run in UNIX environment.
• Improved the application for the performance. Used various techniques including using hints, added indexes, partitioned tables, rewrote queries. Rewrote queries for better performance. Used different techniques including Bulk Collection, analytical functions, aggregate functions, UNION ALL, hints, parallelism to improve performance. Improved refresh time of materialized views by adding parallelism.
• Worked with SAS team for parallel testing and comparing results for same test cases.

Environment : PL/SQL, SQL, PL/SQL developer, Teradata SQL assistant, Teradata, Oracle 12c, Oracle 11.2g, Linux, Korn Shell, Serena Dimension-CM, Serena Business Manager, Windows 10

Confidential

Senior Database Developer

• Worked with BA, collected, analyzed and reviewed the requirements.
• Worked with business analysts, DBA, and other stake holders.
• Designed and developed the processes for Extraction, Transformation and Loading the data.
• Designed the structure of the tables, constraints, keys, indexes etc.
• Did the study of data quality, developed the process for cleaning and loading the data in staging area, cleaning, transforming and loading the data in staging area and presentation areas. Developed package, procedures and functions.
• Wrote developed high level and detailed design documents, Test Plans and Test Cases for the application development using PL/SQL, SQL and Korn Shell.
• Used complex features of PL/SQL and designed, developed, tested and supported the application.
• Wrote complex SQL queries and tuned the queries to improve the performance.
• Tuned queries and applications to improve the performance. Rewrote queries and improved the design of the applications for better performance.
• Worked with different teams for QA, UAT and production deployments and sign offs.
• Developed Unix shell scripts.

Environment : PL/SQL, SQL, TOAD, Perl, Oracle 11g, Natezza, AIX, Linux, Korn Shell, Windows 10

Confidential, Warren, NJ

Principal Software Engineer

• Worked in a large team and interacted with developers, DBA, team leads, productions support staff, managers of other teams.
• Collected, analyzed and reviewed the requirements. Studied the existing databases and new requirements.
• Designed the database, tables, indexes, constraints and the processes. Worked closely with business analysts, collected and analyzed the requirements.
• Did data modeling, developed logical and physical models. Implemented and tested new data model. Designed and developed database objects, triggers, constraints, views and processes.
• Designed and developed processes to process transactions. Followed standard SDLC. Resolved issues and improved the response time. Developed processes for loading and processing of data.
• Developed complex packages, procedures, functions and triggers using PL/SQL, SQL, external tables and SQL*LOADER in UNIX environment.
• Used advanced feature or PL/SQL and Oracle 11g including bulk collection, analytical and aggregate functions including partitioned tables, partitioned index for large tables, Oracle package UTIL FILE for file processing. Used parallelism with partitions to enhance performance.
• Developed complex ETL applications in large data Warehouse environment with several millions of rows per table.
• Improved the performance and optimized the complex queries. Designed the applications for better performance and improved the design for better performance. Used various techniques for optimizing queries. Used appropriate query optimization techniques including minimization of I/O operations, unnecessary sorting, reading minimum columns required from the table, partitioning tables and indexes, reducing joining of large tables, using appropriate indexes, analytical functions for complex operations, hints, parallelism, appropriate constructs, bulk collections with FORALL etc.
• Developed complex SQL*LOADER control files to load data in multiple tables simultaneously and called functions at the time of loading. Did tuning of the queries and improved the performance.
• Designed, developed, tested and deployed complex UNIX Korn Shell scripts that called PL/SQL procedures. Design and developed corn shell scripts for file transfer using FTP.
• Used Autosys extensively. Designed, developed and tested batch jobs using Korn shell scripts, PL/SQL, SQL and Autosys. Scheduled the batch jobs using Autosys. Resolved a number of RAC related issues that were encountered. Supported Autosys jobs in UAT and production environments.
• Designed, developed, and supported Perl applications on Linux.
• Used SVN for configuration management in UNIX environment. Created build and made releases in UAT and production environments.

Environment : PL/SQL, SQL*PLUS, SQL, Autosys, Perl, SQL Developer, Oracle 11g, Solaris, ERwIn, Linux, Korn Shell, SVN, Windows XP/7, Web based environment (java)

Confidential, Jersey City NJ

Senior Database Developer

• Collected, analyzed and reviewed the requirements. Worked with business users and business analysts, DBA, team leads and managers.
• Migrated database objects including tables, packages, procedures, function from Solaris based database to Linux based machine. Rewrote procedures to modify functionality.
• Designed, developed and tested PL/SQL applications. Created database objects including tables, indexes, constraints and triggers.
• Wrote developed high level and detailed design documents, Test Plans and Test Cases for the application development using PL/SQL, SQL and Korn Shell.
• Used complex features of PL/SQL and designed, developed, tested and supported database applications in Oracle 11g RAC environment.
• Created external tables for loading the data files into the tables. Wrote definition of the tables to read data from the file. Wrote procedures to read and data from the table and load into to various tables in the database.
• Used complex features of PL/SQL, developed packages, procedures, function and triggers. Wrote complex SQL queries and tuned the queries to improve the performance.
• Used Oracle 11g extensively. Used advanced features of Oracle including composite table partitioning, index partitioning, analytical functions and windowing functions.
• Tuned queries and applications to improve the performance. Rewrote queries and improved the design of the applications for better performance.
• Designed, developed and tested batch jobs using Korn shell scripts, PL/SQL, SQL and Autosys. Scheduled the batch jobs using Autosys. Resolved a number of issues that were encountered during migration.
• Used complex features of PL/SQL to develop applications for extraction, transformation and loading (ETL). Developed new file transfer processes using Korn Shell scripting, SFTP in RAC and Linux environment as per new security policies of the bank.
• Worked with DBA, business analysts, managers of other teams and developers for requirement gathering, review of requirements, review of test documents, QA and testing and signing off.
• Coordinated constantly with different groups for the user acceptance test and got the sign off. .

Environment: PL/SQL, SQL, TOAD, Perl, Autosys, Oracle 10g and 11g RAC, Solaris, Linux, Korn Shell, Windows XP, and C#

Confidential, Jersey City NJ

Senior Database Developer

• Collected, analyzed and reviewed the requirements and developed BRD (business Requirements Document). Worked with different business analysts, managers, team leads and DBA (data base administrators).
• Wrote Technical Specifications (high level and detailed design documents) and got them signed off by Design Authority. Wrote Test Plan and Test Cases and signed off by Test Authority. Developed programs (did coding). Performed unit testing, system testing, coordinated User Acceptance Test and Regression Tests, and Production Releases.
• Did data modeling. Developed logical and physical models. Identified entities and relationships. Normalized the model. Developed ER Diagrams. Implemented, tested and improved the data model.
• Used complex features of PL/SQL, developed packages, procedures functions and triggers. Used aggregate functions including grouping and rollup, analytical functions, partitioning and dynamic SQL. Wrote complex SQL queries and tuned the queries to improve the performance.
• Tuned queries to improve the performance. Rewrote queries and improved the design of the applications for better performance.
• Used complex features of PL/SQL to develop applications for extraction, transformation and loading (ETL) and very large data warehousing environment. Developed the applications to handle very large tables. Developed complex SQL queries to handle large amount of data.
• Developed complex Perl applications in UNIX environment. Wrote complex Perl sub routines using different features of Perl.
• Used External Tables and SQL*Loader for loading and processing of the data from huge data files. Created a number of external tables.
• Developed materialized views and materialized view logs for summary tables. Used advanced features of Oracle (SQL and PL/SQL) including analytical functions, windowing functions and table and index partitioning.
• Designed, developed, tested and deployed complex UNIX Korn Shell scripts that called SQL scripts.
• Provided support for the application for root cause analysis and fixing issues.
• Used different tool including Ultraedit, Clear Case, Clear Quest, SharePoint and VI editor.

Environment: PL/SQL, SQL, TOAD, Perl, Autosys, Oracle 10g/11g, Solaris, AIX, Korn Shell, Windows XP, Clear Case, Clear Quest

Confidential, Gaithersburg MD

Senior Oracle Developer/Lead Developer

• Collected, analyzed and reviewed the requirements. Wrote requirement specifications. Worked with different business analysts, managers, team leads and DBA (data base administrators).
• Designed and developed ETL applications in large Data Warehousing environment running using PL/SQL, SQL and Korn Shell scripting.
• Used advanced features of PL/SQL and developed procedures and functions. Used Dynamic SQL, bulk collection and pipelined functions in web environment with Java for frontend and Oracle on backend. Queries were written for fast response time for the user.
• Tuned a large number of slow queries and improved performance. Designed, developed and optimized vary complex SQL queries.
• Designed and developed complex PL/SQL applications for OLTP, normal data base and data warehouses (ETL).
• Created partitioned tables and indexes. Redesigned applications for improving response time. Designed, developed and tested Materialized views and materialized view logs.
• Designed, developed, tested and deployed complex Perl scripts for file processing, execution and processing of SQL queries, PL/SQL procedures using Perl DBI with Oracle. Designed and developed complex configurable Perl scripts for HIPPA for transporting files.
• Developed applications using C and UNIX.
• Developed UNIX shell scripts for executing and scheduling jobs.
• Provided round the clock production support on rotation basis and achieved almost 100 % uptime. Analyzed problems, monitor production, interacted with business users and agents. Resolved problems did root cause analysis and did permanent fixes.
• Used Clear Case and Clear Quest for configuration management.

Environment: PL/SQL, SQL, TOAD, Perl, Oracle 11g, C, Oracle 10g, Solaris, AIX, Korn Shell, Web based environment (Java), Windows XP, Clear Case, Clear Quest

Confidential, Washington DC

Senior Software Developer DADS Data Warehouse

• Interacted closely and constantly with business analysts, managers and technical teams. Collected and analyzed the requirements
• Developed SQL*LOADER script for loading the data and PL/SQL applications for processing. Developed applications ETL (Extract Transform and Load) processed for Data Warehousing applications using PL/SQL using 10g environment.
• Improved the performance of the applications by improving design of the applications and tuning of the queries.
• Redesigned applications and used complex features of PL/SQL including partitioned tables, bull collection with saved exceptions, external tables to improve performance of the applications.
• Worked on very large databases with very large tables. Developed and optimized vary complex SQL queries.
• Developed, modified and used SQL*LOADER scripts.
• Designed, developed and tested complex UNIX Korn Shell scripts.

Environment: PL/SQL, SQL*PLUS, SQL, TOAD, Oracle 10g, AIX, Korn Shell, Web Based environment (Java), Windows XP

Confidential, NJ

Senior Software Developer Portfolio Accounting System, Oracle 10g, RACS2 (Data Warehouse, 10g), Geneva (Accounting System)

• Designed the database for processing and storing. Worked closely with business analysts, collected and analyzed the requirements. Did data modeling, developed logical and physical models. Implemented and tested data model.
• Implemented and tested new data model. Designed and developed data base objects, including tables, indexes and triggers.
• Designed and developed processes to process transactions. Followed standard SDLC. Resolved issues and improved the response time.
• Developed complex packages, procedures, functions and triggers using PL/SQL, SQL and SQL*LOADER in UNIX environment.
• RACS2
• Developed ETL applications using PL/SQL. Used complex features of PL/SQL including bulk collection, Dynamic SQL, UTL FILE package.
• Worked on very large databases with very large tables. Developed and optimized vary complex SQL queries. Used partitioned tables with partitioned indexes.
• Used advanced feature or PL/SQL and Oracle 10g including analytical and aggregate functions including CUBE, partitioned tables, and partitioned index for very large tables to develop complex ETL applications in very large data Warehouse environment with billions of rows per table. Improved the performance and tuned the applications and complex queries. Designed and developed very complex applications of better performance.
• Developed complex SQL*LOADER control files to load data in multiple tables simultaneously and called functions at the time of loading. Developed packages to be used by SQL*LOADER complex control file to load financial instrument’s pricing data.
• Did tuning of the queries and improved the performance.
• Improved the design for better performance.
• Developed Data Warehousing applications using PL/SQL in 10g environment.
• Designed, developed, tested and deployed complex UNIX Korn Shell scripts that called PL/SQL procedures.
• Developed complex packages used in SQL*Loader control file.
• Designed, developed, and supported Perl applications on Linux.

Environment: PL/SQL, SQL*PLUS, SQL, Perl, SQL Navigator, TOAD, DBArtisan, MS VISIO, Oracle 10g/11g, Solaris 10, Linux 5.2.1, Korn Shell, Windows XP, java/Oracle environment