PROFESSIONAL SUMMARY

• Around 8 years of IT experience in design and development of database applications using oracle and PL/SQL programming.
• Experience in writing and debugging stored procedures, packages, cursors, Inner Joins & Outer Joins.
• Experience in using the advanced features of PL/SQL like Records, Collections.
• Used several Oracle advanced functions NVL, NVL2, DECODE.
• Implemented UNIX Shell scripts for clean-up, logging and to load the data into database tables.
• Experience in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Knowledge of Version control systems. Conversant with SQL* PLUS, Toad and SQL Developer.
• Worked on ALM defects.
• Good understanding of the principles of DataWarehouse using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Knowledge in running datastage jobs.
• Good knowledge in all phases of Software Development life Cycle (SDLC).
• Experience in understanding business requirements and translating them into technical requirements..
• Experience working in an agile methodology.
• Possess excellent oral / written communication, trouble shooting and interpersonal skills.
• Good ability to quickly grasp, work independently and master new concepts and technologies.

Technical Skills:

Operating Systems: Windows 95/98/NT/2000/XP/Vista/7/Server2008, UNIX.

Programming Languages: SQL, PL/SQL

Databases: Oracle 11g/10g, SQL Server 2005, MY SQL

Tools: SQL*Plus, Toad, SQL Developer

Packages: MS Office Suite (Word, Excel, PowerPoint, Access)

Other: Trouble shooting, Setting up the network and printers, Software/Hardware Installations

Experience Summary:

Client: Confidential Inc, Pataskala, OH

Role : Oracle Developer

Responsibilities:

• Involved in requirement gathering as a part of RMS project.
• To run the conversions as per checklist and migrate data into RMS.
• Created control file scripts and used SQLLDR to load data into the staging table.
• Developed database objects like tables, Indexes, sequences, packages and procedures.
• Implemented UNIX Shell scripts for clean-up, logging, file manipulation and to load the data into database tables.
• Involved in technical documentation for validation scripts.
• Performed modifications to transformation scripts.
• Designed an approach to remove external tables usage in the load scripts.
• Used MKS to keep the latest version of the code developed at one place which helps multiple users to access the code.
• Worked on enhancements and ALM defects.

Client: Confidential, Chicago, IL

Role : Oracle Pl/Sql Developer

Responsibilities:

• Involved in requirement gathering and analysis as a part of Item Intake Application.
• Developed database objects like tables, Indexes, sequences, packages and procedures.
• Modified the existing workbench Rekey reports by developing oracle packages for the application and scheduled jobs using crontab by developing Unix Shell Scripts.
• Modified the existing nonmaintained keycat approval report and implemented the report to run for any country.
• Implemented keycatting quality report to modify list of hard-coded users and pulled the data into flat files using UTL FILE package.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader
• Converted German autocode extract which is currently written in MySql to Oracle.
• Wrote unix scripts to ensure e-mails sent to respective people on Failure/Success, error handling of the processes.
• Extracted data from dictionary database to verify keycat approval accuracy for the Application.
• Created External and Internal Design Documents as per internal standards based on requirements for the Item Intake Application.
• Performed unit testing for all the scripts with different test cases as per the requirements.
• Used Source Version Control SVN to keep the latest version of the code developed at one place, which helps multiple users to access the code.

Client: Confidential, Rosemont, IL

Role : Oracle Pl/Sql Developer

Responsibilities:

• Created Technical Specification Documents as per internal standards based on requirements for the SIS Rewrite (Supplier Incentive System) Application.
• Developed Oracle packages for the application and Scheduled jobs by developing using Unix Shell Scripts
• Developed Functions to create an initial load for tables from USFDW database and to create an ongoing process using flat files from IBM.
• Developed Procedure to create and update history table to reflect new amounts from new compliance details.
• Developed package for weekly upload of EDI Vendors file into CAS (Customer Allowance System).
• Developed packages to create program master and tracking programs from inserted accrual purchase and exclusion detail tables.
• Created one time load from IBM to CAS to update missing fields in invoice header.
• Created and send GL interface file to Peoplesoft by using dbms utility UTL FILE.
• Created local and national reports for GL Accruals that need to be send to CMOD.
• Developed packages to archive tracking and master programs based on parameters set in codes table.
• Created Special bill balance report file to CMOD.
• Used DB Links to pull data from source system to get the up to date data.
• Created new tables, views, queries for new enhancements in the application.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Tuned the queries using Explain Plan
• Created technical documentation for all the scripts.
• Performed unit testing for all the scripts with different test cases as per the requirements.
• Created indexes on the tables for increasing the performance by reducing the data retrieval timing.
• Developed Unix Shell Scripts to Schedule jobs to automate tasks of loading data into Tables.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Extensively used the advanced features of PL/SQL like Records, Collections to fetch large amount of data
• Developed database objects like tables, Indexes, sequences, triggers, packages and procedures.
• Experience in working with EXPLICIT CURSORS and REF CURSORS
• Experience in working a variety of analytical functions like RANK, DENSE RANK, LAG, LEAD.
• Updated test plans, technical specification documents, migration list in sharepoint which helps multiple users to access them.
• Providing on call support.
• Experience working in an agile team.

Client: Confidential, Chicago, IL

Role : Oracle Pl/Sql Developer

Responsibilities:

• Created Technical documents for the CREW (Credit Reporting Exceptions Workflow) Application.
• Designed Schema for the CREW app and Created Tables and Defined Look up values.
• Developed Oracle Pl/Sql Data Load packages for the app Using Pl/Sql Packages and Scheduled them to load the data based on credit reporting day
• Created Email package using oracle supplied UTL SMTP Package which will be used to send emails to CREW Users.
• Created History tables for reporting purpose and filled these tables with crew data using new Pl/SQL Package.
• Used DB Links to pull data from source system to get the up to date data.
• Moved schemas and lookup data to UAT up on successful completion of UAT, application has been deployed to production.
• Created new tables, views, queries for new enhancement in the application using TOAD.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Written Procedures for the validation of input data and to implement business rules.
• Created technical documentation for all the scripts.
• Created indexes on the tables for increasing the performance by reducing the data retrieval timing.
• Developed Unix Shell Scripts to Schedule jobs to automate tasks of loading data into Tables.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Extensively used the advanced features of PL/SQL like Records, Tables.
• Experience in working a variety of analytical functions like RANK, DENSE RANK, LAG, LEAD.
• Partitioned tables using range partitioning technique
• Used Collections, Record types to fetch large amount of data with less contact switching from the database.
• Used version control tool VSS to keep the latest version of the code developed at one place, which helps multiple users to access and make changes to the collection of source code files.

Confidential

Role : Application Developer

Responsibilities:

• Maintained oracle database for fairpoint which is telecommunication based project. This development involves creation of tables, implementing primary and foreign key constraints, procedures using oracle pl/sql.
• Worked for cadtel project and implemented preprocessing tools in it.
• Participated in requirements gathering from data team and executing their requirements.
• Participated in system testing presentations which involves unit testing.
• Created Custom Packages, Procedures, and functions according to the client’s requirement.
• Involved in loading the data loads coming from flat files into staging tables in the Oracle Data base using SQL* Loader
• Developed PL/SQL scripts for Data cleansing.
• Used database Utilities like UTL FILE, DBMS JOB.
• Used TOAD, PL/SQL developer tools for faster application development.
• Created DB links for connecting to remote databases
• Worked on exception handling to trouble-shoot PL/SQL code.
• Generated reports using SQL Server Reporting services.
• Developed Report Models to provide easy slice and dice data access to power users to develop their own reports using Report builder.
• Implemented Automation of Reports to end users by e-mail or file share using SMTP configuration on Report Server.
• Used version control tool VSS to keep the latest version of the code developed at one place.