SUMMARY

• 20+ years of IT experience involving requirements gathering, analysis, design, development, testing and implementation of IT applications.
• Expertise as Developer, Analyst, Module Lead, Project Lead, Onsite Coordinator and involved in Project Management activities.
• Over 9+ years of experience in designing and developing applications using Oracle Technologies performing role of Oracle Senior PL/SQL Developer.
• Proficient in Data Modeling (Relational & Dimensional) using ERWIN
• Experience in developing ETL jobs using leading ETL tools like Informatica, Talend and Pentaho
• Extensive experience in PL/SQL, writing stored procedures, packages, triggers and other database objects, Import/Export, SQL Loader, used standard packages like DBMS JOBS, DBMS OUTPUT, DBMS SQL and UTL FILE utilities.
• Experienced in complex stored procedure, triggers, views and other database objects, bulk load through file, queuing, export/import, XML based data load and, Jr. DBA activities like creating indexes and granting privileges.
• Intensive experience of Development & Production support environment and its responsibilities.
• Excellent analytical, technical, and interpersonal and communication skills coupled with an intense customer - centric attitude.
• Extensively involved in Unit, Integration, system testing and UAT of applications.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i/8i/7.x/6.x

OS: HP Unix 10.2 /Red Hat Linux/Windows 2000

Software Tools: Developer/2000, Informatica 8.x, Talend 5.2, Pentaho 5.x, TOAD, SQL Developer

Languages: PL/SQL, C, Python 2.7, Pro*C

Hardware: HP 9000/T520 server, DEC ALPHA server, Sun servers, Compaq servers

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

• Analysis of business requirements.
• Understanding of Legacy systems, conducting requirements study, system specifications, system design, coding, testing.
• Designing table structures, normalization of tables, entity relationship diagrams, and defining integrity constraints
• Bug fixing and implementation of enhancements for new requirements
• Analyzing the impact of any new business requirement that come in through BRD
• Prepare design documents - Prepare HLD and DLD after BRD freeze
• High-level interaction with the client
• Extensive experience with Oracle PL/SQL, Unit testing, logical and physical database design, database maintenance.
• Preparing the business requirement documents in the agreed format
• Developing complex functions, stored procedures and packages, Triggers by using PL/SQL.
• Single point of contact for the quality assurance compliance and issue solving with respect to the team members
• Performing Coding / Development, Unit Testing and Peer Code Reviews

Environment: Oracle 11.x, PL/SQL, TOAD

Confidential

Team Lead /Senior ETL Developer

Responsibilities:

• As team lead, I handled all the high level interactions with the client, presented monthly metrics and ensured my team worked efficiently towards the resolution of all issues.
• I mentored team members and motivated them to be proactive and take up higher responsibilities.
• Developed ETL jobs for converting data from legacy system to a new application using Java/Oracle technologies
• Involved in coordinating with offshore team for development of ETL jobs
• Developed an audit & control mechanism for ETL jobs
• Developed PL/SQL stored procedures to enhance the capabilities of ETL jobs.
• Tuned PL/SQL stored procedures and achieved 500% improvement in performance.
• Involved in Data Modeling activities using ERWIN.
• Developed complex functions, stored procedures and packages, Triggers by using PL/SQL.
• Single point of contact for the quality assurance compliance and issue solving with respect to the team members
• Performing Coding / Development, Unit Testing and Peer Code Reviews

Environment: Oracle 11.x, Pentaho 5.x, Linux, PL/SQL, SQL Developer

Confidential

Senior Database Developer

Responsibilities:

• Designed Dimensional Model for Texas Driver License Verification Program Data Warehouse
• Developed ETL jobs using Talend and Python
• Designed the architecture and implemented a new service to Confidential ’s biggest client which involved a weekly processing of nearly a 100 million records
• Team coordinator and manager for status reporting, and progress reports, resource allocation and planning, organizing project related trainings and holding team meetings.
• Translating the business requirements into technical requirements.

Environment: MS SqlServer 2012, Talend 5.2, Python 2.7, MySql

Confidential

Lead - Data Management

Responsibilities:

• Administered Oracle Databases for four development projects
• Responsible for database design (Relational model) for four development projects
• Developed stored procedures, functions and packages for four development projects.
• Tuned the applications for superior performance for four development projects.
• Prepared Project Proposals (from database perspective) in response to RFP’s (Request for Proposals).
• Led a five member Data Migration Team for SAP implementation at Oman Gas Company, Muscat for critical Purchase Requisition & Purchase Order modules.

Environment: Oracle 11g, SQL, PL/SQL

Confidential

Oracle Lead & Senior Trainer

Responsibilities:

• Conducted training for 200 students on Cognos 8, Oracle 10g DBA and Oracle PL/SQL programming
• Designed a new and comprehensive course structure for Oracle 10g DBA/PLSQL training and Cognos 8 training
• As a consultant, provided support to Confidential ’s corporate clients for designing their database (Relational Modeling)
• As a consultant, provided support to Confidential ’s corporate clients for tuning their applications for superior performance.
• Responsible for preparing Project Proposals (from database perspective) in response to RFP’s (Request for Proposals).

Environment: Oracle 10g, SQL, PL/SQL, HP UNIX, Cognos 8

Confidential

Principal Consultant

Responsibilities:

• As Head of Data Modeling Certification Program, conducted Data Modeling training to 20 Software Engineers of Satyam, prepared and reviewed Data Models for five applications, prepared detailed guidelines for indexing, partitioning for Data Warehouses.
• Conducted training in Cognos 8 &Informatica 8.1 for 200 Software Engineers of Satyam.

Environment: Oracle 10g, Cognos 8, Informatica 8.1, Erwin

Confidential

Principal Consultant

Responsibilities:

• Lead a team of 9 Oracle DBAs and 1 SQL server DBA and managed DBA activities in all the projects across the company
• Prepared standards for PL/SQL programming (Stored procedures, functions and packages)

Environment: Oracle 9i/10g, SQL, PL/SQL

Confidential

Tech Lead

Responsibilities:

• Extracted, Transformed and Loaded data from legacy systems to new application
• Guided a team of Informatica specialists and an Oracle DBA

Environment: Oracle 9i, InformaticaPowermart 5.0, SQL, PL/SQL

Confidential

Senior Consultant

Responsibilities:

• Provided technical support for Flexcube (a leading core banking solution) for clients in Middle East, Europe & Africa, managed End Of Day operations for Confidential (a leading bank in India), prepared and executed test plans for 3 major releases of Flexcube

Environment: Oracle 9i, Developer/2000, SQL, PL/SQL, UNIX

Confidential

Senior Consultant

Responsibilities:

• Helped to migrate from their old applications in Sybase to new application in Oracle
• Developed reports for this insurance company’s Poland & Brazil Operations

Environment: Oracle 8.x, SQL, PL/SQL, Developer 2000 (Forms & Reports), InformaticaPowermart 4.5

Confidential

Consultant

Responsibilities:

• Implemented Banner, an application, by extracting, transforming and loading data from legacy systems to Banner.
• Financial & Resource Management, tuned queries and reduced execution time from 30% to 70%

Environment: Oracle 7.x, Developer 2000 (Forms & Reports), UNIX, SQL, PL/SQL

Confidential

Senior Software Engineer

Responsibilities:

• Analysis, design, development and implementation of two applications for regulating air and sea shipments of Singapore

Environment: Oracle 7.x, SQL, PL/SQL, Developer 2000, Pro*C, Digital UNIX

Confidential

Senior Software Engineer

Responsibilities:

• Analysis, design, development and implementation of an applications for automating the export functions of a leading bicycle manufacturing company in India.

Environment: Oracle 7.x, SQL, PL/SQL, Developer 2000, Pro*C, HP- UNIX

Confidential

Software Engineer

Responsibilities:

• Developed purchase and stores modules for a steel manufacturing company

Environment: Oracle 6.x, SQL, PL/SQL, Forms 3.0, Reports 1.1, SCO UNIX