SUMMARY

• Having 8 years of experience in IT, extensive knowledge and work experience in System Analysis, design and development of database applications in Client/Server and Internet/Intranet applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, SQL*Loader and open Interface.
• Gathered the business requirements by interacting with users.
• Proficient in writing PL/SQL Packages, Stored Procedures, Triggers, Cursors, Exceptions and Functions. Developed various applications, using Oracle built - in packages.
• Expert in using Oracle Collections (Index-by Tables, Nested Tables, Varrays).
• Expertise in distributed query performance tuning by using EXPLAIN PLAN, SQL Trace and TKPROF Utilities, hints provided by oracle.
• Expert in Export, Import and SQL*Loader Utilities.
• Proficient in Application Performance Tuning and Query Optimization.
• Used Crystal and Oracle reports to generate Reports for wide range of Data Sources.
• Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Code Review, coordinating user training and user testing, Project demonstration, Implementation, Maintenance.
• Expert in RDBMS including Conceptual/logical & physical Database Design and Model using Sybase Power Designer and Erwin.
• Good work experience in UNIX, Sun Solaris, and Windows 95/98/NT/XP/2000.
• Experience in UNIX Shell (Korn, C, BASH) Scripting.
• Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i Forms, Reports, SQL, PL/SQL, Oracle Import and Export Utilities
• Have experience on backend systems running Oracle Databases and working with large database.
• Experienced with providing 24/7 Production Support.
• Self-motivated, excellent team player with proven leadership skills, excellentcommunication and interpersonal skills.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.

TECHNICAL SKILLS:

Operating Systems: Windows 7/2000/98/95, MS-DOS, UNIX

Databases: Oracle 11g/10g/9i/8i, SQL Server7.0/2000, DB2

Database Tools: TOAD, SQL* Plus, Oracle enterprise manager, Discoveror

Web Technologies: Java, JSP, HTML, JavaScript, Servlets, JDBC

ETL Tools: SQL*Loader

Other Tools: Microsoft Office 2007, MS PowerPoint, MS Excel, MS Word.

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

Oracle Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Designing system work flow diagrams using UML and Visio.
• Involved in ERD Design for Enterprise Application building.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Using SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Involved in development of ETL process using SQL* LOADER, PL/SQL Package.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Participated in Performance Tuning using Explain Plan and TkProf
• Written stored procedures, functions and packages for application development.
• Copying of data from development to test and production by using utilities like Export/Import.
• Developed and optimized database structures, stored procedures, dynamic management views, DDL triggers and user defined functions.
• Automating data loading, extraction, report generation using PL/SQL coding.
• Expert in analyzing/troubleshooting and providing technical support for Unix/Oracle applications and their interfaces.
• Run batch jobs for loading database tables from Flat Files using SQL*Loader.
• Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Creating reports like customer details, Premium due based on the entered period.
• Used FTP to transfer dump files from production server to testing server.
• Worked with Front end application team to build Reconciliation Application using JAVA, J2EE.
• Helped in resolving Middle Tier issues when connecting to backend database structures.
• Knowledge of Oracle ware house builder (OWB), to implement it in loading claims module in Medicaid Application.
• Allocated and involved in managing percentage for asset allocations.

Environment: Oracle 11g, SQL*PLUS, PL/SQL developer, TOAD, FTP, Unix sun Solaris(5.8/5.9), ERWIN, ETL, Oracle ware house builder(OWB),Oracle Enterprise Manager (OEM), Unix Shell Scripts, JAVA,SSIS,SSRS,SSAS Windows XP/2000.

Confidential, Minneapolis, MN

Oracle Developer

Responsibilities:

• Created detailed design and requirements documentation with logic to help better understanding of the system
• Continuously interacted with Business Analysts and end users to gather business requirements
• Performed design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices
• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Designing system work flow diagrams using UML and Visio.
• Involved in ERD Design for Enterprise Application building.
• Creation of database objects like Tables, Views, Materialized views Procedures, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.
• Written SQL queries (Sub queries and Join conditions), PL/SQL programming.
• Involved in development of ETL process using SQL* LOADER, PL/SQL Package.
• Created Records, Tables, Objects, Collections (Nested Tables and Varrays), and Error Handling.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database
• Involved in Performance tuning and Query Optimization
• Documented the errors and solutions to fix them for future use
• Provided SQL tuning, table indexing, data migration, project migration, program debugging.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis
• Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.

Environment: Oracle 11g, SQL*PLUS, PL/SQL developer, TOAD, FTP, Unix sun Solaris(5.8/5.9), ERWIN, ETL, Oracle ware house builder(OWB),Oracle Enterprise Manager (OEM), Unix Shell Scripts, JAVA,SSIS,SSRS, Windows XP

Confidential

PL/SQL Developer

Responsibilities:

• Involved in complete software development life cycle.
• Kicked off meetings with the clients (users) and gathered business requirements.
• Creating of SQL*Loader control programs and PL/SQL validation procedures to map data from different data sources to the Oracle Server.
• Functions and triggers were used at different levels in the all modules to perform various validation operations.
• Developed stored procedures and functions in the backend for generating XML -based reports.
• Widely used the parameters facility in UNIX and PL/ SQL to facilitate automation of the processes.
• Developed and coordinated user’s roles and security permission lists for users accessing applications developed.
• Developed packages, stored procedures, functions for performing various calculations and converting COBOL based program of some of the departments into Oracle-based Sql Scripts.
• Created shell scripts to transfer data from web FTP server to Oracle directory on UNIX.
• Provided SQL tuning, table indexing, data migration, project migration, program debugging.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis
• Setup PL/SQL batch programs for taking periodic backups from the legacy system and updating them in the new tables.

Environment: Oracle 9i, 10g (SQL, PL/SQL), Reports 6i, TOAD, SQL*Loader, Microsoft Visio 2003, UNIX, Rational Clear Case.

Confidential, Cleveland, OH

PL/SQL Developer

Responsibilities:

• Involved in complete software development life cycle.
• Gathered the business requirements by interacting with users.
• Responsible for making decisions on coding standards and documentation.
• Extensively developed PL/SQL packages with procedures, functions.
• Developed various test cases including stress tests to test the efficiency and speed of the application.
• Developed procedures to run the SQL*Loader to load data from flat files into the target database tables.
• Optimized the performance of the application with the help of Explain Plan for SQL queries.
• Wrote SQL, PL/SQL, stored procedures, views and cursors for implementing business rules and data transformations.
• Extensively used various data transformation functions of PL/ SQL.
• Widely used the parameters facility in UNIX and PL/ SQL to facilitate automation of the processes.
• Used Stored Procedures for accessing the data from database to Crystal Reports 9.
• Used parameters for filtering data in Crystal Reports 9.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD by using Crystal Reports 9.
• Used Crystal Repository for reusability of objects.
• Optimizing, and fine-tuning the Crystal Reports for efficiency.
• Participated in the DBA activities like creating users, granting and revoking privileges on Database objects and taking backups.
• Allocated percentage for stocks, bonds, mutual funds portfolio and involved in managing investment.
• Managed several stocks, bonds, investments.

Environment: Oracle 9i, 10g (SQL, PL/SQL), Reports 6i, TOAD, SQL*Loader, Microsoft Visio 2003, UNIX, Rational Clear Case.

Confidential, Tarrytown, NY

Oracle PL/SQL Developer

Responsibilities:

• Gathered Business Requirements from the end users.
• Interface with internal Departments like Quality, Project Engineering, Production, and other end users to understand and write user, functional requirements, and detailed design specifications for the software systems.
• RDBMS Design and Model using Erwin, Oracle 9i.
• Extensively used SQL*Loader to load data from flat files (excel/access) to Oracle database.
• Extensively used SQL Query, Joining tables, SQL functions in Queries. Creation of objects in PL/SQL with the use of Cursors, REF Cursors and loops.
• Developed PL/SQL programs, stored procedures and triggers for data loading and validations.
• Wrote Edit checks using PL/SQL and custom packages for data validation and popup the data in discrepancy tables.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD by using Crystal Reports.
• Developed interface program in VB.Net and used ADO.Net Oracle Database as Data Access Layer.
• Designed and implemented Database Backup/Recovery strategies.

Environment: Oracle 9i/10g, PL/SQL, SQL Loader, SQL Reports, Developer 6i (Forms/Reports6i), Crystal Reports, Visual Basic 6.0, HTML/DHTML, PRO*C, JavaScript, VBScript, Visual Studio.Net, Windows NT/2000, UNIX, MS Office, MS Visio, ERWIN.

Confidential, Boston, MA

PL/SQL Developer

Responsibilities:

• Involved in Database designing using Sybase Power Designer 12.0.
• Involved in understanding the SRA (System Requirements Analysis) document for designing the Database.
• Responsible for preparing System Delivery Specifications / Technical System Design (SDS/TSD) document.
• Extensively used tools like TOAD 9.0 and Microsoft Visio 2003
• Involved in writing test cases for Unit testing the application.
• Involved in scheduling jobs through UNIX Cron job.
• Involved in preparing OpDocs to schedule daily, weekly and monthly cycles using control-M. Developed various PL/SQL Procedures, Functions, triggers and Packages.

Environment: Oracle 9i, TOAD, Microsoft Visio, Control-M Enterprise Manager 6.2.01, Power Designer 12.0, Microsoft Visual Source Safe 8.0, Clear Quest.

Confidential, St Louis, MO

PL/SQL Developer

Responsibilities:

• Collected User Requirements by participating in meetings and studying existing System
• Created database objects like tables, views, Sequences, Directories, Synonyms, stored procedures, function, and packages, Cursor, Ref Cursor and Triggers.
• Involved in analysis, design, coding and Testing.
• Involved in modifying various existing packages, procedures, functions and triggers according to the new business needs
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Involved in writing Unix Shell Scripting.
• Used SQL LOADER to upload the information into the database.
• Used Explain Plan for query optimization.
• Created Database design and converting them into database objects.

ENVIRONMENT: Oracle10g, Toad, SQL * Plus, Oracle Designer, Windows NT,Rational Clear Case (Version control tool) and Rational Clear Quest.

Confidential

Oracle Developer

Responbilites:

• Extensively developed PL/SQL Procedures, Functions, Triggers and Packages
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Creating SQL, Object Views, and PL/SQL database objects.
• Used PL/SQL TABLE, RECORDS and OBJECT TYPES.
• Analyzed and prepared Statement of Work and Requirement Definition Document.
• Designed the business logic to eliminate problems and to ensure efficient system functioning.
• Creating the Oracle schema i.e. table spaces, tables, indexes, constraints, triggers, synonyms, database links, roles etc.
• Implementing basic replication using snapshots.

Environment: Oracle 9i (SQL, PLSQL), Forms 6i, Reports 6i, TOAD

Confidential

Data Base Developer

Responsibilities:

• Analysis, Design, Development, Testing and Maintenance.
• Applied Database Tuning and Optimization, Normalization in the new database design.
• Proposed SQL Tuning within applications for optimized database access.
• Audit programs in PL/SQL for Data consistency check and validation.
• Involved in writing Queries, Stored Procedures, functions and triggers.
• Data base Code Optimization using EXPLAIN PLANCreation of users, roles, schemas, tables, indexes etc.

ENVIRONMENT: Windows 2000, Oracle 8i, EXPLAIN PLAN, SQL NavigatorPL/SQL.