SUMMARY

• Over 11+ years of professional experience in IT industry as Oracle SQL/PLSQL Developer for Project Environments like Planning, Analysis, Systems Design, Data Warehouse Design, Applications Development / Data Migration / Data Conversion / Testing / Maintenance / Production Support.
• Involved in database design and data modelling. Worked on Relational and Dimensional data modelling.
• Oracle PLSQL Developer Certified Associate.
• Applications developed using Oracle 10g database, SQL, PL/SQL, Forms 10g, Reports 10g.
• Expertise in data integration, data migration into Oracle databases UTL Procedure, SQL*Loader and data conversion from legacy system into Oracle Application using PL/SQL.
• Proficient working experience in SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers and Indexes.
• Expertise in using tools such as SQL*Plus, SQL Navigator, TOAD, SQL Developer.
• Experience with T - SQL, DDL, DML and DCL Database designing, writing complex stored procedures, triggers and functions.
• Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Performance tuning of INFORMATICA (sources, mappings, targets and sessions) and tuning the SQL queries.Expertise in writing ETL routines in data warehousing applications.
• Experience in migrating data from Legacy systems to Oracle database
• Hands-on experience in creating performance benchmarks and generating SQL*Plus reports.
• Excellent understanding of the Oracle Architecture.
• Expertise in Performance Tuning of SQL queries with the help of Hints, Partitioning, Bulking techniques, and Indexes.
• Extensive experience on Oracle Forms and Reports.
• Experience in Performance tuning using SQLTRACE, EXPLAIN PLANS & TKPROF
• Bachelor of engineering degree from Computer Science Department.
• Experience in preparing technical documentation and user manuals.
• Excellent analytical and interpersonal skills, oral and written communication skills.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, MS-SQL Server 2005, MS Access

Scripting: SQL, PL/SQL, ColdFusion 4.5, UNIX Shell Scripting

Languages: C, C++ HTML, XML, ASP .NET

Reporting Tool: Oracle Forms and Reports, Crystal Reports, Business Objects.

ETL Tool: Informatica, SQL*Loader

Design Tools: ER/Studio, Erwin, Designer.

Query Tools: TOAD, SQL Developer, SQL* PLUS, PLSQL Developer

Operating Systems: Solaris 7.0/8.0, WINDOWS SERVER 95/98/2000, XP, VISTA, MS DOS, LINUX 9.2/9.3

GUI: Oracle Forms 6i, 9i, 10g and Reports 6i, 9i, 10g.

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

Sr Oracle Developer

Responsibilities:

• Extensively worked on stored procedures, functions and packages to support different functionalities of the application.
• Responsible for performing datacuts from prod to lower environments using mydatabase tool to ensure the lower environments had the latest copy of data from prod.
• Responsible for working with the dba team to provide the db scripts for the prod and uat releases and monitor the releases.
• Work with the offshore Database team to create and fix the database code needed for the application to run correctly.
• Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes.
• Working on the ALM defects submitted by the testing team and the users.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Involved in debugging INFORMATICA mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Worked with UI team and Reports team to ensure subscription reports and on demand reports work correctly.
• As a senior Database Developer responsible for creating and managing PLSQL packages used by front end applications as well as batch applications.
• Work with both the GBR side and the technology side of the RDMS application.
• Provided the production support for the applications developed/maintained by views team.
• Working with the team to get the autodeploy setup for the database scripts.
• Involved in the creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database links etc.
• Data base Code Optimization using EXPLAIN PLAN.
• Good experience in enforcing data integrity using integrity constraints.
• Involved in unit testing and provided test scripts to the test team.

Environment: Windows, Oracle 11g.

Confidential, Jersey city, NJ

Sr Oracle Developer

Responsibilities:

• Involved in all the stages of the application development including design, development and maintenance.
• Awarded chase champion twice by peers from other teams that interact with request center on daily basis.
• As a senior Database Developer responsible for creating and managing PLSQL packages used by front end applications as well as batch applications.
• Supported three different applications request center, Instant app and mytechhub. Involved in development and maintenance of the applications.
• Led a team of three database developers. Tasks included mentoring and helping the other developers.
• Provided the production support for the applications developed/maintained by views team.
• Involved in the creation of reports for higher management including reports of billing and inventory for each user in the bank.
• Created and maintained the ER diagrams of the database using Erwin tool.
• Loading data from various sources and scheduled jobs to run on a regular basis using crontab.
• Writing Stored Procedures, Functions, Packages and triggers to implement business rules and processes.
• Involved in the creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database links etc.
• Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Did tuning of SQL queries with the help of Hints, Partitioning, Bulking techniques, and indexes.
• Created SSIS packages, scheduled nightly jobs to load data and monitored them on a regular basis.
• Involved in creating a data warehouse which is used to generate reports for the upper management.
• Interacted with the users for requirements and generated reports for them based on the inputs provided.

Environment: Windows, Oracle 11g.

Confidential, Las Vegas, NV

Sr Oracle Developer

Responsibilities:

• Developed and modified Existing Packages, Stored Procedures, Stored Functions, triggers and Cursors as per business requirement.
• Used TOAD for the sql queries and for managing the database.
• Responsible for creating various database objects like tables, views and indexes.
• Involved in the creation of new reports and maintaining existing reports using oracle reports and jasper reports.
• Involved in the migration of reports from Oracle to Japser.
• Involved in the development of new screens using javascript, Ajax and Html.
• Wrote Complex SQL statements using complex sub queries.
• Involved in Database Tuning, Optimized SQL queries involving large tables and improved application performance using Explain Plan, Hints, TKPROF and SQL trace.
• Involved in developing code to maintain auditing and logging data for the application.
• Used Advanced Explicit cursors concept like FOR UPDATE, WHERE CURRENT OF Clause.
• Developed PL/SQL Packages for easier application design and improved Performance.
• Developed PL/SQL stored procedures for database and application validations.
• Implemented Logical Data Modelling using ERWin Data Modelling tool.
• Loading XML data, obtained from the customers, into XML Type columns and then processing it.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Trapping Exceptions, Trapping Predefined Oracle Server errors through PL/SQL Exception blocks.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Automating data loading, extraction, report generation using UNIX shell scripting.
• Documented the whole process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions

Environment: UNIX, Windows, Oracle 9i/10g.

Confidential, Las Vegas, NV

Oracle Developer

Responsibilities:

• Responsible for plan, design and architecture of high volume Data Migration/ETL platform.
• This ETL platform will provide an automated data extract, transform from various local entitlement systems.
• Database Backend Developer responsible for creating and managing PLSQL packages used by Front end applications as well as batch applications.
• Performing conceptual data modeling, data analysis, data profiling, data mapping and ETL implementation for product integration with client's applications.
• Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to implement business rules and processes.
• Creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database links etc.
• Created Cursors, Collections and DB Triggers.
• Involved in Data Conversion between Oracle Databases. Created database conversion programs.
• Played a major role in designing and development of migration of Oracle reports from 9i to 10g.
• Developed cards and certificates for user identification and tracking user training history.
• Setup batch and production jobs using AUTOSYS.
• Load external files (Excel, XML) into database using SQL*Loader & XPATH Queries.
• Worked with Data Modelers to create the data model for the Train II, CODS IIi
• Involved in the Data Analysis and reducing data discrepancy for the source and target schemas.
• Optimized SQL used in Reports and Files to improve performance drastically.
• Monitored AutoSys job scheduler, which processed feeds and transmitted files to various sites.
• As a part of production support was involved in bug fixing and system enhancements.
• Involved in unit testing and provided test scripts to the test team.

Environment: Windows 2003, Oracle 10g.