Summary

• More than 8 Years of IT experience in analysis, design, development, testing and implementation as Oracle PL/SQL developer.
• Experienced in writing SQL statements, PL/SQL code for the database objects such as tables,views, indexes, sequences, stored procedures, functions, packages, and triggers.
• Extensively worked on Analysis, Designing, Documentation and Deployment of RDBMS Concepts.
• Expertise in all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development & migration, testing, implementing and maintenance.
• Applicable knowledge of Oracle tools like SQL*PLUS, iSQL*PLUS, Oracle Enterprise Manager, SQL*Loader, export/import and data pump utilities like expdp/impdp.
• Experienced in performance tuning using explain plan, TkProf, Trace analysis.
• Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases.
• Experienced in creating different kinds of partitions for managing large tables (Local and Global Partition) and improving data retrieval.
• Utilization of advance features of Oracle 9i for PL/SQL programming (like Using cursor variables, ref cursors, varrays, nested tables, hints and Dynamic SQL.
• Designed Unix Shell Scripts and set the Cron jobs for repetitive database processes.
• Created physical and logical data models using Erwin Tools 3.5/4.0.
• Knowledge in Oracle PL/SQL, Oracle Forms 6i/9i/10g Developers suite (Forms & Reports) and in Developer 2000.
• Extensive experience in Object Oriented Programming (OOP), extensive Oracle programming, Concurrent Programming (Multi-threading), Analysis, Design, Development and Maintenance in Client / Server / N-Tier environment using C#, DOT NET 2.0, VB6, COM, ADO, Web Services, SOAP, Windows Services, Crystal Reports.
• Knowledge of C#, ADO.NET, Core Java to develop frontend application to interact with Oracle backend.
• Experienced in design and development of Windows Application using Win Forms.
• Expertise in using PRAGMA AUTONOMOUS_TRANSACTION
• Extensively used PL/SQL%TYPE and PL/SQL%ROWTYPE declaration attributes.
• Used TOAD to make database application development faster and easier also to simplify day to day administration tasks.
• Experienced in working with DB link and creating materialized views.
• Extensively used DBMS Oracle supplied package such as UTL_FILE and DBMS_STATS
• PL/SQL Coding and SQL Tuning throughout the development wherever needed.
• Extensive knowledge of using Explain Plan utility to gather the statistics for the preexisting queries.
• Strong knowledge of Data Ware Housing (OLAP Environment)
• Expertise in development and design of ETL methodologies for supporting data transformations and processing, in a corporate wide ETL environment using Oracle PL/SQL, DSS and Data warehousing with OLAP technologies.
• Performed Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SQL*Loader for Flat files.
• Extensive hands on experience in different database models, Schema with various methodologies to handle Slowly Changing Dimensions.
• Excellent communication skills, problem solving, trouble shooting skills and logical methodology. Work well in the team environment or leading a team
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.

Skills set

• OS: Solaris5.9, Windows XP/2000, MS-Dos, HP-UX 11.00, Redhat Linux 3.0/4.1,
• Database: Oracle 10g, Oracle 9i, Oracle8i
• Tools: SQL*Plus, iSQL*Plus, Toad .5/8.6/9/9.1, SQL Developer 1.2, PL/SQL
• Developer 6.0, Oracle forms and reports (6i/9i/10g), Erwin, DB2, OEM9i/10g, Business Objects XI3.o, Crystal reports 8.5/10/11, Data pump,Win SCP (SSH), Putty
• File Transfer: FTP, Smart FTP, Hummingbird 10
• Languages: SQL, PL/SQL, Shell Scripting, C, C++, HTML, XML, VB, java, J2EE

Certificate of Excellence

• Oracle Certified Associate. SQL certification (Exam iZ0 007)
• Oracle Certified Associate PL/SQL Developer Certification (Exam iZ0 147)

PROFESSIONAL EXPERIENCE

Location: New York Client: Confidential,
Project: SXC Duration: Jan’2008 to Till date
SXC: NMHC Provide Pharmacy Benefit Management (PBM) for their clients. NMHC is experts at shaping and administering financially and clinically sound pharmacy benefit plans. SXC is an application purchased and customized at NMHC to maintain their clients member benefits and to provide pharmacy benefits.
Role: PL/SQL DEVELOPER
As a PL/SQL Developer my role is to create SQL*load scripts to load member information and other client information to SXC, Designed, developed and implemented various intranet applications and their multiple scenarios and versions on IIS web server with Oracle back end. Developed numerous crystal reports to provide member and provider information to the client
Responsibilities:

• Developed various SQL*Loader scripts to load Member information to the SXC database and fine tuned SQL Loader performance using Direct-load mechanism.
• Involved in relational and dimensional data modeling, physical and logical data modeling using Erwin.
• Created various database objects like Tables, Views, Triggers, synonyms etc and logical database objects like Procedures, Functions and Packages.
• Developed Database Triggers, which checks the data integrity.
• Identified and mapped the various entities, referential integrity constraints and relationships.
• Extensively worked on Performance tuning and Optimization of Queries and standardization of the code by using Explain plans and various hints.
• Extensively worked on Informatica 5.0 for ETL process to build up data warehouse.
• Involved in Extraction, Transformation and Loading (ETL) of the data in the migration process for Oracle 10g database.
• Experience in using packages like DBMS_JOBS, DBMS_SCHEDULER to schedule tasks
• Trouble shooting performance issues using Explain Plan and TKPROF and well versed with STATSPACK.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Used UNIX Shell scripts (KORN Shell) for Extracting and Parsing data from the files.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• SQL and PL/SQL Performance Tuning: Identified SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS_PROFILER), Explain Plan, Auto trace, TKPROF.
• Used HTML to create web application for the frontend team.
• Experience with different backup strategies using Export/Import utilities.
• Wrote shell scripts to automate loading files into database, error handling and notification.
• Worked on table partitioning (Range and List) and deploying various methods of indexing like local indexes and global indexes on portioned tables.
• Worked extensively on Visual Basic, ASP.Net, .Net, ADO.Net, C# to design and develop n-tier architecture applications, Web Applications, Web Services, Windows Services andcreated connectivity with Oracle and SQL Server Databases.
• Created various windows forms, user controls and custom controls based on user’s requirements.
• Created data mapper classes using ADO.Net.
• Used Connection, Command, Data Reader, Data Adapter and Dataset classes to interact with backend objects.
• Experience in creating Win-Forms on .NET framework with emphasis on Visual Basic, C#, VB.Net and ADO.Net
• Expertise in development of critical, well analyzed, easy understandable reports using Crystal Reports by understanding the business needs.
• Attended meetings and review to discuss current issues and processes to tackle such issues.

Environment: Oracle 10.2.0.1/9.2.0.7, Informatica, Oracle Forms 10g Quest Toad Ver8.5, SQL*Loader, Windows 2003/XP, IBM AIX 5.2/ 5.3, Sun Solaris 5.9, Crystal Reports 11, J2EE, Jdeveloper, HTML.