190 likes | 384 Views
Programmer Analyst Internship. Michelle Cotton. Securian Financial. About Securian. Provides individual insurance, group insurance, retirement, and other financial services Headquartered in St. Paul Over 9 million clients nationwide Over 5,000 associates . What I did this Summer. Training
E N D
Programmer Analyst Internship Michelle Cotton Securian Financial
About Securian • Provides individual insurance, group insurance, retirement, and other financial services • Headquartered in St. Paul • Over 9 million clients nationwide • Over 5,000 associates
What I did this Summer • Training • HTML, JavaScript, XML, C++, Informatica, Lotus Notes, Java Batch, Test ESP, AccuRev • Distributed Batch Environment Migration • C++, Internal FTP, Batch Utility, File Watchers • Other • HTML – Maintenance • HTML - Testing
Main Project: DBE Migration • Year long project (June 2011 – June 2012) • Convert all files in scope to use new logic • Sets variables based on DBE environment • DBE variable: local, test, production
DBE Migration – C++ • Retrieved and printed financial information • Added programming changes • Created testing plan • Ran program on two computers at once to compare output • Didn’t quite go as planned…
DBE Migration – C++ if (DBE = local) { filepath = C:\… } if (DBE = test) { filepath = //test file share } if (DBE = production) { filepath = //production file share }
DBE Migration - FTP • FTP: Copies files from mainframe to hard drive, or vice versa. • Used Test ESP to test • Completed PCR/ Job Requisition forms for production testing • Submitted LBT document changes • Sent Testing Sign Off form
DBE Migration – Batch Utility • Generally used to move or rename files • Added logic similar to C++ files • Used similar testing process to FTP jobs • Example: Move test files into dated folders
DBE Migration – Batch Utility set today=%date:~10,4%%date:~4,2%%date:~7,2% if “%DBE%” = “” ( echo DBE variable not set exit 7 ) if “%DBE%” = “local” ( set filepath = C:\... ) … move %filepath% %filepath%%today% exit 0
DBE Migration – File Watchers • Waits a certain amount of time for a file to be FTP’d • Stops running after it finds the file or the time limit is exceeded • Check mainframe for result • Successful if it found the file • Failed if the file was not found
Internship Program • Product Seminars • Met previous interns • Learned about the company and the services it provides • Leadership Seminar • Met the CEO and CIO of Securian
Internship Program • Social Committee • Twins Game • Dinner Cruise • SkyZone – 3D Dodge ball • Other Activities Planned by Securian • Arboretum • Feed my Starving Children • Katy Perry
Want More Information? • http://www.securian.com/Securian/Careers/Students • Questions?
Works Cited • http://www.archalliance.com/blog/?p=589 • http://www.goffpublic.com/case-studies/lobbying-and-government-relations/securian-financial-group/ • http://www.securian.com/Securian/About+Us/Securian+Financial+Group • http://www.securian.com/Securian/Careers/Students