Summary:

• Total Experience: 8 years of experience in project management, object oriented software design, Technical Writing, analysis, development implementation of enterprise application system including databases namely Oracle Access
• Working as a Database Developer since 6 years.
• Experience in Oracle Financials modules like AP and AR.
• Experience with Oracle Applications Incentive Compensation module.
• Experience in Technology Infrastructure Services. full project lifecycle experience like requirement gathering, analysis, design, development, testing, implementation, documentation, deployment, client interaction, and end user training of applications.
• Possesses 7 years of e xtensive experience in Oracle database in analysis, design, development, tuning, testing, implementation and administration of applications in Oracle - Unix, SQL-Server/Windows NT environment using Oracle 8/9i/10g/11i, PL/SQL, Erwin 4.1.4, Developer 2000, Forms 9i/6i/6.0/5.0/4.5, Reports 9i/6i/6.0/3.0/2.5, Designer 6i/2000, Oracle Discoverer 9i.
• Extensive experience in Oracle database administration, writing and maintaining backend code Triggers, Procedures, Packages using SQL, PL/SQL and application tuning database backup restore and recovery processes.
• Experience in Software Development life cycle of Software Engineering-Requirements Analysis, Design, development and documentation.
• Led a team of developers and have project leadership experience in Client-Server, OO design.
• Hard working, motivated, and quality focused.
• A quick learner, very fast in grasping new things -worked on different platforms as well as projects of different fields of application.
• Has excellent communications skills and is a good team player.
• Have prepared several Technical Documents for complete SDLC including Process Flows, ER Diagrams

Technical Knowledge:

• RDBMS Tools: Oracle 10g/9i/8i/8.0/7.x.,, SQL Plus, MS Access, PL/SQL, Oracle Financials, Oracle Incentive Compensation, Designer 2000, Developer 2000, Forms 6i/6.0/5.0/4.5, Reports 6i/6.0/3.0/2.5, SQL Loader, VISIO 2003, SQL NAVIGATOR 3.2d11, TOAD 6.5.0.0.
• Internet Tool: HTML, ADOBE ACROBAT
• Java Skills: Java Applets, HTML, Java Script, CSS.
• Languages: C, Fortran 77, and COBOL.
• Other S/W: Dreamweaver MX 2004, FRONTPAGE 2000, MS Office, MS Project.
• O.S: Windows 95/98/2000/XP, Windows NT 4.0, MS-DOS, UNIX SYSTEM Red Hat Linux 6.0 and Sun Solaris and KSH 1.17 .

Experience:

Database Developer

Roles and Responsibilities

• Currently working as Oracle Database Developer for a Students Management System.
• Created and modified ETL Processes using PL/SQL to reduce costs, increase productivity, and drive competitive advantages by managing data.
• Actively involved in maintaining the Students Management System with the admission process, payment plans and strategies of students for the various courses.
• Working as a Developer to automate and process the students registration process and payment plans.
• Working as a Technical Writer for producing Process Flow diagrams and ER Diagrams for the full SDLC.
• Actively involved in maintaining the website for Netcliff.

Confidential Payment Analysis and Reporting System

Roles and Responsibilities

• As a database DBA/Developer/Business Analyst performed the following activities.
• Gathered requirements from the business users related to the Payment and deposit transactions of the customers of Confidential .
• Automated the whole process of payment transactions and analysis depending upon these requirements I had gathered.
• Prepared documents and flow charts for the business flow.
• Ran patches to update the 9i database production server.
• Was involved in the process of conversion of 9i database into 10g database.
• Designed ER diagram using Erwin 4.1.4. Also did the reverse engineering of the existing database using Ervin Data Modeler.
• Involved in database activities like creating/maintaining tablespaces, creating tables, Constraints, Indexes, Partitioning on the tables.
• Involved in tuning the oracle database. Improved the performance of the queries using hints and indexes.
• Loaded data into oracle tables using SQL Loader and using external tables.
• Wrote complex PL/SQL procedures to modify the data loaded using SQL Loader Post scripts
• Wrote several shell scripts to automate the process of loading data into oracle tables.
• Documented the process flow using Visio 2003 and Erwin.
• Developed the reports using Hyperion reporting tools.
• Developed reports using Oracle Financials 11i AP AR modules.
• Responsible for production turnover.

Environment: WINDOWS NT/2000, Unix, Oracle 10g/9i, Financials 11i AP AR modules, PL/SQL, Microsoft Office Visio Professional 01.6408, Rational ClearCase ExplorerVersion: 2002.05.00, Rational ClearCase HomeBase WRQ Reflection, AllFusion ERwin Data Modeler 4.1.4, TOAD 8.5.3.2, Hyperion Intelligence Dashboard Builder, Hyperion Intelligence Designer

Confidential

Senior Oracle developer

Roles and Responsibilities

• Worked on a SWISS Reporting system as a Database Developer/Business Analyst.
• The SWISS Reporting System uses task and job data in the SWISS system to build data that will enable utilization.
• Was main lead in ghosting/gathering requirements at Confidential from the business users.
• The complete workflow system was on hard papers. I was a technical team lead for the team automating this workflow.
• Also prepared documents/flow charts/notes related to this workflow system.
• Also worked on Reporting and forcasting. This system is made up of tables, views, sequences and stored procedures. A number of SQL Scripts can be executed to build and maintain this environment.
• Developed a Schwab Workflow Information System Strategy SWISS that develops and maintains a Workflow system. It is a system that maintains the flow of jobs, Tasks and Task Elements.
• Designed documents for the Swiss reporting system, which includes designing specs, unit test plan.
• The Task table contains the tasks for all jobs at the most granular level, referred here to as a Task element. Each time the Status of a task changes, a new task element is created in the task table. The time elapsed in processing a task is also calculated using PL/SQL package. Designed Complex procedures using PL/SQL.
• Developed Crystal Reports for all of the task elements those can be attributed to a user are listed chronologically.
• Crystal Reports were also developed to capture The Task Volumes, Task Timings per org id.
• Generated Explain Plain for SQL queries to improve performance tuning.
• Used Oracle Discoverer 9i for administration purposes.

Environment: Windows XP Professional/2000/NT4.0 SP1, Oracle 9.2.0.3.0 Enterprise Edition, Oracle Discoverer 9i, Microsoft Office 2003Crystal Reports 10.0.5.628, SQL Navigator 4.3.1.460, Unix Korn Shell 1.17

Confidential

Senior Oracle Applications Developer/Technical Team lead

Roles and Responsibilities

• Developed A Deferred Revenue system that satisfies following purposes at 24 Hour Fitness.
• I developed PL/SQL code to generate a report containing information about the contracts extended Confidential their original prepaid end dates.
• I used Oracle Applications Incentive Compensation module application to access the contract details as well as pricing and effective end dates for different contracts on Service and Prepaid lines.
• I am also involved in SQL tuning the performance of queries using Explain Plan.
• For most invoice items, 24HourFitness recognizes revenue in a way not supported by standard Oracle AR. For these items, the receipt amount was recognized as revenue in monthly installments over a scheduled period. These distributions are in addition to the standard AutoAccounting distributions that follow AR events. Accounts Receivable are setup with Accrual Basis accounting and the Immediate Accounting Rule will be assigned to invoices by default.
• Additional offsetting distributions are generated for most receipts and reversals, not just for items that are subject to revenue deferral. The new distributions offset specialized distributions made earlier in the receipt cycle to satisfy the unique requirements of 24HourFitness.
• A pair of DFF's, Revenue Account and Revenue Sub Account, identify the GL accounts for invoice items which require offsetting distributions.
• A lookup table identifies the GL accounts for deferral and recognition. This table is keyed by item and qualified by contract type and dues level as needed.
• This extension implements a custom table, the Deferred Revenue Schedule DRS, designed to control the generation of distributions, over time. It contains all the data needed to generate the distributions, and includes timing information to determine when the distribution should be generated.
• I am involved in all of the following four steps to develop and maintain the customer management system.
• In the first step, Cash Applications Processes, receipt and CM applications and reversals are located. For each, the contra account offset distributions and the revenue deferral distributions are generated. As well, the DRS will be populated to control the monthly generation of Revenue recognition.
• In the second step, Scheduled Revenue Recognition, the DRS will be used to generate the monthly Revenue Recognitions.
• The third step processes the tax on Refund CM's.
• The final step produces a summary report of the distributions generated in this run.
• These steps run consecutively as concurrent processes in a report set, scheduled to run daily. The set must be completed before the AR closing at monthend.

Environment: Windows XP Professional/2000/NT4.0, Oracle 11.5.0.8/11 i Applications, Oracle 9.0.2, FORMS 9i/6iREPORTS 9i/6i, PL/SQL, SQL LOADER, SQL PLUS, VISIO 2000, TOAD 8.0.0.47, QVCS 3.2, Remedy User 4.05.02,

Confidential

Senior Oracle Developer/Technical Team lead

Roles and Responsibilities

• Wrote PL/SQL scripts for creation of Oracle database tables, views, procedures, triggers and index.
• Logical and physical data model design using Oracle Designer.
• Actively involved in Troubleshooting and correcting Oracle database problems.
• Extensively used FORMS 9i/6i, REPORTS 9i/6i, Oracle Financials 11i AP and AR modules for user interface system wide master-detail/ ad hoc reports for the Maintenance of Students management system.
• Developed and maintained Students database using Oracle 9i/8i, Forms 9i/6i, Reports 9i/6i.
• Developed forms maintaining track of Students Records.
• Developed reports keeping track of Students payments and loans.
• Fully involved in developing and maintaining the students records web based system.
• Maintained records from 3 different locations like Phoenix, Tempe and Las Vegas.
• Worked as an Exam coordinator at CLC. This task included preparing exams for all tracks offered at CLC,
• Loaded those exams on the web and maintaining them on the web site.
• Maintaining the website of Computer Learning Center.Performed user testing, User Training.
• Was involved in placing students of CLC for various jobs depending upon their skillsets.

Environment: Windows XP Professional/2000/NT4.0, Oracle 9i, Oracle Applications Financials 11i, FORMS 9i/6i, REPORTS 9i/6i, PL/SQL, SQL LOADER, SQL PLUS, Oracle Designer, TOAD, dreamweaver MX 2004, Perl 5.8.8

Confidential

Sr. Programmer Analyst

Roles and Responsibilities

• Developed Stored procedures for accepting the data from Access database and converting it into a form suitable for storing it in Oracle tables. involved in testing of the system developed by our team.
• Worked as a Senior programmer Analyst. The project involved automating the existing manual system at Maricopa County Public Health Department. The current system was automated using Oracle 9i/Oracle 8i,Forms 9i/Forms 6i and Reports 9i/Reports 6i.
• Wrote PL/SQL scripts for creation of Oracle database tables, views, procedures, triggers and index.
• Involved in the design of Technical design document.
• The current application was tested using SQL Navigator 3.0 for testing stored procedures, Forms 6.0 for testing valid data. My role also involved preparing documentation for the project.
• Was involved in placing students of IEI for various job positions depending upon their skillsets.

Environment: Windows NT4.0, Oracle 9i, FORMS 9i/6i, REPORTS 9i/6i, PL/SQL, SQL LOADER, SQL PLUSConfidential Developer

Roles and Responsibilities:

• Worked as a developer. Earlier the application was developed using Oracle Developer Forms 6i and Reports 6i and Oracle 8i, Worked on the web based application to maintain records from three different locations here in Chicago. Involved in registering students for different courses with this application.
• Application also involved the payment plan schedule of the students and regular follow-ups.
• Involved in developing Client Server applications using Developer 2000/6.0/6i 2000
• Designed Oracle Forms Oracle Reports 6.0/6i
• Developed specifications and prototypes for forms, reports and procedures.
• Developed complex forms and reports using developer 6i.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities
• Designed Database Triggers for audit and validation purpose.
• Used Import, Export and SQL Loader 6.0 utilities to load data into the new schema.
• Involved in Developing, Testing, and implementing Client/Server applications
• Involved in troubleshooting, debugging techniques.
• Created object library, template forms to be used in the application.
• Was involved in placing students of Aquarius Institute for various jobs depending upon their skillsets.

.

Environment: WINDOWS NT, Oracle Developer Forms 6i and Reports 6i and Oracle 8i, PL/SQL 8.1.6, SQL Navigator

Confidential Developer

Roles and Responsibilities:

• This project involved understanding of the existing system and designing and developing in Oracle 8.0.
• The front end was developed in Oracle Forms 6.0.
• Reports were created for pay slips using Oracle Reports 6.0.
• Created stored procedures and database triggers.

Environment: Oracle 8.0, Forms 6.0, PL/SQL

Confidential

Developer

Roles and Responsibilities:

• Developed employee information, accounts payable, accounts receivable, client information and cost profit analysis screens using oracle forms 5.0.
• Wrote documents for oracle Forms, reports and PL/SQL standards to be followed on the project.
• Designed, created and tested the database to keep track of office information. Written function specs for functions, procedures and packages.
• This was a reengineering project involving a database for matching the skills and experience of the consultants with the requirements of the clients.
• Designed complex reports using oracle reports 3.0 to capture information periodically.

Environment: Oracle8.0, Forms 4.5.0, Reports 2.5.0, PL/SQL, SQL7.3