Developer Data

SOUMYA

Oracle PL/SQL Developer

Tel: +1-816-***-****

E-mail: ***********@*****.***

Summary:Over eight 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 8i/9i/10g and 11g

Experienced in interacting with Business Users, Business Analyst, IT Leads, Developers and System Analysts to gather and analyze business requirements and translating requirements to functional and technical design specifications.

Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating the data load from staging area to production

Extensively worked on PL/SQL Object Types, Dynamic SQL, Collections, Autonomous transaction, Compound triggers, Materialized Views and Table Partitioning.

Worked with data transformations and loading using Export/Import file packages and SQL* Loader and also 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 Dynamic SQL.

Experience in query Optimization, Performance and Tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds, Bulk Collect, Creation of Global Temporary Tables and Table Partitioning.

Good understanding of Data modeling concepts ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables. And extreme use of Exception Handling.

Excellent understanding of the softwaredevelopment lifecycle (SDLC).

Experience in Data Extraction, Migration Transformation and Error handling.

Adept in using Oracle Tools like SQL Developer, SQL* Plus, Toad, SQL Loader, Data Loader, SQL navigator

Proficient in various Oracle seeded utilities like SQL*Loader, UTL File, Export/Import, External Tables, BULK for data load and processing.

Extensively worked with Informatica 9.1 PowerCenter – Source Analyzer, Warehouse Designer, Transformation developer, MappletDesigner, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, Mapplet, reusable transformations, session tasks and Workflows.

Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Quality Assurance, Code Review and Production Support.

Used supplied packages to extend the functionality of PLSQL programs such as DBMS_JOB for scheduling, UTL_FILE to read and write from database, DBMS_SQL to write Dynamic SQL etc.,

Performed SQL tuning, DB performance enhancement tasks for the performance and speed of execution of database objects and performed dynamic SQL embedding and execution

Experience with Star Schema Modeling and knowledge of Snowflake Dimensional Modeling

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 Data Migration processing including data loading from flat files to the database tables using SQL*Loader.

Very good understanding of Object Oriented Programming and Professional GUI designer

Experience with Oracle AQ and Data Replication.

Implemented GUI pages by using JSP, JavaScript, jQuery, CSS, and HTML.

Having good domain and functional knowledge of Core Banking.

Good debugging skills with strong analytical skills in providing RCA’s and solutions for critical issues faced in the production environment and have ability to work in 24x7 environments.

Quick learner and possesses ability to attain a high degree of accuracy in work.

Self-motivated, creative team player with effective communication and leadership qualities.

TECHNICAL SKILLS:

RDBMS/DBMS

Oracle 9i/10g/11g, SQL Server2008, MS Access, SQL*PLUS, Export/Import, SQL*Loader

Languages

SQL, PL/SQL, C, C++, Java, JSP, HTML, CSS, XML, .Net

Tools

TOAD, SQL developer, SQL Loader, SQL Navigator, SQL*Plus, Informatica Power Center 9.1, SSIS, Forms 6i/9i/10g, Reports 6i/9i/10g, WinSCP, HEDIS

Data modeling

ERwin 4.0/7.x, Visio, Visual Paradigm, IHMC Concept Mapping

Operating systems

Windows 7/Vista, UNIX, LINUX, Windows XP/NT/2000

Oracle Utilities

SQL*LOADER, UTL_ FILE, Export/Import, Data Pump

Others Skills

MS Office (Project, Publisher, Excel, Word, PowerPoint), DreamWeaver

PROFESSIONAL EXPERIENCE:

Client: DST Systems, Kansas City, MO. Aug2014 – Till Date

Sr. Oracle Developer / Sr.PL/SQL Developer

Description:DST systems, being a software development firm specialized in information processing and management. It delivers industry experience, technological expertise and service excellence to help the client’s process, communicate and safeguard the critical, high-value information their customers need to manage life’s most important business.

Responsibilities:

Involved in gathering requirements with team lead for efficient Reporting of the database.

Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.

Worked on Agile Scrum Methodology and designed high level ETL architecture for overall data transfer from the OLTP to EDW with the help of Integration Services.

Involved designing and developing packages for a Data Warehousing and Data Migrations projects using Integration services on different Data Sources.

Developed auto generated system using SQL Server Agent to schedule the packages.

Successfully used Import and export wizard to move data from excel sheet to table in Oracle. Update and load data in the tables, remove duplicates in the excel sheets before moving data into the table.

Developed and modified parameterized, drill down, drill through, cascading parameterized and sub reports in SQL Server Reporting Services and exported them to Excel format for managers and Quality Analyst team for easy validation.

Developed various Charts and Graphs like bar charts, line charts, pie charts by using chart experts for Business Intelligence needs in SQL Reporting Services.

Used various Reporting Services expressions in reporting properties to enhance the layout up to the users’ requirements. Deployed reports on the reporting server and manage the subscriptions.

Optimized the Views, Queries and Stored Procedures to enhance the complex reports. Created clustered and non-clustered indexes wherever possible to speed up the queries which in turn enhance the performance of the Reports.

Created and modified the existing stored procedures, Functions, views and queries to have effective reporting. Wrote sub queries in the stored procedures to minimize the logic in the Reporting Services.

Environment: Oracle Database11g, Linux oracle 6, TOAD, SQL*Developer, Microsoft Share point, Microsoft SQL Server 2008, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010, Microsoft Excel 2010.

Client: Medassets Inc., Saddle river, NJ Nov2013 - Jul 2014

Sr.Oracle Developer / Sr.PL/SQL Developer

Description: MedAssets is at the center of improving the quality and effectiveness of the healthcare industry. From establishing best practice value for clinical and labor resources to supply pricing and procurement processes to reimbursement accuracy to payer contract management and modeling The solutions, industry experts and data-driven methodologies are helping healthcare enterprises make informed changes to drive total cost reduction, financial optimization, clinical delivery alignment and efficiency.

Responsibilities:

Gathered and analyzed requirements from business analyst.

Created database objects like tables, synonyms, sequences, triggers, and views.

Created, edited procedures and functions for improved business requirements.

Used SQL Developer to Load / Extract data into and from Excel files.

Conducted impact analysis and designed structures to enhance performance.

Involved in data cleaning, merging and conversion.

Modified tables, synonyms, sequences, views, stored procedures and triggers.

Generated SQL and PL/SQL scripts to create and drop database objects.

Enforced constraints for data validation.

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 as SQL *LOADER into database.

Used TOAD & SQL Developer for debugging application.

Written cursors and REF Cursors for transaction processing.

Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.

Extensively worked with Informatica – Source Analyzer, Warehouse Designer, Transformation developer, 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.

Developed RDBMS including PL/SQL database backend programming with stored procedures, Functions and packages

Implemented database triggers based on the business rules and requirements.

Assisted in Functional Requirement Specification & Use Case Diagrams to streamlining the business flow.

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

Client: EVEREST Re Group, Ltd, Liberty Corner, NJ Aug2012- Oct2013

Oracle Developer / PL/SQL Developer.

Description: EVEREST is a leading international reinsurance and insurance group with an extensive distribution network.Everest has developed a global footprint and deep client relationships that are largely unmatched by its peers. The Company’s principal business strategies seek to leverage its strengths to optimize returns over the underwriting cycle, thereby creating value for its shareholders and business partners.

Responsibilities:

Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.

Developed custom programs for few modules in different applications.

Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.

Used Unix shell scripts and Perl scripts for automating batch jobs.

Optimized existing queries for better performance and less impact on database.

Responsible for performance tuning, analyzing query plans and query tuning for SQL scripts by using tools such as Explain Plan and SQL*Trace utilities

Worked with Indexes to avoid full table scans on large tables for the fast retrieval of data.

Worked with Bulk Collects to improve the performance of multi-row queries by reducing the context switching.

Developed various Oracle Applications using PL/SQL, SQL*Plus, Forms, Reports, Workflow Builder, and Application Object Library.

Extensively used PLSQL tables and Bulk loader utility for processing data and loading into oracle tables.

Wrote Test cases and performed data validation and process testing for application moving into production.

Extensively utilized version control software for code migrations.

Involved in creating ETL model (snowflake schema), normalizing and documenting.

Worked with Informatica to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Environment: Oracle Database 10g, Oracle Reports 9i, Forms 9i, Windows XP, UNIX, SQL Developer, TOAD, XML, SQL, PLSQL, Perl Scripting, Clear Case, Clear Quest.

Client :3M - Austin, TX Jan2011-Jul2012

Project: 3M DMV Solution – DRIVS/MOVRS/ATMM

Oracle Developer / PL/SQL Developer.

End Client: State of Kansas & State of Idaho

Description:DRIVS/MOVRS/ATMM are modules in 3M DMV (Department of Motor Vehicles) suite. DRIVS module manages the Driver's License Issuance and Driver's records/ Sanctions. This application enables the DMV assist the customers to make new License Issuance/Vehicle Registration, renewexisting ones, and manage the Drivers record/Sanctions. The process varies from State to State. Motor Vehicle Registration Solution (MOVRS) handles title and registration records including inventory management. Accounting Transaction Money Manager (ATMM) manages payment transactions and revenue distribution activities.

Responsibilities:

Responsible for Analysis, Design, Development/Customization and Testing/debugging of the reports.

Extensively developed PL/SQL Packages, Stored procedures, Triggers, and finely tuned them for performance.

Developed custom programs for few modules in different applications.

Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.

Used UNIX shell scripts and Perl scripts for automating batch jobs.

Involved in the database administration and creating objects such as database, users, and schema and table spaces.

Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Developed Procedures for efficient Error Handling process by capturing errors into user managed tables.

Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.

Environment:Oracle 9i, SQL, PL/SQL, SQL*Loader, MS Access, UNIX Shell script, TOAD, UNIX, Windows XP/2000.owb 10g.

Life Insurance Corporation of India, Hyderabad, India Aug2007 – Dec 2010

PL-SQL /Oracle Developer

Description:LIC is one of the leading providers of auto, home and life insurance in INDIA. As a consultant at LIC for the Human Resource Management System (HRMS), part of an ERP (Enterprise Resource Planning), developed and helped to implement HRMS that is designed to handle the human resource activities for the organization. HRMS is a web based three-tier architecture system which provides information about employee data, new hire, applicants, promotion, demotion, leave orabsence, payroll data, and change of certain business rules required development of new modules to the system.

Responsibilities:

Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes and Collections.

Responsible for developing PL/SQL Functions, Procedures, Packages, Cursors and Triggers.

Involved in all phases of software development cycles(SDLC).

Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.

Involved in Code Standardization and Documentation.

Exported the reports into the required formats.

Written many database triggers for automatic updating the tables and views.

Implemented proactive database administration to avoid problems such as running out of free space, insufficient space for temporary segments, fragmentation of data segments, etc.

Responsible for back end stored procedures development using PL/SQL predefined procedures.

Developed SQL scripts for Extraction, transformation and Loading of Data and designed source Entities for Oracle.

Involved in creating user documentation and providing End user training.

Responsible for making the technical documentation, reports related to the application.

Environment: Oracle Database 9i, Windows XP, UNIX, SQL*PLUS, Oracle Reports 6i, Forms 6i, SQL Developer, PL/SQL, JAVA, JSP, Perl, UNIX Shell Scripting.

EDUCATION:

Bachelors of Engineering, Kakatiya University, India.

Contact this candidate