SUMMARY

• 16+ years of experience inSoftware Development Life cycle performed the roles of a Technical Manager/ lead/Project lead/ Project Manager, leading teams of 10+ developers.
• Domain Expertise in Life science, Sales and Distribution, HR, Payroll and Material Management.
• Excellent Technical expertise in Oracle 9i/10G/11G, SQL/PLSQL (Package, Procedure, Functions and DB triggers) and Oracle Forms and Reports
• Expertise in PLSQL; support, maintenance and enhancements of Oracle PLSQL based projects, performance tuning of PLSQL code
• Expertise in writing shell scripts and job scheduling in UNIX.
• Creating workflows, Mapping andscheduling jobs inInformatica
• Involved in complete Software Development Life Cycle (SDLC) starting from inception to implementation of various Database heavy applications with 2 - tier and 3-tier architecture.
• Interaction with clients forbusiness gathering, conducting system analysisand finalizingtechnical / functional specificationsand high level design documents for the project.
• Demonstrated excellence in understanding of all phases in the software life cycle entailingrequirement study, analysis, design, development, testing, implementation and support.
• An effective communicator with exceptional relationship management skills with the ability to relate to people at any level of business and management.
• Experienced in creating various project artifacts like use-case documents, class diagrams, design document, architecture document, etc.
• Handled errors using Exception Handling andJavaScript validation extensively for the ease of debugging and hence directing user to provide suitable data.
• Expert in translating the Technical understanding of products/projects in technical/understanding documents that serve as base of understanding to new members and repository of knowledge to Team.
• Perform resource management activities including staff interview, performance appraisal, and dissemination activities along with OSP Senior Management.
• Performed Business development activities like creating new proposals, Estimations, case studies etc.
• As a lead engineer involved in code review of all the team members.
• Handled Project account level status reporting, offshore/Onshore SPOC for client meetings, Complete Business Analysis Requirement, Mentoring Team.
• Used Oracle HTP.P to deliver embedded HTML5, CSS3, Jquery andJavaScript to present web content.
• Managing the end-to-end implementation of the project including designing, development, testing, implementation and support of software applications.
• Manage client expectations, Monitor the level of customer satisfaction, responds to customer’s query and complaints, and ensure corrective actions being taken for SLA based delivery compliances.

TECHNICAL SKILLS

Operating Systems: HP-UNIX 10.2, Windows 95/98/NT/XP.

Programming Languages: PL/SQL,SQL*Plus, HTML, UNIX shell scripts,C, C++, XML

Databases: ORACLE 11g/10g/9.x/8.x/7.xTools / Utilities Oracle Forms 6i/9i/10g, Reports 6i/9i/10g, SQL LoaderTOAD, SQL*Plus, VB 6.0, D2K,, VSS, Autosys,ETL tools.

System Networks: Oracle Net, HTML, Windows Servers, OLAP/MSMQ series, ODBC, DHTML

Office Tools: MS Word, Excel, Power Point, Visio

Others: Object Oriented Designing Methodology, RDBMS Concepts

PROFESSIONAL EXPERIENCE

Confidential

Technical Manager

Responsibilities:

• Database design and application enhancement using advanced PL/SQL (Cursors, Stored procedures, Packages etc.), oracle forms/ reports 11G.
• Analyze the Business requirements provided by the client.
• Analyze requirements from existing process perspective to identify gaps as well from overall Affiliates business process perspective to come up with best approach to achieve objectives.
• Used an oracle IDE tool called Toad extensively, for data checking and code analysis.
• Writing UNIX shell scripts for executing SQR reports (Pre-billing and billing) and sending Invoices via email.
• Used bootstrap framework, CSS3, Jquery,JavaScript and HTML5 for responsive website to enhance user experience for button and overall UI.
• Preparing adhoc reports using SQL queries for client from the system
• Implementing PL/SQL packages and procedures to enhance functionality or for ad-hoc processing of data, based on the client’s request.
• Written database triggers, procedures and functions for various complex business requirements.
• Performance related improvement by using explain plan, proper indexes and bind variables concept to reduce the execution time by 90%.
• Working closely with users / clients to ensure the project meets business needs.

Confidential, Chicago, IL

Technical Manager (PL/SQL, Oracle Forms/Reports)

Responsibilities:

• Manage client expectations, translating functional requirements to system requirements, Monitor the level of customer satisfaction, responds to customer’s query and complaints, and ensure corrective actions being taken for SLA based delivery compliances.
• Analyze the Business requirements provided by the client.
• Analyze requirements from existing process perspective to identify gaps as well from overall Abbvie process perspective to come up with best approach to achieve objectives.
• Database design and application enhancement using advanced PL/SQL (Cursors, Stored procedures, Packages etc.), oracle forms/ reports 10G.
• DeliveredJavaScripts to generate dynamic views thru HTML scripts.
• Writing Unix shell scripts to build interfaces between SAP and Legacy systems.
• Use various Tools and Technologies in generating the required reports to provide Abbvie business teams with an insight into on productivity and efficiency on various projects.
• Working closely with users / clients to ensure the project meets business needs.

Confidential, Stamford,CT

Senior Associate (PL/SQL)

Responsibilities:

• Working on development of project proposals, cost estimate and budgets, timelines and schedules.
• Preparing Project Charter and Statement of Work (SOW) to initiate a project.
• Managing and leading the project team of 10 members which includes Team Lead, Senior Engineer, and Software Developer.
• Managing co-ordination of the offshore counterpart US Onsite teams engaged in project work.
• Detailed project planning and controlling via global delivery platform.
• Recording and managing project issues and escalating where necessary.
• Managing project scope through established Change Management Process and escalating issues where necessary.
• Monitoring project progress and performance against baseline & prepare and share performance reports with stakeholders.
• Managing project for new resources in niche technology like Oracle Apex and make sure the team is well trained and mentored to make sure the delivery adhere to delivery management process established.
• Liaison with, and updates progress to, project steering board/senior management.
• Managing project team’s goal settings, evaluation and dissemination, staffing activities along with Account Manager.
• Worked withjavadevelopers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Managing performance review for his team members and preparing their performance report.
• Updating resource plan as project needs and work with functional managers to adjust required resources.
• Working closely with users / clients to ensure the project meets business needs.
• Participate in sharing best practices with other project team. Also adopt those kinds of best practices applicable to his projects from the organization’s process asset library.

Confidential, Boston, MA

Senior Associate (PL/SQL)

Responsibilities:

• Validating the requirement and Architecture design. Providing technical solutions for business problems
• Guide 5 members’ team for new enhancements or fixing existing issues in existing applications (Application Value Management).
• Responsible for delivery of project artifacts on time and with good quality which exceeds client expectations.
• To make sure the team is well trained and mentored to make sure the delivery adhere to delivery management process established in Cognizant.
• To make sure he & his team is proactive to identify the issues in the applications they support in advance and propose the solution to the clients on time.
• Worked withJavateam to establish the DB connectivity toJavaand also used ref cursors to return multiple
• To have a plan in place on quarterly basis for the knowledge management of his team in line with pipeline projects as directed by the onsite management.
• Make sure the project stakeholders are communicated on the development as per the communication plan of the project

Confidential

Project Lead (PL/SQL, Oracle Forms/Reports)

Responsibilities:

• Worked on Design, Analysis, coding and extensive testing of Oracle forms, reports 6i based applications.
• Data migration from CARDS to GOMS (Global order management system), which was developed in oracle 10G.
• Used an oracle IDE tool called Toad extensively, for data checking and code analysis.
• Wrote several UNIX shell scripts during the course of project.
• Prepared ad hoc reports using SQL queries for client from the system
• Implemented PL/SQL packages and procedures to enhance functionality or for ad-hoc processing of data, based on the client’s request.
• Written database triggers, procedures and functions for various complex business requirements.
• Performance related improvement by using explain plan, proper indexes and bind variables concept to reduce the execution time by 90%.
• Managed the project team of 5 members which includes Team Lead, Senior Engineer, and Software Developer.

Confidential

Sr. Developer (PL/SQL)

Responsibilities:

• Analyze requirements from existing process perspective to identify gaps as well from overall process perspective to come up with best approach to achieve objectives.
• Provide timelines and estimates on all deliverables to the Project Manager
• Creation of Users and assignment of Roles, Privileges and Auditing.
• Storage Management, which included creation of Tablespaces, setting up of parameters, allocation of Space and tuning of the application using EXPLAIN PLAN.
• Designed graphical user interface screens, Menu system and common functionality.
• Developed numerous reports using Crystal Reports 6.0 .
• Identify potential issues in design and development and come up with suitable workaround solutions.

Confidential

Sr. Programmer (PL/SQL, Oracle Forms/Reports)

Responsibilities:

• Develop new code using Oracle PL/SQL, Forms and Reports as per business requirements to accommodate changes in business process or new business process.
• Performance Tuning of long running jobs using proper joins, indexing, hints etc.
• Provide required grants to user on tables, procedures, functions.
• Create and review install, DDL and DML SQL scripts
• Create new database jobs required for new request or enhancement.
• Prepare Test Requirements from the Business Requirements.
• Generate Test Cases from Test Scenarios and Business Requirements provided using quality center.
• Prepare Test Summary Reports on the actual results generated during Test Execution
• Promote/Deploy new changes from Development to Test, Stage and Production environments.

Confidential

Software Engineer (PL/SQL, Oracle Forms/Reports)

Responsibilities:

• Requirement gathering and analysis.
• Developed different level of forms, report with the guidance of seniors.
• Written database triggers, procedures and functions for various business requirements.
• Prepare Test Summary Reports on the actual results generated during Test Execution
• Promote/Deploy new changes from Development to Test, Stage and Production environments.
• Maintaining, tuning and repairing applications in order to keep them performing according to technical and functional specifications; performing preventive maintenance activities; providing user support.