Data System

Geetu Aggarwal

**-** ** ******, **** Park, Apt: 1D, NewYork City 11374, NY.

Email: **********@*****.***

. 4+ years of experience in software design, development, testing,

deployment and support

. 5+ years of experience in teaching and official work in computer

science.

. Worked in different phases of software development Life cycle

. In-depth knowledge of software development architecture and

specification, online system interfaces, system conversion, database

web design, adhoc reports and trouble shooting.

. Proficient in Perl + Korn Shell scripting

. Expertise in DBI/DBD, Sybase and Perl development

. Strong T-Sql, query and performance tuning skills

. Specialized in application development and maintenance support of

financial related applications.

. Experienced in batch processing, QA, production and deployment

support.

. Excellent Analytical and communication skills.

Languages: Perl, C++, Java, Visual Basic, Ksh.

Database Skills: Sybase, Oracle (8), MS Access, Familiarity with MS SQL,

Postgre SQL, and DB2.

Web Technologies: CGI, HTML, JavaScript, VB Script, XML, Ms Visual Studio.

NET, J2EE, Apache, IBM web sphere.

Operating System: DOS, MS Windows (2000, ME, XP), Unix, and Linux.

Others: DBI/DBD, BCP, ISQL, RCS, Perforce, Familiar with Boxi, Erwin, UML,

And Smart Draw.

EXPERIENCE:

Sep 2008 Working as a Data Base Developer (consultant) at

Morgan Stanley, New York

Present

Brokerage and Clearing system: - Fixed Income/Equity group primarily uses

this application. Analyst and manager are some of the users of this

application. It is used to calculated brokerage and clearing fees globally

across all regions.

Roles and responsibilities:

. Handling incoming data of all US based exchange -including Nasdaq,

NYSE Cme, Bats, Arca and Bloomberg.

. Loading and processing European exchange data.

. Handling fixed income data globally.

. Interact with users to elicit requirements.

. Create csv reports for the users.

. Work in Data handling using KSH, BCP and ISQL.

. Create many Sybase tables and stored procedures.

. Design and Develop various Perl /Sybase stored procedure for

calculating fees for various exchanges

. Work in user management module using Sybase.

. Use DBI/DBD connectivity from Perl to Sybase

. Write various pull scripts in Perl to make data avail from Db2, Sybase

. Pull Data from website using Perl script.

. Convert Xml, Csv, and Excel data file to text files using Perl

modules.

. Create many reports for users in BOXI.

. Participate in Application and Query tuning.

. Create many batch scripts using Perl and Unix.

. Use batch scripts /Ksyts for Data migration.

. Perform documentation and testing.

. Participate in production support, both monitoring and trouble

shooting.

. Participate in development meetings and requirement analysis.

. Preprocess data so as to calculate the fees.

. Loading trade data after parsing the files to database.

Mar 2008 Joined PERI Soft Consultancy, New Jersey

Dec 2011 Programmer working at Morgan Stanley

Jan 2007- PACE University, New York

Dec 2008 Graduate Assistantship, Computer Science and School

of Education

. Installed Linux and other software in Artificial Intelligence

Laboratory.

. Worked in excel and oracle and assisted in back office operations.

June 2007- Lehman Brothers, New York

Aug 2007 Internship: Worked as Associate in Corporate Advisory Division.

.

. Performed Inter system Reconciliation.

. Performed Logical Access, Application Change Management tests on

Applications Murex, Spirit, GPM, CTI, Tiger and Brass.

. Prepared Interface Testing Summary Reports (Data Validation Feed for

the various applications)

. Checked the User Access Controls and Prepared AS/400 report.

. Created Back up and Recovery, Databases and Operating Systems (Main

Frame), Problem Management and ITD Management audit templates.

. Read about the New York Stock Exchange Policy for MISU (Multiple

Installations for Single Users), Market Data Process for Preparing

MISU Reports, reviewed the NYSE MISU reporting process, studied

various U.S. Equity Applications and Order Flows of US Equity Systems

and worked in the annual audit of Market Data Report.

. Read the ISACA -COBIT (Control Objectives for Information and Related

Technology) and aligned the principles with the various audits.

Conducted much of the research required for the audit & visited Data

center at Hudson

May 2001 - P.K.R. Jain Senior Secondary School, Haryana, India

Aug 2006 Faculty

. Taught students in Computer Science & Science

. Developed Results Database System and Timetable for all classes

. Maintained and Upgraded web pages of School

. Responsible for computerized official work and technical support

operations

. Coordinated Summer Camp & extra curricular activities in the school

Ms. Cupid Software (P) Ltd, Haryana, India

Internship:

Worked on the Civil Hospital Management System in Visual Basic 6.0 and

Oracle 8.

ACADEMIC PROJECTS:

. Created XML parser in java for parsing RFC calendar.

. Analyzed, designed and tested Online Survey System.

. Developed an application in RUBY on RAILS.

. Analyzed, designed and implemented Digital News Reader in java & XML.

. Developed Guest Book Application in J2EE, Servlets for Login page.

. Developed online Inventory System in PERL, CGI, HTML, DBI/DBD, and

SYBASE.

. Implemented Rice Sheller Inventory Control in FoxPro.

. Implemented Export system & Banking Information system.

. Manage & Reporting of Portfolio -allows client to manage transactions

after or before the settlement of the purchase orders.

. Fixed Income Analysis System -used by fixed income traders to perform

gap analysis.

. Remittance systems - funds settlement system fro reviewing and

authorizing payments.

EDUCATION:

Master of Science, Computer Science, and GPA: 4 Pace University, New York,

NY December 2007

Master of Computer Applications, Kurukshetra University, Haryana, India

May 2004

Contact this candidate