1 / 11

TD Ameritrade IT audit intern

TD Ameritrade IT audit intern. Ramez Mina. Position definition. Department head  IT audit intern Managers  system analyst and developer to build automated system. Requirements  Unix based system, access to MS SQL server, access to Oracle server, other data resources access.

barth
Download Presentation

TD Ameritrade IT audit intern

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TD AmeritradeIT audit intern Ramez Mina

  2. Position definition • Department head  IT audit intern • Managers  system analyst and developer to build automated system. • Requirements  Unix based system, access to MS SQL server, access to Oracle server, other data resources access. • Permission from dept head  obtained • Permission from IT dept  denied • IT staff??

  3. Configuration of their server • SUSE linux based server • Not connected to internet • Has the basic installation • No compilers of C, C++ or Java • No DBMS server or a web server. • Has Perl package installed, but no extensions or modules. • Not even a VIM editor

  4. Challenges • Spent first 2 weeks trying to install and configure the server using rpm modules. • Dependencies made it really difficult • Had a meeting with one of the system administrators.

  5. Change of plan • Only tool to use was Perl • Instead of the automation system, they had mini non related problems. • Perl was so helpful in solving these problems. • Learned HTML to process some reports of their DBMS. • Learned XML to report some data in a presentable fashion

  6. Examples of Perl scripts • Reading tables from HTML file • Output them in separate files. • Run some math operations on these tables • Make sure they are importable to excel sheet • Process unix-based logs • Cleaning the logs and make them readable • Make sure they are importable to excel sheet • Run some math and statistical operations on the data

  7. Examples of Perl scripts – Con’t • Process mini database from text-based files • A replacement and evolution of a software they already have. • This software had limitations for the functions it provides. • Output the results as text files, or HTML files to be imported by excel. • Reading files with specific hierarchy and convert them to XML.

  8. Requirements, implementation, testing • All the programs had a requirement overview • Prototypes • Implementation using Perl • Testing • On SUSE server • On Windows using cygwin

  9. Other assignments • IT audit assignment • Money laundry online course. • Questionnaire for organizational behavior.

  10. Interview • Department head required me to interview an applicant for a full time position • They changed the position requirements to meet a developer in addition to IT auditor . • They had a hope they would get full privilege for the new staff. • My role was to investigate their development skills, and measure if they would be able to implement the department automation system.

  11. Thank you Questions!

More Related