professional summery

• 7 Years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System RDBMS
• Experience in UNIX and Shell Scripting Experience
• Experience in Data Warehousing tools like Informatica and SSIS.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Wide exposure in the business processes of Telecommunications and Pharmaceutical Industries.
• Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL PLUS, TOAD and SQL LOADER.
• Extensive experience in writing pl/sql procedures/Functions/Packages/Triggers Etc.
• Worked extensively on Collections, Dynamic SQL and Exception handling.
• Expertise in using Advanced PL/SQL concepts like Bulk Processing, Types, Objects and Collections.
• Very Strong in SQL performance tuning using Cost-Based Optimization CBO .
• Experience and knowledge to use ETL tools such as Informatica and SSIS.
• Created Tables, Views, Constraints, Index B Tree, Bitmap and Function Based .
• Created Shell Scripts and Perl Programming for invoking SQL scripts and for automation.
• Have a good understanding on OLTP OLAP environment that includes Production 24x7 , QA and development databases in Oracle.
• Hands on experience in preparing Mapping/Requirement Document and FSD.
• Understanding on Customized workflows and screens as per business requirements.
• Worked in oracle applications oracle 12R ERP in report customizations.
• Have used SQL Developer and SQL Loader to import/export data from or to the flat files
• Debugging the stored procedures using Toad/SQL developer
• Extensive experience with Forms and Reports, Oracle APEX.
• Worked extensively on monitoring the database, connectivity of the databases, Object usage and Space usage in RAC clustered environments.
• Experience in using version control tools like Subversion, and Clear Quest.
• Have a good understanding of Star Schema, Big data, Hadoop Data jobs.
• Good interpersonal, Analytical and Communication skills and a team player.

Work Experience:

confidential

Sr. PL/SQL Developer

Project Name: WINDSTREAM OSS Migration

The Project summary is the migration of existing Legacy McLeod service orders and circuit/telephone number inventory to Metasolv. The legacy systems reside in AS400. It is operational support system migration project. All the inventory objects starting from Network locations, Number Inventory, Equipment, Circuits, Trunks, SONETS, Engineering work orders, Cross connects, Assignments and CLR/DLR circuit layout report/design layout report and The customer layer objects such as customer accounts and PSR's Product service requests have to be migrated from legacy systems to open systems Metasolv Oracle

Job Responsibilities:

• Responsible for analyzing and mapping the source data to target tables
• Development of Oracle Packages, Procedures and Functions for migration of data from landing to staging tables using SQL, PL/SQL and Unix
• Responsible for Unit Testing and fine tune the Sql queries Statement tuning and Pl/sql code.
• Migration of data from Legacy table to target tables and handling errors of METASOLV.
• Development of custom code to migrate data directly to Metasolv.
• Coordinating with onsite team for handling issues regarding TN, Circuits, Engineering work orders and CLR/DLR objects
• Handling all the QC-defects related to objects TN, Circuits, Engineering work orders and CLR/DLR.
• Applied patches in the Pre-production to correct the issues related to TN, Circuits, Engineering work orders, CLR/DLR and Equipments.
• Responsible for running all the MOCK cycles from UNIX environment.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle 9i/10g/11g, Toad, Metasolv, pl/sql developer

confidential

Sr PL/SQL Developer

Under the FAIRPOINT NOR'EASTER program, Capgemini is supporting FairPoint communication, Inc. in acquiring and operating all the LEC assets from Verizon's New England state including Vermont, New Hampshire and Maine. This program will consist of sub projects which collectively support the transition of the Verizon operations to FairPoint. This program will thus involve the transition of the organization and people, system capabilities and system data as well as business process and business operations from Verizon to FairPoint .

Job Responsibilities:

• Responsible for analyzing and mapping the source data to target tables
• Development of Oracle Packages, Procedures and Functions for migration of data from landing to staging tables using SQL and PL/SQL
• Responsible for Unit Testing and Fine tune the Sql queries and PL/SQL code.
• Migration of data from staging table to target tables and Handling Errors of METASOLV using MMT Metasolv Migration Tool
• Development of Custom code to migrate data directly from landing to target table.
• Responsible for creation of Equipment Specification in METASOLV and the Migration of related PRODUCT from one environment to other using Data Selection Tool
• Handling all the QC-defects related SWITCH data migration.
• Responsible for migration of SWITCH equipment, assignments, Circuits, service items and orders.
• Applied patches in the Production to correct the orders and equipment's as per the design.

Environment: Oracle 9i/10g/11g, Toad, Metasolv, pl/sql developer, OEM grid Control etc.

confidential

PL/SQL Developer

PA Courts is under the process of rewriting their legacy applications implemented in COBOL using Java and .Net. Database developer's team is responsible to extensively develop and implement the migration process and providing on call support. The migration project deals with data movement from Legacy DB2 and SYBASE to Oracle and SQL Server. Programming according to the rules and transforming legacy data to the target databases according to new business process.

Job Responsibilities:

• Creating database Objects including Tables, Views and Triggers
• Writing SQL Queries and Stored Procedures for the Crystal Reports
• Monitoring and Ministering Development and Test databases
• Tuning the complex queries using various tools like explain plan, and TKPROF
• Analyzing size and data distribution of the target tables and partitioning accordingly
• Tuned the PL/SQL objects using Bulk Processing using Types
• Debugging and Recompiling the Invalid database objects
• Using SQL Loader and BCP utility to move data between Oracle and SQL Server
• Created work flows using Informatica and required mappings to migrate date from SYBASE to Oracle.
• Scheduled refreshes from OLTP to OLAP using Informatica
• Have used SSIS to map and migrate data
• Used the External Tables to simplify the loading process of flat Files
• Change control management and Ticket management using the Clear Quest
• Testing the new developing changes in pre-prod environments and working with DBA team to deploy the changes into production.
• Developed various shell scripts to run SQL batch jobs, and reports.

Environment: Oracle 9i/10g/11g, Toad, pl/sql developer

confidential

PL/SQL Developer

Job Responsibilities:

• Creating and editing the Physical and Logical models of the databases using Erwin Data Modeler.
• Creating required additional database Objects including Tables, Views and Triggers.
• Writing SQL Queries and Stored Procedures for the Crystal Reports.
• Monitoring and Ministering Development and Test databases.
• Analyzing size and data distribution of the target tables and partitioning accordingly.
• Tuned the PL/SQL objects using Bulk Processing using types.
• Have used Oracle spatial indexes and functions to perform oracle spatial joins.
• Have created Forms and reports using Oracle forms and reports 6i/11g.
• Debugging and Recompiling the Invalid database objects.
• Using SQL Loader and TOAD utility to move data between Oracle databases.
• Scheduled refreshes from OLTP to OLAP using SHELL Scripts.
• Have used Forms and Reports, and APEX to create the required forms and reports.
• Change control management using the Clear Quest.
• Testing the new developing changes in pre-prod environments and working with DBA team to deploy the changes into production.
• Developed various shell scripts to run SQL batch jobs, and reports.

Environment: Oracle 9i/10g/11g, Toad, Forms and Reports 6i/11g, Solaris and Mainframes.

confidential

PL/SQL Developer

This project is about to upgrade all the database objects from 11.5.9 to 11.5.10 version and also to provide maintenance and enhancement work after the upgrade has done. My responsibility is included in providing the analysis on migrating the Oracle applications from 11.5.9 to R12 Version.

Job Responsibilities:

• Involved in the upgrade of the database objects from 11.5.9 to 11.5.10.The process includes finding the changed objects in 11.5.9, and up grading with effected changes. Analyzing, Compiling
• Testing.
• Making SQL reports to generate extracts. Automated the SQL reports by registering Concurrent
• Programs using APIs.
• Provided on call support to the client
• Debugging the failed scripts and procedures.
• Recompiling the invalid stored procedures and other stored objects.
• Checking whether the customer was debited properly and see that the transactions is properly tracked. If not the case checked for the appropriate programs and provide the solution steps to the client to run the programs successfully.
• Developed anonymous PL/SQL blocks to correct the incorrectly processed discounts.
• Tuned frequently-used SQL statements.
• Rewrote the Stored procedures and used Types and Bulk Processing objects to enhance the performance.
• Creating and managing data structures, users, groups and their privileges.
• Creating new partitions and repartitioning tables.
• Updating statistics using DBMS STATS and 'ANALYZE'.
• Used Shell Scripts to call the packages and procedures from the database.

Environment: Oracle Apps 11i/R12 and Development Tools 9i/10g SQL, PL/SQL, Reports, BI Publisher