SUMMARY

• Around 6+ years of extensive experience in the complete Software Development Life Cycle (SDLC) covering Requirements Management, System Analysis, Architecture and Design, Development, Testing and Deployment of business applications.
• Extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server applications using Oracle, SQL, PL/SQL,SQL*Loader.
• Proficient in developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Experienced in developing Master - Detail and Transaction Forms in Oracle Forms Builder (10g) on Windows and Linux platforms, also involved in writing UNIX Shell scripts when needed.
• Experienced in developing Simple and Matrix reports in Oracle Reports Builder (11g) on Windows and Linux platforms.
• Experience in building Data marts for a Commercial Lending Banking product.
• Proficient in PL/SQL programming - Stored Procedures, Functions and Packages, SQL tuning and creation of Oracle objects like tables, views, materialized Views, triggers, cursors, synonyms etc.
• Good experience on Database links, User defined data types, Nested tables and Collections.
• Designed database schemas using Entity relationship modeling with ER diagrams & database normalization principles.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Good understanding of oracle Data dictionary, RDBMS and Normalization techniques.
• Designed and implemented Oracle Forms, Reports and Menus.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Quality Assurance, Code Review.
• Experienced in Query Optimization, Debugging, and Tuning and Improvising performance of the applications.
• Experienced with SQL performance tuning and optimization using execution plans.
• Improved performance of PL/SQL program units by using Bulk Collect and Bulk Bind (ForAll) features with Collections instead of using cursors and FOR loops, and DBMS PROFILER package and GET TIME in DBMS UTILITY package.
• Proficient in working with Indexes, Hints and Table Partitioning.
• Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
• Solid experience in writing and debugging stable and robust PL/SQL code, handling various kinds of Exceptions, SQL, Dynamic SQL, C, and UNIX shell scripts.
• Supported Advance PL/SQL using Cursors, REF Cursors, and Native Dynamic SQL.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Implemented Autonomous transaction and Distributed transaction processing in PL/SQL; Non-Distributed transactions, Distributed transactions, Remote transactions.
• Thorough knowledge in software processes and involved in all phases of development life cycle.
• Involved in developing Forms and Reports using Oracle 9i/11g.
• Experience in Unit and Integration Testing.
• Experience in UNIX, and Shell Scripting.
• Experience in writing JavaScript, HTML, XML.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g, MS SQL server 2014, DB2 and MS Access.

Languages: SQL, PL/SQL, C and UNIX Shell Programming.

Front-End Tools: Oracle Enterprise Manager, Forms Builder and Schema Builder.

GUI: Oracle Forms 9i, Oracle Designer 2000 and SQL*Loader.

Database Tools: TOAD for Oracle, SQL developer, SQL Navigator and SQL worksheet.

Data Modelling: ERwin Data Modeler, Toad Data Modeler.

Operating Systems: Windows NT/2000/98/XP, Linux and Sun Solaris.

Web Applications: JAVA, JSF, JSP, ASP, XML and HTML.

PROFESSIONAL EXPERIENCE

Confidential, Saint Petersburg FL

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in creating detailed Documentation HLD and LLD, which includes all Business requirements and technical specifications.
• Created data mapping files for the data coming from different web services.
• Worked for designing Logical and Physical data models for staging and E-Product catalog databases and staging database.
• Knowledge and experience in structured systems analysis and design techniques.
• Extensively used stored procedures to apply validation logic for the data in staging area to load into catalog Database.
• Develops new screens usingOracleForms10g for application as per requirements.
• Used Explain Plan, HINTS for performance tuning of SQL, PL/SQL queries.
• Worked with ETL team and architect to build data model for staging area.
• Analyzed data, designed and developedOracleforms, layout, report triggers, parameterform, data models.
• Rolled out and administered shared and non-sharedclusters.
• Worked with business experts to understand the source data in web service systems.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Importing and exporting the data into multiple environments.
• Supported for code integration and system integration testing for this application.
• Worked with Java and J2ee development team and worked for Hibernate mapping and Provided SQL Queries.
• Developed different UNIX scripts for the output of the commands.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Loaded flat file data into Oracle stage tables using SQL*Loader, TOAD, Oracle Data Integrator (ODI)
• Designed and developed ETL jobs in ODI to load data in flat files and CSV files on local host into database tables.
• Designed and developed real time jobs in ODI 12c to perform complex transformations and migrate data in stage tables (flat files) from legacy Oracle database servers.
• Developed stored procedures to facilitate data transformations during data migration from legacy applications’ databases to new SFDC application database and performed Unit Testing of these stored procedures. Used Bulk Collect and Bulk Bind (FORALL) features with collections.

Environment: Oracle 11g, Oracle Reports 11g, ODI 11g/12c, Toad, Erwin, SQL Developer.

Confidential, Tampa FL

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in creating detailed Functional Documentation which includes all Business requirements and Technical specifications.
• Interacted extensively with business users, Business Systems Analyst, and SFDC SME for requirements gathering and analysis.
• Created data mapping files for the data coming from different web services.
• Worked for designing Logical and Physical data models for Master Data and Transactional Data.
• Involved in read data files created by other statistical software packages by using SAS. knowledge and experience in structured systems analysis and design techniques.
• Worked with ETL team and architect to build data model for staging area.
• Prepare the Mapping document which details out the mapping of source to the target data model with application of business rules.
• Supported for code integration and system integration testing for this application.
• Worked with ETL team involved in loading data to staging area. Provided all business rules for the database for loading data.
• Worked for ETL process of data loading from different sources and data validation process from staging area to catalog database.
• Did performance tuning of PL/SQL code of a stored procedure which migrates data from source table with multi-million records to destination table and reduced migration time from over 3 hours to 45 minutes using Bulk Collect and Bulk Bind (FORALL) features with collections. Performed SQL Query tuning by using hints in DML statements.
• Used Python in GIS programming.
• Develop best practices to ensure coding efficiency and quality using Perl.
• Involved in handling the changes in compiling scripts according to the database changes.
• Developed reports using complex queries as per client request as a part of production support
• Performed SQL tuning using Explain Plan, Hints and indexes
• Involved in handling the batch jobs using UNIX shell scripting.
• Responsible for performing code reviews.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Utilized SQL*Loader to load flat files into database tables.
• Created data validation test cases and test scripts for Unit Testing and Integration Testing and documented the same.

Environment: Oracle11g/10g, SQL Server Reports, PL/SQL, Toad, SAS, Autosys, Python.

Confidential, Kansas city MO

Oracle Developer

Responsibilities:

• Involved in writing Packages, Functions, Stored Procedures and Database Triggers.
• Worked on Database design with the team.
• Writing PL/SQL code using the technical and functional specifications.
• Generated SQL and PL/SQL scripts to install create and drop database objects including Tables, Views, Primary Keys, Indexes, Constraints, Sequences and Synonyms.
• Created stored procedures, functions, packages, database triggers and cursors based on requirement.
• Measured the performance of the shell scripts by getting the expected results.
• Worked on Logical, Physical and conceptual design of Database Data Modeling, and Data Architecture with the use of Erwin and MS VISIO as a modeling tool.
• Developed complex queries to retrieve the data.
• Created indexes for faster access of data.
• Documented business rules for writing triggers and constraints, functional and technical design, test cases and user guides.
• Involved in testing all forms, PL/SQL code for logic correction. Performed Unit testing on queries and reports.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Involved in debugging and error handling.
• Involved in creating Index’s, passing hints, analyzing the table.
• Monitored the database growth on daily basis. Established backup and recovery strategies.
• Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.
• Designed logical and physical Data Models using ERWIN and executed on large scale to create database.
• Worked on Database tuning and performance monitoring.
• Wrote UNIX Shell scripts.
• Modified UNIX Kernel parameters and associated database parameters.

Environment: Oracle 9i/10g, SQL, TOAD, PL/SQL, SQL*PLUS, Forms 10g, Reports 10g, UNIX, MS Windows XP/2000.

Confidential

Software Engineer

Responsibilities:

• Analyzed and overviewed the database design for better understanding the relations, associations and dependencies within the database.
• Data modeling for client specific requirements.
• Developed database objects including tables, clusters, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Developed complex queries on Data Warehousing and developed PL/SQL procedures to give in nice strategic plans to higher level of management.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements in Oracle data warehousing.
• Used Dynamic SQL programming technique to build and process SQL statements at run time.
• Developed PL/SQL scripts for Data cleansing.
• Developed UNIX shell scripts that help as a scheduler for data load.
• Used TOAD, PL/SQL developer tools for faster application development.
• Performed SQL tuning using Explain Plan, Hints and indexes.

Environment: Oracle 9i, PL/SQL, TOAD and Windows 2000 server