Summary:

• Around 8 years of professional experience in analysis, design, development, testing and implementation as an Oracle PL/SQL Developer.
• Excellent knowledge in Software Development Life Cycle SDLC Metrics that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• Excellent communication skills and ability to work individually and as a member of a team.
• Experience in Business Objects, WebI reports Universe designing in BO XI r2/r3/r4/r5 using Oracle paradigms.
• Good knowledge of Hadoop and BigData concepts and paradigms.
• Programming experience in Visual Basic 6.0, Oracle 11i/10g/9i/8i, SQL, PL/SQL and MS Access.
• Worked as a value added resource in a creative/diverse environment for developing or maintaining complex, multi-tier, business applications using Visual Basic 6.0 and Oracle PL/SQL.
• Experienced in writing complex Queries in SQL Plus.
• Deep knowledge of the full array of Visual Basic 6.0 programming techniques used to create, design, and implement forms.
• Thorough knowledge of data manipulation through ODBC databases.
• Rich Experience in developing Oracle PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Exception Handling and Oracle Reports.
• Experience in generating various reports in Oracle and Crystal Repots.
• Good at using tools such as SQL Navigator, TOAD and SQL Plus.
• Good knowledge of the Oracle paradigms like SQL Loader, Oracle External tables.
• Conceptual knowledge of creating and modifying simple UNIX Shell Scripts.
• Good knowledge and practice of UML concepts.
• Actively coordinated with Quality Team and User Acceptance Testing UAT .
• First-Point-Of-Contact Technical Team Lead for offshore team in Australian Technical Support Development project.

Technical Skills

Professional Experience:

Confidential

Environment: Oracle 10g/11g, SQL, PL/SQL, BO XIr2, DocForms, HP Exstream, Visual Basic 6.0, .Net, Discoverer, Toad, Oracle/Excel Reports, Test TrackPro, SCM, Citrix Server, MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point

Project Description: Developing eCrop, application for Hail and Multi Peril Crop Insurance for Farmers Mutual Hail Insurance Co. eCrop is capable of maintaining every detail related to Policies, Insured, Claims, Commission, Payment calculations, Crops and rates, Acreage and Production History and many more. General Ledger module takes care of calculations in every sub module of the system. It also capable of maintaining production and calculations details w/ different options by unit, by acres, by crop etc. It maintains cheque and payment history. It's a vast but self content system handling Crop Insurance process efficiently.

Role: Oracle PL/SQL Developer w/ BO, Build/Release Manager

Responsibility:

• Fixing ISARs Operation Support Tickets as well as New Development requests using VB Oracle programming.
• Designing and developing Excel Reports by developing complicated SQL Queries.
• Created PL/SQL program units to include using Dynamic SQL.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Creating and maintain Oracle programming scripts using Oracle Database Object - includes tables, materialized views, snapshots, external tables.
• Updating company servers and push fixes to Live environment using Citrix as a part of Release.
• Responsible for Builds and weekly production Releases as a Build Manager.
• Writing Oracle PL/SQL scripts as a part of backend programming.
• Design and Development of eCrop application using Visual Basic 6.0 and Oracle PL/SQL.
• Actively involved in developing back-end procedures, functions, and triggers using Toad.
• Working with BO XIr2 Design and development team for designing Universe, creating different reports and UI Interface using web Intelligence.
• Creating Developing for BO reporting using Oracle concepts for End Users.
• Generating Oracle Reports for AdHoc Reporting.
• Involved in the investigation of production problems and bug fixing.
• Involved in Requirement analysis and information gathering w/ BA and Business Users.
• Involved in Unit functionality testing.

Confidential

Environment: Oracle 8i/9i/10g, SQL, PL/SQL, SQL Loader, BO XIr2, Visual Basic 6.0, MS Access, Windows 2003/NT, MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point

Project Description: Confidential is a leader in professional services, providing award-winning food services, facilities management, and uniform and career apparel to health care institutions, universities and school districts, stadiums and arenas, and businesses around the world. INSIGHT is application which maintains all the financial information about their Food and Facilities Management for the units including maintenance, housekeeping, custodial, and/or grounds services, budgeting labor, supplies, equipment and related services/materials required for cost-effective operations. It also takes care of the sub-contracted work under the service agreement. INSIGHT is financial center keeping track of all the Accounts payable and General Ledger for ARAMARK financial year. The project is a Client Server application with BO reporting feature through the newly implemented GUI's in Visual Basic 6.0.

Role: Oracle PL/SQL Developer, Visual Basic 6.0

Responsibility:

• Used SQL for data manipulation and table conversion for database conversion from Access to Oracle.
• Wrote Triggers to check the data format, constraints followed before and after transferring data to master tables.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Wrote Oracle PL/SQL scripts for backend processing.
• Development of 50 user screens including questionnaire screens in INSIGHT application using Visual Basic 6.0.
• Creation of interface for End User reporting.
• Designed and developed Use Cases to describe the process flow and functionality of each module and its sub modules.
• Active part of Design and development team of Universe designing using BO XI r2 web Intelligence.
• Design and development of different forms and user screens in Visual Basic 6.0.
• Generated different Financial and Cost-center Listings reports using BO.
• Coordinated with testing team for functionality testing.
• Developed test scripts to set foundation for the detailed testing of the proposed system.
• Involved in the investigation of production problems and bug fixing.
• QA the result sets and validated with the standard SRS document.

Confidential

Environment: Visual Basic 6.0, Oracle 8i/9i/10g, SQL plus, Oracle Reports, Perl, UNIX, Shell Scripting, HTML, Java Script, SQL Navigator, Putty, IIS, MS Access, VBA, OTRS Open Source Ticket Request System , MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point .

Project Description:

• This is a development and support project. 24/7 Search is the search industry's premium provider of full service integrated search engine marketing SEM and technology for advertisers seeking to maximise return on their search engine marketing investment.
• Decide DNA is the underlying technology that drives all of 24/7 Search SEM services. Using Decide DNA, 24/7 Search implements, measures, and optimizes all forms of search engine traffic, with extensive capabilities in Paid placement, Pain inclusion and Organic listings. DNA provides support for multiple search products e.g. paid listing, paid inclusion, multiple SEs, Organic SEO . It accepts multiple data inputs including structured files, URL crawl, and keywords. It provides intelligent content optimization and active keyword repository. It automates production of SE feeds and listings.

Role: Technical Analyst / Team Lead

Responsibilities:

• Responsible for making decisions on coding standards and documentation.
• Responsible for Analyzing requirements, designing, maintaining and updating data models
• Created and modified shell scripts using VI Editor for running the processes in the background.
• Involved in developing and handling the Oracle PL/SQL Procedures, Packages, Cursors and Database Triggers using SQL Navigator.
• Enhancing OTRS GUI's with Visual Basic 6.0.
• Migrated data from Text file to Oracle database using SQL Loader.
• Used External tables for reading and writing data to external files.
• Generated different reports for tracking OTRS system and different client accounts using Oracle and VB.
• Implemented various shell scripts for scheduling batch jobs, diagnostics and loading process. Maintained the batch processes using Unix Shell Scripts.
• Aids in both the analysis of issue and development of emergency fixes for immediate release.
• Responsible for management and response to all tickets raised via OTRS.
• Actively participated in gathering Business Requirements and System Specification from system users.
• Sometimes involved in functionality testing in DNA application.
• Involved in logging and Validating the defects on Decide DNA application
• Acting as First-Point-Of-Contact and Technical Team Lead for the offshore team.
• Worked as onsite coordinator in Sydney, Australia.
• Handling communications with client to understand business requirements.
• Understanding the business process flow and identification of dimension for the application.

Confidential

Environment: C, C , Oracle 9i, PL/SQL, SQL plus, Oracle Reports, Unix shell scripting, protocols supported by Mercury Load Runner with Virtual User Generator, Controller, Analysis tool, Siebel CRM, MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point

Project Description: This is a Development and Support project. Load Runner is auto - testing tool used for testing the load of the application. With this tool end users can run load tests for the required hours by generating virtual users. The scripts developed in Load Runner are highly technical. These scripts are recorded replayed using Load Runner component VuGen . There are some ways through which Generator can be connected to the Controller. It also makes use of networking concepts.

Role: Oracle PL/SQL Developer / Application Engineer, Tier I

Responsibilities:

• Creating and maintaining Oracle Database Object - includes tables, views, stored procedures etc using PL/SQL
• Optimized the existing scripts by fixing bugs.
• Migrated data from Text file to Oracle database using SQL Loader.
• Generated various Reports in Oracle like performance tracking, enhancement logs, issue details.
• Monitored and modified Unix Shell scripts to for background job processing.
• Modifying shell scripts for scheduling diagnostics.
• Involved in generating and handling scripts using VuGen Virtual User generator .
• Good knowledge of handling Siebel CRM tool.
• Generate load test for end users and providing client support online as well as through email.
• Handling communications with client to understand business requirement.
• Understanding the business process flow and identification of dimension for the application.

Confidential

Project: Software supporting Dynamometer

Environment: MS Visual Basic 6.0, Oracle 9i, PL-SQL, SQL plus, Oracle Reports, MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point , SQL Navigator.

Project Description:

• Actively involved in developing back-end procedures, functions, and triggers using SQL Plus.
• Designed and developed front end/user screens for entering dynamometer related parameters using Visual Basic 6.0
• Involved in maintaining and writing several Oracle PL/SQL Stored procedures and SQL queries for populating tables using PL/SQL.
• This project is developed for controlling Dynamometer's functionality. Dynamometer is used to measure the horsepower output of an engine. A chassis dyno has large rollers upon which the drive wheels are placed. The vehicle is run up to certain speed and put under load so the amount of power that's being delivered to the wheels can be measured. A dyno can also be used to simulate actual driving conditions when troubleshooting various derivability problems. Dynos are also used to simulate driving conditions during certain types of emissions tests.
• Underlying system controls supplied inputs as well as functionality of the dynamometer.
• Role: Software Developer / Consultant Responsibilities:
• Created indexes for retrieving data quickly.
• Involved in report generation using Oracle Reports for checking the supplied Inputs and outputs of dynamometer.
• Investigation of production problems and bug fixing.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Involved in developing user documentation for the application modules.

Confidential

Environment: MS Visual Basic 6.0, VBA, Oracle 9i, SQL Navigator, Java script, HTML, DHTML, PL-SQL, SQL plus, SQL Loader, Forms 6i, MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point

Project Description: This project is developed for Raj Fisheries Pvt Ltd . Online Inter Office Communication Inventory Management System takes care of Inter-Office communication IntraNet , Inventory management Account handling modules. Inventory module keeps track of import export information. It also includes Maintenance of product Specification Requirement analysis of Order. Account module calculates generates Bills.

Role: Software Developer

Responsibilities:

• IOC and IM were developed in Visual Basic 6.0 creating 30 front end user screens.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Used PL/SQL to validate data and to populate Inventory tables.
• Read data from flat files to oracle tables using SQL loader.
• Wrote scripts for creating Views.
• Created indexes to improve the system performance.
• Based on the requirement developed necessary forms and reports.
• Involved in design development of report generation using Oracle.
• Wrote Procedures and Functions using oracle for managing and maintaining inventory.
• Wrote complex SQL queries using joins and sub queries.
• Generated various reports using Oracle VB for checking inventory and billing purpose.
• Coordinated with testing team for testing of Inventory maintenance module.
• Took part in requirement gathering and documentation.
• Involved in Preparing Flowcharts, Sequence diagram, Activity diagram for modular distributed system architecture.

Confidential

Environment: MS Visual Basic 6.0, VBA, Oracle 8i/9i, Java script, HTML, DHTML, PL-SQL, SQL plus, MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point

Project Description: RADS is the primary Rite Aid Pharmacy System. It enables you to review and maintain information about patients, doctors, and drugs. Most importantly, it provides a means for dispensing prescriptions and furnishing Drug Utilization Review information. Additionally it manages secondary claims information and Third Party claim processing for patients who use these services to pay for their prescriptions.

Role: Software Developer

Responsibilities:

• Design and development of 12 -15 user screens with Visual Basic 6.0
• Developed GUI for filling out patient and drug information using Visual Basic 6.0.
• Used PL/SQL to validate data and to populate billing table, patient information table.
• Encapsulated PL/SQL procedures and functions in packages to organize application.
• Wrote Oracle PL/SQL programs for backend processing.
• Developing different billing and inventory screens user screens.
• Created PL/SQL Procedures using Native Dynamic SQL and Cursor Variables.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL.
• Actively involved in developing back-end procedures, functions, packages and triggers.
• Generated various Reports using VB Oracle for generating patient information and invoices.
• Developed user documentation for all the application modules. Also responsible for writing test plan documents and unit testing for the application modules.
• Preparation of Flowcharts and Use case diagrams.
• Modular Architecture design from distributed, scalability and extensibility point of view.

Confidential

Environment: MS Visual Basic 6.0, Oracle8i/9i, PL-SQL, SQL plus, MS Office MS Access, MS Excel, MS Visio, MS Word, MS Power Point

Project Description: Library management System handles all the transactions related to Library. It displays information about the book according to Author name or Book Title. It also includes Availability checking, Issuing and returning of books Fine calculating

Role: Software Developer

Responsibilities:

• Designed 10-15 Front end Screens By Using Visual Basic 6.0
• Worked with designing team for the design and development of user screens using Visual Basic 6.0.
• Developed packages, procedures and functions in Oracle PL/SQL for data loading and data processing.
• Involved in designing the Primary Foreign Key for the objects in the schema.
• Development of Book Issue Return module with fine calculating in Library system.
• Wrote complex SQL queries using joins and sub queries.
• Development and testing of all the required Oracle PL/SQL stored procedures, functions and triggers.
• Generated various reports using Oracle with VB as required.
• Involved with testing team for functionality testing of the application.
• Performed unit testing for the developed module.
• Involved in the initiation and planning phase of the project.
• Involved in creating Functional and Technical requirement documents.
• Preparation of flowcharts and use case diagrams.