Jaspreet Singh
1018 W 23 Street, Los Angeles, CA, 90007 ● (213) 300-0138 ● jasprees@usc.edu OBJECTIVE: Summer Internship for 2009 PROFILE ♦ 25 months of IT industry experience encompassing a wide range of skill set, roles and industry verticals. ♦ Extensive experience with analysis, design, development, customizations and implementation of software applications including ERP applications. ♦ Proficient in analyzing and translating business requirements to technical requirements and architecture, strong Oracle database skills and development knowledge. ♦ Gave PeopleSoft and Oracle Database Administration training to a batch of 6 IBM resources. ♦ Experience in leading and managing teams. Handled multiple roles – Team Member, Team Lead, Business Analyst, Developer, System/Server Administrator, and Oracle DBA. ♦ Executed software projects for Insurance, Re-Insurance and Investment industry. ♦ Good communication skills, interpersonal skills, self-motivated, quick learner, team player. SKILL SET
Languages: Development Tools: RDBMS: ERP: Reporting Tools: Platforms: Others: C/C++, Java, UNIX Shell Scripting, Perl, Assembly Languages, Peoplecode, VBA, HTML, C#.net PeopleTools, SQR, TOAD, MS Excel Macro, QT (Linux), Visual Studio, PS Change Assistant Oracle 9i/10g, MS-SQL Server 2000/2005, mySQL, MS Access PeopleSoft (PS) XML, SQR, Crystal Reports, XQuery Windows NT/2K/2K3 Server, HP-UX 11.1, Sun Solaris, Linux, AIX, HP, Mac, NACHOS Socket Programming, BGP4, RIP, OSPF, Iperf, GNU Zebra, PS Administration 8.48
rd
EDUCATION University of Southern California, Los Angeles, CA Master of Science, Computer Science Cochin University of Science and Technology, Kochi, India Bachelor of Technology, Computer Science and Engineering
May 2010 Current GPA: 3.85 May 2006 GPA: 3.8 (Scaled)
WORK EXPERIENCE J u n 0 6 – J u l 0 8 , D e v e l o p e r / P S S e r v e r A d m i n / O r a c l e D B A - IBM GS , I n d i a April 07 –July 08, XL Capital PS Financial Upgrade Project: XL Capital PS Financial Upgrade Role: Developer/PS Server Admin/Oracle DBA Responsibilities: ♦ Only offshore Database Administration (DBA) cum PS (PeopleSoft) Admin from India. ♦ I was also part of the Technical Development. I worked on AppEngine, Online Customization and VBA macro. ♦ I used to handle the database refreshes/backups, PeopleSoft Administration, project migrations, data export/import, binary setups, and developing shell scripts for the mounting, machinating, and monitoring different UNIX box and Database activities. ♦ I was a key contributor in tasks where both PeopleSoft admin skills and PS technical skills were required at the same time from a single resource. Environment: PeopleSoft FSCM 8.9, PeopleTools 8.48, Oracle 10g Team Size: More than 80 ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ Aug 06 – Nov 06; Mar 08 - Apr 08, IBM – GBSC’s Assets Development Project: PS Label Change Utility Tool; PS Conversion Engine; PS Extraction Engine Role: Technical Developer/Business Analyst/PS Admin Responsibilities:
♦ ♦ ♦
Developed three generic tools/Assets for IBM which could be used in any PS project. One of these was awarded the best paper in IBM’s Oracle ISV in Jan 2007. The analysis, designing, documenting, and building have also been my job, making me to go-through the whole software development life-cycle.
During the performance enhancement phase in Mar-April08, I executed a PeopleTools upgrade from 8.46 to 8.49 using Change Assistant. Environment: PeopleSoft HCM 8.9, PeopleTools 8.46.08/8.49.09, Oracle 10g Team Size: 3 ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ Dec 06 – Mar 07, Moody’s Invertors Service PS HCM/Financial Upgrade Project: Moody’s Invertors Service PS HCM (Human Capital Management) /Financial Upgrade Role: Technical Analyst/Developer Responsibilities: ♦ I was involved in the Finance Application Re-implementation from version 8.0 to 8.9 with PeopleTools Upgrade from version 8.20 to 8.48. Along with this, there were a lot of new Implementations to support the previous Environment. The major modules involved were Accounts Payables, Accounts Receivables, Billing, and General Ledger where I worked in SQR/AE/PSQuery. Environment: PeopleSoft FSCM 8.0/8.9, PeopleTools 8.20/8.48, Oracle 10g Team Size: Around 40 ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ Academic Projects:
♦ ♦ ♦ P2P File Sharing System: Designed and developed a peer-to-peer file sharing system in C/C++ based on UNIX-socket programming. Apr 2009 CISCO router Configurations: Implemented BGP Oscillations behavior, blackholing, sinholing, traceback, tcp fairness, RED and isolation. Apr 2009 Extending NachOS: Implemented significant modules of an operating system for a simulated MIPS-style workstation using NachOS, a UNIX based Operating System Simulator. Nov 2008 - Implemented locks and condition variables for synchronizing the multi-threaded "Pay” Phones system in kernel mode. - Exhibited multi-programming to execute multiple user program instances of the system, using a new set of system calls. - Enhanced the software memory management using Virtual memory by introducing TLB, IPT and Swap-File concepts. - Fabricated a reliable Distributed Senate Phone System using new generic systems calls and Remote Procedure Calls. ♦ ♦ ♦ SPY CAR: Developed an Internet controlled Surveillance Car/Robot using PIC, and RF modules. NIDS: Implemented a base for the Network Intrusion Detection Systems Tool on Linux. LAN Chat Room: A Client Server implementation using socket programming on Linux using QT IDE. Apr 2006 Apr 2005 Oct 2004
♦
Key Initiatives ♦ Driving SME(Subject Matter Expert) initiative for AppEngine, PS ServerAdmin, PTs Upgrade and Oracle-DBA ♦ ♦ ♦ Active participation in the conference calls with the client Helping and training new team members to understand the project requirements and the various procedures. Helping team members to work with their respective specifications.
Achievements: ♦ IBM’s Service Excellence Bravo award for performance in XL Capital Project in Jan’08 ♦ IBM’s Bravo award for presenting Best Paper at IBM Oracle-ISV Sharenet in Jan’07. ♦ SME (Subject Matter Expert) and the main point of contact in IBM for PS GBSC Assets. ♦ PeopleSoft Certified Champion Developer. Trainings Acquired: ♦ Trained on PeopleTools 8.47 at IBM India Pvt. Ltd. ♦ ♦ Attended Classroom training for Oracle University PeopleSoft Server Administration 8.48. Online Application Services Data Privacy, Introduction to SOA and Web Services