SUMMARY

• Over 6 years of experience in Software system analysis, design and application development using SQL, PL/SQL stored procedures, functions, packages and triggers.
• Exposure & knowledge of designing logical & physical Data Model in Relational Database Management System (RDBMS).
• Experience in working high - transacted OLTP systems.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Very strong in SQL Query Tuning, Database Triggers, Stored Procedures, reducing time for night batch jobs by reviewing PL/SQL code, modifying database parameters.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Loading of data from external systems using SQL*LOADER.
• Created PL/SQL Procedures, Function Packages and SQL queries of mid to high complexity according to System needs.
• Worked on Oracle Forms to create and modify forms modules for designing the interface.
• Experience in using tools like SQL * Plus, SQL developer, PL/SQL developer, TOAD.
• Experienced in writing UNIX shell scripts for automating the process of data loading & Batch Processing.
• Strong knowledge in object oriented programming using C++, JAVA.
• Used PL/SQL built - in package and PL/SQL Collection to improve the performance of the processes.
• Used SQL*Loader and wrote control file scripts to load data from flat files to Oracle tables.
• Knowledge on system configuration for the database PL/SQL applications.
• Responsible for developing and maintaining Oracle PL/SQL applications and database Programming.
• Documentation of projects for Functional Requirement Spec (FRS), Use case Spec, ER-Diagram, Test Plan, and Test Script & Test Cases.
• Creating OLAP Worksheets, Modifying OLAP Worksheets.
• Knowledge of data modeling techniques includes virtually every flavor of Entity-Relationship (ER) modeling, Physical and Logical data modeling.
• Making structural changes to the database objects.
• Transferred data using data transfer tools like FTP (File Transfer Protocol) and SFTP (Smart FTP)
• Experienced in User Acceptance Testing (UAT), Unit testing, System testing, Integration testing, Development and Production.
• Ability to handle multiple tasks and demonstrate initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.
• A team player with motivation and ability to work independently, Worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.
• Experience in various areas including DBA activities, Installing Software's and Configuring Databases, and UNIX Shell Scripting and scheduling tools
• Robust trouble-shooting, problem solving, analytical & design skills with effective communication skills

TECHNICAL SKILLS

IDE: Microsoft Visual Studio, NetBeans, TOAD, Oracle SQL Developer

Programming languages: C, C++, C#, Java, PL/SQL

Operating Systems: Unix, Solaris, Windows 98/XP/Vista/7, Windows Server 2003

Query Languages: SQL, PL SQL, NZSQL, T-SQL

Script Languages: Ant, UNIX shell scripting, Windows Batch scripting, XML, Perl script, HTML

Database: Oracle 12C/11G/10G/9i/8i, Netezza, Microsoft SQL Server 2005, 2008, MS-Access 2000/2007

Others Tools: SQL* Loader, Enterprise Manager Console, Clear Case, Clear Quest, Anthill Pro, CA-HARVEST, CA workload Automation AE (autosys edition), Pac2000, Control M, HP ALM Defect application, Qlikview, Data Transformation Services (DTS)

Modeling Tools: UML, ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Frisco, TX

Oracle PL/SQL Developer/Data Analyst

Responsibilities:

• Worked extensively with Business User to gather requirements and implemented those using Stored Procedures.
• During migration phase, modified the existing SQL Server code to provide the same functionality of baseline application (running on client server architecture).
• After completion of the migration phase, involved in a team to prepare the Unit testing test cases and also executed all the unit test cases to ensure a bug free development.
• Worked in tuning jobs those are taking high elapsing time after migration. The application team reported more than 90 jobs, taking high time to execute after the database and application migration/up gradation. Worked with High Transaction volume data to increase the Performance of stored procedures Using Explain plan and Hints.
• Extensively worked in developing PL/SQL Stored Procedures, Packages, Cursors and Triggers to implement business rules into the application.
• Worked on deploying the code using the version controls tool.
• Ensured all artifacts complied with corporate SDLC Policies and guidelines.
• Written PL/SQL scripts to create new tables and their corresponding database triggers, sequences, synonyms, indexes, and constraints.
• Designed Oracle tables, views, synonyms for the application.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Fixing of various performance issues identified by the end users and testing team.
• Developed Views which were used for reporting purpose.
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN and DBMS PROFILER
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance

Environment: Oracle 11g, UNIX, Toad, SQL Developer, Putty, ER-Win, MS Excel

Confidential, Charlotte, NC

Oracle PL/SQL Developer/Data Analyst

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users
• Responsible for Analyzing requirements, designing, maintaining and updating data models
• Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system
• Involved in emergency code changes and data changes in production by using problem ticket
• Involved in Migration process 11g to 12c
• Developed PL/SQL procedures to pull the data from the distributed systems.
• Created tables, synonyms, sequences, views, Constraints, Index(B Tree, Bitmap and function based)
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements
• Worked on Informatica side for new business requirements
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time
• Created Informatica mapping for Oracle Database tables and views to send reports to the mainframe
• Created autosys jobs for informatica workflow to run at on-time
• Worked as part of the development team, along with the Systems Analysts/Business Analysts
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in setting up the new UNIX server
• Created and scheduled autosys jobs for automation of PL/SQL wrapper scripts in UNIX.
• Migrated all shell scripts from one server to another and created all UNIX folders on new server as per migration process
• Involved in all phases of database development, from needs assessment to QA/QC, design, and support.
• Worked in 24x7-production environment and provided on-call support.
• Involved in monthly releases for different applications.
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers.
• Optimized and modified the triggers, complex store functions, user base data type etc.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable.
• Involved in unit testing and integrated testing and resolving production problems for the applications.
• Prepared root cause analysis for problems occurred.
• Experience of using Pac2000 for tracking the problem tickets and creating them.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures
• Involved in deploying DB objects, UNIX scripts to different environment using anthill.
• Defined database requirements and designed data model.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements
• Integrated the mailing system to alert various group on the status of data pulls and data processing.

Environment: Oracle 12c,11g, Informatica Power center 8.6, Toad, Oracle SQL Developer, Erwin, MS Outlook 2010, UNIX, autosys, putty, anthill, CA Harvest, MS Excel 2010, pac2000.

Confidential, Austin, TX.

Oracle PL/SQL Developer

Responsibilities:

• Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day
• Created and modified severalUNIX shell Scriptsaccording to the changing needs of the project and client requirements
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables
• Involved in the continuous enhancements and fixing of production problems
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances
• Created PL/SQLstored procedures, functions & packagesfor moving the data from staging area to data mart
• Worked on developing and debugging informatica mappings and workflows
• Created scripts to createnew tables, views, queriesfor new enhancement in the application using TOAD
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE
• Reorganized databases and sized database objects to meet standards and improve performance 30%
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus
• Partitionedthe fact tables andmaterialized viewsto enhance the performance
• Extensively usedbulk collectionin PL/SQL objects for improving the performing
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching
• Improved the performance of the slow SQL queries by implementing proper Index, using FORALL and BULK COLLECT; Wrote unit test cases for some critical SOA composites
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application

Environment: Oracle 10g/11g, Oracle Application Express 4.0, Toad, Oracle SQL Developer, Erwin, MS Outlook 2007,MS Office 2007, Visual Source Safe, Windows, UNIX, Control M.

Confidential

Oracle PL/SQL Developer/Data Analyst

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users
• Responsible for Analyzing requirements, designing, maintaining and updating data models
• Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system
• Developed stored procedures to pull the data from the distributed systems
• Created tables, synonyms, sequences, views
• Managed RAC environment for Day to Day Database administrator, Performance Tuning
• Migrated over 3 TB data from Across the Platform ( From Solaris to AIX)
• Worked in 24x7 production environment and provided on-call and day-to-day support
• Handled database server tuning, application tuning, maintaining documentation, and capacity planning & database security
• Proven track record meeting with management and executives as the subject matter expert inSOA
• Expertise in installation and configuration of Oracle and large databases on Unix Operating System
• Participated in code review and design discussions with SOA architects
• Involved in Developing and handling the PL/SQL Packages, Procedures and Database Triggers
• Optimized and modified the triggers, complex store functions, user base data type etc.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN
• Developed payment register FORM and Invoice register FORM using 6i
• Developed data entry REPORTS in REPORTS 6i
• Experience in SQLperformance tuningusing Cost-Based
• Effectively made use ofTable Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-WriteandTransportable
• CreatedTables, Views, Constraints, Index(B Tree, Bitmap and function based)
• Involved in unit testing and integrated testing
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures; Defined database requirements and designed data model
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements; Schedule Backup and recovery from database
• Integrated the mailing system to alert various group on the status of data pulls and data processing
• Informatica Power Center 9.1/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server).
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor
• Designed and developed user interfaces using Oracle Forms 6i also worked on different oracle Reports 6i

Environment: Oracle 10g,11g, Oracle forms/ reports 10G, Toad, Oracle SQL Developer, Erwin, MS Outlook 2007, MS Office 2007, MKS (Source Code Maintenance), UNIX, Windows.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Experience in assisting the Application Developers in creating conceptual database designs that meet the business and technical objectives
• Used conceptual models and extended conceptual models with business rules to develop logical data models
• Designed Oracle Logical Objects including Triggers, Stored Procedures, and Sequences that helped in automating various operations in the database
• Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance by using lexical parameters
• Developed SQL*Loader scripts to load flat files into source staging database and plan the loads to run concurrently without any manual intervention
• Fine Tuned SQL for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based and Rule based Optimization
• Created new and modified database procedures, functions, triggers and other database objects by using TOAD tool.
• Ensure conformance to code standards and documentation requirements
• Creation of database objects like tables, indexes, views, Procedures, Functions, Packages, Triggers, synonyms
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management
• Collectively used different types of control statements in order to process and manipulate data in the Stored Procedures
• Created database links to connect remote database
• Tuned SQL statements and Procedures using Explain Plan

Environment: Oracle 10g/9i, SQL*Plus, SQL developer, UNIX, putty