SUMMARY

• 7 years of experience in Analysis, Design, Development, Implementation & Testing of Applications.
• Extensive experience in client facing roles and working in multicultural, multi - geographic teams.
• Ability to be an effective team player and work under time constraints.
• Prepared Technical Specification documents based on the documents provided by functional team.
• Used SQL*Loader for uploading flat file data into Staging Tables.
• Experience in DATA Migration across Different Relational Database Systems.
• Involved in post implementation maintenance and played a key role in performance tuning.
• Extensive working experience in applying relational database concepts, Entity relation diagrams and normalization concepts.
• Proficient in OracleSQL Tuningand PL/SQL debugging.
• Written complex queries to facilitate the supply of data to other teams.
• Proficient in writing UNIX/LINUX Shell scripting and Technical Design Document (MD70).
• Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, Sql*loader.
• In addition to excellent technical abilities possesses strong oral and written communications skills, analytical and interpersonal skills.
• Design and Creation of PL/SQL code, Oracle Forms and Oracle Reports.
• Experience working with reports, interfaces, conversions and Extensions in Oracle Applications.
• Worked on Warranty Systems, Healthcare, Retail, and Education & Airways domains.
• Expertise in business process engineering and software development life cycle (SDLC) for Banking, Telecommunication & Insurance Clients, including analysis, design, development and implementation of software applications in Oracle 10g/11g using Windows and UNIX environments
• Excellent communication skills and ability to work efficiently in onsite-offshore model with cross-functional teams including application super-users, system end-users, functional analysts, business analysts and technical consultants.
• Analyst Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and Business.
• Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups.
• Experience in Strong Trouble-shooting, Problem solving, Analytical & Design Skills, KSH scripting, Linux with Business Objects.

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 98/2003/2000/ XP Professional, UNIX

DATABASE: Oracle 11g, Oracle 10g /9i

SOFTWARE TOOLS: Oracle 9i/10g/11g, oracle Forms & Reports 6i/11g, TOAD 9/10, SQL Developer, Visual Source Safe

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, HTML, XML, C, C++, PRO*C, Shell, SDLC, JAVA.

PROFESSIONAL EXPERIENCE

Confidential, Albany,NY

PL/SQL Developer

Responsibilities:

• Designs develops and tunes PL/SQl in our high volume database environment with an emphasis on ETL quality and Performance.
• Created stored Procedures in a package .
• Leveraged an existing Procedure and generated the statistics in .CSV file based on the requirement.
• Designed ERD’s for the task I am given.
• Created tables and joined them and inserted values in to those tables using stored procedures.
• Participated in the daily stand up SCRUM AGILE meetings as part of AGILE process for reporting the day to day stats and performance of the work done.
• Worked with both Technical and Nontechnical People.
• Used Shell scripting to load files in the respective tables.
• Created data flow diagrams using Microsoft VISIO.
• Data model through data modeler tools such as Visio.
• Coded,tested,debugged,documented and maintained application programs.
• Confidential is a client where it deals with all the transactions of the workers Compensation and disability benefits .
• Dealt with all kind of FROIs and SROIs in the project and coded accordingly in that based on the acknowledgement I got daily once the batch runned.
• Coded Complex queries, PL/SQL packages,functions and procedures.
• Have knowledge of T-SQL with experience in migrating code and data from sql server to Oracle.
• Worked with SSIS.
• Have experience of creating DDL scripts,migrating scripts to different environment.

Environment: Oracle 11g, PL/SQL, SQL server.

Confidential, Charlotte, NC

Database Analyst/PLSQL Developer

Responsibilities:

• Created functional design document for Coding broker module.
• Provides guidance to developers for logical data modelling for both OLTP and OLAP then implements the data base structures.
• Data Model through Data modeler tools Such as Visio.
• Used SQL loader to load data.
• Developed Payment Registered Forms and invoice registered forms using 6i.
• Developed Data Entry Reports in reports 6i and Forms in 10i/11g.
• Experience with both normalized and dimensional logical data modelling.
• Created Packages, Procedures & functions for Coding broker module.
• Coded, tested, debugged, documented, and maintained application programs.
• Weekly meetings with business users from various regions such as South America, North America to Analyze the data gathered for parts from the suppliers.
• Involved in Integration testing.
• Worked with business analysts and business users in analyzing the requirements.
• Designs develops and tunes PL/SQL in our high volume database environment with an emphasis on ETL quality and performance.
• Participated in the daily stand up SCRUM AGILE meetings as part of AGILE process for reporting the day to day developments of the work done.
• Involved in DBA activities such as creating the DDL’s, GRANT & Export-import utilities.
• Created Data flow diagrams using VISIO.
• Used shell scripting to load files in the respective tables and invoke the procedures.
• Confidential corporation is an American company distributing health information technology and care management tools.

Environment: Oracle 11g, PL/SQL, SQL, SQL Loader. LINUX

Confidential, Palo Alto, CA

Oracle PL/SQL Developer

Responsibilities:

• This involves editing capabilities of customizable syntax highlighting, bookmarks, code completion, code folding, and search or replace.
• The debugging features are especially useful for working with more complex packages, debugging, while stepping through a series of procedures and remote debugging
• By working through the examples I got to know the running of PL/SQL procedures, Functions and packages, Editing PL/SQL code and Compiling the Code.
• Developed stored procedures to pull the data from the distributed systems.
• Created tables, synonyms, sequences, views.
• Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
• Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
• Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Developed numerous forms, reports and utilities using Oracle forms 4.5, Pro*C, C, Sed.
• DevelopedC/C++, Pro*C, Koran shell, SDLCBatch programs handling large volumes of data for parallel processing/load to purge RMS data.
• Data migration techniques used in Oracle External Tables, SQL* Loader.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files .
• Createdrecords, tables, collections(nested tables and arrays) for improving Query reducing context texting .
• UsedPragma Autonomous Transactionto avoid mutating problem in.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand dynamic SQl.

Environment: Oracle 8i/9i/10g/11g, Oracle Forms 6i/9i, Reports6i/9i, UNIX Shell Scripts, PL/SQL, TOAD PL/SQL Developer, SQL Optimizer, Putty.

Confidential, NY

Oracle Forms & Reports Developer

Responsibilities:

• Framed the Coding Standard Scripts used across the Application.
• Created PL/SQL Packages, Tables, Functions and Procedures for the Project.
• Involved in customizing Oracle Reports.
• Designed Technical Specifications based on the business requirements.
• Involved in Documentation of Screen Specifications.
• Designed Online Transaction Processing (OLTP) based on the Use Cases.
• Involved in creating standard PL/SQL Package templates for the Design.
• Designed Test Scripts for the Screens and Batch Programs.
• Process involves designing Oracle OLTP Application.
• Performed tuning for the complex queries in PL/SQL.
• Wealth Management Compliance Surveillance is an approach to migrate data from source database to destined Oracle table.
• Interacted with Business analyst and Project head on daily basis being an AGILE methodology project.
• Co-ordinated with the Java team for frontend changes in line for the LMS application.
• Was involved in handling the PL/SQL changes of backend jobs and ETL process of LMS application.
• Created objects like Tables, Materialized views, Procedures, Packages, Synonyms.
• Performance tuning using hints, indexes and explain plan.
• Extensively used TOAD for all the development work.
• Was part of analysis of the migration of GPC system from Oracle 10g to 11g.
• Wrote SQL and UNIX scripts to move code base to Get version control.
• Co-ordinated with the OBIEE team to cater the reporting requirements.
• Developed and Customized Oracle Forms.
• Process tuning of various Nightly jobs that are rarely analyzed for the use of BULK Collect and Optimizing .
• Administrating software Package like adding, deleting of software packages in Solaris and Adding software patches in Solaris.
• Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.

Environment: Oracle 11g, PL/SQL, Oracle Forms 11g, Oracle Reports 11g, SQL Developer

Confidential, San Diego, CA

Oracle Developer

Responsibilities:

• Interaction with the client to understand the business requirement.
• Designed the tables according the requirements.
• Upload flat files to database using ETL tools like Informatica and SQL Loader.
• Developed procedures to check validity of data according the business rules and fix them.
• Write Script for data updating.
• Daily Report Generation of Telephone Migration Project Status.
• Production Support and Quality Control.
• Oracle objects creation scripts (DDL) for database development to Test and Production environments.
• Oracle PL/SQL design and tuning of stored procedures.
• ETL (Extraction Transformation Load) of data from Oracle tables to flat files and from flat files to Oracle tables.
• Development of PL/SQL Functions, Procedures and Packages using SQL Developer.
• Performed Data-Conditioning for PL/SQL Procedures and provided Unit Test results.
• Performed tuning of the Oracle Objects and Data Correction.
• Argo Group US is a National under writer of specially insurance in niche areas of the property causality market .
• Customized Oracle Forms for the Application.
• Monitored Data-Seeding for the Staging Tables.
• Performed Manual & Automation Regression Testing.
• Customized Oracle Reports .
• Argo group offers a full line of high quality products and services designed to meet the unique coverage and claims handling needs of its clients.
• Involved in Deployment and Provided resolution to the post-production issues/Defects.
• Maintained stored definitions, transformation rules and targets definitions using Informatica.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,
• Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.

Environment: Oracle 11g, PL/SQL, Oracle Forms & Reports 6i, SQL Developer

Confidential

Programmer / Analyst

Responsibilities:

• Various Forms ( Account master, transaction master, Pretty cash etc.) and Transaction reports were developed.
• Applications were tuned using explained PLAN and SQL trace.
• Involved in the Analysis, Design, Development and Deployment of Personnel information /Payroll Automated Banking Transaction systems.
• The Development tools used were Oracle 6.0/7.1, Forms 3.0, Reports 1.1 and Developer 2000.
• Various tables, Procedure and Functions were created.
• Optimized the application Database by encapsulating Procedures and Functions in a Package.
• Tested modules and Fixed bugs.
• Prepared User Documentation.
• Upload flat files to database using ETL tools like Informatica and SQL Loader.
• Developed procedures to check validity of data according the business rules and fix them.
• Write Script for data updating.
• Daily Report Generation of Telephone Migration Project Status.
• Production Support and Quality Control.
• Oracle objects creation scripts (DDL) for database development to Test and Production environments.
• Oracle PL/SQL design and tuning of stored procedures.
• ETL (Extraction Transformation Load) of data from Oracle tables to flat files and from flat files to Oracle tables.

Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX, Toad 10.0.