SUMMARY:

• Over Eight years of experience primarily in Oracle, SQL, PL/SQL, Data Warehousing Development, Production Support.
• Proficient in Oracle 10g/9i/8i/12C, PL/SQL Developer, SQL, Perl, Sun Solaris and HP UNIX, Korn Shell Scripting.
• Proficient in PL/SQL programming - Creating Stored procedures, Functions, packages, cursors, ref cursors, Nested Tables, Associative arrays and user defined types.
• Strong Experience in data warehouse Building, OLAP and OLTP systems, Maintenance and Support which uses ORACLE 8i/9i/10g Databases, SQL SERVER, PL/SQL, SQL* Loader, Shell Scripts, Oracle Express Language in windows NT and Unix environment.
• Strong Knowledge of Data Warehousing concepts, RDBMS and Dimensional modeling primarily Star & snowflake schemas using ERWIN
• Expertise in Tuning of Procedures, Packages, SQL
• Extensively used PL/SQL, Built in Oracle Packages, stored procedures, functions, triggers, cursors, Ref Cursors.
• Worked with the resource and Portfolio Project Managements System called Innotas to track the status of the project.
• Experience working with the resource management systems like Innotas.
• Extensively used Oracle Analytical Functions, Aggregate functions, Dynamic SQL, Exception Handling, Materialized views and views for processing data, enforcing referential integrity and needed business rules.
• Designing, Coding, Testing and implementation of High Availability Distributed System.
• Extensively worked on Table Partitioning, Bulk Binds and Bulk Collects.
• Expertise in performance Tuning- Tuning of SQL queries and complex procedures to improve performance & decrease response time utilizing TkProf, Explain Plan and Hints.
• Involved in Data modeling, E/R diagrams, normalization and de-normalization as per business requirements.
• Experience in Data Migration, SQL Loader.
• Expertise in Creating SQL Loader Scripts to load data from flat files into database and exporting data to flat files using UTL FILE package.
• Extensive experience in developing applications using Oracle Forms and Reports.
• Experience in UNIX Shell Scripting, Perl Scripting.
• Extensive experience using scheduling tools like Cron tab, Autosys.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.
• Adjusted machines and tools to achieve blueprint requirement (Trace Cloud).
• Strong experience in financial industry.
• Worked on creating and tracking the defects in HP Quality Center.
• Excellent analytical and problem solving skills and can work independently.
• Managed EDI related resolutions, inquiries and updates.
• Performed GAP analysis of 5010 EDI transaction using implementation guide to identify the changes in the segments and data elements
• Developer requires solid experience and well-developed understanding of data transfer and EDI.
• Good experience in ASP.Net and WCF.
• Excellent Communication and responsible team player.
• Quick learner with ability to master new concepts and applications.

SKILL SET:

Operating Systems: Windows NT/2000/2003, Solaris 10, HP-UX 10/11, AIX, Linux

Programming languages: Confidential, Confidential ++, VC++, Confidential #, Java, PL/SQL programming.

Web Technologies: HTML, JSP, ASP.NET, WCF, VB.NET

Script Languages: JavaScript, Shell scripting, Perl

Tools: Toad, SQL Developer, OEM, PL/SQL Oracle Developer/2000, Oracle Forms/Reports 6i/9i/10g, Autosys, Visual Studio 2010, Visual Studio 2012, Putty, Citrix, Reflections for UNIX, Datastage, Informatics Power center 8.6

Database: Oracle 10g/9i/8i/8, MS Access 2000, MySQL, MS SQL server 2005/2008

Others: Object Oriented Designing Methodology, UML, RDBMS Concepts

WORK EXPERIENCE:

Confidential, TN

Oracle PL/SQL Database Developer

Responsibilities:

• 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 PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries.
• Used joins, indexes effectively in where clauses for Query optimization.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.

Environment: Oracle 11g ( 11.1.1.0.0 ), Oracle 11g (11.2.0.1.0 ), SQL, SQL*Plus, PL/SQL, Trace Cloud, Oracle Reports, Informatica, Oracle Business Intelligence, APEX, SQL Developer, Toad, Putty, UNIX Shell Scripting.

Confidential, SC

Oracle PL/SQL Database Developer

Responsibilities:

• Interact with SME’s and Business Analysts, gather requirements and convert them to technical requirements.
• Understanding Copybooks and layouts of the main frame file and design the Sql loader control file accordingly.
• FTP the files from mainframe server to windows server.
• Create Windows batch scripts to run the SQL loader jobs.
• Loading large volumes of the claims data into Oracle Tables using SQL loader.
• Used parallelization and Direct load, Multi Table insert techniques to load data from file to oracle Tables.
• Used Hints like parallel, Append while loading data from stage to ODS tables.
• Used UTL FILE package to read and write to OS files
• Create Tables and Partitioning, views, indexes, synonyms.
• Create and remediate complex PL/SQL Packages, Procedures and Functions accordingly to meet the ICD10 code requirements.
• Used PLSQL Collections and features like Bulk collect and bulk binding.
• Involved in designing TRD (Technical Requirements document), and mapping documents.
• Scheduling the Jobs on Autosys job scheduler
• Created and deployed XML Web Services (WCF) using ASP.NET used them to generate the proxy class files based on the web services and consumed in web application.
• Implemented input validation using the ASP.NET Input Validation Controls.

Environment: Oracle10g, SQL, SQL*Plus, PL/SQL, Autosys, VB.NET, Datastage, Cognos, SQL Developer, Innotas, Toad, Putty, Linux, HP Quality Center, Windows NT.

Confidential, NJ

Oracle PL/SQL Database Developer

Responsibilities:

• Gathering business requirements.
• Translate the business requirements into technical requirements, conduct meetings for approvals.
• Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
• Involved in writing data Migration scripts/create table scripts to load database successfully from old schema to new structured schema.
• Altering the database Objects to synchronize it with the new Schema created.
• Involved into updating procedures, functions, triggers and packages based on the change requests.
• Created new Tables, Indexes, views, synonyms and Sequences where needed.
• Create complex SQL, PL/SQL Packages, Procedures and Functions as per the requirement.
• Tuning slow running SQL queries with the help of explain plan.
• Used hints like Append, parallel to aid bulk inserts.
• Indexing tables where needed for faster retrieval of data and increase the performance.
• Tuning of PL/SQL code.
• Used PUTTY & secure shell to connect to UNIX machines.
• Write complex shell scripts for processing of the files and schedule the jobs in Control-M.
• Using external tables to load data into new database
• FTP csv files generated from SAS and load data into oracle tables.
• Used Tortoise CVS control version for synchronizing the upgradations.
• Convert The jobs developed in Oracle DBMS SCHEDULAR to Control-M
• Automated the process of migration from oracle 11.1 to 11.2 by using Control-M
• Was involved in analysis of existing business logic in VB, dependencies and implementation of a similar functionality using VB.NET and ASP.NET MVC.

Environment: Oracle 11g ( 11.1.1.0.0 ), Oracle 11g (11.2.0.1.0 ), SQL, SQL*Plus, PL/SQL, Trace Cloud, Oracle Reports, Informatica, Oracle Business Intelligence, APEX, SQL Developer, VB.NET, Toad, Putty, UNIX Shell Scripting.

Confidential, NJ

Oracle PL/SQL Database Developer

Responsibilities:

• Interact with Development Teams and Managers to analyze business needs.
• Translate the business requirements into technical requirements, conduct meetings for approvals.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP).
• Wrote Perl scripts to interact with the database and migrate data from oracle to SQL server database.
• Used Perforce Visual Client P4V, which provides quick and easy access to versioned files through a graphical interface
• Documented the ETL process for future references.
• Created new Tables, Indexes, views, synonyms and Sequences where needed.
• Create complex PL/SQL Packages, Procedures and Functions as per the requirement.
• Developed and created the new database objects including tables, views, indexes, stored procedures and
• Functions in SQL SERVER.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Handled different types of predefined and user defined exceptions.
• Extensively used PL/SQL Collections, Bulk Collect, for all, Table Types, And Record Types.
• Extensively used UTL FILE package to read and write to OS files and create data feeds to downstream systems.
• Move data between different database environments using Import/Export.
• Optimizing PL/SQL code and SQL queries using Explain Plan and TK Prof utilities and improve the performance of application.
• Created Table partitions and materialized views to improve the performance of slow running queries.
• Wrote complex shell scripts for processing of the files.
• Created Test scripts and involved in Unit, Integration and System testing and User Acceptance Testing.
• Wrote FTP scripts for transferring files, FTP checks to ensure complete file transfers.
• Automated the process of migration from oracle to SQL server by using AUTOSYS. created token files to ensure complete data availability before the automation process initiates in order to migrate the data to new environment.
• Used PUTTY to connect to UNIX machines.
• Used Rapid SQL & Toad for Oracle to access DB, write packages, procedures & functions.
• Designed user interface for application using ASP.NET MVC and implemented business logic using Confidential #.
• Involved in writing data Migration scripts, Created Upstream Source Relationship documents and batch run books.
• Guide/help team members in resolving technical issues.
• Provide 24/7 on call production support and resolve production issues immediately
• Worked with ASP.NET AJAX to create rich UI web applications and to improve performance.
• Hands on experience of debugging an application using the tools provided by the Visual Studio 2010.

Environment: Oracle 9i (9.2.0.1.0), Oracle 10.0.2, SQL, PL/SQL, T-SQL, Rapid SQL 7.6, Toad for Oracle, SQL SERVER MANAGEMENT STUDIO, UNIX, SH, Windows NT, Putty for UNIX, ASP.NET, Perforce, Autosys, Visual Studio 2010.

Confidential, NJ

Oracle PL/SQL Database Developer

Responsibilities:

• Proposed changes to the existing Database Architecture as per requirements and Involved in redesign of database.
• Used ERWIN for Data Modeling and reading the schema designs.
• Analyze the functional & technical requirements of project.
• Wrote complex PL/SQL Packages, Procedures with Cursors, Ref Cursors and Complex Functions to do various financial calculations and to calculate Rate of Return for monthly, quarterly, yearly, calendar year returns & trailing year returns both Annualized & Compounded, handled different exceptions.
• Tuning SQL queries using HINTS, Explain Plan and TKPROF
• Modified existing and designed new user interfaces using Oracle 10g Forms.
• Created mappings to get the data from XML and flat files, from multiple sources into Target.
• Developed 100’s of financial reports according to the specifications of different Fund Managers and Investment Advisors.
• Created database triggers for data security & Consistency.
• Created the Book of Reports where users can select the few reports out of many reports available.
• Upgrade all the reports to iReport 3.1.1 to 4.5
• Create and maintain Jasper iReport repository.
• Scheduled batch jobs in Jasper to run the reports on daily basis and send PDF, EXCEL files to clients.
• Created batch jobs for the data cleansing and generation of summarized reports.
• Scheduled jobs using Jasper Server, Cron tab.
• Developed SQL*loader scripts to load data in the custom tables.
• Working on assigned tickets and resolve day-to-day issues in the OLTP and production systems.
• Created Sun Solaris UNIX Shell scripts for automating the execution process.
• Extensively performed Unit Testing & Integration Testing with different test cases.
• Used PUTTY to connect to the UNIX server.
• Used TortoiseCVS control version for synchronizing the upgradations.
• Created Materialized views & normal views where business requirements needed.
• Coordinated with the team of java developers to accomplish complex financial calculations.
• 24/7 on call production support.

Environment: Oracle 10g, Oracle 10g Developer Suite Forms/Reports, SQL, PL/SQL, SQL*Plus, SQL*Loader, Toad, MySQL 5.0.27, Informatica Power center 8.1, Autosys, Jasper Server 1.3.0/3.1.1/4.5 , Jasper ETL, Innotas, iReport 1.3.0/3.1.1/4.5 , Java, Sun Solaris, Unix Shell Scripting

Confidential, New York

Oracle PL/SQL Database Developer

Responsibilities:

• Analyze the functional & technical requirements of project.
• Create new Tables, Indexes, Views, Materialized Views, Table Partitions as per the requirement in both staging area and target area.
• Create complex SQL, PL/SQL Packages, Procedures, Functions and views as per the requirement.
• Wrote procedures and packages to cleanse, transform and load data from 20 large residential mortgage servicers including Chase Home Loan Servicers, Confidential, Citi etc.
• Programs to load flat files and csv files using SQL LDR.
• Handled different types of predefined and user defined exceptions.
• Extensively used PL/SQL Collections, BULK Collect, Table Types, And Record Types, UTL FILE.
• Extensively used UTL FILE package to create data feeds to downstream systems and credit ratings research.
• Move data between different database environments using Import/Export.
• Extensively used Explain Plan and TKProf utilities to fine tune and improve the performance of application.
• Extensively used hints to tune & optimize queries using DB links.
• Created Table partitions and Materialized views to improve the performance of slow running queries.
• Used DRIVING SITE, HASH, INDEX, NO USE NL, etc hints to optimize queries.
• Wrote complex shell scripts for processing of the files.
• Used $UNIVERSE scheduler to schedule ORACLE & non oracle jobs.
• Created Test scripts and involved in Unit, Integration and System testing.
• Wrote FTP scripts for transferring files between different machines, FTP checks to ensure complete file transfers, new Daily backup scripts to copy last 5 days of files to disaster recovery (DR) system.
• Used PUTTY & Reflections to connect to UNIX machines.
• Used Rapid SQL & SQL Developer to access DB, write packages, procedures & functions.
• 24/7 on call support and resolve P1 issues immediately.
• Guide/help team members in resolving technical issues.
• Provide 24/7 on call production support, resolve P1, P2 issues immediately

Environment: Oracle 9i (9.2.0.1.0), Oracle 10.0.2, SQL, PL/SQL, Rapid SQL 7.6, SQL Developer, UNIX, SH, Windows NT, Reflection for UNIX.

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Understanding the business logic to modify existing SQL Code and Performance Tuning if it requires.
• Used EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also Extensive Usage of Indexes
• Involved into updating procedures, functions, triggers, and packages based on the change requests.
• Coordinate with the front end design team to provide them with the necessary stored procedures, packages and the necessary data.
• Involved in writing procedures, functions, triggers, and packages for new requirements.
• Read data from flat files and uploading that data into oracle tables using SQL*loader.
• Provided Test Data to QA team to validate front end application. Also performed unit testing.
• Requirements Analysis, Specification and Development of Web Focus reports for internal and external users.
• Created user level and system level maintenance documentation.
• Provided Test Data to QA team to validate front end application. Also performed unit testing.
• Involved to prepare user level and system level maintenance documentation.

Environment: Oracle 9i, PL/SQL, SQL*Plus, SQL Loader, Toad, HP UNIX, UNIX Shell Scripting, Ascential DataStage.

Confidential

Oracle Database Developer

Responsibilities:

• Involved in gathering business requirements.
• Analyzed the requirements and converted them into technical specifications.
• Performed design, coding, implementation and support.
• Wrote complex SQL queries using joins and correlated sub queries
• Wrote Stored Procedure, Package and Triggers for back end validations
• Wrote Procedures using Oracle supplied Packages
• Designed Front-end interfaces and created reports as per the requirements using Forms/Reports 6i.
• Code base consists of complex package logic that uses DML and writes all SQL executed to log tables for troubleshooting, and logic that processes logistical data for optimizing selecting a particular product and its features available across different companies. Measuring and reporting product list using Excel, PL/SQL scripts.
• Validations have done in front-end and as will in backend using triggers.
• Involved in the performance tuning of various database queries. The queries retrieved data from different tables in multiple databases.
• Developed Unix Korn Shell Scripts for batch processing of the Reports, which were also scheduled to run Weekly, Monthly or Bi-Monthly.
• Developed SQL loader script for loading data from different schemas.
• Extensively used UTL FILE for creating flat files and XML files used by the downstream systems.
• Extensively used DBMS SQL, Execute Immediate for dynamic SQL.
• Extensively used Analytical functions for complex reporting purposes and hierarchial data
• Used Exception Handling to handle runtime & user defined exceptions.
• Modified existing Shell Scripts and created new Korn Shell Scripts.
• Created Test scripts and involved in Unit, Integration and System testing.
• Prepared System level and user level maintenance documentation.

Environment: Oracle 9i (9.2.0.1.0), SQL, PL/SQL, TOAD, PL/SQL Developer, Unix, Korn Shell Scripting, Windows NT, Reflection for Unix, Oracle Forms/Reports 6i, Windows XP Pro, MS Office 2003 (Excel, Word)