SUMMARY

• Around 8.5 years of experience in software development life cycle including analysis, estimates, design, development, implementation, testing and maintenances of Database & Oracle applications.
• Extensive hands on experience in Database design including
• Subject matter expertise in Oracle Applications - SCM & Order management, Health care, Banking & Finance, and Educational domains
• Dedicated, hard working, & highly motivated individual with an ability to work on multiple projects simultaneously and a proven track record of on time delivery.

TECHNICAL SKILLS

ERP: Oracle Applications - SCM (Inventory, Order Management and purchasing modules)

Database: Oracle 9i, Oracle 10g

Languages: PL / SQL, UNIX Shell script, Visual Basic, VB Macros

Other Tools: SQL*Plus, SQL Developer, TOAD, Report 6i, Forms 6i, SQL * LOADER, Workflows Builder, Discoverer, XML Publisher, Secure Shell, Digital Fuel, Kintana, PVCS, Quality Center, VB Macros, Control M, Informatica

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

• Responsible for system analysis, plan, estimate, develop, review, and implement enhancements & projects of different sizes
• Automated feeds from different sources
• Developed new ETL workflows
• Developed packages and views to support front end requirements
• Supported backend changes needed to application decommission, adding new line of business
• Monitored production feeds
• Coordinate / perform production releases
• Monitored & reviewed junior developers deliverables
• Created / modified feeds, Unix scripts, packages, procedures, views & Informatica workflows
• Rectified failed production feeds
• Fixed production defects

Environment: Oracle DB 10g, SQL * PLUS, TOAD, SQL server, Vertica DB, Mainframes

Confidential

Senior Oracle Developer

Responsibilities:

• Owned architectural runway for DB activities
• Designed database schema with appropriate hierarchical structure
• Develop PL/SQL scripts & procedures
• Review deliverables of team
• Designed workflows and tasks for various jobs
• Guidance to developers through coaching & publishing best practices
• Responsible for system analysis, estimation, development, review, and implementation of enhancements of different sizes
• Business analyst: Managed Systems Requirement/End User documentation, interpretation of business requirements, & communication
• Leading and mentoring a team of up to 6 developers

Environment: Oracle DB 10g, SQL * PLUS, TOAD, Quality Center

Confidential

Senior Oracle Developer

Responsibilities:

• Travelled Onsite for requirements gathering
• Coordinated with BA & Montreal team in implementing code changes, code reviews and bug fixes.
• Created and managed business requirement specifications to record and track requirements throughout the project cycle
• Lead offshore team
• Coordinated and tracked system analysis, reviewed and submitted estimation, developed and reviewed, and implemented enhancements of different sizes
• Designed workflows and tasks for various jobs using Informatica
• Scheduled and implemented Autosys jobs

Environment: Oracle DB 10g, SQL * PLUS, TOAD, Quality Center, Informatica, Autosys

Confidential

Senior Oracle Developer

Responsibilities:

• Coordinate with BA and Montreal team in implementing code changes, code reviews and bug fixes.
• Designed DB framework and involved in data mart development
• Lead Bangalore team during POC
• POC Design data load using Informatica & SSIS
• Helped evaluate best ETL strategy

Environment: TOAD, SSIS, Microsoft SQLServer 2012, Informatica

Confidential

Senior Oracle Developer

Responsibilities:

• Lead Bangalore and liaise with Noida team in implementing code changes, code reviews, testing the scripts & bug fixes.
• Use programming languages and development tools to query and manipulate data in the support of production systems and to resolve ad-hoc user requests.
• Provide guidance and support to junior level developers.
• Testing the existing scripts in 10g and 11g environments - changing the scripts to improve performance - validating the functionality

Environment: Oracle DB 10g, TOAD, Putty, SSH

Confidential

Software engineer

Responsibilities:

• Understand business needs and re-design the DB
• Gather requirements from on-shore team, analyze, estimate, develop, and implement change requests. Design, develop, & test PL/SQL scripts
• Designed workflows and tasks for various jobs using Informatica
• Scheduled and monitored Control M jobs
• Involved in COLLAB contest (Innovative ideas)
• Walk In Directions: A web application that can show walk-in directions from any building to another building or to the extent of a person’s cubicle.
• Get To Know: A searchable human resource information application which has information like current role, skills, certifications, project, & responsibilities of a person

Environment: Oracle DB 10g, SQL * PLUS, Quality Center, PL/SQL developer, Informatica, Control M

Confidential

Senior Software Engineer

Responsibilities:

• Understanding report design and data load requirements from on-shore team
• Design, develop, & test PL/SQL scripts

Environment: Oracle DB 10g, SQL * PLUS, Quality Center, PL/SQL developer, Informatica, BO

Confidential

Team Member

Responsibilities:

• Developed a tool which identifies the difference in the setup values across server instances.
• Built test scenarios and test scripts for components and tools developed
• Worked in RICE, Item conversion, and XML publisher
• Worked on Forms and reports enhancements

Environment: Oracle Application 11i, SQL * PLUS, TOAD, Secure Shell, Quality Center, Report Builder 6i, SQL developer, Developer 6i forms, XML publisher