PROFILE SUMMARY:

• IT Professional with 19 years of solid Oracle development experience in diverse industries; selected expertise encompasses application development, data modeling, database design, ETL, systems migration and Golden Gate .
• Experience in Oracle ERP, Financial Applications, Banking, HRM, Supply chain, Materials Management and Government industries; hands - on experience in Oracle Applications (AR, AP, GL, INV, HRM) customization.
• Experience in Agile, Scrum software development; involved in all phases of SDLC.
• Brings ability to liaise with diverse technical teams; gathering, managing and documenting technical and functional requirements.
• Effective communication ability and noteworthy analytical skills; consistently meets deadlines with superior results.
• Strong verbal and written communication skills as well as strong analytical and problem solving capabilities supporting matrix organizations and end users.
• Able to adapt to new development environments, changing business requirements and learning new systems; ability to work with team and independently.

TECHNICAL SKILLS:

RDBMS: Oracle 11gr2,10i/g, 9i, 8.x, 7.x, 6.0, SQL Server 2000/2005, MS Access 2003/2007

Languages/OS: C, PL/SQL, T/SQL, Basic, Pascal, Windows, Unix, Sun Solaris, HP-UX, Unix, Windows Server, NT 4.0, MS DOS

Web Technologies: HTML, XML, JAVA

Web Servers: Tomcat 6.0, Java 1.6, Weblogic Apache

GUI/Tools: TOAD, SQL Developer, SQL Modeler, Informatica, Oracle Reports 10g, 9i, 6i, Oracle Forms 12i, 4.5/5.0/6./6i/9i/10g Visio, Oracle Designer x, Oracle Developer x, SQL*Loader, Oracle IMPORTS & EXPORTS Oracle Graphics 2.5, Query Builder, Procedure Builder, Schema Builder, Oracle Designer, Discoverer 3.1(admin & user edition), SVN

Help Desk/Reporting/Testing Tools: JIRA, Remedy, Business Objects, Team Track, Track-It, Active Reports, MS Office, Project

PROFESSIONAL EXPERIENCE:

Martinez, CA

Senior Oracle Forms and Reports Developer

Responsibilities:

• Start Building Inventory Application from scratch.
• Sharing in ERD and main design of Database
• Manage Installation, Configuration of Oracle Java, Weblogic and Oracle Forms and Reports
• Build and Maintain new Forms using Oracle Forms.
• Build and Maintain new Reports using Oracle Reports.
• Very high level of PL/SQL programming- packages, triggers and stored procedures as part of the product.
• Maintenance and development of ETL with large volumes of data (Oracle 10g/11gR2 instances ranging from 1to 7 TB).

Technologies: Oracle DB 11gr2, Oracle Forms and Reports 11gr2, Oracle Weblogic 10.0.3.6, JAVA, TOAD, SQL Developer, MS Office Tools.

Silver Spring, MD 

Senior Oracle Developer

• Writing high quality packages, procedures and triggers using PL/SQL according to the business requirements.
• Physical and relational data modeling and design using Oracle SQL Developer Data Modeler.
• Analyzing and/or developing requirements and monitoring performance and assisting with quality assurance.
• Identifying and designing reporting and analytic information solutions by translating complex business, data, and non-functional requirements into information solution options and detailed technical ETL (Extract, Transform, Load) and data designs.
• Generating report with using XML and CSV file format as data source.
• Working with complex data models and object relational database mapping.
• Ensuring that application design is scalable and maintainable and all deliverables are thoroughly documented.
• Practicing Scrum development methodology.

Technologies: Oracle 11gr2, JAVA, TOAD, SQL Developer, Tortoise SVN, JIRA, MS Office Tools.

McLean, VA 

Oracle Developer

• Wrote packages, procedures and triggers using PL/SQL as per the business needs.
• Maintenance Oracle Forms and Reports
• Very high level of PL/SQL programming- packages, triggers and stored procedures as part of the product.
• Maintenance and development of ETL with large volumes of data (Oracle 10g/11gR2 instances ranging from 1to 7 TB).

Technologies: Oracle DB 11gr2, Oracle Forms and Reports 11gr2, Oracle Weblogic 10.0.3.6, JAVA, TOAD, SQL Developer, MS Office Tools.

Oracle Database Developer

• Developed several PL/SQL packages, procedures, functions and triggers.
• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration of Oracle data; physical data modeling, partitioning and developing optimization/indexing strategies on the Teradata platform.
• Used RTC accept to deliver and check-in the code and wrote UTPLsql unit test scripts for test packages.
• Involved in Unix shell scripting to provide automation for jobs.
• Primarily responsible for deployment script, and performed some DBA tasks for comparing Production DB schemas with Test and Development instances.
• Responsible for Metadata Tracker (Dictionary) updating.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Involved in Bug Fixes including Job failures and firewall changes.

Technologies: Oracle 11gr2, Power Designer, TOAD, SQL*Loader, Rapid SQL, Putty, MS Office.

Senior Oracle Developer/DBA

• Promoted from Developer to Lead Developer to Team Lead; had a team of 5 developers reporting to me.
• Student’s System (schedule, results record, SMS, web services)
• Data migration and conversion project for Forms and Reports from Oracle 6i to 9i to 10g to 11g)
• ERP Systems including financial, student registration and document archiving.
• Personnel and Payroll Management System
• Custom and Transportation Systems
• Provided technical support for Oracle Application 12 Oracle ERP (Financials & Human Resources, HRM, Payroll and Inventory).
• Developed robust reports using Oracle Reports.
• Forms Oracle Fast formula, Oracle Forms & Oracle workflow customization.
• Preparation of test scripts for several modules and tasks.
• Responsible for testing and documentation of the test results.
• Heavily used Oracle Forms, PL/SQL, SQL, SQL*Loader.
• Developed several Oracle Forms, Reports, PL/SQL and SQL scripts for the above customizations.
• Developed several new PL/SQL packages, procedures, Functions and triggers.
• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Creating primary database storage structures (tablespaces), creating primary objects (tables, views, indexes), and optimizing the performance of the database, backup, recovery, create new users and grant users for privileges.
• Closely monitor and maintain database and oversee the systems performance and implementation according to the set plans.

Technologies: Oracle 6i to 11g, TOAD, SQL Developer, Tortoise SVN, C Language, Oracle Designer, Oracle Forms/Reports Builder, RMAN, RAC, MS Office Tools.

Systems Analyst/Programmer

• Developing custom extensions to Oracle ERP.
• Technical system analysis, design, documentation & development and customization of Oracle back end application routines.
• Developed several customizations using Oracle PL/SQL packages programs, database triggers, forms, Reports.
• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Development, design, documentation and implementation of custom reports for using SQL, PL/SQL & Oracle Reports.
• Developing & integrating custom forms; Reports for Oracle Apps 11i.
• Oracle ERP Integration and Data conversion for various modules within Supply Chain, Financials & Manufacturing.
• Developed control files, SQL*Loader scripts, Oracle import and export scripts for data loading, migration and backup of Oracle data.
• Data Integration & Management: Mirroring, Log Shipping, Replication, Materialized Views, Power Pivot, Data Normalization, Table Partitioning.
• Installation of Oracle Database Enterprise and connect users to the server (tnsnames.ora), import and export database, using ODBC to make migration from any other database like access or SQL server, creating database users and tables and following the performance of database.
• Analyzed business or scientific problems for resolution through electronic data processing, gathering information from users, determining work problems and designed a system of computer programs and procedures.
• Performed database design, setup, software development and implementation.

Technologies: Oracle 6i to 11i, TOAD, SQL Developer, C Language, Oracle Designer, Oracle Forms/Reports Builder, RMAN, RAC, MS Office Tools.