SUMMARY:

• Over 5+ years of experience in analysis, design, documentation and development of custom applications using Oracle SQL and PL/SQL, working on various versions including Oracle Database 9i/10g and 11g and SQL Server.
• Extensively involved through all phases of SDLC (Software Development Life Cycle) Dealing with the analysis, Design, development, testing, implementation and maintenance.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, indexes, using Oracle PL/SQL database programming language.
• Loading data from flat files into database tables using SQL*Loader.
• Experience in debugging and providing resolution of on production support tickets and served as the primary on - call person.
• Experience in using collections like PL-SQL tables, Nested tables and V-arrays to optimize the code.
• Expertise in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Expertise in working with Oracle TOAD, SQL Navigator, SQL *Loader, Forms 10g/9i/6i and Reports 10g/9i/6i/ for both development and customizations as per client specifications.
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle
• Knowledge in Oracle cursor management, Exceptional Handling and also Experience in performance tuning using SQL Trace, Explain Plan, TkProf, Indexing and Hints.
• NIX-shell scripting, SFTP & FPT & Subversion (SVN) repository experience, Version Control, Tracking and Auditing Tool. TOAD, SQL Developer & Pl/Sql Developer at large transactional databases (such as OLTP and OLAP)
• Design and Develop scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Developing back-end PL/SQL packages, building UNIX shell scripts for data migration & batch processing.
• Developed the UNIX scripts using KORN shell, Autosys jobs to automate jobs.
• Expert in working with various built in packages like DBMS SQL, DBMS SCHEDUER, DBMS PROFILER, UTL FILE.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows, Mac OSDatabase: Oracle, SQL Server, MS Access

Requirements Management: Microsoft Office (Word, PowerPoint Excel)

Scripting Languages: C, C++, HTML, SQL, PL/SQL and XML, JAVA

Data modeling: ERwin, ER Studio, MS Visio

Database Utilities: SQL*PLUS, SQL*Loader, Data Pump, TKPROF

Database Tools: PL/SQL Developer, SQL Navigator, TOAD, SQL*Developer, SQL Tools, SSIS, SSRS

PROFESSIONAL EXPERIENCE:

Confidential, Collegeville, PA

Oracle PL/SQL Developer

Responsibilities:

• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Involved in system integration testing (SIT), ORT and BRT of the commercial IMS migration project
• Preparing Functional and Technical Design documents.
• Created stored procedures for heavy pharmaceutical transaction by using procedural parameters & working with packages, blocks & exception handling.
• Supported Commercial IMS migration fallout errors in different batch types of DRY RUN, STAGING and EXECUTION.
• Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.
• Documented business rules, functional and technical designs, test cases, and user guides.
• Developed PLSQL packages for generating various feeds from oracle database using UTL FILE utility in the client's secure data transmission server.
• Extensively used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Created Materialized views, Views and synonyms on base tables for data abstraction.
• Created DB links between test and production environments to move Meta data from prod to test based on certain conditions.
• Knowledge in Pharma AML compliance and regulatory practices.
• Participated in major deployments in production and fixed issues that occur during deployment by fixing the code based on the environment.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Staging.
• Collect and link metadata from diverse sources, including relational databases and flat files.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.
• Extensively used Oracle ETL process for address data cleansing.
• Good understanding in creating data marts for the business requirements
• Used SQL*Loaders to load the data into database from the text files and spread sheets.
• Worked on creating Materialized Views to maintain copy of the remote data at local node.
• Solving the complicated run time errors while running the process along with DBA team members.
• Analyzed database growths for Capacity Planning, Normalized the data for efficient performance and also Partitioned data into multiple Files and File groups.
• Used SQL Navigator, a popular tool which increases user productivity and application code quality with rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.

Environment: Oracle Database 11g/12c, TOAD, SQL Developer, PL/SQL, UNIX, UNIX Shell Scripting, SQL*Plus, Crystal Reports, Autosys, SQL*LOADER, Agile.

Confidential, Jefferson City, MO

Oracle PL/SQL Developer

Responsibilities:

• Based on Business requirements modified Packages and delivered the Projects before the deadline.
• Performed unit testing of the database after migration from oracle 9i to 10g.
• Worked with AutoSys scheduler in order to schedule workflows and to run packages.
• Created public synonyms on the database links for reusability.
• Written Stored Procedures with return type as Ref cursor.
• Proficient working experience in Oracle utilities such as Export / Import.
• Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX shell scripts.
• Created scripts for future change in Missouri charge code and changed the existing code to accept new codes with change in format.
• Created functions, procedures, triggers and tables for packages for multiple applications.
• Worked extensively with cursors and jobs using DBMS JOB package for running batch jobs midnight every day.
• Used forward engineering to create a physical data model with DDL that best suits the requirements from the logical data model using Erwin.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy SQL Server database system.
• Used SQL loader to load data from flat files to development database.
• Used UTL MAIL packages to automate the report delivery through Emails.
• Resolved tickets that are assigned in JIRA for severity 1 issues. Extracted data from different sources like flat files and loaded into Oracle data warehouse according to the specifications.
• Worked on materialized views, DBMS SCHEDULER for scheduling jobs and UTL MAIL to send mails using oracle 10g.
• Extensively used PL/SQL Developer for creating database objects, running the command scripts for inserting the configuration data items.
• Experience performing development work using Oracle Report Builder on a database system which maintains historical data.

Environment: Oracle Database 11g, UNIX, Forms Builder 10g/6i, Reports Builder 10g/6i, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Force.com Platform (Sandbox & Production), UNIX Shell Scripting, Visual Studio, Toad, JIRA, data pump.

Confidential, Illinois, IL

PL/SQL Developer

Responsibilities:

• Has partitioned various domains in the database to suit the needs and also to make the system faster.
• Performance tuning was extensively needed in these projects and played a major part in it.
• Worked intensively on PL/SQL Tables, Procedures, Records, and Used Dynamic SQL and triggers.
• Created the data model for the given schema.
• Wrote Cleanup procedures to clean up the data that is too old.
• Have worked on tasks like monitoring the number of records received, calculating the threshold of the counts and sending email from oracle when the threshold is not met.
• Analyzed the record count for a given domain, calculated the mean, standard deviation, the upper and lower limits for the same and illustrated them in excel charts.
• Also, worked on tasks like file frequency, where an email from oracle has to be sent when there is any delay in receiving the file from dealer and also check the status of the file.
• Was part of Job scheduling for Snapshot tasks like inserting history data into history tables when the original tables are overloaded and the data needs to be moved.
• In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables, use of various methods like global temporary tables etc.
• Provided alternative approaches when faced with performance bottlenecks. Approaches like range partitioning, global temporary tables.
• Played an important role in analysis, requirements gathering, functional/technical specification, development, deploying and unit testing.
• In order to increase the performance, partition table with partition index has been introduced.
• Performance tuning and query optimization were extensively needed in these projects and worked on the same.
• Have worked on testing the database after the patch (Gathering table stats, refresh table stats, recreating the indexes, etc).
• Made use of cursors in procedures to generate high performance queries and PL/SQL code.
• Scheduled different jobs using job.submit and also using DBMS Scheduler.
• Run batch jobs for loading staging tables from flat files using SQL*Loader.
• Analyzed software specifications by interacting with business analysts and developers.
• Created Materialized views and Materialized view logs.

Environment: Oracle 11g, Oracle Forms 10g, Reports10g, PL/SQL, SQL*Plus 10.1, SQL*Loader, Toad 8.6 & 9.1, UNIX, Windows.

Confidential

PL/SQL Developer

Responsibilities:

• Exposure to the entire process of Software Development Life Cycle
• Developed PL/SQL packages, procedures, triggers, functions, Indexes to implement business logic
• Performed Data Conversions and Data Cleansing
• Worked on SQL*Loader to Extract, Load and Transform data from varied data sources like Flat files and Oracle.
• Involved in creating UNIX Shell Scripting.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export.
• Involved in writing Bulk Collects, Cursors, Ref Cursors, and Exceptions within the various procedures.
• Worked on performance tuning and used EXPLAIN PLAN and Toad/SQL Navigator for tuning the queries.
• Used the FTP commands efficiently to migrate various files and logs have been created successfully in proper directories on completion of the transfer process.
• Designed and developed user interfaces using Oracle Forms 10g.

Environment: SQL Developer, PL/SQL, Oracle, Java/J2EE, UNIX