PROFESSIONAL SUMMARY:

• Over 8 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Experienced with various versions of Oracle Databases including 8i/9i/10g/11g.
• Proficient in writing complex SQL Queries, creating Views, Materialized Views, PL/SQL Procedures, Functions, Packages, Triggers, Utilizing Cursors, Collections, Ref Cursors, Cursor variables, System Reference Cursor, Dynamic SQL, Exceptions and other advanced coding methodology.
• Demonstrated expertise in using PL/SQL to build Oracle Packages, Stored Procedures, Functions, Triggers, and Cursors for processing data, enforcing referential integrity and needed business rules.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads.
• Expertise in Developing, Customizing and Implementation of the Oracle Application Module Order Management (OM)
• Experience in developing and maintaining of AutoSys and related scheduling solutions.
• Proficient in Oracle tools and utilities such as TOAD, PLSQL Developer, SQL*Plus, SQL Developer, SQL*Loader, SQL Navigator, OEM (Oracle Enterprise Manager).
• Extensively Used Cursors, REF Cursors, Bulk technics for Data extraction and Data Loading.
• Utilized Informatica debugger for trouble - shooting and to test the data flow.
• Extensive Performance Tuning experience working with Indexes, Hints Optimizer Statistics, TKPROF and Trace files. Worked heavily with TablePartitioning.
• Extensively worked on Dynamic SQL, Global Temporary Tables, PLSQL Collections, Objects, Records, and Bulk Collections etc.
• Experience in developing UNIX shell scripts. Working knowledge with various UI like Secure Shell, Telnet and Putty.
• Experience in uploading the rules on Oracle DRM.
• Experience in implementing the business rules by creating transformations and developing Mappings.
• Experience on implementing Slowly Changing Dimension Type1, Type2 for Data warehouses.
• Expertise in scheduling Jobs using Autosys.
• Extensively involved in performance tuning for various oracle based applications for enhancing the load performance in various schemas across databases using methods like EXPLAIN PLAN, TKPROF and SQL TRACE.
• Expertise in creating Test Cases, Test Plans, Technical Design Documents and Functional Design Documents.
• Well versed with Unit testing, White Box Testing, Black Box Testing, System testing, Integration testing, Load testing, and Regression testing.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Good knowledge on Version control, ticketing systems and code migration software like Clear case, Quality Center, SYSAID, etc.,
• Good interpersonal skills with excellent written and Oral Communication.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g/9i/8i, SQL Server 2000/2005.

DB Tools: TOAD,SQL*Plus, SQL*Loader, PLSQL Developer,Netezza.

Oracle Tools: Oracle Reports 10g/6i, Oracle Forms 11g/10g/6i.

Language: SQL, PL/SQL, C, C++, Java.

ETL tools: Informatica Power Builder 8.6/9, MS VISO, ERWIN, SSIS, SSRS

Web Technologies: HTML, JSP, Servlets, VBScript.

Scripting Languages: UNIX shell (Bourne and KORN) Scripting, Perl.

Test Automation Tools: Win Runner, Load Runner, QTP, Test Director and Quality Center.

Operating Systems: Windows 98/2000/XP, HP UNIX, Sun Solaris, AIX, and LINUX.

Version Control: CVS, SVN, Clearcase, Pvcs, Udeploy, Jenkins, Gitstash, Kintana.

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Netezza/Oracle Developer

Responsibilities:

• Implemented procedures for development of detailed specifications along with interfaces and platforms.
• Developed programming solutions according to established standards and operating instructions.
• Creating tables in Netezza database and migrating the code from oracle database.
• Utilizing utility package and writing jobs to migrate from oracle to Netezza .
• Writing steps files to run the jobs in Unix environment
• Performing unit testing to check how the data is populated.
• Designing and implementing Surrogate keys , SCD ’s Type1, Type2 for the dimensions in the data warehouse .
• Developing new technology as per Technical review forum (TRF) and writing the procedures to get the data from source database.
• Implementing SCD Type1 by using hash key and primary key .
• Working on Oracle DRM to upload the rules under the hierarchies manually.
• Created Records, Tables, Objects, Collections, Views, Materialized Views, Exceptions and Global temporary tables (Nested Tables and Varrays) and performed Error Handling.
• Using different types of JOINS and HINTS to select the particular data as per business requirement and populate it in the target tables.
• Scheduling batches and sessions for daily loads and tracking the performance.
• Working on Unit Testing and debugging the issues on daily basis.
• Writing complex SQL Queries using aggregate, analytical functions involving multiple tables with joins.
• Developing Control M jobs to run the code on daily basis to populate the data.
• Writing ksh jobs to send daily feed to Oracle DRM.
• Validating data with the end users and business analysts .
• Supporting QA team and giving them the over view of the business and how the code works.
• Resolving the defects and updating the technical documents.
• Checking in all the code as per the daily process and tracking how the jobs run and solving the issues.
• Deploying code on the daily basis using Udeploy and Jenkins .

Environment: Oracle 11g, SQL Developer, SQL*Plus, SQL*LOADER, PVCS, Unix, Aginity for pure data systems for analytics, Oracle DRM, Gitstash, Jenkins, Udeploy.

Confidential, Dallas, TX

Application Developer

Responsibilities:

• Upgrading HCTRA legacy data to BOS2.0 by adding new functionalities and requirements.
• Involved in migrating Transactions and payment related modules to BOS2.0
• Involved in business process analysis and requirement gathering for new customization development.
• Resolving Performance issue by decreasing cost of multiple queries by indexing multiple columns using the Hints to perform well.
• Developed oracle applications using Application programming Interfaces (API) for inserting and updating the data in oracle applications.
• Worked with QA team to verify/review the test scenarios and test cases.
• Created Records, Tables, Objects, Collections, Views, Materialized Views, Exceptions and Global temporary tables (Nested Tables and Varrays) and performed Error Handling.
• Written complex SQL queries using INNER/OUTER joins, Union All, Intersect & Minus set operations.
• Involved in oracle Migration (Database) by creating oracle PL/SQL functions, stored Procedures, Triggers, Packages.
• Developed new Packages to load eligible Transactions into Target table based on business criteria using MERGE statement.
• Developed an effective Error Mechanism for the application using pl/sql routine to send automated emails, created Error-Log Tables and used Autonomous transactions, Locks.
• Performed unit and integration testing of the applications and PL/SQL modules and used CLEARCASE for version control in team development.
• Experience in writing the testing test scripts, test cases for implementation of HCTRA BOS software.
• Exported and Imported data using SQL developer and PL/SQL developer.
• Created PL/SQL packages to perform validations on data from legacy system before loading into Oracle.
• Modified and debugged several SQL queries and PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and HINTS.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created migration run time table to check the performance issue in the process of performance tuning.
• Worked on testing and validating the front end applications on how migrated data works for the current functionality.
• Wrote packages to fetch complex data from different tables in remote databases using joins , sub queries , hints and database links.
• Designed Data Modeling, Design Specifications and to analyze Dependencies .
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.

Environment: Oracle 11g,12c, PLSQL Developer, Microsoft VISIO 2010, SQL*Plus, SQL*LOADER, clear case

Confidential, Atlanta, GA

Sr. Oracle Developer

Responsibilities:

• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Developed the UNIX scripts using KORN shell to automate jobs.
• Worked closely with team in planning, developing and creating mobile applications to match the needs of industrial clients.
• Used Clear case for version controlling and Clear Quest for ticketing system.
• Developed UNIX scripts to automate frequent reports for the users
• Involved in development and maintenance of new applications and optimizing the performance of Aggregation layer to provide a quick response for all the applications.
• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs and running files in batch mode.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Created and used DB- links to connect to other local and QA databases.
• Created documentation for migration and performed extensive testing during the various phases of product implementation.
• Worked closely with the client for gathering requirement for enhancing the existing functionalities and also create new functionalities in the existing mobile app
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Worked on enhancing the existing shell scripts for automating the process of refresh of data periodically.
• Used Materialized views in places where the data does not change very frequently.
• Proved to be a responsible resource to handle performance tuning of SQL queries and PL/SQL stored procedures using Indexes and optimizing hints..
• Worked on moving all SQL code from java to DB2 SQL procedures.
• Planned, Designed and Implemented Table Partitioning for improving performance.
• Developed PL/SQL Packages and Database Triggers.
• Written complex PLSQL procedures by implementing Object-Oriented Programming using Object Types by providing high-level of Abstraction.
• Developed, Tested and Migrated UNIX Shell Scripts.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs and running files in batch mode.
• Analyzed and rectified bugs reported during System Testing and User Acceptance Testing and post production support.
• Responsible for creating stored procedures, packages, functions and triggers.

Environment: IBM DB2Database (AIX), PLSQL Developer, Data Studio v4.1.1, SQL*Plus, SQL*LOADER,UNIX

Confidential, EI Segundo, CA

Sr. Oracle Developer

Responsibilities:

• Involved in Data Integration using Informatica Power Exchange, Data Explorer and Data Quality.
• Developed various complex PLSQL Stored Procedures, Functions, Cursors, Packages, Triggers and Views in the process of creating AUTO and Home Quote and binding a Policy.
• Worked with Data Stage to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Involved in Maintenance, installation, configuring all the control-M deployments
• Provided support of control-M in the new environment including product support in the creation and editing of the new and existing control-M jobs.
• Developed the UNIX scripts using KORN shell to automate jobs.
• Worked extensively on tuning SQL queries and database modules for optimum performance.
• Involved in Data loading and Extracting functions using SQL*Loader.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PL/SQL, SQL*Loader and UNIX shell scripts, to load data from flat files to Oracle database. Performed Data modeling and Designing Oracle Objects Types based on Data Access Layer of the web Applications
• Involved in writing Stored Procedure for XML generation and converting them into PDF format.
• Involved in Scrum, Daily stand-ups, iteration reports.
• Expertise in creating Pro*C Batch Programs with embedded SQL’s, Pl/Sql Procedure calls, Arrays and Dynamic SQL..
• Developed Bulk collect, Object types, Dynamic cursors using advanced PL/SQL programming.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Served as a SSRS 2000 Reports Developer and SQL Server Developer in support of Service Management System.
• Extensively used Triggers for maintaining data integrity and data validation.
• Developed, customized and compiled forms to meet client specific business needs, using Forms 10g. Actively participated in the migration of forms from 6i to 10g.
• Customized Workflow, OM Order Line - Return Receipt/Inspection to send Notifications to inform the individual who created the Return that the return has not been received or inspected within defined criteria
• Modify existing ETL scripts to fix defects at the root cause as enhancement part of project.
• Fine-tuned Informatica jobs by optimizing all transformations.
• Assist Informatica developers in developing mappings with better performance by tuning SQL overrides used in Source Qualifier and Lookup Transformations.
• Delivered end-to-end source to target mapping, and transformation logic for ETL processing.
• Designed and developed Informatica Mappings to load data from Source systems.
• Worked on Migration of Data warehouse in between different versions.
• Created Mail Scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized Subject and Text.
• Developed Perl scripts to automate frequent reports for the users
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and MS-Word.
• Analyzed, designed, optimized and tuned PL/SQL Procedures, Oracle Stored Procedures and used SQL*Loader to load the Historical data into the data warehouse.
• Involved& gathered feedback in the Project plan management sessions as well in Actimize kick-off meeting
• Developed and implemented the new flow of Component trades which includes loading the feed file in Perl/Unix shell, applying the business rules through stored procedures and generating the report in Perl for the end users
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys.
• Extensively utilized Rational Team Concert for code check-in, and Delivering the code to Integration, Pre-Production and production Streams.

Environment: Oracle Database 11g/10g, PLSQL Developer, Toad, SQL*Plus, SQL*LOADER, UNIX,PERL, Forms 10g, Reports 10g, Actimize, Rational Team Concert, Informatica Power center 9, Quality Center 10.0

Confidential, Greenbay, WI

PL/ SQL Developer

Responsibilities:

• As an Oracle developer responsible for analysis, requirements gathering, documentation of technical specifications, data mapping, development and testing.
• Created several database objects like Tables, Views, Triggers, Packages, Procedures and functions
• Developed complex SQL queries using Joins, nested queries, in line Views, in built Packages, Functions and clauses.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Imported various Sources (File based ETL Loading and RDBMS), Created Targets, and Transformations using Informatica Power Center 9.1 Designer.
• Utilized Informatica debugger for trouble-shooting and to test the data flow.
• Developed the PL/SQL applications using advanced features like Native dynamic SQL (NDS), Bulkcollect and INDEX BY TABLES.
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and for better performance.
• System migration from Search space Windows platform to a Web Based Actimize platform and assisted the Project management team in documenting the changes and migration process.
• Performed Imported various Sources (File based ETL Loading and RDBMS), Created Targets, and Transformations using Informatica Power Center 9.1 Designer.
• Imported various Sources (File based ETL Loading and RDBMS), Created Targets, and Transformations using Informatica Power Center 9.1 Designer.
• Performed Informatica Code Migration from Development/Systest/QA.
• Good knowledge on object oriented practices (native perl or Moose) or procedural scripting
• Providing workflows and other information required in the development of code of the perl scripts
• Extensively used Informatica PowerCenter for Extraction, Transformation and Loading process.
• Created various database objects as on need basis to support business like, tables, temporary tables, views, materialized views, stored procedures, functions, triggers and packages.
• Customized Report to change its layout like changing size of the fields, adding some extra field into the display, changing the display of the Report. Writing after Parameters Triggers for the Validation of the data, using Reports 6i.
• Implemented Perl packages extensively. Used multithreading. Used SOAPLite module to communicate with different web-services based on given WSDL
• Implemented Mod PL/SQL which allows easy and efficient connection to Oracle 10g Database to the Internet.
• Extensively worked in Performance tuning of PL/SQL
• Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.
• Developed UNIX shell scripts for batch jobs.
• Involved in loading the data from flat files to Oracle tables using SQL*Loader and C.
• Developed Perl and Shell scripts for upload of data feed into database
• Uploading the Test cases, Manual Test Scripts, Codes and Specification Documents on Visual Source Safe (VSS) for version controlling.

Environment: SQL, PL/SQL, Oracle 11g/10g, SQL* plus, TOAD, Windows 2007, Windows server 2003, MS Office, Tortoise SVN,PERL, Informatica PowerCenter 8.6.0, UNIX Shell Scripting, Linux, and Solaris.

Confidential, Manhattan, NY

Team Lead

Responsibilities:

• Developed complex applications using PL/SQL, Oracle Forms and Reports to suit business needs
• Generated PL/SQL packages with dynamic SQL queries as per the requirements.
• Designed and developed complex Informatica mappings, mapplets, reusable transformations, workflows and worklets using various tasks to facilitate daily, weekly and monthly loading of data.
• Successfully created various Database Objects such as temporary tables, PL/SQL tables, views, materialized views, Indexes, sequences.
• Performed Database Application Level Tuning and Coordinated directly with the end users to understand the Business Requirements and convert them into functional and technical specifications.
• Designed AutoSys based solutions for communication of issues to technical teams.
• Responsible for migrating the folders, mappings and sessions from development to QA/production.
• Load operational data from DB2, SQL Server, flat files, Excel Worksheets into various data marts.
• Drew ER - diagram and workflow chart for better understanding.
• Extensively used the Oracle utilities such as Export/ Import, SQL*Loader, SQL Trace, TKPROF and day-to-day activities of different databases.
• Design and Developed Customized Reports.
• Extensive use Oracle enterprise manager, shell scripting and other analytical tools to performance tune mission-critical Production environments
• Implemented Perl packages extensively.
• Participated in designing and development of applications utilizing Actimize Intelligence Modeler.
• Updated tables without breaking the existing functionality.
• Developed Perl scripts to automate frequent reports for the users
• Worked on ETL tools like Power Center8.0 which were used for data integration and also mapping the data.

Environment: Oracle 10g, PL/SQL, Oracle Forms 10g, Oracle Reports10g, Informatica Power Center 7.1,Oracle SQL Developer, PERL, Actimize, SQL*Plus, SQL*Loader, TOAD.

Confidential, Miami, FL

PL/ SQL Developer

Responsibilities:

• Responsible for gathering Business Requirements, creation of Technical design documents and user Documents.
• Used SQL*Loader, PL/SQL procedures to facilitate data import to staging tables, interface tables and then to base tables.
• Used Materialized views in places where the data does not change very frequently.
• Developed UNIX shell scripts for batch jobs.
• Designed and developed Oracle Monthly Reports.
• Scheduled the execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Used Materialized Views to simplify data-warehouse summary management and speed query processing at the same time.
• Implemented corporate database backup management policy by automating various kinds of backups using UNIX shell scripts.
• Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.
• Wrote Queries to retrieve data in XML format from the tables.
• Responsible for technical support of the products.
• Involved in supporting the Java web development team.
• Developed Email Routing logic for validating, classifying and processing the incoming emails to Email Center.
• Worked on different kind of setups included in Email Center like mapping the Service Request to various groups, creating new groups, assigning agents to the groups etc.
• Developed an Interface for creating order details in to custom extension table and for creating the notes in the QTC/BV instances depending on the order number environment.

Environment: Oracle 9i/10g, SQL, PL/SQL, Oracle Forms 6i, Oracle Reports 6i, TOAD,SQL Loader, UTL FILE utility, XML, Performance Tuning, ETL Tools, Windows 2000, Cygwin, FTP, UNIX

Confidential

Oracle PL/ SQL Developer

Responsibilities:

• Assisted in database designing by creating database objects such as Tables, Views, and Indexes.
• Worked with Sub-queries/Correlated Sub-Queries in Different areas of the database.
• Received data from source (Soft Dollar, Market data & Communications) and imported the data to the interface table using SQL * Loader.
• Developed validation programs to validate the data before importing into oracle tables.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Developed PL/SQL Packages and Database Triggers.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loaderand PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.
• Developed user interfaces using Oracle Forms.
• Customized Reports using Reports according to client requirements.
• Developed Revenue reports like Monthly and weekly Revenue, Total Revenue and Monthly Transaction and Revenue Comparison Reports.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Loader, TOAD, UNIX, Forms 6i, Reports 6i.

Confidential

PL/ SQL Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the BRS document.
• Involved in database modeling and database design.
• Prepared program specifications for PL/SQL Procedures and Functions to do the data-migration and conversion.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures and Packages.
• Involved in database priming, which would update the eligibility, tables with the most current data.
• Run batch jobs for loading database tables from flat files using SQL*Loader.
• Developed an Interface for creating order details in to custom extension table and for creating the notes in the QTC/BV instances depending on the order number environment.
• Developed a custom program for sending survey emails to customers after the service request is closed.
• Created and used DB- links to connect to other local and QA databases.
• Developed new functionality in the existing application as part of change requests.
• Performance tuned DB queries.
• Involved in Unit testing and Integrated testing.
• Created Unix Shell scripts for automating the execution process.

Environment: Oracle 8i, SQL, PL/SQL, SQL Loader, UNIX, Windows 2000.

Confidential

PL/SQL Developer

Responsibilities:

• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the enhancements and fixing of production problems.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created indexe s on the tables for faster retrieval of the data to enhance database performance.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.

Environment:: Oracle 8i, SQL, PL/SQL, SQL Loader, UNIX, Windows 2000.