PROFESSIONAL SUMMARY:

• 5 years of working experience using Oracle 8i,9i,10g,11g,12c in diverse sectors including Retail, Banking, Insurance and Health care.
• Extensive experience in Oracle RDBMS design and developing stored procedures, packages, triggers using SQL and PL/SQL.
• Strong knowledge in Oracle cursor management, collections and exceptional handling.
• Good hands on experience in creation of database objects like tables, views, materialized views, indexes, partitions and sequences.
• Expertise in query performance tuning by using Explain plan, SQL trace and TKPROF utilities and Hints provided by Oracle.
• Expert level knowledge in Oracle Architecture, Data dictionary and Normalization techniques.
• Extensive experience in Data migration techniques using External tables, import/export, SQL*loader, bulk and batch processing.
• Rich Experience in developing PL/SQL procedures, Functions, Packages and Triggers.
• Provided logical and physical data modeling using ERWIN.
• Experience in dimensional data modelling using star and snow flake schema and creating entity relationship diagrams using Toad and Visio.
• High level knowledge on UNIX and AIX operating systems.
• Experience developing Perl and UNIX shell scripting.
• Implemented DBA tasks such as creating users, granting and revoking privileges on database objects and taking backups.
• Worked on ETL process using PL/SQL to populate the tables using OLAP and OLTP data warehouse environment.
• Coordinated with DBA’s, QA’s, Release Management and external teams for technical needs and to ensure the timely release of project.
• Experience in creating Change tickets to move code to production using ServiceNow and do post validation.
• Migrated forms from version 6i to 10g and 10g to 11g, recompiled and restructured as per the business needs and latest functionality available.
• Experience in creating various complex forms using. PLLs, Program Units, Various Smart Triggers, Call functions and adding alerts.
• Created Complex Master Detail Reports, with calculations, format triggers, Programming Units and Report triggers.
• Wrote SQL statements in Pro*C and replaced them with appropriate calls to functions in the SQL runtime library.
• Generated XML datafiles using DBMS XML, and parsed them to other databases using external tools.
• Extensively monitored various jobs for data staging, processing and loading data.
• Hands on Experience in Oracle Discoverer, developing reports, working various components like Discoverer Administrator, Discoverer Desktop, Discoverer Plus and Discoverer Viewer.
• Experienced in UNIX Shell Scripts to automate load process, handle multiple files, call PLSQL procedures, encrypt and archive data files.
• Involved in analyzing and validating data migrations from the old system to highly relational database system.
• Provided support to resolve end user support problems, optimize performance, resolve system defects and analyzed proposed improvements or changes to the system.
• Extracted Transformed and Loaded(ETL) data source database to data warehouse system.
• Excellent communication and responsible team player.
• 24/7 Production Database Support & Maintenance
• Proficient in Error handling and debugging coding issues and troubleshoot production problems.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction
• Good ability to quickly grasp and master new concepts and technologies
• Self - motivated with the ability to effectively manage time and multiple projects.
• Excellent analytical and problem-solving skills and can work independently.

TECHNICAL SKILLS:

Operating Systems: Windows XP/NT/2000,98/95, DOS, UNIX, LINUX

Programming languages: PL/SQL programming, Unix scripting, Java, C, VB.Net

Web Technologies: HTML, DHTML, XML, JSP

Tools: TOAD, PLSQL Developer, SQL Navigator, SQL*Developer, SQL Tools, Erwin, Data Transformation Services

Database Utilities: SQL LOADER, UTL FILE, DBMS SQL, DBMS Packages

Database: Oracle 11g/10g/9i/8i, SQL Server 2003/2005

Version Control Systems: PVCS, Visual Source Safe, Rational Clear Case

Ticketing Systems: Service Center, Timoli, Rational Clear Quest, SysAID, Quality Center

Other Tools: Informaitica Power Center, Oracle Apex, OBIEE, Oracle Discoverer

WORK EXPERIENCE:

Confidential, Sunbury, PA

Oracle PL/SQL Developer / AIX Developer

Responsibilities:

• Developed the standards for documentation of batch scripts migration.
• Took active role in developing new functionality, design and implement Oracle PL/SQL solutions that satisfy business requirements.
• Prepared time estimates for phases of technical projects.
• Developed and maintained project tasks for large and medium projects.
• Documented all aspects of projects to assure other administrators can support the environment easily.
• Documented the old batch job processes to have good understanding on scripts needed to be migrated from old 9i database to oracle 11g database as well as moving batch scripts from AIX 5.1 to AIX 7.1 server.
• Worked on mapping data from old databases (Oracle 9i) to new database (Oracle 11g) and much reliable database custom built based on IBM SurePOS ACE.
• Wrote procedures and sql queries to recreate the logic in binary files created by the Pro*C/C execution.
• Used Sub-query ( WITH clause ) to make complex SQL statements simple and make them more efficient.
• Wrote Shell Scripts for batch jobs from the scratch to simplify the underlying logic where ever necessary like using IFS and modified the existing shell scripts where ever needed.
• Used DataStage as an ETL tool to extract data from sources systems and load the data into the ORACLE database.
• Created shell scripts to run DataStage jobs from UNIX and then schedule this script to run data stage jobs through scheduler.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, prepared test data for testing and error handling.
• Developed ETL procedures to ensure conformity, compliance with minimal redundancy, business requirements and functionality requirements into ETL procedures.
• Populated master tables from the extracts from the other databases.
• Created business views and materialized views as per the requirement for Sales Audit project which is developed to integrate the Store Point of Sales (POS) with the General Ledger, currently Infor Masterpiece .
• Created PL/SQL stored procedures, functions and packages for moving the data.
• Designed, modeled and implemented Data Warehouse and Data Mart: tables, procedures, packages, indexes and UNIX configuration
• Developed custom Forms and Reports as per requirements and making them web enabled using Oracle forms and reports 11g.
• Developed Master Detail, Detail Reports using Group above and tabular reports.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP.
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to data issues and other challenges while implementing the OLAP model.
• Worked on creating indexes for faster processing.
• Created test packages to validate the new and existing procedures and functions in Unit Testing Phase.
• Actively involved in SIT, QA, UAT and Production deployment.
• Created Shell scripts to automate the loading of files into database using Crontab .
• Developed UNIX scripts for transmitting files from the secure server to the vendor specified server, using FTP batch processes.
• Views and Materialized Views are developed for specific data retrieval for the reports.
• Worked on Control-M and Crontab schedulers.

Environment: Oracle Database 9i/11g/12c, AIX, SQL, PL/SQL, SQL*Plus, TOAD 9.0, Oracle Forms 11g, reports 11g, Oracle Developer Suite 10g, Windows 2007, UNIX Scripting, Control-M, CronTab, Datastage , Pro*C

Oracle PL/SQL Developer

Responsibilities:

• Assisted Business Analysts and Users in requirement analysis and authored various documents including BRDs, Technical Specifications, Migration Instructions and conversion mapping documents.
• Created Designs for various PL/SQL codes based upon the requirements, developed them, tested, migrated and provided pre and post production support.
• Created numerous database objects like Tables, Sequences, indexes, views, materialized views, synonyms, etc., as per the business requirement.
• Created database triggers based on requirement analysis and utilized pragma to avoid mutating state.
• Developed stand-alone stored functions, packages for building processes related to Data Extraction, Transformation, validation, Mapping and loading.
• Used the Datastage Designer to develop processes for extracting, transforming, integrating and loading data into staging tables .
• Monitoring the Datastage job on daily basis by running the UNIX shell scripts and made a force start whenever the job failed.
• Developed various reports from scratch utilizing Oracle Reports Builder for day to day validations.
• Created various adhoc reports as of when required for the production analysis and issue fixing.
• Constant interaction with Java Developers for tuning of SQL statements, embedding them in Java code using SQL and for unit testing and other test sequence comparisons.
• Supported Java Web Development Team in writing JavaScript and helping with CSS and XML.
• Extensively created complex forms for UI using Oracle Forms Builder 11g.
• Created master detail forms and utilized CALL FORM and OPEN FORM routines as per the business requirements.
• Migrated forms to middleware, compiled them and deployed them as per the client specific menu hierarchy.
• Worked on Performance tuning extensively. Created database partitions, global and local indexes, optimizer hints to improve overall performance.
• Developed Shell scripts to automate execution of SQL scripts to check incoming data with 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.
• Provided database support to testing team in writing complex SQL queries.
• Involved in support activities during the tenure of the project and extensively fixed various issues working on ticketing and change management tools.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used UTL FILE PACKAGES for writing output messages to file.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Involved in designing of required end user forms and reports using Oracle forms 10g & Reports 10g.
• Worked on SQL Tuning with Query optimization techniques for SQL statements.
• Extensively worked on Performance tuning by using Explain plans and various hints.
• Creating Materialized Views for replication of the actual data present over a DB Link.
• Prepared Test Plans for various functionalities developed and assisted the testers in creation of test scripts that are used in testing the Oracle stored procedures.
• Involved in Defect Prevention activities like identifying the root cause of major defects and raise change requests in HP Quality Center.
• Worked on requirement analysis for Change requests and fixed the defects raised by the user community and other stakeholders.
• Worked on creating users and roles as needed for the applications.
• Worked in review of ETL architecture, design, analysis and technical specification .
• Prepared analytical and status reports and updated the project plan as required
• Created test scripts documentation for procedure testing.

Environment: Oracle 11g, Windows, PL/SQL, SQL plus, oracle forms 6i/10g, oracle reports 9i/10g, TOAD 9.0, Oracle Developer Suite 10g

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with users to define and design needs, developed technical solutions ensuring software integrity.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Used SVN for version controlling and ALM (Application Lifecycle Management) for ticketing system.
• Developed web based front-end screens using Forms 6i.
• Created tables, indexes, constraints, triggers, synonyms, database links etc.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Used TOAD developer tools for faster application design and developments.
• Used Execute Immediate, UTIL FILE (file handler), DBMS SCHEDULER, DBMS ALERT and other utility BUILT-IN packages in PL/SQL.
• Developed master-detail, matrix, and nested summary detail reports, using Reports builder and Discoverer.
• Developed adhoc reports using Discoverer 4i
• Created Business Area according to user requirement using Discoverer 4i.
• Customized and developed Oracle Forms and Reports using Oracle Forms and Reports
• Developed Database Triggers to enforce security.
• Wrote UNIX shell scripts for automating batch jobs.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Developed Test Plans and tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
• Coordinated with clients, Requirements gathering and designing.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created Indexes and sequences for faster retrieval of the visitor information.
• Worked with Bulk Collect & Bulk Bind to improve the retrieval of multi row.
• Implemented Join conditions, group by functions, correlated subqueries, nested subqueries.
• Created procedures and functions for validation of transaction records into interface tables.
• Database security by authenticating users, using logon triggers.
• Created triggers for auditing purpose and created group, tabular, and form reports.
• Created materialized view on remote database and automated scheduler of refreshing of materialized view.
• Created indexes on tables and optimized procedure queries.
• Design few pages using HTML and XML to interact with database.
• Used several Oracle provided packages such as UTL FILE, DBMS JOB, and DBMS SCHEDULER
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Involved in writing technical documentation, and writing test plan.

Environment: UNIX, Solaris 5.9, Oracle 9i, TOAD 10.4, PL/SQL, SQL*Plus 9.2.0.1, SQL Developer 2.9, Oracle Enterprise Manager, FileZilla 0.9.40, UML 2.1, BugZilla 4.0.0, MS Project 2010 PL/SQL, SQL, Oracle 9i, TOAD, Forms 6i, Reports 6i, Discoverer 4i, Windows XP, UNIX, SQL * Loader