SUMMARY:

• Over 13+ years’ experience in commercial application design and development, testing, reverse engineering Oracle Developer/2000 tool sets in Windows NT.
• Excellent skills in designing and development of applications using Oracle 11g/10g/9i/8i/7.2, SQL, PL/SQL Good knowledge on Oracle tools like SQL * PLUS, PL/SQL, SQL and used TOAD in many development projects.
• Excellent SQL skills, experience writing complex queries and working with database objects like tables, views, sequences, synonyms.
• Expertise in developing advanced PL/SQL code through various stored procedures, functions, cursors, triggers, packages and materialized views.
• Experience in Bulk Data loading using Oracle utilities namely SQL Loader and External Tables.
• Expertise in Query Performance Tuning by Analyzing tables, hints, DBMS Profiler, TKPROF, SQL Trace, Explain Plan, Bulk Collect feature, Materialized Views and Troubleshooting Oracle database issues.
• Worked on Crystal Reports.
• Experienced in DB Design, Oracle Forms reports, PL/SQ Development and DBA.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• Experience working in both Data Warehouse and OLTP environments.
• In - depth development experience with warehouse or OLAP based technologies, preferably on Oracle's 10g OLAP or Express platforms, to include all phases of the software development lifecycle, including production support.
• Proven track record of database design and modeling.
• Good knowledge of Data Modeling using ETL tools, OLAP tools, Star Schema, Snowflake Schema, and Entity-Relationship Diagrams.
• Highly motivated and adaptive with the ability to grasp things quickly with excellent interpersonal, technical and communication skills. Ability to work effectively and efficiently in a team and individually.
• Team Player with ability to maintain team spirit and resolve conflicts within the team with ease and calmness. Ability to drive team with ideas and thoughts and keeping everyone engaged.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows 7, Windows XP/2003/2000/NT/98/95, UNIX, LINUX.

DATABASES: Oracle 11g/10g/9i/8i, 7.2, Access 2007, and MySQL

LANGUAGES: C, C++, Java, JavaScript, SQL, PL/SQL, UNIX, XML, Linux, Apache, PHP, HTML, CSS, Visual Basic

ETL TOOL: SQL Loader

FRONTEND TOOLS/UTILITIES: TOAD, SQL Navigator, Oracle Sql Developer, Dream weaver 4.0, Crystal Reports Oracle Forms and Reports

EXPERIENCE:

Confidential, San Diego, CA

Sr. Oracle Developer

• Generate discrepancies report between Cyborg and Workday system by using SQL, and PL/SQL.
• Created around 45 Views to generating Automatic discrepancies reports for given company, HED numbers, and employees.
• Created scripts to create new tables, views, queries for new enhancement in the application.
• Worked on Workday application to test Payroll and Benefit functionalities.
• Created PL/SQL stored procedure to generate Excel spreadsheet reports between Cyborg and Workday systems.
• Developed PL/SQL procedures to import the data from Workday to Cyborg.
• Developed PL/SQL Packages to generate a Benefit Deduction, Employee Salary, Payment Election, Passport Visa Changes, Contact Information, Service Dates, Supervisor Info, and many other reports automatically.

Confidential, Los Angeles, CA

Senior Oracle PL/SQL Developer

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Environment: Oracle 11g SQL, PL/SQL, SQL*Loader, SQL Navigator, TOAD, HTML.

Confidential, Dublin, OH

Senior Oracle Developer/PL SQL Developer

• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution.
• Create and modify PL/SQL packages, Procedures, Functions, triggers, views, and Complex SQL queries.
• Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.
• Adhere to IT Control Policies throughout design, development and testing and in corporate Corporate Architectural Standards into application design specifications.
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications;
• Identify/troubleshoot application code-related issues and provide a solutions.
• Prepare deployment groups for migration of code to QA and Production environments.
• Transform the data from flat files using SQL* Loader and Windows Server.

Confidential, Palo Alto, CA

Sr. Oracle Developer

• Provide production support for SCDE (Supply Chain Data Exchange) application.
• Transform the data from flat files using SQL* Loader, SQL* Plus, and Sql Developer.
• Performance tuning and optimization of SQL statements.
• Used TIDAL to schedule the jobs.
• Worked with partitioned tables in very large database environment in RAC databases.
• Writing packages, complex stored procedures, functions, views, and data base triggers using SQL and PL/SQL in Oracle.
• Schedule Oracle jobs for update, validate data and create vendor reports for analysis.
• Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.
• Guide and code review of junior developers,
• Interact with the clients, collect requirement, and develop technical specification.
• Environment: Windows 7, Oracle11g, PL/SQL, SQL*PLUS, SQL* Loader, Oracle Jobs, Sql Developer, TIDAL, HTML, JavaScript.

Confidential, Phoenix, AZ

Senior Oracle Developer

• Performance tuning and optimization of SQL statements.
• Writing packages, complex stored procedures, functions, views, and data base triggers using SQL and PL/SQL in Oracle.
• Designed, Developed Inquiry Counters, Inquiry Counters Detail, and Inquiry Counters Trend Applications.
• Support Developed, Designed and Tested Purchase Order Inquiry forms, Vendor On Hold Forms.
• Schedule Oracle jobs for update, validate data and create mortgage reports for analysis.
• Modules used are Loan Management, Refinance Management and BOM.
• Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.
• Interact with the clients, collect requirement, and develop technical specification.
• Transform the data from flat files using SQL* Loader, SQL* Plus, and TOAD.
• Environment: Windows 7, Oracle11g, PL/SQL, SQL*PLUS, SQL* Loader, Oracle Jobs, TOAD, HTML, JavaScript, and MKS.

Confidential, Palo Alto, CA

Senior Oracle Developer

Responsibilities:

• Attended daily Scrum meetings with the team for daily updates on the projects.
• Self-starter, with ability to work in a team environment and as an individual.
• Collect requirements from the customers and prepare Business, Functional and Technical Documents.
• Working experiences using SQL* Loader, SQL Developer, SQL* Plus, and TOAD.
• Maintain and modify PL/SQL programs.
• Strong experience on SQL and PL/SQL performance tuning using Tkprof /EXPLAIN/SQL Trace.
• Data Modeling, Data Warehousing, PL/SQL, ETL processing
• Managing Oracle objects including tables, indexes, views, constraints, db links, jobs, snapshots, etc.
• Worked extensively on 15 TB Oracle Data Warehouse, designing, writing specifications, and writing SQL and PL/SQL on a daily base, including Functions, Procedures, Packages, Triggers and ETL Processes. Special attention was given to performance using ALL Oracle newest features like Analytical Functions, Index Organized Tables, Function Based Indexes and Exchange Partition.
• Ability to write well-abstracted, reusable code for all modules.
• Extensively used BULK COLLECT (Implicit/Explicit Cursors), FORALL statements for bulk binding, Partition Utilization to increase performance.
• Used Data Pump, Export/Import, and Oracle Scheduler.
• Troubleshoot/Resolve any Database/Application issues.
• Written Perl and Shell script to upload files, images from User Interface.
• Design, Develop and Maintain of related Forms and Reports.
• Reviews, designs, tests, implements and maintains Crystal Reports.
• Codes complex stored procedures in Oracle for use by the Crystal Reports.
• Developed advanced database driven Web Applications.
• Managed multiple assignments, set priorities and meet deadlines..
• Documenting features, technical specifications & infrastructure requirements.
• Used TOAD to develop all Oracle objects.
• Environment: Windows NT 4.O. Windows XP. Unix, Perl, Oracle (10g, 11i), Dynamic SQL, PL/SQL 8.0, SQL*PLUS, TOAD, HTML, JavaScript, LAMP, VB 6.0. And MKS
• Responsible for complete development lifecycle from requirement gathering till Go Live and warranty support.
• Attended daily scrum meetings with the team for daily updates on the projects.
• Should be able to effectively handle team up to 4 members in onsite-offshore model.
• Review work done by other developers before delivery.
• Should provide post implementation support to fix the production issues.
• Communicated with different client, team members, project managers, and co-workers.
• Participate in technical discussions. Come up with innovative ways to improve the product and process.
• Strong PL/SQL, SQL experience writing Packages, Procedures, Functions, Triggers, Views, DB Links, Synonyms etc
• Designed developed code using ORACLE Dynamic PL/SQL, SQL, FORMS, HTML, CSS, JavaScript, and TOAD.
• Develop and maintain interfaces to/from external systems and custom code in accordance with business requirements.
• Performed key role in cross-functional teams through development, testing, and product launch.
• Environment: Windows NT 4.O. Windows XP. Unix, Oracle (10g, 11i), Dynamic SQL, PL/SQL 8.0, SQL*PLUS, TOAD, HTML, JavaScript, VB 6.0. And MKS
• Attended daily scrum meetings with the team for daily updates on the projects
• Communicated with different client, team members, project managers, and co-workers
• Worked with Business Analysts and customers to understand and validate end-user requirements in accordance with business need.
• Develop PL/SQL packages, Procedures, Functions, Triggers by Using TOAD.
• Developed advanced Web Reports by using PL/SQL, SQL, HTML, JavaScript, and CSS.
• Managed multiple assignments, set priorities and meet deadlines.
• Performed key role in cross-functional teams through development, testing, and product launch.
• Environment: Windows NT 4.O. Windows XP. Unix, Oracle (10g, 11i), Dynamic SQL, PL/SQL 8.0, SQL*PLUS, TOAD, HTML, JavaScript, LAMP, VB 6.0. And MKS.

Confidential, San Carlos, CA

Oracle Developer

• Responsible for development of funds disbursement process, which disbursed funds, based on affiliate’s specific disburse routing options.
• Writing code, which allow users to change the charities, which are associated with pledges.
• Developed data upload scripts using SQL*Loader which uploads data from the legacy (spreadsheets format) into oracle database.
• The procedures, functions, packages and triggers were developed using PL/SQL.
• Also handled some of the DBA’s responsibilities which includes creating user’s, altering user’s, granting privileges, creating roles, modifying data types and other responsibilities.
• Environment: Windows NT 4.O and UNIX, Oracle8, SQL, PL/SQL 2.3, SQL*PLUS and SQL*Loader.

Confidential, Cupertino, CA

Oracle Programmer

• Duties include monitoring and reconciling daily production
• Issues of the oracle 8.0 profiler database and data conversion.
• Running and monitoring of the customer’s sample database.
• Application, additional tasks include enhancing, testing
• And implementing PL/SQL and Confidential -UX shell scripts to confront changing business rules.
• Create AD HOC SQL series to examine possible data integrity flows and resolve phone and e-mail inquiries in a timely manner regarding database structures and data analysis.
• Also responsible for documentation updates and production audit trail reports.
• Analysis of exiting data, develop strategy for conversion, develop processes to convert data, develop processes to duplicate existing calculations, test Conversion routines, work closely with the rest of the Reporting Project development team.