SUMMARY:

• 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 .
• Expert level skills as an Oracle backend developer. Includes PL/SQL and SQL coding, stored procedures, packages, functions, cursors, triggers, constraints, DDL, scalable complex queries and UNIX scripting for loading data.
• Strong experience in Data warehouse concepts.
• Strong experience in ETL, Oracle Warehouse builder, Informatica.
• Good experience in data migration.
• Strong experience in query and performance tuning.
• Strong experience in banking and financial sector.
• Strong conceptual knowledge of Oracle SQL, PL/SQL, Oracle server 11g/10g/9i/8i , Oracle Forms 6i /9i, Oracle Reports 6i / 9i.
• Strong knowledge and experience in advanced PL/SQL concepts like Result cache, encryption, rows security, Pragma serializable packages, bulk collect, external tables.
• Experience in the functional and technical aspects of Oracle E-Business Suite, OBIEE.
• Sound working knowledge in UNIX based Operating System.
• Excellent working knowledge of Crystal Reports.
• Strong SQL Loader experience for data uploading from flat files.
• Strong experience in using TOAD, SQL Developer, SQL Plus and SQL Navigator.
• Worked on production support for more than 3 years, receiving production calls on trouble reports from Client.
• Experience with SQL Server and DB2.
• Tuning and optimizing current/new applications utilizing DBMS packages, and enhancing performance through regeneration and rebuild of indexes and creation of views
• Analyze data quality and report the anomalies to business users using TOAD
• Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle SDLC .
• Excellent analytical, problem solving and communication skills required for working effectively in the field of applications development and maintenance.
• Excellent work ethics, fast enthusiastic learner and a good team player. Strong management, administrative and leadership skills to work in team.

TECHNICAL EXPERTISE:

• Databases : Oracle 11g, 10g/ 9i /8i, DB2, SQL Server Scripting : SQL, PL/SQL, UNIX Shell Scripting Languages : C, C , JAVA, C , XML, .NET
• Query Tools : TOAD, SQL Navigator, SQL PLUS, SQL Developer, SSMS
• GUI Tools : Oracle Forms 5/6/ 6i / 9i, 10g, 11g, Oracle Reports 6i/9i/10g/11g
• Packages : E-Business Suite Oracle Applications R12.0.6, 11i. 11.5.10 , OBIEE Operating Systems : Ubuntu 12.04, Red Hat, Solaris, OS X, Windows XP, 7, 8
• Other Tool : Discoverer 9i, SQL Loader, Summix, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst PL/SQL

Responsibilities:

• Worked on the Credit Risk Oracle data warehouse CRDB .
• Created a new Oracle data warehouse schema as the source for Summix Maestro, a web based tool on top of SQL Server 2012, for generating CCAR reports.
• Created and manipulated stored procedures, functions, indexes, triggers, materialized views, tables, sequences, views on TOAD 12.5/11.6.
• Responsible for guiding and coordinating all aspects of BI project analysis, including requirements gathering, technical specification, detailed data mapping and unit testing.
• Responsible for reverse mapping and data validation of fields from existing schemas in data warehouse to get their actual source used for creating the new hybrid schema.
• Responsible for writing various scripts based on the concepts like dynamic SQL, referential cursors, nested tables, bulk collect, oracle hints, subfactoring etc. in CRDB.
• Responsible for creating the environment on the Summix Maestro tool for various line of business, like auto loans, commercial real estate loans, large business loans etc.
• Created procedures, functions, indexes, partitions, optimizing various joins for tables in the Summix maestro, a web based GUI tool, for creating data warehouse environment.
• Part of the two men team acting as liaison between Oracle database and SQL Server side of the project.
• Worked on Informatica PowerCenter for loading data from flat files into tables and for reverse mapping of fields.
• Responsible for writing complex analytical queries for creating reports in Summix tool on top of SQL Server, in SQL server Management Studio SSMS .
• Assisted in the preparation and documentation of program requirements, specifications and validation of data.
• Provided support for issues arising in the production environment of CRDB, outside the CCAR project.
• Responsible for converting SAS code into PL/SQL procedures and testing/ validation.
• Responsible for conducting peer code review and inspections.
• Responsible for unit and performance testing on both oracle and SQL server.
• Excellent written communication skills. Able to communicate the key issues, problems and requirements with team members from Holland, Belgium and Spain proficiently.
• Experience in both agile and scrum methods.
• Ability to facilitate meeting, follow-up with resulting action items, prioritize and execute tasks in a high-paced environment.

Environment: Oracle 11g, TOAD 11.5/12.6, SQL Server 2012, SSMS, Informatica Power-Center 9, Windows 7, Summix, Summix Maestro, SQL PLUS, SAS, MS Excel, Jira, Sharepoint.

Confidential

Oracle Developer

Responsibilities:

• Post migration testing of database by comparing table data in the pre and post-migration environments.
• Performed data validation - used comparison tool Beyond Compare to check for consistency in table data before and after migration.
• Unit testing of the modules of the project.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Responsible for SQL tuning using explain plan, tkprof utility, optimizer hints to improve the performance.
• Involved in RDBMS design and developed ER-diagrams using Erwin.
• Good working knowledge on Oracle Pseudo columns like ROWID, ROWNUM etc.
• Tuning and optimization of the existing as well as new code as needed using Oracle hints
• Used nested table and Bulk collect for faster retrieval of data and improving performance.
• Interfaced with system analysts to analyze the schema using excel with macros and provided input for updating the entity relationship diagrams.
• Implemented various automated UNIX shell scripts to invoke pl/sql anonymous blocks, stored procedure, functions, packages using SQL Plus.
• Providing technical and functional support for E-Business Suite programs for databases supporting supply chain management, order management, warehouse management system, purchasing.
• Wrote technical design and functionality documents.
• Worked on Oracle E-Business Suite applications for accounts payable/accounts receivable AP/AR , general ledger GL , fixed assets FA , and cash management CM , supporting data extraction, filtering, and validation.
• Prepared unit test cases and executed the same.
• Creating and reporting Crystals Reports for higher management as business tool.
• Developing ETL process for the data-warehouse in Oracle 11g.
• Participating in requirement meetings and design walkthroughs.
• Worked on extracting data from the XML file sand loaded it into the database.
• Comfortable working with Composite Data Types.

Environment: Oracle 9i, 10g r2, 11g r1, Oracle e-Business Suite, Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, Beyond Compare, Microsoft C , Crystal Reports, XML packages, Solaris. Red Hat Enterprise Linux, JDA allocation.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Worked with system analysts to develop front ends using Oracle Discoverer .
• Worked on the program that is to update the resolution code and notes of Service Requests using the concept of Service Oriented Architecture SOA .If any Service Request does not get closed for whatever reason, the list of those SR 's that did not get closed should be emailed to the person who requested the batch update as well as displayed in a report/ concurrent request output.
• Assisted in implementing Oracle AP, AR, GL modules to meet Business requirements of the client.
• Worked on writing Test Plans which was a document describing the scope, approach, resources, and schedule of intended testing activities. It identifies test items, the features to be tested, the testing tasks and who will do each task.
• Effectively involved in understanding and creating data flow, technical flow diagrams using ErWin.
• Experience in creating the tables and sequences for the experimental data load capture using TOAD and SQL plus. Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Developed Oracle Forms and Oracle Reports depending on the functional requirement document.
• Assisted in creating and modifying sub-programs of packages for web-based applications that interacts directly with the pl/sql packages.
• Assisted in declaring global variables, record types, collections, cursor variables, bind variables, co-related queries and oracle joins materialized views extensively.
• Involved in performance tuning of stored procedures to reduce program execution time and optimize memory usage.
• Used nested table, Bulk collect and advanced PL/SQL techniques for faster performance.
• Created indexes and partitions on various tables in order to enhance performance
• Worked extensively on PRAGMA autonomous transactions and Golden Gate Replication with OLTP and DWH technologies to solve and fix mutating table errors
• Used ETL tool Informatica to convert code and load it into the Oracle database.
• Created database triggers to update the transactions on database objects .Managing on-site and off-shore teams during code review sessions and production work
• Participated in fetching the data using cursors, ref-cursors, and record types in the data mart.
• Worked on Crystal Reports for reporting data as specified by the management.
• Created packages extensively to update the status of service requests on the customers form
• Effectively involved in creating efficient technical documentation for non-technical users and providing guidance to better expalin the process plan
• Participated in writing SQL Loader scripts to load the data from flat file to preferred tables
• Worked on Crystal Reports for the higher management in the process of decision making.

Environment: Oracle 10g, MS SQL Server 2005 , Enterprise Manager Grid Controller, Oracle Applications 11i, PL/SQL, SQL Loader, SQL Plus, ERWin, UNIX Shell Script, Forms 6i, Reports 6i, Crystal Reports, TOAD, Workflow, Erwin, Oracle 9i/10g, Microsoft Visio, Windows XP, Oracle E-Business 11.5.7 AP, AR and GL , HP UNIX.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Participating in requirement meetings and design walkthroughs to understand the business requirements. Interact with the Systems Analyst / Business Analyst of the project for any clarifications required in the requirements.
• Providing estimation for the scope of the work.
• Coded and debugged the stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Conducting peer review for the scope items developed by team members.
• Conducting code and design walkthrough of modules developed with the client.
• Developing of PL/SQL packages, stored procedures and functions for the project as per the requirements for packages based EDI transactions.
• Extracting Non-relational data from web services, applications into Relational Database form.
• Performed import and export of schemas, objects using data pump utility in 10g.
• Involved in query and performance tuning
• Developing ETL process for the data-warehouse in Oracle 10g.
• Developing the Unix shell scripts for the batch jobs for the projects.
• Written shell scripts to load data into various subsystems using sql loader
• Worked on XML along with PL/SQL to develop and modify web forms.
• Unit testing of the modules of the project.
• Worked on Crystal Reports,
• Assisted in Golden Gate replication of OLTP transactions.
• Summarized/detailed report of data from the database.
• Providing implementation support to the project.
• Developed Reports to extract the monthly sales information.
• Wrote technical design and functionality documents.
• Customized and developed Oracle Forms and Reports using Oracle Forms6i and Reports6i.

Environment: Windows XP, Solaris, Oracle 11g, 10g, PL/SQL, AGILE methodology, Crystal Report, EDI, XML, JDA allocation, ASP.NET

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Created custom functions, stored procedures, database triggers and packages using Oracle ref cursors to retrieve, validate and process the data.
• Analysed past , current and predictive data for the data warehouse using OBIEE
• Utilized Oracle Tuning, Hints, cursors and cursor for loops to fetch the data faster and effectively from different tables extensively
• Expertized in ETL data flows, creating mappings/workflows to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
• Established data base connectivity using various tools of Delphi Borland Delphi
• Experienced in participating in walkthroughs, Iteration design, problem resolution and error handling
• Worked on Oracle E-Business Suite applications for accounts payable/accounts receivable AP/AR , general ledger, fixed assets, and cash management, supporting data extraction, filtering, and validation.
• Supported Oracle EBS units and resolved technical programming problems.
• Worked on allocation by establishing volume groups by class and product category. Conducted key item analysis and forecasting.
• Wrote technical design and functionality documents
• Created Bourne Shell scripts and Bash Shell Scripts for automating tasks as well as for creating extracts.
• Effectively involved in understanding and creating data flow, technical flow diagrams and data marts
• Worked on Crystal reports for weekly log data updates.
• Assited in migrating from DB2 to Oacle 10g using Oracle Migration Workbench OMWB .
• Participated in data modeling for production and testing databases using Erwin
• Wrote Unix Shell Scripts and SQL Loader Scripts to load flat data into the Oracle Tables
• Deployed customized reports in the applications, calling reports to be uploaded to the web from the back end by using Java applets.
• Extensively managed on-site and off-shore teams by providng the technical user training manuals/materials for OLTP, Discoverer, Oracle Portal and ETL tools
• Client interaction through meetings presentations.
• Involved in developing various Forms, Reports, Procedure, Functions and the PL/SQL Libraries to support the GUI application and EDI transactions.
• To develop Oracle Forms and Oracle Reports depending on the functional requirement document.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Understood data migration process from legacy system to higher versions.

Environment: Oracle Applications 11i AP, AOL , Oracle 9i/10g, SQL Server 2000, DB2, PL/SQL, C, C , ERWin, UNIX Shell Scripts, SSIS, SQL Plus, SQL Loader, Forms 6i, Reports 6i, XML Publisher, Java, Oracle BRMS, Telecom OSS/BSS, Informatica, TOAD, OMWB, EDI,Linux, XML, Microsoft Visio, Windows XP, Oracle Financials E-Business Suite 11i, Oracle Financials 10.4.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in planning, control and implementation of the DBMS using SDLC.
• Developed capacity plan for the database, estimated the table sizes.
• Worked with systems and business analysts to design requirement specifications.
• Implemented data integrity validation checks through constraints and triggers.
• Performance monitoring and tuning of SQL code.
• Responsible for creation of new user ids and setting up privileges and policies for protecting data.
• Wrote functions and stored procedures for order entry and other searching applications.
• Used Borland Delphi to establish connectivity among the various databases.
• Creation of database objects like tables, indexes and views.
• Developed packages for implementing business logic through procedures and functions.
• Developed UNIX shell scripts to automate routine tasks.
• Responsible for SQL tuning using explain plans and SQL trace facilities.

Environment: Oracle 10g, Oracle PL/SQL, SQL, UNIX, Korn Shell Scripting, TOAD, UML, ultra edit