We provide IT Staff Augmentation Services!

Systems Analyst Resume

2.00/5 (Submit Your Rating)

Euless, TX

Summary

  • Extensive experience in supporting and Implementing ERP and SCM Applications.
  • 14 Years of experience with design and development of complex SQL, PL/SQL and Oracle Forms/Reports (6i/10g/11g)
  • 7 Years of Project Management experience.
  • 3 years of experience with Oracle APEX.

Expertise

Software Development Client Relationship/Engagement Problem Solving
SCM/ERP Implementations Design and Development Standards Analytical/Fast Learner
Training

Education

MBA - Finance Madras University
BS Statistics Bharathiyar University

Experience

Application Support lead Confidential, Dallas, TX November 2004 - Present
I was hired to Support a SCM Product called ITIMS with installations across the world.

  • Design, develop and implement strategies and processes to the successful delivery of projects.
  • Design and Developed complex logic using SQL and PL/SQL.
  • Debug existing SQL and PL/SQL logic and determine corrective.
  • Responsible for setting up PL/SQL coding standards.
  • Use Explain Plan to Fine Tune SQL queries to improve performance.
  • Developed reporting applications using Oracle APEX.
  • Developed WELL Management Utility (SLAM) using Oracle 10G Developer Suite.
  • Supported OFA and SAP Interfaces for all the sites.
  • Responsible for Month-End reconciliation between ITIMS and Accounting systems.

Systems Analyst Confidential, Dallas, TX 1998 - 2004
I was responsible for conversion of a Developer 2000 application to Forms 6i. Functional Lead for OFA Data conversion.

  • Responsible for setting up standards for the New Forms and Reports.
  • Developed a Web-Based Call management system to track all issues reported by users across the world.
  • Responsible for Training and User Documentation.
  • Responsible for Conversion of an OFA system to MFGPRO.
  • Project Lead for OFA Y2K testing. Responsible for Test Suite preparation and delivery of Test Plan specification, Test Design specifications, Test Case specifications and Test Procedure documents based on IEEE Standards.
Programmer Analyst Confidential, 1997 - 1998
  • Involved in importing Open Items data and AR Sales data into Oracle A/R.
  • Used Auto Invoice import program to create invoices, debit and credit memos.
  • Responsibilities include Customization, Data Migration, Enhancement and Implementation.
  • Involved in writing PL/SQL scripts for converting Old Legacy Accounts into New Oracle G/L Accounts due to the Merger of Field Crest with Pillowtex.
  • Involved in the role of a Consultant at Field Crest Cannon in North Carolina.

Programmer Confidential, Singapore 1995 - 1997

  • Involved in the Design, Development and Implementation of Inventory and Financial and Payroll system for P T Wavin Duta Jaya, Jakarta (Customer of our branch office).
  • The primary assignment is to add VAT requirements into the transaction.
  • This also requires converting the old PROGRESS database to the new ORACLE database.
Programmer Confidential, Chennai, India 1993 - 1995
  • Involved in the System Study for Balmer Lawrie & Co with respect to Financial and Distribution Module of MXP.
  • Involved in the Beta Site testing of MXP Product at Square D Biotec, Cuddalore conducted by Marcam Asia-Pacific for the first in the region.

Jr. Programmer Confidential, Chennai, India 1991 - 1993

Personal: Married with 2 daughters; Interests in Sports and Movies.

We'd love your feedback!