SUMMARY:

• Over 10 years of vast IT experience in Analysis, Development, Production Support and Implementation of applications using Oracle, UNIX, PL/SQL, Oracle Forms/Reports, Oracle EBS.
• Worked on Production/Application support, development, enhancements and data analysis Projects.
• Good experience in troubleshooting, bug fixing, change request and maintenance of the projects and very strong in data analysis and Data Warehousing concepts.
• Good programming knowledge in Oracle 11g/10g/9i/8i/8.x, PL/SQL, SQL*Plus, TOAD, SQL*Loader and have some basic experience on 12c.
• Proficient in developing Packages, Procedures, Functions, Triggers and developing programs using SQL, PL/SQL
• Expertise in the application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
• Good in resolving production application tickets and familiar with Remedy system.
• Experience in Customizing Oracle and custom ERP applications.
• Good working knowledge in UNIX and UNIX shell scripting.
• Extensive working knowledge in tools like TOAD, Oracle SQL Loader, SQL Plus.
• Used XML Types in Oracle to store and extract the data from the front end application.
• Used Oracle AQ (Advanced Queuing) mechanism in Oracle to Enqueue/Dequeue messages from source system to the target system.
• Have worked on some Data warehouse concepts, ETL using Informatica.
• Good in Client Interaction, Communication, Requirements Gathering and Analysis.
• Highly experienced in onsite off - shore model.
• Experience in developing Reports using Jaspersoft Studio and Jaspersoft server technologies.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Good on Proper and Well-written Documentation of the programs and New Applications developed and/ or Customized / Modified.
• Created Shell Scripts for invoking SQL scripts and scheduled them.
• Good team player with excellent Interpersonal Skills and Self-starter, capable of Working Independently.
• Worked on migration projects like migrating from Oracle to SQL Server.
• Good in setting project goals and achieving it, Highly Result-Oriented.
• Experience in the preparation of Technical Design documents and System Test scripts for Extensions, Data Conversion/Migrations, Inbound / Outbound interfaces, Reports.

TECHNICAL SKILLS:

Languages: PL/SQL, T-SQL, UNIX Shell Scripting, Perl Scripts

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

Tools: SQL* Plus, Toad, SQL* Loader, SQL Developer, Oracle Developer, MS Visio, Text Pad, Excel, Erwin, SSIS, Control-M, EAI Integration, PUTTY, JIRA, Informatica Power Center

BI Tools: Jaspersoft Visual Studio and Server

Version Control: PVCS, Open Source CVS, TFS, VSS

Web Technologies: HTML, JavaScript

Web Servers: Tomcat, IIS, SharePoint, Apache

Operating Systems: UNIX, Solaris, Windows 95/2000/NT/XP

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle Programmer Analyst

• Currently working on Oracle11g environment and deploy the same code on 12c for compatibility and experimental purposes.
• Involved in the creation of database objects like Tables, Views and development of Stored Procedures, Functions, Packages, DB triggers, Indexes using PL/SQL
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Fined tuned some of the legacy queries which were taking time to get executed.
• Did some minor table designing for a new request that came up as a part of the project development.
• Developed stored procedures and functions using VARRAYS and PLSQL Types.
• Developed an API to transfer messages from source Labor Management system to HR Payroll system by Enqueuing/Dequeuing messages using Oracle AQ (Advanced Queuing) mechanism.
• Coordinated with the team members to understand the functionality and business process.
• Developed reports for the project using Jaspersoft Reporting tool. Have done all the initial set up for the Jaspersoft servers. Defined users and their roles so that the reports developed can be access based.
• Worked on some enhancements/bug fixing in the Legacy Oracle Forms and Reports of the current project.
• Modified, created and scheduled many of the concurrent requests and processes as a part of this project using Oracle EBS.
• Also created Value Sets.

Environment: PL/SQL Developer, SQL* Plus, SQL* Loader, Oracle 10g, 11g, Oracle Forms and Reports 6i, Jaspersoft BI Tool, Windows XP, UNIX, Oracle EBS

Confidential

Technical Lead

• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Participated in Designing databases (schemas) to ensure that the relationship between data is guided by tightly bound Key constraints.
• Designed Physical and Logical Data model and Data flow diagrams.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Table space.
• Worked with offshore team in coordinating for production support.
• Involved in writing several complex Queries and Procedures using joins, sub queries and correlated sub queries.
• Optimized the performance of queries by Data Manipulation which includes modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins wherever necessary.
• Used bitmap Indexes, materialized views and partition tables to optimize the queries.
• Developed Data Mappings using various Transformations and PL/SQL Packages to extract, transform and load the data.
• Loaded the data into database tables using SQL*loaderfrom text and excel files.
• Have modified some existing data mappings.
• Created new transformations using Informatica.
• Worked in Application tuning for slow running queries using Explain plan (Auto trace).
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed Data entry, Query and Reports, request screens and tuned the SQL queries.
• Used Joins and Indexes effectively in WHERE clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams.

Environment: Toad, SQLDeveloper, SQL* Plus, SQL* Loader, Oracle 10g, 11g, Erwin, Windows XP, UNIX

Confidential

Technical Lead

• Wrote PL/SQL Stored Procedures, Functions, Triggers and Packages with extensive use of cursors, complex joins, date functions and string handling functions to implement business rules into the application and do the validations as per requirements.
• Developed Shell Scripts and Cron Jobs to maintain scripts for monitoring, troubleshooting.
• Developed SQL *Loader scripts, conversion scripts for the conversion of the data to the custom new schema.
• Optimized Query by Data Manipulations, removed unnecessary columns, normalized tables, eliminated redundant and inconsistent data, established Joins and created clustered/non-clustered indexes wherever necessary.
• Troubleshooting production problems and worked effectively with other team members to identify and address problems.
• Involved in SQL tuning and optimization of SQL performance by generating trace files (DBMS trace), using TKProf and Explain Plan utilities.
• Extensively used Materialized views and DB links for remote instances to retrieve data from other databases.
• Used FTP, SCP and WinSCP to transfer the files between different servers.
• Created DDL for various modules of data model for testing and implementation.
• Performed File transfers using FTP.

Environment: Oracle 10g, UNIX, Windows, SQL* Plus, Version Control, TOAD, SQL Developer

Confidential

Senior Software Engineer

• Worked with team to design, develop, test and implement system.
• Created database objects like Tables, Views and Triggers. Created Procedures, Packages using Oracle tools like SQL Loader, SQL* Plus and PL/SQL.
• Created PL/SQL Triggers to monitor the database activities and to implement some database constraints.
• Involved in Data Loading and Data Migration. Used SQL*Loader to load data from flat/Excel file into the temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Modified existing codesand developedPL/SQL packages to perform Certain Specialized functions/enhancements on oracle Application.
• Involved in problem analysis, resolution, troubleshootingandPerformance Tuning.
• Using SQL trace facility and TKPROF accurately assessed the efficiency of the SQL statements when application runs. For best results, used these tools with Explain PLAN.
• UsedJoins, Indexes, effective Where clauses for Query optimization.
• Used Export and Import to transport data from production to testing and to other databases.
• Participated in development, testing and migration of oracle objects from development to testing and production environments.

Environment: Oracle 9i/8i, PL/SQL, SQL*Loader, UNIX, TKPROF, SQL TRACE, EXPLAIN PLAN.

Confidential

Senior Software Engineer

• Gathered the requirements from the onsite coordinators
• Involved in designing relationship between the tables
• Developed stored procedures, functions and triggers
• Developed interfaces to load the data from the flat files that were sent from the external systems (ETL process)
• Wrote shell scripts which were used to invoke the Oracle packages to load the data
• Scheduled the shell scripts as jobs in UNIX environment
• Provided daily updates to onsite team on self-owned tasks
• Wrote unit test cases and executed them

Confidential

Senior Software Engineer

• procedures, functions and triggers.Migrated the database from Oracle 10g to SQL Server 2005.
• Used the SSMA tool to migrate the database from Oracle to SQL Server.
• Worked on SSIS packages and created new packages for the ETL processes.
• Scheduled the jobs in the SQL Server Agent so that the jobs will run at regular intervals of time. Timely deliveries of the tasks assigned to me.
• Writing unit test cases and executing the test cases.

Environment: Oracle MSSQL Server 2005, T-SQL, SSIS, Oracle 10g, UNIX, MSSQL Server Agent, WINDOWS

Confidential

Senior Software Engineer

• Gathered the requirements from the onsite coordinators
• Involved in designing relationship between the tables
• Developed stored procedures, functions and triggers
• Developed interfaces to load the data from the flat files that were sent from the external systems (ETL process)
• Wrote shell scripts which were used to invoke the Oracle packages to load the data
• Scheduled the shell scripts as jobs in UNIX environment

Confidential

Project Engineer

• Gathered the requirements from the onsite coordinators
• Involved in designing relationship between the tables
• Developed stored procedures, functions and triggers
• Developed interfaces to load the data from the flat files that were sent from the external systems (ETL process)
• Wrote shell scripts which were used to invoke the Oracle packages to load the data
• Scheduled the shell scripts as jobs in UNIX environment

Confidential

Technical Associate

• Worked on Java Script to develop the front end web pages using Oracle Application server by using HTP tags
• Developed stored procedures, functions and triggers
• Worked to store the (TLV - Tag, Length, Value) Messages that we get the Messaging Queues from different systems in the Oracle Database.
• Written packages to store, extract and update these fixed format messages into the database tables in Oracle by using PL/SQL
• Scheduled the shell scripts as jobs in UNIX environment

Confidential

Programmer

• Preparing and Maintaining Forms
• Creating tables and writing SQL queries.
• Developing Reports.