SUMMARY

• 14 + years of experience in Information Technology with extensive experience in Database Application Design, Development & Maintenance, as well as Application performance optimization skills.
• Extensive experience in leading database technologies such as Oracle (9i/10g/11g).
• Domain experience in ERP (Sale, Purchase & Inventory Modules), Finance Accounting Package, Telecomm (Commissions).
• Expertise in Oracle SQL, Analytical functions, PL/SQL, Performance tuning, Data modeling and Data Analysis.
• Strong knowledge in developing PL/SQL objects such as procedures, functions, packages, views, materialized views, DB links & triggers.
• Experience with Fine tune procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Strong knowledge in Table partitioning as well as database design.
• Experience in providing end - end solution for data extraction, transformation and loading.
• Experience in working with complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Experience in complete SDLC including designing, coding and testing.
• Extensive experience in Onsite/Offshore model and experience in handling offshore teams.
• Extensive hands on experience in performance tuning of SQL queries & PL/SQL programs.
• Strong experience on Information Technology domain with key emphasis on Analysis, Design, Development, Unit as well as UAT testing, production deployment and Application Management.
• Sound experience in design, develop & maintain data load processes, backup processes and reporting frameworks.
• Oracle certified professional in Oracle 9i- Forms Developer.

TECHNICAL SKILLS

Programming Languages: Oracle SQL & PL/SQL, UNIX & Shell scripting, Java, C++, Visual Basics

Databases: Oracle 9i/10g/11g

IDE Tools: TOAD, PL/SQL developer, SQL Developer

ETL Tools: Informatica (Introductory knowledge)

Reporting Tools: Oracle Reports, Crystal reports, Visual Basics Reports, Oracle Discoverer 10g

Version control tools: Oracle Repository, CM-Synergy, Subversion

Other Utilities: Oracle SQL loader, Putty, WinSCP, HP Service Manager, HP ALM

Operating Systems: Windows & UNIX

PROFESSIONAL EXPERIENCE

Confidential

Technical Lead and SME

Responsibilities:

• Performing SME - Subject Matter Expert for Commissions Preprocessor Module and provide inputs to various groups like Business Analyst, Commissions Ops, Production Support, Other Development teams etc.
• Create of Error logging and handling procedures/packages for logging and analysis of errors occurred during program execution.
• Experience with Fine tune procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Analyze new CR for feasibility and provide inputs to Project Lead.
• Analyze Issue/Research tickets for any Production Issue and provide inputs to Production Support group.
• Interacting with Business Analyst to understand Business & Functional Requirements.
• Analyzing Requirements given by Business and create System Requirements.
• Create Technical Specification document (Design Document) based on SRs.
• Create Physical Database Design for impacted application modules.
• Involve in Reviews of deliverables ( Design, Code & Unit Test)
• Create of back end database procedures, functions and packages based on the technical specifications.
• Perform Unit Test of all impacted objects and capture results in UTC document.
• Analysis of massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
• Create of Ideas to improve/enhance existing application performance. Present those to client and implement upon approval.
• Support application changes in System Test phase. Track any defect into HP ALM tool.
• Support application change during Production Deployment and perform cycle 0 verification after deployment.
• Leading onshore and offshore teams technically in application analysis, building and Maintenance.
• Providing Technical Guidance to team members as Technical Lead for their ongoing/future projects Build.

Environment: / Tools: UNIX Shell Scripting, Oracle PL/SQL, HP Service Manager, HP ALM, Subversion, Redmine, Sql Developer, WinSCP, Putty

Confidential

Tech Lead

Responsibilities:

• Experience in complete SDLC including designing, coding and testing.
• Experience with Fine tune oracle Forms/procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Cost based optimization.
• Interacting with Business Analyst to understand Business & Functional Requirements (Use Cases).
• Analyzing Requirements given by in Use Cases Documents.
• Create Technical Specification document (Design Document) based on Use Cases.
• Create Physical Database Design for impacted application modules.
• Involve in perform Reviews of deliverables ( Design, Code & Unit Test)
• Design and build application GUI Form based on technical specifications.
• Creation of back end database procedures, functions and packages based on the technical specifications.
• Design and create Report in Oracle Discoverer for Business User based on the technical specifications.
• Perform Unit Test of all impacted objects and capture results in UTC document.

Environment: / Tools: D2k Forms & Reports. Oracle PL/SQL, Oracle Discoverer 10g, Oracle

Confidential

Sr. Developer

Responsibilities:

• Created back end database procedures, functions and packages based on the technical specifications.
• Interacting with Business Analyst to understand Business & Functional Requirements.
• Create Physical Database Design for impacted application modules.
• Design and Build application GUI Forms based on technical specifications.
• Design and Create Reports in Oracle Report Builder for Business User based on the technical specifications.
• Perform Unit Test of all impacted objects and capture results in UTC document.

Environment: / Tools: D2k Forms & Reports. Oracle PL/SQL, Toad

Confidential

Sr. Developer

Responsibilities:

• Experienced in working with complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created back end database procedures, functions, packages and triggers based on the requirements.
• Designed and Create Reports in Oracle Report Builder for Business User based on the requirements
• Interacting with Technical/Project Lead to understand Business & Functional Requirements.
• Create Physical Database Design for impacted application modules.
• Design and Build application GUI Forms based on technical specifications.
• Perform Unit Test of all impacted objects and capture results in UTC document.

Environment: / Tools: D2k Forms & Reports. Oracle PL/SQL, Toad

Confidential

Sr. Developer

Responsibilities:

• Design and Create Reports in Oracle Report Builder for Business User based on the technical specifications.
• Interacting with Technical/Project Lead to understand Business & Functional Requirements.
• Analyze complete Orion ERP modules for Sale, Purchase & Inventory and identify impacted object for customization needed based on Business & Functional requirements.
• Created Physical Database Design for impacted application modules.
• Designed and Build application GUI Forms based on technical specifications.
• Created back end database procedures, functions and packages based on the technical specifications.
• Performed Unit Test of all impacted objects and capture results in UTC document.

Environment: / Tools: D2k Forms & Reports. Oracle PL/SQL

Confidential

Sr. Programmer

Responsibilities:

• Created back end database procedures, functions and packages based on the technical specifications.
• Interacting with Project Lead to understand Business & Functional Requirements.
• Involved in Coding and development of packages in packages, procedures, cursors, tables, views and functions as per the business requirements.
• Created Physical Database Design for impacted application modules.
• Design and Build application GUI Forms based on technical specifications.
• Design and Create Reports in Oracle Report Builder for Business User based on the technical specifications.
• Performed Unit Test of all impacted objects and capture results in UTC document.
• Performed Application implementations at Client site.

Environment: / Tools: D2k Forms & Reports. Oracle PL/SQL, Toad, Plsql Developer

Confidential

Sr. Developer

Responsibilities:

• Involved in the concept of ERP by having regular interaction with Module Lead.
• Gathered the requirements from the users and analyzed their business needs.
• Interacting with Business Analyst to understand Business & Functional Requirements.
• Created Physical Database Design for impacted application modules and Modify existing database objects based on requirements. .
• Design and Build application GUI Forms based on technical specifications.
• Created back end database procedures, functions and packages based on the technical specifications.
• Designed and Created Reports in Oracle Report Builder for Business User based on the technical specifications.
• Performed Unit Test of all impacted objects and capture results in UTC document.
• Performed Application implementations at Client site, Supported application in different departments based on needs and Involved in Research and provide solution on issues encounter by user for implemented application.

Environment: / Tools: D2k Forms & Reports. Oracle PL/SQL, ToadProject Name: E-Gurukul

Confidential

Software Developer

Responsibilities:

• Developed Java servlets & websites for intranet based E-Gurukul website.
• Design & Develop WebPages based on requirements.
• Created Physical Database Design.
• Create of back end database procedures and functions based on requirements.
• Uploaded all class files on Java Web server post QA approval.
• Involved in Java scripting for web pages of the website.
• Provided Training to End User.

Environment: / Tools: Java servlets, MS-Access Database, Microsoft Frontpage, Java Script