SUMMARY

• 7+ years of experience in developing of client/server and multi tired applications using Oracle Database, SQL and PL/SQL of different platforms like Windows NT/2000/XP, UNIX and Linux. Good knowledge of key Oracle performance - related features, such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning, analysis, design, development, and testing of business applications in web based Client/Server architectures.
• Experience in Software Development Life Cycle (SDLC) and AGILE SCRUM methodologies of development process such as requirement analysis & definition, prototyping, designing, coding, testing, deployment and implementation.
• Proficient in writing Packages, Stored Procedures, Functions, Views, Materialized Views, Indexes, Sequences, Synonyms and Database Triggers using SQL and PL/SQL in Oracle.
• Proficient in Oracle 11g/10g/9i/8i/7.3, PL/SQL, DBA back end applications Development Toad, SQL Plus, PL/SQL Developer, UNIX and working knowledge of UNIX editors, Debuggers.
• Solid Experience and knowledge in ETL and Data warehousing concepts.
• Hands on experience with Data warehousing tools, Data Analysis, Data Mapping, Unit Testing, Migration, Conversions and Process Documentation.
• Profound Knowledge in Star SchemaModeling andSnowflakeDimensional Modeling (Data Marts, Facts and Dimensions).
• Strong Knowledge in generating customized Formsand Reports using OracleForms and Reports 6i/9i.
• Strong in using tools such as PL/SQL developer, SQL developer, SQL*Loader, oracle Discoverer, TOAD and SQL*Plus.
• Experience in performance Tuning and Explain plan, SQL loader, DBMS Scheduler, Utl File, Triggers, Indexes, Import and Export utilities and Shell scripting for auto process.
• Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records, Types, Dynamic SQL and Analytical Functions.
• Hands on experience in SQL, PL/SQL Programs, Packages, Stored Procedures, Triggers, Cursors, Dynamic SQL, SQL*Loader, SQL*Plus, UNIX Shell scripting, Performance tuning and Query Optimization.
• Experienced in Dynamic SQL, PL.SQL Collections and Exception handling.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning,Bulking techniques and Indexes.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and Load testing. Seamlessly migrated teh Code from Development to Testing, UAT and Production.
• Proactively interacted with Business Analytical, technical analysts, Developers, Testers and External clients.
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills.

TECHNICAL SKILLS

Web Technologies: ASP, XML, HTML, DHTML, XHTML, CSS, WCF.

Scripting: SQL, PL/SQL, UNIX Shell Scripting, ASP

Programming Languages: SQL, PL/SQL, C# (3.5/3.0/2.0/2. x), VB.NET, XML.

Databases: Oracle 9i/10g/11g, MySQL, DB2, MS SQL Server 2005/2000.

Version Tools: Team Foundation Server (TFS), SVN.

Application Tools: Oracle SQL Developer, Toad, SQL* Loader, SQL Navigator, Workflow, Win Runner, SSIS, SSRS,SSAS,Visual Studio.NET, SQL Management Studio, Adobe Photoshop 7.0, Macromedia Dreamweaver 8, EXADATA

Operating Systems: Windows 7, Vista, Windows XP/NT/2000 and Windows Server .

PROFESSIONAL EXPERIENCE

Confidential, MISSISIPI

PL SQL Analyst

Responsibilities:

• Involved in system analysis design, coding, data conversitons, development and implementation
• Loading of customer data from flat files using SQL loader
• Created tables, Functions, Triggers, procedures and packages for implementing complex database intensive business rules
• Developed procedures to run teh SQL * Loader to load data from flat files into teh target database tables
• Developed complex mappings to load data from Source System (Oracle) and flat files
• Encrypted teh PL/SQL code using wrappers
• Define and represent Entities, Attributes and Joins between teh entities.
• Knowledge of using Perl scripts in automation process and experience with batch processing
• Implemented PL/SQL scripts in accordance with teh necessary Business rules and procedures
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views, and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages.
• Performance tuning of teh application programs using EXPLAIN PLAN and SQL TRACE
• Increased performance by creating Indexes and Hints.
• Analyzing and upgrading Oracle Forms 11g
• Developed Front end Designs using .Net Framework using Win Forms, Web Forms, HTML/DHTML, JavaScript, Crystal Reports 9.0, used Control Objects, Package and Deployment.
• Developed interface program in VB.Net and used ADO.Net Oracle Database as Data Access Layer.
• Support modules for implementation usingPL/SQL Scripts, Unix Shell ScriptsandPro*C.
• Developed Server side programs inPro*C.
• Wrote custom support modules for upgrade implementation usingPl/Sql, Unix Shell Scripts, Pro*C
• Support for teh development, pre-production and teh production databases
• Designed and developed custom built applications using different Oracle products
• Coding, testing and documentation for Oracle Apex along with operational and system level documentation.
• Create Apex triggers for different functions of teh application including database and report triggers
• Responsible for coding and modifications to enforce business rules and to improve performance of teh system

Environment: Oracle 11g (SQL, PL/SQL), SQL*Loader, Forms 6i, TOAD 7.4, HTML/DHTML, PRO*C, JavaScript, APEX, Windows NT/2000, Crystal Report 8.0/9.0, Erwin 4.0, UNIX, CITRIX.

Confidential, REDWOOD CITY, CALIFORNIA

Oracle PL/SQL Developer

Responsibilities:

• Developing teh Oracle reports based on teh project requirements.
• Conducting teh unit testing and performance testing on teh reports.
• Experience in Oracle Backend programming in SQL and PL/SQL, Procedures, functions, triggers and packages in Oracle database server and also for Oracle Application Server using PL/SQL.
• Wrote DDL Scripts to create new database objects like tables, views, sequences, synonyms, and indexes.
• Created Materialized views and Materialized view logs.
• Wrote extensive Exception handling procedures to handle exceptions.
• Generated monthly reports in different formats like tabular, form and matrix using Oracle Reports.
• Wrote SQL scripts to perform Back End testing of teh Oracle database using SQL.
• Involved in writing Unit Test Cases and Test Scripts for Manual Testing from Use Cases.
• Involved in debugging and Tuning teh PL/SQL code, tuning queries, optimization for teh Oracle database.
• Attended Design meetings, code review and test review meetings.
• Data loading from other databases and text files into Oracle Database using SQL*LOADER.
• Extensive experience in loading high volume data and Performance tuning.
• Experience in Performance Tuning using various types of Hints, Partitioning and Indexes.
• Expertise in handling errors using Exceptions.
• Attended Design meetings, code review and test review meetings.
• Attended meetings and review to discuss current issues and processes to tackle issues.
• Worked as a Developer, did requirement analysis, design, developed (Oracle - PL/SQL), tested and implemented and provided infant care on production.
• Gatheird teh requirement from teh client and translated teh business design into technical design.
• Involved in creating Procedures, Functions, Packages, and Triggers. Creating reports using Reports 6i.
• Extensively involved in writing SQL queries (sub queries and join conditions) for generating complex reports.
• Involved in teh development of UNIX shell scripts.
• Performed tuning of teh SQL queries using Explain Plan.

Environment: Oracle 9i, SQL & PL/SQL Development, Oracle Forms and Reports 6i, HTML & CSS, Windows 98/2000/XP.

Confidential, Oklahoma City, OK

Oracle PL/SQL Developer

Responsibilities:

• Worked with Business Users to gather requirements for developing new Reports and also Changes in teh existing Reports.
• Designed and developed Reports according to user specification. Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Extensively Involved in Performance tuning and Optimization of teh SQL queries.
• Wrote Stored Procedures, Functions,Packagesandtriggers using PL/SQL to implement business rules and processes and also performed code debugging using TOAD
• Set up batch and production jobs through Autosys.
• Created Shell scripts to access and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Experience in creating complexSSISpackagesusing proper control and data flow elements with error handling.
• Created reports in SSRS with different type of properties likechartcontrols, filters, Interactive Sorting, SQL parametersetc.
• CombinedDundaschartcontrol with.NETGrid view control and binded both of those controls to a common data source.
• Designed processes to extract, transform, and load data to teh Data Mart. And extensively used SQL*LOADER method to load data from flat files.
• Optimized SQL used in Reports and Files to improve performance to higher extent.
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations in Mappings.
• Extensively used IMPORT utility to load teh exported files.
• Migrated reports from Crystal Reports Version 10 to Crystal Reports Version 11.
• Responsible for teh production issues and bug fixing.
• Generated weekly/monthly/yearly Reports using Discoverer 4i for Department wise Payments to vendors.
• Developed various custom reports and customized standard Oracle reports like Account Status Report and Bank Account Listing as per teh business requirements.

Environment: Oracle 9i, Oracle Reports 6i, SQL, PL/SQL, Erwin, TOAD, Unix,ETL, PVCS Version Manager, Exceed, Test Director.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in teh requirement capturing
• Design & coding of transaction & master forms
• Handled Data Base creation & Back up Management activity of Oracle.
• Preparing Functional and design documents & participation in project review
• Involved in designing data base Including triggers & indexes
• Coordination between development team in project assignment
• Extensively used of PL/SQL Stored Procedures, Functions, Form Triggers and Packages.
• Developed web based front-end screens using Forms 6.0
• Creating SQL, PL/SQL database objects.
• Written teh Interface Stored Procedures for Data Transformation
• Used TOAD, PL/SQL developer tools for faster application design and developments Developed procedures using Dynamic SQL
• Involved in Testing (Both Unit and Integration Level) and Implementation.
• Tested teh entire application in testing environment and exported to Production.
• Done teh documentation and provided on-site production support.

Environment: s: Oracle 8.0.5, PL/SQL, SQL Plus, Windows 2000 and UNIX.