PROFESSIONAL SUMMARY:

• Over 20+ years of work experience as Lead Developer
• Specialized in
• Oracle PL/SQL (20 Years)
• Oracle Forms 10g, Reports 10g Development / customization
• Advanced PL/SQL Scripting, Python Scripting
• Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
• Stored Packages, Procedures & Functions
• SQL Performance Tuning
• UNIX Shell Scripting
• Interface development
• ETL(Data Extraction, Transformation & Loading),
• Oracle Data Integrator, Data Migration
• Complex Query Writing and Performance Tuning.
• Domain Exposure: Banking & Financial Systems, Supply Chain Management, Credit Card Dispute Management, Hire Purchase, Leasing, Bill Discounting, Fixed Deposits.
• Clients Worked with: Galileo, USA, Vadum Inc, USA, DataForce Systems Inc, USA, Soft Brands Hospitality, USA, Cronos Inc, UK, Baker Haus Veit, Canada, Custom Glass Products, USA, Pliva Inc, USA, Massachusetts Institute of Technology, USA, Confidential, Standard Chartered Bank, Standard Chartered Bank, Malaysia, Standard Chartered Bank, Thailand, Confidential, ICARDA, Syria, Electricity Holding Company, Sultanate of Oman, Diwan of Royal Court, Oman, etc, Bank Sohar, Oman, Oman Telecommunications, Oman.
• Worked with Manufacturing Business Intelligence & Financial Business Intelligence & Good exposure to BI publisher.
• Technical Expertise: Strong Technical Development skills (PL/SQL), Leading Technical Team, Mentoring, Project Planning Analysis Design implementation, Process Implementation and Liaison with Client. Proficient with MS Project; highly trained in full life cycle development from project proposal to project closeout. Integrating SAP & Oracle System, JD Edwards & Microsoft Portals. Migrating Oracle systems from older versions to the latest versions.
• Excellent Communication, Technical and Management skills.
• Extraction, Transformation & Loading
• Strong Knowledge In Database Administration in Oracle 11g (RAC, Dataguard, Data pump & RMAN
• Infrastructure Management Solutions: Software Migration, Software Conversion, Data Migration, and Product Implementation, Development & Customization.

TECHNICAL SKILLS:

Operating Systems: DOS, Stratus VOS, Novel NetWare, Sun Solaris, Winix, HP UX, Linux.

Languages: BASIC, COBOL, FORTRAN, C. OOPS: Exposure to Java. Scripting: Advanced Unix Shell Scripting. GUI: VB Basic 4.0, Visual Basic 6.0, Visual Studio 2003, Developer/2000, Power Builder. Web Applications: HTML, ASP, CGI - Perl, JSP,Servlets, Web logic. RDBMS: Oracle 7.x, 8.x, 10g, Sql*Forms 3.x, 4.x, 6.x Forms 10g, Forms 6i, Reports 6i, Sql*Report Writer 1.1, 2.x, Reports 10g, Pro*C & Sql*Menu 5.0, SQL, and PL/SQL, SQL Server 6.5, SSRS, Crystal Reports, PostgreSQL V6.5, 7.0, Sybase. Exposure: VB.NET, ASP.NET. Data/Database Architect: DFD, Logical/Physical Data Models, ERD, HLD, LLD, ERWIN Tools. Data Warehouse & BI: AWS(Analytic Workspace Manager), Discoverer Plus, BI Publisher. Database Tuning: Query Tuning (Explain Plan, Hints, TKprof). Oracle BI: AWS & Discover Plus. Software Quality: Code Reviews, Unit Testing, Integration Testing

Performance Monitor Tools: Enterprise Manager, SQL Analyzer and Quest (Toad). Project Management Tools:

Microsoft project. Presentation Tools: Power Point, Visio, Excel. Version/Source Code Control: PVCS, Visual

PROFESSIONAL EXPERIENCE:

Confidential

Lead Technical Consultant - Oracle Pl/Sql

Responsibilities:

• Provide Coding, Testing, Debugging of Production Systems using PL/SQL programming
• Install New programs/applications and Maintain the existing programs
• Provide Oncall support and respond to the emergencies within applications and programs
• Provide First-tier support to end users for IT applications
• Advanced PL/SQL Coding & Oracle performance Tuning.
• Creating packages, stored procedures, stored functions
• Performance Tuning in SQL/PL SQL (Bulk processing)

Environment: Oracle PL/SQL, Oracle12c, Linux

Confidential

Lead Technical Consultant - Oracle Pl/Sql

Responsibilities:

• Provide design and support to newer application for the Railway Systems
• Advanced PL/SQL Coding & Oracle performance Tuning.
• Creating packages, stored procedures, stored functions
• Domain Expertise on Railway transport systems
• Work with large group of Java developers and provide database solutions to the team
• Performance Tuning in SQL/PL SQL (Bulk processing)
• Developed Management Information reporting using Oracle APEX

Environment: Oracle PL/SQL, Oracle12c, Linux

Confidential

Lead Technical Consultant - Oracle Pl/Sql

Responsibilities:

• Presently providing technical services for Product implementation and Automation
• Advanced Unix Shell Scripting
• Advanced PL/SQL Coding & Oracle performance Tuning.
• Create packages
• Crate Triggers, Stored Procedures & functions
• Domain Expertise on Marketing Solutions.

Environment: Oracle PL/SQL 11g, Oracle11g, Linux

Confidential

Lead Technical Consultant - Oracle Pl/Sql

Responsibilities:

• Presently providing support for the critical production issues OPEN LOOP Project at FDC
• CA scheduler - Oracle jobs
• Advanced PL/SQL Coding & Oracle performance Tuning.
• Write Triggers, Packages, Procedures and functions
• Domain Expertise on Finance & Credit Card.
• Gift Card usage reports using Oracle APEX and BI Publishing
• Oracle Data Integrator
• Involved in Development of APEX based web applications

Environment: Oracle PL/SQL, Oracle11g

Confidential

Lead Technical Contactor - Oracle Pl/Sql

Responsibilities:

• Presently providing production support for the critical applications at Confidential
• Designed and Developed LOAN Putback System Phase I for Confidential . Loan put back system is basically to track the loans if any of the representations or warranties are breached, and the breach materially and adversely affects the value of a loan, which can be as simple as reducing its market value, the offending loan is to be “put-back” to the sponsor, meaning that the sponsor is required to repurchase the loan for the outstanding principal balance plus any accrued interest.
• Advanced PL/SQL Coding & Database Architecting.
• Python Scripting
• Domain Expertise on Finance and Insurance, Deployment Strategy.
• Advanced Reports development using SSRS 2008(SQL Server Reporting Services).
• Query Tuning

Environment: Oracle PL/SQL, Oracle 11g, SSRS

Confidential

Lead Technical Consultant

Responsibilities:

• Coded Advanced PL/SQL Coding, Building Repository of reusable codes, and project documentation.
• Worked on Database Design. Wrote Unix Shell Scripting.
• Helped pre-sales and sales team in building POC (Proof of Concept).
• Conducted for clients on Oracle SQL/PL/SQL.
• Mentored teams on Implementation Strategy, Integration, Best Practices.
• For Microsoft Web Portal and JDE Integration involved in Core development on Visual Basic 6 built. components to pull data from JD.
• Played a Lead Technical Consultant role performing Code reviews, Design decisions.
• Architected and migrated huge Oracle custom application to Oracle 10g Version.
• Oracle Data Integrator
• Migrating Huge Migration project with MIT Boston to migrate a VAX based Oracle custom application to UNIX.
• Wrote Unix Shell scripts.
• Mentored teams on Implementation Strategy, Integration, Best Practices, etc.

Environment: Oracle PL/SQL, Forms 10g and Reports 10g, Windows 2000 Server, Oracle 10G, Oracle 10g, IIS, XML, ASP, HTML, COM+, Visual Basic 6, MS SQL 7.0 / 2000Server, Unix, VAX, Shell Scripts, Pro*C.

Confidential

Lead Technical Consultant

Responsibilities:

• Designed and built complex designs, writing Extensive complex PL/SQL programs.
• Implemented Oracle based product ORION for US and Canada based customer from offshore.
• Played a lead Oracle Technical Consultant role performing Code reviews, Design decisions.
• Architected and designed the offshore onsite coordination model.
• Preparing RFP, Project Estimation, Costing sheets.
• Building Repository of reusable codes, and project documentation.
• Writing Shell scripts in Linux (Redhat).
• Mentored Teams on Implementation Strategy, Integration, Best Practices, etc.

Environment: Solaris, Linux, Oracle PL/SQL, Oracle 8i, Oracle Forms 6i and Reports 6i.

Confidential

Associate Lead Technical Consultant

Responsibilities:

• Designing and building complex designs, writing Extensive complex PL/SQL programs,
• Part of the Product development team involving design and development of Oracle based product LAMS.
• Played a Lead Unix Technical Consultant role performing Code reviews, Design decisions
• Played a Lead Technical Consultant role performing Code reviews, Design decisions
• Migrating Huge Migration project with Cronos, UK UNIX based Oracle custom application to Java Platform.
• Providing Solutions on Configuration Management, Deployment Strategy and Migration Strategy.
• Writing Shell Scripts
• Mentored Teams on Implementation Strategy, Integration, Best Practices, etc.

Environment: Linux, Oracle PL/SQL, Oracle 8i, Oracle Forms 6i and Reports 6i., Pro*C Shell Scripts

Confidential

Senior Project Leader

Responsibilities:

• Designed and built complex designs, writing Extensive complex PL/SQL programs.
• Set up an offshore model and deriving the strategy for onsite offshore communications.
• Played a technical consultant role performing Code reviews, Design decisions.
• Conducted a requirement study for Supply chain management system.
• Building Repository of reusable codes, and project documentation.
• Migrated huge Oracle reports Migration project.
• Provided Solutions on Configuration Management, Deployment Strategy and Migration Strategy.
• Maintained existing shell scripts and writing new scripts as and when required.
• Mentored teams on Implementation Strategy, Integration, Best Practices.

Environment: HP-UX, Oracle PL/SQL, Oracle 8i, Oracle Forms 6i and Reports 6i, Pro*C, Unix Shell Scripting, Power Builder 6.5 with PFC, Sybase Adaptive Server, Object Cycle, Power Designer, Windows 2000 Server, IIS, XML, ASP, HTML, COM+, VBScript, MS SQL 7.0, Sun Sparc, Web logic, HTML, JavaScript, JSP,: Linux, HTML, DHTML, JavaScript, CGI-Perl, PostgreSQL.

Confidential

Systems Analyst

Responsibilities:

• Designing and building complex designs, writing complex programs using PL/SQL
• Coding and construction & Unit Testing
• Migrating Character based application to a GUI based application
• Designed solution to implement re-usable code, Team work, Best Practices

Environment: Oracle v7.3, Oracle PL/SQL, Developer/2000, Sun O/S - Unix SVR4, Unix Shell Scripting

Confidential

Senior Systems Executive

Responsibilities:

• Application development, Database design & review
• Coding and construction & Unit Testing
• Designed solution to implement re-usable codeTeam work, Best Practices
• Writing Shell scripts
• Application development, Database design & review
• Coding and construction & Unit Testing
• Designed solution to implement re-usable code
• Writing Shell Scripts

Environment: Stratus VOS, Wipro Winix, Oracle v7.0, Oracle PL/SQL, Forms 3.0, SQL*Report Writer V1.1, SQL*Loader, Unix SVR4, FoxPro 2.5, Novell NetWare

Confidential

Software Developer/Programmer

Responsibilities:

• Application development.
• Database design & review.
• Coding and construction, Designed solution to implement re-usable code.
• Unit Testing.

Environment: Oracle v7.0, Forms 3.0, SQL*Report Writer V1.1, SQL*Loader, Unix SVR4, FoxPro 2.5, Visual Basic V4.0, MS-Access.