SUMMARY:

I have gained extensive software working experience in IT industry for more than 25 years and across various industries. For last 20 years, I have worked as a software consultant and specialize in UNIX Scripting and Oracle PL/SQL development. Many companies benefited from my innovative outlook and technical expertise, including my problem - solving skills and ability to coach other developers.

TECHNICAL SKILLS:

Software: Toad, SQL Developer, SSMS, Visual Studio, PVCS, Erwin, Exceed

Computer Languages: PL/SQL, KORN SHELL, UNIX/C, OCI, PRO*C,JAVA,JAVASCRIPT,Java Spring Framework, C#SQLServer 2008R2, SSIS, Angular 4

EXPERIENCE:

Confidential, Torrance, CA

PL/SQL, UNIX Consultant

Responsibilities:

• Design and develop the subset of Campaign System in Oracle DB to provide data to the fulfillment vendor.
• In addition, work as SQL Server developer on a chat software.
• Required constant fixes to the existing tables and stored procedures.
• Learn the SSIS tool for ETL process support.
• PL/SQL, KORN Script, Oracle 11g, SQLServer 2008, SSIS, GIT, ClearCase .

Confidential, Deer Valley, AZ

PL/SQL, UNIX Consultant

Responsibilities:

• Perform SQL tuning to the existing SQL used in Datastage as well as the Crystal report.
• Provide production support to the Datastage ETL processes which load daily retail sales data to the Oracle database.
• Knowledge transferred the PL/SQL coding technique to the Datastage and OBIEE developers.
• PL/SQL, KORN Script, Oracle 11g, Datastage Version 8.7, SVN .

Confidential, Houston, TX

PL/SQL, UNIX Consultant

Responsibilities:

• Work as senior oracle developer to this energy/power based company which supply to the commercial and residential properties.
• Provide production support to the existing PL/SQL programs.
• Trained and mentor the full time developers with the best PL/SQL coding practices.
• PL/SQL, KORN Script, Oracle 11g, SVN .

Confidential, Boca Raton, FL

PL/SQL, UNIX Consultant

Responsibilities:

• Work as Lead PL/SQL Developer to provide technical support to the full time developers.
• Work on data conversion project which required in of PL/SQL coding to the SME.
• In addition, work with Java Spring web developer to enhance the database response time of the packages.
• Rewrote packages which was over designed of the oracle collection.
• Keeping simple in code helps the readability and performance.
• PL/SQL, KORN Script, Oracle 11g, Eclipse, Java Spring, JQWidget .

Confidential, Newport Beach, CA

PL/SQL, UNIX Consultant

Responsibilities:

• Work as software architect, developer, QA, production support.
• Challenge work involves software application development of newly required database logic/functionality through analysis, design, coding, and testing; as well as the daily support and maintenance of newly built functionality in a fast demanding financial environment.
• Develop functional enhancements and performance tuning of new/existing PL/SQL programs
• Work extensively with the partition tables to handle big volume of data.
• In addition, use of dynamic SQL to kick off the multiple stored procedures.
• Provide the technical support to technical staff, business users as well as upper management.
• Investigate and resolve bugs identified by OPS, end users.
• Develop work plans and monitor plan progress during the development life cycle
• Participate in collaborative discussions to monitor progress against enhancement and bug resolution
• Provide on - call support and functional assistance to end users.

Confidential, CA

PL/SQL, UNIX Consultant

Responsibilities:

• Design, build, and maintain various parts of the data infrastructure to support financial analysis (requirements gathering, SQL queries, ETL, dimensional data modeling - etc).
• Work with Business Intelligence, DBA, source systems development teams for data acquisition and data quality.
• Identify data issues and their root causes and recommend fixes.
• Develop reporting structures to capture and measure analytic metrics that drive business forward.
• Enhance the PL/SQL programs to meet the new business requirements for the Commission and Billing Systems.
• Assist the senior technical database lead with the optimal coding methodology.
• Help the QA staffs with the testing scenarios.
• All programs were developed in Oracle PL/SQL, and UNIX KORN Shell Script.
• Oracle 11g, UNIX, Window 7.

Confidential, CA

PL/SQL, UNIX Consultant

Responsibilities:

• Optimized the existing PL/SQL programs and developed new programs to meet the newly business requirement for the passport project (credential verification program).
• Guide database developers to optimal coding methodology. Oracle 9i, 10g, UNIX, Window 7.

Confidential, CA

PL/SQL, UNIX Consultant

Responsibilities:

• Architect solutions for Payments of Compensations (Commission, Bonus, Etc) to the Dealers.
• Worked closely with Technical Manager, Business Analyst and Subject Matter Experts to determine their data integration needs and help integrate to their systems.
• All programs were developed in Oracle PL/SQL, and UNIX KORN Shell Script.
• Oracle 10g, TOAD 9.0.1, UNIX HP.

Confidential, CA

PL/SQL, UNIX Consultant

Responsibilities:

• Designed and Developed oracle database repository to store the employees data.
• Source data were provided in SAP IDOC formatted files.
• Wrote UNIX KSH shell script to parse and invoke the SQL*Loader to populate the staging tables
• Wrote many packages for data loading operations as well as data extracting operation.
• Develop all the interface programs, which were written in Oracle PL/SQL, and UNIX KORN Shell Script, to feed the peripherals systems.
• Provided UNIX installation script to release/support team.
• Oracle 10g, TOAD 8.6, 9.0.1, UNIX AIX 5L, Oracle Designer 6i.