SUMMARY

• About 7+ years of experience in analysis, design, development, testing and implementation of application software as Oracle PL/SQL developer.
• Expertise in SQL and PL/SQL programming and strong Knowledge on oracle architecture and database design.
• Solid experience in vertical segment Automotive, Banking, Retail management system and financial management system.
• 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.
• Extensively worked wif various SQL scripts for relational databases.
• Knowledge of working wif teh Oracle Application server for teh Forms and 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.
• Experience wif 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 teh 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.
• Experience in Database modeling and database object definitions using tools like Oracle Designer.
• Experienced in Unit testing and Integration Testing wif 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 dat schedule, validate flat file data, execute SQL, archive files or FTP files.
• Great Team player wif Strong interpersonal skills, communication skills and documentation skills

TECHNICAL SKILLS

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

Database tools: PL/SQL Developer, Forms10g/9i/6i, TOAD, Oracle Enterprise Manager, DataStage, Informatica

Operating systems: UNIX, Windows NT/2000/2003/XP/7

Languages: C, C++, JAVA, SQL, PL/SQL, UNIX Shell Scripting

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 teh data.
• Responsible for problem identification and resolution of failed processes or jobs and assisted in troubleshooting issues wif 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.
• Designed Batch Processing system for applications using AutoSys. Developed standardized scripts for job implementation.
• Tuning of teh SQL queries, which takes long time to process teh request using Explain Plans to reduce teh response time.
• Used AutoSys job scheduler for automating teh daily regular run of DW cycle in UAT environments
• Involved in Database Designing and Creation.
• Used PL/SQL and SQL Loader to create ETL packages for flat file loading and error capturing into log tables.
• SQL tuning using SQL Trace and TKPROF, Explain Plan for performance issues resolution.
• Constantly monitor teh performance of teh Databases and viewing Alert log files & Trace files.
• 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 teh 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 teh test results.
• Loading data from flat files into Oracle 10g database using SQL*loader and UNIX script.
• Create User Schemas, TABLES, INDEXES, SEQUENCES, and VIEWS.
• Used Scrambled and Unscrambled functions to Encrypt and Decrypt teh sensitive data.
• Worked wif DBA to create teh physical model and tables.
• Built and maintained SQL Scripts, Indexes, reports and queries for data analysis and extraction.
• Experience in all phases of Data warehouse development from requirements gathering for teh data warehouse to develop teh code, Unit Testing and Documenting.
• Developed reconciliation scripts to validate teh data loaded in teh tables as a part of unit testing.
• Developed job sequencer wif proper job dependencies, job control stages, triggers.
• Verify, validate data using SQL queries.
• Interacted wif teh business users to better understand teh requirements and document their expectations, handling teh current process, modifying and created teh jobs to teh updated requirements, handle teh load process to data mart and eventually data warehouse.
• Analyzing teh code written by different developers to understand teh transformation applied on columns to document them.
• Created Unit Testing Document wif all possible Test cases/Scripts.
• Involved inUnit testing, System testingto check whether teh data loads into target are accurate.
• Data Modeler wif strong Conceptual and Logical Data Modeling skills has experience wif 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.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon teh requirement, published Data model in model mart, created naming convention files, co-coordinated wif DBAs to apply teh data model changes.
• Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
• Documented teh Excel formulas and pivot tables used for data cleansing.
• Gathering requirements for summary data sets for each stakeholder group. Includes elements, configurability logic for trending reports, history tracking and other aggregations.
• Created/maintained/modified data base design document wif detailed description of logical entities and physical tables.
• Sorting logical data grouping for originations source data dat to be loaded into analytics.
• Experience in complete life cycle of Design, Development, Maintenance and Documentation of Conversion Process.
• Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.
• Acquired basic Knowledge for using Informatica 8.6 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata.
• Knowledge in Informatica Power Center 8.6 for extraction, transformation and load i.e. ETL of data in teh data warehouse.
• Extensively used Microsoft Visio for documentation.
• Strong understanding of teh 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, SQL, PLSQL, UNIX, AUTOSYS, SQL LOADER, MICROSOFT VISIO, FLAT Files, ERWIN 3.5, Informatica 8.6

Confidential, Plymouth, Michigan

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 teh data from teh 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 teh new business measures.
• Worked on PL/SQL tool TOAD to run SQL queries to validate teh data.
• Modifying existing web application GUI as per teh need from teh 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 stored packages wif Oracle's Web Toolkit.
• Worked wif front end application developers wif their queries/stored procedures while building User-Interface for teh 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 wif offshore team.
• Worked closely wif end-users and team members to understand business requirements dat drive teh analysis.
• Extensively worked wif Data Stage Job Sequences to Control and Execute Data Stage Jobs and JobSequences using various Activities.
• Used server jobs to Extraction, Transformation and Load.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• 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 teh runtime engine to schedule running teh 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 wif 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 teh Dynamic Pricing Portal team, to support teh business team.
• Developed both inbound and outbound interfaces using PL/SQL to load data into targeted database and extract teh data from teh database to flat files.
• Developed stored procedures and triggers to facilitate consistent data entry into database.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Utilized SQL Loader to load flat files database tables.
• Initialized utilization of Data Warehouse ETL software during conversion of data to Oracle DB.
• Used UNIX Shell Scripts to automate backend jobs.
• Executing and maintaining teh data warehouse extract transform load (ETL) process.
• Gathered statistics and analyzed tables and Indexes for performance tuning.
• Used performance tuning utilities like EXPLAIN PLAN, SQL Trace and DBMS PROFILER to improve teh performance by reducing teh run time of queries on teh database.
• Based on teh data loaded in teh target database (oracle) various business reports are developed.
• For teh reporting purpose extensively used SQL Scripts.
• Wrote complex SQL queries using Joins, Sub queries and Group functions.
• Involved in modifying various existing packages, procedures, functions and triggers according to teh new business measures.
• 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.
• Used Cursors, Native Dynamic SQL and Bulk Collections to implement teh Bulk Load.
• Used Materialized views in order to improve teh performance.
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into teh database.
• Trouble shooting performance issues wifin packages using DBMS OUTPUT
• Coordinating wif teh business users for System Test and User Acceptance Test.
• Developed scripts for validating teh UAT deployment for teh schema objects.
• Responsible for Documentation of all teh project developments and methodologies followed for teh defect-fix, as per teh standards defined and teh 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, UNIX (Sun Solaris).

Confidential, AR

Web Developer

Responsibilities:

• Created Mobile website for teh library http://ualr.edu/library/mobile.Teh mobile website helps students to
• 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 teh user interface in searching, finding teh library material content using Ajax, JQuery and JavaScript, CSS.
• Played a major role in migrating teh 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.
• Worked closely wif designer and converted Photoshop images into web pages consistent wif Organization Standards.

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

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

Confidential

PL/SQL Developer

Responsibilities:

• Analyzed requirements, designed, developed, deployed and documented software components.
• Designed ER diagram using Erwin, to set teh logical and physical relationships of database.
• Developed teh SQL Loader script, and most of PL/SQL stored procedures, Triggers, and views to handle teh Online and Batch processes.
• Created database Triggers for teh security purposes.
• Used Oracle snapshots for replication between various sub branches.
• Loaded teh data into database using teh SQL*Loader from various sources.
• Creating SQL, Object Views, and PL/SQL database objects. Developed teh stored procedures for data transformation purposes.
• Tuned teh SQL Queries wif teh output of Oracle Tools like Explain Plan, TKPROF.
• Fixing bugs according to teh 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 teh interfaces.

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