PROFESSIONAL SUMMARY

• Over 10 Years of Commercial software development experience.
• Over 10 Years of on PL/SQL development.
• 7 years in a high level management capacity leading and delivering development projects, managing Senior Managers, plant controller, plant managers and vice president.
• Extensive business knowledge of bearing repair business, complex Electricity billing system, Textile mill and software development centers.
• Experts in proposing innovative solutions to meet customer requirements.
• Extensive knowledge on ‘ONBASE’ document imaging and retrieving system.
• Extensive knowledge on ‘TIB’ Temporary Import Bond reconciliation.
• Ability to perform individually and as part of a team and directly with customers and Quality engineers to ensure quality.
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, Implementation and testing.
• Motivated self - starter who likes working on very productive, fast-paced teams.
• Provide technical expertise in database area throughout the life cycle of the projects.
• Good Communication Skill.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Consultant Programmer Analyst

Responsibilities:

• Technical consultant in software project.
• Provide technical assistance in identifying, evaluating, and developing systems and procedures which are cost effective and meet user requirements.
• Provide multiple solution for process enhancement and reduce TAT(turn Around Time)
• Write SQL queries.
• Supporting and enhancing Legacy system.
• Developed various alerts for system integrity and accuracy.
• Work closely with plant controller for automatically publishing sales at end of day to leads and sales force.
• User access administrating.
• Work center wise employee performance evolution.
• Ability to interact effectively with non-technical, functional user community
• Automate procedure for fast and accurate reporting leads and sales force.
• Developed various alerts for system integrity and accuracy.
• Work closely with QA for enforcing quality standards.
• Work closely with plant controller for automatically publishing sales at end of day to leads and sales force, royalty owners.
• Providing IT solution for automating complex contract review process.
• User access administrating.
• Extensively worked on Oracle development and maintenance of MRO.

Confidential . CA

Principal Programmer Analysts.

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in the continuous enhancements and fixing of production problems.
• Created scripts to createnew tables, views, queries, Alerts, triggersfor new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, procedures and packages using oracle tools likeToad.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Assist in the review and prioritization process of change requests and new development projects
• Provide technical expertise in database area throughout the life cycle of the projects.
• Designed, developed and modify various forms and reports.
• Writes complex PL SQL queries, stored procedures, packages, and triggers for customizing requirements.
• Create and implement Test plan.
• Automated various processes and system controls.
• Provides Oracle Applications techno-functional production support to business users.
• Reviews Oracle Applications functional design and configuration and ensures compliance with corporate policy, SOX regulations, and general best practices.
• Registers executable, forms, reports procedures, views, database triggers etc. by version control / Change Control procedures as required in the development environment.
• Involved in Price change activity like pre and post sales analysis, letter to all specified vendors, take care of pipeline cases and prices are based on vendor and fleet code.
• Generating and distributing MIS summary which includes Production planning, sales, budget, Received, rejected, shipped, on hold, due and, over due part summary every day (including week, month, year) in early morning automatically.
• Participated in Kaizen event for various process improvements and saved huge man hours.
• Develop standards and guidelines to guide the use of software and to protect vulnerable information.
• Leading contribution in making IT compliance with certain US custom laws related to the import and export of munitions item (defense articles) rules compliance.
• Providing IT solution which compliance with FAA(Federal aviation authority), ISO(Quality standard), sales tax
• Honored twice in Employee of Quarter.
• Couple of times declare as IT hero of Month
• Improvement in IT for dimension department’s procedure saves 700 man hours per year.
• Turnaround time (TAT) improvement. (Measure TAT on each process for each work orders on daily bases and evaluate the performance of each department.)
• Implement a process that addressed a significant quality gap with one of the plant’s largest customer.
• Involved in the continuous enhancements and fixing of production problems.
• Created PL/SQLpackagesfor various requirements.

Confidential

Sr. Programmer

Responsibilities:

• Experience with Agile software development processes.
• Excellent problem solving and debugging skills to provide assistance to users.
• Successfully designed, developed & implemented various applications, using a variety of languages, database on different platforms.
• Helping various departments for their IT needs.
• Computerized Co.’s Stock, Debenture Department independently.
• Handled stock dividend and debenture interest payment and stock transfer.
• Fixed deposit and interest payment system.
• Coal accounting.
• Service line billing ( Job Costing & Billing)
• Contributed in energy billing system.
• EDUCATION