EXPERIENCE SUMMARY:

• Over 8 years of programming experience as an Oracle PL/SQL developer and Data Modeler in Analysis, Design, and Data Modeling in conceptual, Logical and Physical models.
• Expertise in Implementation of Business Applications using Oracle technologies in Financial, Pharmacy, Insurance domains.
• Strong working experience in Oracle 9i/10g/11g database programming using PL/SQL (Stored Procedures, Functions, Packages, and Triggers) and standard built - in Oracle packages in UNIX and Windows environment.
• Extensively worked in Client-Server application environment using Oracle 10g/9i/8i/7.x on Windows, UNIX/LINUX platforms and profound knowledge on Oracle 11g.
• Very Good experience with UNIX Cron Jobs, Batch Processing with highly complex data model
• Strong working experience on Full life cycle of System Development Life Cycle.
• Expert in coding complex and advanced PL/SQL programs using Oracle’s Object-Oriented programming, collections, records, index-by tables, object types and methods.
• Well-acquainted in working with complex SQL queries with joins, date functions, inlinefunctions, sub-queries to generate reports, Functions, Procedures, Exception handling, Views, Packages, Triggers and Ref Cursors.
• Extensive experience in using PLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Bulk Load, Regular Expressions, FORALL, Merge, Global Temporary tables, advanced replication.
• Experience in using the oracle data masking on application data.
• Excellent proficiency in Data Transformations and loading using Export/Import and SQL*Loader and worked on External tables and Transportable table spaces.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL*Plus, SQL Developer and SQL Navigator.
• Strong understanding of SDLC models Water fall and Agile.
• Experience in Query optimization & Performance tuning using Execution Plan, Performance Monitor.
• Experience in developing user interface for database applications using the Oracle Apex.
• Knowledge in performing logical database backup and recovery using Oracle’s EXPORT/IMPORT.
• Experience in working with Java developers to coordinate Web-based functionalities with Oracle
• Database. Knowledge in XML, HTML and JavaScript.
• Strong experience on working with Procedures for improving the load performance in various
• schemas across databases using appropriate HINTS.
• Hard hand in interacting with business analysts and developers to analyze the user requirements, functional specifications and system specifications.
• Proficient experience in working on conceptual, physical and logical data models using various
• Data Modeling tools like Erwin 3.5,4.0,4.1,7.1,7.2, Designer 2000, MS Visio.
• Strong understanding in the principles of Data ware housing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, Slowly changing dimensions, foreign key concepts, referential integrity, and Cubes.
• Extensive experience in Data modeling, system development, Reverse and forward Engineering using Erwin 7.0/4.1/3.5.
• Experienced in OLTP, OLAP, GUI, Relational Database Management Systems (RDBMS) and Report Development.
• Excellent analytical and interpersonal skills, oral and written Communication Skills.

SKILLS MATRIX:

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

Operating Systems: Windows 98/XP, UNIX / MS Windows 2000/2003

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Languages: PL/SQL, T-SQL, HTML, XML, UNIX shell script, Java Script, .NetTools/ Utilities SQL*Plus, PL/SQL Developer, TOAD, PuTTy, Visual Studio, Import/Export, SQL*LOADER, SQL navigator, Oracle forms, Oracle Reports, Oracle SQL developer, CVS, Oracle APEX, HTML DB, DTS Package, VI Editor, Erwin, NDM, Data Stage, Autosys 4.5/4.5.1, WinSCP, MS Excel, MS Project, MS Visio, Ipswitch WS FTP 12, Ultra Edit, TortoiseSVN

PROFESSIONAL EXPERIENCE:

Confidential, Detroit Michgan

Sr.Oracle PL/SQL Developer

Responsibilities:

• Work on multiple tasks and multiple database instances at the same time.
• Used Export/Import utility for backup purpose and transferring data from one database to another.
• Wrote SQL*Loader script file for reading data from CSV/xlsx file and loading into oracle table.
• Optimized and enhanced the existing procedures and SQL statements for the better performance using EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Used procedures and triggers to load data from the source database to data warehouse database.
• Modify existing SQL. PL/SQL scripts in Dev environment as per required.
• Manually run scripts in development to validate, DB link, jobs correctly load tables through SQL*Loader, Extract data from tables, load into temp tables, load data from temp tables to tables, Refresh Martial Views
• Maintaining daily batch cycle and providing Maximum production support
• Create and edit UNIX shell scripts to address new business requirements
• Involved in all stages of development environment
• Involved in creating test cases, UAT test cases and creating technical specification.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX Shell scripts to automate repetitive database processes.
• Maintain and Monitor Tidal and Autosys job scheduler. In Model environment Application maintenance and enhancement. Job monitoring, abend fixing.
• Prod parallel testing in HP (Autosys) and Ally Data Canter (Tidal) 
• Worked with ETL team involved in data loading from different sources and data validation process from staging area to catalog database Executing ftp, telnet for remote access between UNIX systems
• Handle tables, index and partitioning and Involved in data cleaning, merging and conversion
• Involved in application tuning of database by defining the suitable indexes tuning SQL queries.
• Performed Performance Tuning using the DBMS PROFILER package, this checks the run time behavior.
• Usage of UTL FILE package to load the data from external files that is exported from Server. Identified if any programs or any updates in the table or any deletion by setting up the DBMS JOB package.

Environment: Oracle 10g/11gR2, Toad 9.0, PL/SQL, SQL Developer, UNIX, Oracle forms 11g and reports 11g, Tidal, Autosys, Oracle Apex, Data masking, UAT Test, PROD Test, PuTTy, Ipswitch WS FTP 12, Ultra Edit, TortoiseSVN

Confidential, Charlotte, North Carolina

Sr.Oracle PL/SQL Developer

Responsibilities:

• Work on multiple projects and multiple database instances at the same time.
• Directly work with business stakeholders to receive and process data per existing processes.
• Create and edit stored procedures and functions to address new business requirements.
• Design, modify and update database tables, setting up indexes, data constraints, database views, and referential integrity.
• Write SQL codes to modify business rules to validate and load on database.
• Create and maintain scripts with SQL loader to perform data loads for multiple DB instances.
• Experience in working on jasper reports server for reporting services of an web application.
• Performed the data Integration using the IBM InfoSphere DataStage.
• Performed data extract, transform and load between DB2 and oracle using the data stage.
• Involved in all stages of development environment.
• Involved in requirement gathering, documentation in creating technical documentation.
• Involved in design, mapping and manual testing of the design application.
• Worked on writing test cases for the manual testing and participated for final QA testing.
• Worked in team of Oracle Apex for the web layer design of the applications.
• Involved in designing, and updating oracle forms, reports for the Business Analyst in the verall application design, development.
• Worked on oracle forms and reports, in building reports for Business Analyst according to the change in requirements.
• Involved in building oracle forms for the backend oracle application.
• Involved in data model conversion from conceptual design to logical design using the ER model.
• Involved in creating logical and physical data modeling using Erwin.
• Worked on initiating and implementing the security and privacy for oracle application data using the oracle data masking package.
• Worked on with the front end .net platform for creating compatible scripts related to backend.
• Perform data migration/replication between database instances.
• Write PL/SQL procedures, packages, materialized views and develop other database scripts like tables, synonyms, sequences, triggers,
• Handle tables, index and partitioning and Involved in data cleaning, merging and conversion
• Worked on agile and test driven environment, participated on daily scrum meeting, discuss and finalize road blocks.
• Used agile development methodology for application development and design.
• Involved in day to day meeting with development team in Agile environment updating with further steps and providing feedback on current issues.
• Use JIRA as the defect tracking system.
• Interacted with production support team regarding production issues.
• Familiar with both OLTP and Data Warehouse environments.
• Involved in application manual testing, designing of UAT test cases for QA testing.
• Debug and optimize performance of PL/SQL code.
• Aggregate/window functions and commonly used OLAP functions and exception handling
• Maintain and Monitor Autosys job scheduler, Pearl watchers to monitor file loaded in FTP by line of business.

Environment: Oracle 8i/9i/11g, Toad 9.0, PL/SQL, SQL Developer, ERWIN, UNIX, IBM Data Stage, Oracle forms 11g and reports 11g, Oracle Apex, Data masking, BODI, .Net, UAT Test, Informatica Power Center 8.1.

Confidential, New York, NY

PL/SQL Developer.

Responsibilities:

• Analyzed database and also involved in Requirement Analysis, System Design, preparing Functional Specifications, preparing Design.
• Created the business logic in packages, extensively used functions and Pipelined functions.
• Captured all the business validations in various lookup tables.
• Developed database objects including tables, Global temp tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
• Used oracle forms and reports builder for creating oracle forms, reports in documentation, application development.
• Involved in waterfall development environment, participated in all stages of application development.
• Involved in creating test cases, UAT test cases and creating technical specification.
• Involved in documenting oracle reports and creating triggers on reports.
• Created SQL*Loader scripts to load data into the temporary staging tables.
• Created Custom Triggers, Stored Procedures, Packages and SQL Scripts.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed complex SQL queries for data retrieval from various database objects including tables and views
• Involved in Requirement gathering and creating Dataflow Diagrams, ER diagrams and database diagrams.
• Wrote shell scripts to automate the loading, balancing and extraction process
• Developed various complex stored procedures, packages, interfaces and triggers in PL/SQL
• Created various SQL and PL/SQL scripts for verification of the required functionalities
• Worked on various backend Procedures and Functions using PL/SQL
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to the requirements
• Performance tuning using Explain plan, TkProf.
• Executing ftp, telnet for remote access between UNIX systems
• Check the functionality of data in the front-end whether it is displaying properly or not.
• Extensively involved in UNIX shell scripting for writing Wrapper scripts, SQL Execution scripts in ETL processes

Environment: Oracle 11g/10g, PL/SQL, SQL*Loader, TOAD, MS Office, oracle forms, Oracle Reports 10g, HP-UX.

Confidential, Bloomington, IL

Data Modeler/Oracle Developer

Responsibilities:

• Managed and resolved design issues during development.
• Involved in creating database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block, and applied business rules on them.
• Involved in application tuning of database by defining the suitable indexes tuning SQL queries.
• Actively participated in writing complex PLSQL code to ETL data into data warehouse.
• Developed PLSQL code to manipulate application databases for many applications.
• Involved in developing PLSQL code to return various result sets to application environments.
• Handled various small projects independently.
• Optimized and enhanced the existing procedures and SQL statements for the better performance using EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
• Used procedures and triggers to load data from the source database to data warehouse database.
• Performed Performance Tuning using the DBMS PROFILER package, this checks the run time behavior.
• Usage of UTL FILE package to load the data from external files that is exported from Server.
• Identified if any programs or any updates in the table or any deletion by setting up the DBMS JOB package.
• Used Export/Import utility for backup purpose and transferring data from one database to another.
• Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
• Involved in designing, developing, testing, deploying and modifying database applications using Oracle standard database implementation processes.
• Experience in designing, developing, testing, deploying, and modifying end-user reports using Crystal Reports.
• Created database Triggers to Implement and enforce data integrity and security. Developed
• Forms level validation triggers, Procedures, Alerts, Attached Libraries, Record Group, LOV etc.
• Designed reporting architect by defining joins, cardinality between tables, linked the existing architect using Crystal reports
• Converted/Migrated reports from lower environment to higher in crystal reports.
• Created different types of reports, such as master/detail, cross tab and chart. Use of filters, conditions, calculations, etc.
• Used Report Migration utility to migrate reports in crystal reports.
• Worked extensively on distribution, maintenance, and optimization of reports for Crystal Reports Deployments.
• Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.

Environment: Oracle Database 10g, Oracle 9i, SQL*Loader, Toad, SQL Developer, UNIX, Windows XP, Crystal Reports XI, Web Intelligence Release 2.

Confidential, Portland, OR

Pl/SQL Developer and Data Migrations

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specification and design document for the development of the CEMR Application.
• Completely involved in migrating data to Epic applications in a text file format and transferring the data onto the FTP Server which is accessible to the interface team.
• Involved in analyzing the root cause for the missing data and providing the missing data from the Extracts for Testing.
• Extensively worked in providing updated records of the patients on weekly basis by comparing the with the previously-Exported patients records.
• Involved in keeping track of previously-Exported patients and archived them for future reference purpose.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the patients’ database.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Design and developed the scripts to create table, views, indexes and sequence.
• Created the custom tables to import the Patient’s data and insert into the database tables.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Used Perl Scripting in moving the files faster to the Archive folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing BRD, functional document, user document, process flow diagram and flow charts.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS package, MS- Office, UNIX (Putty), Perl Scripts, MS Visio.

Confidential, Philadelphia, PA

Oracle Developer/ PL/SQL Developer.

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source- staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Responsible to write scripts which identify the legacy data and the valid data.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Wrote UNIX Shell scripts for performing development and DBA activities.
• Tested the ETL process in testing environment and created test cases.

Environment: Oracle 9i, SQL, PL/SQL, Red hat Linux 2.1/3.0, Windows 2000 server, TOAD, SQL LOADER, ETL, EXPORT, IMPORT