SUMMARY

• Over 9 years of experience in analysis, design, development, and testing of business applications in OLTP, web based Client/Server architectures.
• Proficient in analyzing the end user requirements and converting them into efficient Technical Solutions.
• Expertise in SQL and PL/SQL programming, developing complex code units, database triggers and using the latest features to optimize performance.
• Proven ability in Agile methodologies, SCRUM, RUP and Project Management Skills like Project Planning, Scheduling, Scope Management, Change Management
• Stakeholder Management, Human Resource Management, and Conflict management, Project Execution and Control, Quality Management.
• Strong Knowledge on oracle architecture and database design.
• Excellent conceptual knowledge of Oracle 9i/10g/11g, PL/SQL.
• Experience in Database design using Normalization and E/R Diagrams.
• Extensive experience in database programming using SQL and PL/SQL following industry best practices.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Strong knowledge in front end development using oracle forms/reports6i/9i/10g.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Expertise in loading data from legacy systems using SQL*Loader.
• Developed materialized views for data replication in distributed environments.
• Experience in Database modeling and database object definitions using tools like Oracle Designer.
• Experience in Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Performed Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses.
• Strong knowledge on OLAP components development.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Experience in writing Technical design documents and developing unit test documents.
• Supported integration and end user testing with efficient defect management process.
• Worked in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Strong Analytical, Problem solving and communication skills.
• Extensively involved in communicating with the onsite users in resolving the issues and contributing my part of technical support to the team.
• Created Ab Initio scripts for data conditioning, transformation, validation and loading.
• Experienced in all SDLC stages with CMMI level procedures and processes.
• Hard working, aggressive in acquiring new skills, ability to excel under pressure, innovative, self - motivated and good problem solving skills.
• Experienced and effective in visualizing and implementing creative solutions to the most complex requirements.

TECHNICAL SKILLS

Databases: Oracle 12c/11g/ 10g/9i, SQL Server, MS Access.

Scripting: SQL, PL/SQL, UNIX Shell Scripting.

Languages: C, C++, XML, HTML.

Operating Systems: Windows 2000/XP, UNIX, LINUX

GUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g.

Data Modeling: Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables, Physical and Logical Data Modeling.

ETL Tools: Informatica Power Center 8.6.1

Tools: Toad, SQL*Plus, SQL*Loader, Erwin, and SVN

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Requirement Analysis, System Design, Preparing Functional Specifications, Preparing Design Specifications, and Development
• Responsible for creating PL/SQL scripts for processing data, applying business rules and loading them onto the target for reporting on the front end.
• Create, develop, modify and maintain database objects, PL/SQL packages, functions, stored procedures, triggers, views, materialized views to extract data from different sources.
• Optimized existing packages for enhanced performance and inclusion of new features of latest database versions.
• Developed PL/SQL procedures that extracted data from a data warehouse for policy reporting.
• Extracted data from various location and load them into the oracle table using SQL*LOADER.
• Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle by using Oracle SQL Developer.
• Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS PROFILER, and Hints etc.
• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs and running files in batch mode.
• Exported reports into various formats like XML, PDF, HTML, EXCEL and MS-Word.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Creating Materialized Views for replication of the actual data present over a DB Link.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Created various Data Models using Erwin - Normalized and Dimensional Modeling.
• Enhanced performance of the application through SQL tuning using TOAD
• Involved in designing ER diagram using oracle designer, to set the logical and physical relationships of database.
• Involved in moving the code to production using Change Management Procedures.
• Designing the data model (logical/physical) by creating new objects and by using existing objects of the data mart as per the business requirements.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Extensively used advanced PLSQL features like BULK COLLECT, FORALL, REF CURSORS, COLLECTIONS data types in the procedures, functions
• Experience in providing solutions of capacity, replication data issues.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed new Packages to load eligible Vendor Order Request into the Target table based on various business criteria using the MERGE Statement.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Wrote Complex SQL script, Analytical Function using Cursors, Bulking techniques, Collections, Dynamic SQL.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL * Plus, TOAD, SQL*Loader, Shell Scripts, SQL *Loader, SQL Plus, SQL Developer, UNIX shell script, Informatica Power Center, Web Services, JavaScript, IBM ClearCase, JIRA, Teradata SQL Assistant, BTEQ, FastLoad, FastExport, MultiLoad.

Confidential, Gaithersburg, MD

Sr. PL/SQL Oracle Developer

Responsibilities:

• Responsible for interacting with Business Users and other development teams for gathering requirements.
• Developed Functional and Technical Specifications.
• Involved in creating SQL loader scripts to load the data from the flat file received from 3rd party vendors into oracle tables.
• Involved in writing PL/SQL program using UTL FILE package.
• Involved in Unit testing, System testing and UAT.
• Worked as production support specialist and resolved production related issues.
• Developed Functions and Procedures to manipulate the data and to load to the tables.
• Used Oracle Advanced concepts like types, PL/SQL tables and V-Arrays and dynamic SQL in generating the complex extracts from database.
• Extensively wrote the PL/SQL and SQL programs and Designed and developed the views, materialized views, triggers and cursors.
• Implemented parameters, condition, filters and calculations in reports through Oracle Discoverer Desktop.
• Involved in source data analysis and creating ETL design document along with the enterprise architects.
• Developed major ETL packages by implementing various business transformation logics to load the data into different stages in Data Warehouse.
• Developed Conceptual, Logical and physical data model and scripts to create users, roles and schema objects
• Developed SQL*Loader control files to extract data from flat files, create error, result log files and load data into temporary table to do validations
• Written PLSQL procedures to extract the daily promoted and demoted managers from the HR database.
• Designed and developed forms using Oracle Forms 10g to allow the end users to manage the customer relation effectively and efficiently.
• Created Materialized Views for Aggregator Facts.
• Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Experience in the preparation of Functional Design document and System Test scripts for Extensions, Data Conversion/Migrations, Reports, Forms and Customizations.
• Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
• Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Successfully designed and developed standard and custom reports using Oracle Reports and Pro*C.
• Developed validation programs to validate the data before importing into the payables table.
• Designed, developed, tested and implemented using Oracle Forms.
• Performed RUP patching and upgraded Oracle Apps databases
• Involved in tuning using EXPLAIN PLAN and used hints to tune the queries.
• Involved in the creation of database objects like tables, views, stored procedures, functions, Indexes for new requirements.
• Involved in creating users and requests, schedules in Oracle Apps for all interfaces.
• Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.
• Involved in Code Reviews and test Reviews.
• Participating in Quality Audits.

Environment: Oracle Applications 12.1.3, SQL, PL/SQL, Oracle Forms and Reports 11g, Oracle Streams 10g (Replication), SQL*LOADER, UNIX shell scripting, TOAD.

Confidential, Ashburn, VA

Oracle Developer

Responsibilities:

• As a Developer involved in multiple projects. Some of the applications were developed using ASP, Visual Basic and Oracle as a back end.
• Some of the applications were developed using Oracle as front end and back end.
• Apply the appropriate standards, processes, procedures, and tools throughout the development life cycle.
• Identified the Business Processes, roles and user interactions with the system in the current ‘as is’ process and future ‘to be’ process.
• Worked in Creating Fast formula for Employment number generation in HRMS
• Developed Custom programs for multiple HRMS customizations
• Involved in Requirement Analysis, Estimation, Design, Coding, and Testing and on-time delivery.
• Conduct data analysis of input files to system and suggest required modifications.
• Allocation of tasks to the offshore resources. Monitoring the activities and efforts of the offshore team.
• Responsible for implementation, data migration at client place. Migrated data from flat files (which were in UNIX system) toOracletables using SQL * Loader and stored procedures.
• Involved in developing, testing, compiling, debugging and maintains the data using oracle, PL/SQL, UNIX.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Knowledge transfer to client technical team.
• Defined Key performance index using dashboards and websites to drive high business performance
• Physical modeling of databases, database object creation and development of oracle pl/sql packages and UNIX shell scripts to implement business functionality.
• Perform performance Tuning and create backup strategies.
• Implement test strategy.
• Database and ETL development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Used features like 11g pivot, partitioning, parallelism, materialized views, temporary tables, object types, result caching and optimizer hints to make queries performance-wise efficient
• Re-designed/Re-factored reporting queries to make use of 11g database new features and to maximize the performance
• Involved in data replication and high availability design scenarios with Oracle Streams.
• Analyze system capabilities to resolve questions of program intent, output requirements
• Develop highly complex applications using Oracle 11g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
• Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Write PL/SQL Programs. Used SQL*Loader to load the data from flat files to oracle Tables.
• Develop advanced SQL *Loader scripts for conditional data loads.
• Tune PL/SQL code and other SQL for efficient processing.
• Used advanced oracle features such as table partitioning, bulk binds.
• Unit testing/support system test/regression test and UAT of applications.
• Correct program errors, prepare operating instructions, compile documentation of program development.

Environment: Oracle 11g/10g, Oracle 11g Forms & Reports, PL/SQL, TOAD, UNIX, and Windows XP.

Confidential, Dallas, TX

Oracle Pl/SQL Developer/ Data Analyst

Responsibilities:

• Collaborated with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in logical modeling and physical modeling of application.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Involved in creation of Conceptual Modeling covering all the business requirements.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
• Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Involved in moving the schema using export and import from production to Development and Development to Test Boxes.
• Developed Outbound interfaces in HR module to send across the employee master data and time data to ADP.
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Procedures for efficient error handling process by capturing errors into user managed tables.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with master tables, insert the valid data into Customer Management System and invalid data into error tables which will be sent back to sender notifying the errors.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Created some oracle objects for OLAP.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 10g,Oracle Forms 10g, PL/SQL, TOAD, SQL Developer, Shell scripting (Bourne and Korn), SQL*loader, Stored Procedures/Triggers, XML, Sun Solaris 5.6.

Confidential

Oracle Pl/SQL Developer/ Data Analyst

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created SQL*Loader control files for loading the data from flat files to staging area tables.
• Developed SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Designed and developed complex reports to meet end user requirements and deployed using Oracle Report 10g.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms 10g.
• Involved in logical and physical database design, Identified Fact Tables, Transaction Tables.
• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER, etc.
• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Developed Reports for Financial, Procurement and HRMS modules
• Created Bitmap indexes on low cardinality columns as they result in reduced response time for queries and substantial reduction of storage space.
• Design and development of conversions, interfaces, customizations, Custom Forms, Reports and all Technical design and solutions.
• Implemented Application Infrastructure policies, procedures and standards, and ensured their continual compliance.

Environment: Oracle 10g, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 10g, Reports10g.

Confidential

Oracle PL/SQL Developer/ Data Analyst

Responsibilities:

• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Knowledge of Normalization, and data transfer, documentation, preventive maintenance, code review, automation, store procedures and triggers etc.
• Performed exception handling for data that did not conform to the required format.
• Responsible for making the merged data in turn available to other clients.
• Wrote UNIX scripts to automate loading files into database using error handling and notification.
• Involved in implementing the data integrity validation checks through constraints and triggers.
• Involved in developing packages for implementing business logic through procedures and functions.
• Developed and modified procedures, functions, triggers, forms, reports and deployed the changes in the system.
• Developed user interfaces using Oracle Forms.
• Extensively involved in application tuning, SQL tuning, memory tuning and I/O tuning using Explain Plan and SQL trace facilities.
• Performance of the queries is enhanced by executing optimization techniques such as index creation, table partition and coding stored procedures.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Used UTI FILE PACKAGES for writing DBMS OUTPUT messages to file.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.

Environment: Oracle 9i, SQL, PLSQL, SQL*Loader, UNIX Shell script, TOAD, Oracle Forms 9i, Reports9i.