SUMMARY

• Around 8 years of experience in the Information Technology field with extensive experience in Database development, RDBMS based application, Requirement gathering and analysis, Unit Testing and monitoring, documentation and technical support.
• Experienced as Oracle developer in large production environments with database implementation on UNIX and Windows.
• Experienced in Developing PL/SQL Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
• Extensive knowledge in developing PL/SQL codes using Oracle 11g.
• Extensively involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Experienced in tuning the application using Explain plan to optimize the cost and for higher efficiency.
• Experienced in developing the UNIX Shell Scripts to execute the scripts and manipulate files and directories.
• Involved in troubleshooting, debugging and fixing the codes/scripts.
• Experienced in migration of database from SQL Server 2000 to Oracle 10g.
• Translated the T - SQL procedure, function and views into Oracle’s PL/SQL Packages, Procedure, Function and views.
• Extensive Knowledge and Experience in ETL tools like Informatica, SQL Loader and Bulk Insert to transfer the data between different databases.
• Extensive Knowledge and Experience in Data Analysis and managing data warehouse and data marts.
• Extensive Knowledge in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
• Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
• Projects in Investment Banking Domain and Health Domain.
• Experienced in providing technical and non-technical production support.
• Advance knowledge in MS Office like, Excel and PowerPoint.
• Involved in preparing functional specification, technical documentation, schema documents, flow charts and user support documents.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, T-SQL, VB.NET, C#.NET, ASP.NET

Database: MS SQL Server, Oracle 9i, 10g, 11g, MS Access

Web Programming: HTML, XML

IDE: Visual Studio 2005/2008, Eclipse 3.3/3.4

OS: Windows XP, Vista, Windows 7, Linux/UNIX, AutoSys, Perl

Tools: MS Office, Microsoft Project, MS Visio

Network protocol: TCP/IP, HTTP, FTP

ETL Tools: Informatica, DataStage

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Oracle PL/SQL Developer / Database Analyst

Responsibilities:

• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequence
• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database to implement the business logic.
• Assisted with implementation/upgrade of AutoSys and JAWS, troubleshoot errors, and documentation/procedures.
• Monitor Productionjobsto ensure successful execution.
• Responsible for problem identification and resolution of failed processes or jobs and assisted customers in troubleshooting issues with their applications in AutoSys.
• 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.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• 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.
• Creation of database objects liketables, views, materialized views, procedures and packages using 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.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Confidential, Southfield, MI

Oracle PL/SQL Developer

Environment: Informatica Power Center 8.6, Oracle 10g, SQL, PL/SQL, Erwin 4.0, TOAD, UNIX Shell Scripting, Windows XP, UNIX.

Responsibilities:

• Involved in gathering business requirements in liaison with business users and technical teams.
• Created requirement specification documents and identified data sources and targets.
• Worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters.
• Performed logical and physical Data Modeling/ER-Modeling using Erwin 4.0.
• Worked on Informatica Power Center 8.6- Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplet Designer, and Transformation Developer.
• Extensively worked with database objects including tables, views, indexes, and schemas.
• Worked on the design, development and testing of the PL/SQL stored procedures, functions, triggers and packages for the ETL processes.
• Involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Extracted data from Flat files, XML files and loaded them into Oracle.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Used SQL tools like TOAD to run SQL queries and validate the data.
• Provided support and played a major role in debugging production issue.
• Integrated, tested, debugged and implemented application systems.

Confidential, Manhattan, NY

Oracle PL/SQL Developer

Environment: Oracle 10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD, MS- Office, UNIX, Shell Scripts, MS Visio.

Responsibilities:

• Involved in Software Development Lifecycle (SDLC) on Investments Banking Project, Mutual Funds.
• Involved in design, development, analysis, testing and deployment of Mutual Fund Program which included Customers, Account Information, Account Balance, Brokers, Broker Contacts and Assets.
• Gathered Requirement and prepared program specification for the development of PL/SQL procedures, functions and packages.
• Worked with the data migration using SQL*Loader, Bulk Insert and also used SSIS BI tool for migrating the data base from SQL Server.
• Re-constructed the PL/SQL procedures for the previous versions of Oracle Database with respect to the new DB Design.
• Built the Stored Procedures such as Packages, Procedures, Functions and database triggers from TSQL to PL/SQL.
• Worked with the PL/SQL Collections.
• Involved in Query Level Performance tuning using Optimizer Hints, partitioning tables and Indexes.
• Involved in Tuning the application using Explain plan to optimize the cost and for higher efficiency..
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Confidential, Atlanta, GA

Pl/SQL Developer

Environment: Oracle 9i, MS SQL Server 2000/2005, PL/SQL, SQL* Loader, TOAD, MS- VISIO, VI Editor, UNIX, Windows XP.

Responsibilities:

• Gathered requirement from the business users, prepared functional specification and design documents.
• Created the packages, procedures, functions and views applying the business logic to calculate safety stock and service level.
• Created Indexes and also partitioned the tables to improve the performance of the query.
• Used Optimizer hints to the SQL query for faster and better performance.
• Created custom trigger for the validation of input data and to implement business rules and analyze the data.
• Created complex queries and test queries to test the application.
• Designed and Developed the Data Model And ER Diagram.
• Designed and developed the data's pre-staging and staging mechanism for incoming data from data warehouse.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Migration of the existing MS-SQL Server procedures, function and Triggers into Oracles PL/SQL Packages, Procedures, Functions and views to calculate the manufacturing cost.
• Converted SQL Server DTS packages to Oracle 10g.
• Created the Process flow diagrams for each functions on the schema using the MS Visio.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Prepared the technical documentation and user support documents.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 8i, PL/SQL, SQL, UNIX.

Responsibilities:

• Generated various company standards of processing the data based on information gathered from key business users.
• Coded and debugged the stored Procedures, Packages and Views/Materialized Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance
• Created indexes and partitions on various tables in order to enhance performance.
• Provided support and played a major role in debugging production issue.
• Performed code reviews on PL/SQL.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Integrated, tested, debugged and implemented application systems.