Sql Oracle

EMY GEORGE

Email: **********@*****.***, Ph: 408-***-****

EXPERIENCE SUMMARY:

Oracle PL/SQL developer with 5 years of IT Experience in development and implementation of ORACLE RDBMS(DDL, DML) and as Web Developer with extensive experience in Web UI Development and testing web pages with Usability standards in Windows, UNIX & Linux environments.

Experience in banking, educational and e-learning domain.

Involved in all phases of SDLC like System Analysis, Design, Development, Testing and Deployment of multi-tier web based business applications in Windows and UNIX environment.

Experience and Knowledge in developing PLSQL programs (writing stored procedures, functions,triggers) and SQL queries and shell scripting for batch job scheduling.

Extensive knowledge in Configuration and Integration of Oracle Products - Oracle Client, Oracle Enterprise Manager, third-party tools like TOAD, SQL Loader, etc.

Experience in Development & Production Support in Mainframes with AUTOSYS monitoring Tools.

Scheduled AUTOSYS jobs through inserting, deleting and updating jobs in various development/production instances.

Extensive working experience in analyzing reason for job failures, JIL scripting, handling user queries on Autosys.

Created Oracle reports using Crystal Report for different interfaces to fulfill their business needs.

Knowledge in performance tuning and data analysis using Explain plan, TKPROF and Oracle STATSPACK

Good knowledge on logical and physical Data Modeling & Data ware Housing Concept,ETL

Experience in NDMing data & files for batch processing, UNIX Shell scripting and Version Control System and deployment using ANT.

Experience in using web technologies like HTML, CSS, JavaScript/jQuery for developing web based enterprise solutions.

Good Knowledge in using jQuery Components and integrating back-end applications with AJAX driven web 2.0 front-end using OO JavaScript framework

Worked together with the client community and the IT professionals to deliver quality, efficient and cost-effective software that meets the needs of the corporation, at the time of implementation.

Experienced in all phases of usability testing including user profiles and personas, task analysis, contextual research, test moderation, and reporting.

Creative and problem-solver who always goes the extra mile, and adapt at learning new systems and processes, and has proven ability to work effectively as a team member.

Efficient at meeting deadlines, working under pressure, and managing multiple tasks simultaneously.

VISA STATUS:

Green Card

TECHNICAL SKILLS

Languages

Oracle PL/SQL, SQL, JAVA,J2EE

Database

Oracle8.x/9.x/10

Scripting Language

Unix Shell Scripting, XML, Jquery/Javacsript

Web Technologies /Framework

HTML, XML, JavaScript, JSON, CSS, AJAX, jQuery, Struts MVC, Apache Tomcat

OS

SUN Solaris, RedHAT Linux, Windows 98

Tools & Utilities

TOAD, PL/SQL, SQL * PLUS, AUTOSYS, Crystal Report, ANT, SVN

EDUCATION

B.E in Computer Science & Engineering, Mahatma Gandhi University, India

Pursuing Oracle Database 11g Certification.

WORK EXPERIENCE:

Wells Fargo Bank, San Francisco May 2013 – May 2014

(PL/SQL Developer)

Responsibilities:

Developed consolidated DDL scripts to Create/Alter Oracle objects like Packages, Procedures, Functions, Tables, Views, Index, Sequences, Materialized view and to analyze tables.

Wrote SQL queries to perform DML operations.

Supported testing and UAT environment.

Created Views/schemas, database Links, sequences & synonyms and grant additional access to reports/extracts/AFS data on service request.

Created and refreshed schemas, tables in staging/development environments using export/import utility.

Creation of users, setting default table spaces, temporary table spaces and creation of roles, profiles and frequent modification to user accounts.

Grant privileges to users depending upon the user requests and environments.

Worked on SQL script to obsolete reports and some email addresses of AFSO Emailed

Report for the install.

Actively participated in AFSO WATS (Solaris) migration to REDHAT Production.

Created JIL scripts for new AUTOSYS job creation for Red Hat Production.

Supported Data loading and monitored AUTOSYS jobs in Testing environment as well as Production environment.

Created and modified Oracle Reports in Crystal Report and moved reports to RDO Development as well as Production Server.

Prepared Analysis Documents and SIA documents as part of service request in AFSO group.

Environment :ORACLE 9i/10g, SUN SOLARIS 5.8, RED HAT Linux 4.0, PL/SQL, SQL, TOAD, UNIX Shell scripting, Crystal Report, AUTOSYS.

Alphavista, Sunnyvale November 2008 – December 2010

(Software Programmer)

Responsibilities:

Participated in requirements gathering, analysis, Conceptual Design and Details.

Created tables and wrote sql queries to implement various plugins.

Extensively used JQuery plug-in like Auto populating select-box, Search plug-in, calendar plug-in, and Auto populating multiple select-boxes.

Worked Layout pages designed using XHTML and CSS.

Designed and implemented user interfaces for the website.

Developed dynamic e-mails using JavaScript, and hand coding of HTML and CSS.

Wrote CSS compatible for IE and Firefox browsers.

Fix all UI issues, coding issues, browser compatibility, content defects, image issues and accessibility issues.

Involved in creating JavaScript’s and cascading style sheets for the entire product.

Coordinated with creative team and marketing team.

Build and deploy project using ANT scripts.

Interacted with Java programmers to fix the UI issues in JSPs.

Worked in Agile development environment.

Environment : Java 1.3, HTML, J2EE, JavaScript, jQuery, CSS, UNIX, Oracle10g, PL/SQL, XML, Windows Platforms, IDE- Eclipse.

RSET, Cochin, India June 2006 – June 2008

(Programmer)

Responsibilities:

Played a programmer role in UI design and development of the front-end architecture.

Worked as Scientific Assistant to conduct curriculum programming lab sessions such as DBMS, UNIX, Web Technology (Java, J2EE, Javascript, JSP, Servlet, HTML), C etc.

Given consultancy to curriculum Semester projects in Java- J2EE Enterprise-Web applications.

Designed the class diagrams and implemented the core JAVA classes for the business logic implementation.

Designed complex tables and wrote stored procedures and functions and SQL queries.

Responsible for creating UI standards, front end templates and screen prototypes.

Created CSS navigational menu that is role based, menu items change dynamically, derived from the database in the form of XML.

Handled all the client side validation and tab navigation using JavaScript.

Involved in creating templates by using struts and JSP pages. Helped design and develop testing methodology.

Worked with dynamic HTML i.e. DHTML using CSS, DOM, Events and JavaScript.

Involved in Design UI Screen, Created several mock up Using HTML, CSS and JavaScript.

Front-end validations are done using Java Script.

Managed and updated department’s web resources with the prominent use of JavaScript, Dreamweaver and HTML.

Environment: Java, JavaScript, CSS, HTML, DHTML, Apache, Macromedia, PL/SQL, Microsoft SQL Server.

Contact this candidate