PROFESSIONAL SUMMARY:

• About 15 years of experience in the area of Analysis, Design, Development, customizations and Implementation of client server applications.
• Worked in diverse areas of business comprising ERP, Loan Banking, Corporate Banking, Manufacturing, M&E Industries and gained keen insight into functionality requirements, methodology of developing software applications for these areas.
• Proficient in analyzing and translating business requirements to technical.
• Experience with various technologies such as Oracle SQL, PL/SQL, Oracle Forms, Oracle Reports, Oracle Application Express (Apex) & shell scripting.
• Experienced in PL/SQL application fine - tuning and performance tuning of SQL queries by using DBMS HPROF, Explain Plan & TKProf.
• Oracle certified professional (OCP)
• Plan and implement backup & recovery strategies Using RMAN & Data pump (expdp/ impdp).
• Experience in migration of data from Excel and Flat file to oracle database using SQL Loader.
• Development and Implementation Experience of ERP & Banking Software.
• Experience in leading and managing teams. Handled multiple roles - Team Lead, Software Developer, Systems Analyst.
• Good communication skills, interpersonal skills, self-motivated, quick learner, team player.
• Ability to accept challenges & adapt new technologies quickly.

TECHNICAL SKILLS:

Programming Languages: SQL, PL/SQL, shell, XML, Pro* C.

GUI Tools: - Oracle Forms 6i/10g, Oracle Designer, Visual Basic 6.0, Oracle APEX.

Reporting Tool: -Oracle Reports, BI Publisher, Crystal Reports.

Database: - Oracle, MongoDB.

Version control: Visual Source Safe, IBM Rational Clear case.

Others: SQL Loader, RMAN, Putty, WinSCP, TOAD, Eclipse, Unix/Linux, Jira Agile using Kanban.

PROFESSIONAL EXPERIENCE:

Advisory System Analyst

Confidential, Ann arbor, Michigan,

Responsibilities:

• Work with end user to analyze and understand the Business Requirements and translate customer requirements into formal requirements.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements using Oracle PL/SQL program units like packages, procedures, triggers, function etc.
• Database design & developing UI, Using Oracle Forms, Oracle Reports, Designer & Oracle Apex.
• Responsible for performing different level of core technical activities like design, development, unit testing, integration testing, UAT and deployment.
• Provide Production support for all Exodus Applications like Dissertation, Early English Book, Canadian Government Publication (CRI) & Research Collections.
• Responsible for providing day to day direction to the offshore team to get the assignment complete on scheduled time and provide regular work status to project management and to customer.

Environment: Oracle SQL, PL/SQL, Linux /Solaris OS. Oracle Forms 10g, Report 10g, Oracle Designer, Oracle Apex, Oracle developer /Toad. Pro *C, Jira Agile using Kanban Board.

Sr. System Engineer

Confidential .

Responsibilities:

• Worked for same client ( Confidential ) from India, before moving to USA.

System Analyst

Confidential

Responsibilities:

• Involving in application design based on business logics.
• Designing & developing Oracle Forms & Reports.
• Writing PL SQL program units like packages, procedures, triggers, functions, etc.
• Maintaining the technical documentation and product manual creation for customized software and business processes.
• Harmonizing with the product development group to fix bugs in core and for making enhancements in product features/ functionalities based on Standard functional requirements.
• Translate customer requirements into formal requirements and create design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results.
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.

Environment: Oracle SQL, PL/SQL, Linux OS, Oracle Forms 10g, Report 10g, IBM Rational Clear case.

Sr. System Engineer.

Confidential,

Responsibilities:

• Developed in house solution for ERP Application using Oracle SQL, PL/SQL, Oracle forms & Reports 6i.
• Accountable for consulting in functional as well as technical aspects of ERP Implementation for end user and project implementation.
• Interfacing with the end user for mapping the requirements stipulated.
• Involving in application design based on business logic.
• Designing & developing forms / reports.
• Responsible database backup & recovery.
• Responsible for application performance & to tune SQL Queries using Hints, explain Plan & TKProf
• Writing PL SQL program units like packages, procedures, triggers, functions, etc.
• Maintaining the technical documentation and product manual creation for customized software and business processes.

Environment: Oracle SQL, PL/SQL, Oracle Forms 6i, Report 6i, Visual Source Safe, windows OS.

Sr. System Engineer

Confidential

Responsibilities:

• Developed & Implemented ERP (Suvidha) solution for client Kapson Industries using Oracle SQL, PL/SQL, Visual Basic & Crystal report.
• Worked on ERP Modules like Sale (Order Acceptance, IPO Acceptance, Dispatch, and Billing), Purchase (Indent preparation, Purchase Order, MRIR, and Quality Control), Store & Production.
• Involved in Requirement analysis and creating documents needed to project.
• Responsible for Implemented of the project & to provide training to end users.
• Responsible database backup & recovery.
• Responsible for application performance & to tune SQL Queries using Hints & explain Plan.

Environment: Visual Basic 6, Crystal Reports 8.5, Oracle SQL, PL/SQL, Windows NT OS.