PROFILE:

• 8 years of total IT Experience
• 8 years of Oracle Database Experience
• 8 Years of PL/SQL Experience
• Strong Experience with Forms and Reports

SUMMARY:

• 8 years of experience in Oracle 11g/10g/9i/8i ,PL/SQL, Oracle Forms 6i, Oracle Reports 6i, TOAD, PVCS, VSS, Java Script, VB Script, HTML
• 8 years of Oracle Development experience including analysis, modeling, design, administration and maintenance of Oracle Database systems on both UNIX and NT platforms.
• 8 years of solid experience in Oracle Database Programming using PL/SQL, SQL, MS SQL, Oracle Forms 5.0/6i and Reports 6i/3/2.5, Database Design (both Physical and Logical), Database Modeling (Designer 2000), Data Mapping, Cleansing, Transformations, Data Exports & Imports, Application Support, Performance Tuning, Resource Management, Software Maintenance, User & Security Management, Oracle Tuning & Optimization.
• Strong work experience in Oracle Database (10g/9i/8i). SQL, PL/SQL, Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, Inline Views, Export/Import Utilities.
• 5 years of strong experience using Developer 2000, Reports 6i, HTML, Oracle 8i/8.0, MS SQL Server 7.0/2000, MS Access 7.0, DB2, Windows 2000, Windows NT 4.0, Windows 98/95
• Exposure in using CASE tools like TOAD, SQL Navigator for writing PL/SQL programs
• Tuning of SQL Queries to improve performance of a system. Identify root causes and resolve problems related to system functionality. Experience in numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, Testing and Implementation.
• More than 3 years experience in developing reports using Crystal Reports 8 / 9 and used SQL Server 2000 and 2005 as Backend
• Around 3 years of experience in VB 6.0, ASP 3.0 in developing / maintaining web/desktop applications
• Expertise in analyzing business requirements and converting business requirement into code
• Extensive knowledge of creating Business Requirement and Technical Document
• Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production support on various platforms like UNIX, Windows NT/2000/XP/98.
• Worked on Financial modules like AP, GL, AR modules in a product called Orion and developing various reports for this product feature
• Experience in development, working with Data Migration, Data Conversion and Extraction/Transformation/Loading using client specific tool with Oracle.
• Written technical design documentation (e.g. data flow diagrams, mapping documents, etc) for application maintenance
• Exceptional experience in dealing with various databases like Oracle, DB2, SQL Server, MS Access, and Flat files.
• Excellent communication and interpersonal skills. Ability to work effectively as a team member and individually.

Education:
• Bachelors in Engineering.

Technical Skills:

Data Base:

Oracle 11g/10g/9i/8i/, SQL Server 2000/2005, PL/SQL , MS-Access

Operating systems:

Windows 2000/NT/XP and MS-DOS

Programming Languages:

PL/SQL, HTML, Visual Basic 6.0 (VB), ASP 3.0

GUI Tools:

Developer 2000 (Oracle Forms 6i), MS Front Page,

Reporting Tools:

Oracle Reports 6i, Crystal Reports 8.5 / 9, Business Objects XI R2/R3 (BOXI), Infoview, Web Intelligence

Front End Tools:

TOAD

Other Utilities:

ODBC, UNIX Shell Scripting, PVCS, VSS, BMC Remedy, Change Management, Redgate SQL Compare and integrator, MS-Office 2000 / 2003 (Word / Excel / Powerpoint)

PROFESSIONAL EXPERIENCE:

Confidential,IL Jun’10 – Current
Senior Oracle PL/SQL Developer

Confidential,is a regional bank headquartered in Key Tower within Cleveland, Ohio\'s Public Square. As of 2007, it is the 16th largest bank in the United States based on total deposits.

Responsibilities:

• Responsible for systems analysis, development enhancement, maintenance and support of Oracle based Oracle / VB based application
• Used Packages and Stored Procedures in different types of modules
• Involved in migrating database from Oracle 8i to Oracle 11g
• Studying current application and preparing the case study document for migration part
• Created COM+ module for accessing different DBs
• Handling new enhancements like developing new forms in VB 6.0 and creating backend tables and packages in Oracle 10g corresponding to the front end coding
• A middle layer DLL for connecting to Oracle database was removed and replaced with front end coding for the same.
• Documented all the details discussed in team meetings and circulated amongst the team members through email.
• Made use of TOAD as an editor to handle with backend database.
• Used MS-Project to maintain the schedule of deliverables
• Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique that makes the applications more flexible and versatile.

Environment: Oracle 11g/10g, PL/SQL, TOAD, Java Script, HTML, VSS, Visual Basic 6.0, VB Script, COM+

Confidential,MI May’09 – Apr’10
Software Oracle PL/SQL Developer

Confidential,is a leading global automotive supplier that designs, engineers and manufactures innovative climate, interior, electronic and lighting. The company formed in 1997 and spun off from the Ford Motor Company in 2000. In 2005, Visteon moved to new headquarters in Van Buren Township, Michigan. Visteon is to the Ford Motor Company as Delphi is to General Motors and Denso is to Toyota. I worked in enhancement and maintenance of the existing enterProj (PMO tool). EnterProj is a tool that Visteon uses for the project management for all the manufacturing projects and IT projects across all Visteon plants and Offices. Various enhancement requests and maintenance issues were handled as per the requirements in co-operation with the corporate office (home office) in US.

Responsibilities:

• Used PL/SQL Developer as an editor for oracle database interaction
• Learnt the PMO tool effectively within a short period of time.
• Handled many admin tasks having the administrator role within enterProj like changing ownership of projects, giving user access, security roles, etc,.
• Handled modifications in stored procedures, packages, and functions, at the backend and also in PL/SQL coding both at backend and front end.
• Oracle 10g/9i/8i, Forms 6, Reports 6, PL/SQL, TOAD, Java Script, HTML, SQL Server 2000, PVCS, Business Objects X1 R2, MS-Excel 2003 (VLookup, HLookup, MATCH, IF, PIVOT Table), MS-Access 2003, MS-Word 2003, Adobe Acrobat 9.0, DB2, MS-Project
• Created many procedures in SQL 2000 and DTS / Jobs
• Migrated database from SQL 2000 to SQL 2005
• Created SSIS Packages as part of migration activity into SQL 2005 environment
• Used MS Access to import data from Oracle and used MS-ACCESS to solve data issues quickly and effectively
• Used HTML, JavaScript and embedded PL/SQL coding within those languages.
• Involved in unit testing and integration testing for all the self made changes.
• Involved in resolving issues present in the product by analyzing the cause of the issue and solving the same.
• Created a new functionality eFIN routing which would generate automatic emails to users when a particular eFIN is submitted, approved or rejected. EFIN is the tool that handles the financial implications within enterProj.
• Made use of TOAD as an editor to handle with backend database.
• Handling time reporting, metrics analysis and weekly and monthly updates of team members in KBC, India.
• Co-ordinating client interaction with Offshore Team members
• Lead a team of 7 people to manage this project effectively and got many accolade from Client
• Using MS Excel, created Pivot table to show metric data as a report to the management
• Implement Support Processes for BO Application Support
• Scheduling and re-running BOXI reports, if it is failed
• Responsible for analyzing business requirements and developing queries and reports using BOXI to provide Web-enabled data analysis solutions to business clients.
• Created the Crystal reports using Oracle tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system
• Used BMC remedy to accept on call tickets and created change records using CM Tool for all application level changes

Environment: Oracle 10g/9i/8i, Forms 6, Reports 6, PL/SQL, TOAD, Java Script, HTML, PVCS, MS-Access 2003, MS-Excel, MS-Project, Crystal Reports 9, Business Objects XI R2/R3, Windows 2003/ Vista environment, BMC Remedy

Confidential,WI Mar’07 – Mar‘08
Senior Oracle Developer

Enhancement and maintenance of the existing ERP product especially in manufacturing module was the core objective of this project. New enhancements for easier user interface and for the various requirements of the clients were handled. I was one of the team members and lead two team members for this enhancement and maintenance phase of the project

Responsibilities:

• Involved in resolving issues present in the product by analyzing the cause of the issue and solving the same.
• Involved in allocation of work and verification of program specifications done by fellow team members.
• Handled modifications in stored procedures, functions, packages, tables, views at the backend and also in PL/SQL coding both at backend and front end.
• Involved in unit testing for all the self made changes made respectively in our team.
• Involved in preparing documents for program change specification and program specification for the various changes that need to be done in the existing ERP Product.
• Used HTML and java script for coding at the front end for web applications and forms 6i and reports 6i for desktop applications.
• Created many database structures like tables, sequences and procedures as per the requirement for solving the issues and also for new enhancements.
• Was leading a team of two members and made a code review for their coding and documented.
• Documented all the details discussed in team meetings and circulated amongst the team members through email.
• Made use of TOAD as an editor to handle with backend database.
• Used MS-Project to maintain the schedule of deliverables
• Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique that makes the applications more flexible and versatile.
• Migrated data from DB2 to SQL Server 2000

Environment: Oracle 9i/8i, Forms 6, Reports 6, PL/SQL, TOAD, Java Script, HTML, SQL Server 2000, PVCS, Crystal Reports 9, MS-Excel, MS-Access 2003, MS-Word 2003, Adobe Acrobat 9.0, DB2, MS-Project

Confidential,MN Feb’06 - Dec’06
Software Engineer

Orion 10.5(ERP Product)
Mainly working in product development and enhancement for this product, used all over the globe. All the requirements from various geographies were collected together to prepare the requirement document from the product management group. All these form the roadmap for the next development version for the product. I was one of the key members for the development phase for the version 10.5 of the product in the Module GL/AR/AP and Budget Module. From this version onwards the GL/AR/AP shall be given separately to the customer so that it can be integrated with any ERP of Purchase, Sales or Inventory Modules. This project was a development for the new version of the product and was not specific to a client.

Responsibilities:

• Involved in gathering customer specification and their requirements from the design team
• Analyzing the business requirement and to enable to fit to the product as a technical requirement.
• Involved in writing SQL scripts for SQL reports that has to be developed as a basis in the product.
• Involved in system testing User Acceptance testing.
• Created and managed tables, established relationships between tables, created constraints.
• Created database objects including tables, views, indexes, Stored Procedures, Functions etc.
• Handled modifications in packages, stored procedures and functions for the new enhancement to be made.
• Created three new forms for querying Account Receivable /Accounts Payable module and a budget copy form in budget module.
• Created two reports for tax submission and the corresponding interface forms.
• Customization done for two other forms in Payments and Receipts.
• Initiated and involved in many team building activities.
• Created many documents (URD, Design Document, Technical Specification, and Unit Test Cases) and maintaining through PVCS.
• Involved in UTC preparation / System Testing / Integration testing
• Involved in Database design for the new development in database for the requirement of the project
• Created Business Requirements and converted them into System Requirement Specifications, technical and functional requirements

Environment: Oracle 9i/8i Forms 6, Reports 6, PL/SQL, TOAD, TOAD, PVCS, MS Office, Windows 2003 Server.

Confidential,MN May’05-Jan’06
Software Engineer

Fixed Asset Maintenance

Responsibilities:

• Mainly involved in fixing issues that were logged by the Quality testing department.
• Involved in creating two new forms for the new requirements of the customer. Made the new screen for the negative cost adjustment in constant discussions with the design team and Quality assurance people and the product management group for providing a user friendly environment for the client.
• Was involved in creating software requirement specification for the new enhancements to be brought in.
• Customized many other forms for this module as per the call logged by the quality team.
• Well versed in writing complex SQL queries using TOAD as a tool
• PL/SQL programming including triggers, procedures and packages.
• Established relationships between tables; created constraints.
• Created database objects including tables, views, indexes etc. as required.
• Developed new reports using Parameter, Sub Total & Grand Total.
• Involved in Application Design, Database design, Coding, Testing & Implementation.
• Involved in UTC preparation / System Testing / Integration testing
• Prepared Proposals, Project Plans, Requirements Documents, Road maps, Change Orders, etc.
• Interacted with Business Users and Business Owners to know their Business views in developing and modifying Universes and Reports accordingly.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Involved in Performance tuning of PL/SQL Queries

Environment: Oracle 9i/8i Forms 6, Reports 6, PL/SQL, TOAD, TOAD, PVCS, MS Office, Server 2000, Windows NT/XP.

Confidential,MN Jul’04 – May’05
Software Engineer

Auto Sales (ERP Product)
Confidential,was one of 3I clients for the Job contracting Module. Certain enhancements and requirements for this client as specified by the Product Management group were carried out. This was a pure customization project to meet the client’s requirement in addition to the feature available in the existing product. Enhancements and customizations in the auto sales part of the ERP product called ORION. Changes were made in all screens depending on the client needs and specifications. This project is based on the job processing for the auto service company. The flow for the job processing was also changed as per the customer’s requirements and the vehicles given for the service.

Responsibilities:

• Interacted with users to gather the new requirements and working with existing issues
• Involved in gathering customer specification and their requirements from the design team and from the customer.
• Analyzing the business requirement and to enable to fit to the product as a technical requirement.
• Responsible in preparation of prototype and the SRS for the customer requirement.
• Was involved in creating 2 forms for this client and customization in four other forms.
• Involved in system testing, User Acceptance testing.
• PL/SQL programming including triggers, procedures and packages.
• A key member in system testing at the end of the project
• Generated number of reports on a daily, weekly and monthly basis using Oracle Reports
• Evaluated and validated existing metrics.

Environment: Oracle 9i/8i, Forms 6, Reports 6, PL/SQL, TOAD, TOAD, PVCS

Confidential,CO Jul’03 - Jun’04
Oracle Developer

Pay Star DF (Product)
Confidential,is a product focused on Staffing specific back office. It is a client server application built using PL/SQL, Oracle 8i, SQL, Developer 2000 (Oracle forms and Reports), Visual Basic 6.0, ASP, SQL Server 2000 & Crystal Reports. It takes care of Registering Persons, Customers, Order, Timecard, Invoices, Payments, Tax Items, Payroll, Billing and Year End Processing.

Responsibilities:

• Involved in creating forms and reports for Consultant registration, customer maintenance, job order and invoice modules.
• Involved in developing, testing, compiling, debugging and maintaining the data using Oracle 8i, SQL.
• Created many Forms for registering a consultant, his personal details, his past work experience, his skill sets and his expectation with the client and all other miscellaneous details.
• A query screen was also developed to find a consultant with some specific skill set or a specific location as desired by the client.
• Was involved in creating many forms for customer details maintenance, the contact person, the skill set required, previous order history, kind of industry, location, head office, branches, preferences and other details.
• Involved in developing a query screen and a report for finding a suitable customer for a consultant depending on his preferences.
• Involved developing a separate module in ASP, Java Script, SQL Server 2000 for tax calculations for yearend processing
• Created Stored Procedures, Functions, DTS Packages in SQL Server 2000
• Was also involved in developing Timecard maintenance, Job Order screen, Invoice screen
• Effectively handled design and construction of invoice and order forms.

Environment: Oracle PL/SQL, SQL, Developer 2000(Forms and Reports), Oracle 8i, TOAD, PVCS, VB 6.0, ASP 3.0, SQL Server 2000, Java Script, Crystal Reports 8.5, MS-Office

Confidential,India Jul’02 - May’03
Oracle Developer

Pay Star DF (Product)
Confidential,is a product focused on Staffing specific back office Product. It is a n-tier application built using PL/SQL, Oracle 8i, SQL, Developer 2000 (Oracle forms and Reports), Visual Basic 6.0, ASP, SQL Server 2000 & Crystal Reports. It takes care of Registering Persons, Customers, Order, Timecard, Invoices, Payments, Tax Items, Payroll, Billing and Year End Processing.

Responsibilities:

• Started using PL/SQL, Oracle, Developer 2000 and Reports 6i
• Involved in creating forms and reports for Consultant registration, customer maintenance, job order and invoice modules.
• Involved in developing, testing, compiling, debugging and maintaining the data using Oracle 8i, SQL.
• Created many Forms for registering a consultant, his personal details, his past work experience, his skill sets and his expectation with the client and all other miscellaneous details.
• Involved in developing a query screen and a report for finding a suitable customer for a consultant depending on his preferences.
• Involved developing a separate module in ASP, Java Script, SQL Server 2000 for tax calculations for yearend processing
• Created Stored Procedures, Functions, DTS Packages in SQL Server 2000

Environment: Oracle PL/SQL, SQL, Developer 2000(Forms and Reports), Oracle 8i, TOAD, PVCS, VB 6.0, ASP 3.0, SQL Server 2000, Java Script, Crystal Reports 8.5, MS-Office