PROFESSIONAL SUMMARY:

• 8+ years of executive IT industry wif emphasis on Analysis, Design, Development, Implementation and Management of projects using Oracle (SQL, PL/SQL).
• Strong Knowledge on oracle architecture and database design.
• Excellent conceptual knowledge of Oracle 9i/10g/11g, PL/SQL.
• Partition of large Tables using range partition technique.
• Experience wif Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Extensive experience in writing Database Triggers, Stored Procedures, Functions, Cursors and Packages using PL/SQL.
• Experience in advanced PL/SQL concepts for Bulk Operations using Bulk collect, Bulk Exception, Collection and FORALL.
• Proficient in DBA responsibilities such as user management (synonyms/privileges, roles, table partitioning, index, sequence) space management (table spaces, rollback segment) monitoring (alert log).
• Good Knowledge of Multi organization Access control (MOAC) architecture and understanding of MOAC Impact on custom programs development like report, forms, and workflow PL/SQL packages.
• Extensively used Cursors, Ref Cursors, Exceptions and Anonymous blocks for generating reports.
• Strong in using tools such as PL/SQL developer, SQL Navigator, TOAD and SQL*Plus.
• Expertise in loading data from legacy systems using SQL*Loader.
• Strong knowledge on advanced PL/SQL concepts such as records, tables, types, Exception Handling, Dynamic SQL, PL/SQL Collections.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Extensive experience in defining and implementing Enterprise Metadata Architecture & Standards, guidelines and data/integration architectures for a large project, illustrating mastery of design patterns and best practices.
• Experience in writing Technical design documents and developing unit test documents.
• Created reports that has been defined by Business Objects and generated Crystal reports.
• Experience wif Oracle OEM/Grid Control and DBA Tools using SQL developer.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad - hoc reporting and coding utilizing SAS on UNIX, Windows.
• Built solutions for Data Cleansing/Data Scrubbing.
• Strong understanding of the Data model, Entity Relationship Diagrams and RDBMS concepts.
• Strong ability to share knowledge wif others and collaborate as part of a team to achieve positive outcomes wif good communication skills.
• Hands-on experience wif Oracle APEX 5.0.3 (Oracle Application Express).
• Greater flexibility wif work hours and/or extended hours on occasions to meet client.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, APEX Shell Scripting, Java, JavaScript, XML, HTML.

Database: Oracle 9i/10g/11g/12c, SQL Server 2000/2005/2012, MySQL 5.0/4.1, MS Access, DB2.

Operating Systems: Windows, Unix, Linux.

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

PROFESSIONAL EXPERIENCE

Confidential Corp, NY

Oracle PL/SQL developer.

Responsibilities:

• Developed severalPackages, Procedures, Functions and Triggers to use in multiple series of other backend programs using PL/SQL.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables for small Business and Consumer Markets (SBCM) customers.
• Written SQL scripts to create database objects like tables, views and sequences.
• Constant monitoring and performance tuning of Oracle12c database, checking the most queries.
• Coded PL/SQL sub-programs and modified the existing PL/SQL program units for customerContact Employees (CCE’s) relationships.
• Customer Data Load from flat files into Oracle tables using PL/SQL procedures.
• Created ETL design specifications.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and implementation was used as well as ETL methodology.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files (Fixed Width and Delimited) to staging database and from staging to the target Warehouse database.
• Solid understanding of both the business and the technical aspects of BI Solutions.
• Created table partitioning based on the systems and date range.
• Implemented the snapshot process for moving the data into the warehouse.
• Assigning the Email notification when the data loading and validation done.
• Performed review and analysis of deadlocks and database performance tuning.
• Imported test cases into TFS environment (using Microsoft Visual Studio and Microsoft Test Manager), including adding and updating parameters and detailed steps throughout testing cycles.
• Conducted code walkthrough & internal/peer reviews on application code and other deliverables.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions.
• Worked onXMLalong wif PL/SQL to develop and modify web forms.
• Implementing the jobs using Apex wif the job monitoring tool.
• Involved in the continuous enhancements and fixing of production problems.
• Worked closely wif the Application Development teams to identify and implement continuous improvements and TEMPeffective problem resolution strategies.

Environment: Oracle 11g/12c, HTML,SQL Developer,Apex 5.0.3,Actian Vector, UNIX Scripting, WinSCP, Putty, Windows 2007/10.

Confidential, Milpitas, CA

Oracle PL/SQL developer.

Responsibilities:

• Created SQL*plus reports as per client's various needs, and developed business objects.
• Developed various PL/SQL stored procedures and functions.
• Developed PL/SQL triggers on master tables for automatic creation of primary keys and foreign keys.
• Developed back end interfaces using PL/SQL Stored packages, Procedures, Functions, Collections, Object, Types, Triggers.
• Modified several SQL*Loader scripts to handle new feeds from different sources and load data into the database from several sources.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Experience wif industry standard methodologies such asAgilein various software development project.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data wif 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.
• Created and Executed Manual test cases through Microsoft Visual Studio Team Services.
• Creating and enhancing daily, monthly, yearly jobs using Perl and UNIX shell Scripting.
• Used PL/SQL programming to develop Stored Procedures, Functions and Database Triggers including standard packages like DBMS SQL, DBMS XPLAN, DBMS JOB, and UTL FILE.
• Used OracleJDeveloperto support JAVA, JSP and HTML codes used in modules.
• UsedSQL Server SSIS toolto build high performance data integration solutions includingextraction, transformationandload packagesfordata warehousing. Extracted data from theXMLfile and loaded it into thedatabase.
• Formulated SQL queries, functions and processes as per customization requirement for APEX.
• Supported APEX applications and conducted performance tuning for PLSQL.
• Contributed wif database designs and assisted in increasing response time for APEX reports.
• Designed application framework and developed Oracle APEX Application.
• Provided APEX guidance and support to technical staff on application maintenance and SDLC process.
• Extensively used Cursors, Ref Cursors, Exceptions and Anonymous blocks for generating reports.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.
• Design, Install, configure, and monitor Golden Gate Replication 12c.
• Defining Keys, Attributes and Entities for Data Warehouse.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Experience wif merging data files coming from different geographical customer into the existing data warehouse.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.

Environment: Oracle Database 10g/11g SQL Developer, XML, SQL, PLSQL, UNIX Scripting, WinSCP, Putty, Citrix, Windows 7, UNIX.

Confidential - Collegeville, PA

Oracle PL/SQL developer.

Responsibilities:

• Developed PL/SQL stored procedures, packages, and triggers for data load and transformation, and data extraction.
• Proficient working experience in Oracle utilities such as Export / Import.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus and Toad.
• Designed OLAP cubes wif star schema and multiple partitions using SSAS.
• Performed exception handling for data that did not conform to the required format.
• Developed Shell scripts and SQL control files to load data through SQL Loader.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Submitted quarterly business efficiency reports to management and made recommendations for moving forward.
• Involved in Logical & Physical Database Layout Design. Applied principals of Normalization to improve performance.
• Responsible for database maintenance and management and submitting troubleshooting reports weekly to management.
• Worked regularly wif departmental managers to create useful and comprehensive reports as an Oracle HRMS Consultant.
• Assisted in the research and process phases of all business planning projects.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Staging.
• Resolved tickets that are assigned in JIRA for severity 1 issues. Extracted data from different sources like flat files and loaded into Oracle data warehouse according to the specifications.
• Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Closely worked wif DBA teams in the maintaining the databases and trouble shoots experiencing from the Users.
• Worked on Data migration project by validating three source data row by row and field by filed.
• Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.
• Good understanding in creating data marts for the business requirements.
• Responsible for creation of new users and setting up privileges and policies for protection of data.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Defragmentation of tables, partitioning, indexes for improved performance and efficiency.

Environment: Windows, Oracle SQL Developer, PL/SQL, Oracle 10g.

Confidential - Jersey City, NJ

Oracle PL/SQL developer.

Responsibilities:

• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Remarkable Oracle HR and Payroll implementation experience.
• Huge knowledge of Oracle Human Resource System and detailed functionality.
• Created standard HR and Payroll business processes
• Managed competing priorities and devise creative business solutions as an Oracle HRMS Consultant.
• Analyzed and configured the HR and Payroll components in Oracle.
• Built solutions for Data Cleansing/Data Scrubbing.
• Handled end to end project lifecycle.
• Headed teams in delivery of Oracle HRMS solutions.
• Worked in development, testing and production environment using SQL, PL/SQL procedure, shell script.
• A year of experience Maintained TEMPeffective internal controls over financial reporting to ensure compliance wif Sarbanes-Oxley and accurate reporting of financial position.
• Two years of experience in financial reporting.
• Developed and Published Daily and weekly reports using Financial Reporting studio to the Senior IT Managers.
• Experience wif continuous integration and DevOps methodologies, best practices and tools such as Git, Jenkins, Nexus, Rally, Jira, etc.
• Created numerous Management Report & Books for the Client's Payment History application using Financial Reporting Studio.
• Developing Custom Oracle Forms for Oracle Applications 10g using Oracle Forms 10g.
• Did oracle data loading into oracle database from flat files using Kron shell scripts.
• Developed user documentation for all the application modules.
• Analyzed, designed, developed Forms and reports and procedure and functions for billing modules to bill the Pay per click customers.
• Working wif cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.
• Extensive experience in requirement gathering, design, development, testing and implementation of enterprise data warehouse (EDW) implementations and enhancements in Waterfall/Agile software development environments.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), Table Partitioning and Error Handling.
• Involved in Performance Tuning, optimizing database issues.
• Creation of Stored Procedures for Batch Processing.
• Experience in Designing and developing complex mappings using various Transformations like Source Qualifier, Joiner, Aggregator, Router, Filter, Expression, Lookup, Sequence Generator, Update Strategy etc.
• Developed UNIX Shell Scripts to execute procedures and run the SQL scripts through autosys jobs.
• Developed reports using Oracle report Developer.
• Wrote Packages containing several Procedures and Functions in PL/SQL to validate before loading into Application database.
• Involved in Creation of tables, Partitioning tables, Join conditions, correlated sub queries, and nested queries, views for the business application development.
• Proven ability and ability to work collaboratively wif business analysts, testers, developers and other team members in the overall enhancement of software product quality.

Environment: Windows XP/7, Windows 2003, 2008 R2, UNIX, SQL, PL-SQL,Oracle Database 11g/10g, SQL Developer, XML, SQL, PLSQL, Citrix, FTP, SQL Loader,Windows 7, UNIX.

Confidential

Oracle PL/SQL developer.

Responsibilities:

• Worked on Data Extract Process which is done on demand as per the user requirements. Upon their specific request, data is retrieved from various systems using SQL/PLSQL coding and delivered in their requested format.
• Actively involved in optimization and tuning of SQL queries through utilizing the explain plan to find out the problem area of the query.
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Provided alternative approaches when faced wif performance bottlenecks. Approaches like range partitioning, global temporary tables.
• Created Indexes on tables for new database to faster retrieval of data for the Reports.
• Loading the data from UNIX server to external tables and managing the data as per the customer requirements.
• Created the database objects like tables, views, procedures, packages, triggers, materialized views using Oracle tools like SQL* Plus, Toad, Oracle SQL Developer.
• Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on UNIX, Windows.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Performed SQL tuning on complex queries using tools such as Explain Plan, TKProf and DBMS Profiler.
• Loading and maintaining daily, weekly and monthly data in the tables as per the retention policies.
• Design and develop framework to migrate multiple large financial databases from Sybase to Oracle 11g/12c.
• Involved in writing Bulk Collects, Cursors, Ref Cursors, and Exceptions wifin the various procedures.
• Support and modify existing code.
• Involved in migration of data from legacy application to Project View.
• Involved in creation of ReportingDB from the TransactionDB.
• Involved in creating UNIX shell Scripting.

Environment: Oracle 11g, SQL Developer, PL/SQL, TOAD, Windows 7, UNIX.

Confidential

Oracle PL/SQL developer.

Responsibilities:

• Worked in development, testing and production environment using packages, stored procedures, functions, triggers.
• Built and modified PL/SQL Stored Procedures, Functions, Packages and Triggers to implement business rules into the application.
• Created database objects like tables, views, procedures, packages using Oracle tools like Toad.
• Extensively used error and exception handling techniques.
• Worked on daily sales load job for upstream and downstream data flow.
• Performed Data Conversions and Data Cleansing.
• Worked on SQL*Loader to Extract, Load and Transform data from varied data sources like Flat files and Oracle.
• Has worked on testing the database after the patch (Gathering table stats, refresh table stats, recreating the indexes, etc.).
• Generated PL/SQL scripts to create and drop several database objects including tables, primary keys, Views, Indexes, constraints, packages, sequences, synonyms and grants.
• Involved in the full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• Developed test plan documents for all backend database modules.
• Development, Unit test, user test and QA, and Deployment of Applications/PL/SQL Code and BI reports.
• Involved in creating UNIX Shell Scripting.
• Used the FTP commands efficiently to migrate various files and logs has been created successfully in proper directories on completion of the transfer process.
• Worked on Database Links to import/export data among various databases.

Environment: Oracle Database 11g/12c, SQL Developer, XML, SQL, PLSQL, UNIX Scripting, Putty, Citrix, FTP, SQL Loader, Windows and UNIX.