SUMMARY

• 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.
• Over 12 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.

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Developer

Responsibilities:

• Use Oracle Collections, Bulking techniques, Partition utilization to increase performance.
• Create and modify PL/SQL packages, Procedures, Functions, triggers, views, and Complex SQL queries.
• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution.
• Adhere to IT Control Policies throughout design, development and testing and incorporate 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

Sr. Oracle Developer

Responsibilities:

• 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

Senior Oracle Developer

Responsibilities:

• 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

Senior oracle Developer

• Designed and developed code for the Telemetry and Command System. This system enables satellite engineers to build up a complete database of software commands issued from ground control or the on-board computer and associated telemetry data status and diagnostic data returned from satellite electronics . All electronic devices, wiring, commands, and telemetry are modeled, thus allowing a full simulation of satellite functionality to occur prior to build and launch of satellite.
• Coded generic change tracking and approval system for all edited tables. This generic mechanism tracks every user change at the table and column level.
• Coded table-driven security mechanism providing granular access to various aspects of systems screens, menus, subsets of data .

Major Contribution:

• Developed much of the Code Generator that produces 90 of the PL/SQL code required to support each user screen. Using advanced dynamic SQL and PL/SQL techniques, this code reads Oracle
• Dictionary objects Table and Column definitions, Primary and Foreign Key Constraints, etc. and creates the following stored procedures and much more :
• Produces clean, formatted, indented code that follows company coding standards variable naming conventions, calls to common utilities, clean indenting and formatting of code, etc. .
• Greatly improves maintainability since the 45 generated packages all look and read the same.
• Represented our server development group on the Test and Deployment Team. Worked closely with key super user and key client developer to develop test procedures to fully test all logic scenarios.

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

Responsibilities:

• Responsible for complete development lifecycle from requirement gathering till Go Live and warranty support.
• Designed developed code using ORACLE Dynamic PL/SQL, SQL, FORMS, HTML, CSS, JavaScript, and TOAD.
• Strong PL/SQL, SQL experience writing Packages, Procedures, Functions, Triggers, Views, DB Links, Synonyms etc
• Participate in technical discussions. Come up with innovative ways to improve the product and process.
• Communicated with different client, team members, project managers, and co-workers.
• Should provide post implementation support to fix the production issues.
• Review work done by other developers before delivery.
• Should be able to effectively handle team up to 4 members in onsite-offshore model.
• Attended daily scrum meetings with the team for daily updates on the projects.
• 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

Confidential

Responsibilities:

• 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

Oracle Developer

Responsibilities:

• 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

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 HP-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.

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
• Front-end tools/Utilities: TOAD, SQL Navigator, Oracle Sql Developer, Dream weaver 4.0, Crystal Reports Oracle Forms and Reports