SUMMARY

• 7+ 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 OracleSQL, 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.
• Expertise in Unit Testing and Integration Testing Of the Application.
• Expertise in Master Data Management - Through Database and through Informatica Repository Manager.
• Experience in debugging and performance tuning of sources, targets, mappings and sessions.
• 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 applicationsutilizing 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.
• Experience in high-end programming using SQL, PL/SQL, SQL * Loader, Java, C, C++..
• Excellent Communication Skills and a recognized Team Player with strong project Leadership and Time management capabilities.
• Excellent work ethics, fast & enthusiastic learner and a good team player. Strong management, administrative and leadership skills to work in team.

TECHNICAL SKILLS

Operating Systems: Windows XP/NT/2000, 98/95/Vista, DOS, Solaris 10, Unix, Linux.

Database: Oracle 12c,11g,10g, 9i, 8i, 7.x, MS Access and SQL Server 2000,2005.

Programming languages: ANSI C, C++, SQL, PL/SQL programming.

Database Tools: Toad, PLSQL Developer, SQL Navigator, SQL Tools, Erwin.

Utilities: UTL FILE, DBMS PIPE, Exp, Imp and Data pump.

Web Technologies: HTML, XML.

Script Languages: Shell, Perl scripting.

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts, and ETL.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr. Oracle - PL/SQL Developer

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 InformaticaPowerCenter 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 12c,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, Jacksonville, FL

Sr. Database Developer

Responsibilities:

• Involved in Requirement gathering and writing Functional and Technical documents.
• Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements.
• Created materialized views, Inline Views & normal views where business requirements needed.
• Tune the SQL queries and complex procedures to improve performance.
• Created database triggers for data security & Consistency.
• Developed procedures, functions and packages for new requirements.
• Developed SQL*loader scripts to load data from various forms of flat files into staging tables in Oracle database using shell scripts.
• Developed packages for processing data in the staging tables according to the Clients requirements.
• Implemented Advanced PLSQL Concepts for better performance of PLSQL Applications.
• Extracted Transformed and Loaded (ETL) data source database to data warehouse system.
• Developed and created various scenarios for testing the code.
• Debugged existing code for business logic issues.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.

Environment: Oracle11g,Oracle 12c, SQL, PL/SQL, SQL*Plus, SQL*Loader, Java, SQL Navigator, Sub Version, Mercury Quality Control, UNIX, JIRA

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 fromOracle, 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 Consultant

Responsibilities:

• Worked on low-level system design Use Case diagrams, Sequence Diagrams using Rational Rose.
• Responsible for developing application logic using Java/J2EE technologies like Java, HTML, CSS, JSP, Servlets,
• Responsible for developing stored procedures on back end using Oracle PL/SQL and used JDBC APIs to call these procedures.
• Responsible for manual testing and white box testing of the application.
• Involved in production bug fixes and maintenances using clarify tool.
• Responsible for production support and maintenance (24/7).
• Responsible for onsite (Cisco Systems - North Carolina) co-ordination with India team based in Pune.
• Responsible for peer-review, analysis and documentation.
• Responsible for assigning tasks to offshore team and coordinating with the project managers.

Environment: Oracle SQL, PL/SQL, Java jdk1.1/1.2, J2EE, JSP, Servlets, Sun Solaris, Tomcat 3.2, Log4j, ILOG, Netscape Enterprise Server 3.6.3, CVS.