Sales Data

MAMATHA G. REDDY 513-***-****

**** ********* ***, *****, ** 45040

*******.******@*****.***

_______________________________________________________________

Summary

. Ten years of experience in designing, developing, testing,

enhancing, and implementing applications. Able to quickly learn new

concepts and technologies.

. Adept at overseeing all stages of software development life cycle

(SDLC) and Rational Unified Process (RUP) from design and

documentation to implementation.

. Proven background in improving process quality and providing system

automation recommendations and strategies to manage solutions and

data efficiently.

. Expertise in determining customer needs and effectively translating

those needs into software solutions. Capable to maintain positive

communications and working relationships at all business levels.

. Proven track record in writing high quality complex processes.

. Sun Certified Java Programmer for SE 6.

Technical Skills

Languages: SQL, PL/SQL, Pro*C, C, C#, C++, Perl and Java

Operating Systems: Win2K, Windows XP, Linux and UNIX

(Solaris, HP & AIX)

Tools: Oracle reports 2.5, Crystal Reports 5.0,

and Autosys

Databases: Oracle 8.x, SYBASE 12.5 and DB2 8.x

IDE Tools: WSAD, PowerBuilder 10.5, MS Visual Studio, & DBArtisan

Configuration Management: ClearCase/ClearQuest, CVS, Visual Source

Safe, SCCS

Web Technologies: XML & HTML

Awards

2007: Excellence in Action CIO Award-IMS East Development Team, State

Street Corporation, Boston, MA

2006: Excellence in Action CIO Award Nominee, State Street Corporation,

Boston, MA

2004: Excellence in Action CIO Award Nominee, State Street Corporation,

Boston, MA

Experience

Application Developer Consultant (AVP) May 2006

- Dec 08

Application Developer III (Officer) Apr

2001 - May 06

State Street Corporation, Princeton, NJ

Financial Data Extracts, Loads, Maintenance & Reporting:

PLATFORM: Perl, C, C++, Java, UNIX, Shell Scripts, Autosys, DB2, SYBASE,

Power Builder 5/6.5

Designed & developed mission critical batch processes to extract various

types of data from Portfolio Accounting System (PAS) Data warehouse (DW)

DB2 DB and load into various SYBASE Databases. Data includes Securities,

Holdings, Foreign Exchange Currencies, Taxlots, Fund Shares, General Ledger

& Transactions for the client funds. This data will be used by reporting

unit to analyze various things. There are Graphical User Interfaces (GUI)

for each type of data mentioned as above to maintain and reporting purpose.

. Developed common extraction process using Perl/ Shell Scripts to

standardize all data extracts. With this in place, making extract

creation simpler and more flexible. There are approximately 60 extracts

are being run on daily basis. This system reduced production down time to

zero percent.

. Implemented complex data rules while loading data using stored procedures

& C/C++.

. Tuned the database queries to improve the data base performance during

high volume data retrieval process. Wrote complex DB2 queries to extract

data from DW.

. Maintained responsibility for all activities related to design,

distribution, implementation, troubleshooting, customer care, and problem

resolution for Data Extracts & Loads.

. Redesigned & developed legacy C++ load process using Perl.

. Migrated legacy Perl Processes using Java.

Auction Market Preferred Stocks (AMPS) Compliance System:

PLATFORM: Perl, C, C++, UNIX, Shell Scripts, SYBASE, PowerBuilder 6.5

AMPS is a 2 tier application consists of PowerBuilder 6.5 as a front end

and SYBASE/C/C++ as backend. This application gets the Holdings,

Securities & Transactions data from various internal State Street DBs and

Security Ratings from various Rating sources. After applying lot of

predefined compliance rules, Compliance Reports & Basic Maintenance Amount

(BMA) Reports get generated. These will be used to monitor fund

performance etc by business.

. Designed & Developed Rules Engine to incorporate complex compliance

rules as per business using C++/SYBASE Stored Procedures.

. Enhanced the existing SYBASE Open Server process written in C, to

invoke this Rules Engine from the front end application in addition to

batch process.

. Created build scripts to compile C++/C code in various environments as

per State Street standards.

Enterprise Implementation:

PLATFORM: Perl, UNIX, Shell Scripts, Autosys, SYBASE, Java

State Street's Investor Management Solutions (IMS) provides middle-office

services, back-office services and support to various Investment

Management Firms. Its solution-set includes products like Global Trade

Manager (GTM), Record Keeping System (RKS), Enterprise Data Warehouse

(EDW) and so on. State Street Princeton supports lot of IMS clients which

include JW Seligman (JWS). JWS has been migrated to Enterprise platform by

replacing its legacy Global Portfolio System.

. Developed/migrated IMS Client specific Reports, Interfaces,

applications and Trade Batch Processing etc to the Enterprise

environment.

. Developed home grown Recon Tools and set up STaARs vendor product for

data Reconciliation.

. Created detailed project plan with well-defined tasks, milestones,

client sign-offs, test cycles, and specifications, which served to

communicate project progress to management.

Responsibilities:

. Supported operating system/compiler and development environment

upgrades.

. Adapted Clear Case & Clear Quest for source code control & defect

tracking. Acted as a point of contact for all the source code control

issues. Trained new team members to use Clear Case & Clear Quest.

. Aided in development, execution, and maintenance of disaster recovery

plans.

. Documented all necessary Rational Unified Process artifacts for all

the projects worked.

. Ensure best practices are applied and integrity of data is maintained

through security, documentation, and change management.

. Identified data issues and provided recommendations for resolution to

ensure optimal performance. Proactively fixed the existing bugs and

enhanced applications to prevent potential failures.

. Work with business stakeholders, application developers, and

production teams and across functional units to identify business

needs and discuss solution options.

. Developed numerous Shell & Perl Scripts for various critical

processes.

Senior Technical Associate

AT& T/IBM, Piscataway, NJ Feb 1998 - Mar

01

Customer Account Data Management - Biller Extracts (CADM-BE) & Legacy

Gateway Deferred Updates (CADM-DU)

PLATFORM: C, C++, UNIX, ORACLE, Pro*C, PL/SQL, CONTROL-M

Worked as Developer/Analyst for the CADM-BE application, which provides

billing information from the CADM database to the "Universal Biller"

(UB) to support bill production and bill reprinting via "cyclic

extract" files. Once the billing is done, UB consolidates the data and

passes the updated files to CADM-DU and DU updates CADM.

Responsibilities:

. Design, development, enhancement, and maintenance of the application code

using C, C++, PRO *C, PL/SQL, SQL* Plus, and shell scripts.

. Involved in the automation of job scheduling by writing Control-M

templates & shell scripts.

. Worked as lead developer for SUN PORT project that includes porting all

the BE source code from HP to SUN.

Multi Cultural Sales Tracking & Compensation - Sales Information

Resource System (MISTIC-SIRS):

PLATFORM: C, C++, UNIX, SYBASE, POWER BUILDER, CRYSTAL REPORTS

Worked as a Programmer/Analyst in this Sales Information Resource

System (SIRS) which is part of MISIC. It was designed using SYBASE 11

and POWER BUILDER. The database stores the sales related information

for the Consumer Direct Sales Organization.

Responsibilities:

. Design, development, enhancement and maintenance of the application

.

. Worked on Ad-hoc reports and completed approximately 100 ad-hoc

reports. Despite a very aggressive schedule, I was able to meet all

deadlines with no negative impact to clients.

. Involved as a lead developer in Y2K testing of MISTIC application.

Programmer June 1997 -

Feb 98

Transportation Data Inc., Summit, NJ

Shipping Schedules Maintenance System:

PLATFORM: WINDOWS NT, ORACLE7.3.3, ORACLE FORMS4.5

The system maintains the container shipping schedules of various carriers

for voyages in and out of the U.S and Canada. I was responsible for

development of reports & front-end screens.

Education

Graduate Certification in Internet Applications Development

New Jersey Institute of Technology, Newark, NJ

Dec 1999

B.S., Electronics and Communication Engineering

S. V. University, Andhra Pradesh, India

July 1993

Personal: US Citizen

Contact this candidate