• Over 10 years of experience in IT industry mainly in design, development, implementation, testing and documentation of business applications using Oracle/UNIX/Oracle Data Integrator ODI technologies.
• Proven experience in PL/SQL that includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables IOT , SQL Loader, Exceptional Handling etc.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Good understanding of RDBMS, Oracle Database architecture, design and performed some DBA duties, such as Table partitioning, import/export and data pump.
• Solid experience in performance tuning and Query Tuning Using Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF etc. .
• Experience in using SQL tools like Oracle SQL Developer, TOAD and PL/SQL Developer and SQL Plus.
• Excellent Knowledge of Extraction, Loading and Transformation process ELT .
• Expertise in Production Support activities and documenting the Abend resolutions for root cause analysis.
• Ability to work on complex technical assignments and ensuring the timely deliveries.
• Strong analytical and problem solving skills with the ability to quickly adapt to new environments and learn new technologies.
• A Team evolved person with excellent organizational, verbal, written communication, presentation and understanding skills.

Confidential

Sr. Oracle PL/SQL Consultant.

• Quill Corporation is the largest mail order office supply retailer in the United States and is currently owned by STAPLES. Working in Datawarehousing BI Business Intelligence team for a CMS Application.
• Based on the behavior of the orders placed by customers, Promotions are generated in different channels for different customer groups. Users will create campaign for every customer group. For these customers, Campaign process runs in the backend, which generates various distribution lists for respective vendors. Upon receiving these distribution list, Vendors will distribute promotions to each customer independently and all opts outs and bounces emails will be feeded back to our system for future suppressions.

Responsibilities:

• Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Developed interfaces, packages, scenarios and Load Plans in ODI.
• Performance tuning of PL/SQL procedures and SQL queries.
• Defining checklists for coding, testing deliverables.
• Developing the High Level Design for the enhancements.
• Coding in PL/SQL and Shell Scripting.
• Coordinating with SP/DBA for environment related issues.
• Review of Test Cases and System Testing.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Job Scheduling using ODI and CRONTAB.

Environment: Windows 7 Pro, Oracle 11g/10g, Pl/SQL, SQL Loader, UNIX shell scripting, Oracle SQL Developer, PL/SQL Developer, WinScp, CRON Scheduler.

Confidential

Oracle PL/SQL Computer Programmer

• The primary objective is to migrate the current GM EPC4 to the Cornerstone platform with a phased release. The go-to market strategy will also include the End of Life plan for the current GM EPC. The migration plan for Cornerstone will carefully consider the end user to minimize disruption, avoid impact with retraining and to begin using the new GM EPC immediately upon the user performing a normal monthly update.
• Approach:
• Deliver a solution that will enable GM to be the number one parts catalog provider across all OEMs in all regions of the world. This rating is ultimately determined by the end users dealers of the parts catalog. The primary goal is to sell more parts starting with improving the end user experience.

Responsibilities:

• Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Developed interfaces, packages, scenarios and Load Plans in ODI.
• Performance tuning of PL/SQL procedures and SQL queries.
• Defining checklists for coding, testing deliverables.
• Developing the High Level Design for the enhancements.
• Coding in PL/SQL and Shell Scripting.
• Coordinating with SP/DBA for environment related issues.
• Review of Test Cases and System Testing.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Job Scheduling using ODI and CRONTAB.

Environment: Windows 7 Pro, Oracle 11g/10g, Pl/SQL, ODI, Oracle Apex 4.1, SQL Loader, UNIX shell scripting, Oracle SQL Developer, PL/SQL Developer, AccuRev, CRON Scheduler.

Confidential

Programmer Analyst.

Third Party Provisioning System TPP is Comcast's automated solution to provision Telephony customers in accordance with the regulatory requirements by managing all pre-provisioning activities and third party provisioning tasks.

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Performance tuning of PL/SQL procedures and SQL queries.
• Defining checklists for coding, testing deliverables.
• Developing the High Level Design for the enhancements.
• Coding in PL/SQL and Shell Scripting.
• Coordinating with SP/DBA for environment related issues.
• Review of Test Cases and System Testing.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Job Scheduling using UC4

Environment: Windows XP Pro, Oracle 11g/10g, Pl/SQL, SQL Loader, UNIX shell scripting, Explain Plan, TKProf, Oracle SQL Developer, PL/SQL Developer, SVN, UC4 Scheduler.

Confidential

Oracle PL/SQL Developer

• Flextronics is a leader in Electronics Manufacturing Services. This Project is designed for managing the Inventory, as it is a primary source.
• MDSS stands for Material Decision Support System. A highly intelligence system which manages the inventory for the entire Flextronics. This Inventory is managed by the Materials and Procurements Team, which in turn manages the sites. There are about 6000 concurrent users, who use this application worldwide.
• This Application has PL/SQL Web Reports which are purely built on PL/SQL and java script.

Responsibilities:

• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.
• Did thorough analysis of the requirements and prepared the detailed analysis reports and estimations for work requests.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Developed various Complex Queries, Views for Generating Reports.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.
• Developed Test Plans and participate in unit testing, system testing, thru production implementation.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Written Shell Scripts for automation of some daily tasks which were scheduled in Tivoli.
• Creating new jobs in Tivoli and scheduling them as per Business requirements.
• Loading data from flat files into database tables using SQL Loader.
• Did the database export/import activities for core data.
• Effective Interaction with Support and other Application groups through on call for high priority issues
• Analysis of customer reported issues, which could be a code issue, data fix issue, performance issue, setup issue, functional issue or an RDBMS issue.

Environment: Windows XP Pro, Oracle 10g/9i, Pl/SQL, SQL Loader, UNIX shell scripting, Explain Plan, TKProf, Oracle SQL Developer, Toad, Tivoli, Javascript, Clear Case, Clear Quest.

Confidential

Oracle PL/SQL Developer

• The goal of the NPF Daily Export is to send a file of adds and changes of the Provider Demographic, Contracts, Filed Fees and State Fee data to DDPA and post these updates to DDPA's NPF System of Record SOR successfully.
• The NPF Daily Export will run 5 days a week, and will extract all updates made to the Demographic, Contracts, Filed Fees and State Fees in MetaVance since the last Export run to create add/change/delete transactions in the NPF format. These transactions will be sent to DDPA after the NPF Daily Export extract is run. DDPA will apply these updates to the NPF database and will generate: updates to the NPF Consumer Copy on the DDC PROD Unix Server via Oracle Streams, a file of rejected transactions to create error reports used for problem analysis and resolution.

Responsibilities:

• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Written Procedures to Load Data into data warehouse system from Staging Tables.
• Written Shell Scripts, control files to load data into staging tables and DW tables.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Experience in E-R data modeling using Toad data modeling tool.
• Prepared final design documents and general instruction to follow during development.
• Loading data from flat files into database tables using SQL Loader.
• Expertise in UNIX environment and shell scripting. Excellent knowledge in Batch Jobs using UNIX CRON, AWK UNIX Shell Script csh, bash, ksh and APIs Using PERL Scripts.
• Fine tuned the SQL queries using Explain Plan and applying appropriate hints and indexes.
• Did thorough analysis of the requirements and prepared the detailed analysis reports and estimations for work requests.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Did the database export/import activities for core data.
• Did the Check-out/Check-in process version control , Baseline creation using IBM Clear Case and used IBM Clear Quest for Defect tracking.

Environment: Windows XP Pro, Oracle 10g/9i, Pl/SQL, SQL Loader, UNIX shell scripting, Explain Plan, TKProf, Toad, Tidal, Clear Case, Clear Quest, Ultra edit.

Confidential

Oracle PL/SQL Developer

• Export validation process will be run on UNIX to validate the export files received from mainframe against replicated database and generate validated output file. File transfer will be initiated from mainframe. Input file checking batch will run at specific time to look for the file and will launch validation batch upon receipt of input files. Batch will also move all files to archive folder and will purge archived files that are older than 30 days.
• Export validation applies on different record types like Tax identification, Business identification, Service Office Location, Provider and Filed Fee etc.

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Translating business rules into procedures, packages, database triggers and functions using PL/SQL.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.
• Developed Test Plans and participate in unit testing, system testing, thru production implementation.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Data from Flat Files been uploaded into Staging Tables using SQL Loader.
• Written Shell Scripts for automation of some daily tasks which were scheduled in Autosys.
• Did the Check-out/Check-in process version control using IBM Clear Case and used Clear Quest for Bug tracking.

Environment: Windows XP Pro, Oracle 10g/9i, SQL, Pl/SQL, Pro C/C , SQL Loader, UNIX, Explain Plan, TKProf, Toad, Tidal, Clear Case, Clear Quest, Edit plus.

Confidential

Oracle PL/SQL Developer

• The main processes constitute the highest level in the business function hierarchy of System ESS, Which includes customer order process management, reservation, priority and backorder management, Credit assessment and Credit check management, Production restrictions and customer eligibility management, Production alternatives management, Hold management, Kit/assembly management, Broker and commission management.
• The System ESS has many Inbound and Outbound interfaces, Which are using to interface data from System ESS PO, Customer, Vendor price, Sales order etc. to other Systems like OF, OPM, Gemms, Fujitso Oracle Apps and from Other's System to System ESS.

Responsibilities:

• Developed packages, Stored Procedures and Stored Functions using Toad and SQL Plus.
• Written many database triggers for automatic updating the tables.
• Used EXPLAIN PLAN, ANALYZE, HINTS, TK-Prof and SQL Trace to tune queries for better performance and also Extensive Usage of Indexes.
• Developed PL/SQL programs to dump the data from staging tables into Base Table.
• Wrote SQL scripts to create staging tables and developed SQL Loader control files to load the data from data files into the staging tables.
• Optimizing database objects and streamlining applications. Managed job scheduling using Autosys.
• Performed certain DBA duties like creating table spaces, creating primary objects, creating users and giving grant options.
• As a member of a large Technical Team supporting various applications of GE business Network, My team was responsible for supporting an application called System ESS. This is application has been designed in PL-Trim and is a combination of complex Unix shell scripting and PL/SQL
• Responsible for monitoring and trouble shooting various EDI Electronic Data Interchange Interfaces, Which involves debugging various script routines and finding the root cause of failure
• Did thorough analysis of the requirements and prepared the detailed analysis reports and estimations for work requests.
• As the application System ESS is closely knitted with various other applications like Oracle finance, Scheduler, Gemms etc., my responsibility involved complex technical discussion with other team members serving various other applications in order to find minimal solution
• Production Support in System ESS Application for Interfaces, EDIs and Outage issues.
• As the Application System ESS is a critical zone service 24X7 , it required our team to be at High availability.
• Tuning SQL queries used in the applications to improve performance.
• Did the Support activities like Night batch monitoring, Autosys job monitoring, Batch processing, Application Health Checkup, Normal/business Critical Case solving, Workflow Case solving, Month/Year end issue solving.
• Prepared status reports and attended status meetings on a weekly basis to understand the resource utilization and assignments progress.
• User support for the data warehouse issues like Business Object's reports and data extraction and validation.

Environment: Oracle 10g/9i, SQL, PL/SQL, PL-Trim, SQL Loader, Toad, Explain Plan, TKProf, Windows NT/2000, UNIX Sun Solaris Shell Scripting, Autosys, VSS.

Confidential

Oracle PL/SQL Developer

The Project is aimed to build mediation system for British Telecom. The mediation system collects raw CDRs from 21CN Ericsson Soft switch and performs validation, filtering, parsing, enrichment and routing to the downstream systems then transforms the data to the required downstream format. The downstream format is the GENEVA billing system, data integrity checking system CDRA.

Responsibilities:

• Coding of Application Program from the Technical specifications using DSD Scripting.
• Experience on Openet's FusionWork mediation system and involved in FusionWork's installation, setups and production deployment.
• Did the coding and deployment for Ericsson and Marconi switches Network elements using DSD scripting.
• Creation of database objects like views, procedures, packages using Oracle tools like SQL Plus and Toad.
• Worked in creation of Views and Synonyms for hiding the actual Tables.
• Extensively worked in writing SQL Queries Sub queries, Join conditions and correlated sub queries ,
• Wrote Stored Procedures, Functions, Packages etc. in SQL Plus.
• Wrote many database triggers for automatic updating of the tables.
• Created indexes on tables and Optimizing Stored procedure queries.
• Created SQL scripts to load data from flat files into new tables using SQL Loader.
• Used SQL Trace and Explain Plan to Speed up the SQL Statements.
• Created UNIX shell scripts to automate data loading, extraction and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Provided support for database security issues in creating profiles and users.
• Directly interacted with the End Users and implemented the changes in application as per user reviews and requests.
• Participated in the sign-offs and production-deployment process.

Environment: Oracle 10g/9i, PL/SQL, Toad, Explain Plan, TKProf, Windows NT/2000, UNIX Sun Solaris Shell Scripting, CRON, Fusion Works mediation.

Confidential

Oracle PL/SQL Developer

• The Billing Automatic Configuration Environment will fulfill the strategic requirement of bringing automated portfolio configuration to the Billing and Payments platform. The interface will accept messages that detail product and pricing configurations from external systems and will create the required model on the billing system to represent the products and charges. BACE interface will consists of following main components:
• MQ Reader: External system will put the message in the MQ and MQ Reader process real time will read the queue and load the message into the work unit control table.
• Validator: This real time process will read the messages from the work unit control table and validate the messages and accordingly update the work unit instance control table.
• Parser: This batch process will read all the validated messages from the work unit control and convert them into the set of the API calls.
• Loader: This process will extract the information if required from the GENEVA database and make the API calls and updates billing entities information in the Geneva Database.

Responsibilities:

• Worked in System Analysis, Design, Coding, Testing, Development, Documentation and Production Support.
• Closely worked with users to understand the business and to develop the requirements specifications into technical specifications document.
• Wrote and modified stored procedures, stand alone functions and PL/SQL packages to comply with the requirements.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Wrote SQL Scripts to create, alter, and drop database objects, like tables, views, and sequences.
• Written Shell Scripts for automation of some daily tasks.
• Worked on CVS repository, a tool used by Alltel to store scripts for future use in different versions.
• Created User Training documents for end users. So that when they use application they can refer the document.
• Tested the application to ensure proper functionality, data accuracy, and that modifications have no adverse Impact on integrated system environment.
• Tuning SQL queries used in the applications to improve performance.

Environment: Oracle 10g/9i, PL/SQL, Java, XML, SQL Loader, Toad, Explain Plan, TKProf, Windows NT/2000, UNIX Sun Solaris Shell Scripting, CRON, CVS, Edit plus.

Confidential

Oracle Pro C/PL-SQL Developer

• The Mutual Fund Registration Transfer R T System is a system to Help Citibank personnel from the Investor Service Centers and centralized back office to efficiently manage large volumes of mutual fund transactions on behalf of its customers who are Asset Management Companies AMC .
• Systematic Investment Plan:
• Under SIP, The investor contracts to keep investing a fixed sum periodically thereby enabling savings in a disciplined and phased manner. The mode of investment could be through direct debit to the investor's salary or bank account. The SIP is available only for certain fund schemes-the systems maintain a list of these eligible schemes in the General parameter master. Each fund type has a minimum amount for each periodic investment as well as a minimum number of installments. Investment can be made monthly, quarterly, half yearly or annually. The SIP booking takes place from the web based front-end and is executed on fixed dates in a month. The SIP Execution program inserts record into SIP booking table. The SIP execution program picks up the eligible SIP and inserts record into Transaction table. Only after the execution of SIP, the allocation program considers the SIP amount for allocation. The inputs for SIP allocation will be taken from the same as mentioned in the allocation for subscription and are taken from the Transaction master. The NAV selection, POP, Unit price and allocated units computation will be same as that of allocation for subscription. But the Entry load for SIP will picked from slab master table.

Responsibilities:

• Used the Dynamic SQL to create the text file for reading and writing purpose in PL/SQL.
• Created temporary table for report writing using Dynamic SQL.
• Designed the report layout and design documents.
• Experienced on fundamentals of the investment management, such as Securities, Financial Instruments Stocks, Bonds, Mutual funds and Derivatives .
• Analyzed business requirements and created Technical specifications.
• Coding of Application Program from the Specifications using Oracle Pro C and PL/SQL.
• Involved in EOD End of the Day support issues.
• Wrote Procedures, functions, triggers and packages for new requirements.
• Wrote SQL Queries for data validation, extraction and loading.
• Developed Test Plans and participate in unit testing, system testing, thru production implementation.

Environment: Oracle 10g/9i, SQL, PL/SQL, Pro C, SQL Loader, Toad, Explain Plan, TKProf, Windows NT/2000, UNIX Sun Solaris Shell Scripting, SQL Navigator, CRON, VSS.

Confidential

Oracle Pro C/PL-SQL Developer

• This project deals with the processing of the merchant applications and maintenance of all the details pertaining to a merchant. Accordingly merchant administration module can be broadly classified into three sub modules.
• Merchant information maintenance handles the maintenance of the master details, which includes the address details, account level details, etc.
• Merchant terminal maintenance handles the maintenance of all the details of the terminals that merchant is having at his outlet.
• Transaction discount maintenance handles the maintenance of the commission details that a merchant is supposed to give to the bank for the transactions at the outlet.

Responsibilities:

• Coded stored procedure to implement a variety of data manipulation and query routines using SQL, PL/SQL and Pro C.
• For insertion, deletion and updating at form level the stored procedure and function are grouped in form of package from better performance.
• Coded database triggers for data manipulation as well as to maintain the security and referential integrity.
• Involved in loading the data into staging tables using SQL Loader.
• Created Views to fulfill the requirement of Reports and Forms.
• Creating and Dropping Table through Dynamic SQL.
• Responsible for Unit testing.

Environment: Oracle 9i, SQL, PL/SQL, Pro C, SQL Loader, Toad, Explain Plan, TKProf, Windows NT/2000, UNIX Sun Solaris Shell Scripting, VSS.