SUMMARY

• 5 years of professional experience in development, support, testing and implementing of client/server and multi - tier applications using Oracle database 10g, 11g, 12c, PL/SQL, Oracle Forms, utilizing SDLC methodology in UNIX, LINUX and WINDOWS.
• Proficient in SQL and PL/SQL programming- Creating Packages, Stored procedures, Functions, cursors, ref cursors, Nested Tables, triggers, types, Bulk collection and Pipelined Functions.
• Experience in writing UNIX shell scripts, ESP.
• Used SQL and PL/SQL performance tuning techniques which included creating indexes, partitioning tables, providing Hints, Optimizer query execution plans, SQL trace and TKPROF
• Usage of vi editor for writing the Unix korn, bash scripts.
• Good understanding and experience in Data modeling, ER Diagrams, Normalization and De-normalization of Tables.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language and maintaining the DDL scripts
• Proficient in features of Oracle for PL/SQL programming like using cursor variables, Ref cursors, arrays, nested tables and Dynamic SQL.
• Experience in working with Object Oriented Programming concepts
• Excellent problem solving and decision-making skills.
• Proven leadership and organizational abilities.

TECHNICAL SKILLS

Data Base: Oracle 12c/11g/10g, MS Access and MS SQL Server

Operating Systems: UNIX, Linux, Windows

Data Base Tools: SQL *Plus, Toad, Oracle SQL developer, SQL Navigator

Utilities: UTL FILE, DBMS PIPE, Exp, Imp and Data pump, SQL *loader

Tools: Oracle Forms and Reports 10g, 6i, 2.5, Erwin, Rational Rose

Languages: SQL 11g, PL/SQL 12c/11g/10g, C, JavaScript, Unix Shell Scripting

Web Technologies: HTML 5, CSS 3, Java Script and XML

PROFESSIONAL EXPERIENCE

Confidential

Oracle PLSQL Developer

Responsibilities:

• Monitor incoming/outgoing data and troubleshoot errors as they occur.
• Interacted client in Agile and supervised in preparation of the technical documentation.
• Used PL/SQL programming including Oracle Web toolkit, HTP, HTF and OWA packagesWeb UI development skills using following technologies - JavaScript, HTML, CSS and XML.
• Maintained data in relational structure using Tables, Views, Materialized Views, TemporaryTable, External tables.
• Designed DB tables using Indexes, Partitions, Sequences, Synonyms, Grants and Roles.
• Wrote PLSQL - Packages, Procedures, Functions using Cursors, Ref Cursors, Dynamic SQL,
• Bind Variables, Bulk Collect, Bulk Bind, Pipelined functions, Collections, PLSQL Table, XML Parser.
• Wrote complex business transformation using PL/SQL and delivered data to target tables.
• Apply required pre/post validation to assure correctness of data for business.
• Extract DDL for Schema from lower environments and deploy in upper environments.

Confidential, San Jose, CA

IT Developer

Responsibilities:

• Monitor incoming/outgoing data and Troubleshoot errors as they occur.
• Create and maintain technical documentation, process flows, etc
• Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 11g and Oracle Forms builder 11g respectively.
• Participate in weekly team meetings.
• Worked thoroughly on coding and debugging of Stored Procedures, Functions, Packages and other Oracle Objects to implement Business Rules.
• Wrote PL/SQL Database Triggers to implement the business rules in the application
• Extensively worked with DBAs and BAs towards performance tuning
• Created indexes and nested tables as a part of tuning.
• Generated SQL and PL/SQL scripts to create and drop database objects including: Tables, Views and Primary keys, Indexes, Constraints, Packages, Sequences and Synonyms.
• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs and running files in batch mode.
• Developed PL/SQL Triggers and Master Tables for automatic creation of primary keys.

Environment: Oracle 10g/11g, PLSQL Developer, My Eclipse, Toad, Autosys, UNIX, OBIEE, Java and SVN Tortoise.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Performance tuned DB Queries.
• Updated tables without breaking the existing functionality
• Check shell scripts, and PL/SQL scripts if any is used.
• Scheduling Execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.
• Created new Tables, Indexes, and Sequences where needed.
• Created Database Triggers for Data security & Consistency.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Developed PL/SQL Packages and Database Triggers.
• Involved in Data Modeling DB Queries.
• Designing system work flow diagrams using UML
• Infrastructure Monitoring/Alerting.
• Identify potential issues early and before impact with proactive monitoring.

Confidential

Web/UI Developer

Responsibilities:

• Responsible for the overall layout design, color scheme of the web site using HTML5, XHTML and CSS3 and Responsible for creating detailed wire frames and process flows
• Developed different JQuery component in MVC micro architecture framework, which internally use various design pattern such as singleton, command, delegate, etc.
• Developed UI using HTML5, CSS3, Angularjs for interactive cross browser functionality and complex user interface
• Developed HTML prototypes and UI deliverables, such as wireframes, flowcharts, screen mock-ups, and interface design specifications
• Designed Frontend with in object-oriented JavaScript Framework like AngularJS,
• Using Twitter Angular Bootstrap, HTML5, CSS3 for Layout and Design
• Worked on prototypes for Responsive design
• Used Dreamweaver, Photoshop, Flex for implementing application and designing graphics and images
• Wrote extensive HTML, CSS and JavaScript code to build dynamic pages using Eclipse
• Designed DOM based interactive to reprogram selected links and adopted WCAG 2.0 standards for HTML and XHTML and W3C standards for CSS as well
• Used AJAX for implementing part of the functionality for Customer Registration, View Customer information modules
• Used agile methodology for the software development

Environment: HTML5, HTML4.01, CSS3/CSS2, JavaScript & AngularJS,