PROFESSIONAL SUMMARY

• About 7+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer. Solid experience in vertical segment Automotive, Banking, Retail management system and financial management system.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
• Good Knowledge in Relational Data Modeling.
• Expertise in using tools such as TOAD, SQL developer, PL/SQL developer.
• Strong knowledge of Oracle 9i/10g/11g, PL/SQL.
• Excellent Analytical, conceptual and root cause analysis and problem solving skills.
• Strong Experience in designing and developing oracle objects Tables, Views, Indexes PL/SQL Packages, Functions, Stored Procedures, and Triggers.
• Strong knowledge in Oracle Cursor management, Exception Handling, REF Cursors
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Collections, Nested Tables, VARRAYS, Records, Types, and Dynamic SQL and Analytical functions.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
• Experience in PL/SQL collections, Bulk collections and Exception handling.
• Developed normalized Logical and Physical database models to design OLTP system.
• Extensively worked with various SQL scripts for relational databases.
• Knowledge of working with the Oracle Application server for the Forms and Crystal Reports application in various projects.
• Extensively worked on PL/SQL features like Forms, Triggers, Data blocks, Report Layout, Parameter forms, Report Triggers.
• Experience in designing and developing various reports using Oracle Reports
• Good understanding of Oracle Data Dictionary, RDBMS and Normalization techniques.
• Designed numerous Oracle Forms and Reports by interacting directly with End Users and Business Analyst.
• Experience with database query optimization and performance tuning using Explain Plan, SQL - Trace, TK-Prof oracle utilities and creating relevant system and users documentation
• Strong working experience in use of SDLC methodologies, standards and Gathering the Requirements, Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading (ETL)
• Expertise in understanding Slowly Changing Dimensions Type1, Type2 and Type3.
• Providing assistance in logical/physical data modeling using ERWIN.
• Extensively worked on Triggers for implementing complex data integrity checks and for auditing tables. Worked on Erwin and ER Studio in different projects in both OLAP and OLTP applications
• Experience in database modeling and database object definitions using tools like Oracle Designer.
• Experienced in Unit testing and Integration Testing with excellent debugging skills.
• Developed and Modified PL/SQL packages, functions, Procedures as per customer requirement to make new enhancements or to resolve problems.
• Ability to program UNIX shell scripts in applications that schedule, validate flat file data, execute SQL, archive files or FTP files.
• Great Team player with Strong interpersonal skills, communication skills and documentation skills.

TECHNICAL SKILLS

Languages: : C, PL/SQL, JavaScript, HTML,XML, SQL,UNIX, TOAD

RDBMS: : Oracle 11g/10g/9i, TOAD, SQL Developer, SQL * Plus, SQL Navigator

Version Controlling Tools: : Clear Case.

Database Tools: : PL/SQL Developer, Reports/Forms11g/10g/9i/6i, TOAD, Oracle Enterprise Manager, DataStage.

Data Modeling Tools: : Erwin 7.3/7x/4.0, MS Office Visio 2003/2007

Operating Systems: : Windows 95/98/2000 XP/Vista/7, Solaris.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle PL SQL Developer

Responsibilities:

• Participated in complete process of functionality testing of all AutoSys applications.
• Used different transformations such as Merge, Join, Filter, Lookup, and Aggregator to transform the data.
• Responsible for problem identification and resolution of failed processes or jobs and assisted in troubleshooting issues with applications in AutoSys.
• Proactive in finding issues and seeking and implementing solutions.
• Used PL/SQL to create PACKAGES, FUNCTIONS, and PROCEDURES.
• Executed PL/SQL blocks using cursors, REFCURSORS, exception handling, Collections, Index of Table and Dynamic SQL.
• Tuning of the SQL queries, which takes long time to process the request using Explain Plans to reduce the response time.
• Used AutoSys job scheduler for automating the daily regular run of DW cycle in UAT environments.
• Worked on Developing Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
• Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing into log tables.
• Created referential integrity in the OLTP data model for consistent relationship between tables and efficient database design.
• SQL tuning using SQL Trace and TKPROF, Explain Plan for performance issues resolution.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Created ETL Procedures for more than 600+ tables and views on top of these tables.
• Tested and corrected errors and refined changes to database. Tuned performance by exploiting the Oracle’s new built-in functions and rewriting SQL statements.
• Used Bulk Collect feature for improve performances to handle large amount of table data.
• Wrote Test case/ data preparation, execution including verification of the test results.
• Loading data from flat files into Oracle 10g database using SQL*loader and UNIX script.
• Used Scrambled and Unscrambled functions to Encrypt and Decrypt the sensitive data.
• Worked with DBA to create the physical model and tables.
• Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
• Interacted with the business users to better understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements, handle the load process to data mart.
• Analyzing the pl/sql code written by different developers to understand the transformation applied on columns to document them.
• Experience in testing the Forms, debugging and fixing the Forms after being tested.
• Involved inUnit testing, System testingto check whether the data loads into target are accurate.
• Data Modeler with strong Conceptual and Logical Data Modeling skills has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Worked extensively on forward and reverse engineering processes.
• Documented the Excel formulas and pivot tables used for data cleansing.
• Extensively used Microsoft Visio for documentation.
• Strong understanding of the principles of Data warehousing, Fact Tables, Dimension Tables.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Participated in weekly status meetings.

Environment: Oracle 11g/10g, Oracle Forms 11g/10g, SQL, PLSQL, UNIX, AUTOSYS, SQL*LOADER, MICROSOFT VISIO, FLAT Files, ERWIN 3.5.

Confidential

Oracle PL SQL Developer

Responsibilities:

• Excess Equipment is a Web Application for all plants to Request Equipment’s.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Participated in system analysis and data modeling, which included creating tables, views, indexes synonyms, triggers, functions, procedures, cursors, and packages according to the new business measures.
• Worked on PL/SQL tool TOAD to run SQL queries to validate the data.
• Modifying existing web application GUI as per the need from the look and feel point of view using HTML, Java script.
• Extensively used HTP and HTF package used to dynamically build webpage from PL/SQL.
• Developed, Designed and customized forms by using Oracle Forms 10g and Reports 10g
• Developed stored packages with Oracle's Web Toolkit.
• Worked with front end application developers with their queries/stored procedures while building User-Interface for the project.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Good experience in communicating with offshore team.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.
• Extensively worked with Data Stage Job Sequences to Control and Execute Data Stage Jobs and Job Sequences using various Activities.
• Used server jobs to Extraction, Transformation and Load.
• Worked on package more than 15000 lines.
• Extensively used Parallel Stages like Join, Merge, Lookup, Filter, Remove Duplicates, Row Generator, Modify etc. for development and debugging purposes.
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring scheduling and validating its components.
• Used DataStage Manager for managing DataStage repository (view and edit), define custom routines & transforms, Import and export items between different DataStage systems or exchange metadata with other data warehousing tools.

Environment: Oracle 11g/10g, SQL, PLSQL, UNIX, TOAD, DATA STAGE 8.5x, 9.1x

Confidential, Minneapolis, Minnesota

Oracle PL SQL Developer

Responsibilities:

• Worked in the Dynamic Pricing Portal team, to support the business team.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract the data from the database to flat files.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Initialized utilization of Data Warehouse ETL software during conversion of data to Oracle DB.
• Worked on Developing Forms Screens used by Oracle Developer Suite for forms procedures, functions and packages generate to end product of forms.
• Used UNIX Shell Scripts to automate backend jobs.
• Executing and maintaining the data warehouse extract transform load (ETL) process.
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Based on the data loaded in the target database (oracle) various business reports are developed.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business measures.
• Created Simple Crystal Reports Ad Hoc Reports, Frequency Reports, Summary Reports, Dynamic grouping, graphical reports.
• Worked as an application DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database.
• Executed PL/SQL blocks using cursors, REF cursors, exception handling, Collections -Nested tables and Index of Table and Dynamic SQL.
• Getting requirements from the user, developing Simple Crystal Reports & maintaining proper documentation of the reports for future reference.
• Used Cursors, Native Dynamic SQL and Bulk Collections to implement the Bulk Load.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Good knowledge in front end development using oracle forms/reports9i/10g for creating master detail forms and adding alerts.
• Experience in deploying forms and reports on the web.
• Trouble shooting performance issues within packages using DBMS OUTPUT
• Coordinating with the business users for System Test and User Acceptance Test.
• Responsible for Documentation of all the project developments and methodologies followed for the defect-fix, as per the standards defined and the system requirements.
• Resolving problems by reviewing and analyzing software documentation and production outputs to identify causes - troubleshooting
• Handling every week’s production deployment.

Environment: Oracle 11g, SQL, PLSQL, Crystal Reports 8.5, UNIX (Sun Solaris), Oracle Forms 9i/10g, SQL * LOADER

Confidential, AR

Web Developer

Responsibilities:

• Access library catalog, electronic databases and library information through smart phone devices.
• Responsible for Monitoring and Managing site development and regular web site maintenance.
• Redesigned and improvised the user interface in searching, finding the library material content using Ajax, JQuery and JavaScript, CSS.
• Played a major role in migrating the library website to Word Press.
• Designed and developed a web application for managing and tracking IT resources.
• Extensively worked on Java, JSP, JSTL, PHP, SQL, HTML, and CSS.
• Used HTML, CSS for designing web pages for UALR library.
• Worked closely with designer and converted Photoshop images into web pages consistent with Organization Standards.
• Actively Participated in all meeting for improving, reviewing and testing the changes made.
• Created Surveys to get the feedback from students and Professors of all courses.

Environment: Java, JSP, JSTL, PHP, SQL, HTML, JavaScript, Ajax, JQuery, CSS, Word Press, Apache Tomcat, MySql.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed various PL/SQL stored procedures, functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Used PL/SQL to develop stored procedures, Functions, triggers including standard packages and used DBMS SQL, DBMS XPLAN, DBMS PROFILER, DBMS JOB, DBMS MVIEW and UTL FILE.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Utilized SQL*Loader to load flat files database tables.
• Involved in data model reviews with internal data architect, business analysts, and business users with explanation of the data model to make sure it is in-line with business requirements.
• Developed PL/SQL blocks using Collections like Nested Tables and VARRAYS, Bulk collections and Exception handling.
• Created rationalized domains to bring consistency in the tables.
• Involved in Writing, debugging and optimizing PL/SQL code using optimizer hints.
• Experience as an Applications DBA including creating and managing schemas, tables, constraints, indexes, and materialized views and managing database
• Involved in the ETL process of developing new tables from the existing views and materialized views.
• Worked in SQL, PL/SQL development and database support as well as maintenance.
• Developed and implemented various migration scripts for various schema objects migration.
• Performing Unit, Integration and System testing, and setting up UAT for the project modules.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Worked closely with end-users and team members to understand business requirements that drive the analysis.
• Participated in Peercode reviews and verifying coding standards.
• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.

Environment: Oracle 9i, 10g, SQL, PLSQL, SQL*Loader, UNIX, TOAD

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using Erwin, to set the logical and physical relationships of database.
• Developed the SQL*Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle the Online and Batch processes.
• Learned to develop the custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 9i and Oracle Forms builder 9i respectively.
• Developed Master Detail, Detail reports using tabular and Group above reports.
• Developed Reports to extract the monthly information.
• Created database Triggers for the security purposes.
• Used Oracle snapshots for replication between various sub branches.
• Loaded the data into database using the SQL*Loader from various sources.
• Creating SQL, Object Views, and PL/SQL database objects. Developed the stored procedures for data transformation purposes.
• Developing paper lay out reports in various styles based on the user requirements.
• Tuned the SQL Queries with the output of Oracle Tools like Explain Plan, TKPROF.
• Fixing bugs according to the software change requirement.
• Used TOAD, PL/SQL developer tools for faster application design and developments Performance tuning, SQL tuning.
• Developed complex procedures to handle errors and exceptions at database level using PL/SQL.
• Developed test plan documents for all back end database modules.
• Responsible for unit testing, and documentation of the interfaces.

Environment: Oracle database 8i/9i, Java, Servlets, PL/SQL, SQL Plus, SQL*LOADER, Windows 2000 Professional, and UNIX, Erwin 3.x