SUMMARY

• Over 8+ years of experience in the development of client/server and multi tired applications using Oracle Database,SQL, andPL/SQLon different platforms like Windows … UNIX.
• Extensive experience in the database analysis, development and maintenance of business applications using Oracle 11g,10g, 9i, 8i,PL/SQLDeveloper.
• Excellent understanding of the software development lifecycle (SDLC).
• Expertise in developingSQL,PL/SQLscripts in oracle distributed environment.
• Experience in Database design using Normalization and E/R diagrams.
• Extensively worked onPL/SQLObject Types, DynamicSQL, Collections, Autonomous transaction, Compound triggers, Materialized Views and Table Partitioning.
• Worked with data transformations and loading using Export/Import file packages andSQL* Loader and created external tables to manage data which is stored at the operating system.
• Created Instead of triggers for updating join views with DML operations.
• Created Global temporary tables to maintain session data and improved the performance of data retrieval and created views, indexes, triggers on them.
• Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors, Cursor Variables, Collections, Triggers, Native DynamicSQL.
• Wrote simple and complexSQLqueries using DML,DDL, Table joins, Group functions, Grouping functions, Analytical functions, Partition by clause towards Reports and Application development.Extensively used oracle tools like TOAD andSQLNavigator.
• Strong knowledge in cursors, records, Ref Cursors, Varrays, nested tables, Bulk Processes(DML), Merge, DynamicSQL(DDL), Exception handling.
• Aware withVBAcodingand reverse engineered excel macros to prepare requirement documents.Experience in Data Extraction, Migration Transformation and Error handling.
• Knowledge in Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications created.Experience in writing complexSQLQueries, created materialized views. Expert in Export, Import andSQL*Loader Utilities.
• Experience in Data Migration processing including data loading from flat files to the database tables usingSQL*Loader.Experience in OLTP like Oracle,SQLserver.
• Expertise in RDBMS development including OracleSQL,PL/SQLdatabase backend programming with stored procedures, Functions and packages.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformationdeveloper, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, Mapplet, reusable transformations, session tasks and Workflows.Experience in data extraction, data migration and Data loading.
• Excellent communication and interpersonal skills, with the ability to manage responsibilities individually or as part of a team environment.

TECHNICAL SKILLS

Databases: Oracle … SQLServer … Sybase, Microsoft Access.

DB Tools: TOAD,SQL*Plus,SQLDeveloper,SQL*Loader,PL/SQLDeveloper

Oracle Tools: Oracle Reports 10g/6i, Oracle Forms …

Language: SQL, T-SQL,PL/SQL, C, C++.

ETL tools: Informatica Power Builder 8.6/9, Data Warehouse

Web Technologies: HTML, JSP, XML, CSS, SERVLETS.

Scripting Languages: UNIX shell Scripting, Perl.

Test Automation Tools: AutoSys, Win Runner, QTP, Test Director

Operating Systems: Windows … UNIX and LINUX.

Version Control: CVS, SVN.

PROFESSIONAL EXPERIENCE

Sr. PL/SQL Developer

Confidential, Detroit, MI

Responsibilities:

• Analyzed the requirements and designed the program flow.
• Participated in the full life cycle of this project including information gathering, analysis, design, development, testing and support of this module.
• Created database objects like tables, synonyms, sequences, triggers, and views.
• Created, edited procedures and functions for improved business requirements.
• Created complex Stored Procedures andSQLJoins and other statements to maintain referential integrity and implemented complex business logics.
• Modified tables, synonyms, sequences, views, stored procedures and triggers.
• Designed and Created Database objects and WrittenPL/SQLPROGRAMMING for data extraction and transformation.
• Developed a tool using excel +VBAto connect to database and get summary of instruments data for any day. Implemented database triggers based on the business rules and requirements.
• Extensively worked in OracleSQL,PL/SQL,SQL*Plus,SQL*Loader, Query performance tuning, CreatedDDLscripts, Created database objects like Tables, Views Indexes, Synonyms Sequences. Migration of existing data from MSaccessto oracle.
• Unit testing onPL/SQLPackages and procedure, functions according to business requirement.
• Documented every phase like Technical specifications, source to target mappings, data and release notes.Assisted in testing and deployment of the application.
• Responsible for Import and export data from various data sources likeSQLServer Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard.Created various visualizations and reports using VBA.
• Assisted in Functional Requirement Specification & Use Case Diagrams to streamlining the business flow.UsedSQLDeveloperto Load / Extract data into and from Excel files.

Environment: Oracle 10g/11g,PL/SQL, Toad, VBA, Microsoft Access, MSSQL2005, HTML, MS Visio 2005.

Sr. PL/SQL Developer

Confidential, Long Beach, CA

Responsibilities:

• Involved in data cleaning, merging and conversion.Enforced constraints for data validation.
• Developed and maintained MSAccessfront-end that allowed users to create and view data/reports. GeneratedSQLandPL/SQLscripts to create and drop database objects.
• Fixed performance issues and bugs with packages and stored procedures using explain plan.
• Created ETL mechanism to transform the data from OLTP source to the newly created OLAP model.Loaded flat file using asSQL*LOADER into database.
• Extensively worked with Informatica - Source Analyzer, Warehouse Designer, Transformationdeveloper, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.
• Used workflow monitor to monitor the jobs, reviewed session/workflow logs that were generated for each session to resolve issues, used Informatica debugger to identify issues in mapping execution.Used TOAD &SQLDeveloperfor debugging application.Gathered and analyzed requirements from business analyst.
• Developed RDBMS includingPL/SQLdatabase backend programming with stored procedures, Functions and packages. Conducted impact analysis and designed structures to enhance performance.

Environment: UNIX, Oracle 10g/11g,PL/SQL, Sun Solaris 5.8, Toad, VBA, Microsoft Access, Informatica 8, VI Editor, MSSQL2005, HTML, MS Visio 2005.

Senior Oracle PL/SQL Developer Lead

Confidential, Charlotte, NC

Responsibilities:

• Involved in the analysis, design, and development and testing phases of Software Development Life Cycle (SDLC).Managed and resolved design issues during deployment.
• Gathered the requirements from the data analysts and architects and performed technical analysis to reach a viable solution.Involved in tuning and optimization ofSQLstatements.
• Converted, loaded and integrated data fromMicrosoft Access, Excel, text.csv files and internal database applications including the mainframe with data captured for security applications.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.Involved in writing test scripts, unit testing, system testing and documentation.
• Built complex queries usingSQLand wrote stored procedures &packages usingPL/SQL.
• Using OracleSQLDeveloperData Modeler create and edit logical, relational, physical, multi-dimensional and data type models. GeneratedDDLfrom data models using ODI.
• Worked withMicrosoftAccess, andSQLServer … to write functions, procedures and views to meet the user's requirements.
• Advanced execution in MS EXCEL, EXCEL macros, MS access,VBAscripting, MySQL, SSIS, SSRS, SSAS, OLAP, Reporting and Analytics, Oracle 9i, Oracle 8i,PL/SQL(Stored Procedures), T-SQL.
• WrotePL/SQLStored Procedures, Functions, and Packages to implement Business Rules.
• Designed and developedPL/SQLfunctions/ stored procedures/ cursors/ triggers/ packages.
• Involved in day-to-day duties of DBA work like taking backup and recovery of database environment.Worked with production support team in resolving production issues.
• Experience in AccessVBAto extract data from a variety of operational data sources on multiple platforms, and build a data warehouse and data marts that integrate the extracted data.
• Designed database structures for effective data extraction, validation, run detail notification and error logging.Supported code deployment from lower to higher environment.
• DevelopedPL/SQLETL scripts to transfer data across the schemas and databases.
• Involved in development and scheduled jobs using Autosys for automation.
• Maintain (Add/Delete/Modify) Jobs based on business requirement using AutoSys.

Environment: ORACLE 11g/ 10g,SQL*Plus,PL/SQL,SQL*Loader, VBA, Autosys, Microsoft Access, TOAD,SQLDeveloper, UNIX, MS Visio, Windows XP/ 7.

Oracle PL/SQL Developer

Confidential, Wilmington, DE

Responsibilities:

• Migrated 3.5 million members from Cigna's WorldeCare System to its new application system - Diamond 950 in the ETL process using OraclePL/SQL,SQL*Loader Scripts and stored procedures and packages.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2,Access, Excel) to centralizedSQLServer databases usingSQLServer Integration Services (SSIS) to overcome transformations constraints.Designed tables, schemas on Oracle for data migration processes.
• Reviewed Data Migration Business Requirements (DMBRs) to determine the scope of System and Functional Specifications.
• Created data mapping plan for Calendar Contract Year Maximums Load/ Accumulator Dollar & Day Limits Load.Delivered workstream project reports to Project Managers.
• Developed and implementedPL/SQLprograms (stored procedures, packages & functions) for the membership conversion.
• Led a team of 4 that developed re-usableSQL(SQL*Plus andPL/SQL) scripts including stored procedures, packages for an Oracle based Medical Claims on-line validation system that supports claim entry process.
• Identified and defined functional Specs on BR's requirements for Member's Benefit Accumulator Migration.Coded, ranDDLstatements for structural changes to tables, views, indexes, partitions.
• Developed and maintained Member Eligibility Validation and Member Enrolment Update Software to support business in on-line validation and updates of members'healthcareand enrolment information.
• Supported business clients with recommended system solutions to business process problems.

Environment: ORACLE 11g,SQL*Plus,PL/SQL,SQL*Loader, Microsoft Access, TOAD, SQL developer, UNIX, Autosys, MS Visio, Windows XP/ 7, COBOL.

Oracle Developer

Confidential

Responsibilities:

• Complete study of the system and prepared Logical and Physical database design.
• Implemented triggers to enhance functionality supplement validation and control navigation.
• Worked extensively asPL/SQLprogrammer, DevelopedPL/SQLProcedures that handle key business logic.Created front-end screens for opening new registrations using HTML, CSS.
• Designed and Created database usingSQLandPL/SQL, wrote backend stored procedures, functions and triggers which allow users to analyze daily, weekly and monthly connection requests, issued connections versus projected issues and keeping track of customer details monthly.WroteSQL* loader scripts to load the data from flat files into database.
• Migrated Databases fromSqlserver 2008 R2 toMicrosoftAccessusing SSIS.
• Worked on design and generation of different Database Objects like Tables, Views, Materialized Views, Synonyms, Sequences, Stored Procedures, Functions, PLSQL Packages, Database Triggers, etc. Test case/data preparation, execution and verification of the test results.
• CreatedPL/SQLprogram units to include DML, DDL statements using DynamicSQL.
• Created database objects like Tables, Indexes, Sequences, Constraints, and Views.
• Ability to develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing with system developers to ensure overall functionality and technical quality of deliverables.Handled various exceptions to troubleshootPL/SQLcode.

Environment: Oracle 9i,PL/SQL, Unix, HTML, CSS,SQL*Loader, Toad,SQLDeveloper SQL, Microsoft Access, Java.