SUMMARY:

• An IT professional with 8 years of progressive programming experience in designing, developing and implementing Complex Business applications, using Oracle Relational Database Management System (RDBMS).
• Hands on experience in all phases of Software Development Life Cycle (SDLC) including requirement gathering, analysis, design, development, testing, implementation, maintenance and documentation.
• Extensive experience in developing applications using Oracle database 11g/10g, on Windows/Unix Environment.
• Strong Coding and Designing Experience in Oracle PL/SQL & SQL scripting.
• Expertise in the development of PL/SQL Stored Procedures, Functions, Triggers and Packages in PL/SQL to implement business logic in the source and target mapping documents.
• Experience in designing and developing Complex applications, developing Reports for Internet/Intranet based applications using Oracle sql scripting, PostgreSQL and SSRS.
• Extensively worked on data Extraction, Transformation and loading (ETL) data from various sources like Oracle, SQL Server and different file formats utilizing oracle Utility tools SQL *Loader, Import and Export and also used Informatica Power center in the upstream processing.
• Expertise in Massaging & filtering of data at the Staging Table using different logics in the control file and developing reusable PL/SQL procedure, functions and exclusively Utilized PL/SQL For all, BULK Collect feature to optimize the ETL performance.
• Expertise in writing SQL Queries in SQL*Plus, PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, in Performance Tuning of SQL queries scripts in SQL*Plus& Views using Explain Plan, SQL Trace, on Oracle 11g/10g databases.
• Experienced in performance analysis and SQL query tuning and run time reduction using Explain plan and query rewrite.
• Analyzed data from different data source, eliminated irrelevant and unneeded data and addressed high defects in UAT and Production which helped me in gaining knowledge in data mining
• Good knowledge on Logical and Physical Data Modeling. Experience with Data flow diagrams, Data dictionary, Database normalization techniques, Entity relation modeling and design techniques.
• Experience with Star SchemaModeling and knowledge of Snowflake SchemaDimensional modeling.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and Dimension Modeling for OLAP, helping to make the source to target mappings easy.
• Extensive experience developing ETLs for large Data Warehouse environment using Oracle 11g/10g in Agile Methodology.
• Expertise in working with Oracle built - in packages such as DBMS JOBS; DBMS SCHEDULER, DBMS SQL, DBMS XSML, UTL FILE, UTL MAIL.
• Experience in Global Temporary Tables (GTT), Pipeline Functions, Exception handling and Dynamic SQL in Toad and SQL*Plus.
• Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• Worked closely with users to understand and prioritize business goals and information needs, then translate these needs into system requirements and design specifications; refine conceptual systems design requirements into the technical design.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills.
• Received many appreciations from Client for delivering bug free product within the estimated schedule.
• Domain knowledge on Investment/Financial Banking, Tele-Communication, Healthcare, Medicare yet willing to broaden my exposure even in other domains.

TECHNICAL SKILLS:

RDBMS: Oracle 11g, Oracle 10g, 9i, SQL Server

Scripting: SQL, PL/SQL, Advanced Pl/SQL, PostgreSQL, C, C++, UNIX shell scripting

Tools: Oracle SQL Developer, Toad 12.0, SQL*Plus, SSIS, Oracle forms, reports builder 10g, Putty, Erwin, Ab-initio, Informatica Power Center.

Data Analysis: Requirement Analysis, Business Analysis, Detail Design, Data Flow Diagrams, Data Definition Table, Business Rules, Data Modeling, Data Warehousing, System Integration, Data Mining

Web and Application servers: Web sphere, HTML, XML, PHP 5, VB Script, VBA, Qlick View

Packages: MS Office Suite- MS-Word, MS-Excel, MS-Power point.

Others Tools: MS Visio, Quality center, SVN, SQL*Loader, Sql*plus, SQL Developer, PLSQL Developer, MS Project Professional 2013

OS: Windows 8/7/XP/2000/Linux, Mac

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Oracle PL/SQL Developer

Responsibilities:

• Analyze all business requirements and document all technical specifications and prepare codes for same and design and implement all test unit procedures.
• Develop new programs and codes for all existing ones and prepare all technical specifications for various applications and ensure adherence to all project time-frame.
• Analyze all existing programs and perform appropriate coding and tests on all programs and implement.
• Collaborate with various user groups and perform research on all data processing functions and source to target mappings and the required transformations.
• Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.
• Analyzed data from different data source, eliminated irrelevant and unneeded data and addressed high defects in UAT and Production which helped me in gaining knowledge in data mining
• Interacted with OBIEE business analysts to develop entity relationship within their setup to process data efficiently.
• Database performance tuning for achieving high scalability and speed by tweaking the SQL scripts.
• Analyze and ensure efficient transition of all technical design documents and develop various analytical SQL scripts in SQL*Plus and PL/SQL packages to provide support to all application developers.
• Developed PL/SQL stored procedures, functions and packages in Oracle for SSRS Reports.
• Developed data integration strategies to create an Extract file (Text /CSV File) using UNIX shell Scripting.
• Implemented migration tasks from PostgreSQL to oracle database.
• Coordinate with various developers, project managers and analyst to prepare designs for new upstream applications and helped the ETL process using INFORMATICA Power Center and documented all processes to ensure effective evaluation of all applications.
• Effectively used Event Handlers, Logging, Error handling, Checkpoints and Package configuration during PLSQL packages deployment and maintenance.
• Worked extensively on data extraction, cleansing and data integration, and loading from various data sources and Spool the output to CSV files using UNIX shell scripting.
• Documented the HLD of the process using VISIO, so that it would be very useful for the ones who come new on board.

Environment: Oracle 11g/10g, SQL, PL/SQL, Oracle SQL Developer, PostgreSQL SQL*Loader, SQL*Plus, Oracle Forms builder 10g, TOAD, UNIX, Qlick view, OBIEE, Oracle Apps, Informatica Power Center, Data Modeling, Data migration, SQL Navigator, Unix Shell Scripting, SSIS, SSRS, DATA Mining.

Confidential, Frederick, MD

Oracle PL/SQL Developer

Responsibilities:

• Involved in analyzing the data mapping documents and data flow diagrams.
• Provided scripts to create database objects needed such as, tables, views, indexes, procedure, functions and packages.
• Worked on setting up the change tables, change views and packages for oracle native CDC (change data capture).
• Created/modified oracle loan procedures, packages and functions to move the change data across multiple environments using DB links.
• Responsible for improving the performance of oracle CDC load process.
• Worked on analyzing, fixing and testing the CDC conflicts issues in production. Worked on creating test cases and data validation scripts.
• Worked on Use cases, which enables users to check the pool level statistics of fixed and ARM pools and trades through UI.
• Developed automated scripts to create audit triggers for the tables.
• Created SQL loader scripts to load the data from files to temporary tables.
• Worked on rotational on call support.
• Worked extensively in designing and developing the process for the ARCHIVAL and UNARCHIVAL of pooled loans in to the POSTWARE database, on the basis of the LOAN status on the SMS (Secondary Marketing System).
• Worked on the design and development of CORE Loans Consumption Process, and the Reporting Package adhering to the Business Requirements.
• Built the package with Error-Trap Process using the Save-Exceptions
• Created analytical SQL scripts and queries to handle the error loans and was able to quickly point to the column which has corrupted information.
• Extensively worked on complex Prod/UAT defects (CDTS) and resolved them efficiently in time.
• Thoroughly analyzed the upstream process and their ETL in Informatica Power Center and came up with the design and the plan for the Error-handling mechanism, which serves as a Maintenance package.
• Held Meetings and worked with the off-shore Team closely and guided them to build the Maintenance pkg
• Created Detail Technical Documents and participated in the meetings with business helping the BSC to write the Functional Specification Document on the Capital/Money Market Database.
• Documented the HLD of the process using VISIO, so that it would be very useful for the ones who come new on board.

Environment: Oracle 10g, SQL, PL/SQL, SQL*Loader, SQL*Plus, Informatica Power Center, Ab-initio, MS Access, SQL Developer, Oracle Forms 10g, Reports10g, Windows XP/2000, Data Modeling, Data migration, SQL Navigator, Unix Shell Scripting, Investment/Financial Banking, Pooling and trading System.

Confidential, Reston, VA

Oracle PL/SQL Developer

Responsibilities:

• Studied user requirements and converted them into formal Functional specifications while interfacing with the client.
• Worked to define the project implementation strategies.
• Responsible for System Analysis, Development and support for ATLAS.
• Involved in Designing and Partitioning of the tables in the database along with DBA as a part of performance tuning.
• Involved in writing PL/SQL Packages, Functions and Stored Procedures and DB Triggers and Developed database objects like tables, views, indexes, and sequences.
• Responsible for back end stored procedures development using PL/SQL predefined Procedure.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Extensively developed PL/SQL sub-programs with features like FOR ALL, bulk collection for high performance of stored procedures.
• Understood complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Loading of the data from different data sources like CSV, XML, FLAT files etc, to oracle database using SQL Loader.
• Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
• Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Used CRONJOB for job scheduling on UNIX as well as tools like Autosys to run regular day to day administration scripts and setting up batch scripts.
• Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing SQL *Loader.
• Created indexes, materialized views to improve the system performance.
• Used different oracle utilities such as explain plan, SQL trace, Oracle hints for Cost based optimization of the query to increase the system performance.
• Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
• Used built in functions of PL/SQL such as SQLCODE, SQLERRM for error reporting.
• Used RAISE APPLICATION ERROR, PRAGMA EXCEPTION INIT to capture error Messages.
• Used PL/SQL Built-in Packages DBMS STANDARD, DBMS OUTPUT
• Developed forms and reports using Oracle Forms and Reports Builder 10g
• Wrote SQL Scripts for reports and creating views for reports.
• Involved in Developing and Customizing Forms and reports based on the requirement
• Prepared Technical specifications documents and Application Design documents

Environment: Oracle 10g,11g, Oracle SQL Developer, Oracle Forms, Reports Builder 10g, Unix, SQL complex queries, SQL*Plus, and stored procedures.

Confidential, New Jersey

Oracle PL/SQL Developer

Responsibilities:

• Involved in Development and Production support phases in the SDLC. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Designed and developed common utilities for standardizing certain functionality using packages and sub programs.
• Participated in System Analysis, Design and Data Modeling.
• Created programming code using advanced concepts of Records, Collections and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility. Writing validation packages using PL/SQL package.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Involved in writing data base objects to implement interface using procedure, functions and packages to enhance the application based on the client requirements using Oracle SQL and PL/SQL.
• Created and manipulated stored procedures, functions, packages and triggers using Oracle Sql Developer.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in working with INLINE CURSORS, EXPLICIT CURSORS, REF-CURSORS.
• Used Global Temporary Tables (GTT) and Pipeline Functions in ETL process for stage-tables.
• Used SQL Loader to load the data into oracle stage-tables from different data sources like FLAT, CSV and Text files.
• Design and develop Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL* Loader and External tables.
• Strong knowledge of OLTP and ETL Process using Import/Export and DBMS XSL Processor in a Data Warehouse System.
• Supplied packages were used to extend the functionality of PL/SQL programs such as DBMS JOB for scheduling, UTL FILE to read and write from database, DBMS SQL to write Dynamic SQL etc.
• Developed custom Oracle Forms and Reports as per client requirements and making them web enabled using Oracle Forms builder 10g and Oracle Reports builder 10g respectively.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• Designed and created new customized reports using SQL Developer 3.1. Interacted with the client IT team and the business team to resolve issues and dependencies.

Environment: Oracle 11g/10g, SQL, PL/SQL, Oracle SQL Developer, SQL*Loader, Oracle Forms builder 10g, TOAD, UNIX.

Confidential April

Oracle PL/SQL Developer

Responsibilities:

• Associated and involved in different phases of System Development Life Cycle (SDLC).
• Interacted with business analysts to develop entity relationship diagram.
• Created complex stored procedures and functions using PL/SQL.
• Database performance tuning for achieving high scalability and speed.
• Written SQL scripts, PL/SQL stored procedure, functions, triggers, and packages.
• Involved in developing front end screens using forms 6i and generated reports using reports 6i builder.
• Written scripts to validate data in staging tables and developed SQL*Loader control files to load the data from flat files into the staging tables.
• Support developers with database objects, including tables, views, triggers and stored procedures as well as DDL, DML SQL queries.
• Provided technical support to end users like modifications in PL/SQL modules, User Interface based on the defects observed in testing and production phase
• Responsible for coding and debugging and maintaining quality standards set by management.

Environment: Oracle9i, SQL, PL/SQL, SQL*Loader, SQL*Plus, Oracle Forms 6i, Toad, Windows 2000/NT/XP, UNIX.

Confidential,

SQL Developer Trainee.

Responsibilities:

• Associated and involved in different phases of System Development Life Cycle with Sr. Oracle Developers.
• Interacted with business analysts to understand the Business Requirements.
• Written SQL scripts using Joins and aggregate functions.
• Written simple PL/SQL stored procedure, functions, triggers, and packages after analyzing the Requirements thoroughly with the other members in the team.
• Written complex queries using joins, sub query, correlated query.
• Involved in developing front end screens using forms 6i and generated reports using Reports 6i builder.
• Developed the forms for the application and including forms based on stored Procedures at application level.
• Developed SQL*Loader control files to load the data from CSV files into the staging tables which was one of the part in the ETL Process.
• Provided technical support to end users like modifications in PL/SQL modules, User Interface based on the defects observed in testing and production phase.

Environment: Oracle9i, SQL, PL/SQL, SQL*Loader, Oracle Forms 6i, Windows 2000/NT/XP.