SUMMARY

• 5+years of experience as Oracle PL SQL developer in large production environments with database implementation on Unix and Windows.
• Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
• Expertise in Performance Tuning and Query Optimization using various types of Hints, Partitioning, Bulking techniques, and Indexes.
• Proficient in Data Migration from one server to other servers using tools like SQL Loader, Oracle Scheduler, and data transformation services, data conversions from legacy systems to SQL server.
• Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert.
• Experience in utilizing Oracle tools and methods like the use of External Tables, Pipelined functions, Materialized Views, Bulk Collects.
• Experience in creating various type of reports such as Complex drill down drill through reports, Matrix reports, Sub reports and Charts using Excel pivot tables and Visual Basic codes.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
• Highly experienced in environment Oracle 11g, Bitbucket, Unix, MS Access, MS Excel, MS Word, MS SQL, DTS, SSIS, SQL, PL/SQL, SQL*Loader, Toad, Windows XP/2000, XML, Korn Shell Scripts, Oracle Workflow Builder, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Allentown, PA

Database/PL SQL Developer

Responsibilities:

• Designed and developed data quality check PL/SQL queries to provide a better data quality for business credit reports users.
• Worked on optimizing existing PL/SQL packages, procedures, functions and views to suit business needs.
• Used Informatica Powercenter 9.5.1 to extract, transform and load data (ETL processing).
• Used PL/SQL tables and records in transaction processing.
• Created shell scripts to execute PL/SQL procedures and packages. Created staging tables to handle the import data.
• Worked with Oracle external tables to query the data that is stored outside the database in flat files. They are useful in the ETL process of Data warehousing and can be queried in parallel.
• Created Oracle Tables, Views, Constrains, Synonyms, Sequences.
• Loaded the data using the SQL loader, Imports & UTL files based on file formats.
• Created data matching rules to transfer raw data files into existing databases.

Confidential, Oaks, PA

Database/PL SQL Developer

Responsibilities:

• Supported relational database development and SEI Wealth Platform in Wealth Management/ Investments Management/ Asset Management domain.
• Built Foreign Exchange Settlement services and Portfolio Management systems for Confidential .
• Extensively used PL/SQL features such as procedures stored procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Wrote complex SQL queries and PL/SQL procedures to meet business requirements.
• Involved in developing Web applications using C#, ASP.Net.
• Developed load procedures using PL/SQL and other procedures to keep the Database current. Presented to management on a weekly basis the progress and issues regarding their data.
• Responsible for day - to-day tasks like re-indexing, checking integrity, backup and recovery.
• Created staging tables and partitioning tables to handle import data and initiate currency transfer for Fees teams.

Confidential, Allentown, PA

PL SQL Developer

Responsibilities:

• Created PL SQL queries and configuration tables to maintain the new client data. Involved in a production support team and fixed the failing batch processing files.
• Run the billing shell scripts in Full Testing environment and sent bill print files to internal print services and external client FTP servers.
• For the client purchasing the offering, prepared the required data and more options via a front-end site.
• Strong experience in creating complex Stored Procedures, Index, Functions, packages, triggers, cursors, tables, views and other SQL joins and statements.
• Used database links to access remote tables from member company database.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, Triggers and problems related to the privileges.
• Strong communication skills and ability to work in a team and individually. Adding logic and functionalities to current Unix jobs for automating the reports to be generated and sent to FTP server.
• Loaded/Synced projects with PVCS Repository.

Confidential, Long Island, NY

PL SQL Developer

Responsibilities:

• Developed Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Migrated logical and physical models from SQL Server 2000, SQL Server 2008, and Microsoft Access to Oracle database.
• Prepare detailed statistical reports in MS Access and MS Excel to track progress of weekly, monthly and quarterly customers and sales growth.
• Collected requirements from users and made performance tuning in existing product and in designing the database.
• Used database links to access remote tables from member company database.
• Analyzed the functional specs provided by the business analysts and created technical specs documents for all the enhancements.
• Experience in Data migration and conversation from SQL Server 2000 to SQL Server 2008. Tuned Report performance by creating temporary tables and rewriting SQL statements.
• Test case/release notes preparation, execution and verification of the test results. Creating and automating the regular Jobs.
• Created DTS and SSIS package to schedule the jobs for batch processing.
• Responsible for setting preferences for various ad-hoc requests and distribution of tasks. Used linked tables, pass through queries and many other access features also wrote code in Visual Basic to perform some complex reporting tasks.

Confidential

Oracle Developer

Responsibilities:

• The project involved detailed design using E-R Diagrams and Data Flow Diagrams.
• Extensively used PL/SQL features such as procedures stored procedures, functions, packages & database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Loaded data from flat files into database tables using SQL* loader. Wrote complex SQL queries and PL/SQL.
• Tuned SQL queries an performed refinement of the database using tools like EXPLAIN PLAN, and TKPROF to significantly improve the system response, time and efficiency.
• Developed stored procedures, functions and packages for updating, inserting and deleting data from the tables.
• Involved in Unit level testing, Module level testing and System level testing.
• Documented the whole process flow, PL/SQL Packages, log files, locations and description, log tables and possible error messages, process codes and description.